explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TYwK

Settings
# exclusive inclusive rows x rows loops node
1. 1,159.615 13,259.689 ↑ 800.0 1 1

Hash Right Join (cost=10,992,399.02..108,355,664.20 rows=800 width=161) (actual time=13,259.685..13,259.689 rows=1 loops=1)

  • Hash Cond: ((d_store_2018_12_27_07_01_39_3.store_src_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text)
2. 2,317.286 12,100.074 ↑ 25.0 1 1

GroupAggregate (cost=10,647,297.69..108,010,537.56 rows=25 width=40) (actual time=12,100.074..12,100.074 rows=1 loops=1)

  • Group Key: d_store_2018_12_27_07_01_39_3.store_src_cd
3. 0.142 6,576.221 ↑ 25.0 1 1

HashAggregate (cost=10,647,297.69..50,049,547.56 rows=25 width=272) (actual time=6,576.220..6,576.221 rows=1 loops=1)

  • Group Key: d_store_2018_12_27_07_01_39_3.store_src_cd, (d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30)
4. 0.014 732.609 ↑ 9,674.0 1 1

Merge Left Join (cost=8,383,759.62..10,646,451.22 rows=9,674 width=272) (actual time=732.047..732.609 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: ((d_store_2018_12_27_07_01_39_3.store_src_cd)::text = (d_store_2018_12_27_07_01_39_4.store_src_cd)::text)
5. 0.004 668.174 ↑ 605.0 1 1

Nested Loop (cost=5,452,641.99..6,960,373.45 rows=605 width=249) (actual time=667.951..668.174 rows=1 loops=1)

6. 0.010 668.080 ↑ 303.0 1 1

Nested Loop Left Join (cost=5,452,641.27..6,960,314.83 rows=303 width=249) (actual time=667.861..668.080 rows=1 loops=1)

  • Join Filter: (((d_store_2018_12_27_07_01_39_3.store_src_cd)::text = ("*SELECT* 1".tdlinx_store_cd)::text) AND ((f_store_sku_pkg_agg_2018_12_27_07_28_06.master_pkg_sku_cd)::text = ("*SELECT* 1".pkgsku_cd)::text))
7. 0.004 655.356 ↑ 246.0 1 1

Nested Loop (cost=5,452,638.84..6,205,457.10 rows=246 width=249) (actual time=655.349..655.356 rows=1 loops=1)

8. 0.003 655.313 ↑ 123.0 1 1

Nested Loop Left Join (cost=5,452,638.41..6,205,444.52 rows=123 width=129) (actual time=655.310..655.313 rows=1 loops=1)

9. 0.010 643.080 ↑ 123.0 1 1

Merge Join (cost=5,452,637.98..5,452,640.83 rows=123 width=121) (actual time=643.077..643.080 rows=1 loops=1)

  • Merge Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06.master_pkg_sku_cd)::text = (vw.sku)::text)
10. 0.009 0.248 ↑ 123.0 1 1

Sort (cost=516.02..516.32 rows=123 width=81) (actual time=0.247..0.248 rows=1 loops=1)

  • Sort Key: f_store_sku_pkg_agg_2018_12_27_07_28_06.master_pkg_sku_cd
  • Sort Method: quicksort Memory: 25kB
11. 0.020 0.239 ↑ 123.0 1 1

Hash Join (cost=12.14..511.75 rows=123 width=81) (actual time=0.237..0.239 rows=1 loops=1)

  • Hash Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22.master_pkg_sku_cd)::text)
12. 0.016 0.016 ↑ 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=46) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
13. 0.107 0.203 ↑ 1.0 248 1

Hash (cost=8.48..8.48 rows=248 width=35) (actual time=0.203..0.203 rows=248 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
14. 0.096 0.096 ↑ 1.0 248 1

Seq Scan on d_item_sku_pkg_2018_12_27_07_05_22 (cost=0.00..8.48 rows=248 width=35) (actual time=0.004..0.096 rows=248 loops=1)

15. 0.010 642.822 ↑ 200.0 1 1

Sort (cost=5,452,121.97..5,452,122.47 rows=200 width=49) (actual time=642.822..642.822 rows=1 loops=1)

  • Sort Key: vw.sku
  • Sort Method: quicksort Memory: 29kB
16. 0.002 642.812 ↑ 200.0 1 1

Subquery Scan on vw (cost=5,452,109.32..5,452,114.32 rows=200 width=49) (actual time=642.811..642.812 rows=1 loops=1)

17. 0.025 642.810 ↑ 200.0 1 1

HashAggregate (cost=5,452,109.32..5,452,112.32 rows=200 width=49) (actual time=642.810..642.810 rows=1 loops=1)

  • Group Key: d_store_2018_12_27_07_01_39_5.store_src_cd, f_store_sku_pkg_agg_2018_12_27_07_28_06_2.master_pkg_sku_cd
18. 0.004 642.785 ↑ 702.0 2 1

Append (cost=4.56..5,452,098.79 rows=1,404 width=49) (actual time=25.148..642.785 rows=2 loops=1)

19. 0.039 604.182 ↑ 753.0 1 1

Nested Loop (cost=4.56..1,681,308.34 rows=753 width=275) (actual time=25.147..604.182 rows=1 loops=1)

20. 0.013 604.047 ↑ 376.0 1 1

Nested Loop Left Join (cost=3.84..1,681,246.02 rows=376 width=275) (actual time=25.014..604.047 rows=1 loops=1)

  • Join Filter: (((d_store_2018_12_27_07_01_39_5.store_src_cd)::text = ("*SELECT* 1_1".tdlinx_store_cd)::text) AND ((f_store_sku_pkg_agg_2018_12_27_07_28_06_2.master_pkg_sku_cd)::text = ("*SELECT* 1_1".pkgsku_cd)::text))
  • Rows Removed by Join Filter: 2
21. 0.003 12.672 ↑ 246.0 1 1

Nested Loop (cost=1.42..753,781.40 rows=246 width=95) (actual time=12.504..12.672 rows=1 loops=1)

22. 0.068 12.641 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=95) (actual time=12.477..12.641 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_2.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
23. 0.007 12.375 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=95) (actual time=12.373..12.375 rows=1 loops=1)

24. 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_2 (cost=0.56..498.48 rows=123 width=95) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
25. 0.003 12.356 ↓ 0.0 0 1

Subquery Scan on p_2 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.356..12.356 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))
26. 0.001 12.353 ↓ 0.0 0 1

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

27. 0.004 12.352 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20.entity_01_cd)::text)
28. 12.348 12.348 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.348..12.348 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
29. 0.000 0.000 ↓ 0.0 0

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

30. 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_sku_pkg_agg_2018_12_27_07_28_06_2.store_src_cd)::text)
  • Heap Fetches: 0
31. 0.123 0.198 ↑ 1.0 248 1

Materialize (cost=0.00..9.72 rows=248 width=9) (actual time=0.010..0.198 rows=248 loops=1)

32. 0.075 0.075 ↑ 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=9) (actual time=0.004..0.075 rows=248 loops=1)

33. 0.004 0.028 ↑ 2.0 1 1

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

34. 0.003 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)

35. 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.002..0.002 rows=1 loops=1)

36. 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_5 (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)
37. 0.011 591.362 ↑ 102.0 3 1

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

38. 0.005 591.351 ↑ 102.0 3 1

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

39. 0.001 12.710 ↑ 246.0 1 1

Subquery Scan on *SELECT* 1_1 (cost=2.42..753,798.09 rows=246 width=197) (actual time=12.497..12.710 rows=1 loops=1)

40. 0.034 12.709 ↑ 246.0 1 1

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

41.          

Initplan (forNested Loop)

42. 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)

43. 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_65 (cost=0.00..1.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

44. 0.178 12.645 ↑ 123.0 1 1

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

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_3.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_3.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
45. 0.067 0.067 ↑ 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_3 (cost=0.00..8.48 rows=248 width=13) (actual time=0.002..0.067 rows=248 loops=1)

46. 0.101 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)

47. 0.005 12.299 ↑ 123.0 1 1

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

48. 0.015 0.015 ↑ 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=53) (actual time=0.014..0.015 rows=1 loops=1)

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

Subquery Scan on p_3 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.279..12.279 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_3.store_src_cd)::text) AND ((p_3.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_3.master_pkg_sku_cd)::text))
50. 0.001 12.277 ↓ 0.0 0 1

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

51. 0.003 12.276 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.276..12.276 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)
52. 12.273 12.273 ↓ 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..6,101.56 rows=18 width=16) (actual time=12.273..12.273 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_3.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
53. 0.000 0.000 ↓ 0.0 0

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

54. 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 = (f_store_sku_pkg_agg_2018_12_27_07_28_06_3.store_src_cd)::text)
  • Heap Fetches: 0
55. 0.003 0.027 ↑ 2.0 1 1

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

56. 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)

57. 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_3 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

58. 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_6 (cost=0.43..8.47 rows=2 width=8) (actual time=0.019..0.020 rows=1 loops=1)

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

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

60. 0.026 289.131 ↑ 58.0 1 1

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

61.          

Initplan (forNested Loop)

62. 0.002 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)

63. 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_66 (cost=0.00..1.01 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

64. 0.020 289.066 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=560) (actual time=289.039..289.066 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
65. 0.005 289.019 ↑ 29.0 1 1

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

66. 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=48) (actual time=0.014..0.015 rows=1 loops=1)

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

Subquery Scan on p_4 (cost=8.87..5,922.79 rows=1 width=12) (actual time=288.999..288.999 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.store_src_cd)::text) AND ((p_4.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24.brand_cd)::text))
68. 0.001 288.997 ↓ 0.0 0 1

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

