Re: Pg stuck at 100% cpu, for multiple days

On Mon, 2021-08-30 at 17:18 +0200, hubert depesz lubaczewski wrote:
> The thing is - I can't close it with pg_terminate_backend(), and I'd
> rather not kill -9, as it will, I think, close all other connections,
> and this is prod server.

Of course the cause should be fixed, but to serve your immediate need:

After calling pg_terminate_backend(), you can attach gdb to the backend and then run

  print ProcessInterrupts()

That will cause the backend to exit normally without crashing the server.

Yours,
Laurenz Albe