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 |