PGXC_RUNNING_XACTS¶
PGXC_RUNNING_XACTS displays information about running transactions on each node in the cluster. The content is the same as that displayed in PG_RUNNING_XACTS.
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 restart |
prepare_xid | xid | Transaction ID in 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 |