TRANSACTIONS_RUNNING_XACTS
Displays information about running transactions on the current node.
Name |
Type |
Description |
---|---|---|
handle |
integer |
Slot handle in the transaction manager corresponding to a transaction. The value is fixed at –1. |
gxid |
xid |
Transaction ID. |
state |
tinyint |
Transaction status (3: prepared; 0: starting). |
node |
text |
Node name. |
xmin |
xid |
Minimum transaction ID on the node. |
vacuum |
Boolean |
Specifies whether the current transaction is lazy vacuum. |
timeline |
bigint |
Number of database restarts. |
prepare_xid |
xid |
Transaction ID in the prepared state. If the state is not prepared, the value is 0. |
pid |
bigint |
Thread ID corresponding to the transaction. |
next_xid |
xid |
Minimum CSN of a local active transaction. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.