PG_SESSION_IOSTAT displays the I/O load management information about the task currently executed by the user.
IOPS is counted by ones for column storage and by thousands for row storage.
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 |
Logical cluster of the user running the job |