explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AvNN : Optimization for: plan #QM6w

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.013 47.147 ↑ 1.0 5 1

ProjectSet (cost=3,267.51..3,267.57 rows=5 width=104) (actual time=47.081..47.147 rows=5 loops=1)

2. 0.000 47.134 ↑ 1.0 1 1

Aggregate (cost=3,267.51..3,267.52 rows=1 width=360) (actual time=47.071..47.134 rows=1 loops=1)

3.          

Initplan (for Aggregate)

4. 0.001 27.165 ↑ 1.0 1 1

Limit (cost=28.19..47.8 rows=1 width=4) (actual time=27.119..27.165 rows=1 loops=1)

5. 11.914 27.164 ↑ 1,315.0 1 1

Nested Loop (cost=28.19..25,813.22 rows=1,315 width=4) (actual time=27.118..27.164 rows=1 loops=1)

6. 3.683 15.250 ↑ 5.4 48,377 1

Merge Append (cost=28.04..21,866.29 rows=262,983 width=36) (actual time=1.152..15.25 rows=48,377 loops=1)

7. 0.007 0.007 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_23_date_idx on daily_amazon_inventory_snapshots_p2020_07_23 daily_amazon_inventory_snapshots_p2020_07_23 (cost=0.14..14.89 rows=250 width=36) (actual time=0.007..0.007 rows=0 loops=1)

8. 0.011 0.011 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_24_date_idx on daily_amazon_inventory_snapshots_p2020_07_24 daily_amazon_inventory_snapshots_p2020_07_24 (cost=0.14..14.89 rows=250 width=36) (actual time=0.011..0.011 rows=0 loops=1)

9. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_25_date_idx on daily_amazon_inventory_snapshots_p2020_07_25 daily_amazon_inventory_snapshots_p2020_07_25 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

10. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_26_date_idx on daily_amazon_inventory_snapshots_p2020_07_26 daily_amazon_inventory_snapshots_p2020_07_26 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

11. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_27_date_idx on daily_amazon_inventory_snapshots_p2020_07_27 daily_amazon_inventory_snapshots_p2020_07_27 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

12. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_28_date_idx on daily_amazon_inventory_snapshots_p2020_07_28 daily_amazon_inventory_snapshots_p2020_07_28 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.006 rows=0 loops=1)

13. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_29_date_idx on daily_amazon_inventory_snapshots_p2020_07_29 daily_amazon_inventory_snapshots_p2020_07_29 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

14. 0.009 0.009 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_30_date_idx on daily_amazon_inventory_snapshots_p2020_07_30 daily_amazon_inventory_snapshots_p2020_07_30 (cost=0.14..14.89 rows=250 width=36) (actual time=0.009..0.009 rows=0 loops=1)

15. 0.008 0.008 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_31_date_idx on daily_amazon_inventory_snapshots_p2020_07_31 daily_amazon_inventory_snapshots_p2020_07_31 (cost=0.14..14.89 rows=250 width=36) (actual time=0.008..0.008 rows=0 loops=1)

16. 0.008 0.008 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_01_date_idx on daily_amazon_inventory_snapshots_p2020_08_01 daily_amazon_inventory_snapshots_p2020_08_01 (cost=0.14..14.89 rows=250 width=36) (actual time=0.007..0.008 rows=0 loops=1)

17. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_02_date_idx on daily_amazon_inventory_snapshots_p2020_08_02 daily_amazon_inventory_snapshots_p2020_08_02 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

18. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_03_date_idx on daily_amazon_inventory_snapshots_p2020_08_03 daily_amazon_inventory_snapshots_p2020_08_03 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.006 rows=0 loops=1)

19. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_04_date_idx on daily_amazon_inventory_snapshots_p2020_08_04 daily_amazon_inventory_snapshots_p2020_08_04 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

20. 0.007 0.007 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_05_date_idx on daily_amazon_inventory_snapshots_p2020_08_05 daily_amazon_inventory_snapshots_p2020_08_05 (cost=0.14..14.89 rows=250 width=36) (actual time=0.007..0.007 rows=0 loops=1)

21. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_06_date_idx on daily_amazon_inventory_snapshots_p2020_08_06 daily_amazon_inventory_snapshots_p2020_08_06 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

22. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_07_date_idx on daily_amazon_inventory_snapshots_p2020_08_07 daily_amazon_inventory_snapshots_p2020_08_07 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

23. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_08_date_idx on daily_amazon_inventory_snapshots_p2020_08_08 daily_amazon_inventory_snapshots_p2020_08_08 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

24. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_09_date_idx on daily_amazon_inventory_snapshots_p2020_08_09 daily_amazon_inventory_snapshots_p2020_08_09 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

25. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_10_date_idx on daily_amazon_inventory_snapshots_p2020_08_10 daily_amazon_inventory_snapshots_p2020_08_10 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.006 rows=0 loops=1)

26. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_11_date_idx on daily_amazon_inventory_snapshots_p2020_08_11 daily_amazon_inventory_snapshots_p2020_08_11 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.006 rows=0 loops=1)

27. 0.011 0.011 ↑ 3,694.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_12_date_idx on daily_amazon_inventory_snapshots_p2020_08_12 daily_amazon_inventory_snapshots_p2020_08_12 (cost=0.28..145.69 rows=3,694 width=37) (actual time=0.011..0.011 rows=1 loops=1)

28. 0.160 0.160 ↑ 3,748.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_13_date_idx on daily_amazon_inventory_snapshots_p2020_08_13 daily_amazon_inventory_snapshots_p2020_08_13 (cost=0.28..147.5 rows=3,748 width=37) (actual time=0.159..0.16 rows=1 loops=1)

29. 0.014 0.014 ↑ 3,747.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_14_date_idx on daily_amazon_inventory_snapshots_p2020_08_14 daily_amazon_inventory_snapshots_p2020_08_14 (cost=0.28..147.48 rows=3,747 width=37) (actual time=0.014..0.014 rows=1 loops=1)

