pgsql: Invent pgstat_fetch_stat_backend_by_pid()

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Invent pgstat_fetch_stat_backend_by_pid()
Date: 2025-02-28 02:21:54
Message-ID: E1tnq0g-0004NU-1q@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Invent pgstat_fetch_stat_backend_by_pid()

This code is extracted from pg_stat_get_backend_io() in pgstatfuncs.c,
so as it can be shared with other areas that need backend pgstats
entries while having the benefits of the various sanity checks
refactored here. As per its name, this retrieves backend statistics
based on a PID, with the option of retrieving a BackendType if given in
input.

Currently, this is used for the backend-level IO statistics. The next
move would be to reuse that for the backend-level WAL statistics.

Author: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
Discussion: https://postgr.es/m/Z3zqc4o09dM/Ezyz(at)ip-10-97-1-34(dot)eu-west-3(dot)compute(dot)internal

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c2a50ac678eb5ccee271aef3e7ed146ac395a32b

Modified Files
--------------
src/backend/utils/activity/pgstat_backend.c | 53 +++++++++++++++++++++++++++++
src/backend/utils/adt/pgstatfuncs.c | 30 +---------------
src/include/pgstat.h | 2 ++
3 files changed, 56 insertions(+), 29 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Jeff Davis 2025-02-28 04:42:53 pgsql: Adjust pg_dump tag for relation stats.
Previous Message Michael Paquier 2025-02-28 01:16:34 pgsql: pg_upgrade: Fix inconsistency in memory freeing