autovacuum run but last_autovacuum is empty

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org>
Subject: autovacuum run but last_autovacuum is empty
Date: 2018-11-26 15:12:02
Message-ID: CA+t6e1nKAhrZ6BC7x6pP+bdZiNDx7x3M_cgye9HWbFF0AAqa3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,
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 ?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2018-11-26 15:24:59 Re: autovacuum run but last_autovacuum is empty
Previous Message Viswanath 2018-11-26 10:11:18 Optimizer choosing the wrong plan