30. 0.014 0.014 ↑ 4,284.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_15_date_idx on daily_amazon_inventory_snapshots_p2020_08_15 daily_amazon_inventory_snapshots_p2020_08_15 (cost=0.28..158.54 rows=4,284 width=37) (actual time=0.014..0.014 rows=1 loops=1)

31. 0.009 0.009 ↑ 4,283.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_16_date_idx on daily_amazon_inventory_snapshots_p2020_08_16 daily_amazon_inventory_snapshots_p2020_08_16 (cost=0.28..158.53 rows=4,283 width=37) (actual time=0.009..0.009 rows=1 loops=1)

32. 0.010 0.010 ↑ 4,308.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_17_date_idx on daily_amazon_inventory_snapshots_p2020_08_17 daily_amazon_inventory_snapshots_p2020_08_17 (cost=0.28..159.9 rows=4,308 width=37) (actual time=0.01..0.01 rows=1 loops=1)

33. 0.012 0.012 ↑ 4,356.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_18_date_idx on daily_amazon_inventory_snapshots_p2020_08_18 daily_amazon_inventory_snapshots_p2020_08_18 (cost=0.28..161.62 rows=4,356 width=37) (actual time=0.012..0.012 rows=1 loops=1)

34. 0.013 0.013 ↑ 4,355.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_19_date_idx on daily_amazon_inventory_snapshots_p2020_08_19 daily_amazon_inventory_snapshots_p2020_08_19 (cost=0.28..161.61 rows=4,355 width=37) (actual time=0.013..0.013 rows=1 loops=1)

35. 0.012 0.012 ↑ 4,352.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_20_date_idx on daily_amazon_inventory_snapshots_p2020_08_20 daily_amazon_inventory_snapshots_p2020_08_20 (cost=0.28..154.56 rows=4,352 width=37) (actual time=0.012..0.012 rows=1 loops=1)

36. 0.010 0.010 ↑ 4,346.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_21_date_idx on daily_amazon_inventory_snapshots_p2020_08_21 daily_amazon_inventory_snapshots_p2020_08_21 (cost=0.28..154.47 rows=4,346 width=37) (actual time=0.01..0.01 rows=1 loops=1)

37. 0.017 0.017 ↑ 4,344.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_22_date_idx on daily_amazon_inventory_snapshots_p2020_08_22 daily_amazon_inventory_snapshots_p2020_08_22 (cost=0.28..153.44 rows=4,344 width=37) (actual time=0.016..0.017 rows=1 loops=1)

38. 0.012 0.012 ↑ 4,361.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_23_date_idx on daily_amazon_inventory_snapshots_p2020_08_23 daily_amazon_inventory_snapshots_p2020_08_23 (cost=0.28..154.7 rows=4,361 width=37) (actual time=0.012..0.012 rows=1 loops=1)

39. 0.010 0.010 ↑ 4,358.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_24_date_idx on daily_amazon_inventory_snapshots_p2020_08_24 daily_amazon_inventory_snapshots_p2020_08_24 (cost=0.28..154.65 rows=4,358 width=37) (actual time=0.01..0.01 rows=1 loops=1)

40. 0.010 0.010 ↑ 4,352.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_25_date_idx on daily_amazon_inventory_snapshots_p2020_08_25 daily_amazon_inventory_snapshots_p2020_08_25 (cost=0.28..154.56 rows=4,352 width=37) (actual time=0.009..0.01 rows=1 loops=1)

41. 0.012 0.012 ↑ 4,351.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_26_date_idx on daily_amazon_inventory_snapshots_p2020_08_26 daily_amazon_inventory_snapshots_p2020_08_26 (cost=0.28..154.55 rows=4,351 width=37) (actual time=0.011..0.012 rows=1 loops=1)

42. 0.012 0.012 ↑ 4,346.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_27_date_idx on daily_amazon_inventory_snapshots_p2020_08_27 daily_amazon_inventory_snapshots_p2020_08_27 (cost=0.28..153.47 rows=4,346 width=37) (actual time=0.012..0.012 rows=1 loops=1)

43. 0.011 0.011 ↑ 4,340.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_28_date_idx on daily_amazon_inventory_snapshots_p2020_08_28 daily_amazon_inventory_snapshots_p2020_08_28 (cost=0.28..153.38 rows=4,340 width=37) (actual time=0.011..0.011 rows=1 loops=1)

44. 0.007 0.007 ↑ 250.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_29_date_idx on daily_amazon_inventory_snapshots_p2020_08_29 daily_amazon_inventory_snapshots_p2020_08_29 (cost=0.14..15.89 rows=250 width=36) (actual time=0.007..0.007 rows=1 loops=1)

45. 0.008 0.008 ↑ 250.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_30_date_idx on daily_amazon_inventory_snapshots_p2020_08_30 daily_amazon_inventory_snapshots_p2020_08_30 (cost=0.14..15.89 rows=250 width=36) (actual time=0.007..0.008 rows=1 loops=1)

46. 0.009 0.009 ↑ 250.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_31_date_idx on daily_amazon_inventory_snapshots_p2020_08_31 daily_amazon_inventory_snapshots_p2020_08_31 (cost=0.14..15.89 rows=250 width=36) (actual time=0.008..0.009 rows=1 loops=1)

47. 0.012 0.012 ↑ 3,893.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_01_date_idx on daily_amazon_inventory_snapshots_p2020_09_01 daily_amazon_inventory_snapshots_p2020_09_01 (cost=0.28..146.68 rows=3,893 width=36) (actual time=0.011..0.012 rows=1 loops=1)

48. 0.010 0.010 ↑ 3,891.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_02_date_idx on daily_amazon_inventory_snapshots_p2020_09_02 daily_amazon_inventory_snapshots_p2020_09_02 (cost=0.28..146.65 rows=3,891 width=36) (actual time=0.01..0.01 rows=1 loops=1)

49. 0.011 0.011 ↑ 3,881.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_03_date_idx on daily_amazon_inventory_snapshots_p2020_09_03 daily_amazon_inventory_snapshots_p2020_09_03 (cost=0.28..146.5 rows=3,881 width=36) (actual time=0.01..0.011 rows=1 loops=1)

