Hola !!!
Bueno obviamente segui tus consejos y los resultados fueron los esperados.
La verdad que sabia que habia diferencia pero no pense que seria tan
abismal y que lo que estaba pasando era otra cosa que no podia ver.
:-) .
Muchas gracias.
Que tengan todos un buen dia
Hash Join (cost=2134.80..3743.13 rows=8 width=86) (actual
time=1786.45..2260.38 rows=41 loops=1)
Hash Cond: ("outer".numero = "inner".numexp)
Join Filter: (("outer".anio = "inner".anioexp) AND ("inner".extexp =
"outer".extension))
-> Seq Scan on e_expediente (cost=0.00..1563.80 rows=8749 width=60)
(actual time=0.34..455.41 rows=3430 loops=1)
Filter: (estado = 'recibido'::character varying)
-> Hash (cost=2134.72..2134.72 rows=29 width=26) (actual
time=1778.67..1778.67 rows=0 loops=1)
-> Hash Join (cost=1235.06..2134.72 rows=29 width=26) (actual
time=788.77..1777.92 rows=72 loops=1)
Hash Cond: ("outer".codusuarioi = "inner".idusuario)
-> Merge Join (cost=1228.66..2122.54 rows=1085 width=22)
(actual time=764.28..1747.30 rows=4055 loops=1)
Merge Cond: ("outer".idpase = "inner".r)
-> Index Scan using idpase_e_pase_key on e_pase
p (cost=0.00..847.78 rows=10846 width=18) (actual time=0.86..762.49
rows=10961 loops=1)
-> Sort (cost=1228.66..1231.37 rows=1085 width=14)
(actual time=762.87..775.93 rows=4055 loops=1)
Sort Key: j.r
-> Subquery Scan j (cost=1038.41..1173.98
rows=1085 width=14) (actual time=379.08..710.13 rows=4055 loops=1)
-> Aggregate (cost=1038.41..1173.98
rows=1085 width=14) (actual time=379.06..673.10 rows=4055 loops=1)
-> Group (cost=1038.41..1146.87
rows=10846 width=14) (actual time=378.94..576.72 rows=10961 loops=1)
-> Sort
(cost=1038.41..1065.52 rows=10846 width=14) (actual time=378.89..409.18
rows=10961 loops=1)
Sort Key: numexp,
anioexp, extexp
-> Seq Scan on
e_pase (cost=0.00..311.46 rows=10846 width=14) (actual time=0.21..196.74
rows=10961 loops=1)
-> Hash (cost=6.39..6.39 rows=3 width=4) (actual
time=1.84..1.84 rows=0 loops=1)
-> Seq Scan on e_usuario u (cost=0.00..6.39 rows=3
width=4) (actual time=0.67..1.76 rows=3 loops=1)
Filter: (coddep = 40)
Total runtime: 2273.54 msec
(23 rows)