PG_USER_STATUS

PG_USER_STATUS provides 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	ID of a role
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 a role
tempspace	bigint	Size of the temporary table storage space used by a role
passwordexpired	smallint	Whether a password is valid. - 0: The password is valid. - 1: The password is invalid.