6.34 Sys Schema Processes Metrics

Lists the Sys Schema Processes metrics and provides a brief description of each.

Table 6.34 Sys Schema Processes Metrics

Name	Description
Command	The command type the process is running.
Connection Id	The id of the connection for this process.
Current Memory	Memory allocated by the process.
Current Statement	The currently running SQL statement for this process.
Database	The current default database for this process.
Full Scan	Did the currently running SQL statement for this process cause a full table scan? YES/NO.
Last Statement	The previous SQL statement ran by this process, if no SQL statement is currently running.
Last Statement Latency	Latency of the previously running SQL statement for this process.
Last Wait	Cause of the last wait for this process.
Last Wait Latency	Latency of the last wait for this process.
Lock Latency	The time spent waiting for locks of the currently running SQL statement for this process.
Pid	Operating system process ID of the client using this process.
Program Name	Program name of the client using this process.
Progress	Percentage of work completed of the currently running SQL statement for this process.
Rows Affected	Rows modified by the currently running SQL statement for this process.
Rows Examined	Rows examined by the currently running SQL statement for this process.
Rows Sent	Rows sent to the client by the currently running SQL statement for this process.
Source	Source code location of the current/last wait in the server for this process.
State	The current state for this process.
Statement Latency	Latency of the currently running SQL statement for this process.
Thread Id	The thread id for this process.
Time	The time, in seconds, that this process has been within the current state.
Tmp Disk Tables	On-disk temporary tables created by the currently running SQL statement for this process.
Tmp Tables	Temporary tables created by the currently running SQL statement for this process.
Transaction Autocommit	Autocommit state of the current transaction for this process.
Transaction Latency	Latency of the current transaction for this process.
Transaction State	State of the current transaction for this process.
User	The user the process runs as.