50. 0.010 0.010 ↑ 3,879.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_04_date_idx on daily_amazon_inventory_snapshots_p2020_09_04 daily_amazon_inventory_snapshots_p2020_09_04 (cost=0.28..146.47 rows=3,879 width=36) (actual time=0.01..0.01 rows=1 loops=1)

51. 0.012 0.012 ↑ 3,872.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_05_date_idx on daily_amazon_inventory_snapshots_p2020_09_05 daily_amazon_inventory_snapshots_p2020_09_05 (cost=0.28..146.36 rows=3,872 width=36) (actual time=0.012..0.012 rows=1 loops=1)

52. 0.010 0.010 ↑ 3,869.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_06_date_idx on daily_amazon_inventory_snapshots_p2020_09_06 daily_amazon_inventory_snapshots_p2020_09_06 (cost=0.28..146.31 rows=3,869 width=36) (actual time=0.01..0.01 rows=1 loops=1)

53. 0.011 0.011 ↑ 3,860.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_07_date_idx on daily_amazon_inventory_snapshots_p2020_09_07 daily_amazon_inventory_snapshots_p2020_09_07 (cost=0.28..146.18 rows=3,860 width=36) (actual time=0.011..0.011 rows=1 loops=1)

54. 0.009 0.009 ↑ 3,852.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_08_date_idx on daily_amazon_inventory_snapshots_p2020_09_08 daily_amazon_inventory_snapshots_p2020_09_08 (cost=0.28..195.06 rows=3,852 width=36) (actual time=0.008..0.009 rows=1 loops=1)

55. 0.009 0.009 ↑ 3,850.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_09_date_idx on daily_amazon_inventory_snapshots_p2020_09_09 daily_amazon_inventory_snapshots_p2020_09_09 (cost=0.28..193.03 rows=3,850 width=36) (actual time=0.009..0.009 rows=1 loops=1)

56. 0.014 0.014 ↑ 3,849.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_10_date_idx on daily_amazon_inventory_snapshots_p2020_09_10 daily_amazon_inventory_snapshots_p2020_09_10 (cost=0.28..184.02 rows=3,849 width=36) (actual time=0.013..0.014 rows=1 loops=1)

57. 0.011 0.011 ↑ 3,847.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_11_date_idx on daily_amazon_inventory_snapshots_p2020_09_11 daily_amazon_inventory_snapshots_p2020_09_11 (cost=0.28..183.99 rows=3,847 width=36) (actual time=0.01..0.011 rows=1 loops=1)

58. 0.010 0.010 ↑ 3,846.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_12_date_idx on daily_amazon_inventory_snapshots_p2020_09_12 daily_amazon_inventory_snapshots_p2020_09_12 (cost=0.28..193.97 rows=3,846 width=36) (actual time=0.01..0.01 rows=1 loops=1)

59. 0.009 0.009 ↑ 3,844.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_13_date_idx on daily_amazon_inventory_snapshots_p2020_09_13 daily_amazon_inventory_snapshots_p2020_09_13 (cost=0.28..193.94 rows=3,844 width=36) (actual time=0.009..0.009 rows=1 loops=1)

60. 0.009 0.009 ↑ 3,841.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_14_date_idx on daily_amazon_inventory_snapshots_p2020_09_14 daily_amazon_inventory_snapshots_p2020_09_14 (cost=0.28..192.89 rows=3,841 width=36) (actual time=0.009..0.009 rows=1 loops=1)

61. 0.011 0.011 ↑ 4,263.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_15_date_idx on daily_amazon_inventory_snapshots_p2020_09_15 daily_amazon_inventory_snapshots_p2020_09_15 (cost=0.28..199.23 rows=4,263 width=36) (actual time=0.011..0.011 rows=1 loops=1)

62. 0.011 0.011 ↑ 3,832.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_16_date_idx on daily_amazon_inventory_snapshots_p2020_09_16 daily_amazon_inventory_snapshots_p2020_09_16 (cost=0.28..175.76 rows=3,832 width=36) (actual time=0.011..0.011 rows=1 loops=1)

63. 0.011 0.011 ↑ 3,831.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_17_date_idx on daily_amazon_inventory_snapshots_p2020_09_17 daily_amazon_inventory_snapshots_p2020_09_17 (cost=0.28..192.75 rows=3,831 width=36) (actual time=0.011..0.011 rows=1 loops=1)

64. 0.011 0.011 ↑ 3,842.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_18_date_idx on daily_amazon_inventory_snapshots_p2020_09_18 daily_amazon_inventory_snapshots_p2020_09_18 (cost=0.28..193.91 rows=3,842 width=36) (actual time=0.011..0.011 rows=1 loops=1)

65. 0.009 0.009 ↑ 3,842.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_19_date_idx on daily_amazon_inventory_snapshots_p2020_09_19 daily_amazon_inventory_snapshots_p2020_09_19 (cost=0.28..193.91 rows=3,842 width=36) (actual time=0.009..0.009 rows=1 loops=1)

66. 0.008 0.008 ↑ 3,842.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_20_date_idx on daily_amazon_inventory_snapshots_p2020_09_20 daily_amazon_inventory_snapshots_p2020_09_20 (cost=0.28..194.91 rows=3,842 width=36) (actual time=0.008..0.008 rows=1 loops=1)

67. 0.016 0.016 ↑ 3,836.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_21_date_idx on daily_amazon_inventory_snapshots_p2020_09_21 daily_amazon_inventory_snapshots_p2020_09_21 (cost=0.28..176.82 rows=3,836 width=36) (actual time=0.016..0.016 rows=1 loops=1)

68. 0.008 0.008 ↑ 3,834.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_22_date_idx on daily_amazon_inventory_snapshots_p2020_09_22 daily_amazon_inventory_snapshots_p2020_09_22 (cost=0.28..182.79 rows=3,834 width=36) (actual time=0.008..0.008 rows=1 loops=1)

