explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0WH

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 17.572 ↑ 20.0 1 1

Limit (cost=10,533,778.32..10,533,778.37 rows=20 width=1,516) (actual time=17.568..17.572 rows=1 loops=1)

  • Output: name, name_alias, micode, feature_id, language_code, tel_num, fax_num, email, http, brandname, open_24h, formattedaddress, mainaddressline, addresslastline, placename, areaname1, areaname2, areaname3, areaname4, postcode1, postcode2, country, add (...)
2. 0.056 17.564 ↑ 244.0 1 1

Sort (cost=10,533,778.32..10,533,778.93 rows=244 width=1,516) (actual time=17.562..17.564 rows=1 loops=1)

  • Output: name, name_alias, micode, feature_id, language_code, tel_num, fax_num, email, http, brandname, open_24h, formattedaddress, mainaddressline, addresslastline, placename, areaname1, areaname2, areaname3, areaname4, postcode1, postcode2, countr (...)
  • Sort Key: ((_st_distance('0101000020E61000002D3E05C0788E2A4048A8195245B121C0'::geography, geography(poi_nr_world_poi.geometry), 0::double precision, false) / 1609.34::double precision))
  • Sort Method: quicksort Memory: 25kB
3. 4.755 17.508 ↑ 244.0 1 1

Bitmap Heap Scan on public.poi_nr_world_poi (cost=571,511.97..10,533,771.83 rows=244 width=1,516) (actual time=14.365..17.508 rows=1 loops=1)

  • Output: name, name_alias, micode, feature_id, language_code, tel_num, fax_num, email, http, brandname, open_24h, formattedaddress, mainaddressline, addresslastline, placename, areaname1, areaname2, areaname3, areaname4, postcode1, postcode2, (...)
  • Recheck Cond: ((poi_nr_world_poi.geometry)::geography && '0101000020E61000002D3E05C0788E2A4048A8195245B121C0'::geography)
  • Filter: ((poi_nr_world_poi.micode = 10,980,400) AND ('0101000020E61000002D3E05C0788E2A4048A8195245B121C0'::geography && _st_expand((poi_nr_world_poi.geometry)::geography, 1609.34::double precision)) AND _st_dwithin((poi_nr_world_poi.geometry):: (...)
  • Rows Removed by Filter: 5
4. 12.753 12.753 ↑ 3,581,052.5 6 1

Bitmap Index Scan on world_poi_idx4 (cost=0.00..571,511.91 rows=21,486,315 width=0) (actual time=12.753..12.753 rows=6 loops=1)

  • Index Cond: ((poi_nr_world_poi.geometry)::geography && '0101000020E61000002D3E05C0788E2A4048A8195245B121C0'::geography)
Total runtime : 17.848 ms