explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FTej

Settings
# exclusive inclusive rows x rows loops node
1. 117.054 713.556 ↑ 235.1 201,107 1

Gather Merge (cost=8,868,505.37..14,306,697.82 rows=47,288,630 width=84) (actual time=596.345..713.556 rows=201,107 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 116.612 596.502 ↑ 470.3 100,554 2 / 2

Sort (cost=8,867,505.36..8,985,726.93 rows=47,288,630 width=84) (actual time=582.930..596.502 rows=100,554 loops=2)

  • Sort Key: b.bet_id, s.selection_id
  • Sort Method: external merge Disk: 11,384kB
  • Worker 0: Sort Method: external merge Disk: 9,888kB
3. 24.176 479.890 ↑ 470.3 100,554 2 / 2

Merge Left Join (cost=8.51..188,637.11 rows=47,288,630 width=84) (actual time=0.127..479.890 rows=100,554 loops=2)

  • Merge Cond: (b.bet_id = m.bet_id)
  • Join Filter: ((b.partition_id = m.partition_id) AND (s.selection_id = m.selection_id))
4. 41.509 455.702 ↑ 470.3 100,554 2 / 2

Nested Loop Left Join (cost=0.84..32,576.96 rows=47,288,630 width=72) (actual time=0.113..455.702 rows=100,554 loops=2)

5. 52.663 52.663 ↑ 1.2 40,170 2 / 2

Parallel Index Scan using bet_odds_cache_p01_pkey on bet_odds_cache_p01 b (cost=0.42..4,474.61 rows=47,162 width=59) (actual time=0.023..52.663 rows=40,170 loops=2)

  • Index Cond: (partition_id = 1)
6. 361.530 361.530 ↑ 1.0 3 80,340 / 2

Index Scan using bet_odds_selection_cache_p01_pkey on bet_odds_selection_cache_p01 s (cost=0.42..0.57 rows=3 width=23) (actual time=0.007..0.009 rows=3 loops=80,340)

  • Index Cond: ((partition_id = b.partition_id) AND (partition_id = 1) AND (bet_id = b.bet_id))
7. 0.005 0.012 ↓ 0.0 0 2 / 2

Sort (cost=7.67..7.69 rows=8 width=26) (actual time=0.012..0.012 rows=0 loops=2)

  • Sort Key: m.bet_id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
8. 0.002 0.007 ↓ 0.0 0 2 / 2

Bitmap Heap Scan on live_to_prematch_cache_p01 m (cost=1.31..7.55 rows=8 width=26) (actual time=0.007..0.007 rows=0 loops=2)

  • Recheck Cond: (partition_id = 1)
9. 0.005 0.005 ↓ 0.0 0 2 / 2

Bitmap Index Scan on live_to_prematch_cache_p01_pkey (cost=0.00..1.31 rows=8 width=0) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: (partition_id = 1)
Planning time : 0.427 ms
Execution time : 747.663 ms