PG_RUNNING_XACTS
PG_RUNNING_XACTS displays information about running transactions on the current node. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.
| Name | Type | Description |
|---|---|---|
| handle | integer | Slot handle in the transaction manager corresponding to a transaction. The value is fixed at –1. |
| gxid | xid | Transaction ID. |
| state | tinyint | Transaction status.
|
| node | text | Node name |
| xmin | xid | Minimum transaction ID on the node. |
| vacuum | boolean | Specifies whether the current transaction is lazy vacuum.
|
| timeline | bigint | Number of database restarts. |
| prepare_xid | xid | ID of the transaction in the prepared state; otherwise, the value is 0. |
| pid | bigint | Thread ID corresponding to the transaction. |
| next_xid | xid | Transaction ID sent from a CN to a DN. |
| dbid | oid | ID of the database corresponding to the transaction. |
