explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iZWj

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 10,347.820 ↑ 20.0 1 1

Limit (cost=40,151.64..40,151.69 rows=20 width=1,515) (actual time=10,347.816..10,347.820 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.013 10,347.813 ↑ 241.0 1 1

Sort (cost=40,151.64..40,152.24 rows=241 width=1,515) (actual time=10,347.812..10,347.813 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. 10,313.246 10,347.800 ↑ 241.0 1 1

Bitmap Heap Scan on public.poi_nr_world_poi (cost=236.09..40,145.23 rows=241 width=1,515) (actual time=10,232.439..10,347.800 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.micode = 10,980,400)
  • Filter: (((poi_nr_world_poi.geometry)::geography && '0101000020E61000002D3E05C0788E2A4048A8195245B121C0'::geography) AND ('0101000020E61000002D3E05C0788E2A4048A8195245B121C0'::geography && _st_expand((poi_nr_world_poi.geometry)::geography, 16 (...)
  • Rows Removed by Filter: 155,299
4. 34.554 34.554 ↓ 8.6 155,300 1

Bitmap Index Scan on world_poi_idx1 (cost=0.00..236.03 rows=18,062 width=0) (actual time=34.554..34.554 rows=155,300 loops=1)

  • Index Cond: (poi_nr_world_poi.micode = 10,980,400)
Total runtime : 10,351.090 ms