Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ Schemas/ DBE_PERF Schema/ Workload/ SUMMARY_WORKLOAD_SQL_COUNT
Updated on 2024-06-03 GMT+08:00
View PDF
Share

SUMMARY_WORKLOAD_SQL_COUNT

Displays the distribution of SQL statements in workloads on each primary database node in the database, as shown in Table 1.

Table 1 SUMMARY_WORKLOAD_SQL_COUNT columns

Name

Type

Description

node_name

name

Node name.

workload

name

Workload 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: Workload