Does the Phoenix Query Server have an option to log the SQL statements which are executed?
We see there are ways to get various PQS trace logs modifying the log4j settings used by the queryserver.py: log4j.org.apache.phoenix.jdbc.PhoenixStatementFactory=TRACE (or DEBUG) log4j.org.apache.phoenix.jdbc.PhoenixStatement=TRACE log4j.logger.org.apache.calcite.avatica=TRACE log4j.logger.org.apache.phoenix.queryserver.server=TRACE etc... but the data in the trace logs (which show SQL statements) are not particularly user friendly. And it does not seem straightforward to get to end-to-end query execution times. Any suggestions how to get simple SQL logs (raw query, execution time, ...)? The idea is to monitor user activity and take action if query times are slow, or timeout. Thanks, Michael
