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

Re: Understanding the output of EXPLAIN ANALYSE

From: Greg Stark <gsstark(at)mit(dot)edu>
To: "Thurber, Fred" <Fred(dot)Thurber(at)gdit(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Understanding the output of EXPLAIN ANALYSE
Date: 2009-07-23 21:11:15
Message-ID: 407d949e0907231411u6c392854sa9169db7bd2c1eec@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, Jul 23, 2009 at 6:14 PM, Thurber, Fred<Fred(dot)Thurber(at)gdit(dot)com> wrote:
> "Nested Loop  (cost=78.63..101.14 rows=1 width=256) (actual
> time=0.000..16.000 rows=2818 loops=1)"


Well it was expecting 1 row and got 2,818 so the costs are going to be
pretty wildly wrong. But since you cut out all the details it's pretty
hard to guess what happened.

-- 
greg
http://mit.edu/~gsstark/resume.pdf

In response to

Responses

pgsql-novice by date

Next:From: Saul LozanoDate: 2009-07-23 21:26:47
Subject: Re: Setting up security for development
Previous:From: Michael SwierczekDate: 2009-07-23 20:15:44
Subject: Re: Setting up security for development

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