| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Jesper Krogh <jesper(at)krogh(dot)cc> |
| Cc: | Craig Ringer <craig(at)2ndquadrant(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Slow query-plan generation (fast query) PG 9.2 |
| Date: | 2013-09-04 13:59:39 |
| Message-ID: | CAHyXU0yv9-A1r2cuzFScwK_uJjqBRRBDFWnF2vgE4F_meZnoeA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Sep 3, 2013 at 2:34 PM, Jesper Krogh <jesper(at)krogh(dot)cc> wrote:
> On 03/09/13 09:47, Craig Ringer wrote:
>
> On 09/03/2013 03:46 PM, jesper(at)krogh(dot)cc wrote:
>
> Hi.
>
> I have a strange situation where generating the query plan takes 6s+ and
> executing it takes very little time.
>
> How do you determine that it's planning time at fault here?
>
> Not that I'm sure, but the timing I send were only for "explain" not
> "explain analyze". The database is constantly updating and at the moment i
> cannot reproduce it any more. But at the time I picked the numbers it were
> very reproducible.. (tried 10+ times over 15 minutes).
Maybe your explain was blocking on locks?
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeison Bedoya Delgado | 2013-09-04 15:22:46 | higth performance write to disk |
| Previous Message | David Boreham | 2013-09-04 13:14:53 | Re: AMD vs Intel |