explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vlaI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 0

Limit (cost=108127.50..108127.51 rows=7 width=8362) (actual time=4224.627..4224.627 rows=0 loops=1)69 width=536) (cost=0..0 rows=0 width=0) (never executed)

  • JIT:
  • Functions: 170
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 36.368 ms, Inlining 0.000 ms, Optimization 11.487 ms, Emission 270.230 ms, Total 318.086 ms
2. 0.000 0.000 ↓ 0.0 0

Sort (cost=108127.50..108127.51 rows=7 width=8362) (actual time=3940.033..3940.033 rows=0 loops=1)) (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: this_.idIndex Cond: (id = gamesessio25_.player_id)
3. 0.000 0.000 ↓ 0.0 0

Sort Method: quicksort Memory: 25kB on player player29_ (cost=0.42..2.64 rows=1 width=797) (never executed)

4. 0.001 3,939.951 ↓ 0.0 0 1

Nested Loop Left Join (cost=32.10..108,127.40 rows=7 width=8,362) (actual time=3,939.951..3,939.951 rows=0 loops=1)

5. 0.001 3,939.950 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.67..108,108.92 rows=7 width=7,561) (actual time=3,939.950..3,939.950 rows=0 loops=1)

6. 0.000 3,939.949 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.25..108,090.91 rows=7 width=6,764) (actual time=3,939.949..3,939.949 rows=0 loops=1)

  • Join Filter: (game26_.game_publisher_id = gamepublis27_.id)
7. 0.001 3,939.949 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.25..108,081.80 rows=7 width=6,228) (actual time=3,939.949..3,939.949 rows=0 loops=1)

  • Join Filter: (gamesessio25_.game_id = game26_.id)on 270.230 ms, Total 318.086 ms
8. 0.000 3,939.948 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.25..107,966.05 rows=7 width=6,171) (actual time=3,939.948..3,939.948 rows=0 loops=1)

  • Join Filter: (internaltr1_.game_session_id = gamesessio25_.id)
9. 0.001 3,939.948 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.25..107,925.50 rows=7 width=5,888) (actual time=3,939.947..3,939.948 rows=0 loops=1)

10. 0.001 3,939.947 ↓ 0.0 0 1

Nested Loop Left Join (cost=30.83..107,907.22 rows=7 width=5,091) (actual time=3,939.947..3,939.947 rows=0 loops=1)

  • Join Filter: (casinogame22_.game_publisher_id = gamepublis23_.id)
11. 0.001 3,939.946 ↓ 0.0 0 1

Nested Loop Left Join (cost=30.83..107,898.11 rows=7 width=4,555) (actual time=3,939.946..3,939.946 rows=0 loops=1)

  • Join Filter: (casinogame21_.casino_game_id = casinogame22_.id)
12. 0.000 3,939.945 ↓ 0.0 0 1

Nested Loop Left Join (cost=30.83..107,804.68 rows=7 width=4,468) (actual time=3,939.945..3,939.945 rows=0 loops=1)

  • Join Filter: (casinogame20_.casino_session_id = casinogame21_.id)
13. 0.001 3,939.945 ↓ 0.0 0 1

Nested Loop Left Join (cost=30.83..107,780.58 rows=7 width=3,859) (actual time=3,939.945..3,939.945 rows=0 loops=1)

  • Join Filter: (internaltr1_.casino_round_id = casinogame20_.id)
14. 0.001 3,939.944 ↓ 0.0 0 1

Nested Loop Left Join (cost=30.83..107,716.53 rows=7 width=3,713) (actual time=3,939.944..3,939.944 rows=0 loops=1)

  • Join Filter: (relaxexter2_1_.provider_id = externalga18_.id)
15. 0.000 3,939.943 ↓ 0.0 0 1

Nested Loop Left Join (cost=30.83..107,714.58 rows=7 width=3,701) (actual time=3,939.943..3,939.943 rows=0 loops=1)

16. 81.348 3,939.943 ↓ 0.0 0 1

Hash Join (cost=30.40..107,711.34 rows=7 width=3,683) (actual time=3,939.943..3,939.943 rows=0 loops=1)

  • Hash Cond: (this_.internal_transaction_id = internaltr1_.id)
17. 337.917 3,858.467 ↓ 1.0 510,334 1

Hash Left Join (cost=26.41..106,410.75 rows=493,943 width=3,631) (actual time=46.689..3,858.467 rows=510,334 loops=1)

  • Hash Cond: (player10_.platform_id = platform16_.id)
18. 307.848 3,520.542 ↓ 1.0 510,334 1

Hash Left Join (cost=25.39..104,994.61 rows=493,943 width=3,583) (actual time=46.669..3,520.542 rows=510,334 loops=1)

  • Hash Cond: (partner14_.broker_id = broker15_.id)
19. 325.467 3,212.677 ↓ 1.0 510,334 1

Hash Left Join (cost=24.36..103,608.35 rows=493,943 width=3,560) (actual time=46.640..3,212.677 rows=510,334 loops=1)

  • Hash Cond: (player10_.partner_id = partner14_.id)
20. 376.511 2,887.179 ↓ 1.0 510,334 1

