#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	1.249	↑ 1.0	1	1	→ 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))
2.	1.247	1.247	↑ 192,423.0	1	1	→ Index Scan using geonames_geog_idx on raw.geonames (cost=0.28..103,449.43 rows=192,423 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

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

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	1.247 ms	99.8 %
Limit	1	0.002 ms	0.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
raw.geonames	1	1.247 ms	99.8 %
Index Scan	1	1.247 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WSMx

Color mode:

Visible columns:

Per node type stats

Per table stats