6.39 Sys Schema Statement Analysis by Total Executions Metrics

Lists the Sys Schema Statement Analysis by Total Executions metrics and provides a brief description of each.

Table 6.39 Sys Schema Statement Analysis by Total Executions Metrics

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.