69. 0.009 0.009 ↑ 3,833.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_23_date_idx on daily_amazon_inventory_snapshots_p2020_09_23 daily_amazon_inventory_snapshots_p2020_09_23 (cost=0.28..182.78 rows=3,833 width=36) (actual time=0.009..0.009 rows=1 loops=1)

70. 0.013 0.013 ↑ 3,832.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_24_date_idx on daily_amazon_inventory_snapshots_p2020_09_24 daily_amazon_inventory_snapshots_p2020_09_24 (cost=0.28..192.76 rows=3,832 width=36) (actual time=0.012..0.013 rows=1 loops=1)

71. 0.009 0.009 ↑ 3,821.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_25_date_idx on daily_amazon_inventory_snapshots_p2020_09_25 daily_amazon_inventory_snapshots_p2020_09_25 (cost=0.28..192.6 rows=3,821 width=36) (actual time=0.008..0.009 rows=1 loops=1)

72. 0.011 0.011 ↑ 3,816.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_26_date_idx on daily_amazon_inventory_snapshots_p2020_09_26 daily_amazon_inventory_snapshots_p2020_09_26 (cost=0.28..192.52 rows=3,816 width=36) (actual time=0.011..0.011 rows=1 loops=1)

73. 0.010 0.010 ↑ 3,815.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_27_date_idx on daily_amazon_inventory_snapshots_p2020_09_27 daily_amazon_inventory_snapshots_p2020_09_27 (cost=0.28..183.5 rows=3,815 width=36) (actual time=0.01..0.01 rows=1 loops=1)

74. 0.011 0.011 ↑ 3,813.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_28_date_idx on daily_amazon_inventory_snapshots_p2020_09_28 daily_amazon_inventory_snapshots_p2020_09_28 (cost=0.28..183.47 rows=3,813 width=36) (actual time=0.011..0.011 rows=1 loops=1)

75. 0.009 0.009 ↑ 3,813.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_29_date_idx on daily_amazon_inventory_snapshots_p2020_09_29 daily_amazon_inventory_snapshots_p2020_09_29 (cost=0.28..173.47 rows=3,813 width=36) (actual time=0.009..0.009 rows=1 loops=1)

76. 0.009 0.009 ↑ 3,812.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_30_date_idx on daily_amazon_inventory_snapshots_p2020_09_30 daily_amazon_inventory_snapshots_p2020_09_30 (cost=0.28..177.46 rows=3,812 width=36) (actual time=0.009..0.009 rows=1 loops=1)

77. 0.012 0.012 ↑ 4,226.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_01_date_idx on daily_amazon_inventory_snapshots_p2020_10_01 daily_amazon_inventory_snapshots_p2020_10_01 (cost=0.28..198.67 rows=4,226 width=36) (actual time=0.012..0.012 rows=1 loops=1)

78. 0.011 0.011 ↑ 3,811.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_02_date_idx on daily_amazon_inventory_snapshots_p2020_10_02 daily_amazon_inventory_snapshots_p2020_10_02 (cost=0.28..192.45 rows=3,811 width=36) (actual time=0.011..0.011 rows=1 loops=1)

79. 0.010 0.010 ↑ 3,811.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_03_date_idx on daily_amazon_inventory_snapshots_p2020_10_03 daily_amazon_inventory_snapshots_p2020_10_03 (cost=0.28..193.45 rows=3,811 width=36) (actual time=0.01..0.01 rows=1 loops=1)

80. 0.009 0.009 ↑ 3,810.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_04_date_idx on daily_amazon_inventory_snapshots_p2020_10_04 daily_amazon_inventory_snapshots_p2020_10_04 (cost=0.28..191.43 rows=3,810 width=36) (actual time=0.009..0.009 rows=1 loops=1)

81. 0.910 0.910 ↓ 1.1 4,035 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_05_date_idx on daily_amazon_inventory_snapshots_p2020_10_05 daily_amazon_inventory_snapshots_p2020_10_05 (cost=0.28..192.38 rows=3,807 width=36) (actual time=0.009..0.91 rows=4,035 loops=1)

82. 0.881 0.881 ↑ 1.0 4,070 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_06_date_idx on daily_amazon_inventory_snapshots_p2020_10_06 daily_amazon_inventory_snapshots_p2020_10_06 (cost=0.28..181.33 rows=4,070 width=36) (actual time=0.009..0.881 rows=4,070 loops=1)

83. 0.882 0.882 ↑ 1.0 4,069 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_07_date_idx on daily_amazon_inventory_snapshots_p2020_10_07 daily_amazon_inventory_snapshots_p2020_10_07 (cost=0.28..181.31 rows=4,069 width=36) (actual time=0.011..0.882 rows=4,069 loops=1)

84. 0.831 0.831 ↑ 1.0 4,066 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_08_date_idx on daily_amazon_inventory_snapshots_p2020_10_08 daily_amazon_inventory_snapshots_p2020_10_08 (cost=0.28..192.27 rows=4,066 width=36) (actual time=0.01..0.831 rows=4,066 loops=1)

85. 0.839 0.839 ↑ 1.0 4,091 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_09_date_idx on daily_amazon_inventory_snapshots_p2020_10_09 daily_amazon_inventory_snapshots_p2020_10_09 (cost=0.28..193.64 rows=4,091 width=36) (actual time=0.009..0.839 rows=4,091 loops=1)

86. 0.833 0.833 ↑ 1.0 4,092 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_10_date_idx on daily_amazon_inventory_snapshots_p2020_10_10 daily_amazon_inventory_snapshots_p2020_10_10 (cost=0.28..174.66 rows=4,092 width=36) (actual time=0.01..0.833 rows=4,092 loops=1)

87. 0.858 0.858 ↑ 1.0 4,090 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_11_date_idx on daily_amazon_inventory_snapshots_p2020_10_11 daily_amazon_inventory_snapshots_p2020_10_11 (cost=0.28..174.63 rows=4,090 width=36) (actual time=0.011..0.858 rows=4,090 loops=1)

88. 1.096 1.096 ↑ 1.0 4,090 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_12_date_idx on daily_amazon_inventory_snapshots_p2020_10_12 daily_amazon_inventory_snapshots_p2020_10_12 (cost=0.28..175.63 rows=4,090 width=36) (actual time=0.025..1.096 rows=4,090 loops=1)

89. 0.824 0.824 ↑ 1.0 4,079 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_13_date_idx on daily_amazon_inventory_snapshots_p2020_10_13 daily_amazon_inventory_snapshots_p2020_10_13 (cost=0.28..193.46 rows=4,079 width=37) (actual time=0.009..0.824 rows=4,079 loops=1)

90. 0.875 0.875 ↑ 1.0 4,063 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_14_date_idx on daily_amazon_inventory_snapshots_p2020_10_14 daily_amazon_inventory_snapshots_p2020_10_14 (cost=0.28..192.22 rows=4,063 width=37) (actual time=0.008..0.875 rows=4,063 loops=1)

91. 0.799 0.799 ↑ 1.0 4,042 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_15_date_idx on daily_amazon_inventory_snapshots_p2020_10_15 daily_amazon_inventory_snapshots_p2020_10_15 (cost=0.28..184.91 rows=4,042 width=37) (actual time=0.01..0.799 rows=4,042 loops=1)

92. 0.928 0.928 ↑ 1.0 3,590 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_16_date_idx on daily_amazon_inventory_snapshots_p2020_10_16 daily_amazon_inventory_snapshots_p2020_10_16 (cost=0.28..168.13 rows=3,590 width=37) (actual time=0.01..0.928 rows=3,590 loops=1)

93. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_17_date_idx on daily_amazon_inventory_snapshots_p2020_10_17 daily_amazon_inventory_snapshots_p2020_10_17 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

94. 0.007 0.007 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_18_date_idx on daily_amazon_inventory_snapshots_p2020_10_18 daily_amazon_inventory_snapshots_p2020_10_18 (cost=0.14..14.89 rows=250 width=36) (actual time=0.007..0.007 rows=0 loops=1)

95. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_19_date_idx on daily_amazon_inventory_snapshots_p2020_10_19 daily_amazon_inventory_snapshots_p2020_10_19 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

96. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_20_date_idx on daily_amazon_inventory_snapshots_p2020_10_20 daily_amazon_inventory_snapshots_p2020_10_20 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.006 rows=0 loops=1)

97. 0.015 0.015 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_21_date_idx on daily_amazon_inventory_snapshots_p2020_10_21 daily_amazon_inventory_snapshots_p2020_10_21 (cost=0.14..14.89 rows=250 width=36) (actual time=0.015..0.015 rows=0 loops=1)

98. 0.007 0.007 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_22_date_idx on daily_amazon_inventory_snapshots_p2020_10_22 daily_amazon_inventory_snapshots_p2020_10_22 (cost=0.14..14.89 rows=250 width=36) (actual time=0.007..0.007 rows=0 loops=1)

99. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_23_date_idx on daily_amazon_inventory_snapshots_p2020_10_23 daily_amazon_inventory_snapshots_p2020_10_23 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

100. 0.011 0.011 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_24_date_idx on daily_amazon_inventory_snapshots_p2020_10_24 daily_amazon_inventory_snapshots_p2020_10_24 (cost=0.14..14.89 rows=250 width=36) (actual time=0.011..0.011 rows=0 loops=1)

101. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_25_date_idx on daily_amazon_inventory_snapshots_p2020_10_25 daily_amazon_inventory_snapshots_p2020_10_25 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

102. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_26_date_idx on daily_amazon_inventory_snapshots_p2020_10_26 daily_amazon_inventory_snapshots_p2020_10_26 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

103. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_27_date_idx on daily_amazon_inventory_snapshots_p2020_10_27 daily_amazon_inventory_snapshots_p2020_10_27 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

104. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_28_date_idx on daily_amazon_inventory_snapshots_p2020_10_28 daily_amazon_inventory_snapshots_p2020_10_28 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

105. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_29_date_idx on daily_amazon_inventory_snapshots_p2020_10_29 daily_amazon_inventory_snapshots_p2020_10_29 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

106. 0.009 0.009 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_30_date_idx on daily_amazon_inventory_snapshots_p2020_10_30 daily_amazon_inventory_snapshots_p2020_10_30 (cost=0.14..14.89 rows=250 width=36) (actual time=0.009..0.009 rows=0 loops=1)

107. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_31_date_idx on daily_amazon_inventory_snapshots_p2020_10_31 daily_amazon_inventory_snapshots_p2020_10_31 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

108. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_11_01_date_idx on daily_amazon_inventory_snapshots_p2020_11_01 daily_amazon_inventory_snapshots_p2020_11_01 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

109. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_11_02_date_idx on daily_amazon_inventory_snapshots_p2020_11_02 daily_amazon_inventory_snapshots_p2020_11_02 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

110. 0.009 0.009 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_11_03_date_idx on daily_amazon_inventory_snapshots_p2020_11_03 daily_amazon_inventory_snapshots_p2020_11_03 (cost=0.14..14.89 rows=250 width=36) (actual time=0.009..0.009 rows=0 loops=1)

111. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_11_04_date_idx on daily_amazon_inventory_snapshots_p2020_11_04 daily_amazon_inventory_snapshots_p2020_11_04 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.006 rows=0 loops=1)

112. 0.007 0.007 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_11_05_date_idx on daily_amazon_inventory_snapshots_p2020_11_05 daily_amazon_inventory_snapshots_p2020_11_05 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.007 rows=0 loops=1)

113. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_11_06_date_idx on daily_amazon_inventory_snapshots_p2020_11_06 daily_amazon_inventory_snapshots_p2020_11_06 (cost=0.14..14.89 rows=250 width=36) (actual time=0.006..0.006 rows=0 loops=1)

114. 0.005 0.005 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_11_07_date_idx on daily_amazon_inventory_snapshots_p2020_11_07 daily_amazon_inventory_snapshots_p2020_11_07 (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.005 rows=0 loops=1)

115. 0.006 0.006 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_default_date_idx on daily_amazon_inventory_snapshots_default daily_amazon_inventory_snapshots_default (cost=0.14..14.89 rows=250 width=36) (actual time=0.005..0.006 rows=0 loops=1)

