0001-Fix-documentation-bug-for-pg_stat_recovery_prefetch.patch
application/octet-stream
Filename: 0001-Fix-documentation-bug-for-pg_stat_recovery_prefetch.patch
Type: application/octet-stream
Part: 0
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch 0001
Subject: Fix documentation bug for pg_stat_recovery_prefetch
| File | + | − |
|---|---|---|
| doc/src/sgml/monitoring.sgml | 19 | 16 |
From c9028b18da2668e7fbd8da08b2b4f0a57ec419fa Mon Sep 17 00:00:00 2001
From: Sirisha Chamarthi <sirichamarthi22@gmail.com>
Date: Mon, 11 Apr 2022 13:02:35 -0700
Subject: [PATCH] Fix documentation bug for pg_stat_recovery_prefetch
---
doc/src/sgml/monitoring.sgml | 35 +++++++++++++++++++----------------
1 file changed, 19 insertions(+), 16 deletions(-)
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index 87b6e5fb5e..42ef9fa053 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -336,7 +336,8 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser
<row>
<entry><structname>pg_stat_recovery_prefetch</structname><indexterm><primary>pg_stat_recovery_prefetch</primary></indexterm></entry>
<entry>Only one row, showing statistics about blocks prefetched during recovery.
- See <xref linkend="pg-stat-recovery-prefetch-view"/> for details.
+ See <link linkend="monitoring-pg-stat-recovery-prefetch">
+ <structname>pg_stat_recovery_prefetch</structname></link> for details.
</entry>
</row>
@@ -2977,18 +2978,20 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
</sect2>
- <sect2 id="monitoring-pg-stat-subscription">
- <title><structname>pg_stat_subscription</structname></title>
+ <sect2 id="monitoring-pg-stat-recovery-prefetch">
+ <title><structname>pg_stat_recovery_prefetch</structname></title>
<indexterm>
- <primary>pg_stat_subscription</primary>
+ <primary>pg_stat_recovery_prefetch</primary>
</indexterm>
<para>
- The <structname>pg_stat_subscription</structname> view will contain one
- row per subscription for main worker (with null PID if the worker is
- not running), and additional rows for workers handling the initial data
- copy of the subscribed tables.
+ The <structname>pg_stat_recovery_prefetch</structname> view will contain
+ only one row. The columns <structfield>wal_distance</structfield>,
+ <structfield>block_distance</structfield> and
+ <structfield>io_depth</structfield> show current values, and the
+ other columns show cumulative counters that can be reset
+ with the <function>pg_stat_reset_shared</function> function.
</para>
<table id="pg-stat-recovery-prefetch-view" xreflabel="pg_stat_recovery_prefetch">
@@ -3052,14 +3055,14 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
</tgroup>
</table>
- <para>
- The <structname>pg_stat_recovery_prefetch</structname> view will contain
- only one row. The columns <structfield>wal_distance</structfield>,
- <structfield>block_distance</structfield> and
- <structfield>io_depth</structfield> show current values, and the
- other columns show cumulative counters that can be reset
- with the <function>pg_stat_reset_shared</function> function.
- </para>
+ </sect2>
+
+ <sect2 id="monitoring-pg-stat-subscription">
+ <title><structname>pg_stat_subscription</structname></title>
+
+ <indexterm>
+ <primary>pg_stat_subscription</primary>
+ </indexterm>
<table id="pg-stat-subscription" xreflabel="pg_stat_subscription">
<title><structname>pg_stat_subscription</structname> View</title>
--
2.35.1.windows.2