On Tue, Sep 3, 2013 at 2:34 PM, Jesper Krogh <jesper@xxxxxxxx> wrote: > On 03/09/13 09:47, Craig Ringer wrote: > > On 09/03/2013 03:46 PM, jesper@xxxxxxxx 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