69. 0.005 288.996 ↓ 0.0 0 1

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_2.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_2.entity_01_cd)::text)
70. 0.003 288.991 ↓ 0.0 0 1

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_2.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_4.master_pkg_sku_cd)::text)
71. 288.988 288.988 ↓ 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..5,840.38 rows=11,608 width=16) (actual time=288.988..288.988 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
72. 0.000 0.000 ↓ 0.0 0

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

73. 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_4 (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)
74. 0.000 0.000 ↓ 0.0 0

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

75. 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_2 (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
76. 0.017 0.027 ↑ 1.0 25 1

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

77. 0.010 0.010 ↑ 1.0 25 1

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

78. 0.005 0.036 ↑ 2.0 1 1

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

79. 0.003 0.031 ↑ 2.0 1 1

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

80. 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_4 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

81. 0.027 0.027 ↑ 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.026..0.027 rows=1 loops=1)

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

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

83. 0.036 289.502 ↑ 2.0 1 1

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

84.          

Initplan (forNested Loop Left Join)

85. 0.003 0.005 ↑ 1.0 1 1

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

86. 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_67 (cost=0.00..1.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

87. 0.004 0.083 ↑ 2.0 1 1

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

88. 0.002 0.066 ↑ 1.0 1 1

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

89. 0.005 0.020 ↑ 1.0 1 1

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

90. 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)

91. 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=44) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
92. 0.006 0.044 ↑ 1.0 1 1

Subquery Scan on fb (cost=0.43..121.14 rows=1 width=8) (actual time=0.042..0.044 rows=1 loops=1)

  • Filter: ((fb.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_1.store_src_cd)::text)
93. 0.015 0.038 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_1.store_src_cd
94. 0.009 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_1.store_src_cd)::text = '7425774'::text)
95. 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_1 (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 = '7425774'::text)
96. 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_8 (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)
97. 0.001 289.378 ↓ 0.0 0 1

Subquery Scan on p_5 (cost=0.43..149.40 rows=1 width=8) (actual time=289.378..289.378 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_8.store_src_cd)::text))
98. 0.004 289.377 ↓ 0.0 0 1

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

99. 0.002 289.373 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=289.373..289.373 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_3.entity_01_cd)::text)
100. 289.371 289.371 ↓ 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..5,840.38 rows=11,608 width=7) (actual time=289.371..289.371 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
101. 0.000 0.000 ↓ 0.0 0

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

102. 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 = (d_store_2018_12_27_07_01_39_8.store_src_cd)::text)
  • Heap Fetches: 0
103. 0.004 0.096 ↑ 2.0 1 1

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.095..0.096 rows=1 loops=1)

104. 0.001 0.092 ↑ 2.0 1 1

Subquery Scan on dist_1 (cost=0.72..51.04 rows=2 width=8) (actual time=0.091..0.092 rows=1 loops=1)

105. 0.041 0.091 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_4.store_src_cd
106. 0.005 0.050 ↑ 1.3 3 1

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

107. 0.018 0.018 ↑ 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_4 (cost=0.43..17.68 rows=4 width=16) (actual time=0.015..0.018 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
108. 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_4.entity_01_cd)::text)
109. 0.022 38.599 ↑ 651.0 1 1

GroupAggregate (cost=3,770,701.63..3,770,776.41 rows=651 width=49) (actual time=38.599..38.599 rows=1 loops=1)

  • Group Key: d_store_2018_12_27_07_01_39_9.store_src_cd, f_store_sku_pkg_agg_2018_12_27_07_28_06_4.master_pkg_sku_cd
110. 0.021 38.577 ↑ 3,251.0 2 1

Sort (cost=3,770,701.63..3,770,717.88 rows=6,502 width=49) (actual time=38.577..38.577 rows=2 loops=1)

  • Sort Key: d_store_2018_12_27_07_01_39_9.store_src_cd, f_store_sku_pkg_agg_2018_12_27_07_28_06_4.master_pkg_sku_cd
  • Sort Method: quicksort Memory: 27kB
111. 0.003 38.556 ↑ 3,251.0 2 1

Append (cost=4.27..3,770,289.84 rows=6,502 width=49) (actual time=25.014..38.556 rows=2 loops=1)

112. 0.046 25.338 ↑ 4,838.0 1 1

Merge Join (cost=4.27..1,507,781.24 rows=4,838 width=126) (actual time=25.012..25.338 rows=1 loops=1)

  • Merge Cond: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_4.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_5.master_pkg_sku_cd)::text)
113. 0.002 12.716 ↑ 492.0 1 1

Nested Loop (cost=2.13..753,835.58 rows=492 width=26) (actual time=12.555..12.716 rows=1 loops=1)

114. 0.075 12.592 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.437..12.592 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_5.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
115. 0.003 12.331 ↑ 123.0 1 1

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

116. 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_4 (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
117. 0.001 12.306 ↓ 0.0 0 1

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

  • Filter: (((p_6.store_src_cd)::text = '7425774'::text) AND ((p_6.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_4.store_src_cd)::text) AND ((p_6.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_4.master_pkg_sku_cd)::text))
118. 0.002 12.305 ↓ 0.0 0 1

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

119. 0.005 12.303 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_5.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_4.entity_01_cd)::text)
120. 12.298 12.298 ↓ 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..6,101.56 rows=18 width=16) (actual time=12.298..12.298 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
121. 0.000 0.000 ↓ 0.0 0

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

122. 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_sku_pkg_agg_2018_12_27_07_28_06_4.store_src_cd)::text)
  • Heap Fetches: 0
123. 0.116 0.186 ↑ 1.0 248 1

Materialize (cost=0.00..9.72 rows=248 width=9) (actual time=0.016..0.186 rows=248 loops=1)

124. 0.070 0.070 ↑ 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_5 (cost=0.00..8.48 rows=248 width=9) (actual time=0.004..0.070 rows=248 loops=1)

125. 0.007 0.122 ↑ 4.0 1 1

Materialize (cost=1.15..60.61 rows=4 width=8) (actual time=0.117..0.122 rows=1 loops=1)

126. 0.001 0.115 ↑ 4.0 1 1

Nested Loop (cost=1.15..60.59 rows=4 width=8) (actual time=0.111..0.115 rows=1 loops=1)

127. 0.005 0.025 ↑ 2.0 1 1

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

128. 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_6 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

129. 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.019..0.019 rows=1 loops=1)

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

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.087..0.089 rows=1 loops=1)

131. 0.002 0.085 ↑ 2.0 1 1

Subquery Scan on dist_2 (cost=0.72..51.04 rows=2 width=8) (actual time=0.084..0.085 rows=1 loops=1)

132. 0.031 0.083 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_6.store_src_cd
133. 0.008 0.052 ↑ 1.3 3 1

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

134. 0.017 0.017 ↑ 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_6 (cost=0.43..17.68 rows=4 width=16) (actual time=0.015..0.017 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
135. 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 d_entity_2018_12_27_07_01_12_1 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.009 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_6.entity_01_cd)::text)
136. 0.005 12.576 ↑ 492.0 1 1

Materialize (cost=2.13..753,836.81 rows=492 width=135) (actual time=12.413..12.576 rows=1 loops=1)

137. 0.001 12.571 ↑ 492.0 1 1

Nested Loop (cost=2.13..753,835.58 rows=492 width=135) (actual time=12.408..12.571 rows=1 loops=1)

138. 0.072 12.457 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=135) (actual time=12.298..12.457 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_5.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_6.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
139. 0.007 12.198 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=126) (actual time=12.197..12.198 rows=1 loops=1)

140. 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 f_store_sku_pkg_agg_2018_12_27_07_28_06_5 (cost=0.56..498.48 rows=123 width=126) (actual time=0.013..0.013 rows=1 loops=1)

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

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

  • Filter: (((p_7.store_src_cd)::text = '7425774'::text) AND ((p_7.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_5.store_src_cd)::text) AND ((p_7.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_5.master_pkg_sku_cd)::text))
142. 0.003 12.176 ↓ 0.0 0 1

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

143. 0.002 12.173 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_7.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_5.entity_01_cd)::text)
144. 12.171 12.171 ↓ 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..6,101.56 rows=18 width=16) (actual time=12.171..12.171 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_5.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
145. 0.000 0.000 ↓ 0.0 0

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

146. 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_7 (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_5.store_src_cd)::text)
  • Heap Fetches: 0
147. 0.117 0.187 ↑ 1.0 248 1

Materialize (cost=0.00..9.72 rows=248 width=9) (actual time=0.010..0.187 rows=248 loops=1)

148. 0.070 0.070 ↑ 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_6 (cost=0.00..8.48 rows=248 width=9) (actual time=0.003..0.070 rows=248 loops=1)

149. 0.006 0.113 ↑ 4.0 1 1

Materialize (cost=1.15..60.61 rows=4 width=8) (actual time=0.109..0.113 rows=1 loops=1)

150. 0.002 0.107 ↑ 4.0 1 1

Nested Loop (cost=1.15..60.59 rows=4 width=8) (actual time=0.103..0.107 rows=1 loops=1)

151. 0.003 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)

152. 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_7 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

153. 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_10 (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)
154. 0.002 0.081 ↑ 2.0 1 1

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.080..0.081 rows=1 loops=1)

155. 0.003 0.079 ↑ 2.0 1 1

Subquery Scan on dist_3 (cost=0.72..51.04 rows=2 width=8) (actual time=0.078..0.079 rows=1 loops=1)

156. 0.028 0.076 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_8.store_src_cd
157. 0.009 0.048 ↑ 1.3 3 1

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

158. 0.015 0.015 ↑ 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_8 (cost=0.43..17.68 rows=4 width=16) (actual time=0.014..0.015 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
159. 0.024 0.024 ↑ 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 d_entity_2018_12_27_07_01_12_2 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_8.entity_01_cd)::text)
160. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=2.55..754,117.26 rows=540 width=49) (actual time=0.023..0.023 rows=0 loops=1)

161. 0.001 0.023 ↓ 0.0 0 1

Nested Loop (cost=1.83..754,059.47 rows=270 width=49) (actual time=0.023..0.023 rows=0 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_6.master_pkg_sku_cd)::text = (rpt.sku)::text)
162. 0.000 0.022 ↓ 0.0 0 1

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

163. 0.002 0.022 ↓ 0.0 0 1

