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

Commits on Nov 3, 2025

  1. Adding per backend commit and rollback counters 

    It relies on the existing per backend statistics that has been added in
9aea73f. The new pending counters are updated when the database ones are
flushed (to reduce the overhead of incrementing new counters).
    @bdrouvotAWS
    bdrouvotAWS authored and Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    6ad7a20 View commit details
    Browse the repository at this point in the history

  2. Adding XID generation count per backend 

    This commit adds a new counter to record the number of XIDs generated per
backend. It will help to detect if a backend is consuming XIDs at a high rate.

Virtual transactions are not taken into account on purpose, we do want to track
only the XID where there is a risk of wraparound.
    @bdrouvotAWS
    bdrouvotAWS authored and Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    1f715f4 View commit details
    Browse the repository at this point in the history

  3. Adding the pg_stat_backend_transaction view 

    This view displays one row per server process, showing transaction statistics
related to the current activity of that process. It currently displays the pid,
the number of XIDs generated, the number of commits, the number of rollbacks and
the time at which these statistics were last reset.

It's built on top of a new function (pg_stat_get_backend_transactions()). 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 Nov 3, 2025
    Configuration menu
    Copy the full SHA
    e8bdcb1 View commit details
    Browse the repository at this point in the history

  4. [CF 5947] v4 - Adding per backend commit and rollback counters 

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

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

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 Nov 3, 2025
    Configuration menu
    Copy the full SHA
    5404377 View commit details
    Browse the repository at this point in the history
Loading