phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Young <yomaiq...@gmail.com>
Subject Phoenix Query Server query logging
Date Wed, 01 Feb 2017 01:10:51 GMT
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

Mime
View raw message