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 | Number of bytes read during the monitoring interval, in kilobytes/s. |
write_kbytes | bigint | Number of bytes written during the monitoring interval, in kilobytes/s. |
read_counts | bigint | Number of read times during the monitoring interval. |
write_counts | bigint | Number of write times during the monitoring interval. |
read_speed | double precision | Read speed, in bytes/s. |
write_speed | double precision | Write speed, in bytes/s. |
openGauss 2024-05-19 00:45:18