Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Workload Management/ GS_WLM_USER_INFO
Updated on 2025-08-19 GMT+08:00
View PDF

GS_WLM_USER_INFO

GS_WLM_USER_INFO displays user statistics. Only users with the sysadmin permission can query this view.

If no data is displayed in the queried view, contact Huawei technical support.

Table 1 GS_WLM_USER_INFO columns

Name

Type

Description

userid

oid

OID of a user.

username

name

Username.

sysadmin

Boolean

Specifies whether the user is the administrator.

  • t (true): yes.
  • f (false): no.

rpoid

oid

OID of the associated resource pool.

respool

name

Name of the associated resource pool.

parentid

oid

OID of the user group.

totalspace

bigint

Available space limit of the user.

spacelimit

bigint

User table space limit.

childcount

integer

Number of child users.

childlist

text

Child user list.
Parent topic: Workload Management