explain.depesz.com

PostgreSQL's explain analyze made readable

Result: evwq : Optimization for: Optimization for: Optimization for: acdd; plan #GlUo; plan #jHFV; plan #bts6

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 23.841 ↑ 1.0 1 1

Limit (cost=28.43..141.95 rows=1 width=364) (actual time=23.802..23.841 rows=1 loops=1)

2. 0.314 23.839 ↑ 200.0 1 1

Aggregate (cost=28.43..22,731.67 rows=200 width=364) (actual time=23.801..23.839 rows=1 loops=1)

3. 0.150 23.525 ↑ 6.9 173 1

Nested Loop (cost=28.43..22,628.59 rows=1,201 width=50) (actual time=20.173..23.525 rows=173 loops=1)

4. 0.000 22.856 ↑ 6.9 173 1

Nested Loop (cost=28.03..22,072.93 rows=1,201 width=109) (actual time=20.162..22.856 rows=173 loops=1)

5. 8.227 22.310 ↑ 6.4 189 1

Nested Loop (cost=27.74..21,711.07 rows=1,201 width=65) (actual time=20.148..22.31 rows=189 loops=1)

6. 2.909 14.083 ↑ 6.6 36,428 1

Merge Append (cost=27.59..18,106.6 rows=240,152 width=100) (actual time=1.21..14.083 rows=36,428 loops=1)

7. 0.004 0.004 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_23_date_idx on daily_amazon_inventory_snapshots_p2020_07_23 dais (cost=0.14..14.89 rows=250 width=292) (actual time=0.003..0.004 rows=0 loops=1)

8. 0.003 0.003 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_24_date_idx on daily_amazon_inventory_snapshots_p2020_07_24 dais_1 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.003 rows=0 loops=1)

9. 0.002 0.002 ↓ 0.0 0 1

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

10. 0.003 0.003 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_26_date_idx on daily_amazon_inventory_snapshots_p2020_07_26 dais_3 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.003 rows=0 loops=1)

11. 0.002 0.002 ↓ 0.0 0 1

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

12. 0.002 0.002 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_28_date_idx on daily_amazon_inventory_snapshots_p2020_07_28 dais_5 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.002 rows=0 loops=1)

13. 0.003 0.003 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_29_date_idx on daily_amazon_inventory_snapshots_p2020_07_29 dais_6 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.003 rows=0 loops=1)

14. 0.004 0.004 ↓ 0.0 0 1

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

15. 0.004 0.004 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_07_31_date_idx on daily_amazon_inventory_snapshots_p2020_07_31 dais_8 (cost=0.14..14.89 rows=250 width=292) (actual time=0.003..0.004 rows=0 loops=1)

16. 0.002 0.002 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_01_date_idx on daily_amazon_inventory_snapshots_p2020_08_01 dais_9 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.002 rows=0 loops=1)

17. 0.003 0.003 ↓ 0.0 0 1

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

18. 0.003 0.003 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_03_date_idx on daily_amazon_inventory_snapshots_p2020_08_03 dais_11 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.003 rows=0 loops=1)

19. 0.003 0.003 ↓ 0.0 0 1

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

20. 0.003 0.003 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_05_date_idx on daily_amazon_inventory_snapshots_p2020_08_05 dais_13 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.003 rows=0 loops=1)

21. 0.003 0.003 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_06_date_idx on daily_amazon_inventory_snapshots_p2020_08_06 dais_14 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.003 rows=0 loops=1)

22. 0.003 0.003 ↓ 0.0 0 1

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

23. 0.003 0.003 ↓ 0.0 0 1

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

24. 0.002 0.002 ↓ 0.0 0 1

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

25. 0.003 0.003 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_10_date_idx on daily_amazon_inventory_snapshots_p2020_08_10 dais_18 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.003 rows=0 loops=1)

26. 0.002 0.002 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_11_date_idx on daily_amazon_inventory_snapshots_p2020_08_11 dais_19 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.002 rows=0 loops=1)

27. 0.026 0.026 ↑ 3,596.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_12_date_idx on daily_amazon_inventory_snapshots_p2020_08_12 dais_20 (cost=0.28..126.22 rows=3,596 width=92) (actual time=0.026..0.026 rows=1 loops=1)

