PostgreSQLの接続数について

接続数の確認

SELECT * FROM pg_stat_activity;

同時接続数の設定値の確認

SHOW max_connections;

接続の開放

SELECT pg_terminate_backend(pid)
  FROM pg_stat_activity
 WHERE datname = 'DB名'
   AND pid <> pg_backend_pid();