Help Center > > Developer Guide> System Catalogs and System Views> System Views> GLOBAL_WORKLOAD_TRANSACTION

GLOBAL_WORKLOAD_TRANSACTION

Updated at: Sep 17, 2021 GMT+08:00

GLOBAL_WORKLOAD_TRANSACTION provides the total transaction information about workload Cgroups on all CNs in the cluster. This view is accessible only to users with system administrator rights. It is valid only when the real-time resource monitoring function is enabled, that is, enable_resource_track is on.

Table 1 GLOBAL_WORKLOAD_TRANSACTION columns

Name

Type

Description

workload

name

Workload Cgroup name

commit_counter

bigint

Total number of submission times on each CN

rollback_counter

bigint

Total number of rollback times on each CN

resp_min

bigint

Minimum response time of the cluster

resp_max

bigint

Maximum response time of the cluster

resp_avg

bigint

Average response time on each CN

resp_total

bigint

Total response time on each CN

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