28. 0.014 0.014 ↑ 3,657.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_13_date_idx on daily_amazon_inventory_snapshots_p2020_08_13 dais_21 (cost=0.28..128.13 rows=3,657 width=92) (actual time=0.014..0.014 rows=1 loops=1)

29. 0.013 0.013 ↑ 3,656.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_14_date_idx on daily_amazon_inventory_snapshots_p2020_08_14 dais_22 (cost=0.28..128.12 rows=3,656 width=92) (actual time=0.013..0.013 rows=1 loops=1)

30. 0.019 0.019 ↑ 3,716.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_15_date_idx on daily_amazon_inventory_snapshots_p2020_08_15 dais_23 (cost=0.28..132.02 rows=3,716 width=92) (actual time=0.018..0.019 rows=1 loops=1)

31. 0.016 0.016 ↑ 3,715.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_16_date_idx on daily_amazon_inventory_snapshots_p2020_08_16 dais_24 (cost=0.28..132 rows=3,715 width=92) (actual time=0.016..0.016 rows=1 loops=1)

32. 0.020 0.020 ↑ 3,737.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_17_date_idx on daily_amazon_inventory_snapshots_p2020_08_17 dais_25 (cost=0.28..132.34 rows=3,737 width=92) (actual time=0.02..0.02 rows=1 loops=1)

33. 0.018 0.018 ↑ 3,784.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_18_date_idx on daily_amazon_inventory_snapshots_p2020_08_18 dais_26 (cost=0.28..134.04 rows=3,784 width=92) (actual time=0.018..0.018 rows=1 loops=1)

34. 0.014 0.014 ↑ 3,783.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_19_date_idx on daily_amazon_inventory_snapshots_p2020_08_19 dais_27 (cost=0.28..134.03 rows=3,783 width=92) (actual time=0.014..0.014 rows=1 loops=1)

35. 0.014 0.014 ↑ 3,872.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_20_date_idx on daily_amazon_inventory_snapshots_p2020_08_20 dais_28 (cost=0.28..136.36 rows=3,872 width=91) (actual time=0.014..0.014 rows=1 loops=1)

36. 0.012 0.012 ↑ 3,867.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_21_date_idx on daily_amazon_inventory_snapshots_p2020_08_21 dais_29 (cost=0.28..136.28 rows=3,867 width=91) (actual time=0.011..0.012 rows=1 loops=1)

37. 0.013 0.013 ↑ 3,865.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_22_date_idx on daily_amazon_inventory_snapshots_p2020_08_22 dais_30 (cost=0.28..136.25 rows=3,865 width=91) (actual time=0.013..0.013 rows=1 loops=1)

38. 0.010 0.010 ↑ 3,883.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_23_date_idx on daily_amazon_inventory_snapshots_p2020_08_23 dais_31 (cost=0.28..137.53 rows=3,883 width=91) (actual time=0.01..0.01 rows=1 loops=1)

39. 0.012 0.012 ↑ 3,880.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_24_date_idx on daily_amazon_inventory_snapshots_p2020_08_24 dais_32 (cost=0.28..137.48 rows=3,880 width=91) (actual time=0.012..0.012 rows=1 loops=1)

40. 0.014 0.014 ↑ 3,875.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_25_date_idx on daily_amazon_inventory_snapshots_p2020_08_25 dais_33 (cost=0.28..137.41 rows=3,875 width=91) (actual time=0.014..0.014 rows=1 loops=1)

41. 0.009 0.009 ↑ 3,874.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_26_date_idx on daily_amazon_inventory_snapshots_p2020_08_26 dais_34 (cost=0.28..137.39 rows=3,874 width=91) (actual time=0.008..0.009 rows=1 loops=1)

42. 0.016 0.016 ↑ 3,869.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_27_date_idx on daily_amazon_inventory_snapshots_p2020_08_27 dais_35 (cost=0.28..136.31 rows=3,869 width=91) (actual time=0.016..0.016 rows=1 loops=1)

43. 0.018 0.018 ↑ 3,863.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_28_date_idx on daily_amazon_inventory_snapshots_p2020_08_28 dais_36 (cost=0.28..136.22 rows=3,863 width=91) (actual time=0.018..0.018 rows=1 loops=1)

44. 0.008 0.008 ↑ 250.0 1 1

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

