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