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:
|
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. |