Re: Parallel workers stats in pg_stat_database

Guillaume Lelarge <guillaume@lelarge.info>

From: Guillaume Lelarge <guillaume@lelarge.info>

To: Benoit Lobréau <benoit.lobreau@dalibo.com>

Cc: Michael Paquier <michael@paquier.xyz>, Bertrand Drouvot <bertranddrouvot.pg@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2024-10-07T08:19:04Z

Lists: pgsql-hackers

Attachments

v5-0001-Introduce-two-new-counters-in-EState.patch (text/x-patch) patch v5-0001
v5-0002-Adds-four-parallel-workers-stat-columns-to-pg_sta.patch (text/x-patch) patch v5-0002

Hey,

Le mer. 2 oct. 2024 à 11:12, Benoit Lobréau <benoit.lobreau@dalibo.com> a
écrit :

> Hi,
>
> Thanks for your imput ! I will fix the doc as proposed and do the split
> as soon as I have time.
>
>
I've done the split, but I didn't go any further than that.

Two patches attached:
* v5-0001 adds the metrics (same patch than v3-0001 for pg_stat_statements)
* v5-0002 handles the metrics for pg_stat_database.

"make check" works, and I also did a few other tests without any issues.

Regards.


-- 
Guillaume.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add two attributes to pg_stat_database for parallel workers activity
- e7a9496de906 18.0 landed
Introduce two fields in EState to track parallel worker activity
- de3a2ea3b264 18.0 landed