explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fDcp

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 2.980 ↓ 0.0 0 1

Unique (cost=6,843.70..6,865.95 rows=809 width=62) (actual time=2.980..2.980 rows=0 loops=1)

  • Buffers: shared hit=8 read=2
2. 0.044 2.979 ↓ 0.0 0 1

Sort (cost=6,843.70..6,845.73 rows=809 width=62) (actual time=2.979..2.979 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.fcode
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8 read=2
3. 0.002 2.935 ↓ 0.0 0 1

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

  • Buffers: shared hit=2 read=2
4. 2.933 2.933 ↓ 0.0 0 1

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

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

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

  • Index Cond: (geonameid = alternatename.geonameid)
Planning time : 1.200 ms
Execution time : 3.102 ms