Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer - Mailing list pgsql-hackers

From Juan José Santamaría Flecha
Subject Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer
Date
Msg-id CAC+AXB1Vco9jSmjZsdGupqiRMSDfTBu_H6r=FQhmZrUpwScjhA@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer  (Soumya S Murali <soumyamurali.work@gmail.com>)
Responses Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer
List 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

pgsql-hackers by date:

Previous
From: David Geier
Date:
Subject: Re: Performance issues with parallelism and LIMIT
Next
From: Tomas Vondra
Date:
Subject: Re: Performance issues with parallelism and LIMIT