QUERY_METRICS
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. |