Postgres Pro
Downloads
Home   >   mailing lists

autovacuum run but last_autovacuum is empty - Mailing list pgsql-performance

From Mariel Cherkassky
Subject autovacuum run but last_autovacuum is empty
Date
Msg-id CA+t6e1nKAhrZ6BC7x6pP+bdZiNDx7x3M_cgye9HWbFF0AAqa3A@mail.gmail.com
Whole thread Raw
Responses Re: autovacuum run but last_autovacuum is empty  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
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 ?

pgsql-performance by date:

Previous
From: Viswanath
Date:
Subject: Optimizer choosing the wrong plan
Next
From: Tom Lane
Date:
Subject: Re: autovacuum run but last_autovacuum is empty