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

[Walter Vaughan]

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly