This query allows you to monitor the : autovacuum_freeze_max_age
SELECT datname, round(age(datfrozenxid)/to_number(current_setting(‘autovacuum_freeze_max_age’),’999999999′)*100,1) as Percent FROM pg_database where datname != ‘template0’;
« Maîtrisez vos idées, optimisez vos bases.»
Laisser un commentaire