pgimeno

EXPLAIN ANALYZE  SELECT L.ID, L.PROVINCIA,    L.NOMBRE, L.CP  FROM LOCALIDADES L  ORDER BY L.NOMBRE;/*                                                                         QUERY PLAN------------------------------------------------------------------------------------------------------------------------------------------------------------ Index Scan using i_localidades_nombre_provincia on localidades l  (cost=0.00..4420.53 rows=59177 width=36) (actual time=0.187..110.994 rows=59177 loops=1) Total runtime: 171.793 ms(2 filas)*/EXPLAIN ANALYZE  SELECT L.ID, L.PROVINCIA,   L.NOMBRE, L.CP, P.NOMBRE  FROM LOCALIDADES L   INNER JOIN PROVINCIAS P    ON P.ID = L.PROVINCIA  ORDER BY L.NOMBRE;/*                                                           QUERY PLAN-------------------------------------------------------------------------------------------------------------------------------- Sort  (cost=10917.24..11065.18 rows=59177 width=129) (actual time=634.545..800.236 rows=59177 loops=1)   Sort Key: l.nombre   ->  Hash Join  (cost=2.19..1977.65 rows=59177 width=129) (actual time=0.241..237.299 rows=59177 loops=1)         Hash Cond: (l.provincia = p.id)         ->  Seq Scan on localidades l  (cost=0.00..1161.77 rows=59177 width=36) (actual time=0.017..81.990 rows=59177 loops=1)         ->  Hash  (cost=1.53..1.53 rows=53 width=97) (actual time=0.163..0.163 rows=53 loops=1)               ->  Seq Scan on provincias p  (cost=0.00..1.53 rows=53 width=97) (actual time=0.013..0.080 rows=53 loops=1) Total runtime: 862.770 ms(8 filas)*/