Piotr Synowiec
Piotr Synowiec
~1 min read

Categories

Tags

How to kill all processes except my own connection to specific DB

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

where ‘database_name’ is your DB that you are working on.