Updated on 2023-10-23 GMT+08:00

PG_TOTAL_USER_RESOURCE_INFO_OID

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

Table 1 PG_TOTAL_USER_RESOURCE_INFO_OID columns

Name

Type

Description

userid

oid

User ID

used_memory

integer

Used memory, in MB

total_memory

integer

Available memory, in MB. The value 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

total_cpu

integer

Total number of CPU cores of the Cgroup associated with the user on the node

used_space

bigint

Used storage space, in KB

total_space

bigint

Available storage space, in KB. The value -1 indicates that the space is not limited.

used_temp_space

bigint

Used temporary storage space, in KB

total_temp_space

bigint

Total available temporary space, in KB. The value -1 indicates that the space is not limited.

used_spill_space

bigint

Used disk space for spilling, in KB

total_spill_space

bigint

Total available disk space for spilling, in KB. The value -1 indicates that the space is not limited.

read_kbytes

bigint

Volume of data read from the disk, in KB.

write_kbytes

bigint

Volume of data written to the disk, in KB.

read_counts

bigint

Number of disk read times.

write_counts

bigint

Number of disk write times.

read_speed

double precision

Disk read rate, in B/ms.

write_speed

double precision

Disk write rate, in B/ms.