HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.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 Handle in the transaction manager corresponding to the transaction. The value is fixed to –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 by other nodes to the current node. The value is fixed to 0.
Copyright © 2011-2024 www.enmotech.com All rights reserved.