explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OruQ

Settings
# exclusive inclusive rows x rows loops node
1. 11.194 7,766.259 ↓ 5,672.0 5,672 1

Nested Loop (cost=1.69..830,830.89 rows=1 width=208) (actual time=37.712..7,766.259 rows=5,672 loops=1)

  • Join Filter: ((temp_process_game_player_id.player_id = process_game_player_rating.player_id) AND (temp_process_game_player_id.process_game_player_param_id = process_game_player_rating.process_game_player_param_id))
2. 11.262 7,584.905 ↓ 1.4 5,672 1

Merge Join (cost=1.12..797,412.44 rows=4,096 width=20) (actual time=37.685..7,584.905 rows=5,672 loops=1)

  • Merge Cond: ((process_game_player_rating_1.player_id = temp_process_game_player_id.player_id) AND (process_game_player_rating_1.process_game_player_param_id = temp_process_game_player_id.process_game_player_param_id))
3. 218.013 7,568.498 ↑ 3.6 5,672 1

GroupAggregate (cost=0.84..796,629.55 rows=20,263 width=12) (actual time=37.657..7,568.498 rows=5,672 loops=1)

  • Group Key: process_game_player_rating_1.player_id, process_game_player_rating_1.process_game_player_param_id
4. 781.000 7,350.485 ↓ 66.8 1,353,400 1

Nested Loop (cost=0.84..796,274.95 rows=20,263 width=12) (actual time=1.654..7,350.485 rows=1,353,400 loops=1)

5. 12.550 12.550 ↑ 1.0 8,085 1

Index Only Scan using player_id_pgpp_id on temp_process_game_player_id temp_process_game_player_id_1 (cost=0.28..397.56 rows=8,085 width=8) (actual time=0.047..12.550 rows=8,085 loops=1)

  • Heap Fetches: 8085
6. 6,556.935 6,556.935 ↓ 4.0 167 8,085

Index Scan using process_player_param_process_game_player on process_game_player_rating process_game_player_rating_1 (cost=0.56..98.02 rows=42 width=12) (actual time=0.068..0.811 rows=167 loops=8,085)

  • Index Cond: ((process_id = 57) AND (process_game_player_param_id = temp_process_game_player_id_1.process_game_player_param_id) AND (player_id = temp_process_game_player_id_1.player_id))
7. 5.145 5.145 ↑ 1.0 8,052 1

Index Only Scan using player_id_pgpp_id on temp_process_game_player_id (cost=0.28..397.56 rows=8,085 width=8) (actual time=0.023..5.145 rows=8,052 loops=1)

  • Heap Fetches: 8052
8. 170.160 170.160 ↑ 1.0 1 5,672

Index Scan using process_game_player_rating_pkey on process_game_player_rating (cost=0.56..8.14 rows=1 width=208) (actual time=0.029..0.030 rows=1 loops=5,672)

  • Index Cond: (id = (max(process_game_player_rating_1.id)))
  • Filter: ((process_id = 57) AND (process_game_player_rating_1.player_id = player_id) AND (process_game_player_rating_1.process_game_player_param_id = process_game_player_param_id))