Updated on 2024-09-02 GMT+08:00

GLOBAL_WORKLOAD_SQL_ELAPSE_TIME

GLOBAL_WORKLOAD_SQL_ELAPSE_TIME displays statistics on the response time of SQL statements in all workload Cgroups in a cluster, including the maximum, minimum, average, and total response time of SELECT, UPDATE, INSERT, and DELETE statements. The unit is microsecond.

Table 1 GLOBAL_WORKLOAD_SQL_ELAPSE_TIME columns

Name

Type

Description

workload

name

Workload Cgroup name

total_select_elapse

bigint

Total response time of SELECT statements

max_select_elapse

bigint

Maximum response time of SELECT statements

min_select_elapse

bigint

Minimum response time of SELECT statements

avg_select_elapse

bigint

Average response time of SELECT statements

total_update_elapse

bigint

Total response time of UPDATE statements

max_update_elapse

bigint

Maximum response time of UPDATE statements

min_update_elapse

bigint

Minimum response time of UPDATE statements

avg_update_elapse

bigint

Average response time of UPDATE statements

total_insert_elapse

bigint

Total response time of INSERT statements

max_insert_elapse

bigint

Maximum response time of INSERT statements

min_insert_elapse

bigint

Minimum response time of INSERT statements

avg_insert_elapse

bigint

Average response time of INSERT statements

total_delete_elapse

bigint

Total response time of DELETE statements

max_delete_elapse

bigint

Maximum response time of DELETE statements

min_delete_elapse

bigint

Minimum response time of DELETE statements

avg_delete_elapse

bigint

Average response time of DELETE statements