45. 0.006 0.006 ↑ 250.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_30_date_idx on daily_amazon_inventory_snapshots_p2020_08_30 dais_38 (cost=0.14..15.89 rows=250 width=292) (actual time=0.006..0.006 rows=1 loops=1)

46. 0.004 0.004 ↑ 250.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_08_31_date_idx on daily_amazon_inventory_snapshots_p2020_08_31 dais_39 (cost=0.14..15.89 rows=250 width=292) (actual time=0.004..0.004 rows=1 loops=1)

47. 0.018 0.018 ↑ 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 dais_40 (cost=0.28..137.68 rows=3,893 width=89) (actual time=0.018..0.018 rows=1 loops=1)

48. 0.014 0.014 ↑ 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 dais_41 (cost=0.28..137.65 rows=3,891 width=89) (actual time=0.014..0.014 rows=1 loops=1)

49. 0.016 0.016 ↑ 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 dais_42 (cost=0.28..137.5 rows=3,881 width=89) (actual time=0.015..0.016 rows=1 loops=1)

50. 0.016 0.016 ↑ 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 dais_43 (cost=0.28..137.47 rows=3,879 width=89) (actual time=0.016..0.016 rows=1 loops=1)

51. 0.013 0.013 ↑ 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 dais_44 (cost=0.28..137.36 rows=3,872 width=89) (actual time=0.013..0.013 rows=1 loops=1)

52. 0.022 0.022 ↑ 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 dais_45 (cost=0.28..137.31 rows=3,869 width=89) (actual time=0.022..0.022 rows=1 loops=1)

53. 0.017 0.017 ↑ 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 dais_46 (cost=0.28..136.18 rows=3,860 width=89) (actual time=0.017..0.017 rows=1 loops=1)

54. 0.020 0.020 ↑ 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 dais_47 (cost=0.28..190.06 rows=3,852 width=89) (actual time=0.019..0.02 rows=1 loops=1)

55. 0.015 0.015 ↑ 3,840.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_09_date_idx on daily_amazon_inventory_snapshots_p2020_09_09 dais_48 (cost=0.28..133.88 rows=3,840 width=89) (actual time=0.015..0.015 rows=1 loops=1)

56. 0.023 0.023 ↑ 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 dais_49 (cost=0.28..134.02 rows=3,849 width=89) (actual time=0.023..0.023 rows=1 loops=1)

57. 0.019 0.019 ↑ 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 dais_50 (cost=0.28..133.98 rows=3,847 width=89) (actual time=0.019..0.019 rows=1 loops=1)

58. 0.024 0.024 ↑ 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 dais_51 (cost=0.28..133.97 rows=3,846 width=89) (actual time=0.024..0.024 rows=1 loops=1)

59. 0.018 0.018 ↑ 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 dais_52 (cost=0.28..133.94 rows=3,844 width=89) (actual time=0.017..0.018 rows=1 loops=1)

60. 0.038 0.038 ↑ 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 dais_53 (cost=0.28..133.9 rows=3,841 width=89) (actual time=0.038..0.038 rows=1 loops=1)

61. 0.019 0.019 ↑ 3,884.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_09_15_date_idx on daily_amazon_inventory_snapshots_p2020_09_15 dais_54 (cost=0.28..134.54 rows=3,884 width=89) (actual time=0.019..0.019 rows=1 loops=1)

62. 0.020 0.020 ↑ 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 dais_55 (cost=0.28..133.76 rows=3,832 width=89) (actual time=0.02..0.02 rows=1 loops=1)

63. 0.019 0.019 ↑ 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 dais_56 (cost=0.28..133.75 rows=3,831 width=89) (actual time=0.019..0.019 rows=1 loops=1)

64. 0.019 0.019 ↑ 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 dais_57 (cost=0.28..133.91 rows=3,842 width=89) (actual time=0.019..0.019 rows=1 loops=1)

65. 0.022 0.022 ↑ 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 dais_58 (cost=0.28..133.91 rows=3,842 width=89) (actual time=0.021..0.022 rows=1 loops=1)

66. 0.025 0.025 ↑ 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 dais_59 (cost=0.28..133.91 rows=3,842 width=89) (actual time=0.025..0.025 rows=1 loops=1)

67. 0.021 0.021 ↑ 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 dais_60 (cost=0.28..133.82 rows=3,836 width=89) (actual time=0.02..0.021 rows=1 loops=1)

68. 0.015 0.015 ↑ 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 dais_61 (cost=0.28..133.79 rows=3,834 width=89) (actual time=0.015..0.015 rows=1 loops=1)

69. 0.023 0.023 ↑ 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 dais_62 (cost=0.28..133.78 rows=3,833 width=89) (actual time=0.022..0.023 rows=1 loops=1)

70. 0.019 0.019 ↑ 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 dais_63 (cost=0.28..133.76 rows=3,832 width=89) (actual time=0.019..0.019 rows=1 loops=1)

71. 0.015 0.015 ↑ 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 dais_64 (cost=0.28..132.59 rows=3,821 width=89) (actual time=0.015..0.015 rows=1 loops=1)

72. 0.016 0.016 ↑ 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 dais_65 (cost=0.28..132.52 rows=3,816 width=89) (actual time=0.016..0.016 rows=1 loops=1)

73. 0.018 0.018 ↑ 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 dais_66 (cost=0.28..132.5 rows=3,815 width=89) (actual time=0.018..0.018 rows=1 loops=1)

74. 0.014 0.014 ↑ 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 dais_67 (cost=0.28..132.47 rows=3,813 width=89) (actual time=0.014..0.014 rows=1 loops=1)

75. 0.025 0.025 ↑ 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 dais_68 (cost=0.28..132.47 rows=3,813 width=89) (actual time=0.025..0.025 rows=1 loops=1)

76. 0.020 0.020 ↑ 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 dais_69 (cost=0.28..132.46 rows=3,812 width=90) (actual time=0.019..0.02 rows=1 loops=1)

77. 0.020 0.020 ↑ 3,811.0 1 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_01_date_idx on daily_amazon_inventory_snapshots_p2020_10_01 dais_70 (cost=0.28..132.45 rows=3,811 width=90) (actual time=0.02..0.02 rows=1 loops=1)

78. 0.021 0.021 ↑ 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 dais_71 (cost=0.28..132.45 rows=3,811 width=90) (actual time=0.021..0.021 rows=1 loops=1)

79. 0.019 0.019 ↑ 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 dais_72 (cost=0.28..132.45 rows=3,811 width=89) (actual time=0.018..0.019 rows=1 loops=1)

80. 0.941 0.941 ↑ 1.1 3,623 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_04_date_idx on daily_amazon_inventory_snapshots_p2020_10_04 dais_73 (cost=0.28..132.43 rows=3,810 width=89) (actual time=0.019..0.941 rows=3,623 loops=1)

81. 1.033 1.033 ↑ 1.0 3,807 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_05_date_idx on daily_amazon_inventory_snapshots_p2020_10_05 dais_74 (cost=0.28..132.38 rows=3,807 width=89) (actual time=0.018..1.033 rows=3,807 loops=1)

82. 1.033 1.033 ↑ 1.0 3,617 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_06_date_idx on daily_amazon_inventory_snapshots_p2020_10_06 dais_75 (cost=0.28..126.54 rows=3,617 width=90) (actual time=0.017..1.033 rows=3,617 loops=1)

83. 0.891 0.891 ↑ 1.0 3,614 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_07_date_idx on daily_amazon_inventory_snapshots_p2020_10_07 dais_76 (cost=0.28..126.49 rows=3,614 width=89) (actual time=0.017..0.891 rows=3,614 loops=1)

84. 1.063 1.063 ↑ 1.0 3,611 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_08_date_idx on daily_amazon_inventory_snapshots_p2020_10_08 dais_77 (cost=0.28..126.45 rows=3,611 width=89) (actual time=0.018..1.063 rows=3,611 loops=1)

85. 1.349 1.349 ↑ 1.0 3,633 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_09_date_idx on daily_amazon_inventory_snapshots_p2020_10_09 dais_78 (cost=0.28..126.77 rows=3,633 width=89) (actual time=0.012..1.349 rows=3,633 loops=1)

86. 0.947 0.947 ↑ 1.0 3,633 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_10_date_idx on daily_amazon_inventory_snapshots_p2020_10_10 dais_79 (cost=0.28..126.77 rows=3,633 width=89) (actual time=0.018..0.947 rows=3,633 loops=1)

