PG_TOTAL_USER_RESOURCE_INFO

PG_TOTAL_USER_RESOURCE_INFO 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. I/O monitoring items are valid only when enable_logical_io_statistics is set to on.

Table 1 PG_TOTAL_USER_RESOURCE_INFO columns

Name	Type	Description
username	name	Username
used_memory	integer	Used memory(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, 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. 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 permanent table storage space, in KB
total_space	bigint	Available permanent table storage space, in KB (-1 if the storage space is not limited)
used_temp_space	bigint	Used temporary 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	Size of the used operator flushing space(Reserved field, not in use yet.), in KB
total_spill_space	bigint	Total size of the available operator flushing space(Reserved field, not in use yet.), in KB (-1 if the space is not limited)
read_kbytes	bigint	Primary database node: total bytes read by the user's complex jobs on all database nodes in the last 5 seconds, in KB Database node: total bytes read by the user's complex jobs from the instance startup time to the current time, in KB Not supported currently, available only in distributed mode.
write_kbytes	bigint	Primary database node: total bytes written by the user's complex jobs on all database nodes in the last 5 seconds, in KB Database node: total bytes written by the user's complex jobs from the instance startup time to the current time, in KB Not supported currently, available only in distributed mode.
read_counts	bigint	Primary database node: total number of read times of the user's complex jobs on all database nodes in the last 5 seconds Database node: total number of read times of the user's complex jobs from the instance startup time to the current time Not supported currently, available only in distributed mode.
write_counts	bigint	Primary database node: total number of write times of the user's complex jobs on all database nodes in the last 5 seconds Database node: total number of write times of the user's complex jobs from the instance startup time to the current time Not supported currently, available only in distributed mode.
read_speed	double precision	Primary database node: average read rate of the user's complex jobs on a single database node in the last 5 seconds, in KB/s Database node: average read rate of the user's complex jobs on the database node in the last 5 seconds, in KB/s Not supported currently, available only in distributed mode.
write_speed	double precision	Primary database node: average write rate of the user's complex jobs on a single database node in the last 5 seconds, in KB/s Database node: average write rate of the user's complex jobs on the database node in the last 5 seconds, in KB/s Not supported currently, available only in distributed mode.