diff options
| author | Magnus Hagander <magnus@hagander.net> | 2010-01-19 14:11:32 +0000 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2010-01-19 14:11:32 +0000 |
| commit | 7e40cdc07585d5f93dd1f35ce1d402eba55e425b (patch) | |
| tree | 08fff74f07840a934a001bd12bdba8140663da05 /doc/src | |
| parent | 4f15699d706130540f7cf1ed4f995b61cf50b09c (diff) | |
| download | postgresql-7e40cdc07585d5f93dd1f35ce1d402eba55e425b.tar.gz postgresql-7e40cdc07585d5f93dd1f35ce1d402eba55e425b.zip | |
Add pg_stat_reset_shared('bgwriter') to reset the cluster-wide shared
statistics of the bgwriter.
Greg Smith
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 13 |
1 files changed, 12 insertions, 1 deletions
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 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.73 2009/11/29 18:14:30 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.74 2010/01/19 14:11:30 mha Exp $ --> <chapter id="monitoring"> <title>Monitoring Database Activity</title> @@ -918,6 +918,17 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re (requires superuser privileges) </entry> </row> + + <row> + <entry><literal><function>pg_stat_reset_shared</function>(text)</literal></entry> + <entry><type>void</type></entry> + <entry> + Reset some of the shared statistics counters for the database cluster to + zero (requires superuser privileges). Calling + <literal>pg_stat_reset_shared('bgwriter')</> will zero all the values shown by + <structname>pg_stat_bgwriter</>. + </entry> + </row> </tbody> </tgroup> </table> |