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

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 current job across DNs.

maxcurriops

integer

Maximum I/O of the current job across DNs.

minpeakiops

integer

Minimum peak I/O of the current job across DNs.

maxpeakiops

integer

Maximum peak I/O of the current job across DNs.

io_limits

integer

io_limits set for the job.

io_priority

text

io_priority set for the job.

query

text

Job.

node_group

text

Node group of the user to which a job belongs.

curr_io_limits

integer

Real-time value of iolimits when io_priority is used to control I/Os.
Parent topic: Session and Thread