pgsql: Include planning time in EXPLAIN ANALYZE output.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Include planning time in EXPLAIN ANALYZE output.
Date: 2014-01-29 21:10:00
Message-ID: E1W8cOW-0002wI-Ng@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Include planning time in EXPLAIN ANALYZE output.

This doesn't work for prepared queries, but it's not too easy to get
the information in that case and there's some debate as to exactly
what the right thing to measure is, so just do this for now.

Andreas Karlsson, with slight doc changes by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/9347baa5bbc70368f2f01438bbb8116863dac1ec

Modified Files
--------------
doc/src/sgml/perform.sgml | 27 +++++++++++++++++++++++++++
doc/src/sgml/ref/explain.sgml | 17 ++++++++++++-----
src/backend/commands/explain.c | 24 +++++++++++++++++++++---
src/backend/commands/prepare.c | 2 +-
src/include/commands/explain.h | 4 ++--
5 files changed, 63 insertions(+), 11 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2014-01-29 21:38:44 pgsql: Forgot to bump catalog version for json_array_elements_text.
Previous Message Andrew Dunstan 2014-01-29 20:51:26 pgsql: Add json_array_elements_text function.

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-01-29 21:10:02 Re: Planning time in explain/explain analyze
Previous Message Andres Freund 2014-01-29 20:53:43 Re: Removing xloginsert_slots?