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

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