agora inbox for [email protected]
help / color / mirror / Atom feedFrom: Justin Pryzby <[email protected]>
Subject: [PATCH 5/7] Doc review for pg_stat_replication_slots: 986816750
Date: Sat, 19 Dec 2020 04:26:03 -0600
---
doc/src/sgml/monitoring.sgml | 29 ++++++++++++++---------------
1 file changed, 14 insertions(+), 15 deletions(-)
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index 243b437351..d26fb57ab6 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -317,7 +317,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser
<row>
<entry><structname>pg_stat_replication_slots</structname><indexterm><primary>pg_stat_replication_slots</primary></indexterm></entry>
<entry>One row per replication slot, showing statistics about
- replication slot usage.
+ the replication slot's usage.
See <link linkend="monitoring-pg-stat-replication-slots-view">
<structname>pg_stat_replication_slots</structname></link> for details.
</entry>
@@ -2600,10 +2600,10 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
<structfield>spill_txns</structfield> <type>bigint</type>
</para>
<para>
- Number of transactions spilled to disk after the memory used by
- logical decoding of changes from WAL for this slot exceeds
+ Number of transactions spilled to disk because the memory used by
+ logical decoding of changes from WAL for this slot exceeded
<literal>logical_decoding_work_mem</literal>. The counter gets
- incremented both for toplevel transactions and subtransactions.
+ incremented for both toplevel transactions and subtransactions.
</para></entry>
</row>
@@ -2613,8 +2613,8 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
</para>
<para>
Number of times transactions were spilled to disk while decoding changes
- from WAL for this slot. Transactions may get spilled repeatedly, and
- this counter gets incremented on every such invocation.
+ from WAL for this slot. A given transaction may be spilled multiple times, and
+ this counter is incremented each time.
</para></entry>
</row>
@@ -2636,10 +2636,10 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
</para>
<para>
Number of in-progress transactions streamed to the decoding output plugin
- after the memory used by logical decoding of changes from WAL for this
- slot exceeds <literal>logical_decoding_work_mem</literal>. Streaming only
+ because the memory used by logical decoding of changes from WAL for this
+ slot exceeded <literal>logical_decoding_work_mem</literal>. Streaming only
works with toplevel transactions (subtransactions can't be streamed
- independently), so the counter does not get incremented for subtransactions.
+ independently), so the counter is not incremented for subtransactions.
</para></entry>
</row>
@@ -2650,8 +2650,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
<para>
Number of times in-progress transactions were streamed to the decoding
output plugin while decoding changes from WAL for this slot. Transactions
- may get streamed repeatedly, and this counter gets incremented on every
- such invocation.
+ may be streamed multiple times, and this counter is incremented each time.
</para></entry>
</row>
@@ -4970,10 +4969,10 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
</para>
<para>
Resets statistics to zero for a single replication slot, or for all
- replication slots in the cluster. The argument can be either the name
- of the slot to reset the stats or NULL. If the argument is NULL, all
- counters shown in the <structname>pg_stat_replication_slots</structname>
- view for all replication slots are reset.
+ replication slots in the cluster. The argument can be either NULL or the name
+ of a slot for which stats are to be reset. If the argument is NULL, all
+ counters in the <structname>pg_stat_replication_slots</structname>
+ view are reset for all replication slots.
</para>
<para>
This function is restricted to superusers by default, but other users
--
2.17.0
--Pk6IbRAofICFmK5e
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment;
filename="0006-pg_restore-must-be-specified-and-list.patch"
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: [PATCH 5/7] Doc review for pg_stat_replication_slots: 986816750
In-Reply-To: <no-message-id-1863273@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox