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

PGXC_WORKLOAD_SQL_COUNT

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

PGXC_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in workload Cgroups on all CNs in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements. It is accessible only to users with system administrator rights.

Table 1 PGXC_WORKLOAD_SQL_COUNT columns

Name

Type

Description

node_name

name

Node name

workload

name

Workload Cgroup name

select_count

bigint

Number of SELECT statements

update_count

bigint

Number of UPDATE statements

insert_count

bigint

Number of INSERT statements

delete_count

bigint

Number of DELETE statements

ddl_count

bigint

Number of DDL statements

dml_count

bigint

Number of DML statements

dcl_count

bigint

Number of DCL statements

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