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

GLOBAL_STATEMENT_COUNT

Displays statistics about five types of running statements (SELECT, INSERT, UPDATE, DELETE, and MERGE INTO) as well as DDL, DML, and DCL statements on each node of the database, as described in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

Table 1 GLOBAL_STATEMENT_COUNT columns

Name

Type

Description

node_name

text

Node name

user_name

text

Username

select_count

bigint

Statistical result of the SELECT statement.

update_count

bigint

Statistical result of the UPDATE statement.

insert_count

bigint

Statistical result of the INSERT statement.

delete_count

bigint

Statistical result of the DELETE statement.

mergeinto_count

bigint

Statistical result of the MERGE INTO statement.

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.

total_select_elapse

bigint

Total response time of SELECT statements (unit: μs).

avg_select_elapse

bigint

Average response time of SELECT statements (unit: μs).

max_select_elapse

bigint

Maximum response time of SELECT statements (unit: μs).

min_select_elapse

bigint

Minimum response time of SELECT statements (unit: μs).

total_update_elapse

bigint

Total response time of UPDATE statements (unit: μs).

avg_update_elapse

bigint

Average response time of UPDATE statements (unit: μs).

max_update_elapse

bigint

Maximum response time of UPDATE statements (unit: μs).

min_update_elapse

bigint

Minimum response time of UPDATE statements (unit: μs).

total_insert_elapse

bigint

Total response time of INSERT statements (unit: μs).

avg_insert_elapse

bigint

Average response time of INSERT statements (unit: μs).

max_insert_elapse

bigint

Maximum response time of INSERT statements (unit: μs).

min_insert_elapse

bigint

Minimum response time of INSERT statements (unit: μs).

total_delete_elapse

bigint

Total response time of DELETE statements (unit: μs).

avg_delete_elapse

bigint

Average response time of DELETE statements (unit: μs).

max_delete_elapse

bigint

Maximum response time of DELETE statements (unit: μs).

min_delete_elapse

bigint

Minimum response time of DELETE statements (unit: μs).

dbid

oid

ID of the database to which the five types of statements (SELECT, INSERT, UPDATE, DELETE, and MERGE INTO) 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.