explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bujy

Settings
# exclusive inclusive rows x rows loops node
1. 5.915 718.749 ↑ 1.5 661 1

Nested Loop Left Join (cost=2.96..646,596.90 rows=999 width=1,071) (actual time=1.298..718.749 rows=661 loops=1)

2. 1.049 706.885 ↑ 1.5 661 1

Nested Loop Left Join (cost=2.41..638,930.55 rows=999 width=444) (actual time=1.250..706.885 rows=661 loops=1)

3. 1.277 699.887 ↑ 1.5 661 1

Nested Loop Left Join (cost=1.98..631,475.50 rows=999 width=245) (actual time=1.206..699.887 rows=661 loops=1)

4. 0.667 691.339 ↑ 1.5 661 1

Merge Left Join (cost=1.42..623,880.17 rows=999 width=180) (actual time=1.179..691.339 rows=661 loops=1)

  • Merge Cond: ((a.client_nm)::text = (e.client_nm)::text)
  • Join Filter: (((a.client_typ)::text = (e.client_typ)::text) AND ((a.marketplace)::text = (e.marketplace)::text))
5. 1.344 690.472 ↑ 1.5 661 1

Nested Loop Left Join (cost=1.14..621,320.86 rows=999 width=158) (actual time=1.142..690.472 rows=661 loops=1)

6. 0.196 576.758 ↑ 1.5 661 1

Nested Loop (cost=0.57..333,641.93 rows=999 width=109) (actual time=0.605..576.758 rows=661 loops=1)

7. 0.146 0.146 ↑ 1.0 1 1

Index Only Scan using dashboard_list_pk on dashboard_list g (cost=0.28..216.54 rows=1 width=29) (actual time=0.017..0.146 rows=1 loops=1)

  • Index Cond: ((dashboard_nm = '3M'::text) AND (dashboard_status = 'Active'::text) AND (client_typ = 'C'::text))
  • Heap Fetches: 1
8. 0.117 576.416 ↑ 4.2 661 1

Append (cost=0.29..333,397.78 rows=2,761 width=94) (actual time=0.584..576.416 rows=661 loops=1)

9. 0.011 0.011 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2016_10_indx1 on product_seller_daily_price_2016_10 a (cost=0.29..6.06 rows=1 width=81) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
10. 0.007 0.007 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2016_11_indx1 on product_seller_daily_price_2016_11 a_1 (cost=0.29..6.06 rows=1 width=81) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
11. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on product_seller_daily_price_2016_12 a_2 (cost=0.00..4.86 rows=1 width=81) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Rows Removed by Filter: 57
12. 0.005 0.005 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_1_indx1 on product_seller_daily_price_2017_1 a_3 (cost=0.29..6.07 rows=1 width=85) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
13. 0.010 0.010 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_2_indx1 on product_seller_daily_price_2017_2 a_4 (cost=0.43..8.45 rows=1 width=87) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
14. 0.009 0.009 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_3_indx1 on product_seller_daily_price_2017_3 a_5 (cost=0.43..6.20 rows=1 width=87) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
15. 0.009 0.009 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_4_indx1 on product_seller_daily_price_2017_4 a_6 (cost=0.43..8.46 rows=1 width=87) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
16. 0.009 0.009 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_5_indx1 on product_seller_daily_price_2017_5 a_7 (cost=0.43..6.21 rows=1 width=87) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
17. 0.015 0.015 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_6_idx on product_seller_daily_price_2017_6 a_8 (cost=0.43..10.65 rows=1 width=86) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
18. 0.012 0.012 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_7_idx on product_seller_daily_price_2017_7 a_9 (cost=0.43..10.65 rows=1 width=86) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
19. 0.012 0.012 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_8_idx on product_seller_daily_price_2017_8 a_10 (cost=0.44..10.65 rows=1 width=86) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
20. 0.014 0.014 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_9_idx on product_seller_daily_price_2017_9 a_11 (cost=0.44..10.65 rows=1 width=85) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
21. 0.022 0.022 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_10_idx on product_seller_daily_price_2017_10 a_12 (cost=0.44..10.66 rows=1 width=85) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
22. 0.017 0.017 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_11_idx on product_seller_daily_price_2017_11 a_13 (cost=0.44..10.66 rows=1 width=87) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
23. 0.015 0.015 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2017_12_idx on product_seller_daily_price_2017_12 a_14 (cost=0.45..10.67 rows=1 width=88) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
24. 0.016 0.016 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_1_idx on product_seller_daily_price_2018_1 a_15 (cost=0.44..10.66 rows=1 width=86) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
25. 0.017 0.017 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_2_idx on product_seller_daily_price_2018_2 a_16 (cost=0.44..10.66 rows=1 width=88) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
26. 0.015 0.015 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_3_idx on product_seller_daily_price_2018_3 a_17 (cost=0.44..10.66 rows=1 width=88) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
27. 0.016 0.016 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_4_idx on product_seller_daily_price_2018_4 a_18 (cost=0.44..10.66 rows=1 width=87) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
28. 0.015 0.015 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_5_idx on product_seller_daily_price_2018_5 a_19 (cost=0.44..10.66 rows=1 width=89) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
29. 0.020 0.020 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_6_idx on product_seller_daily_price_2018_6 a_20 (cost=0.45..10.67 rows=1 width=90) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
30. 0.017 0.017 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_7_idx on product_seller_daily_price_2018_7 a_21 (cost=0.45..10.67 rows=1 width=89) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
31. 0.015 0.015 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_8_idx on product_seller_daily_price_2018_8 a_22 (cost=0.45..10.67 rows=1 width=89) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
32. 0.017 0.017 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_9_idx on product_seller_daily_price_2018_9 a_23 (cost=0.45..10.67 rows=1 width=91) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
33. 0.018 0.018 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_10_idx on product_seller_daily_price_2018_10 a_24 (cost=0.45..10.67 rows=1 width=89) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
34. 0.015 0.015 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_11_idx on product_seller_daily_price_2018_11 a_25 (cost=0.45..10.67 rows=1 width=90) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
35. 0.019 0.019 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2018_12_idx on product_seller_daily_price_2018_12 a_26 (cost=0.57..10.92 rows=1 width=90) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
36. 0.020 0.020 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2019_1_idx on product_seller_daily_price_2019_1 a_27 (cost=0.57..10.92 rows=1 width=90) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
37. 0.016 0.016 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2019_2_idx on product_seller_daily_price_2019_2 a_28 (cost=0.57..10.92 rows=1 width=91) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
38. 0.016 0.016 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2019_3_idx on product_seller_daily_price_2019_3 a_29 (cost=0.57..10.92 rows=1 width=91) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
39. 0.018 0.018 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2019_4_idx on product_seller_daily_price_2019_4 a_30 (cost=0.57..10.92 rows=1 width=90) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
40. 0.018 0.018 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2019_5_idx on product_seller_daily_price_2019_5 a_31 (cost=0.57..10.92 rows=1 width=91) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
41. 0.015 0.015 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2019_6_idx on product_seller_daily_price_2019_6 a_32 (cost=0.57..10.92 rows=1 width=92) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
42. 0.017 0.017 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2019_7_idx on product_seller_daily_price_2019_7 a_33 (cost=0.57..10.92 rows=1 width=94) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
43. 0.015 0.015 ↓ 0.0 0 1

