USER_SESSIONS

Returns user session history on the system.

Returns user session history on the system.

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 VARCHAR 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 VARCHAR 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.
RUNTIME_PRIORITY VARCHAR

Determines the amount of run-time resources (CPU, I/O bandwidth) the Resource Manager should dedicate to queries already running in the resource pool. Valid values are:

  • HIGH

  • MEDIUM

  • LOW

Queries with a HIGH run-time priority are given more CPU and I/O resources than those with a MEDIUM or LOW run-time priority.

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 operation is executing.
CLIENT_OS_HOSTNAME VARCHAR The hostname of the client as reported by their operating system.
CLIENT_HOSTNAME VARCHAR

The IP address and port of the TCP socket from which the client connection was made; NULL if the session is internal.

Vertica accepts either IPv4 or IPv6 connections from a client machine. If the client machine contains mappings for both IPv4 and IPv6, the server randomly chooses one IP address family to make a connection. This can cause the CLIENT_HOSTNAME column to display either IPv4 or IPv6 values, based on which address family the server chooses.

CLIENT_PID INTEGER

Linux process identifier of the client process that issued this connection.

Note: The client process could be on a different machine from the server.

CLIENT_LABEL VARCHAR User-specified label for the client connection that can be set when using ODBC. See Label in DSN Parameters.
SSL_STATE VARCHAR

Indicates if Vertica used Secure Socket Layer (SSL) for a particular session. Possible values are:

  • None – Vertica did not use SSL.

  • Server – Sever authentication was used, so the client could authenticate the server.

  • Mutual – Both the server and the client authenticated one another through mutual authentication.

See Implementing Security and TLS protocol.

AUTHENTICATION_METHOD VARCHAR

Type of client authentication used for a particular session, if known. Possible values are:

  • Unknown

  • Trust

  • Reject

  • Kerberos

  • Password

  • MD5

  • LDAP

  • Kerberos-GSS

  • Ident

See Security and authentication and Configuring client authentication.

CLIENT_TYPE VARCHAR

The type of client from which the connection was made. Possible client type values:

  • ADO.NET Driver

  • ODBC Driver

  • JDBC Driver

  • vsql

CLIENT_VERSION VARCHAR Returns the client version.
CLIENT_OS VARCHAR Returns the client operating system.
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

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.

See also