Re: query plan estimate

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pg noob <pgnube(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: query plan estimate
Date: 2013-04-01 00:52:59
Message-ID: 24671.1364777579@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

pg noob <pgnube(at)gmail(dot)com> writes:
> I'm looking at this query plan, an excerpt of which is shown here, and I am
> just wondering how the estimated cost for the Nested Loop is calculated?

http://www.postgresql.org/docs/9.2/static/using-explain.html

There's a nestloop example about a third of the way down the page ...

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2013-04-01 13:42:42 Re: Question about postmaster's CPU usage
Previous Message Jeff Janes 2013-03-31 17:16:50 Re: 9.2.3 upgrade reduced pgbench performance by 60%