From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: planner question.. |
Date: | 2003-04-17 15:12:16 |
Message-ID: | 200304172042.16034.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Thursday 17 Apr 2003 7:42 pm, Stephan Szabo wrote:
> On Thu, 17 Apr 2003, Rajesh Kumar Mallah wrote:
> > I think there shud be more documentation on
> > understanding EXPLAIN (ANALYZE) output.
> > once i found an webpage but lost it.
>
> I believe there's one inside the docs on performance or optimization.
I have seen that and saw a better one somewhere else which i
cant recall.
> > where do u see its expecting 5000 not 100000?
> >
> > > > | Aggregate (cost=23982.58..23982.58 rows=1 width=0) (actual
> > > > | time=22872.97..22872.97 rows=1 loops=1) |
> > > > | -> Seq Scan on profile_master (cost=0.00..23970.40 rows=4871
> > > > | width=0) (actual time=328.44..22730.69 rows=102090 loops=1) |
>
> In the Seq Scan line, it's got rows=4871. That's the number it thinks are
> going to match the filter/index condition.
Thanks for spotting , i will go thru the docs once again though :)
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
From | Date | Subject | |
---|---|---|---|
Next Message | Guy Fraser | 2003-04-17 15:18:49 | Re: What is the scope of a temp table? |
Previous Message | Rajesh Kumar Mallah | 2003-04-17 15:10:06 | Re: planner question.. |