explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E938

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

Sort (cost=115.63..115.63 rows=1 width=2,771) (actual rows= loops=)

  • Sort Key: "Game".date
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=36.31..115.62 rows=1 width=2,771) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=36.04..111.85 rows=1 width=2,159) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=35.76..105.41 rows=1 width=2,031) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=35.48..98.97 rows=1 width=1,903) (actual rows= loops=)

  • Join Filter: (((""Season"".divisions #> '{42,teams}'::text[]) @> ((""Game"".""HomeTeamId"")::text)::jsonb) OR ((""Season"".divisions #> '{42,teams}'::text[]) @> ((""Game"".""AwayTeamId"")::text)::jsonb))
6. 0.000 0.000 ↓ 0.0

Index Scan using "Season_pkey" on "Season" (cost=0.15..8.17 rows=1 width=357) (actual rows= loops=)

  • Index Cond: (id = 362)
7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "Game" (cost=35.33..90.20 rows=15 width=1,546) (actual rows= loops=)

  • Recheck Cond: (("SeasonId" = 362) AND ("LeagueId" = 529))
8. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=35.33..35.33 rows=15 width=0) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "fkindex_Game_SeasonId" (cost=0.00..14.47 rows=292 width=0) (actual rows= loops=)

  • Index Cond: ("SeasonId" = 362)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "fkindex_Game_LeagueId" (cost=0.00..20.60 rows=575 width=0) (actual rows= loops=)

  • Index Cond: ("LeagueId" = 529)
11. 0.000 0.000 ↓ 0.0

Index Scan using "Team_pkey" on "Team" "HomeTeam" (cost=0.28..6.43 rows=1 width=128) (actual rows= loops=)

  • Index Cond: ("Game"."HomeTeamId" = id)
12. 0.000 0.000 ↓ 0.0

Index Scan using "Team_pkey" on "Team" "AwayTeam" (cost=0.28..6.43 rows=1 width=128) (actual rows= loops=)

  • Index Cond: ("Game"."AwayTeamId" = id)
13. 0.000 0.000 ↓ 0.0

Index Scan using "Location_pkey" on "Location" (cost=0.27..3.76 rows=1 width=612) (actual rows= loops=)

  • Index Cond: ("Game"."LocationId" = id)