explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SGer

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 222.864 ↓ 3.0 118 1

Sort (cost=43,746.09..43,746.19 rows=40 width=50) (actual time=222.859..222.864 rows=118 loops=1)

  • Sort Key: ((round((sum(((l.is_winner)::integer)::numeric) / (sum(1))::numeric), 4) * '100'::numeric)) DESC
  • Sort Method: quicksort Memory: 34kB
2. 0.000 222.818 ↓ 3.0 118 1

Finalize GroupAggregate (cost=43,710.90..43,745.02 rows=40 width=50) (actual time=222.498..222.818 rows=118 loops=1)

  • Group Key: h.hero_id
  • Filter: (sum(1) >= 1)
3. 26.355 227.384 ↓ 1.5 354 1

Gather Merge (cost=43,710.90..43,738.67 rows=238 width=50) (actual time=222.482..227.384 rows=354 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.066 201.029 ↑ 1.0 118 3 / 3

Sort (cost=42,710.88..42,711.18 rows=119 width=50) (actual time=201.023..201.029 rows=118 loops=3)

  • Sort Key: h.hero_id
  • Sort Method: quicksort Memory: 41kB
  • Worker 0: Sort Method: quicksort Memory: 41kB
  • Worker 1: Sort Method: quicksort Memory: 41kB
5. 2.291 200.963 ↑ 1.0 118 3 / 3

Partial HashAggregate (cost=42,705.29..42,706.78 rows=119 width=50) (actual time=200.918..200.963 rows=118 loops=3)

  • Group Key: h.hero_id
6. 60.121 198.672 ↑ 1.8 6,363 3 / 3

Parallel Hash Join (cost=16,751.56..42,504.70 rows=11,462 width=3) (actual time=71.738..198.672 rows=6,363 loops=3)

  • Hash Cond: ((h.match_id = l.match_id) AND (h.side = l.side))
7. 67.414 67.414 ↑ 1.3 479,379 3 / 3

Parallel Seq Scan on heroes h (cost=0.00..16,716.67 rows=599,248 width=12) (actual time=0.018..67.414 rows=479,379 loops=3)

  • Filter: (hero_id <> 72)
  • Rows Removed by Filter: 1,591
8. 0.780 71.137 ↑ 1.5 1,591 3 / 3

Parallel Hash (cost=16,716.67..16,716.67 rows=2,326 width=11) (actual time=71.137..71.137 rows=1,591 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 384kB
9. 70.357 70.357 ↑ 1.5 1,591 3 / 3

Parallel Seq Scan on heroes l (cost=0.00..16,716.67 rows=2,326 width=11) (actual time=0.188..70.357 rows=1,591 loops=3)

  • Filter: (hero_id = 72)
  • Rows Removed by Filter: 479,379
Planning time : 0.434 ms
Execution time : 227.812 ms