• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_USER_IOSTAT

PG_USER_IOSTAT

PG_SESSION_WLMSTAT shows the corresponding 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_USER_IOSTAT columns

Name

Type

Description

userid

oid

User ID

min_curr_iops

int4

Minimum I/O of the current user across DNs

max_curr_iops

int4

Maximum I/O of the current user across DNs

min_peak_iops

int4

Minimum peak I/O of the current user across DNs

max_peak_iops

int4

Maximum I/O of the current user across DNs

io_limits

int4

io_limits set for the resource pool specified by the user

io_priority

text

io_priority set for the user