explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DdGc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 209,290.121 ↑ 1.0 1 1

Finalize Aggregate (cost=3,317,194.59..3,317,194.60 rows=1 width=384) (actual time=209,290.121..209,290.121 rows=1 loops=1)

2. 292.628 209,566.796 ↓ 1.5 3 1

Gather (cost=3,317,194.23..3,317,194.44 rows=2 width=384) (actual time=209,289.455..209,566.796 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 195,377.959 209,274.168 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=3,316,194.23..3,316,194.24 rows=1 width=384) (actual time=209,274.167..209,274.168 rows=1 loops=3)

4. 731.307 13,896.209 ↑ 1.2 7,051,685 3 / 3

Parallel Append (cost=0.00..2,260,249.40 rows=8,799,540 width=164) (actual time=0.741..13,896.209 rows=7,051,685 loops=3)

5. 296.712 296.712 ↓ 2.4 405,679 1 / 3

Parallel Seq Scan on prod_stats_daily_20200302 (cost=0.00..41,073.33 rows=169,033 width=180) (actual time=1.097..890.137 rows=405,679 loops=1)

6. 278.861 278.861 ↓ 2.4 310,286 1 / 3

Parallel Seq Scan on prod_stats_daily_20190520 (cost=0.00..37,430.66 rows=129,266 width=213) (actual time=1.099..836.584 rows=310,286 loops=1)

7. 218.514 218.514 ↓ 2.4 308,741 1 / 3

Parallel Seq Scan on prod_stats_daily_20200504 (cost=0.00..36,721.38 rows=128,538 width=178) (actual time=1.270..655.541 rows=308,741 loops=1)

8. 218.431 218.431 ↓ 2.4 308,004 1 / 3

Parallel Seq Scan on prod_stats_daily_20190513 (cost=0.00..36,573.22 rows=128,322 width=198) (actual time=1.367..655.293 rows=308,004 loops=1)

9. 217.716 217.716 ↓ 2.4 343,925 1 / 3

Parallel Seq Scan on prod_stats_daily_20200210 (cost=0.00..35,113.82 rows=143,282 width=168) (actual time=1.332..653.147 rows=343,925 loops=1)

10. 205.982 205.982 ↓ 2.4 343,303 1 / 3

Parallel Seq Scan on prod_stats_daily_20200127 (cost=0.00..34,927.45 rows=143,045 width=164) (actual time=0.847..617.946 rows=343,303 loops=1)

11. 195.551 195.551 ↓ 2.4 344,326 1 / 3

Parallel Seq Scan on prod_stats_daily_20200309 (cost=0.00..34,172.52 rows=143,452 width=166) (actual time=6.375..586.652 rows=344,326 loops=1)

12. 206.929 206.929 ↓ 2.4 330,532 1 / 3

Parallel Seq Scan on prod_stats_daily_20191125 (cost=0.00..33,966.17 rows=137,717 width=174) (actual time=6.594..620.787 rows=330,532 loops=1)

13. 218.323 218.323 ↓ 2.6 280,880 1 / 3

Parallel Seq Scan on prod_stats_daily_20200427 (cost=0.00..33,771.28 rows=108,228 width=168) (actual time=1.178..654.968 rows=280,880 loops=1)

14. 210.813 210.813 ↓ 2.5 276,622 1 / 3

Parallel Seq Scan on prod_stats_daily_20200511 (cost=0.00..33,334.11 rows=109,611 width=207) (actual time=0.940..632.439 rows=276,622 loops=1)

15. 213.622 213.622 ↓ 2.4 327,736 1 / 3

Parallel Seq Scan on prod_stats_daily_20200203 (cost=0.00..33,190.62 rows=136,562 width=166) (actual time=1.287..640.866 rows=327,736 loops=1)

16. 210.880 210.880 ↓ 2.4 324,383 1 / 3

Parallel Seq Scan on prod_stats_daily_20200120 (cost=0.00..32,598.72 rows=135,172 width=156) (actual time=1.329..632.640 rows=324,383 loops=1)

17. 326.866 326.866 ↓ 2.4 318,066 1 / 3

Parallel Seq Scan on prod_stats_daily_20200217 (cost=0.00..31,883.08 rows=132,508 width=160) (actual time=1.698..980.597 rows=318,066 loops=1)

