# exclusive inclusive rows x rows loops node
1. 0.000 5,107.820 ↑ 1.0 2 1

Finalize GroupAggregate (cost=4,017,774.18..8,151,644.98 rows=2 width=10) (actual time=5,107.816..5,107.820 rows=2 loops=1)

  • Group Key: s.legcode
  • Buffers: shared hit=503583
  • Functions: 68
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 24.947 ms, Inlining 634.484 ms, Optimization 2063.643 ms, Emission 700.285 ms, Total 3423.359 ms
2. 162.185 5,138.677 ↓ 1.2 10 1

Gather Merge (cost=4,017,774.18..8,151,644.92 rows=8 width=10) (actual time=5,011.219..5,138.677 rows=10 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=2442311
3. 1,100.951 4,976.492 ↑ 1.0 2 5

Partial GroupAggregate (cost=4,016,774.13..8,150,643.91 rows=2 width=10) (actual time=4,880.459..4,976.492 rows=2 loops=5)

  • Group Key: s.legcode
  • Buffers: shared hit=2442311
4. 30.565 3,875.541 ↑ 11.2 14,610 5

Sort (cost=4,016,774.13..4,017,183.30 rows=163,669 width=1,497) (actual time=3,869.839..3,875.541 rows=14,610 loops=5)

  • Sort Key: s.legcode
  • Sort Method: quicksort Memory: 15442kB
  • Worker 0: Sort Method: quicksort Memory: 16413kB
  • Worker 1: Sort Method: quicksort Memory: 16115kB
  • Worker 2: Sort Method: quicksort Memory: 16409kB
  • Worker 3: Sort Method: quicksort Memory: 16131kB
  • Buffers: shared hit=2442235
5. 827.353 3,844.976 ↑ 11.2 14,610 5

Nested Loop (cost=0.15..3,940,015.60 rows=163,669 width=1,497) (actual time=1,060.468..3,844.976 rows=14,610 loops=5)

  • Buffers: shared hit=2442203
6. 70.668 70.668 ↑ 1.2 122,790 5

Parallel Seq Scan on cari03streams s (cost=0.00..78,377.70 rows=153,370 width=536) (actual time=0.028..70.668 rows=122,790 loops=5)

  • Buffers: shared hit=76844
7. 2,946.955 2,946.955 ↓ 0.0 0 613,949

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

  • Index Cond: (the_geom && s.the_geom)
  • Filter: ((district = '02'::text) AND st_intersects(s.the_geom, the_geom))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=2343939
Planning time : 2.567 ms
Execution time : 5,145.232 ms