The thread user or thread name. 

• db 

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

• command 

For foreground threads, the type of command the thread is executing on behalf of the client, or Sleep  if the session is idle. 

• state 

An action, event, or state that indicates what the thread is doing. 

• time 

The time in seconds that the thread has been in its current state. 

• current_statement 

The statement the thread is executing, or NULL  if it is not executing any statement. 

• statement_latency 

How long the statement has been executing. 

• progress 

The percentage of work completed for stages that support progress reporting. See Section 28.3, “sys Schema Progress Reporting” . 

• lock_latency 

The time spent waiting for locks by the current statement. 

• rows_examined 

The number of rows read from storage engines by the current statement. 

• rows_sent 

The number of rows returned by the current statement. 

• rows_affected 

The number of rows affected by the current statement. 

• tmp_tables 

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

• tmp_disk_tables 

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

• full_scan 

The number of full table scans performed by the current statement. 

