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 |
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
