Thread: autovacuum log?

Vacuum only writes normal operations messages to the logs if you have
log_min_messages set to DEBUG2 or DEBUG3 (with DEBUG3 giving more
output).  I'm not sure what query stats are kept for autovacuum
activities in 8.3, but in versions <= 8.2.x you can run the following
query to see what autovacuum is currently doing:

SELECT current_query
FROM pg_stat_activity
WHERE query_start IS NULL;

This works because autovacuum vacuum queries started by autovacuum
apparently don't have their start time (or client_addr) noted.

On Dec 13, 2007, at 8:00 AM, MG wrote:

> Hello,
>
> when I put the autovacuum on, where can I check what it does? Is
> there any log-file?
>
> Regards
> Michaela
>
>

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com