Hi,
This won't answer your question but still... I usually really like your scripts, it's nicely written, but this part seems really weird to me:
Le mar. 13 sept. 2022 à 20:23, Bryn Llewellyn <bryn@xxxxxxxxxxxx> a écrit :
-- No error
do $body$
declare
p int not null := 0;
begin
for p in (
select pid
from pg_stat_activity
where backend_type = 'client backend'
and pid <> pg_backend_pid())
loop
perform pg_terminate_backend(p);
end loop;
end;
$body$;
While your script works great, I'm wondering why you don't write it this way:
SELECT pg_terminate_backend(pid) FROM pg_stat_activity
WHERE backend_type = 'client backend' AND pid <> pg_backend_pid();
WHERE backend_type = 'client backend' AND pid <> pg_backend_pid();
As it is less code, it's quicker to understand what it does.
--
Guillaume.
