explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T7Bl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.041 ↓ 0.0 0 1

Unique (cost=6,843.70..6,867.97 rows=809 width=100) (actual time=0.041..0.041 rows=0 loops=1)

  • Buffers: shared hit=4
2. 0.016 0.041 ↓ 0.0 0 1

Sort (cost=6,843.70..6,845.73 rows=809 width=100) (actual time=0.041..0.041 rows=0 loops=1)

  • Sort Key: geoname.name, geoname.country, geoname.latitude, geoname.longitude, geoname.population, geoname.admin1, geoname.admin2, geoname.admin3, geoname.admin4, geoname.alternatenames, geoname.fcode
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4
3. 0.001 0.025 ↓ 0.0 0 1

Nested Loop (cost=0.99..6,804.63 rows=809 width=100) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=4
4. 0.024 0.024 ↓ 0.0 0 1

Index Scan using idx_alternatename_search on alternatename (cost=0.56..8.58 rows=809 width=4) (actual time=0.023..0.024 rows=0 loops=1)

  • Index Cond: (((alternatename)::text ~>=~ 'foo'::text) AND ((alternatename)::text ~<~ 'fop'::text))
  • Filter: ((alternatename)::text ~~ 'foo%'::text)
  • Buffers: shared hit=4
5. 0.000 0.000 ↓ 0.0 0

Index Scan using geoname_pkey on geoname (cost=0.43..8.40 rows=1 width=104) (never executed)

  • Index Cond: (geonameid = alternatename.geonameid)
Planning time : 0.771 ms
Execution time : 0.131 ms