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.