In this article, we will see how to find currently logged in users in PostgreSQL. We can get the currently logged in users information by querying against pg_stat_activity system view. pg_stat_activity shows the datname, pid, usename, backend_start,wait_event_type,wait_event,state,query,…
Query to find currently logged in users in PostgreSQL
SELECT DISTINCT usename FROM pg_stat_activity;
Ouput:
usename ---------- james postgres