sys Schema Views The thread user or thread name. The default database for the thread, or  NULL  if there is none. For foreground threads, the type of command the thread is executing on behalf of the client, or  Sleep  if the session is idle. An action, event, or state that indicates what the thread is doing. The time in seconds that the thread has been in its current state. The statement the thread is executing, or  NULL  if it is not executing any statement. How long the statement has been executing. The percentage of work completed for stages that support progress reporting. See Section 28.3, “sys Schema Progress Reporting” . The time spent waiting for locks by the current statement. The number of rows read from storage engines by the current statement. The number of rows returned by the current statement. The number of rows affected by the current statement. The number of internal in-memory temporary tables created by the current statement. The number of internal on-disk temporary tables created by the current statement. The number of full table scans performed by the current statement. • db • command • state • time • current_statement • statement_latency • progress • lock_latency • rows_examined • rows_sent • rows_affected • tmp_tables • tmp_disk_tables • full_scan 5158