explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ISrE

Settings
# exclusive inclusive rows x rows loops node
1. 0.369 3,891.773 ↑ 96.0 1 1

Hash Right Join (cost=939,870.82..1,852,689.82 rows=96 width=155) (actual time=3,891.768..3,891.773 rows=1 loops=1)

  • Hash Cond: ((bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text)
2. 0.405 3,891.290 ↑ 12.0 1 1

GroupAggregate (cost=939,575.05..1,852,391.13 rows=12 width=40) (actual time=3,891.289..3,891.290 rows=1 loops=1)

  • Group Key: bc_retail_accounts_pkg_mv.tdlinx_store_cd
3. 0.497 3,890.694 ↑ 3.0 4 1

GroupAggregate (cost=939,575.05..1,841,264.71 rows=12 width=137) (actual time=2,161.015..3,890.694 rows=4 loops=1)

  • Group Key: bc_retail_accounts_pkg_mv.tdlinx_store_cd, bc_retail_accounts_pkg_mv.brand_cd
4. 0.021 1,582.101 ↑ 70.2 5 1

Nested Loop Left Join (cost=939,575.05..1,694,999.29 rows=351 width=137) (actual time=1,581.085..1,582.101 rows=5 loops=1)

  • Join Filter: (((bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv_1.tdlinx_store_cd)::text) AND ((bc_retail_accounts_pkg_mv.master_pkg_sku_cd)::text = (bc_retail_accounts_pkg_mv_1.master_pkg_sku_cd)::text))
  • Rows Removed by Join Filter: 20
5. 0.026 1,580.970 ↑ 29.2 5 1

Nested Loop Left Join (cost=935,647.35..1,690,541.20 rows=146 width=114) (actual time=1,580.121..1,580.970 rows=5 loops=1)

  • Join Filter: (((bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text = ("*SELECT* 1".tdlinx_store_cd)::text) AND ((bc_retail_accounts_pkg_mv.master_pkg_sku_cd)::text = ("*SELECT* 1".pkgsku_cd)::text))
  • Rows Removed by Join Filter: 20
6. 0.023 1,517.234 ↑ 23.8 5 1

Nested Loop (cost=935,644.93..936,230.20 rows=119 width=114) (actual time=1,517.171..1,517.234 rows=5 loops=1)

  • Join Filter: ((vw.sku)::text = (bc_retail_accounts_pkg_mv.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 20
7. 0.021 0.021 ↑ 23.8 5 1

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv (cost=0.43..223.20 rows=119 width=73) (actual time=0.015..0.021 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
8. 0.020 1,517.190 ↑ 40.0 5 5

Materialize (cost=935,644.49..935,650.49 rows=200 width=49) (actual time=303.431..303.438 rows=5 loops=5)

9. 0.003 1,517.170 ↑ 40.0 5 1

Subquery Scan on vw (cost=935,644.49..935,649.49 rows=200 width=49) (actual time=1,517.148..1,517.170 rows=5 loops=1)

10. 0.052 1,517.167 ↑ 40.0 5 1

HashAggregate (cost=935,644.49..935,647.49 rows=200 width=49) (actual time=1,517.148..1,517.167 rows=5 loops=1)

  • Group Key: bc_retail_accounts_pkg_mv_2.tdlinx_store_cd, bc_retail_accounts_pkg_mv_2.master_pkg_sku_cd
11. 0.006 1,517.115 ↑ 38.2 10 1

Append (cost=2.86..935,641.63 rows=382 width=49) (actual time=61.140..1,517.115 rows=10 loops=1)

12. 0.155 1,515.793 ↑ 36.4 5 1

Nested Loop Left Join (cost=2.86..927,008.18 rows=182 width=278) (actual time=61.138..1,515.793 rows=5 loops=1)

  • Join Filter: (((bc_retail_accounts_pkg_mv_2.tdlinx_store_cd)::text = ("*SELECT* 1_1".tdlinx_store_cd)::text) AND ((bc_retail_accounts_pkg_mv_2.master_pkg_sku_cd)::text = ("*SELECT* 1_1".pkgsku_cd)::text))
  • Rows Removed by Join Filter: 45
13. 0.013 0.013 ↑ 23.8 5 1

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_2 (cost=0.43..223.20 rows=119 width=98) (actual time=0.008..0.013 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
14. 0.026 1,515.625 ↑ 30.6 10 5

Materialize (cost=2.42..926,148.05 rows=306 width=211) (actual time=12.212..303.125 rows=10 loops=5)

15. 0.009 1,515.599 ↑ 30.6 10 1

Append (cost=2.42..926,146.52 rows=306 width=211) (actual time=61.059..1,515.599 rows=10 loops=1)

16. 0.003 61.825 ↑ 49.2 5 1

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

17. 0.038 61.822 ↑ 49.2 5 1

Nested Loop (cost=2.42..753,795.63 rows=246 width=57) (actual time=61.057..61.822 rows=5 loops=1)

18.          

Initplan (forNested Loop)

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

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

21. 0.439 61.750 ↑ 24.6 5 1

Nested Loop (cost=0.99..753,768.51 rows=123 width=57) (actual time=61.002..61.750 rows=5 loops=1)

  • Join Filter: ((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)
  • Rows Removed by Join Filter: 1235
22. 0.055 0.055 ↑ 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=13) (actual time=0.004..0.055 rows=248 loops=1)

23. 0.288 61.256 ↑ 24.6 5 248

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

24. 0.020 60.968 ↑ 24.6 5 1

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

25. 0.018 0.018 ↑ 24.6 5 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=53) (actual time=0.012..0.018 rows=5 loops=1)

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
26. 0.005 60.930 ↓ 0.0 0 5

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

  • Filter: (((p.store_src_cd)::text = '7583851'::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))
27. 0.005 60.925 ↓ 0.0 0 5

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

28. 0.010 60.920 ↓ 0.0 0 5

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

  • 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)
29. 60.910 60.910 ↓ 0.0 0 5

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

  • 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
30. 0.000 0.000 ↓ 0.0 0

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

31. 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.store_src_cd)::text)
  • Heap Fetches: 0
32. 0.006 0.030 ↑ 2.0 1 5

Materialize (cost=0.43..9.51 rows=2 width=8) (actual time=0.005..0.006 rows=1 loops=5)

33. 0.004 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)

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

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

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
36. 0.005 1,168.096 ↑ 14.5 4 1

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

37. 0.068 1,168.091 ↑ 14.5 4 1

Nested Loop (cost=10.74..171,908.79 rows=58 width=560) (actual time=292.753..1,168.091 rows=4 loops=1)

38.          

Initplan (forNested Loop)

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

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

41. 0.055 1,167.988 ↑ 7.2 4 1

Nested Loop (cost=9.30..171,894.36 rows=29 width=560) (actual time=292.696..1,167.988 rows=4 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: 96
42. 0.022 1,167.893 ↑ 7.2 4 1

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

43. 0.043 0.043 ↑ 7.2 4 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.035..0.043 rows=4 loops=1)

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
44. 0.004 1,167.828 ↓ 0.0 0 4

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

  • Filter: (((p_1.store_src_cd)::text = '7583851'::text) AND ((p_1.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24.store_src_cd)::text) AND ((p_1.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24.brand_cd)::text))
45. 0.008 1,167.824 ↓ 0.0 0 4

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

46. 0.012 1,167.816 ↓ 0.0 0 4

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_1.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_1.entity_01_cd)::text)
47. 0.008 1,167.804 ↓ 0.0 0 4

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_1.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_1.master_pkg_sku_cd)::text)
48. 1,167.796 1,167.796 ↓ 0.0 0 4

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

  • 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
