]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Print planning time only in EXPLAIN ANALYZE, not plain EXPLAIN.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 15 Oct 2014 22:50:16 +0000 (18:50 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 15 Oct 2014 22:50:16 +0000 (18:50 -0400)
commit9bb6b7c5ed617b34edf1a962c9405359822418d3
tree6a9a6535cba6bd586f48f247a77a3961a5317d95
parent4971c36b46c63c0b36a38df6a4b6ad9f303e4620
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.
contrib/auto_explain/auto_explain.c
doc/src/sgml/perform.sgml
doc/src/sgml/ref/explain.sgml
src/backend/commands/explain.c
src/include/commands/explain.h