explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aJ9u

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 10,932.464 ↑ 1.1 13 1

Sort (cost=26,545.50..26,545.53 rows=14 width=34) (actual time=10,932.464..10,932.464 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=320814
2. 9,235.866 10,932.449 ↑ 1.1 13 1

HashAggregate (cost=26,545.09..26,545.23 rows=14 width=34) (actual time=10,932.434..10,932.449 rows=13 loops=1)

  • Group Key: cari.leglabellevel1
  • Buffers: shared hit=320814
3. 36.030 1,696.583 ↑ 1.9 45,327 1

Nested Loop (cost=4.34..23,800.73 rows=84,442 width=2,064) (actual time=0.940..1,696.583 rows=45,327 loops=1)

  • Buffers: shared hit=172611
4. 0.269 0.303 ↑ 1.0 229 1

Bitmap Heap Scan on congdistrictsdicesimple50_2014 lp (cost=4.06..189.72 rows=229 width=961) (actual time=0.044..0.303 rows=229 loops=1)

  • Recheck Cond: (district = '03'::text)
  • Heap Blocks: exact=53
  • Buffers: shared hit=56
5. 0.034 0.034 ↑ 1.0 229 1

Bitmap Index Scan on ind_district_2014 (cost=0.00..4.00 rows=229 width=0) (actual time=0.034..0.034 rows=229 loops=1)

  • Index Cond: (district = '03'::text)
  • Buffers: shared hit=3
6. 1,660.250 1,660.250 ↓ 12.4 198 229

Index Scan using cari03wetlands_the_geom_geom_idx on cari03wetlands cari (cost=0.29..102.94 rows=16 width=1,103) (actual time=1.249..7.250 rows=198 loops=229)

  • Index Cond: (the_geom && lp.the_geom)
  • Filter: _st_intersects(the_geom, lp.the_geom)
  • Rows Removed by Filter: 12
  • Buffers: shared hit=172425
Planning time : 2.358 ms
Execution time : 10,932.607 ms