explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XYEGK : Optimization for: plan #QM6w

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.017 98.065 ↑ 1.0 5 1

ProjectSet (cost=9,011.39..9,011.45 rows=5 width=104) (actual time=97.989..98.065 rows=5 loops=1)

2. 0.684 98.048 ↑ 1.0 1 1

Aggregate (cost=9,011.39..9,011.4 rows=1 width=360) (actual time=97.975..98.048 rows=1 loops=1)

3.          

Initplan (for Aggregate)

4. 0.504 15.627 ↑ 1.0 1 1

Aggregate (cost=5,791.67..5,791.68 rows=1 width=4) (actual time=15.573..15.627 rows=1 loops=1)

5. 5.795 15.123 ↓ 7.0 9,205 1

Nested Loop (cost=2.33..5,788.38 rows=1,315 width=4) (actual time=0.138..15.123 rows=9,205 loops=1)

6. 0.004 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.006 ↑ 1.0 1 1

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

8. 0.005 0.005 ↑ 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.005..0.005 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.656 9.318 ↑ 8.3 9,205 1

Append (cost=0.14..5,025.28 rows=76,090 width=36) (actual time=0.105..9.318 rows=9,205 loops=1)

10. 0.004 0.004 ↓ 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.003..0.004 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
11. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
12. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
13. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
14. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
15. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
16. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
17. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
18. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
19. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
20. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
21. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
22. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
23. 0.003 0.003 ↓ 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.002..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
24. 0.003 0.003 ↓ 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.002..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
25. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
26. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
27. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
28. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
29. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

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

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_12_pkey on daily_amazon_inventory_snapshots_p2020_08_12 daily_amazon_inventory_snapshots_p2020_08_12 (cost=0.28..89.41 rows=1,847 width=37) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
31. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_13_pkey on daily_amazon_inventory_snapshots_p2020_08_13 daily_amazon_inventory_snapshots_p2020_08_13 (cost=0.28..89.54 rows=1,874 width=37) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
32. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_14_pkey on daily_amazon_inventory_snapshots_p2020_08_14 daily_amazon_inventory_snapshots_p2020_08_14 (cost=0.28..90.12 rows=1,874 width=37) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
33. 0.043 0.043 ↑ 7.6 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..100.49 rows=1,428 width=37) (actual time=0.011..0.043 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
34. 0.041 0.041 ↑ 7.6 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..99.58 rows=1,428 width=37) (actual time=0.01..0.041 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
35. 0.041 0.041 ↑ 7.7 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..97.27 rows=1,436 width=37) (actual time=0.01..0.041 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 6
36. 0.041 0.041 ↑ 7.8 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..100.26 rows=1,452 width=37) (actual time=0.01..0.041 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 6
37. 0.041 0.041 ↑ 7.8 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..99.24 rows=1,452 width=37) (actual time=0.009..0.041 rows=187 loops=1)

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

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_20_pkey on daily_amazon_inventory_snapshots_p2020_08_20 daily_amazon_inventory_snapshots_p2020_08_20 (cost=0.28..114.66 rows=1,451 width=37) (actual time=0.008..0.041 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 6
39. 0.042 0.042 ↑ 7.7 187 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_21_pkey on daily_amazon_inventory_snapshots_p2020_08_21 daily_amazon_inventory_snapshots_p2020_08_21 (cost=0.28..114.75 rows=1,449 width=37) (actual time=0.009..0.042 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 6
40. 0.039 0.039 ↑ 7.8 186 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_22_pkey on daily_amazon_inventory_snapshots_p2020_08_22 daily_amazon_inventory_snapshots_p2020_08_22 (cost=0.28..114.93 rows=1,448 width=37) (actual time=0.008..0.039 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 5
41. 0.054 0.054 ↑ 7.8 186 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_23_pkey on daily_amazon_inventory_snapshots_p2020_08_23 daily_amazon_inventory_snapshots_p2020_08_23 (cost=0.28..114.87 rows=1,454 width=37) (actual time=0.008..0.054 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 5
42. 0.048 0.048 ↑ 7.8 186 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_24_pkey on daily_amazon_inventory_snapshots_p2020_08_24 daily_amazon_inventory_snapshots_p2020_08_24 (cost=0.28..114.77 rows=1,453 width=37) (actual time=0.015..0.048 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 5
43. 0.046 0.046 ↑ 7.8 186 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_25_pkey on daily_amazon_inventory_snapshots_p2020_08_25 daily_amazon_inventory_snapshots_p2020_08_25 (cost=0.28..114.59 rows=1,451 width=37) (actual time=0.013..0.046 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 5
44. 0.042 0.042 ↑ 7.8 186 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_26_pkey on daily_amazon_inventory_snapshots_p2020_08_26 daily_amazon_inventory_snapshots_p2020_08_26 (cost=0.28..115.65 rows=1,450 width=37) (actual time=0.011..0.042 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 5
45. 0.041 0.041 ↑ 7.8 186 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_27_pkey on daily_amazon_inventory_snapshots_p2020_08_27 daily_amazon_inventory_snapshots_p2020_08_27 (cost=0.28..113.85 rows=1,449 width=37) (actual time=0.009..0.041 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 5
46. 0.042 0.042 ↑ 7.8 186 1

Index Only Scan using daily_amazon_inventory_snapshots_p2020_08_28_pkey on daily_amazon_inventory_snapshots_p2020_08_28 daily_amazon_inventory_snapshots_p2020_08_28 (cost=0.28..114.91 rows=1,447 width=37) (actual time=0.01..0.042 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 5
47. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
48. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
49. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
50. 0.041 0.041 ↑ 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..52.92 rows=973 width=36) (actual time=0.01..0.041 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
51. 0.040 0.040 ↑ 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..53.92 rows=973 width=36) (actual time=0.009..0.04 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
52. 0.041 0.041 ↑ 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..53.17 rows=970 width=36) (actual time=0.009..0.041 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
53. 0.039 0.039 ↑ 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..53.17 rows=970 width=36) (actual time=0.008..0.039 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
54. 0.040 0.040 ↑ 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..51.85 rows=968 width=36) (actual time=0.009..0.04 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
55. 0.058 0.058 ↑ 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..53.13 rows=967 width=36) (actual time=0.028..0.058 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
56. 0.039 0.039 ↑ 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..52.81 rows=965 width=36) (actual time=0.008..0.039 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
57. 0.041 0.041 ↑ 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..47.26 rows=963 width=36) (actual time=0.01..0.041 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 5
58. 0.041 0.041 ↑ 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.41..49.24 rows=962 width=36) (actual time=0.011..0.041 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 5
59. 3.032 3.032 ↑ 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.41..66.17 rows=962 width=36) (actual time=2.988..3.032 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
60. 0.055 0.055 ↑ 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.41..67.17 rows=962 width=36) (actual time=0.024..0.055 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
61. 0.051 0.051 ↑ 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.41..46.24 rows=962 width=36) (actual time=0.02..0.051 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
62. 0.052 0.052 ↑ 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.41..47.22 rows=961 width=36) (actual time=0.021..0.052 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
63. 0.057 0.057 ↑ 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.41..47.21 rows=960 width=36) (actual time=0.024..0.057 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
64. 0.051 0.051 ↑ 4.5 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.41..72.44 rows=853 width=36) (actual time=0.017..0.051 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
65. 0.059 0.059 ↑ 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..42.05 rows=958 width=36) (actual time=0.024..0.059 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
66. 0.051 0.051 ↑ 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.41..47.17 rows=958 width=36) (actual time=0.018..0.051 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
67. 0.051 0.051 ↑ 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.41..59.75 rows=960 width=36) (actual time=0.018..0.051 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 8
68. 0.048 0.048 ↑ 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.41..47.21 rows=960 width=36) (actual time=0.018..0.048 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
69. 0.051 0.051 ↑ 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.41..47.21 rows=960 width=36) (actual time=0.019..0.051 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 8
70. 0.060 0.060 ↑ 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.41..44.19 rows=959 width=36) (actual time=0.018..0.06 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 8
71. 0.050 0.050 ↑ 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.41..45.17 rows=958 width=36) (actual time=0.018..0.05 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 8
72. 2.039 2.039 ↑ 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.41..44.17 rows=958 width=36) (actual time=1.979..2.039 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 8
73. 0.068 0.068 ↑ 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.41..47.17 rows=958 width=36) (actual time=0.036..0.068 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
74. 0.051 0.051 ↑ 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.41..47.12 rows=955 width=36) (actual time=0.02..0.051 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
75. 0.052 0.052 ↑ 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.41..47.1 rows=954 width=36) (actual time=0.019..0.052 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
76. 0.051 0.051 ↑ 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.41..66.09 rows=954 width=36) (actual time=0.02..0.051 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
77. 0.050 0.050 ↑ 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.41..66.08 rows=953 width=36) (actual time=0.018..0.05 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
78. 0.053 0.053 ↑ 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..40.96 rows=953 width=36) (actual time=0.018..0.053 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 8
79. 0.058 0.058 ↑ 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..41.96 rows=953 width=36) (actual time=0.025..0.058 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 8
80. 0.050 0.050 ↑ 4.5 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.41..63.96 rows=845 width=36) (actual time=0.014..0.05 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 7
81. 0.048 0.048 ↑ 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.41..47.08 rows=953 width=36) (actual time=0.017..0.048 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 8
82. 0.080 0.080 ↑ 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.41..65.22 rows=953 width=36) (actual time=0.019..0.08 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
  • Heap Fetches: 8
83. 0.066 0.066 ↑ 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.41..47.06 rows=952 width=36) (actual time=0.035..0.066 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
84. 0.048 0.048 ↑ 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.41..47.06 rows=952 width=36) (actual time=0.021..0.048 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
85. 0.012 0.012 ↓ 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..66.43 rows=1,018 width=36) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
86. 0.013 0.013 ↓ 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..65.48 rows=1,017 width=36) (actual time=0.012..0.013 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
87. 0.016 0.016 ↓ 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.41..70.01 rows=1,016 width=36) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
88. 0.013 0.013 ↓ 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.41..73.17 rows=1,023 width=36) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
89. 0.012 0.012 ↓ 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..62.08 rows=1,023 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
90. 0.012 0.012 ↓ 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..59.69 rows=1,022 width=36) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
91. 0.012 0.012 ↓ 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..60.71 rows=1,022 width=36) (actual time=0.012..0.012 rows=0 loops=1)

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

Index Only Scan using daily_amazon_inventory_snapshots_p2020_10_13_pkey on daily_amazon_inventory_snapshots_p2020_10_13 daily_amazon_inventory_snapshots_p2020_10_13 (cost=0.41..119.36 rows=2,040 width=37) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
93. 0.015 0.015 ↓ 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.41..101.55 rows=2,032 width=37) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
94. 0.011 0.011 ↓ 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.28..108.45 rows=2,021 width=37) (actual time=0.011..0.011 rows=0 loops=1)

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

Seq Scan on daily_amazon_inventory_snapshots_p2020_10_16 daily_amazon_inventory_snapshots_p2020_10_16 (cost=0..141.88 rows=3,590 width=37) (actual time=0.846..0.846 rows=0 loops=1)

  • Filter: (amazon_sellers_1.seller_marketplace_sha = amazon_seller_sha)
96. 0.017 0.017 ↓ 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.017..0.017 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
97. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
98. 0.018 0.018 ↓ 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.018..0.018 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
99. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
100. 0.021 0.021 ↓ 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.021..0.021 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
101. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
102. 0.012 0.012 ↓ 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.011..0.012 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.009 0.009 ↓ 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.009..0.009 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 daily_amazon_inventory_snapshots_p2020_10_26 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..0.009 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.008..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.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
109. 0.011 0.011 ↓ 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.011..0.011 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.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 daily_amazon_inventory_snapshots_p2020_11_01 (cost=0.14..2.16 rows=1 width=36) (actual time=0.008..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 daily_amazon_inventory_snapshots_p2020_11_02 (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 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.009 0.009 ↓ 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.009..0.009 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.009 0.009 ↓ 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.009 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.008..0.008 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers_1.seller_marketplace_sha)
119. 11.045 81.737 ↓ 7.1 2,511 1

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

120. 9.057 58.137 ↓ 7.1 2,511 1

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

121. 0.418 34.616 ↓ 10.2 3,616 1

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

122. 0.006 0.029 ↑ 1.0 1 1

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

123. 0.002 0.023 ↑ 1.0 1 1

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

124. 0.021 0.021 ↑ 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.021..0.021 rows=1 loops=1)

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

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

126. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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