PG_RUNNING_XACTS¶
PG_RUNNING_XACTS displays information about running transactions on the current node.
Name | Type | Description |
|---|---|---|
handle | integer | Handle corresponding to the transaction in GTM |
gxid | xid | Transaction ID |
state | tinyint | Transaction status (3: prepared or 0: starting) |
node | text | Node name |
xmin | xid | Minimum transaction ID xmin 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 status. If the status is not prepared, the value is 0. |
pid | bigint | Thread ID corresponding to the transaction |
next_xid | xid | Transaction ID sent from a CN to a DN |