| From: | Juan José Santamaría Flecha <juanjo(dot)santamaria(at)gmail(dot)com> |
|---|---|
| To: | Soumya S Murali <soumyamurali(dot)work(at)gmail(dot)com> |
| Cc: | Álvaro Herrera <alvherre(at)kurilemu(dot)de>, Michael Banck <mbanck(at)gmx(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, melanieplageman(at)gmail(dot)com |
| Subject: | Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer |
| Date: | 2025-11-26 17:23:08 |
| Message-ID: | CAC+AXB1Vco9jSmjZsdGupqiRMSDfTBu_H6r=FQhmZrUpwScjhA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
El mié, 26 nov 2025, 11:14, Soumya S Murali <soumyamurali(dot)work(at)gmail(dot)com>
escribió:
> On Mon, Nov 24, 2025 at 3:37 PM Álvaro Herrera <alvherre(at)kurilemu(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2025-11-26 17:30:36 | Re: Performance issues with parallelism and LIMIT |
| Previous Message | David Geier | 2025-11-26 17:22:50 | Re: Performance issues with parallelism and LIMIT |