explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3qpz

Settings
# exclusive inclusive rows x rows loops node
1. 273.433 274.824 ↓ 0.0 0 1

Bitmap Heap Scan on flow_caches (cost=334.75..5,877.88 rows=460 width=432) (actual time=274.824..274.824 rows=0 loops=1)

  • Recheck Cond: (area_id = 6)
  • Filter: (_st_distance(location, '0101000020E610000017D9CEF7536313403BDF4F8D97DE4640'::geography, '0'::double precision, true) < '400'::double precision)
  • Rows Removed by Filter: 11,824
  • Heap Blocks: exact=688
2. 1.391 1.391 ↓ 8.6 11,824 1

Bitmap Index Scan on area_id (cost=0.00..334.64 rows=1,381 width=0) (actual time=1.391..1.391 rows=11,824 loops=1)

  • Index Cond: (area_id = 6)
Planning time : 0.935 ms
Execution time : 274.964 ms