can someone explain that?

Started by Luis Amigoabout 24 years ago3 messages
#1Luis Amigo
lamigo@atc.unican.es
1 attachment(s)

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?

Attachments:

query21.sqltext/plain; charset=us-ascii; name=query21.sqlDownload
#2Martijn van Oosterhout
kleptog@svana.org
In reply to: Luis Amigo (#1)
Re: can someone explain that?

On Fri, Dec 14, 2001 at 10:48:36AM +0100, Luis Amigo wrote:

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)

How long did this query take? Was it over an hour?
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/

Show quoted text

Terrorists can only take my life. Only my government can take my freedom.

#3Luis Amigo
lamigo@atc.unican.es
In reply to: Luis Amigo (#1)
Re: can someone explain that?

Martijn van Oosterhout wrote:

On Fri, Dec 14, 2001 at 10:48:36AM +0100, Luis Amigo wrote:

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)

How long did this query take? Was it over an hour?
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/

Terrorists can only take my life. Only my government can take my freedom.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

18sec
Regards