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 the GUC parameter use_workload_manager is set to on.
| Name | Type | Description |
|---|---|---|
| userid | oid | User ID. |
| used_memory | integer | Size of the memory being used, 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. |
| 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 (-1 if 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 (-1 if the temporary 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 (-1 if the space is not limited). |
| read_kbytes | bigint | Amount of data read from the disk, in KB. |
| write_kbytes | bigint | Amount 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
