Hi,
On Sun, Aug 10, 2025 at 07:47:09AM +, Bertrand Drouvot wrote:
> To sum up, v3 contains:
>
> 0001 -
> Adding per backend commit and rollback counters
> 0002 -
> Adding XID generation count per backend
> 0003 -
> Adding the pg_stat_backend view
Following re
er of seqscans, vacuum count, analyze count..., I'll open a
dedicated
thread for those) and I think that a single view to display them all makes
more sense than a lot of individual functions. This view is added in 0003.
To sum up, v3 contains:
0001 -
Adding per backend commit and rollback cou
ched.
Regards,
--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
>From 711863b09f54db89f74ebfbe822d25322668e7e4 Mon Sep 17 00:00:00 2001
From: Bertrand Drouvot
Date: Mon, 4 Aug 2025 08:14:02 +
Subject: [PATCH v2] Adding p
14:02 +
Subject: [PATCH v1] Adding per backend commit and rollback counters
This commit adds 2 functions: pg_stat_get_backend_xact_commit() and
pg_stat_get_backend_xact_rollback() to report the number of transactions that
have been committed/rolled back for a given backend PID.
It relies on th