Nested Loop (cost=0.43..9.50 rows=1 width=14) (actual time=0.022..0.022 rows=0 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_8 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

165. 0.018 0.018 ↓ 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_11 (cost=0.43..8.48 rows=1 width=14) (actual time=0.018..0.018 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
166. 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_11.rpt_to_cd)::text)
167. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.99..753,769.44 rows=123 width=26) (never executed)

168. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (never executed)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_6.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_7.master_pkg_sku_cd)::text)
169. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=17) (never executed)

170. 0.000 0.000 ↓ 0.0 0

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_6 (cost=0.56..498.48 rows=123 width=17) (never executed)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 0
171. 0.000 0.000 ↓ 0.0 0

Subquery Scan on p_8 (cost=0.43..6,120.35 rows=1 width=17) (never executed)

  • Filter: (((p_8.store_src_cd)::text = '7425774'::text) AND ((p_8.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_6.store_src_cd)::text) AND ((p_8.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_6.master_pkg_sku_cd)::text))
172. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.43..6,120.33 rows=1 width=17) (never executed)

173. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (never executed)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_9.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_6.entity_01_cd)::text)
174. 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_6 (cost=0.00..6,101.56 rows=18 width=16) (never executed)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_6.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))
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_9 (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_6.store_src_cd)::text)
  • Heap Fetches: 0
177. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..9.72 rows=248 width=9) (never executed)

178. 0.000 0.000 ↓ 0.0 0

Seq Scan on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_7 (cost=0.00..8.48 rows=248 width=9) (never executed)

179. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.72..51.05 rows=2 width=8) (never executed)

180. 0.000 0.000 ↓ 0.0 0

Subquery Scan on dist_4 (cost=0.72..51.04 rows=2 width=8) (never executed)

181. 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_10.store_src_cd
182. 0.000 0.000 ↓ 0.0 0

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

183. 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_10 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 0
184. 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_3 (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_10.entity_01_cd)::text)
185. 0.002 0.017 ↓ 0.0 0 1

Nested Loop (cost=2.55..754,138.35 rows=565 width=49) (actual time=0.017..0.017 rows=0 loops=1)

186. 0.000 0.015 ↓ 0.0 0 1

Nested Loop (cost=1.83..754,080.26 rows=282 width=49) (actual time=0.015..0.015 rows=0 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_7.master_pkg_sku_cd)::text = (parent.sku)::text)
187. 0.001 0.015 ↓ 0.0 0 1

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

188. 0.001 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.43..9.50 rows=1 width=14) (actual time=0.014..0.014 rows=0 loops=1)

189. 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_9 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

190. 0.011 0.011 ↓ 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_12 (cost=0.43..8.48 rows=1 width=14) (actual time=0.011..0.011 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
191. 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_12.ult_parent_cd)::text)
192. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.99..753,769.44 rows=123 width=26) (never executed)

193. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (never executed)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_7.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_8.master_pkg_sku_cd)::text)
194. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=17) (never executed)

195. 0.000 0.000 ↓ 0.0 0

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) (never executed)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 0
196. 0.000 0.000 ↓ 0.0 0

Subquery Scan on p_9 (cost=0.43..6,120.35 rows=1 width=17) (never executed)

  • Filter: (((p_9.store_src_cd)::text = '7425774'::text) AND ((p_9.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_7.store_src_cd)::text) AND ((p_9.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_7.master_pkg_sku_cd)::text))
197. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.43..6,120.33 rows=1 width=17) (never executed)

198. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (never executed)

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_11.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_7.entity_01_cd)::text)
199. 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_7 (cost=0.00..6,101.56 rows=18 width=16) (never executed)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_7.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))
200. 0.000 0.000 ↓ 0.0 0

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

201. 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_11 (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_7.store_src_cd)::text)
  • Heap Fetches: 0
202. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..9.72 rows=248 width=9) (never executed)

203. 0.000 0.000 ↓ 0.0 0

Seq Scan on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_8 (cost=0.00..8.48 rows=248 width=9) (never executed)

204. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.72..51.05 rows=2 width=8) (never executed)

205. 0.000 0.000 ↓ 0.0 0

Subquery Scan on dist_5 (cost=0.72..51.04 rows=2 width=8) (never executed)

206. 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_12.store_src_cd
207. 0.000 0.000 ↓ 0.0 0

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

208. 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_12 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 0
209. 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_4 (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_12.entity_01_cd)::text)
210. 0.003 13.175 ↑ 559.0 1 1

Nested Loop (cost=2.56..754,187.97 rows=559 width=49) (actual time=12.802..13.175 rows=1 loops=1)

211. 0.029 13.093 ↑ 280.0 1 1

Nested Loop (cost=1.84..754,129.93 rows=280 width=49) (actual time=12.722..13.093 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_8.master_pkg_sku_cd)::text = (dma.sku)::text)
  • Rows Removed by Join Filter: 104
212. 0.067 12.558 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.389..12.558 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_8.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_9.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
213. 0.004 12.288 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=17) (actual time=12.287..12.288 rows=1 loops=1)

214. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

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

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

  • Filter: (((p_10.store_src_cd)::text = '7425774'::text) AND ((p_10.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_8.store_src_cd)::text) AND ((p_10.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_8.master_pkg_sku_cd)::text))
216. 0.003 12.270 ↓ 0.0 0 1

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

217. 0.004 12.267 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_13.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_8.entity_01_cd)::text)
218. 12.263 12.263 ↓ 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_8 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.263..12.263 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_8.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
219. 0.000 0.000 ↓ 0.0 0

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

220. 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_13 (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_8.store_src_cd)::text)
  • Heap Fetches: 0
221. 0.126 0.203 ↑ 1.0 248 1

Materialize (cost=0.00..9.72 rows=248 width=9) (actual time=0.009..0.203 rows=248 loops=1)

222. 0.077 0.077 ↑ 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_9 (cost=0.00..8.48 rows=248 width=9) (actual time=0.003..0.077 rows=248 loops=1)

223. 0.126 0.506 ↑ 1.2 105 1

Materialize (cost=0.85..134.48 rows=123 width=49) (actual time=0.295..0.506 rows=105 loops=1)

224. 0.056 0.380 ↑ 1.2 105 1

Nested Loop (cost=0.85..133.86 rows=123 width=49) (actual time=0.290..0.380 rows=105 loops=1)

225. 0.002 0.022 ↑ 2.0 1 1

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

226. 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_10 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

227. 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_13 (cost=0.43..8.47 rows=2 width=18) (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)
228. 0.302 0.302 ↓ 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.257..0.302 rows=105 loops=1)

  • Index Cond: (((cd)::text = ((COALESCE(d_store_2018_12_27_07_01_39_13.dma_cd, 'UNK'::character varying))::character varying(30))::text) AND ((rpt_to_cd)::text = (d_store_2018_12_27_07_01_39_13.rpt_to_cd)::text))
229. 0.002 0.079 ↑ 2.0 1 1

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.078..0.079 rows=1 loops=1)

230. 0.003 0.077 ↑ 2.0 1 1

Subquery Scan on dist_6 (cost=0.72..51.04 rows=2 width=8) (actual time=0.076..0.077 rows=1 loops=1)

231. 0.024 0.074 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_14.store_src_cd
232. 0.010 0.050 ↑ 1.3 3 1

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

233. 0.016 0.016 ↑ 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_14 (cost=0.43..17.68 rows=4 width=16) (actual time=0.014..0.016 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
234. 0.024 0.024 ↑ 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 d_entity_2018_12_27_07_01_12_5 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_14.entity_01_cd)::text)
235. 0.002 12.230 ↓ 0.0 0 1

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

  • Filter: (((p.store_src_cd)::text = '7425774'::text) AND ((p.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.store_src_cd)::text) AND ((p.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.master_pkg_sku_cd)::text))
236. 0.001 12.228 ↓ 0.0 0 1

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

237. 0.004 12.227 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_15.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_9.entity_01_cd)::text)
238. 12.223 12.223 ↓ 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_9 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.223..12.223 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06.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
239. 0.000 0.000 ↓ 0.0 0

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

240. 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_15 (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
241. 0.011 0.039 ↑ 2.0 1 1

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

242. 0.004 0.028 ↑ 2.0 1 1

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

243. 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.001..0.002 rows=1 loops=1)

244. 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=8) (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)
245. 0.006 12.714 ↑ 246.0 1 1

Materialize (cost=2.42..753,799.32 rows=246 width=17) (actual time=12.503..12.714 rows=1 loops=1)

246. 0.001 12.708 ↑ 246.0 1 1

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

247. 0.002 12.707 ↑ 246.0 1 1

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

248. 0.032 12.705 ↑ 246.0 1 1

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

249.          

Initplan (forNested Loop)

250. 0.002 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)

251. 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_68 (cost=0.00..1.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

252. 0.179 12.640 ↑ 123.0 1 1

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

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_9.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_10.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
253. 0.061 0.061 ↑ 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_10 (cost=0.00..8.48 rows=248 width=13) (actual time=0.003..0.061 rows=248 loops=1)

254. 0.097 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)

255. 0.007 12.303 ↑ 123.0 1 1

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

256. 0.015 0.015 ↑ 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_9 (cost=0.56..498.48 rows=123 width=53) (actual time=0.014..0.015 rows=1 loops=1)

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

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

  • Filter: (((p_11.store_src_cd)::text = '7425774'::text) AND ((p_11.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_9.store_src_cd)::text) AND ((p_11.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_9.master_pkg_sku_cd)::text))
258. 0.001 12.279 ↓ 0.0 0 1

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

259. 0.003 12.278 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_16.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_10.entity_01_cd)::text)
260. 12.275 12.275 ↓ 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_10 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.275..12.275 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_9.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
261. 0.000 0.000 ↓ 0.0 0

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

262. 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_16 (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_9.store_src_cd)::text)
  • Heap Fetches: 0
263. 0.004 0.029 ↑ 2.0 1 1

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

264. 0.001 0.025 ↑ 2.0 1 1

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

265. 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_11 (cost=0.00..1.01 rows=1 width=0) (actual time=0.002..0.003 rows=1 loops=1)

266. 0.021 0.021 ↑ 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_14 (cost=0.43..8.47 rows=2 width=8) (actual time=0.020..0.021 rows=1 loops=1)

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

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.088..0.090 rows=1 loops=1)

