Re: [COMMITTERS] pgsql: Include planning time in EXPLAIN ANALYZE output. - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: [COMMITTERS] pgsql: Include planning time in EXPLAIN ANALYZE output.
Date
Msg-id CAM3SWZTMzVsYi0yjYg_rnM_oKppPLKYpBMV+x9z-9Wb_jpeN1Q@mail.gmail.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Include planning time in EXPLAIN ANALYZE output.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [COMMITTERS] pgsql: Include planning time in EXPLAIN ANALYZE output.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, Feb 3, 2014 at 4:15 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> I'm not really feeling a compelling need to change that.  We've been
> displaying total runtime - described exactly that way - for many
> releases and it's surely is confusing to the novice that the time
> reported can be much less than the time reported by psql's \timing
> option, usually because of planning time.

I think that has a lot more to do with network roundtrip time and
protocol/serialization overhead.


-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Wait free LW_SHARED acquisition - v0.2
Next
From: Andres Freund
Date:
Subject: Re: Re: Misaligned BufferDescriptors causing major performance problems on AMD