Help Center> GaussDB> Centralized_3.x> Schemas> DBE_PERF Schema> Transaction> SUMMARY_TRANSACTIONS_RUNNING_XACTS

Updated on 2024-05-07 GMT+08:00

View PDF

SUMMARY_TRANSACTIONS_RUNNING_XACTS

SUMMARY_TRANSACTIONS_RUNNING_XACTS displays information about the running transactions on each node 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 a 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 state 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 at 0.