explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cNZK

Settings
# exclusive inclusive rows x rows loops node
1. 12.041 8,049.195 ↓ 10.0 10 1

Nested Loop (cost=10.15..19.47 rows=1 width=226) (actual time=1,986.570..8,049.195 rows=10 loops=1)

  • Join Filter: ((temp_process_game_player_id.player_id = process_game_player_rating_1.player_id) AND (temp_process_game_player_id.process_game_player_param_id = process_game_player_rating_1.process_game_player_param_id) AND (process_game_player_rating.id = (max(process_game_player_rating_1.id))))
  • Rows Removed by Join Filter: 26840
2. 1,229.999 2,159.689 ↓ 2,685.0 2,685 1

Nested Loop (cost=0.44..9.71 rows=1 width=234) (actual time=0.198..2,159.689 rows=2,685 loops=1)

  • Join Filter: ((process_game_player_rating.player_id = temp_process_game_player_id.player_id) AND (process_game_player_rating.process_game_player_param_id = temp_process_game_player_id.process_game_player_param_id))
  • Rows Removed by Join Filter: 1855355
3. 186.474 186.474 ↓ 185,804.0 185,804 1

Index Scan using ix_process_game_player_rating_process_id on process_game_player_rating (cost=0.44..8.46 rows=1 width=226) (actual time=0.017..186.474 rows=185,804 loops=1)

  • Index Cond: (process_id = 40)
4. 743.216 743.216 ↑ 1.0 10 185,804

Seq Scan on temp_process_game_player_id (cost=0.00..1.10 rows=10 width=8) (actual time=0.002..0.004 rows=10 loops=185,804)

5. 2,542.695 5,877.465 ↓ 10.0 10 2,685

GroupAggregate (cost=9.71..9.74 rows=1 width=12) (actual time=0.893..2.189 rows=10 loops=2,685)

  • Group Key: process_game_player_rating_1.player_id, process_game_player_rating_1.process_game_player_param_id
6. 1,354.639 3,334.770 ↓ 2,685.0 2,685 2,685

Sort (cost=9.71..9.72 rows=1 width=12) (actual time=0.738..1.242 rows=2,685 loops=2,685)

  • Sort Key: process_game_player_rating_1.player_id, process_game_player_rating_1.process_game_player_param_id
  • Sort Method: quicksort Memory: 222kB
7. 1,078.363 1,980.131 ↓ 2,685.0 2,685 1

Nested Loop (cost=0.44..9.71 rows=1 width=12) (actual time=0.158..1,980.131 rows=2,685 loops=1)

  • Join Filter: ((process_game_player_rating_1.player_id = temp_process_game_player_id_1.player_id) AND (process_game_player_rating_1.process_game_player_param_id = temp_process_game_player_id_1.process_game_player_param_id))
  • Rows Removed by Join Filter: 1855355
8. 158.552 158.552 ↓ 185,804.0 185,804 1

Index Scan using ix_process_game_player_rating_process_id on process_game_player_rating process_game_player_rating_1 (cost=0.44..8.46 rows=1 width=12) (actual time=0.008..158.552 rows=185,804 loops=1)

  • Index Cond: (process_id = 40)
9. 743.216 743.216 ↑ 1.0 10 185,804

Seq Scan on temp_process_game_player_id temp_process_game_player_id_1 (cost=0.00..1.10 rows=10 width=8) (actual time=0.002..0.004 rows=10 loops=185,804)