How can I tell if PostgreSQL’s Autovacuum is running on UNIX?
PostgreSQL 9.3 Determine if Autovacuum is Running This is specific to Postgres 9.3 on UNIX. For Windows, see this question. Query Postgres System Table SELECT schemaname, relname, last_vacuum, last_autovacuum, vacuum_count, autovacuum_count — not available on 9.0 and earlier FROM pg_stat_user_tables; Grep System Process Status $ ps -axww | grep autovacuum 24352 ?? Ss 1:05.33 postgres: … Read more