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.
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) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.