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