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 engineers for technical support before using it.) IOPS is counted by ones for column store and by 10 thousands for row store.

Table 1 STATEMENT_IOSTAT_COMPLEX_RUNTIME columns

Name

Type

Description

query_id

bigint

Job ID

mincurriops

integer

Minimum I/O of the current job across DNs

maxcurriops

integer

Maximum I/O of the current job across DNs

minpeakiops

integer

Minimum peak I/O of the current job across DNs

maxpeakiops

integer

Maximum peak I/O of the current job across DNs

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 cluster of the user running the job (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.)

curr_io_limits

integer

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