Index Scan using product_seller_daily_price_2019_8_idx on product_seller_daily_price_2019_8 a_34 (cost=0.57..10.92 rows=1 width=94) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text))
44. 247.839 247.839 ↑ 1.8 661 1

Index Scan using product_seller_daily_price_2019_9_idx1 on product_seller_daily_price_2019_9 a_35 (cost=0.57..268,024.58 rows=1,215 width=94) (actual time=0.042..247.839 rows=661 loops=1)

  • Index Cond: ((as_of_date >= date((now() - '3 days'::interval))) AND ((client_nm)::text = (g.client_nm)::text))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text))
45. 327.934 327.934 ↓ 0.0 0 1

Seq Scan on product_seller_daily_price_2019_10 a_36 (cost=0.00..65,019.81 rows=1,510 width=93) (actual time=327.934..327.934 rows=0 loops=1)

  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Rows Removed by Filter: 1,298,902
46. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on product_seller_daily_price_2019_11 a_37 (cost=0.00..10.82 rows=1 width=1,024) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((client_typ)::text = 'C'::text) AND ((g.client_nm)::text = (client_nm)::text) AND (as_of_date >= date((now() - '3 days'::interval))))
47. 27.762 112.370 ↓ 0.0 0 661

Append (cost=0.57..287.66 rows=31 width=88) (actual time=0.169..0.170 rows=0 loops=661)

