Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ PGXC_WORKLOAD_SQL_COUNT
Updated on 2024-09-02 GMT+08:00
View PDF
Share

PGXC_WORKLOAD_SQL_COUNT

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. Only the system administrator or the preset role gs_role_read_all_stats can access this view.

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.
Parent topic: System Views