Postgres find multiple connections by username
Postgres find multiple connections by username
SELECT usename as username,
count(pid)
FROM pg_stat_activity
GROUP BY usename
ORDER BY count DESC;
Postgres find multiple connections by username
SELECT usename as username,
count(pid)
FROM pg_stat_activity
GROUP BY usename
ORDER BY count DESC;