From cf54a2c002544a4b7934deb44c895750aadb0a3c Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Wed, 9 Oct 2024 08:30:45 +0900 Subject: 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 --- doc/src/sgml/pgstatstatements.sgml | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml index 9b0aff73b1e..501b468e9af 100644 --- a/doc/src/sgml/pgstatstatements.sgml +++ b/doc/src/sgml/pgstatstatements.sgml @@ -527,6 +527,24 @@ + + + parallel_workers_to_launch bigint + + + Number of parallel workers planned to be launched + + + + + + parallel_workers_launched bigint + + + Number of parallel workers actually launched + + + stats_since timestamp with time zone -- cgit v1.2.3