PG_TOTAL_USER_RESOURCE_INFO
PG_TOTAL_USER_RESOURCE_INFO displays the resource usage of all users. Only administrators can query this view. This view is valid only if use_workload_manager is set to on.
| Name | Type | Description |
|---|---|---|
| username | name | Username |
| used_memory | integer | Used memory (unit: MB) |
| total_memory | integer | Available memory (unit: MB). 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. Only the CPU usage of complex jobs is collected, and the value is the CPU usage of the related Cgroup. |
| total_cpu | integer | Total number of CPU cores of the Cgroup associated with a user on the node |
| used_space | bigint | Used permanent table storage space (unit: KB) |
| total_space | bigint | Available storage space (unit: KB). -1 indicates that the storage space is not limited. |
| used_temp_space | bigint | Used temporary table storage space (unit: KB) |
| total_temp_space | bigint | Available temporary table storage space (unit: KB). -1 indicates that the storage space is not limited. |
| used_spill_space | bigint | Size of the used operator flushing space, in KB |
| total_spill_space | bigint | Size of the available operator flushing space, in KB. The value -1 indicates that the operator flushing space is not limited. |
| read_kbytes | bigint | CN: total number of bytes read by a user's complex jobs on all DNs in the last 5 seconds. The unit is KB. DN: total number of bytes read by a user's complex jobs from the instance startup time to the current time. The unit is KB. |
| write_kbytes | bigint | CN: total number of bytes written by a user's complex jobs on all DNs in the last 5 seconds. The unit is KB. DN: total number of bytes written by a user's complex jobs from the instance startup time to the current time. The unit is KB. |
| read_counts | bigint | CN: total number of read times of a user's complex jobs on all DNs in the last 5 seconds. Unit: count. DN: total number of read times of a user's complex jobs from the instance startup time to the current time. Unit: count. |
| write_counts | bigint | CN: total number of write times of a user's complex jobs on all DNs in the last 5 seconds. Unit: count. DN: total number of write times of a user's complex jobs from the instance startup time to the current time. Unit: count. |
| read_speed | double precision | CN: average read rate of a user's complex jobs on a single DN in the last 5 seconds. (Unit: KB/s) DN: indicates the average read rate of a user's complex jobs on a single DN in the last 5 seconds. (Unit: KB/s) |
| write_speed | double precision | CN: average write rate of a user's complex jobs on a single DN in the last 5 seconds. (Unit: KB/s) DN: average write rate of a user's complex jobs on a single DN in the last 5 seconds. (Unit: KB/s) |
Last Article: PG_TOTAL_MEMORY_DETAIL
Next Article: PG_USER
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.