Help Center/
GaussDB(DWS)/
Standard Data Warehouse (8.1.3.x)/
System Catalogs and System Views/
System Views/
PGXC_USER_TRANSACTION
Updated on 2023-10-31 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 when the real-time resource monitoring function is enabled, that is, when enable_resource_track is on.
|
Name |
Type |
Description |
|---|---|---|
|
node_name |
name |
Node name |
|
usename |
name |
Username |
|
commit_counter |
bigint |
Number of the commit times |
|
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 |
Parent topic: System Views
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.
