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

PG_TOTAL_USER_RESOURCE_INFO

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

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

Used memory (unit: MB)

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.

used_cpu

double precision

Number of CPU cores in use. Only the CPU usage of complex jobs 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 storage space (unit: KB). -1 indicates that the storage space is not limited.

used_temp_space

bigint

Used temporary table storage space (unit: KB)

total_temp_space

bigint

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

used_spill_space

bigint

Size of the used operator flushing space, in KB

total_spill_space

bigint

Size of the available operator flushing space, in KB. The value -1 indicates that the operator flushing space is not limited.

read_kbytes

bigint

CN: total number of bytes read by a user's complex jobs on all DNs in the last 5 seconds. The unit is KB.

DN: 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

CN: total number of bytes written by a user's complex jobs on all DNs in the last 5 seconds. The unit is KB.

DN: 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. Unit: count.

DN: total number of read times of a user's complex jobs from the instance startup time to the current time. Unit: count.

write_counts

bigint

CN: total number of write times of a user's complex jobs on all DNs in the last 5 seconds. Unit: count.

DN: total number of write times of a user's complex jobs from the instance startup time to the current time. Unit: count.

read_speed

double precision

CN: average read rate of a user's complex jobs on a single DN in the last 5 seconds. (Unit: KB/s)

DN: indicates the average read rate of a user's complex jobs on a single DN in the last 5 seconds. (Unit: KB/s)

write_speed

double precision

CN: average write rate of a user's complex jobs on a single DN in the last 5 seconds. (Unit: KB/s)

DN: average write rate of a user's complex jobs on a single DN in the last 5 seconds. (Unit: KB/s)

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