Hash Left Join (cost=21.97..102,308.14 rows=493,943 width=3,137) (actual time=46.594..2,887.179 rows=510,334 loops=1)

  • Hash Cond: (player10_.mirror_id = mirror13_.id)
21. 310.080 2,510.597 ↓ 1.0 510,334 1

Hash Left Join (cost=16.55..100,978.42 rows=493,943 width=3,100) (actual time=46.512..2,510.597 rows=510,334 loops=1)

  • Hash Cond: (player10_.mg_platform_id = mgplatform12_.id)
22. 419.180 2,200.507 ↓ 1.0 510,334 1

Hash Left Join (cost=15.53..99,680.80 rows=493,943 width=2,478) (actual time=46.490..2,200.507 rows=510,334 loops=1)

  • Hash Cond: (player10_.country_id = country11_.code_iso)
23. 346.643 1,781.196 ↓ 1.0 510,334 1

Merge Left Join (cost=8.13..98,353.90 rows=493,943 width=2,453) (actual time=46.334..1,781.196 rows=510,334 loops=1)

  • Merge Cond: (relaxexter2_1_.player_id = player10_.id)
24. 340.378 853.787 ↓ 1.0 510,334 1

Nested Loop (cost=1.56..45,790.37 rows=493,943 width=1,656) (actual time=3.050..853.787 rows=510,334 loops=1)

  • Join Filter: (relaxexter2_.session_id = this_.session_id)
25. 6.129 185.377 ↓ 1.0 6,432 1

Nested Loop Left Join (cost=1.14..17,462.11 rows=6,304 width=1,588) (actual time=2.576..185.377 rows=6,432 loops=1)

  • Join Filter: (externalga5_.provider_id = externalga9_.id)
  • Rows Removed by Join Filter: 45,024
26. 4.342 172.816 ↓ 1.0 6,432 1

Nested Loop Left Join (cost=1.14..16,685.56 rows=6,304 width=1,576) (actual time=2.562..172.816 rows=6,432 loops=1)

27. 5.452 155.610 ↓ 1.0 6,432 1

Nested Loop Left Join (cost=1.00..15,381.05 rows=6,304 width=1,568) (actual time=2.551..155.610 rows=6,432 loops=1)

  • Join Filter: (gamepublis6_.provider_id = externalga7_.id)
  • Rows Removed by Join Filter: 35,302
28. 4.324 143.726 ↓ 1.0 6,432 1

Nested Loop Left Join (cost=1.00..14,596.83 rows=6,304 width=1,556) (actual time=2.530..143.726 rows=6,432 loops=1)

29. 11.409 126.538 ↓ 1.0 6,432 1

Nested Loop Left Join (cost=0.85..13,582.20 rows=6,304 width=1,020) (actual time=2.519..126.538 rows=6,432 loops=1)

30. 6.523 102.265 ↓ 1.0 6,432 1

Nested Loop (cost=0.57..11,682.24 rows=6,304 width=156) (actual time=2.490..102.265 rows=6,432 loops=1)

31. 29.230 29.230 ↑ 1.0 33,256 1

Index Scan using egs_player_id on external_game_session relaxexter2_1_ (cost=0.29..1,369.66 rows=33,873 width=62) (actual time=0.082..29.230 rows=33,256 loops=1)

  • Filter: (currency_id = 2)
  • Rows Removed by Filter: 2,966
32. 66.512 66.512 ↓ 0.0 0 33,256

Index Scan using pk_relax_game_session on relax_game_session relaxexter2_ (cost=0.28..0.30 rows=1 width=94) (actual time=0.002..0.002 rows=0 loops=33,256)

  • Index Cond: (session_id = relaxexter2_1_.id)
33. 12.864 12.864 ↑ 1.0 1 6,432

Index Scan using pk_external_game on external_game externalga5_ (cost=0.28..0.30 rows=1 width=864) (actual time=0.002..0.002 rows=1 loops=6,432)

  • Index Cond: (id = relaxexter2_1_.game_id)
34. 12.864 12.864 ↑ 1.0 1 6,432

Index Scan using game_publisher_pkey on game_publisher gamepublis6_ (cost=0.14..0.16 rows=1 width=536) (actual time=0.002..0.002 rows=1 loops=6,432)

  • Index Cond: (id = externalga5_.game_publisher_id)
35. 6.421 6.432 ↑ 1.5 6 6,432

Materialize (cost=0.00..1.14 rows=9 width=12) (actual time=0.000..0.001 rows=6 loops=6,432)

36. 0.011 0.011 ↑ 1.1 8 1

Seq Scan on external_game_provider externalga7_ (cost=0.00..1.09 rows=9 width=12) (actual time=0.011..0.011 rows=8 loops=1)

37. 12.864 12.864 ↑ 1.0 1 6,432

Index Scan using pk_game_publisher_blocking_rules on game_publisher_blocking_rules gamepublis8_ (cost=0.14..0.21 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=6,432)

  • Index Cond: (game_publisher_id = gamepublis6_.id)
38. 6.426 6.432 ↑ 1.1 8 6,432

