explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d9q1

Settings
# exclusive inclusive rows x rows loops node
1. 0.145 9.903 ↑ 1.5 2 1

Subquery Scan on dp (cost=425.66..110,227.14 rows=3 width=40) (actual time=0.745..9.903 rows=2 loops=1)

2. 0.144 0.520 ↑ 1.5 2 1

GroupAggregate (cost=425.66..429.54 rows=3 width=2,256) (actual time=0.457..0.520 rows=2 loops=1)

  • Group Key: dd.deal_sk
3. 0.025 0.376 ↑ 6.3 6 1

Sort (cost=425.66..425.75 rows=38 width=1,864) (actual time=0.376..0.376 rows=6 loops=1)

  • Sort Key: dd.deal_sk
  • Sort Method: quicksort Memory: 28kB
4. 0.005 0.351 ↑ 6.3 6 1

Nested Loop (cost=8.76..424.66 rows=38 width=1,864) (actual time=0.104..0.351 rows=6 loops=1)

5. 0.006 0.340 ↑ 6.3 6 1

Nested Loop (cost=8.61..418.48 rows=38 width=1,857) (actual time=0.100..0.340 rows=6 loops=1)

6. 0.012 0.328 ↑ 6.3 6 1

Nested Loop (cost=8.46..412.21 rows=38 width=1,838) (actual time=0.097..0.328 rows=6 loops=1)

7. 0.006 0.310 ↑ 6.3 6 1

Nested Loop (cost=8.18..400.71 rows=38 width=1,827) (actual time=0.093..0.310 rows=6 loops=1)

8. 0.006 0.292 ↑ 6.3 6 1

Nested Loop (cost=7.90..389.21 rows=38 width=1,812) (actual time=0.089..0.292 rows=6 loops=1)

9. 0.006 0.280 ↑ 6.3 6 1

Nested Loop (cost=7.75..383.03 rows=38 width=1,694) (actual time=0.085..0.280 rows=6 loops=1)

10. 0.008 0.268 ↑ 6.3 6 1

Nested Loop (cost=7.61..376.75 rows=38 width=1,698) (actual time=0.081..0.268 rows=6 loops=1)

11. 0.004 0.254 ↑ 6.3 6 1

Nested Loop (cost=7.46..370.57 rows=38 width=1,702) (actual time=0.077..0.254 rows=6 loops=1)

12. 0.031 0.244 ↑ 6.3 6 1

Nested Loop (cost=7.31..364.30 rows=38 width=1,644) (actual time=0.073..0.244 rows=6 loops=1)

13. 0.001 0.207 ↑ 6.3 6 1

Nested Loop (cost=7.17..358.11 rows=38 width=1,372) (actual time=0.070..0.207 rows=6 loops=1)

14. 0.001 0.188 ↑ 6.3 6 1

Nested Loop (cost=6.88..345.45 rows=38 width=1,376) (actual time=0.063..0.188 rows=6 loops=1)

15. 0.002 0.175 ↑ 6.3 6 1

Nested Loop (cost=6.59..333.71 rows=38 width=1,361) (actual time=0.059..0.175 rows=6 loops=1)

16. 0.007 0.161 ↑ 6.3 6 1

Nested Loop (cost=6.30..321.96 rows=38 width=1,346) (actual time=0.053..0.161 rows=6 loops=1)

17. 0.001 0.142 ↑ 6.3 6 1

Nested Loop (cost=6.01..310.22 rows=38 width=1,327) (actual time=0.048..0.142 rows=6 loops=1)

18. 0.006 0.123 ↑ 6.3 6 1

Nested Loop (cost=5.73..298.38 rows=38 width=1,309) (actual time=0.043..0.123 rows=6 loops=1)

19. 0.008 0.111 ↑ 6.3 6 1

Nested Loop (cost=5.44..286.24 rows=38 width=1,305) (actual time=0.040..0.111 rows=6 loops=1)

20. 0.005 0.091 ↑ 6.3 6 1

