explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yydr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,336.058 ↑ 1.0 1 1

Finalize Aggregate (cost=82,439.02..82,439.03 rows=1 width=384) (actual time=4,336.057..4,336.058 rows=1 loops=1)

2. 25.593 4,352.470 ↓ 1.5 3 1

Gather (cost=82,438.66..82,438.87 rows=2 width=384) (actual time=4,335.305..4,352.470 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,724.476 4,326.877 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=81,438.66..81,438.67 rows=1 width=384) (actual time=4,326.877..4,326.877 rows=1 loops=3)

4. 21.331 1,602.401 ↑ 1.2 183,383 3 / 3

Parallel Append (cost=0.00..54,029.67 rows=228,408 width=90) (actual time=0.909..1,602.401 rows=183,383 loops=3)

5. 41.997 41.997 ↓ 1.7 16,137 1 / 3

Parallel Seq Scan on prod_stats_daily_20190722 (cost=0.00..1,508.57 rows=9,457 width=89) (actual time=1.380..125.990 rows=16,137 loops=1)

6. 42.355 42.355 ↓ 1.7 13,352 1 / 3

Parallel Seq Scan on prod_stats_daily_20190624 (cost=0.00..1,428.36 rows=7,836 width=93) (actual time=1.318..127.064 rows=13,352 loops=1)

7. 28.049 28.049 ↓ 1.7 15,129 1 / 3

Parallel Seq Scan on prod_stats_daily_20190729 (cost=0.00..1,422.68 rows=8,868 width=89) (actual time=2.181..84.146 rows=15,129 loops=1)

8. 30.703 30.703 ↓ 1.7 15,086 1 / 3

Parallel Seq Scan on prod_stats_daily_20190923 (cost=0.00..1,410.67 rows=8,867 width=90) (actual time=2.376..92.109 rows=15,086 loops=1)

9. 34.891 34.891 ↓ 1.7 13,027 1 / 3

Parallel Seq Scan on prod_stats_daily_20190617 (cost=0.00..1,392.35 rows=7,635 width=92) (actual time=1.869..104.673 rows=13,027 loops=1)

10. 38.979 38.979 ↓ 1.7 14,875 1 / 3

Parallel Seq Scan on prod_stats_daily_20190916 (cost=0.00..1,373.15 rows=8,715 width=89) (actual time=1.687..116.937 rows=14,875 loops=1)

11. 43.063 43.063 ↓ 1.7 14,607 1 / 3

Parallel Seq Scan on prod_stats_daily_20190715 (cost=0.00..1,367.78 rows=8,578 width=91) (actual time=1.799..129.189 rows=14,607 loops=1)

12. 43.496 43.496 ↓ 1.7 14,475 1 / 3

Parallel Seq Scan on prod_stats_daily_20190930 (cost=0.00..1,347.90 rows=8,490 width=89) (actual time=1.588..130.487 rows=14,475 loops=1)

13. 34.174 34.174 ↓ 1.7 12,632 1 / 3

Parallel Seq Scan on prod_stats_daily_20190701 (cost=0.00..1,258.13 rows=7,413 width=92) (actual time=1.961..102.523 rows=12,632 loops=1)

14. 33.899 33.899 ↓ 1.7 13,318 1 / 3

Parallel Seq Scan on prod_stats_daily_20190909 (cost=0.00..1,248.24 rows=7,824 width=90) (actual time=1.559..101.696 rows=13,318 loops=1)

15. 31.970 31.970 ↓ 1.7 13,328 1 / 3

Parallel Seq Scan on prod_stats_daily_20190805 (cost=0.00..1,248.12 rows=7,812 width=89) (actual time=1.641..95.909 rows=13,328 loops=1)

16. 34.456 34.456 ↓ 1.7 13,397 1 / 3

Parallel Seq Scan on prod_stats_daily_20190708 (cost=0.00..1,245.77 rows=7,877 width=91) (actual time=1.320..103.368 rows=13,397 loops=1)

17. 31.957 31.957 ↓ 1.7 13,319 1 / 3

Parallel Seq Scan on prod_stats_daily_20191007 (cost=0.00..1,243.03 rows=7,803 width=88) (actual time=1.581..95.872 rows=13,319 loops=1)

18. 37.231 37.231 ↓ 1.7 12,985 1 / 3

Parallel Seq Scan on prod_stats_daily_20190902 (cost=0.00..1,221.28 rows=7,628 width=90) (actual time=1.792..111.694 rows=12,985 loops=1)

19. 39.144 39.144 ↓ 1.7 13,311 1 / 3

Parallel Seq Scan on prod_stats_daily_20191021 (cost=0.00..1,218.02 rows=7,802 width=84) (actual time=1.748..117.431 rows=13,311 loops=1)

20. 38.785 38.785 ↓ 1.7 12,889 1 / 3

Parallel Seq Scan on prod_stats_daily_20191014 (cost=0.00..1,187.78 rows=7,578 width=86) (actual time=1.624..116.355 rows=12,889 loops=1)

21. 39.028 39.028 ↓ 1.7 12,725 1 / 3

Parallel Seq Scan on prod_stats_daily_20190819 (cost=0.00..1,185.82 rows=7,482 width=90) (actual time=1.602..117.084 rows=12,725 loops=1)

22. 36.212 36.212 ↓ 1.7 12,796 1 / 3

Parallel Seq Scan on prod_stats_daily_20191104 (cost=0.00..1,169.09 rows=7,509 width=85) (actual time=1.873..108.637 rows=12,796 loops=1)

23. 36.661 36.661 ↓ 1.7 12,013 1 / 3

Parallel Seq Scan on prod_stats_daily_20190826 (cost=0.00..1,124.38 rows=7,038 width=90) (actual time=1.529..109.982 rows=12,013 loops=1)

24. 38.943 38.943 ↓ 1.7 10,120 1 / 3

Parallel Seq Scan on prod_stats_daily_20190513 (cost=0.00..1,119.25 rows=5,925 width=93) (actual time=1.698..116.828 rows=10,120 loops=1)

25. 37.520 37.520 ↓ 1.7 10,920 1 / 3

Parallel Seq Scan on prod_stats_daily_20200504 (cost=0.00..1,096.24 rows=6,424 width=94) (actual time=4.260..112.561 rows=10,920 loops=1)

26. 29.984 29.984 ↓ 1.7 11,529 1 / 3

Parallel Seq Scan on prod_stats_daily_20200210 (cost=0.00..1,065.50 rows=6,750 width=88) (actual time=1.900..89.951 rows=11,529 loops=1)

27. 36.756 36.756 ↓ 1.7 9,401 1 / 3

Parallel Seq Scan on prod_stats_daily_20190520 (cost=0.00..1,034.23 rows=5,523 width=94) (actual time=2.170..110.267 rows=9,401 loops=1)

28. 34.678 34.678 ↓ 1.7 10,918 1 / 3

Parallel Seq Scan on prod_stats_daily_20190812 (cost=0.00..1,015.08 rows=6,408 width=90) (actual time=1.936..104.033 rows=10,918 loops=1)

29. 31.839 31.839 ↓ 1.7 9,114 1 / 3

Parallel Seq Scan on prod_stats_daily_20190610 (cost=0.00..977.36 rows=5,336 width=93) (actual time=1.956..95.517 rows=9,114 loops=1)

30. 29.069 29.069 ↓ 1.7 9,491 1 / 3

Parallel Seq Scan on prod_stats_daily_20200511 (cost=0.00..946.67 rows=5,567 width=96) (actual time=2.979..87.208 rows=9,491 loops=1)

31. 26.771 26.771 ↓ 1.7 9,556 1 / 3

Parallel Seq Scan on prod_stats_daily_20200120 (cost=0.00..883.00 rows=5,600 width=88) (actual time=1.669..80.314 rows=9,556 loops=1)

32. 28.991 28.991 ↓ 1.7 7,994 1 / 3

Parallel Seq Scan on prod_stats_daily_20190506 (cost=0.00..879.02 rows=4,702 width=92) (actual time=1.827..86.973 rows=7,994 loops=1)

33. 27.755 27.755 ↑ 1.8 3,139 3 / 3

Parallel Seq Scan on prod_stats_daily_20200203 (cost=0.00..872.39 rows=5,539 width=88) (actual time=0.559..27.755 rows=3,139 loops=3)

