"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> writes: > Estimates extracted from the problem plan: > Nested Loop Left Join (rows=806903677108) > -> Nested Loop Left Join (rows=203176856) > -> Nested Loop Left Join (rows=51160) > -> Nested Loop Left Join (rows=28) > -> Append (rows=4) > -> Append (rows=2) > -> Append (rows=2) That does look weird. Do we have a self-contained test case? I wouldn't necessarily expect the join rowcount to be exactly the product of the input rowcounts, but it shouldn't be that far off, I should think. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance