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 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 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 from a CN to a DN |
openGauss 2024-05-19 00:45:18