49. 0.000 0.000 ↓ 0.0 0

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

50. 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_1 (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)
51. 0.000 0.000 ↓ 0.0 0

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

52. 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_brand_agg_2018_12_27_07_29_24.store_src_cd)::text)
  • Heap Fetches: 0
53. 0.033 0.040 ↑ 1.0 25 4

Materialize (cost=0.00..1.38 rows=25 width=516) (actual time=0.003..0.010 rows=25 loops=4)

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

55. 0.002 0.032 ↑ 2.0 1 4

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

56. 0.004 0.030 ↑ 2.0 1 1

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

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

58. 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_4 (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 = '7583851'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
59. 0.002 285.669 ↑ 2.0 1 1

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

60. 0.031 285.667 ↑ 2.0 1 1

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

61.          

Initplan (forNested Loop Left Join)

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

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

64. 0.004 0.115 ↑ 2.0 1 1

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

65. 0.004 0.096 ↑ 1.0 1 1

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

66. 0.007 0.027 ↑ 1.0 1 1

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

67. 0.002 0.002 ↑ 1.0 1 1

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

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

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
69. 0.004 0.065 ↑ 1.0 1 1

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

  • Filter: ((fb.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_1.store_src_cd)::text)
70. 0.028 0.061 ↑ 1.0 1 1

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_1.store_src_cd
71. 0.018 0.033 ↑ 7.2 4 1

Result (cost=0.43..120.90 rows=29 width=22) (actual time=0.025..0.033 rows=4 loops=1)

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_1.store_src_cd)::text = '7583851'::text)
72. 0.015 0.015 ↑ 7.2 4 1

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

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
73. 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_5 (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 = '7583851'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
74. 0.001 285.517 ↓ 0.0 0 1

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

  • Filter: (((p_2.store_src_cd)::text = '7583851'::text) AND ((p_2.store_src_cd)::text = (d_store_2018_12_27_07_01_39_5.store_src_cd)::text))
75. 0.005 285.516 ↓ 0.0 0 1

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

76. 0.001 285.511 ↓ 0.0 0 1

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_2.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_2.entity_01_cd)::text)
77. 285.510 285.510 ↓ 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=7) (actual time=285.510..285.510 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
78. 0.000 0.000 ↓ 0.0 0

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

79. 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 = (d_store_2018_12_27_07_01_39_5.store_src_cd)::text)
  • Heap Fetches: 0
80. 0.069 1.316 ↑ 40.0 5 1

HashAggregate (cost=8,626.62..8,629.62 rows=200 width=49) (actual time=1.305..1.316 rows=5 loops=1)

  • Group Key: bc_retail_accounts_pkg_mv_3.tdlinx_store_cd, bc_retail_accounts_pkg_mv_3.master_pkg_sku_cd
81. 0.010 1.247 ↑ 37.5 20 1

Append (cost=1.11..8,621.00 rows=750 width=49) (actual time=0.082..1.247 rows=20 loops=1)

82. 0.107 0.158 ↑ 57.0 5 1

Merge Join (cost=1.11..453.37 rows=285 width=131) (actual time=0.082..0.158 rows=5 loops=1)

  • Merge Cond: ((bc_retail_accounts_pkg_mv_3.master_pkg_sku_cd)::text = (bc_retail_accounts_pkg_mv_4.master_pkg_sku_cd)::text)
83. 0.035 0.035 ↑ 23.8 5 1

Index Only Scan using bc_retail_accounts_pkg_pk on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_3 (cost=0.56..223.33 rows=119 width=17) (actual time=0.035..0.035 rows=5 loops=1)

  • Index Cond: (tdlinx_store_cd = '7583851'::text)
  • Heap Fetches: 5
84. 0.006 0.016 ↑ 23.8 5 1

Materialize (cost=0.56..223.63 rows=119 width=131) (actual time=0.011..0.016 rows=5 loops=1)

85. 0.010 0.010 ↑ 23.8 5 1

