SUMMARY_TRANSACTIONS_RUNNING_XACTS
SUMMARY_TRANSACTIONS_RUNNING_XACTS displays information about the running transactions on each node 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. |
openGauss 2024-09-07 01:01:32