explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gYap

Settings
# exclusive inclusive rows x rows loops node
1. 0.138 11,936.529 ↑ 32.0 1 1

Hash Left Join (cost=1,278,328.80..6,530,052.23 rows=32 width=161) (actual time=11,936.502..11,936.529 rows=1 loops=1)

  • Hash Cond: ((agg.store_src_cd)::text = (d_store_2018_12_27_07_01_39_1.store_src_cd)::text)
2. 0.025 11,936.391 ↑ 16.0 1 1

Nested Loop (cost=1,278,311.85..6,530,034.24 rows=16 width=239) (actual time=11,936.365..11,936.391 rows=1 loops=1)

  • Join Filter: CASE WHEN (COALESCE(agg_1.depl_r365_eqv_qty_ty, 0::numeric) <= 0::numeric) THEN (((d_store_2018_12_27_07_01_39_2.store_stts_cd)::text <> ALL ('{D,C}'::text[])) AND ((d_store_2018_12_27_07_01_39.beer_flg)::text = 'Y'::text)) ELSE true END
3. 584.010 11,936.366 ↑ 16.0 1 1

Hash Left Join (cost=1,278,311.42..6,530,025.13 rows=16 width=269) (actual time=11,936.342..11,936.366 rows=1 loops=1)

  • Hash Cond: ((d_store_2018_12_27_07_01_39.store_src_cd)::text = (agg_1.store_src_cd)::text)
4. 0.006 11,352.356 ↑ 8.0 1 1

Nested Loop Left Join (cost=1,105,900.73..6,357,614.24 rows=8 width=241) (actual time=11,352.333..11,352.356 rows=1 loops=1)

  • Join Filter: ((d_store_2018_12_27_07_01_39.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
5. 0.005 576.709 ↑ 8.0 1 1

Nested Loop Left Join (cost=172,377.39..172,663.57 rows=8 width=201) (actual time=576.689..576.709 rows=1 loops=1)

  • Join Filter: ((agg.store_src_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text)
6. 0.004 0.091 ↑ 4.0 1 1

Nested Loop Left Join (cost=18.56..252.78 rows=4 width=123) (actual time=0.081..0.091 rows=1 loops=1)

  • Join Filter: (((d_store_2018_12_27_07_01_39.warehouse_chain_flg)::text = 'N'::text) AND ((f_rad_store_2018_12_27_07_48_52.store_src_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text))
7. 0.002 0.071 ↑ 2.0 1 1

Nested Loop Left Join (cost=14.01..180.86 rows=2 width=125) (actual time=0.066..0.071 rows=1 loops=1)

  • Join Filter: (((d_store_2018_12_27_07_01_39.warehouse_chain_flg)::text = 'Y'::text) AND ((f_pos_store_2018_12_27_07_15_04_1.store_src_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text))
8. 0.002 0.062 ↑ 2.0 1 1

Nested Loop Left Join (cost=9.50..130.61 rows=2 width=125) (actual time=0.058..0.062 rows=1 loops=1)

  • Join Filter: (((d_store_2018_12_27_07_01_39.warehouse_chain_flg)::text = 'N'::text) AND ((f_rad_store_2018_12_27_07_48_52_1.store_src_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text))
9. 0.003 0.038 ↑ 2.0 1 1

Nested Loop Left Join (cost=4.94..58.72 rows=2 width=125) (actual time=0.036..0.038 rows=1 loops=1)

  • Join Filter: (((d_store_2018_12_27_07_01_39.warehouse_chain_flg)::text = 'Y'::text) AND ((f_pos_store_2018_12_27_07_15_04.store_src_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text))
10. 0.022 0.022 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 (cost=0.43..8.47 rows=2 width=125) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
11. 0.002 0.013 ↓ 0.0 0 1

Materialize (cost=4.51..50.22 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

12. 0.001 0.011 ↓ 0.0 0 1

Bitmap Heap Scan on f_pos_store_2018_12_27_07_15_04 (cost=4.51..50.21 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((time_period_cd)::text = 'L12CM'::text)
13. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on f_pos_store_2018_12_27_07_15_04_store_src_cd_idx (cost=0.00..4.51 rows=12 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
14. 0.003 0.022 ↑ 1.0 1 1

Materialize (cost=4.56..71.86 rows=1 width=8) (actual time=0.020..0.022 rows=1 loops=1)

15. 0.005 0.019 ↑ 1.0 1 1

Bitmap Heap Scan on f_rad_store_2018_12_27_07_48_52 f_rad_store_2018_12_27_07_48_52_1 (cost=4.56..71.85 rows=1 width=8) (actual time=0.018..0.019 rows=1 loops=1)

  • Recheck Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((time_period_cd)::text = 'L6M'::text)
  • Rows Removed by Filter: 11
  • Heap Blocks: exact=1
16. 0.014 0.014 ↑ 1.4 12 1

Bitmap Index Scan on f_rad_store_2018_12_27_07_48_52_store_src_cd_idx (cost=0.00..4.56 rows=17 width=0) (actual time=0.014..0.014 rows=12 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
17. 0.001 0.007 ↓ 0.0 0 1

Materialize (cost=4.51..50.22 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

18. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on f_pos_store_2018_12_27_07_15_04 f_pos_store_2018_12_27_07_15_04_1 (cost=4.51..50.21 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((time_period_cd)::text = 'L6M'::text)
19. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on f_pos_store_2018_12_27_07_15_04_store_src_cd_idx (cost=0.00..4.51 rows=12 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
20. 0.000 0.016 ↑ 2.0 1 1

Materialize (cost=4.56..71.86 rows=2 width=8) (actual time=0.013..0.016 rows=1 loops=1)

21. 0.007 0.016 ↑ 2.0 1 1

Bitmap Heap Scan on f_rad_store_2018_12_27_07_48_52 (cost=4.56..71.85 rows=2 width=8) (actual time=0.013..0.016 rows=1 loops=1)

  • Recheck Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((time_period_cd)::text = 'L12CM'::text)
  • Rows Removed by Filter: 11
  • Heap Blocks: exact=1
22. 0.009 0.009 ↑ 1.4 12 1

Bitmap Index Scan on f_rad_store_2018_12_27_07_48_52_store_src_cd_idx (cost=0.00..4.56 rows=17 width=0) (actual time=0.009..0.009 rows=12 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
23. 0.003 576.613 ↑ 2.0 1 1

Materialize (cost=172,358.83..172,410.67 rows=2 width=78) (actual time=576.604..576.613 rows=1 loops=1)

24. 0.004 576.610 ↑ 2.0 1 1

Nested Loop (cost=172,358.83..172,410.66 rows=2 width=78) (actual time=576.602..576.610 rows=1 loops=1)

25. 0.007 576.524 ↑ 1.0 1 1

Subquery Scan on agg (cost=172,358.11..172,359.61 rows=1 width=78) (actual time=576.517..576.524 rows=1 loops=1)

  • Filter: (((agg.brand_dsc)::character varying(200))::text = 'TOTAL'::text)
  • Rows Removed by Filter: 1
26. 0.037 576.517 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=576.513..576.517 rows=2 loops=1)

  • Group Key: "*SELECT* 1".store_src_cd, "*SELECT* 1".store_cd, "*SELECT* 1".store_name, "*SELECT* 1".addr_01_dsc, "*SELECT* 1".city_dsc, "*SELECT* 1".state_cd, "*SELECT* 1".postal_cd, "*SELECT* 1".dma_cd, "*SELECT* 1".dma_dsc, "*SELECT* 1".latitude, "*SELECT* 1".longitude, "*SELECT* 1".store_number, "*SELECT* 1".premise_type_dsc, "*SELECT* 1".channel_cd, "*SELECT* 1".channel_dsc, "*SELECT* 1".ult_parent_cd, "*SELECT* 1".ult_parent_dsc, "*SELECT* 1".rpt_to_cd, "*SELECT* 1".rpt_to_dsc, "*SELECT* 1".chain_ind_flg, "*SELECT* 1".cbbd_chain_flg, "*SELECT* 1".off_premise_sales_priority, ('N'::text), "*SELECT* 1".priority_flg, "*SELECT* 1".brand_cd, "*SELECT* 1".brand_dsc, "*SELECT* 1".first_sold_dt, "*SELECT* 1".last_sold_dt, "*SELECT* 1".risk_flg, "*SELECT* 1".new_flg, "*SELECT* 1".depl_cytd_eqv_qty_ty, "*SELECT* 1".depl_cytd_eqv_qty_ly, "*SELECT* 1".similar_store_depl_cytd_qty_ty, "*SELECT* 1".depl_r365_eqv_qty_ty, "*SELECT* 1".depl_r365_eqv_qty_ly, "*SELECT* 1".similar_store_depl_r365_qty_ty, "*SELECT* 1".depl_l30_eqv_qty_ty, "*SELECT* 1".depl_l30_eqv_qty_ly, "*SELECT* 1".similar_store_depl_l30_qty_ty, "*SELECT* 1".depl_l90_eqv_qty_ty, "*SELECT* 1".depl_l90_eqv_qty_ly, "*SELECT* 1".similar_store_depl_l90_qty_ty, "*SELECT* 1".premise_vol_rank, "*SELECT* 1".similar_store_depl_cytd_qty_ly, "*SELECT* 1".similar_store_depl_r365_qty_ly, "*SELECT* 1".similar_store_depl_l30_qty_ly, "*SELECT* 1".similar_store_depl_l90_qty_ly, "*SELECT* 1".depl_l60_eqv_qty_ty, "*SELECT* 1".depl_l60_eqv_qty_ly, "*SELECT* 1".similar_store_depl_l60_qty_ty, "*SELECT* 1".similar_store_depl_l60_qty_ly, "*SELECT* 1".depl_l120_eqv_qty_ty, "*SELECT* 1".depl_l120_eqv_qty_ly, "*SELECT* 1".similar_store_depl_l120_qty_ty, "*SELECT* 1".similar_store_depl_l120_qty_ly, "*SELECT* 1".depl_lcm_eqv_qty_ty, "*SELECT* 1".depl_lcm_eqv_qty_ly, "*SELECT* 1".similar_store_depl_lcm_qty_ty, "*SELECT* 1".similar_store_depl_lcm_qty_ly, "*SELECT* 1".depl_cmip_eqv_qty_ty, "*SELECT* 1".depl_cmip_eqv_qty_ly, "*SELECT* 1".similar_store_depl_cmip_qty_ty, "*SELECT* 1".similar_store_depl_cmip_qty_ly, "*SELECT* 1".depl_cmip2_eqv_qty_ty, "*SELECT* 1".depl_cmip2_eqv_qty_ly, "*SELECT* 1".similar_store_depl_cmip1_qty_ly, "*SELECT* 1".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1".sim_distribution_l90_ty)::bigint), (("*SELECT* 1".sim_distribution_l90_ly)::bigint), (("*SELECT* 1".eff_distribution_l90_ty)::bigint), (("*SELECT* 1".eff_distribution_l90_ly)::bigint), "*SELECT* 1".depl_cytm_eqv_qty_ty, "*SELECT* 1".depl_cytm_eqv_qty_ly, "*SELECT* 1".similar_store_depl_cytm_qty_ty, "*SELECT* 1".similar_store_depl_cytm_qty_ly, "*SELECT* 1".inv_cnt_l30, "*SELECT* 1".inv_cnt_l60, "*SELECT* 1".inv_cnt_l90, "*SELECT* 1".inv_cnt_l120, "*SELECT* 1".inv_cnt_l365, "*SELECT* 1".inv_cnt_cytm, "*SELECT* 1".inv_cnt_cytd, "*SELECT* 1".inv_cnt_lcm, "*SELECT* 1".inv_cnt_cmip
27. 0.003 576.480 ↑ 30.0 2 1

Append (cost=9.73..172,345.51 rows=60 width=1,585) (actual time=287.801..576.480 rows=2 loops=1)

28. 0.016 287.830 ↑ 58.0 1 1

Subquery Scan on *SELECT* 1 (cost=9.73..171,907.49 rows=58 width=1,617) (actual time=287.799..287.830 rows=1 loops=1)

29. 0.016 287.814 ↑ 58.0 1 1

Nested Loop (cost=9.73..171,906.91 rows=58 width=1,617) (actual time=287.785..287.814 rows=1 loops=1)

30. 0.012 287.765 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=287.739..287.765 rows=1 loops=1)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56.brand_cd)::text)
  • Rows Removed by Join Filter: 24
31. 0.006 287.720 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=287) (actual time=287.718..287.720 rows=1 loops=1)

32. 0.015 0.015 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 (cost=0.43..120.90 rows=29 width=279) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
33. 0.002 287.699 ↓ 0.0 0 1

Subquery Scan on p (cost=8.87..5,922.79 rows=1 width=12) (actual time=287.699..287.699 rows=0 loops=1)

  • Filter: (((p.store_src_cd)::text = '7425774'::text) AND ((p.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24.store_src_cd)::text) AND ((p.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24.brand_cd)::text))
34. 0.001 287.697 ↓ 0.0 0 1

Limit (cost=8.87..5,922.78 rows=1 width=12) (actual time=287.697..287.697 rows=0 loops=1)

35. 0.002 287.696 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=287.696..287.696 rows=0 loops=1)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25.entity_01_cd)::text)
36. 0.001 287.694 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=287.694..287.694 rows=0 loops=1)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22.master_pkg_sku_cd)::text)
37. 287.693 287.693 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=287.693..287.693 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
38. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24.brand_cd)::text)
40. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24.store_src_cd)::text)
  • Heap Fetches: 0
42. 0.024 0.033 ↑ 1.0 25 1

Materialize (cost=0.00..1.38 rows=25 width=1,032) (actual time=0.008..0.033 rows=25 loops=1)

43. 0.009 0.009 ↑ 1.0 25 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.003..0.009 rows=25 loops=1)

44. 0.004 0.033 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=310) (actual time=0.030..0.033 rows=1 loops=1)

45. 0.005 0.029 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=310) (actual time=0.027..0.029 rows=1 loops=1)

46. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 (cost=0.00..1.01 rows=1 width=128) (actual time=0.002..0.002 rows=1 loops=1)

47. 0.022 0.022 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_3 (cost=0.43..8.47 rows=2 width=182) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
48. 0.004 288.647 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2 (cost=1.71..438.02 rows=2 width=669) (actual time=288.637..288.647 rows=1 loops=1)

49. 0.023 288.643 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.71..438.00 rows=2 width=669) (actual time=288.634..288.643 rows=1 loops=1)

50. 0.004 0.080 ↑ 2.0 1 1

Nested Loop (cost=1.28..139.10 rows=2 width=661) (actual time=0.072..0.080 rows=1 loops=1)

51. 0.004 0.063 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=487) (actual time=0.058..0.063 rows=1 loops=1)

52. 0.007 0.022 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=423) (actual time=0.019..0.022 rows=1 loops=1)

53. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_1 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

54. 0.013 0.013 ↑ 1.0 1 1

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_1 (cost=0.42..8.44 rows=1 width=295) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
55. 0.004 0.037 ↑ 1.0 1 1

Subquery Scan on fb (cost=0.43..121.14 rows=1 width=72) (actual time=0.036..0.037 rows=1 loops=1)

  • Filter: ((fb.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_1.store_src_cd)::text)
56. 0.012 0.033 ↑ 1.0 1 1

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (actual time=0.032..0.033 rows=1 loops=1)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_1.store_src_cd
57. 0.006 0.021 ↑ 29.0 1 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.020..0.021 rows=1 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_1.store_src_cd)::text = '7425774'::text)
58. 0.015 0.015 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_1 (cost=0.43..120.90 rows=29 width=22) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
59. 0.013 0.013 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_4 (cost=0.43..8.47 rows=2 width=182) (actual time=0.011..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
60. 0.002 288.540 ↓ 0.0 0 1

Subquery Scan on p_1 (cost=0.43..149.40 rows=1 width=8) (actual time=288.540..288.540 rows=0 loops=1)

  • Filter: (((p_1.store_src_cd)::text = '7425774'::text) AND ((p_1.store_src_cd)::text = (d_store_2018_12_27_07_01_39_4.store_src_cd)::text))
61. 0.005 288.538 ↓ 0.0 0 1

Limit (cost=0.43..149.39 rows=1 width=8) (actual time=288.538..288.538 rows=0 loops=1)

62. 0.001 288.533 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=288.533..288.533 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_1.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_1.entity_01_cd)::text)
63. 288.532 288.532 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_1 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=288.532..288.532 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
64. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_1 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_4.store_src_cd)::text)
  • Heap Fetches: 0
66. 0.024 0.082 ↑ 2.0 1 1

GroupAggregate (cost=0.72..51.02 rows=2 width=38) (actual time=0.082..0.082 rows=1 loops=1)

  • Group Key: x_store_entity_2018_12_27_07_38_25_2.store_src_cd
67. 0.009 0.058 ↑ 1.3 3 1

Nested Loop (cost=0.72..50.96 rows=4 width=38) (actual time=0.034..0.058 rows=3 loops=1)

68. 0.022 0.022 ↑ 1.3 3 1

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_2 (cost=0.43..17.68 rows=4 width=16) (actual time=0.020..0.022 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
69. 0.027 0.027 ↑ 1.0 1 3

Index Scan using d_entity_2018_12_27_07_01_12_entity_01_cd_idx on d_entity_2018_12_27_07_01_12 (cost=0.29..8.31 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_2.entity_01_cd)::text)
70. 0.005 10,775.641 ↑ 1.0 1 1

Materialize (cost=933,523.34..6,184,950.55 rows=1 width=40) (actual time=10,775.640..10,775.641 rows=1 loops=1)

71. 0.095 10,775.636 ↑ 1.0 1 1

GroupAggregate (cost=933,523.34..6,184,950.53 rows=1 width=40) (actual time=10,775.636..10,775.636 rows=1 loops=1)

  • Group Key: f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd
72. 0.072 5,275.326 ↑ 1.0 1 1

GroupAggregate (cost=933,523.34..3,942,362.77 rows=1 width=95) (actual time=5,275.326..5,275.326 rows=1 loops=1)

  • Group Key: f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd, 'brand_cd'::character varying(30)
73.          

Initplan (forGroupAggregate)