34. 26.169 26.169 ↑ 1.2 4,760 2 / 3

Parallel Seq Scan on prod_stats_daily_20191028 (cost=0.00..871.68 rows=5,568 width=86) (actual time=0.868..39.254 rows=4,760 loops=2)

35. 24.974 24.974 ↓ 1.7 9,337 1 / 3

Parallel Seq Scan on prod_stats_daily_20200127 (cost=0.00..867.78 rows=5,478 width=90) (actual time=1.587..74.921 rows=9,337 loops=1)

36. 25.077 25.077 ↓ 1.7 8,523 1 / 3

Parallel Seq Scan on prod_stats_daily_20200427 (cost=0.00..853.56 rows=4,956 width=93) (actual time=1.769..75.231 rows=8,523 loops=1)

37. 27.361 27.361 ↓ 1.7 9,014 1 / 3

Parallel Seq Scan on prod_stats_daily_20200217 (cost=0.00..836.78 rows=5,278 width=88) (actual time=1.355..82.082 rows=9,014 loops=1)

38. 28.376 28.376 ↓ 1.7 7,461 1 / 3

Parallel Seq Scan on prod_stats_daily_20190527 (cost=0.00..825.75 rows=4,375 width=93) (actual time=2.394..85.129 rows=7,461 loops=1)

39. 23.662 23.662 ↓ 1.7 8,504 1 / 3

Parallel Seq Scan on prod_stats_daily_20200113 (cost=0.00..784.71 rows=4,971 width=88) (actual time=1.566..70.987 rows=8,504 loops=1)

40. 25.508 25.508 ↓ 1.7 7,983 1 / 3

Parallel Seq Scan on prod_stats_daily_20200224 (cost=0.00..721.75 rows=4,675 width=87) (actual time=1.994..76.525 rows=7,983 loops=1)

41. 25.724 25.724 ↓ 1.7 7,954 1 / 3

Parallel Seq Scan on prod_stats_daily_20200302 (cost=0.00..721.40 rows=4,640 width=89) (actual time=1.634..77.171 rows=7,954 loops=1)

42. 23.156 23.156 ↓ 1.7 7,359 1 / 3

Parallel Seq Scan on prod_stats_daily_20200106 (cost=0.00..680.92 rows=4,292 width=88) (actual time=2.185..69.467 rows=7,359 loops=1)

43. 22.669 22.669 ↓ 1.7 5,880 1 / 3

Parallel Seq Scan on prod_stats_daily_20190603 (cost=0.00..641.55 rows=3,455 width=92) (actual time=1.728..68.006 rows=5,880 loops=1)

44. 19.925 19.925 ↓ 1.7 7,018 1 / 3

Parallel Seq Scan on prod_stats_daily_20200309 (cost=0.00..633.14 rows=4,114 width=87) (actual time=1.641..59.774 rows=7,018 loops=1)

45. 19.500 19.500 ↓ 1.7 5,728 1 / 3

Parallel Seq Scan on prod_stats_daily_20190422 (cost=0.00..613.73 rows=3,373 width=89) (actual time=1.761..58.499 rows=5,728 loops=1)

46. 21.420 21.420 ↓ 1.7 5,623 1 / 3

Parallel Seq Scan on prod_stats_daily_20190429 (cost=0.00..610.90 rows=3,290 width=92) (actual time=7.842..64.260 rows=5,623 loops=1)

47. 16.903 16.903 ↓ 1.7 6,400 1 / 3

Parallel Seq Scan on prod_stats_daily_20191202 (cost=0.00..585.40 rows=3,740 width=87) (actual time=1.626..50.708 rows=6,400 loops=1)

48. 13.523 13.523 ↓ 1.7 6,111 1 / 3

Parallel Seq Scan on prod_stats_daily_20191216 (cost=0.00..565.82 rows=3,582 width=88) (actual time=1.718..40.570 rows=6,111 loops=1)

49. 15.627 15.627 ↓ 1.7 6,126 1 / 3

Parallel Seq Scan on prod_stats_daily_20191230 (cost=0.00..561.75 rows=3,575 width=86) (actual time=1.669..46.881 rows=6,126 loops=1)

