explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lwqS : Simple Index

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

Bitmap Heap Scan on redcarpet (cost=4.22..7.66 rows=2 width=40) (actual time=0.092..0.104 rows=6 loops=1)

  • Recheck Cond: ((timecrash >= '20:00:00'::time without time zone) AND (timecrash <= '20:30:00'::time without time zone))
  • Filter: (('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)
  • Heap Blocks: exact=2
2. 0.061 0.061 ↑ 1.2 6 1

Bitmap Index Scan on timecrash (cost=0.00..4.22 rows=7 width=0) (actual time=0.061..0.061 rows=6 loops=1)

  • Index Cond: ((timecrash >= '20:00:00'::time without time zone) AND (timecrash <= '20:30:00'::time without time zone))
Planning time : 0.979 ms
Execution time : 0.200 ms