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

Feedback
编组 3备份
    openGauss 2024-05-30 00:44:48
    cancel