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

STATEMENT_IOSTAT_COMPLEX_RUNTIME

STATEMENT_IOSTAT_COMPLEX_RUNTIME displays I/O load management information about ongoing jobs executed by the current user. The current feature is a lab feature. Contact Huawei technical support before using it. IOPS is counted by ones for column storage and by 10 thousands for row storage.

Table 1 STATEMENT_IOSTAT_COMPLEX_RUNTIME columns

Name

Type

Description

query_id

bigint

Job ID

mincurriops

integer

Minimum I/O of the job across database nodes

maxcurriops

integer

Maximum I/O of the job across database nodes

minpeakiops

integer

Minimum peak I/O of the current job across database nodes

maxpeakiops

integer

Maximum peak I/O of the current job across database nodes

io_limits

integer

io_limits set for the job

io_priority

text

io_priority set for the job

query

text

Job

node_group

text

Logical database of the user running the job

curr_io_limits

integer

Real-time io_limits value when io_priority is used to control I/Os