Re: pgsql: Add mem_exceeded_count column to pg_stat_replication_slots.

On Wed, Oct 29, 2025 at 1:52 AM Bertrand Drouvot
<bertranddrouvot(dot)pg(at)gmail(dot)com> wrote:
>
> Hi,
>
> On Wed, Oct 08, 2025 at 05:05:21PM +0000, Masahiko Sawada wrote:
> > Add mem_exceeded_count column to pg_stat_replication_slots.
> >
> > This commit introduces a new column mem_exceeded_count to the
> > pg_stat_replication_slots view. This counter tracks how often the
> > memory used by logical decoding exceeds the logical_decoding_work_mem
> > limit. The new statistic helps users determine whether exceeding the
> > logical_decoding_work_mem limit is a rare occurrences or a frequent
> > issue, information that wasn't available through existing statistics.
> >
> > Bumps catversion.
> >
> > Author: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
> > Reviewed-by: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
> > Reviewed-by: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
> > Reviewed-by: shveta malik <shveta(dot)malik(at)gmail(dot)com>
> > Reviewed-by: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
> > Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
> > Discussion: https://postgr.es/m/978D21E8-9D3B-40EA-A4B1-F87BABE7868C@yesql.se
>
> I just realized that the discussion mentioned above is not the right one.
> That should be: https://postgr.es/m/aK6zNcmb%2BPpySFvG%40ip-10-97-1-34.eu-west-3.compute.internal
>
> Reporting that here so that the link is not lost.
>

Thank you. That's my fault.

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com