PG_SESSION_IOSTAT

PG_SESSION_IOSTAT shows I/O load management information about the task currently executed by the user. (The current feature is a lab feature. Contact Huawei technical support before using it.) Only users with the sysadmin or monitor admin permission can query this view.

IOPS is counted by ones for column-storage and by 10 thousands for row storage.

**Table 1** PG_SESSION_IOSTAT columns
Name	Type	Description
query_id	bigint	Job ID
mincurriops	integer	Minimum I/O of the current job on each DN
maxcurriops	integer	Maximum I/O of the current job on each DN
minpeakiops	integer	Minimum peak I/O of the current job on each DN
maxpeakiops	integer	Maximum peak I/O of the current job on each DN
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 (The current feature is a lab feature. Contact Huawei technical support before using it.)
curr_io_limits	integer	Real-time io_limits value when io_priority is used to control I/Os