explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jwhz : Optimization for: plan #olq7

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.434 11.843 ↑ 1.0 1 1

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

2. 0.587 11.409 ↓ 7.7 9,205 1

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

3. 0.006 0.024 ↑ 1.0 1 1

Aggregate (cost=2.19..2.2 rows=1 width=33) (actual time=0.022..0.024 rows=1 loops=1)

4. 0.002 0.018 ↑ 1.0 1 1

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

5. 0.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

  • Index Cond: (((seller_id)::text = 'A24BVQ69RJOKWH'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text))
  • Filter: (((seller_id)::text ~~ 'A24BVQ69RJOKWH'::text) AND ((marketplace_id)::text ~~ 'ATVPDKIKX0DER'::text))
6. 0.594 10.798 ↑ 9.1 9,205 1

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
16. 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.seller_marketplace_sha)
17. 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.seller_marketplace_sha)
18. 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.seller_marketplace_sha)
19. 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.002..0.003 rows=0 loops=1)

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

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

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

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

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

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

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

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

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
28. 0.352 0.352 ↓ 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.352..0.352 rows=0 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
29. 0.360 0.360 ↓ 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.36..0.36 rows=0 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
30. 0.044 0.044 ↑ 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.015..0.044 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 7
31. 0.038 0.038 ↑ 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.008..0.038 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 7
32. 0.037 0.037 ↑ 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.009..0.037 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 6
33. 0.039 0.039 ↑ 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.009..0.039 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 6
34. 0.037 0.037 ↑ 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.009..0.037 rows=187 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 6
35. 0.386 0.386 ↑ 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.007..0.386 rows=187 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
36. 0.644 0.644 ↑ 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.005..0.644 rows=187 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
37. 1.891 1.891 ↑ 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.01..1.891 rows=186 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
38. 0.390 0.390 ↑ 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.011..0.39 rows=186 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
39. 0.400 0.400 ↑ 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.006..0.4 rows=186 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
40. 0.382 0.382 ↑ 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.006..0.382 rows=186 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
41. 0.494 0.494 ↑ 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.005..0.494 rows=186 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
42. 0.394 0.394 ↑ 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.009..0.394 rows=186 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
43. 0.433 0.433 ↑ 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.006..0.433 rows=186 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
44. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

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

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
47. 0.083 0.083 ↑ 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.011..0.083 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
48. 0.080 0.080 ↑ 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.008..0.08 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
49. 0.081 0.081 ↑ 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.009..0.081 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
50. 0.079 0.079 ↑ 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.008..0.079 rows=188 loops=1)

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

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

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
52. 0.083 0.083 ↑ 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.01..0.083 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
53. 0.079 0.079 ↑ 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.008..0.079 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
54. 0.036 0.036 ↑ 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.009..0.036 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
55. 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.011..0.106 rows=186 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 186
56. 0.081 0.081 ↑ 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.008..0.081 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
57. 0.080 0.080 ↑ 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.008..0.08 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
58. 0.081 0.081 ↑ 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.008..0.081 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
59. 0.080 0.080 ↑ 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.009..0.08 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
60. 0.081 0.081 ↑ 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.008..0.081 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
61. 0.078 0.078 ↑ 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.007..0.078 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
62. 0.080 0.080 ↑ 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.007..0.08 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
63. 0.080 0.080 ↑ 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.008..0.08 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
64. 0.089 0.089 ↑ 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.008..0.089 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
65. 0.081 0.081 ↑ 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.008..0.081 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
66. 0.079 0.079 ↑ 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.008..0.079 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
67. 0.078 0.078 ↑ 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.008..0.078 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
68. 0.079 0.079 ↑ 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.008..0.079 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
69. 0.203 0.203 ↑ 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.084..0.203 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
70. 0.085 0.085 ↑ 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.01..0.085 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
71. 0.100 0.100 ↑ 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.009..0.1 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
72. 0.084 0.084 ↑ 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.01..0.084 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
73. 0.084 0.084 ↑ 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.009..0.084 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
74. 0.083 0.083 ↑ 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.01..0.083 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
75. 0.080 0.080 ↑ 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.009..0.08 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
76. 0.081 0.081 ↑ 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.008..0.081 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
77. 0.082 0.082 ↑ 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.009..0.082 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
78. 0.081 0.081 ↑ 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.008..0.081 rows=189 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 189
79. 0.079 0.079 ↑ 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.007..0.079 rows=189 loops=1)

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

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

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
81. 0.081 0.081 ↑ 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.009..0.081 rows=188 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
  • Heap Fetches: 188
82. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
83. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

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

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
85. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

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

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

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
88. 0.017 0.017 ↓ 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.017..0.017 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
89. 0.356 0.356 ↓ 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.356..0.356 rows=0 loops=1)

  • Filter: (amazon_sellers.seller_marketplace_sha = amazon_seller_sha)
90. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
91. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
92. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (amazon_seller_sha = amazon_sellers.seller_marketplace_sha)
Planning time : 3.91 ms
Execution time : 12.431 ms