Open topic with navigation
It is possible to detect historical slow queries in the Automation Console, in addition to querying
SYSTEM.QUERYSTATS. To access slow query information, go to the database detail page, by clicking Databases in the left panel and then selecting which database you want to investigate.To see historical data about queries that have already completed, select the Historical Slow Queries tab.
Information displayed here includes a unique identifier for the query, the elapsed time for the query, the database name, the host on which the query is running and the SQL statement. This is equivalent the NuoDB slow query log,
SYSTEM.QUERYSTATS, as described at Identifying Historical Slow Queries Using System Tables. By default, NuoDB stores the ten slowest queries that took more than ten seconds to execute. As with
SYSTEM.QUERYSTATS, this can be modified by changing
MIN_QUERY_TIME values in
SYSTEM.PROPERTIES. Use the SET command to change the default settings.
If you select the ID for the query, you can get more details including the
EXPLAIN output for the query.