LOCK_USAGE

Provides aggregate information about lock requests, releases, and attempts, such as wait time/count and hold time/count. Vertica records:

  • Lock attempts at the end of the locking process
  • Lock releases after lock attempts are released
Column Name Data Type Description
NODE_NAME

VARCHAR

Name of the node that is reporting the requested information on which lock interaction occurs.

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.

OBJECT_NAME

VARCHAR

Name of object being locked; can be a table or an internal structure (projection, global catalog, or local catalog).

MODE

VARCHAR

Intended operations of the transaction. Otherwise, this value is NONE. For a list of lock modes and compatibility, see Lock Modes.

AVG_HOLD_TIME

INTERVAL

Average time (measured in intervals) that Vertica holds a lock.

MAX_HOLD_TIME

INTERVAL

Maximum time (measured in intervals) that Vertica holds a lock.

HOLD_COUNT

INTEGER

Total number of times the lock was granted in the given mode.

AVG_WAIT_TIME

INTERVAL

Average time (measured in intervals) that Vertica waits on the lock.

MAX_WAIT_TIME

INTERVAL

Maximum time (measured in intervals) that Vertica waits on a lock.

WAIT_COUNT

INTEGER

Total number of times lock was unavailable at the time it was first requested.

Privileges

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