Sort  (cost=12133.56..12152.94 rows=7753 width=323) (actual
time=6273.053..7088.678 rows=96960 loops=1)
  Sort Key: def_parte.descripcion_parte
  Sort Method:  external merge  Disk: 34792kB
  ->  Hash Join  (cost=2314.16..10463.69 rows=7753 width=323) (actual
time=436.588..2076.630 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=2303.33..9126.09 rows=83283 width=278) (actual
time=435.762..1668.556 rows=96960 loops=1)
              Hash Cond: (def_dtransac.id_parte = def_parte.id_parte)
              ->  Hash Join  (cost=2297.88..7975.50 rows=83283 width=244)
(actual time=435.404..1281.980 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.005..166.602 rows=96960 loops=1)
                    ->  Hash  (cost=1601.94..1601.94 rows=16635 width=214)
(actual time=431.639..431.639 rows=19367 loops=1)
                          ->  Hash Join  (cost=20.21..1601.94 rows=16635
width=214) (actual time=1.856..339.760 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.727..267.421 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.570..198.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.535..124.980
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.005..33.168 rows=19367 loops=1)
                                                  ->  Hash
(cost=11.67..11.67 rows=233 width=76) (actual time=1.517..1.517 rows=233
loops=1)
                                                        ->  Hash Join
(cost=1.14..11.67 rows=233 width=76) (actual time=0.038..1.102 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.003..0.341 rows=233 loops=1)
                                                              ->  Hash
(cost=1.06..1.06 rows=6 width=19) (actual time=0.023..0.023 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.010 rows=6 loops=1)
                                            ->  Hash  (cost=1.06..1.06
rows=6 width=19) (actual time=0.025..0.025 rows=6 loops=1)
                                                  ->  Seq Scan on
def_almacen def_almacendestino  (cost=0.00..1.06 rows=6 width=19) (actual
time=0.004..0.012 rows=6 loops=1)
                                      ->  Hash  (cost=1.47..1.47 rows=47
width=25) (actual time=0.147..0.147 rows=47 loops=1)
                                            ->  Seq Scan on def_tiposervicio
(cost=0.00..1.47 rows=47 width=25) (actual time=0.004..0.070 rows=47
loops=1)
                                ->  Hash  (cost=1.38..1.38 rows=38 width=34)
(actual time=0.118..0.118 rows=38 loops=1)
                                      ->  Seq Scan on def_traninve
(cost=0.00..1.38 rows=38 width=34) (actual time=0.005..0.058 rows=38
loops=1)
              ->  Hash  (cost=4.09..4.09 rows=109 width=38) (actual
time=0.344..0.344 rows=109 loops=1)
                    ->  Seq Scan on def_parte  (cost=0.00..4.09 rows=109
width=38) (actual time=0.005..0.165 rows=109 loops=1)
        ->  Hash  (cost=7.33..7.33 rows=233 width=57) (actual
time=0.810..0.810 rows=233 loops=1)
              ->  Seq Scan on def_localizacion def_localizaciondestino
(cost=0.00..7.33 rows=233 width=57) (actual time=0.013..0.356 rows=233
loops=1)
Total runtime: 7283.938 ms