explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W6Fh

Settings
# exclusive inclusive rows x rows loops node
1. 8,624.950 15,443.591 ↓ 12.2 487,250 1

HashAggregate (cost=909,317.80..911,117.80 rows=40,000 width=226) (actual time=14,738.366..15,443.591 rows=487,250 loops=1)

  • Output: (d_daily_brand_performance_choi_week_mod.asin)::character varying(10), CASE WHEN (sum(d_daily_brand_performance_choi_week_mod.page_views) = '0'::numeric) THEN '0'::numeric ELSE round(('100'::numeric * (sum(d_daily_brand_performance_choi_week_mod.buy_box_page_views) / sum(d_daily_brand_performance_choi_week_mod.page_views))), 2) END, COALESCE((d_daily_brand_performance_choi_week_mod.gcid)::character varying(16), ' '::character varying), avg(NULLIF(d_daily_brand_performance_choi_week_mod.ratings_avg, '0'::numeric)), sum(d_daily_brand_performance_choi_week_mod.ratings_cnt), NULLIF(max(d_daily_brand_performance_choi_week_mod.sales_rank), '0'::numeric), d_daily_brand_performance_choi_week_mod.asin, d_daily_brand_performance_choi_week_mod.gcid
  • Group Key: d_daily_brand_performance_choi_week_mod.asin, d_daily_brand_performance_choi_week_mod.gcid
  • Buffers: shared hit=6900928
2. 714.414 6,818.641 ↑ 1.0 6,773,885 1

Result (cost=0.00..754,634.71 rows=6,874,804 width=46) (actual time=0.059..6,818.641 rows=6,773,885 loops=1)

  • Output: d_daily_brand_performance_choi_week_mod.asin, d_daily_brand_performance_choi_week_mod.gcid, d_daily_brand_performance_choi_week_mod.page_views, d_daily_brand_performance_choi_week_mod.buy_box_page_views, d_daily_brand_performance_choi_week_mod.ratings_avg, d_daily_brand_performance_choi_week_mod.ratings_cnt, d_daily_brand_performance_choi_week_mod.sales_rank
  • Buffers: shared hit=6900928
3. 510.095 6,104.227 ↑ 1.0 6,773,885 1

Append (cost=0.00..685,886.67 rows=6,874,804 width=46) (actual time=0.059..6,104.227 rows=6,773,885 loops=1)

  • Buffers: shared hit=6900928
