Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I tell if I'm autovacuuming? - Mailing list pgsql-admin

From Ireneusz Pluta
Subject Re: How can I tell if I'm autovacuuming?
Date
Msg-id 4BFBC336.1010709@wp.pl
Whole thread Raw
In response to Re: How can I tell if I'm autovacuuming?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Tree view 
>> (b) How can I verify that my databases are being vacuumed by autovacuum?
>>
>
> pg_stat_user_tables should have a last_autovac column.
>
Also, you can see autovacuum related messages like:

DEBUG:  autovacuum: processing database "postgres"
DEBUG:  autovacuum: processing database "template1"

in your server log, by setting log_min_messages to 'debug1' in your
postgresql.conf.
As a side effect you may also see some other messages enabled with the
same debug level,

pgsql-admin by date:

Previous
From: Khangelani Gama
Date:
Subject: Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3
Next
From: Ian Lea
Date:
Subject: Re: Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3