On Sat, 4 Jun 2016 Andrew Beverley <andy@xxxxxxxxxxx> wrote: > When I run EXPLAIN ANALYZE, I see that the actual query is scanning > significantly more rows for the join than was estimated. There is also > a huge number of loops for the joins. Why is this, and is there an > easy fix? I should have said: PostgreSQL version 9.4.6 running on Debian 8.4 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general