Sort  (cost=8957.36..8976.74 rows=7753 width=323) (actual
time=5896.823..6664.020 rows=96960 loops=1)
  Sort Key: def_parte.descripcion_parte
  Sort Method:  external sort  Disk: 34800kB
  ->  Hash Join  (cost=1826.16..8456.49 rows=7753 width=323) (actual
time=420.360..1836.670 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=419.594..1448.205 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=419.204..1072.918 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.009..160.501 rows=96960 loops=1)
                    ->  Hash  (cost=1601.94..1601.94 rows=16635 width=214)
(actual time=419.128..419.128 rows=19367 loops=1)
                          ->  Hash Join  (cost=20.21..1601.94 rows=16635
width=214) (actual time=2.202..357.511 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=2.059..281.524 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.654..203.674 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.609..133.452
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.008..41.066 rows=19367 loops=1)
                                                  ->  Hash
(cost=11.67..11.67 rows=233 width=76) (actual time=1.583..1.583 rows=233
loops=1)
                                                        ->  Hash Join
(cost=1.14..11.67 rows=233 width=76) (actual time=0.048..1.167 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.005..0.331 rows=233 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_almacenorigen  (cost=0.00..1.06 rows=6 width=19)
(actual time=0.003..0.011 rows=6 loops=1)
                                            ->  Hash  (cost=1.06..1.06
rows=6 width=19) (actual time=0.028..0.028 rows=6 loops=1)
                                                  ->  Seq Scan on
def_almacen def_almacendestino  (cost=0.00..1.06 rows=6 width=19) (actual
time=0.005..0.013 rows=6 loops=1)
                                      ->  Hash  (cost=1.47..1.47 rows=47
width=25) (actual time=0.390..0.390 rows=47 loops=1)
                                            ->  Seq Scan on def_tiposervicio
(cost=0.00..1.47 rows=47 width=25) (actual time=0.006..0.311 rows=47
loops=1)
                                ->  Hash  (cost=1.38..1.38 rows=38 width=34)
(actual time=0.127..0.127 rows=38 loops=1)
                                      ->  Seq Scan on def_traninve
(cost=0.00..1.38 rows=38 width=34) (actual time=0.006..0.061 rows=38
loops=1)
              ->  Hash  (cost=4.09..4.09 rows=109 width=38) (actual
time=0.375..0.375 rows=109 loops=1)
                    ->  Seq Scan on def_parte  (cost=0.00..4.09 rows=109
width=38) (actual time=0.006..0.169 rows=109 loops=1)
        ->  Hash  (cost=7.33..7.33 rows=233 width=57) (actual
time=0.747..0.747 rows=233 loops=1)
              ->  Seq Scan on def_localizacion def_localizaciondestino
(cost=0.00..7.33 rows=233 width=57) (actual time=0.014..0.380 rows=233
loops=1)
Total runtime: 6829.172 ms