48. 3.305 3.305 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_8_idx on fba_product_daily_run_2019_8 (cost=0.57..9.75 rows=1 width=88) (actual time=0.005..0.005 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
49. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_7_idx on fba_product_daily_run_2019_7 (cost=0.57..9.74 rows=1 width=88) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
50. 1.322 1.322 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2017_4_indx1 on fba_product_daily_run_2017_4 (cost=0.43..5.50 rows=1 width=93) (actual time=0.002..0.002 rows=0 loops=661)

  • Index Cond: ((a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
51. 1.322 1.322 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2017_5_indx1 on fba_product_daily_run_2017_5 (cost=0.43..7.47 rows=1 width=93) (actual time=0.002..0.002 rows=0 loops=661)

  • Index Cond: ((a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: ((as_of_month = ANY ('{9,10}'::integer[])) AND ((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
52. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2017_6_idx on fba_product_daily_run_2017_6 (cost=0.44..9.45 rows=1 width=94) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
53. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2017_7_idx on fba_product_daily_run_2017_7 (cost=0.44..9.45 rows=1 width=94) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
54. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2017_8_idx on fba_product_daily_run_2017_8 (cost=0.44..9.45 rows=1 width=95) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
55. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2017_9_idx on fba_product_daily_run_2017_9 (cost=0.44..11.42 rows=1 width=93) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
56. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2017_10_idx on fba_product_daily_run_2017_10 (cost=0.44..11.42 rows=1 width=93) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
57. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2017_11_idx on fba_product_daily_run_2017_11 (cost=0.44..9.45 rows=1 width=93) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
58. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2017_12_idx on fba_product_daily_run_2017_12 (cost=0.44..9.46 rows=1 width=94) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
59. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_1_idx on fba_product_daily_run_2018_1 (cost=0.44..9.46 rows=1 width=93) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
60. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_2_idx on fba_product_daily_run_2018_2 (cost=0.44..9.45 rows=1 width=92) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
61. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_3_idx on fba_product_daily_run_2018_3 (cost=0.44..9.46 rows=1 width=93) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
62. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_4_idx on fba_product_daily_run_2018_4 (cost=0.44..9.46 rows=1 width=92) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
63. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_5_idx on fba_product_daily_run_2018_5 (cost=0.44..9.46 rows=1 width=93) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
64. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_6_idx on fba_product_daily_run_2018_6 (cost=0.44..9.46 rows=1 width=94) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
65. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_7_idx on fba_product_daily_run_2018_7 (cost=0.45..9.47 rows=1 width=93) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
66. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_8_idx on fba_product_daily_run_2018_8 (cost=0.45..9.47 rows=1 width=91) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
67. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_9_idx on fba_product_daily_run_2018_9 (cost=0.45..9.47 rows=1 width=90) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
68. 3.305 3.305 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_10_idx on fba_product_daily_run_2018_10 (cost=0.45..11.45 rows=1 width=89) (actual time=0.005..0.005 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
69. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_11_idx on fba_product_daily_run_2018_11 (cost=0.45..9.47 rows=1 width=87) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
70. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2018_12_idx on fba_product_daily_run_2018_12 (cost=0.45..9.47 rows=1 width=88) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
71. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_1_idx on fba_product_daily_run_2019_1 (cost=0.57..9.72 rows=1 width=88) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
72. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_2_idx on fba_product_daily_run_2019_2 (cost=0.57..9.73 rows=1 width=88) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
73. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_3_idx on fba_product_daily_run_2019_3 (cost=0.57..9.73 rows=1 width=89) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
74. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_4_idx on fba_product_daily_run_2019_4 (cost=0.57..9.74 rows=1 width=88) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
75. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_5_idx on fba_product_daily_run_2019_5 (cost=0.57..9.74 rows=1 width=88) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
76. 2.644 2.644 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_6_idx on fba_product_daily_run_2019_6 (cost=0.57..9.74 rows=1 width=88) (actual time=0.004..0.004 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
77. 7.932 7.932 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_9_idx1 on fba_product_daily_run_2019_9 (cost=0.57..7.66 rows=1 width=88) (actual time=0.012..0.012 rows=0 loops=661)

  • Index Cond: (((a.product_asin)::text = (product_asin)::text) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))) AND ((a.seller_id)::text = (merchant_id)::text) AND ((a.marketplace)::text = (marketplace)::text))
  • Filter: (as_of_month = ANY ('{9,10}'::integer[]))
78. 1.322 1.322 ↓ 0.0 0 661

Index Scan using fba_product_daily_run_2019_10_idx on fba_product_daily_run_2019_10 (cost=0.14..3.53 rows=1 width=1,284) (actual time=0.002..0.002 rows=0 loops=661)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (a.as_of_date = as_of_date) AND (as_of_date >= date((now() - '3 days'::interval))))
  • Filter: (((a.seller_id)::text = (merchant_id)::text) AND ((a.product_asin)::text = (product_asin)::text) AND ((a.marketplace)::text = (marketplace)::text))
79. 0.200 0.200 ↑ 1.0 662 1

Index Scan using product_urls_1_idx on product_urls e (cost=0.28..2,552.58 rows=687 width=50) (actual time=0.031..0.200 rows=662 loops=1)

  • Index Cond: ((client_typ)::text = 'C'::text)
80. 7.271 7.271 ↑ 1.0 1 661

Index Scan using pki_psm_index1 on pki_product_seller_map b (cost=0.56..7.59 rows=1 width=105) (actual time=0.011..0.011 rows=1 loops=661)

  • Index Cond: (((a.product_asin)::text = (product_asin_alt)::text) AND ((a.seller_nm)::text = (seller_nm_alt)::text) AND ((a.client_nm)::text = (client_nm)::text))
81. 5.949 5.949 ↑ 1.0 1 661

Index Scan using pki_products_index1 on pki_products c (cost=0.43..7.45 rows=1 width=223) (actual time=0.009..0.009 rows=1 loops=661)

  • Index Cond: (((a.product_asin)::text = (product_asin_alt)::text) AND ((a.client_nm)::text = (client_nm)::text))
82. 5.949 5.949 ↑ 1.0 1 661

Index Scan using pki_sel_index2 on pki_sellers f (cost=0.55..7.57 rows=1 width=78) (actual time=0.009..0.009 rows=1 loops=661)

  • Index Cond: (((a.seller_id)::text = (seller_id_alt)::text) AND ((a.seller_nm)::text = (seller_nm_alt)::text) AND ((a.marketplace)::text = (marketplace)::text))
Planning time : 12.686 ms
Execution time : 720.526 ms