SESSION_PROFILES

Provides basic session parameters and lock time out data.

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