GroupAggregate (cost=-25142102027752040829944596389028691968.00..-25142102027752040829944596389028691968.00 rows=1600000000 width=254) (actual time=1.640..1.640 rows=0 loops=1) Group Key: "*SELECT* 1".sendid_fk, "*SELECT* 1".campaign_fk, ('-1'::smallint), (('-1'::smallint)::integer) Buffers: shared hit=11 -> Sort (cost=-25142102027752040829944596389028691968.00..-25142102027752040829944596389028691968.00 rows=16812456500 width=120) (actual time=1.638..1.638 rows=0 loops=1) Sort Key: "*SELECT* 1".sendid_fk, "*SELECT* 1".campaign_fk, ('-1'::smallint), (('-1'::smallint)::integer) Sort Method: quicksort Memory: 25kB Buffers: shared hit=11 -> Append (cost=329985.38..-25142102027752040829944596389028691968.00 rows=16812456500 width=120) (actual time=1.621..1.621 rows=0 loops=1) Buffers: shared hit=11 -> Subquery Scan on "*SELECT* 1" (cost=329985.38..462708.80 rows=3537400 width=120) (actual time=0.077..0.077 rows=0 loops=1) Buffers: shared hit=6 -> Merge Right Join (cost=329985.38..418491.30 rows=3537400 width=118) (actual time=0.076..0.076 rows=0 loops=1) Merge Cond: (cm.campaign_name = ev.campaign_name) Buffers: shared hit=6 -> Index Scan using campaign__campaign_name on campaign cm (cost=0.15..67.80 rows=1310 width=34) (actual time=0.015..0.015 rows=1 loops=1) Buffers: shared hit=2 -> Sort (cost=329985.23..331335.38 rows=540061 width=74) (actual time=0.058..0.058 rows=0 loops=1) Sort Key: ev.campaign_name Sort Method: quicksort Memory: 25kB Buffers: shared hit=4 -> Merge Right Join (cost=270456.49..278563.96 rows=540061 width=74) (actual time=0.049..0.049 rows=0 loops=1) Merge Cond: (et.event_type_name = ev.event_type) Buffers: shared hit=4 -> Sort (cost=90.93..94.20 rows=1310 width=32) (actual time=0.025..0.025 rows=1 loops=1) Sort Key: et.event_type_name Sort Method: quicksort Memory: 25kB Buffers: shared hit=1 -> Seq Scan on event_type et (cost=0.00..23.10 rows=1310 width=32) (actual time=0.006..0.007 rows=5 loops=1) Buffers: shared hit=1 -> Sort (cost=270365.57..270571.70 rows=82452 width=74) (actual time=0.023..0.023 rows=0 loops=1) Sort Key: ev.event_type Sort Method: quicksort Memory: 25kB Buffers: shared hit=3 -> Hash Left Join (cost=40461.31..263632.84 rows=82452 width=74) (actual time=0.014..0.014 rows=0 loops=1) Hash Cond: (ev.click_subscriber_key = csu.subscriber_name) Buffers: shared hit=3 -> Hash Left Join (cost=21328.11..243458.68 rows=82452 width=102) (actual time=0.013..0.013 rows=0 loops=1) Hash Cond: (ev.open_subscriber_key = osu.subscriber_name) Buffers: shared hit=3 -> Hash Left Join (cost=2194.91..223284.53 rows=82452 width=130) (actual time=0.012..0.012 rows=0 loops=1) Hash Cond: (ev.sendid = si.sendid_name) Buffers: shared hit=3 -> Bitmap Heap Scan on event ev (cost=2155.44..222204.65 rows=82452 width=160) (actual time=0.012..0.012 rows=0 loops=1) Recheck Cond: (event_day_fk = 20171120) Buffers: shared hit=3 -> Bitmap Index Scan on event__event_day_fk (cost=0.00..2134.82 rows=82452 width=0) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: (event_day_fk = 20171120) Buffers: shared hit=3 -> Hash (cost=23.10..23.10 rows=1310 width=34) (never executed) -> Seq Scan on sendid si (cost=0.00..23.10 rows=1310 width=34) (never executed) -> Hash (cost=11259.20..11259.20 rows=629920 width=36) (never executed) -> Seq Scan on subscriber osu (cost=0.00..11259.20 rows=629920 width=36) (never executed) -> Hash (cost=11259.20..11259.20 rows=629920 width=36) (never executed) -> Seq Scan on subscriber csu (cost=0.00..11259.20 rows=629920 width=36) (never executed) -> Merge Left Join (cost=-25142102027752040829944596389028691968.00..-25142102027752040829944596389028691968.00 rows=16808919100 width=120) (actual time=1.543..1.543 rows=0 loops=1) Merge Cond: (t.customer_fk = cu.customer_id) Buffers: shared hit=5 -> Sort (cost=-25142102027752040829944596389028691968.00..-25142102027752040829944596389028691968.00 rows=16808919100 width=82) (actual time=1.543..1.543 rows=0 loops=1) Sort Key: t.customer_fk Sort Method: quicksort Memory: 25kB Buffers: shared hit=5 -> Nested Loop (cost=-2021924571963149.75..-25142102027752040829944596389028691968.00 rows=16808919100 width=82) (actual time=1.537..1.537 rows=0 loops=1) Join Filter: (si_1.sendid_name = ev_1.sendid) Buffers: shared hit=5 -> HashAggregate (cost=239661.55..242267.55 rows=260600 width=34) (actual time=1.536..1.536 rows=0 loops=1) Group Key: ev_1.sendid, cm_1.campaign_id Buffers: shared hit=5 -> Merge Join (cost=228900.82..236989.10 rows=534491 width=34) (actual time=0.016..0.016 rows=0 loops=1) Merge Cond: (cm_1.campaign_name = ev_1.campaign_name) Buffers: shared hit=5 -> Index Scan using campaign__campaign_name on campaign cm_1 (cost=0.15..67.80 rows=1303 width=34) (actual time=0.007..0.007 rows=1 loops=1) Filter: (campaign_id IS NOT NULL) Buffers: shared hit=2 -> Sort (cost=228900.67..229105.77 rows=82040 width=64) (actual time=0.008..0.008 rows=0 loops=1) Sort Key: ev_1.campaign_name Sort Method: quicksort Memory: 25kB Buffers: shared hit=3 -> Bitmap Heap Scan on event ev_1 (cost=2155.34..222204.55 rows=82040 width=64) (actual time=0.002..0.002 rows=0 loops=1) Recheck Cond: (event_day_fk = 20171120) Filter: (sendid IS NOT NULL) Buffers: shared hit=3 -> Bitmap Index Scan on event__event_day_fk (cost=0.00..2134.82 rows=82452 width=0) (actual time=0.002..0.002 rows=0 loops=1) Index Cond: (event_day_fk = 20171120) Buffers: shared hit=3 -> Nested Loop (cost=-2021924572202811.25..-96477751449547350295223172333568.00 rows=84496365 width=144) (never executed) Join Filter: (ad.ad_group_name = si_1.sendid_name) -> Seq Scan on sendid si_1 (cost=0.00..23.10 rows=1303 width=34) (never executed) Filter: (sendid_id IS NOT NULL) -> Nested Loop (cost=-2021924572202811.25..-74042786991210548153116786688.00 rows=84929134 width=110) (never executed) Join Filter: (t.ad_fk = ad.ad_id) -> Index Scan using ad__ad_group_name on ad (cost=0.42..1415932.35 rows=2157 width=40) (never executed) Filter: (channel_name = 'Email'::text) -> Nested Loop Left Join (cost=-2021924572202811.75..-34326744084937666832891904.00 rows=16977262428 width=86) (never executed) -> Merge Left Join (cost=767470.10..256025144.48 rows=16977262428 width=92) (never executed) Merge Cond: (t.touchpoint_id = rp.touchpoint_fk) -> Merge Left Join (cost=595487.90..1108803.95 rows=34168763 width=68) (never executed) Merge Cond: (t.touchpoint_id = ap.touchpoint_fk) -> Sort (cost=509005.69..509397.99 rows=156921 width=44) (never executed) Sort Key: t.touchpoint_id -> Append (cost=0.00..495463.66 rows=156921 width=44) (never executed) -> Seq Scan on touchpoint t (cost=0.00..0.00 rows=1 width=44) (never executed) Filter: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_0 t_1 (cost=353.49..33026.70 rows=10460 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_0__day_fk (cost=0.00..350.88 rows=10460 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_1 t_2 (cost=353.31..32951.98 rows=10436 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_1__day_fk (cost=0.00..350.70 rows=10436 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_2 t_3 (cost=353.51..33033.17 rows=10462 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_2__day_fk (cost=0.00..350.89 rows=10462 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_3 t_4 (cost=353.21..32910.10 rows=10423 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_3__day_fk (cost=0.00..350.60 rows=10423 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_4 t_5 (cost=353.62..33075.49 rows=10476 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_4__day_fk (cost=0.00..351.00 rows=10476 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_5 t_6 (cost=358.10..33273.80 rows=10538 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_5__day_fk (cost=0.00..355.46 rows=10538 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_6 t_7 (cost=353.21..32913.40 rows=10424 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_6__day_fk (cost=0.00..350.61 rows=10424 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_7 t_8 (cost=353.48..33023.38 rows=10459 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_7__day_fk (cost=0.00..350.87 rows=10459 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_8 t_9 (cost=353.53..33042.77 rows=10465 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_8__day_fk (cost=0.00..350.92 rows=10465 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_9 t_10 (cost=353.66..33094.94 rows=10482 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_9__day_fk (cost=0.00..351.04 rows=10482 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_10 t_11 (cost=353.35..32968.57 rows=10442 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_10__day_fk (cost=0.00..350.74 rows=10442 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_11 t_12 (cost=353.66..33094.59 rows=10482 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_11__day_fk (cost=0.00..351.04 rows=10482 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_12 t_13 (cost=357.94..33211.98 rows=10518 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_12__day_fk (cost=0.00..355.31 rows=10518 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_13 t_14 (cost=352.93..32799.96 rows=10388 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_13__day_fk (cost=0.00..350.34 rows=10388 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Bitmap Heap Scan on touchpoint_14 t_15 (cost=353.53..33042.83 rows=10465 width=44) (never executed) Recheck Cond: (day_fk = 20171120) -> Bitmap Index Scan on touchpoint_14__day_fk (cost=0.00..350.92 rows=10465 width=0) (never executed) Index Cond: (day_fk = 20171120) -> Sort (cost=86482.21..86591.08 rows=43549 width=32) (never executed) Sort Key: ap.touchpoint_fk -> Append (cost=0.00..83126.68 rows=43549 width=32) (never executed) -> Seq Scan on acquisition_performance ap (cost=0.00..0.00 rows=1 width=32) (never executed) Filter: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_0 ap_1 (cost=50.91..5537.62 rows=2901 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_0__performance_attribution_model_fk (cost=0.00..50.18 rows=2901 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_1 ap_2 (cost=50.95..5548.79 rows=2907 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_1__performance_attribution_model_fk (cost=0.00..50.23 rows=2907 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_2 ap_3 (cost=50.95..5547.08 rows=2906 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_2__performance_attribution_model_fk (cost=0.00..50.22 rows=2906 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_3 ap_4 (cost=50.87..5528.44 rows=2896 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_3__performance_attribution_model_fk (cost=0.00..50.14 rows=2896 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_4 ap_5 (cost=50.91..5537.32 rows=2901 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_4__performance_attribution_model_fk (cost=0.00..50.18 rows=2901 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_5 ap_6 (cost=50.95..5546.79 rows=2906 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_5__performance_attribution_model_fk (cost=0.00..50.22 rows=2906 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_6 ap_7 (cost=50.92..5539.61 rows=2902 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_6__performance_attribution_model_fk (cost=0.00..50.19 rows=2902 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_7 ap_8 (cost=50.88..5530.15 rows=2897 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_7__performance_attribution_model_fk (cost=0.00..50.15 rows=2897 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_8 ap_9 (cost=50.88..5530.15 rows=2897 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_8__performance_attribution_model_fk (cost=0.00..50.15 rows=2897 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_9 ap_10 (cost=50.95..5547.08 rows=2906 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_9__performance_attribution_model_fk (cost=0.00..50.22 rows=2906 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_10 ap_11 (cost=50.88..5530.73 rows=2897 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_10__performance_attribution_model_fk (cost=0.00..50.15 rows=2897 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_11 ap_12 (cost=50.99..5555.96 rows=2911 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_11__performance_attribution_model_fk (cost=0.00..50.26 rows=2911 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_12 ap_13 (cost=50.99..5558.25 rows=2912 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_12__performance_attribution_model_fk (cost=0.00..50.27 rows=2912 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_13 ap_14 (cost=50.92..5539.91 rows=2902 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_13__performance_attribution_model_fk (cost=0.00..50.19 rows=2902 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on acquisition_performance_14 ap_15 (cost=50.95..5548.79 rows=2907 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on acquisition_performance_14__performance_attribution_model_fk (cost=0.00..50.23 rows=2907 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Sort (cost=171982.20..172230.63 rows=99373 width=32) (never executed) Sort Key: rp.touchpoint_fk -> Append (cost=0.00..163733.96 rows=99373 width=32) (never executed) -> Seq Scan on reactivation_performance rp (cost=0.00..0.00 rows=1 width=32) (never executed) Filter: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_0 rp_1 (cost=111.52..10860.88 rows=6592 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_0__performance_attribution_model_fk (cost=0.00..109.87 rows=6592 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_1 rp_2 (cost=111.11..10775.38 rows=6540 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_1__performance_attribution_model_fk (cost=0.00..109.48 rows=6540 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_2 rp_3 (cost=111.49..10855.79 rows=6589 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_2__performance_attribution_model_fk (cost=0.00..109.84 rows=6589 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_3 rp_4 (cost=111.30..10814.83 rows=6564 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_3__performance_attribution_model_fk (cost=0.00..109.66 rows=6564 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_4 rp_5 (cost=111.62..10883.29 rows=6606 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_4__performance_attribution_model_fk (cost=0.00..109.97 rows=6606 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_5 rp_6 (cost=119.65..11740.46 rows=7126 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_5__performance_attribution_model_fk (cost=0.00..117.87 rows=7126 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_6 rp_7 (cost=110.50..10646.17 rows=6461 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_6__performance_attribution_model_fk (cost=0.00..108.88 rows=6461 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_7 rp_8 (cost=111.42..10841.49 rows=6580 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_7__performance_attribution_model_fk (cost=0.00..109.78 rows=6580 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_8 rp_9 (cost=111.04..10761.08 rows=6531 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_8__performance_attribution_model_fk (cost=0.00..109.41 rows=6531 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_9 rp_10 (cost=116.87..11151.48 rows=6767 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_9__performance_attribution_model_fk (cost=0.00..115.18 rows=6767 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_10 rp_11 (cost=110.49..10644.25 rows=6460 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_10__performance_attribution_model_fk (cost=0.00..108.88 rows=6460 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_11 rp_12 (cost=117.28..11238.07 rows=6820 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_11__performance_attribution_model_fk (cost=0.00..115.58 rows=6820 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_12 rp_13 (cost=117.45..11273.68 rows=6842 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_12__performance_attribution_model_fk (cost=0.00..115.74 rows=6842 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_13 rp_14 (cost=109.69..10476.41 rows=6357 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_13__performance_attribution_model_fk (cost=0.00..108.10 rows=6357 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on reactivation_performance_14 rp_15 (cost=111.09..10770.70 rows=6537 width=32) (never executed) Recheck Cond: (performance_attribution_model_fk = 2) -> Bitmap Index Scan on reactivation_performance_14__performance_attribution_model_fk (cost=0.00..109.45 rows=6537 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Bitmap Heap Scan on converting_touchpoints_attribution conv (cost=-2021924572970281.75..-2021924572970244.00 rows=1 width=10) (never executed) Recheck Cond: ((t.touchpoint_id = touchpoint_fk) AND (performance_attribution_model_fk = 2)) -> BitmapAnd (cost=-2021924572970281.75..-2021924572970281.75 rows=1850 width=0) (never executed) -> Bitmap Index Scan on converting_touchpoints_attribution__touchpoint_fk (cost=0.00..-2021911688068401.00 rows=1850 width=0) (never executed) Index Cond: (t.touchpoint_id = touchpoint_fk) -> Bitmap Index Scan on converting_touchpoints_attribution__performance_attribution_mod (cost=0.00..-12884901880.97 rows=1850 width=0) (never executed) Index Cond: (performance_attribution_model_fk = 2) -> Sort (cost=696479.79..707910.70 rows=4572361 width=6) (never executed) Sort Key: cu.customer_id -> Seq Scan on customer cu (cost=0.00..190673.61 rows=4572361 width=6) (never executed) Planning time: 7.154 ms Execution time: 6.358 ms