diff options
| author | Michael Paquier <michael@paquier.xyz> | 2024-10-09 08:30:45 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2024-10-09 08:30:45 +0900 |
| commit | cf54a2c002544a4b7934deb44c895750aadb0a3c (patch) | |
| tree | 5732146babb49b1fd76163570404e00e3a6f3bf4 /contrib/pg_stat_statements/pg_stat_statements.control | |
| parent | de3a2ea3b264a5625cda6d8968f75e9bfb4dbdcb (diff) | |
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
Diffstat (limited to 'contrib/pg_stat_statements/pg_stat_statements.control')
| -rw-r--r-- | contrib/pg_stat_statements/pg_stat_statements.control | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/pg_stat_statements/pg_stat_statements.control b/contrib/pg_stat_statements/pg_stat_statements.control index 8a76106ec67..d45ebc12e36 100644 --- a/contrib/pg_stat_statements/pg_stat_statements.control +++ b/contrib/pg_stat_statements/pg_stat_statements.control @@ -1,5 +1,5 @@ # pg_stat_statements extension comment = 'track planning and execution statistics of all SQL statements executed' -default_version = '1.11' +default_version = '1.12' module_pathname = '$libdir/pg_stat_statements' relocatable = true |