Nested Loop (cost=5.15..274.11 rows=38 width=1,301) (actual time=0.034..0.091 rows=6 loops=1)

21. 0.006 0.062 ↑ 6.3 6 1

Nested Loop (cost=5.01..267.93 rows=38 width=1,305) (actual time=0.030..0.062 rows=6 loops=1)

22. 0.013 0.044 ↑ 6.3 6 1

Nested Loop (cost=4.86..261.74 rows=38 width=1,163) (actual time=0.025..0.044 rows=6 loops=1)

23. 0.011 0.011 ↑ 1.5 2 1

Index Scan using idx_dl_rdlid on dim_deal dd (cost=0.29..16.03 rows=3 width=1,085) (actual time=0.010..0.011 rows=2 loops=1)

  • Index Cond: ((reveal_deal_id > 18801) AND (reveal_deal_id < 18804))
24. 0.012 0.020 ↑ 6.7 3 2

Bitmap Heap Scan on fact_deal_line fdl (cost=4.58..81.71 rows=20 width=86) (actual time=0.008..0.010 rows=3 loops=2)

  • Recheck Cond: (deal_sk = dd.deal_sk)
  • Filter: (is_active_record = 1)
  • Heap Blocks: exact=2
25. 0.008 0.008 ↑ 6.7 3 2

Bitmap Index Scan on idx_fact_deal_line_deal_sk (cost=0.00..4.57 rows=20 width=0) (actual time=0.004..0.004 rows=3 loops=2)

  • Index Cond: (deal_sk = dd.deal_sk)
26. 0.012 0.012 ↑ 1.0 1 6

Index Scan using dim_deal_status_pkey on dim_deal_status dds (cost=0.14..0.16 rows=1 width=150) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (deal_status_sk = fdl.deal_status_sk)
27. 0.024 0.024 ↑ 1.0 1 6

Index Only Scan using dim_proposal_status_pkey on dim_proposal_status dps (cost=0.14..0.16 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=6)

  • Index Cond: (proposal_status_sk = fdl.proposal_status_sk)
  • Heap Fetches: 6
28. 0.012 0.012 ↑ 1.0 1 6

