Updated on 2025-05-29 GMT+08:00

SUMMARY_USER_LOGIN

SUMMARY_USER_LOGIN records information about user logins and logouts on the primary database node, as described in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

Table 1 SUMMARY_USER_LOGIN columns

Name

Type

Description

node_name

text

Node name.

user_name

text

Username.

user_id

integer

User OID (Its value is the same as that of oid in pg_authid.)

login_counter

bigint

Number of logins.

logout_counter

bigint

Number of logouts.

dbid

oid

ID of the database to which the user logs in.