explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cYaw

Settings
# exclusive inclusive rows x rows loops node
1. 5.087 3,023.452 ↑ 3.2 9,280 1

Sort (cost=134,346.60..134,421.10 rows=29,800 width=576) (actual time=3,022.879..3,023.452 rows=9,280 loops=1)

  • Sort Key: (sum(mf.amount)) DESC
  • Sort Method: quicksort Memory: 1690kB
2. 18.452 3,018.365 ↑ 3.2 9,280 1

GroupAggregate (cost=121,599.12..127,656.86 rows=29,800 width=576) (actual time=2,996.940..3,018.365 rows=9,280 loops=1)

  • Group Key: tp.player_id, g.name
3. 20.993 2,999.913 ↑ 8.2 34,824 1

Sort (cost=121,599.12..122,309.78 rows=284,262 width=555) (actual time=2,996.921..2,999.913 rows=34,824 loops=1)

  • Sort Key: tp.player_id, g.name
  • Sort Method: quicksort Memory: 5600kB
4. 2,951.674 2,978.920 ↑ 8.2 34,824 1

Hash Join (cost=313.37..12,762.95 rows=284,262 width=555) (actual time=2,767.476..2,978.920 rows=34,824 loops=1)

  • Hash Cond: (mf.title_player_id = tp.id)
5. 10.128 27.246 ↓ 1.3 34,824 1

Hash Join (cost=116.33..2,540.38 rows=27,760 width=547) (actual time=0.576..27.246 rows=34,824 loops=1)

  • Hash Cond: (mf.game_id = g.id)
6. 11.858 17.118 ↑ 1.1 34,824 1

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

7. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Filter: verified
8. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
9. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
10. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
11. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
12. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
13. 0.001 0.001 ↓ 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.001 rows=0 loops=1)

  • Filter: verified
14. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
15. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
16. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
17. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
18. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
19. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
20. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
21. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
22. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
23. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
24. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
25. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
26. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

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

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

  • Filter: verified
29. 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
30. 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
31. 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
32. 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
33. 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
34. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: verified
35. 0.010 0.010 ↑ 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.009..0.010 rows=1 loops=1)

  • Filter: verified
36. 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
37. 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
38. 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
39. 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
40. 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
41. 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
42. 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
43. 0.005 0.005 ↑ 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.005 rows=1 loops=1)

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

  • Filter: verified
47. 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
48. 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
49. 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
50. 0.034 0.034 ↑ 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.009..0.034 rows=37 loops=1)

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

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

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

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

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

  • Filter: verified
  • Rows Removed by Filter: 226
56. 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.006..0.167 rows=458 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Filter: verified
  • Rows Removed by Filter: 137
78. 0.098 0.098 ↑ 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.098 rows=301 loops=1)

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

  • Filter: verified
  • Rows Removed by Filter: 93
80. 0.168 0.168 ↑ 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.168 rows=511 loops=1)

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

  • Filter: verified
  • Rows Removed by Filter: 82
82. 0.170 0.170 ↑ 1.0 490 1

Seq Scan on monetize_fact_y2019_m9_d14 mf_75 (cost=0.00..17.85 rows=490 width=37) (actual time=0.006..0.170 rows=490 loops=1)

  • Filter: verified
  • Rows Removed by Filter: 95