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

Поиск
Список
Период
Сортировка
От Juan José Santamaría Flecha
Тема Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer
Дата
Msg-id CAC+AXB1Vco9jSmjZsdGupqiRMSDfTBu_H6r=FQhmZrUpwScjhA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer  (Soumya S Murali <soumyamurali.work@gmail.com>)
Ответы Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer
Список 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 по дате отправления: