PG_USER_STATUS¶
PG_USER_STATUS records the states of users that access to the database. It is accessible only to users with system administrator rights.
Column | Type | Description |
---|---|---|
roloid | OID | ID of the role |
failcount | Integer | Specifies the number of failed attempts. |
locktime | Timestamp with time zone | Time at which the role is locked |
rolstatus | Smallint | Role state
|
permspace | Bigint | Size of the permanent table storage space used by a role in the current instance. |
tempspace | Bigint | Size of the temporary table storage space used by a role in the current instance. |