TRANSACTIONS_RUNNING_XACTS

TRANSACTIONS_RUNNING_XACTS displays information about running transactions on the current node.

Table 1 TRANSACTIONS_RUNNING_XACTS columns

Name	Type	Description
handle	integer	事务对应的事务管理器中的槽位句柄，该值恒为-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	其余节点发送给当前节点的事务id，该值恒为0。