explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WSMx

Settings
# 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