diff options
Diffstat (limited to 'doc/src/sgml/monitoring.sgml')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 77 |
1 files changed, 76 insertions, 1 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 6e57a83df88..58ec5d3fc42 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.47 2007/03/16 17:57:35 mha Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.48 2007/03/30 18:34:55 mha Exp $ --> <chapter id="monitoring"> <title>Monitoring Database Activity</title> @@ -261,6 +261,16 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re </row> <row> + <entry><structname>pg_stat_bgwriter</></entry> + <entry>One row only, showing cluster-wide statistics from the + background writer: number of scheduled checkpoints, requested + checkpoints, buffers written by checkpoints, lru-scans and all-scans, + and the number of times the bgwriter aborted a round because it had + written too many buffers during lru-scans and all-scans. + </entry> + </row> + + <row> <entry><structname>pg_stat_database</></entry> <entry>One row per database, showing database OID, database name, number of active server processes connected to that database, @@ -752,6 +762,71 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re </row> <row> + <entry><literal><function>pg_stat_get_bgwriter_timed_checkpoints</function>()</literal></entry> + <entry><type>bigint</type></entry> + <entry> + The number of times the bgwriter has started timed checkpoints + (because the <varname>checkpoint_timeout</varname> time has expired). + </entry> + </row> + + <row> + <entry><literal><function>pg_stat_get_bgwriter_requested_checkpoints</function>()</literal></entry> + <entry><type>bigint</type></entry> + <entry> + The number of times the bgwriter has started checkpoints based on + requests from backends because the <varname>checkpoint_segments</varname> + has been exceeded or because the CHECKPOINT command has been issued. + </entry> + </row> + + <row> + <entry><literal><function>pg_stat_get_bgwriter_buf_written_checkpoints</function>()</literal></entry> + <entry><type>bigint</type></entry> + <entry> + The number of buffers written by the bgwriter during checkpoints. + </entry> + </row> + + <row> + <entry><literal><function>pg_stat_get_bgwriter_buf_written_lru</function>()</literal></entry> + <entry><type>bigint</type></entry> + <entry> + The number of buffers written by the bgwriter when performing a + LRU scan of the buffer cache. + </entry> + </row> + + <row> + <entry><literal><function>pg_stat_get_bgwriter_buf_written_all</function>()</literal></entry> + <entry><type>bigint</type></entry> + <entry> + The number of buffers written by the bgwriter when performing a + scan of all the buffer cache. + </entry> + </row> + + <row> + <entry><literal><function>pg_stat_get_bgwriter_maxwritten_lru</function>()</literal></entry> + <entry><type>bigint</type></entry> + <entry> + The number of times the bgwriter has stopped its LRU round because + it has written more buffers than specified in the + <varname>bgwriter_lru_maxpages</varname> parameter. + </entry> + </row> + + <row> + <entry><literal><function>pg_stat_get_bgwriter_maxwritten_all</function>()</literal></entry> + <entry><type>bigint</type></entry> + <entry> + The number of times the bgwriter has stopped its all-buffer round + because it has written more buffers than specified in the + <varname>bgwriter_all_maxpages</varname> parameter. + </entry> + </row> + + <row> <entry><literal><function>pg_stat_clear_snapshot</function>()</literal></entry> <entry><type>void</type></entry> <entry> |