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

Hi, On Wed, Nov 26, 2025 at 06:23:08PM +0100, Juan José Santamaría Flecha wrote: > El mié, 26 nov 2025, 11:14, Soumya S Murali > escribió: > There is a "Checkpoints" section in the pgbadger reports, and that's > probably the most widely used tool. That one parses the Postgres logs, so is unaffec

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

El mié, 26 nov 2025, 11:14, Soumya S Murali escribió: > On Mon, Nov 24, 2025 at 3:37 PM Álvaro Herrera > 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 disappoi

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

On Mon, Nov 24, 2025 at 3:37 PM Álvaro Herrera wrote: > > On 2025-Nov-24, Michael Banck wrote: > > > In general I doubt how much those gauges (as oppposed to counters) only > > pertaining to the last checkpoint are useful in pg_stat_checkpointer. > > What would be the use case for those two values

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

On Mon, Nov 24, 2025 at 2:48 PM Michael Banck wrote: > > Hi, > > On Mon, Nov 24, 2025 at 11:40:44AM +0530, Soumya S Murali wrote: > > While debugging checkpointer write behavior, I recently found some of the > > enhancements related to extending pg_stat_checkpointer by including > > checkpoint typ

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

Hi, On Mon, Nov 24, 2025 at 11:07:41AM +0100, Álvaro Herrera wrote: > On 2025-Nov-24, Michael Banck wrote: > > > In general I doubt how much those gauges (as oppposed to counters) only > > pertaining to the last checkpoint are useful in pg_stat_checkpointer. > > What would be the use case for tho

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

On 2025-Nov-24, Michael Banck wrote: > In general I doubt how much those gauges (as oppposed to counters) only > pertaining to the last checkpoint are useful in pg_stat_checkpointer. > What would be the use case for those two values? I think it's useful to know how long checkpoint has to work. I

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

Hi, On Mon, Nov 24, 2025 at 11:40:44AM +0530, Soumya S Murali wrote: > While debugging checkpointer write behavior, I recently found some of the > enhancements related to extending pg_stat_checkpointer by including > checkpoint type (manual/timed/immediate), last_checkpoint_time and > checkpoint_t

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

On 2025-Nov-20, BharatDB wrote: > Hi all, Please see https://postgr.es/m/ca+tgmozwtlxmdxp9ckslohtdzxj2bxhjk7+0w206wxgpypx...@mail.gmail.com especially point 2. -- Álvaro Herrera