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’;
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
Δ
Please enable JavaScript in your browser to view the content
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’;
Josselin Joly