explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YX3L

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 1,944.610 ↑ 1.0 5 1

Limit (cost=134,574.72..134,574.73 rows=5 width=13,597) (actual time=1,944.588..1,944.610 rows=5 loops=1)

2. 35.716 1,944.589 ↑ 1,439.6 5 1

Sort (cost=134,574.72..134,592.72 rows=7,198 width=13,597) (actual time=1,944.586..1,944.589 rows=5 loops=1)

  • Sort Key: this_.finished, this_.last_user_activity
  • Sort Method: top-N heapsort Memory: 43kB
3. 22.710 1,908.873 ↓ 1.5 10,555 1

Hash Left Join (cost=27,385.57..134,455.16 rows=7,198 width=13,597) (actual time=116.660..1,908.873 rows=10,555 loops=1)

  • Hash Cond: (playerrewa17_.player_id = sdplayer19_.player_id)
4. 44.142 1,834.624 ↓ 1.5 10,555 1

Nested Loop Left Join (cost=13,808.20..92,062.83 rows=7,198 width=10,202) (actual time=65.100..1,834.624 rows=10,555 loops=1)

5. 20.632 1,748.262 ↓ 1.5 10,555 1

Hash Left Join (cost=13,799.93..84,118.77 rows=7,198 width=10,005) (actual time=65.080..1,748.262 rows=10,555 loops=1)

  • Hash Cond: (this_.budget_allocation_id = budgetallo13_.id)
6. 48.085 1,725.031 ↓ 1.5 10,555 1

Nested Loop Left Join (cost=13,717.79..83,941.67 rows=7,198 width=9,932) (actual time=62.468..1,725.031 rows=10,555 loops=1)

  • Join Filter: (scenario10_.league_edition_id = leagueedit12_.id)
  • Rows Removed by Join Filter: 63330
7. 16.650 1,645.281 ↓ 1.5 10,555 1

Hash Left Join (cost=13,717.79..83,292.78 rows=7,198 width=9,888) (actual time=62.444..1,645.281 rows=10,555 loops=1)

  • Hash Cond: (scenariost9_.scenario = scenario10_.id)
8. 36.190 1,626.545 ↓ 1.5 10,555 1

Nested Loop Left Join (cost=13,651.31..83,127.33 rows=7,198 width=9,697) (actual time=60.350..1,626.545 rows=10,555 loops=1)

9. 81.863 228.760 ↓ 1.5 10,555 1

Hash Join (cost=13,643.00..48,415.66 rows=7,198 width=9,456) (actual time=60.200..228.760 rows=10,555 loops=1)

  • Hash Cond: (this_.player_id = p1_.player_id)
10. 31.609 87.002 ↓ 1.5 10,555 1

Nested Loop Left Join (cost=1.70..13,241.40 rows=7,198 width=6,061) (actual time=0.171..87.002 rows=10,555 loops=1)

  • Join Filter: (this_.task = abstractta3_.id)
11. 44.838 44.838 ↓ 1.5 10,555 1

Index Scan using be_player_task_task_player_id_key on be_player_task this_ (cost=0.43..13,091.31 rows=7,198 width=174) (actual time=0.042..44.838 rows=10,555 loops=1)

  • Index Cond: (task = 8463)
  • Filter: (((state)::text = 'FINISHED'::text) OR ((state)::text = 'PENDING'::text))
12. 10.408 10.555 ↑ 1.0 1 10,555

Materialize (cost=1.27..42.12 rows=1 width=5,887) (actual time=0.000..0.001 rows=1 loops=10,555)

13. 0.005 0.147 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.27..42.12 rows=1 width=5,887) (actual time=0.119..0.147 rows=1 loops=1)

  • Join Filter: (abstractta3_.id = scenariost9_.task)
14. 0.007 0.122 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.27..38.98 rows=1 width=5,815) (actual time=0.096..0.122 rows=1 loops=1)

  • Join Filter: (abstractta3_.league_edition_id = leagueedit8_.id)
  • Rows Removed by Join Filter: 6
15. 0.005 0.111 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.27..37.84 rows=1 width=5,771) (actual time=0.085..0.111 rows=1 loops=1)

16. 0.004 0.091 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.98..29.75 rows=1 width=2,376) (actual time=0.070..0.091 rows=1 loops=1)

17. 0.005 0.056 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.70..21.44 rows=1 width=1,941) (actual time=0.039..0.056 rows=1 loops=1)

18. 0.003 0.038 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.56..16.60 rows=1 width=1,853) (actual time=0.033..0.038 rows=1 loops=1)

19. 0.023 0.023 ↑ 1.0 1 1

Index Scan using be_task_pkey on be_task abstractta3_ (cost=0.28..8.29 rows=1 width=1,780) (actual time=0.021..0.023 rows=1 loops=1)

  • Index Cond: (id = 8463)
20. 0.012 0.012 ↑ 1.0 1 1

Index Scan using be_budget_allocation_pkey on be_budget_allocation budgetallo4_ (cost=0.28..8.29 rows=1 width=73) (actual time=0.010..0.012 rows=1 loops=1)

  • Index Cond: (abstractta3_.budget_allocation_id = id)
21. 0.013 0.013 ↑ 1.0 1 1

Index Scan using be_budget_account_pkey on be_budget_account account5_ (cost=0.14..4.83 rows=1 width=88) (actual time=0.002..0.013 rows=1 loops=1)

  • Index Cond: (budgetallo4_.account_id = id)
22. 0.031 0.031 ↑ 1.0 1 1

