From 9e0f87a4955ede0769d2f9a93171145b6ddab901 Mon Sep 17 00:00:00 2001 From: Amit Kapila Date: Wed, 28 Oct 2020 07:28:51 +0530 Subject: [PATCH] Minor improvements in description of spilled counters in pg_stat_replication_slots view. Per a suggestion by Justin Pryzby. Discussion: https://postgr.es/m/CA+fd4k5_pPAYRTDrO2PbtTOe0eHQpBvuqmCr8ic39uTNmR49Eg@mail.gmail.com --- doc/src/sgml/monitoring.sgml | 11 +++++------ 1 file changed, 5 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index aeb694d4a8..313e44ed54 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -2614,10 +2614,9 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i spill_count bigint - Number of times transactions were spilled to disk while performing - decoding of changes from WAL for this slot. Transactions - may get spilled repeatedly, and this counter gets incremented on every - such invocation. + 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. @@ -2628,8 +2627,8 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i Amount of decoded transaction data spilled to disk while performing decoding of changes from WAL for this slot. This and other spill - counters can be used to gauge the I/O occurred during logical decoding - and accordingly can tune logical_decoding_work_mem. + counters can be used to gauge the I/O which occurred during logical + decoding and allow tuning logical_decoding_work_mem. -- 2.39.5