GroupAggregate (cost=384347.08..414413.11 rows=37349 width=254) (actual time=5343.214..5417.604 rows=1194 loops=1) Group Key: "*SELECT* 1".sendid_fk, "*SELECT* 1".campaign_fk, ('-1'::smallint), (('-1'::smallint)::integer) Buffers: shared hit=421793 read=26153, temp read=1561 written=1717 -> Sort (cost=384347.08..385280.81 rows=373491 width=120) (actual time=5343.180..5351.390 rows=55816 loops=1) Sort Key: "*SELECT* 1".sendid_fk, "*SELECT* 1".campaign_fk, ('-1'::smallint), (('-1'::smallint)::integer) Sort Method: external merge Disk: 2880kB Buffers: shared hit=421793 read=26153, temp read=1561 written=1717 -> Append (cost=140964.58..319780.25 rows=373491 width=120) (actual time=2319.179..5287.481 rows=55816 loops=1) Buffers: shared hit=421787 read=26153, temp read=1201 written=1356 -> Subquery Scan on "*SELECT* 1" (cost=140964.58..155107.05 rows=373160 width=120) (actual time=2319.178..2358.269 rows=51664 loops=1) Buffers: shared hit=19573 read=20783, temp read=1201 written=1356 -> Merge Right Join (cost=140964.58..150442.55 rows=373160 width=118) (actual time=2319.176..2350.994 rows=51664 loops=1) Merge Cond: (et.event_type_name = ev.event_type) Buffers: shared hit=19573 read=20783, temp read=1201 written=1356 -> Sort (cost=90.93..94.20 rows=1310 width=32) (actual time=1.088..1.090 rows=5 loops=1) Sort Key: et.event_type_name Sort Method: quicksort Memory: 25kB Buffers: shared read=1 -> Seq Scan on event_type et (cost=0.00..23.10 rows=1310 width=32) (actual time=1.065..1.066 rows=5 loops=1) Buffers: shared read=1 -> Materialize (cost=140873.65..141158.50 rows=56971 width=17) (actual time=2318.081..2331.993 rows=51664 loops=1) Buffers: shared hit=19573 read=20782, temp read=1201 written=1356 -> Sort (cost=140873.65..141016.08 rows=56971 width=17) (actual time=2318.076..2323.706 rows=51664 loops=1) Sort Key: ev.event_type Sort Method: external merge Disk: 1312kB Buffers: shared hit=19573 read=20782, temp read=1201 written=1205 -> Hash Left Join (cost=90861.89..135705.53 rows=56971 width=17) (actual time=1897.747..2291.303 rows=51664 loops=1) Hash Cond: (ev.campaign_name = cm.campaign_name) Buffers: shared hit=19573 read=20782, temp read=1037 written=1040 -> Hash Left Join (cost=90858.44..134918.72 rows=56971 width=38) (actual time=1897.709..2277.430 rows=51664 loops=1) Hash Cond: (ev.sendid = si.sendid_name) Buffers: shared hit=19572 read=20782, temp read=1037 written=1040 -> Merge Right Join (cost=90848.40..134190.85 rows=56971 width=42) (actual time=1897.586..2263.942 rows=51664 loops=1) Merge Cond: (osu.subscriber_name = ev.open_subscriber_key) Buffers: shared hit=19571 read=20781, temp read=1037 written=1040 -> Index Scan using subscriber__subscriber_name on subscriber osu (cost=0.43..39487.86 rows=1323362 width=36) (actual time=0.010..216.141 rows=1323194 loops=1) Buffers: shared hit=19562 -> Materialize (cost=90847.98..91132.83 rows=56971 width=70) (actual time=1897.564..1916.819 rows=51664 loops=1) Buffers: shared hit=9 read=20781, temp read=1037 written=1040 -> Sort (cost=90847.98..90990.40 rows=56971 width=70) (actual time=1897.561..1911.064 rows=51664 loops=1) Sort Key: ev.open_subscriber_key Sort Method: external merge Disk: 4112kB Buffers: shared hit=9 read=20781, temp read=1037 written=1040 -> Merge Right Join (cost=41811.94..85011.85 rows=56971 width=70) (actual time=215.181..1861.479 rows=51664 loops=1) Merge Cond: (csu.subscriber_name = ev.click_subscriber_key) Buffers: shared hit=9 read=20781, temp read=523 written=523 -> Index Scan using subscriber__subscriber_name on subscriber csu (cost=0.43..39487.86 rows=1323362 width=36) (actual time=0.005..1510.625 rows=1323194 loops=1) Buffers: shared hit=9 read=19553 -> Materialize (cost=41778.04..42062.89 rows=56971 width=98) (actual time=214.084..225.830 rows=51664 loops=1) Buffers: shared read=1228, temp read=523 written=523 -> Sort (cost=41778.04..41920.47 rows=56971 width=98) (actual time=214.080..220.578 rows=51664 loops=1) Sort Key: ev.click_subscriber_key Sort Method: external sort Disk: 4184kB Buffers: shared read=1228, temp read=523 written=523 -> Index Scan using event__event_day_fk on event ev (cost=0.56..35495.92 rows=56971 width=98) (actual time=3.877..192.397 rows=51664 loops=1) Index Cond: (event_day_fk = 20171120) Buffers: shared read=1228 -> Hash (cost=5.57..5.57 rows=357 width=7) (actual time=0.103..0.103 rows=357 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 22kB Buffers: shared hit=1 read=1 -> Seq Scan on sendid si (cost=0.00..5.57 rows=357 width=7) (actual time=0.013..0.059 rows=357 loops=1) Buffers: shared hit=1 read=1 -> Hash (cost=2.09..2.09 rows=109 width=26) (actual time=0.032..0.032 rows=109 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 15kB Buffers: shared hit=1 -> Seq Scan on campaign cm (cost=0.00..2.09 rows=109 width=26) (actual time=0.007..0.013 rows=109 loops=1) Buffers: shared hit=1 -> Hash Join (cost=37715.40..164669.88 rows=331 width=120) (actual time=264.900..2924.332 rows=4152 loops=1) Hash Cond: (ad.ad_group_name = si_1.sendid_name) Buffers: shared hit=402214 read=5370 -> Nested Loop Left Join (cost=37705.37..164655.25 rows=37 width=115) (actual time=264.770..2919.386 rows=4152 loops=1) Buffers: shared hit=402212 read=5370 -> Nested Loop Left Join (cost=37705.37..163946.79 rows=16 width=99) (actual time=210.937..2437.542 rows=4152 loops=1) Buffers: shared hit=214029 read=5076 -> Nested Loop Left Join (cost=37705.37..163597.96 rows=8 width=75) (actual time=173.726..2018.663 rows=4152 loops=1) Buffers: shared hit=27013 read=4975 -> Nested Loop Left Join (cost=37704.81..163579.72 rows=8 width=73) (actual time=96.881..1909.229 rows=4152 loops=1) Buffers: shared hit=9961 read=4896 -> Hash Join (cost=37704.38..163562.73 rows=8 width=71) (actual time=96.873..1877.702 rows=4152 loops=1) Hash Cond: (ad.ad_group_name = sendid_campaign_match.sendid) Buffers: shared hit=1232 read=4896 -> Hash Join (cost=304.31..126040.79 rows=38 width=63) (actual time=60.935..1839.130 rows=4285 loops=1) Hash Cond: (t.ad_fk = ad.ad_id) Buffers: shared hit=3 read=4896 -> Append (cost=0.00..124157.87 rows=125038 width=44) (actual time=48.277..1810.384 rows=123117 loops=1) Buffers: shared read=4855 -> Seq Scan on touchpoint t (cost=0.00..0.00 rows=1 width=44) (actual time=0.002..0.002 rows=0 loops=1) Filter: (day_fk = 20171120) -> Index Scan using touchpoint_0__day_fk on touchpoint_0 t_1 (cost=0.43..7616.82 rows=7654 width=44) (actual time=48.273..237.069 rows=8295 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=331 -> Index Scan using touchpoint_1__day_fk on touchpoint_1 t_2 (cost=0.43..8099.65 rows=8152 width=44) (actual time=3.415..83.608 rows=8257 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=341 -> Index Scan using touchpoint_2__day_fk on touchpoint_2 t_3 (cost=0.43..8207.70 rows=8262 width=44) (actual time=3.172..49.089 rows=8168 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=325 -> Index Scan using touchpoint_3__day_fk on touchpoint_3 t_4 (cost=0.43..8639.32 rows=8712 width=44) (actual time=3.443..141.148 rows=8377 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=330 -> Index Scan using touchpoint_4__day_fk on touchpoint_4 t_5 (cost=0.43..8540.24 rows=8608 width=44) (actual time=3.038..147.760 rows=8197 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=314 -> Index Scan using touchpoint_5__day_fk on touchpoint_5 t_6 (cost=0.43..7897.13 rows=7940 width=44) (actual time=3.870..42.844 rows=8264 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=324 -> Index Scan using touchpoint_6__day_fk on touchpoint_6 t_7 (cost=0.43..8156.89 rows=8211 width=44) (actual time=3.439..144.567 rows=8194 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=328 -> Index Scan using touchpoint_7__day_fk on touchpoint_7 t_8 (cost=0.43..8830.66 rows=8908 width=44) (actual time=4.362..143.630 rows=8068 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=322 -> Index Scan using touchpoint_8__day_fk on touchpoint_8 t_9 (cost=0.43..9695.86 rows=9808 width=44) (actual time=3.337..142.971 rows=8273 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=329 -> Index Scan using touchpoint_9__day_fk on touchpoint_9 t_10 (cost=0.43..8124.32 rows=8179 width=44) (actual time=3.349..150.226 rows=8167 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=325 -> Index Scan using touchpoint_10__day_fk on touchpoint_10 t_11 (cost=0.43..8356.39 rows=8418 width=44) (actual time=4.030..39.337 rows=8233 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=325 -> Index Scan using touchpoint_11__day_fk on touchpoint_11 t_12 (cost=0.43..7450.94 rows=7481 width=44) (actual time=3.529..45.088 rows=8140 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=319 -> Index Scan using touchpoint_12__day_fk on touchpoint_12 t_13 (cost=0.43..7753.21 rows=7790 width=44) (actual time=3.935..153.074 rows=8131 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=313 -> Index Scan using touchpoint_13__day_fk on touchpoint_13 t_14 (cost=0.43..8589.00 rows=8660 width=44) (actual time=3.264..145.147 rows=8255 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=318 -> Index Scan using touchpoint_14__day_fk on touchpoint_14 t_15 (cost=0.43..8199.74 rows=8254 width=44) (actual time=2.911..135.576 rows=8098 loops=1) Index Cond: (day_fk = 20171120) Buffers: shared read=311 -> Hash (cost=300.40..300.40 rows=313 width=35) (actual time=11.881..11.881 rows=1145 loops=1) Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 109kB Buffers: shared read=41 -> Index Scan using ad__channel_name on ad (cost=0.42..300.40 rows=313 width=35) (actual time=2.580..11.649 rows=1145 loops=1) Index Cond: (channel_name = 'Email'::text) Buffers: shared read=41 -> Hash (cost=37079.88..37079.88 rows=25615 width=8) (actual time=35.890..35.890 rows=115 loops=1) Buckets: 32768 Batches: 1 Memory Usage: 261kB Buffers: shared hit=1229 -> Subquery Scan on sendid_campaign_match (cost=36567.58..37079.88 rows=25615 width=8) (actual time=35.713..35.857 rows=115 loops=1) Buffers: shared hit=1229 -> HashAggregate (cost=36567.58..36823.73 rows=25615 width=8) (actual time=35.712..35.843 rows=115 loops=1) Group Key: ev_1.sendid, cm_1.campaign_id Buffers: shared hit=1229 -> Hash Join (cost=4.02..36282.72 rows=56971 width=8) (actual time=0.071..25.206 rows=51664 loops=1) Hash Cond: (ev_1.campaign_name = cm_1.campaign_name) Buffers: shared hit=1229 -> Index Scan using event__event_day_fk on event ev_1 (cost=0.56..35495.92 rows=56971 width=29) (actual time=0.024..12.175 rows=51664 loops=1) Index Cond: (event_day_fk = 20171120) Filter: (sendid IS NOT NULL) Buffers: shared hit=1228 -> Hash (cost=2.09..2.09 rows=109 width=26) (actual time=0.038..0.038 rows=109 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 15kB Buffers: shared hit=1 -> Seq Scan on campaign cm_1 (cost=0.00..2.09 rows=109 width=26) (actual time=0.010..0.020 rows=109 loops=1) Filter: (campaign_id IS NOT NULL) Buffers: shared hit=1 -> Index Scan using customer_pkey on customer cu (cost=0.43..2.12 rows=1 width=6) (actual time=0.007..0.007 rows=1 loops=4152) Index Cond: (customer_id = t.customer_fk) Buffers: shared hit=8729 -> Index Scan using converting_touchpoints_attribution__touchpoint_fk_performance_a on converting_touchpoints_attribution conv (cost=0.56..2.27 rows=1 width=10) (actual time=0.026..0.026 rows=0 loops=4152) Index Cond: ((t.touchpoint_id = touchpoint_fk) AND (performance_attribution_model_fk = 2)) Buffers: shared hit=17052 read=79 -> Append (cost=0.00..43.44 rows=16 width=32) (actual time=0.099..0.099 rows=0 loops=4152) Buffers: shared hit=187016 read=101 -> Seq Scan on acquisition_performance ap (cost=0.00..0.00 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=4152) Filter: ((performance_attribution_model_fk = 2) AND (touchpoint_fk = t.touchpoint_id)) -> Index Scan using acquisition_performance_0__touchpoint_fk on acquisition_performance_0 ap_1 (cost=0.42..2.90 rows=1 width=32) (actual time=0.027..0.027 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12456 read=9 -> Index Scan using acquisition_performance_1__touchpoint_fk on acquisition_performance_1 ap_2 (cost=0.42..2.90 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12500 read=7 -> Index Scan using acquisition_performance_2__touchpoint_fk on acquisition_performance_2 ap_3 (cost=0.42..2.90 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12451 read=6 -> Index Scan using acquisition_performance_3__touchpoint_fk on acquisition_performance_3 ap_4 (cost=0.42..2.90 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12455 read=8 -> Index Scan using acquisition_performance_4__touchpoint_fk on acquisition_performance_4 ap_5 (cost=0.42..2.90 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12480 read=9 -> Index Scan using acquisition_performance_5__touchpoint_fk on acquisition_performance_5 ap_6 (cost=0.42..2.90 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Buffers: shared hit=12451 read=5 -> Index Scan using acquisition_performance_6__touchpoint_fk on acquisition_performance_6 ap_7 (cost=0.42..2.90 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Buffers: shared hit=12516 read=6 -> Index Scan using acquisition_performance_7__touchpoint_fk on acquisition_performance_7 ap_8 (cost=0.42..2.90 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12451 read=6 -> Index Scan using acquisition_performance_8__touchpoint_fk on acquisition_performance_8 ap_9 (cost=0.42..2.89 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12455 read=8 -> Index Scan using acquisition_performance_9__touchpoint_fk on acquisition_performance_9 ap_10 (cost=0.42..2.89 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12473 read=7 -> Index Scan using acquisition_performance_10__touchpoint_fk on acquisition_performance_10 ap_11 (cost=0.42..2.89 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Buffers: shared hit=12451 read=5 -> Index Scan using acquisition_performance_11__touchpoint_fk on acquisition_performance_11 ap_12 (cost=0.42..2.90 rows=1 width=32) (actual time=0.027..0.027 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12451 read=6 -> Index Scan using acquisition_performance_12__touchpoint_fk on acquisition_performance_12 ap_13 (cost=0.42..2.89 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12523 read=8 -> Index Scan using acquisition_performance_13__touchpoint_fk on acquisition_performance_13 ap_14 (cost=0.42..2.89 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Buffers: shared hit=12451 read=5 -> Index Scan using acquisition_performance_14__touchpoint_fk on acquisition_performance_14 ap_15 (cost=0.42..2.89 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12452 read=6 -> Append (cost=0.00..44.12 rows=16 width=32) (actual time=0.105..0.115 rows=0 loops=4152) Buffers: shared hit=188183 read=294 -> Seq Scan on reactivation_performance rp (cost=0.00..0.00 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=4152) Filter: ((performance_attribution_model_fk = 2) AND (touchpoint_fk = t.touchpoint_id)) -> Index Scan using reactivation_performance_0__touchpoint_fk on reactivation_performance_0 rp_1 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12549 read=20 -> Index Scan using reactivation_performance_1__touchpoint_fk on reactivation_performance_1 rp_2 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12574 read=21 -> Index Scan using reactivation_performance_2__touchpoint_fk on reactivation_performance_2 rp_3 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12544 read=20 -> Index Scan using reactivation_performance_3__touchpoint_fk on reactivation_performance_3 rp_4 (cost=0.43..2.94 rows=1 width=32) (actual time=0.005..0.005 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12552 read=19 -> Index Scan using reactivation_performance_4__touchpoint_fk on reactivation_performance_4 rp_5 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12516 read=18 -> Index Scan using reactivation_performance_5__touchpoint_fk on reactivation_performance_5 rp_6 (cost=0.43..2.95 rows=1 width=32) (actual time=0.028..0.028 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12562 read=21 -> Index Scan using reactivation_performance_6__touchpoint_fk on reactivation_performance_6 rp_7 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12530 read=18 -> Index Scan using reactivation_performance_7__touchpoint_fk on reactivation_performance_7 rp_8 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12535 read=19 -> Index Scan using reactivation_performance_8__touchpoint_fk on reactivation_performance_8 rp_9 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12529 read=20 -> Index Scan using reactivation_performance_9__touchpoint_fk on reactivation_performance_9 rp_10 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12561 read=19 -> Index Scan using reactivation_performance_10__touchpoint_fk on reactivation_performance_10 rp_11 (cost=0.43..2.94 rows=1 width=32) (actual time=0.028..0.028 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12533 read=21 -> Index Scan using reactivation_performance_11__touchpoint_fk on reactivation_performance_11 rp_12 (cost=0.43..2.95 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12591 read=20 -> Index Scan using reactivation_performance_12__touchpoint_fk on reactivation_performance_12 rp_13 (cost=0.43..2.95 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12527 read=18 -> Index Scan using reactivation_performance_13__touchpoint_fk on reactivation_performance_13 rp_14 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12531 read=20 -> Index Scan using reactivation_performance_14__touchpoint_fk on reactivation_performance_14 rp_15 (cost=0.43..2.94 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=4152) Index Cond: (touchpoint_fk = t.touchpoint_id) Filter: (performance_attribution_model_fk = 2) Rows Removed by Filter: 0 Buffers: shared hit=12549 read=20 -> Hash (cost=5.57..5.57 rows=357 width=7) (actual time=0.105..0.105 rows=357 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 22kB Buffers: shared hit=2 -> Seq Scan on sendid si_1 (cost=0.00..5.57 rows=357 width=7) (actual time=0.014..0.057 rows=357 loops=1) Filter: (sendid_id IS NOT NULL) Buffers: shared hit=2 Planning time: 635.005 ms Execution time: 5423.894 ms