18. 354.949 354.949 ↓ 2.4 266,563 1 / 3

Parallel Seq Scan on prod_stats_daily_20190624 (cost=0.00..30,975.50 rows=111,050 width=187) (actual time=1.165..1,064.847 rows=266,563 loops=1)

19. 272.331 272.331 ↓ 2.4 308,856 1 / 3

Parallel Seq Scan on prod_stats_daily_20191230 (cost=0.00..30,837.67 rows=128,668 width=160) (actual time=1.356..816.993 rows=308,856 loops=1)

20. 239.927 239.927 ↓ 2.4 292,386 1 / 3

Parallel Seq Scan on prod_stats_daily_20190729 (cost=0.00..30,760.12 rows=121,812 width=191) (actual time=1.268..719.782 rows=292,386 loops=1)

21. 197.343 197.343 ↓ 2.4 292,182 1 / 3

Parallel Seq Scan on prod_stats_daily_20190722 (cost=0.00..30,585.20 rows=121,720 width=186) (actual time=1.129..592.030 rows=292,182 loops=1)

22. 182.004 182.004 ↓ 2.4 259,808 1 / 3

Parallel Seq Scan on prod_stats_daily_20190506 (cost=0.00..30,458.41 rows=108,241 width=182) (actual time=1.290..546.011 rows=259,808 loops=1)

23. 203.974 203.974 ↓ 2.4 302,430 1 / 3

Parallel Seq Scan on prod_stats_daily_20200113 (cost=0.00..30,035.00 rows=126,000 width=150) (actual time=1.467..611.921 rows=302,430 loops=1)

24. 214.275 214.275 ↓ 2.4 266,531 1 / 3

Parallel Seq Scan on prod_stats_daily_20190701 (cost=0.00..29,296.47 rows=111,047 width=184) (actual time=1.358..642.826 rows=266,531 loops=1)

25. 178.162 178.162 ↓ 2.4 292,095 1 / 3

Parallel Seq Scan on prod_stats_daily_20200106 (cost=0.00..29,014.04 rows=121,704 width=150) (actual time=1.141..534.485 rows=292,095 loops=1)

26. 169.634 169.634 ↓ 2.4 289,230 1 / 3

Parallel Seq Scan on prod_stats_daily_20191118 (cost=0.00..28,899.03 rows=120,502 width=147) (actual time=1.268..508.901 rows=289,230 loops=1)

27. 182.639 182.639 ↓ 2.4 249,086 1 / 3

Parallel Seq Scan on prod_stats_daily_20190617 (cost=0.00..28,620.73 rows=103,773 width=176) (actual time=1.305..547.918 rows=249,086 loops=1)

28. 184.666 184.666 ↓ 2.4 244,011 1 / 3

Parallel Seq Scan on prod_stats_daily_20190527 (cost=0.00..28,424.56 rows=101,656 width=177) (actual time=1.176..553.998 rows=244,011 loops=1)

29. 181.188 181.188 ↓ 2.4 285,857 1 / 3

Parallel Seq Scan on prod_stats_daily_20191223 (cost=0.00..28,344.95 rows=119,095 width=157) (actual time=1.522..543.564 rows=285,857 loops=1)

30. 144.348 144.348 ↓ 2.4 284,803 1 / 3

Parallel Seq Scan on prod_stats_daily_20200224 (cost=0.00..27,766.55 rows=118,655 width=154) (actual time=1.163..433.043 rows=284,803 loops=1)

31. 131.483 131.483 ↓ 2.4 267,813 1 / 3

Parallel Seq Scan on prod_stats_daily_20190715 (cost=0.00..27,761.71 rows=111,571 width=180) (actual time=1.433..394.450 rows=267,813 loops=1)

32. 131.306 131.306 ↓ 2.4 263,278 1 / 3

Parallel Seq Scan on prod_stats_daily_20190826 (cost=0.00..27,251.97 rows=109,697 width=174) (actual time=1.338..393.919 rows=263,278 loops=1)

33. 126.909 126.909 ↓ 2.4 267,184 1 / 3

Parallel Seq Scan on prod_stats_daily_20191209 (cost=0.00..26,749.47 rows=111,347 width=151) (actual time=1.260..380.728 rows=267,184 loops=1)

