QUERY_METRICS
Monitors the sessions and queries running on each node.
Monitors the sessions and queries running on each node.
Note
Totals in this table are reset each time the database restarts.| Column Name | Data Type | Description |
|---|---|---|
NODE_NAME |
VARCHAR | The node name for which information is listed. |
ACTIVE_USER_SESSION_COUNT |
INTEGER | The number of active user sessions (connections). |
ACTIVE_SYSTEM_SESSION_COUNT |
INTEGER | The number of active system sessions. |
TOTAL_USER_SESSION_COUNT |
INTEGER | The total number of user sessions. |
TOTAL_SYSTEM_SESSION_COUNT |
INTEGER | The total number of system sessions. |
TOTAL_ACTIVE_SESSION_COUNT |
INTEGER | The total number of active user and system sessions. |
TOTAL_SESSION_COUNT |
INTEGER | The total number of user and system sessions. |
RUNNING_QUERY_COUNT |
INTEGER | The number of queries currently running. |
EXECUTED_QUERY_COUNT |
INTEGER | The total number of queries that ran. |