Sys Schema Processes Metrics
Lists the Sys Schema Processes metrics and provides a brief description of each.
| 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. |