Re: Track statistics for streaming of in-progress transactions - Mailing list pgsql-hackers

From Ajin Cherian
Subject Re: Track statistics for streaming of in-progress transactions
Date
Msg-id CAFPTHDYdsJ86S0Za+JFoN=U0Hw_m6qpLbHqkNnt8kZCsrz=-2A@mail.gmail.com
Whole thread Raw
In response to Track statistics for streaming of in-progress transactions  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Track statistics for streaming of in-progress transactions
List pgsql-hackers
On Wed, Oct 14, 2020 at 2:39 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> Commit 464824323e has added the support of the streaming of
> in-progress transactions into the built-in logical replication. The
> attached patch adds the statistics about transactions streamed to the
> decoding output plugin from ReorderBuffer. Users can query the
> pg_stat_replication_slots view to check these stats and call
> pg_stat_reset_replication_slot to reset the stats of a particular
> slot. Users can pass NULL in pg_stat_reset_replication_slot to reset
> stats of all the slots.
>
> Commit 9868167500 has added the basic infrastructure to capture the
> stats of slot and this commit extends the statistics collector to
> track additional information about slots.
>
> This patch was originally written by Ajin Cherian [1]. I have fixed
> bugs and modified some comments in the code.
>
> Thoughts?
>
> [1] - https://www.postgresql.org/message-id/CAFPTHDZ8RnOovefzB%2BOMoRxLSD404WRLqWBUHe6bWqM5ew1bNA%40mail.gmail.com

I've applied the patch. It applies cleanly. I've reviewed the patch
and have no comments to report.
I have also run some tests to get streaming stats as well as reset the
stats counter, everything seems to be working as expected.
I am fine with the changes.

regards,
Ajin Cherian
Fujitsu Australia



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Hash support for row types
Next
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: Transactions involving multiple postgres foreign servers, take 2