STATEMENT_IOSTAT_COMPLEX_RUNTIME
STATEMENT_IOSTAT_COMPLEX_RUNTIME displays I/O load management information about ongoing jobs executed by the current user. 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 openGauss of the user running the job
|
curr_io_limits
|
integer
|
Real-time io_limits value when io_priority is used to control I/Os
|