Re: Adding per backend commit and rollback counters

Bertrand Drouvot <bertranddrouvot.pg@gmail.com>

From: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-08-07T08:17:26Z
Lists: pgsql-hackers

Attachments

Hi,

On Mon, Aug 04, 2025 at 02:20:48PM +0000, Bertrand Drouvot wrote:
> This patch is pretty straightforward as it relies on the existing per backend
> statistics machinery that has been added in 9aea73fc61d (so that there is not
> that much design to discuss).

Still, while working on adding more backend stats (more on that later), I 
realized that in v1, I missed to use pgstat_report_fixed (recently added in 
793928c2d5a): the attached fixes that.

Also, I think it's better to put the new xact pending counters in the existing
PgStat_BackendPending, done that way in the attached.

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com