Re: Resetting spilled txn statistics in pg_stat_replication - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Resetting spilled txn statistics in pg_stat_replication
Date
Msg-id CAA4eK1+F5yRdE0WwMPf5y4Pb2jKWbxRXvHokf=8P=rvw_LNb9w@mail.gmail.com
Whole thread Raw
In response to Re: Resetting spilled txn statistics in pg_stat_replication  (Masahiko Sawada <masahiko.sawada@2ndquadrant.com>)
Responses Re: Resetting spilled txn statistics in pg_stat_replication
Re: Resetting spilled txn statistics in pg_stat_replication
List pgsql-hackers
On Tue, Oct 13, 2020 at 4:54 AM Masahiko Sawada
<masahiko.sawada@2ndquadrant.com> wrote:
>
> Attached the updated version patch. Please review it.
>

I have pushed this but it failed in one of the BF. See
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=florican&dt=2020-10-13%2003%3A07%3A25

The failure is shown below and I am analyzing it. See, if you can
provide any insights.

@@ -58,7 +58,7 @@
 SELECT name, spill_txns, spill_count FROM pg_stat_replication_slots;
       name       | spill_txns | spill_count
 -----------------+------------+-------------
- regression_slot |          1 |          12
+ regression_slot |          1 |          10
 (1 row)

 -- reset the slot stats, and wait for stats collector to reset
@@ -96,7 +96,7 @@
 SELECT name, spill_txns, spill_count FROM pg_stat_replication_slots;
       name       | spill_txns | spill_count
 -----------------+------------+-------------
- regression_slot |          1 |          12
+ regression_slot |          1 |          10
 (1 row)



-- 
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Masahiro Ikeda
Date:
Subject: Re: New statistics for tuning WAL buffer size
Next
From: Amit Kapila
Date:
Subject: Re: Resetting spilled txn statistics in pg_stat_replication