Index Scan using bc_retail_accounts_pkg_pk on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_4 (cost=0.56..223.33 rows=119 width=131) (actual time=0.008..0.010 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
86. 0.010 0.117 ↑ 19.4 5 1

Nested Loop (cost=0.85..660.27 rows=97 width=49) (actual time=0.042..0.117 rows=5 loops=1)

87. 0.022 0.022 ↑ 10.2 5 1

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_5 (cost=0.43..223.50 rows=51 width=23) (actual time=0.018..0.022 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
  • Filter: (chain_ind_flg = 'Y'::bpchar)
88. 0.085 0.085 ↑ 1.0 1 5

Index Scan using stores_report_to_totals_mv_x_cd_dsc_sku_idx on stores_report_to_totals_mv rpt (cost=0.42..8.55 rows=1 width=47) (actual time=0.014..0.017 rows=1 loops=5)

  • Index Cond: (((cd)::text = (bc_retail_accounts_pkg_mv_5.rpt_to_cd)::text) AND ((sku)::text = (bc_retail_accounts_pkg_mv_5.master_pkg_sku_cd)::text))
89. 0.008 0.113 ↑ 21.2 5 1

Nested Loop (cost=0.85..656.78 rows=106 width=49) (actual time=0.036..0.113 rows=5 loops=1)

90. 0.015 0.015 ↑ 10.2 5 1

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_6 (cost=0.43..223.50 rows=51 width=23) (actual time=0.011..0.015 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
  • Filter: (chain_ind_flg = 'Y'::bpchar)
91. 0.090 0.090 ↑ 1.0 1 5

Index Scan using stores_ultimate_parent_totals_mv_x_cd_dsc_sku_idx on stores_ultimate_parent_totals_mv parent (cost=0.42..8.49 rows=1 width=47) (actual time=0.017..0.018 rows=1 loops=5)

  • Index Cond: (((cd)::text = (bc_retail_accounts_pkg_mv_6.ult_parent_cd)::text) AND ((sku)::text = (bc_retail_accounts_pkg_mv_6.master_pkg_sku_cd)::text))
92. 0.014 0.849 ↑ 52.4 5 1

Nested Loop (cost=0.85..6,843.09 rows=262 width=49) (actual time=0.200..0.849 rows=5 loops=1)

93. 0.010 0.010 ↑ 23.8 5 1

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_7 (cost=0.43..223.20 rows=119 width=27) (actual time=0.009..0.010 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
94. 0.825 0.825 ↑ 1.0 1 5

Index Scan using stores_dma_totals_mv_x_cd_dsc_rpt_to_cd_sku_idx on stores_dma_totals_mv dma (cost=0.42..55.62 rows=1 width=51) (actual time=0.165..0.165 rows=1 loops=5)

  • Index Cond: (((cd)::text = (bc_retail_accounts_pkg_mv_7.dma_cd)::text) AND ((rpt_to_cd)::text = (bc_retail_accounts_pkg_mv_7.rpt_to_cd)::text) AND ((sku)::text = (bc_retail_accounts_pkg_mv_7.master_pkg_sku_cd)::text))
95. 0.009 63.710 ↑ 49.2 5 5

Materialize (cost=2.42..753,799.32 rows=246 width=17) (actual time=12.583..12.742 rows=5 loops=5)

96. 0.005 63.701 ↑ 49.2 5 1

Append (cost=2.42..753,798.09 rows=246 width=17) (actual time=62.912..63.701 rows=5 loops=1)

97. 0.002 63.696 ↑ 49.2 5 1

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

98. 0.044 63.694 ↑ 49.2 5 1

Nested Loop (cost=2.42..753,795.63 rows=246 width=57) (actual time=62.910..63.694 rows=5 loops=1)

99.          

Initplan (forNested Loop)

100. 0.002 0.004 ↑ 1.0 1 1

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

101. 0.002 0.002 ↑ 1.0 1 1

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

102. 0.320 63.616 ↑ 24.6 5 1

Nested Loop (cost=0.99..753,768.51 rows=123 width=57) (actual time=62.850..63.616 rows=5 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_2.master_pkg_sku_cd)::text)
  • Rows Removed by Join Filter: 1235
103. 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_2 (cost=0.00..8.48 rows=248 width=13) (actual time=0.004..0.056 rows=248 loops=1)

104. 0.426 63.240 ↑ 24.6 5 248

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

105. 0.017 62.814 ↑ 24.6 5 1

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

106. 0.017 0.017 ↑ 24.6 5 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=53) (actual time=0.013..0.017 rows=5 loops=1)

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
107. 0.005 62.780 ↓ 0.0 0 5

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

  • Filter: (((p_3.store_src_cd)::text = '7583851'::text) AND ((p_3.store_src_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_1.store_src_cd)::text) AND ((p_3.master_pkg_sku_cd)::text = (f_store_sku_pkg_agg_2018_12_27_07_28_06_1.master_pkg_sku_cd)::text))
108. 0.005 62.775 ↓ 0.0 0 5

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

109. 0.020 62.770 ↓ 0.0 0 5

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

  • 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)
110. 62.750 62.750 ↓ 0.0 0 5

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

  • 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
111. 0.000 0.000 ↓ 0.0 0

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

112. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (store_src_cd = (f_store_sku_pkg_agg_2018_12_27_07_28_06_1.store_src_cd)::text)
  • Heap Fetches: 0
113. 0.001 0.030 ↑ 2.0 1 5

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

114. 0.004 0.029 ↑ 2.0 1 1

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

115. 0.003 0.003 ↑ 1.0 1 1

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

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

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
117. 0.017 1.110 ↑ 23.8 5 5

Materialize (cost=3,927.69..4,154.34 rows=119 width=49) (actual time=0.193..0.222 rows=5 loops=5)

118. 0.202 1.093 ↑ 23.8 5 1

Merge Left Join (cost=3,927.69..4,153.75 rows=119 width=49) (actual time=0.958..1.093 rows=5 loops=1)

  • Merge Cond: (((bc_retail_accounts_pkg_mv_1.tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv_8.tdlinx_store_cd)::text) AND ((bc_retail_accounts_pkg_mv_1.master_pkg_sku_cd)::text = (bc_retail_accounts_pkg_mv_8.master_pkg_sku_cd)::text))
119. 0.018 0.018 ↑ 23.8 5 1

Index Scan using bc_retail_accounts_pkg_pk on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_1 (cost=0.56..223.33 rows=119 width=122) (actual time=0.015..0.018 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
120. 0.023 0.873 ↑ 40.0 5 1

Sort (cost=3,927.14..3,927.64 rows=200 width=49) (actual time=0.872..0.873 rows=5 loops=1)

  • Sort Key: bc_retail_accounts_pkg_mv_8.tdlinx_store_cd, bc_retail_accounts_pkg_mv_8.master_pkg_sku_cd
  • Sort Method: quicksort Memory: 45kB
121. 0.046 0.850 ↑ 40.0 5 1

HashAggregate (cost=3,914.99..3,917.49 rows=200 width=49) (actual time=0.848..0.850 rows=5 loops=1)

  • Group Key: bc_retail_accounts_pkg_mv_8.tdlinx_store_cd, bc_retail_accounts_pkg_mv_8.master_pkg_sku_cd
122. 0.009 0.804 ↑ 42.5 20 1

Append (cost=86.34..3,908.62 rows=850 width=49) (actual time=0.089..0.804 rows=20 loops=1)

123. 0.108 0.161 ↑ 21.2 5 1

Merge Join (cost=86.34..311.79 rows=106 width=71) (actual time=0.089..0.161 rows=5 loops=1)

  • Merge Cond: ((bc_retail_accounts_pkg_mv_8.master_pkg_sku_cd)::text = (stores_beer_sim_tot_velocity_by_sku_brand_mv.master_pkg_sku_cd)::text)
124. 0.012 0.012 ↑ 23.8 5 1

Index Only Scan using bc_retail_accounts_pkg_pk on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_8 (cost=0.56..223.33 rows=119 width=17) (actual time=0.010..0.012 rows=5 loops=1)

  • Index Cond: (tdlinx_store_cd = '7583851'::text)
  • Heap Fetches: 5
125. 0.011 0.041 ↑ 8.8 5 1

Sort (cost=85.78..85.89 rows=44 width=71) (actual time=0.040..0.041 rows=5 loops=1)

  • Sort Key: stores_beer_sim_tot_velocity_by_sku_brand_mv.master_pkg_sku_cd
  • Sort Method: quicksort Memory: 25kB
126. 0.030 0.030 ↑ 8.8 5 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.026..0.030 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
127. 0.106 0.243 ↑ 53.4 5 1

Nested Loop (cost=0.85..1,212.24 rows=267 width=94) (actual time=0.071..0.243 rows=5 loops=1)

128. 0.017 0.017 ↑ 23.8 5 1

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_9 (cost=0.43..223.20 rows=119 width=27) (actual time=0.015..0.017 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
129. 0.120 0.120 ↑ 1.0 1 5

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.28 rows=1 width=92) (actual time=0.021..0.024 rows=1 loops=5)

  • Index Cond: (((dma_cd)::text = (bc_retail_accounts_pkg_mv_9.dma_cd)::text) AND ((rpt_to_cd)::text = (bc_retail_accounts_pkg_mv_9.rpt_to_cd)::text) AND ((master_pkg_sku_cd)::text = (bc_retail_accounts_pkg_mv_9.master_pkg_sku_cd)::text))
130. 0.104 0.196 ↑ 46.0 5 1

Nested Loop (cost=0.85..1,197.38 rows=230 width=98) (actual time=0.057..0.196 rows=5 loops=1)

131. 0.012 0.012 ↑ 23.8 5 1

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_10 (cost=0.43..223.20 rows=119 width=23) (actual time=0.010..0.012 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
132. 0.080 0.080 ↑ 1.0 1 5

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..8.16 rows=1 width=90) (actual time=0.014..0.016 rows=1 loops=5)

  • Index Cond: (((rpt_to_cd)::text = (bc_retail_accounts_pkg_mv_10.rpt_to_cd)::text) AND ((master_pkg_sku_cd)::text = (bc_retail_accounts_pkg_mv_10.master_pkg_sku_cd)::text))
133. 0.099 0.195 ↑ 49.4 5 1

Nested Loop (cost=0.85..1,178.70 rows=247 width=97) (actual time=0.050..0.195 rows=5 loops=1)

134. 0.011 0.011 ↑ 23.8 5 1

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_11 (cost=0.43..223.20 rows=119 width=23) (actual time=0.009..0.011 rows=5 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = '7583851'::text)
135. 0.085 0.085 ↑ 1.0 1 5

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..8.00 rows=1 width=89) (actual time=0.013..0.017 rows=1 loops=5)

  • Index Cond: (((ult_parent_cd)::text = (bc_retail_accounts_pkg_mv_11.ult_parent_cd)::text) AND ((master_pkg_sku_cd)::text = (bc_retail_accounts_pkg_mv_11.master_pkg_sku_cd)::text))
136.          

SubPlan (forGroupAggregate)

137. 0.016 0.048 ↑ 5.0 1 4

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

  • Recheck Cond: ((bc_retail_accounts_pkg_mv.brand_cd)::text = (brand_cd)::text)
  • Heap Blocks: exact=4
138. 0.032 0.032 ↑ 5.0 1 4

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

  • Index Cond: ((bc_retail_accounts_pkg_mv.brand_cd)::text = (brand_cd)::text)
139. 0.008 0.020 ↑ 5.0 1 4

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

  • Recheck Cond: ((bc_retail_accounts_pkg_mv.brand_cd)::text = (brand_cd)::text)
  • Heap Blocks: exact=4
140. 0.012 0.012 ↑ 5.0 1 4

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

  • Index Cond: ((bc_retail_accounts_pkg_mv.brand_cd)::text = (brand_cd)::text)
141. 0.004 1,156.644 ↑ 1.0 1 4

Subquery Scan on c (cost=15.19..5,970.78 rows=1 width=32) (actual time=289.142..289.161 rows=1 loops=4)

142. 0.012 1,156.640 ↑ 1.0 1 4

Unique (cost=15.19..5,970.77 rows=1 width=152) (actual time=289.141..289.160 rows=1 loops=4)

143. 0.146 1,156.628 ↑ 18.0 1 4

Nested Loop Left Join (cost=15.19..5,970.68 rows=18 width=152) (actual time=289.139..289.157 rows=1 loops=4)

  • Join Filter: (((bc_retail_accounts_pkg_mv_13.tdlinx_store_cd)::text = ("*SELECT* 2_1".tdlinx_store_cd)::text) AND ((bc_retail_accounts_pkg_mv_13.brand_cd)::text = ("*SELECT* 2_1".brand_cd)::text))
144. 0.052 0.052 ↑ 9.0 1 4

Index Only Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_13 (cost=0.43..22.61 rows=9 width=12) (actual time=0.011..0.013 rows=1 loops=4)

  • Index Cond: ((tdlinx_store_cd = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND (brand_cd = (bc_retail_accounts_pkg_mv.brand_cd)::text))
  • Heap Fetches: 5
145. 0.014 1,156.430 ↑ 2.0 1 5

Materialize (cost=14.75..5,947.31 rows=2 width=226) (actual time=231.276..231.286 rows=1 loops=5)

146. 0.012 1,156.416 ↑ 2.0 1 4

Append (cost=14.75..5,947.30 rows=2 width=226) (actual time=289.092..289.104 rows=1 loops=4)

147. 0.008 1,156.404 ↑ 2.0 1 4

Subquery Scan on *SELECT* 2_1 (cost=14.75..5,947.30 rows=2 width=226) (actual time=289.090..289.101 rows=1 loops=4)

148. 0.089 1,156.396 ↑ 2.0 1 4

Nested Loop (cost=14.75..5,947.28 rows=2 width=560) (actual time=289.089..289.099 rows=1 loops=4)

149.          

Initplan (forNested Loop)

150. 0.000 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)

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

152. 0.012 1,156.220 ↑ 1.0 1 4

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

153. 0.040 0.168 ↑ 1.0 1 4

Nested Loop (cost=4.44..14.87 rows=1 width=564) (actual time=0.033..0.042 rows=1 loops=4)

154. 0.012 0.056 ↑ 1.0 1 4

Nested Loop (cost=0.00..2.39 rows=1 width=516) (actual time=0.008..0.014 rows=1 loops=4)

155. 0.004 0.004 ↑ 1.0 1 4

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=4)

