Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> GS_WORKLOAD_SQL_COUNT
GS_WORKLOAD_SQL_COUNT
GS_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in workload Cgroups on the current node, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
| 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
Last Article: PGXC_WLM_WORKLOAD_RECORDS
Next Article: GS_WORKLOAD_SQL_ELAPSE_TIME
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.