can someone explain that?

From: Luis Amigo <lamigo(at)atc(dot)unican(dot)es>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: can someone explain that?
Date: 2001-12-14 09:48:36
Message-ID: 3C19CAF4.1FEFD6FA@atc.unican.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

while explaining this query.

We're getting this strange result:
Limit (cost=840340.22..840340.22 rows=6 width=53) (actual
time=-3035.03..-3034.97 rows=3 loops=1)
-> Sort (cost=840340.22..840340.22 rows=7 width=53) (actual
time=-3035.07..-3035.05 rows=3 loops=1)
-> Aggregate (cost=840339.80..840340.13 rows=7 width=53)
(actual time=-3037.55..-3036.18 rows=3 loops=1)
-> Group (cost=840339.80..840339.96 rows=67 width=53)
(actual time=-3038.21..-3036.80 rows=37 loops=1)
-> Sort (cost=840339.80..840339.80 rows=67
width=53) (actual time=-3038.26..-3038.00 rows=37 loops=1)
-> Nested Loop (cost=6.88..840337.78 rows=67
width=53) (actual time=532.35..-3040.17 rows=37 loops=1)
-> Hash Join (cost=6.88..839378.23
rows=201 width=49) (actual time=531.00..-3094.78 rows=86 loops=1)
-> Seq Scan on lineitem l1
(cost=0.00..839343.72 rows=5025 width=8) (actual time=45.33..-3151.70
rows=3079 loops=1)
SubPlan
-> Index Scan using
lineitem_pkey on lineitem l2 (cost=0.00..18.33 rows=5 width=172)
(actual time=0.20..0.20 rows=1 loops=30334)
-> Index Scan using
lineitem_pkey on lineitem l3 (cost=0.00..18.34 rows=2 width=172)
(actual time=0.24..0.24 rows=1 loops=29240)
-> Hash (cost=6.87..6.87 rows=4
width=41) (actual time=5.78..5.78 rows=0 loops=1)
-> Hash Join
(cost=1.31..6.87 rows=4 width=41) (actual time=1.46..5.71 rows=3
loops=1)
-> Seq Scan on
supplier (cost=0.00..5.00 rows=100 width=37) (actual time=0.06..3.24
rows=100 loops=1)
-> Hash
(cost=1.31..1.31 rows=1 width=4) (actual time=0.61..0.61 rows=0 loops=1)

-> Seq Scan on
nation (cost=0.00..1.31 rows=1 width=4) (actual time=0.47..0.56 rows=1
loops=1)
-> Index Scan using orders_pkey on
orders (cost=0.00..4.76 rows=1 width=4) (actual time=0.57..0.58 rows=0
loops=86)
Total runtime: -3032.37 msec
Can someone explain this?

Attachment Content-Type Size
query21.sql text/plain 660 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message omid omoomi 2001-12-14 10:23:11 Re: slow queries on large syslog table
Previous Message Anil Kumar Narule 2001-12-14 08:42:52 Display of Japanese character

Browse pgsql-hackers by date

  From Date Subject
Next Message Hermann RANGAMANA 2001-12-14 09:50:54 psql interval type
Previous Message Zeugswetter Andreas SB SD 2001-12-14 09:00:49 Re: Problem compiling postgres sql --with-tcl