From 7e40cdc07585d5f93dd1f35ce1d402eba55e425b Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Tue, 19 Jan 2010 14:11:32 +0000 Subject: Add pg_stat_reset_shared('bgwriter') to reset the cluster-wide shared statistics of the bgwriter. Greg Smith --- doc/src/sgml/monitoring.sgml | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index f56fd214ae4..940b8b79ffe 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1,4 +1,4 @@ - + Monitoring Database Activity @@ -918,6 +918,17 @@ postgres: user database host + + + pg_stat_reset_shared(text) + void + + Reset some of the shared statistics counters for the database cluster to + zero (requires superuser privileges). Calling + pg_stat_reset_shared('bgwriter') will zero all the values shown by + pg_stat_bgwriter. + + -- cgit v1.2.3