SYSTEM_SESSIONS

Provides information about system internal session history by system task.

Provides information about system internal session history by system task.

Column Name Data Type Description
NODE_NAME VARCHAR Name of the node that is reporting the requested information.
USER_NAME VARCHAR Name of the user at the time Vertica recorded the session.
SESSION_ID INTEGER Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused when the session closes.
TRANSACTION_ID INTEGER Identifier for the transaction within the session, if any. If a session is active but no transaction has begun, TRANSACTION_ID returns NULL.
STATEMENT_ID VARCHAR Unique numeric ID for the currently-running statement. NULL indicates that no statement is currently being processed. The combination of TRANSACTION_ID and STATEMENT_ID uniquely identifies a statement within a session.
SESSION_TYPE VARCHAR

Session type, one of:

  • CLIENT

  • DBD

  • MERGEOUT

  • REBALANCE_CLUSTER

  • RECOVERY

  • REFRESH

  • TIMER_SERVICE

  • CONNECTION

  • SUBSESSION

  • REPARTITION_TABLE

  • LICENSE_AUDIT

  • STARTUP

  • SHUTDOWN

  • VSPREAD

RUNTIME_PRIORITY VARCHAR Specifies how many run-time resources (CPU, I/O bandwidth) are allocated to queries that are running in the resource pool.
DESCRIPTION VARCHAR Transaction description in this session.
SESSION_START_TIMESTAMP TIMESTAMPTZ Value of session at beginning of history interval.
SESSION_END_TIMESTAMP TIMESTAMPTZ Value of session at end of history interval.
IS_ACTIVE BOOLEAN Denotes if the session is still running.
SESSION_DURATION_MS INTEGER Duration of the session in milliseconds.
CLIENT_TYPE VARCHAR Columns not used in SYSTEM_SESSIONS system table. To view values for these columns, see the V_MONITOR schema system tables SESSIONS, USER_SESSIONS, CURRENT_SESSION, and SESSION_PROFILES.
CLIENT_VERSION VARCHAR
CLIENT_OS VARCHAR
CLIENT_OS_USER_NAME VARCHAR The name of the user that logged into, or attempted to log into, the database. This is logged even when the login attempt is unsuccessful.

Privileges

Superuser