Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)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