Updated on 2023-10-23 GMT+08:00

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 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