Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x

Shoaib Mir wrote:

> pg_stat_all_table view should help you:
>
> select last_autovacuum, last_autoanalyze from pg_stat_all_tables;

select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
last_autovacuum | last_autoanalyze
-----------------+------------------
|
...snip lots of identically blank lines...
|
|
(939 rows)

Does that mean it's working or not configured right?

Thanks,
Walter