explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3jmK : 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.010 16.218 ↑ 1.0 5 1

ProjectSet (cost=14,453.31..14,453.37 rows=5 width=104) (actual time=16.159..16.218 rows=5 loops=1)

2. 0.000 16.208 ↑ 1.0 1 1

Aggregate (cost=14,453.31..14,453.32 rows=1 width=360) (actual time=16.151..16.208 rows=1 loops=1)

3.          

Initplan (for Aggregate)

4. 0.459 12.314 ↑ 1.0 1 1

Aggregate (cost=6,599.23..6,599.24 rows=1 width=4) (actual time=12.273..12.314 rows=1 loops=1)

5. 0.604 11.855 ↓ 7.7 9,205 1

Nested Loop (cost=2.33..6,596.22 rows=1,201 width=4) (actual time=1.443..11.855 rows=9,205 loops=1)

6. 0.002 0.019 ↑ 1.0 1 1

Aggregate (cost=2.19..2.2 rows=1 width=33) (actual time=0.017..0.019 rows=1 loops=1)

7. 0.001 0.017 ↑ 1.0 1 1

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

8. 0.016 0.016 ↑ 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.015..0.016 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))
9. 0.600 11.232 ↑ 9.1 9,205 1

Append (cost=0.14..5,759.66 rows=83,437 width=36) (actual time=1.41..11.232 rows=9,205 loops=1)

10. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_23_pkey on daily_amazon_inventory_snapshots_p2020_07_23 dais_109 (cost=0.14..2.16 rows=1 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
11. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_24_pkey on daily_amazon_inventory_snapshots_p2020_07_24 dais_110 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
12. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_25_pkey on daily_amazon_inventory_snapshots_p2020_07_25 dais_111 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
13. 0.007 0.007 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_26_pkey on daily_amazon_inventory_snapshots_p2020_07_26 dais_112 (cost=0.14..2.16 rows=1 width=36) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
14. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_27_pkey on daily_amazon_inventory_snapshots_p2020_07_27 dais_113 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
15. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_28_pkey on daily_amazon_inventory_snapshots_p2020_07_28 dais_114 (cost=0.14..2.16 rows=1 width=36) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
16. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_29_pkey on daily_amazon_inventory_snapshots_p2020_07_29 dais_115 (cost=0.14..2.16 rows=1 width=36) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
17. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_30_pkey on daily_amazon_inventory_snapshots_p2020_07_30 dais_116 (cost=0.14..2.16 rows=1 width=36) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
18. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_31_pkey on daily_amazon_inventory_snapshots_p2020_07_31 dais_117 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
19. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_01_pkey on daily_amazon_inventory_snapshots_p2020_08_01 dais_118 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
20. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_02_pkey on daily_amazon_inventory_snapshots_p2020_08_02 dais_119 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
21. 0.007 0.007 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_03_pkey on daily_amazon_inventory_snapshots_p2020_08_03 dais_120 (cost=0.14..2.16 rows=1 width=36) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
22. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_04_pkey on daily_amazon_inventory_snapshots_p2020_08_04 dais_121 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
23. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_05_pkey on daily_amazon_inventory_snapshots_p2020_08_05 dais_122 (cost=0.14..2.16 rows=1 width=36) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
24. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_06_pkey on daily_amazon_inventory_snapshots_p2020_08_06 dais_123 (cost=0.14..2.16 rows=1 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
25. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_07_pkey on daily_amazon_inventory_snapshots_p2020_08_07 dais_124 (cost=0.14..2.16 rows=1 width=36) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
26. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_08_pkey on daily_amazon_inventory_snapshots_p2020_08_08 dais_125 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
27. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_09_pkey on daily_amazon_inventory_snapshots_p2020_08_09 dais_126 (cost=0.14..2.16 rows=1 width=36) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
28. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_10_pkey on daily_amazon_inventory_snapshots_p2020_08_10 dais_127 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.01 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
29. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_11_pkey on daily_amazon_inventory_snapshots_p2020_08_11 dais_128 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
30. 0.370 0.370 ↓ 0.0 0 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_12 dais_129 (cost=0..104.95 rows=3,596 width=37) (actual time=0.37..0.37 rows=0 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
31. 0.404 0.404 ↓ 0.0 0 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_13 dais_130 (cost=0..106.71 rows=3,657 width=37) (actual time=0.404..0.404 rows=0 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
32. 0.426 0.426 ↓ 0.0 0 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_14 dais_131 (cost=0..106.7 rows=3,656 width=37) (actual time=0.426..0.426 rows=0 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
33. 0.059 0.059 ↑ 9.9 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_15_pkey on daily_amazon_inventory_snapshots_p2020_08_15 dais_132 (cost=0.28..67.25 rows=1,858 width=37) (actual time=0.028..0.059 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
34. 0.046 0.046 ↑ 9.9 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_16_pkey on daily_amazon_inventory_snapshots_p2020_08_16 dais_133 (cost=0.28..67.25 rows=1,858 width=37) (actual time=0.016..0.046 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
35. 0.049 0.049 ↑ 10.0 187 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_17_pkey on daily_amazon_inventory_snapshots_p2020_08_17 dais_134 (cost=0.28..67.42 rows=1,868 width=37) (actual time=0.016..0.049 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 6
36. 0.052 0.052 ↑ 10.1 187 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_18_pkey on daily_amazon_inventory_snapshots_p2020_08_18 dais_135 (cost=0.28..69.11 rows=1,892 width=37) (actual time=0.021..0.052 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 6
37. 0.046 0.046 ↑ 10.1 187 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_19_pkey on daily_amazon_inventory_snapshots_p2020_08_19 dais_136 (cost=0.28..68.11 rows=1,892 width=37) (actual time=0.016..0.046 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 6
38. 0.385 0.385 ↑ 10.4 187 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_20 dais_137 (cost=0..113.4 rows=1,936 width=37) (actual time=0.008..0.385 rows=187 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
39. 0.544 0.544 ↑ 10.3 187 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_21 dais_138 (cost=0..113.34 rows=1,934 width=37) (actual time=0.005..0.544 rows=187 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
40. 0.396 0.396 ↑ 10.4 186 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_22 dais_139 (cost=0..113.31 rows=1,932 width=37) (actual time=0.008..0.396 rows=186 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
41. 0.521 0.521 ↑ 10.4 186 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_23 dais_140 (cost=0..114.54 rows=1,942 width=37) (actual time=0.005..0.521 rows=186 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
42. 0.389 0.389 ↑ 10.4 186 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_24 dais_141 (cost=0..114.5 rows=1,940 width=37) (actual time=0.008..0.389 rows=186 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
43. 0.404 0.404 ↑ 10.4 186 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_25 dais_142 (cost=0..114.44 rows=1,938 width=37) (actual time=0.006..0.404 rows=186 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
44. 0.437 0.437 ↑ 10.4 186 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_26 dais_143 (cost=0..114.43 rows=1,937 width=37) (actual time=0.005..0.437 rows=186 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
45. 0.457 0.457 ↑ 10.4 186 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_27 dais_144 (cost=0..113.36 rows=1,934 width=37) (actual time=0.008..0.457 rows=186 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
46. 0.387 0.387 ↑ 10.4 186 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_28 dais_145 (cost=0..113.29 rows=1,932 width=37) (actual time=0.007..0.387 rows=186 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
47. 0.014 0.014 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_29_pkey on daily_amazon_inventory_snapshots_p2020_08_29 dais_146 (cost=0.14..2.16 rows=1 width=36) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
48. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_30_pkey on daily_amazon_inventory_snapshots_p2020_08_30 dais_147 (cost=0.14..2.16 rows=1 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
49. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_31_pkey on daily_amazon_inventory_snapshots_p2020_08_31 dais_148 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
50. 0.091 0.091 ↑ 5.2 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_01_pkey on daily_amazon_inventory_snapshots_p2020_09_01 dais_149 (cost=0.28..84.98 rows=973 width=36) (actual time=0.017..0.091 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
51. 0.093 0.093 ↑ 5.2 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_02_pkey on daily_amazon_inventory_snapshots_p2020_09_02 dais_150 (cost=0.28..85.99 rows=973 width=36) (actual time=0.021..0.093 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
52. 0.106 0.106 ↑ 5.2 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_03_pkey on daily_amazon_inventory_snapshots_p2020_09_03 dais_151 (cost=0.28..85.96 rows=970 width=36) (actual time=0.017..0.106 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
53. 0.085 0.085 ↑ 5.2 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_04_pkey on daily_amazon_inventory_snapshots_p2020_09_04 dais_152 (cost=0.28..85.97 rows=970 width=36) (actual time=0.016..0.085 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
54. 0.083 0.083 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_05_pkey on daily_amazon_inventory_snapshots_p2020_09_05 dais_153 (cost=0.28..84.95 rows=968 width=36) (actual time=0.016..0.083 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
55. 0.089 0.089 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_06_pkey on daily_amazon_inventory_snapshots_p2020_09_06 dais_154 (cost=0.28..84.94 rows=967 width=36) (actual time=0.017..0.089 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
56. 0.237 0.237 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_07_pkey on daily_amazon_inventory_snapshots_p2020_09_07 dais_155 (cost=0.28..85.22 rows=965 width=36) (actual time=0.153..0.237 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
57. 0.052 0.052 ↑ 5.2 186 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_08_pkey on daily_amazon_inventory_snapshots_p2020_09_08 dais_156 (cost=0.41..44.26 rows=963 width=36) (actual time=0.025..0.052 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
58. 0.275 0.275 ↑ 5.2 186 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_09_pkey on daily_amazon_inventory_snapshots_p2020_09_09 dais_157 (cost=0.28..84.16 rows=960 width=36) (actual time=0.017..0.275 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 186
59. 0.097 0.097 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_10_pkey on daily_amazon_inventory_snapshots_p2020_09_10 dais_158 (cost=0.28..84.23 rows=962 width=36) (actual time=0.021..0.097 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
60. 0.090 0.090 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_11_pkey on daily_amazon_inventory_snapshots_p2020_09_11 dais_159 (cost=0.28..84.24 rows=962 width=36) (actual time=0.015..0.09 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
61. 0.095 0.095 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_12_pkey on daily_amazon_inventory_snapshots_p2020_09_12 dais_160 (cost=0.28..84.24 rows=962 width=36) (actual time=0.016..0.095 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
62. 0.158 0.158 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_13_pkey on daily_amazon_inventory_snapshots_p2020_09_13 dais_161 (cost=0.28..84.23 rows=961 width=36) (actual time=0.023..0.158 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
63. 0.091 0.091 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_14_pkey on daily_amazon_inventory_snapshots_p2020_09_14 dais_162 (cost=0.28..84.22 rows=960 width=36) (actual time=0.018..0.091 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
64. 0.088 0.088 ↑ 5.2 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_15_pkey on daily_amazon_inventory_snapshots_p2020_09_15 dais_163 (cost=0.28..84.53 rows=971 width=36) (actual time=0.016..0.088 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
65. 0.111 0.111 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_16_pkey on daily_amazon_inventory_snapshots_p2020_09_16 dais_164 (cost=0.28..84.21 rows=958 width=36) (actual time=0.017..0.111 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
66. 0.089 0.089 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_17_pkey on daily_amazon_inventory_snapshots_p2020_09_17 dais_165 (cost=0.28..83.21 rows=958 width=36) (actual time=0.013..0.089 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
67. 0.086 0.086 ↑ 5.1 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_18_pkey on daily_amazon_inventory_snapshots_p2020_09_18 dais_166 (cost=0.28..82.27 rows=960 width=36) (actual time=0.016..0.086 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
68. 0.095 0.095 ↑ 5.1 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_19_pkey on daily_amazon_inventory_snapshots_p2020_09_19 dais_167 (cost=0.28..84.27 rows=960 width=36) (actual time=0.022..0.095 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
69. 0.090 0.090 ↑ 5.1 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_20_pkey on daily_amazon_inventory_snapshots_p2020_09_20 dais_168 (cost=0.28..84.27 rows=960 width=36) (actual time=0.016..0.09 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
70. 0.196 0.196 ↑ 5.1 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_21_pkey on daily_amazon_inventory_snapshots_p2020_09_21 dais_169 (cost=0.28..83.27 rows=959 width=36) (actual time=0.021..0.196 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
71. 0.092 0.092 ↑ 5.1 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_22_pkey on daily_amazon_inventory_snapshots_p2020_09_22 dais_170 (cost=0.28..83.26 rows=958 width=36) (actual time=0.019..0.092 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
72. 0.119 0.119 ↑ 5.1 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_23_pkey on daily_amazon_inventory_snapshots_p2020_09_23 dais_171 (cost=0.28..83.26 rows=958 width=36) (actual time=0.017..0.119 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
73. 0.098 0.098 ↑ 5.1 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_24_pkey on daily_amazon_inventory_snapshots_p2020_09_24 dais_172 (cost=0.28..83.26 rows=958 width=36) (actual time=0.022..0.098 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
74. 0.092 0.092 ↑ 5.1 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_25_pkey on daily_amazon_inventory_snapshots_p2020_09_25 dais_173 (cost=0.28..83.53 rows=955 width=36) (actual time=0.016..0.092 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
75. 0.094 0.094 ↑ 5.0 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_26_pkey on daily_amazon_inventory_snapshots_p2020_09_26 dais_174 (cost=0.28..83.52 rows=954 width=36) (actual time=0.017..0.094 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
76. 0.093 0.093 ↑ 5.0 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_27_pkey on daily_amazon_inventory_snapshots_p2020_09_27 dais_175 (cost=0.28..81.53 rows=954 width=36) (actual time=0.017..0.093 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
77. 0.092 0.092 ↑ 5.0 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_28_pkey on daily_amazon_inventory_snapshots_p2020_09_28 dais_176 (cost=0.28..81.51 rows=953 width=36) (actual time=0.015..0.092 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
78. 0.091 0.091 ↑ 5.0 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_29_pkey on daily_amazon_inventory_snapshots_p2020_09_29 dais_177 (cost=0.28..82.51 rows=953 width=36) (actual time=0.017..0.091 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
79. 0.089 0.089 ↑ 5.0 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_09_30_pkey on daily_amazon_inventory_snapshots_p2020_09_30 dais_178 (cost=0.28..82.52 rows=953 width=36) (actual time=0.019..0.089 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
80. 0.442 0.442 ↑ 5.0 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_01_pkey on daily_amazon_inventory_snapshots_p2020_10_01 dais_179 (cost=0.28..82.52 rows=953 width=36) (actual time=0.013..0.442 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
81. 0.098 0.098 ↑ 5.0 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_02_pkey on daily_amazon_inventory_snapshots_p2020_10_02 dais_180 (cost=0.28..82.52 rows=953 width=36) (actual time=0.025..0.098 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
82. 0.087 0.087 ↑ 5.0 189 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_03_pkey on daily_amazon_inventory_snapshots_p2020_10_03 dais_181 (cost=0.28..81.52 rows=953 width=36) (actual time=0.016..0.087 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 189
83. 0.087 0.087 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_04_pkey on daily_amazon_inventory_snapshots_p2020_10_04 dais_182 (cost=0.28..83.45 rows=952 width=36) (actual time=0.016..0.087 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
84. 0.101 0.101 ↑ 5.1 188 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_05_pkey on daily_amazon_inventory_snapshots_p2020_10_05 dais_183 (cost=0.28..83.46 rows=952 width=36) (actual time=0.028..0.101 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 188
85. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_06_pkey on daily_amazon_inventory_snapshots_p2020_10_06 dais_184 (cost=0.28..80.11 rows=1,206 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
86. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_07_pkey on daily_amazon_inventory_snapshots_p2020_10_07 dais_185 (cost=0.28..79.09 rows=1,205 width=36) (actual time=0.01..0.011 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
87. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_08_pkey on daily_amazon_inventory_snapshots_p2020_10_08 dais_186 (cost=0.28..79.07 rows=1,204 width=36) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
88. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_09_pkey on daily_amazon_inventory_snapshots_p2020_10_09 dais_187 (cost=0.28..79.19 rows=1,211 width=36) (actual time=0.01..0.011 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
89. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_10_pkey on daily_amazon_inventory_snapshots_p2020_10_10 dais_188 (cost=0.28..79.19 rows=1,211 width=36) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
90. 0.013 0.013 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_11_pkey on daily_amazon_inventory_snapshots_p2020_10_11 dais_189 (cost=0.28..80.19 rows=1,211 width=36) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
91. 0.159 0.159 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_12_pkey on daily_amazon_inventory_snapshots_p2020_10_12 dais_190 (cost=0.28..80.19 rows=1,211 width=36) (actual time=0.159..0.159 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
92. 0.443 0.443 ↓ 0.0 0 1

Seq Scan on daily_amazon_inventory_snapshots_p2020_10_13 dais_191 (cost=0..105.33 rows=3,626 width=37) (actual time=0.443..0.443 rows=0 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
93. 0.012 0.012 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_14_pkey on daily_amazon_inventory_snapshots_p2020_10_14 dais_192 (cost=0.14..2.16 rows=1 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
94. 0.043 0.043 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_15_pkey on daily_amazon_inventory_snapshots_p2020_10_15 dais_193 (cost=0.14..2.16 rows=1 width=36) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
95. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_16_pkey on daily_amazon_inventory_snapshots_p2020_10_16 dais_194 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
96. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_17_pkey on daily_amazon_inventory_snapshots_p2020_10_17 dais_195 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
97. 0.048 0.048 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_18_pkey on daily_amazon_inventory_snapshots_p2020_10_18 dais_196 (cost=0.14..2.16 rows=1 width=36) (actual time=0.048..0.048 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
98. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_19_pkey on daily_amazon_inventory_snapshots_p2020_10_19 dais_197 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
99. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_20_pkey on daily_amazon_inventory_snapshots_p2020_10_20 dais_198 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
100. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_21_pkey on daily_amazon_inventory_snapshots_p2020_10_21 dais_199 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
101. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_22_pkey on daily_amazon_inventory_snapshots_p2020_10_22 dais_200 (cost=0.14..2.16 rows=1 width=36) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
102. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_23_pkey on daily_amazon_inventory_snapshots_p2020_10_23 dais_201 (cost=0.14..2.16 rows=1 width=36) (actual time=0.01..0.011 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
103. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_24_pkey on daily_amazon_inventory_snapshots_p2020_10_24 dais_202 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
104. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_25_pkey on daily_amazon_inventory_snapshots_p2020_10_25 dais_203 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
105. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_26_pkey on daily_amazon_inventory_snapshots_p2020_10_26 dais_204 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
106. 0.016 0.016 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_27_pkey on daily_amazon_inventory_snapshots_p2020_10_27 dais_205 (cost=0.14..2.16 rows=1 width=36) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
107. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_28_pkey on daily_amazon_inventory_snapshots_p2020_10_28 dais_206 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
108. 0.012 0.012 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_29_pkey on daily_amazon_inventory_snapshots_p2020_10_29 dais_207 (cost=0.14..2.16 rows=1 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
109. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_30_pkey on daily_amazon_inventory_snapshots_p2020_10_30 dais_208 (cost=0.14..2.16 rows=1 width=36) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
110. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_31_pkey on daily_amazon_inventory_snapshots_p2020_10_31 dais_209 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
111. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_01_pkey on daily_amazon_inventory_snapshots_p2020_11_01 dais_210 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
112. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_02_pkey on daily_amazon_inventory_snapshots_p2020_11_02 dais_211 (cost=0.14..2.16 rows=1 width=36) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
113. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_03_pkey on daily_amazon_inventory_snapshots_p2020_11_03 dais_212 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
114. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_04_pkey on daily_amazon_inventory_snapshots_p2020_11_04 dais_213 (cost=0.14..2.16 rows=1 width=36) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
115. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_05_pkey on daily_amazon_inventory_snapshots_p2020_11_05 dais_214 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
116. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_06_pkey on daily_amazon_inventory_snapshots_p2020_11_06 dais_215 (cost=0.14..2.16 rows=1 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
117. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_07_pkey on daily_amazon_inventory_snapshots_p2020_11_07 dais_216 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
118. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_default_pkey on daily_amazon_inventory_snapshots_default dais_217 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
119. 0.300 15.905 ↑ 6.6 172 1

Hash Join (cost=253.92..7,777.1 rows=1,140 width=38) (actual time=15.044..15.905 rows=172 loops=1)

120. 0.194 13.073 ↑ 6.6 172 1

Nested Loop (cost=2.61..7,519.81 rows=1,140 width=97) (actual time=12.345..13.073 rows=172 loops=1)

121. 0.030 12.503 ↑ 6.1 188 1

Nested Loop (cost=2.33..7,176.25 rows=1,140 width=53) (actual time=12.332..12.503 rows=188 loops=1)

122. 0.005 0.026 ↑ 1.0 1 1

Aggregate (cost=2.19..2.2 rows=1 width=33) (actual time=0.025..0.026 rows=1 loops=1)

123. 0.001 0.021 ↑ 1.0 1 1

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

124. 0.020 0.020 ↑ 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.02..0.02 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))
125. 12.312 12.447 ↑ 443.8 188 1

Append (cost=0.14..6,339.68 rows=83,437 width=86) (actual time=12.298..12.447 rows=188 loops=1)

126. 0.000 0.000 ↓ 0.0 0 0

Index Scan using daily_amazon_inventory_snapshots_p2020_07_23_date_idx on daily_amazon_inventory_snapshots_p2020_07_23 dais (cost=0.14..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

  • Index Cond: (date = $1)
  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
135. 0.000 0.000 ↓ 0.0 0 0

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_12 dais_20 (cost=0..113.94 rows=3,596 width=88) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_13 dais_21 (cost=0..115.85 rows=3,657 width=88) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_14 dais_22 (cost=0..115.84 rows=3,656 width=88) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_15 dais_23 (cost=0..119.74 rows=1,858 width=88) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_16 dais_24 (cost=0..119.72 rows=1,858 width=88) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_17 dais_25 (cost=0..120.06 rows=1,868 width=88) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_18 dais_26 (cost=0..121.76 rows=1,892 width=88) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_19 dais_27 (cost=0..121.75 rows=1,892 width=88) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_20 dais_28 (cost=0..123.08 rows=1,936 width=87) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_21 dais_29 (cost=0..123 rows=1,934 width=87) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_22 dais_30 (cost=0..122.97 rows=1,932 width=87) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_23 dais_31 (cost=0..124.25 rows=1,942 width=87) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_24 dais_32 (cost=0..124.2 rows=1,940 width=87) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_25 dais_33 (cost=0..124.12 rows=1,938 width=87) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_26 dais_34 (cost=0..124.11 rows=1,937 width=87) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_27 dais_35 (cost=0..123.03 rows=1,934 width=87) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_08_28 dais_36 (cost=0..122.94 rows=1,932 width=87) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_01_pkey on daily_amazon_inventory_snapshots_p2020_09_01 dais_40 (cost=0.28..87.41 rows=973 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_02_pkey on daily_amazon_inventory_snapshots_p2020_09_02 dais_41 (cost=0.28..88.42 rows=973 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_03_pkey on daily_amazon_inventory_snapshots_p2020_09_03 dais_42 (cost=0.28..88.39 rows=970 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_04_pkey on daily_amazon_inventory_snapshots_p2020_09_04 dais_43 (cost=0.28..88.39 rows=970 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_05_pkey on daily_amazon_inventory_snapshots_p2020_09_05 dais_44 (cost=0.28..87.37 rows=968 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_06_pkey on daily_amazon_inventory_snapshots_p2020_09_06 dais_45 (cost=0.28..87.36 rows=967 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_07_pkey on daily_amazon_inventory_snapshots_p2020_09_07 dais_46 (cost=0.28..87.63 rows=965 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_08_pkey on daily_amazon_inventory_snapshots_p2020_09_08 dais_47 (cost=0.41..134.09 rows=963 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_09_pkey on daily_amazon_inventory_snapshots_p2020_09_09 dais_48 (cost=0.28..86.56 rows=960 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_10_pkey on daily_amazon_inventory_snapshots_p2020_09_10 dais_49 (cost=0.28..86.64 rows=962 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_11_pkey on daily_amazon_inventory_snapshots_p2020_09_11 dais_50 (cost=0.28..86.64 rows=962 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_12_pkey on daily_amazon_inventory_snapshots_p2020_09_12 dais_51 (cost=0.28..86.65 rows=962 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_13_pkey on daily_amazon_inventory_snapshots_p2020_09_13 dais_52 (cost=0.28..86.63 rows=961 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_14_pkey on daily_amazon_inventory_snapshots_p2020_09_14 dais_53 (cost=0.28..86.62 rows=960 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_15_pkey on daily_amazon_inventory_snapshots_p2020_09_15 dais_54 (cost=0.28..86.96 rows=971 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_16_pkey on daily_amazon_inventory_snapshots_p2020_09_16 dais_55 (cost=0.28..86.6 rows=958 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_17_pkey on daily_amazon_inventory_snapshots_p2020_09_17 dais_56 (cost=0.28..85.61 rows=958 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_18_pkey on daily_amazon_inventory_snapshots_p2020_09_18 dais_57 (cost=0.28..84.67 rows=960 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_19_pkey on daily_amazon_inventory_snapshots_p2020_09_19 dais_58 (cost=0.28..86.67 rows=960 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_20_pkey on daily_amazon_inventory_snapshots_p2020_09_20 dais_59 (cost=0.28..86.67 rows=960 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_21_pkey on daily_amazon_inventory_snapshots_p2020_09_21 dais_60 (cost=0.28..85.67 rows=959 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_22_pkey on daily_amazon_inventory_snapshots_p2020_09_22 dais_61 (cost=0.28..85.65 rows=958 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_23_pkey on daily_amazon_inventory_snapshots_p2020_09_23 dais_62 (cost=0.28..85.66 rows=958 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_24_pkey on daily_amazon_inventory_snapshots_p2020_09_24 dais_63 (cost=0.28..85.66 rows=958 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_25_pkey on daily_amazon_inventory_snapshots_p2020_09_25 dais_64 (cost=0.28..85.92 rows=955 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_26_pkey on daily_amazon_inventory_snapshots_p2020_09_26 dais_65 (cost=0.28..85.91 rows=954 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_27_pkey on daily_amazon_inventory_snapshots_p2020_09_27 dais_66 (cost=0.28..83.91 rows=954 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_28_pkey on daily_amazon_inventory_snapshots_p2020_09_28 dais_67 (cost=0.28..83.9 rows=953 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_29_pkey on daily_amazon_inventory_snapshots_p2020_09_29 dais_68 (cost=0.28..84.9 rows=953 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_09_30_pkey on daily_amazon_inventory_snapshots_p2020_09_30 dais_69 (cost=0.28..84.9 rows=953 width=86) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_01_pkey on daily_amazon_inventory_snapshots_p2020_10_01 dais_70 (cost=0.28..84.9 rows=953 width=86) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_02_pkey on daily_amazon_inventory_snapshots_p2020_10_02 dais_71 (cost=0.28..84.9 rows=953 width=86) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_03_pkey on daily_amazon_inventory_snapshots_p2020_10_03 dais_72 (cost=0.28..83.9 rows=953 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_04_pkey on daily_amazon_inventory_snapshots_p2020_10_04 dais_73 (cost=0.28..85.83 rows=952 width=85) (never executed)

  • Index Cond: ((amazon_seller_sha = amazon_sellers.seller_marketplace_sha) AND (date = $1))
200. 0.135 0.135 ↑ 5.1 188 1

Index Scan using daily_amazon_inventory_snapshots_p2020_10_05_pkey on daily_amazon_inventory_snapshots_p2020_10_05 dais_74 (cost=0.28..85.84 rows=952 width=85) (actual time=0.015..0.135 rows=188 loops=1)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_06_pkey on daily_amazon_inventory_snapshots_p2020_10_06 dais_75 (cost=0.28..83.12 rows=1,206 width=86) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_07_pkey on daily_amazon_inventory_snapshots_p2020_10_07 dais_76 (cost=0.28..82.1 rows=1,205 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_08_pkey on daily_amazon_inventory_snapshots_p2020_10_08 dais_77 (cost=0.28..82.08 rows=1,204 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_09_pkey on daily_amazon_inventory_snapshots_p2020_10_09 dais_78 (cost=0.28..82.22 rows=1,211 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_10_pkey on daily_amazon_inventory_snapshots_p2020_10_10 dais_79 (cost=0.28..82.22 rows=1,211 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_11_pkey on daily_amazon_inventory_snapshots_p2020_10_11 dais_80 (cost=0.28..83.22 rows=1,211 width=85) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_p2020_10_12_pkey on daily_amazon_inventory_snapshots_p2020_10_12 dais_81 (cost=0.28..83.22 rows=1,211 width=85) (never executed)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_10_13 dais_82 (cost=0..114.39 rows=3,626 width=87) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

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..2.17 rows=1 width=288) (never executed)

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

Index Scan using daily_amazon_inventory_snapshots_default_date_idx on daily_amazon_inventory_snapshots_default dais_108 (cost=0.14..2.17 rows=1 width=288) (never executed)

  • Index Cond: (date = $1)
  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
235. 0.376 0.376 ↑ 1.0 1 188

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

  • Index Cond: (seller_marketplace_sku_sha = dais.amazon_product_sha)
236. 1.660 2.532 ↑ 1.0 6,212 1

Hash (cost=158.12..158.12 rows=6,212 width=70) (actual time=2.532..2.532 rows=6,212 loops=1)

237. 0.872 0.872 ↑ 1.0 6,212 1

Seq Scan on amazon_current_cogs acc (cost=0..158.12 rows=6,212 width=70) (actual time=0.01..0.872 rows=6,212 loops=1)

Planning time : 15.128 ms
Execution time : 17.739 ms