#接続数の確認
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();
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme