[psql-list-session-connection] List sessions / active connections in PostgreSQL database #psql

psql-list-session-connections.sql

select pid as process_id, 
       usename as user_name, 
       datname as database_name, 
       client_addr as client_address, 
       application_name,
       backend_start,
       state,
       state_change
from pg_stat_activity
where datname like '%'
order by datname, application_name, process_id;