Index Scan using dim_dates_pkey on dim_dates psd (cost=0.29..0.32 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (date_sk = fdl.proposal_start_date_sk)
29. 0.006 0.006 ↑ 1.0 1 6

Index Scan using dim_dates_pkey on dim_dates ped (cost=0.29..0.32 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (date_sk = fdl.proposal_end_date_sk)
30. 0.018 0.018 ↑ 1.0 1 6

Index Scan using dim_advertiser_pkey on dim_advertiser dad (cost=0.29..0.31 rows=1 width=26) (actual time=0.003..0.003 rows=1 loops=6)

  • Index Cond: (advertiser_sk = fdl.advertiser_sk)
31. 0.012 0.012 ↑ 1.0 1 6

Index Scan using dim_agency_pkey on dim_agency dag (cost=0.29..0.31 rows=1 width=27) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (agency_sk = fdl.agency_sk)
32. 0.012 0.012 ↑ 1.0 1 6

Index Scan using dim_agency_pkey on dim_agency prag (cost=0.29..0.31 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (agency_sk = fdl.parent_agency_sk)
33. 0.012 0.012 ↑ 1.0 1 6

Index Scan using dim_agency_pkey on dim_agency psag (cost=0.29..0.31 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (agency_sk = fdl.posting_agency_sk)
34. 0.018 0.018 ↑ 1.0 1 6

Index Only Scan using dim_brand_pkey on dim_brand dbr (cost=0.29..0.33 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=6)

  • Index Cond: (brand_sk = fdl.brand_sk)
  • Heap Fetches: 6
35. 0.006 0.006 ↑ 1.0 1 6

Index Scan using dim_calendar_type_pkey on dim_calendar_type dct (cost=0.14..0.16 rows=1 width=280) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (calendar_type_sk = fdl.calendar_type_sk)
36. 0.006 0.006 ↑ 1.0 1 6

Index Scan using dim_division_pkey on dim_division ddv (cost=0.15..0.17 rows=1 width=66) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (division_sk = fdl.division_sk)
37. 0.006 0.006 ↑ 1.0 1 6

Index Only Scan using dim_network_pkey on dim_network ddn (cost=0.14..0.16 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (network_sk = fdl.network_sk)
  • Heap Fetches: 6
38. 0.006 0.006 ↑ 1.0 1 6

Index Only Scan using dim_property_pkey on dim_property ddp (cost=0.15..0.17 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (property_sk = fdl.property_sk)
  • Heap Fetches: 6
39. 0.006 0.006 ↑ 1.0 1 6

Index Scan using dim_rate_card_type_pkey on dim_rate_card_type rct (cost=0.14..0.16 rows=1 width=126) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (rate_card_type_sk = fdl.rate_card_type_sk)
40. 0.012 0.012 ↑ 1.0 1 6

Index Scan using dim_user_pkey on dim_user adu (cost=0.28..0.30 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (user_sk = fdl.ae_user_sk)
41. 0.006 0.006 ↑ 1.0 1 6

Index Scan using dim_user_pkey on dim_user sdu (cost=0.28..0.30 rows=1 width=19) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (user_sk = fdl.sales_planner_user_sk)
42. 0.006 0.006 ↑ 1.0 1 6

Index Scan using dim_team_pkey on dim_team ddt (cost=0.15..0.17 rows=1 width=27) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (team_sk = fdl.team_sk)
43. 0.006 0.006 ↑ 1.0 1 6

Index Scan using dim_audience_pkey on dim_audience gau (cost=0.14..0.16 rows=1 width=15) (actual time=0.001..0.001 rows=1 loops=6)

  • Index Cond: (audience_sk = fdl.guaranteed_audience_sk)
44.          

SubPlan (forSubquery Scan)

45. 0.006 3.208 ↑ 1.0 1 2

Subquery Scan on od (cost=7,384.57..7,520.62 rows=1 width=8) (actual time=1.604..1.604 rows=1 loops=2)

46. 0.008 3.202 ↑ 1.0 1 2

GroupAggregate (cost=7,384.57..7,520.60 rows=1 width=16) (actual time=1.601..1.601 rows=1 loops=2)

  • Group Key: di.deal_sk
47. 0.004 3.194 ↓ 8.0 8 2

Nested Loop Left Join (cost=7,384.57..7,520.59 rows=1 width=16) (actual time=1.595..1.597 rows=8 loops=2)

  • Join Filter: (di.deal_sk = f.deal_sk)
48. 0.008 0.008 ↑ 1.0 1 2

Index Only Scan using dim_deal_pkey on dim_deal di (cost=0.29..4.30 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
  • Heap Fetches: 0
49. 0.802 3.182 ↑ 247.7 7 2

Merge Join (cost=7,384.28..7,494.61 rows=1,734 width=16) (actual time=1.589..1.591 rows=7 loops=2)

  • Merge Cond: (d.date_sk = f.order_start_date_sk)
50. 2.314 2.314 ↑ 4.1 5,332 2

Index Scan using dim_dates_pkey on dim_dates d (cost=0.29..1,382.34 rows=21,916 width=12) (actual time=0.006..1.157 rows=5,332 loops=2)

51. 0.028 0.066 ↑ 247.7 7 2

Sort (cost=6,752.44..6,756.78 rows=1,734 width=12) (actual time=0.033..0.033 rows=7 loops=2)

  • Sort Key: f.order_start_date_sk
  • Sort Method: quicksort Memory: 25kB
52. 0.030 0.038 ↑ 247.7 7 2

Bitmap Heap Scan on fact_spot f (cost=33.87..6,659.16 rows=1,734 width=12) (actual time=0.005..0.019 rows=7 loops=2)

  • Recheck Cond: (deal_sk = dp.deal_sk)
  • Heap Blocks: exact=4
53. 0.008 0.008 ↑ 247.7 7 2

Bitmap Index Scan on idx_fact_spot_replace_deal_sk (cost=0.00..33.44 rows=1,734 width=0) (actual time=0.004..0.004 rows=7 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
54. 0.000 2.952 ↑ 1.0 1 2

Subquery Scan on od_1 (cost=7,384.57..7,520.61 rows=1 width=8) (actual time=1.476..1.476 rows=1 loops=2)

55. 0.006 2.952 ↑ 1.0 1 2

GroupAggregate (cost=7,384.57..7,520.60 rows=1 width=16) (actual time=1.476..1.476 rows=1 loops=2)

  • Group Key: di_1.deal_sk
56. 0.004 2.946 ↓ 8.0 8 2

Nested Loop Left Join (cost=7,384.57..7,520.59 rows=1 width=16) (actual time=1.470..1.473 rows=8 loops=2)

  • Join Filter: (di_1.deal_sk = f_1.deal_sk)
57. 0.008 0.008 ↑ 1.0 1 2

Index Only Scan using dim_deal_pkey on dim_deal di_1 (cost=0.29..4.30 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
  • Heap Fetches: 0
58. 0.832 2.934 ↑ 247.7 7 2

Merge Join (cost=7,384.28..7,494.61 rows=1,734 width=16) (actual time=1.465..1.467 rows=7 loops=2)

  • Merge Cond: (d_1.date_sk = f_1.order_start_date_sk)
59. 2.060 2.060 ↑ 4.1 5,332 2

Index Scan using dim_dates_pkey on dim_dates d_1 (cost=0.29..1,382.34 rows=21,916 width=12) (actual time=0.004..1.030 rows=5,332 loops=2)

60. 0.020 0.042 ↑ 247.7 7 2

Sort (cost=6,752.44..6,756.78 rows=1,734 width=12) (actual time=0.020..0.021 rows=7 loops=2)

  • Sort Key: f_1.order_start_date_sk
  • Sort Method: quicksort Memory: 25kB
61. 0.014 0.022 ↑ 247.7 7 2

Bitmap Heap Scan on fact_spot f_1 (cost=33.87..6,659.16 rows=1,734 width=12) (actual time=0.007..0.011 rows=7 loops=2)

  • Recheck Cond: (deal_sk = dp.deal_sk)
  • Heap Blocks: exact=4
62. 0.008 0.008 ↑ 247.7 7 2

Bitmap Index Scan on idx_fact_spot_replace_deal_sk (cost=0.00..33.44 rows=1,734 width=0) (actual time=0.004..0.004 rows=7 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
63. 0.002 2.788 ↑ 1.0 1 2

Subquery Scan on od_2 (cost=7,384.57..7,523.11 rows=1 width=8) (actual time=1.394..1.394 rows=1 loops=2)

64. 0.006 2.786 ↑ 1.0 1 2

GroupAggregate (cost=7,384.57..7,523.09 rows=1 width=16) (actual time=1.393..1.393 rows=1 loops=2)

  • Group Key: di_2.deal_sk
65. 0.006 2.780 ↓ 8.0 8 2

Nested Loop Left Join (cost=7,384.57..7,523.08 rows=1 width=16) (actual time=1.386..1.390 rows=8 loops=2)

  • Join Filter: (di_2.deal_sk = f_2.deal_sk)
66. 0.008 0.008 ↑ 1.0 1 2

Index Only Scan using dim_deal_pkey on dim_deal di_2 (cost=0.29..4.30 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
  • Heap Fetches: 0
67. 0.762 2.766 ↑ 247.7 7 2

Merge Join (cost=7,384.28..7,497.10 rows=1,734 width=16) (actual time=1.381..1.383 rows=7 loops=2)

  • Merge Cond: (d_2.date_sk = f_2.order_end_date_sk)
68. 1.962 1.962 ↑ 4.1 5,342 2

Index Scan using dim_dates_pkey on dim_dates d_2 (cost=0.29..1,382.34 rows=21,916 width=12) (actual time=0.005..0.981 rows=5,342 loops=2)

69. 0.024 0.042 ↑ 247.7 7 2

Sort (cost=6,752.44..6,756.78 rows=1,734 width=12) (actual time=0.019..0.021 rows=7 loops=2)

  • Sort Key: f_2.order_end_date_sk
  • Sort Method: quicksort Memory: 25kB
70. 0.010 0.018 ↑ 247.7 7 2

Bitmap Heap Scan on fact_spot f_2 (cost=33.87..6,659.16 rows=1,734 width=12) (actual time=0.006..0.009 rows=7 loops=2)

  • Recheck Cond: (deal_sk = dp.deal_sk)
  • Heap Blocks: exact=4
71. 0.008 0.008 ↑ 247.7 7 2

Bitmap Index Scan on idx_fact_spot_replace_deal_sk (cost=0.00..33.44 rows=1,734 width=0) (actual time=0.004..0.004 rows=7 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
72. 0.000 0.084 ↑ 1.0 1 2

Subquery Scan on od_3 (cost=34.46..6,689.13 rows=1 width=8) (actual time=0.042..0.042 rows=1 loops=2)

73. 0.004 0.084 ↑ 1.0 1 2

GroupAggregate (cost=34.46..6,689.11 rows=1 width=16) (actual time=0.042..0.042 rows=1 loops=2)

  • Group Key: di_3.deal_sk
74. 0.029 0.080 ↓ 8.0 8 2

Nested Loop Left Join (cost=34.46..6,689.10 rows=1 width=16) (actual time=0.025..0.040 rows=8 loops=2)

75. 0.012 0.036 ↓ 8.0 8 2

Nested Loop Left Join (cost=34.16..6,685.14 rows=1 width=16) (actual time=0.013..0.018 rows=8 loops=2)

  • Join Filter: (di_3.deal_sk = s.deal_sk)
76. 0.006 0.006 ↑ 1.0 1 2

Index Only Scan using dim_deal_pkey on dim_deal di_3 (cost=0.29..4.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
  • Heap Fetches: 0
77. 0.010 0.018 ↑ 247.7 7 2

Bitmap Heap Scan on fact_spot s (cost=33.87..6,659.16 rows=1,734 width=16) (actual time=0.005..0.009 rows=7 loops=2)

  • Recheck Cond: (deal_sk = dp.deal_sk)
  • Heap Blocks: exact=4
78. 0.008 0.008 ↑ 247.7 7 2

Bitmap Index Scan on idx_fact_spot_replace_deal_sk (cost=0.00..33.44 rows=1,734 width=0) (actual time=0.004..0.004 rows=7 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
79. 0.015 0.015 ↑ 1.0 1 15

Index Scan using dim_order_pkey on dim_order dmo (cost=0.29..3.96 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=15)

  • Index Cond: (s.order_sk = order_sk)
80. 0.020 0.134 ↑ 1.0 1 2

Aggregate (cost=91.02..91.03 rows=1 width=32) (actual time=0.067..0.067 rows=1 loops=2)

81. 0.006 0.114 ↑ 20.0 1 2

Group (cost=90.56..90.71 rows=20 width=42) (actual time=0.056..0.057 rows=1 loops=2)

  • Group Key: fdl_1.deal_sk, dmn.network_sk
82. 0.008 0.108 ↑ 6.7 3 2

Sort (cost=90.56..90.61 rows=20 width=42) (actual time=0.054..0.054 rows=3 loops=2)

  • Sort Key: dmn.network_sk
  • Sort Method: quicksort Memory: 25kB
83. 0.016 0.100 ↑ 6.7 3 2

Hash Join (cost=13.00..90.13 rows=20 width=42) (actual time=0.048..0.050 rows=3 loops=2)

  • Hash Cond: (fdl_1.network_sk = dmn.network_sk)
84. 0.006 0.010 ↑ 6.7 3 2

Bitmap Heap Scan on fact_deal_line fdl_1 (cost=4.58..81.66 rows=20 width=12) (actual time=0.005..0.005 rows=3 loops=2)

  • Recheck Cond: (deal_sk = dp.deal_sk)
  • Heap Blocks: exact=2
85. 0.004 0.004 ↑ 6.7 3 2

Bitmap Index Scan on idx_fact_deal_line_deal_sk (cost=0.00..4.57 rows=20 width=0) (actual time=0.002..0.002 rows=3 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
86. 0.028 0.074 ↑ 1.0 241 1

Hash (cost=5.41..5.41 rows=241 width=34) (actual time=0.074..0.074 rows=241 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
87. 0.046 0.046 ↑ 1.0 241 1

Seq Scan on dim_network dmn (cost=0.00..5.41 rows=241 width=34) (actual time=0.007..0.046 rows=241 loops=1)

88. 0.012 0.046 ↑ 1.0 1 2

Aggregate (cost=102.27..102.28 rows=1 width=32) (actual time=0.023..0.023 rows=1 loops=2)

89. 0.002 0.034 ↑ 20.0 1 2

Group (cost=101.82..101.97 rows=20 width=84) (actual time=0.016..0.017 rows=1 loops=2)

  • Group Key: fdl_2.deal_sk, dmp.property_sk
90. 0.004 0.032 ↑ 6.7 3 2

Sort (cost=101.82..101.87 rows=20 width=84) (actual time=0.016..0.016 rows=3 loops=2)

  • Sort Key: dmp.property_sk
  • Sort Method: quicksort Memory: 25kB
91. 0.011 0.028 ↑ 6.7 3 2

Hash Join (cost=24.25..101.38 rows=20 width=84) (actual time=0.013..0.014 rows=3 loops=2)

  • Hash Cond: (fdl_2.property_sk = dmp.property_sk)
92. 0.004 0.008 ↑ 6.7 3 2

Bitmap Heap Scan on fact_deal_line fdl_2 (cost=4.58..81.66 rows=20 width=12) (actual time=0.003..0.004 rows=3 loops=2)

  • Recheck Cond: (deal_sk = dp.deal_sk)
  • Heap Blocks: exact=2
93. 0.004 0.004 ↑ 6.7 3 2

Bitmap Index Scan on idx_fact_deal_line_deal_sk (cost=0.00..4.57 rows=20 width=0) (actual time=0.002..0.002 rows=3 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)
94. 0.004 0.009 ↑ 26.9 16 1

Hash (cost=14.30..14.30 rows=430 width=76) (actual time=0.009..0.009 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
95. 0.005 0.005 ↑ 26.9 16 1

Seq Scan on dim_property dmp (cost=0.00..14.30 rows=430 width=76) (actual time=0.004..0.005 rows=16 loops=1)

96. 0.006 0.026 ↑ 1.0 1 2

Aggregate (cost=7,152.37..7,152.38 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=2)

97. 0.014 0.020 ↓ 0.0 0 2

Bitmap Heap Scan on fact_spot fs (cost=33.52..7,150.82 rows=308 width=14) (actual time=0.010..0.010 rows=0 loops=2)

  • Recheck Cond: (deal_sk = dp.deal_sk)
  • Filter: ((is_active_record = 1) AND ((stewardship_status_sk = ANY ('{1,2,3}'::integer[])) OR (is_manual_adjustment = 1)) AND (broadcast_week_date_sk <= (to_char((((reveal.get_broadcast_date_from_calendar((now())::date) ->> 'broadcast_quarter_end_date'::text))::date)::timestamp with time zone, 'YYYYMMDD'::text))::bigint))
  • Rows Removed by Filter: 7
  • Heap Blocks: exact=4
98. 0.006 0.006 ↑ 247.7 7 2

Bitmap Index Scan on idx_fact_spot_replace_deal_sk (cost=0.00..33.44 rows=1,734 width=0) (actual time=0.003..0.003 rows=7 loops=2)

  • Index Cond: (deal_sk = dp.deal_sk)