156. 0.040 0.040 ↑ 1.0 1 4

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_1 (cost=0.00..1.38 rows=1 width=516) (actual time=0.005..0.010 rows=1 loops=4)

  • Filter: (((brand_cd)::character varying(30))::text = (bc_retail_accounts_pkg_mv.brand_cd)::text)
  • Rows Removed by Filter: 24
157. 0.016 0.072 ↑ 2.0 1 4

Bitmap Heap Scan on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_3 (cost=4.44..12.45 rows=2 width=48) (actual time=0.017..0.018 rows=1 loops=4)

  • Recheck Cond: (((store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_1.brand_cd)::text))
  • Heap Blocks: exact=4
158. 0.056 0.056 ↑ 2.0 1 4

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

  • Index Cond: (((store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_1.brand_cd)::text))
159. 0.008 1,156.040 ↓ 0.0 0 4

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

  • Filter: (((p_5.store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND ((p_5.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_3.store_src_cd)::text) AND ((p_5.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_3.brand_cd)::text))
160. 0.004 1,156.032 ↓ 0.0 0 4

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

161. 0.012 1,156.028 ↓ 0.0 0 4

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_5.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_5.entity_01_cd)::text)
162. 0.008 1,156.016 ↓ 0.0 0 4

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_5.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_3.master_pkg_sku_cd)::text)
163. 1,156.008 1,156.008 ↓ 0.0 0 4

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

  • 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
164. 0.000 0.000 ↓ 0.0 0

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

165. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_3.brand_cd)::text)
166. 0.000 0.000 ↓ 0.0 0

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

167. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_3.store_src_cd)::text)
  • Heap Fetches: 0
168. 0.084 0.084 ↑ 2.0 1 4

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

  • Index Cond: ((store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
169. 0.264 1,149.680 ↑ 28.0 1 4

Nested Loop (cost=16.04..6,061.84 rows=28 width=294) (actual time=287.400..287.420 rows=1 loops=4)

170. 0.060 1.064 ↑ 7.0 1 4

GroupAggregate (cost=0.85..102.90 rows=7 width=44) (actual time=0.265..0.266 rows=1 loops=4)

  • Group Key: bc_retail_accounts_esri_mv_12.tdlinx_store_cd, bc_retail_accounts_esri_mv_12.brand_cd
171. 0.028 1.004 ↑ 1.8 4 4

Append (cost=0.85..102.76 rows=7 width=44) (actual time=0.068..0.251 rows=4 loops=4)

172. 0.128 0.276 ↑ 2.0 1 4

Nested Loop (cost=0.85..19.47 rows=2 width=129) (actual time=0.066..0.069 rows=1 loops=4)

173. 0.068 0.068 ↑ 1.0 1 4

Index Scan using stores_beer_tot_vol_sim_perf_comp_tdlinx_store_cd_brand_cd_idx1 on stores_beer_tot_vol_sim_perf_comps_by_brand_mv stores_beer_tot_vol_sim_perf_comps_by_brand_mv_1 (cost=0.42..8.45 rows=1 width=129) (actual time=0.016..0.017 rows=1 loops=4)

  • Index Cond: (((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv.brand_cd)::text))
174. 0.080 0.080 ↑ 2.0 1 4

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_12 (cost=0.43..10.99 rows=2 width=12) (actual time=0.019..0.020 rows=1 loops=4)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: (((brand_cd)::text <> 'TOTAL'::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv.brand_cd)::text))
  • Rows Removed by Filter: 3
175. 0.136 0.260 ↑ 2.0 1 4

Nested Loop (cost=0.85..27.92 rows=2 width=124) (actual time=0.063..0.065 rows=1 loops=4)

176. 0.052 0.052 ↑ 2.0 1 4

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_13 (cost=0.43..10.99 rows=2 width=22) (actual time=0.011..0.013 rows=1 loops=4)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: (((brand_cd)::text <> 'TOTAL'::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv.brand_cd)::text))
  • Rows Removed by Filter: 3
