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.