PostgreSQLで現在の接続数をみたい場合のSQL文
詳細
SELECT * FROM pg_stat_activity
ORDER BY query_start;
サマリー
SELECT datname, usename, COUNT(*)
FROM pg_stat_activity
GROUP BY datname, usename;
PostgreSQLで現在の接続数をみたい場合のSQL文
詳細
SELECT * FROM pg_stat_activity
ORDER BY query_start;
サマリー
SELECT datname, usename, COUNT(*)
FROM pg_stat_activity
GROUP BY datname, usename;