| From: | Chris Jones <chris(at)mt(dot)sri(dot)com> |
|---|---|
| To: | Konstantinos Agouros <elwood(at)agouros(dot)de> |
| Cc: | Joel Burton <jburton(at)scw(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re: Very long running query |
| Date: | 2001-04-11 17:36:34 |
| Message-ID: | 20010411113634.A23106@mt.sri.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Apr 11, 2001 at 11:03:53AM +0200, Konstantinos Agouros wrote:
> > what does explain command show about your query?
> NOTICE: QUERY PLAN:
>
> Subquery Scan *SELECT* (cost=0.02..0.03 rows=1 width=40)
> -> Aggregate (cost=0.02..0.03 rows=1 width=40)
> -> Group (cost=0.02..0.03 rows=1 width=40)
> -> Sort (cost=0.02..0.02 rows=1 width=40)
> -> Nested Loop (cost=0.00..0.01 rows=1 width=40)
> -> Seq Scan on websensebycat a (cost=0.00..0.00 rows=1 width=24)
> -> Seq Scan on netscapereduce b (cost=0.00..0.00 rows=1 width=16)
> SubPlan
> -> Seq Scan on urlcounts (cost=0.00..0.00 rows=1 width=12)
Umm, standard question: Have you run VACUUM ANALYZE?
Chris
--
chris(at)mt(dot)sri(dot)com -----------------------------------------------------
Chris Jones SRI International, Inc.
www.sri.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Jones | 2001-04-11 17:38:24 | Re: PHP question |
| Previous Message | Mark Butler | 2001-04-11 16:48:49 | Re: Index type promotion |