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

GLOBAL_WLM_RESPOOL_IO_INFO

This view is used to view the real-time I/O usage of resource pools on all nodes in a distributed system. Only the user with the SYSADMIN or MONADMIN permission can query this view.

This view can be used to query only the data on the primary DN. You need to log in to the standby node and use the system function gs_wlm_respool_io_info() to query the usage of I/Os.

Table 1 GLOBAL_WLM_RESPOOL_IO_INFO columns

Name

Type

Description

node_name

name

Node name.

respool_name

name

Name of a resource pool.

io_limits

integer

Upper limit of IOPS. The value 0 indicates there is no limit.

  • Row-store: The unit is determined by GUC parameter io_control_unit, which is used to count the number of I/Os during I/O control. The value of io_control_unit is 1, which indicates one IOPS.

io_priority

text

I/O priority set for jobs that consume I/O resources. It takes effect when the I/O usage reaches 90%. None indicates there is no control.

current_iops

integer

Number of times that the current I/O has been triggered.

The current I/O statistics occasionally exceed the upper limit, which is related to the I/O statistics algorithm and is normal.

Example:
1
2
3
4
5
6
7
8
gaussdb=# SELECT * FROM GLOBAL_WLM_RESPOOL_CONCURRENCY_INFO;
 node_name   | respool_name | io_limits | io_priority | current_iops 
--------------+--------------+-----------+-------------+--------------
 coordinator1 | default_pool |         0 | None        |            0
 datanode2    | default_pool |         0 | None        |            0
 datanode3    | default_pool |         0 | None        |            0
 datanode1    | default_pool |         0 | None        |            0
(4 rows)