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/5958~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/5958
Choose a head ref
  • 3 commits
  • 12 files changed
  • 2 contributors

Commits on Oct 20, 2025

  1. Adding per backend relation statistics tracking 

    This commit introduces per backend relation stats tracking and adds a
new PgStat_BackendRelPending struct to store the pending statistics. To begin with,
this commit adds a new counter numscans to record the number of sequential
scans initiated on tables.

This commit relies on the existing per backend statistics machinery that has been
added in 9aea73f.
    @bdrouvotAWS
    bdrouvotAWS authored and Commitfest Bot committed Oct 20, 2025
    Configuration menu
    Copy the full SHA
    1f3a54c View commit details
    Browse the repository at this point in the history

  2. Adding the pg_stat_backend_relation view 

    This view displays one row per server process, showing relation statistics related
to the current activity of that process. It currently displays the pid, the
number of sequential scans initiated on tables and the
time at which these statistics were last reset.

It's built on top of a new function (pg_stat_get_backend_relations()). The idea
is the same as pg_stat_activity and pg_stat_get_activity().

Adding documentation and tests.

XXX: Bump catversion
    @bdrouvotAWS
    bdrouvotAWS authored and Commitfest Bot committed Oct 20, 2025
    Configuration menu
    Copy the full SHA
    33dedf1 View commit details
    Browse the repository at this point in the history

  3. [CF 5958] v3 - Per backend relation statistics tracking 

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

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

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/[email protected]
Author(s): Bertrand Drouvot
    Commitfest Bot committed Oct 20, 2025
    Configuration menu
    Copy the full SHA
    1cf6c0b View commit details
    Browse the repository at this point in the history
Loading