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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
