Re: Adding per backend commit and rollback counters

2025-08-28 Thread Bertrand Drouvot
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

Re: Adding per backend commit and rollback counters

2025-08-10 Thread Bertrand Drouvot
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

Re: Adding per backend commit and rollback counters

2025-08-07 Thread Bertrand Drouvot
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

Adding per backend commit and rollback counters

2025-08-04 Thread Bertrand Drouvot
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