> > We haven't isolated *which* table it is blocked on (assuming it is), > but all autovac's cease running until we manually intervene. > > When we get into this state again, is there some other information > (other than what is in pg_stat_statement or pg_stat_activity) that > would be useful for folks here to help understand what is going on?
https://www.postgresql.org/docs/current/progress-reporting.html#VACUUM-PROGRESS-REPORTING