explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 05oy

Settings
# exclusive inclusive rows x rows loops node
1. 3,925.065 422,791.773 ↓ 1,232.0 1,232 1

Nested Loop (cost=17.15..32.91 rows=1 width=182) (actual time=407.448..422,791.773 rows=1,232 loops=1)

  • Join Filter: ((temp_process_game_player_id.id = process_game_player_rating_1.player_id) AND (process_game_player_rating.id = (max(process_game_player_rating_1.id))) AND ((process_game_player_rating.param_value)::text = (process_game_player_rating_1.param_value)::text))
  • Rows Removed by Join Filter: 45395504
2. 249.222 1,636.804 ↓ 36,848.0 36,848 1

Nested Loop (cost=0.72..16.42 rows=1 width=186) (actual time=0.066..1,636.804 rows=36,848 loops=1)

3. 391.750 391.750 ↓ 331,944.0 331,944 1

Index Scan using ix_process_game_player_rating_process_id on process_game_player_rating (cost=0.43..8.12 rows=1 width=182) (actual time=0.029..391.750 rows=331,944 loops=1)

  • Index Cond: (process_id = 55)
  • Filter: (param_type = 'map'::paramtype)
4. 995.832 995.832 ↓ 0.0 0 331,944

Index Only Scan using temp_process_game_player_id_pkey on temp_process_game_player_id (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=331,944)

  • Index Cond: (id = process_game_player_rating.player_id)
  • Heap Fetches: 36848
5. 217,808.528 417,229.904 ↓ 1,232.0 1,232 36,848

GroupAggregate (cost=16.43..16.46 rows=1 width=11) (actual time=0.013..11.323 rows=1,232 loops=36,848)

  • Group Key: process_game_player_rating_1.player_id, process_game_player_rating_1.param_value
6. 199,044.473 199,421.376 ↓ 36,848.0 36,848 36,848

Sort (cost=16.43..16.44 rows=1 width=11) (actual time=0.011..5.412 rows=36,848 loops=36,848)

  • Sort Key: process_game_player_rating_1.player_id, process_game_player_rating_1.param_value
  • Sort Method: quicksort Memory: 3244kB
7. 0.000 376.903 ↓ 36,848.0 36,848 1

Nested Loop (cost=0.72..16.42 rows=1 width=11) (actual time=0.017..376.903 rows=36,848 loops=1)

8. 106.897 106.897 ↓ 331,944.0 331,944 1

Index Scan using ix_process_game_player_rating_process_id on process_game_player_rating process_game_player_rating_1 (cost=0.43..8.12 rows=1 width=11) (actual time=0.013..106.897 rows=331,944 loops=1)

  • Index Cond: (process_id = 55)
  • Filter: (param_type = 'map'::paramtype)
9. 331.944 331.944 ↓ 0.0 0 331,944

Index Only Scan using temp_process_game_player_id_pkey on temp_process_game_player_id temp_process_game_player_id_1 (cost=0.28..8.30 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=331,944)

  • Index Cond: (id = process_game_player_rating_1.player_id)
  • Heap Fetches: 36848