Updated on 2025-05-29 GMT+08:00

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.

IOPS is counted by 10 thousands per second.

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 I/O peak of a database instance during job running.

maxpeakiops

integer

Maximum I/O peak of a database instance during job running.

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 value of io_limits when io_priority is used to control I/Os.