View global avtovacuum settings code select name setting…

View global avtovacuum settings:

select name, setting, unit
from pg_settings 
where name like 'autovacuum%';

Show single table avtovacuum configuration

select relname, reloptions
from pg_class where reloptions::TEXT like '%autovacuum%';

Set vacuum and analyse scale factor and threshold for a table:

ALTER TABLE piblic.log SET (autovacuum_vacuum_scale_factor = 0.1);
ALTER TABLE piblic.log SET (autovacuum_vacuum_threshold = 1000000);
ALTER TABLE piblic.log SET (autovacuum_analyze_scale_factor = 0.1);
ALTER TABLE piblic.log SET (autovacuum_analyze_threshold = 1000000);