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 by PG_RUNNING_XACTS. Only users with the system admin or monitor admin permission can view the information.
Name |
Type |
Description |
---|---|---|
handle |
integer |
Handle corresponding to the transaction in GTM |
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 |
Whether the current transaction is lazy vacuum
|
timeline |
bigint |
Number of database restarts |
prepare_xid |
xid |
Transaction ID in the prepared state (0 if the state is not prepared) |
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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot