pgsql: Allow EXPLAIN (ANALYZE, VERBOSE) to display per-worker statistic

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow EXPLAIN (ANALYZE, VERBOSE) to display per-worker statistic
Date: 2015-12-09 18:25:22
Message-ID: E1a6jQY-0004LB-Sr@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow EXPLAIN (ANALYZE, VERBOSE) to display per-worker statistics.

The original parallel sequential scan commit included only very limited
changes to the EXPLAIN output. Aggregated totals from all workers were
displayed, but there was no way to see what each individual worker did
or to distinguish the effort made by the workers from the effort made by
the leader.

Per a gripe by Thom Brown (and maybe others). Patch by me, reviewed
by Amit Kapila.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b287df70e4080350aa471ecca428be145581dd4d

Modified Files
--------------
src/backend/commands/explain.c | 251 ++++++++++++++++++++++-------------
src/backend/executor/execParallel.c | 98 ++++++++------
src/include/executor/instrument.h | 6 +
src/include/nodes/execnodes.h | 1 +
4 files changed, 226 insertions(+), 130 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2015-12-09 19:13:14 pgsql: Remove redundant sentence.
Previous Message Kevin Grittner 2015-12-08 23:36:25 pgsql: Improve performance in freeing memory contexts