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

[Pavan Deolasee]

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...
  |
  |
(939 rows)

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



It means auto vacuum/analyze did not trigger on any of the
tables. You may want to try:

SELECT name, setting from pg_settings where name like  '%autovacuum%';

to get the settings of autovacuum and check if autovacuum is turned on or
not.

Thanks,
Pavan

--

EnterpriseDB http://www.enterprisedb.com

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

[Shoaib Mir]

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 ANALYZE manually and see if that gets
updated in the last_vacuum of pg_stats_all_tables.

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/13/07, Walter Vaughan [EMAIL PROTECTED] wrote:


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

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

[Sic Transit Gloria Mundi]

Hi,

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 that in the system catalog.

Thanks!


 
-
Need Mail bonding?
Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users.

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

[Tom Lane]

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 that in the system catalog.

Try the pg_stat views.

regards, tom lane

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

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

[Shoaib Mir]

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 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 that in the system catalog.

Thanks!

--
Need Mail bonding?
Go to the Yahoo! Mail 
QAhttp://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=asksid=396546091for
 great
tips from Yahoo! 
Answershttp://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=asksid=396546091users.

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