explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7jar

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

Limit (cost=175,038.52..175,038.53 rows=5 width=10,202) (actual time=3,069.876..3,069.883 rows=5 loops=1)

2. 32.597 3,069.877 ↑ 1,440.0 5 1

Sort (cost=175,038.52..175,056.52 rows=7,200 width=10,202) (actual time=3,069.875..3,069.877 rows=5 loops=1)

  • Sort Key: this_.finished, this_.last_user_activity
  • Sort Method: top-N heapsort Memory: 35kB
3. 49.545 3,037.280 ↓ 1.5 10,688 1

Nested Loop Left Join (cost=27,393.12..174,918.93 rows=7,200 width=10,202) (actual time=575.321..3,037.280 rows=10,688 loops=1)

  • Join Filter: (playerrewa16_.league_edition_id = leagueedit17_.id)
  • Rows Removed by Join Filter: 64128
4. 30.000 2,955.671 ↓ 1.5 10,688 1

Hash Left Join (cost=27,393.12..174,269.85 rows=7,200 width=10,158) (actual time=575.291..2,955.671 rows=10,688 loops=1)

  • Hash Cond: (playerrewa16_.player_id = sdplayer18_.player_id)
5. 19.803 2,680.375 ↓ 1.5 10,688 1

Nested Loop Left Join (cost=13,815.75..137,919.48 rows=7,200 width=6,763) (actual time=329.968..2,680.375 rows=10,688 loops=1)

6. 19.237 2,649.884 ↓ 1.5 10,688 1

Hash Left Join (cost=13,815.32..78,386.19 rows=7,200 width=6,610) (actual time=329.960..2,649.884 rows=10,688 loops=1)

  • Hash Cond: (this_.budget_allocation_id = budgetallo12_.id)
7. 52.038 2,627.725 ↓ 1.5 10,688 1

Nested Loop Left Join (cost=13,733.17..78,209.06 rows=7,200 width=6,537) (actual time=327.024..2,627.725 rows=10,688 loops=1)

  • Join Filter: (scenario9_.league_edition_id = leagueedit11_.id)
  • Rows Removed by Join Filter: 64128
8. 17.297 2,543.623 ↓ 1.5 10,688 1

Hash Left Join (cost=13,733.17..77,559.99 rows=7,200 width=6,493) (actual time=327.001..2,543.623 rows=10,688 loops=1)

  • Hash Cond: (scenario9_.budget_allocation_id = budgetallo10_.id)
9. 44.568 2,524.014 ↓ 1.5 10,688 1

Nested Loop Left Join (cost=13,651.03..77,369.84 rows=7,200 width=6,420) (actual time=324.681..2,524.014 rows=10,688 loops=1)

10. 74.962 502.166 ↓ 1.5 10,688 1

Hash Join (cost=13,642.71..42,648.53 rows=7,200 width=6,179) (actual time=324.518..502.166 rows=10,688 loops=1)

  • Hash Cond: (this_.player_id = p1_.player_id)
11. 29.427 102.923 ↓ 1.5 10,688 1

Nested Loop Left Join (cost=1.41..13,238.23 rows=7,200 width=2,784) (actual time=0.127..102.923 rows=10,688 loops=1)

  • Join Filter: (this_.task = abstractta3_.id)
12. 62.808 62.808 ↓ 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.038..62.808 rows=10,688 loops=1)

  • Index Cond: (task = 8479)
  • Filter: (((state)::text = 'FINISHED'::text) OR ((state)::text = 'PENDING'::text))
13. 10.591 10.688 ↑ 1.0 1 10,688

Materialize (cost=0.98..35.28 rows=1 width=2,610) (actual time=0.000..0.001 rows=1 loops=10,688)

14. 0.011 0.097 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.98..35.27 rows=1 width=2,610) (actual time=0.081..0.097 rows=1 loops=1)

  • Join Filter: (scenariost8_.scenario = scenario9_.id)
  • Rows Removed by Join Filter: 11
15. 0.006 0.081 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.98..34.02 rows=1 width=2,492) (actual time=0.067..0.081 rows=1 loops=1)

  • Join Filter: (abstractta3_.id = scenariost8_.task)
16. 0.008 0.062 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.98..30.89 rows=1 width=2,420) (actual time=0.049..0.062 rows=1 loops=1)

  • Join Filter: (abstractta3_.league_edition_id = leagueedit7_.id)
  • Rows Removed by Join Filter: 6
17. 0.007 0.051 ↑ 1.0 1 1

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

18. 0.006 0.037 ↑ 1.0 1 1

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

19. 0.005 0.026 ↑ 1.0 1 1

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

20. 0.010 0.010 ↑ 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.008..0.010 rows=1 loops=1)

  • Index Cond: (id = 8479)
21. 0.011 0.011 ↑ 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.011 rows=1 loops=1)

  • Index Cond: (abstractta3_.budget_allocation_id = id)
22. 0.005 0.005 ↑ 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.004..0.005 rows=1 loops=1)

  • Index Cond: (budgetallo4_.account_id = id)
23. 0.007 0.007 ↑ 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.005..0.007 rows=1 loops=1)

  • Index Cond: (abstractta3_.icon = id)
24. 0.003 0.003 ↑ 1.0 6 1

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

25. 0.013 0.013 ↓ 0.0 0 1

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

  • Filter: (task = 8479)
  • Rows Removed by Filter: 90
26. 0.005 0.005 ↑ 1.0 11 1

Seq Scan on be_scenario scenario9_ (cost=0.00..1.11 rows=11 width=118) (actual time=0.001..0.005 rows=11 loops=1)

27. 289.555 324.281 ↓ 1.0 25,577 1

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

  • Buckets: 1024 Batches: 4 Memory Usage: 2304kB
28. 34.726 34.726 ↓ 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.006..34.726 rows=25,577 loops=1)

  • Filter: ((player_registration_state)::text <> 'ERASED'::text)
29. 694.720 1,977.280 ↑ 1.0 1 10,688

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

  • Hash Cond: (account15_.id = playerrewa14_.account_id)
30. 630.592 630.592 ↑ 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.059 rows=131 loops=10,688)

31. 21.376 651.968 ↑ 1.0 1 10,688

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
32. 630.592 630.592 ↑ 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.058..0.059 rows=1 loops=10,688)

  • Index Cond: (this_.reward_history_id = id)
33. 1.153 2.312 ↑ 1.0 1,962 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 200kB
34. 1.159 1.159 ↑ 1.0 1,962 1

Seq Scan on be_budget_allocation budgetallo10_ (cost=0.00..57.62 rows=1,962 width=73) (actual time=0.003..1.159 rows=1,962 loops=1)

35. 32.057 32.064 ↑ 1.0 6 10,688

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

36. 0.007 0.007 ↑ 1.0 6 1

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

37. 1.982 2.922 ↑ 1.0 1,962 1

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

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

39. 10.688 10.688 ↓ 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.001..0.001 rows=0 loops=10,688)

  • Index Cond: (playerrewa14_.history_id = id)
40. 218.679 245.296 ↓ 1.0 25,577 1

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

  • Buckets: 1024 Batches: 4 Memory Usage: 2307kB
41. 26.617 26.617 ↓ 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.004..26.617 rows=25,577 loops=1)

42. 32.058 32.064 ↑ 1.0 6 10,688

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

43. 0.006 0.006 ↑ 1.0 6 1

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

Total runtime : 3,093.098 ms