Logging of autovacuum activity
От | Markus Wollny |
---|---|
Тема | Logging of autovacuum activity |
Дата | |
Msg-id | 28011CD60FB1724DBA4442E38277F62608ACB295@hermes.computec.de обсуждение исходный текст |
Ответы |
Re: Logging of autovacuum activity
Re: Logging of autovacuum activity |
Список | pgsql-general |
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_autovacuumdaemon's output to a file. Now pg_autovacuum has become part of the core, I wonder if there's some other possibilityof monitoring its activity? I've got the following logging-settings set: client_min_messages = error log_min_messages = notice log_error_verbosity = default log_min_error_statement = notice log_min_duration_statement = -1 log_line_prefix = '<%t - %p: %r@%d>' Everything else is commented out, i.e. set to defaults. There is however nothing to be found in the logs concerning autovacuumor any standard vacuum at all. I couldn't find anything in the docs regarding the specific logging of vacuum runs.For my nightly vacuum maintenance job, I simply pipe sterr of vacuum verbose analyze to a separate logfile. Concerningautovacuum, I'd like to have some info on when it runs and which tables it has processed. It is running for sure,I can often see the autovacuum process pop up in top. I only see no means of finding out what it actually does whenit's running. Kind regards Markus Computec Media AG Sitz der Gesellschaft und Registergericht: Fürth (HRB 8818) Vorstandsmitglieder: Johannes S. Gözalan (Vorsitzender) und Rainer Rosenbusch Vorsitzender des Aufsichtsrates: Jürg Marquard Umsatzsteuer-Identifikationsnummer: DE 812 575 276
В списке pgsql-general по дате отправления: