Re: [GENERAL] Logging of autovacuum activity

2008-04-01 Thread Ben
select schemaname,relname,last_autovacuum,last_autoanalyze from pg_stat_user_tables; ...should get you what you're after. On Tue, 1 Apr 2008, Markus Wollny wrote: Hi, I am a bit stuck finding out how to log autovacuum activity in PostgreSQL 8.2. In the olden times I used to pipe the pg_auto

Re: [GENERAL] Logging of autovacuum activity

2008-04-01 Thread Simon Riggs
On Tue, 2008-04-01 at 21:02 +0200, Markus Wollny wrote: > I am a bit stuck finding out how to log autovacuum activity in > PostgreSQL 8.2. In the olden times I used to pipe the pg_autovacuum > daemon's output to a file. Now pg_autovacuum has become part of the > core, I wonder if there's some othe

[GENERAL] Logging of autovacuum activity

2008-04-01 Thread Markus Wollny
Hi, I am a bit stuck finding out how to log autovacuum activity in PostgreSQL 8.2. In the olden times I used to pipe the pg_autovacuum daemon's output to a file. Now pg_autovacuum has become part of the core, I wonder if there's some other possibility of monitoring its activity? I've got the f