34. 130.027 130.027 ↓ 2.4 259,055 1 / 3

Parallel Seq Scan on prod_stats_daily_20190819 (cost=0.00..26,718.25 rows=107,925 width=176) (actual time=1.023..390.080 rows=259,055 loops=1)

35. 124.587 124.587 ↓ 2.4 255,097 1 / 3

Parallel Seq Scan on prod_stats_daily_20190902 (cost=0.00..26,393.88 rows=106,288 width=172) (actual time=1.531..373.760 rows=255,097 loops=1)

36. 122.796 122.796 ↓ 2.4 231,591 1 / 3

Parallel Seq Scan on prod_stats_daily_20190610 (cost=0.00..26,328.84 rows=96,484 width=167) (actual time=1.357..368.389 rows=231,591 loops=1)

37. 109.785 109.785 ↓ 2.4 228,342 1 / 3

Parallel Seq Scan on prod_stats_daily_20190429 (cost=0.00..26,183.22 rows=95,122 width=165) (actual time=1.519..329.355 rows=228,342 loops=1)

38. 128.626 128.626 ↓ 2.4 262,712 1 / 3

Parallel Seq Scan on prod_stats_daily_20191104 (cost=0.00..26,150.41 rows=109,441 width=155) (actual time=1.203..385.877 rows=262,712 loops=1)

39. 119.159 119.159 ↓ 2.4 261,060 1 / 3

Parallel Seq Scan on prod_stats_daily_20191111 (cost=0.00..25,752.72 rows=108,772 width=146) (actual time=1.268..357.478 rows=261,060 loops=1)

40. 125.694 125.694 ↓ 2.4 261,996 1 / 3

Parallel Seq Scan on prod_stats_daily_20191202 (cost=0.00..25,703.53 rows=109,152 width=152) (actual time=1.395..377.081 rows=261,996 loops=1)

41. 116.828 116.828 ↓ 2.4 248,866 1 / 3

Parallel Seq Scan on prod_stats_daily_20190805 (cost=0.00..25,671.77 rows=103,677 width=172) (actual time=2.200..350.485 rows=248,866 loops=1)

42. 126.765 126.765 ↓ 2.4 248,516 1 / 3

Parallel Seq Scan on prod_stats_daily_20190909 (cost=0.00..25,482.46 rows=103,546 width=165) (actual time=1.325..380.295 rows=248,516 loops=1)

43. 123.190 123.190 ↓ 2.4 245,300 1 / 3

Parallel Seq Scan on prod_stats_daily_20190708 (cost=0.00..25,193.86 rows=102,186 width=172) (actual time=1.212..369.570 rows=245,300 loops=1)

44. 123.448 123.448 ↓ 2.4 252,975 1 / 3

Parallel Seq Scan on prod_stats_daily_20191216 (cost=0.00..24,900.99 rows=105,399 width=150) (actual time=1.372..370.343 rows=252,975 loops=1)

45. 114.055 114.055 ↓ 2.4 244,985 1 / 3

Parallel Seq Scan on prod_stats_daily_20200420 (cost=0.00..24,457.60 rows=102,060 width=158) (actual time=1.183..342.166 rows=244,985 loops=1)

46. 119.867 119.867 ↓ 2.4 214,271 1 / 3

Parallel Seq Scan on prod_stats_daily_20190603 (cost=0.00..24,445.67 rows=89,267 width=161) (actual time=1.128..359.602 rows=214,271 loops=1)

47. 116.045 116.045 ↓ 2.4 245,935 1 / 3

Parallel Seq Scan on prod_stats_daily_20191028 (cost=0.00..24,328.50 rows=102,450 width=146) (actual time=1.314..348.135 rows=245,935 loops=1)

48. 115.880 115.880 ↓ 2.4 242,035 1 / 3

Parallel Seq Scan on prod_stats_daily_20191014 (cost=0.00..24,075.40 rows=100,840 width=150) (actual time=1.347..347.640 rows=242,035 loops=1)

49. 121.357 121.357 ↓ 2.4 246,740 1 / 3

Parallel Seq Scan on prod_stats_daily_20200316 (cost=0.00..23,993.98 rows=102,798 width=146) (actual time=1.138..364.072 rows=246,740 loops=1)

