explain.depesz.com

PostgreSQL's explain analyze made readable

Result: esBt

Settings

Optimization(s) for this plan:

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

GroupAggregate (cost=18,902,920.98..19,012,742.85 rows=10 width=732) (actual rows= loops=)

  • Group Key: mpd.id
2. 0.000 0.000 ↓ 0.0

Sort (cost=18,902,920.98..18,924,885.31 rows=8,785,734 width=700) (actual rows= loops=)

  • Sort Key: mpd.id
3. 0.000 0.000 ↓ 0.0

Gather (cost=4,205,032.95..9,691,608.15 rows=8,785,734 width=700) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=4,204,032.95..8,812,034.75 rows=3,660,722 width=700) (actual rows= loops=)

  • Hash Cond: (dc.deck_main_id = dmpt.deck_main_id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,203,410.61..8,623,581.09 rows=3,660,722 width=692) (actual rows= loops=)

  • Hash Cond: (mp.match_id = m.match_id)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,690,611.03..5,144,536.12 rows=3,660,722 width=692) (actual rows= loops=)

  • Hash Cond: (mp.deck_complete_id = dc.id)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=19.00..2,759,964.70 rows=3,660,722 width=692) (actual rows= loops=)

  • Hash Cond: (mp.meta_period_id = mpd.id)
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on match_player mp (cost=0.00..2,621,235.07 rows=52,714,407 width=32) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=18.88..18.88 rows=10 width=668) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on meta_period mpd (cost=0.00..18.88 rows=10 width=668) (actual rows= loops=)

  • Filter: ((published IS TRUE) AND ((event_name)::text = ANY ('{Ladder,Traditional_Ladder,Historic_Ladder,Traditional_Historic_Ladder}'::text[])) AND ((end_ts IS NULL) OR ((end_ts >= '2020-07-04 00:00:00+00'::timestamp with time zone) AND (end_ts <= '2020-08-04 00:00:00+00'::timestamp with time zone))))
11. 0.000 0.000 ↓ 0.0

Hash (cost=1,545,053.90..1,545,053.90 rows=8,372,490 width=16) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on deck_complete dc (cost=0.00..1,545,053.90 rows=8,372,490 width=16) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=1,397,993.48..1,397,993.48 rows=64,132,648 width=16) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on match m (cost=0.00..1,397,993.48 rows=64,132,648 width=16) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=376.04..376.04 rows=19,704 width=24) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on deck_meta_period_tags dmpt (cost=0.00..376.04 rows=19,704 width=24) (actual rows= loops=)