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

GS_WORKLOAD_TRANSACTION

Updated at: Jul 15, 2020 GMT+08:00

GS_WORKLOAD_TRANSACTION provides transaction information about workload cgroups on a single CN. The database records the number of times that each workload Cgroup commits and rolls back transactions and the response time of transaction commitment and rollback, in microseconds.

Table 1 GS_WORKLOAD_TRANSACTION columns

Name

Type

Description

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