explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WZlL

Settings
# exclusive inclusive rows x rows loops node
1. 382.723 382.723 ↓ 2.0 2 1

Index Scan using geo_location_idx on vehicles vehicle (cost=0.40..16.80 rows=1 width=183) (actual time=122.528..382.723 rows=2 loops=1)

  • Index Cond: (geo_location && '0101000020E610000000008073AC792340B16F6D29652F4A40'::geography)
  • Filter: ((NOT is_unlocked) AND ((state)::text = 'ACTIVE'::text) AND ('0101000020E610000000008073AC792340B16F6D29652F4A40'::geography && _st_expand(geo_location, '1179'::double precision)) AND _st_dwithin(geo_location, '0101000020E610000000008073AC792340B16F6D29652F4A40'::geography, '1179'::double precision, true))
  • Rows Removed by Filter: 209
  • Buffers: shared hit=290782
Planning time : 0.727 ms
Execution time : 382.779 ms