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 |
openGauss 2024-09-07 00:58:25