Index Scan using gf_file_entry_pkey on gf_file_entry fileentry6_ (cost=0.28..8.30 rows=1 width=435) (actual time=0.030..0.031 rows=1 loops=1)

  • Index Cond: (abstractta3_.icon = id)
23. 0.015 0.015 ↑ 1.0 1 1

Index Scan using gf_player_pkey on gf_player player7_ (cost=0.29..8.08 rows=1 width=3,395) (actual time=0.011..0.015 rows=1 loops=1)

  • Index Cond: (fileentry6_.owner_id = player_id)
24. 0.004 0.004 ↑ 1.0 6 1

Seq Scan on be_league_edition leagueedit8_ (cost=0.00..1.06 rows=6 width=44) (actual time=0.002..0.004 rows=6 loops=1)

25. 0.020 0.020 ↓ 0.0 0 1

Seq Scan on be_scenario_step scenariost9_ (cost=0.00..3.12 rows=1 width=72) (actual time=0.020..0.020 rows=0 loops=1)

  • Filter: (task = 8463)
  • Rows Removed by Filter: 90
26. 28.169 59.895 ↑ 1.0 25,572 1

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

  • Buckets: 1024 Batches: 4 Memory Usage: 2304kB
27. 31.726 31.726 ↑ 1.0 25,572 1

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

  • Filter: ((player_registration_state)::text <> 'ERASED'::text)
28. 664.965 1,361.595 ↑ 1.0 1 10,555

Hash Right Join (cost=8.31..13.13 rows=1 width=241) (actual time=0.123..0.129 rows=1 loops=10,555)

  • Hash Cond: (account16_.id = playerrewa15_.account_id)
29. 591.080 591.080 ↑ 1.0 131 10,555

Seq Scan on be_budget_account account16_ (cost=0.00..4.31 rows=131 width=88) (actual time=0.002..0.056 rows=131 loops=10,555)

30. 21.110 105.550 ↑ 1.0 1 10,555

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
31. 84.440 84.440 ↑ 1.0 1 10,555

Index Scan using bplrwrdhst_pk on be_player_reward_history playerrewa15_ (cost=0.43..8.30 rows=1 width=153) (actual time=0.008..0.008 rows=1 loops=10,555)

  • Index Cond: (this_.reward_history_id = id)
32. 0.032 2.086 ↑ 1.0 11 1

Hash (cost=66.34..66.34 rows=11 width=191) (actual time=2.086..2.086 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
33. 0.858 2.054 ↑ 1.0 11 1

Hash Right Join (cost=1.25..66.34 rows=11 width=191) (actual time=0.276..2.054 rows=11 loops=1)

  • Hash Cond: (budgetallo11_.id = scenario10_.budget_allocation_id)
34. 1.178 1.178 ↑ 1.0 1,962 1

Seq Scan on be_budget_allocation budgetallo11_ (cost=0.00..57.62 rows=1,962 width=73) (actual time=0.002..1.178 rows=1,962 loops=1)

35. 0.008 0.018 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=118) (actual time=0.018..0.018 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
36. 0.010 0.010 ↑ 1.0 11 1

Seq Scan on be_scenario scenario10_ (cost=0.00..1.11 rows=11 width=118) (actual time=0.003..0.010 rows=11 loops=1)

37. 31.660 31.665 ↑ 1.0 6 10,555

Materialize (cost=0.00..1.09 rows=6 width=44) (actual time=0.000..0.003 rows=6 loops=10,555)

38. 0.005 0.005 ↑ 1.0 6 1

Seq Scan on be_league_edition leagueedit12_ (cost=0.00..1.06 rows=6 width=44) (actual time=0.003..0.005 rows=6 loops=1)

39. 1.262 2.599 ↑ 1.0 1,962 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 200kB
40. 1.337 1.337 ↑ 1.0 1,962 1

Seq Scan on be_budget_allocation budgetallo13_ (cost=0.00..57.62 rows=1,962 width=73) (actual time=0.002..1.337 rows=1,962 loops=1)

41. 21.110 42.220 ↓ 0.0 0 10,555

Hash Right Join (cost=8.27..9.36 rows=1 width=197) (actual time=0.004..0.004 rows=0 loops=10,555)

  • Hash Cond: (leagueedit18_.id = playerrewa17_.league_edition_id)
42. 0.000 0.000 ↓ 0.0 0

Seq Scan on be_league_edition leagueedit18_ (cost=0.00..1.06 rows=6 width=44) (never executed)

43. 10.555 21.110 ↓ 0.0 0 10,555

Hash (cost=8.26..8.26 rows=1 width=153) (actual time=0.002..0.002 rows=0 loops=10,555)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
44. 10.555 10.555 ↓ 0.0 0 10,555

Index Scan using bplrwrdhst_pk on be_player_reward_history playerrewa17_ (cost=0.43..8.26 rows=1 width=153) (actual time=0.001..0.001 rows=0 loops=10,555)

  • Index Cond: (playerrewa15_.history_id = id)
45. 28.441 51.539 ↑ 1.0 25,572 1

Hash (cost=2,568.72..2,568.72 rows=25,572 width=3,395) (actual time=51.539..51.539 rows=25,572 loops=1)

  • Buckets: 1024 Batches: 4 Memory Usage: 2307kB
46. 23.098 23.098 ↑ 1.0 25,572 1

Seq Scan on gf_player sdplayer19_ (cost=0.00..2,568.72 rows=25,572 width=3,395) (actual time=0.007..23.098 rows=25,572 loops=1)

Total runtime : 1,945.460 ms