PG_SESSION_IOSTAT

PG_SESSION_IOSTAT displays I/O workload management information about the task currently executed by the user. Only the user with the SYSADMIN or MONADMIN permission can query this view.

IOPS is counted by 10 thousands per second.

**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 I/O peak of a database instance during job running.
maxpeakiops	integer	Maximum I/O peak of a database instance during job running.
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 value of io_limits when io_priority is used to control I/Os.