On Mon, Dec 16, 2013 at 4:14 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Is there a way to measure the planning time? It's not reported in 'explain analyze' or 'explain analyze verbose', right?
Joe Van Dyk <joe@xxxxxxxxx> writes:Yup, that's what I was just about to suggest. You might want to use
> Hm, setting set join_collapse_limit = 9 seemed to fix the problem. Is that
> my best/only option?
10 or 12 in case some of your queries are a bit more complex than
this one --- but don't go overboard, or you may find yourself with
unreasonable planning time.
Joe
