Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ Schemas/ DBE_PERF Schema/ Session/Thread/ STATEMENT_IOSTAT_COMPLEX_RUNTIME
Updated on 2025-08-19 GMT+08:00
View PDF

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.
Parent topic: Session/Thread