diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 8287587..fe07f6f 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -340,7 +340,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser pg_stat_prefetch_recoverypg_stat_prefetch_recovery Only one row, showing statistics about blocks prefetched during recovery. - See for details. + See for details. @@ -2910,21 +2910,25 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i - - <structname>pg_stat_subscription</structname> + + <structname>pg_stat_prefetch_recovery</structname> - pg_stat_subscription + pg_stat_prefetch_recovery - 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_prefetch_recovery view will contain only + one row. It is filled with nulls if recovery is not running or WAL + prefetching is not enabled. See + for more information. The counters in this view are reset whenever the + , + or + setting is changed and + the server configuration is reloaded. - +
<structname>pg_stat_prefetch_recovery</structname> View @@ -2984,16 +2988,20 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
+
+ + + <structname>pg_stat_subscription</structname> + + + pg_stat_subscription + - The pg_stat_prefetch_recovery view will contain only - one row. It is filled with nulls if recovery is not running or WAL - prefetching is not enabled. See - for more information. The counters in this view are reset whenever the - , - or - setting is changed and - the server configuration is reloaded. + 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.