50. 16.705 16.705 ↓ 1.7 5,338 1 / 3

Parallel Seq Scan on prod_stats_daily_20190401 (cost=0.00..555.08 rows=3,108 width=91) (actual time=1.847..50.114 rows=5,338 loops=1)

51. 13.831 13.831 ↓ 1.7 5,152 1 / 3

Parallel Seq Scan on prod_stats_daily_20190408 (cost=0.00..546.20 rows=3,020 width=92) (actual time=1.902..41.492 rows=5,152 loops=1)

52. 17.181 17.181 ↓ 1.7 6,069 1 / 3

Parallel Seq Scan on prod_stats_daily_20200420 (cost=0.00..544.66 rows=3,566 width=89) (actual time=1.571..51.544 rows=6,069 loops=1)

53. 19.112 19.112 ↓ 1.7 5,087 1 / 3

Parallel Seq Scan on prod_stats_daily_20190415 (cost=0.00..538.85 rows=2,985 width=90) (actual time=1.696..57.337 rows=5,087 loops=1)

54. 18.204 18.204 ↓ 1.7 5,699 1 / 3

Parallel Seq Scan on prod_stats_daily_20191209 (cost=0.00..535.49 rows=3,349 width=88) (actual time=1.760..54.613 rows=5,699 loops=1)

55. 17.980 17.980 ↓ 1.7 5,776 1 / 3

Parallel Seq Scan on prod_stats_daily_20191111 (cost=0.00..530.59 rows=3,359 width=86) (actual time=1.572..53.940 rows=5,776 loops=1)

56. 15.989 15.989 ↓ 1.7 5,788 1 / 3

Parallel Seq Scan on prod_stats_daily_20191223 (cost=0.00..527.98 rows=3,398 width=87) (actual time=2.204..47.968 rows=5,788 loops=1)

57. 11.461 11.461 ↓ 1.7 4,949 1 / 3

Parallel Seq Scan on prod_stats_daily_20191125 (cost=0.00..466.83 rows=2,883 width=88) (actual time=2.461..34.384 rows=4,949 loops=1)

58. 9.169 9.169 ↓ 1.7 4,866 1 / 3

Parallel Seq Scan on prod_stats_daily_20191118 (cost=0.00..459.38 rows=2,838 width=85) (actual time=1.737..27.508 rows=4,866 loops=1)

59. 9.281 9.281 ↓ 1.7 4,738 1 / 3

Parallel Seq Scan on prod_stats_daily_20200413 (cost=0.00..430.80 rows=2,780 width=91) (actual time=1.519..27.842 rows=4,738 loops=1)

60. 9.318 9.318 ↓ 1.7 4,557 1 / 3

Parallel Seq Scan on prod_stats_daily_20200316 (cost=0.00..407.77 rows=2,677 width=86) (actual time=2.119..27.954 rows=4,557 loops=1)

61. 8.783 8.783 ↓ 1.7 4,248 1 / 3

Parallel Seq Scan on prod_stats_daily_20200330 (cost=0.00..384.74 rows=2,474 width=89) (actual time=1.567..26.349 rows=4,248 loops=1)

62. 11.494 11.494 ↓ 1.7 4,174 1 / 3

Parallel Seq Scan on prod_stats_daily_20200323 (cost=0.00..376.31 rows=2,431 width=87) (actual time=1.735..34.481 rows=4,174 loops=1)

63. 11.281 11.281 ↓ 1.7 3,895 1 / 3

Parallel Seq Scan on prod_stats_daily_20200406 (cost=0.00..356.66 rows=2,266 width=89) (actual time=1.670..33.844 rows=3,895 loops=1)

64. 11.681 11.681 ↓ 1.7 3,077 1 / 3

Parallel Seq Scan on prod_stats_daily_20190325 (cost=0.00..317.85 rows=1,785 width=91) (actual time=1.713..35.042 rows=3,077 loops=1)

65. 0.672 0.672 ↓ 1.7 333 1 / 3

Parallel Seq Scan on prod_stats_daily_20200518 (cost=0.00..41.96 rows=196 width=96) (actual time=0.025..2.016 rows=333 loops=1)

Planning time : 435.993 ms
Execution time : 4,353.486 ms