explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c1ae

Settings
# exclusive inclusive rows x rows loops node
1. 18,487.118 19,190.381 ↓ 0.0 0 1

Bitmap Heap Scan on cell_tower (cost=9,136.68..472,336.33 rows=68,583 width=56) (actual time=19,190.381..19,190.381 rows=0 loops=1)

  • Recheck Cond: (box(point(lat, lng), point(lat, lng)) && '(43.9209376191502088,-79.200860502043156),(43.6511415608497941,-79.5745763979568466)'::box)
  • Filter: (acos(LEAST(GREATEST((('-0.982895895955158361'::double precision * sin(radians(lat))) + (('0.721928850899719809'::double precision * cos(radians(lat))) * cos((radians(lng) - '-1.38557707259874929'::double precision)))), '-1'::double precision), '1'::double precision)) <= '0.0023544147631223305'::double precision)
  • Rows Removed by Filter: 76,273
  • Heap Blocks: exact=30,214
2. 703.263 703.263 ↑ 2.7 76,273 1

Bitmap Index Scan on cell_tower_box_gist_idx (cost=0.00..9,119.53 rows=205,748 width=0) (actual time=703.263..703.263 rows=76,273 loops=1)

  • Index Cond: (box(point(lat, lng), point(lat, lng)) && '(43.9209376191502088,-79.200860502043156),(43.6511415608497941,-79.5745763979568466)'::box)
Planning time : 6.044 ms
Execution time : 19,192.101 ms