Help Center > > Developer Guide

PGXC_WORKLOAD_TRANSACTION

Updated at: Jul 14, 2021 GMT+08:00

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.

Table 1 PGXC_WORKLOAD_TRANSACTION columns

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

resp_max

bigint

Maximum response time

resp_avg

bigint

Average response time

resp_total

bigint

Total response time

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel