GS_USER_MONITOR

Updated on 2024-09-02 GMT+08:00

View PDF

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.

**Table 1** GS_USER_MONITOR columns
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.