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

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.

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.