HomeMogDBMogDB StackUqbar
v3.0

Documentation:v3.0

Supported Versions:

Other Versions:

SUMMARY_TRANSACTIONS_RUNNING_XACTS

SUMMARY_TRANSACTIONS_RUNNING_XACTS displays information about the running transactions on each CN in the cluster. The column content is the same as that of TRANSACTIONS_RUNNING_XACTS.

Table 1 SUMMARY_TRANSACTIONS_RUNNING_XACTS columns

Name Type Description
handle integer Slot handle in the transaction manager corresponding to the transaction. The value is fixed at -1.
gxid xid Transaction ID
state tinyint Transaction status (3: prepared or 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. 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 other nodes to the current node. The value is fixed at 0.
Copyright © 2011-2024 www.enmotech.com All rights reserved.