diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2011-11-25 12:10:46 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2011-11-25 16:34:32 -0300 |
| commit | 9d3b50244357ef4c4e3b6e01f91de599077179c8 (patch) | |
| tree | 520ed45e3952130a098589ed12f04abde06bd4c6 /src/include/miscadmin.h | |
| parent | 877b67c38b946dcbf70fe11736bdde841e4c826b (diff) | |
| download | postgresql-9d3b50244357ef4c4e3b6e01f91de599077179c8.tar.gz | |
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
Diffstat (limited to 'src/include/miscadmin.h')
| -rw-r--r-- | src/include/miscadmin.h | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/include/miscadmin.h b/src/include/miscadmin.h index 9d194171a5..4ee08fead6 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; |