Help Center/ GaussDB/ Centralized_2.x/ Schemas/ DBE_PERF Schema/ Session/Thread/ STATEMENT_IOSTAT_COMPLEX_RUNTIME

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

View PDF

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