explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mOTD

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 6,718.919 ↑ 1.1 13 1

Sort (cost=55,323.03..55,323.07 rows=14 width=33) (actual time=6,718.917..6,718.919 rows=13 loops=1)

  • Sort Key: (sum(st_area(st_intersection(cari.the_geom, lp.the_geom)))) DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=120229 read=10936
2. 3,939.118 6,718.883 ↑ 1.1 13 1

HashAggregate (cost=55,322.63..55,322.77 rows=14 width=33) (actual time=6,718.880..6,718.883 rows=13 loops=1)

  • Group Key: cari.leglabellevel1
  • Buffers: shared hit=120226 read=10936
3. 16.610 2,779.765 ↑ 9.7 18,083 1

Nested Loop (cost=8.24..49,638.93 rows=174,883 width=2,043) (actual time=3.830..2,779.765 rows=18,083 loops=1)

  • Buffers: shared hit=16164 read=10936
4. 0.536 1.157 ↑ 1.0 474 1

Bitmap Heap Scan on congdistrictsdicesimple50_2014 lp (cost=7.96..422.63 rows=474 width=961) (actual time=0.684..1.157 rows=474 loops=1)

  • Recheck Cond: (district = '02'::text)
  • Heap Blocks: exact=72
  • Buffers: shared hit=73 read=2
5. 0.621 0.621 ↑ 1.0 474 1

Bitmap Index Scan on ind_district_2014 (cost=0.00..7.84 rows=474 width=0) (actual time=0.621..0.621 rows=474 loops=1)

  • Index Cond: (district = '02'::text)
  • Buffers: shared hit=1 read=2
6. 2,761.998 2,761.998 ↓ 2.4 38 474

Index Scan using cari03wetlands_the_geom_geom_idx on cari03wetlands cari (cost=0.29..103.67 rows=16 width=1,082) (actual time=0.331..5.827 rows=38 loops=474)

  • Index Cond: (the_geom && lp.the_geom)
  • Filter: _st_intersects(the_geom, lp.the_geom)
  • Rows Removed by Filter: 5
  • Buffers: shared hit=16087 read=10934
Planning time : 4.760 ms
Execution time : 6,719.183 ms