Work with queries in ADQM Control
The Queries page in the ADQM Control web interface displays SQL queries executed in ADQM clusters connected to the monitoring system. On this page, you can get an overview of queries to cluster databases and view various query execution metrics — for example, to analyze query performance, amounts of read/written data, resource usage, errors if they have occurred during query execution, etc. Information on queries can also be presented in the form of graphs, which allow you to visualize the number of queries of different types, see how the total number of queries sent to the cluster is distributed among users, and track any queries that are too long (compared to the average).
The Queries page contains two tabs, each of which displays a list of queries executed in an ADQM cluster in a specific way:
-
All queries — each query run is shown separately.
-
Query groups — queries are grouped by the
normalized_query_hashnumeric hash value (that is, queries with the same SQL structure, but possibly different literal values, are shown as one entry in the list).
At the top of the screen, you can set up the following filters to select which data the Queries page should display:
-
Cluster — ADQM cluster where queries were executed.
-
Time — time period when queries were launched. In the window that opens when you click the field, you can select an interval from the offered options on the Range tab or set a custom time range (at least 1 hour) on the Calendar tab.
-
Refresh — frequency of data updates.
Query history is always displayed on the Queries page according to these filters — it contains all queries run on the selected ADQM cluster during the specified time period.
You can also get a list of the longest-running queries or queries used the most memory in the Top 10 queries section on the Dashboard page.