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) |
openGauss 2024-09-07 01:01:32