Are you an LLM? You can read better optimized documentation at /en/docs/7.0.0-lite/database_reference/pg_session_iostat.md for this page in Markdown format
PG_SESSION_IOSTAT
PG_SESSION_IOSTAT shows I/O load management information about the task currently executed by the user. Only users with the sysadmin or monitor admin permission can query this view.
IOPS is counted by ones for column store and by 10 thousands for row store.
Table 1 PG_SESSION_IOSTAT columns
Name | Type | Description |
|---|
query_id | bigint | Job ID |
mincurriops | integer | Minimum I/O of the job across database instances |
maxcurriops | integer | Maximum I/O of the job across database instances |
minpeakiops | integer | Minimum peak I/O of the current job across database instances |
maxpeakiops | integer | Maximum peak I/O of the current job across database instances |
io_limits | integer | io_limits set for the job |
io_priority | text | io_priority set for the job |
query | text | Job |
node_group | text | Unsupported currently |
curr_io_limits | integer | Real-time io_limits value when io_priority is used to control I/Os |