explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qJ3y

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.010 16.904 ↑ 1.0 5 1

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

2. 0.000 16.894 ↑ 1.0 1 1

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

3.          

Initplan (for Aggregate)

4. 0.418 12.785 ↑ 1.0 1 1

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

5. 0.622 12.367 ↓ 7.7 9,205 1

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

6. 0.002 0.010 ↑ 1.0 1 1

Aggregate (cost=2.19..2.2 rows=1 width=33) (actual time=0.008..0.01 rows=1 loops=1)

7. 0.001 0.008 ↑ 1.0 1 1

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

8. 0.007 0.007 ↑ 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.007..0.007 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.567 11.735 ↑ 9.1 9,205 1

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

10. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_23_pkey on daily_amazon_inventory_snapshots_p2020_07_23 daily_amazon_inventory_snapshots_p2020_07_23 (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)
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 daily_amazon_inventory_snapshots_p2020_07_24 (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)
12. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_25_pkey on daily_amazon_inventory_snapshots_p2020_07_25 daily_amazon_inventory_snapshots_p2020_07_25 (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)
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 daily_amazon_inventory_snapshots_p2020_07_26 (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.014 0.014 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_27_pkey on daily_amazon_inventory_snapshots_p2020_07_27 daily_amazon_inventory_snapshots_p2020_07_27 (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)
15. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_28_pkey on daily_amazon_inventory_snapshots_p2020_07_28 daily_amazon_inventory_snapshots_p2020_07_28 (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)
16. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_07_29_pkey on daily_amazon_inventory_snapshots_p2020_07_29 daily_amazon_inventory_snapshots_p2020_07_29 (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)
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 daily_amazon_inventory_snapshots_p2020_07_30 (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)
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 daily_amazon_inventory_snapshots_p2020_07_31 (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.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_01_pkey on daily_amazon_inventory_snapshots_p2020_08_01 daily_amazon_inventory_snapshots_p2020_08_01 (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)
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 daily_amazon_inventory_snapshots_p2020_08_02 (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.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_03_pkey on daily_amazon_inventory_snapshots_p2020_08_03 daily_amazon_inventory_snapshots_p2020_08_03 (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)
22. 0.007 0.007 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_04_pkey on daily_amazon_inventory_snapshots_p2020_08_04 daily_amazon_inventory_snapshots_p2020_08_04 (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)
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 daily_amazon_inventory_snapshots_p2020_08_05 (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.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_06_pkey on daily_amazon_inventory_snapshots_p2020_08_06 daily_amazon_inventory_snapshots_p2020_08_06 (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)
25. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_07_pkey on daily_amazon_inventory_snapshots_p2020_08_07 daily_amazon_inventory_snapshots_p2020_08_07 (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)
26. 0.007 0.007 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_08_pkey on daily_amazon_inventory_snapshots_p2020_08_08 daily_amazon_inventory_snapshots_p2020_08_08 (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)
27. 0.014 0.014 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_09_pkey on daily_amazon_inventory_snapshots_p2020_08_09 daily_amazon_inventory_snapshots_p2020_08_09 (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)
28. 0.012 0.012 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_10_pkey on daily_amazon_inventory_snapshots_p2020_08_10 daily_amazon_inventory_snapshots_p2020_08_10 (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)
29. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_11_pkey on daily_amazon_inventory_snapshots_p2020_08_11 daily_amazon_inventory_snapshots_p2020_08_11 (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)
30. 0.410 0.410 ↓ 0.0 0 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_30_pkey on daily_amazon_inventory_snapshots_p2020_08_30 daily_amazon_inventory_snapshots_p2020_08_30 (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)
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 daily_amazon_inventory_snapshots_p2020_08_31 (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.110 0.110 ↑ 5.2 188 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_14_pkey on daily_amazon_inventory_snapshots_p2020_10_14 daily_amazon_inventory_snapshots_p2020_10_14 (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)
94. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_15_pkey on daily_amazon_inventory_snapshots_p2020_10_15 daily_amazon_inventory_snapshots_p2020_10_15 (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)
95. 0.012 0.012 ↓ 0.0 0 1

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

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

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_17_pkey on daily_amazon_inventory_snapshots_p2020_10_17 daily_amazon_inventory_snapshots_p2020_10_17 (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)
97. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_18_pkey on daily_amazon_inventory_snapshots_p2020_10_18 daily_amazon_inventory_snapshots_p2020_10_18 (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)
98. 0.014 0.014 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_19_pkey on daily_amazon_inventory_snapshots_p2020_10_19 daily_amazon_inventory_snapshots_p2020_10_19 (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)
99. 0.014 0.014 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_20_pkey on daily_amazon_inventory_snapshots_p2020_10_20 daily_amazon_inventory_snapshots_p2020_10_20 (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)
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 daily_amazon_inventory_snapshots_p2020_10_21 (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.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_22_pkey on daily_amazon_inventory_snapshots_p2020_10_22 daily_amazon_inventory_snapshots_p2020_10_22 (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)
102. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_23_pkey on daily_amazon_inventory_snapshots_p2020_10_23 daily_amazon_inventory_snapshots_p2020_10_23 (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)
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 daily_amazon_inventory_snapshots_p2020_10_24 (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 daily_amazon_inventory_snapshots_p2020_10_25 (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)
105. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_26_pkey on daily_amazon_inventory_snapshots_p2020_10_26 daily_amazon_inventory_snapshots_p2020_10_26 (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)
106. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_27_pkey on daily_amazon_inventory_snapshots_p2020_10_27 daily_amazon_inventory_snapshots_p2020_10_27 (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)
107. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_28_pkey on daily_amazon_inventory_snapshots_p2020_10_28 daily_amazon_inventory_snapshots_p2020_10_28 (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)
108. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_29_pkey on daily_amazon_inventory_snapshots_p2020_10_29 daily_amazon_inventory_snapshots_p2020_10_29 (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)
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 daily_amazon_inventory_snapshots_p2020_10_30 (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)
110. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_31_pkey on daily_amazon_inventory_snapshots_p2020_10_31 daily_amazon_inventory_snapshots_p2020_10_31 (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)
111. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_01_pkey on daily_amazon_inventory_snapshots_p2020_11_01 daily_amazon_inventory_snapshots_p2020_11_01 (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)
112. 0.015 0.015 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_02_pkey on daily_amazon_inventory_snapshots_p2020_11_02 daily_amazon_inventory_snapshots_p2020_11_02 (cost=0.14..2.16 rows=1 width=36) (actual time=0.014..0.015 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 daily_amazon_inventory_snapshots_p2020_11_03 (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.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_04_pkey on daily_amazon_inventory_snapshots_p2020_11_04 daily_amazon_inventory_snapshots_p2020_11_04 (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)
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 daily_amazon_inventory_snapshots_p2020_11_05 (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.008 0.008 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_06_pkey on daily_amazon_inventory_snapshots_p2020_11_06 daily_amazon_inventory_snapshots_p2020_11_06 (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)
117. 0.010 0.010 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_11_07_pkey on daily_amazon_inventory_snapshots_p2020_11_07 daily_amazon_inventory_snapshots_p2020_11_07 (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)
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 daily_amazon_inventory_snapshots_default (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)
119. 0.118 16.610 ↑ 6.6 172 1

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

120. 0.062 13.594 ↑ 6.6 172 1

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

121. 0.032 12.968 ↑ 6.1 188 1

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

122. 0.004 0.037 ↑ 1.0 1 1

Aggregate (cost=2.19..2.2 rows=1 width=33) (actual time=0.035..0.037 rows=1 loops=1)

123. 0.002 0.033 ↑ 1.0 1 1

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

124. 0.031 0.031 ↑ 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.031..0.031 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.784 12.899 ↑ 443.8 188 1

Append (cost=0.14..6,339.68 rows=83,437 width=86) (actual time=12.78..12.899 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.115 0.115 ↑ 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.021..0.115 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.564 0.564 ↑ 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.003..0.003 rows=1 loops=188)

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

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

237. 1.017 1.017 ↑ 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..1.017 rows=6,212 loops=1)

Planning time : 29.291 ms
Execution time : 20.104 ms