Thread: BUG #4020: RFE: have way to log autovacuum activity

The following bug has been logged online:

Bug reference:      4020
Logged by:          Joseph S
Email address:      jks@selectacast.net
PostgreSQL version: 8.2.5
Operating system:   CentOS 5
Description:        RFE: have way to log autovacuum activity
Details:

When autovacuum decides to vacuum one of our large tables, the whole site
slows down, but it is not always obvious why.  It would be nice if there was
an option to log autovacuum activity so I know how often a vacuum runs and
how long it takes.

Joseph S wrote:

> When autovacuum decides to vacuum one of our large tables, the whole site
> slows down, but it is not always obvious why.  It would be nice if there was
> an option to log autovacuum activity so I know how often a vacuum runs and
> how long it takes.

Yeah, we have a configurable autovacuum log on 8.3.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Alvaro Herrera wrote:

> Yeah, we have a configurable autovacuum log on 8.3.
>
Sorry, I looked but didn't see it.

Joseph S wrote:
> Alvaro Herrera wrote:
>
>> Yeah, we have a configurable autovacuum log on 8.3.
>>
> Sorry, I looked but didn't see it.

#log_autovacuum_min_duration = -1   # -1 disables, 0 logs all actions and
                    # their durations, > 0 logs only
                    # actions running at least that time.

We don't log "start of action" though ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.