USER_SESSIONS

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_HOSTNAME

VARCHAR

IP address of the client system

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 in Connecting to Vertica.

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 in the Administrator's Guide.

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 Implementing 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

No explicit privileges are required. You only see the records for tables that you have privileges to view.

See Also