On Mon, Feb 24, 2025 at 5:50 PM Yongye Serkfem <yserkfem@xxxxxxxxx> wrote:
Hi Everyone!I am having a series of idle connections and unable to delete them with a single command. Any help in realizing this would be greatly appreciated.
This will kill idle connections older than two hours:
select pid, pg_terminate_backend(pid)
from pg_stat_activity
where state = 'idle'
and (EXTRACT(epoch FROM now() - backend_start))/3600.0 > 2;
from pg_stat_activity
where state = 'idle'
and (EXTRACT(epoch FROM now() - backend_start))/3600.0 > 2;
Be warned that it might kill more than you want. Add more WHERE predicates as filter.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
