From c9028b18da2668e7fbd8da08b2b4f0a57ec419fa Mon Sep 17 00:00:00 2001 From: Sirisha Chamarthi 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 pg_stat_recovery_prefetchpg_stat_recovery_prefetch Only one row, showing statistics about blocks prefetched during recovery. - See for details. + See + pg_stat_recovery_prefetch for details. @@ -2977,18 +2978,20 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i - - <structname>pg_stat_subscription</structname> + + <structname>pg_stat_recovery_prefetch</structname> - pg_stat_subscription + pg_stat_recovery_prefetch - The pg_stat_subscription 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 pg_stat_recovery_prefetch view will contain + only one row. The columns wal_distance, + block_distance and + io_depth show current values, and the + other columns show cumulative counters that can be reset + with the pg_stat_reset_shared function. @@ -3052,14 +3055,14 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
- - The pg_stat_recovery_prefetch view will contain - only one row. The columns wal_distance, - block_distance and - io_depth show current values, and the - other columns show cumulative counters that can be reset - with the pg_stat_reset_shared function. - +
+ + + <structname>pg_stat_subscription</structname> + + + pg_stat_subscription + <structname>pg_stat_subscription</structname> View -- 2.35.1.windows.2