177. 0.072 0.072 ↑ 1.0 1 4

Index Scan using stores_beer_tot_vol_dma_perf_com_dma_cd_rpt_to_cd_brand_cd_idx1 on stores_beer_tot_vol_dma_perf_comps_by_brand_mv stores_beer_tot_vol_dma_perf_comps_by_brand_mv_1 (cost=0.42..8.45 rows=1 width=123) (actual time=0.017..0.018 rows=1 loops=4)

  • Index Cond: (((dma_cd)::text = (bc_retail_accounts_esri_mv_13.dma_cd)::text) AND ((rpt_to_cd)::text = (bc_retail_accounts_esri_mv_13.rpt_to_cd)::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv.brand_cd)::text))
178. 0.128 0.228 ↑ 1.0 1 4

Nested Loop (cost=0.72..27.64 rows=1 width=134) (actual time=0.054..0.057 rows=1 loops=4)

179. 0.052 0.052 ↑ 2.0 1 4

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_14 (cost=0.43..10.99 rows=2 width=18) (actual time=0.012..0.013 rows=1 loops=4)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: (((brand_cd)::text <> 'TOTAL'::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv.brand_cd)::text))
  • Rows Removed by Filter: 3
180. 0.048 0.048 ↑ 1.0 1 4

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

  • Index Cond: (((rpt_to_cd)::text = (bc_retail_accounts_esri_mv_14.rpt_to_cd)::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv.brand_cd)::text))
181. 0.116 0.212 ↑ 2.0 1 4

Nested Loop (cost=0.72..27.65 rows=2 width=134) (actual time=0.051..0.053 rows=1 loops=4)

182. 0.052 0.052 ↑ 2.0 1 4

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_15 (cost=0.43..10.99 rows=2 width=18) (actual time=0.011..0.013 rows=1 loops=4)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: (((brand_cd)::text <> 'TOTAL'::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv.brand_cd)::text))
  • Rows Removed by Filter: 3
183. 0.044 0.044 ↑ 1.0 1 4

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

  • Index Cond: (((ult_parent_cd)::text = (bc_retail_accounts_esri_mv_15.ult_parent_cd)::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv.brand_cd)::text))
184. 0.016 1,148.352 ↑ 4.0 1 4

Materialize (cost=15.18..5,958.32 rows=4 width=274) (actual time=287.071..287.088 rows=1 loops=4)

185. 0.028 1,148.336 ↑ 4.0 1 4

Nested Loop Left Join (cost=15.18..5,958.30 rows=4 width=274) (actual time=287.067..287.084 rows=1 loops=4)

  • Join Filter: (((bc_retail_accounts_esri_mv_11.tdlinx_store_cd)::text = ("*SELECT* 2_2".tdlinx_store_cd)::text) AND ((bc_retail_accounts_esri_mv_11.brand_cd)::text = ("*SELECT* 2_2".brand_cd)::text))
186. 0.060 0.060 ↑ 2.0 1 4

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_11 (cost=0.43..10.93 rows=2 width=94) (actual time=0.011..0.015 rows=1 loops=4)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = (bc_retail_accounts_pkg_mv.brand_cd)::text)
  • Rows Removed by Filter: 3
187. 0.016 1,148.248 ↑ 2.0 1 4

Materialize (cost=14.75..5,947.31 rows=2 width=266) (actual time=287.049..287.062 rows=1 loops=4)

188. 0.004 1,148.232 ↑ 2.0 1 4

Append (cost=14.75..5,947.30 rows=2 width=266) (actual time=287.046..287.058 rows=1 loops=4)

189. 0.012 1,148.228 ↑ 2.0 1 4

Subquery Scan on *SELECT* 2_2 (cost=14.75..5,947.30 rows=2 width=266) (actual time=287.045..287.057 rows=1 loops=4)

190. 0.092 1,148.216 ↑ 2.0 1 4

Nested Loop (cost=14.75..5,947.28 rows=2 width=560) (actual time=287.043..287.054 rows=1 loops=4)

191.          

Initplan (forNested Loop)

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

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

194. 0.020 1,148.028 ↑ 1.0 1 4

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

195. 0.040 0.184 ↑ 1.0 1 4

Nested Loop (cost=4.44..14.87 rows=1 width=564) (actual time=0.038..0.046 rows=1 loops=4)

196. 0.012 0.068 ↑ 1.0 1 4

Nested Loop (cost=0.00..2.39 rows=1 width=516) (actual time=0.010..0.017 rows=1 loops=4)

197. 0.020 0.020 ↑ 1.0 1 4

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.004..0.005 rows=1 loops=4)

198. 0.036 0.036 ↑ 1.0 1 4

Seq Scan on d_item_brand_2018_12_27_07_07_56 d_item_brand_2018_12_27_07_07_56_2 (cost=0.00..1.38 rows=1 width=516) (actual time=0.004..0.009 rows=1 loops=4)

  • Filter: (((brand_cd)::character varying(30))::text = (bc_retail_accounts_pkg_mv.brand_cd)::text)
  • Rows Removed by Filter: 24
199. 0.016 0.076 ↑ 2.0 1 4

Bitmap Heap Scan on f_store_brand_agg_2018_12_27_07_29_24 f_store_brand_agg_2018_12_27_07_29_24_4 (cost=4.44..12.45 rows=2 width=48) (actual time=0.018..0.019 rows=1 loops=4)

  • Recheck Cond: (((store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_2.brand_cd)::text))
  • Heap Blocks: exact=4
