Updated on 2023-12-29 GMT+08:00

GS_WLM_USER_RESOURCE_HISTORY

The GS_WLM_USER_RESOURCE_HISTORY system table stores information about resources used by users and is valid only on CNs. Each record in the system table indicates the resource usage of a user at a time point, including the memory, number of CPU cores, storage space, temporary space, operator flushing space, logical I/O traffic, number of logical I/O times, and logical I/O rate. The memory, CPU, and I/O monitoring items record only the resource usage of complex jobs.

Data in the GS_WLM_USER_RESOURCE_HISTORY system table comes from the PG_TOTAL_USER_RESOURCE_INFO view.

Table 1 GS_WLM_USER_RESOURCE_HISTORY column

Name

Type

Description

username

text

Username

timestamp

timestamp with time zone

Timestamp

used_memory

int

Memory size used by a user, in MB.

  • DN: The memory used by users on the current DN is displayed.
  • CN: The total memory usage of users on all DNs is displayed.

total_memory

int

Memory used by the resource pool, in MB. 0 indicates that the available memory is not limited and depends on the maximum memory available in the database (max_dynamic_memory). A calculation formula is as follows:

total_memory = max_dynamic_memory * parent_percent * user_percent

CN: The sum of maximum available memory on all DNs is displayed.

used_cpu

real

Number of CPU cores in use

total_cpu

int

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

used_space

bigint

Used storage space (unit: KB)

total_space

bigint

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

used_temp_space

bigint

Used temporary storage space (unit: KB)

total_temp_space

bigint

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

used_spill_space

bigint

Used space of operator flushing (unit: KB)

total_spill_space

bigint

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

read_kbytes

bigint

Byte traffic of read operations in a monitoring period (unit: KB)

write_kbytes

bigint

Byte traffic of write operations in a monitoring period (unit: KB)

read_counts

bigint

Number of read operations in a monitoring period.

write_counts

bigint

Number of write operations in a monitoring period.

read_speed

real

Byte rate of read operations in a monitoring period (unit: KB)

write_speed

real

Byte rate of write operations in a monitoring period (unit: KB)