TRANSACTIONS

Records the details of each transaction.

Column Name Data Type Description
START_TIMESTAMP

TIMESTAMPTZ

Beginning of history interval.

END_TIMESTAMP

TIMESTAMPTZ

End of history interval.

NODE_NAME

VARCHAR

Name of the node that is reporting the requested information.

USER_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the user.

USER_NAME

VARCHAR

Name of the user for which transaction information is listed.

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

INTEGER

Identifier for the transaction within the session, if any; otherwise NULL.

DESCRIPTION

VARCHAR

Textual description of the transaction.

START_EPOCH

INTEGER

Number of the start epoch for the transaction.

END_EPOCH

INTEGER

Number of the end epoch for the transaction

NUMBER_OF_STATEMENTS

INTEGER

Number of query statements executed in this transaction.

ISOLATION

VARCHAR

Denotes the transaction mode as "READ COMMITTED" or "SERIALIZABLE".

IS_READ_ONLY

BOOLEAN

Denotes "READ ONLY" transaction mode.

IS_COMMITTED

BOOLEAN

Determines if the transaction was committed. False means ROLLBACK.

IS_LOCAL

BOOLEAN

Denotes transaction is local (non-distributed).

IS_INITIATOR

BOOLEAN

Denotes if the transaction occurred on this node (t).

IS_DDL

BOOLEAN

Distinguishes between a DDL transaction (t) and non-DDL transaction (f).

Privileges

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.

See Also

Transactions