WLM_USER_RESOURCE_RUNTIME
WLM_USER_RESOURCE_RUNTIME 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 |
|---|---|---|
| username | name | Username |
| used_memory | integer | Used memory (unit: 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 | integer | 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 (unit: KB) |
| total_space | bigint | Available storage space (unit: KB) The value -1 indicates that the maximum storage space is not limited. |
| used_temp_space | bigint | Used temporary space (reserved column; unit: KB) |
| total_temp_space | bigint | Available temporary storage space (reserved column; unit: KB) The value -1 indicates that the maximum temporary storage space is not limited. |
| used_spill_space | bigint | Used space for storing spilled data (reserved column; unit: KB) |
| total_spill_space | bigint | Available storage space for spilled data (reserved column; unit: KB) The value -1 indicates that the maximum space for spilled data is not limited. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
