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	Size of the memory being used(The total size of memory used by the user's current active session. If no business is running or the session has ended, the dynamic memory will be automatically reclaimed, resulting in a size of 0.), in MB.
total_memory	integer	Available memory (unit: 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. CPU usage data is collected only in complex jobs, and the value is the CPU usage of the related Cgroup.
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 (unit: KB). The value -1 indicates that the space is not limited.
used_temp_space	bigint	Used temporary storage space(Reserved field, not in use yet.), in KB.
total_temp_space	bigint	Total available temporary space(Reserved field, not in use yet.), in KB (-1 if the temporary space is not limited).
used_spill_space	bigint	Used disk space for spilling(Reserved field, not in use yet.), in KB.
total_spill_space	bigint	Total available disk space for spilling(Reserved field, not in use yet.), in KB. The value -1 indicates that the space is not limited.
read_kbytes	bigint	Amount of data read from the disk(Not supported currently, available only in distributed mode.), in KB.
write_kbytes	bigint	Amount of data written to the disk(Not supported currently, available only in distributed mode.), in KB.
read_counts	bigint	Number of disk read times(Not supported currently, available only in distributed mode.).
write_counts	bigint	Number of disk write times(Not supported currently, available only in distributed mode.).
read_speed	double precision	Disk read rate(Not supported currently, available only in distributed mode.), in B/ms.
write_speed	double precision	Disk write rate(Not supported currently, available only in distributed mode.), in B/ms.