4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on booker.d_daily_brand_performance_choi_week_mod (cost=0.00..0.00 rows=1 width=262) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: d_daily_brand_performance_choi_week_mod.asin, d_daily_brand_performance_choi_week_mod.page_views, d_daily_brand_performance_choi_week_mod.buy_box_page_views, d_daily_brand_performance_choi_week_mod.gcid, d_daily_brand_performance_choi_week_mod.ratings_avg, d_daily_brand_performance_choi_week_mod.ratings_cnt, d_daily_brand_performance_choi_week_mod.sales_rank
  • Filter: ((d_daily_brand_performance_choi_week_mod.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (d_daily_brand_performance_choi_week_mod.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone) AND (d_daily_brand_performance_choi_week_mod.marketplace_id = 1) AND (d_daily_brand_performance_choi_week_mod.brand_owner_id = 142499351))
5. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_0_unique on booker.ddbp_201902_choi_1_0 (cost=0.56..1,043.04 rows=2,179 width=46) (actual time=0.017..0.017 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_0.asin, ddbp_201902_choi_1_0.page_views, ddbp_201902_choi_1_0.buy_box_page_views, ddbp_201902_choi_1_0.gcid, ddbp_201902_choi_1_0.ratings_avg, ddbp_201902_choi_1_0.ratings_cnt, ddbp_201902_choi_1_0.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_0.marketplace_id = 1) AND (ddbp_201902_choi_1_0.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_0.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_0.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=7
6. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_1_unique on booker.ddbp_201902_choi_1_1 (cost=0.56..825.61 rows=1,727 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_1.asin, ddbp_201902_choi_1_1.page_views, ddbp_201902_choi_1_1.buy_box_page_views, ddbp_201902_choi_1_1.gcid, ddbp_201902_choi_1_1.ratings_avg, ddbp_201902_choi_1_1.ratings_cnt, ddbp_201902_choi_1_1.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_1.marketplace_id = 1) AND (ddbp_201902_choi_1_1.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_1.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_1.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
7. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_2_unique on booker.ddbp_201902_choi_1_2 (cost=0.56..906.98 rows=1,894 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_2.asin, ddbp_201902_choi_1_2.page_views, ddbp_201902_choi_1_2.buy_box_page_views, ddbp_201902_choi_1_2.gcid, ddbp_201902_choi_1_2.ratings_avg, ddbp_201902_choi_1_2.ratings_cnt, ddbp_201902_choi_1_2.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_2.marketplace_id = 1) AND (ddbp_201902_choi_1_2.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_2.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_2.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
8. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_3_unique on booker.ddbp_201902_choi_1_3 (cost=0.56..944.66 rows=1,974 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_3.asin, ddbp_201902_choi_1_3.page_views, ddbp_201902_choi_1_3.buy_box_page_views, ddbp_201902_choi_1_3.gcid, ddbp_201902_choi_1_3.ratings_avg, ddbp_201902_choi_1_3.ratings_cnt, ddbp_201902_choi_1_3.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_3.marketplace_id = 1) AND (ddbp_201902_choi_1_3.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_3.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_3.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
9. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_4_unique on booker.ddbp_201902_choi_1_4 (cost=0.56..998.95 rows=2,088 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_4.asin, ddbp_201902_choi_1_4.page_views, ddbp_201902_choi_1_4.buy_box_page_views, ddbp_201902_choi_1_4.gcid, ddbp_201902_choi_1_4.ratings_avg, ddbp_201902_choi_1_4.ratings_cnt, ddbp_201902_choi_1_4.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_4.marketplace_id = 1) AND (ddbp_201902_choi_1_4.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_4.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_4.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
10. 1,407.478 1,407.478 ↑ 1.0 1,696,987 1

Index Scan using ddbp_201902_choi_1_5_unique on booker.ddbp_201902_choi_1_5 (cost=0.56..162,977.81 rows=1,723,680 width=46) (actual time=0.011..1,407.478 rows=1,696,987 loops=1)

  • Output: ddbp_201902_choi_1_5.asin, ddbp_201902_choi_1_5.page_views, ddbp_201902_choi_1_5.buy_box_page_views, ddbp_201902_choi_1_5.gcid, ddbp_201902_choi_1_5.ratings_avg, ddbp_201902_choi_1_5.ratings_cnt, ddbp_201902_choi_1_5.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_5.marketplace_id = 1) AND (ddbp_201902_choi_1_5.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_5.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_5.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1726639
11. 0.020 0.020 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_6_unique on booker.ddbp_201902_choi_1_6 (cost=0.56..938.96 rows=1,961 width=46) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_6.asin, ddbp_201902_choi_1_6.page_views, ddbp_201902_choi_1_6.buy_box_page_views, ddbp_201902_choi_1_6.gcid, ddbp_201902_choi_1_6.ratings_avg, ddbp_201902_choi_1_6.ratings_cnt, ddbp_201902_choi_1_6.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_6.marketplace_id = 1) AND (ddbp_201902_choi_1_6.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_6.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_6.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
12. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_7_unique on booker.ddbp_201902_choi_1_7 (cost=0.56..863.35 rows=1,804 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_7.asin, ddbp_201902_choi_1_7.page_views, ddbp_201902_choi_1_7.buy_box_page_views, ddbp_201902_choi_1_7.gcid, ddbp_201902_choi_1_7.ratings_avg, ddbp_201902_choi_1_7.ratings_cnt, ddbp_201902_choi_1_7.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_7.marketplace_id = 1) AND (ddbp_201902_choi_1_7.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_7.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_7.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
13. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_8_unique on booker.ddbp_201902_choi_1_8 (cost=0.56..929.74 rows=1,942 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_8.asin, ddbp_201902_choi_1_8.page_views, ddbp_201902_choi_1_8.buy_box_page_views, ddbp_201902_choi_1_8.gcid, ddbp_201902_choi_1_8.ratings_avg, ddbp_201902_choi_1_8.ratings_cnt, ddbp_201902_choi_1_8.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_8.marketplace_id = 1) AND (ddbp_201902_choi_1_8.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_8.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_8.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
14. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_9_unique on booker.ddbp_201902_choi_1_9 (cost=0.56..854.05 rows=1,782 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_9.asin, ddbp_201902_choi_1_9.page_views, ddbp_201902_choi_1_9.buy_box_page_views, ddbp_201902_choi_1_9.gcid, ddbp_201902_choi_1_9.ratings_avg, ddbp_201902_choi_1_9.ratings_cnt, ddbp_201902_choi_1_9.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_9.marketplace_id = 1) AND (ddbp_201902_choi_1_9.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_9.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_9.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
15. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_1_10_unique on booker.ddbp_201902_choi_1_10 (cost=0.56..971.46 rows=2,031 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_1_10.asin, ddbp_201902_choi_1_10.page_views, ddbp_201902_choi_1_10.buy_box_page_views, ddbp_201902_choi_1_10.gcid, ddbp_201902_choi_1_10.ratings_avg, ddbp_201902_choi_1_10.ratings_cnt, ddbp_201902_choi_1_10.sales_rank
  • Index Cond: ((ddbp_201902_choi_1_10.marketplace_id = 1) AND (ddbp_201902_choi_1_10.brand_owner_id = 142499351) AND (ddbp_201902_choi_1_10.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_1_10.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
16. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_0_unique on booker.ddbp_201902_choi_2_0 (cost=0.56..1,067.50 rows=2,235 width=46) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_0.asin, ddbp_201902_choi_2_0.page_views, ddbp_201902_choi_2_0.buy_box_page_views, ddbp_201902_choi_2_0.gcid, ddbp_201902_choi_2_0.ratings_avg, ddbp_201902_choi_2_0.ratings_cnt, ddbp_201902_choi_2_0.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_0.marketplace_id = 1) AND (ddbp_201902_choi_2_0.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_0.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_0.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
17. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_1_unique on booker.ddbp_201902_choi_2_1 (cost=0.56..828.85 rows=1,734 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_1.asin, ddbp_201902_choi_2_1.page_views, ddbp_201902_choi_2_1.buy_box_page_views, ddbp_201902_choi_2_1.gcid, ddbp_201902_choi_2_1.ratings_avg, ddbp_201902_choi_2_1.ratings_cnt, ddbp_201902_choi_2_1.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_1.marketplace_id = 1) AND (ddbp_201902_choi_2_1.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_1.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_1.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
18. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_2_unique on booker.ddbp_201902_choi_2_2 (cost=0.56..903.74 rows=1,887 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_2.asin, ddbp_201902_choi_2_2.page_views, ddbp_201902_choi_2_2.buy_box_page_views, ddbp_201902_choi_2_2.gcid, ddbp_201902_choi_2_2.ratings_avg, ddbp_201902_choi_2_2.ratings_cnt, ddbp_201902_choi_2_2.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_2.marketplace_id = 1) AND (ddbp_201902_choi_2_2.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_2.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_2.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
19. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_3_unique on booker.ddbp_201902_choi_2_3 (cost=0.56..973.72 rows=2,039 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_3.asin, ddbp_201902_choi_2_3.page_views, ddbp_201902_choi_2_3.buy_box_page_views, ddbp_201902_choi_2_3.gcid, ddbp_201902_choi_2_3.ratings_avg, ddbp_201902_choi_2_3.ratings_cnt, ddbp_201902_choi_2_3.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_3.marketplace_id = 1) AND (ddbp_201902_choi_2_3.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_3.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_3.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
20. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_4_unique on booker.ddbp_201902_choi_2_4 (cost=0.56..1,017.76 rows=2,133 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_4.asin, ddbp_201902_choi_2_4.page_views, ddbp_201902_choi_2_4.buy_box_page_views, ddbp_201902_choi_2_4.gcid, ddbp_201902_choi_2_4.ratings_avg, ddbp_201902_choi_2_4.ratings_cnt, ddbp_201902_choi_2_4.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_4.marketplace_id = 1) AND (ddbp_201902_choi_2_4.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_4.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_4.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
21. 1,466.597 1,466.597 ↓ 1.0 1,693,725 1

Index Scan using ddbp_201902_choi_2_5_unique on booker.ddbp_201902_choi_2_5 (cost=0.56..161,349.26 rows=1,653,388 width=46) (actual time=0.013..1,466.597 rows=1,693,725 loops=1)

  • Output: ddbp_201902_choi_2_5.asin, ddbp_201902_choi_2_5.page_views, ddbp_201902_choi_2_5.buy_box_page_views, ddbp_201902_choi_2_5.gcid, ddbp_201902_choi_2_5.ratings_avg, ddbp_201902_choi_2_5.ratings_cnt, ddbp_201902_choi_2_5.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_5.marketplace_id = 1) AND (ddbp_201902_choi_2_5.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_5.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_5.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1729501
22. 0.018 0.018 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_6_unique on booker.ddbp_201902_choi_2_6 (cost=0.56..938.35 rows=1,964 width=46) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_6.asin, ddbp_201902_choi_2_6.page_views, ddbp_201902_choi_2_6.buy_box_page_views, ddbp_201902_choi_2_6.gcid, ddbp_201902_choi_2_6.ratings_avg, ddbp_201902_choi_2_6.ratings_cnt, ddbp_201902_choi_2_6.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_6.marketplace_id = 1) AND (ddbp_201902_choi_2_6.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_6.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_6.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
23. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_7_unique on booker.ddbp_201902_choi_2_7 (cost=0.56..861.35 rows=1,804 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_7.asin, ddbp_201902_choi_2_7.page_views, ddbp_201902_choi_2_7.buy_box_page_views, ddbp_201902_choi_2_7.gcid, ddbp_201902_choi_2_7.ratings_avg, ddbp_201902_choi_2_7.ratings_cnt, ddbp_201902_choi_2_7.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_7.marketplace_id = 1) AND (ddbp_201902_choi_2_7.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_7.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_7.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
24. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_8_unique on booker.ddbp_201902_choi_2_8 (cost=0.56..973.85 rows=2,034 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_8.asin, ddbp_201902_choi_2_8.page_views, ddbp_201902_choi_2_8.buy_box_page_views, ddbp_201902_choi_2_8.gcid, ddbp_201902_choi_2_8.ratings_avg, ddbp_201902_choi_2_8.ratings_cnt, ddbp_201902_choi_2_8.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_8.marketplace_id = 1) AND (ddbp_201902_choi_2_8.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_8.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_8.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
25. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_9_unique on booker.ddbp_201902_choi_2_9 (cost=0.56..873.35 rows=1,829 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_9.asin, ddbp_201902_choi_2_9.page_views, ddbp_201902_choi_2_9.buy_box_page_views, ddbp_201902_choi_2_9.gcid, ddbp_201902_choi_2_9.ratings_avg, ddbp_201902_choi_2_9.ratings_cnt, ddbp_201902_choi_2_9.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_9.marketplace_id = 1) AND (ddbp_201902_choi_2_9.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_9.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_9.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
26. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_2_10_unique on booker.ddbp_201902_choi_2_10 (cost=0.56..986.75 rows=2,065 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_2_10.asin, ddbp_201902_choi_2_10.page_views, ddbp_201902_choi_2_10.buy_box_page_views, ddbp_201902_choi_2_10.gcid, ddbp_201902_choi_2_10.ratings_avg, ddbp_201902_choi_2_10.ratings_cnt, ddbp_201902_choi_2_10.sales_rank
  • Index Cond: ((ddbp_201902_choi_2_10.marketplace_id = 1) AND (ddbp_201902_choi_2_10.brand_owner_id = 142499351) AND (ddbp_201902_choi_2_10.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_2_10.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
27. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_0_unique on booker.ddbp_201902_choi_3_0 (cost=0.56..1,089.24 rows=2,282 width=46) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_0.asin, ddbp_201902_choi_3_0.page_views, ddbp_201902_choi_3_0.buy_box_page_views, ddbp_201902_choi_3_0.gcid, ddbp_201902_choi_3_0.ratings_avg, ddbp_201902_choi_3_0.ratings_cnt, ddbp_201902_choi_3_0.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_0.marketplace_id = 1) AND (ddbp_201902_choi_3_0.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_0.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_0.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
28. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_1_unique on booker.ddbp_201902_choi_3_1 (cost=0.56..864.10 rows=1,809 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_1.asin, ddbp_201902_choi_3_1.page_views, ddbp_201902_choi_3_1.buy_box_page_views, ddbp_201902_choi_3_1.gcid, ddbp_201902_choi_3_1.ratings_avg, ddbp_201902_choi_3_1.ratings_cnt, ddbp_201902_choi_3_1.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_1.marketplace_id = 1) AND (ddbp_201902_choi_3_1.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_1.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_1.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
29. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_2_unique on booker.ddbp_201902_choi_3_2 (cost=0.56..923.48 rows=1,934 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_2.asin, ddbp_201902_choi_3_2.page_views, ddbp_201902_choi_3_2.buy_box_page_views, ddbp_201902_choi_3_2.gcid, ddbp_201902_choi_3_2.ratings_avg, ddbp_201902_choi_3_2.ratings_cnt, ddbp_201902_choi_3_2.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_2.marketplace_id = 1) AND (ddbp_201902_choi_3_2.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_2.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_2.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
30. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_3_unique on booker.ddbp_201902_choi_3_3 (cost=0.56..1,003.84 rows=2,106 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_3.asin, ddbp_201902_choi_3_3.page_views, ddbp_201902_choi_3_3.buy_box_page_views, ddbp_201902_choi_3_3.gcid, ddbp_201902_choi_3_3.ratings_avg, ddbp_201902_choi_3_3.ratings_cnt, ddbp_201902_choi_3_3.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_3.marketplace_id = 1) AND (ddbp_201902_choi_3_3.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_3.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_3.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
31. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_4_unique on booker.ddbp_201902_choi_3_4 (cost=0.56..1,045.61 rows=2,192 width=46) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_4.asin, ddbp_201902_choi_3_4.page_views, ddbp_201902_choi_3_4.buy_box_page_views, ddbp_201902_choi_3_4.gcid, ddbp_201902_choi_3_4.ratings_avg, ddbp_201902_choi_3_4.ratings_cnt, ddbp_201902_choi_3_4.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_4.marketplace_id = 1) AND (ddbp_201902_choi_3_4.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_4.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_4.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
32. 1,495.058 1,495.058 ↓ 1.0 1,690,206 1

Index Scan using ddbp_201902_choi_3_5_unique on booker.ddbp_201902_choi_3_5 (cost=0.56..159,831.95 rows=1,683,968 width=46) (actual time=0.013..1,495.058 rows=1,690,206 loops=1)

  • Output: ddbp_201902_choi_3_5.asin, ddbp_201902_choi_3_5.page_views, ddbp_201902_choi_3_5.buy_box_page_views, ddbp_201902_choi_3_5.gcid, ddbp_201902_choi_3_5.ratings_avg, ddbp_201902_choi_3_5.ratings_cnt, ddbp_201902_choi_3_5.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_5.marketplace_id = 1) AND (ddbp_201902_choi_3_5.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_5.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_5.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1720357
33. 0.019 0.019 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_6_unique on booker.ddbp_201902_choi_3_6 (cost=0.56..987.14 rows=2,068 width=46) (actual time=0.019..0.019 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_6.asin, ddbp_201902_choi_3_6.page_views, ddbp_201902_choi_3_6.buy_box_page_views, ddbp_201902_choi_3_6.gcid, ddbp_201902_choi_3_6.ratings_avg, ddbp_201902_choi_3_6.ratings_cnt, ddbp_201902_choi_3_6.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_6.marketplace_id = 1) AND (ddbp_201902_choi_3_6.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_6.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_6.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
34. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_7_unique on booker.ddbp_201902_choi_3_7 (cost=0.56..868.75 rows=1,820 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_7.asin, ddbp_201902_choi_3_7.page_views, ddbp_201902_choi_3_7.buy_box_page_views, ddbp_201902_choi_3_7.gcid, ddbp_201902_choi_3_7.ratings_avg, ddbp_201902_choi_3_7.ratings_cnt, ddbp_201902_choi_3_7.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_7.marketplace_id = 1) AND (ddbp_201902_choi_3_7.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_7.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_7.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
35. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_8_unique on booker.ddbp_201902_choi_3_8 (cost=0.56..1,004.74 rows=2,107 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_8.asin, ddbp_201902_choi_3_8.page_views, ddbp_201902_choi_3_8.buy_box_page_views, ddbp_201902_choi_3_8.gcid, ddbp_201902_choi_3_8.ratings_avg, ddbp_201902_choi_3_8.ratings_cnt, ddbp_201902_choi_3_8.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_8.marketplace_id = 1) AND (ddbp_201902_choi_3_8.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_8.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_8.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
36. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_9_unique on booker.ddbp_201902_choi_3_9 (cost=0.56..906.29 rows=1,899 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_9.asin, ddbp_201902_choi_3_9.page_views, ddbp_201902_choi_3_9.buy_box_page_views, ddbp_201902_choi_3_9.gcid, ddbp_201902_choi_3_9.ratings_avg, ddbp_201902_choi_3_9.ratings_cnt, ddbp_201902_choi_3_9.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_9.marketplace_id = 1) AND (ddbp_201902_choi_3_9.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_9.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_9.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
37. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_3_10_unique on booker.ddbp_201902_choi_3_10 (cost=0.56..1,020.98 rows=2,139 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_3_10.asin, ddbp_201902_choi_3_10.page_views, ddbp_201902_choi_3_10.buy_box_page_views, ddbp_201902_choi_3_10.gcid, ddbp_201902_choi_3_10.ratings_avg, ddbp_201902_choi_3_10.ratings_cnt, ddbp_201902_choi_3_10.sales_rank
  • Index Cond: ((ddbp_201902_choi_3_10.marketplace_id = 1) AND (ddbp_201902_choi_3_10.brand_owner_id = 142499351) AND (ddbp_201902_choi_3_10.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_3_10.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
38. 0.006 0.006 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_0_unique on booker.ddbp_201902_choi_4_0 (cost=0.56..1,086.08 rows=2,273 width=46) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_0.asin, ddbp_201902_choi_4_0.page_views, ddbp_201902_choi_4_0.buy_box_page_views, ddbp_201902_choi_4_0.gcid, ddbp_201902_choi_4_0.ratings_avg, ddbp_201902_choi_4_0.ratings_cnt, ddbp_201902_choi_4_0.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_0.marketplace_id = 1) AND (ddbp_201902_choi_4_0.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_0.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_0.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
39. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_1_unique on booker.ddbp_201902_choi_4_1 (cost=0.56..873.88 rows=1,828 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_1.asin, ddbp_201902_choi_4_1.page_views, ddbp_201902_choi_4_1.buy_box_page_views, ddbp_201902_choi_4_1.gcid, ddbp_201902_choi_4_1.ratings_avg, ddbp_201902_choi_4_1.ratings_cnt, ddbp_201902_choi_4_1.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_1.marketplace_id = 1) AND (ddbp_201902_choi_4_1.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_1.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_1.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
40. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_2_unique on booker.ddbp_201902_choi_4_2 (cost=0.56..957.41 rows=2,004 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_2.asin, ddbp_201902_choi_4_2.page_views, ddbp_201902_choi_4_2.buy_box_page_views, ddbp_201902_choi_4_2.gcid, ddbp_201902_choi_4_2.ratings_avg, ddbp_201902_choi_4_2.ratings_cnt, ddbp_201902_choi_4_2.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_2.marketplace_id = 1) AND (ddbp_201902_choi_4_2.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_2.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_2.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
41. 0.006 0.006 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_3_unique on booker.ddbp_201902_choi_4_3 (cost=0.56..1,016.40 rows=2,131 width=46) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_3.asin, ddbp_201902_choi_4_3.page_views, ddbp_201902_choi_4_3.buy_box_page_views, ddbp_201902_choi_4_3.gcid, ddbp_201902_choi_4_3.ratings_avg, ddbp_201902_choi_4_3.ratings_cnt, ddbp_201902_choi_4_3.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_3.marketplace_id = 1) AND (ddbp_201902_choi_4_3.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_3.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_3.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
42. 0.006 0.006 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_4_unique on booker.ddbp_201902_choi_4_4 (cost=0.56..1,049.39 rows=2,198 width=46) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_4.asin, ddbp_201902_choi_4_4.page_views, ddbp_201902_choi_4_4.buy_box_page_views, ddbp_201902_choi_4_4.gcid, ddbp_201902_choi_4_4.ratings_avg, ddbp_201902_choi_4_4.ratings_cnt, ddbp_201902_choi_4_4.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_4.marketplace_id = 1) AND (ddbp_201902_choi_4_4.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_4.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_4.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
43. 1,224.627 1,224.627 ↑ 1.0 1,692,967 1

Index Scan using ddbp_201902_choi_4_5_unique on booker.ddbp_201902_choi_4_5 (cost=0.56..163,429.21 rows=1,733,611 width=46) (actual time=0.011..1,224.627 rows=1,692,967 loops=1)

  • Output: ddbp_201902_choi_4_5.asin, ddbp_201902_choi_4_5.page_views, ddbp_201902_choi_4_5.buy_box_page_views, ddbp_201902_choi_4_5.gcid, ddbp_201902_choi_4_5.ratings_avg, ddbp_201902_choi_4_5.ratings_cnt, ddbp_201902_choi_4_5.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_5.marketplace_id = 1) AND (ddbp_201902_choi_4_5.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_5.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_5.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1724268
44. 0.018 0.018 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_6_unique on booker.ddbp_201902_choi_4_6 (cost=0.56..993.22 rows=2,079 width=46) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_6.asin, ddbp_201902_choi_4_6.page_views, ddbp_201902_choi_4_6.buy_box_page_views, ddbp_201902_choi_4_6.gcid, ddbp_201902_choi_4_6.ratings_avg, ddbp_201902_choi_4_6.ratings_cnt, ddbp_201902_choi_4_6.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_6.marketplace_id = 1) AND (ddbp_201902_choi_4_6.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_6.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_6.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
45. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_7_unique on booker.ddbp_201902_choi_4_7 (cost=0.56..897.60 rows=1,879 width=46) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_7.asin, ddbp_201902_choi_4_7.page_views, ddbp_201902_choi_4_7.buy_box_page_views, ddbp_201902_choi_4_7.gcid, ddbp_201902_choi_4_7.ratings_avg, ddbp_201902_choi_4_7.ratings_cnt, ddbp_201902_choi_4_7.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_7.marketplace_id = 1) AND (ddbp_201902_choi_4_7.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_7.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_7.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
46. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_8_unique on booker.ddbp_201902_choi_4_8 (cost=0.56..1,012.21 rows=2,121 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_8.asin, ddbp_201902_choi_4_8.page_views, ddbp_201902_choi_4_8.buy_box_page_views, ddbp_201902_choi_4_8.gcid, ddbp_201902_choi_4_8.ratings_avg, ddbp_201902_choi_4_8.ratings_cnt, ddbp_201902_choi_4_8.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_8.marketplace_id = 1) AND (ddbp_201902_choi_4_8.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_8.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_8.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
47. 0.023 0.023 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_9_unique on booker.ddbp_201902_choi_4_9 (cost=0.56..942.54 rows=1,974 width=46) (actual time=0.023..0.023 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_9.asin, ddbp_201902_choi_4_9.page_views, ddbp_201902_choi_4_9.buy_box_page_views, ddbp_201902_choi_4_9.gcid, ddbp_201902_choi_4_9.ratings_avg, ddbp_201902_choi_4_9.ratings_cnt, ddbp_201902_choi_4_9.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_9.marketplace_id = 1) AND (ddbp_201902_choi_4_9.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_9.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_9.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
48. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ddbp_201902_choi_4_10_unique on booker.ddbp_201902_choi_4_10 (cost=0.56..1,053.55 rows=2,207 width=46) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: ddbp_201902_choi_4_10.asin, ddbp_201902_choi_4_10.page_views, ddbp_201902_choi_4_10.buy_box_page_views, ddbp_201902_choi_4_10.gcid, ddbp_201902_choi_4_10.ratings_avg, ddbp_201902_choi_4_10.ratings_cnt, ddbp_201902_choi_4_10.sales_rank
  • Index Cond: ((ddbp_201902_choi_4_10.marketplace_id = 1) AND (ddbp_201902_choi_4_10.brand_owner_id = 142499351) AND (ddbp_201902_choi_4_10.metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (ddbp_201902_choi_4_10.metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=4
Planning time : 9.973 ms