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

GS_WLM_USER_RESOURCE_HISTORY

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

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

Specifies the used memory (unit: MB)

total_memory

int

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

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)

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