Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> PGXC_RUNNING_XACTS
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 by 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 |
Parent topic: System Views
Last Article: PGXC_PREPARED_XACTS
Next Article: PGXC_STAT_ACTIVITY
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.