explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FZFo

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

Limit (cost=0.71..188,240.25 rows=100 width=28) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.71..547,300,825.03 rows=290,747 width=28) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..546,016,557.89 rows=290,747 width=20) (actual rows= loops=)

  • Join Filter: (m.id = pa.match_id)
4. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.42..7,960,121.89 rows=52,389 width=16) (actual rows= loops=)

  • Join Filter: (l.tier = "*VALUES*".column1)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..7,956,978.52 rows=104,778 width=20) (actual rows= loops=)

  • Join Filter: (m.league_id = l.id)
6. 0.000 0.000 ↓ 0.0

Index Scan using uqnieneineie on mtch m (cost=0.42..2,040,779.59 rows=104,778 width=24) (actual rows= loops=)

  • Filter: (NOT has_error)
7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..225.47 rows=3,765 width=12) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on league l (cost=0.00..206.65 rows=3,765 width=12) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..0.04 rows=2 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.00..0.03 rows=2 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..73,149.00 rows=684,603 width=20) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on player_appearance pa (cost=0.00..69,725.99 rows=684,603 width=20) (actual rows= loops=)

  • Filter: (hero_damage > 0)
13. 0.000 0.000 ↓ 0.0

Index Scan using player_pkey on player p (cost=0.29..4.42 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (pa.player_id = id)