Skip site navigation (1) Skip section navigation (2)

Re: A very long running query....

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Ioannis Anagnostopoulos <ioannis(at)anatec(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: A very long running query....
Date: 2012-07-20 21:23:52
Message-ID: CAGTBQpa07PMrLA3qsM9Zf9QXcPvgntyVX7qL9CqEwQtK9LH1hA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
On Fri, Jul 20, 2012 at 6:19 PM, Ioannis Anagnostopoulos
<ioannis(at)anatec(dot)com> wrote:
> "        ->  Nested Loop  (cost=0.00..20942.93 rows=53 width=144) (actual
> time=62.174..17783236.718 rows=387105 loops=1)"
> "              Join Filter: (feed_all_y2012m07.message_copies.msg_id =
> feed_all_y2012m07.ship_pos_messages.msg_id)"
> "              ->  Append  (cost=0.00..19057.93 rows=53 width=33) (actual
> time=62.124..5486473.545 rows=387524 loops=1)"

Misestimated row counts... did you try running an analyze, or upping
statistic targets?

In response to

Responses

pgsql-novice by date

Next:From: Ioannis AnagnostopoulosDate: 2012-07-20 21:27:31
Subject: Re: A very long running query....
Previous:From: Ioannis AnagnostopoulosDate: 2012-07-20 21:19:22
Subject: A very long running query....

pgsql-performance by date

Next:From: Ioannis AnagnostopoulosDate: 2012-07-20 21:27:31
Subject: Re: A very long running query....
Previous:From: Ioannis AnagnostopoulosDate: 2012-07-20 21:19:22
Subject: A very long running query....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group