Expose checkpoint timestamp and duration in pg_stat

Expose checkpoint timestamp and duration in pg_stat_checkpointer

Title

Expose checkpoint timestamp and duration in pg_stat_checkpointer

CI (CFBot)

Needs rebase! Needs rebase since 3 months. Failing since 3 months.
Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Tags

Extensions Performance

Created

2025-12-10 09:36:50

Last modified

2026-04-01 04:34:16 (3 days ago)

Latest email

2025-12-04 05:13:23 (4 months ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Needs review

PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF

PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF

Target version

Authors

Soumya S Murali (soumyamurali)

Reviewers

Committer

Links

Emails

[PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer: First at 2025-11-24 06:10:44 by Soumya S Murali <soumyamurali.work at gmail.com>
Latest at 2025-12-04 05:13:23 by Soumya S Murali <soumyamurali.work at gmail.com>
Latest attachment (0001-Improve-checkpoint-logging-and-expose-last-checkpoin.patch) at 2025-11-28 04:53:54 from Soumya S Murali <soumyamurali.work at gmail.com>

Attachment (0001-Improve-checkpoint-logging-and-expose-last-checkpoin.patch) at 2025-11-28 04:53:54 from Soumya S Murali <soumyamurali.work at gmail.com> (Patch: Yes)
Attachment (0001-Added-enhancement-related-to-checkpoint-reason-durat.patch) at 2025-11-24 06:10:44 from Soumya S Murali <soumyamurali.work at gmail.com> (Patch: Yes)

History

When	Who	What
2026-04-01 04:34:16	Soumya S Murali (soumyamurali)	Moved from CF PG19-Final to CF PG20-1
2026-02-02 04:54:02	Soumya S Murali (soumyamurali)	Moved from CF PG19-4 to CF PG19-Final
2025-12-10 09:37:22	CFbot	Patch needs rebase
2025-12-10 09:36:52	Soumya S Murali (soumyamurali)	Attached mail thread CAMtXxw_W6w2Q1QsCvMPnoq3xCMKzH28Zjk_EmL60oP+sCTkXOw@mail.gmail.com
2025-12-10 09:36:50	Soumya S Murali (soumyamurali)	Created patch record