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

2025-11-26 Thread Soumya S Murali
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

2025-11-26 Thread Soumya S Murali
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

2025-11-24 Thread Michael Banck
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

2025-11-24 Thread Álvaro Herrera
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

2025-11-24 Thread Michael Banck
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

2025-11-20 Thread Álvaro Herrera
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