Updated on 2024-06-03 GMT+08:00

WLM_USER_RESOURCE_RUNTIME

WLM_USER_RESOURCE_RUNTIME displays resource usage of all users. Only administrators can query this view, as described in Table 1. This view is valid only when the GUC parameter use_workload_manager is set to on.

Table 1 WLM_USER_RESOURCE_RUNTIME columns

Name

Type

Description

username

name

Username.

used_memory

integer

Size of the memory being used (unit: MB).

total_memory

integer

Available memory (unit: MB). The value 0 indicates that the available memory is not limited and depends on the maximum memory available in the database.

used_cpu

integer

Number of CPU cores in use.

total_cpu

integer

Total number of CPU cores of the Cgroup associated with the user on the node.

used_space

bigint

Used storage space (unit: KB).

total_space

bigint

Available storage space (unit: KB). The value -1 indicates that the space is not limited.

used_temp_space

bigint

Used temporary space (reserved column; unit: KB).

total_temp_space

bigint

Available temporary space (reserved column; unit: KB). The value -1 indicates that the maximum temporary storage space is not limited.

used_spill_space

bigint

Used space for storing spilled data (reserved column; unit: KB).

total_spill_space

bigint

Available space for storing spilled data (reserved column; unit: KB). The value -1 indicates that the maximum space for storing spilled data is not limited.