TRANSACTIONS_RUNNING_XACTS
Displays information about running transactions on the current node, as described in Table 1.
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 |
Specifies whether the current transaction is a lazy vacuum (VACUUM only if necessary) transaction.
|
timeline |
bigint |
Number of database restarts. |
prepare_xid |
xid |
ID of the transaction in the prepared state (the value is 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. |
dbid |
oid |
ID of the database corresponding to the transaction. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.