Updated on 2023-10-23 GMT+08:00

SUMMARY_STATEMENT_COUNT

SUMMARY_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 all nodes (database nodes) of the database.

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)