Make sure you have stats collector enabled, if auto vacuum is doing the
analyze and vacuum it should be recording that info in this view. For
details on this you can have a look at -->
http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html
Just for a test try doing a VACUUM or ANALY
On 2/13/07, Walter Vaughan <[EMAIL PROTECTED]> wrote:
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
last_autovacuum | last_autoanalyze
-+--
|
...snip lots of identically blank lines...
|
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 lot
pg_stat_all_table view should help you:
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/9/07, Sic Transit Gloria Mundi <[EMAIL PROTECTED]> wrote:
Hi,
I couldnt find this on google, the archives, or the manual. But wit
Sic Transit Gloria Mundi <[EMAIL PROTECTED]> writes:
> I couldnt find this on google, the archives, or the manual. But with the
> changes to what the autovacuum daemon logs, how can we verify it's doing its
> thing? Is there a way to query the last time a table was vacuumed? But I
> don't see
