doc-exports/docs/dws/dev/dws_04_0567.html

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	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)

Parent topic: System Catalogs