explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 5Fh

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

Limit (cost=0.00..1,000.70 rows=15 width=12) (actual time=991.701..999.261 rows=15 loops=1)

2. 80.685 999.243 ↑ 107.9 15 1

Nested Loop (cost=0.00..108,008.63 rows=1,619 width=12) (actual time=991.700..999.243 rows=15 loops=1)

3. 158.734 158.734 ↑ 3.1 47,489 1

Index Scan Backward using replays_game_game_time on replays_game (cost=0.00..5,652.77 rows=147,119 width=12) (actual time=0.023..158.734 rows=47,489 loops=1)

4. 759.824 759.824 ↓ 0.0 0 47,489

Index Scan using replays_playeringame_game_id on replays_playeringame (cost=0.00..0.69 rows=1 width=4) (actual time=0.016..0.016 rows=0 loops=47,489)

  • Index Cond: (game_id = replays_game.id)
  • Filter: (player_id = 60201)