PGXC_WLM_USER_RESOURCE_HISTORY
The PGXC_WLM_USER_RESOURCE_HISTORY view displays historical information about resource consumption of all users on the corresponding instances. This view is supported only by clusters of version 8.2.0 or later.
Column | Type | Description |
|---|---|---|
nodename | Name | Instance name, including CNs and DNs. |
username | Text | Username |
Timestamp | Timestamp with time zone | Timestamp |
used_memory | Integer | Used memory (unit: MB). On a DN, it indicates a user's memory usage on the current DN. On a CN, it indicates a user's total memory usage on all DNs. |
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. On a DN, it indicates the memory available to a user on the current DN. On a CN, it indicates the total memory available to a user 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. On a DN, it indicates a user's CPU core usage on the current DN. On a CN, it indicates a user's total CPU core usage on all DNs. |
total_cpu | Integer | Total number of CPU cores of the Cgroups associated with a user. On a DN, it indicates the CPU cores available to a user on the current DN. On a CN, it indicates the total CPU cores available to a user on all DNs. |
used_space | Bigint | Used permanent table storage space (unit: KB) On a DN, it indicates the size of the permanent table storage space used by a user on the current DN. On a CN, it indicates the total size of the permanent table storage space used by a user on all DNs. |
total_space | Bigint | Available storage space, in KB. –1 indicates that the storage space is not limited. On a DN, it indicates the size of the permanent table storage space available to a user on the current DN. On a CN, it indicates the total size of the permanent table storage space available to a user on all DNs. |
used_temp_space | Bigint | Used temporary table storage space (unit: KB) On a DN, it indicates the size of the temporary table storage space used by a user on the current DN. On a CN, it indicates the total size of the temporary table storage space used by a user on all DNs. |
total_temp_space | Bigint | Available temporary table storage space, in KB. –1 indicates that the storage space is not limited. On a DN, it indicates the size of the temporary table storage space available to a user on the current DN. On a CN, it indicates the total size of the temporary table storage space available to a user on all DNs. |
used_spill_space | Bigint | Size of space used for operator spill to disk, in KB. On a DN, it indicates displays the size of the operator flushing space used by the user on the current DN. On a CN, it indicates the total space used by a user's operators spilled to disk on all DNs. |
total_spill_space | Bigint | Size of space available for operator spill to disk, in KB. The value –1 indicates that the space is not limited. On a DN, it indicates displays the size of the operator flushing space that can be used by the user on the current DN. On a CN, it indicates the total space available for a user to spill operators to disk on all DNs. |
read_kbytes | Bigint | On a CN, it indicates total number of bytes read by a user's complex jobs on all DNs in the last 5 seconds. The unit is KB. On a DN, it indicates the 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 | On a CN, it indicates total number of bytes written by a user's complex jobs on all DNs in the last 5 seconds. On a DN, it indicates the 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 | On a CN, it indicates total number of read times of a user's complex jobs on all DNs in the last 5 seconds. On a DN, it indicates total number of read times of a user's complex jobs from the instance startup time to the current time. |
write_counts | Bigint | On a CN, it indicates total number of write times of a user's complex jobs on all DNs in the last 5 seconds. On a DN, it indicates total number of write times of a user's complex jobs from the instance startup time to the current time. |
read_speed | Double precision | On a CN, it indicates the average read rate of a user's complex jobs on a single DN in the last 5 seconds, in KB/s. On a DN, it indicates the average read rate of a user's complex jobs on the DN in the last 5 seconds, in KB/s. |
write_speed | Double precision | On a CN, it indicates the average write rate of a user's complex jobs on a single DN in the last 5 seconds, in KB/s. On a DN, it indicates the average write rate of a user's complex jobs 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 a 5s monitoring period, in KB/s. On a DN, it indicates the average network sending rate of a user on the DN in a 5s monitoring period, 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 a 5s monitoring period, in KB/s. On a DN, it indicates the average network receiving rate of a user on the DN in a 5s monitoring period, in KB/s. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
