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

Updated on 2023-10-23 GMT+08:00

View PDF

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 corresponding to the transaction in GTM
gxid	xid	Transaction ID
state	tinyint	Transaction status (3: prepared; 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	ID of the transaction in the prepared state (the value is 0 if the state is not prepared)
pid	bigint	Thread ID corresponding to the transaction
next_xid	xid	Transaction ID sent from a CN to a DN