PGXC_WORKLOAD_TRANSACTION provides transaction information about workload Cgroups 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 |
workload |
name |
Workload Cgroup name |
commit_counter |
bigint |
Number of the commit times |
rollback_counter |
bigint |
Number of rollbacks |
resp_min |
bigint |
Minimum response time (unit: μs) |
resp_max |
bigint |
Maximum response time (unit: μs) |
resp_avg |
bigint |
Average response time (unit: μs) |
resp_total |
bigint |
Total response time (unit: μs) |