SUMMARY_TRANSACTIONS_RUNNING_XACTS
Displays information about running transactions on each CN in the cluster, 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.