HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

Other Versions:

PG_SESSION_IOSTAT

PG_SESSION_IOSTAT shows I/O load management information about the task currently executed by the user. Only users with the sysadmin or monitor admin permission can query this view.

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

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 peak I/O of the current job across database instances
maxpeakiops integer Maximum peak I/O of the current job across database instances
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 io_limits value when io_priority is used to control I/Os
Copyright © 2011-2024 www.enmotech.com All rights reserved.