"Hash Join (cost=185752.78..187799.62 rows=45019 width=718) (actual
time=31684.822..32254.666 rows=52319 loops=1)"
" Hash Cond: (vihilos2.idhilo = mhilos.idhilo)"
" -> Hash Join (cost=185712.22..186802.41 rows=45019 width=697) (actual
time=31683.393..32075.793 rows=53162 loops=1)"
" Hash Cond: (vihilos1.idprop = mclientes.idcliente)"
" -> Merge Left Join (cost=185648.75..186119.93 rows=45019
width=673) (actual time=31681.345..32001.075 rows=53359 loops=1)"
" Merge Cond: ((vihilos2.itemvi = vsuma_egresos.itemvi) AND
(vihilos2.idvihilo = vsuma_egresos.idvihilo))"
" -> Sort (cost=170265.05..170377.59 rows=45019 width=591)
(actual time=13857.876..13989.097 rows=53359 loops=1)"
" Sort Key: vihilos2.itemvi, vihilos1.idvihilo"
" -> Hash Join (cost=2537.07..142775.47 rows=45019
width=591) (actual time=9897.396..12466.461 rows=53359 loops=1)"
" Hash Cond: (vihilos2.idvihilo =
vihilos1.idvihilo)"
" -> Seq Scan on vihilos2 (cost=0.00..51525.81
rows=822681 width=377) (actual time=9286.709..9568.051 rows=53428 loops=1)"
" -> Hash (cost=1696.57..1696.57 rows=19640
width=214) (actual time=609.369..609.369 rows=39239 loops=1)"
" -> Hash Join (cost=1.07..1696.57
rows=19640 width=214) (actual time=15.039..538.578 rows=39239 loops=1)"
" Hash Cond: (vihilos1.idalmacen =
malmacen.idalmacen)"
" -> Seq Scan on vihilos1
(cost=0.00..1351.80 rows=39280 width=136) (actual time=14.957..487.212
rows=39280 loops=1)"
" -> Hash (cost=1.03..1.03 rows=3
width=90) (actual time=0.049..0.049 rows=3 loops=1)"
" -> Seq Scan on malmacen
(cost=0.00..1.03 rows=3 width=90) (actual time=0.027..0.031 rows=3 loops=1)"
" -> Sort (cost=15383.70..15428.18 rows=17790 width=152)
(actual time=17823.437..17855.135 rows=50255 loops=1)"
" Sort Key: vsuma_egresos.itemvi, vsuma_egresos.idvihilo"
" -> Subquery Scan vsuma_egresos (cost=0.00..12727.84
rows=17790 width=152) (actual time=1736.676..17381.784 rows=49948 loops=1)"
" -> GroupAggregate (cost=0.00..12549.94
rows=17790 width=51) (actual time=1736.672..17344.530 rows=49948 loops=1)"
" -> Index Scan using vehilos2_idx1 on
vehilos2 (cost=0.00..11261.08 rows=78203 width=51) (actual
time=109.888..17159.513 rows=78203 loops=1)"
" -> Hash (cost=44.32..44.32 rows=1532 width=32) (actual
time=2.030..2.030 rows=1532 loops=1)"
" -> Seq Scan on mclientes (cost=0.00..44.32 rows=1532
width=32) (actual time=0.021..1.093 rows=1532 loops=1)"
" -> Hash (cost=28.58..28.58 rows=958 width=29) (actual time=1.373..1.373
rows=958 loops=1)"
" -> Seq Scan on mhilos (cost=0.00..28.58 rows=958 width=29)
(actual time=0.028..0.751 rows=958 loops=1)"
"Total runtime: 32272.397 ms"