268. 0.002 0.086 ↑ 2.0 1 1

Subquery Scan on dist (cost=0.72..51.04 rows=2 width=8) (actual time=0.086..0.086 rows=1 loops=1)

269. 0.031 0.084 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_17.store_src_cd
270. 0.008 0.053 ↑ 1.3 3 1

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

271. 0.018 0.018 ↑ 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_17 (cost=0.43..17.68 rows=4 width=16) (actual time=0.015..0.018 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
272. 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 d_entity_2018_12_27_07_01_12_6 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.009 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_17.entity_01_cd)::text)
273. 0.006 64.421 ↑ 800.0 1 1

Materialize (cost=2,931,117.63..3,684,989.93 rows=800 width=49) (actual time=64.083..64.421 rows=1 loops=1)

274. 0.001 64.415 ↑ 800.0 1 1

Nested Loop (cost=2,931,117.63..3,684,987.93 rows=800 width=49) (actual time=64.077..64.415 rows=1 loops=1)

275. 0.085 64.338 ↑ 400.0 1 1

Merge Left Join (cost=2,931,116.91..3,684,925.86 rows=400 width=49) (actual time=64.003..64.338 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)
  • Join Filter: ((d_store_2018_12_27_07_01_39_4.store_src_cd)::text = (d_store_2018_12_27_07_01_39_15.store_src_cd)::text)
276. 0.003 12.682 ↑ 246.0 1 1

Nested Loop (cost=1.56..753,802.90 rows=246 width=86) (actual time=12.349..12.682 rows=1 loops=1)

277. 0.146 12.651 ↑ 123.0 1 1

Nested Loop (cost=1.13..753,791.35 rows=123 width=86) (actual time=12.322..12.651 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_1.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
278. 0.105 0.105 ↑ 1.0 248 1

Index Only Scan using d_item_sku_pkg_2018_12_27_07_05_22_pk on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_1 (cost=0.14..31.31 rows=248 width=9) (actual time=0.012..0.105 rows=248 loops=1)

  • Heap Fetches: 248
279. 0.133 12.400 ↑ 123.0 1 248

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

280. 0.006 12.267 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=86) (actual time=12.265..12.267 rows=1 loops=1)

281. 0.015 0.015 ↑ 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.014..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
282. 0.003 12.246 ↓ 0.0 0 1

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

  • Filter: (((p_1.store_src_cd)::text = '7425774'::text) AND ((p_1.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_1.store_src_cd)::text) AND ((p_1.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_1.master_pkg_sku_cd)::text))
283. 0.001 12.243 ↓ 0.0 0 1

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

284. 0.004 12.242 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_18.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_11.entity_01_cd)::text)
285. 12.238 12.238 ↓ 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_11 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.238..12.238 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_1.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
286. 0.000 0.000 ↓ 0.0 0

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

287. 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_18 (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_1.store_src_cd)::text)
  • Heap Fetches: 0
288. 0.007 0.028 ↑ 2.0 1 1

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

289. 0.021 0.021 ↑ 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=8) (actual time=0.018..0.021 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
290. 0.012 51.571 ↑ 325.0 1 1

Sort (cost=2,931,115.35..2,931,116.16 rows=325 width=49) (actual time=51.570..51.571 rows=1 loops=1)

  • Sort Key: f_store_sku_pkg_agg_2018_12_27_07_28_06_10.master_pkg_sku_cd
  • Sort Method: quicksort Memory: 29kB
291. 0.034 51.559 ↑ 325.0 1 1

HashAggregate (cost=2,931,094.48..2,931,098.54 rows=325 width=49) (actual time=51.558..51.559 rows=1 loops=1)

  • Group Key: d_store_2018_12_27_07_01_39_15.store_src_cd, f_store_sku_pkg_agg_2018_12_27_07_28_06_10.master_pkg_sku_cd
292. 0.006 51.525 ↑ 812.2 4 1

Append (cost=2.69..2,931,070.11 rows=3,249 width=49) (actual time=12.572..51.525 rows=4 loops=1)

293. 0.039 12.785 ↑ 435.0 1 1

Nested Loop (cost=2.69..668,064.80 rows=435 width=71) (actual time=12.571..12.785 rows=1 loops=1)

294. 0.157 12.625 ↑ 109.0 1 1

Nested Loop (cost=1.54..667,995.49 rows=109 width=79) (actual time=12.416..12.625 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_10.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_11.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
295. 0.068 0.068 ↑ 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_11 (cost=0.00..8.48 rows=248 width=9) (actual time=0.003..0.068 rows=248 loops=1)

296. 0.114 12.400 ↑ 109.0 1 248

Materialize (cost=1.54..667,581.80 rows=109 width=88) (actual time=0.050..0.050 rows=1 loops=248)

297. 0.005 12.286 ↑ 109.0 1 1

Nested Loop Left Join (cost=1.54..667,581.26 rows=109 width=88) (actual time=12.282..12.286 rows=1 loops=1)

298. 0.012 0.046 ↑ 109.0 1 1

Nested Loop (cost=1.11..462.54 rows=109 width=88) (actual time=0.043..0.046 rows=1 loops=1)

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

  • Index Cond: ((tdlinx_store_cd)::text = '7425774'::text)
300. 0.018 0.018 ↑ 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.017..0.018 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
301. 0.001 12.235 ↓ 0.0 0 1

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

  • Filter: (((p_12.store_src_cd)::text = '7425774'::text) AND ((p_12.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_10.store_src_cd)::text) AND ((p_12.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_10.master_pkg_sku_cd)::text))
302. 0.002 12.234 ↓ 0.0 0 1

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

303. 0.002 12.232 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_19.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_12.entity_01_cd)::text)
304. 12.230 12.230 ↓ 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_12 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.230..12.230 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_10.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
305. 0.000 0.000 ↓ 0.0 0

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

306. 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_19 (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_10.store_src_cd)::text)
  • Heap Fetches: 0
307. 0.002 0.121 ↑ 4.0 1 1

Materialize (cost=1.15..60.61 rows=4 width=8) (actual time=0.117..0.121 rows=1 loops=1)

308. 0.003 0.119 ↑ 4.0 1 1

Nested Loop (cost=1.15..60.59 rows=4 width=8) (actual time=0.115..0.119 rows=1 loops=1)

309. 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)

310. 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_12 (cost=0.00..1.01 rows=1 width=0) (actual time=0.002..0.003 rows=1 loops=1)

311. 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_15 (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)
312. 0.002 0.092 ↑ 2.0 1 1

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.091..0.092 rows=1 loops=1)

313. 0.003 0.090 ↑ 2.0 1 1

Subquery Scan on dist_7 (cost=0.72..51.04 rows=2 width=8) (actual time=0.089..0.090 rows=1 loops=1)

314. 0.038 0.087 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_20.store_src_cd
315. 0.009 0.049 ↑ 1.3 3 1

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

316. 0.016 0.016 ↑ 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_20 (cost=0.43..17.68 rows=4 width=16) (actual time=0.014..0.016 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
317. 0.024 0.024 ↑ 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 d_entity_2018_12_27_07_01_12_7 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_20.entity_01_cd)::text)
318. 0.039 12.892 ↑ 568.0 1 1

Nested Loop (cost=2.56..754,086.74 rows=568 width=94) (actual time=12.746..12.892 rows=1 loops=1)

319. 0.119 12.764 ↑ 284.0 1 1

Nested Loop (cost=1.84..754,024.34 rows=284 width=94) (actual time=12.620..12.764 rows=1 loops=1)

  • Join Filter: ((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)
  • Rows Removed by Join Filter: 104
320. 0.071 0.150 ↑ 1.2 105 1

Nested Loop (cost=0.85..26.42 rows=124 width=94) (actual time=0.050..0.150 rows=105 loops=1)

321. 0.003 0.018 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=18) (actual time=0.016..0.018 rows=1 loops=1)

322. 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_13 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

323. 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_16 (cost=0.43..8.47 rows=2 width=18) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
324. 0.061 0.061 ↓ 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.025..0.061 rows=105 loops=1)

  • Index Cond: (((dma_cd)::text = ((COALESCE(d_store_2018_12_27_07_01_39_16.dma_cd, 'UNK'::character varying))::character varying(30))::text) AND ((rpt_to_cd)::text = (d_store_2018_12_27_07_01_39_16.rpt_to_cd)::text))
325. 0.004 12.495 ↑ 123.0 1 105

Materialize (cost=0.99..753,769.44 rows=123 width=26) (actual time=0.118..0.119 rows=1 loops=105)

326. 0.067 12.491 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.331..12.491 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_11.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_12.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
327. 0.005 12.232 ↑ 123.0 1 1

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

328. 0.015 0.015 ↑ 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.014..0.015 rows=1 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 1
329. 0.000 12.212 ↓ 0.0 0 1

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

  • Filter: (((p_13.store_src_cd)::text = '7425774'::text) AND ((p_13.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_11.store_src_cd)::text) AND ((p_13.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_11.master_pkg_sku_cd)::text))
330. 0.003 12.212 ↓ 0.0 0 1

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

331. 0.002 12.209 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_21.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_13.entity_01_cd)::text)
332. 12.207 12.207 ↓ 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_13 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.207..12.207 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_11.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
333. 0.000 0.000 ↓ 0.0 0

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

334. 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_21 (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_11.store_src_cd)::text)
  • Heap Fetches: 0
335. 0.123 0.192 ↑ 1.0 248 1

Materialize (cost=0.00..9.72 rows=248 width=9) (actual time=0.009..0.192 rows=248 loops=1)

336. 0.069 0.069 ↑ 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_12 (cost=0.00..8.48 rows=248 width=9) (actual time=0.003..0.069 rows=248 loops=1)

337. 0.002 0.089 ↑ 2.0 1 1

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.088..0.089 rows=1 loops=1)

338. 0.001 0.087 ↑ 2.0 1 1

Subquery Scan on dist_8 (cost=0.72..51.04 rows=2 width=8) (actual time=0.086..0.087 rows=1 loops=1)

