explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QM6w

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.015 361.286 ↑ 1.0 5 1

ProjectSet (cost=18,264.12..18,264.18 rows=5 width=104) (actual time=353.966..361.286 rows=5 loops=1)

2. 0.050 361.271 ↑ 1.0 1 1

Aggregate (cost=18,264.12..18,264.13 rows=1 width=360) (actual time=353.954..361.271 rows=1 loops=1)

3. 31.275 361.221 ↓ 1.5 3 1

Gather (cost=18,263.77..18,263.98 rows=2 width=328) (actual time=349.808..361.221 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 140.624 329.946 ↑ 1.0 1 3 / 3

Aggregate (cost=17,263.77..17,263.78 rows=1 width=328) (actual time=329.908..329.946 rows=1 loops=3)

5. 56.666 189.322 ↑ 2.0 53,653 3 / 3

Hash Join (cost=704.62..11,002 rows=108,900 width=57) (actual time=28.258..189.322 rows=53,653 loops=3)

6. 53.261 119.782 ↑ 2.0 53,653 3 / 3

Hash Join (cost=427.15..10,152.64 rows=108,900 width=116) (actual time=15.301..119.782 rows=53,653 loops=3)

7. 14.477 55.555 ↑ 1.4 76,064 3 / 3

Append (cost=0..9,439.48 rows=108,883 width=74) (actual time=4.171..55.555 rows=76,064 loops=3)

8. 26.557 26.557 ↑ 1.3 53,691 3 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_default dais_125 (cost=0..5,299.14 rows=67,114 width=57) (actual time=4.086..26.557 rows=53,691 loops=3)

9. 0.495 0.495 ↓ 1.7 3,816 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_09_26 dais (cost=0..132.45 rows=2,245 width=57) (actual time=0.159..1.484 rows=3,816 loops=1)

10. 0.478 0.478 ↓ 1.7 3,815 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_09_27 dais_1 (cost=0..132.44 rows=2,244 width=57) (actual time=0.166..1.433 rows=3,815 loops=1)

11. 2.812 2.812 ↓ 1.7 3,813 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_09_28 dais_2 (cost=0..132.43 rows=2,243 width=57) (actual time=0.158..8.436 rows=3,813 loops=1)

12. 2.825 2.825 ↓ 1.7 3,813 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_09_29 dais_3 (cost=0..132.43 rows=2,243 width=57) (actual time=0.205..8.476 rows=3,813 loops=1)

13. 2.993 2.993 ↑ 1.2 1,906 2 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_09_30 dais_4 (cost=0..132.42 rows=2,242 width=57) (actual time=0.083..4.49 rows=1,906 loops=2)

14. 0.422 0.422 ↓ 1.7 3,811 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_01 dais_5 (cost=0..132.42 rows=2,242 width=57) (actual time=0.068..1.267 rows=3,811 loops=1)

15. 0.416 0.416 ↓ 1.7 3,811 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_02 dais_6 (cost=0..132.42 rows=2,242 width=57) (actual time=0.056..1.248 rows=3,811 loops=1)

16. 0.376 0.376 ↓ 1.7 3,811 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_03 dais_7 (cost=0..132.42 rows=2,242 width=57) (actual time=0.053..1.129 rows=3,811 loops=1)

17. 0.404 0.404 ↓ 1.7 3,810 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_04 dais_8 (cost=0..132.41 rows=2,241 width=57) (actual time=0.056..1.213 rows=3,810 loops=1)

18. 0.382 0.382 ↓ 1.7 3,807 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_05 dais_9 (cost=0..131.39 rows=2,239 width=57) (actual time=0.053..1.146 rows=3,807 loops=1)

19. 0.363 0.363 ↓ 1.7 3,633 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_09 dais_13 (cost=0..126.37 rows=2,137 width=57) (actual time=0.051..1.088 rows=3,633 loops=1)

20. 0.360 0.360 ↓ 1.7 3,633 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_10 dais_14 (cost=0..126.37 rows=2,137 width=57) (actual time=0.051..1.079 rows=3,633 loops=1)

21. 0.364 0.364 ↓ 1.7 3,632 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_11 dais_15 (cost=0..126.36 rows=2,136 width=57) (actual time=0.05..1.091 rows=3,632 loops=1)

22. 0.377 0.377 ↓ 1.7 3,632 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_12 dais_16 (cost=0..126.36 rows=2,136 width=57) (actual time=0.05..1.131 rows=3,632 loops=1)

23. 0.392 0.392 ↓ 1.7 3,626 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_13 dais_17 (cost=0..126.33 rows=2,133 width=58) (actual time=0.052..1.177 rows=3,626 loops=1)

24. 0.364 0.364 ↓ 1.7 3,617 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_06 dais_10 (cost=0..125.28 rows=2,128 width=57) (actual time=0.055..1.091 rows=3,617 loops=1)

25. 0.329 0.329 ↓ 1.7 3,614 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_07 dais_11 (cost=0..125.26 rows=2,126 width=57) (actual time=0.051..0.986 rows=3,614 loops=1)

26. 0.349 0.349 ↓ 1.7 3,611 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_08 dais_12 (cost=0..125.24 rows=2,124 width=57) (actual time=0.063..1.046 rows=3,611 loops=1)

27. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_14 dais_18 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

28. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_15 dais_19 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

29. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_16 dais_20 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

30. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_17 dais_21 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

31. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_18 dais_22 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

32. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_19 dais_23 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

33. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_20 dais_24 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

34. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_21 dais_25 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

35. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_22 dais_26 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

36. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_23 dais_27 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

37. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_24 dais_28 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

38. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_25 dais_29 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

39. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_26 dais_30 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

40. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_27 dais_31 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

41. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_28 dais_32 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

42. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_29 dais_33 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

43. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_30 dais_34 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

44. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_31 dais_35 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

45. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_01 dais_36 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

46. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_02 dais_37 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

47. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_03 dais_38 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

48. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_04 dais_39 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

49. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_05 dais_40 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

50. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_06 dais_41 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

51. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_07 dais_42 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

52. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_08 dais_43 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

53. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_09 dais_44 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

54. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_10 dais_45 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

55. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_11 dais_46 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

56. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_12 dais_47 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

57. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_13 dais_48 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

58. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_14 dais_49 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

59. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_15 dais_50 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

60. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_16 dais_51 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

61. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_17 dais_52 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

62. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_18 dais_53 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

63. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_19 dais_54 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

64. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_20 dais_55 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

65. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_21 dais_56 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

66. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_22 dais_57 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

67. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_23 dais_58 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

68. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_24 dais_59 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

69. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_25 dais_60 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

70. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_26 dais_61 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

71. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_27 dais_62 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

72. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_28 dais_63 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

73. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_29 dais_64 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

74. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_11_30 dais_65 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

75. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_01 dais_66 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

76. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_02 dais_67 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

77. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_03 dais_68 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

78. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_04 dais_69 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

79. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_05 dais_70 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

80. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_06 dais_71 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

81. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_07 dais_72 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

82. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_08 dais_73 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

83. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_09 dais_74 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

84. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_10 dais_75 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

85. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_11 dais_76 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

86. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_12 dais_77 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

87. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_13 dais_78 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

88. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_14 dais_79 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

89. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_15 dais_80 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

90. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_16 dais_81 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

91. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_17 dais_82 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

92. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_18 dais_83 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

93. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_19 dais_84 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

94. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_20 dais_85 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

95. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_21 dais_86 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

96. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_22 dais_87 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

97. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_23 dais_88 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

98. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_24 dais_89 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

99. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_25 dais_90 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

100. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_26 dais_91 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

101. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_27 dais_92 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

102. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_28 dais_93 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

103. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_29 dais_94 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

104. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_30 dais_95 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

105. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_12_31 dais_96 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

106. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_01 dais_97 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

107. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_02 dais_98 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

108. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_03 dais_99 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

109. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_04 dais_100 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

110. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_05 dais_101 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

111. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_06 dais_102 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

112. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_07 dais_103 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

113. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_08 dais_104 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

114. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_09 dais_105 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

115. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_10 dais_106 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

116. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_11 dais_107 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

117. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_12 dais_108 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

118. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_13 dais_109 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

119. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_14 dais_110 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

120. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_15 dais_111 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

121. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_16 dais_112 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

122. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_17 dais_113 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

123. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_18 dais_114 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

124. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_19 dais_115 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

125. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_20 dais_116 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

126. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_21 dais_117 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

127. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_22 dais_118 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

128. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_23 dais_119 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

129. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_24 dais_120 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

130. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_25 dais_121 (cost=0..11.82 rows=182 width=192) (actual time=0..0 rows=0 loops=1)

131. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_26 dais_122 (cost=0..11.82 rows=182 width=192) (actual time=0..0.001 rows=0 loops=1)

132. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_27 dais_123 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.001 rows=0 loops=1)

133. 0.001 0.001 ↓ 0.0 0 1 / 3

Seq Scan on daily_amazon_inventory_age_snapshots_p2021_01_28 dais_124 (cost=0..11.82 rows=182 width=192) (actual time=0.001..0.002 rows=0 loops=1)

134. 4.941 10.966 ↑ 1.0 6,540 3 / 3

Hash (cost=345.4..345.4 rows=6,540 width=76) (actual time=10.965..10.966 rows=6,540 loops=3)

135. 6.025 6.025 ↑ 1.0 6,540 3 / 3

Seq Scan on amazon_products ap (cost=0..345.4 rows=6,540 width=76) (actual time=0.017..6.025 rows=6,540 loops=3)

136. 8.422 12.874 ↓ 1.0 6,758 3 / 3

Hash (cost=176.99..176.99 rows=6,699 width=70) (actual time=12.873..12.874 rows=6,758 loops=3)

137. 4.452 4.452 ↓ 1.0 6,758 3 / 3

Seq Scan on amazon_current_cogs acc (cost=0..176.99 rows=6,699 width=70) (actual time=0.018..4.452 rows=6,758 loops=3)

Planning time : 4.561 ms
Execution time : 361.893 ms