On Sun, Feb 2, 2014 at 11:13 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Peter Geoghegan <p...@heroku.com> writes: >> On Wed, Jan 29, 2014 at 1:10 PM, Robert Haas <rh...@postgresql.org> wrote: >>> Include planning time in EXPLAIN ANALYZE output. > >> Isn't it perhaps a little confusing that "Planning time" may well >> exceed "Total runtime"? > > Perhaps s/Total runtime/Execution time/ ?
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. But adding the planning time to the output seems to me to make that better, not worse. If the user can't figure out that runtime != planning time, I'm not sure they'll be able to figure out execution time != planning time, either. One of the reasons it's called "Total runtime", or so I've always assumed, is because it's more inclusive than the time shown for the root node of the plan tree. Specifically, it includes the time required to fire triggers. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
