Re: infinite loop in an update statement

[Greg Sabino Mullane <htamfids@xxxxxxxxx>]

On Wed, Sep 11, 2024 at 6:14 AM Fabrice Chapuis <fabrice636861@xxxxxxxxx> wrote:

status = active

wait event = NULL

wait event type = NULL

That seems quite unlikely. Perhaps you are seeing the pg_stat_activity query itself? Try this:

select state, now()-state_change, wait_event_type, wait_event, query

from pg_stat_activity where query ~ 'SELECT MIN' and pg_backend_pid() <> pid;

Cheers,

Greg