SESSION_PROFILES

Provides basic session parameters and lock time out data. To obtain information about sessions, see Profiling Database Performance.

Column Name Data Type Description
NODE_NAME

VARCHAR

The node name for which information is listed.

USER_NAME

VARCHAR

The name used to log in to the database or NULL if the session is internal.

CLIENT_HOSTNAME

VARCHAR

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

LOGIN_TIMESTAMP

TIMESTAMP

The date and time the user logged into the database or when the internal session was created. This field is useful for identifying sessions that have been left open for a period of time and could be idle.

LOGOUT_TIMESTAMP

TIMESTAMP

The date and time the user logged out of the database or when the internal session was closed.

SESSION_ID

VARCHAR

A unique numeric ID assigned by the Vertica catalog, which identifies the session for which profiling information is captured. This identifier is unique within the cluster at any point in time but can be reused when the session closes.

EXECUTED_STATEMENT_SUCCESS_COUNT

INTEGER

The number of successfully run statements.

EXECUTED_STATEMENT_FAILURE_COUNT

INTEGER

The number of unsuccessfully run statements.

LOCK_GRANT_COUNT

INTEGER

The number of locks granted during the session.

DEADLOCK_COUNT

INTEGER

The number of deadlocks encountered during the session.

LOCK_TIMEOUT_COUNT

INTEGER

The number of times a lock timed out during the session.

LOCK_CANCELLATION_COUNT

INTEGER

The number of times a lock was canceled during the session.

LOCK_REJECTION_COUNT

INTEGER

The number of times a lock was rejected during a session.

LOCK_ERROR_COUNT

INTEGER

The number of lock errors encountered during the session.

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.

See Also

LOCKS