Materialize (cost=0.00..1.14 rows=9 width=12) (actual time=0.000..0.001 rows=8 loops=6,432)

39. 0.006 0.006 ↑ 1.1 8 1

Seq Scan on external_game_provider externalga9_ (cost=0.00..1.09 rows=9 width=12) (actual time=0.005..0.006 rows=8 loops=1)

40. 328.032 328.032 ↑ 1.6 79 6,432

Index Scan using idx_relax_session_id on relax_game_transaction this_ (cost=0.42..2.92 rows=126 width=76) (actual time=0.006..0.051 rows=79 loops=6,432)

  • Index Cond: (session_id = relaxexter2_1_.id)
41. 580.766 580.766 ↑ 1.3 263,423 1

Index Scan using pk_player on player player10_ (cost=0.42..45,520.61 rows=347,456 width=797) (actual time=0.026..580.766 rows=263,423 loops=1)

42. 0.058 0.131 ↑ 1.0 240 1

Hash (cost=4.40..4.40 rows=240 width=25) (actual time=0.131..0.131 rows=240 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
43. 0.073 0.073 ↑ 1.0 240 1

Seq Scan on country country11_ (cost=0.00..4.40 rows=240 width=25) (actual time=0.032..0.073 rows=240 loops=1)

44. 0.003 0.010 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=622) (actual time=0.010..0.010 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
45. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on platform mgplatform12_ (cost=0.00..1.01 rows=1 width=622) (actual time=0.007..0.007 rows=1 loops=1)

46. 0.037 0.071 ↑ 1.0 152 1

Hash (cost=3.52..3.52 rows=152 width=37) (actual time=0.071..0.071 rows=152 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
47. 0.034 0.034 ↑ 1.0 152 1

Seq Scan on mirror mirror13_ (cost=0.00..3.52 rows=152 width=37) (actual time=0.012..0.034 rows=152 loops=1)

48. 0.014 0.031 ↑ 1.0 62 1

Hash (cost=1.62..1.62 rows=62 width=423) (actual time=0.031..0.031 rows=62 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
49. 0.017 0.017 ↑ 1.0 62 1

Seq Scan on partner partner14_ (cost=0.00..1.62 rows=62 width=423) (actual time=0.009..0.017 rows=62 loops=1)

50. 0.002 0.017 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=23) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
51. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on broker broker15_ (cost=0.00..1.01 rows=1 width=23) (actual time=0.014..0.015 rows=1 loops=1)

52. 0.003 0.008 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=48) (actual time=0.008..0.008 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
53. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on platform platform16_ (cost=0.00..1.01 rows=1 width=48) (actual time=0.004..0.005 rows=1 loops=1)

54. 0.039 0.128 ↓ 2.5 106 1

Hash (cost=3.47..3.47 rows=42 width=52) (actual time=0.128..0.128 rows=106 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
55. 0.089 0.089 ↓ 2.5 106 1

Index Scan using idx_internal_transaction_registration_date on internal_transaction internaltr1_ (cost=0.43..3.47 rows=42 width=52) (actual time=0.038..0.089 rows=106 loops=1)

  • Index Cond: ((internal_transaction_registration_date >= '2020-09-11 14:35:09'::timestamp without time zone) AND (internal_transaction_registration_date <= '2020-09-11 14:36:09'::timestamp without time zone))
56. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ip_address on ip_address ipaddress17_ (cost=0.42..0.46 rows=1 width=18) (never executed)

  • Index Cond: (id = player10_.ip_address_id)
57. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.14 rows=9 width=12) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Seq Scan on external_game_provider externalga18_ (cost=0.00..1.09 rows=9 width=12) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..16.90 rows=460 width=146) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Seq Scan on casino_game_round casinogame20_ (cost=0.00..14.60 rows=460 width=146) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..11.80 rows=120 width=609) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Seq Scan on casino_game_session casinogame21_ (cost=0.00..11.20 rows=120 width=609) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..20.65 rows=710 width=87) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Seq Scan on casino_game casinogame22_ (cost=0.00..17.10 rows=710 width=87) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..2.04 rows=69 width=536) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Seq Scan on game_publisher gamepublis23_ (cost=0.00..1.69 rows=69 width=536) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_player on player player24_ (cost=0.42..2.61 rows=1 width=797) (never executed)

  • Index Cond: (id = casinogame21_.player_id)
68. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..13.90 rows=260 width=283) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Seq Scan on game_session gamesessio25_ (cost=0.00..12.60 rows=260 width=283) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..23.50 rows=900 width=57) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Seq Scan on game game26_ (cost=0.00..19.00 rows=900 width=57) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..2.04 rows=69 width=536) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Seq Scan on game_publisher gamepublis27_ (cost=0.00..1.69 rows=69 width=536) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_player on player player28_ (cost=0.42..2.57 rows=1 width=797) (never executed)

  • Index Cond: (id = gamesessio25_.player_id)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_player on player player29_ (cost=0.42..2.64 rows=1 width=797) (never executed)

  • Index Cond: (id = internaltr1_.player_id)
Planning time : 41.668 ms
Execution time : 4,301.003 ms