87. 1.083 1.083 ↑ 1.0 3,632 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_11_date_idx on daily_amazon_inventory_snapshots_p2020_10_11 dais_80 (cost=0.28..126.76 rows=3,632 width=89) (actual time=0.019..1.083 rows=3,632 loops=1)

88. 0.934 0.934 ↑ 1.0 3,632 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_12_date_idx on daily_amazon_inventory_snapshots_p2020_10_12 dais_81 (cost=0.28..126.76 rows=3,632 width=89) (actual time=0.022..0.934 rows=3,632 loops=1)

89. 0.870 0.870 ↑ 1.0 3,626 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_13_date_idx on daily_amazon_inventory_snapshots_p2020_10_13 dais_82 (cost=0.28..126.67 rows=3,626 width=91) (actual time=0.013..0.87 rows=3,626 loops=1)

90. 0.003 0.003 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_14_date_idx on daily_amazon_inventory_snapshots_p2020_10_14 dais_83 (cost=0.14..14.89 rows=250 width=292) (actual time=0.003..0.003 rows=0 loops=1)

91. 0.002 0.002 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_15_date_idx on daily_amazon_inventory_snapshots_p2020_10_15 dais_84 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.002 rows=0 loops=1)

92. 0.002 0.002 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_16_date_idx on daily_amazon_inventory_snapshots_p2020_10_16 dais_85 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.002 rows=0 loops=1)

93. 0.002 0.002 ↓ 0.0 0 1

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

94. 0.002 0.002 ↓ 0.0 0 1

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

95. 0.003 0.003 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_19_date_idx on daily_amazon_inventory_snapshots_p2020_10_19 dais_88 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.003 rows=0 loops=1)

96. 0.002 0.002 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_20_date_idx on daily_amazon_inventory_snapshots_p2020_10_20 dais_89 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.002 rows=0 loops=1)

97. 0.002 0.002 ↓ 0.0 0 1

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

98. 0.002 0.002 ↓ 0.0 0 1

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

99. 0.002 0.002 ↓ 0.0 0 1

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

100. 0.002 0.002 ↓ 0.0 0 1

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

101. 0.002 0.002 ↓ 0.0 0 1

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

102. 0.002 0.002 ↓ 0.0 0 1

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

103. 0.002 0.002 ↓ 0.0 0 1

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

104. 0.002 0.002 ↓ 0.0 0 1

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

105. 0.002 0.002 ↓ 0.0 0 1

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

106. 0.002 0.002 ↓ 0.0 0 1

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

107. 0.002 0.002 ↓ 0.0 0 1

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

108. 0.002 0.002 ↓ 0.0 0 1

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

109. 0.002 0.002 ↓ 0.0 0 1

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

110. 0.002 0.002 ↓ 0.0 0 1

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

111. 0.002 0.002 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_11_04_date_idx on daily_amazon_inventory_snapshots_p2020_11_04 dais_104 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.002 rows=0 loops=1)

112. 0.002 0.002 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_p2020_11_05_date_idx on daily_amazon_inventory_snapshots_p2020_11_05 dais_105 (cost=0.14..14.89 rows=250 width=292) (actual time=0.002..0.002 rows=0 loops=1)

113. 0.002 0.002 ↓ 0.0 0 1

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

114. 0.002 0.002 ↓ 0.0 0 1

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

115. 0.002 0.002 ↓ 0.0 0 1

Index Scan using daily_amazon_inventory_snapshots_default_date_idx on daily_amazon_inventory_snapshots_default dais_108 (cost=0.14..14.89 rows=250 width=292) (actual time=0.001..0.002 rows=0 loops=1)

116. 0.000 0.000 ↑ 1.0 1 36,428

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

117. 0.001 0.011 ↑ 1.0 1 1

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

118. 0.010 0.010 ↑ 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.01..0.01 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. 0.567 0.567 ↑ 1.0 1 189

Index Scan using amazon_products_pkey on amazon_products ap (cost=0.28..0.3 rows=1 width=76) (actual time=0.003..0.003 rows=1 loops=189)

  • Index Cond: (seller_marketplace_sku_sha = dais.amazon_product_sha)
120. 0.519 0.519 ↑ 1.0 1 173

Index Scan using amazon_current_cogs_pkey on amazon_current_cogs acc (cost=0.41..0.46 rows=1 width=70) (actual time=0.003..0.003 rows=1 loops=173)

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