Skip site navigation (1) Skip section navigation (2)

RE: Demora mi consulta

From: MIGUEL CANCHAS <mcanchas(at)tsr(dot)com(dot)pe>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: RE: Demora mi consulta
Date: 2008-03-11 14:34:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-es-ayuda
Hash Join  (cost=185752.78..187799.62 rows=45019 width=718)
  Hash Cond: (vihilos2.idhilo = mhilos.idhilo)
  ->  Hash Join  (cost=185712.22..186802.41 rows=45019 width=697)
        Hash Cond: (vihilos1.idprop = mclientes.idcliente)
        ->  Merge Left Join  (cost=185648.75..186119.93 rows=45019
              Merge Cond: ((vihilos2.itemvi = vsuma_egresos.itemvi) AND
(vihilos2.idvihilo = vsuma_egresos.idvihilo))
              ->  Sort  (cost=170265.05..170377.59 rows=45019 width=591)
                    Sort Key: vihilos2.itemvi, vihilos1.idvihilo
                    ->  Hash Join  (cost=2537.07..142775.47 rows=45019
                          Hash Cond: (vihilos2.idvihilo = vihilos1.idvihilo)
                          ->  Seq Scan on vihilos2  (cost=0.00..51525.81
rows=822681 width=377)
                          ->  Hash  (cost=1696.57..1696.57 rows=19640
                                ->  Hash Join  (cost=1.07..1696.57
rows=19640 width=214)
                                      Hash Cond: (vihilos1.idalmacen =
                                      ->  Seq Scan on vihilos1
(cost=0.00..1351.80 rows=39280 width=136)
                                      ->  Hash  (cost=1.03..1.03 rows=3
                                            ->  Seq Scan on malmacen
(cost=0.00..1.03 rows=3 width=90)
              ->  Sort  (cost=15383.70..15428.18 rows=17790 width=152)
                    Sort Key: vsuma_egresos.itemvi, vsuma_egresos.idvihilo
                    ->  Subquery Scan vsuma_egresos  (cost=0.00..12727.84
rows=17790 width=152)
                          ->  GroupAggregate  (cost=0.00..12549.94
rows=17790 width=51)
                                ->  Index Scan using vehilos2_idx1 on
vehilos2  (cost=0.00..11261.08 rows=78203 width=51)
        ->  Hash  (cost=44.32..44.32 rows=1532 width=32)
              ->  Seq Scan on mclientes  (cost=0.00..44.32 rows=1532
  ->  Hash  (cost=28.58..28.58 rows=958 width=29)
        ->  Seq Scan on mhilos  (cost=0.00..28.58 rows=958 width=29)


pgsql-es-ayuda by date

Next:From: Alvaro HerreraDate: 2008-03-11 14:36:02
Subject: Re: Demora mi consulta
Previous:From: Raul LapitzondoDate: 2008-03-11 14:26:10
Subject: Re: Funcion SQL mas lenta que un SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group