autovacuum

Settings for a specific table

 SELECT relname, reloptions FROM pg_class WHERE relname='table_name';

ALTER TABLE table_name SET (autovacuum_enabled = on);
ALTER TABLE table_name SET (autovacuum_vacuum_scale_factor = 0, autovacuum_vacuum_threshold = 50);

reset

ALTER TABLE table_name reset (autovacuum_enabled,autovacuum_vacuum_scale_factor,autovacuum_vacuum_threshold);

select relname, n_live_tup, n_dead_tup,n_tup_ins,n_tup_upd,last_autovacuum,last_autoanalyze from pg_stat_all_tables where relname like 'call_project_%';