explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gD1d

Settings
# exclusive inclusive rows x rows loops node
1. 4.528 1,301,850.220 ↑ 7.4 2,194 1

GroupAggregate (cost=10,868.28..11,394.35 rows=16,187 width=1,600) (actual time=1,301,845.393..1,301,850.220 rows=2,194 loops=1)

  • Group Key: g.name, g.version, sku.sku_name, ps.player_level
2. 14.478 1,301,845.692 ↑ 3.6 4,526 1

Sort (cost=10,868.28..10,908.74 rows=16,187 width=1,575) (actual time=1,301,845.344..1,301,845.692 rows=4,526 loops=1)

  • Sort Key: g.version, sku.sku_name, ps.player_level
  • Sort Method: quicksort Memory: 829kB
3. 1,298,187.122 1,301,831.214 ↑ 3.6 4,526 1

Merge Join (cost=3,004.58..3,254.50 rows=16,187 width=1,575) (actual time=1,283,636.358..1,301,831.214 rows=4,526 loops=1)

  • Merge Cond: (mf.player_stats_id = ps.id)
4. 3.118 3,644.092 ↓ 3.2 4,528 1

Sort (cost=2,699.48..2,703.04 rows=1,423 width=1,579) (actual time=3,642.831..3,644.092 rows=4,528 loops=1)

  • Sort Key: mf.player_stats_id
  • Sort Method: quicksort Memory: 829kB
5. 3,142.013 3,640.974 ↓ 3.2 4,528 1

Hash Join (cost=424.36..2,624.95 rows=1,423 width=1,579) (actual time=3,456.308..3,640.974 rows=4,528 loops=1)

  • Hash Cond: (mf.title_player_id = tp.id)
6. 363.839 498.961 ↓ 32.6 4,528 1

Hash Join (cost=227.31..2,377.72 rows=139 width=1,571) (actual time=479.163..498.961 rows=4,528 loops=1)

  • Hash Cond: (mf.sku_id = sku.id)
7. 83.130 135.122 ↓ 24.3 4,528 1

Hash Join (cost=110.98..2,259.30 rows=186 width=1,063) (actual time=116.737..135.122 rows=4,528 loops=1)

  • Hash Cond: (mf.game_id = g.id)
8. 10.511 51.992 ↑ 1.1 34,824 1

Append (cost=0.00..2,006.72 rows=37,262 width=39) (actual time=0.378..51.992 rows=34,824 loops=1)

9. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d1 mf (cost=0.00..11.20 rows=60 width=64) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: verified
10. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d2 mf_1 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
11. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d3 mf_2 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
12. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d4 mf_3 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
13. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d5 mf_4 (cost=0.00..11.20 rows=60 width=64) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: verified
14. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d6 mf_5 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
15. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d7 mf_6 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
16. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d8 mf_7 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
17. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d9 mf_8 (cost=0.00..11.20 rows=60 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: verified
18. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d10 mf_9 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
19. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d11 mf_10 (cost=0.00..11.20 rows=60 width=64) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: verified
20. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d12 mf_11 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
21. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d13 mf_12 (cost=0.00..11.20 rows=60 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: verified
22. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d14 mf_13 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
23. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d15 mf_14 (cost=0.00..11.20 rows=60 width=64) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: verified
24. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d16 mf_15 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
25. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d17 mf_16 (cost=0.00..11.20 rows=60 width=64) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: verified
26. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d18 mf_17 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
27. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d19 mf_18 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
28. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d20 mf_19 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
29. 0.294 0.294 ↑ 1.0 1 1

Seq Scan on monetize_fact_y2019_m7_d21 mf_20 (cost=0.00..1.01 rows=1 width=64) (actual time=0.293..0.294 rows=1 loops=1)

  • Filter: verified
30. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d22 mf_21 (cost=0.00..11.20 rows=60 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: verified
31. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d23 mf_22 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
32. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d24 mf_23 (cost=0.00..11.20 rows=60 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: verified
33. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d25 mf_24 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
34. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d26 mf_25 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
35. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d27 mf_26 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
36. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d28 mf_27 (cost=0.00..11.20 rows=60 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: verified
37. 0.287 0.287 ↑ 1.0 1 1

Seq Scan on monetize_fact_y2019_m7_d29 mf_28 (cost=0.00..1.01 rows=1 width=64) (actual time=0.287..0.287 rows=1 loops=1)

  • Filter: verified
38. 0.271 0.271 ↑ 1.0 1 1

Seq Scan on monetize_fact_y2019_m7_d30 mf_29 (cost=0.00..1.01 rows=1 width=64) (actual time=0.270..0.271 rows=1 loops=1)

  • Filter: verified
39. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m7_d31 mf_30 (cost=0.00..11.20 rows=60 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: verified
40. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m8_d1 mf_31 (cost=0.00..11.20 rows=60 width=64) (actual time=0.004..0.005 rows=0 loops=1)

  • Filter: verified
41. 34.991 34.991 ↑ 1.0 1 1

Seq Scan on monetize_fact_y2019_m8_d2 mf_32 (cost=0.00..1.01 rows=1 width=64) (actual time=34.990..34.991 rows=1 loops=1)

  • Filter: verified
42. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m8_d3 mf_33 (cost=0.00..11.20 rows=60 width=64) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: verified
43. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m8_d4 mf_34 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
44. 0.017 0.017 ↓ 2.0 2 1

Seq Scan on monetize_fact_y2019_m8_d5 mf_35 (cost=0.00..1.02 rows=1 width=64) (actual time=0.016..0.017 rows=2 loops=1)

  • Filter: verified
45. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on monetize_fact_y2019_m8_d6 mf_36 (cost=0.00..1.01 rows=1 width=64) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: verified
46. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on monetize_fact_y2019_m8_d7 mf_37 (cost=0.00..1.01 rows=1 width=64) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: verified
47. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on monetize_fact_y2019_m8_d8 mf_38 (cost=0.00..11.20 rows=60 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: verified
48. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on monetize_fact_y2019_m8_d9 mf_39 (cost=0.00..1.01 rows=1 width=64) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: verified
49. 0.005 0.005 ↓ 2.0 4 1

Seq Scan on monetize_fact_y2019_m8_d10 mf_40 (cost=0.00..1.04 rows=2 width=64) (actual time=0.004..0.005 rows=4 loops=1)

  • Filter: verified
50. 0.011 0.011 ↑ 3.0 2 1

Seq Scan on monetize_fact_y2019_m8_d11 mf_41 (cost=0.00..1.13 rows=6 width=64) (actual time=0.008..0.011 rows=2 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 11
51. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on monetize_fact_y2019_m8_d12 mf_42 (cost=0.00..1.30 rows=2 width=37) (actual time=0.014..0.015 rows=2 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 28
52. 0.042 0.042 ↑ 1.0 37 1

Seq Scan on monetize_fact_y2019_m8_d13 mf_43 (cost=0.00..4.02 rows=37 width=36) (actual time=0.011..0.042 rows=37 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 65
53. 0.174 0.174 ↑ 1.0 346 1

Seq Scan on monetize_fact_y2019_m8_d14 mf_44 (cost=0.00..13.26 rows=346 width=37) (actual time=0.005..0.174 rows=346 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 80
54. 0.302 0.302 ↑ 1.0 489 1

Seq Scan on monetize_fact_y2019_m8_d15 mf_45 (cost=0.00..26.36 rows=489 width=37) (actual time=0.023..0.302 rows=489 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 347
55. 0.255 0.255 ↑ 1.0 514 1

Seq Scan on monetize_fact_y2019_m8_d16 mf_46 (cost=0.00..22.29 rows=514 width=37) (actual time=0.005..0.255 rows=514 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 215
56. 0.209 0.209 ↑ 1.0 488 1

Seq Scan on monetize_fact_y2019_m8_d17 mf_47 (cost=0.00..19.12 rows=488 width=37) (actual time=0.011..0.209 rows=488 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 124
57. 0.275 0.275 ↑ 1.0 558 1

Seq Scan on monetize_fact_y2019_m8_d18 mf_48 (cost=0.00..25.84 rows=558 width=37) (actual time=0.012..0.275 rows=558 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 226
58. 0.167 0.167 ↑ 1.0 458 1

Seq Scan on monetize_fact_y2019_m8_d19 mf_49 (cost=0.00..17.83 rows=458 width=37) (actual time=0.010..0.167 rows=458 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 125
59. 0.212 0.212 ↑ 1.0 455 1

Seq Scan on monetize_fact_y2019_m8_d20 mf_50 (cost=0.00..23.48 rows=455 width=37) (actual time=0.014..0.212 rows=455 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 293
60. 0.155 0.155 ↑ 1.0 466 1

Seq Scan on monetize_fact_y2019_m8_d21 mf_51 (cost=0.00..16.23 rows=466 width=37) (actual time=0.010..0.155 rows=466 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 57
61. 0.177 0.177 ↑ 1.0 424 1

Seq Scan on monetize_fact_y2019_m8_d22 mf_52 (cost=0.00..17.76 rows=424 width=37) (actual time=0.005..0.177 rows=424 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 152
62. 0.206 0.206 ↑ 1.0 529 1

Seq Scan on monetize_fact_y2019_m8_d23 mf_53 (cost=0.00..21.91 rows=529 width=37) (actual time=0.006..0.206 rows=529 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 162
63. 0.174 0.174 ↑ 1.0 450 1

Seq Scan on monetize_fact_y2019_m8_d24 mf_54 (cost=0.00..17.80 rows=450 width=37) (actual time=0.006..0.174 rows=450 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 130
64. 0.176 0.176 ↑ 1.0 464 1

Seq Scan on monetize_fact_y2019_m8_d25 mf_55 (cost=0.00..19.30 rows=464 width=37) (actual time=0.005..0.176 rows=464 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 166
65. 0.170 0.170 ↑ 1.0 493 1

Seq Scan on monetize_fact_y2019_m8_d26 mf_56 (cost=0.00..17.60 rows=493 width=37) (actual time=0.009..0.170 rows=493 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 67
66. 0.177 0.177 ↑ 1.0 461 1

Seq Scan on monetize_fact_y2019_m8_d27 mf_57 (cost=0.00..19.19 rows=461 width=37) (actual time=0.006..0.177 rows=461 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 158
67. 0.165 0.165 ↑ 1.0 475 1

Seq Scan on monetize_fact_y2019_m8_d28 mf_58 (cost=0.00..16.14 rows=475 width=37) (actual time=0.010..0.165 rows=475 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 39
68. 0.162 0.162 ↑ 1.0 385 1

Seq Scan on monetize_fact_y2019_m8_d29 mf_59 (cost=0.00..17.64 rows=385 width=37) (actual time=0.014..0.162 rows=385 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 179
69. 0.149 0.149 ↑ 1.0 431 1

Seq Scan on monetize_fact_y2019_m8_d30 mf_60 (cost=0.00..16.28 rows=431 width=37) (actual time=0.005..0.149 rows=431 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 97
70. 0.121 0.121 ↑ 1.0 367 1

Seq Scan on monetize_fact_y2019_m8_d31 mf_61 (cost=0.00..13.06 rows=367 width=37) (actual time=0.005..0.121 rows=367 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 39
71. 0.093 0.093 ↑ 1.0 264 1

Seq Scan on monetize_fact_y2019_m9_d1 mf_62 (cost=0.00..8.92 rows=264 width=37) (actual time=0.007..0.093 rows=264 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 28
72. 0.156 0.156 ↑ 1.0 400 1

Seq Scan on monetize_fact_y2019_m9_d2 mf_63 (cost=0.00..13.41 rows=400 width=37) (actual time=0.009..0.156 rows=400 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 41
73. 0.161 0.161 ↑ 1.0 402 1

Seq Scan on monetize_fact_y2019_m9_d3 mf_64 (cost=0.00..16.13 rows=402 width=37) (actual time=0.023..0.161 rows=402 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 111
74. 0.143 0.143 ↑ 1.0 364 1

Seq Scan on monetize_fact_y2019_m9_d4 mf_65 (cost=0.00..15.99 rows=364 width=37) (actual time=0.009..0.143 rows=364 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 135
75. 0.168 0.168 ↑ 1.0 355 1

Seq Scan on monetize_fact_y2019_m9_d5 mf_66 (cost=0.00..20.51 rows=355 width=37) (actual time=0.005..0.168 rows=355 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 296
76. 0.131 0.131 ↑ 1.0 360 1

Seq Scan on monetize_fact_y2019_m9_d6 mf_67 (cost=0.00..13.27 rows=360 width=37) (actual time=0.005..0.131 rows=360 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 67
77. 0.110 0.110 ↑ 1.0 327 1

Seq Scan on monetize_fact_y2019_m9_d7 mf_68 (cost=0.00..12.83 rows=327 width=37) (actual time=0.005..0.110 rows=327 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 56
78. 0.263 0.263 ↑ 1.0 321 1

Seq Scan on monetize_fact_y2019_m9_d8 mf_69 (cost=0.00..35.02 rows=321 width=37) (actual time=0.007..0.263 rows=321 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 681
79. 0.133 0.133 ↑ 1.0 364 1

Seq Scan on monetize_fact_y2019_m9_d9 mf_70 (cost=0.00..16.01 rows=364 width=37) (actual time=0.006..0.133 rows=364 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 137
80. 0.112 0.112 ↑ 1.0 301 1

Seq Scan on monetize_fact_y2019_m9_d10 mf_71 (cost=0.00..11.48 rows=301 width=37) (actual time=0.008..0.112 rows=301 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 47
81. 0.142 0.142 ↑ 1.0 395 1

Seq Scan on monetize_fact_y2019_m9_d11 mf_72 (cost=0.00..15.88 rows=395 width=37) (actual time=0.006..0.142 rows=395 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 93
82. 0.174 0.174 ↑ 1.0 511 1

Seq Scan on monetize_fact_y2019_m9_d12 mf_73 (cost=0.00..17.60 rows=511 width=37) (actual time=0.009..0.174 rows=511 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 49
83. 0.190 0.190 ↑ 1.0 570 1

Seq Scan on monetize_fact_y2019_m9_d13 mf_74 (cost=0.00..20.52 rows=570 width=37) (actual time=0.005..0.190 rows=570 loops=1)

  • Filter: verified