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 |
Last Article: PG_SESSION_WLMSTAT
Next Article: PG_SETTINGS
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.