Re: Parallel workers stats in pg_stat_database

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

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

To: Guillaume Lelarge <guillaume@lelarge.info>

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

Date: 2024-10-11T23:14:54Z

Lists: pgsql-hackers

Attachments

V6_0003-Adds-two-parallel-workers-stat-columns-for-utilities.patch (text/x-patch) patch 0003
V6_0002-Setup-counters-for-parallel-vacuums.patch (text/x-patch) patch 0002
V6_0001-Adds-two-parallel-workers-stat-columns-to-pg_stat_da.patch (text/x-patch) patch 0001

On 10/11/24 09:33, Guillaume Lelarge wrote:
> FWIW, with the recent commits of the pg_stat_statements patch, you need 
> a slight change in the patch I sent on this thread. You'll find a patch 
> attached to do that. You need to apply it after a rebase to master.

Thanks.

Here is an updated version, I modified it to:

* have the same wording in the doc and code (planned => to_launch)
* split de declaration from the rest (and have the same code as the 
parallel worker logging patch)

-- 
Benoit Lobréau
Consultant
http://dalibo.com

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