74. 0.001 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on brands_mv (cost=4.32..11.31 rows=5 width=418) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ('brand_cd'::text = (brand_cd)::text)
75. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on brands_mv_brand_cd_brand_dsc_idx (cost=0.00..4.31 rows=5 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ('brand_cd'::text = (brand_cd)::text)
76. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on brands_mv brands_mv_1 (cost=4.32..11.31 rows=5 width=418) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ('brand_cd'::text = (brand_cd)::text)
77. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on brands_mv_brand_cd_brand_dsc_idx (cost=0.00..4.31 rows=5 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ('brand_cd'::text = (brand_cd)::text)
78. 0.004 616.234 ↑ 1,488.0 1 1

Nested Loop (cost=933,500.73..1,687,841.42 rows=1,488 width=95) (actual time=616.014..616.234 rows=1 loops=1)

79. 0.013 616.217 ↑ 744.0 1 1

Hash Right Join (cost=933,500.30..1,687,676.71 rows=744 width=95) (actual time=615.999..616.217 rows=1 loops=1)

  • Hash Cond: ((("*SELECT* 1_1".tdlinx_store_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND (("*SELECT* 1_1".pkgsku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.master_pkg_sku_cd)::text))
80. 0.001 12.615 ↑ 246.0 1 1

Append (cost=2.42..753,798.09 rows=246 width=17) (actual time=12.400..12.615 rows=1 loops=1)

81. 0.004 12.614 ↑ 246.0 1 1

Subquery Scan on *SELECT* 1_1 (cost=2.42..753,798.09 rows=246 width=17) (actual time=12.399..12.614 rows=1 loops=1)

82. 0.023 12.610 ↑ 246.0 1 1

Nested Loop (cost=2.42..753,795.63 rows=246 width=57) (actual time=12.397..12.610 rows=1 loops=1)

83.          

Initplan (forNested Loop)

84. 0.001 0.002 ↑ 1.0 1 1

Limit (cost=0.00..1.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

85. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_53 (cost=0.00..1.01 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

86. 0.094 12.567 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.51 rows=123 width=57) (actual time=12.357..12.567 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_2.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_1.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
87. 0.073 0.073 ↑ 1.0 248 1

Seq Scan on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_1 (cost=0.00..8.48 rows=248 width=13) (actual time=0.004..0.073 rows=248 loops=1)

88. 0.168 12.400 ↑ 123.0 1 248

Materialize (cost=0.99..753,302.78 rows=123 width=53) (actual time=0.050..0.050 rows=1 loops=248)

89. 0.005 12.232 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=53) (actual time=12.231..12.232 rows=1 loops=1)

90. 0.009 0.009 ↑ 123.0 1 1

Index Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_2 (cost=0.56..498.48 rows=123 width=53) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
91. 0.002 12.218 ↓ 0.0 0 1

Subquery Scan on p_2 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.218..12.218 rows=0 loops=1)

  • Filter: (((p_2.store_src_cd)::text = '7425774'::text) AND ((p_2.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_2.store_src_cd)::text) AND ((p_2.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_2.master_pkg_sku_cd)::text))
92. 0.002 12.216 ↓ 0.0 0 1

Limit (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.216..12.216 rows=0 loops=1)

93. 0.004 12.214 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.214..12.214 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_3.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_2.entity_01_cd)::text)
94. 12.210 12.210 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_2 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.210..12.210 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_2.master_pkg_sku_cd)::text) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
95. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_3 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06_2.store_src_cd)::text)
  • Heap Fetches: 0
97. 0.001 0.018 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=8) (actual time=0.016..0.018 rows=1 loops=1)

98. 0.004 0.017 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=8) (actual time=0.015..0.017 rows=1 loops=1)

99. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_2 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

100. 0.011 0.011 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_7 (cost=0.43..8.47 rows=2 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
101. 0.006 603.589 ↑ 605.0 1 1

Hash (cost=933,488.80..933,488.80 rows=605 width=104) (actual time=603.589..603.589 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
102. 0.008 603.583 ↑ 605.0 1 1

Merge Left Join (cost=932,962.67..933,488.80 rows=605 width=104) (actual time=603.576..603.583 rows=1 loops=1)

  • Merge Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_1.master_pkg_sku_cd)::text)
  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_1.store_src_cd)::text)
103. 0.005 602.473 ↑ 123.0 1 1

Merge Join (cost=930,183.94..930,684.39 rows=123 width=72) (actual time=602.472..602.473 rows=1 loops=1)

  • Merge Cond: ((vw.sku)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.master_pkg_sku_cd)::text)
104. 0.006 602.455 ↑ 200.0 1 1

Sort (cost=930,183.38..930,183.88 rows=200 width=49) (actual time=602.455..602.455 rows=1 loops=1)

  • Sort Key: vw.sku
  • Sort Method: quicksort Memory: 29kB
105. 0.003 602.449 ↑ 200.0 1 1

Subquery Scan on vw (cost=930,170.74..930,175.74 rows=200 width=49) (actual time=602.448..602.449 rows=1 loops=1)

106. 0.018 602.446 ↑ 200.0 1 1

HashAggregate (cost=930,170.74..930,173.74 rows=200 width=49) (actual time=602.446..602.446 rows=1 loops=1)

  • Group Key: f_store_sku_pkg_agg_2018_12_27_07_28_06_3.store_src_cd, f_store_sku_pkg_agg_2018_12_27_07_28_06_3.master_pkg_sku_cd
107. 0.003 602.428 ↑ 304.0 2 1

Append (cost=3.41..930,166.18 rows=608 width=49) (actual time=12.589..602.428 rows=2 loops=1)

108. 0.037 601.659 ↑ 376.0 1 1

Nested Loop (cost=3.41..927,318.53 rows=376 width=275) (actual time=12.588..601.659 rows=1 loops=1)

109. 0.012 601.609 ↑ 188.0 1 1

Nested Loop Left Join (cost=2.98..927,304.42 rows=188 width=275) (actual time=12.541..601.609 rows=1 loops=1)

  • Join Filter: (((f_store_sku_pkg_agg_2018_12_27_07_28_06_3.store_src_cd)::text = ("*SELECT* 1_2".tdlinx_store_cd)::text) AND ((f_store_sku_pkg_agg_2018_12_27_07_28_06_3.master_pkg_sku_cd)::text = ("*SELECT* 1_2".pkgsku_cd)::text))
  • Rows Removed by Join Filter: 2
110. 0.017 0.017 ↑ 123.0 1 1

Index Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_3 (cost=0.56..498.48 rows=123 width=95) (actual time=0.015..0.017 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
111. 0.009 601.580 ↑ 102.0 3 1

Materialize (cost=2.42..926,148.05 rows=306 width=211) (actual time=12.518..601.580 rows=3 loops=1)

112. 0.003 601.571 ↑ 102.0 3 1

Append (cost=2.42..926,146.52 rows=306 width=211) (actual time=12.515..601.571 rows=3 loops=1)

113. 0.002 12.728 ↑ 246.0 1 1

Subquery Scan on *SELECT* 1_2 (cost=2.42..753,798.09 rows=246 width=197) (actual time=12.515..12.728 rows=1 loops=1)

114. 0.028 12.726 ↑ 246.0 1 1

Nested Loop (cost=2.42..753,795.63 rows=246 width=57) (actual time=12.513..12.726 rows=1 loops=1)

115.          

Initplan (forNested Loop)

116. 0.001 0.003 ↑ 1.0 1 1

Limit (cost=0.00..1.01 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1)

117. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_50 (cost=0.00..1.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

118. 0.206 12.670 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.51 rows=123 width=57) (actual time=12.460..12.670 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_4.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_2.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
119. 0.064 0.064 ↑ 1.0 248 1

Seq Scan on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_2 (cost=0.00..8.48 rows=248 width=13) (actual time=0.003..0.064 rows=248 loops=1)

120. 0.069 12.400 ↑ 123.0 1 248

Materialize (cost=0.99..753,302.78 rows=123 width=53) (actual time=0.050..0.050 rows=1 loops=248)

121. 0.007 12.331 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=53) (actual time=12.328..12.331 rows=1 loops=1)

122. 0.010 0.010 ↑ 123.0 1 1

Index Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_4 (cost=0.56..498.48 rows=123 width=53) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
123. 0.002 12.314 ↓ 0.0 0 1

Subquery Scan on p_3 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.314..12.314 rows=0 loops=1)

  • Filter: (((p_3.store_src_cd)::text = '7425774'::text) AND ((p_3.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_4.store_src_cd)::text) AND ((p_3.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_4.master_pkg_sku_cd)::text))
124. 0.002 12.312 ↓ 0.0 0 1

Limit (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.312..12.312 rows=0 loops=1)

125. 0.004 12.310 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.310..12.310 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_4.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_3.entity_01_cd)::text)
126. 12.306 12.306 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_3 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.306..12.306 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_4.master_pkg_sku_cd)::text) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
127. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_4 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06_4.store_src_cd)::text)
  • Heap Fetches: 0
129. 0.001 0.025 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=8) (actual time=0.023..0.025 rows=1 loops=1)

130. 0.002 0.024 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=8) (actual time=0.022..0.024 rows=1 loops=1)

131. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_3 (cost=0.00..1.01 rows=1 width=0) (actual time=0.002..0.003 rows=1 loops=1)

132. 0.019 0.019 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_9 (cost=0.43..8.47 rows=2 width=8) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
133. 0.002 298.567 ↑ 58.0 1 1

Subquery Scan on *SELECT* 2_1 (cost=10.74..171,909.37 rows=58 width=266) (actual time=298.540..298.567 rows=1 loops=1)

134. 0.024 298.565 ↑ 58.0 1 1

Nested Loop (cost=10.74..171,908.79 rows=58 width=560) (actual time=298.539..298.565 rows=1 loops=1)

135.          

Initplan (forNested Loop)

136. 0.003 0.004 ↑ 1.0 1 1

Limit (cost=0.00..1.01 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=1)

137. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_51 (cost=0.00..1.01 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

138. 0.017 298.507 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=560) (actual time=298.484..298.507 rows=1 loops=1)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24_2.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_1.brand_cd)::text)
  • Rows Removed by Join Filter: 24
139. 0.006 298.466 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=48) (actual time=298.464..298.466 rows=1 loops=1)

140. 0.016 0.016 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_2 (cost=0.43..120.90 rows=29 width=48) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
141. 0.001 298.444 ↓ 0.0 0 1

Subquery Scan on p_4 (cost=8.87..5,922.79 rows=1 width=12) (actual time=298.444..298.444 rows=0 loops=1)

  • Filter: (((p_4.store_src_cd)::text = '7425774'::text) AND ((p_4.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_2.store_src_cd)::text) AND ((p_4.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_2.brand_cd)::text))
142. 0.003 298.443 ↓ 0.0 0 1

Limit (cost=8.87..5,922.78 rows=1 width=12) (actual time=298.443..298.443 rows=0 loops=1)

143. 0.003 298.440 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=298.440..298.440 rows=0 loops=1)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_4.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_5.entity_01_cd)::text)
144. 0.002 298.437 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=298.437..298.437 rows=0 loops=1)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_4.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_3.master_pkg_sku_cd)::text)
145. 298.435 298.435 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_4 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=298.435..298.435 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
146. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_3 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_2.brand_cd)::text)
148. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_5 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_2.store_src_cd)::text)
  • Heap Fetches: 0
150. 0.017 0.024 ↑ 1.0 25 1

Materialize (cost=0.00..1.38 rows=25 width=516) (actual time=0.007..0.024 rows=25 loops=1)

151. 0.007 0.007 ↑ 1.0 25 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_1 (cost=0.00..1.25 rows=25 width=516) (actual time=0.003..0.007 rows=25 loops=1)

152. 0.002 0.030 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=8) (actual time=0.028..0.030 rows=1 loops=1)

153. 0.002 0.028 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=8) (actual time=0.026..0.028 rows=1 loops=1)

154. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_4 (cost=0.00..1.01 rows=1 width=0) (actual time=0.002..0.003 rows=1 loops=1)

155. 0.023 0.023 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_10 (cost=0.43..8.47 rows=2 width=8) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
156. 0.003 290.273 ↑ 2.0 1 1

Subquery Scan on *SELECT* 3 (cost=2.72..439.05 rows=2 width=266) (actual time=290.262..290.273 rows=1 loops=1)

157. 0.030 290.270 ↑ 2.0 1 1

Nested Loop Left Join (cost=2.72..439.03 rows=2 width=44) (actual time=290.261..290.270 rows=1 loops=1)

158.          

Initplan (forNested Loop Left Join)

159. 0.001 0.004 ↑ 1.0 1 1

Limit (cost=0.00..1.01 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=1)

160. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_52 (cost=0.00..1.01 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1)

161. 0.002 0.074 ↑ 2.0 1 1

Nested Loop (cost=1.28..139.10 rows=2 width=44) (actual time=0.065..0.074 rows=1 loops=1)

162. 0.003 0.059 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=44) (actual time=0.053..0.059 rows=1 loops=1)

163. 0.004 0.021 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=44) (actual time=0.017..0.021 rows=1 loops=1)

164. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_5 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

165. 0.015 0.015 ↑ 1.0 1 1

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_2 (cost=0.42..8.44 rows=1 width=44) (actual time=0.012..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
166. 0.004 0.035 ↑ 1.0 1 1

Subquery Scan on fb_1 (cost=0.43..121.14 rows=1 width=8) (actual time=0.034..0.035 rows=1 loops=1)

  • Filter: ((fb_1.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_2.store_src_cd)::text)
167. 0.010 0.031 ↑ 1.0 1 1

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (actual time=0.031..0.031 rows=1 loops=1)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_3.store_src_cd
168. 0.008 0.021 ↑ 29.0 1 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.020..0.021 rows=1 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_2.store_src_cd)::text = '7425774'::text)
169. 0.013 0.013 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_3 (cost=0.43..120.90 rows=29 width=22) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
170. 0.013 0.013 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_11 (cost=0.43..8.47 rows=2 width=8) (actual time=0.011..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
171. 0.001 290.162 ↓ 0.0 0 1

Subquery Scan on p_5 (cost=0.43..149.40 rows=1 width=8) (actual time=290.162..290.162 rows=0 loops=1)

  • Filter: (((p_5.store_src_cd)::text = '7425774'::text) AND ((p_5.store_src_cd)::text = (d_store_2018_12_27_07_01_39_11.store_src_cd)::text))
172. 0.004 290.161 ↓ 0.0 0 1

Limit (cost=0.43..149.39 rows=1 width=8) (actual time=290.161..290.161 rows=0 loops=1)

173. 0.002 290.157 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=290.157..290.157 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_6.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_5.entity_01_cd)::text)
174. 290.155 290.155 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_5 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=290.155..290.155 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
175. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

176. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_6 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_11.store_src_cd)::text)
  • Heap Fetches: 0
177. 0.001 0.013 ↑ 2.0 1 1

Materialize (cost=0.43..8.48 rows=2 width=8) (actual time=0.012..0.013 rows=1 loops=1)

178. 0.012 0.012 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_8 (cost=0.43..8.47 rows=2 width=8) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
179. 0.020 0.766 ↑ 232.0 1 1

HashAggregate (cost=2,838.08..2,841.56 rows=232 width=49) (actual time=0.766..0.766 rows=1 loops=1)

  • Group Key: f_store_sku_pkg_agg_2018_12_27_07_28_06_5.store_src_cd, f_store_sku_pkg_agg_2018_12_27_07_28_06_5.master_pkg_sku_cd
180. 0.006 0.746 ↑ 1,159.0 2 1

Append (cost=1.97..2,820.70 rows=2,318 width=49) (actual time=0.107..0.746 rows=2 loops=1)

181. 0.034 0.110 ↑ 1,210.0 1 1

Nested Loop (cost=1.97..1,042.96 rows=1,210 width=126) (actual time=0.105..0.110 rows=1 loops=1)

182. 0.010 0.044 ↑ 302.0 1 1

Merge Join (cost=1.11..1,001.79 rows=302 width=134) (actual time=0.042..0.044 rows=1 loops=1)

  • Merge Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_5.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_6.master_pkg_sku_cd)::text)
183. 0.022 0.022 ↑ 123.0 1 1

Index Only Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_5 (cost=0.56..498.48 rows=123 width=17) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 1
184. 0.003 0.012 ↑ 123.0 1 1

Materialize (cost=0.56..498.78 rows=123 width=126) (actual time=0.011..0.012 rows=1 loops=1)

185. 0.009 0.009 ↑ 123.0 1 1

Index Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_6 (cost=0.56..498.48 rows=123 width=126) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
186. 0.001 0.032 ↑ 4.0 1 1

Materialize (cost=0.85..17.01 rows=4 width=16) (actual time=0.029..0.032 rows=1 loops=1)

187. 0.003 0.031 ↑ 4.0 1 1

Nested Loop (cost=0.85..16.99 rows=4 width=16) (actual time=0.029..0.031 rows=1 loops=1)

188. 0.015 0.015 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_12 (cost=0.43..8.47 rows=2 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
189. 0.001 0.013 ↑ 2.0 1 1

Materialize (cost=0.43..8.48 rows=2 width=8) (actual time=0.012..0.013 rows=1 loops=1)

190. 0.012 0.012 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_13 (cost=0.43..8.47 rows=2 width=8) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
191. 0.010 0.036 ↓ 0.0 0 1

Hash Join (cost=53.48..555.02 rows=270 width=49) (actual time=0.036..0.036 rows=0 loops=1)

  • Hash Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_7.master_pkg_sku_cd)::text = (rpt.sku)::text)
192. 0.010 0.010 ↑ 123.0 1 1

Index Only Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_7 (cost=0.56..498.48 rows=123 width=17) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 1
193. 0.001 0.016 ↓ 0.0 0 1

Hash (cost=51.31..51.31 rows=129 width=49) (actual time=0.016..0.016 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
194. 0.001 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.84..51.31 rows=129 width=49) (actual time=0.015..0.015 rows=0 loops=1)

195. 0.014 0.014 ↓ 0.0 0 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_14 (cost=0.43..8.48 rows=1 width=14) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: (((max_ver_flg)::text = 'Y'::text) AND ((chain_ind_flg)::character(1) = 'Y'::bpchar))
  • Rows Removed by Filter: 1
196. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_report_to_totals_mv_x_cd_dsc_sku_idx on stores_report_to_totals_mv rpt (cost=0.42..42.63 rows=20 width=47) (never executed)

  • Index Cond: ((cd)::text = (d_store_2018_12_27_07_01_39_14.rpt_to_cd)::text)
197. 0.004 0.028 ↓ 0.0 0 1

Hash Join (cost=55.94..557.62 rows=282 width=49) (actual time=0.028..0.028 rows=0 loops=1)

  • Hash Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_8.master_pkg_sku_cd)::text = (parent.sku)::text)
198. 0.010 0.010 ↑ 123.0 1 1

Index Only Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_8 (cost=0.56..498.48 rows=123 width=17) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 1
199. 0.001 0.014 ↓ 0.0 0 1

Hash (cost=53.65..53.65 rows=139 width=49) (actual time=0.014..0.014 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
200. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.84..53.65 rows=139 width=49) (actual time=0.013..0.013 rows=0 loops=1)

201. 0.012 0.012 ↓ 0.0 0 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_15 (cost=0.43..8.48 rows=1 width=14) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: (((max_ver_flg)::text = 'Y'::text) AND ((chain_ind_flg)::character(1) = 'Y'::bpchar))
  • Rows Removed by Filter: 1
202. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_ultimate_parent_totals_mv_x_cd_dsc_sku_idx on stores_ultimate_parent_totals_mv parent (cost=0.42..44.96 rows=21 width=47) (never executed)

  • Index Cond: ((cd)::text = (d_store_2018_12_27_07_01_39_15.ult_parent_cd)::text)
203. 0.008 0.566 ↑ 556.0 1 1

Hash Join (cost=136.43..641.92 rows=556 width=49) (actual time=0.565..0.566 rows=1 loops=1)

  • Hash Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_9.master_pkg_sku_cd)::text = (dma.sku)::text)
