[Active connections in Postgres]

active_connections.sql

SELECT
    usename,
    application_name,
    client_addr,
    COUNT(*) as connection_count,
    MIN(backend_start) as first_connection,
    MAX(backend_start) as latest_connection
FROM pg_stat_activity
GROUP BY usename, application_name, client_addr
ORDER BY connection_count DESC;

SELECT
    COUNT(*) as connection_count
FROM pg_stat_activity;