You are here: SQL Development > Improving Query Performance > Identifying Historical Slow Queries Using Automation Console

Identifying Historical Slow Queries Using Automation Console

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 MAX_QUERY_COUNT and 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.