SUMMARY_TRANSACTIONS_RUNNING_XACTS
SUMMARY_TRANSACTIONS_RUNNING_XACTS displays the summary of running transactions on the primary database node.
| 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 (3: prepared; 0: starting). |
| node | text | Node name. |
| xmin | xid | Minimum transaction ID on the node. |
| vacuum | Boolean | Specifies whether the current transaction is lazy vacuum. |
| timeline | bigint | Specifies whether the current transaction is a lazy vacuum (VACUUM only if necessary) transaction.
|
| prepare_xid | xid | Transaction ID in the prepared state. If the state is not prepared, the value is 0. |
| pid | bigint | Thread ID corresponding to the transaction. |
| next_xid | xid | Transaction ID sent by other nodes to the current node. The value is fixed at 0. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.