Updated on 2025-07-15 GMT+08:00

SUMMARY_STATEMENT_COUNT

Displays the summary statistics of five types of statements (SELECT, INSERT, UPDATE, DELETE, and MERGE INTO) and DDL, DML, and DCL statements executed on each database node.

Table 1 SUMMARY_STATEMENT_COUNT columns

Name

Type

Description

user_name

text

Username

select_count

numeric

Statistical result of the SELECT statement

update_count

numeric

Statistical result of the UPDATE statement

insert_count

numeric

Statistical result of the INSERT statement

delete_count

numeric

Statistical result of the DELETE statement

mergeinto_count

numeric

Statistical result of the MERGE INTO statement

ddl_count

numeric

Number of DDL statements

dml_count

numeric

Number of DML statements

dcl_count

numeric

Number of DCL statements

total_select_elapse

numeric

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

numeric

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

numeric

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

numeric

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)