STATEMENT_IOSTAT_COMPLEX_RUNTIME

STATEMENT_IOSTAT_COMPLEX_RUNTIME displays I/O workload management information about ongoing jobs executed by the current user, as described in Table 1. IOPS is counted by 10 thousands per second.

**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.
curr_io_limits	integer	Real-time value of io_limits when io_priority is used to control I/Os.