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’;
[Postgres] Monitor autovacuum_freeze_max_age
Commentaires
Une réponse à “[Postgres] Monitor autovacuum_freeze_max_age”
-
Hi, this is a comment.
To get started with moderating, editing, and deleting comments, please visit the Comments screen in the dashboard.
Commenter avatars come from Gravatar.
Laisser un commentaire