200. 0.060 0.060 ↑ 2.0 1 4

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.015..0.015 rows=1 loops=4)

  • Index Cond: (((store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND ((brand_cd)::text = (d_item_brand_2018_12_27_07_07_56_2.brand_cd)::text))
201. 0.008 1,147.824 ↓ 0.0 0 4

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

  • Filter: (((p_6.store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND ((p_6.store_src_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_4.store_src_cd)::text) AND ((p_6.brand_cd)::text = (f_store_brand_agg_2018_12_27_07_29_24_4.brand_cd)::text))
202. 0.008 1,147.816 ↓ 0.0 0 4

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

203. 0.024 1,147.808 ↓ 0.0 0 4

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

  • Join Filter: ((x_priority_package_2018_12_27_06_56_20_6.entity_01_cd)::text = (x_store_entity_2018_12_27_07_38_25_6.entity_01_cd)::text)
204. 0.008 1,147.784 ↓ 0.0 0 4

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

  • Hash Cond: ((x_priority_package_2018_12_27_06_56_20_6.master_sku_cd)::text = (d_item_sku_pkg_2018_12_27_07_05_22_4.master_pkg_sku_cd)::text)
205. 1,147.776 1,147.776 ↓ 0.0 0 4

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..5,840.38 rows=11,608 width=16) (actual time=286.944..286.944 rows=0 loops=4)

  • 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
206. 0.000 0.000 ↓ 0.0 0

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

207. 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_4.brand_cd)::text)
208. 0.000 0.000 ↓ 0.0 0

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

209. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (store_src_cd = (f_store_brand_agg_2018_12_27_07_29_24_4.store_src_cd)::text)
  • Heap Fetches: 0
210. 0.092 0.092 ↑ 2.0 1 4

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.022..0.023 rows=1 loops=4)

  • Index Cond: ((store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
211. 0.012 1.404 ↑ 1.0 1 4

Subquery Scan on bp (cost=0.43..132.36 rows=1 width=32) (actual time=0.351..0.351 rows=1 loops=4)

212. 0.292 1.392 ↑ 1.0 1 4

GroupAggregate (cost=0.43..132.35 rows=1 width=117) (actual time=0.348..0.348 rows=1 loops=4)

  • Group Key: bc_retail_accounts_pkg_mv_14.tdlinx_store_cd, bc_retail_accounts_pkg_mv_14.brand_cd
213. 0.072 0.072 ↑ 9.0 1 4

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_14 (cost=0.43..22.61 rows=9 width=117) (actual time=0.017..0.018 rows=1 loops=4)

  • Index Cond: (((bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text = (tdlinx_store_cd)::text) AND ((bc_retail_accounts_pkg_mv.brand_cd)::text = (brand_cd)::text))
214.          

SubPlan (forGroupAggregate)

215. 0.008 1.028 ↑ 7.0 1 4

Subquery Scan on pc_2 (cost=0.99..108.41 rows=7 width=32) (actual time=0.256..0.257 rows=1 loops=4)

216. 0.056 1.020 ↑ 7.0 1 4

GroupAggregate (cost=0.99..108.34 rows=7 width=44) (actual time=0.255..0.255 rows=1 loops=4)

  • Group Key: bc_retail_accounts_esri_mv_16.tdlinx_store_cd, bc_retail_accounts_esri_mv_16.brand_cd
217. 0.028 0.964 ↑ 1.8 4 4

Append (cost=0.99..108.20 rows=7 width=44) (actual time=0.072..0.241 rows=4 loops=4)

218. 0.016 0.292 ↑ 2.0 1 4

Nested Loop (cost=0.99..25.11 rows=2 width=44) (actual time=0.071..0.073 rows=1 loops=4)

219. 0.140 0.208 ↑ 1.0 1 4

GroupAggregate (cost=0.56..14.15 rows=1 width=66) (actual time=0.052..0.052 rows=1 loops=4)

  • Group Key: stores_beer_sim_tot_velocity_by_sku_brand_mv_2.tdlinx_store_cd, stores_beer_sim_tot_velocity_by_sku_brand_mv_2.brand_cd
220. 0.068 0.068 ↑ 4.0 1 4

Index Scan using stores_beer_sim_tot_velocity__tdlinx_store_cd_brand_cd_mast_idx on stores_beer_sim_tot_velocity_by_sku_brand_mv stores_beer_sim_tot_velocity_by_sku_brand_mv_2 (cost=0.56..13.89 rows=4 width=66) (actual time=0.017..0.017 rows=1 loops=4)

  • Index Cond: (((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv_14.tdlinx_store_cd)::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv_14.brand_cd)::text))
221. 0.068 0.068 ↑ 2.0 1 4

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_16 (cost=0.43..10.93 rows=2 width=12) (actual time=0.016..0.017 rows=1 loops=4)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv_14.tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = (bc_retail_accounts_pkg_mv_14.brand_cd)::text)
  • Rows Removed by Filter: 3
222. 0.120 0.240 ↑ 2.0 1 4

Nested Loop (cost=0.85..27.86 rows=2 width=89) (actual time=0.058..0.060 rows=1 loops=4)

223. 0.044 0.044 ↑ 2.0 1 4

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_17 (cost=0.43..10.93 rows=2 width=22) (actual time=0.009..0.011 rows=1 loops=4)

  • Index Cond: ((bc_retail_accounts_pkg_mv_14.tdlinx_store_cd)::text = (tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = (bc_retail_accounts_pkg_mv_14.brand_cd)::text)
  • Rows Removed by Filter: 3
224. 0.076 0.076 ↑ 1.0 1 4

Index Scan using stores_beer_dma_tot_velocity_by_b_dma_cd_rpt_to_cd_brand_cd_idx on stores_beer_dma_tot_velocity_by_brand_mv (cost=0.42..8.45 rows=1 width=87) (actual time=0.018..0.019 rows=1 loops=4)

  • Index Cond: (((dma_cd)::text = (bc_retail_accounts_esri_mv_17.dma_cd)::text) AND ((rpt_to_cd)::text = (bc_retail_accounts_esri_mv_17.rpt_to_cd)::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv_14.brand_cd)::text))
225. 0.112 0.204 ↑ 1.0 1 4

Nested Loop (cost=0.72..27.58 rows=1 width=93) (actual time=0.049..0.051 rows=1 loops=4)

226. 0.048 0.048 ↑ 2.0 1 4

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_18 (cost=0.43..10.93 rows=2 width=18) (actual time=0.011..0.012 rows=1 loops=4)

  • Index Cond: ((bc_retail_accounts_pkg_mv_14.tdlinx_store_cd)::text = (tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = (bc_retail_accounts_pkg_mv_14.brand_cd)::text)
  • Rows Removed by Filter: 3
227. 0.044 0.044 ↑ 1.0 1 4

Index Scan using stores_beer_rpt_tot_velocity_by_brand_mv_rpt_to_cd_brand_cd_idx on stores_beer_rpt_tot_velocity_by_brand_mv (cost=0.29..8.31 rows=1 width=85) (actual time=0.011..0.011 rows=1 loops=4)

  • Index Cond: (((rpt_to_cd)::text = (bc_retail_accounts_esri_mv_18.rpt_to_cd)::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv_14.brand_cd)::text))
228. 0.112 0.200 ↑ 2.0 1 4

Nested Loop (cost=0.72..27.58 rows=2 width=92) (actual time=0.048..0.050 rows=1 loops=4)

229. 0.044 0.044 ↑ 2.0 1 4

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_19 (cost=0.43..10.93 rows=2 width=18) (actual time=0.010..0.011 rows=1 loops=4)

  • Index Cond: ((bc_retail_accounts_pkg_mv_14.tdlinx_store_cd)::text = (tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = (bc_retail_accounts_pkg_mv_14.brand_cd)::text)
  • Rows Removed by Filter: 3
230. 0.044 0.044 ↑ 1.0 1 4

Index Scan using stores_beer_ult_tot_velocity_by_bran_ult_parent_cd_brand_cd_idx on stores_beer_ult_tot_velocity_by_brand_mv (cost=0.29..8.31 rows=1 width=84) (actual time=0.010..0.011 rows=1 loops=4)

  • Index Cond: (((ult_parent_cd)::text = (bc_retail_accounts_esri_mv_19.ult_parent_cd)::text) AND ((brand_cd)::text = (bc_retail_accounts_pkg_mv_14.brand_cd)::text))
231. 0.170 0.300 ↑ 1.0 1 5

Subquery Scan on _beer_packages_by_store (cost=0.00..0.03 rows=1 width=24) (actual time=0.059..0.060 rows=1 loops=5)

232. 0.130 0.130 ↑ 1.0 1 5

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.026..0.026 rows=1 loops=5)

233.          

SubPlan (forGroupAggregate)

234. 0.001 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.01..528.08 rows=16 width=294) (actual time=0.018..0.018 rows=0 loops=1)

  • Join Filter: (((bc_retail_accounts_esri_mv_2.tdlinx_store_cd)::text = (pc.tdlinx_store_cd)::text) AND ((bc_retail_accounts_esri_mv_2.brand_cd)::text = (pc.brand_cd)::text))
235. 0.002 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.15..450.01 rows=2 width=274) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: ((bc_retail_accounts_esri_mv_2.tdlinx_store_cd)::text = ("*SELECT* 3_1".tdlinx_store_cd)::text)
236. 0.015 0.015 ↓ 0.0 0 1

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_2 (cost=0.43..10.93 rows=1 width=94) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text = (tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = 'TOTAL'::text)
  • Rows Removed by Filter: 4
