SYSTEM_SESSIONS

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. Can be one of:

  • CLIENT
  • DBD
  • MERGEOUT
  • MOVEOUT
  • 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