SUMMARY_TRANSACTIONS_RUNNING_XACTS
Displays information about the running transactions on each CN in the cluster. The column content is the same as that of TRANSACTIONS_RUNNING_XACTS.
| Name | Type | Description |
|---|---|---|
| handle | integer | Handle corresponding to the transaction in GTM. |
| 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 | Number of database restarts. |
| 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 | Minimum CSN of a local active transaction. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.