This topic lists SQL monitoring metrics and their meanings.
Basic information
Time model
Execution plan
| Metric Name | Metric Meaning |
|---|---|
| SQL Text | Short SQL Text |
| SQL ID | SQL ID |
| Database | The Database Accessed by SQL |
| User | The User Executing SQL |
| Tenant Name | Tenant Name |
| Tenant ID | Tenant ID |
| SQL Type | SQL type, including SELECT, INSERT, UPDATE, DELETE, etc. |
| Metric Name | Metric Meaning |
|---|---|
| Event with Maximum Latency | Event with Maximum Latency |
| CPU Proportion | The percentage of CPU time of the SQL statement in TOPSQL (%) |
| Total Database Time Consumption | Total Time Consumed by Database to Execute SQL in Specified Time Period (ms) |
| Average Time Consumption | Average Time Consumed by Database to Execute SQL in Specified Time Period (ms) |
| Total Elapsed Time | Total SQL Elapsed Time in Specified Period (ms) |
| Elapsed Time | This parameter specifies the average elapsed time of SQL in a specified period. Unit: milliseconds. SQL elapsed time means the time required to send a SQL request and receive a result. |
| Maximum Response Time | Maximum SQL Elapsed Time in Specified Period (ms) |
| CPU Time | Average CPU Time of SQL in Specified Period (ms) |
| Maximum CPU Time | Maximum CPU Time of SQL in Specified Period (ms) |
| Network Transmission Time | Average Network Transmission Time of SQL in Specified Period (ms) |
| Network Queuing Time | Average Network Jointime of SQL in Specified Period (ms) |
| Queuing Time | Average Queuing Time of SQL in Specified Period (ms) |
| Parsing Time | Average Query Parsing Time of SQL in Specified Period (ms) |
| Generation Time | Average Plan Generation Time of SQL in Specified Period (ms) |
| Execution Time | Average SQL Plan Execution Time in the Specified Time Period (ms) |
| Waiting Time | Average SQL Latency in Specified Period (ms) |
| Total Waiting Time | Total SQL Waiting Time in Specified Period (ms) |
| Number of Waits | Average SQL Delays in Specified Period |
| Application Waiting Time | Average Application Event Latency in Specified Period (ms) |
| Concurrency Event Waiting Time | Average Concurrency Event Latency of Execution Plans in Specified Period (ms) |
| I/O Latency | Average UserIO Event Latency of SQL in Specified Period (ms) |
| Scheduling Latency | Average Schedule Event Latency of SQL in Specified Period (ms) |
| Metric Name | Metric Meaning |
|---|---|
| Total Executions | Total SQL Executions Within Specified Period of Time |
| Executions per Second | Average SQL Executions per Second in Specified Period |
| Total Errors | Total SQL Execution Errors |
| Logical Read | Average Number of Logical Reads During SQL Execution |
| Affected Rows | Average Affected Rows of SQL in Specified Period |
| Returned Rows | The average number of return lines of the SQL statement in the specified period of time. |
| Accessed Partitions | Average Accessed Partitions of SQL in Specified Period |
| Proportion of Errors | SQL Errors in Specified Period (%) |
| Total Timeout Errors | Timeout Errors (4012) of SQL in Specified Period |
| Total Out-of-Memory Errors | Insufficient Memory Errors (4013) of SQL in Specified Period |
| Total Syntax Errors | Query Parsing Errors (5001) of SQL in Specified Period |
| Total Key-Value Conflict Errors | Conflicting Key Errors (5024) of SQL in Specified Period |
| Total Data Overflow Errors | Data Overlength Errors (5167) of SQL in Specified Period |
| Total Unknown Column Errors | Unknown Column Errors (5217) of SQL in Specified Period |
| Total Transaction Rollback Errors | Transaction Roll-back Errors (6002) of SQL in Specified Period |
| RPC Requests | Average RPC Requests of SQL in Specified Period |
| Proportion of Local Plans | Local Plans of SQL in Specified Period (%) |
| Proportion of Remote Plans | Remote Plans of SQL in Specified Period (%) |
| Proportion of Distributed Plans | Percentage Of SQL Distributed Plans in Specified Time Period (%) |
| RPC Requests | Average RPC Requests of SQL in Specified Period |
| Proportion of Missed Plans | SQL Plan Miss Rate in Specified Period |
| Row Cache Hit | Average Row Cache Hits |
| Bloom Filter Cache Hit | Average Bloom Filter Cache Hits |
| Block Cache Hit | Average Block Cache Hits |
| Block Index Cache Hit | Average Block Index Cache Hits |
| Physical Reads | Average Physical Reads of SQL in Specified Period |
| Total Retries | Total SQL Retries in Specified Period |
| Table Scan | Average Number of Table Scans by SQL in Specified Period |
| Strong Consistency Transaction Proportion | Strongly Consistent Transactions of SQL in Specified Period (%) |
| Weak Consistency Transaction Proportion | Weakly Consistent Transactions of SQL in Specified Period (%) |
| Rows of Memory Reads | Average Rows of MemStore Reads of SQL in Specified Period |
| Rows of Physical Reads | Average Rows of Ssstore Reads of SQL in Specified Period |