explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VjMP : L0-Page

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

Nested Loop (cost=602.88..880.26 rows=7 width=448) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=602.73..878.89 rows=7 width=302) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=602.58..878.52 rows=1 width=270) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=602.30..878.21 rows=1 width=233) (actual rows= loops=)

  • Hash Cond: (rtt.team_id = rt.id)
  • Join Filter: ((rt.id = rt1.id) OR (rt.id = rt2.id))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=581.68..850.62 rows=398 width=251) (actual rows= loops=)

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

Hash Join (cost=41.25..292.38 rows=3,688 width=71) (actual rows= loops=)

  • Hash Cond: (m.team_b = rt1.id)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=20.62..221.05 rows=3,688 width=71) (actual rows= loops=)

  • Hash Cond: (m.team_a = rt2.id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on match m (cost=0.00..149.71 rows=3,688 width=71) (actual rows= loops=)

  • Filter: (sport_type = 1)
9. 0.000 0.000 ↓ 0.0

Hash (cost=12.50..12.50 rows=650 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on real_teams rt2 (cost=0.00..12.50 rows=650 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=12.50..12.50 rows=650 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on real_teams rt1 (cost=0.00..12.50 rows=650 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=534.30..534.30 rows=490 width=188) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=444.57..534.30 rows=490 width=188) (actual rows= loops=)

  • Hash Cond: (rmm.round_id = r.id)
15. 0.000 0.000 ↓ 0.0

Seq Scan on round_match_mapping rmm (cost=0.00..69.06 rows=4,206 width=16) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash (cost=437.97..437.97 rows=528 width=188) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash Join (cost=277.22..437.97 rows=528 width=188) (actual rows= loops=)

  • Hash Cond: (i.real_team_id = rtt.team_id)
18. 0.000 0.000 ↓ 0.0

Hash Join (cost=231.27..384.76 rows=528 width=32) (actual rows= loops=)

  • Hash Cond: (i.league_id = r.league_id)
19. 0.000 0.000 ↓ 0.0

Seq Scan on innings i (cost=0.00..132.06 rows=4,306 width=16) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash (cost=224.32..224.32 rows=556 width=32) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash Join (cost=80.42..224.32 rows=556 width=32) (actual rows= loops=)

  • Hash Cond: (r.league_id = l.id)
22. 0.000 0.000 ↓ 0.0

Seq Scan on round r (cost=0.00..121.34 rows=4,534 width=16) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash (cost=73.29..73.29 rows=570 width=16) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Index Scan using idx_league_isdeleted on league l (cost=0.28..73.29 rows=570 width=16) (actual rows= loops=)

  • Index Cond: (is_deleted = false)
  • Filter: (NOT is_deleted)
25. 0.000 0.000 ↓ 0.0

Hash (cost=37.09..37.09 rows=709 width=156) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on real_team_theme rtt (cost=0.00..37.09 rows=709 width=156) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash (cost=12.50..12.50 rows=650 width=14) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on real_teams rt (cost=0.00..12.50 rows=650 width=14) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Index Scan using idx_sid_series on series s (cost=0.27..0.29 rows=1 width=45) (actual rows= loops=)

  • Index Cond: (id = m.series_id)
30. 0.000 0.000 ↓ 0.0

Index Scan using idx_std_id on series_type_details std (cost=0.15..0.31 rows=7 width=34) (actual rows= loops=)

  • Index Cond: (id = s.series_type)
31. 0.000 0.000 ↓ 0.0

Index Scan using idx_str_id on sports_type_ref str (cost=0.15..0.19 rows=1 width=148) (actual rows= loops=)

  • Index Cond: (id = rt.sports_type)