339. 0.038 0.086 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_22.store_src_cd
340. 0.005 0.048 ↑ 1.3 3 1

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

341. 0.016 0.016 ↑ 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_22 (cost=0.43..17.68 rows=4 width=16) (actual time=0.015..0.016 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
342. 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 d_entity_2018_12_27_07_01_12_8 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.009 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_22.entity_01_cd)::text)
343. 0.036 12.950 ↑ 1,105.0 1 1

Nested Loop (cost=2.55..754,423.38 rows=1,105 width=98) (actual time=12.731..12.950 rows=1 loops=1)

344. 0.167 12.830 ↑ 552.0 1 1

Nested Loop (cost=1.83..754,350.25 rows=552 width=98) (actual time=12.613..12.830 rows=1 loops=1)

  • Join Filter: ((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)
  • Rows Removed by Join Filter: 155
345. 0.098 0.183 ↑ 1.7 156 1

Nested Loop (cost=0.84..94.03 rows=264 width=98) (actual time=0.038..0.183 rows=156 loops=1)

346. 0.004 0.022 ↑ 2.0 1 1

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

347. 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_14 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

348. 0.017 0.017 ↑ 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=14) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
349. 0.063 0.063 ↓ 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.015..0.063 rows=156 loops=1)

  • Index Cond: ((rpt_to_cd)::text = (d_store_2018_12_27_07_01_39_17.rpt_to_cd)::text)
350. 0.024 12.480 ↑ 123.0 1 156

Materialize (cost=0.99..753,769.44 rows=123 width=26) (actual time=0.079..0.080 rows=1 loops=156)

351. 0.070 12.456 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.297..12.456 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_12.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_13.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
352. 0.003 12.198 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=17) (actual time=12.197..12.198 rows=1 loops=1)

353. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 1
354. 0.003 12.182 ↓ 0.0 0 1

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

  • Filter: (((p_14.store_src_cd)::text = '7425774'::text) AND ((p_14.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_12.store_src_cd)::text) AND ((p_14.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_12.master_pkg_sku_cd)::text))
355. 0.001 12.179 ↓ 0.0 0 1

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

356. 0.003 12.178 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_23.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_14.entity_01_cd)::text)
357. 12.175 12.175 ↓ 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_14 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.175..12.175 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_12.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
358. 0.000 0.000 ↓ 0.0 0

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

359. 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_23 (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_12.store_src_cd)::text)
  • Heap Fetches: 0
360. 0.120 0.188 ↑ 1.0 248 1

Materialize (cost=0.00..9.72 rows=248 width=9) (actual time=0.011..0.188 rows=248 loops=1)

361. 0.068 0.068 ↑ 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_13 (cost=0.00..8.48 rows=248 width=9) (actual time=0.003..0.068 rows=248 loops=1)

362. 0.003 0.084 ↑ 2.0 1 1

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.083..0.084 rows=1 loops=1)

363. 0.001 0.081 ↑ 2.0 1 1

Subquery Scan on dist_9 (cost=0.72..51.04 rows=2 width=8) (actual time=0.080..0.081 rows=1 loops=1)

364. 0.030 0.080 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_24.store_src_cd
365. 0.010 0.050 ↑ 1.3 3 1

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

366. 0.016 0.016 ↑ 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_24 (cost=0.43..17.68 rows=4 width=16) (actual time=0.014..0.016 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
367. 0.024 0.024 ↑ 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 d_entity_2018_12_27_07_01_12_9 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_24.entity_01_cd)::text)
368. 0.038 12.892 ↑ 1,141.0 1 1

Nested Loop (cost=2.55..754,462.71 rows=1,141 width=97) (actual time=12.690..12.892 rows=1 loops=1)

369. 0.107 12.768 ↑ 570.0 1 1

Nested Loop (cost=1.83..754,388.86 rows=570 width=97) (actual time=12.569..12.768 rows=1 loops=1)

  • Join Filter: ((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)
  • Rows Removed by Join Filter: 155
370. 0.099 0.181 ↑ 1.8 156 1

Nested Loop (cost=0.84..97.59 rows=283 width=97) (actual time=0.035..0.181 rows=156 loops=1)

371. 0.001 0.019 ↑ 2.0 1 1

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

372. 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_15 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

373. 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_18 (cost=0.43..8.47 rows=2 width=14) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
374. 0.063 0.063 ↓ 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.012..0.063 rows=156 loops=1)

  • Index Cond: ((ult_parent_cd)::text = (d_store_2018_12_27_07_01_39_18.ult_parent_cd)::text)
375. 0.071 12.480 ↑ 123.0 1 156

Materialize (cost=0.99..753,769.44 rows=123 width=26) (actual time=0.079..0.080 rows=1 loops=156)

376. 0.070 12.409 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.251..12.409 rows=1 loops=1)

  • Join Filter: ((f_store_sku_pkg_agg_2018_12_27_07_28_06_13.master_pkg_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_14.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 247
377. 0.005 12.154 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=17) (actual time=12.153..12.154 rows=1 loops=1)

378. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

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

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

  • Filter: (((p_15.store_src_cd)::text = '7425774'::text) AND ((p_15.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_13.store_src_cd)::text) AND ((p_15.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_13.master_pkg_sku_cd)::text))
380. 0.001 12.135 ↓ 0.0 0 1

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

381. 0.003 12.134 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_25.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_15.entity_01_cd)::text)
382. 12.131 12.131 ↓ 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_15 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.131..12.131 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_13.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
383. 0.000 0.000 ↓ 0.0 0

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

384. 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_25 (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_13.store_src_cd)::text)
  • Heap Fetches: 0
385. 0.119 0.185 ↑ 1.0 248 1

Materialize (cost=0.00..9.72 rows=248 width=9) (actual time=0.007..0.185 rows=248 loops=1)

386. 0.066 0.066 ↑ 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_14 (cost=0.00..8.48 rows=248 width=9) (actual time=0.002..0.066 rows=248 loops=1)

387. 0.002 0.086 ↑ 2.0 1 1

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.085..0.086 rows=1 loops=1)

388. 0.002 0.084 ↑ 2.0 1 1

Subquery Scan on dist_10 (cost=0.72..51.04 rows=2 width=8) (actual time=0.083..0.084 rows=1 loops=1)

389. 0.032 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_26.store_src_cd
390. 0.013 0.050 ↑ 1.3 3 1

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

391. 0.016 0.016 ↑ 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_26 (cost=0.43..17.68 rows=4 width=16) (actual time=0.014..0.016 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
392. 0.021 0.021 ↑ 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 d_entity_2018_12_27_07_01_12_10 (cost=0.29..8.31 rows=1 width=30) (actual time=0.007..0.007 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_26.entity_01_cd)::text)
393. 0.003 0.076 ↑ 2.0 1 1

Materialize (cost=0.72..52.08 rows=2 width=8) (actual time=0.074..0.076 rows=1 loops=1)

394. 0.004 0.073 ↑ 2.0 1 1

Nested Loop (cost=0.72..52.07 rows=2 width=8) (actual time=0.072..0.073 rows=1 loops=1)

395. 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_1 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

396. 0.026 0.068 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_27.store_src_cd
397. 0.008 0.042 ↑ 1.3 3 1

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

398. 0.013 0.013 ↑ 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_27 (cost=0.43..17.68 rows=4 width=16) (actual time=0.012..0.013 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
399. 0.021 0.021 ↑ 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 d_entity_2018_12_27_07_01_12_11 (cost=0.29..8.31 rows=1 width=30) (actual time=0.006..0.007 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_27.entity_01_cd)::text)
400.          

SubPlan (forHashAggregate)

401. 0.006 0.014 ↑ 5.0 1 1

