From: Alvaro Herrera <alvherre@commandprompt.com>
To: Stefano Nichele <stefano.nichele@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: tracking last_autovacuum
Date: Thu, 18 Dec 2008 10:07:30 -0300
Message-ID: <20081218130730.GC5447@alvh.no-ip.org> (raw)
In-Reply-To: <494A49CA.4050905@gmail.com>
References: <494A49CA.4050905@gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, stefano.nichele@gmail.com
Subject: Re: tracking last_autovacuum
In-Reply-To: <20081218130730.GC5447@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox