Useful for debugging sites that are hogging connections, especially if you have persistent connections on.

SELECT
    datname,
    COUNT(*) AS open_connections,
    MAX(backend_start) AS oldest_connection,
    MIN(backend_start) AS newest_connection
    FROM pg_stat_activity GROUP BY datname
UNION SELECT
    'Summary',
    COUNT(*),
    MAX(backend_start),
    MIN(backend_start)
    FROM pg_stat_activity;

Sorry, I accidentally deleted this post. Here it is again.

This entry was posted on Sunday, March 9th, 2008 at 8:58 am and is filed under PostgreSQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.