204. 0.009 0.009 ↑ 123.0 1 1

Index Only Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_9 (cost=0.56..498.48 rows=123 width=17) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 1
205. 0.069 0.549 ↑ 2.3 105 1

Hash (cost=132.82..132.82 rows=244 width=49) (actual time=0.549..0.549 rows=105 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 76kB
206. 0.056 0.480 ↑ 2.3 105 1

Nested Loop (cost=0.85..132.82 rows=244 width=49) (actual time=0.387..0.480 rows=105 loops=1)

207. 0.010 0.010 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_16 (cost=0.43..8.47 rows=2 width=18) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
208. 0.414 0.414 ↓ 105.0 105 1

Index Scan using stores_dma_totals_mv_x_cd_dsc_rpt_to_cd_sku_idx on stores_dma_totals_mv dma (cost=0.42..62.17 rows=1 width=51) (actual time=0.373..0.414 rows=105 loops=1)

  • Index Cond: (((cd)::text = (d_store_2018_12_27_07_01_39_16.dma_cd)::text) AND ((rpt_to_cd)::text = (d_store_2018_12_27_07_01_39_16.rpt_to_cd)::text))
209. 0.013 0.013 ↑ 123.0 1 1

Index Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 (cost=0.56..498.48 rows=123 width=31) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
210. 0.003 1.102 ↑ 246.0 1 1

Materialize (cost=2,778.74..2,794.12 rows=246 width=49) (actual time=1.097..1.102 rows=1 loops=1)

211. 0.003 1.099 ↑ 246.0 1 1

Nested Loop (cost=2,778.74..2,793.51 rows=246 width=49) (actual time=1.095..1.099 rows=1 loops=1)

212. 0.071 1.081 ↑ 123.0 1 1

Merge Left Join (cost=2,778.31..2,781.96 rows=123 width=49) (actual time=1.079..1.081 rows=1 loops=1)

  • Merge Cond: (((f_store_sku_pkg_agg_2018_12_27_07_28_06_1.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_10.master_pkg_sku_cd)::text) AND ((f_store_sku_pkg_agg_2018_12_27_07_28_06_1.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_10.store_src_cd)::text))
213. 0.007 0.019 ↑ 123.0 1 1

Sort (cost=502.75..503.05 rows=123 width=86) (actual time=0.019..0.019 rows=1 loops=1)

  • Sort Key: f_store_sku_pkg_agg_2018_12_27_07_28_06_1.master_pkg_sku_cd, f_store_sku_pkg_agg_2018_12_27_07_28_06_1.store_src_cd
  • Sort Method: quicksort Memory: 25kB
214. 0.012 0.012 ↑ 123.0 1 1

Index Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_1 (cost=0.56..498.48 rows=123 width=86) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
215. 0.005 0.991 ↑ 200.0 1 1

Sort (cost=2,275.56..2,276.06 rows=200 width=49) (actual time=0.990..0.991 rows=1 loops=1)

  • Sort Key: f_store_sku_pkg_agg_2018_12_27_07_28_06_10.master_pkg_sku_cd, f_store_sku_pkg_agg_2018_12_27_07_28_06_10.store_src_cd
  • Sort Method: quicksort Memory: 29kB
216. 0.016 0.986 ↑ 200.0 1 1

HashAggregate (cost=2,263.42..2,265.92 rows=200 width=49) (actual time=0.986..0.986 rows=1 loops=1)

  • Group Key: f_store_sku_pkg_agg_2018_12_27_07_28_06_10.store_src_cd, f_store_sku_pkg_agg_2018_12_27_07_28_06_10.master_pkg_sku_cd
217. 0.005 0.970 ↑ 476.8 4 1

Append (cost=1.54..2,249.12 rows=1,907 width=49) (actual time=0.068..0.970 rows=4 loops=1)

218. 0.026 0.071 ↑ 217.0 1 1

Nested Loop (cost=1.54..475.36 rows=217 width=71) (actual time=0.068..0.071 rows=1 loops=1)

219. 0.005 0.031 ↑ 109.0 1 1

Nested Loop (cost=1.11..462.54 rows=109 width=71) (actual time=0.030..0.031 rows=1 loops=1)

220. 0.016 0.016 ↑ 44.0 1 1

Index Scan using stores_beer_sim_tot_velocity__tdlinx_store_cd_brand_cd_mast_idx on stores_beer_sim_tot_velocity_by_sku_brand_mv (cost=0.56..84.58 rows=44 width=71) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7425774'::text)
221. 0.010 0.010 ↑ 1.0 1 1

Index Only Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_10 (cost=0.56..8.58 rows=1 width=17) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((store_src_cd = '7425774'::text) AND (master_pkg_sku_cd = (stores_beer_sim_tot_velocity_by_sku_brand_mv.master_pkg_sku_cd)::text))
  • Heap Fetches: 1
222. 0.003 0.014 ↑ 2.0 1 1

Materialize (cost=0.43..8.48 rows=2 width=8) (actual time=0.013..0.014 rows=1 loops=1)

223. 0.011 0.011 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_17 (cost=0.43..8.47 rows=2 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
224. 0.038 0.254 ↑ 568.0 1 1

Hash Join (cost=29.04..538.91 rows=568 width=94) (actual time=0.253..0.254 rows=1 loops=1)

  • Hash Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_11.master_pkg_sku_cd)::text = (stores_beer_dma_tot_velocity_by_sku_brand_mv.master_pkg_sku_cd)::text)
225. 0.009 0.009 ↑ 123.0 1 1

Index Only Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_11 (cost=0.56..498.48 rows=123 width=17) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 1
226. 0.070 0.207 ↑ 2.4 105 1

Hash (cost=25.38..25.38 rows=248 width=94) (actual time=0.207..0.207 rows=105 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
227. 0.061 0.137 ↑ 2.4 105 1

Nested Loop (cost=0.85..25.38 rows=248 width=94) (actual time=0.042..0.137 rows=105 loops=1)

228. 0.010 0.010 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_18 (cost=0.43..8.47 rows=2 width=18) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
229. 0.066 0.066 ↓ 105.0 105 1

Index Scan using stores_beer_dma_tot_velocity__dma_cd_rpt_to_cd_brand_cd_mas_idx on stores_beer_dma_tot_velocity_by_sku_brand_mv (cost=0.42..8.45 rows=1 width=92) (actual time=0.028..0.066 rows=105 loops=1)

  • Index Cond: (((dma_cd)::text = (d_store_2018_12_27_07_01_39_18.dma_cd)::text) AND ((rpt_to_cd)::text = (d_store_2018_12_27_07_01_39_18.rpt_to_cd)::text))
230. 0.034 0.316 ↑ 552.0 1 1

Hash Join (cost=96.86..605.83 rows=552 width=98) (actual time=0.315..0.316 rows=1 loops=1)

  • Hash Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_12.master_pkg_sku_cd)::text = (stores_beer_rpt_tot_velocity_by_sku_brand_mv.master_pkg_sku_cd)::text)
231. 0.010 0.010 ↑ 123.0 1 1

Index Only Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_12 (cost=0.56..498.48 rows=123 width=17) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 1
232. 0.095 0.272 ↑ 1.7 156 1

Hash (cost=93.00..93.00 rows=264 width=98) (actual time=0.272..0.272 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
233. 0.096 0.177 ↑ 1.7 156 1

Nested Loop (cost=0.84..93.00 rows=264 width=98) (actual time=0.031..0.177 rows=156 loops=1)

234. 0.013 0.013 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_19 (cost=0.43..8.47 rows=2 width=14) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
235. 0.068 0.068 ↓ 7.8 156 1

Index Scan using stores_beer_rpt_tot_velocity__rpt_to_cd_brand_cd_master_pkg_idx on stores_beer_rpt_tot_velocity_by_sku_brand_mv (cost=0.42..42.07 rows=20 width=90) (actual time=0.016..0.068 rows=156 loops=1)

  • Index Cond: ((rpt_to_cd)::text = (d_store_2018_12_27_07_01_39_19.rpt_to_cd)::text)
236. 0.031 0.324 ↑ 570.0 1 1

Hash Join (cost=100.66..609.94 rows=570 width=97) (actual time=0.323..0.324 rows=1 loops=1)

  • Hash Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_13.master_pkg_sku_cd)::text = (stores_beer_ult_tot_velocity_by_sku_brand_mv.master_pkg_sku_cd)::text)
237. 0.010 0.010 ↑ 123.0 1 1

Index Only Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_13 (cost=0.56..498.48 rows=123 width=17) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 1
238. 0.091 0.283 ↑ 1.8 156 1

Hash (cost=96.56..96.56 rows=283 width=97) (actual time=0.283..0.283 rows=156 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
239. 0.101 0.192 ↑ 1.8 156 1

Nested Loop (cost=0.84..96.56 rows=283 width=97) (actual time=0.039..0.192 rows=156 loops=1)

240. 0.024 0.024 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_20 (cost=0.43..8.47 rows=2 width=14) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
241. 0.067 0.067 ↓ 7.4 156 1

Index Scan using stores_beer_ult_tot_velocity__ult_parent_cd_brand_cd_master_idx on stores_beer_ult_tot_velocity_by_sku_brand_mv (cost=0.42..43.84 rows=21 width=89) (actual time=0.011..0.067 rows=156 loops=1)

  • Index Cond: ((ult_parent_cd)::text = (d_store_2018_12_27_07_01_39_20.ult_parent_cd)::text)
242. 0.002 0.015 ↑ 2.0 1 1

Materialize (cost=0.43..8.48 rows=2 width=8) (actual time=0.014..0.015 rows=1 loops=1)

243. 0.013 0.013 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_6 (cost=0.43..8.47 rows=2 width=8) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
244. 0.002 0.013 ↑ 2.0 1 1

Materialize (cost=0.43..8.48 rows=2 width=8) (actual time=0.012..0.013 rows=1 loops=1)

245. 0.011 0.011 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_5 (cost=0.43..8.47 rows=2 width=8) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
246.          

SubPlan (forGroupAggregate)

247. 0.001 0.074 ↑ 2.0 1 1

Subquery Scan on c (cost=15.74..6,487.30 rows=2 width=32) (actual time=0.071..0.074 rows=1 loops=1)

248. 0.003 0.073 ↑ 2.0 1 1

Unique (cost=15.74..6,487.28 rows=2 width=148) (actual time=0.070..0.073 rows=1 loops=1)

249. 0.021 0.070 ↑ 500.0 1 1

Nested Loop (cost=15.74..6,484.78 rows=500 width=148) (actual time=0.068..0.070 rows=1 loops=1)

250. 0.005 0.036 ↑ 250.0 1 1

Nested Loop Left Join (cost=15.31..6,457.56 rows=250 width=148) (actual time=0.035..0.036 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_15.store_src_cd)::text = ("*SELECT* 2_12".tdlinx_store_cd)::text)
251. 0.010 0.010 ↑ 125.0 1 1

Index Only Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_15 (cost=0.56..506.51 rows=125 width=8) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Heap Fetches: 1
252. 0.001 0.021 ↓ 0.0 0 1

Materialize (cost=14.75..5,947.31 rows=2 width=148) (actual time=0.021..0.021 rows=0 loops=1)

253. 0.002 0.020 ↓ 0.0 0 1

Append (cost=14.75..5,947.30 rows=2 width=148) (actual time=0.020..0.020 rows=0 loops=1)

254. 0.001 0.018 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_12 (cost=14.75..5,947.30 rows=2 width=148) (actual time=0.018..0.018 rows=0 loops=1)

255. 0.002 0.017 ↓ 0.0 0 1

Nested Loop (cost=14.75..5,947.28 rows=2 width=560) (actual time=0.017..0.017 rows=0 loops=1)

256.          

Initplan (forNested Loop)

257. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.01 rows=1 width=32) (never executed)

258. 0.000 0.000 ↓ 0.0 0

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_28 (cost=0.00..1.01 rows=1 width=32) (never executed)

259. 0.003 0.015 ↓ 0.0 0 1

Nested Loop Left Join (cost=13.32..5,937.67 rows=1 width=560) (actual time=0.015..0.015 rows=0 loops=1)

260. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=4.44..14.87 rows=1 width=564) (actual time=0.012..0.012 rows=0 loops=1)

261. 0.002 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.39 rows=1 width=516) (actual time=0.012..0.012 rows=0 loops=1)

262. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_29 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

263. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_12 (cost=0.00..1.38 rows=1 width=516) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ('brand_cd'::text = ((brand_cd)::character varying(30))::text)
  • Rows Removed by Filter: 25
264. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_25 (cost=4.44..12.45 rows=2 width=48) (never executed)

  • Recheck Cond: (((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_12.brand_cd)::text))
265. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on f_store_brand_agg_2018_12_27_07_29_24_pk (cost=0.00..4.44 rows=2 width=0) (never executed)

  • Index Cond: (((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_12.brand_cd)::text))
266. 0.000 0.000 ↓ 0.0 0

Subquery Scan on p_27 (cost=8.87..5,922.79 rows=1 width=12) (never executed)

  • Filter: (((p_27.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_27.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_25.store_src_cd)::text) AND ((p_27.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_25.brand_cd)::text))
267. 0.000 0.000 ↓ 0.0 0

Limit (cost=8.87..5,922.78 rows=1 width=12) (never executed)

268. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (never executed)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_27.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_38.entity_01_cd)::text)
269. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (never executed)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_27.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_14.master_pkg_sku_cd)::text)
270. 0.000 0.000 ↓ 0.0 0

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_27 (cost=0.00..5,840.38 rows=11,608 width=16) (never executed)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
271. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

272. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_14 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_25.brand_cd)::text)
273. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

274. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_38 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_25.store_src_cd)::text)
  • Heap Fetches: 0
275. 0.000 0.000 ↓ 0.0 0

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_44 (cost=0.43..8.47 rows=2 width=8) (never executed)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
276. 0.002 0.013 ↑ 2.0 1 1

Materialize (cost=0.43..8.48 rows=2 width=8) (actual time=0.012..0.013 rows=1 loops=1)

277. 0.011 0.011 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_43 (cost=0.43..8.47 rows=2 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
278. 0.002 2,302.762 ↓ 0.0 0 1

Nested Loop (cost=344,732.84..868,036.11 rows=20 width=582) (actual time=2,302.762..2,302.762 rows=0 loops=1)

279. 0.002 2,302.760 ↓ 0.0 0 1

GroupAggregate (cost=172,359.25..689,677.62 rows=5 width=188) (actual time=2,302.760..2,302.760 rows=0 loops=1)

  • Group Key: agg_12.store_src_cd, ((agg_12.brand_cd)::character varying(30))
280. 0.009 2,302.758 ↓ 0.0 0 1

Append (cost=172,359.25..689,677.52 rows=5 width=188) (actual time=2,302.758..2,302.758 rows=0 loops=1)

281. 0.001 581.511 ↓ 0.0 0 1

Nested Loop (cost=172,359.25..172,419.44 rows=2 width=227) (actual time=581.511..581.511 rows=0 loops=1)

282. 0.001 581.510 ↓ 0.0 0 1

Nested Loop (cost=172,358.53..172,368.36 rows=1 width=227) (actual time=581.510..581.510 rows=0 loops=1)

283. 0.008 581.509 ↓ 0.0 0 1

Subquery Scan on agg_12 (cost=172,358.11..172,359.91 rows=1 width=110) (actual time=581.509..581.509 rows=0 loops=1)

  • Filter: ((((agg_12.brand_cd)::character varying(30))::text <> 'TOTAL'::text) AND (((agg_12.brand_cd)::character varying(30))::text = 'brand_cd'::text))
  • Rows Removed by Filter: 2
284. 0.036 581.501 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=581.499..581.501 rows=2 loops=1)

  • Group Key: "*SELECT* 1_13".store_src_cd, "*SELECT* 1_13".store_cd, "*SELECT* 1_13".store_name, "*SELECT* 1_13".addr_01_dsc, "*SELECT* 1_13".city_dsc, "*SELECT* 1_13".state_cd, "*SELECT* 1_13".postal_cd, "*SELECT* 1_13".dma_cd, "*SELECT* 1_13".dma_dsc, "*SELECT* 1_13".latitude, "*SELECT* 1_13".longitude, "*SELECT* 1_13".store_number, "*SELECT* 1_13".premise_type_dsc, "*SELECT* 1_13".channel_cd, "*SELECT* 1_13".channel_dsc, "*SELECT* 1_13".ult_parent_cd, "*SELECT* 1_13".ult_parent_dsc, "*SELECT* 1_13".rpt_to_cd, "*SELECT* 1_13".rpt_to_dsc, "*SELECT* 1_13".chain_ind_flg, "*SELECT* 1_13".cbbd_chain_flg, "*SELECT* 1_13".off_premise_sales_priority, ('N'::text), "*SELECT* 1_13".priority_flg, "*SELECT* 1_13".brand_cd, "*SELECT* 1_13".brand_dsc, "*SELECT* 1_13".first_sold_dt, "*SELECT* 1_13".last_sold_dt, "*SELECT* 1_13".risk_flg, "*SELECT* 1_13".new_flg, "*SELECT* 1_13".depl_cytd_eqv_qty_ty, "*SELECT* 1_13".depl_cytd_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_cytd_qty_ty, "*SELECT* 1_13".depl_r365_eqv_qty_ty, "*SELECT* 1_13".depl_r365_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_r365_qty_ty, "*SELECT* 1_13".depl_l30_eqv_qty_ty, "*SELECT* 1_13".depl_l30_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_l30_qty_ty, "*SELECT* 1_13".depl_l90_eqv_qty_ty, "*SELECT* 1_13".depl_l90_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_l90_qty_ty, "*SELECT* 1_13".premise_vol_rank, "*SELECT* 1_13".similar_store_depl_cytd_qty_ly, "*SELECT* 1_13".similar_store_depl_r365_qty_ly, "*SELECT* 1_13".similar_store_depl_l30_qty_ly, "*SELECT* 1_13".similar_store_depl_l90_qty_ly, "*SELECT* 1_13".depl_l60_eqv_qty_ty, "*SELECT* 1_13".depl_l60_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_l60_qty_ty, "*SELECT* 1_13".similar_store_depl_l60_qty_ly, "*SELECT* 1_13".depl_l120_eqv_qty_ty, "*SELECT* 1_13".depl_l120_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_l120_qty_ty, "*SELECT* 1_13".similar_store_depl_l120_qty_ly, "*SELECT* 1_13".depl_lcm_eqv_qty_ty, "*SELECT* 1_13".depl_lcm_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_lcm_qty_ty, "*SELECT* 1_13".similar_store_depl_lcm_qty_ly, "*SELECT* 1_13".depl_cmip_eqv_qty_ty, "*SELECT* 1_13".depl_cmip_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_cmip_qty_ty, "*SELECT* 1_13".similar_store_depl_cmip_qty_ly, "*SELECT* 1_13".depl_cmip2_eqv_qty_ty, "*SELECT* 1_13".depl_cmip2_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_cmip1_qty_ly, "*SELECT* 1_13".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1_13".sim_distribution_l90_ty)::bigint), (("*SELECT* 1_13".sim_distribution_l90_ly)::bigint), (("*SELECT* 1_13".eff_distribution_l90_ty)::bigint), (("*SELECT* 1_13".eff_distribution_l90_ly)::bigint), "*SELECT* 1_13".depl_cytm_eqv_qty_ty, "*SELECT* 1_13".depl_cytm_eqv_qty_ly, "*SELECT* 1_13".similar_store_depl_cytm_qty_ty, "*SELECT* 1_13".similar_store_depl_cytm_qty_ly, "*SELECT* 1_13".inv_cnt_l30, "*SELECT* 1_13".inv_cnt_l60, "*SELECT* 1_13".inv_cnt_l90, "*SELECT* 1_13".inv_cnt_l120, "*SELECT* 1_13".inv_cnt_l365, "*SELECT* 1_13".inv_cnt_cytm, "*SELECT* 1_13".inv_cnt_cytd, "*SELECT* 1_13".inv_cnt_lcm, "*SELECT* 1_13".inv_cnt_cmip