237. 0.000 0.000 ↓ 0.0 0

Append (cost=2.72..439.05 rows=2 width=188) (never executed)

238. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_1 (cost=2.72..439.05 rows=2 width=188) (never executed)

239. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.72..439.03 rows=2 width=44) (never executed)

240.          

Initplan (forNested Loop Left Join)

241. 0.000 0.000 ↓ 0.0 0

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

242. 0.000 0.000 ↓ 0.0 0

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

243. 0.000 0.000 ↓ 0.0 0

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

244. 0.000 0.000 ↓ 0.0 0

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

245. 0.000 0.000 ↓ 0.0 0

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

246. 0.000 0.000 ↓ 0.0 0

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

247. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
248. 0.000 0.000 ↓ 0.0 0

Subquery Scan on fb_1 (cost=0.43..121.14 rows=1 width=8) (never executed)

  • Filter: ((fb_1.store_src_cd)::text = (f_store_agg_2018_12_27_07_28_55_2.store_src_cd)::text)
249. 0.000 0.000 ↓ 0.0 0

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

  • Group Key: f_store_brand_agg_2018_12_27_07_29_24_2.store_src_cd
250. 0.000 0.000 ↓ 0.0 0

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

  • One-Time Filter: ((f_store_agg_2018_12_27_07_28_55_2.store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
251. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
252. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
253. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (((p_4.store_src_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND ((p_4.store_src_cd)::text = (d_store_2018_12_27_07_01_39_7.store_src_cd)::text))
254. 0.000 0.000 ↓ 0.0 0

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

255. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: ((x_store_entity_2018_12_27_07_38_25_4.entity_01_cd)::text = (x_priority_package_2018_12_27_06_56_20_4.entity_01_cd)::text)
256. 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_4 (cost=0.00..5,840.38 rows=11,608 width=7) (never executed)

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

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

258. 0.000 0.000 ↓ 0.0 0

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

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

Materialize (cost=0.85..77.70 rows=8 width=44) (never executed)

260. 0.000 0.000 ↓ 0.0 0

Subquery Scan on pc (cost=0.85..77.66 rows=8 width=44) (never executed)

261. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.85..77.58 rows=8 width=44) (never executed)

  • Group Key: bc_retail_accounts_esri_mv_3.tdlinx_store_cd, bc_retail_accounts_esri_mv_3.brand_cd
262. 0.000 0.000 ↓ 0.0 0

Append (cost=0.85..77.42 rows=8 width=44) (never executed)

263. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..19.39 rows=1 width=129) (never executed)

264. 0.000 0.000 ↓ 0.0 0

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_3 (cost=0.43..10.93 rows=1 width=12) (never executed)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = 'TOTAL'::text)
265. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text) AND ((brand_cd)::text = 'TOTAL'::text))
266. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..19.41 rows=3 width=124) (never executed)

267. 0.000 0.000 ↓ 0.0 0

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_4 (cost=0.43..10.93 rows=1 width=22) (never executed)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = 'TOTAL'::text)
268. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (((dma_cd)::text = (bc_retail_accounts_esri_mv_4.dma_cd)::text) AND ((rpt_to_cd)::text = (bc_retail_accounts_esri_mv_4.rpt_to_cd)::text) AND ((brand_cd)::text = 'TOTAL'::text))
269. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..19.27 rows=2 width=134) (never executed)

270. 0.000 0.000 ↓ 0.0 0

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_5 (cost=0.43..10.93 rows=1 width=18) (never executed)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = 'TOTAL'::text)
271. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (((rpt_to_cd)::text = (bc_retail_accounts_esri_mv_5.rpt_to_cd)::text) AND ((brand_cd)::text = 'TOTAL'::text))
272. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..19.27 rows=2 width=134) (never executed)

273. 0.000 0.000 ↓ 0.0 0

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_6 (cost=0.43..10.93 rows=1 width=18) (never executed)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = 'TOTAL'::text)
274. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (((ult_parent_cd)::text = (bc_retail_accounts_esri_mv_6.ult_parent_cd)::text) AND ((brand_cd)::text = 'TOTAL'::text))
275. 0.003 0.173 ↑ 1.0 1 1

Subquery Scan on sv (cost=0.43..399.08 rows=1 width=32) (actual time=0.173..0.173 rows=1 loops=1)

276. 0.095 0.170 ↑ 1.0 1 1

GroupAggregate (cost=0.43..399.07 rows=1 width=113) (actual time=0.170..0.170 rows=1 loops=1)

  • Group Key: bc_retail_accounts_pkg_mv_12.tdlinx_store_cd
277. 0.012 0.012 ↑ 24.2 5 1

Index Scan using bc_retail_accounts_pkg_new_tdlinx_store_cd_brand_cd_idx_lnd on bc_retail_accounts_pkg_mv bc_retail_accounts_pkg_mv_12 (cost=0.43..226.74 rows=121 width=113) (actual time=0.010..0.012 rows=5 loops=1)

  • Index Cond: ((bc_retail_accounts_pkg_mv.tdlinx_store_cd)::text = (tdlinx_store_cd)::text)
278.          

SubPlan (forGroupAggregate)

279. 0.002 0.063 ↓ 0.0 0 1

Subquery Scan on pc_1 (cost=0.99..155.63 rows=5 width=32) (actual time=0.063..0.063 rows=0 loops=1)

280. 0.001 0.061 ↓ 0.0 0 1

GroupAggregate (cost=0.99..155.58 rows=5 width=40) (actual time=0.061..0.061 rows=0 loops=1)

  • Group Key: bc_retail_accounts_esri_mv_7.tdlinx_store_cd
281. 0.005 0.060 ↓ 0.0 0 1

Append (cost=0.99..155.50 rows=5 width=40) (actual time=0.060..0.060 rows=0 loops=1)

282. 0.002 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.99..97.68 rows=1 width=40) (actual time=0.015..0.015 rows=0 loops=1)

283. 0.013 0.013 ↓ 0.0 0 1

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_7 (cost=0.43..10.93 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv_12.tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = 'TOTAL'::text)
  • Rows Removed by Filter: 4
284. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=0.56..86.73 rows=1 width=62) (never executed)

  • Group Key: stores_beer_sim_tot_velocity_by_sku_brand_mv_1.tdlinx_store_cd
285. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_sim_tot_velocity__tdlinx_store_cd_brand_cd_mast_idx on stores_beer_sim_tot_velocity_by_sku_brand_mv stores_beer_sim_tot_velocity_by_sku_brand_mv_1 (cost=0.56..84.58 rows=44 width=62) (never executed)

  • Index Cond: ((tdlinx_store_cd)::text = (bc_retail_accounts_pkg_mv_12.tdlinx_store_cd)::text)
286. 0.002 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.72..19.27 rows=2 width=85) (actual time=0.013..0.013 rows=0 loops=1)

287. 0.011 0.011 ↓ 0.0 0 1

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_8 (cost=0.43..10.93 rows=1 width=18) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((bc_retail_accounts_pkg_mv_12.tdlinx_store_cd)::text = (tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = 'TOTAL'::text)
  • Rows Removed by Filter: 4
288. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_dma_tot_velocity_by_store_mv_dma_cd_rpt_to_cd_idx on stores_beer_dma_tot_velocity_by_store_mv (cost=0.29..8.31 rows=1 width=83) (never executed)

  • Index Cond: (((dma_cd)::text = (bc_retail_accounts_esri_mv_8.dma_cd)::text) AND ((rpt_to_cd)::text = (bc_retail_accounts_esri_mv_8.rpt_to_cd)::text))
289. 0.001 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.71..19.25 rows=1 width=89) (actual time=0.014..0.014 rows=0 loops=1)

