Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer

Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>

From: Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
To: Soumya S Murali <soumyamurali.work@gmail.com>
Cc: Álvaro Herrera <alvherre@kurilemu.de>, Michael Banck <mbanck@gmx.net>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, melanieplageman@gmail.com
Date: 2025-11-26T17:23:08Z
Lists: pgsql-hackers
El mié, 26 nov 2025, 11:14, Soumya S Murali <soumyamurali.work@gmail.com>
escribió:

> On Mon, Nov 24, 2025 at 3:37 PM Álvaro Herrera <alvherre@kurilemu.de>
> wrote:
>
> > In the past, I looked at a couple of monitoring dashboards offered by
> > cloud vendors, searching for anything valuable in terms of checkpoints.
> > What I saw was very disappointing -- mostly just "how many checkpoints
> > per minute", which is mostly flat zero with periodic spikes.  Totally
> > useless.  Does anybody know if some vendor has good charts for this?
> > Also, if we were to add this new proposed duration, how could these
> > charts improve?
>
> I will look into this in more depth. Will let you know if I find
> something concrete.
>

There is a "Checkpoints" section in the pgbadger reports, and that's
probably the most widely used tool.

Regards

Juan José Santamaría Flecha

>