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. |