pgsql: Print planning time only in EXPLAIN ANALYZE, not plain EXPLAIN. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Print planning time only in EXPLAIN ANALYZE, not plain EXPLAIN.
Date
Msg-id E1XeXOi-0005Mv-B2@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Print planning time only in EXPLAIN ANALYZE, not plain EXPLAIN.

We've gotten enough push-back on that change to make it clear that it
wasn't an especially good idea to do it like that.  Revert plain EXPLAIN
to its previous behavior, but keep the extra output in EXPLAIN ANALYZE.
Per discussion.

Internally, I set this up as a separate flag ExplainState.summary that
controls printing of planning time and execution time.  For now it's
just copied from the ANALYZE option, but we could consider exposing it
to users.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/90063a7612e2730f7757c2a80ba384bbe7e35c4b

Modified Files
--------------
contrib/auto_explain/auto_explain.c |    1 +
doc/src/sgml/perform.sgml           |   25 ++++++-------------------
doc/src/sgml/ref/explain.sgml       |   19 +++++++------------
src/backend/commands/explain.c      |   10 +++++++---
src/include/commands/explain.h      |    5 +++--
5 files changed, 24 insertions(+), 36 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Print planning time only in EXPLAIN ANALYZE, not plain EXPLAIN.
Next
From: Tom Lane
Date:
Subject: pgsql: Support timezone abbreviations that sometimes change.