Re: Replication slot stats misgivings
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: vignesh C <vignesh21@gmail.com>, Andres Freund <andres@anarazel.de>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Date: 2021-04-12T12:36:39Z
Lists: pgsql-hackers
On Mon, Apr 12, 2021 at 5:29 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote: > > On Mon, Apr 12, 2021 at 8:08 PM Amit Kapila <amit.kapila16@gmail.com> wrote: > > > > On Mon, Apr 12, 2021 at 4:34 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote: > > > > > > On Mon, Apr 12, 2021 at 6:19 PM Amit Kapila <amit.kapila16@gmail.com> wrote: > > > > > > > > On Mon, Apr 12, 2021 at 10:27 AM Masahiko Sawada <sawada.mshk@gmail.com> wrote: > > > > > > > > > > On Sat, Apr 10, 2021 at 9:53 PM Amit Kapila <amit.kapila16@gmail.com> wrote: > > > > > > > > > > > > > > > > > > It seems Vignesh has changed patches based on the latest set of > > > > > > comments so you might want to rebase. > > > > > > > > > > I've merged my patch into the v6 patch set Vignesh submitted. > > > > > > > > > > I've attached the updated version of the patches. I didn't change > > > > > anything in the patch that changes char[NAMEDATALEN] to NameData (0001 > > > > > patch) and patches that add tests. > > > > > > > > > > > > > I think we can push 0001. What do you think? > > > > > > +1 > > > > > > > > > > > > In 0003 patch I reordered the > > > > > output parameters of pg_stat_replication_slots; showing total number > > > > > of transactions and total bytes followed by statistics for spilled and > > > > > streamed transactions seems appropriate to me. > > > > > > > > > > > > > I am not sure about this because I think we might want to add some > > > > info of stream/spill bytes in total_bytes description (something like > > > > stream/spill bytes are not in addition to total_bytes). > > BTW doesn't it confuse users that stream/spill bytes are not in > addition to total_bytes? User will need to do "total_bytes + > spill/stream_bytes" to know the actual total amount of data sent to > the decoding output plugin, is that right? > No, total_bytes includes the spill/stream bytes. So, the user doesn't need to do any calculation to compute totel_bytes sent to output plugin. -- With Regards, Amit Kapila.
Commits
-
Doc: Update logical decoding stats information.
- 0c6b92d9c6fb 14.0 landed
-
Fix tests for replication slots stats.
- fc69509131c3 14.0 landed
-
Update replication statistics after every stream/spill.
- 592f00f8dec6 14.0 landed
-
Fix the computation of slot stats for 'total_bytes'.
- 205f466282be 14.0 landed
-
Another try to fix the test case added by commit f5fc2f5b23.
- 51ef9173030c 14.0 landed
-
Use HTAB for replication slot statistics.
- 3fa17d37716f 14.0 landed
-
Fix test case added by commit f5fc2f5b23.
- c64dcc7fee5f 14.0 landed
-
Add information of total data processed to replication slot stats.
- f5fc2f5b23d1 14.0 landed
-
Use NameData datatype for slotname in stats.
- cca57c1d9bf7 14.0 landed