Updated on 2024-06-03 GMT+08:00

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.