explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 01HJ : L0-Page

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

Sort (cost=202.82..202.84 rows=7 width=455) (actual rows= loops=)

  • Sort Key: m.id, rt.id
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.08..202.72 rows=7 width=455) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.93..202.36 rows=1 width=423) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.65..202.05 rows=1 width=380) (actual rows= loops=)

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

Nested Loop (cost=2.38..192.11 rows=32 width=396) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.10..182.34 rows=32 width=396) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.96..175.93 rows=32 width=250) (actual rows= loops=)

  • Join Filter: (rtt.team_id = rt.id)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.68..165.16 rows=35 width=252) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..149.85 rows=45 width=196) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..134.18 rows=49 width=196) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..118.56 rows=50 width=40) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..97.01 rows=60 width=32) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

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

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

Index Scan using idx_rnd_lid on round r (cost=0.28..1.35 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (league_id = l.id)
15. 0.000 0.000 ↓ 0.0

Index Scan using "innings_index_leagueId" on innings i (cost=0.28..0.34 rows=2 width=24) (actual rows= loops=)

  • Index Cond: (league_id = r.league_id)
16. 0.000 0.000 ↓ 0.0

Index Scan using unique_rtt_teamid on real_team_theme rtt (cost=0.28..0.30 rows=1 width=156) (actual rows= loops=)

  • Index Cond: (team_id = i.real_team_id)
17. 0.000 0.000 ↓ 0.0

Index Scan using idx_rid_mapping on round_match_mapping rmm (cost=0.28..0.31 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (round_id = r.id)
18. 0.000 0.000 ↓ 0.0

Index Scan using idx_mid on match m (cost=0.28..0.33 rows=1 width=64) (actual rows= loops=)

  • Index Cond: (id = rmm.match_id)
  • Filter: (sport_type = 1)
19. 0.000 0.000 ↓ 0.0

Index Scan using idx_rt_id on real_teams rt (cost=0.28..0.30 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (id = i.real_team_id)
20. 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)
21. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_rt_id on real_teams rt2 (cost=0.28..0.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = m.team_a)
22. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_rt_id on real_teams rt1 (cost=0.28..0.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = m.team_b)
23. 0.000 0.000 ↓ 0.0

Index Scan using idx_sid_series on series s (cost=0.28..0.30 rows=1 width=51) (actual rows= loops=)

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

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

  • Index Cond: (id = s.series_type)