explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fBjU : Distance 10 km

Settings
# exclusive inclusive rows x rows loops node
1. 4.577 4.577 ↑ 2.8 736 1

Seq Scan on venue (cost=0.00..348.09 rows=2,031 width=251) (actual time=0.068..4.577 rows=736 loops=1)

  • Filter: (('(2.351837,48.863615)'::point <@> point((longitude)::double precision, (latitude)::double precision)) < '10'::double precision)
  • Rows Removed by Filter: 5357
Planning time : 1.561 ms
Execution time : 7.058 ms