50. 117.468 117.468 ↓ 2.4 235,470 1 / 3

Parallel Seq Scan on prod_stats_daily_20190923 (cost=0.00..23,824.92 rows=98,092 width=157) (actual time=1.259..352.405 rows=235,470 loops=1)

51. 107.788 107.788 ↓ 2.4 238,312 1 / 3

Parallel Seq Scan on prod_stats_daily_20200413 (cost=0.00..23,669.87 rows=99,287 width=153) (actual time=1.185..323.364 rows=238,312 loops=1)

52. 105.454 105.454 ↓ 2.4 229,788 1 / 3

Parallel Seq Scan on prod_stats_daily_20190812 (cost=0.00..23,568.33 rows=95,732 width=174) (actual time=1.126..316.363 rows=229,788 loops=1)

53. 108.489 108.489 ↓ 2.4 238,004 1 / 3

Parallel Seq Scan on prod_stats_daily_20191021 (cost=0.00..23,500.51 rows=99,151 width=145) (actual time=6.291..325.468 rows=238,004 loops=1)

54. 111.968 111.968 ↓ 2.4 230,312 1 / 3

Parallel Seq Scan on prod_stats_daily_20190916 (cost=0.00..23,147.58 rows=95,958 width=160) (actual time=1.334..335.903 rows=230,312 loops=1)

55. 111.273 111.273 ↓ 2.4 231,407 1 / 3

Parallel Seq Scan on prod_stats_daily_20190930 (cost=0.00..23,018.12 rows=96,412 width=151) (actual time=1.212..333.818 rows=231,407 loops=1)

56. 109.827 109.827 ↓ 2.4 228,640 1 / 3

Parallel Seq Scan on prod_stats_daily_20191007 (cost=0.00..22,808.47 rows=95,247 width=149) (actual time=1.295..329.481 rows=228,640 loops=1)

57. 95.242 95.242 ↓ 2.4 191,570 1 / 3

Parallel Seq Scan on prod_stats_daily_20190422 (cost=0.00..21,878.06 rows=79,806 width=165) (actual time=1.270..285.725 rows=191,570 loops=1)

58. 93.848 93.848 ↓ 2.4 224,504 1 / 3

Parallel Seq Scan on prod_stats_daily_20200323 (cost=0.00..21,872.18 rows=93,518 width=143) (actual time=1.317..281.544 rows=224,504 loops=1)

59. 97.329 97.329 ↓ 2.4 212,937 1 / 3

Parallel Seq Scan on prod_stats_daily_20200406 (cost=0.00..21,111.09 rows=88,709 width=142) (actual time=1.155..291.987 rows=212,937 loops=1)

60. 90.016 90.016 ↓ 2.4 202,424 1 / 3

Parallel Seq Scan on prod_stats_daily_20200330 (cost=0.00..19,696.38 rows=84,338 width=137) (actual time=1.110..270.049 rows=202,424 loops=1)

61. 93.846 93.846 ↓ 2.4 170,788 1 / 3

Parallel Seq Scan on prod_stats_daily_20190304 (cost=0.00..19,475.49 rows=71,149 width=164) (actual time=1.160..281.539 rows=170,788 loops=1)

62. 83.637 83.637 ↓ 2.4 154,708 1 / 3

Parallel Seq Scan on prod_stats_daily_20190415 (cost=0.00..17,594.52 rows=64,452 width=159) (actual time=1.242..250.911 rows=154,708 loops=1)

63. 67.148 67.148 ↓ 2.4 144,045 1 / 3

Parallel Seq Scan on prod_stats_daily_20190408 (cost=0.00..16,222.01 rows=60,001 width=153) (actual time=5.492..201.445 rows=144,045 loops=1)

64. 63.204 63.204 ↓ 2.4 142,570 1 / 3

Parallel Seq Scan on prod_stats_daily_20190225 (cost=0.00..16,023.99 rows=59,399 width=148) (actual time=1.027..189.612 rows=142,570 loops=1)

65. 61.538 61.538 ↓ 2.4 136,176 1 / 3

Parallel Seq Scan on prod_stats_daily_20190204 (cost=0.00..15,553.38 rows=56,738 width=148) (actual time=1.266..184.613 rows=136,176 loops=1)

66. 59.901 59.901 ↓ 2.4 135,252 1 / 3

Parallel Seq Scan on prod_stats_daily_20190401 (cost=0.00..14,897.40 rows=56,340 width=145) (actual time=1.347..179.703 rows=135,252 loops=1)

67. 65.947 65.947 ↓ 2.4 133,546 1 / 3

Parallel Seq Scan on prod_stats_daily_20190325 (cost=0.00..14,794.39 rows=55,639 width=143) (actual time=1.208..197.842 rows=133,546 loops=1)

68. 67.136 67.136 ↑ 1.2 43,769 3 / 3

Parallel Seq Scan on prod_stats_daily_20190318 (cost=0.00..14,737.01 rows=54,701 width=148) (actual time=0.406..67.136 rows=43,769 loops=3)

69. 57.765 57.765 ↓ 1.2 63,719 2 / 3

Parallel Seq Scan on prod_stats_daily_20190211 (cost=0.00..14,498.89 rows=53,089 width=145) (actual time=0.632..86.648 rows=63,719 loops=2)

70. 63.588 63.588 ↓ 2.4 122,600 1 / 3

Parallel Seq Scan on prod_stats_daily_20181119 (cost=0.00..13,895.66 rows=51,066 width=153) (actual time=1.256..190.764 rows=122,600 loops=1)

71. 76.940 76.940 ↓ 2.4 121,687 1 / 3

Parallel Seq Scan on prod_stats_daily_20190311 (cost=0.00..13,434.93 rows=50,693 width=145) (actual time=1.284..230.821 rows=121,687 loops=1)

72. 75.404 75.404 ↓ 2.4 117,775 1 / 3

Parallel Seq Scan on prod_stats_daily_20190218 (cost=0.00..13,237.63 rows=49,063 width=140) (actual time=1.409..226.211 rows=117,775 loops=1)

73. 60.364 60.364 ↓ 2.4 113,811 1 / 3

Parallel Seq Scan on prod_stats_daily_20190128 (cost=0.00..12,939.11 rows=47,411 width=143) (actual time=1.264..181.091 rows=113,811 loops=1)

74. 69.854 69.854 ↓ 2.4 104,586 1 / 3

Parallel Seq Scan on prod_stats_daily_20200518 (cost=0.00..12,680.81 rows=43,381 width=177) (actual time=1.244..209.563 rows=104,586 loops=1)

75. 69.048 69.048 ↓ 2.4 133,488 1 / 3

Parallel Seq Scan on prod_stats_daily_20180528 (cost=0.00..12,062.10 rows=55,610 width=127) (actual time=1.273..207.144 rows=133,488 loops=1)

76. 60.544 60.544 ↓ 2.4 125,899 1 / 3

Parallel Seq Scan on prod_stats_daily_20180521 (cost=0.00..11,720.45 rows=52,445 width=119) (actual time=1.294..181.632 rows=125,899 loops=1)

77. 92.807 92.807 ↓ 2.4 98,235 1 / 3

Parallel Seq Scan on prod_stats_daily_20180305 (cost=0.00..11,675.24 rows=40,924 width=349) (actual time=1.050..278.422 rows=98,235 loops=1)

78. 54.963 54.963 ↓ 2.4 122,005 1 / 3

Parallel Seq Scan on prod_stats_daily_20180604 (cost=0.00..10,719.25 rows=50,825 width=129) (actual time=1.307..164.890 rows=122,005 loops=1)

79. 47.832 47.832 ↓ 2.4 88,736 1 / 3

Parallel Seq Scan on prod_stats_daily_20190121 (cost=0.00..10,132.53 rows=36,953 width=135) (actual time=1.300..143.496 rows=88,736 loops=1)

80. 44.471 44.471 ↓ 2.4 104,583 1 / 3

Parallel Seq Scan on prod_stats_daily_20180514 (cost=0.00..9,669.74 rows=43,574 width=114) (actual time=1.261..133.414 rows=104,583 loops=1)

81. 48.445 48.445 ↓ 2.4 84,105 1 / 3

Parallel Seq Scan on prod_stats_daily_20181224 (cost=0.00..9,648.29 rows=35,029 width=134) (actual time=3.372..145.336 rows=84,105 loops=1)

82. 47.548 47.548 ↓ 2.4 84,402 1 / 3

Parallel Seq Scan on prod_stats_daily_20190114 (cost=0.00..9,624.50 rows=35,150 width=132) (actual time=1.201..142.645 rows=84,402 loops=1)

83. 50.048 50.048 ↓ 2.4 107,403 1 / 3

Parallel Seq Scan on prod_stats_daily_20180806 (cost=0.00..9,619.26 rows=44,726 width=131) (actual time=2.044..150.143 rows=107,403 loops=1)

84. 75.118 75.118 ↓ 2.4 74,792 1 / 3

Parallel Seq Scan on prod_stats_daily_20180326 (cost=0.00..9,516.63 rows=31,163 width=387) (actual time=1.331..225.353 rows=74,792 loops=1)

85. 45.054 45.054 ↓ 2.4 85,245 1 / 3

Parallel Seq Scan on prod_stats_daily_20181022 (cost=0.00..9,482.19 rows=35,519 width=134) (actual time=1.310..135.161 rows=85,245 loops=1)

86. 42.773 42.773 ↓ 2.4 82,450 1 / 3

Parallel Seq Scan on prod_stats_daily_20181231 (cost=0.00..9,423.44 rows=34,344 width=130) (actual time=1.195..128.320 rows=82,450 loops=1)

87. 77.001 77.001 ↓ 2.4 76,395 1 / 3

Parallel Seq Scan on prod_stats_daily_20180319 (cost=0.00..9,423.29 rows=31,829 width=380) (actual time=1.289..231.003 rows=76,395 loops=1)

88. 53.805 53.805 ↓ 2.4 79,914 1 / 3

Parallel Seq Scan on prod_stats_daily_20190107 (cost=0.00..9,112.77 rows=33,278 width=131) (actual time=1.479..161.414 rows=79,914 loops=1)

89. 48.266 48.266 ↓ 2.4 101,654 1 / 3

Parallel Seq Scan on prod_stats_daily_20180730 (cost=0.00..9,076.36 rows=42,336 width=128) (actual time=1.389..144.797 rows=101,654 loops=1)

90. 56.910 56.910 ↓ 2.4 97,208 1 / 3

Parallel Seq Scan on prod_stats_daily_20180813 (cost=0.00..9,046.78 rows=40,478 width=131) (actual time=1.535..170.731 rows=97,208 loops=1)

91. 47.710 47.710 ↓ 2.4 78,814 1 / 3

Parallel Seq Scan on prod_stats_daily_20181217 (cost=0.00..8,982.34 rows=32,834 width=130) (actual time=1.530..143.131 rows=78,814 loops=1)

92. 58.285 58.285 ↓ 2.4 80,615 1 / 3

Parallel Seq Scan on prod_stats_daily_20181126 (cost=0.00..8,980.77 rows=33,577 width=137) (actual time=1.215..174.856 rows=80,615 loops=1)

93. 44.538 44.538 ↓ 2.4 80,936 1 / 3

Parallel Seq Scan on prod_stats_daily_20181008 (cost=0.00..8,959.08 rows=33,708 width=134) (actual time=1.217..133.615 rows=80,936 loops=1)

94. 43.756 43.756 ↓ 2.4 97,346 1 / 3

Parallel Seq Scan on prod_stats_daily_20180723 (cost=0.00..8,658.53 rows=40,553 width=126) (actual time=0.977..131.269 rows=97,346 loops=1)

95. 44.741 44.741 ↓ 2.4 93,708 1 / 3

Parallel Seq Scan on prod_stats_daily_20180507 (cost=0.00..8,612.45 rows=39,045 width=111) (actual time=1.135..134.222 rows=93,708 loops=1)

96. 78.739 78.739 ↓ 2.4 71,471 1 / 3

Parallel Seq Scan on prod_stats_daily_20180312 (cost=0.00..8,608.72 rows=29,772 width=368) (actual time=1.355..236.216 rows=71,471 loops=1)

97. 56.433 56.433 ↓ 2.4 73,933 1 / 3

Parallel Seq Scan on prod_stats_daily_20181210 (cost=0.00..8,469.95 rows=30,795 width=130) (actual time=1.078..169.299 rows=73,933 loops=1)

98. 61.040 61.040 ↓ 2.4 75,497 1 / 3

Parallel Seq Scan on prod_stats_daily_20181029 (cost=0.00..8,274.50 rows=31,450 width=130) (actual time=1.214..183.121 rows=75,497 loops=1)

99. 85.184 85.184 ↓ 2.4 66,871 1 / 3

Parallel Seq Scan on prod_stats_daily_20180226 (cost=0.00..8,220.60 rows=27,860 width=388) (actual time=1.246..255.551 rows=66,871 loops=1)

100. 60.139 60.139 ↓ 2.4 73,987 1 / 3

Parallel Seq Scan on prod_stats_daily_20181015 (cost=0.00..8,175.23 rows=30,823 width=132) (actual time=1.194..180.418 rows=73,987 loops=1)

101. 52.854 52.854 ↓ 2.4 73,593 1 / 3

Parallel Seq Scan on prod_stats_daily_20181105 (cost=0.00..8,133.49 rows=30,649 width=132) (actual time=1.376..158.563 rows=73,593 loops=1)

102. 80.637 80.637 ↓ 2.4 66,524 1 / 3

Parallel Seq Scan on prod_stats_daily_20180219 (cost=0.00..8,077.03 rows=27,703 width=384) (actual time=2.571..241.911 rows=66,524 loops=1)

103. 51.769 51.769 ↓ 2.4 72,712 1 / 3

Parallel Seq Scan on prod_stats_daily_20181112 (cost=0.00..7,971.87 rows=30,287 width=129) (actual time=1.161..155.306 rows=72,712 loops=1)

104. 50.193 50.193 ↓ 2.4 70,815 1 / 3

Parallel Seq Scan on prod_stats_daily_20181203 (cost=0.00..7,936.96 rows=29,496 width=131) (actual time=1.320..150.578 rows=70,815 loops=1)

105. 61.022 61.022 ↓ 2.4 71,836 1 / 3

Parallel Seq Scan on prod_stats_daily_20181001 (cost=0.00..7,860.16 rows=29,916 width=129) (actual time=1.508..183.067 rows=71,836 loops=1)

106. 96.504 96.504 ↓ 2.4 85,253 1 / 3

Parallel Seq Scan on prod_stats_daily_20180430 (cost=0.00..7,791.22 rows=35,522 width=108) (actual time=1.171..289.513 rows=85,253 loops=1)

107. 106.602 106.602 ↓ 2.4 76,766 1 / 3

Parallel Seq Scan on prod_stats_daily_20180402 (cost=0.00..7,762.63 rows=31,963 width=186) (actual time=1.264..319.807 rows=76,766 loops=1)

108. 92.424 92.424 ↓ 2.4 70,915 1 / 3

Parallel Seq Scan on prod_stats_daily_20180924 (cost=0.00..7,742.38 rows=29,538 width=128) (actual time=1.234..277.272 rows=70,915 loops=1)

109. 69.977 69.977 ↓ 2.4 88,968 1 / 3

Parallel Seq Scan on prod_stats_daily_20180702 (cost=0.00..7,620.57 rows=37,058 width=119) (actual time=1.174..209.930 rows=88,968 loops=1)

110. 55.278 55.278 ↓ 2.4 83,568 1 / 3

Parallel Seq Scan on prod_stats_daily_20180416 (cost=0.00..7,612.96 rows=34,796 width=108) (actual time=1.133..165.834 rows=83,568 loops=1)

111. 52.219 52.219 ↓ 2.4 88,129 1 / 3

Parallel Seq Scan on prod_stats_daily_20180709 (cost=0.00..7,555.18 rows=36,718 width=118) (actual time=1.160..156.658 rows=88,129 loops=1)

112. 45.531 45.531 ↓ 2.4 86,887 1 / 3

Parallel Seq Scan on prod_stats_daily_20180716 (cost=0.00..7,494.85 rows=36,185 width=121) (actual time=1.134..136.594 rows=86,887 loops=1)

113. 45.750 45.750 ↓ 2.4 81,768 1 / 3

Parallel Seq Scan on prod_stats_daily_20180409 (cost=0.00..7,441.48 rows=34,048 width=107) (actual time=1.060..137.250 rows=81,768 loops=1)

