explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nokC : Composite Index

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

Bitmap Heap Scan on redcarpet (cost=4.34..7.78 rows=2 width=40) (actual time=0.086..0.099 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.058 0.058 ↑ 1.2 6 1

Bitmap Index Scan on composite (cost=0.00..4.34 rows=7 width=0) (actual time=0.058..0.058 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.972 ms
Execution time : 0.203 ms