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. For details about the columns, see Table 1.

IOPS is counted by 10 thousands per second.

Contact Huawei technical support if the view displays no data.

**Table 1** PG_SESSION_IOSTAT columns
Name	Type	Description
query_id	bigint	Job ID.
mincurriops	integer	Minimum I/O of the current job across each DN.
maxcurriops	integer	Maximum I/O of the current job across each DN.
minpeakiops	integer	Minimum I/O peak at each DN during job running.
maxpeakiops	integer	Maximum I/O peak at each DN during job running.
io_limits	integer	The GUC parameter io_limits set for the job.
io_priority	text	The GUC parameter io_priority set for the job.
query	text	Job.
node_group	text	Node group of the user to which a job belongs.
curr_io_limits	integer	Real-time value of io_limits when io_priority is used to control I/Os.