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 >