Sys Schema Statement Analysis by Total Latency Metrics
Lists the Sys Schema Statement Analysis by Total Latency metrics and provides a brief description of each.
| Name | Description |
|---|---|
| Avg Latency | The average wait time per timed occurrence of the statement. |
| Avg Time of Execution | The average time the statement takes to execute. |
| Database | The default database for the statement, or NULL if there is none. |
| Digest | The statement digest. |
| Error Count | The total number of errors produced by occurrences of the statement. |
| Exec Count | The total number of times the statement has executed. |
| First Seen | The time at which the statement was first seen. |
| Full Scan | Indication with a * character if there has been full table scans performed by occurrences of the statement, or empty if none. |
| Last Seen | The time at which the statement was most recently seen. |
| Lock Latency | The total time waiting for locks by timed occurrences of the statement. |
| Max Latency | The maximum single wait time of timed occurrences of the statement. |
| Max Time of Execution | The maximum time the statement took to execute. |
| Min Time of Execution | The minimum time the statement took to execute. |
| Query | The normalized statement string. |
| Rows Affected | The total number of rows affected by occurrences of the statement. |
| Rows Affected Avg | The average number of rows affected per occurrence of the statement. |
| Rows Examined | The total number of rows read from storage engines by occurrences of the statement. |
| Rows Examined Avg | The average number of rows read from storage engines per occurrence of the statement. |
| Rows Sent | The total number of rows returned by occurrences of the statement. |
| Rows Sent Avg | The average number of rows returned per occurrence of the statement. |
| Rows Sorted | The total number of rows sorted by occurrences of the statement. |
| Select Full Join | Number of select full joins of the statement. |
| Select Full Range Join | Number of select full range joins of the statement. |
| Select Range | Number of select ranges of the statement. |
| Select Range Check | Number of select range checks of the statement. |
| Select Scan | Number of select scans of the statement. |
| Sort Merge Passes | The total number of sort merge passes by occurrences of the statement. |
| Tmp Disk Tables | The total number of internal on-disk temporary tables created by occurrences of the statement. |
| Tmp Tables | The total number of internal in-memory temporary tables created by occurrences of the statement. |
| Tmp Tables Per Query Avg | The average number of internal in-memory temporary tables created by per occurrences of the statement. |
| Tmp Tables To Disk Pct | The percentage of internal in-memory temporary tables that were converted to on-disk tables. |
| Total Latency | The total wait time of timed occurrences of the statement. |
| Total Time of Execution | The total time the statement takes to execute. |
| Warning Count | The total number of warnings produced by occurrences of the statement. |