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?
Fri, 14 Dec 2001 10:48:36 +0100
Luis Amigo <lamigo@atc.unican.es>
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/
> Terrorists can only take my life. Only my government can take my freedom.

Fri, 14 Dec 2001 21:43:45 +1100
Martijn van Oosterhout <kleptog@svana.org>
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


Fri, 14 Dec 2001 13:32:11 +0100
Luis Amigo <lamigo@atc.unican.es>
Re: can someone explain that?