285. 0.004 581.465 ↑ 30.0 2 1

Append (cost=9.73..172,345.51 rows=60 width=1,585) (actual time=285.110..581.465 rows=2 loops=1)

286. 0.007 285.137 ↑ 58.0 1 1

Subquery Scan on *SELECT* 1_13 (cost=9.73..171,907.49 rows=58 width=1,617) (actual time=285.108..285.137 rows=1 loops=1)

287. 0.018 285.130 ↑ 58.0 1 1

Nested Loop (cost=9.73..171,906.91 rows=58 width=1,617) (actual time=285.101..285.130 rows=1 loops=1)

288. 0.018 285.074 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=285.048..285.074 rows=1 loops=1)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24_26.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_13.brand_cd)::text)
  • Rows Removed by Join Filter: 24
289. 0.007 285.029 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=287) (actual time=285.028..285.029 rows=1 loops=1)

290. 0.014 0.014 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_26 (cost=0.43..120.90 rows=29 width=279) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
291. 0.002 285.008 ↓ 0.0 0 1

Subquery Scan on p_28 (cost=8.87..5,922.79 rows=1 width=12) (actual time=285.008..285.008 rows=0 loops=1)

  • Filter: (((p_28.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_28.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_26.store_src_cd)::text) AND ((p_28.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_26.brand_cd)::text))
292. 0.002 285.006 ↓ 0.0 0 1

Limit (cost=8.87..5,922.78 rows=1 width=12) (actual time=285.006..285.006 rows=0 loops=1)

293. 0.002 285.004 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=285.004..285.004 rows=0 loops=1)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_28.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_39.entity_01_cd)::text)
294. 0.002 285.002 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=285.002..285.002 rows=0 loops=1)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_28.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_15.master_pkg_sku_cd)::text)
295. 285.000 285.000 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_28 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=285.000..285.000 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
296. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

297. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_15 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_26.brand_cd)::text)
298. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

299. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_39 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_26.store_src_cd)::text)
  • Heap Fetches: 0
300. 0.017 0.027 ↑ 1.0 25 1

Materialize (cost=0.00..1.38 rows=25 width=1,032) (actual time=0.008..0.027 rows=25 loops=1)

301. 0.010 0.010 ↑ 1.0 25 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_13 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.003..0.010 rows=25 loops=1)

302. 0.009 0.038 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=310) (actual time=0.035..0.038 rows=1 loops=1)

303. 0.006 0.029 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=310) (actual time=0.027..0.029 rows=1 loops=1)

304. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_31 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

305. 0.022 0.022 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_45 (cost=0.43..8.47 rows=2 width=182) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
306. 0.004 296.324 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_14 (cost=1.71..438.02 rows=2 width=669) (actual time=296.314..296.324 rows=1 loops=1)

307. 0.021 296.320 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.71..438.00 rows=2 width=669) (actual time=296.312..296.320 rows=1 loops=1)

308. 0.006 0.083 ↑ 2.0 1 1

Nested Loop (cost=1.28..139.10 rows=2 width=661) (actual time=0.075..0.083 rows=1 loops=1)

309. 0.007 0.065 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=487) (actual time=0.060..0.065 rows=1 loops=1)

310. 0.008 0.022 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=423) (actual time=0.019..0.022 rows=1 loops=1)

311. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_32 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

312. 0.012 0.012 ↑ 1.0 1 1

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_14 (cost=0.42..8.44 rows=1 width=295) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
313. 0.003 0.036 ↑ 1.0 1 1

Subquery Scan on fb_13 (cost=0.43..121.14 rows=1 width=72) (actual time=0.035..0.036 rows=1 loops=1)

  • Filter: ((fb_13.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_14.store_src_cd)::text)
314. 0.010 0.033 ↑ 1.0 1 1

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (actual time=0.033..0.033 rows=1 loops=1)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_27.store_src_cd
315. 0.008 0.023 ↑ 29.0 1 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.022..0.023 rows=1 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_14.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
316. 0.015 0.015 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_27 (cost=0.43..120.90 rows=29 width=22) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
317. 0.012 0.012 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_46 (cost=0.43..8.47 rows=2 width=182) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
318. 0.001 296.216 ↓ 0.0 0 1

Subquery Scan on p_29 (cost=0.43..149.40 rows=1 width=8) (actual time=296.216..296.216 rows=0 loops=1)

  • Filter: (((p_29.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_29.store_src_cd)::text = (d_store_2018_12_27_07_01_39_46.store_src_cd)::text))
319. 0.003 296.215 ↓ 0.0 0 1

Limit (cost=0.43..149.39 rows=1 width=8) (actual time=296.215..296.215 rows=0 loops=1)

320. 0.001 296.212 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=296.212..296.212 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_40.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_29.entity_01_cd)::text)
321. 296.211 296.211 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_29 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=296.211..296.211 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
322. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

323. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_40 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_46.store_src_cd)::text)
  • Heap Fetches: 0
324. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_tot_vol_sim_perf_comp_tdlinx_store_cd_brand_cd_idx1 on stores_beer_tot_vol_sim_perf_comps_by_brand_mv stores_beer_tot_vol_sim_perf_comps_by_brand_mv_1 (cost=0.42..8.45 rows=1 width=129) (never executed)

  • Index Cond: (((tdlinx_store_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((brand_cd)::text = 'brand_cd'::text))
325. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.72..51.02 rows=2 width=38) (never executed)

  • Group Key: x_store_entity_2018_12_27_07_38_25_41.store_src_cd
326. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..50.96 rows=4 width=38) (never executed)

327. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_41 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Heap Fetches: 0
328. 0.000 0.000 ↓ 0.0 0

Index Scan using d_entity_2018_12_27_07_01_12_entity_01_cd_idx on d_entity_2018_12_27_07_01_12 d_entity_2018_12_27_07_01_12_11 (cost=0.29..8.31 rows=1 width=30) (never executed)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_41.entity_01_cd)::text)
329. 0.001 577.436 ↓ 0.0 0 1

Nested Loop (cost=172,359.25..172,419.44 rows=1 width=222) (actual time=577.436..577.436 rows=0 loops=1)

330. 0.003 577.435 ↓ 0.0 0 1

Nested Loop (cost=172,358.53..172,368.37 rows=1 width=222) (actual time=577.435..577.435 rows=0 loops=1)

331. 0.008 577.432 ↓ 0.0 0 1

Subquery Scan on agg_13 (cost=172,358.11..172,359.91 rows=1 width=220) (actual time=577.432..577.432 rows=0 loops=1)

  • Filter: ((((agg_13.brand_cd)::character varying(30))::text <> 'TOTAL'::text) AND (((agg_13.brand_cd)::character varying(30))::text = 'brand_cd'::text))
  • Rows Removed by Filter: 2
332. 0.038 577.424 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=577.423..577.424 rows=2 loops=1)

  • Group Key: "*SELECT* 1_14".store_src_cd, "*SELECT* 1_14".store_cd, "*SELECT* 1_14".store_name, "*SELECT* 1_14".addr_01_dsc, "*SELECT* 1_14".city_dsc, "*SELECT* 1_14".state_cd, "*SELECT* 1_14".postal_cd, "*SELECT* 1_14".dma_cd, "*SELECT* 1_14".dma_dsc, "*SELECT* 1_14".latitude, "*SELECT* 1_14".longitude, "*SELECT* 1_14".store_number, "*SELECT* 1_14".premise_type_dsc, "*SELECT* 1_14".channel_cd, "*SELECT* 1_14".channel_dsc, "*SELECT* 1_14".ult_parent_cd, "*SELECT* 1_14".ult_parent_dsc, "*SELECT* 1_14".rpt_to_cd, "*SELECT* 1_14".rpt_to_dsc, "*SELECT* 1_14".chain_ind_flg, "*SELECT* 1_14".cbbd_chain_flg, "*SELECT* 1_14".off_premise_sales_priority, ('N'::text), "*SELECT* 1_14".priority_flg, "*SELECT* 1_14".brand_cd, "*SELECT* 1_14".brand_dsc, "*SELECT* 1_14".first_sold_dt, "*SELECT* 1_14".last_sold_dt, "*SELECT* 1_14".risk_flg, "*SELECT* 1_14".new_flg, "*SELECT* 1_14".depl_cytd_eqv_qty_ty, "*SELECT* 1_14".depl_cytd_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_cytd_qty_ty, "*SELECT* 1_14".depl_r365_eqv_qty_ty, "*SELECT* 1_14".depl_r365_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_r365_qty_ty, "*SELECT* 1_14".depl_l30_eqv_qty_ty, "*SELECT* 1_14".depl_l30_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_l30_qty_ty, "*SELECT* 1_14".depl_l90_eqv_qty_ty, "*SELECT* 1_14".depl_l90_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_l90_qty_ty, "*SELECT* 1_14".premise_vol_rank, "*SELECT* 1_14".similar_store_depl_cytd_qty_ly, "*SELECT* 1_14".similar_store_depl_r365_qty_ly, "*SELECT* 1_14".similar_store_depl_l30_qty_ly, "*SELECT* 1_14".similar_store_depl_l90_qty_ly, "*SELECT* 1_14".depl_l60_eqv_qty_ty, "*SELECT* 1_14".depl_l60_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_l60_qty_ty, "*SELECT* 1_14".similar_store_depl_l60_qty_ly, "*SELECT* 1_14".depl_l120_eqv_qty_ty, "*SELECT* 1_14".depl_l120_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_l120_qty_ty, "*SELECT* 1_14".similar_store_depl_l120_qty_ly, "*SELECT* 1_14".depl_lcm_eqv_qty_ty, "*SELECT* 1_14".depl_lcm_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_lcm_qty_ty, "*SELECT* 1_14".similar_store_depl_lcm_qty_ly, "*SELECT* 1_14".depl_cmip_eqv_qty_ty, "*SELECT* 1_14".depl_cmip_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_cmip_qty_ty, "*SELECT* 1_14".similar_store_depl_cmip_qty_ly, "*SELECT* 1_14".depl_cmip2_eqv_qty_ty, "*SELECT* 1_14".depl_cmip2_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_cmip1_qty_ly, "*SELECT* 1_14".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1_14".sim_distribution_l90_ty)::bigint), (("*SELECT* 1_14".sim_distribution_l90_ly)::bigint), (("*SELECT* 1_14".eff_distribution_l90_ty)::bigint), (("*SELECT* 1_14".eff_distribution_l90_ly)::bigint), "*SELECT* 1_14".depl_cytm_eqv_qty_ty, "*SELECT* 1_14".depl_cytm_eqv_qty_ly, "*SELECT* 1_14".similar_store_depl_cytm_qty_ty, "*SELECT* 1_14".similar_store_depl_cytm_qty_ly, "*SELECT* 1_14".inv_cnt_l30, "*SELECT* 1_14".inv_cnt_l60, "*SELECT* 1_14".inv_cnt_l90, "*SELECT* 1_14".inv_cnt_l120, "*SELECT* 1_14".inv_cnt_l365, "*SELECT* 1_14".inv_cnt_cytm, "*SELECT* 1_14".inv_cnt_cytd, "*SELECT* 1_14".inv_cnt_lcm, "*SELECT* 1_14".inv_cnt_cmip
333. 0.004 577.386 ↑ 30.0 2 1

Append (cost=9.73..172,345.51 rows=60 width=1,585) (actual time=287.379..577.386 rows=2 loops=1)

334. 0.008 287.407 ↑ 58.0 1 1

Subquery Scan on *SELECT* 1_14 (cost=9.73..171,907.49 rows=58 width=1,617) (actual time=287.377..287.407 rows=1 loops=1)

335. 0.015 287.399 ↑ 58.0 1 1

Nested Loop (cost=9.73..171,906.91 rows=58 width=1,617) (actual time=287.371..287.399 rows=1 loops=1)

336. 0.011 287.345 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=287.320..287.345 rows=1 loops=1)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24_28.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_14.brand_cd)::text)
  • Rows Removed by Join Filter: 24
337. 0.010 287.300 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=287) (actual time=287.298..287.300 rows=1 loops=1)

338. 0.019 0.019 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_28 (cost=0.43..120.90 rows=29 width=279) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
339. 0.002 287.271 ↓ 0.0 0 1

Subquery Scan on p_30 (cost=8.87..5,922.79 rows=1 width=12) (actual time=287.271..287.271 rows=0 loops=1)

  • Filter: (((p_30.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_30.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_28.store_src_cd)::text) AND ((p_30.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_28.brand_cd)::text))
340. 0.002 287.269 ↓ 0.0 0 1

Limit (cost=8.87..5,922.78 rows=1 width=12) (actual time=287.269..287.269 rows=0 loops=1)

341. 0.004 287.267 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=287.267..287.267 rows=0 loops=1)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_30.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_42.entity_01_cd)::text)
342. 0.002 287.263 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=287.263..287.263 rows=0 loops=1)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_30.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_16.master_pkg_sku_cd)::text)
343. 287.261 287.261 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_30 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=287.261..287.261 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
344. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

345. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_16 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_28.brand_cd)::text)
346. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

347. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_42 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_28.store_src_cd)::text)
  • Heap Fetches: 0
348. 0.022 0.034 ↑ 1.0 25 1

Materialize (cost=0.00..1.38 rows=25 width=1,032) (actual time=0.009..0.034 rows=25 loops=1)

349. 0.012 0.012 ↑ 1.0 25 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_14 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.002..0.012 rows=25 loops=1)

350. 0.007 0.039 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=310) (actual time=0.036..0.039 rows=1 loops=1)

351. 0.007 0.032 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=310) (actual time=0.029..0.032 rows=1 loops=1)

352. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_33 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

353. 0.024 0.024 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_47 (cost=0.43..8.47 rows=2 width=182) (actual time=0.022..0.024 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
354. 0.004 289.975 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_15 (cost=1.71..438.02 rows=2 width=669) (actual time=289.966..289.975 rows=1 loops=1)

355. 0.024 289.971 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.71..438.00 rows=2 width=669) (actual time=289.963..289.971 rows=1 loops=1)

356. 0.006 0.082 ↑ 2.0 1 1

Nested Loop (cost=1.28..139.10 rows=2 width=661) (actual time=0.074..0.082 rows=1 loops=1)

357. 0.004 0.063 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=487) (actual time=0.058..0.063 rows=1 loops=1)

358. 0.008 0.022 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=423) (actual time=0.019..0.022 rows=1 loops=1)

359. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_34 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

360. 0.013 0.013 ↑ 1.0 1 1

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_15 (cost=0.42..8.44 rows=1 width=295) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
361. 0.004 0.037 ↑ 1.0 1 1

Subquery Scan on fb_14 (cost=0.43..121.14 rows=1 width=72) (actual time=0.035..0.037 rows=1 loops=1)

  • Filter: ((fb_14.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_15.store_src_cd)::text)
362. 0.011 0.033 ↑ 1.0 1 1

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (actual time=0.032..0.033 rows=1 loops=1)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_29.store_src_cd
363. 0.007 0.022 ↑ 29.0 1 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.021..0.022 rows=1 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_15.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
364. 0.015 0.015 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_29 (cost=0.43..120.90 rows=29 width=22) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
365. 0.013 0.013 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_48 (cost=0.43..8.47 rows=2 width=182) (actual time=0.011..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
366. 0.001 289.865 ↓ 0.0 0 1

Subquery Scan on p_31 (cost=0.43..149.40 rows=1 width=8) (actual time=289.865..289.865 rows=0 loops=1)

  • Filter: (((p_31.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_31.store_src_cd)::text = (d_store_2018_12_27_07_01_39_48.store_src_cd)::text))
367. 0.001 289.864 ↓ 0.0 0 1

Limit (cost=0.43..149.39 rows=1 width=8) (actual time=289.864..289.864 rows=0 loops=1)

368. 0.003 289.863 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=289.863..289.863 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_43.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_31.entity_01_cd)::text)
369. 289.860 289.860 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_31 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=289.860..289.860 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
370. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

371. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_43 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_48.store_src_cd)::text)
  • Heap Fetches: 0
372. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_tot_vol_dma_perf_com_dma_cd_rpt_to_cd_brand_cd_idx1 on stores_beer_tot_vol_dma_perf_comps_by_brand_mv stores_beer_tot_vol_dma_perf_comps_by_brand_mv_1 (cost=0.42..8.45 rows=1 width=123) (never executed)

  • Index Cond: (((dma_cd)::text = ((agg_13.dma_cd)::character varying(30))::text) AND ((rpt_to_cd)::text = (agg_13.rpt_to_cd)::text) AND ((brand_cd)::text = 'brand_cd'::text))
373. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.72..51.02 rows=2 width=38) (never executed)

  • Group Key: x_store_entity_2018_12_27_07_38_25_44.store_src_cd
374. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..50.96 rows=4 width=38) (never executed)

375. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_44 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Heap Fetches: 0
376. 0.000 0.000 ↓ 0.0 0

Index Scan using d_entity_2018_12_27_07_01_12_entity_01_cd_idx on d_entity_2018_12_27_07_01_12 d_entity_2018_12_27_07_01_12_12 (cost=0.29..8.31 rows=1 width=30) (never executed)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_44.entity_01_cd)::text)
377. 0.001 570.116 ↓ 0.0 0 1

Nested Loop (cost=172,359.12..172,419.30 rows=1 width=232) (actual time=570.116..570.116 rows=0 loops=1)

378. 0.002 570.115 ↓ 0.0 0 1

Nested Loop (cost=172,358.40..172,368.23 rows=1 width=232) (actual time=570.115..570.115 rows=0 loops=1)

379. 0.009 570.113 ↓ 0.0 0 1

Subquery Scan on agg_14 (cost=172,358.11..172,359.91 rows=1 width=188) (actual time=570.113..570.113 rows=0 loops=1)

  • Filter: ((((agg_14.brand_cd)::character varying(30))::text <> 'TOTAL'::text) AND (((agg_14.brand_cd)::character varying(30))::text = 'brand_cd'::text))
  • Rows Removed by Filter: 2
