explain.depesz.com

PostgreSQL's explain analyze made readable

Result: loow

Settings
# exclusive inclusive rows x rows loops node
1. 3,302.634 14,719.783 ↓ 1.2 5,622,019 1

Planning Time: 0.988 msGather Merge (cost=535,852.42..1,082,472.75 rows=4,684,990 width=84) (actual time=10,984.407..14,719.783 rows=5,622,019 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 3,271.561 11,417.149 ↑ 1.2 1,874,006 3 / 3

Sort (cost=534,852.39..540,708.63 rows=2,342,495 width=84) (actual time=10,931.800..11,417.149 rows=1,874,006 loops=3)

  • Worker 1: Sort Method: external merge Disk: 199,120kB
  • Worker 0: Sort Method: external merge Disk: 198,528kB
  • Sort Method: external merge Disk: 198,360kB
  • Sort Key: b.bet_id, s.selection_id
3. 1,115.152 8,145.588 ↑ 1.2 1,874,006 3 / 3

Parallel Hash Left Join (cost=131,227.35..221,365.59 rows=2,342,495 width=84) (actual time=4,366.462..8,145.588 rows=1,874,006 loops=3)

  • Hash Cond: ((b.partition_id = m.partition_id) AND (b.bet_id = m.bet_id) AND (s.selection_id = m.selection_id))
4. 6,873.901 6,873.901 ↑ 1.2 1,874,006 3 / 3

Parallel Hash Left Join (cost=119,483.61..182,545.74 rows=2,342,495 width=72) (actual time=4,205.279..6,873.901 rows=1,874,006 loops=3)

5. 0.000 156.535 ↑ 1.2 187,887 3 / 3

Parallel Hash (cost=7,633.73..7,633.73 rows=234,858 width=26) (actual time=156.535..156.535 rows=187,887 loops=3)

  • Hash Cond: ((b.partition_id = s.partition_id) AND (b.bet_id = s.bet_id))
  • Buckets: 1,048,576 Batches: 1 Memory Usage: 43,520kB
6. 63.964 63.964 ↑ 1.2 187,887 3 / 3

Parallel Seq Scan on live_to_prematch_cache_p05 m (cost=0.00..7,633.73 rows=234,858 width=26) (actual time=0.019..63.964 rows=187,887 loops=3)

7. 781.395 781.395 ↑ 1.2 416,667 3 / 3

Parallel Seq Scan on bet_odds_cache_p05 b (cost=0.00..23,177.42 rows=520,833 width=59) (actual time=0.288..781.395 rows=416,667 loops=3)

8. 720.378 3,122.289 ↑ 1.2 1,874,006 3 / 3

Parallel Hash (cost=70,620.18..70,620.18 rows=2,342,495 width=23) (actual time=3,122.289..3,122.289 rows=1,874,006 loops=3)

  • Filter: (partition_id = 5)
  • Filter: (partition_id = 5)
  • Buckets: 524,288 Batches: 32 Memory Usage: 15,232kB
9. 2,401.911 2,401.911 ↑ 1.2 1,874,006 3 / 3

Parallel Seq Scan on bet_odds_selection_cache_p05 s (cost=0.00..70,620.18 rows=2,342,495 width=23) (actual time=1.466..2,401.911 rows=1,874,006 loops=3)

  • Filter: (partition_id = 5)
Execution time : 15,880.166 ms