Bitmap Heap Scan on brands_mv (cost=4.32..11.32 rows=5 width=418) (actual time=0.013..0.014 rows=1 loops=1)

  • Recheck Cond: (((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text = (brand_cd)::text)
  • Heap Blocks: exact=1
402. 0.008 0.008 ↑ 5.0 1 1

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

  • Index Cond: (((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text = (brand_cd)::text)
403. 0.006 0.011 ↑ 5.0 1 1

Bitmap Heap Scan on brands_mv brands_mv_1 (cost=4.32..11.32 rows=5 width=418) (actual time=0.010..0.011 rows=1 loops=1)

  • Recheck Cond: (((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text = (brand_cd)::text)
  • Heap Blocks: exact=1
404. 0.005 0.005 ↑ 5.0 1 1

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

  • Index Cond: (((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text = (brand_cd)::text)
405. 0.004 301.282 ↑ 1.0 1 1

Subquery Scan on c (cost=16.89..12,147.42 rows=1 width=32) (actual time=301.051..301.282 rows=1 loops=1)

406. 0.002 301.278 ↑ 1.0 1 1

Unique (cost=16.89..12,147.41 rows=1 width=152) (actual time=301.049..301.278 rows=1 loops=1)

407. 0.037 301.276 ↑ 4.0 1 1

Nested Loop (cost=16.89..12,147.39 rows=4 width=152) (actual time=301.047..301.276 rows=1 loops=1)

408. 0.008 301.136 ↑ 2.0 1 1

Nested Loop Left Join (cost=16.17..12,096.19 rows=2 width=152) (actual time=300.909..301.136 rows=1 loops=1)

  • Join Filter: (((d_store_2018_12_27_07_01_39_43.store_src_cd)::text = ("*SELECT* 2_12".tdlinx_store_cd)::text) AND (((d_item_sku_pkg_2018_12_27_07_05_22_27.brand_cd)::character varying(30))::text = ("*SELECT* 2_12".brand_cd)::text))
409. 0.006 12.647 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.42..6,148.79 rows=1 width=12) (actual time=12.433..12.647 rows=1 loops=1)

410. 0.005 0.361 ↑ 1.0 1 1

Nested Loop (cost=0.98..28.44 rows=1 width=29) (actual time=0.148..0.361 rows=1 loops=1)

411. 0.030 0.340 ↑ 1.0 1 1

Nested Loop (cost=0.56..19.95 rows=1 width=21) (actual time=0.129..0.340 rows=1 loops=1)

412. 0.013 0.078 ↓ 29.0 29 1

Nested Loop (cost=0.00..11.36 rows=1 width=13) (actual time=0.023..0.078 rows=29 loops=1)

413. 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_42 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

414. 0.063 0.063 ↓ 29.0 29 1

Seq Scan on d_item_sku_pkg_2018_12_27_07_05_22 d_item_sku_pkg_2018_12_27_07_05_22_27 (cost=0.00..10.34 rows=1 width=13) (actual time=0.020..0.063 rows=29 loops=1)

  • Filter: (((brand_cd)::character varying(30))::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text)
  • Rows Removed by Filter: 219
415. 0.232 0.232 ↓ 0.0 0 29

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..8.58 rows=1 width=17) (actual time=0.008..0.008 rows=0 loops=29)

  • Index Cond: ((store_src_cd = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND (master_pkg_sku_cd = (d_item_sku_pkg_2018_12_27_07_05_22_27.master_pkg_sku_cd)::text))
  • Heap Fetches: 1
416. 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_43 (cost=0.43..8.47 rows=2 width=8) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
417. 0.002 12.280 ↓ 0.0 0 1

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

  • Filter: (((p_40.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_40.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_15.store_src_cd)::text) AND ((p_40.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_15.master_pkg_sku_cd)::text))
418. 0.002 12.278 ↓ 0.0 0 1

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

419. 0.002 12.276 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_64.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_40.entity_01_cd)::text)
420. 12.274 12.274 ↓ 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..6,101.56 rows=18 width=16) (actual time=12.274..12.274 rows=0 loops=1)

  • Filter: (((master_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_15.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
421. 0.000 0.000 ↓ 0.0 0

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

422. 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_64 (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_15.store_src_cd)::text)
  • Heap Fetches: 0
423. 0.002 288.481 ↑ 2.0 1 1

Append (cost=14.75..5,947.36 rows=2 width=226) (actual time=288.468..288.481 rows=1 loops=1)

424. 0.003 288.479 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_12 (cost=14.75..5,947.36 rows=2 width=226) (actual time=288.467..288.479 rows=1 loops=1)

425. 0.039 288.476 ↑ 2.0 1 1

Nested Loop (cost=14.75..5,947.34 rows=2 width=560) (actual time=288.465..288.476 rows=1 loops=1)

426.          

Initplan (forNested Loop)

427. 0.002 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)

428. 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_41 (cost=0.00..1.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

429. 0.003 288.407 ↑ 1.0 1 1

Nested Loop Left Join (cost=13.32..5,937.73 rows=1 width=560) (actual time=288.397..288.407 rows=1 loops=1)

430. 0.010 0.070 ↑ 1.0 1 1

Nested Loop (cost=4.44..14.93 rows=1 width=564) (actual time=0.060..0.070 rows=1 loops=1)

431. 0.004 0.031 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.46 rows=1 width=516) (actual time=0.024..0.031 rows=1 loops=1)

432. 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=0) (actual time=0.001..0.001 rows=1 loops=1)

433. 0.026 0.026 ↑ 1.0 1 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.44 rows=1 width=516) (actual time=0.021..0.026 rows=1 loops=1)

  • Filter: (((brand_cd)::character varying(30))::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text)
  • Rows Removed by Filter: 24
434. 0.012 0.029 ↑ 2.0 1 1

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) (actual time=0.028..0.029 rows=1 loops=1)

  • Recheck Cond: (((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_12.brand_cd)::text))
  • Heap Blocks: exact=1
435. 0.017 0.017 ↑ 2.0 1 1

Bitmap Index Scan on f_store_brand_agg_2018_12_27_07_29_24_pk (cost=0.00..4.44 rows=2 width=0) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_12.brand_cd)::text))
436. 0.001 288.334 ↓ 0.0 0 1

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

  • Filter: (((p_41.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_41.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_25.store_src_cd)::text) AND ((p_41.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_25.brand_cd)::text))
437. 0.002 288.333 ↓ 0.0 0 1

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

438. 0.003 288.331 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=288.331..288.331 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_65.entity_01_cd)::text)
439. 0.003 288.328 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=288.328..288.328 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_28.master_pkg_sku_cd)::text)
440. 288.325 288.325 ↓ 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=288.325..288.325 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
441. 0.000 0.000 ↓ 0.0 0

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

442. 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_28 (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)
443. 0.000 0.000 ↓ 0.0 0

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

444. 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_65 (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
445. 0.026 0.026 ↑ 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_44 (cost=0.43..8.47 rows=2 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
446. 0.004 0.103 ↑ 2.0 1 1

Materialize (cost=0.72..51.05 rows=2 width=8) (actual time=0.102..0.103 rows=1 loops=1)

447. 0.004 0.099 ↑ 2.0 1 1

Subquery Scan on dist_13 (cost=0.72..51.04 rows=2 width=8) (actual time=0.098..0.099 rows=1 loops=1)

448. 0.039 0.095 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_66.store_src_cd
449. 0.011 0.056 ↑ 1.3 3 1

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

450. 0.018 0.018 ↑ 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_66 (cost=0.43..17.68 rows=4 width=16) (actual time=0.016..0.018 rows=3 loops=1)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Heap Fetches: 3
451. 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 d_entity_2018_12_27_07_01_12_24 (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_66.entity_01_cd)::text)
452. 0.077 3,223.609 ↑ 20.0 1 1

Nested Loop (cost=344,732.84..868,036.93 rows=20 width=582) (actual time=3,223.589..3,223.609 rows=1 loops=1)

453. 0.033 2,335.671 ↑ 5.0 1 1

GroupAggregate (cost=172,359.26..689,678.23 rows=5 width=188) (actual time=2,335.671..2,335.671 rows=1 loops=1)

  • Group Key: agg_12.store_src_cd, ((agg_12.brand_cd)::character varying(30))
454. 0.011 2,335.638 ↑ 1.7 3 1

Append (cost=172,359.26..689,678.13 rows=5 width=188) (actual time=1,166.161..2,335.638 rows=3 loops=1)

455. 0.001 582.488 ↓ 0.0 0 1

Nested Loop (cost=172,359.26..172,419.59 rows=2 width=227) (actual time=582.488..582.488 rows=0 loops=1)

456. 0.009 582.487 ↓ 0.0 0 1

Nested Loop (cost=172,358.54..172,368.52 rows=1 width=227) (actual time=582.487..582.487 rows=0 loops=1)

457. 0.012 582.461 ↑ 1.0 1 1

Subquery Scan on agg_12 (cost=172,358.11..172,360.06 rows=1 width=110) (actual time=582.460..582.461 rows=1 loops=1)

  • Filter: ((((agg_12.brand_cd)::character varying(30))::text <> 'TOTAL'::text) AND (((agg_12.brand_cd)::character varying(30))::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text))
  • Rows Removed by Filter: 1
458. 0.042 582.449 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=582.447..582.449 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
459. 0.006 582.407 ↑ 30.0 2 1

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

460. 0.009 282.760 ↑ 58.0 1 1

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

461. 0.020 282.751 ↑ 58.0 1 1

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

462. 0.017 282.684 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=282.659..282.684 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
463. 0.010 282.628 ↑ 29.0 1 1

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

464. 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_26 (cost=0.43..120.90 rows=29 width=279) (actual time=0.014..0.016 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
465. 0.001 282.602 ↓ 0.0 0 1

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

  • Filter: (((p_42.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_42.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_26.store_src_cd)::text) AND ((p_42.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_26.brand_cd)::text))
466. 0.002 282.601 ↓ 0.0 0 1

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

467. 0.004 282.599 ↓ 0.0 0 1

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_42.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_67.entity_01_cd)::text)
468. 0.005 282.595 ↓ 0.0 0 1

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_42.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_29.master_pkg_sku_cd)::text)
469. 282.590 282.590 ↓ 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=16) (actual time=282.590..282.590 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
470. 0.000 0.000 ↓ 0.0 0

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

471. 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_29 (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)
472. 0.000 0.000 ↓ 0.0 0

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

473. 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_67 (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
474. 0.031 0.039 ↑ 1.0 25 1

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

475. 0.008 0.008 ↑ 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.004..0.008 rows=25 loops=1)

476. 0.014 0.047 ↑ 2.0 1 1

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

477. 0.006 0.033 ↑ 2.0 1 1

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

478. 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_45 (cost=0.00..1.01 rows=1 width=128) (actual time=0.002..0.002 rows=1 loops=1)

479. 0.025 0.025 ↑ 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.024..0.025 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
480. 0.005 299.641 ↑ 2.0 1 1

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

481. 0.034 299.636 ↑ 2.0 1 1

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

482. 0.006 0.102 ↑ 2.0 1 1

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

483. 0.006 0.081 ↑ 1.0 1 1

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

484. 0.008 0.023 ↑ 1.0 1 1

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

485. 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_46 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

486. 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_14 (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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
487. 0.010 0.052 ↑ 1.0 1 1

Subquery Scan on fb_13 (cost=0.43..121.14 rows=1 width=72) (actual time=0.051..0.052 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)
488. 0.019 0.042 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_27.store_src_cd
489. 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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
490. 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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
491. 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_46 (cost=0.43..8.47 rows=2 width=182) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
492. 0.002 299.500 ↓ 0.0 0 1

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

  • Filter: (((p_43.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_43.store_src_cd)::text = (d_store_2018_12_27_07_01_39_46.store_src_cd)::text))
493. 0.003 299.498 ↓ 0.0 0 1

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

494. 0.003 299.495 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_68.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_43.entity_01_cd)::text)
495. 299.492 299.492 ↓ 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=7) (actual time=299.492..299.492 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
496. 0.000 0.000 ↓ 0.0 0

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

497. 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_68 (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
498. 0.017 0.017 ↓ 0.0 0 1

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.43..8.45 rows=1 width=129) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (((tdlinx_store_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((brand_cd)::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text))
499. 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_69.store_src_cd
500. 0.000 0.000 ↓ 0.0 0

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

501. 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_69 (cost=0.43..17.68 rows=4 width=16) (never executed)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Heap Fetches: 0
502. 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_25 (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_69.entity_01_cd)::text)
503. 0.047 583.671 ↑ 1.0 1 1

Nested Loop (cost=172,359.25..172,419.59 rows=1 width=222) (actual time=583.668..583.671 rows=1 loops=1)

504. 0.010 583.527 ↑ 1.0 1 1

Nested Loop (cost=172,358.53..172,368.52 rows=1 width=222) (actual time=583.525..583.527 rows=1 loops=1)

505. 0.010 583.494 ↑ 1.0 1 1

Subquery Scan on agg_13 (cost=172,358.11..172,360.06 rows=1 width=220) (actual time=583.493..583.494 rows=1 loops=1)

  • Filter: ((((agg_13.brand_cd)::character varying(30))::text <> 'TOTAL'::text) AND (((agg_13.brand_cd)::character varying(30))::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text))
  • Rows Removed by Filter: 1
506. 0.041 583.484 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=583.481..583.484 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
507. 0.005 583.443 ↑ 30.0 2 1

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

508. 0.014 287.384 ↑ 58.0 1 1

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

509. 0.020 287.370 ↑ 58.0 1 1

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

510. 0.014 287.301 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=287.277..287.301 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
511. 0.011 287.248 ↑ 29.0 1 1

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

512. 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_28 (cost=0.43..120.90 rows=29 width=279) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
513. 0.002 287.221 ↓ 0.0 0 1

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

  • Filter: (((p_44.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_44.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_28.store_src_cd)::text) AND ((p_44.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_28.brand_cd)::text))
514. 0.001 287.219 ↓ 0.0 0 1

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

515. 0.005 287.218 ↓ 0.0 0 1

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_44.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_70.entity_01_cd)::text)
516. 0.002 287.213 ↓ 0.0 0 1

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_44.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_30.master_pkg_sku_cd)::text)
517. 287.211 287.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_44 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=287.211..287.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
518. 0.000 0.000 ↓ 0.0 0

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

