Query to Check the Active and Inactive users in PostgreSQL

 

/*Query to Check the Active and Inactive users in PostgreSQL*/

———————————————————————————————————–

select count(*),usename,state from pg_stat_activity group by usename, state;

select usename,state,state_change,pid,backend_start,client_addr from pg_stat_activity where usename like ‘sc_%’ order by 5,2,1;