380. 0.034 570.104 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=570.103..570.104 rows=2 loops=1)

  • Group Key: "*SELECT* 1_15".store_src_cd, "*SELECT* 1_15".store_cd, "*SELECT* 1_15".store_name, "*SELECT* 1_15".addr_01_dsc, "*SELECT* 1_15".city_dsc, "*SELECT* 1_15".state_cd, "*SELECT* 1_15".postal_cd, "*SELECT* 1_15".dma_cd, "*SELECT* 1_15".dma_dsc, "*SELECT* 1_15".latitude, "*SELECT* 1_15".longitude, "*SELECT* 1_15".store_number, "*SELECT* 1_15".premise_type_dsc, "*SELECT* 1_15".channel_cd, "*SELECT* 1_15".channel_dsc, "*SELECT* 1_15".ult_parent_cd, "*SELECT* 1_15".ult_parent_dsc, "*SELECT* 1_15".rpt_to_cd, "*SELECT* 1_15".rpt_to_dsc, "*SELECT* 1_15".chain_ind_flg, "*SELECT* 1_15".cbbd_chain_flg, "*SELECT* 1_15".off_premise_sales_priority, ('N'::text), "*SELECT* 1_15".priority_flg, "*SELECT* 1_15".brand_cd, "*SELECT* 1_15".brand_dsc, "*SELECT* 1_15".first_sold_dt, "*SELECT* 1_15".last_sold_dt, "*SELECT* 1_15".risk_flg, "*SELECT* 1_15".new_flg, "*SELECT* 1_15".depl_cytd_eqv_qty_ty, "*SELECT* 1_15".depl_cytd_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_cytd_qty_ty, "*SELECT* 1_15".depl_r365_eqv_qty_ty, "*SELECT* 1_15".depl_r365_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_r365_qty_ty, "*SELECT* 1_15".depl_l30_eqv_qty_ty, "*SELECT* 1_15".depl_l30_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_l30_qty_ty, "*SELECT* 1_15".depl_l90_eqv_qty_ty, "*SELECT* 1_15".depl_l90_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_l90_qty_ty, "*SELECT* 1_15".premise_vol_rank, "*SELECT* 1_15".similar_store_depl_cytd_qty_ly, "*SELECT* 1_15".similar_store_depl_r365_qty_ly, "*SELECT* 1_15".similar_store_depl_l30_qty_ly, "*SELECT* 1_15".similar_store_depl_l90_qty_ly, "*SELECT* 1_15".depl_l60_eqv_qty_ty, "*SELECT* 1_15".depl_l60_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_l60_qty_ty, "*SELECT* 1_15".similar_store_depl_l60_qty_ly, "*SELECT* 1_15".depl_l120_eqv_qty_ty, "*SELECT* 1_15".depl_l120_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_l120_qty_ty, "*SELECT* 1_15".similar_store_depl_l120_qty_ly, "*SELECT* 1_15".depl_lcm_eqv_qty_ty, "*SELECT* 1_15".depl_lcm_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_lcm_qty_ty, "*SELECT* 1_15".similar_store_depl_lcm_qty_ly, "*SELECT* 1_15".depl_cmip_eqv_qty_ty, "*SELECT* 1_15".depl_cmip_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_cmip_qty_ty, "*SELECT* 1_15".similar_store_depl_cmip_qty_ly, "*SELECT* 1_15".depl_cmip2_eqv_qty_ty, "*SELECT* 1_15".depl_cmip2_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_cmip1_qty_ly, "*SELECT* 1_15".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1_15".sim_distribution_l90_ty)::bigint), (("*SELECT* 1_15".sim_distribution_l90_ly)::bigint), (("*SELECT* 1_15".eff_distribution_l90_ty)::bigint), (("*SELECT* 1_15".eff_distribution_l90_ly)::bigint), "*SELECT* 1_15".depl_cytm_eqv_qty_ty, "*SELECT* 1_15".depl_cytm_eqv_qty_ly, "*SELECT* 1_15".similar_store_depl_cytm_qty_ty, "*SELECT* 1_15".similar_store_depl_cytm_qty_ly, "*SELECT* 1_15".inv_cnt_l30, "*SELECT* 1_15".inv_cnt_l60, "*SELECT* 1_15".inv_cnt_l90, "*SELECT* 1_15".inv_cnt_l120, "*SELECT* 1_15".inv_cnt_l365, "*SELECT* 1_15".inv_cnt_cytm, "*SELECT* 1_15".inv_cnt_cytd, "*SELECT* 1_15".inv_cnt_lcm, "*SELECT* 1_15".inv_cnt_cmip
381. 0.003 570.070 ↑ 30.0 2 1

Append (cost=9.73..172,345.51 rows=60 width=1,585) (actual time=284.565..570.070 rows=2 loops=1)

382. 0.009 284.594 ↑ 58.0 1 1

Subquery Scan on *SELECT* 1_15 (cost=9.73..171,907.49 rows=58 width=1,617) (actual time=284.564..284.594 rows=1 loops=1)

383. 0.018 284.585 ↑ 58.0 1 1

Nested Loop (cost=9.73..171,906.91 rows=58 width=1,617) (actual time=284.557..284.585 rows=1 loops=1)

384. 0.021 284.531 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=284.506..284.531 rows=1 loops=1)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24_30.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_15.brand_cd)::text)
  • Rows Removed by Join Filter: 24
385. 0.010 284.486 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=287) (actual time=284.484..284.486 rows=1 loops=1)

386. 0.019 0.019 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_30 (cost=0.43..120.90 rows=29 width=279) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
387. 0.002 284.457 ↓ 0.0 0 1

Subquery Scan on p_32 (cost=8.87..5,922.79 rows=1 width=12) (actual time=284.457..284.457 rows=0 loops=1)

  • Filter: (((p_32.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_32.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_30.store_src_cd)::text) AND ((p_32.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_30.brand_cd)::text))
388. 0.002 284.455 ↓ 0.0 0 1

Limit (cost=8.87..5,922.78 rows=1 width=12) (actual time=284.455..284.455 rows=0 loops=1)

389. 0.004 284.453 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=284.453..284.453 rows=0 loops=1)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_32.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_45.entity_01_cd)::text)
390. 0.001 284.449 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=284.449..284.449 rows=0 loops=1)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_32.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_17.master_pkg_sku_cd)::text)
391. 284.448 284.448 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_32 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=284.448..284.448 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
392. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

393. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_17 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_30.brand_cd)::text)
394. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

395. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_45 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_30.store_src_cd)::text)
  • Heap Fetches: 0
396. 0.015 0.024 ↑ 1.0 25 1

Materialize (cost=0.00..1.38 rows=25 width=1,032) (actual time=0.009..0.024 rows=25 loops=1)

397. 0.009 0.009 ↑ 1.0 25 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_15 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.003..0.009 rows=25 loops=1)

398. 0.008 0.036 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=310) (actual time=0.034..0.036 rows=1 loops=1)

399. 0.006 0.028 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=310) (actual time=0.027..0.028 rows=1 loops=1)

400. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_35 (cost=0.00..1.01 rows=1 width=128) (actual time=0.002..0.002 rows=1 loops=1)

401. 0.020 0.020 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_49 (cost=0.43..8.47 rows=2 width=182) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
402. 0.005 285.473 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_16 (cost=1.71..438.02 rows=2 width=669) (actual time=285.463..285.473 rows=1 loops=1)

403. 0.023 285.468 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.71..438.00 rows=2 width=669) (actual time=285.459..285.468 rows=1 loops=1)

404. 0.004 0.079 ↑ 2.0 1 1

Nested Loop (cost=1.28..139.10 rows=2 width=661) (actual time=0.071..0.079 rows=1 loops=1)

405. 0.005 0.062 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=487) (actual time=0.058..0.062 rows=1 loops=1)

406. 0.007 0.021 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=423) (actual time=0.018..0.021 rows=1 loops=1)

407. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_36 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

408. 0.012 0.012 ↑ 1.0 1 1

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_16 (cost=0.42..8.44 rows=1 width=295) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
409. 0.004 0.036 ↑ 1.0 1 1

Subquery Scan on fb_15 (cost=0.43..121.14 rows=1 width=72) (actual time=0.035..0.036 rows=1 loops=1)

  • Filter: ((fb_15.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_16.store_src_cd)::text)
410. 0.010 0.032 ↑ 1.0 1 1

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (actual time=0.032..0.032 rows=1 loops=1)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_31.store_src_cd
411. 0.008 0.022 ↑ 29.0 1 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.021..0.022 rows=1 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_16.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
412. 0.014 0.014 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_31 (cost=0.43..120.90 rows=29 width=22) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
413. 0.013 0.013 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_50 (cost=0.43..8.47 rows=2 width=182) (actual time=0.011..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
414. 0.001 285.366 ↓ 0.0 0 1

Subquery Scan on p_33 (cost=0.43..149.40 rows=1 width=8) (actual time=285.366..285.366 rows=0 loops=1)

  • Filter: (((p_33.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_33.store_src_cd)::text = (d_store_2018_12_27_07_01_39_50.store_src_cd)::text))
415. 0.003 285.365 ↓ 0.0 0 1

Limit (cost=0.43..149.39 rows=1 width=8) (actual time=285.365..285.365 rows=0 loops=1)

416. 0.001 285.362 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=285.362..285.362 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_46.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_33.entity_01_cd)::text)
417. 285.361 285.361 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_33 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=285.361..285.361 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
418. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

419. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_46 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_50.store_src_cd)::text)
  • Heap Fetches: 0
420. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_tot_vol_rpt_perf_comps_by_b_rpt_to_cd_brand_cd_idx1 on stores_beer_tot_vol_rpt_perf_comps_by_brand_mv stores_beer_tot_vol_rpt_perf_comps_by_brand_mv_1 (cost=0.29..8.31 rows=1 width=126) (never executed)

  • Index Cond: (((rpt_to_cd)::text = (agg_14.rpt_to_cd)::text) AND ((brand_cd)::text = 'brand_cd'::text))
421. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.72..51.02 rows=2 width=38) (never executed)

  • Group Key: x_store_entity_2018_12_27_07_38_25_47.store_src_cd
422. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..50.96 rows=4 width=38) (never executed)

423. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_47 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Heap Fetches: 0
424. 0.000 0.000 ↓ 0.0 0

Index Scan using d_entity_2018_12_27_07_01_12_entity_01_cd_idx on d_entity_2018_12_27_07_01_12 d_entity_2018_12_27_07_01_12_13 (cost=0.29..8.31 rows=1 width=30) (never executed)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_47.entity_01_cd)::text)
425. 0.002 573.686 ↓ 0.0 0 1

Nested Loop (cost=172,359.12..172,419.29 rows=1 width=232) (actual time=573.686..573.686 rows=0 loops=1)

426. 0.001 573.684 ↓ 0.0 0 1

Nested Loop (cost=172,358.40..172,368.23 rows=1 width=232) (actual time=573.684..573.684 rows=0 loops=1)

427. 0.009 573.683 ↓ 0.0 0 1

Subquery Scan on agg_15 (cost=172,358.11..172,359.91 rows=1 width=188) (actual time=573.683..573.683 rows=0 loops=1)

  • Filter: ((((agg_15.brand_cd)::character varying(30))::text <> 'TOTAL'::text) AND (((agg_15.brand_cd)::character varying(30))::text = 'brand_cd'::text))
  • Rows Removed by Filter: 2
428. 0.034 573.674 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=573.673..573.674 rows=2 loops=1)

  • Group Key: "*SELECT* 1_16".store_src_cd, "*SELECT* 1_16".store_cd, "*SELECT* 1_16".store_name, "*SELECT* 1_16".addr_01_dsc, "*SELECT* 1_16".city_dsc, "*SELECT* 1_16".state_cd, "*SELECT* 1_16".postal_cd, "*SELECT* 1_16".dma_cd, "*SELECT* 1_16".dma_dsc, "*SELECT* 1_16".latitude, "*SELECT* 1_16".longitude, "*SELECT* 1_16".store_number, "*SELECT* 1_16".premise_type_dsc, "*SELECT* 1_16".channel_cd, "*SELECT* 1_16".channel_dsc, "*SELECT* 1_16".ult_parent_cd, "*SELECT* 1_16".ult_parent_dsc, "*SELECT* 1_16".rpt_to_cd, "*SELECT* 1_16".rpt_to_dsc, "*SELECT* 1_16".chain_ind_flg, "*SELECT* 1_16".cbbd_chain_flg, "*SELECT* 1_16".off_premise_sales_priority, ('N'::text), "*SELECT* 1_16".priority_flg, "*SELECT* 1_16".brand_cd, "*SELECT* 1_16".brand_dsc, "*SELECT* 1_16".first_sold_dt, "*SELECT* 1_16".last_sold_dt, "*SELECT* 1_16".risk_flg, "*SELECT* 1_16".new_flg, "*SELECT* 1_16".depl_cytd_eqv_qty_ty, "*SELECT* 1_16".depl_cytd_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_cytd_qty_ty, "*SELECT* 1_16".depl_r365_eqv_qty_ty, "*SELECT* 1_16".depl_r365_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_r365_qty_ty, "*SELECT* 1_16".depl_l30_eqv_qty_ty, "*SELECT* 1_16".depl_l30_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_l30_qty_ty, "*SELECT* 1_16".depl_l90_eqv_qty_ty, "*SELECT* 1_16".depl_l90_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_l90_qty_ty, "*SELECT* 1_16".premise_vol_rank, "*SELECT* 1_16".similar_store_depl_cytd_qty_ly, "*SELECT* 1_16".similar_store_depl_r365_qty_ly, "*SELECT* 1_16".similar_store_depl_l30_qty_ly, "*SELECT* 1_16".similar_store_depl_l90_qty_ly, "*SELECT* 1_16".depl_l60_eqv_qty_ty, "*SELECT* 1_16".depl_l60_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_l60_qty_ty, "*SELECT* 1_16".similar_store_depl_l60_qty_ly, "*SELECT* 1_16".depl_l120_eqv_qty_ty, "*SELECT* 1_16".depl_l120_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_l120_qty_ty, "*SELECT* 1_16".similar_store_depl_l120_qty_ly, "*SELECT* 1_16".depl_lcm_eqv_qty_ty, "*SELECT* 1_16".depl_lcm_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_lcm_qty_ty, "*SELECT* 1_16".similar_store_depl_lcm_qty_ly, "*SELECT* 1_16".depl_cmip_eqv_qty_ty, "*SELECT* 1_16".depl_cmip_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_cmip_qty_ty, "*SELECT* 1_16".similar_store_depl_cmip_qty_ly, "*SELECT* 1_16".depl_cmip2_eqv_qty_ty, "*SELECT* 1_16".depl_cmip2_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_cmip1_qty_ly, "*SELECT* 1_16".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1_16".sim_distribution_l90_ty)::bigint), (("*SELECT* 1_16".sim_distribution_l90_ly)::bigint), (("*SELECT* 1_16".eff_distribution_l90_ty)::bigint), (("*SELECT* 1_16".eff_distribution_l90_ly)::bigint), "*SELECT* 1_16".depl_cytm_eqv_qty_ty, "*SELECT* 1_16".depl_cytm_eqv_qty_ly, "*SELECT* 1_16".similar_store_depl_cytm_qty_ty, "*SELECT* 1_16".similar_store_depl_cytm_qty_ly, "*SELECT* 1_16".inv_cnt_l30, "*SELECT* 1_16".inv_cnt_l60, "*SELECT* 1_16".inv_cnt_l90, "*SELECT* 1_16".inv_cnt_l120, "*SELECT* 1_16".inv_cnt_l365, "*SELECT* 1_16".inv_cnt_cytm, "*SELECT* 1_16".inv_cnt_cytd, "*SELECT* 1_16".inv_cnt_lcm, "*SELECT* 1_16".inv_cnt_cmip
429. 0.005 573.640 ↑ 30.0 2 1

Append (cost=9.73..172,345.51 rows=60 width=1,585) (actual time=285.865..573.640 rows=2 loops=1)

430. 0.008 285.893 ↑ 58.0 1 1

Subquery Scan on *SELECT* 1_16 (cost=9.73..171,907.49 rows=58 width=1,617) (actual time=285.863..285.893 rows=1 loops=1)

431. 0.017 285.885 ↑ 58.0 1 1

Nested Loop (cost=9.73..171,906.91 rows=58 width=1,617) (actual time=285.857..285.885 rows=1 loops=1)

432. 0.011 285.832 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=285.807..285.832 rows=1 loops=1)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24_32.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_16.brand_cd)::text)
  • Rows Removed by Join Filter: 24
433. 0.010 285.788 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=287) (actual time=285.786..285.788 rows=1 loops=1)

434. 0.019 0.019 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_32 (cost=0.43..120.90 rows=29 width=279) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
435. 0.002 285.759 ↓ 0.0 0 1

Subquery Scan on p_34 (cost=8.87..5,922.79 rows=1 width=12) (actual time=285.759..285.759 rows=0 loops=1)

  • Filter: (((p_34.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_34.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_32.store_src_cd)::text) AND ((p_34.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_32.brand_cd)::text))
436. 0.001 285.757 ↓ 0.0 0 1

Limit (cost=8.87..5,922.78 rows=1 width=12) (actual time=285.757..285.757 rows=0 loops=1)

437. 0.004 285.756 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=285.756..285.756 rows=0 loops=1)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_34.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_48.entity_01_cd)::text)
438. 0.003 285.752 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=285.752..285.752 rows=0 loops=1)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_34.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_18.master_pkg_sku_cd)::text)
439. 285.749 285.749 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_34 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=285.749..285.749 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
440. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

441. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_18 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_32.brand_cd)::text)
442. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

443. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_48 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_32.store_src_cd)::text)
  • Heap Fetches: 0
444. 0.017 0.033 ↑ 1.0 25 1

Materialize (cost=0.00..1.38 rows=25 width=1,032) (actual time=0.009..0.033 rows=25 loops=1)

445. 0.016 0.016 ↑ 1.0 25 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_16 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.004..0.016 rows=25 loops=1)

446. 0.007 0.036 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=310) (actual time=0.033..0.036 rows=1 loops=1)

447. 0.006 0.029 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=310) (actual time=0.027..0.029 rows=1 loops=1)

448. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_37 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

449. 0.022 0.022 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_51 (cost=0.43..8.47 rows=2 width=182) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
450. 0.005 287.742 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_17 (cost=1.71..438.02 rows=2 width=669) (actual time=287.731..287.742 rows=1 loops=1)

451. 0.029 287.737 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.71..438.00 rows=2 width=669) (actual time=287.727..287.737 rows=1 loops=1)

452. 0.003 0.078 ↑ 2.0 1 1

Nested Loop (cost=1.28..139.10 rows=2 width=661) (actual time=0.069..0.078 rows=1 loops=1)

453. 0.004 0.061 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=487) (actual time=0.055..0.061 rows=1 loops=1)

454. 0.008 0.021 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=423) (actual time=0.017..0.021 rows=1 loops=1)

455. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_38 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

456. 0.012 0.012 ↑ 1.0 1 1

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_17 (cost=0.42..8.44 rows=1 width=295) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
457. 0.005 0.036 ↑ 1.0 1 1

Subquery Scan on fb_16 (cost=0.43..121.14 rows=1 width=72) (actual time=0.034..0.036 rows=1 loops=1)

  • Filter: ((fb_16.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_17.store_src_cd)::text)
