pg_stat_statements: Add columns to track parallel worker activity
authorMichael Paquier <[email protected]>
Tue, 8 Oct 2024 23:30:45 +0000 (08:30 +0900)
committerMichael Paquier <[email protected]>
Tue, 8 Oct 2024 23:30:45 +0000 (08:30 +0900)
commitcf54a2c002544a4b7934deb44c895750aadb0a3c
tree5732146babb49b1fd76163570404e00e3a6f3bf4
parentde3a2ea3b264a5625cda6d8968f75e9bfb4dbdcb
pg_stat_statements: Add columns to track parallel worker activity

The view pg_stat_statements gains two columns:
- parallel_workers_to_launch, the number of parallel workers planned to
be launched.
- parallel_workers_launched, the number of parallel workers actually
launched.

The ratio of both columns offers hints that parallel workers are lacking
on a per-statement basis, requiring some tuning, in coordination with
"calls", the number of times a query is executed.

As of now, these numbers are tracked within Gather and GatherMerge
nodes.  They could be extended to utilities that make use of parallel
workers (parallel btree and brin, VACUUM).

The module is bumped to 1.12.

Author: Guillaume Lelarge
Discussion: https://postgr.es/m/CAECtzeWtTGOK0UgKXdDGpfTVSa5bd_VbUt6K6xn8P7X+_dZqKw@mail.gmail.com
contrib/pg_stat_statements/Makefile
contrib/pg_stat_statements/expected/oldextversions.out
contrib/pg_stat_statements/expected/parallel.out[new file with mode: 0644]
contrib/pg_stat_statements/meson.build
contrib/pg_stat_statements/pg_stat_statements--1.11--1.12.sql[new file with mode: 0644]
contrib/pg_stat_statements/pg_stat_statements.c
contrib/pg_stat_statements/pg_stat_statements.control
contrib/pg_stat_statements/sql/oldextversions.sql
contrib/pg_stat_statements/sql/parallel.sql[new file with mode: 0644]
doc/src/sgml/pgstatstatements.sgml