QUERY PLAN Sort (cost=1117.66..1117.69 rows=12 width=381) (actual time=140.087..140.087 rows=4 loops=1) Sort Key: rdocumento.rdocumento -> Hash Join (cost=68.68..1117.44 rows=12 width=381) (actual time=10.728..140.061 rows=4 loops=1) Hash Cond: ("outer".rtipocasa = "inner".rtipocasa) -> Merge Join (cost=67.14..1115.70 rows=16 width=358) (actual time=10.553..139.816 rows=4 loops=1) Merge Cond: ("outer".restadopro = "inner".restadopro) Join Filter: ("inner".rpropietario = "outer".rpropietario) -> Nested Loop (cost=0.00..25952.23 rows=30 width=336) (actual time=7.891..131.836 rows=5 loops=1) -> Index Scan using restadopro_pk on restadopro (cost=0.00..3.02 rows=2 width=15) (actual time=0.023..0.030 rows=2 loops=1) -> Nested Loop (cost=0.00..12974.45 rows=15 width=321) (actual time=7.795..65.847 rows=2 loops=2) Join Filter: ("outer".restadocasa = "inner".restadocasa) -> Nested Loop (cost=0.00..12957.76 rows=15 width=312) (actual time=7.766..65.760 rows=2 loops=2) Join Filter: ("outer".restadodoc = "inner".restadodoc) -> Nested Loop (cost=0.00..12941.41 rows=15 width=311) (actual time=7.738..65.678 rows=2 loops=2) -> Seq Scan on lzempresa (cost=0.00..2.77 rows=1 width=104) (actual time=0.011..0.038 rows=1 loops=2) Filter: (46 = lzempresa) -> Nested Loop (cost=0.00..12938.49 rows=15 width=207) (actual time=7.708..65.594 rows=2 loops=2) Join Filter: ("outer".lzmoneda = "inner".lzmoneda) -> Nested Loop (cost=0.00..12922.81 rows=15 width=194) (actual time=7.683..65.533 rows=2 loops=2) -> Seq Scan on rparametro (cost=0.00..48.23 rows=1 width=28) (actual time=0.127..0.806 rows=1 loops=2) Filter: ((restadopar = 1) AND (964 = rcasa)) -> Nested Loop (cost=0.00..12874.43 rows=15 width=174) (actual time=7.539..64.688 rows=2 loops=2) Join Filter: (("inner".lzmoneda = "outer".lzmoneda) AND ("inner".rtipodoc = "outer".rtipodoc)) -> Nested Loop Left Join (cost=0.00..12305.81 rows=15 width=97) (actual time=7.120..60.076 rows=2 loops=2) Join Filter: ("outer".lzmes = "inner".lzmes) -> Nested Loop Left Join (cost=0.00..12280.01 rows=15 width=81) (actual time=7.103..59.948 rows=2 loops=2) Join Filter: (("outer".rtipopago = "inner".rtipopago) AND ("outer".rclasepago = "inner".rclasepago) AND ("outer".lzempresa = "inner".lzempresa)) -> Nested Loop Left Join (cost=0.00..12246.45 rows=15 width=80) (actual time=7.075..59.695 rows=2 loops=2) Join Filter: (("inner".rdocumento = "outer".rdocumento) AND ("inner".lzempresa = "outer".lzempresa) AND ("inner".rtipodoc = "outer".rtipodoc)) Filter: (("inner".rclasepago = 2) OR ("outer".rtipodoc = 3) OR ("outer".rtipodoc = 2)) -> Seq Scan on rdocumento (cost=0.00..441.30 rows=15 width=44) (actual time=3.059..9.848 rows=2 loops=2) Filter: ((restadodoc <> 1) AND (restadodoc <> 4) AND (964 = rcasa) AND (46 = lzempresa)) -> Seq Scan on rdetalled (cost=0.00..359.86 rows=17086 width=44) (actual time=0.004..11.766 rows=14251 loops=5) -> Seq Scan on rtipopago (cost=0.00..1.45 rows=45 width=25) (actual time=0.006..0.062 rows=37 loops=5) -> Seq Scan on lzmes (cost=0.00..1.32 rows=32 width=24) (actual time=0.003..0.024 rows=26 loops=5) -> Nested Loop (cost=0.00..37.82 rows=6 width=93) (actual time=0.399..1.822 rows=5 loops=5) Join Filter: ("outer".rsector = "inner".rsector) -> Index Scan using rcasa_pk on rcasa (cost=0.00..5.28 rows=1 width=60) (actual time=0.024..0.026 rows=1 loops=5) Index Cond: (rcasa = 964) Filter: (46 = lzempresa) -> Nested Loop (cost=0.00..28.11 rows=354 width=45) (actual time=0.046..1.586 rows=290 loops=5) -> Index Scan using rcaspro_pk on rcaspro (cost=0.00..5.67 rows=1 width=12) (actual time=0.014..0.017 rows=1 loops=5) Index Cond: (964 = rcasa) Filter: (46 = lzempresa) -> Nested Loop (cost=0.00..18.91 rows=354 width=33) (actual time=0.024..0.968 rows=290 loops=5) -> Nested Loop (cost=0.00..3.14 rows=6 width=19) (actual time=0.012..0.027 rows=5 loops=5) -> Seq Scan on lzmoneda lzmoneda_1 (cost=0.00..1.02 rows=2 width=9) (actual time=0.003..0.005 rows=2 loops=5) -> Seq Scan on rtipodoc (cost=0.00..1.03 rows=3 width=10) (actual time=0.002..0.005 rows=3 loops=9) -> Seq Scan on rsector (cost=0.00..2.04 rows=59 width=14) (actual time=0.004..0.089 rows=58 loops=25) Filter: (46 = lzempresa) -> Seq Scan on lzmoneda (cost=0.00..1.02 rows=2 width=21) (actual time=0.002..0.003 rows=2 loops=5) -> Seq Scan on restadodoc (cost=0.00..1.04 rows=4 width=9) (actual time=0.002..0.006 rows=4 loops=5) -> Seq Scan on restadocasa (cost=0.00..1.05 rows=5 width=17) (actual time=0.003..0.007 rows=5 loops=5) -> Sort (cost=67.14..68.88 rows=699 width=46) (actual time=2.590..3.326 rows=2789 loops=1) Sort Key: rpropietario.restadopro -> Seq Scan on rpropietario (cost=0.00..34.11 rows=699 width=46) (actual time=0.019..1.786 rows=698 loops=1) Filter: (lzempresa = 46) -> Hash (cost=1.48..1.48 rows=27 width=39) (actual time=0.100..0.100 rows=0 loops=1) -> Seq Scan on rtipocasa (cost=0.00..1.48 rows=27 width=39) (actual time=0.019..0.073 rows=26 loops=1) Filter: (46 = lzempresa) Total runtime: 140.858 ms