Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ DWS System Catalogs and Views/ System Views/ PGXC_USER_TRANSACTION
Updated on 2025-10-09 GMT+08:00
PGXC_USER_TRANSACTION
PGXC_USER_TRANSACTION provides transaction information about users on all CNs. It is accessible only to users with system administrator rights. This view is valid only if the real-time resource monitoring function is enabled, that is, if enable_resource_track is on.
| Column | Type | Description |
|---|---|---|
| node_name | Name | Node name. |
| usename | Name | Username. |
| commit_counter | Bigint | Number of commits. |
| rollback_counter | Bigint | Number of rollbacks. |
| resp_min | Bigint | Minimum response time. |
| resp_max | Bigint | Maximum response time. |
| resp_avg | Bigint | Average response time. |
| resp_total | Bigint | Total response time. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
