From: Tom Lane <tgl@sss.pgh.pa.us>
To: Franck Routier <franck.routier@axege.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: What happens between end of explain analyze and end of query execution ?
Date: Fri, 05 Apr 2013 10:17:28 -0400
Message-ID: <4113.1365171448@sss.pgh.pa.us> (raw)
In-Reply-To: <515ED7BC.40907@axege.com>
References: <515D92BF.5000309@axege.com>
<CAPmjWd100eemBz1RTw=r24zgh8+YO8iq86fThqsALznrPuyWqg@mail.gmail.com>
<515D9FC5.7030105@axege.com>
<18910.1365092713@sss.pgh.pa.us>
<515DCB34.6040801@axege.com>
<6354.1365102532@sss.pgh.pa.us>
<515ED7BC.40907@axege.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Franck Routier <franck.routier@axege.com> writes:
> Le 04/04/2013 21:08, Tom Lane a écrit :
>> Hmph. Can't see any reason for that to take a remarkably long time to
>> plan. Can you put together a self-contained test case demonstrating
>> excessive planning time? What PG version is this, anyway?
> What I notice is that removing joins has a huge impact on the time
> explain takes to return:
Hm, kind of looks like it's just taking an unreasonable amount of time
to process each join clause. What have you got the statistics targets
set to in this database? What are the datatypes of the join columns?
And (again) what PG version is this exactly?
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
Subject: Re: What happens between end of explain analyze and end of query execution ?
In-Reply-To: <4113.1365171448@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