Sort  (cost=8957.36..8976.74 rows=7753 width=323) (actual
time=5898.935..6742.563 rows=96960 loops=1)
  Sort Key: def_parte.descripcion_parte
  Sort Method:  external merge  Disk: 34760kB
  ->  Hash Join  (cost=1826.16..8456.49 rows=7753 width=323) (actual
time=522.880..2586.672 rows=96960 loops=1)
        Hash Cond: ((def_transac.id_almacendestino =
def_localizaciondestino.id_almacen) AND (def_transac.id_localizaciondestino
= def_localizaciondestino.id_localizacion))
        ->  Hash Join  (cost=1815.33..7118.89 rows=83283 width=278) (actual
time=521.959..2183.164 rows=96960 loops=1)
              Hash Cond: (def_dtransac.id_parte = def_parte.id_parte)
              ->  Hash Join  (cost=1809.88..5968.30 rows=83283 width=244)
(actual time=521.360..1777.429 rows=96960 loops=1)
                    Hash Cond: (def_dtransac.id_transac =
def_transac.id_transac)
                    ->  Seq Scan on def_dtransac  (cost=0.00..2113.60
rows=96960 width=34) (actual time=0.034..706.677 rows=96960 loops=1)
                    ->  Hash  (cost=1601.94..1601.94 rows=16635 width=214)
(actual time=521.296..521.296 rows=19367 loops=1)
                          ->  Hash Join  (cost=20.21..1601.94 rows=16635
width=214) (actual time=2.001..428.736 rows=19367 loops=1)
                                Hash Cond: (def_transac.id_traninve =
def_traninve.id_traninve)
                                ->  Hash Join  (cost=18.36..1371.35
rows=16635 width=184) (actual time=1.844..351.284 rows=19367 loops=1)
                                      Hash Cond:
(def_transac.id_tiposervicio = def_tiposervicio.id_tiposervicio)
                                      ->  Hash Join  (cost=16.30..1140.57
rows=16635 width=167) (actual time=1.626..277.645 rows=19367 loops=1)
                                            Hash Cond:
(def_transac.id_almacendestino = def_almacendestino.id_almacen)
                                            ->  Hash Join
(cost=15.16..910.70 rows=16635 width=148) (actual time=1.516..209.798
rows=19367 loops=1)
                                                  Hash Cond:
((def_transac.id_almacenorigen = def_almacenorigen.id_almacen) AND
(def_transac.id_localizacionorigen =
def_localizacionorigen.id_localizacion))
                                                  ->  Seq Scan on
def_transac  (cost=0.00..556.67 rows=19367 width=84) (actual
time=0.031..84.543 rows=19367 loops=1)
                                                  ->  Hash
(cost=11.67..11.67 rows=233 width=76) (actual time=1.470..1.470 rows=233
loops=1)
                                                        ->  Hash Join
(cost=1.14..11.67 rows=233 width=76) (actual time=0.041..1.032 rows=233
loops=1)
                                                              Hash Cond:
(def_localizacionorigen.id_almacen = def_almacenorigen.id_almacen)
                                                              ->  Seq Scan
on def_localizacion def_localizacionorigen  (cost=0.00..7.33 rows=233
width=57) (actual time=0.004..0.334 rows=233 loops=1)
                                                              ->  Hash
(cost=1.06..1.06 rows=6 width=19) (actual time=0.024..0.024 rows=6 loops=1)
                                                                    ->  Seq
Scan on def_almacen def_almacenorigen  (cost=0.00..1.06 rows=6 width=19)
(actual time=0.002..0.011 rows=6 loops=1)
                                            ->  Hash  (cost=1.06..1.06
rows=6 width=19) (actual time=0.096..0.096 rows=6 loops=1)
                                                  ->  Seq Scan on
def_almacen def_almacendestino  (cost=0.00..1.06 rows=6 width=19) (actual
time=0.032..0.041 rows=6 loops=1)
                                      ->  Hash  (cost=1.47..1.47 rows=47
width=25) (actual time=0.206..0.206 rows=47 loops=1)
                                            ->  Seq Scan on def_tiposervicio
(cost=0.00..1.47 rows=47 width=25) (actual time=0.029..0.128 rows=47
loops=1)
                                ->  Hash  (cost=1.38..1.38 rows=38 width=34)
(actual time=0.146..0.146 rows=38 loops=1)
                                      ->  Seq Scan on def_traninve
(cost=0.00..1.38 rows=38 width=34) (actual time=0.032..0.086 rows=38
loops=1)
              ->  Hash  (cost=4.09..4.09 rows=109 width=38) (actual
time=0.585..0.585 rows=109 loops=1)
                    ->  Seq Scan on def_parte  (cost=0.00..4.09 rows=109
width=38) (actual time=0.055..0.360 rows=109 loops=1)
        ->  Hash  (cost=7.33..7.33 rows=233 width=57) (actual
time=0.889..0.889 rows=233 loops=1)
              ->  Seq Scan on def_localizacion def_localizaciondestino
(cost=0.00..7.33 rows=233 width=57) (actual time=0.060..0.498 rows=233
loops=1)
Total runtime: 6897.256 ms