From: Tom Lane <tgl@sss.pgh.pa.us>
To: Franck Routier <franck.routier@axege.com>
Cc: Nikolas Everett <nik9000@gmail.com>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: What happens between end of explain analyze and end of query execution ?
Date: Thu, 04 Apr 2013 12:25:13 -0400
Message-ID: <18910.1365092713@sss.pgh.pa.us> (raw)
In-Reply-To: <515D9FC5.7030105@axege.com>
References: <515D92BF.5000309@axege.com>
<CAPmjWd100eemBz1RTw=r24zgh8+YO8iq86fThqsALznrPuyWqg@mail.gmail.com>
<515D9FC5.7030105@axege.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Franck Routier <franck.routier@axege.com> writes:
> Right, explain alone takes 3.6 seconds, so the time really seems to go
> query planning...
Well, you've not shown us the query, so it's all going to be
speculation. But maybe you have some extremely expensive function that
the planner is evaluating to fold to a constant, or something like that?
The generated plan isn't terribly complicated, but we can't see what
was required to produce it.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, franck.routier@axege.com, nik9000@gmail.com
Subject: Re: What happens between end of explain analyze and end of query execution ?
In-Reply-To: <18910.1365092713@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox