explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2xey

Settings
# exclusive inclusive rows x rows loops node
1. 21.391 341,353.042 ↑ 2.4 6,741 1

GroupAggregate (cost=10,867.72..11,393.80 rows=16,187 width=1,600) (actual time=341,329.184..341,353.042 rows=6,741 loops=1)

  • Group Key: g.name, g.version, sku.sku_name, ps.player_level
2. 102.134 341,331.651 ↓ 1.9 30,296 1

Sort (cost=10,867.72..10,908.19 rows=16,187 width=1,575) (actual time=341,329.139..341,331.651 rows=30,296 loops=1)

  • Sort Key: g.version, sku.sku_name, ps.player_level
  • Sort Method: quicksort Memory: 5029kB
3. 338,312.223 341,229.517 ↓ 1.9 30,296 1

Merge Left Join (cost=3,004.02..3,253.94 rows=16,187 width=1,575) (actual time=322,590.348..341,229.517 rows=30,296 loops=1)

  • Merge Cond: (mf.player_stats_id = ps.id)
4. 19.332 2,917.294 ↓ 21.3 30,296 1

Sort (cost=2,698.92..2,702.48 rows=1,423 width=1,579) (actual time=2,911.133..2,917.294 rows=30,296 loops=1)

  • Sort Key: mf.player_stats_id
  • Sort Method: quicksort Memory: 5029kB
5. 2,864.163 2,897.962 ↓ 21.3 30,296 1

Hash Join (cost=424.36..2,624.39 rows=1,423 width=1,579) (actual time=2,683.123..2,897.962 rows=30,296 loops=1)

  • Hash Cond: (mf.title_player_id = tp.id)
6. 9.873 33.799 ↓ 218.0 30,296 1

Hash Join (cost=227.31..2,377.16 rows=139 width=1,571) (actual time=1.976..33.799 rows=30,296 loops=1)

  • Hash Cond: (mf.sku_id = sku.id)
7. 8.396 23.926 ↓ 162.9 30,296 1

Hash Join (cost=110.98..2,258.74 rows=186 width=1,063) (actual time=0.604..23.926 rows=30,296 loops=1)

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

Append (cost=0.00..2,006.27 rows=37,235 width=39) (actual time=0.058..15.530 rows=34,824 loops=1)

9. 0.006 0.006 ↓ 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.006..0.006 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.002 0.002 ↓ 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.002..0.002 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.001..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.002 0.002 ↓ 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.002..0.002 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.002 0.002 ↓ 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.002..0.002 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.002 0.002 ↓ 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.002..0.002 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.002 0.002 ↓ 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.002..0.002 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.002 0.002 ↓ 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.002..0.002 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.012 0.012 ↑ 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.011..0.012 rows=1 loops=1)

  • Filter: verified
30. 0.003 0.003 ↓ 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.003..0.003 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.002 0.002 ↓ 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.002..0.002 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.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Filter: verified
37. 0.007 0.007 ↑ 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.007..0.007 rows=1 loops=1)

  • Filter: verified
38. 0.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

  • Filter: verified
39. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Filter: verified
40. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Filter: verified
41. 0.004 0.004 ↑ 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=0.004..0.004 rows=1 loops=1)

  • Filter: verified
42. 0.002 0.002 ↓ 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.002..0.002 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.006 0.006 ↓ 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.005..0.006 rows=2 loops=1)

  • Filter: verified
45. 0.006 0.006 ↑ 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.005..0.006 rows=1 loops=1)

  • Filter: verified
46. 0.005 0.005 ↑ 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.005..0.005 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.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

  • Filter: verified
49. 0.006 0.006 ↓ 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.005..0.006 rows=4 loops=1)

  • Filter: verified
50. 0.008 0.008 ↑ 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.005..0.008 rows=2 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 11
51. 0.010 0.010 ↑ 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.009..0.010 rows=2 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 28
52. 0.048 0.048 ↑ 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.017..0.048 rows=37 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 65
53. 0.134 0.134 ↑ 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.134 rows=346 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 80
54. 0.246 0.246 ↑ 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.016..0.246 rows=489 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 347
55. 0.217 0.217 ↑ 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.006..0.217 rows=514 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 215
56. 0.180 0.180 ↑ 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.009..0.180 rows=488 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 124
57. 0.223 0.223 ↑ 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.014..0.223 rows=558 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 226
58. 0.163 0.163 ↑ 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.005..0.163 rows=458 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 125
59. 0.189 0.189 ↑ 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.005..0.189 rows=455 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 293
60. 0.169 0.169 ↑ 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.005..0.169 rows=466 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 57
61. 0.160 0.160 ↑ 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.006..0.160 rows=424 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 152
62. 0.188 0.188 ↑ 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.005..0.188 rows=529 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 162
63. 0.159 0.159 ↑ 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.005..0.159 rows=450 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 130
64. 0.174 0.174 ↑ 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.174 rows=464 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 166
65. 0.166 0.166 ↑ 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.013..0.166 rows=493 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 67
66. 0.169 0.169 ↑ 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.005..0.169 rows=461 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 158
67. 0.148 0.148 ↑ 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.005..0.148 rows=475 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 39
68. 0.160 0.160 ↑ 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.011..0.160 rows=385 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 179
69. 0.153 0.153 ↑ 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.006..0.153 rows=431 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 97
70. 0.120 0.120 ↑ 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.007..0.120 rows=367 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 39
71. 0.087 0.087 ↑ 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.004..0.087 rows=264 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 28
72. 0.126 0.126 ↑ 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.005..0.126 rows=400 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 41
73. 0.150 0.150 ↑ 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.011..0.150 rows=402 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 111
74. 0.137 0.137 ↑ 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.005..0.137 rows=364 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 135
75. 0.180 0.180 ↑ 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.180 rows=355 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 296
76. 0.121 0.121 ↑ 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.121 rows=360 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 67
77. 0.106 0.106 ↑ 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.106 rows=327 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 56
78. 0.227 0.227 ↑ 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.004..0.227 rows=321 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 681
79. 0.136 0.136 ↑ 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.005..0.136 rows=364 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 137
80. 0.100 0.100 ↑ 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.005..0.100 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.159 0.159 ↑ 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.005..0.159 rows=511 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 49
83. 0.209 0.209 ↑ 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.209 rows=570 loops=1)

  • Filter: verified