explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zaiT

Settings
# exclusive inclusive rows x rows loops node
1. 1,159.478 13,237.394 ↑ 800.0 1 1

Hash Right Join (cost=10,992,399.02..108,355,664.20 rows=800 width=161) (actual time=13,237.389..13,237.394 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,311.536 12,077.916 ↑ 25.0 1 1

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

  • Group Key: d_store_2018_12_27_07_01_39_3.store_src_cd
3. 0.118 6,564.525 ↑ 25.0 1 1

HashAggregate (cost=10,647,297.69..50,049,547.56 rows=25 width=272) (actual time=6,564.524..6,564.525 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.011 733.736 ↑ 9,674.0 1 1

Merge Left Join (cost=8,383,759.62..10,646,451.22 rows=9,674 width=272) (actual time=733.179..733.736 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.002 669.782 ↑ 605.0 1 1

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

6. 0.006 669.708 ↑ 303.0 1 1

Nested Loop Left Join (cost=5,452,641.27..6,960,314.83 rows=303 width=249) (actual time=669.489..669.708 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.003 656.971 ↑ 246.0 1 1

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

8. 0.004 656.937 ↑ 123.0 1 1

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

9. 0.008 644.617 ↑ 123.0 1 1

Merge Join (cost=5,452,637.98..5,452,640.83 rows=123 width=121) (actual time=644.615..644.617 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.004 0.225 ↑ 123.0 1 1

Sort (cost=516.02..516.32 rows=123 width=81) (actual time=0.225..0.225 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.011 0.221 ↑ 123.0 1 1

Hash Join (cost=12.14..511.75 rows=123 width=81) (actual time=0.220..0.221 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.017 0.017 ↑ 123.0 1 1

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
14. 0.086 0.086 ↑ 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.003..0.086 rows=248 loops=1)

15. 0.004 644.384 ↑ 200.0 1 1

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

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

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

17. 0.019 644.377 ↑ 200.0 1 1

HashAggregate (cost=5,452,109.32..5,452,112.32 rows=200 width=49) (actual time=644.377..644.377 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.003 644.358 ↑ 702.0 2 1

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

19. 0.036 605.792 ↑ 753.0 1 1

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

20. 0.010 605.682 ↑ 376.0 1 1

Nested Loop Left Join (cost=3.84..1,681,246.02 rows=376 width=275) (actual time=28.650..605.682 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.002 14.478 ↑ 246.0 1 1

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

22. 0.065 14.451 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=95) (actual time=14.289..14.451 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.010 14.197 ↑ 123.0 1 1

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

24. 0.011 0.011 ↑ 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.010..0.011 rows=1 loops=1)

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

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

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

27. 0.004 14.174 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=14.174..14.174 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. 14.170 14.170 ↓ 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=14.170..14.170 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.110 0.189 ↑ 1.0 248 1

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

32. 0.079 0.079 ↑ 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.003..0.079 rows=248 loops=1)

33. 0.003 0.025 ↑ 2.0 1 1

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

34. 0.003 0.022 ↑ 2.0 1 1

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

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

36. 0.018 0.018 ↑ 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.016..0.018 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
37. 0.006 591.194 ↑ 102.0 3 1

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

38. 0.004 591.188 ↑ 102.0 3 1

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

39. 0.003 14.545 ↑ 246.0 1 1

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

40. 0.027 14.542 ↑ 246.0 1 1

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

41.          

Initplan (forNested Loop)

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

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

44. 0.282 14.487 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.51 rows=123 width=57) (actual time=14.277..14.487 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.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_3 (cost=0.00..8.48 rows=248 width=13) (actual time=0.001..0.069 rows=248 loops=1)

46. 0.000 14.136 ↑ 123.0 1 248

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

47. 0.004 14.150 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=53) (actual time=14.148..14.150 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.003 14.131 ↓ 0.0 0 1

Subquery Scan on p_3 (cost=0.43..6,120.35 rows=1 width=17) (actual time=14.131..14.131 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 14.128 ↓ 0.0 0 1

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

51. 0.003 14.127 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=14.127..14.127 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. 14.124 14.124 ↓ 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=14.124..14.124 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.025 ↑ 2.0 1 1

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

56. 0.003 0.022 ↑ 2.0 1 1

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

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

58. 0.018 0.018 ↑ 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.017..0.018 rows=1 loops=1)

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

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

60. 0.025 287.607 ↑ 58.0 1 1

Nested Loop (cost=10.74..171,908.79 rows=58 width=560) (actual time=287.580..287.607 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.012 287.549 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=560) (actual time=287.526..287.549 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 287.508 ↑ 29.0 1 1

Nested Loop Left Join (cost=9.30..171,882.17 rows=29 width=48) (actual time=287.507..287.508 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.001 287.488 ↓ 0.0 0 1

Subquery Scan on p_4 (cost=8.87..5,922.79 rows=1 width=12) (actual time=287.488..287.488 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.002 287.487 ↓ 0.0 0 1

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

69. 0.004 287.485 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=287.485..287.485 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.002 287.481 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=287.481..287.481 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. 287.479 287.479 ↓ 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=287.479..287.479 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.029 ↑ 1.0 25 1

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

77. 0.012 0.012 ↑ 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.012 rows=25 loops=1)

78. 0.002 0.030 ↑ 2.0 1 1

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

79. 0.004 0.028 ↑ 2.0 1 1

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

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

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

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

83. 0.032 289.029 ↑ 2.0 1 1

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

84.          

Initplan (forNested Loop Left Join)

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

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.003 0.075 ↑ 2.0 1 1

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

88. 0.004 0.059 ↑ 1.0 1 1

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

89. 0.006 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.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_1 (cost=0.42..8.44 rows=1 width=44) (actual time=0.011..0.012 rows=1 loops=1)

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

Subquery Scan on fb (cost=0.43..121.14 rows=1 width=8) (actual time=0.034..0.035 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.012 0.032 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_1.store_src_cd
94. 0.007 0.020 ↑ 29.0 1 1

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

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_1.store_src_cd)::text = '7425774'::text)
95. 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_1 (cost=0.43..120.90 rows=29 width=22) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '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.011..0.013 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
97. 0.003 288.919 ↓ 0.0 0 1

Subquery Scan on p_5 (cost=0.43..149.40 rows=1 width=8) (actual time=288.919..288.919 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.003 288.916 ↓ 0.0 0 1

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

99. 0.003 288.913 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=288.913..288.913 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. 288.910 288.910 ↓ 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=288.910..288.910 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.003 0.074 ↑ 2.0 1 1

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

104. 0.001 0.071 ↑ 2.0 1 1

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

105. 0.021 0.070 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_4.store_src_cd
106. 0.006 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)

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

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

GroupAggregate (cost=3,770,701.63..3,770,776.41 rows=651 width=49) (actual time=38.563..38.563 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.013 38.545 ↑ 3,251.0 2 1

Sort (cost=3,770,701.63..3,770,717.88 rows=6,502 width=49) (actual time=38.545..38.545 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.007 38.532 ↑ 3,251.0 2 1

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

112. 0.042 25.355 ↑ 4,838.0 1 1

Merge Join (cost=4.27..1,507,781.24 rows=4,838 width=126) (actual time=25.034..25.355 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.003 12.710 ↑ 492.0 1 1

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

114. 0.059 12.607 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.454..12.607 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.005 12.363 ↑ 123.0 1 1

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

116. 0.021 0.021 ↑ 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.021 rows=1 loops=1)

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

Subquery Scan on p_6 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.337..12.337 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.003 12.336 ↓ 0.0 0 1

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

119. 0.004 12.333 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.333..12.333 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.329 12.329 ↓ 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.329..12.329 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.115 0.185 ↑ 1.0 248 1

Materialize (cost=0.00..9.72 rows=248 width=9) (actual time=0.005..0.185 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.003..0.070 rows=248 loops=1)

125. 0.002 0.100 ↑ 4.0 1 1

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

126. 0.002 0.098 ↑ 4.0 1 1

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

127. 0.005 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)

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.018 0.018 ↑ 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.017..0.018 rows=1 loops=1)

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

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

131. 0.001 0.071 ↑ 2.0 1 1

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

132. 0.022 0.070 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_6.store_src_cd
133. 0.005 0.048 ↑ 1.3 3 1

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

134. 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_6 (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
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.003 12.603 ↑ 492.0 1 1

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

137. 0.003 12.600 ↑ 492.0 1 1

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

138. 0.064 12.500 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=135) (actual time=12.343..12.500 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.011 12.250 ↑ 123.0 1 1

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

140. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

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

Subquery Scan on p_7 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.228..12.228 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.001 12.226 ↓ 0.0 0 1

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

143. 0.003 12.225 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.225..12.225 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.222 12.222 ↓ 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.222..12.222 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.108 0.186 ↑ 1.0 248 1

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

148. 0.078 0.078 ↑ 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.004..0.078 rows=248 loops=1)

149. 0.002 0.097 ↑ 4.0 1 1

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

150. 0.003 0.095 ↑ 4.0 1 1

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

151. 0.004 0.022 ↑ 2.0 1 1

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

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

153. 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_10 (cost=0.43..8.47 rows=2 width=8) (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)
154. 0.001 0.070 ↑ 2.0 1 1

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

155. 0.002 0.069 ↑ 2.0 1 1

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

156. 0.019 0.067 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_8.store_src_cd
157. 0.005 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.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_8 (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
159. 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_2 (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_8.entity_01_cd)::text)
160. 0.001 0.022 ↓ 0.0 0 1

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

161. 0.001 0.021 ↓ 0.0 0 1

Nested Loop (cost=1.83..754,059.47 rows=270 width=49) (actual time=0.021..0.021 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.020 ↓ 0.0 0 1

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

163. 0.002 0.020 ↓ 0.0 0 1

Nested Loop (cost=0.43..9.50 rows=1 width=14) (actual time=0.020..0.020 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.016 0.016 ↓ 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.016..0.016 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.001 0.016 ↓ 0.0 0 1

Nested Loop (cost=2.55..754,138.35 rows=565 width=49) (actual time=0.016..0.016 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.000 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.003 0.015 ↓ 0.0 0 1

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

189. 0.000 0.000 ↑ 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.000..0.000 rows=1 loops=1)

190. 0.012 0.012 ↓ 0.0 0 1

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

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: (((max_ver_flg)::text = 'Y'::text) AND ((chain_ind_flg)::character(1) = 'Y'::bpchar))
  • Rows Removed by Filter: 1
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.002 13.132 ↑ 559.0 1 1

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

211. 0.032 13.060 ↑ 280.0 1 1

Nested Loop (cost=1.84..754,129.93 rows=280 width=49) (actual time=12.738..13.060 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.056 12.580 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.422..12.580 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.002 12.330 ↑ 123.0 1 1

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

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

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

Subquery Scan on p_10 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.311..12.311 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.002 12.309 ↓ 0.0 0 1

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

217. 0.003 12.307 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.307..12.307 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.304 12.304 ↓ 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.304..12.304 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.118 0.194 ↑ 1.0 248 1

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

222. 0.076 0.076 ↑ 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.076 rows=248 loops=1)

223. 0.071 0.448 ↑ 1.2 105 1

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

224. 0.058 0.377 ↑ 1.2 105 1

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

225. 0.004 0.024 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=18) (actual time=0.022..0.024 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.295 0.295 ↓ 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.255..0.295 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.070 ↑ 2.0 1 1

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

230. 0.001 0.068 ↑ 2.0 1 1

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

231. 0.020 0.067 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_14.store_src_cd
232. 0.004 0.047 ↑ 1.3 3 1

Nested Loop (cost=0.72..50.96 rows=4 width=38) (actual time=0.027..0.047 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.015..0.016 rows=3 loops=1)

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
234. 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_5 (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_14.entity_01_cd)::text)
235. 0.001 12.316 ↓ 0.0 0 1

Subquery Scan on p (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.316..12.316 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.002 12.315 ↓ 0.0 0 1

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

237. 0.004 12.313 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.313..12.313 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.309 12.309 ↓ 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.309..12.309 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.006 0.031 ↑ 2.0 1 1

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

242. 0.002 0.025 ↑ 2.0 1 1

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

243. 0.003 0.003 ↑ 1.0 1 1

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

244. 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_3 (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)
245. 0.002 12.731 ↑ 246.0 1 1

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

246. 0.002 12.729 ↑ 246.0 1 1

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

247. 0.001 12.727 ↑ 246.0 1 1

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

248. 0.027 12.726 ↑ 246.0 1 1

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

249.          

Initplan (forNested Loop)

250. 0.003 0.004 ↑ 1.0 1 1

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

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

252. 0.202 12.670 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.51 rows=123 width=57) (actual time=12.465..12.670 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.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_10 (cost=0.00..8.48 rows=248 width=13) (actual time=0.004..0.068 rows=248 loops=1)

254. 0.064 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.006 12.336 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=53) (actual time=12.334..12.336 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.315 ↓ 0.0 0 1

Subquery Scan on p_11 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.315..12.315 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.002 12.313 ↓ 0.0 0 1

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

259. 0.003 12.311 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.311..12.311 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.308 12.308 ↓ 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.308..12.308 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.002 0.025 ↑ 2.0 1 1

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

264. 0.003 0.023 ↑ 2.0 1 1

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

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

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

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

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

268. 0.003 0.071 ↑ 2.0 1 1

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

269. 0.019 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_17.store_src_cd
270. 0.005 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)

271. 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_17 (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
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.003 63.943 ↑ 800.0 1 1

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

274. 0.002 63.940 ↑ 800.0 1 1

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

275. 0.078 63.879 ↑ 400.0 1 1

Merge Left Join (cost=2,931,116.91..3,684,925.86 rows=400 width=49) (actual time=63.548..63.879 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.004 12.687 ↑ 246.0 1 1

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

277. 0.154 12.664 ↑ 123.0 1 1

Nested Loop (cost=1.13..753,791.35 rows=123 width=86) (actual time=12.338..12.664 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.110 0.110 ↑ 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.010..0.110 rows=248 loops=1)

  • Heap Fetches: 248
279. 0.112 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.005 12.288 ↑ 123.0 1 1

Nested Loop Left Join (cost=0.99..753,302.17 rows=123 width=86) (actual time=12.287..12.288 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.002 12.268 ↓ 0.0 0 1

Subquery Scan on p_1 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.268..12.268 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.002 12.266 ↓ 0.0 0 1

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

284. 0.003 12.264 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.264..12.264 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.261 12.261 ↓ 0.0 0 1

Seq Scan on x_priority_package_2018_12_27_06_56_20 x_priority_package_2018_12_27_06_56_20_11 (cost=0.00..6,101.56 rows=18 width=16) (actual time=12.261..12.261 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.003 0.019 ↑ 2.0 1 1

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

289. 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_4 (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 = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
290. 0.009 51.114 ↑ 325.0 1 1

Sort (cost=2,931,115.35..2,931,116.16 rows=325 width=49) (actual time=51.113..51.114 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.025 51.105 ↑ 325.0 1 1

HashAggregate (cost=2,931,094.48..2,931,098.54 rows=325 width=49) (actual time=51.104..51.105 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.080 ↑ 812.2 4 1

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

293. 0.035 12.613 ↑ 435.0 1 1

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

294. 0.278 12.486 ↑ 109.0 1 1

Nested Loop (cost=1.54..667,995.49 rows=109 width=79) (actual time=12.277..12.486 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.056 0.056 ↑ 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.056 rows=248 loops=1)

296. 0.002 12.152 ↑ 109.0 1 248

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

297. 0.004 12.150 ↑ 109.0 1 1

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

298. 0.005 0.039 ↑ 109.0 1 1

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

299. 0.018 0.018 ↑ 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.017..0.018 rows=1 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7425774'::text)
300. 0.016 0.016 ↑ 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.014..0.016 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.107 ↓ 0.0 0 1

Subquery Scan on p_12 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.107..12.107 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.106 ↓ 0.0 0 1

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

303. 0.002 12.104 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.104..12.104 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.102 12.102 ↓ 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.102..12.102 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.003 0.092 ↑ 4.0 1 1

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

308. 0.002 0.089 ↑ 4.0 1 1

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

309. 0.004 0.020 ↑ 2.0 1 1

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

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

311. 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_15 (cost=0.43..8.47 rows=2 width=8) (actual time=0.015..0.015 rows=1 loops=1)

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

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

313. 0.001 0.065 ↑ 2.0 1 1

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

314. 0.018 0.064 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_20.store_src_cd
315. 0.006 0.046 ↑ 1.3 3 1

Nested Loop (cost=0.72..50.96 rows=4 width=38) (actual time=0.026..0.046 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.015..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.032 12.755 ↑ 568.0 1 1

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

319. 0.122 12.657 ↑ 284.0 1 1

Nested Loop (cost=1.84..754,024.34 rows=284 width=94) (actual time=12.515..12.657 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.081 0.145 ↑ 1.2 105 1

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

321. 0.005 0.017 ↑ 2.0 1 1

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

322. 0.000 0.000 ↑ 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.000..0.000 rows=1 loops=1)

323. 0.012 0.012 ↑ 2.0 1 1

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

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
324. 0.047 0.047 ↓ 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.047 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.000 12.390 ↑ 123.0 1 105

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

326. 0.069 12.394 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.240..12.394 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.140 ↑ 123.0 1 1

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

328. 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_11 (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
329. 0.001 12.122 ↓ 0.0 0 1

Subquery Scan on p_13 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.122..12.122 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.001 12.121 ↓ 0.0 0 1

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

331. 0.003 12.120 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.120..12.120 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.117 12.117 ↓ 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.117..12.117 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.107 0.185 ↑ 1.0 248 1

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

336. 0.078 0.078 ↑ 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.078 rows=248 loops=1)

337. 0.002 0.066 ↑ 2.0 1 1

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

338. 0.001 0.064 ↑ 2.0 1 1

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

339. 0.016 0.063 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_22.store_src_cd
340. 0.006 0.047 ↑ 1.3 3 1

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

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

  • Index Cond: (store_src_cd = '7425774'::text)
  • Heap Fetches: 3
342. 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_8 (cost=0.29..8.31 rows=1 width=30) (actual time=0.007..0.008 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.032 12.862 ↑ 1,105.0 1 1

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

344. 0.105 12.766 ↑ 552.0 1 1

Nested Loop (cost=1.83..754,350.25 rows=552 width=98) (actual time=12.564..12.766 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.080 0.181 ↑ 1.7 156 1

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

346. 0.003 0.018 ↑ 2.0 1 1

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

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

348. 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_17 (cost=0.43..8.47 rows=2 width=14) (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)
349. 0.083 0.083 ↓ 7.8 156 1

Index Scan using stores_beer_rpt_tot_velocity__rpt_to_cd_brand_cd_master_pkg_idx on stores_beer_rpt_tot_velocity_by_sku_brand_mv (cost=0.42..42.07 rows=20 width=90) (actual time=0.016..0.083 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.066 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.067 12.414 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.259..12.414 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.168 ↑ 123.0 1 1

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

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

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

Subquery Scan on p_14 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.151..12.151 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.148 ↓ 0.0 0 1

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

356. 0.003 12.147 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.147..12.147 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.144 12.144 ↓ 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.144..12.144 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.111 0.179 ↑ 1.0 248 1

Materialize (cost=0.00..9.72 rows=248 width=9) (actual time=0.005..0.179 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.001 0.064 ↑ 2.0 1 1

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

363. 0.001 0.063 ↑ 2.0 1 1

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

364. 0.018 0.062 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_24.store_src_cd
365. 0.007 0.044 ↑ 1.3 3 1

Nested Loop (cost=0.72..50.96 rows=4 width=38) (actual time=0.025..0.044 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.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_9 (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_24.entity_01_cd)::text)
368. 0.030 12.844 ↑ 1,141.0 1 1

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

369. 0.086 12.747 ↑ 570.0 1 1

Nested Loop (cost=1.83..754,388.86 rows=570 width=97) (actual time=12.549..12.747 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.089 0.181 ↑ 1.8 156 1

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

371. 0.005 0.021 ↑ 2.0 1 1

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

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

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

  • Index Cond: ((store_src_cd)::text = '7425774'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
374. 0.071 0.071 ↓ 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.071 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.088 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.062 12.392 ↑ 123.0 1 1

Nested Loop (cost=0.99..753,768.83 rows=123 width=26) (actual time=12.236..12.392 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.004 12.143 ↑ 123.0 1 1

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

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

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

Subquery Scan on p_15 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.125..12.125 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.123 ↓ 0.0 0 1

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

381. 0.004 12.122 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.122..12.122 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.118 12.118 ↓ 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.118..12.118 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.115 0.187 ↑ 1.0 248 1

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

386. 0.072 0.072 ↑ 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.072 rows=248 loops=1)

387. 0.002 0.067 ↑ 2.0 1 1

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

388. 0.003 0.065 ↑ 2.0 1 1

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

389. 0.016 0.062 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_26.store_src_cd
390. 0.008 0.046 ↑ 1.3 3 1

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

391. 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_26 (cost=0.43..17.68 rows=4 width=16) (actual time=0.014..0.017 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.002 0.059 ↑ 2.0 1 1

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

394. 0.004 0.057 ↑ 2.0 1 1

Nested Loop (cost=0.72..52.07 rows=2 width=8) (actual time=0.056..0.057 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.014 0.052 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_27.store_src_cd
397. 0.007 0.038 ↑ 1.3 3 1

Nested Loop (cost=0.72..50.96 rows=4 width=38) (actual time=0.021..0.038 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.018 0.018 ↑ 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.006 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.014..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.004 0.007 ↑ 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.007..0.007 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.003 0.003 ↑ 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.003..0.003 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.002 302.043 ↑ 1.0 1 1

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

406. 0.004 302.041 ↑ 1.0 1 1

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

407. 0.034 302.037 ↑ 4.0 1 1

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

408. 0.009 301.922 ↑ 2.0 1 1

Nested Loop Left Join (cost=16.17..12,096.19 rows=2 width=152) (actual time=301.694..301.922 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.004 12.671 ↑ 1.0 1 1

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

410. 0.004 0.355 ↑ 1.0 1 1

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

411. 0.030 0.336 ↑ 1.0 1 1

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

412. 0.015 0.074 ↓ 29.0 29 1

Nested Loop (cost=0.00..11.36 rows=1 width=13) (actual time=0.021..0.074 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.057 0.057 ↓ 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.018..0.057 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.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_43 (cost=0.43..8.47 rows=2 width=8) (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)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
417. 0.002 12.312 ↓ 0.0 0 1

Subquery Scan on p_40 (cost=0.43..6,120.35 rows=1 width=17) (actual time=12.312..12.312 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.001 12.310 ↓ 0.0 0 1

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

419. 0.002 12.309 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,120.33 rows=1 width=17) (actual time=12.309..12.309 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.307 12.307 ↓ 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.307..12.307 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 289.242 ↑ 2.0 1 1

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

424. 0.004 289.240 ↑ 2.0 1 1

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

425. 0.031 289.236 ↑ 2.0 1 1

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

426.          

Initplan (forNested Loop)

427. 0.001 0.004 ↑ 1.0 1 1

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

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

429. 0.004 289.176 ↑ 1.0 1 1

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

430. 0.008 0.049 ↑ 1.0 1 1

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

431. 0.004 0.019 ↑ 1.0 1 1

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

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

433. 0.013 0.013 ↑ 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.007..0.013 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.005 0.022 ↑ 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.021..0.022 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 289.123 ↓ 0.0 0 1

Subquery Scan on p_41 (cost=8.87..5,922.79 rows=1 width=12) (actual time=289.123..289.123 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 289.122 ↓ 0.0 0 1

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

438. 0.002 289.120 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=289.120..289.120 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 289.118 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=289.118..289.118 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. 289.115 289.115 ↓ 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=289.115..289.115 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.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_44 (cost=0.43..8.47 rows=2 width=8) (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)
446. 0.003 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)

447. 0.001 0.078 ↑ 2.0 1 1

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

448. 0.025 0.077 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_66.store_src_cd
449. 0.011 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)

450. 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_66 (cost=0.43..17.68 rows=4 width=16) (actual time=0.015..0.017 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.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_24 (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_66.entity_01_cd)::text)
452. 0.067 3,201.474 ↑ 20.0 1 1

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

453. 0.021 2,324.704 ↑ 5.0 1 1

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

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

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

455. 0.001 578.617 ↓ 0.0 0 1

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

456. 0.008 578.616 ↓ 0.0 0 1

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

457. 0.009 578.592 ↑ 1.0 1 1

Subquery Scan on agg_12 (cost=172,358.11..172,360.06 rows=1 width=110) (actual time=578.592..578.592 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.037 578.583 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=578.582..578.583 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.003 578.546 ↑ 30.0 2 1

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

460. 0.008 281.582 ↑ 58.0 1 1

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

461. 0.020 281.574 ↑ 58.0 1 1

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

462. 0.011 281.517 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=281.493..281.517 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.008 281.475 ↑ 29.0 1 1

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

464. 0.014 0.014 ↑ 29.0 1 1

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

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

Subquery Scan on p_42 (cost=8.87..5,922.79 rows=1 width=12) (actual time=281.453..281.453 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 281.452 ↓ 0.0 0 1

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

467. 0.005 281.450 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=281.450..281.450 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.002 281.445 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=281.445..281.445 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. 281.443 281.443 ↓ 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=281.443..281.443 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.028 0.031 ↑ 1.0 25 1

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

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

476. 0.008 0.037 ↑ 2.0 1 1

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

477. 0.006 0.029 ↑ 2.0 1 1

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

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

479. 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_45 (cost=0.43..8.47 rows=2 width=182) (actual time=0.021..0.021 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.002 296.961 ↑ 2.0 1 1

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

481. 0.029 296.959 ↑ 2.0 1 1

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

482. 0.006 0.079 ↑ 2.0 1 1

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

483. 0.005 0.061 ↑ 1.0 1 1

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

484. 0.008 0.022 ↑ 1.0 1 1

Nested Loop (cost=0.42..9.46 rows=1 width=423) (actual time=0.018..0.022 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.012 0.012 ↑ 1.0 1 1

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

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
487. 0.003 0.034 ↑ 1.0 1 1

Subquery Scan on fb_13 (cost=0.43..121.14 rows=1 width=72) (actual time=0.033..0.034 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.011 0.031 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_27.store_src_cd
489. 0.007 0.020 ↑ 29.0 1 1

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

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_14.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
490. 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_27 (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)
491. 0.012 0.012 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_46 (cost=0.43..8.47 rows=2 width=182) (actual time=0.010..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)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
492. 0.001 296.851 ↓ 0.0 0 1

Subquery Scan on p_43 (cost=0.43..149.40 rows=1 width=8) (actual time=296.851..296.851 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.004 296.850 ↓ 0.0 0 1

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

494. 0.002 296.846 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=296.846..296.846 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. 296.844 296.844 ↓ 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=296.844..296.844 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.016 0.016 ↓ 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.016..0.016 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.044 582.232 ↑ 1.0 1 1

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

504. 0.009 582.109 ↑ 1.0 1 1

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

505. 0.008 582.077 ↑ 1.0 1 1

Subquery Scan on agg_13 (cost=172,358.11..172,360.06 rows=1 width=220) (actual time=582.076..582.077 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.037 582.069 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=582.067..582.069 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.003 582.032 ↑ 30.0 2 1

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

508. 0.008 287.626 ↑ 58.0 1 1

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

509. 0.019 287.618 ↑ 58.0 1 1

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

510. 0.015 287.563 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=287.538..287.563 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.010 287.516 ↑ 29.0 1 1

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

512. 0.029 0.029 ↑ 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.028..0.029 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.001 287.477 ↓ 0.0 0 1

Subquery Scan on p_44 (cost=8.87..5,922.79 rows=1 width=12) (actual time=287.477..287.477 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.002 287.476 ↓ 0.0 0 1

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

515. 0.004 287.474 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=287.474..287.474 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.003 287.470 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=287.470..287.470 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.467 287.467 ↓ 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.467..287.467 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.019 0.032 ↑ 1.0 25 1

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

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

524. 0.007 0.036 ↑ 2.0 1 1

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

525. 0.005 0.029 ↑ 2.0 1 1

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

526. 0.002 0.002 ↑ 1.0 1 1

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

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

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

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

529. 0.025 294.400 ↑ 2.0 1 1

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

530. 0.002 0.078 ↑ 2.0 1 1

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

531. 0.005 0.064 ↑ 1.0 1 1

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

532. 0.007 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)

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.014 0.014 ↑ 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.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)
535. 0.004 0.036 ↑ 1.0 1 1

Subquery Scan on fb_14 (cost=0.43..121.14 rows=1 width=72) (actual time=0.035..0.036 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.011 0.032 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_29.store_src_cd
537. 0.006 0.021 ↑ 29.0 1 1

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

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

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

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
539. 0.012 0.012 ↑ 2.0 1 1

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

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

Subquery Scan on p_45 (cost=0.43..149.40 rows=1 width=8) (actual time=294.297..294.297 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 294.296 ↓ 0.0 0 1

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

542. 0.001 294.293 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=294.293..294.293 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. 294.292 294.292 ↓ 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=294.292..294.292 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.028 0.079 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_72.store_src_cd
548. 0.006 0.051 ↑ 1.3 3 1

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

549. 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_72 (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
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.009..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.043 582.267 ↑ 1.0 1 1

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

552. 0.009 582.149 ↑ 1.0 1 1

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

553. 0.009 582.121 ↑ 1.0 1 1

Subquery Scan on agg_14 (cost=172,358.11..172,360.06 rows=1 width=188) (actual time=582.120..582.121 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.035 582.112 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=582.111..582.112 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.006 582.077 ↑ 30.0 2 1

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

556. 0.006 288.711 ↑ 58.0 1 1

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

557. 0.017 288.705 ↑ 58.0 1 1

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

558. 0.024 288.653 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=288.628..288.653 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.008 288.609 ↑ 29.0 1 1

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

560. 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_30 (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)
561. 0.002 288.587 ↓ 0.0 0 1

Subquery Scan on p_46 (cost=8.87..5,922.79 rows=1 width=12) (actual time=288.587..288.587 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.003 288.585 ↓ 0.0 0 1

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

563. 0.004 288.582 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=288.582..288.582 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.002 288.578 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=288.578..288.578 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. 288.576 288.576 ↓ 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=288.576..288.576 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.012 0.020 ↑ 1.0 25 1

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

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

572. 0.007 0.035 ↑ 2.0 1 1

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

573. 0.006 0.028 ↑ 2.0 1 1

Nested Loop (cost=0.43..9.50 rows=2 width=310) (actual time=0.026..0.028 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.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_49 (cost=0.43..8.47 rows=2 width=182) (actual time=0.020..0.021 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.004 293.360 ↑ 2.0 1 1

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

577. 0.022 293.356 ↑ 2.0 1 1

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

578. 0.003 0.077 ↑ 2.0 1 1

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

579. 0.006 0.061 ↑ 1.0 1 1

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

580. 0.006 0.021 ↑ 1.0 1 1

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

581. 0.002 0.002 ↑ 1.0 1 1

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

582. 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_16 (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)
583. 0.002 0.034 ↑ 1.0 1 1

Subquery Scan on fb_15 (cost=0.43..121.14 rows=1 width=72) (actual time=0.033..0.034 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.011 0.032 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_31.store_src_cd
585. 0.006 0.021 ↑ 29.0 1 1

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

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_16.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
586. 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_31 (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)
587. 0.013 0.013 ↑ 2.0 1 1

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

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

Subquery Scan on p_47 (cost=0.43..149.40 rows=1 width=8) (actual time=293.257..293.257 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 293.255 ↓ 0.0 0 1

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

590. 0.001 293.252 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=293.252..293.252 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. 293.251 293.251 ↓ 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=293.251..293.251 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.019 0.019 ↑ 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.018..0.019 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.022 0.075 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_75.store_src_cd
596. 0.013 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)

597. 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_75 (cost=0.43..17.68 rows=4 width=16) (actual time=0.014..0.016 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.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_27 (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_75.entity_01_cd)::text)
599. 0.048 581.558 ↑ 1.0 1 1

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

600. 0.009 581.438 ↑ 1.0 1 1

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

601. 0.009 581.410 ↑ 1.0 1 1

Subquery Scan on agg_15 (cost=172,358.11..172,360.06 rows=1 width=188) (actual time=581.409..581.410 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.036 581.401 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=581.399..581.401 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.365 ↑ 30.0 2 1

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

604. 0.006 287.340 ↑ 58.0 1 1

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

605. 0.017 287.334 ↑ 58.0 1 1

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

606. 0.012 287.283 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=287.258..287.283 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.010 287.241 ↑ 29.0 1 1

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

608. 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_32 (cost=0.43..120.90 rows=29 width=279) (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)
609. 0.001 287.218 ↓ 0.0 0 1

Subquery Scan on p_48 (cost=8.87..5,922.79 rows=1 width=12) (actual time=287.218..287.218 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.217 ↓ 0.0 0 1

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

611. 0.003 287.215 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=287.215..287.215 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.003 287.212 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=287.212..287.212 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.209 287.209 ↓ 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.209..287.209 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.015 0.030 ↑ 1.0 25 1

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

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

620. 0.009 0.034 ↑ 2.0 1 1

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

621. 0.005 0.025 ↑ 2.0 1 1

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

622. 0.001 0.001 ↑ 1.0 1 1

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

623. 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_51 (cost=0.43..8.47 rows=2 width=182) (actual time=0.018..0.019 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.005 294.021 ↑ 2.0 1 1

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

625. 0.025 294.016 ↑ 2.0 1 1

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

626. 0.005 0.080 ↑ 2.0 1 1

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

627. 0.004 0.062 ↑ 1.0 1 1

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

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

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.014 0.014 ↑ 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.014 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.005 0.036 ↑ 1.0 1 1

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

  • Filter: ((fb_16.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_17.store_src_cd)::text)
632. 0.010 0.031 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_33.store_src_cd
633. 0.008 0.021 ↑ 29.0 1 1

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

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

Index Scan using f_store_brand_agg_2018_12_27_07_29_24_pk on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_33 (cost=0.43..120.90 rows=29 width=22) (actual time=0.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)
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.011..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 293.911 ↓ 0.0 0 1

Subquery Scan on p_49 (cost=0.43..149.40 rows=1 width=8) (actual time=293.911..293.911 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.002 293.909 ↓ 0.0 0 1

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

638. 0.003 293.907 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=293.907..293.907 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. 293.904 293.904 ↓ 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=293.904..293.904 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.019 0.019 ↑ 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.019..0.019 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.022 0.072 ↑ 2.0 1 1

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

  • Group Key: x_store_entity_2018_12_27_07_38_25_78.store_src_cd
644. 0.007 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)

645. 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_78 (cost=0.43..17.68 rows=4 width=16) (actual time=0.015..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
646. 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_28 (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_78.entity_01_cd)::text)
647. 0.003 876.703 ↑ 4.0 1 1

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

648. 0.005 876.700 ↑ 4.0 1 1

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

649. 0.007 876.612 ↑ 2.0 1 1

Nested Loop Left Join (cost=172,372.86..178,307.15 rows=2 width=660) (actual time=876.596..876.612 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.008 589.440 ↑ 1.0 1 1

Subquery Scan on agg_11 (cost=172,358.11..172,359.76 rows=1 width=480) (actual time=589.439..589.440 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.033 589.432 ↑ 30.0 2 1

HashAggregate (cost=172,358.11..172,358.71 rows=60 width=1,585) (actual time=589.430..589.432 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.006 589.399 ↑ 30.0 2 1

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

653. 0.008 293.566 ↑ 58.0 1 1

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

654. 0.018 293.558 ↑ 58.0 1 1

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

655. 0.015 293.501 ↑ 29.0 1 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=1,315) (actual time=293.475..293.501 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.009 293.454 ↑ 29.0 1 1

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

657. 0.017 0.017 ↑ 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.015..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)
658. 0.001 293.428 ↓ 0.0 0 1

Subquery Scan on p_50 (cost=8.87..5,922.79 rows=1 width=12) (actual time=293.428..293.428 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.002 293.427 ↓ 0.0 0 1

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

660. 0.006 293.425 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=293.425..293.425 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 293.419 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=293.419..293.419 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. 293.417 293.417 ↓ 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=293.417..293.417 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.025 0.032 ↑ 1.0 25 1

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

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

669. 0.008 0.039 ↑ 2.0 1 1

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

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

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.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_53 (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)
673. 0.003 295.827 ↑ 2.0 1 1

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

674. 0.022 295.824 ↑ 2.0 1 1

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

675. 0.006 0.079 ↑ 2.0 1 1

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

676. 0.006 0.062 ↑ 1.0 1 1

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

677. 0.008 0.022 ↑ 1.0 1 1

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

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

679. 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_18 (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)
680. 0.003 0.034 ↑ 1.0 1 1

Subquery Scan on fb_17 (cost=0.43..121.14 rows=1 width=72) (actual time=0.033..0.034 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.011 0.031 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_35.store_src_cd
682. 0.007 0.020 ↑ 29.0 1 1

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

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_18.store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)
683. 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_35 (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)
684. 0.011 0.011 ↑ 2.0 1 1

Index Scan using d_store_2018_12_27_07_01_39_store_src_cd_idx on d_store_2018_12_27_07_01_39 d_store_2018_12_27_07_01_39_54 (cost=0.43..8.47 rows=2 width=182) (actual time=0.010..0.011 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 295.723 ↓ 0.0 0 1

Subquery Scan on p_51 (cost=0.43..149.40 rows=1 width=8) (actual time=295.723..295.723 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.002 295.721 ↓ 0.0 0 1

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

687. 0.001 295.719 ↓ 0.0 0 1

Nested Loop (cost=0.43..6,554.54 rows=44 width=8) (actual time=295.719..295.719 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. 295.718 295.718 ↓ 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=295.718..295.718 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.165 ↑ 2.0 1 1

Append (cost=14.75..5,947.36 rows=2 width=266) (actual time=287.150..287.165 rows=1 loops=1)

692. 0.003 287.161 ↑ 2.0 1 1

Subquery Scan on *SELECT* 2_13 (cost=14.75..5,947.36 rows=2 width=266) (actual time=287.148..287.161 rows=1 loops=1)

693. 0.030 287.158 ↑ 2.0 1 1

Nested Loop (cost=14.75..5,947.34 rows=2 width=560) (actual time=287.145..287.158 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.004 287.102 ↑ 1.0 1 1

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

698. 0.011 0.053 ↑ 1.0 1 1

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

699. 0.003 0.018 ↑ 1.0 1 1

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

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

701. 0.013 0.013 ↑ 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.007..0.013 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.005 0.024 ↑ 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.023..0.024 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.019 0.019 ↑ 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.019..0.019 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.045 ↓ 0.0 0 1

Subquery Scan on p_52 (cost=8.87..5,922.79 rows=1 width=12) (actual time=287.045..287.045 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.001 287.043 ↓ 0.0 0 1

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

706. 0.003 287.042 ↓ 0.0 0 1

Nested Loop (cost=8.87..5,922.78 rows=1 width=12) (actual time=287.042..287.042 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.002 287.039 ↓ 0.0 0 1

Hash Join (cost=8.44..5,894.17 rows=182 width=11) (actual time=287.039..287.039 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.037 287.037 ↓ 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.037..287.037 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.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_55 (cost=0.43..8.47 rows=2 width=8) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = (d_store_2018_12_27_07_01_39_3.store_src_cd)::text)