From: | "Travis Bauer" <trbauer(at)cs(dot)indiana(dot)edu> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Help on analyzing performance problem. |
Date: | 2000-08-26 04:13:57 |
Message-ID: | NEBBKFAPMLLNJENAEJNDAEBJCAAA.trbauer@cs.indiana.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a problem with a _very_ slow query. I'm not sure how to understand
the explain output. Can anyone tell from the following where I might look
for a bottleneck in the system?
Thank,
Travis
psql:test.sql:1: NOTICE: QUERY PLAN:
Nested Loop (cost=3.03..240.90 rows=4 width=124)
-> Nested Loop (cost=3.03..150.16 rows=7 width=92)
-> Merge Join (cost=3.03..3.63 rows=11 width=76)
-> Sort (cost=1.52..1.52 rows=17 width=32)
-> Seq Scan on oilday (cost=0.00..1.17 rows=17
width=32)
-> Sort (cost=1.52..1.52 rows=17 width=44)
-> Seq Scan on oilday (cost=0.00..1.17 rows=17
width=44)
-> Index Scan using well_pkey on well (cost=0.00..13.45 rows=1
width=16)
SubPlan
-> Materialize (cost=11.44..11.44 rows=82 width=12)
-> Nested Loop (cost=0.00..11.44 rows=82 width=12)
-> Seq Scan on usernames (cost=0.00..1.03
rows=1 width=4)
-> Index Scan using comp_index on well
(cost=0.00..10.21 rows=15 width=8)
-> Index Scan using well_pkey on well (cost=0.00..13.45 rows=1 width=32)
SubPlan
-> Materialize (cost=11.44..11.44 rows=82 width=12)
-> Nested Loop (cost=0.00..11.44 rows=82 width=12)
-> Seq Scan on usernames (cost=0.00..1.03 rows=1
width=4)
-> Index Scan using comp_index on well
(cost=0.00..10.21 rows=15 width=8)
From | Date | Subject | |
---|---|---|---|
Next Message | anuj | 2000-08-26 05:14:26 | RE: system catalog problems |
Previous Message | Bruce Guenter | 2000-08-26 03:13:26 | Re: set pgsql-general nomail |