explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fjam

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 4,184.166 ↑ 1.1 13 1

Sort (cost=6,459,188.35..6,459,188.38 rows=14 width=33) (actual time=4,184.165..4,184.166 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=507,782
  • Functions: 68
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 24.235 ms, Inlining 617.954 ms, Optimization 1952.496 ms, Emission 1023.642 ms, Total 3618.327 ms
2. 0.000 4,184.150 ↑ 1.1 13 1

Finalize GroupAggregate (cost=6,459,180.96..6,459,188.08 rows=14 width=33) (actual time=4,183.990..4,184.150 rows=13 loops=1)

  • Group Key: cari.leglabellevel1
  • Buffers: shared hit=507,782
3. 89.891 4,228.405 ↓ 1.1 60 1

Gather Merge (cost=6,459,180.96..6,459,187.66 rows=56 width=33) (actual time=4,183.906..4,228.405 rows=60 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=2,483,977
4. 0.125 4,138.514 ↑ 1.2 12 5 / 5

Sort (cost=6,458,180.90..6,458,180.93 rows=14 width=33) (actual time=4,138.513..4,138.514 rows=12 loops=5)

  • Sort Key: cari.leglabellevel1
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
  • Worker 3: Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2,483,833
5. 675.732 4,138.389 ↑ 1.2 12 5 / 5

Partial HashAggregate (cost=6,458,180.49..6,458,180.63 rows=14 width=33) (actual time=4,138.386..4,138.389 rows=12 loops=5)

  • Group Key: cari.leglabellevel1
  • Buffers: shared hit=2,483,709
6. 1,109.686 3,462.657 ↑ 36.4 3,617 5 / 5

Nested Loop (cost=0.15..3,129,470.47 rows=131,804 width=2,052) (actual time=963.794..3,462.657 rows=3,617 loops=5)

  • Buffers: shared hit=2,418,961
7. 107.152 107.152 ↑ 1.3 93,576 5 / 5

Parallel Seq Scan on cari03wetlands cari (cost=0.00..172,762.28 rows=117,428 width=1,091) (actual time=0.032..107.152 rows=93,576 loops=5)

  • Buffers: shared hit=171,588
8. 2,245.819 2,245.819 ↓ 0.0 0 467,879 / 5

Index Scan using congdistrictsdicesimple50_2014_the_geom_gist on congdistrictsdicesimple50_2014 lp (cost=0.15..25.17 rows=1 width=961) (actual time=0.024..0.024 rows=0 loops=467,879)

  • Index Cond: (the_geom && cari.the_geom)
  • Filter: ((district = '02'::text) AND st_intersects(cari.the_geom, the_geom))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1,860,334
Execution time : 4,234.040 ms