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 <b...@yugabyte.com> a écrit : > > > > > > > > > > > > > > > > > > *-- No errordo $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(); As it is less code, it's quicker to understand what it does. -- Guillaume.
