Improve logging of autovacuum I/O activity
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 25 Nov 2011 15:10:46 +0000 (12:10 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 25 Nov 2011 19:34:32 +0000 (16:34 -0300)
commit9d3b50244357ef4c4e3b6e01f91de599077179c8
tree520ed45e3952130a098589ed12f04abde06bd4c6
parent877b67c38b946dcbf70fe11736bdde841e4c826b
Improve logging of autovacuum I/O activity

This adds some I/O stats to the logging of autovacuum (when the
operation takes long enough that log_autovacuum_min_duration causes it
to be logged), so that it is easier to tune.  Notably, it adds buffer
I/O counts (hits, misses, dirtied) and read and write rate.

Authors: Greg Smith and Noah Misch
src/backend/commands/vacuum.c
src/backend/commands/vacuumlazy.c
src/backend/storage/buffer/bufmgr.c
src/backend/utils/init/globals.c
src/include/miscadmin.h