explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SR3f

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 7,644.238 ↑ 23.3 3 1

Sort (cost=1,030,542.38..1,030,542.56 rows=70 width=846) (actual time=7,644.238..7,644.238 rows=3 loops=1)

  • Sort Key: actions1_.id DESC
  • Sort Method: quicksort Memory: 26kB
2.          

Initplan (forSort)

3. 0.026 7,644.124 ↑ 1.0 1 1

Aggregate (cost=1,030,282.92..1,030,282.93 rows=1 width=8) (actual time=7,644.124..7,644.124 rows=1 loops=1)

4. 7,644.098 7,644.098 ↓ 88.0 88 1

Seq Scan on game_scale_round gamescaler2_ (cost=0.00..1,030,282.92 rows=1 width=8) (actual time=2,642.388..7,644.098 rows=88 loops=1)

  • Filter: ((((status)::text = 'SUCCESS'::text) OR (status IS NULL)) AND (game_id = 53) AND (user_id = 31200))
  • Rows Removed by Filter: 26118983
5. 0.004 7,644.228 ↑ 23.3 3 1

Nested Loop (cost=1.00..257.31 rows=70 width=846) (actual time=7,644.225..7,644.228 rows=3 loops=1)

6. 7,644.182 7,644.182 ↑ 1.0 1 1

Index Scan using game_scale_round_pkey on game_scale_round gamescaler0_ (cost=0.44..8.46 rows=1 width=88) (actual time=7,644.181..7,644.182 rows=1 loops=1)

  • Index Cond: (id = $0)
7. 0.042 0.042 ↑ 23.3 3 1

Index Scan using game_scale_action_round_index on game_scale_action actions1_ (cost=0.57..248.15 rows=70 width=758) (actual time=0.040..0.042 rows=3 loops=1)

  • Index Cond: (round_id = $0)
Planning time : 0.271 ms
Execution time : 7,644.312 ms