Help Center/ GaussDB(DWS)/ Standard Data Warehouse (8.1.3.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ GLOBAL_WORKLOAD_SQL_COUNT
Updated on 2023-10-31 GMT+08:00
View PDF

GLOBAL_WORKLOAD_SQL_COUNT

GLOBAL_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in all workload Cgroups in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.

Table 1 GLOBAL_WORKLOAD_SQL_COUNT columns

Name

Type

Description

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