Help Center/ GaussDB/ Centralized_8.x/ Schemas/ DBE_PERF Schema/ Transaction/ SUMMARY_TRANSACTIONS_RUNNING_XACTS

Updated on 2024-06-03 GMT+08:00

View PDF

SUMMARY_TRANSACTIONS_RUNNING_XACTS

true: yes
false: no

Displays the summary of running transactions on the primary database node, as described in Table 1.

**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	Specifies whether the current transaction is a lazy vacuum (VACUUM only if necessary) transaction. true: yes false: no
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 at 0.