Date: Thu, 18 Dec 2008 10:07:30 -0300
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Stefano Nichele <stefano.nichele@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: tracking last_autovacuum
Message-ID: <20081218130730.GC5447@alvh.no-ip.org>
References: <494A49CA.4050905@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <494A49CA.4050905@gmail.com>
User-Agent: Mutt/1.5.18 (2008-05-17)

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.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.