Re: What happens between end of explain analyze and end of query execution ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Franck Routier <franck(dot)routier(at)axege(dot)com>
Cc: Nikolas Everett <nik9000(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: What happens between end of explain analyze and end of query execution ?
Date: 2013-04-04 16:25:13
Message-ID: 18910.1365092713@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Franck Routier <franck(dot)routier(at)axege(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Franck Routier 2013-04-04 18:49:24 Re: What happens between end of explain analyze and end of query execution ?
Previous Message Franck Routier 2013-04-04 15:44:05 Re: What happens between end of explain analyze and end of query execution ?