Re: What happens between end of explain analyze and end of query execution ? - Mailing list pgsql-performance

From Tom Lane
Subject Re: What happens between end of explain analyze and end of query execution ?
Date
Msg-id 18910.1365092713@sss.pgh.pa.us
Whole thread Raw
In response to Re: What happens between end of explain analyze and end of query execution ?  (Franck Routier <franck.routier@axege.com>)
Responses Re: What happens between end of explain analyze and end of query execution ?
List pgsql-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


pgsql-performance by date:

Previous
From: Franck Routier
Date:
Subject: Re: What happens between end of explain analyze and end of query execution ?
Next
From: Franck Routier
Date:
Subject: Re: What happens between end of explain analyze and end of query execution ?