Postgres Pro
Downloads
Home   >   mailing lists

Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them? - Mailing list pgsql-general

From Aleksey Tsalolikhin
Subject Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?
Date
Msg-id AANLkTikV-4f5E6lSP5M5hJ2M6-ABxMm5XQ7brQb78I16@mail.gmail.com
Whole thread Raw
In response to check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
Responses Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
List pgsql-general
Tree view 
I just ran the "last_autovacuum" test of check_postgres, and it reported

7 (of my 100) tables have been autovacuumed more than 1 day ago;
the oldest autovacuum time was 7 weeks ago.

8 more tables in pg_catalog were autovacuumed more than 1 day ago.

Thanks,
-at

pgsql-general by date:

Previous
From: Aleksey Tsalolikhin
Date:
Subject: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?
Next
From: Aleksey Tsalolikhin
Date:
Subject: Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?