Re: infinite loop in an update statement

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