Updated on 2024-06-03 GMT+08:00

WORKLOAD_SQL_ELAPSE_TIME

WORKLOAD_SQL_ELAPSE_TIME collects SELECT, UPDATE, INSERT, and DELETE (SUID) statistics, as described in Table 1.

Table 1 WORKLOAD_SQL_ELAPSE_TIME columns

Name

Type

Description

workload

name

Workload name.

total_select_elapse

bigint

Total 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).

avg_select_elapse

bigint

Average response time of SELECT statements (unit: μs).

total_update_elapse

bigint

Total 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).

avg_update_elapse

bigint

Average response time of UPDATE statements (unit: μs).

total_insert_elapse

bigint

Total 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).

avg_insert_elapse

bigint

Average response time of INSERT statements (unit: μs).

total_delete_elapse

bigint

Total 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).

avg_delete_elapse

bigint

Average response time of DELETE statements (unit: μs).