From 9d3b50244357ef4c4e3b6e01f91de599077179c8 Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Fri, 25 Nov 2011 12:10:46 -0300 Subject: 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/include/miscadmin.h | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'src/include') diff --git a/src/include/miscadmin.h b/src/include/miscadmin.h index 9d194171a56..4ee08fead6f 100644 --- a/src/include/miscadmin.h +++ b/src/include/miscadmin.h @@ -230,6 +230,10 @@ extern int VacuumCostPageDirty; extern int VacuumCostLimit; extern int VacuumCostDelay; +extern int VacuumPageHit; +extern int VacuumPageMiss; +extern int VacuumPageDirty; + extern int VacuumCostBalance; extern bool VacuumCostActive; -- cgit v1.2.3