• thread_id 

The thread ID for the connection. 

• ssl_version 

The version of SSL used for the connection. 

• ssl_cipher 

The SSL cipher used for the connection. 

• ssl_sessions_reused 

The number of reused SSL sessions for the connection. 

## 28.4.3.35 The statement_analysis and x$statement_analysis Views 

These views list normalized statements with aggregated statistics. The content mimics the MySQL Enterprise Monitor Query Analysis view. By default, rows are sorted by descending total latency. 

The statement_analysis  and x$statement_analysis  views have these columns: 

• query 

The normalized statement string. 

• db 

The default database for the statement, or NULL  if there is none. 

• full_scan 

The total number of full table scans performed by occurrences of the statement. 

• exec_count 

The total number of times the statement has executed. 

• err_count 

The total number of errors produced by occurrences of the statement. 

• warn_count 

The total number of warnings produced by occurrences of the statement. 

• total_latency 

The total wait time of timed occurrences of the statement. 

• max_latency 

The maximum single wait time of timed occurrences of the statement. 

• avg_latency 

The average wait time per timed occurrence of the statement. 

• lock_latency 

