GS_USER_MONITOR
GS_USER_MONITOR displays all users' job running and resource usage information. This view can be queried only on CNs. This view is supported only by clusters of 8.2.1.100 and later versions.
| Column | Type | Description |
|---|---|---|
| usename | Name | Username |
| rpname | Name | Name of the resource pool associated with the user |
| nodegroup | Name | Name of the logical cluster the resource pool belongs to. The default value is installation. |
| session_count | Bigint | Number of sessions initiated by the user, including idle and active sessions |
| active_count | Bigint | Number of active sessions initiated by the user, that is, the number of sessions that are performing queries. |
| global_wait | Bigint | Number of jobs that are queued because the number of concurrent jobs on a single CN exceeds the value of max_active_statements. |
| fast_run | Bigint | Number of jobs that are running on the fast lane of the resource pool among all jobs executed by the user. |
| fast_wait | Bigint | Number of jobs queued in the fast lane of the resource pool among all jobs executed by the user. |
| slow_run | Bigint | Number of jobs that are running on the slow lane of the resource pool among all jobs executed by the user. |
| slow_wait | Bigint | Number of jobs queued in the slow lane of the resource pool among all jobs executed by the user. |
| used_mem | Bigint | Average memory used by a user on all DNs, in MB. |
| estimate_mem | Bigint | Total estimated memory used by running jobs, in MB. |
| used_cpu | Double precision | Average number of CPU cores used by a user on all DNs. If a single node contains multiple DNs, the number of CPU cores used by a user on the node must be multiplied by the number of DNs. |
| read_speed | Bigint | Average logical I/O read rate of a user on all DNs, in KB/s. |
| write_speed | Bigint | Average logical I/O write rate of a user on all DNs, in KB/s. |
| send_speed | Bigint | Average data sending rate of a user on all DNs, in KB/s. |
| recv_speed | Bigint | Average data receiving rate of a user on all DNs, in KB/s. |
| used_space | Bigint | Used space of user permanent tables, in KB. |
| space_limit | Bigint | Maximum space that can be used by user permanent tables, in KB. The value -1 indicates that the space size is not limited. |
| used_temp_space | Bigint | Used space of user temporary tables, in KB. |
| temp_space_limit | Bigint | Maximum space that can be used by user temporary tables, in KB. The value -1 indicates that the space size is not limited. |
| used_spill_space | Bigint | Used space for flushing intermediate result sets, in KB. |
| spill_space_limit | Bigint | Maximum space that can be used for flushing intermediate result sets, in KB. The value -1 indicates that the space size is not limited. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
