Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_SESSION_IOSTAT

PG_SESSION_IOSTAT

Updated at: Jul 15, 2020 GMT+08:00

PG_SESSION_IOSTAT displays the I/O load management information about the task currently executed by the user.

IOPS is counted by ones for column storage and by 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 across DNs

maxcurriops

integer

Maximum I/O of the current job across DNs

minpeakiops

integer

Minimum peak I/O of the current job across DNs

maxpeakiops

integer

Maximum peak I/O of the current job across DNs

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel