From b736aef2ec57b520ebadb70cceac0fed3168a5df Mon Sep 17 00:00:00 2001
From: Robert Haas <rhaas@postgresql.org>
Date: Thu, 5 Apr 2012 14:03:21 -0400
Subject: Publish checkpoint timing information to pg_stat_bgwriter.

Greg Smith, Peter Geoghegan, and Robert Haas
---
 doc/src/sgml/monitoring.sgml | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

(limited to 'doc/src')

diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index ed8aeb20c60..423f9b1a9a0 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -767,6 +767,28 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
      This value can also be returned by directly calling
      the <function>pg_stat_get_bgwriter_requested_checkpoints</function> function.</entry>
      </row>
+     <row>
+      <entry>checkpoint_write_time</entry>
+      <entry><type>bigint</type></entry>
+      <entry>
+        Total amount of time that has been spent in the portion of
+        checkpoint processing where files are written to disk, in milliseconds.
+        This value can also be returned by directly calling the
+        <function>pg_stat_get_checkpoint_write_time</function>
+        function.
+      </entry>
+     </row>
+     <row>
+      <entry>checkpoint_sync_time</entry>
+      <entry><type>bigint</type></entry>
+      <entry>
+        Total amount of time that has been spent in the portion of
+        checkpoint processing where files are synchronized to disk, in
+        milliseconds.  This value can also be returned by directly calling
+        the <function>pg_stat_get_checkpoint_sync_time</function>
+        function.
+      </entry>
+     </row>
      <row>
       <entry>buffers_checkpoint</entry>
       <entry><type>bigint</type></entry>
-- 
cgit v1.2.3