Skip site navigation (1) Skip section navigation (2)

Re: tracking last_autovacuum

From: Stefano Nichele <stefano(dot)nichele(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: tracking last_autovacuum
Date: 2008-12-18 13:13:41
Message-ID: 494A4C85.9090700@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Yes, i could do that but it seems simpler (to me) with a trigger than 
looking at the recent changes records and store them somewhere.

ste

Alvaro Herrera wrote:
> Stefano Nichele escribió:
>   
>> Hi All,
>> in  pg_stat_all_tables, the fields last_autovacuum, last_autoanalyze are  
>> updated any time autovacuum vacuums a table.
>> I would like to keep an history of these activities in order to see when  
>> and how many times any single table is vacuumed.
>>
>> Is there any features that can help me ? (I'm using postgres 8.2.9)
>>
>> What about creating a trigger on pg_stat_all_tables and storing the  
>> required info in another table (like autovacuum_history) ?
>>     
>
> I guess you could run a query once every autovacuum_naptime and have it
> save aside all those entries from pg_stat_all_tables that have recent
> dates into a history table.
>
>   



In response to

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2008-12-18 13:16:55
Subject: Re: tracking last_autovacuum
Previous:From: Alvaro HerreraDate: 2008-12-18 13:07:30
Subject: Re: tracking last_autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group