PG_TOTAL_USER_RESOURCE_INFO

Updated on 2024-12-19 GMT+08:00

View PDF

PG_TOTAL_USER_RESOURCE_INFO displays the resource usage of all users. Only administrators can query this view. This view is valid only if use_workload_manager is set to on.

**Table 1** **PG_TOTAL_USER_RESOURCE_INFO** columns
Name	Type	Description
username	name	Username
used_memory	integer	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	integer	Memory used by the resource pool (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	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.
total_cpu	integer	Total number of CPU cores of the Cgroup associated with a user on the node
used_space	bigint	Used permanent table storage space (unit: KB)
total_space	bigint	Available permanent table storage space (unit: KB) The value -1 indicates no limit.
used_temp_space	bigint	Used temporary table storage space (unit: KB)
total_temp_space	bigint	Available temporary table storage space (unit: KB) The value -1 indicates no limit.
used_spill_space	bigint	Space used for operator spill, in KB.
total_spill_space	bigint	Available space for operator spill, in KB. The value -1 indicates no limit.
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	CN: total number of read times of a user's complex jobs on all DNs in the last 5 seconds. DN: total number of read times of a user's complex jobs from the instance startup time to the current time.
write_counts	bigint	CN: total number of write times of a user's complex jobs on all DNs in the last 5 seconds. DN: 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.