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.
Column | Type | Description |
|---|---|---|
username | Name | Username |
used_memory | Integer | Memory used by a user, in MB.
|
total_memory | Integer | Memory used by the resource pool, in MB. 0 indicates that the maximum available memory is not limited and depends on the maximum available memory of the database (max_dynamic_memory). The calculation formula is as follows: total_memory =max_dynamic_memory * parent_percent * user_percent On a CN, it indicates the total maximum available memory on all DNs. |
used_cpu | Double precision | Number of CPU cores in use. Only the CPU usage of complex jobs in the non-default resource pool 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 | On a CN, it indicates the total number of bytes logically read by a user on all DNs in the last 5 seconds, in KB. On a DN, it indicates the total number of bytes logically read by a user from the instance startup time to the current time, in KB. |
write_kbytes | Bigint | On a CN, it indicates the total number of bytes logically written by a user on all DNs in the last 5 seconds, in KB. On a DN, it indicates the total number of bytes logically written by a user from the instance startup time to the current time, in KB. |
read_counts | Bigint | On a CN, it indicates the total number of logical reads performed by a user on all DNs in the last 5 seconds. On a DN, it indicates the total number of logical reads performed by a user from the instance startup time to the current time. |
write_counts | Bigint | On a CN, it indicates the total number of logical writes performed by a user on all DNs in the last 5 seconds. On a DN, it indicates the total number of logical writes performed by a user from the instance startup time to the current time. |
read_speed | Double precision | On a CN, it indicates the sum of average logical read rates of a user on all DNs in the last 5 seconds, in KB/s. On a DN, it indicates the average logical read rate of a user on the DN in the last 5 seconds, in KB/s. |
write_speed | Double precision | On a CN, it indicates the sum of average logical write rates of a user on all DNs in the last 5 seconds, in KB/s. On a DN, it indicates the average logical write rate of a user on the DN in the last 5 seconds, in KB/s. |
send_speed | Double precision | On a CN, it indicates the sum of the average network sending rates of a user on all DNs in the last 5 seconds, in KB/s. On a DN, it indicates the average network sending rate of a user on the DN in the last 5 seconds, in KB/s. |
recv_speed | Double precision | On a CN, it indicates the sum of the average network receiving rates of a user on all DNs in the last 5 seconds, in KB/s. On a DN, it indicates the average network receiving rate of a user on the DN in the last 5 seconds, in KB/s. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
