Re: infinite loop in an update statement

On Wed, Sep 11, 2024 at 6:14 AM Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
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