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