Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/6308~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/6308
Choose a head ref
  • 2 commits
  • 8 files changed
  • 2 contributors

Commits on Dec 24, 2025

  1. Add last_executed timestamp to pg_stat_statements 

    This patch adds a last_executed timestamp column to pg_stat_statements,
recording when each statement was most recently executed. This enables
efficient filtering of active statements, which is particularly useful
for monitoring systems that poll pg_stat_statements periodically.

The new column helps reduce storage overhead in monitoring systems. For
example, a system polling every 3 minutes can now filter statements
executed since the last poll, avoiding storage of unchanged statistics.

The implementation updates the timestamp on every statement execution
with minimal overhead, protected by the existing spinlock. The timestamp
is persisted with other statistics and survives server restarts.

Changes include:
- New last_executed column of type timestamptz in pg_stat_statements view
- pg_stat_statements_1_14 function for version 1.14
- Upgrade script from version 1.13 to 1.14
- Regression test covering timestamp behavior
- Updated file header magic number for stats file format change
- Documentation updates
    @pashagolub
    pashagolub authored and Commitfest Bot committed Dec 24, 2025
    Configuration menu
    Copy the full SHA
    212a4fb View commit details
    Browse the repository at this point in the history

  2. [CF 6308] Add last_executed timestamp to pg_stat_statements 

    This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/6308

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/CAK7ymc+FxoVswo1ok_xDW-xPG-ZEZ8SAqCUkJ7WF04=0aQDvVQ@mail.gmail.com
Author(s): Pavlo Golub
    Commitfest Bot committed Dec 24, 2025
    Configuration menu
    Copy the full SHA
    75659fe View commit details
    Browse the repository at this point in the history
Loading