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

tracking last_autovacuum

From: Stefano Nichele <stefano(dot)nichele(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: tracking last_autovacuum
Date: 2008-12-18 13:02:02
Message-ID: 494A49CA.4050905@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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) ?

Cheers,
ste




Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2008-12-18 13:07:30
Subject: Re: tracking last_autovacuum
Previous:From: Alvaro HerreraDate: 2008-12-18 12:59:35
Subject: Re: DROP INDEX causes errors

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