458. 0.009 0.031 ↑ 1.0 1 1

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (actual time=0.031..0.031 rows=1 loops=1)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_33.store_src_cd
459. 0.009 0.022 ↑ 29.0 1 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.021..0.022 rows=1 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_17.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
460. 0.013 0.013 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_33 (cost=0.43..120.90 rows=29 width=22) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
461. 0.014 0.014 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_52 (cost=0.43..8.47 rows=2 width=182) (actual time=0.011..0.014 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
462. 0.001 287.630 ↓ 0.0 0 1

Subquery Scan on p_35 (cost=0.43..149.40 rows=1 width=8) (actual time=287.630..287.630 rows=0 loops=1)

  • Filter: (((p_35.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_35.store_src_cd)::text = (d_store_2018_12_27_07_01_39_52.store_src_cd)::text))
463. 0.003 287.629 ↓ 0.0 0 1

Limit (cost=0.43..149.39 rows=1 width=8) (actual time=287.629..287.629 rows=0 loops=1)

464. 0.002 287.626 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=287.626..287.626 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_49.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_35.entity_01_cd)::text)
465. 287.624 287.624 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_35 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=287.624..287.624 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
466. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

467. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_49 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_52.store_src_cd)::text)
  • Heap Fetches: 0
468. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_tot_vol_ult_perf_comps__ult_parent_cd_brand_cd_idx1 on stores_beer_tot_vol_ult_perf_comps_by_brand_mv stores_beer_tot_vol_ult_perf_comps_by_brand_mv_1 (cost=0.29..8.31 rows=1 width=126) (never executed)

  • Index Cond: (((ult_parent_cd)::text = (agg_15.ult_parent_cd)::text) AND ((brand_cd)::text = 'brand_cd'::text))
469. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.72..51.02 rows=2 width=38) (never executed)

  • Group Key: x_store_entity_2018_12_27_07_38_25_50.store_src_cd
470. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..50.96 rows=4 width=38) (never executed)

471. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_50 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Heap Fetches: 0
472. 0.000 0.000 ↓ 0.0 0

Index Scan using d_entity_2018_12_27_07_01_12_entity_01_cd_idx on d_entity_2018_12_27_07_01_12 d_entity_2018_12_27_07_01_12_14 (cost=0.29..8.31 rows=1 width=30) (never executed)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_50.entity_01_cd)::text)
473. 0.000 0.000 ↓ 0.0 0

Materialize (cost=172,373.58..178,358.05 rows=4 width=660) (never executed)

474. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=172,373.58..178,358.03 rows=4 width=660) (never executed)

475. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=172,372.86..178,306.94 rows=2 width=660) (never executed)

  • Join Filter: (((agg_11.store_src_cd)::text = ("*SELECT* 2_13".tdlinx_store_cd)::text) AND (((agg_11.brand_cd)::character varying(30))::text = ("*SELECT* 2_13".brand_cd)::text))
476. 0.000 0.000 ↓ 0.0 0

Subquery Scan on agg_11 (cost=172,358.11..172,359.61 rows=1 width=480) (never executed)

  • Filter: (((agg_11.brand_cd)::character varying(30))::text = 'brand_cd'::text)
477. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (never executed)

  • Group Key: "*SELECT* 1_17".store_src_cd, "*SELECT* 1_17".store_cd, "*SELECT* 1_17".store_name, "*SELECT* 1_17".addr_01_dsc, "*SELECT* 1_17".city_dsc, "*SELECT* 1_17".state_cd, "*SELECT* 1_17".postal_cd, "*SELECT* 1_17".dma_cd, "*SELECT* 1_17".dma_dsc, "*SELECT* 1_17".latitude, "*SELECT* 1_17".longitude, "*SELECT* 1_17".store_number, "*SELECT* 1_17".premise_type_dsc, "*SELECT* 1_17".channel_cd, "*SELECT* 1_17".channel_dsc, "*SELECT* 1_17".ult_parent_cd, "*SELECT* 1_17".ult_parent_dsc, "*SELECT* 1_17".rpt_to_cd, "*SELECT* 1_17".rpt_to_dsc, "*SELECT* 1_17".chain_ind_flg, "*SELECT* 1_17".cbbd_chain_flg, "*SELECT* 1_17".off_premise_sales_priority, ('N'::text), "*SELECT* 1_17".priority_flg, "*SELECT* 1_17".brand_cd, "*SELECT* 1_17".brand_dsc, "*SELECT* 1_17".first_sold_dt, "*SELECT* 1_17".last_sold_dt, "*SELECT* 1_17".risk_flg, "*SELECT* 1_17".new_flg, "*SELECT* 1_17".depl_cytd_eqv_qty_ty, "*SELECT* 1_17".depl_cytd_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_cytd_qty_ty, "*SELECT* 1_17".depl_r365_eqv_qty_ty, "*SELECT* 1_17".depl_r365_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_r365_qty_ty, "*SELECT* 1_17".depl_l30_eqv_qty_ty, "*SELECT* 1_17".depl_l30_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_l30_qty_ty, "*SELECT* 1_17".depl_l90_eqv_qty_ty, "*SELECT* 1_17".depl_l90_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_l90_qty_ty, "*SELECT* 1_17".premise_vol_rank, "*SELECT* 1_17".similar_store_depl_cytd_qty_ly, "*SELECT* 1_17".similar_store_depl_r365_qty_ly, "*SELECT* 1_17".similar_store_depl_l30_qty_ly, "*SELECT* 1_17".similar_store_depl_l90_qty_ly, "*SELECT* 1_17".depl_l60_eqv_qty_ty, "*SELECT* 1_17".depl_l60_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_l60_qty_ty, "*SELECT* 1_17".similar_store_depl_l60_qty_ly, "*SELECT* 1_17".depl_l120_eqv_qty_ty, "*SELECT* 1_17".depl_l120_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_l120_qty_ty, "*SELECT* 1_17".similar_store_depl_l120_qty_ly, "*SELECT* 1_17".depl_lcm_eqv_qty_ty, "*SELECT* 1_17".depl_lcm_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_lcm_qty_ty, "*SELECT* 1_17".similar_store_depl_lcm_qty_ly, "*SELECT* 1_17".depl_cmip_eqv_qty_ty, "*SELECT* 1_17".depl_cmip_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_cmip_qty_ty, "*SELECT* 1_17".similar_store_depl_cmip_qty_ly, "*SELECT* 1_17".depl_cmip2_eqv_qty_ty, "*SELECT* 1_17".depl_cmip2_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_cmip1_qty_ly, "*SELECT* 1_17".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1_17".sim_distribution_l90_ty)::bigint), (("*SELECT* 1_17".sim_distribution_l90_ly)::bigint), (("*SELECT* 1_17".eff_distribution_l90_ty)::bigint), (("*SELECT* 1_17".eff_distribution_l90_ly)::bigint), "*SELECT* 1_17".depl_cytm_eqv_qty_ty, "*SELECT* 1_17".depl_cytm_eqv_qty_ly, "*SELECT* 1_17".similar_store_depl_cytm_qty_ty, "*SELECT* 1_17".similar_store_depl_cytm_qty_ly, "*SELECT* 1_17".inv_cnt_l30, "*SELECT* 1_17".inv_cnt_l60, "*SELECT* 1_17".inv_cnt_l90, "*SELECT* 1_17".inv_cnt_l120, "*SELECT* 1_17".inv_cnt_l365, "*SELECT* 1_17".inv_cnt_cytm, "*SELECT* 1_17".inv_cnt_cytd, "*SELECT* 1_17".inv_cnt_lcm, "*SELECT* 1_17".inv_cnt_cmip
478. 0.000 0.000 ↓ 0.0 0

Append (cost=9.73..172,345.51 rows=60 width=1,585) (never executed)

479. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_17 (cost=9.73..171,907.49 rows=58 width=1,617) (never executed)

480. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.73..171,906.91 rows=58 width=1,617) (never executed)

481. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (never executed)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24_34.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_17.brand_cd)::text)
482. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=287) (never executed)

483. 0.000 0.000 ↓ 0.0 0

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_34 (cost=0.43..120.90 rows=29 width=279) (never executed)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
484. 0.000 0.000 ↓ 0.0 0

Subquery Scan on p_36 (cost=8.87..5,922.79 rows=1 width=12) (never executed)

  • Filter: (((p_36.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_36.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_34.store_src_cd)::text) AND ((p_36.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_34.brand_cd)::text))
485. 0.000 0.000 ↓ 0.0 0

Limit (cost=8.87..5,922.78 rows=1 width=12) (never executed)

486. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (never executed)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_36.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_51.entity_01_cd)::text)
487. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (never executed)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_36.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_19.master_pkg_sku_cd)::text)
488. 0.000 0.000 ↓ 0.0 0

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_36 (cost=0.00..5,840.38 rows=11,608 width=16) (never executed)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
489. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

490. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_19 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_34.brand_cd)::text)
491. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

492. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_51 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_34.store_src_cd)::text)
  • Heap Fetches: 0
493. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.38 rows=25 width=1,032) (never executed)

494. 0.000 0.000 ↓ 0.0 0

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_17 (cost=0.00..1.25 rows=25 width=1,032) (never executed)

495. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..9.51 rows=2 width=310) (never executed)

496. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..9.50 rows=2 width=310) (never executed)

497. 0.000 0.000 ↓ 0.0 0

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_39 (cost=0.00..1.01 rows=1 width=128) (never executed)

498. 0.000 0.000 ↓ 0.0 0

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_53 (cost=0.43..8.47 rows=2 width=182) (never executed)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
499. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_18 (cost=1.71..438.02 rows=2 width=669) (never executed)

500. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.71..438.00 rows=2 width=669) (never executed)

501. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..139.10 rows=2 width=661) (never executed)

502. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=487) (never executed)

503. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..9.46 rows=1 width=423) (never executed)

504. 0.000 0.000 ↓ 0.0 0

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_40 (cost=0.00..1.01 rows=1 width=128) (never executed)

505. 0.000 0.000 ↓ 0.0 0

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_18 (cost=0.42..8.44 rows=1 width=295) (never executed)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
506. 0.000 0.000 ↓ 0.0 0

Subquery Scan on fb_17 (cost=0.43..121.14 rows=1 width=72) (never executed)

  • Filter: ((fb_17.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_18.store_src_cd)::text)
507. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (never executed)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_35.store_src_cd
508. 0.000 0.000 ↓ 0.0 0

Result (cost=0.43..120.90 rows=29 width=22) (never executed)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_18.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
509. 0.000 0.000 ↓ 0.0 0

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_35 (cost=0.43..120.90 rows=29 width=22) (never executed)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
510. 0.000 0.000 ↓ 0.0 0

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_54 (cost=0.43..8.47 rows=2 width=182) (never executed)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
511. 0.000 0.000 ↓ 0.0 0

Subquery Scan on p_37 (cost=0.43..149.40 rows=1 width=8) (never executed)

  • Filter: (((p_37.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_37.store_src_cd)::text = (d_store_2018_12_27_07_01_39_54.store_src_cd)::text))
512. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.43..149.39 rows=1 width=8) (never executed)

513. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (never executed)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_52.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_37.entity_01_cd)::text)
514. 0.000 0.000 ↓ 0.0 0

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_37 (cost=0.00..5,840.38 rows=11,608 width=7) (never executed)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
515. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

516. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_52 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_54.store_src_cd)::text)
  • Heap Fetches: 0
517. 0.000 0.000 ↓ 0.0 0

Append (cost=14.75..5,947.30 rows=2 width=266) (never executed)

518. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_13 (cost=14.75..5,947.30 rows=2 width=266) (never executed)

519. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=14.75..5,947.28 rows=2 width=560) (never executed)

520.          

Initplan (forNested Loop)

521. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.01 rows=1 width=32) (never executed)

522. 0.000 0.000 ↓ 0.0 0

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_30 (cost=0.00..1.01 rows=1 width=32) (never executed)

523. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=13.32..5,937.67 rows=1 width=560) (never executed)

524. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.44..14.87 rows=1 width=564) (never executed)

525. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.39 rows=1 width=516) (never executed)

526. 0.000 0.000 ↓ 0.0 0

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_41 (cost=0.00..1.01 rows=1 width=0) (never executed)

527. 0.000 0.000 ↓ 0.0 0

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_18 (cost=0.00..1.38 rows=1 width=516) (never executed)

  • Filter: (((brand_cd)::character varying(30))::text = 'brand_cd'::text)
528. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_36 (cost=4.44..12.45 rows=2 width=48) (never executed)

  • Recheck Cond: (((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_18.brand_cd)::text))
529. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on f_store_brand_agg_2018_12_27_07_29_24_pk (cost=0.00..4.44 rows=2 width=0) (never executed)

  • Index Cond: (((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_18.brand_cd)::text))
530. 0.000 0.000 ↓ 0.0 0

Subquery Scan on p_38 (cost=8.87..5,922.79 rows=1 width=12) (never executed)

  • Filter: (((p_38.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p_38.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_36.store_src_cd)::text) AND ((p_38.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_36.brand_cd)::text))
531. 0.000 0.000 ↓ 0.0 0

Limit (cost=8.87..5,922.78 rows=1 width=12) (never executed)

532. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (never executed)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_38.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_53.entity_01_cd)::text)
533. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (never executed)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_38.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_20.master_pkg_sku_cd)::text)
534. 0.000 0.000 ↓ 0.0 0

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_38 (cost=0.00..5,840.38 rows=11,608 width=16) (never executed)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
535. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

536. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_20 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_36.brand_cd)::text)
537. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

538. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_53 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_36.store_src_cd)::text)
  • Heap Fetches: 0
539. 0.000 0.000 ↓ 0.0 0

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_55 (cost=0.43..8.47 rows=2 width=8) (never executed)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
540. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.72..51.05 rows=2 width=8) (never executed)

541. 0.000 0.000 ↓ 0.0 0

Subquery Scan on dist_1 (cost=0.72..51.04 rows=2 width=8) (never executed)

542. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.72..51.02 rows=2 width=38) (never executed)

  • Group Key: x_store_entity_2018_12_27_07_38_25_54.store_src_cd
543. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..50.96 rows=4 width=38) (never executed)

544. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_54 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Heap Fetches: 0
545. 0.000 0.000 ↓ 0.0 0

Index Scan using d_entity_2018_12_27_07_01_12_entity_01_cd_idx on d_entity_2018_12_27_07_01_12 d_entity_2018_12_27_07_01_12_15 (cost=0.29..8.31 rows=1 width=30) (never executed)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_54.entity_01_cd)::text)
546. 0.002 2,355.928 ↑ 2.0 1 1

Subquery Scan on bp (cost=0.98..1,379,900.90 rows=2 width=32) (actual time=2,355.927..2,355.928 rows=1 loops=1)

547. 0.087 2,355.926 ↑ 2.0 1 1

GroupAggregate (cost=0.98..1,379,900.88 rows=2 width=77) (actual time=2,355.925..2,355.926 rows=1 loops=1)

  • Group Key: f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd, 'brand_cd'::character varying(30)
548. 0.007 0.048 ↑ 250.0 1 1

Nested Loop (cost=0.98..518.10 rows=250 width=77) (actual time=0.046..0.048 rows=1 loops=1)

549. 0.021 0.021 ↑ 125.0 1 1

Index Scan using f_store_sku_pkg_agg_2018_12_27_07_28_06_pk on f_store_sku_pkg_agg_2018_12_27_07_28_06 f_store_sku_pkg_agg_2018_12_27_07_28_06_16 (cost=0.56..506.51 rows=125 width=77) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
550. 0.004 0.020 ↑ 2.0 1 1

Materialize (cost=0.43..8.48 rows=2 width=8) (actual time=0.019..0.020 rows=1 loops=1)

551. 0.016 0.016 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_64 (cost=0.43..8.47 rows=2 width=8) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
552.          

SubPlan (forGroupAggregate)

553. 0.001 2,355.791 ↓ 0.0 0 1

Subquery Scan on pc_1 (cost=172,359.39..689,674.45 rows=5 width=32) (actual time=2,355.791..2,355.791 rows=0 loops=1)

554. 0.003 2,355.790 ↓ 0.0 0 1

GroupAggregate (cost=172,359.39..689,674.40 rows=5 width=188) (actual time=2,355.790..2,355.790 rows=0 loops=1)

  • Group Key: agg_16.store_src_cd, ((agg_16.brand_cd)::character varying(30))
555. 0.007 2,355.787 ↓ 0.0 0 1

Append (cost=172,359.39..689,674.30 rows=5 width=188) (actual time=2,355.787..2,355.787 rows=0 loops=1)

556. 0.002 598.269 ↓ 0.0 0 1

Nested Loop (cost=172,359.39..172,417.13 rows=2 width=142) (actual time=598.269..598.269 rows=0 loops=1)

557. 0.001 598.267 ↓ 0.0 0 1

Nested Loop (cost=172,358.67..172,366.07 rows=1 width=142) (actual time=598.267..598.267 rows=0 loops=1)

558. 0.006 598.266 ↓ 0.0 0 1

Subquery Scan on agg_16 (cost=172,358.11..172,359.61 rows=1 width=110) (actual time=598.266..598.266 rows=0 loops=1)

  • Filter: (((agg_16.brand_cd)::character varying(30))::text = 'brand_cd'::text)
  • Rows Removed by Filter: 2