114. 52.468 52.468 ↓ 2.4 77,001 1 / 3

Parallel Seq Scan on prod_stats_daily_20180827 (cost=0.00..7,365.79 rows=32,079 width=128) (actual time=1.322..157.405 rows=77,001 loops=1)

115. 44.952 44.952 ↓ 2.4 80,217 1 / 3

Parallel Seq Scan on prod_stats_daily_20180423 (cost=0.00..7,299.09 rows=33,409 width=108) (actual time=1.305..134.855 rows=80,217 loops=1)

116. 45.207 45.207 ↓ 2.4 84,731 1 / 3

Parallel Seq Scan on prod_stats_daily_20180618 (cost=0.00..7,293.87 rows=35,287 width=120) (actual time=1.287..135.621 rows=84,731 loops=1)

117. 47.198 47.198 ↓ 2.4 84,599 1 / 3

Parallel Seq Scan on prod_stats_daily_20180625 (cost=0.00..7,262.25 rows=35,225 width=119) (actual time=1.210..141.593 rows=84,599 loops=1)

118. 44.648 44.648 ↓ 2.4 74,575 1 / 3

Parallel Seq Scan on prod_stats_daily_20180903 (cost=0.00..7,022.53 rows=31,053 width=127) (actual time=1.309..133.945 rows=74,575 loops=1)

119. 47.241 47.241 ↓ 2.4 80,908 1 / 3

Parallel Seq Scan on prod_stats_daily_20180611 (cost=0.00..6,970.92 rows=33,692 width=119) (actual time=1.156..141.722 rows=80,908 loops=1)

120. 68.541 68.541 ↓ 2.4 58,376 1 / 3

Parallel Seq Scan on prod_stats_daily_20180205 (cost=0.00..6,935.16 rows=24,316 width=368) (actual time=1.382..205.624 rows=58,376 loops=1)

121. 41.423 41.423 ↓ 2.4 69,763 1 / 3

Parallel Seq Scan on prod_stats_daily_20180820 (cost=0.00..6,720.43 rows=29,043 width=127) (actual time=1.211..124.269 rows=69,763 loops=1)

122. 66.920 66.920 ↓ 2.4 54,539 1 / 3

Parallel Seq Scan on prod_stats_daily_20180212 (cost=0.00..6,643.21 rows=22,721 width=393) (actual time=1.142..200.761 rows=54,539 loops=1)

123. 44.237 44.237 ↓ 2.4 70,465 1 / 3

Parallel Seq Scan on prod_stats_daily_20180910 (cost=0.00..6,574.48 rows=29,348 width=125) (actual time=1.258..132.712 rows=70,465 loops=1)

124. 40.437 40.437 ↓ 2.4 67,220 1 / 3

Parallel Seq Scan on prod_stats_daily_20180917 (cost=0.00..6,318.01 rows=28,001 width=124) (actual time=1.296..121.310 rows=67,220 loops=1)

125. 69.520 69.520 ↓ 2.4 51,700 1 / 3

Parallel Seq Scan on prod_stats_daily_20180129 (cost=0.00..6,133.29 rows=21,529 width=367) (actual time=1.469..208.559 rows=51,700 loops=1)

126. 28.726 28.726 ↓ 1.7 19,807 1 / 3

Parallel Seq Scan on prod_stats_daily_20180122 (cost=0.00..2,362.51 rows=11,651 width=360) (actual time=0.018..86.177 rows=19,807 loops=1)

127. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on prod_stats_daily_pre_2018 (cost=0.00..13.71 rows=371 width=32) (actual time=0.000..0.000 rows=0 loops=1)

128. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on prod_stats_daily_20180101 (cost=0.00..13.71 rows=371 width=32) (actual time=0.000..0.000 rows=0 loops=1)

129. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on prod_stats_daily_20180108 (cost=0.00..13.71 rows=371 width=32) (actual time=0.000..0.000 rows=0 loops=1)

130. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Seq Scan on prod_stats_daily_20180115 (cost=0.00..13.71 rows=371 width=32) (actual time=0.003..0.003 rows=0 loops=1)

Planning time : 24.851 ms
Execution time : 209,568.572 ms