PG_SESSION_IOSTAT¶
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 |