Understanding Top 10

By default, QAN shows the top ten queries. You can sort queries by any column - just click the small arrow to the right of the column name. Also you can add a column for each additional field which is exposed by the data source by clicking the + sign on the right edge of the header and typing or selecting from the available list of fields.

_images/qan.query-summary-table.default.1.png

The query summary table shows the monitored queries from the selected database.

To view more queries, use buttons below the query summary table.

Query Detail Section

In addition to the metrics in the query metrics summary table, QAN displays more information about the query itself below the table.

_images/qan.query.1.png

The Query Detail section shows the SQL statement for the selected query.

Tables tab for the selected query seen in the same section contains the table definition and indexes for each table referenced by the query:

_images/qan.query.2.png

Tables and indexes details the selected query.

Table Of Contents

Previous topic

Navigating to Query Analytics

Next topic

Filtering Queries