Re: Logging of autovacuum activity
От | Ben |
---|---|
Тема | Re: Logging of autovacuum activity |
Дата | |
Msg-id | Pine.LNX.4.64.0804011217210.18595@localhost.localdomain обсуждение исходный текст |
Ответ на | Logging of autovacuum activity ("Markus Wollny" <Markus.Wollny@computec.de>) |
Список | pgsql-general |
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_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 > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
В списке pgsql-general по дате отправления: