explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Gwr

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1,823.216 ↑ 1.0 5 1

Limit (cost=49,067.92..49,067.93 rows=5 width=7,475) (actual time=1,823.210..1,823.216 rows=5 loops=1)

2. 15.367 1,823.210 ↑ 1,440.0 5 1

Sort (cost=49,067.92..49,085.92 rows=7,200 width=7,475) (actual time=1,823.208..1,823.210 rows=5 loops=1)

  • Sort Key: this_.finished, this_.last_user_activity
  • Sort Method: top-N heapsort Memory: 30kB
3. 13.719 1,807.843 ↓ 1.5 10,688 1

Hash Left Join (cost=46,052.81..48,948.33 rows=7,200 width=7,475) (actual time=1,778.240..1,807.843 rows=10,688 loops=1)

  • Hash Cond: (this_.budget_allocation_id = budgetallo12_.id)
4. 34.198 1,791.949 ↓ 1.5 10,688 1

Hash Right Join (cost=45,970.66..48,771.21 rows=7,200 width=7,402) (actual time=1,776.045..1,791.949 rows=10,688 loops=1)

  • Hash Cond: (sdplayer18_.player_id = playerrewa16_.player_id)
5. 10.671 10.671 ↓ 1.0 25,577 1

Seq Scan on gf_player sdplayer18_ (cost=0.00..2,568.72 rows=25,572 width=3,395) (actual time=0.003..10.671 rows=25,577 loops=1)

6. 20.026 1,747.080 ↓ 1.5 10,688 1

Hash (cost=45,880.66..45,880.66 rows=7,200 width=4,007) (actual time=1,747.080..1,747.080 rows=10,688 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8408kB
7. 39.206 1,727.054 ↓ 1.5 10,688 1

Nested Loop Left Join (cost=13,663.14..45,880.66 rows=7,200 width=4,007) (actual time=69.109..1,727.054 rows=10,688 loops=1)

8. 46.175 148.776 ↓ 1.5 10,688 1

Hash Join (cost=13,641.73..37,921.25 rows=7,200 width=3,569) (actual time=68.935..148.776 rows=10,688 loops=1)

  • Hash Cond: (this_.player_id = p1_.player_id)
9. 33.762 33.762 ↓ 1.5 10,688 1

Index Scan using be_player_task_task_player_id_key on be_player_task this_ (cost=0.43..13,094.95 rows=7,200 width=174) (actual time=0.026..33.762 rows=10,688 loops=1)

  • Index Cond: (task = 8479)
  • Filter: (((state)::text = 'FINISHED'::text) OR ((state)::text = 'PENDING'::text))
10. 33.262 68.839 ↓ 1.0 25,577 1

Hash (cost=2,632.65..2,632.65 rows=25,572 width=3,395) (actual time=68.839..68.839 rows=25,577 loops=1)

  • Buckets: 1024 Batches: 4 Memory Usage: 2304kB
11. 35.577 35.577 ↓ 1.0 25,577 1

Seq Scan on gf_player p1_ (cost=0.00..2,632.65 rows=25,572 width=3,395) (actual time=0.005..35.577 rows=25,577 loops=1)

  • Filter: ((player_registration_state)::text <> 'ERASED'::text)
12. 96.192 1,539.072 ↑ 1.0 1 10,688

Hash Right Join (cost=21.41..22.50 rows=1 width=438) (actual time=0.141..0.144 rows=1 loops=10,688)

  • Hash Cond: (leagueedit17_.id = playerrewa16_.league_edition_id)
13. 42.752 42.752 ↑ 1.0 6 10,688

Seq Scan on be_league_edition leagueedit17_ (cost=0.00..1.06 rows=6 width=44) (actual time=0.002..0.004 rows=6 loops=10,688)

14. 21.376 1,400.128 ↑ 1.0 1 10,688

Hash (cost=21.39..21.39 rows=1 width=394) (actual time=0.131..0.131 rows=1 loops=10,688)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
15. 42.752 1,378.752 ↑ 1.0 1 10,688

Nested Loop Left Join (cost=8.75..21.39 rows=1 width=394) (actual time=0.124..0.129 rows=1 loops=10,688)

16. 651.968 1,336.000 ↑ 1.0 1 10,688

Hash Right Join (cost=8.31..13.13 rows=1 width=241) (actual time=0.120..0.125 rows=1 loops=10,688)

  • Hash Cond: (account15_.id = playerrewa14_.account_id)
17. 577.152 577.152 ↑ 1.0 131 10,688

Seq Scan on be_budget_account account15_ (cost=0.00..4.31 rows=131 width=88) (actual time=0.002..0.054 rows=131 loops=10,688)

18. 32.064 106.880 ↑ 1.0 1 10,688

Hash (cost=8.30..8.30 rows=1 width=153) (actual time=0.010..0.010 rows=1 loops=10,688)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
19. 74.816 74.816 ↑ 1.0 1 10,688

Index Scan using bplrwrdhst_pk on be_player_reward_history playerrewa14_ (cost=0.43..8.30 rows=1 width=153) (actual time=0.007..0.007 rows=1 loops=10,688)

  • Index Cond: (this_.reward_history_id = id)
20. 0.000 0.000 ↓ 0.0 0 10,688

Index Scan using bplrwrdhst_pk on be_player_reward_history playerrewa16_ (cost=0.43..8.26 rows=1 width=153) (actual time=0.000..0.000 rows=0 loops=10,688)

  • Index Cond: (playerrewa14_.history_id = id)
21. 1.134 2.175 ↑ 1.0 1,962 1

Hash (cost=57.62..57.62 rows=1,962 width=73) (actual time=2.175..2.175 rows=1,962 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 200kB
22. 1.041 1.041 ↑ 1.0 1,962 1

Seq Scan on be_budget_allocation budgetallo12_ (cost=0.00..57.62 rows=1,962 width=73) (actual time=0.013..1.041 rows=1,962 loops=1)

Total runtime : 1,823.583 ms