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 AANLkTik3ewpTTx5XkB6o4PC5zaUKrsMtFix-FvFrjkqi@mail.gmail.com
Whole thread Raw
In response to 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 am sorry for the multiple posts; just noticed there are two tests
for analyze:  last_analyze and last_autoanalyze

last_autoanalyze matches last_autovacuum -  7 weeks ago

Aleksey

pgsql-general by date:

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