Horton

Fix "force_parallel_mode = regress" to work with ANALYZE + VERBOSE.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: b925a00f4ef65db9359e1c60fbf0e56d05afb25a
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2019-12-17T01:14:35Z
Releases: 13.0 
Fix "force_parallel_mode = regress" to work with ANALYZE + VERBOSE.

force_parallel_mode = regress is supposed to force use of a Gather
node without having any impact on EXPLAIN output.  But it failed to
accomplish that if both ANALYZE and VERBOSE are given, because that
enables per-worker output data that you wouldn't see if the Gather
hadn't been inserted.  Improve the logic so that we suppress the
per-worker data too.

This allows putting the new test case added by commit 5935917ce
back into the originally intended form (cf. 776a2c887, 22864f6e0).
We can also get rid of a kluge in subselect.sql, which previously
had to clean up after force_parallel_mode's failure to do what it
said on the tin.

Discussion: https://postgr.es/m/18445.1576177309@sss.pgh.pa.us

Files

PathChange+/−
src/backend/commands/explain.c modified +23 −4
src/include/commands/explain.h modified +1 −0
src/test/regress/expected/partition_prune.out modified +5 −5
src/test/regress/expected/subselect.out modified +0 −2
src/test/regress/sql/partition_prune.sql modified +1 −1
src/test/regress/sql/subselect.sql modified +0 −2

Discussion