Postgres Pro
Downloads
Home   >   mailing lists

Re: Actual rows significantly more than estimated during many joins - Mailing list pgsql-general

From Andrew Beverley
Subject Re: Actual rows significantly more than estimated during many joins
Date
Msg-id 20160604131858.74ce49cb6698475f9984b771@andybev.com
Whole thread Raw
In response to Actual rows significantly more than estimated during many joins  (Andrew Beverley <andy@andybev.com>)
List pgsql-general
Tree view 
On Sat, 4 Jun 2016 Andrew Beverley <andy@andybev.com> 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

pgsql-general by date:

Previous
From: Andrew Beverley
Date:
Subject: Actual rows significantly more than estimated during many joins
Next
From: Vik Fearing
Date:
Subject: Re: Replication