explain.depesz.com

A tool for finding a real cause for slow queries.

Result: hN7

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=10,413.93..10,413.96 rows=15 width=12) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=10,413.93..10,418.19 rows=1,707 width=12) (actual time=.. rows= loops=)

  • Sort Key: replays_game.game_time
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7,914.79..10,372.05 rows=1,707 width=12) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=7,914.79..7,919.18 rows=439 width=4) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using replays_playeringame_player_id on replays_playeringame (cost=0.00..7,910.52 rows=1,707 width=4) (actual time=.. rows= loops=)

  • Index Cond: (player_id = 50027)
  • 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))
6. 0.000 0.000 ↓ 0.0

Index Scan using replays_game_pkey on replays_game (cost=0.00..5.57 rows=1 width=12) (actual time=.. rows= loops=)

  • Index Cond: (id = replays_playeringame.game_id)