explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C0DY : Without index

Settings
# exclusive inclusive rows x rows loops node
1. 0.124 0.124 ↓ 3.0 6 1

Seq Scan on redcarpet (cost=0.00..23.00 rows=2 width=40) (actual time=0.035..0.124 rows=6 loops=1)

  • Filter: ((timecrash >= '20:00:00'::time without time zone) AND (timecrash <= '20:30:00'::time without time zone) AND (('7922'::double precision * asin(sqrt(((sin(radians((('35.95956710652295'::double precision - lat1) / '2'::double precision))) ^ '2'::double precision) + ((cos(radians(lat1)) * '0.8094315853778711'::double precision) * (sin(radians((('-78.95570271414434'::double precision - long1) / '2'::double precision))) ^ '2'::double precision)))))) <= '10'::double precision))
  • Rows Removed by Filter: 314
Planning time : 0.974 ms
Execution time : 0.185 ms