explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 1mK

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.005 209.963 ↑ 1.0 15 1

Limit (cost=0.00..16,528.15 rows=15 width=12) (actual time=194.032..209.963 rows=15 loops=1)

2. 18.437 209.958 ↑ 314.5 15 1

Nested Loop Semi Join (cost=0.00..5,198,654.70 rows=4,718 width=12) (actual time=194.030..209.958 rows=15 loops=1)

3. 12.754 68.143 ↑ 19.8 20,563 1

Nested Loop (cost=0.00..1,696,888.62 rows=406,470 width=16) (actual time=0.055..68.143 rows=20,563 loops=1)

4. 8.955 8.955 ↑ 19.0 7,739 1

Index Scan Backward using replays_game_game_time on replays_game (cost=0.00..424,616.58 rows=147,058 width=12) (actual time=0.041..8.955 rows=7,739 loops=1)

5. 46.434 46.434 ↑ 1.3 3 7,739

Index Scan using replays_playeringame_game_id on replays_playeringame (cost=0.00..8.60 rows=4 width=4) (actual time=0.005..0.006 rows=3 loops=7,739)

  • Index Cond: (game_id = replays_game.id)
6. 123.378 123.378 ↓ 0.0 0 20,563

Index Scan using replays_playeringame_game_id on replays_playeringame (cost=0.00..8.61 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=20,563)

  • Index Cond: (game_id = replays_game.id)
  • Filter: ((win IS NOT NULL) AND (apm IS NOT NULL) AND (wpm IS NOT NULL) AND (apm > 0::double precision) AND (wpm > 0::double precision) AND (player_id = 50027))