PDF (US Ltr)
- 0.7Mb
PDF (A4)
- 0.7Mb
Lists the Sys Schema Statement Analysis metrics and provides a brief description of each.
Table 6.35 Sys Schema Statement Analysis Metrics
| Name | Description |
|---|---|
| Avg Latency | The average wait time per timed occurrence of the statement. |
| 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. |
| 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. |
| 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. |
| Total Latency | The total wait time of timed occurrences of the statement. |
| Warning Count | The total number of warnings produced by occurrences of the statement. |