PG_RUNNING_XACTS

PG_RUNNING_XACTS displays the running transaction information on the current node.

Table 1 PG_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 t (true): yes f (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 to 0.