explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YZeM

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,884.034 ↑ 1.0 5 1

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

2. 34.348 1,884.030 ↑ 1,439.6 5 1

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

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

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

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

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

5. 19.932 1,699.380 ↓ 1.5 10,555 1

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

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

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

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

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

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

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

9. 82.739 225.302 ↓ 1.5 10,555 1

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

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

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

  • Join Filter: (this_.task = abstractta3_.id)
11. 43.529 43.529 ↓ 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.040..43.529 rows=10,555 loops=1)

  • Index Cond: (task = 8463)
  • Filter: (((state)::text = 'FINISHED'::text) OR ((state)::text = 'PENDING'::text))
12. 10.438 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.003 0.117 ↑ 1.0 1 1

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

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

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

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

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

16. 0.005 0.064 ↑ 1.0 1 1

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

17. 0.003 0.047 ↑ 1.0 1 1

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

18. 0.006 0.032 ↑ 1.0 1 1

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

19. 0.017 0.017 ↑ 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.016..0.017 rows=1 loops=1)

  • Index Cond: (id = 8463)
20. 0.009 0.009 ↑ 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.008..0.009 rows=1 loops=1)

  • Index Cond: (abstractta3_.budget_allocation_id = id)
21. 0.012 0.012 ↑ 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.003..0.012 rows=1 loops=1)

  • Index Cond: (budgetallo4_.account_id = id)
22. 0.012 0.012 ↑ 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.011..0.012 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.013..0.015 rows=1 loops=1)

  • Index Cond: (fileentry6_.owner_id = player_id)
24. 0.005 0.005 ↑ 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.005 rows=6 loops=1)

25. 0.019 0.019 ↓ 0.0 0 1

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

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

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

  • Buckets: 1024 Batches: 4 Memory Usage: 2304kB
27. 30.672 30.672 ↑ 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.020..30.672 rows=25,572 loops=1)

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

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

  • Hash Cond: (account16_.id = playerrewa15_.account_id)
29. 569.970 569.970 ↑ 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.054 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.007..0.008 rows=1 loops=10,555)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
33. 0.793 1.837 ↑ 1.0 11 1

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

  • Hash Cond: (budgetallo11_.id = scenario10_.budget_allocation_id)
34. 1.025 1.025 ↑ 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.025 rows=1,962 loops=1)

35. 0.012 0.019 ↑ 1.0 11 1

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

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

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

37. 31.661 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.004 0.004 ↑ 1.0 6 1

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

39. 0.972 1.875 ↑ 1.0 1,962 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 200kB
40. 0.903 0.903 ↑ 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..0.903 rows=1,962 loops=1)

41. 31.665 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. 0.000 10.555 ↓ 0.0 0 10,555

Hash (cost=8.26..8.26 rows=1 width=153) (actual time=0.001..0.001 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. 26.763 48.507 ↑ 1.0 25,572 1

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

  • Buckets: 1024 Batches: 4 Memory Usage: 2307kB
46. 21.744 21.744 ↑ 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.006..21.744 rows=25,572 loops=1)

Total runtime : 1,885.016 ms