Richard Huxton <dev(at)archonet(dot)com> writes:
> Scara Maccai wrote:
>> http://explain-analyze.info/query_plans/3817-query-plan-2525
> Ah, good - that's useful.
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? What PG version is this, and can you extract a self-contained
test case with an equally silly estimate?
regards, tom lane