explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jgJ3

Settings
# exclusive inclusive rows x rows loops node
1. 4.403 689.661 ↑ 1.5 661 1

Nested Loop Left Join (cost=2.96..370,949.08 rows=999 width=1,071) (actual time=4.150..689.661 rows=661 loops=1)

2. 1.064 679.309 ↑ 1.5 661 1

Nested Loop Left Join (cost=2.41..363,289.69 rows=999 width=463) (actual time=4.092..679.309 rows=661 loops=1)

3. 1.117 672.957 ↑ 1.5 661 1

Nested Loop Left Join (cost=1.98..355,841.14 rows=999 width=264) (actual time=4.059..672.957 rows=661 loops=1)

4. 0.402 665.230 ↑ 1.5 661 1

Merge Left Join (cost=1.42..348,252.37 rows=999 width=199) (actual time=4.016..665.230 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. 0.026 664.638 ↑ 1.5 661 1

Nested Loop Left Join (cost=1.14..345,693.06 rows=999 width=177) (actual time=3.960..664.638 rows=661 loops=1)

  • Join Filter: ((a.as_of_date = fba_product_daily_run_2019_8.as_of_date) AND ((a.seller_id)::text = (fba_product_daily_run_2019_8.merchant_id)::text) AND ((a.product_asin)::text = (fba_product_daily_run_2019_8.product_asin)::text) AND ((a.marketplace)::text = (fba_product_daily_run_2019_8.marketplace)::text))
6. 0.121 661.307 ↑ 1.5 661 1

Nested Loop (cost=0.57..344,665.73 rows=999 width=109) (actual time=0.841..661.307 rows=661 loops=1)

7. 0.158 0.158 ↑ 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.025..0.158 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.112 661.028 ↑ 4.2 661 1

Append (cost=0.29..344,421.58 rows=2,761 width=94) (actual time=0.811..661.028 rows=661 loops=1)

9. 0.015 0.015 ↓ 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.015..0.015 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.010 0.010 ↓ 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.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))
11. 0.028 0.028 ↓ 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.028..0.028 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.008 0.008 ↓ 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.008..0.008 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.013 0.013 ↓ 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.013..0.013 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.011 0.011 ↓ 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.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))
15. 0.012 0.012 ↓ 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.011..0.012 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.016 0.016 ↓ 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.016..0.016 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.021 0.021 ↓ 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.021..0.021 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.017 0.017 ↓ 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.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))
19. 0.019 0.019 ↓ 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.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))
20. 0.018 0.018 ↓ 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.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))
21. 0.028 0.028 ↓ 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.028..0.028 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.023 0.023 ↓ 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.023..0.023 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.021 0.021 ↓ 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.021..0.021 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.023 0.023 ↓ 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.023..0.023 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.022 0.022 ↓ 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.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))
26. 0.029 0.029 ↓ 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.028..0.029 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.021 0.021 ↓ 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.021..0.021 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.020 0.020 ↓ 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.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))
29. 0.025 0.025 ↓ 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.025..0.025 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.022 0.022 ↓ 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.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))
31. 0.021 0.021 ↓ 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.021..0.021 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.023 0.023 ↓ 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.023..0.023 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.030 0.030 ↓ 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.030..0.030 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.024 0.024 ↓ 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.024..0.024 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.028 0.028 ↓ 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.028..0.028 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.022 0.022 ↓ 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.021..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))
38. 0.022 0.022 ↓ 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.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))
39. 0.027 0.027 ↓ 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.027..0.027 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.027 0.027 ↓ 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.027..0.027 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.022 0.022 ↓ 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.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))
42. 0.024 0.024 ↓ 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.024..0.024 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.023 0.023 ↓ 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.023..0.023 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. 305.744 305.744 ↑ 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..279,048.38 rows=1,215 width=94) (actual time=0.034..305.744 rows=661 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))) AND ((client_nm)::text = (g.client_nm)::text))
  • Filter: ((client_typ)::text = 'C'::text)
45. 354.432 354.432 ↓ 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=354.432..354.432 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. 0.189 3.305 ↓ 0.0 0 661

Materialize (cost=0.57..330.61 rows=31 width=129) (actual time=0.005..0.005 rows=0 loops=661)

48. 0.006 3.116 ↓ 0.0 0 1

Append (cost=0.57..330.45 rows=31 width=129) (actual time=3.116..3.116 rows=0 loops=1)

49. 0.028 0.028 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
50. 0.023 0.023 ↓ 0.0 0 1

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

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

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

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: (as_of_month = ANY ('{9,10}'::integer[]))
52. 0.024 0.024 ↓ 0.0 0 1

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

  • Index Cond: (as_of_date >= date((now() - '3 days'::interval)))
  • Filter: (as_of_month = ANY ('{9,10}'::integer[]))
53. 0.024 0.024 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
54. 0.021 0.021 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
55. 0.023 0.023 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
56. 0.025 0.025 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
57. 0.028 0.028 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
58. 0.023 0.023 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
59. 0.036 0.036 ↓ 0.0 0 1

Index Scan using fba_product_daily_run_2017_12_idx on fba_product_daily_run_2017_12 (cost=0.44..10.66 rows=1 width=94) (actual time=0.035..0.036 rows=0 loops=1)

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

Index Scan using fba_product_daily_run_2018_1_idx on fba_product_daily_run_2018_1 (cost=0.44..10.66 rows=1 width=93) (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))))
61. 0.021 0.021 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
62. 0.025 0.025 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
63. 0.023 0.023 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
64. 0.021 0.021 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
65. 0.021 0.021 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
66. 0.029 0.029 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
67. 0.023 0.023 ↓ 0.0 0 1

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

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

Index Scan using fba_product_daily_run_2018_9_idx on fba_product_daily_run_2018_9 (cost=0.45..10.66 rows=1 width=90) (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))))
69. 0.029 0.029 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
70. 0.024 0.024 ↓ 0.0 0 1

Index Scan using fba_product_daily_run_2018_11_idx on fba_product_daily_run_2018_11 (cost=0.45..10.66 rows=1 width=87) (actual time=0.023..0.024 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
71. 0.024 0.024 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
72. 0.048 0.048 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
73. 0.024 0.024 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
74. 0.028 0.028 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
75. 0.024 0.024 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
76. 0.028 0.028 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
77. 0.024 0.024 ↓ 0.0 0 1

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

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
78. 2.351 2.351 ↓ 0.0 0 1

Index Scan using fba_product_daily_run_2019_9_idx on fba_product_daily_run_2019_9 (cost=0.57..10.92 rows=1 width=87) (actual time=2.351..2.351 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
79. 0.028 0.028 ↓ 0.0 0 1

Index Scan using fba_product_daily_run_2019_10_idx on fba_product_daily_run_2019_10 (cost=0.14..8.31 rows=1 width=1,284) (actual time=0.027..0.028 rows=0 loops=1)

  • Index Cond: ((as_of_month = ANY ('{9,10}'::integer[])) AND (as_of_date >= date((now() - '3 days'::interval))))
80. 0.190 0.190 ↑ 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.050..0.190 rows=662 loops=1)

  • Index Cond: ((client_typ)::text = 'C'::text)
81. 6.610 6.610 ↑ 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.010..0.010 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))
82. 5.288 5.288 ↑ 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.008..0.008 rows=1 loops=661)

  • Index Cond: (((a.product_asin)::text = (product_asin_alt)::text) AND ((a.client_nm)::text = (client_nm)::text))
83. 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.008..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.506 ms
Execution time : 691.462 ms