explain.depesz.com

A tool for finding a real cause for slow queries.

Result: meE

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

Limit (cost=0.00..11,460.73 rows=15 width=12) (actual time=75.850..83.053 rows=15 loops=1)

2. 3.550 83.048 ↑ 113.8 15 1

Nested Loop (cost=0.00..1,304,230.80 rows=1,707 width=12) (actual time=75.849..83.048 rows=15 loops=1)

3. 8.803 8.803 ↑ 18.7 7,855 1

Index Scan Backward using replays_game_game_time on replays_game (cost=0.00..318,455.66 rows=147,058 width=12) (actual time=0.041..8.803 rows=7,855 loops=1)

4. 70.695 70.695 ↓ 0.0 0 7,855

Index Scan using replays_playeringame_game_id on replays_playeringame (cost=0.00..6.69 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=7,855)

  • 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))