GS_WLM_USER_INFO
GS_WLM_USER_INFO displays user statistics.
Table 1 GS_WLM_USER_INFO columns
Name  | Type  | Description  | 
|---|
userid  | oid  | OID of a user  | 
username  | name  | Username  | 
sysadmin  | boolean  | Whether the user is the administrator  | 
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  | interger  | Number of child users  | 
childlist  | text  | Child user list  | 
openGauss 2025-11-03 22:43:02