explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qhPF

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.162 ↑ 3.5 2 1

Nested Loop (cost=40.73..95.12 rows=7 width=399) (actual time=0.151..0.162 rows=2 loops=1)

2. 0.009 0.142 ↑ 3.5 2 1

Nested Loop (cost=40.58..93.40 rows=7 width=353) (actual time=0.134..0.142 rows=2 loops=1)

  • Join Filter: (game.league_id = league.league_id)
3. 0.028 0.109 ↑ 3.5 2 1

Hash Join (cost=40.43..91.94 rows=7 width=349) (actual time=0.106..0.109 rows=2 loops=1)

  • Hash Cond: ((game_club.game_id = game.game_id) AND (game_club.league_id = game.league_id) AND (game_club.game_date = game.game_date) AND (game_club.club_id = club.club_id))
4. 0.027 0.027 ↑ 830.0 2 1

Seq Scan on game_club (cost=0.00..26.60 rows=1,660 width=21) (actual time=0.026..0.027 rows=2 loops=1)

5. 0.004 0.054 ↑ 175.0 2 1

Hash (cost=33.43..33.43 rows=350 width=348) (actual time=0.054..0.054 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.024 0.050 ↑ 175.0 2 1

Hash Join (cost=19.00..33.43 rows=350 width=348) (actual time=0.046..0.050 rows=2 loops=1)

  • Hash Cond: (club.league_id = game.league_id)
7. 0.009 0.009 ↑ 70.0 5 1

Seq Scan on club (cost=0.00..13.50 rows=350 width=172) (actual time=0.008..0.009 rows=5 loops=1)

8. 0.006 0.017 ↑ 400.0 1 1

Hash (cost=14.00..14.00 rows=400 width=176) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.011 0.011 ↑ 400.0 1 1

Seq Scan on game (cost=0.00..14.00 rows=400 width=176) (actual time=0.010..0.011 rows=1 loops=1)

10. 0.024 0.024 ↑ 1.0 1 2

Index Scan using league_pkey on league (cost=0.15..0.20 rows=1 width=20) (actual time=0.012..0.012 rows=1 loops=2)

  • Index Cond: (league_id = game_club.league_id)
11. 0.014 0.014 ↑ 1.0 1 2

Index Scan using sport_pkey on sport (cost=0.15..0.24 rows=1 width=54) (actual time=0.007..0.007 rows=1 loops=2)

  • Index Cond: (sport_id = league.sport_id)