519. 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_30 (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)
520. 0.000 0.000 ↓ 0.0 0

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

521. 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_70 (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
522. 0.022 0.039 ↑ 1.0 25 1

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

523. 0.017 0.017 ↑ 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.003..0.017 rows=25 loops=1)

524. 0.015 0.049 ↑ 2.0 1 1

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

525. 0.009 0.034 ↑ 2.0 1 1

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

526. 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_47 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

527. 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.024..0.024 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
528. 0.005 296.054 ↑ 2.0 1 1

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

529. 0.032 296.049 ↑ 2.0 1 1

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

530. 0.005 0.094 ↑ 2.0 1 1

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

531. 0.006 0.075 ↑ 1.0 1 1

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

532. 0.010 0.024 ↑ 1.0 1 1

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

533. 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_48 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

534. 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_15 (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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
535. 0.004 0.045 ↑ 1.0 1 1

Subquery Scan on fb_14 (cost=0.43..121.14 rows=1 width=72) (actual time=0.044..0.045 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)
536. 0.017 0.041 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_29.store_src_cd
537. 0.011 0.024 ↑ 29.0 1 1

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

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_15.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
538. 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_29 (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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
539. 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_48 (cost=0.43..8.47 rows=2 width=182) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
540. 0.001 295.923 ↓ 0.0 0 1

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

  • Filter: (((p_45.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_45.store_src_cd)::text = (d_store_2018_12_27_07_01_39_48.store_src_cd)::text))
541. 0.003 295.922 ↓ 0.0 0 1

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

542. 0.001 295.919 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_71.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_45.entity_01_cd)::text)
543. 295.918 295.918 ↓ 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_45 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=295.918..295.918 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
544. 0.000 0.000 ↓ 0.0 0

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

545. 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_71 (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
546. 0.023 0.023 ↑ 1.0 1 1

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.46 rows=1 width=123) (actual time=0.022..0.023 rows=1 loops=1)

  • 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 = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text))
547. 0.035 0.097 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_72.store_src_cd
548. 0.016 0.062 ↑ 1.3 3 1

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

549. 0.019 0.019 ↑ 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_72 (cost=0.43..17.68 rows=4 width=16) (actual time=0.016..0.019 rows=3 loops=1)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Heap Fetches: 3
550. 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 d_entity_2018_12_27_07_01_12_26 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.009 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_72.entity_01_cd)::text)
551. 0.048 587.299 ↑ 1.0 1 1

Nested Loop (cost=172,359.12..172,419.45 rows=1 width=232) (actual time=587.295..587.299 rows=1 loops=1)

552. 0.011 587.151 ↑ 1.0 1 1

Nested Loop (cost=172,358.40..172,368.38 rows=1 width=232) (actual time=587.148..587.151 rows=1 loops=1)

553. 0.012 587.120 ↑ 1.0 1 1

Subquery Scan on agg_14 (cost=172,358.11..172,360.06 rows=1 width=188) (actual time=587.119..587.120 rows=1 loops=1)

  • Filter: ((((agg_14.brand_cd)::character varying(30))::text <> 'TOTAL'::text) AND (((agg_14.brand_cd)::character varying(30))::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text))
  • Rows Removed by Filter: 1
554. 0.047 587.108 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=587.107..587.108 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
555. 0.003 587.061 ↑ 30.0 2 1

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

556. 0.013 289.958 ↑ 58.0 1 1

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

557. 0.018 289.945 ↑ 58.0 1 1

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

558. 0.017 289.887 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=289.862..289.887 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
559. 0.007 289.839 ↑ 29.0 1 1

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

560. 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_30 (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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
561. 0.002 289.817 ↓ 0.0 0 1

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

  • Filter: (((p_46.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_46.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_30.store_src_cd)::text) AND ((p_46.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_30.brand_cd)::text))
562. 0.001 289.815 ↓ 0.0 0 1

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

563. 0.004 289.814 ↓ 0.0 0 1

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_46.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_73.entity_01_cd)::text)
564. 0.001 289.810 ↓ 0.0 0 1

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_46.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_31.master_pkg_sku_cd)::text)
565. 289.809 289.809 ↓ 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_46 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=289.809..289.809 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
566. 0.000 0.000 ↓ 0.0 0

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

567. 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_31 (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)
568. 0.000 0.000 ↓ 0.0 0

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

569. 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_73 (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
570. 0.024 0.031 ↑ 1.0 25 1

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

571. 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_15 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.003..0.007 rows=25 loops=1)

572. 0.009 0.040 ↑ 2.0 1 1

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

573. 0.007 0.031 ↑ 2.0 1 1

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

574. 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_49 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

575. 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_49 (cost=0.43..8.47 rows=2 width=182) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
576. 0.005 297.100 ↑ 2.0 1 1

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

577. 0.032 297.095 ↑ 2.0 1 1

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

578. 0.006 0.093 ↑ 2.0 1 1

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

579. 0.006 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)

580. 0.009 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)

581. 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_50 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.001 rows=1 loops=1)

582. 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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
583. 0.007 0.045 ↑ 1.0 1 1

Subquery Scan on fb_15 (cost=0.43..121.14 rows=1 width=72) (actual time=0.044..0.045 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)
584. 0.014 0.038 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_31.store_src_cd
585. 0.010 0.024 ↑ 29.0 1 1

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

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_16.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
586. 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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
587. 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_50 (cost=0.43..8.47 rows=2 width=182) (actual time=0.012..0.014 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
588. 0.002 296.970 ↓ 0.0 0 1

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

  • Filter: (((p_47.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_47.store_src_cd)::text = (d_store_2018_12_27_07_01_39_50.store_src_cd)::text))
589. 0.003 296.968 ↓ 0.0 0 1

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

590. 0.002 296.965 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_74.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_47.entity_01_cd)::text)
591. 296.963 296.963 ↓ 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_47 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=296.963..296.963 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
592. 0.000 0.000 ↓ 0.0 0

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

593. 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_74 (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
594. 0.020 0.020 ↑ 1.0 1 1

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) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: (((rpt_to_cd)::text = (agg_14.rpt_to_cd)::text) AND ((brand_cd)::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text))
595. 0.036 0.100 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_75.store_src_cd
596. 0.017 0.064 ↑ 1.3 3 1

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

597. 0.020 0.020 ↑ 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_75 (cost=0.43..17.68 rows=4 width=16) (actual time=0.016..0.020 rows=3 loops=1)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Heap Fetches: 3
598. 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 d_entity_2018_12_27_07_01_12_27 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.009 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_75.entity_01_cd)::text)
599. 0.046 582.169 ↑ 1.0 1 1

Nested Loop (cost=172,359.12..172,419.45 rows=1 width=232) (actual time=582.166..582.169 rows=1 loops=1)

600. 0.007 582.028 ↑ 1.0 1 1

Nested Loop (cost=172,358.40..172,368.38 rows=1 width=232) (actual time=582.026..582.028 rows=1 loops=1)

601. 0.013 582.003 ↑ 1.0 1 1

Subquery Scan on agg_15 (cost=172,358.11..172,360.06 rows=1 width=188) (actual time=582.002..582.003 rows=1 loops=1)

  • Filter: ((((agg_15.brand_cd)::character varying(30))::text <> 'TOTAL'::text) AND (((agg_15.brand_cd)::character varying(30))::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text))
  • Rows Removed by Filter: 1
602. 0.047 581.990 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=581.988..581.990 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
603. 0.004 581.943 ↑ 30.0 2 1

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

604. 0.011 287.261 ↑ 58.0 1 1

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

605. 0.026 287.250 ↑ 58.0 1 1

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

606. 0.028 287.184 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=287.159..287.184 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
607. 0.012 287.132 ↑ 29.0 1 1

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

608. 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_32 (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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
609. 0.002 287.106 ↓ 0.0 0 1

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

  • Filter: (((p_48.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_48.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_32.store_src_cd)::text) AND ((p_48.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_32.brand_cd)::text))
610. 0.002 287.104 ↓ 0.0 0 1

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

611. 0.003 287.102 ↓ 0.0 0 1

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_48.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_76.entity_01_cd)::text)
612. 0.004 287.099 ↓ 0.0 0 1

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_48.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_32.master_pkg_sku_cd)::text)
613. 287.095 287.095 ↓ 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_48 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=287.095..287.095 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
614. 0.000 0.000 ↓ 0.0 0

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

