Actions |
You can click View Details to view the details of the SQL pattern. For more information, see the "Query details" section of this topic.
|
SQL Pattern |
The statement of the SQL pattern. You can click the icon to copy the SQL statement.
|
Username |
The database username that is used to commit the SQL statement. |
Client IP |
The IP address of the client that commits the SQL statement. |
Table Name |
The tables scanned based on the SQL pattern. |
Creation Time |
The earliest commit time of the SQL statement within the query time range. |
Executions |
The number of executions of the SQL statement within the query time range. In the
event of resource usage bursts in a cluster, you can sort SQL statements by Executions
and identify the SQL statements that are frequently executed while the cluster runs
abnormally. You can then further perform analysis and identify the cause to the increase
in the executions of these SQL statements.
|
Failures |
The number of failed executions of the SQL statement within the query time range.
|
Average Total Time Consumed |
The average total amount of time consumed by the SQL statement within the query time
range. Unit: milliseconds.
|
Maximum Total Time Consumed |
The maximum total amount of time consumed by the SQL statement within the query time
range. Unit: milliseconds. You can compare the values of Average Total Time Consumed
and Maximum Total Time Consumed to understand whether an increase in the amount of
time consumed by the SQL pattern is caused by other SQL patterns. If the value of
Maximum Total Time Consumed is close to that of Average Total Time Consumed during
normal running of the cluster, an increase in the amount of time consumed by the SQL
pattern during abnormal running of the cluster is caused by other SQL patterns.
|
Average Execution Duration |
The average execution duration of the SQL statement within the query time range. Unit:
milliseconds.
|
Maximum Execution Duration |
The maximum execution duration of the SQL statement within the query time range. Unit:
milliseconds. For more information about the execution duration, see Use query monitoring charts and lists.
|
Average Peak Memory |
The average peak memory size of the SQL statement within the query time range. Unit:
byte.
|
Maximum Peak Memory |
The maximum peak memory size of the SQL statement within the query time range. Unit:
byte. You can compare the values of Maximum Peak Memory and Average Peak Memory to
determine the stability of memory resource usage of the SQL statement. If the value
of Maximum Peak Memory is far greater than that of Average Peak Memory, the amount
of data being scanned may be increasing or the execution plan may be changed. You
can click View Details in the Actions column to view the SQL statement list on the Query Details page and identify the cause.
|
Average Data Scanned |
The average amount of data scanned based on the SQL statement within the query time
range. Unit: MB.
|
Maximum Data Scanned |
The maximum amount of data scanned based on the SQL statement within the query time
range. Unit: MB. You can compare the values of Maximum Data Scanned and Average Data
Scanned to determine the stability of the amount of data scanned based on SQL statements
in SQL patterns of the same category. If the value of Maximum Data Scanned is far
greater than that of Average Data Scanned, the amount of data scanned is unstable.
You can then identify the cause.
|