Re: pgsql: Add mem_exceeded_count column to pg_stat_replication_slots.

From: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Masahiko Sawada <msawada(at)postgresql(dot)org>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Add mem_exceeded_count column to pg_stat_replication_slots.
Date: 2025-10-29 08:52:00
Message-ID: aQHVsIGv8gbSuO8r@ip-10-97-1-34.eu-west-3.compute.internal
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2025-10-29 09:01:48 pgsql: Reorganize GUC structs
Previous Message Peter Eisentraut 2025-10-29 08:33:19 pgsql: formatting.c cleanup: Add some const pointer qualifiers