615. 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_32 (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)
616. 0.000 0.000 ↓ 0.0 0

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

617. 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_76 (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
618. 0.018 0.024 ↑ 1.0 25 1

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

619. 0.006 0.006 ↑ 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.003..0.006 rows=25 loops=1)

620. 0.008 0.040 ↑ 2.0 1 1

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

621. 0.005 0.032 ↑ 2.0 1 1

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

622. 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_51 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

623. 0.025 0.025 ↑ 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.024..0.025 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
624. 0.006 294.678 ↑ 2.0 1 1

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

625. 0.026 294.672 ↑ 2.0 1 1

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

626. 0.008 0.094 ↑ 2.0 1 1

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

627. 0.005 0.073 ↑ 1.0 1 1

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

628. 0.010 0.025 ↑ 1.0 1 1

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

629. 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_52 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

630. 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_17 (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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
631. 0.006 0.043 ↑ 1.0 1 1

Subquery Scan on fb_16 (cost=0.43..121.14 rows=1 width=72) (actual time=0.042..0.043 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)
632. 0.013 0.037 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_33.store_src_cd
633. 0.010 0.024 ↑ 29.0 1 1

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

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_17.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
634. 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_33 (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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
635. 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_52 (cost=0.43..8.47 rows=2 width=182) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
636. 0.002 294.552 ↓ 0.0 0 1

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

  • Filter: (((p_49.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_49.store_src_cd)::text = (d_store_2018_12_27_07_01_39_52.store_src_cd)::text))
637. 0.003 294.550 ↓ 0.0 0 1

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

638. 0.003 294.547 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_77.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_49.entity_01_cd)::text)
639. 294.544 294.544 ↓ 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_49 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=294.544..294.544 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
640. 0.000 0.000 ↓ 0.0 0

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

641. 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_77 (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
642. 0.018 0.018 ↑ 1.0 1 1

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) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: (((ult_parent_cd)::text = (agg_15.ult_parent_cd)::text) AND ((brand_cd)::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text))
643. 0.033 0.095 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_78.store_src_cd
644. 0.017 0.062 ↑ 1.3 3 1

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

645. 0.018 0.018 ↑ 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_78 (cost=0.43..17.68 rows=4 width=16) (actual time=0.015..0.018 rows=3 loops=1)

  • Index Cond: (store_src_cd = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Heap Fetches: 3
646. 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 d_entity_2018_12_27_07_01_12_28 (cost=0.29..8.31 rows=1 width=30) (actual time=0.008..0.009 rows=1 loops=3)

  • Index Cond: ((entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_78.entity_01_cd)::text)
647. 0.005 887.861 ↑ 4.0 1 1

Materialize (cost=172,373.58..178,358.27 rows=4 width=660) (actual time=887.842..887.861 rows=1 loops=1)

648. 0.004 887.856 ↑ 4.0 1 1

Nested Loop (cost=172,373.58..178,358.25 rows=4 width=660) (actual time=887.838..887.856 rows=1 loops=1)

649. 0.010 887.744 ↑ 2.0 1 1

Nested Loop Left Join (cost=172,372.86..178,307.15 rows=2 width=660) (actual time=887.728..887.744 rows=1 loops=1)

  • 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))
650. 0.010 600.438 ↑ 1.0 1 1

Subquery Scan on agg_11 (cost=172,358.11..172,359.76 rows=1 width=480) (actual time=600.437..600.438 rows=1 loops=1)

  • Filter: (((agg_11.brand_cd)::character varying(30))::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text)
  • Rows Removed by Filter: 1
651. 0.046 600.428 ↑ 30.0 2 1

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

  • 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
652. 0.002 600.382 ↑ 30.0 2 1

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

653. 0.017 303.308 ↑ 58.0 1 1

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

654. 0.020 303.291 ↑ 58.0 1 1

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

655. 0.015 303.227 ↑ 29.0 1 1

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

  • 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)
  • Rows Removed by Join Filter: 24
656. 0.010 303.177 ↑ 29.0 1 1

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

657. 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_34 (cost=0.43..120.90 rows=29 width=279) (actual time=0.014..0.016 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
658. 0.002 303.151 ↓ 0.0 0 1

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

  • Filter: (((p_50.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_50.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_34.store_src_cd)::text) AND ((p_50.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_34.brand_cd)::text))
659. 0.001 303.149 ↓ 0.0 0 1

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

660. 0.005 303.148 ↓ 0.0 0 1

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_50.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_79.entity_01_cd)::text)
661. 0.002 303.143 ↓ 0.0 0 1

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_50.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_33.master_pkg_sku_cd)::text)
662. 303.141 303.141 ↓ 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_50 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=303.141..303.141 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
663. 0.000 0.000 ↓ 0.0 0

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

664. 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_33 (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)
665. 0.000 0.000 ↓ 0.0 0

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

666. 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_79 (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
667. 0.030 0.035 ↑ 1.0 25 1

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

668. 0.005 0.005 ↑ 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_17 (cost=0.00..1.25 rows=25 width=1,032) (actual time=0.004..0.005 rows=25 loops=1)

669. 0.008 0.044 ↑ 2.0 1 1

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

670. 0.006 0.036 ↑ 2.0 1 1

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

671. 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_53 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

672. 0.028 0.028 ↑ 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_53 (cost=0.43..8.47 rows=2 width=182) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
673. 0.004 297.072 ↑ 2.0 1 1

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

674. 0.031 297.068 ↑ 2.0 1 1

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

675. 0.005 0.095 ↑ 2.0 1 1

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

676. 0.005 0.075 ↑ 1.0 1 1

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

677. 0.008 0.025 ↑ 1.0 1 1

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

678. 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_54 (cost=0.00..1.01 rows=1 width=128) (actual time=0.001..0.002 rows=1 loops=1)

679. 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_18 (cost=0.42..8.44 rows=1 width=295) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
680. 0.008 0.045 ↑ 1.0 1 1

Subquery Scan on fb_17 (cost=0.43..121.14 rows=1 width=72) (actual time=0.043..0.045 rows=1 loops=1)

  • Filter: ((fb_17.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_18.store_src_cd)::text)
681. 0.013 0.037 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_35.store_src_cd
682. 0.009 0.024 ↑ 29.0 1 1

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

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_18.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
683. 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_35 (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 = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
684. 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_54 (cost=0.43..8.47 rows=2 width=182) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
685. 0.002 296.942 ↓ 0.0 0 1

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

  • Filter: (((p_51.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_51.store_src_cd)::text = (d_store_2018_12_27_07_01_39_54.store_src_cd)::text))
686. 0.003 296.940 ↓ 0.0 0 1

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

687. 0.002 296.937 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_80.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_51.entity_01_cd)::text)
688. 296.935 296.935 ↓ 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_51 (cost=0.00..5,840.38 rows=11,608 width=7) (actual time=296.935..296.935 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
689. 0.000 0.000 ↓ 0.0 0

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

690. 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_80 (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
691. 0.004 287.296 ↑ 2.0 1 1

Append (cost=14.75..5,947.36 rows=2 width=266) (actual time=287.282..287.296 rows=1 loops=1)

692. 0.003 287.292 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_13 (cost=14.75..5,947.36 rows=2 width=266) (actual time=287.280..287.292 rows=1 loops=1)

693. 0.040 287.289 ↑ 2.0 1 1

Nested Loop (cost=14.75..5,947.34 rows=2 width=560) (actual time=287.277..287.289 rows=1 loops=1)

694.          

Initplan (forNested Loop)

695. 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)

696. 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=32) (actual time=0.002..0.002 rows=1 loops=1)

697. 0.003 287.220 ↑ 1.0 1 1

Nested Loop Left Join (cost=13.32..5,937.73 rows=1 width=560) (actual time=287.210..287.220 rows=1 loops=1)

698. 0.011 0.060 ↑ 1.0 1 1

Nested Loop (cost=4.44..14.93 rows=1 width=564) (actual time=0.050..0.060 rows=1 loops=1)

699. 0.004 0.020 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.46 rows=1 width=516) (actual time=0.013..0.020 rows=1 loops=1)

700. 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_55 (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

701. 0.015 0.015 ↑ 1.0 1 1

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.44 rows=1 width=516) (actual time=0.009..0.015 rows=1 loops=1)

  • Filter: (((brand_cd)::character varying(30))::text = ((d_item_sku_pkg_2018_12_27_07_05_22.brand_cd)::character varying(30))::text)
  • Rows Removed by Filter: 24
702. 0.009 0.029 ↑ 2.0 1 1

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) (actual time=0.028..0.029 rows=1 loops=1)

  • Recheck Cond: (((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_18.brand_cd)::text))
  • Heap Blocks: exact=1
703. 0.020 0.020 ↑ 2.0 1 1

Bitmap Index Scan on f_store_brand_agg_2018_12_27_07_29_24_pk (cost=0.00..4.44 rows=2 width=0) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: (((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_18.brand_cd)::text))
704. 0.002 287.157 ↓ 0.0 0 1

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

  • Filter: (((p_52.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text) AND ((p_52.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_36.store_src_cd)::text) AND ((p_52.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_36.brand_cd)::text))
705. 0.002 287.155 ↓ 0.0 0 1

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

706. 0.003 287.153 ↓ 0.0 0 1

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_52.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_81.entity_01_cd)::text)
707. 0.001 287.150 ↓ 0.0 0 1

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_52.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_34.master_pkg_sku_cd)::text)
708. 287.149 287.149 ↓ 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_52 (cost=0.00..5,840.38 rows=11,608 width=16) (actual time=287.149..287.149 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
709. 0.000 0.000 ↓ 0.0 0

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

710. 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_34 (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)
711. 0.000 0.000 ↓ 0.0 0

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

712. 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_81 (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
713. 0.026 0.026 ↑ 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_55 (cost=0.43..8.47 rows=2 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)