PGXC_WORKLOAD_TRANSACTION
PGXC_WORKLOAD_TRANSACTION provides transaction information about workload cgroups on all CNs. Only the system administrator or the preset role gs_role_read_all_stats can access this view. This view is valid only when the real-time resource monitoring function is enabled, that is, when enable_resource_track is on.
Column | Type | Description |
|---|---|---|
node_name | Name | Node name. |
workload | Name | Workload Cgroup name. |
commit_counter | Bigint | Number of the commits. |
rollback_counter | Bigint | Number of rollbacks. |
resp_min | Bigint | Minimum response time, in microseconds. |
resp_max | Bigint | Maximum response time, in microseconds. |
resp_avg | Bigint | Average response time, in microseconds. |
resp_total | Bigint | Total response time, in microseconds. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
