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
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
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