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)
*/