Updated on 2025-05-29 GMT+08:00

WORKLOAD_SQL_COUNT

Displays the distribution of SQL statements in workloads on the current node, as described in Table 1.

Table 1 WORKLOAD_SQL_COUNT columns

Name

Type

Description

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. The statistical result contains the SQL statements executed by users and the SQL statements executed by the database backend thread.

dml_count

bigint

Number of DML statements. The statistical result contains the SQL statements executed by users and the SQL statements executed by the database backend thread.

dcl_count

bigint

Number of DCL statements. The statistical result contains the SQL statements executed by users and the SQL statements executed by the database backend thread.

dbid

oid

ID of the database to which the statistics belong.

user_dml_count

bigint

Number of DML statements executed by users.

bg_dml_count

bigint

Number of DML statements executed by the database backend thread.