PGXC_WLM_USER_RESOURCE_HISTORY

Updated on 2024-09-30 GMT+08:00

View PDF

The PGXC_WLM_USER_RESOURCE_HISTORY view displays historical information about resource consumption of all users on the corresponding instances. This view is supported only by clusters of version 8.2.0 or later.

**Table 1** PGXC_WLM_USER_RESOURCE_HISTORY columns
Name	Type	Description
nodename	name	Instance name, including CNs and DNs.
username	text	Username
timestamp	timestamp with time zone	Timestamp
used_memory	integer	Used memory (unit: MB). On a DN, it indicates a user's memory usage on the current DN. On a CN, it indicates a user's total memory usage on all DNs.
total_memory	integer	Available memory (unit: MB). 0 indicates that the available memory is not limited and depends on the maximum memory available in the database. On a DN, it indicates the memory available to a user on the current DN. On a CN, it indicates the total memory available to a user on all DNs.
used_cpu	double precision	Number of CPU cores in use. Only the CPU usage of complex jobs in the non-default resource pool is collected, and the value is the CPU usage of the related cgroup. On a DN, it indicates a user's CPU core usage on the current DN. On a CN, it indicates a user's total CPU core usage on all DNs.
total_cpu	integer	Total number of CPU cores of the Cgroups associated with a user. On a DN, it indicates the CPU cores available to a user on the current DN. On a CN, it indicates the total CPU cores available to a user on all DNs.
used_space	bigint	Used permanent table storage space (unit: KB) On a DN, it indicates the size of the permanent table storage space used by a user on the current DN. On a CN, it indicates the total size of the permanent table storage space used by a user on all DNs.
total_space	bigint	Available storage space, in KB. –1 indicates that the storage space is not limited. On a DN, it indicates the size of the permanent table storage space available to a user on the current DN. On a CN, it indicates the total size of the permanent table storage space available to a user on all DNs.
used_temp_space	bigint	Used temporary table storage space (unit: KB) On a DN, it indicates the size of the temporary table storage space used by a user on the current DN. On a CN, it indicates the total size of the temporary table storage space used by a user on all DNs.
total_temp_space	bigint	Available temporary table storage space, in KB. –1 indicates that the storage space is not limited. On a DN, it indicates the size of the temporary table storage space available to a user on the current DN. On a CN, it indicates the total size of the temporary table storage space available to a user on all DNs.
used_spill_space	bigint	Size of space used for operator spill to disk, in KB. On a DN, it indicates displays the size of the operator flushing space used by the user on the current DN. On a CN, it indicates the total space used by a user's operators spilled to disk on all DNs.
total_spill_space	bigint	Size of space available for operator spill to disk, in KB. The value –1 indicates that the space is not limited. On a DN, it indicates displays the size of the operator flushing space that can be used by the user on the current DN. On a CN, it indicates the total space available for a user to spill operators to disk on all DNs.
read_kbytes	bigint	On a CN, it indicates total number of bytes read by a user's complex jobs on all DNs in the last 5 seconds. The unit is KB. On a DN, it indicates the total number of bytes read by a user's complex jobs from the instance startup time to the current time. The unit is KB.
write_kbytes	bigint	On a CN, it indicates total number of bytes written by a user's complex jobs on all DNs in the last 5 seconds. On a DN, it indicates the total number of bytes written by a user's complex jobs from the instance startup time to the current time. The unit is KB.
read_counts	bigint	On a CN, it indicates total number of read times of a user's complex jobs on all DNs in the last 5 seconds. On a DN, it indicates total number of read times of a user's complex jobs from the instance startup time to the current time.
write_counts	bigint	On a CN, it indicates total number of write times of a user's complex jobs on all DNs in the last 5 seconds. On a DN, it indicates total number of write times of a user's complex jobs from the instance startup time to the current time.
read_speed	double precision	On a CN, it indicates the average read rate of a user's complex jobs on a single DN in the last 5 seconds, in KB/s. On a DN, it indicates the average read rate of a user's complex jobs on the DN in the last 5 seconds, in KB/s.
write_speed	double precision	On a CN, it indicates the average write rate of a user's complex jobs on a single DN in the last 5 seconds, in KB/s. On a DN, it indicates the average write rate of a user's complex jobs on the DN in the last 5 seconds, in KB/s.
send_speed	double precision	On a CN, it indicates the sum of the average network sending rates of a user on all DNs in a 5s monitoring period, in KB/s. On a DN, it indicates the average network sending rate of a user on the DN in a 5s monitoring period, in KB/s.
recv_speed	double precision	On a CN, it indicates the sum of the average network receiving rates of a user on all DNs in a 5s monitoring period, in KB/s. On a DN, it indicates the average network receiving rate of a user on the DN in a 5s monitoring period, in KB/s.