PG_USER_STATUS

0: normal.
1: The role is locked for a specific period of time because the failed login attempts exceed the threshold.
2: The role is locked by the administrator.

PG_USER_STATUS records the states of users who access the database. This system catalog is accessible only to system administrators.

**Table 1** PG_USER_STATUS columns
Name	Type	Description
oid	oid	Row identifier (hidden attribute, which must be specified).
roloid	oid	Role ID.
failcount	integer	Number of failed attempts.
locktime	timestamp with time zone	Time at which the role is locked.
rolstatus	smallint	Role state. 0: normal. 1: The role is locked for a specific period of time because the failed login attempts exceed the threshold. 2: The role is locked by the administrator.
permspace	bigint	Size of the permanent table storage space used by the role.
tempspace	bigint	Size of the temporary table storage space used by the role.
passwordexpired	smallint	Specifies whether a password is valid. 0: The password is valid. 1: The password is invalid.