Re: Deleting idle connections
| От | Ron Johnson |
|---|---|
| Тема | Re: Deleting idle connections |
| Дата | |
| Msg-id | CANzqJaDVz6H=wUqXi72ZieNs3ivTSuYxnM6AYxEKKOMQigU_iw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Deleting idle connections (Yongye Serkfem <yserkfem@gmail.com>) |
| Ответы |
Re: Deleting idle connections
|
| Список | pgsql-general |
On Mon, Feb 24, 2025 at 5:50 PM Yongye Serkfem <yserkfem@gmail.com> 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!
В списке pgsql-general по дате отправления: