Scara Maccai wrote:
>> Hmmm ... why is the inner Nested Loop estimated to produce
>> 30120 rows,
>> when the cartesian product of its inputs would only be 285
>> * 14 = 3990
>> rows?
>
> Oh my... didn't notice it!!!
It was doing the same thing here too:
http://explain-analyze.info/query_plans/3807-query-plan-2511
Basically the same location too: nested loop over a seq-scan and an append.
--
Richard Huxton
Archonet Ltd