116. 0.000 0.000 ↑ 1.0 1 48,377

Materialize (cost=0.15..2.19 rows=1 width=33) (actual time=0..0 rows=1 loops=48,377)

117. 0.001 0.012 ↑ 1.0 1 1

Limit (cost=0.15..2.17 rows=1 width=33) (actual time=0.012..0.012 rows=1 loops=1)

118. 0.011 0.011 ↑ 1.0 1 1

Index Scan using amazon_sellers_seller_id_marketplace_id_key on amazon_sellers amazon_sellers_1 (cost=0.15..2.17 rows=1 width=33) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (((seller_id)::text = 'A24BVQ69RJOKWH'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text))
  • Filter: (((seller_id)::text ~~ 'A24BVQ69RJOKWH'::text) AND ((marketplace_id)::text ~~ 'ATVPDKIKX0DER'::text))
119. 2.161 44.211 ↓ 7.1 2,511 1

Nested Loop (cost=3.16..3,199.28 rows=355 width=42) (actual time=27.238..44.211 rows=2,511 loops=1)

120. 2.758 37.028 ↓ 7.1 2,511 1

Nested Loop (cost=2.75..3,035.03 rows=355 width=101) (actual time=27.217..37.028 rows=2,511 loops=1)

121. 0.612 30.654 ↓ 10.2 3,616 1

Nested Loop (cost=2.47..2,926.7 rows=355 width=57) (actual time=27.202..30.654 rows=3,616 loops=1)

122. 0.005 0.028 ↑ 1.0 1 1

Aggregate (cost=2.19..2.2 rows=1 width=33) (actual time=0.027..0.028 rows=1 loops=1)

123. 0.001 0.023 ↑ 1.0 1 1

Limit (cost=0.15..2.17 rows=1 width=33) (actual time=0.023..0.023 rows=1 loops=1)

124. 0.022 0.022 ↑ 1.0 1 1

Index Scan using amazon_sellers_seller_id_marketplace_id_key on amazon_sellers amazon_sellers (cost=0.15..2.17 rows=1 width=33) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (((seller_id)::text = 'A1LMQBEOGTEVAC'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text))
  • Filter: (((seller_id)::text ~~ 'A1LMQBEOGTEVAC'::text) AND ((marketplace_id)::text ~~ 'ATVPDKIKX0DER'::text))
125. 27.397 30.014 ↑ 6.3 3,616 1

Append (cost=0.28..2,698.14 rows=22,637 width=90) (actual time=27.159..30.014 rows=3,616 loops=1)

126. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_09_26_pkey on daily_amazon_inventory_age_snapshots_p2020_09_26 dais (cost=0.28..122.89 rows=954 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
127. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_09_27_pkey on daily_amazon_inventory_age_snapshots_p2020_09_27 dais_1 (cost=0.28..120.9 rows=954 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
128. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_09_28_pkey on daily_amazon_inventory_age_snapshots_p2020_09_28 dais_2 (cost=0.28..120.89 rows=953 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
129. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_09_29_pkey on daily_amazon_inventory_age_snapshots_p2020_09_29 dais_3 (cost=0.28..121.89 rows=953 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
130. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_09_30_pkey on daily_amazon_inventory_age_snapshots_p2020_09_30 dais_4 (cost=0.28..121.89 rows=953 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
131. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_01_pkey on daily_amazon_inventory_age_snapshots_p2020_10_01 dais_5 (cost=0.28..121.9 rows=953 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
132. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_02_pkey on daily_amazon_inventory_age_snapshots_p2020_10_02 dais_6 (cost=0.28..121.9 rows=953 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
133. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_03_pkey on daily_amazon_inventory_age_snapshots_p2020_10_03 dais_7 (cost=0.28..120.9 rows=953 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
134. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_04_pkey on daily_amazon_inventory_age_snapshots_p2020_10_04 dais_8 (cost=0.28..122.79 rows=952 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
135. 2.617 2.617 ↓ 3.8 3,616 1

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_05_pkey on daily_amazon_inventory_age_snapshots_p2020_10_05 dais_9 (cost=0.28..122.09 rows=952 width=89) (actual time=0.028..2.617 rows=3,616 loops=1)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
136. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_06_pkey on daily_amazon_inventory_age_snapshots_p2020_10_06 dais_10 (cost=0.28..110.97 rows=1,206 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
137. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_07_pkey on daily_amazon_inventory_age_snapshots_p2020_10_07 dais_11 (cost=0.28..109.95 rows=1,205 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
138. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_08_pkey on daily_amazon_inventory_age_snapshots_p2020_10_08 dais_12 (cost=0.28..109.93 rows=1,204 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
139. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_09_pkey on daily_amazon_inventory_age_snapshots_p2020_10_09 dais_13 (cost=0.28..110.51 rows=1,211 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
140. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_10_pkey on daily_amazon_inventory_age_snapshots_p2020_10_10 dais_14 (cost=0.28..110.51 rows=1,211 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
141. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_11_pkey on daily_amazon_inventory_age_snapshots_p2020_10_11 dais_15 (cost=0.28..111.51 rows=1,211 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
142. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_12_pkey on daily_amazon_inventory_age_snapshots_p2020_10_12 dais_16 (cost=0.28..111.51 rows=1,211 width=89) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
143. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on daily_amazon_inventory_age_snapshots_p2020_10_13 dais_17 (cost=0..159.39 rows=3,626 width=91) (never executed)

  • Filter: ((date = $0) AND (amazon_sellers.seller_marketplace_sha = amazon_seller_sha))
144. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_14_pkey on daily_amazon_inventory_age_snapshots_p2020_10_14 dais_18 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
145. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_15_pkey on daily_amazon_inventory_age_snapshots_p2020_10_15 dais_19 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
146. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_16_pkey on daily_amazon_inventory_age_snapshots_p2020_10_16 dais_20 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
147. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_17_pkey on daily_amazon_inventory_age_snapshots_p2020_10_17 dais_21 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
148. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_18_pkey on daily_amazon_inventory_age_snapshots_p2020_10_18 dais_22 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
149. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_19_pkey on daily_amazon_inventory_age_snapshots_p2020_10_19 dais_23 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
150. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_20_pkey on daily_amazon_inventory_age_snapshots_p2020_10_20 dais_24 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
151. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_21_pkey on daily_amazon_inventory_age_snapshots_p2020_10_21 dais_25 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
152. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_22_pkey on daily_amazon_inventory_age_snapshots_p2020_10_22 dais_26 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
153. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_23_pkey on daily_amazon_inventory_age_snapshots_p2020_10_23 dais_27 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
154. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_24_pkey on daily_amazon_inventory_age_snapshots_p2020_10_24 dais_28 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
155. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_25_pkey on daily_amazon_inventory_age_snapshots_p2020_10_25 dais_29 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
156. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_26_pkey on daily_amazon_inventory_age_snapshots_p2020_10_26 dais_30 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
157. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_27_pkey on daily_amazon_inventory_age_snapshots_p2020_10_27 dais_31 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
158. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_28_pkey on daily_amazon_inventory_age_snapshots_p2020_10_28 dais_32 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
159. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_29_pkey on daily_amazon_inventory_age_snapshots_p2020_10_29 dais_33 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
160. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_30_pkey on daily_amazon_inventory_age_snapshots_p2020_10_30 dais_34 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
161. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_10_31_pkey on daily_amazon_inventory_age_snapshots_p2020_10_31 dais_35 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
162. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_01_pkey on daily_amazon_inventory_age_snapshots_p2020_11_01 dais_36 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
163. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_02_pkey on daily_amazon_inventory_age_snapshots_p2020_11_02 dais_37 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
164. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_03_pkey on daily_amazon_inventory_age_snapshots_p2020_11_03 dais_38 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
165. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_04_pkey on daily_amazon_inventory_age_snapshots_p2020_11_04 dais_39 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
166. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_05_pkey on daily_amazon_inventory_age_snapshots_p2020_11_05 dais_40 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
167. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_06_pkey on daily_amazon_inventory_age_snapshots_p2020_11_06 dais_41 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
168. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_07_pkey on daily_amazon_inventory_age_snapshots_p2020_11_07 dais_42 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
169. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_08_pkey on daily_amazon_inventory_age_snapshots_p2020_11_08 dais_43 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
170. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_09_pkey on daily_amazon_inventory_age_snapshots_p2020_11_09 dais_44 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
171. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_10_pkey on daily_amazon_inventory_age_snapshots_p2020_11_10 dais_45 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
172. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_11_pkey on daily_amazon_inventory_age_snapshots_p2020_11_11 dais_46 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
173. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_12_pkey on daily_amazon_inventory_age_snapshots_p2020_11_12 dais_47 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
174. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_13_pkey on daily_amazon_inventory_age_snapshots_p2020_11_13 dais_48 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
175. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_14_pkey on daily_amazon_inventory_age_snapshots_p2020_11_14 dais_49 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
176. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_15_pkey on daily_amazon_inventory_age_snapshots_p2020_11_15 dais_50 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
177. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_16_pkey on daily_amazon_inventory_age_snapshots_p2020_11_16 dais_51 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
178. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_17_pkey on daily_amazon_inventory_age_snapshots_p2020_11_17 dais_52 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
179. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_18_pkey on daily_amazon_inventory_age_snapshots_p2020_11_18 dais_53 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
180. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_19_pkey on daily_amazon_inventory_age_snapshots_p2020_11_19 dais_54 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
181. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_20_pkey on daily_amazon_inventory_age_snapshots_p2020_11_20 dais_55 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
182. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_21_pkey on daily_amazon_inventory_age_snapshots_p2020_11_21 dais_56 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
183. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_22_pkey on daily_amazon_inventory_age_snapshots_p2020_11_22 dais_57 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
184. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_23_pkey on daily_amazon_inventory_age_snapshots_p2020_11_23 dais_58 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
185. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_24_pkey on daily_amazon_inventory_age_snapshots_p2020_11_24 dais_59 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
186. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_25_pkey on daily_amazon_inventory_age_snapshots_p2020_11_25 dais_60 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
187. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_26_pkey on daily_amazon_inventory_age_snapshots_p2020_11_26 dais_61 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
188. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_27_pkey on daily_amazon_inventory_age_snapshots_p2020_11_27 dais_62 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
189. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_28_pkey on daily_amazon_inventory_age_snapshots_p2020_11_28 dais_63 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
190. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_29_pkey on daily_amazon_inventory_age_snapshots_p2020_11_29 dais_64 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
191. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_11_30_pkey on daily_amazon_inventory_age_snapshots_p2020_11_30 dais_65 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
192. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_01_pkey on daily_amazon_inventory_age_snapshots_p2020_12_01 dais_66 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
193. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_02_pkey on daily_amazon_inventory_age_snapshots_p2020_12_02 dais_67 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
194. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_03_pkey on daily_amazon_inventory_age_snapshots_p2020_12_03 dais_68 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
195. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_04_pkey on daily_amazon_inventory_age_snapshots_p2020_12_04 dais_69 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
196. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_05_pkey on daily_amazon_inventory_age_snapshots_p2020_12_05 dais_70 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
197. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_06_pkey on daily_amazon_inventory_age_snapshots_p2020_12_06 dais_71 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
198. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_07_pkey on daily_amazon_inventory_age_snapshots_p2020_12_07 dais_72 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
199. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_08_pkey on daily_amazon_inventory_age_snapshots_p2020_12_08 dais_73 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
200. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_09_pkey on daily_amazon_inventory_age_snapshots_p2020_12_09 dais_74 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
201. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_10_pkey on daily_amazon_inventory_age_snapshots_p2020_12_10 dais_75 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
202. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_11_pkey on daily_amazon_inventory_age_snapshots_p2020_12_11 dais_76 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
203. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_12_pkey on daily_amazon_inventory_age_snapshots_p2020_12_12 dais_77 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
204. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_13_pkey on daily_amazon_inventory_age_snapshots_p2020_12_13 dais_78 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
205. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_14_pkey on daily_amazon_inventory_age_snapshots_p2020_12_14 dais_79 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
206. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_15_pkey on daily_amazon_inventory_age_snapshots_p2020_12_15 dais_80 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
207. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_16_pkey on daily_amazon_inventory_age_snapshots_p2020_12_16 dais_81 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
208. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_17_pkey on daily_amazon_inventory_age_snapshots_p2020_12_17 dais_82 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
209. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_18_pkey on daily_amazon_inventory_age_snapshots_p2020_12_18 dais_83 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
210. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_19_pkey on daily_amazon_inventory_age_snapshots_p2020_12_19 dais_84 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
211. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_20_pkey on daily_amazon_inventory_age_snapshots_p2020_12_20 dais_85 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
212. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_21_pkey on daily_amazon_inventory_age_snapshots_p2020_12_21 dais_86 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
213. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_22_pkey on daily_amazon_inventory_age_snapshots_p2020_12_22 dais_87 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
214. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_23_pkey on daily_amazon_inventory_age_snapshots_p2020_12_23 dais_88 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
215. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_24_pkey on daily_amazon_inventory_age_snapshots_p2020_12_24 dais_89 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
216. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_25_pkey on daily_amazon_inventory_age_snapshots_p2020_12_25 dais_90 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
217. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_26_pkey on daily_amazon_inventory_age_snapshots_p2020_12_26 dais_91 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
218. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_27_pkey on daily_amazon_inventory_age_snapshots_p2020_12_27 dais_92 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
219. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_28_pkey on daily_amazon_inventory_age_snapshots_p2020_12_28 dais_93 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
220. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_29_pkey on daily_amazon_inventory_age_snapshots_p2020_12_29 dais_94 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
221. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_30_pkey on daily_amazon_inventory_age_snapshots_p2020_12_30 dais_95 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
222. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2020_12_31_pkey on daily_amazon_inventory_age_snapshots_p2020_12_31 dais_96 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
223. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_01_pkey on daily_amazon_inventory_age_snapshots_p2021_01_01 dais_97 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
224. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_02_pkey on daily_amazon_inventory_age_snapshots_p2021_01_02 dais_98 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
225. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_03_pkey on daily_amazon_inventory_age_snapshots_p2021_01_03 dais_99 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
226. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_04_pkey on daily_amazon_inventory_age_snapshots_p2021_01_04 dais_100 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
227. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_05_pkey on daily_amazon_inventory_age_snapshots_p2021_01_05 dais_101 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
228. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_06_pkey on daily_amazon_inventory_age_snapshots_p2021_01_06 dais_102 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
229. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_07_pkey on daily_amazon_inventory_age_snapshots_p2021_01_07 dais_103 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
230. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_08_pkey on daily_amazon_inventory_age_snapshots_p2021_01_08 dais_104 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
231. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_09_pkey on daily_amazon_inventory_age_snapshots_p2021_01_09 dais_105 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
232. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_10_pkey on daily_amazon_inventory_age_snapshots_p2021_01_10 dais_106 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
233. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_11_pkey on daily_amazon_inventory_age_snapshots_p2021_01_11 dais_107 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
234. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_12_pkey on daily_amazon_inventory_age_snapshots_p2021_01_12 dais_108 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
235. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_13_pkey on daily_amazon_inventory_age_snapshots_p2021_01_13 dais_109 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
236. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_14_pkey on daily_amazon_inventory_age_snapshots_p2021_01_14 dais_110 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
237. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_15_pkey on daily_amazon_inventory_age_snapshots_p2021_01_15 dais_111 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
238. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_16_pkey on daily_amazon_inventory_age_snapshots_p2021_01_16 dais_112 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
239. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_17_pkey on daily_amazon_inventory_age_snapshots_p2021_01_17 dais_113 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
240. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_18_pkey on daily_amazon_inventory_age_snapshots_p2021_01_18 dais_114 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
241. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_19_pkey on daily_amazon_inventory_age_snapshots_p2021_01_19 dais_115 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
242. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_20_pkey on daily_amazon_inventory_age_snapshots_p2021_01_20 dais_116 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
243. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_21_pkey on daily_amazon_inventory_age_snapshots_p2021_01_21 dais_117 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
244. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_22_pkey on daily_amazon_inventory_age_snapshots_p2021_01_22 dais_118 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
245. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_23_pkey on daily_amazon_inventory_age_snapshots_p2021_01_23 dais_119 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
246. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_24_pkey on daily_amazon_inventory_age_snapshots_p2021_01_24 dais_120 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
247. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_25_pkey on daily_amazon_inventory_age_snapshots_p2021_01_25 dais_121 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
248. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_26_pkey on daily_amazon_inventory_age_snapshots_p2021_01_26 dais_122 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
249. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_27_pkey on daily_amazon_inventory_age_snapshots_p2021_01_27 dais_123 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
250. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_p2021_01_28_pkey on daily_amazon_inventory_age_snapshots_p2021_01_28 dais_124 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $0))
251. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_age_snapshots_default_date_idx on daily_amazon_inventory_age_snapshots_default dais_125 (cost=0.42..199.64 rows=915 width=89) (never executed)

  • Index Cond: (date = $0)
  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
252. 3.616 3.616 ↑ 1.0 1 3,616

Index Scan using amazon_products_pkey on amazon_products ap (cost=0.28..0.31 rows=1 width=76) (actual time=0.001..0.001 rows=1 loops=3,616)

  • Index Cond: (seller_marketplace_sku_sha = dais.amazon_product_sha)
253. 5.022 5.022 ↑ 1.0 1 2,511

Index Scan using amazon_current_cogs_pkey on amazon_current_cogs acc (cost=0.41..0.46 rows=1 width=70) (actual time=0.002..0.002 rows=1 loops=2,511)

  • Index Cond: ((amazon_seller_sha = ap.amazon_seller_sha) AND (amazon_product_sha = ap.seller_marketplace_sku_sha))
Planning time : 18.49 ms
Execution time : 49.263 ms