"Sort (cost=37633.25..37688.71 rows=22187 width=37) (actual time=1491.610..1589.220 rows=50275 loops=1)" " Sort Key: localidad, cuenta" " -> Seq Scan on suscriptor (cost=636.63..36031.63 rows=22187 width=37) (actual time=103.608..726.218 rows=50275 loops=1)" " Filter: ((((status)::text = '0'::text) OR ((status)::text = '3'::text)) AND ((cod_ciclo)::text = '01'::text) AND ((suscriptor)::text = '1'::text) AND (NOT (hashed subplan)))" " SubPlan" " -> Index Scan using in_prefac_ano_mes on prefacturacion (cost=0.00..633.32 rows=1325 width=21) (actual time=27.565..72.155 rows=11100 loops=1)" " Index Cond: ((ano_mes)::text = '200701'::text)" " Filter: ((((descripcion)::text = '01'::text) OR ((descripcion)::text = '05'::text)) AND ((facturado)::text <> '2'::text))" "Total runtime: 1692.211 ms"