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 engineers for 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 engineers for technical support before using it.)
curr_io_limits	integer	Real-time io_limits value when io_priority is used to control I/Os