explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Oa5h

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=62,156,708.42..70,363,454.35 rows=15,618,557 width=41) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Parallel Hash Semi Join (cost=62,155,708.42..68,800,598.65 rows=6,507,732 width=41) (actual rows= loops=)

  • Hash Cond: (tab.agg_rgs_id = pay.agg_rgs_id)
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on translated_ids tab (cost=0.00..5,600,415.33 rows=44,291,450 width=41) (actual rows= loops=)

  • Filter: ((translated_id_type)::text = 'P'::text)
4. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=62,041,104.73..62,041,104.73 rows=6,242,215 width=21) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=21,389,047.75..62,041,104.73 rows=6,242,215 width=21) (actual rows= loops=)

  • Hash Cond: (pay.game_round_id = rnd.id)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on game_payments pay (cost=0.00..31,900,776.53 rows=536,130,453 width=29) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=21,330,132.00..21,330,132.00 rows=3,591,020 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Index Scan using game_rounds_x1 on game_rounds rnd (cost=0.57..21,330,132.00 rows=3,591,020 width=8) (actual rows= loops=)