Limit (cost=0.28..0.82 rows=1 width=227) (actual time=1.248..1.249 rows=1 loops=1)
Output: geonameid, name, asciiname, alternatenames, latitude, longitude, feature_class, feature_code, country_code, cc2, admin1_code, admin2_code, admin3_code, admin4_code, population, elevation, dem, timezone, modification, geog, ((geog <-> '0101000020E610000000000000000037C00000000000804AC0'::geography))
-> Index Scan using geonames_geog_idx on raw.geonames (cost=0.28..103449.43 rows=192423 width=227) (actual time=1.247..1.247 rows=1 loops=1)
Output: geonameid, name, asciiname, alternatenames, latitude, longitude, feature_class, feature_code, country_code, cc2, admin1_code, admin2_code, admin3_code, admin4_code, population, elevation, dem, timezone, modification, geog, (geog <-> '0101000020E610000000000000000037C00000000000804AC0'::geography)
Order By: (geonames.geog <-> '0101000020E610000000000000000037C00000000000804AC0'::geography)
Planning Time: 14.145 ms
Execution Time: 1.330 ms