PGXC_RUNNING_XACTS
PGXC_RUNNING_XACTS displays information about running transactions on each node in the cluster. The content is the same as that displayed in PG_RUNNING_XACTS.
Column |
Type |
Description |
---|---|---|
handle |
Integer |
Handle corresponding to the transaction in GTM |
gxid |
Xid |
Transaction ID |
state |
tinyint |
Transaction status (3: prepared or 0: starting) |
node |
Text |
Node name |
xmin |
Xid |
Minimum transaction ID xmin on the node |
vacuum |
boolean |
Whether the current transaction is lazy vacuum |
timeline |
Bigint |
Number of database restarts |
prepare_xid |
Xid |
Transaction ID in prepared state. If the status is not prepared, the value is 0. |
pid |
Bigint |
Thread ID corresponding to the transaction |
next_xid |
Xid |
Transaction ID sent from a CN to a DN |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.