559. 0.038 598.260 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=598.258..598.260 rows=2 loops=1)

  • Group Key: "*SELECT* 1_18".store_src_cd, "*SELECT* 1_18".store_cd, "*SELECT* 1_18".store_name, "*SELECT* 1_18".addr_01_dsc, "*SELECT* 1_18".city_dsc, "*SELECT* 1_18".state_cd, "*SELECT* 1_18".postal_cd, "*SELECT* 1_18".dma_cd, "*SELECT* 1_18".dma_dsc, "*SELECT* 1_18".latitude, "*SELECT* 1_18".longitude, "*SELECT* 1_18".store_number, "*SELECT* 1_18".premise_type_dsc, "*SELECT* 1_18".channel_cd, "*SELECT* 1_18".channel_dsc, "*SELECT* 1_18".ult_parent_cd, "*SELECT* 1_18".ult_parent_dsc, "*SELECT* 1_18".rpt_to_cd, "*SELECT* 1_18".rpt_to_dsc, "*SELECT* 1_18".chain_ind_flg, "*SELECT* 1_18".cbbd_chain_flg, "*SELECT* 1_18".off_premise_sales_priority, ('N'::text), "*SELECT* 1_18".priority_flg, "*SELECT* 1_18".brand_cd, "*SELECT* 1_18".brand_dsc, "*SELECT* 1_18".first_sold_dt, "*SELECT* 1_18".last_sold_dt, "*SELECT* 1_18".risk_flg, "*SELECT* 1_18".new_flg, "*SELECT* 1_18".depl_cytd_eqv_qty_ty, "*SELECT* 1_18".depl_cytd_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_cytd_qty_ty, "*SELECT* 1_18".depl_r365_eqv_qty_ty, "*SELECT* 1_18".depl_r365_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_r365_qty_ty, "*SELECT* 1_18".depl_l30_eqv_qty_ty, "*SELECT* 1_18".depl_l30_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_l30_qty_ty, "*SELECT* 1_18".depl_l90_eqv_qty_ty, "*SELECT* 1_18".depl_l90_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_l90_qty_ty, "*SELECT* 1_18".premise_vol_rank, "*SELECT* 1_18".similar_store_depl_cytd_qty_ly, "*SELECT* 1_18".similar_store_depl_r365_qty_ly, "*SELECT* 1_18".similar_store_depl_l30_qty_ly, "*SELECT* 1_18".similar_store_depl_l90_qty_ly, "*SELECT* 1_18".depl_l60_eqv_qty_ty, "*SELECT* 1_18".depl_l60_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_l60_qty_ty, "*SELECT* 1_18".similar_store_depl_l60_qty_ly, "*SELECT* 1_18".depl_l120_eqv_qty_ty, "*SELECT* 1_18".depl_l120_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_l120_qty_ty, "*SELECT* 1_18".similar_store_depl_l120_qty_ly, "*SELECT* 1_18".depl_lcm_eqv_qty_ty, "*SELECT* 1_18".depl_lcm_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_lcm_qty_ty, "*SELECT* 1_18".similar_store_depl_lcm_qty_ly, "*SELECT* 1_18".depl_cmip_eqv_qty_ty, "*SELECT* 1_18".depl_cmip_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_cmip_qty_ty, "*SELECT* 1_18".similar_store_depl_cmip_qty_ly, "*SELECT* 1_18".depl_cmip2_eqv_qty_ty, "*SELECT* 1_18".depl_cmip2_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_cmip1_qty_ly, "*SELECT* 1_18".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1_18".sim_distribution_l90_ty)::bigint), (("*SELECT* 1_18".sim_distribution_l90_ly)::bigint), (("*SELECT* 1_18".eff_distribution_l90_ty)::bigint), (("*SELECT* 1_18".eff_distribution_l90_ly)::bigint), "*SELECT* 1_18".depl_cytm_eqv_qty_ty, "*SELECT* 1_18".depl_cytm_eqv_qty_ly, "*SELECT* 1_18".similar_store_depl_cytm_qty_ty, "*SELECT* 1_18".similar_store_depl_cytm_qty_ly, "*SELECT* 1_18".inv_cnt_l30, "*SELECT* 1_18".inv_cnt_l60, "*SELECT* 1_18".inv_cnt_l90, "*SELECT* 1_18".inv_cnt_l120, "*SELECT* 1_18".inv_cnt_l365, "*SELECT* 1_18".inv_cnt_cytm, "*SELECT* 1_18".inv_cnt_cytd, "*SELECT* 1_18".inv_cnt_lcm, "*SELECT* 1_18".inv_cnt_cmip
560. 0.006 598.222 ↑ 30.0 2 1

Append (cost=9.73..172,345.51 rows=60 width=1,585) (actual time=299.495..598.222 rows=2 loops=1)

561. 0.006 299.523 ↑ 58.0 1 1

Subquery Scan on *SELECT* 1_18 (cost=9.73..171,907.49 rows=58 width=1,617) (actual time=299.494..299.523 rows=1 loops=1)

562. 0.015 299.517 ↑ 58.0 1 1

Nested Loop (cost=9.73..171,906.91 rows=58 width=1,617) (actual time=299.488..299.517 rows=1 loops=1)

563. 0.012 299.468 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=299.442..299.468 rows=1 loops=1)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24_37.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_19.brand_cd)::text)
  • Rows Removed by Join Filter: 24
564. 0.007 299.422 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=287) (actual time=299.421..299.422 rows=1 loops=1)

565. 0.015 0.015 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_37 (cost=0.43..120.90 rows=29 width=279) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
566. 0.002 299.400 ↓ 0.0 0 1

Subquery Scan on p_39 (cost=8.87..5,922.79 rows=1 width=12) (actual time=299.400..299.400 rows=0 loops=1)

  • Filter: (((p_39.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text) AND ((p_39.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_37.store_src_cd)::text) AND ((p_39.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_37.brand_cd)::text))
567. 0.001 299.398 ↓ 0.0 0 1

Limit (cost=8.87..5,922.78 rows=1 width=12) (actual time=299.398..299.398 rows=0 loops=1)

568. 0.004 299.397 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=299.397..299.397 rows=0 loops=1)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_39.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_55.entity_01_cd)::text)
569. 0.002 299.393 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=299.393..299.393 rows=0 loops=1)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_39.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_21.master_pkg_sku_cd)::text)
570. 299.391 299.391 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_39 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=299.391..299.391 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
571. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

572. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_21 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_37.brand_cd)::text)
573. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

574. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_55 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_37.store_src_cd)::text)
  • Heap Fetches: 0
575. 0.022 0.034 ↑ 1.0 25 1

Materialize (cost=0.00..1.38 rows=25 width=1,032) (actual time=0.009..0.034 rows=25 loops=1)

576. 0.012 0.012 ↑ 1.0 25 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_19 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.003..0.012 rows=25 loops=1)

577. 0.008 0.034 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=310) (actual time=0.031..0.034 rows=1 loops=1)

578. 0.005 0.026 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=310) (actual time=0.024..0.026 rows=1 loops=1)

579. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_42 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

580. 0.020 0.020 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_56 (cost=0.43..8.47 rows=2 width=182) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
581. 0.003 298.693 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_19 (cost=1.71..438.02 rows=2 width=669) (actual time=298.684..298.693 rows=1 loops=1)

582. 0.025 298.690 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.71..438.00 rows=2 width=669) (actual time=298.681..298.690 rows=1 loops=1)

583. 0.004 0.077 ↑ 2.0 1 1

Nested Loop (cost=1.28..139.10 rows=2 width=661) (actual time=0.069..0.077 rows=1 loops=1)

584. 0.004 0.060 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=487) (actual time=0.055..0.060 rows=1 loops=1)

585. 0.008 0.021 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=423) (actual time=0.018..0.021 rows=1 loops=1)

586. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_43 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

587. 0.012 0.012 ↑ 1.0 1 1

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_19 (cost=0.42..8.44 rows=1 width=295) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
588. 0.004 0.035 ↑ 1.0 1 1

Subquery Scan on fb_18 (cost=0.43..121.14 rows=1 width=72) (actual time=0.034..0.035 rows=1 loops=1)

  • Filter: ((fb_18.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_19.store_src_cd)::text)
589. 0.011 0.031 ↑ 1.0 1 1

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (actual time=0.030..0.031 rows=1 loops=1)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_38.store_src_cd
590. 0.006 0.020 ↑ 29.0 1 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.019..0.020 rows=1 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_19.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
591. 0.014 0.014 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_38 (cost=0.43..120.90 rows=29 width=22) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
592. 0.013 0.013 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_57 (cost=0.43..8.47 rows=2 width=182) (actual time=0.010..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
593. 0.001 298.588 ↓ 0.0 0 1

Subquery Scan on p_40 (cost=0.43..149.40 rows=1 width=8) (actual time=298.588..298.588 rows=0 loops=1)

  • Filter: (((p_40.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text) AND ((p_40.store_src_cd)::text = (d_store_2018_12_27_07_01_39_57.store_src_cd)::text))
594. 0.003 298.587 ↓ 0.0 0 1

Limit (cost=0.43..149.39 rows=1 width=8) (actual time=298.587..298.587 rows=0 loops=1)

595. 0.001 298.584 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=298.584..298.584 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_56.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_40.entity_01_cd)::text)
596. 298.583 298.583 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_40 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=298.583..298.583 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
597. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

598. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_56 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_57.store_src_cd)::text)
  • Heap Fetches: 0
599. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.56..6.44 rows=1 width=66) (never executed)

  • Group Key: stores_beer_sim_tot_velocity_by_sku_brand_mv_2.tdlinx_store_cd, stores_beer_sim_tot_velocity_by_sku_brand_mv_2.brand_cd
600. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_sim_tot_velocity__tdlinx_store_cd_brand_cd_mast_idx on stores_beer_sim_tot_velocity_by_sku_brand_mv stores_beer_sim_tot_velocity_by_sku_brand_mv_2 (cost=0.56..6.33 rows=1 width=66) (never executed)

  • Index Cond: (((tdlinx_store_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text) AND ((brand_cd)::text = 'brand_cd'::text))
601. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.72..51.02 rows=2 width=38) (never executed)

  • Group Key: x_store_entity_2018_12_27_07_38_25_57.store_src_cd
602. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..50.96 rows=4 width=38) (never executed)

603. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_57 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
  • Heap Fetches: 0
604. 0.000 0.000 ↓ 0.0 0

Index Scan using d_entity_2018_12_27_07_01_12_entity_01_cd_idx on d_entity_2018_12_27_07_01_12 d_entity_2018_12_27_07_01_12_16 (cost=0.29..8.31 rows=1 width=30) (never executed)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_57.entity_01_cd)::text)
605. 0.002 582.910 ↓ 0.0 0 1

Nested Loop (cost=172,359.25..172,419.13 rows=1 width=187) (actual time=582.910..582.910 rows=0 loops=1)

606. 0.001 582.908 ↓ 0.0 0 1

Nested Loop (cost=172,358.53..172,368.07 rows=1 width=187) (actual time=582.908..582.908 rows=0 loops=1)

607. 0.005 582.907 ↓ 0.0 0 1

Subquery Scan on agg_17 (cost=172,358.11..172,359.61 rows=1 width=220) (actual time=582.907..582.907 rows=0 loops=1)

  • Filter: (((agg_17.brand_cd)::character varying(30))::text = 'brand_cd'::text)
  • Rows Removed by Filter: 2
608. 0.034 582.902 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=582.900..582.902 rows=2 loops=1)

  • Group Key: "*SELECT* 1_19".store_src_cd, "*SELECT* 1_19".store_cd, "*SELECT* 1_19".store_name, "*SELECT* 1_19".addr_01_dsc, "*SELECT* 1_19".city_dsc, "*SELECT* 1_19".state_cd, "*SELECT* 1_19".postal_cd, "*SELECT* 1_19".dma_cd, "*SELECT* 1_19".dma_dsc, "*SELECT* 1_19".latitude, "*SELECT* 1_19".longitude, "*SELECT* 1_19".store_number, "*SELECT* 1_19".premise_type_dsc, "*SELECT* 1_19".channel_cd, "*SELECT* 1_19".channel_dsc, "*SELECT* 1_19".ult_parent_cd, "*SELECT* 1_19".ult_parent_dsc, "*SELECT* 1_19".rpt_to_cd, "*SELECT* 1_19".rpt_to_dsc, "*SELECT* 1_19".chain_ind_flg, "*SELECT* 1_19".cbbd_chain_flg, "*SELECT* 1_19".off_premise_sales_priority, ('N'::text), "*SELECT* 1_19".priority_flg, "*SELECT* 1_19".brand_cd, "*SELECT* 1_19".brand_dsc, "*SELECT* 1_19".first_sold_dt, "*SELECT* 1_19".last_sold_dt, "*SELECT* 1_19".risk_flg, "*SELECT* 1_19".new_flg, "*SELECT* 1_19".depl_cytd_eqv_qty_ty, "*SELECT* 1_19".depl_cytd_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_cytd_qty_ty, "*SELECT* 1_19".depl_r365_eqv_qty_ty, "*SELECT* 1_19".depl_r365_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_r365_qty_ty, "*SELECT* 1_19".depl_l30_eqv_qty_ty, "*SELECT* 1_19".depl_l30_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_l30_qty_ty, "*SELECT* 1_19".depl_l90_eqv_qty_ty, "*SELECT* 1_19".depl_l90_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_l90_qty_ty, "*SELECT* 1_19".premise_vol_rank, "*SELECT* 1_19".similar_store_depl_cytd_qty_ly, "*SELECT* 1_19".similar_store_depl_r365_qty_ly, "*SELECT* 1_19".similar_store_depl_l30_qty_ly, "*SELECT* 1_19".similar_store_depl_l90_qty_ly, "*SELECT* 1_19".depl_l60_eqv_qty_ty, "*SELECT* 1_19".depl_l60_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_l60_qty_ty, "*SELECT* 1_19".similar_store_depl_l60_qty_ly, "*SELECT* 1_19".depl_l120_eqv_qty_ty, "*SELECT* 1_19".depl_l120_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_l120_qty_ty, "*SELECT* 1_19".similar_store_depl_l120_qty_ly, "*SELECT* 1_19".depl_lcm_eqv_qty_ty, "*SELECT* 1_19".depl_lcm_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_lcm_qty_ty, "*SELECT* 1_19".similar_store_depl_lcm_qty_ly, "*SELECT* 1_19".depl_cmip_eqv_qty_ty, "*SELECT* 1_19".depl_cmip_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_cmip_qty_ty, "*SELECT* 1_19".similar_store_depl_cmip_qty_ly, "*SELECT* 1_19".depl_cmip2_eqv_qty_ty, "*SELECT* 1_19".depl_cmip2_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_cmip1_qty_ly, "*SELECT* 1_19".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1_19".sim_distribution_l90_ty)::bigint), (("*SELECT* 1_19".sim_distribution_l90_ly)::bigint), (("*SELECT* 1_19".eff_distribution_l90_ty)::bigint), (("*SELECT* 1_19".eff_distribution_l90_ly)::bigint), "*SELECT* 1_19".depl_cytm_eqv_qty_ty, "*SELECT* 1_19".depl_cytm_eqv_qty_ly, "*SELECT* 1_19".similar_store_depl_cytm_qty_ty, "*SELECT* 1_19".similar_store_depl_cytm_qty_ly, "*SELECT* 1_19".inv_cnt_l30, "*SELECT* 1_19".inv_cnt_l60, "*SELECT* 1_19".inv_cnt_l90, "*SELECT* 1_19".inv_cnt_l120, "*SELECT* 1_19".inv_cnt_l365, "*SELECT* 1_19".inv_cnt_cytm, "*SELECT* 1_19".inv_cnt_cytd, "*SELECT* 1_19".inv_cnt_lcm, "*SELECT* 1_19".inv_cnt_cmip
609. 0.005 582.868 ↑ 30.0 2 1

Append (cost=9.73..172,345.51 rows=60 width=1,585) (actual time=293.121..582.868 rows=2 loops=1)

610. 0.006 293.148 ↑ 58.0 1 1

Subquery Scan on *SELECT* 1_19 (cost=9.73..171,907.49 rows=58 width=1,617) (actual time=293.120..293.148 rows=1 loops=1)

611. 0.017 293.142 ↑ 58.0 1 1

Nested Loop (cost=9.73..171,906.91 rows=58 width=1,617) (actual time=293.114..293.142 rows=1 loops=1)

612. 0.010 293.091 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=293.066..293.091 rows=1 loops=1)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24_39.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_20.brand_cd)::text)
  • Rows Removed by Join Filter: 24
613. 0.010 293.049 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=287) (actual time=293.047..293.049 rows=1 loops=1)

614. 0.019 0.019 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_39 (cost=0.43..120.90 rows=29 width=279) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
615. 0.001 293.020 ↓ 0.0 0 1

Subquery Scan on p_41 (cost=8.87..5,922.79 rows=1 width=12) (actual time=293.020..293.020 rows=0 loops=1)

  • Filter: (((p_41.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text) AND ((p_41.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_39.store_src_cd)::text) AND ((p_41.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_39.brand_cd)::text))
616. 0.002 293.019 ↓ 0.0 0 1

Limit (cost=8.87..5,922.78 rows=1 width=12) (actual time=293.019..293.019 rows=0 loops=1)

617. 0.004 293.017 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=293.017..293.017 rows=0 loops=1)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_41.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_58.entity_01_cd)::text)
618. 0.001 293.013 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=293.013..293.013 rows=0 loops=1)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_41.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_22.master_pkg_sku_cd)::text)
619. 293.012 293.012 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_41 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=293.012..293.012 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
620. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

621. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_22 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_39.brand_cd)::text)
622. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

623. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_58 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_39.store_src_cd)::text)
  • Heap Fetches: 0
624. 0.016 0.032 ↑ 1.0 25 1

Materialize (cost=0.00..1.38 rows=25 width=1,032) (actual time=0.007..0.032 rows=25 loops=1)

625. 0.016 0.016 ↑ 1.0 25 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_20 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.003..0.016 rows=25 loops=1)

626. 0.007 0.034 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=310) (actual time=0.032..0.034 rows=1 loops=1)

627. 0.005 0.027 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=310) (actual time=0.025..0.027 rows=1 loops=1)

628. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_44 (cost=0.00..1.01 rows=1 width=128) (actual time=0.002..0.002 rows=1 loops=1)

629. 0.020 0.020 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_58 (cost=0.43..8.47 rows=2 width=182) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
630. 0.003 289.715 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_20 (cost=1.71..438.02 rows=2 width=669) (actual time=289.707..289.715 rows=1 loops=1)

631. 0.022 289.712 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.71..438.00 rows=2 width=669) (actual time=289.705..289.712 rows=1 loops=1)

632. 0.005 0.076 ↑ 2.0 1 1

Nested Loop (cost=1.28..139.10 rows=2 width=661) (actual time=0.069..0.076 rows=1 loops=1)

633. 0.004 0.059 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=487) (actual time=0.054..0.059 rows=1 loops=1)

634. 0.009 0.021 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=423) (actual time=0.018..0.021 rows=1 loops=1)

635. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_45 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

636. 0.011 0.011 ↑ 1.0 1 1

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_20 (cost=0.42..8.44 rows=1 width=295) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
637. 0.003 0.034 ↑ 1.0 1 1

Subquery Scan on fb_19 (cost=0.43..121.14 rows=1 width=72) (actual time=0.033..0.034 rows=1 loops=1)

  • Filter: ((fb_19.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_20.store_src_cd)::text)
638. 0.012 0.031 ↑ 1.0 1 1

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (actual time=0.030..0.031 rows=1 loops=1)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_40.store_src_cd
639. 0.007 0.019 ↑ 29.0 1 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.019..0.019 rows=1 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_20.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
640. 0.012 0.012 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_40 (cost=0.43..120.90 rows=29 width=22) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
641. 0.012 0.012 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_59 (cost=0.43..8.47 rows=2 width=182) (actual time=0.010..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
642. 0.002 289.614 ↓ 0.0 0 1

Subquery Scan on p_42 (cost=0.43..149.40 rows=1 width=8) (actual time=289.614..289.614 rows=0 loops=1)

  • Filter: (((p_42.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text) AND ((p_42.store_src_cd)::text = (d_store_2018_12_27_07_01_39_59.store_src_cd)::text))
643. 0.002 289.612 ↓ 0.0 0 1

Limit (cost=0.43..149.39 rows=1 width=8) (actual time=289.612..289.612 rows=0 loops=1)

644. 0.001 289.610 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=289.610..289.610 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_59.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_42.entity_01_cd)::text)
645. 289.609 289.609 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_42 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=289.609..289.609 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
646. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

647. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_59 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_59.store_src_cd)::text)
  • Heap Fetches: 0
648. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_dma_tot_velocity_by_b_dma_cd_rpt_to_cd_brand_cd_idx on stores_beer_dma_tot_velocity_by_brand_mv (cost=0.42..8.45 rows=1 width=87) (never executed)

  • Index Cond: (((dma_cd)::text = ((agg_17.dma_cd)::character varying(30))::text) AND ((rpt_to_cd)::text = (agg_17.rpt_to_cd)::text) AND ((brand_cd)::text = 'brand_cd'::text))
649. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.72..51.02 rows=2 width=38) (never executed)

  • Group Key: x_store_entity_2018_12_27_07_38_25_60.store_src_cd
650. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..50.96 rows=4 width=38) (never executed)

651. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_60 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
  • Heap Fetches: 0
652. 0.000 0.000 ↓ 0.0 0

Index Scan using d_entity_2018_12_27_07_01_12_entity_01_cd_idx on d_entity_2018_12_27_07_01_12 d_entity_2018_12_27_07_01_12_17 (cost=0.29..8.31 rows=1 width=30) (never executed)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_60.entity_01_cd)::text)
653. 0.002 590.816 ↓ 0.0 0 1

Nested Loop (cost=172,359.12..172,419.00 rows=1 width=191) (actual time=590.816..590.816 rows=0 loops=1)

654. 0.001 590.814 ↓ 0.0 0 1

Nested Loop (cost=172,358.40..172,367.93 rows=1 width=191) (actual time=590.814..590.814 rows=0 loops=1)

655. 0.004 590.813 ↓ 0.0 0 1

Subquery Scan on agg_18 (cost=172,358.11..172,359.61 rows=1 width=188) (actual time=590.813..590.813 rows=0 loops=1)

  • Filter: (((agg_18.brand_cd)::character varying(30))::text = 'brand_cd'::text)
  • Rows Removed by Filter: 2
656. 0.037 590.809 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=590.806..590.809 rows=2 loops=1)

  • Group Key: "*SELECT* 1_20".store_src_cd, "*SELECT* 1_20".store_cd, "*SELECT* 1_20".store_name, "*SELECT* 1_20".addr_01_dsc, "*SELECT* 1_20".city_dsc, "*SELECT* 1_20".state_cd, "*SELECT* 1_20".postal_cd, "*SELECT* 1_20".dma_cd, "*SELECT* 1_20".dma_dsc, "*SELECT* 1_20".latitude, "*SELECT* 1_20".longitude, "*SELECT* 1_20".store_number, "*SELECT* 1_20".premise_type_dsc, "*SELECT* 1_20".channel_cd, "*SELECT* 1_20".channel_dsc, "*SELECT* 1_20".ult_parent_cd, "*SELECT* 1_20".ult_parent_dsc, "*SELECT* 1_20".rpt_to_cd, "*SELECT* 1_20".rpt_to_dsc, "*SELECT* 1_20".chain_ind_flg, "*SELECT* 1_20".cbbd_chain_flg, "*SELECT* 1_20".off_premise_sales_priority, ('N'::text), "*SELECT* 1_20".priority_flg, "*SELECT* 1_20".brand_cd, "*SELECT* 1_20".brand_dsc, "*SELECT* 1_20".first_sold_dt, "*SELECT* 1_20".last_sold_dt, "*SELECT* 1_20".risk_flg, "*SELECT* 1_20".new_flg, "*SELECT* 1_20".depl_cytd_eqv_qty_ty, "*SELECT* 1_20".depl_cytd_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_cytd_qty_ty, "*SELECT* 1_20".depl_r365_eqv_qty_ty, "*SELECT* 1_20".depl_r365_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_r365_qty_ty, "*SELECT* 1_20".depl_l30_eqv_qty_ty, "*SELECT* 1_20".depl_l30_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_l30_qty_ty, "*SELECT* 1_20".depl_l90_eqv_qty_ty, "*SELECT* 1_20".depl_l90_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_l90_qty_ty, "*SELECT* 1_20".premise_vol_rank, "*SELECT* 1_20".similar_store_depl_cytd_qty_ly, "*SELECT* 1_20".similar_store_depl_r365_qty_ly, "*SELECT* 1_20".similar_store_depl_l30_qty_ly, "*SELECT* 1_20".similar_store_depl_l90_qty_ly, "*SELECT* 1_20".depl_l60_eqv_qty_ty, "*SELECT* 1_20".depl_l60_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_l60_qty_ty, "*SELECT* 1_20".similar_store_depl_l60_qty_ly, "*SELECT* 1_20".depl_l120_eqv_qty_ty, "*SELECT* 1_20".depl_l120_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_l120_qty_ty, "*SELECT* 1_20".similar_store_depl_l120_qty_ly, "*SELECT* 1_20".depl_lcm_eqv_qty_ty, "*SELECT* 1_20".depl_lcm_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_lcm_qty_ty, "*SELECT* 1_20".similar_store_depl_lcm_qty_ly, "*SELECT* 1_20".depl_cmip_eqv_qty_ty, "*SELECT* 1_20".depl_cmip_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_cmip_qty_ty, "*SELECT* 1_20".similar_store_depl_cmip_qty_ly, "*SELECT* 1_20".depl_cmip2_eqv_qty_ty, "*SELECT* 1_20".depl_cmip2_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_cmip1_qty_ly, "*SELECT* 1_20".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1_20".sim_distribution_l90_ty)::bigint), (("*SELECT* 1_20".sim_distribution_l90_ly)::bigint), (("*SELECT* 1_20".eff_distribution_l90_ty)::bigint), (("*SELECT* 1_20".eff_distribution_l90_ly)::bigint), "*SELECT* 1_20".depl_cytm_eqv_qty_ty, "*SELECT* 1_20".depl_cytm_eqv_qty_ly, "*SELECT* 1_20".similar_store_depl_cytm_qty_ty, "*SELECT* 1_20".similar_store_depl_cytm_qty_ly, "*SELECT* 1_20".inv_cnt_l30, "*SELECT* 1_20".inv_cnt_l60, "*SELECT* 1_20".inv_cnt_l90, "*SELECT* 1_20".inv_cnt_l120, "*SELECT* 1_20".inv_cnt_l365, "*SELECT* 1_20".inv_cnt_cytm, "*SELECT* 1_20".inv_cnt_cytd, "*SELECT* 1_20".inv_cnt_lcm, "*SELECT* 1_20".inv_cnt_cmip
657. 0.004 590.772 ↑ 30.0 2 1

Append (cost=9.73..172,345.51 rows=60 width=1,585) (actual time=294.471..590.772 rows=2 loops=1)

658. 0.007 294.498 ↑ 58.0 1 1

Subquery Scan on *SELECT* 1_20 (cost=9.73..171,907.49 rows=58 width=1,617) (actual time=294.470..294.498 rows=1 loops=1)

659. 0.016 294.491 ↑ 58.0 1 1

Nested Loop (cost=9.73..171,906.91 rows=58 width=1,617) (actual time=294.463..294.491 rows=1 loops=1)

660. 0.010 294.440 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=294.415..294.440 rows=1 loops=1)

  • Join Filter: ((f_store_brand_agg_2018_12_27_07_29_24_41.brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_21.brand_cd)::text)
  • Rows Removed by Join Filter: 24
661. 0.009 294.398 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=287) (actual time=294.396..294.398 rows=1 loops=1)

662. 0.018 0.018 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_41 (cost=0.43..120.90 rows=29 width=279) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
663. 0.001 294.371 ↓ 0.0 0 1

Subquery Scan on p_43 (cost=8.87..5,922.79 rows=1 width=12) (actual time=294.371..294.371 rows=0 loops=1)

  • Filter: (((p_43.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text) AND ((p_43.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_41.store_src_cd)::text) AND ((p_43.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_41.brand_cd)::text))
664. 0.002 294.370 ↓ 0.0 0 1

Limit (cost=8.87..5,922.78 rows=1 width=12) (actual time=294.370..294.370 rows=0 loops=1)

665. 0.004 294.368 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=294.368..294.368 rows=0 loops=1)

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_43.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_61.entity_01_cd)::text)
666. 0.002 294.364 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=294.364..294.364 rows=0 loops=1)

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_43.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_23.master_pkg_sku_cd)::text)
667. 294.362 294.362 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_43 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=294.362..294.362 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
668. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.32..8.32 rows=10 width=13) (never executed)

669. 0.000 0.000 ↓ 0.0 0

Index Scan using d_item_sku_pkg_2018_12_27_07_05_22_brand_cd_idx on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_23 (cost=0.14..8.32 rows=10 width=13) (never executed)

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_41.brand_cd)::text)
670. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

671. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_61 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_41.store_src_cd)::text)
  • Heap Fetches: 0
672. 0.010 0.032 ↑ 1.0 25 1

Materialize (cost=0.00..1.38 rows=25 width=1,032) (actual time=0.007..0.032 rows=25 loops=1)

673. 0.022 0.022 ↑ 1.0 25 1

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_21 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.004..0.022 rows=25 loops=1)

674. 0.008 0.035 ↑ 2.0 1 1

Materialize (cost=0.43..9.51 rows=2 width=310) (actual time=0.032..0.035 rows=1 loops=1)

675. 0.006 0.027 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=310) (actual time=0.025..0.027 rows=1 loops=1)

676. 0.001 0.001 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_46 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

677. 0.020 0.020 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_60 (cost=0.43..8.47 rows=2 width=182) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
678. 0.005 296.270 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_21 (cost=1.71..438.02 rows=2 width=669) (actual time=296.258..296.270 rows=1 loops=1)

679. 0.028 296.265 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.71..438.00 rows=2 width=669) (actual time=296.255..296.265 rows=1 loops=1)

680. 0.006 0.093 ↑ 2.0 1 1

Nested Loop (cost=1.28..139.10 rows=2 width=661) (actual time=0.083..0.093 rows=1 loops=1)

681. 0.007 0.073 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..130.61 rows=1 width=487) (actual time=0.068..0.073 rows=1 loops=1)

682. 0.006 0.031 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=423) (actual time=0.028..0.031 rows=1 loops=1)

683. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on l_time_period_cbbd_2018_12_27_07_04_41 l_time_period_cbbd_2018_12_27_07_04_41_47 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

684. 0.023 0.023 ↑ 1.0 1 1

Index Scan using f_store_agg_2018_12_27_07_28_55_pk on f_store_agg_2018_12_27_07_28_55 f_store_agg_2018_12_27_07_28_55_21 (cost=0.42..8.44 rows=1 width=295) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
685. 0.003 0.035 ↑ 1.0 1 1

Subquery Scan on fb_20 (cost=0.43..121.14 rows=1 width=72) (actual time=0.034..0.035 rows=1 loops=1)

  • Filter: ((fb_20.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_21.store_src_cd)::text)
686. 0.010 0.032 ↑ 1.0 1 1

GroupAggregate (cost=0.43..121.13 rows=1 width=22) (actual time=0.032..0.032 rows=1 loops=1)

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_42.store_src_cd
687. 0.008 0.022 ↑ 29.0 1 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.021..0.022 rows=1 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_21.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
688. 0.014 0.014 ↑ 29.0 1 1

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_42 (cost=0.43..120.90 rows=29 width=22) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
689. 0.014 0.014 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_61 (cost=0.43..8.47 rows=2 width=182) (actual time=0.011..0.014 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
690. 0.001 296.144 ↓ 0.0 0 1

Subquery Scan on p_44 (cost=0.43..149.40 rows=1 width=8) (actual time=296.144..296.144 rows=0 loops=1)

  • Filter: (((p_44.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text) AND ((p_44.store_src_cd)::text = (d_store_2018_12_27_07_01_39_61.store_src_cd)::text))
691. 0.003 296.143 ↓ 0.0 0 1

Limit (cost=0.43..149.39 rows=1 width=8) (actual time=296.143..296.143 rows=0 loops=1)

692. 0.002 296.140 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=296.140..296.140 rows=0 loops=1)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_62.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_44.entity_01_cd)::text)
693. 296.138 296.138 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_44 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=296.138..296.138 rows=0 loops=1)

  • Filter: ((to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) >= (eff_dt_id)::numeric) AND (to_number(to_char((('now'::cstring)::date)::timestamp with time zone, 'YYYYMMDD'::text), '99999999'::text) <= (exp_dt_id)::numeric))
  • Rows Removed by Filter: 104475
694. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..17.70 rows=4 width=16) (never executed)

695. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_62 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_61.store_src_cd)::text)
  • Heap Fetches: 0
696. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_rpt_tot_velocity_by_brand_mv_rpt_to_cd_brand_cd_idx on stores_beer_rpt_tot_velocity_by_brand_mv (cost=0.29..8.31 rows=1 width=85) (never executed)

  • Index Cond: (((rpt_to_cd)::text = (agg_18.rpt_to_cd)::text) AND ((brand_cd)::text = 'brand_cd'::text))
697. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.72..51.02 rows=2 width=38) (never executed)

  • Group Key: x_store_entity_2018_12_27_07_38_25_63.store_src_cd
698. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..50.96 rows=4 width=38) (never executed)

699. 0.000 0.000 ↓ 0.0 0

Index Only Scan using x_store_entity_2018_12_27_07_38_25_pk on x_store_entity_2018_12_27_07_38_25 x_store_entity_2018_12_27_07_38_25_63 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06_16.store_src_cd)::text)
  • Heap Fetches: 0
700. 0.000 0.000 ↓ 0.0 0

Index Scan using d_entity_2018_12_27_07_01_12_entity_01_cd_idx on d_entity_2018_12_27_07_01_12 d_entity_2018_12_27_07_01_12_18 (cost=0.29..8.31 rows=1 width=30) (never executed)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_63.entity_01_cd)::text)
701. 0.002 583.785 ↓ 0.0 0 1

Nested Loop (cost=172,359.12..172,418.99 rows=1 width=190) (actual time=583.785..583.785 rows=0 loops=1)

702. 0.001 583.783 ↓ 0.0 0 1

Nested Loop (cost=172,358.40..172,367.93 rows=1 width=190) (actual time=583.783..583.783 rows=0 loops=1)

  • Join Filter: ((agg_19.ult_parent_cd)::text = (stores_beer_ult_tot_velocity_by_brand_mv.ult_parent_cd)::text)
703. 0.007 583.782 ↓ 0.0 0 1

Subquery Scan on agg_19 (cost=172,358.11..172,359.61 rows=1 width=188) (actual time=583.782..583.782 rows=0 loops=1)

  • Filter: (((agg_19.brand_cd)::character varying(30))::text = 'brand_cd'::text)
  • Rows Removed by Filter: 2
704. 0.032 583.775 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=583.774..583.775 rows=2 loops=1)

  • Group Key: "*SELECT* 1_21".store_src_cd, "*SELECT* 1_21".store_cd, "*SELECT* 1_21".store_name, "*SELECT* 1_21".addr_01_dsc, "*SELECT* 1_21".city_dsc, "*SELECT* 1_21".state_cd, "*SELECT* 1_21".postal_cd, "*SELECT* 1_21".dma_cd, "*SELECT* 1_21".dma_dsc, "*SELECT* 1_21".latitude, "*SELECT* 1_21".longitude, "*SELECT* 1_21".store_number, "*SELECT* 1_21".premise_type_dsc, "*SELECT* 1_21".channel_cd, "*SELECT* 1_21".channel_dsc, "*SELECT* 1_21".ult_parent_cd, "*SELECT* 1_21".ult_parent_dsc, "*SELECT* 1_21".rpt_to_cd, "*SELECT* 1_21".rpt_to_dsc, "*SELECT* 1_21".chain_ind_flg, "*SELECT* 1_21".cbbd_chain_flg, "*SELECT* 1_21".off_premise_sales_priority, ('N'::text), "*SELECT* 1_21".priority_flg, "*SELECT* 1_21".brand_cd, "*SELECT* 1_21".brand_dsc, "*SELECT* 1_21".first_sold_dt, "*SELECT* 1_21".last_sold_dt, "*SELECT* 1_21".risk_flg, "*SELECT* 1_21".new_flg, "*SELECT* 1_21".depl_cytd_eqv_qty_ty, "*SELECT* 1_21".depl_cytd_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_cytd_qty_ty, "*SELECT* 1_21".depl_r365_eqv_qty_ty, "*SELECT* 1_21".depl_r365_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_r365_qty_ty, "*SELECT* 1_21".depl_l30_eqv_qty_ty, "*SELECT* 1_21".depl_l30_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_l30_qty_ty, "*SELECT* 1_21".depl_l90_eqv_qty_ty, "*SELECT* 1_21".depl_l90_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_l90_qty_ty, "*SELECT* 1_21".premise_vol_rank, "*SELECT* 1_21".similar_store_depl_cytd_qty_ly, "*SELECT* 1_21".similar_store_depl_r365_qty_ly, "*SELECT* 1_21".similar_store_depl_l30_qty_ly, "*SELECT* 1_21".similar_store_depl_l90_qty_ly, "*SELECT* 1_21".depl_l60_eqv_qty_ty, "*SELECT* 1_21".depl_l60_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_l60_qty_ty, "*SELECT* 1_21".similar_store_depl_l60_qty_ly, "*SELECT* 1_21".depl_l120_eqv_qty_ty, "*SELECT* 1_21".depl_l120_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_l120_qty_ty, "*SELECT* 1_21".similar_store_depl_l120_qty_ly, "*SELECT* 1_21".depl_lcm_eqv_qty_ty, "*SELECT* 1_21".depl_lcm_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_lcm_qty_ty, "*SELECT* 1_21".similar_store_depl_lcm_qty_ly, "*SELECT* 1_21".depl_cmip_eqv_qty_ty, "*SELECT* 1_21".depl_cmip_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_cmip_qty_ty, "*SELECT* 1_21".similar_store_depl_cmip_qty_ly, "*SELECT* 1_21".depl_cmip2_eqv_qty_ty, "*SELECT* 1_21".depl_cmip2_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_cmip1_qty_ly, "*SELECT* 1_21".similar_store_depl_cmip2_qty_ly, (("*SELECT* 1_21".sim_distribution_l90_ty)::bigint), (("*SELECT* 1_21".sim_distribution_l90_ly)::bigint), (("*SELECT* 1_21".eff_distribution_l90_ty)::bigint), (("*SELECT* 1_21".eff_distribution_l90_ly)::bigint), "*SELECT* 1_21".depl_cytm_eqv_qty_ty, "*SELECT* 1_21".depl_cytm_eqv_qty_ly, "*SELECT* 1_21".similar_store_depl_cytm_qty_ty, "*SELECT* 1_21".similar_store_depl_cytm_qty_ly, "*SELECT* 1_21".inv_cnt_l30, "*SELECT* 1_21".inv_cnt_l60, "*SELECT* 1_21".inv_cnt_l90, "*SELECT* 1_21".inv_cnt_l120, "*SELECT* 1_21".inv_cnt_l365, "*SELECT* 1_21".inv_cnt_cytm, "*SELECT* 1_21".inv_cnt_cytd, "*SELECT* 1_21".inv_cnt_lcm, "*SELECT* 1_21".inv_cnt_cmip
705. 0.006 583.743 ↑ 30.0 2 1

Append (cost=9.73..172,345.51 rows=60 width=1,585) (actual time=290.479..583.743 rows=2 loops=1)

706. 0.007