290. 0.013 0.013 ↓ 0.0 0 1

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_9 (cost=0.43..10.93 rows=1 width=14) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((bc_retail_accounts_pkg_mv_12.tdlinx_store_cd)::text = (tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = 'TOTAL'::text)
  • Rows Removed by Filter: 4
291. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_rpt_tot_velocity_by_store_mv_rpt_to_cd_idx on stores_beer_rpt_tot_velocity_by_store_mv (cost=0.28..8.30 rows=1 width=81) (never executed)

  • Index Cond: ((rpt_to_cd)::text = (bc_retail_accounts_esri_mv_9.rpt_to_cd)::text)
292. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.71..19.25 rows=1 width=88) (actual time=0.013..0.013 rows=0 loops=1)

293. 0.012 0.012 ↓ 0.0 0 1

Index Scan using bc_retail_accounts_esri_new_tdlinx_store_cd_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_10 (cost=0.43..10.93 rows=1 width=14) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((bc_retail_accounts_pkg_mv_12.tdlinx_store_cd)::text = (tdlinx_store_cd)::text)
  • Filter: ((brand_cd)::text = 'TOTAL'::text)
  • Rows Removed by Filter: 4
294. 0.000 0.000 ↓ 0.0 0

Index Scan using stores_beer_ult_tot_velocity_by_store_mv_ult_parent_cd_idx on stores_beer_ult_tot_velocity_by_store_mv (cost=0.28..8.30 rows=1 width=80) (never executed)

  • Index Cond: ((ult_parent_cd)::text = (bc_retail_accounts_esri_mv_10.ult_parent_cd)::text)
295. 0.002 0.114 ↑ 8.0 1 1

Hash (cost=295.68..295.68 rows=8 width=123) (actual time=0.114..0.114 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
296. 0.005 0.112 ↑ 8.0 1 1

Nested Loop (cost=20.70..295.68 rows=8 width=123) (actual time=0.106..0.112 rows=1 loops=1)

  • Join Filter: CASE WHEN (COALESCE(bc_retail_accounts_esri_mv_1.total_sales_r365, 0::numeric) <= 0::numeric) THEN (((d_store_2018_12_27_07_01_39_2.store_stts_cd)::text <> ALL ('{D,C}'::text[])) AND ((d_store_2018_12_27_07_01_39.beer_flg)::text = 'Y'::text)) ELSE true END
297. 0.002 0.097 ↑ 8.0 1 1

Nested Loop Left Join (cost=20.27..286.88 rows=8 width=130) (actual time=0.093..0.097 rows=1 loops=1)

  • Join Filter: ((d_store_2018_12_27_07_01_39.store_src_cd)::text = (bc_retail_accounts_esri_mv_1.tdlinx_store_cd)::text)
298. 0.001 0.086 ↑ 8.0 1 1

Nested Loop Left Join (cost=19.84..278.31 rows=8 width=123) (actual time=0.082..0.086 rows=1 loops=1)

  • Join Filter: ((bc_retail_accounts_esri_mv.tdlinx_store_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text)
299. 0.004 0.070 ↑ 4.0 1 1

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

  • Join Filter: (((d_store_2018_12_27_07_01_39.warehouse_chain_flg)::text = 'N'::text) AND ((f_rad_store_2018_12_27_07_48_52.store_src_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text))
300. 0.001 0.054 ↑ 2.0 1 1

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

  • Join Filter: (((d_store_2018_12_27_07_01_39.warehouse_chain_flg)::text = 'Y'::text) AND ((f_pos_store_2018_12_27_07_15_04_1.store_src_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text))
301. 0.001 0.048 ↑ 2.0 1 1

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

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

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

  • Join Filter: (((d_store_2018_12_27_07_01_39.warehouse_chain_flg)::text = 'Y'::text) AND ((f_pos_store_2018_12_27_07_15_04.store_src_cd)::text = (d_store_2018_12_27_07_01_39.store_src_cd)::text))
303. 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 (cost=0.43..8.47 rows=2 width=125) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
304. 0.001 0.009 ↓ 0.0 0 1

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

305. 0.000 0.008 ↓ 0.0 0 1

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

  • Recheck Cond: ((store_src_cd)::text = '7583851'::text)
  • Filter: ((time_period_cd)::text = 'L12CM'::text)
306. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
307. 0.001 0.017 ↓ 0.0 0 1

Materialize (cost=4.56..71.86 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

308. 0.003 0.016 ↓ 0.0 0 1

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

  • Recheck Cond: ((store_src_cd)::text = '7583851'::text)
  • Filter: ((time_period_cd)::text = 'L6M'::text)
  • Rows Removed by Filter: 6
  • Heap Blocks: exact=1
309. 0.013 0.013 ↑ 2.8 6 1

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

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
310. 0.001 0.005 ↓ 0.0 0 1

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

311. 0.000 0.004 ↓ 0.0 0 1

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

  • Recheck Cond: ((store_src_cd)::text = '7583851'::text)
  • Filter: ((time_period_cd)::text = 'L6M'::text)
312. 0.004 0.004 ↓ 0.0 0 1

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

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
313. 0.001 0.012 ↑ 2.0 1 1

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

314. 0.002 0.011 ↑ 2.0 1 1

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

  • Recheck Cond: ((store_src_cd)::text = '7583851'::text)
  • Filter: ((time_period_cd)::text = 'L12CM'::text)
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=1
315. 0.009 0.009 ↑ 2.8 6 1

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

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
316. 0.001 0.015 ↓ 0.0 0 1

Materialize (cost=1.28..25.41 rows=2 width=8) (actual time=0.015..0.015 rows=0 loops=1)

317. 0.001 0.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.28..25.40 rows=2 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Join Filter: ((d_store_2018_12_27_07_01_39_1.store_src_cd)::text = (bc_retail_accounts_esri_mv.tdlinx_store_cd)::text)
318. 0.013 0.013 ↓ 0.0 0 1

Index Only Scan using bc_retail_accounts_esri_tdlinx_store_cd_brand_dsc_idx_lnd on bc_retail_accounts_esri_mv (cost=0.43..8.45 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((tdlinx_store_cd = '7583851'::text) AND (brand_dsc = 'TOTAL'::text))
  • Heap Fetches: 0
319. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..16.93 rows=2 width=8) (never executed)

320. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)
322. 0.001 0.009 ↓ 0.0 0 1

Materialize (cost=0.43..8.46 rows=1 width=15) (actual time=0.009..0.009 rows=0 loops=1)

323. 0.008 0.008 ↓ 0.0 0 1

Index Scan using bc_retail_accounts_esri_tdlinx_store_cd_brand_dsc_idx_lnd on bc_retail_accounts_esri_mv bc_retail_accounts_esri_mv_1 (cost=0.43..8.45 rows=1 width=15) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (((tdlinx_store_cd)::text = '7583851'::text) AND ((brand_dsc)::text = 'TOTAL'::text))
324. 0.002 0.010 ↑ 2.0 1 1

Materialize (cost=0.43..8.48 rows=2 width=10) (actual time=0.009..0.010 rows=1 loops=1)

325. 0.008 0.008 ↑ 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_2 (cost=0.43..8.47 rows=2 width=10) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ((store_src_cd)::text = '7583851'::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)