Re: [PATCH] Expose checkpoint reason to completion log messages.

Soumya S Murali <soumyamurali.work@gmail.com>

From: Soumya S Murali <soumyamurali.work@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Michael Banck <mbanck@gmx.net>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Álvaro Herrera <alvherre@kurilemu.de>, melanieplageman@gmail.com, juanjo.santamaria@gmail.com
Date: 2026-01-01T08:09:32Z
Lists: pgsql-hackers

Attachments

Hi all,

On Thu, Dec 18, 2025 at 5:49 AM Andres Freund <andres@anarazel.de> wrote:
>
> Hi,
>
> On 2025-12-01 16:48:56 +0530, Soumya S Murali wrote:
> > This patch is an update after reworking the “checkpoint reason” changes as
> > a standalone patch, separate from the pg_stat_checkpointer additions as
> > suggested [1].
>
> This seems to not pass the tests on any platform:
> https://cirrus-ci.com/github/postgresql-cfbot/postgresql/cf%2F6306
>
> Looks like you need to update 019_replslot_limit.pl for the changed log
> format.
>
> I suggest running the tests before submitting.
>
> Greetings,
>
> Andres


I have updated my patch and have tested successfully. Also had rerun
the entire recovery TAP suite and every test got passed successfully.
I am attaching the updated patch herewith.


Regards,
Soumya

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Log checkpoint request flags in checkpoint completion messages.