explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EYl8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.332 ↑ 23.3 3 1

Sort (cost=268.05..268.22 rows=70 width=846) (actual time=0.331..0.332 rows=3 loops=1)

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

Initplan (forSort)

3. 0.010 0.276 ↑ 1.0 1 1

Aggregate (cost=8.59..8.60 rows=1 width=8) (actual time=0.276..0.276 rows=1 loops=1)

4. 0.266 0.266 ↓ 88.0 88 1

Index Scan using round_user_game_index on game_scale_round gamescaler2_ (cost=0.56..8.58 rows=1 width=8) (actual time=0.055..0.266 rows=88 loops=1)

  • Index Cond: ((user_id = 31200) AND (game_id = 53))
  • Filter: (((status)::text = 'SUCCESS'::text) OR (status IS NULL))
5. 0.004 0.322 ↑ 23.3 3 1

Nested Loop (cost=1.00..257.31 rows=70 width=846) (actual time=0.319..0.322 rows=3 loops=1)

6. 0.296 0.296 ↑ 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=0.295..0.296 rows=1 loops=1)

  • Index Cond: (id = $0)
7. 0.022 0.022 ↑ 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.022..0.022 rows=3 loops=1)

  • Index Cond: (round_id = $0)