explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rMwn

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 9,077.718 ↑ 1.0 1 1

Limit (cost=677,877.09..677,877.61 rows=1 width=16) (actual time=9,077.716..9,077.718 rows=1 loops=1)

  • Buffers: shared hit=35060
2. 16.085 9,077.714 ↑ 14,119.0 1 1

Result (cost=677,877.09..685,148.38 rows=14,119 width=16) (actual time=9,077.714..9,077.714 rows=1 loops=1)

  • Buffers: shared hit=35060
3. 1.756 9,061.629 ↑ 14,119.0 1 1

Sort (cost=677,877.09..677,912.39 rows=14,119 width=16,224) (actual time=9,061.629..9,061.629 rows=1 loops=1)

  • Sort Key: (st_distance(wkb_geometry, 0101000020E61000003A330BFE489954C05FD38382521A3B40::geometry))
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=35036
4. 9,059.063 9,059.873 ↑ 14.1 1,002 1

Bitmap Heap Scan on s_fld_haz_ar (cost=14,920.38..677,806.50 rows=14,119 width=16,224) (actual time=14.947..9,059.873 rows=1,002 loops=1)

  • Recheck Cond: ((wkb_geometry)::geography && 0101000020E61000003A330BFE489954C05FD38382521A3B40::geography)
  • Filter: (((fld_zone)::text = ANY ({A,A99,AE,AH,AO,V,VE}::text[])) AND (0101000020E61000003A330BFE489954C05FD38382521A3B40::geography && _st_expand((wkb_geometry)::geography, 4000::double precision)) AND _st_dwithin((wkb_geometry)::geography, 0101000020E61000003A330BFE489954C05FD38382521A3B40::geography, 4000::double precision, true))
  • Rows Removed by Filter: 1403
  • Heap Blocks: exact=1200
  • Buffers: shared hit=35036
5. 0.810 0.810 ↑ 232.4 2,405 1

Bitmap Index Scan on s_fld_haz_ar_wkb_geometry_geog_idx (cost=0.00..14,916.85 rows=558,992 width=0) (actual time=0.810..0.810 rows=2,405 loops=1)

  • Index Cond: ((wkb_geometry)::geography && 0101000020E61000003A330BFE489954C05FD38382521A3B40::geography)
  • Buffers: shared hit=47
Planning time : 0.223 ms
Execution time : 9,077.762 ms