The total time waiting for locks by timed occurrences 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_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_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. 

• tmp_tables 

The total number of internal in-memory temporary tables created by occurrences of the statement. 

• tmp_disk_tables 

The total number of internal on-disk temporary tables created by occurrences of the statement. 

## 28.4.3.36 The statements_with_errors_or_warnings and x $statements_with_errors_or_warnings Views 

• 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. 

• digest 

The statement digest. 

• first_seen 

The time at which the statement was first seen. 

• last_seen 

The time at which the statement was most recently seen. 

These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. 

