Re: autovacuum run but last_autovacuum is empty

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autovacuum run but last_autovacuum is empty
Дата
Msg-id 28510.1543245899@sss.pgh.pa.us
обсуждение исходный текст
Ответ на autovacuum run but last_autovacuum is empty  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Ответы Re: autovacuum run but last_autovacuum is empty  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-performance
Mariel Cherkassky <mariel.cherkassky@gmail.com> writes:
> I checked pg_stat_all_tables and I see that the last_autovacuum is empty
> for all the tables but in the database`s log I see that autovacuum was
> running and deleted records(not all of them but still deleted...).
> Can someone explain why the pg_stat_all_tables doesnt show the real data ?

Hm, are you sure the stats collector is working at all?  Are other fields
in the pg_stat data updating?

(If not, you may have a problem with firewall rules blocking traffic
on the stats loopback port.)

            regards, tom lane


В списке pgsql-performance по дате отправления:

Предыдущее
От: Mariel Cherkassky
Дата:
Сообщение: autovacuum run but last_autovacuum is empty
Следующее
От: Jakub Glapa
Дата:
Сообщение: Re: dsa_allocate() faliure