Re: [PERFORM] query plan estimate

2013-03-31 Thread Tom Lane
pg noob 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

[PERFORM] query plan estimate

2013-03-31 Thread pg noob
Hi all, 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? -> Nested Loop (*cost=0.00..2888.16* rows=240 width=16) (actual time=0.034..2.180 rows=91 loops=1) Output: public.mg.lctime, public.