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.
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot