explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tni9

Settings
# exclusive inclusive rows x rows loops node
1. 69.945 30,311.115 ↑ 1,000.0 100 1

GroupAggregate (cost=32,709,228.43..35,460,228.43 rows=100,000 width=8,826) (actual time=30,241.531..30,311.115 rows=100 loops=1)

  • Output: sum((sum(f.active_meas))), sum((sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time_impression_count ELSE '0'::bigint END))), sum((sum(f.active_viewable))), sum((sum(f.ad_not_found_timeout))), sum((sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_hidden ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_onebyone ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stacked ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stuffed ELSE '0'::bigint END))), sum((sum(f.adtagsfound))), sum((sum(f.btf_absolute_l))), sum((sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_l ELSE '0'::bigint END))), sum((sum(f.btf_absolute_ots))), sum((sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_ots ELSE '0'::bigint END))), sum((sum(f.c1))), sum((sum(f.c1_git))), sum((sum(f.c1_unfiltered))), sum((sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_inview ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.dentsu_display_ots ELSE '0'::bigint END))), sum((sum(f.exceptions))), sum((sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_imps ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_time ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.full_vis_2_sec_continuous_inview ELSE '0'::bigint END))), sum((sum(f.gen4))), sum((sum(f.groupm_display_imps))), sum((sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.groupm_display_imps ELSE '0'::bigint END))), sum((sum(f.gv_adult))), sum((sum(f.gv_arms))), sum((sum(f.gv_categorized))), sum((sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_categorized ELSE '0'::bigint END))), sum((sum(f.gv_crime))), sum((sum(f.gv_death_injury))), sum((sum(f.gv_download))), sum((sum(f.gv_drugs))), sum((sum(f.gv_hatespeech))), sum((sum(f.gv_military))), sum((sum(f.gv_obscenity))), sum((sum(f.gv_safe))), sum((sum(f.gv_terrorism))), sum((sum(f.gv_tobacco))), sum((sum(f.gv_unsafe))), sum((sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_unsafe ELSE (COALESCE(f.gv_categorized, '0'::bigint) - COALESCE(f.gv_safe, '0'::bigint)) END))), sum((sum(f.h1))), sum((sum(f.had_any_strict_view_time))), sum((sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.had_any_strict_view_time ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date < '2015-02-26'::date) THEN (CASE WHEN (t.date >= '2015-01-10'::date) THEN LEAST((COALESCE(f.px_or_strict_js_ots, '0'::bigint) - COALESCE(f.susp_bot_viewable, '0'::bigint)), (COALESCE(f.susp_l, '0'::bigint) - COALESCE(f.susp_bot, '0'::bigint))) ELSE '0'::bigint END)::double precision ELSE floor(((COALESCE(f.px_or_strict_js_ots, '0'::bigint))::double precision - ((COALESCE(f.susp_bot_viewable, '0'::bigint))::double precision * CASE WHEN (COALESCE(f.susp_l_inview_measurable, '0'::bigint) = 0) THEN '1'::double precision ELSE ((COALESCE(f.l_somehow_measurable, '0'::bigint) / COALESCE(f.susp_l_inview_measurable, '0'::bigint)))::double precision END))) END))), sum((sum(f.ia_loaded))), sum((sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_loaded ELSE '0'::bigint END))), sum((sum(f.ia_measurable))), sum((sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_measurable ELSE '0'::bigint END))), sum((sum(f.impressions))), sum((sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.in_vp ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.in_vp ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp_meas ELSE '0'::bigint END))), sum((sum(f.ir4interactions))), sum((sum((COALESCE(f.l, '0'::bigint) - COALESCE(f.l_mobile, '0'::bigint))))), sum((sum(f.msir4sum))), sum((sum(f.iva))), sum((sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.iva ELSE '0'::bigint END))), sum((sum(f.ivb))), sum((sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivb ELSE '0'::bigint END))), sum((sum(f.ivc))), sum((sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivc ELSE '0'::bigint END))), sum((sum(f.ivd))), sum((sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivd ELSE '0'::bigint END))), sum((sum(f.ive))), sum((sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ive ELSE '0'::bigint END))), sum((sum(f.l))), sum((sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-02-20'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-05-13'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(f.l_above_fold))), sum((sum(CASE WHEN (t.date > '2012-11-19'::date) THEN f.l_somehow_measurable ELSE f.l_birds_eye END))), sum((sum(CASE WHEN (t.date >= '2014-03-18'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(f.l_birds_eye))), sum((sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_birds_eye ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_measurable, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END))), sum((sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-09-01'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2018-04-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-11-18'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END))), sum((sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots_1_sec, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END))), sum((sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_ots ELSE '0'::bigint END))), sum((sum(f.l_groupm_payable_imp))), sum((sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_groupm_payable_imp ELSE '0'::bigint END))), sum((sum(f.l_mobile))), sum((sum(f.l_mobile_not_iframe))), sum((sum(f.l_not_iframe))), sum((sum(f.l_not_iframe_git))), sum((sum(f.l_not_iframe_unfiltered))), sum((sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(f.l_px))), sum((sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(f.l_somehow_measurable))), sum((sum(CASE WHEN (t.date <= '2013-12-13'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2013-12-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-07-29'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-07-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(f.l_somehow_measurable_git))), sum((sum(CASE WHEN (t.date >= '2012-12-19'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(f.l_somehow_measurable_unfiltered))), sum((sum(f.l_time))), sum((sum(CASE WHEN (t.date >= '2012-03-21'::date) THEN f.l ELSE '0'::bigint END))), t.level0top, f.level1, sum((sum(f.loads_git))), sum((sum(CASE WHEN (t.date >= '2018-02-21'::date) THEN f.l ELSE '0'::bigint END))), sum((sum(f.loads_unfiltered))), sum((sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.loads_unfiltered ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.loads_unfiltered ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.loads_unfiltered ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END))), sum((sum(f.mm_history))), sum((sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_history ELSE '0'::bigint END))), sum((sum(f.mm_no_referrer))), sum((sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_no_referrer ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.moat_sdk_measurable_imps ELSE '0'::bigint END))), sum((sum(f.ms_lax_dwell_sum))), sum((sum(f.ms_px_or_lax_js_in_viewsum))), sum((sum(f.ms_px_or_strict_js_in_viewsum))), sum((sum(f.msdwellsum))), sum((sum(f.ms_px_or_strict_js_in_viewsum))), sum((sum(f.msreactionsum))), sum((sum(f.mstoscrollcount))), sum((sum(f.mstoscrollsum))), sum((sum(f.mstoviewsum))), sum((sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_available_imps ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_measurable_imps ELSE '0'::bigint END))), sum((sum(f.on_screen_1_continuous_second_imps))), sum((sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.opacity_ever_non_zero ELSE '0'::bigint END))), sum((sum(f.ots))), sum((sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.ots ELSE '0'::bigint END))), sum((sum(f.px_or_strict_js_ots))), sum((sum(f.px_or_strict_js_ots))), sum((sum(f.page_ever_focused))), sum((sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.page_ever_focused ELSE '0'::bigint END))), sum((sum(f.passthrough_imps))), sum((sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.passthrough_imps ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.pixels_received ELSE '0'::bigint END))), sum((sum(f.px_or_lax_js_ots))), sum((sum(f.px_or_strict_js_ots))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END))), sum((sum(f.px_or_strict_js_ots_git))), sum((sum(f.px_or_strict_js_ots_unfiltered))), sum((sum(f.px_ots))), sum((sum(f.pxbe_any_ots))), sum((sum(f.pxbe_l))), sum((sum(f.pxbe_lax_ots))), sum((sum(f.pxbe_ms_lax_in_view_sum))), sum((sum(f.pxbe_ms_px_in_view_sum))), sum((sum(f.pxbe_px_ots))), sum((sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_perc ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_time ELSE '0'::bigint END))), sum((sum(f.s1))), sum((sum(f.session_hijacked_imps))), sum((sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.session_hijacked_imps ELSE '0'::bigint END))), (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), sum((sum(f.lax_ots))), sum((sum(f.gen6))), sum((sum(f.susp_ad_invisible))), sum((sum(f.susp_ad_onebyone))), sum((sum(f.susp_ad_stuffed))), sum((sum(f.susp_bad_domain))), sum((sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.susp_bad_domain ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_bot ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_browser ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_data_center ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.susp_l END))), sum((sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.susp_bot_dentsu_display_ots ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_geo ELSE '0'::bigint END))), sum((sum(f.susp_bot_inview_measurable))), sum((sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable ELSE '0'::bigint END))), sum((sum(f.susp_bot_inview_measurable_gm))), sum((sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.l END))), sum((sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN (COALESCE(f.loads_unfiltered, '0'::bigint) - COALESCE(f.l, '0'::bigint)) ELSE f.susp_bot END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_proxy ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_spider ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_susp_browser ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END))), sum((sum(f.susp_bot_viewable_gmp))), sum((sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gmp ELSE '0'::bigint END))), sum((sum(f.susp_hidden_ad))), sum((sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.susp_hidden_ad ELSE '0'::bigint END))), sum((sum(f.susp_inapp_sivt))), sum((sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.susp_incentivized_imps ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_l ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_l ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_late_night ELSE '0'::bigint END))), sum((sum(f.susp_ms_abf))), sum((sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.susp_ms_abf ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_old_browser ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_top_hour ELSE '0'::bigint END))), sum((sum(f.t1))), sum((sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.throttling_imps ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2013-02-04'::date) THEN f.gen7 ELSE f.msreactionsum END))), sum((sum(f.total_fully_on_screen_time))), sum((sum(f.total_on_screen_time))), sum((sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END))), sum((sum(CASE WHEN (t.date >= '2016-08-24'::date) THEN COALESCE(f.l_birds_eye, '0'::bigint) WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2016-08-24'::date)) THEN COALESCE(f.l_somehow_measurable, '0'::bigint) ELSE '0'::bigint END))), (COALESCE(client_creative_properties.x_y, '-'::text))
  • Group Key: t.level0top, f.level1, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), (COALESCE(client_creative_properties.x_y, '-'::text))
  • Buffers: shared hit=17688
2. 22.432 30,241.170 ↑ 29.7 3,369 1

Sort (cost=32,709,228.43..32,714,228.43 rows=100,000 width=8,826) (actual time=30,240.033..30,241.170 rows=3,369 loops=1)

  • Output: t.level0top, f.level1, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), (COALESCE(client_creative_properties.x_y, '-'::text)), (sum(f.active_meas)), (sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time_impression_count ELSE '0'::bigint END)), (sum(f.active_viewable)), (sum(f.ad_not_found_timeout)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_hidden ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_onebyone ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stacked ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stuffed ELSE '0'::bigint END)), (sum(f.adtagsfound)), (sum(f.btf_absolute_l)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_l ELSE '0'::bigint END)), (sum(f.btf_absolute_ots)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_ots ELSE '0'::bigint END)), (sum(f.c1)), (sum(f.c1_git)), (sum(f.c1_unfiltered)), (sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_inview ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.dentsu_display_ots ELSE '0'::bigint END)), (sum(f.exceptions)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_time ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.full_vis_2_sec_continuous_inview ELSE '0'::bigint END)), (sum(f.gen4)), (sum(f.groupm_display_imps)), (sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.groupm_display_imps ELSE '0'::bigint END)), (sum(f.gv_adult)), (sum(f.gv_arms)), (sum(f.gv_categorized)), (sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_categorized ELSE '0'::bigint END)), (sum(f.gv_crime)), (sum(f.gv_death_injury)), (sum(f.gv_download)), (sum(f.gv_drugs)), (sum(f.gv_hatespeech)), (sum(f.gv_military)), (sum(f.gv_obscenity)), (sum(f.gv_safe)), (sum(f.gv_terrorism)), (sum(f.gv_tobacco)), (sum(f.gv_unsafe)), (sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_unsafe ELSE (COALESCE(f.gv_categorized, '0'::bigint) - COALESCE(f.gv_safe, '0'::bigint)) END)), (sum(f.h1)), (sum(f.had_any_strict_view_time)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.had_any_strict_view_time ELSE '0'::bigint END)), (sum(CASE WHEN (t.date < '2015-02-26'::date) THEN (CASE WHEN (t.date >= '2015-01-10'::date) THEN LEAST((COALESCE(f.px_or_strict_js_ots, '0'::bigint) - COALESCE(f.susp_bot_viewable, '0'::bigint)), (COALESCE(f.susp_l, '0'::bigint) - COALESCE(f.susp_bot, '0'::bigint))) ELSE '0'::bigint END)::double precision ELSE floor(((COALESCE(f.px_or_strict_js_ots, '0'::bigint))::double precision - ((COALESCE(f.susp_bot_viewable, '0'::bigint))::double precision * CASE WHEN (COALESCE(f.susp_l_inview_measurable, '0'::bigint) = 0) THEN '1'::double precision ELSE ((COALESCE(f.l_somehow_measurable, '0'::bigint) / COALESCE(f.susp_l_inview_measurable, '0'::bigint)))::double precision END))) END)), (sum(f.ia_loaded)), (sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_loaded ELSE '0'::bigint END)), (sum(f.ia_measurable)), (sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_measurable ELSE '0'::bigint END)), (sum(f.impressions)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.in_vp ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.in_vp ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp_meas ELSE '0'::bigint END)), (sum(f.ir4interactions)), (sum((COALESCE(f.l, '0'::bigint) - COALESCE(f.l_mobile, '0'::bigint)))), (sum(f.msir4sum)), (sum(f.iva)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.iva ELSE '0'::bigint END)), (sum(f.ivb)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivb ELSE '0'::bigint END)), (sum(f.ivc)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivc ELSE '0'::bigint END)), (sum(f.ivd)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivd ELSE '0'::bigint END)), (sum(f.ive)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ive ELSE '0'::bigint END)), (sum(f.l)), (sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-20'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-05-13'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.l_above_fold)), (sum(CASE WHEN (t.date > '2012-11-19'::date) THEN f.l_somehow_measurable ELSE f.l_birds_eye END)), (sum(CASE WHEN (t.date >= '2014-03-18'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(f.l_birds_eye)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_birds_eye ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_measurable, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END)), (sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-01'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-04-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-11-18'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END)), (sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots_1_sec, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_ots ELSE '0'::bigint END)), (sum(f.l_groupm_payable_imp)), (sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_groupm_payable_imp ELSE '0'::bigint END)), (sum(f.l_mobile)), (sum(f.l_mobile_not_iframe)), (sum(f.l_not_iframe)), (sum(f.l_not_iframe_git)), (sum(f.l_not_iframe_unfiltered)), (sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.l_px)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.l_somehow_measurable)), (sum(CASE WHEN (t.date <= '2013-12-13'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2013-12-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-07-29'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-07-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(f.l_somehow_measurable_git)), (sum(CASE WHEN (t.date >= '2012-12-19'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(f.l_somehow_measurable_unfiltered)), (sum(f.l_time)), (sum(CASE WHEN (t.date >= '2012-03-21'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.loads_git)), (sum(CASE WHEN (t.date >= '2018-02-21'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.loads_unfiltered)), (sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(f.mm_history)), (sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_history ELSE '0'::bigint END)), (sum(f.mm_no_referrer)), (sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_no_referrer ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.moat_sdk_measurable_imps ELSE '0'::bigint END)), (sum(f.ms_lax_dwell_sum)), (sum(f.ms_px_or_lax_js_in_viewsum)), (sum(f.ms_px_or_strict_js_in_viewsum)), (sum(f.msdwellsum)), (sum(f.ms_px_or_strict_js_in_viewsum)), (sum(f.msreactionsum)), (sum(f.mstoscrollcount)), (sum(f.mstoscrollsum)), (sum(f.mstoviewsum)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_available_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_measurable_imps ELSE '0'::bigint END)), (sum(f.on_screen_1_continuous_second_imps)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.opacity_ever_non_zero ELSE '0'::bigint END)), (sum(f.ots)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.ots ELSE '0'::bigint END)), (sum(f.px_or_strict_js_ots)), (sum(f.px_or_strict_js_ots)), (sum(f.page_ever_focused)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.page_ever_focused ELSE '0'::bigint END)), (sum(f.passthrough_imps)), (sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.passthrough_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.pixels_received ELSE '0'::bigint END)), (sum(f.px_or_lax_js_ots)), (sum(f.px_or_strict_js_ots)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (sum(f.px_or_strict_js_ots_git)), (sum(f.px_or_strict_js_ots_unfiltered)), (sum(f.px_ots)), (sum(f.pxbe_any_ots)), (sum(f.pxbe_l)), (sum(f.pxbe_lax_ots)), (sum(f.pxbe_ms_lax_in_view_sum)), (sum(f.pxbe_ms_px_in_view_sum)), (sum(f.pxbe_px_ots)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_perc ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_time ELSE '0'::bigint END)), (sum(f.s1)), (sum(f.session_hijacked_imps)), (sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.session_hijacked_imps ELSE '0'::bigint END)), (sum(f.lax_ots)), (sum(f.gen6)), (sum(f.susp_ad_invisible)), (sum(f.susp_ad_onebyone)), (sum(f.susp_ad_stuffed)), (sum(f.susp_bad_domain)), (sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.susp_bad_domain ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_bot ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_browser ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_data_center ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.susp_l END)), (sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.susp_bot_dentsu_display_ots ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_geo ELSE '0'::bigint END)), (sum(f.susp_bot_inview_measurable)), (sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable ELSE '0'::bigint END)), (sum(f.susp_bot_inview_measurable_gm)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.l END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN (COALESCE(f.loads_unfiltered, '0'::bigint) - COALESCE(f.l, '0'::bigint)) ELSE f.susp_bot END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_proxy ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_spider ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_susp_browser ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END)), (sum(f.susp_bot_viewable_gmp)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gmp ELSE '0'::bigint END)), (sum(f.susp_hidden_ad)), (sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.susp_hidden_ad ELSE '0'::bigint END)), (sum(f.susp_inapp_sivt)), (sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.susp_incentivized_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_late_night ELSE '0'::bigint END)), (sum(f.susp_ms_abf)), (sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.susp_ms_abf ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_old_browser ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_top_hour ELSE '0'::bigint END)), (sum(f.t1)), (sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.throttling_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2013-02-04'::date) THEN f.gen7 ELSE f.msreactionsum END)), (sum(f.total_fully_on_screen_time)), (sum(f.total_on_screen_time)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-08-24'::date) THEN COALESCE(f.l_birds_eye, '0'::bigint) WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2016-08-24'::date)) THEN COALESCE(f.l_somehow_measurable, '0'::bigint) ELSE '0'::bigint END))
  • Sort Key: t.level0top COLLATE "C", f.level1 COLLATE "C", (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)) COLLATE "C", (COALESCE(client_creative_properties.x_y, '-'::text))
  • Sort Method: quicksort Memory: 4795kB
  • Buffers: shared hit=17688
3. 7.576 30,218.738 ↑ 29.7 3,369 1

Hash Left Join (cost=465,146.20..32,326,920.03 rows=100,000 width=8,826) (actual time=28,351.067..30,218.738 rows=3,369 loops=1)

  • Output: t.level0top, f.level1, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), COALESCE(client_creative_properties.x_y, '-'::text), (sum(f.active_meas)), (sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time_impression_count ELSE '0'::bigint END)), (sum(f.active_viewable)), (sum(f.ad_not_found_timeout)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_hidden ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_onebyone ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stacked ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stuffed ELSE '0'::bigint END)), (sum(f.adtagsfound)), (sum(f.btf_absolute_l)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_l ELSE '0'::bigint END)), (sum(f.btf_absolute_ots)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_ots ELSE '0'::bigint END)), (sum(f.c1)), (sum(f.c1_git)), (sum(f.c1_unfiltered)), (sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_inview ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.dentsu_display_ots ELSE '0'::bigint END)), (sum(f.exceptions)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_time ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.full_vis_2_sec_continuous_inview ELSE '0'::bigint END)), (sum(f.gen4)), (sum(f.groupm_display_imps)), (sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.groupm_display_imps ELSE '0'::bigint END)), (sum(f.gv_adult)), (sum(f.gv_arms)), (sum(f.gv_categorized)), (sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_categorized ELSE '0'::bigint END)), (sum(f.gv_crime)), (sum(f.gv_death_injury)), (sum(f.gv_download)), (sum(f.gv_drugs)), (sum(f.gv_hatespeech)), (sum(f.gv_military)), (sum(f.gv_obscenity)), (sum(f.gv_safe)), (sum(f.gv_terrorism)), (sum(f.gv_tobacco)), (sum(f.gv_unsafe)), (sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_unsafe ELSE (COALESCE(f.gv_categorized, '0'::bigint) - COALESCE(f.gv_safe, '0'::bigint)) END)), (sum(f.h1)), (sum(f.had_any_strict_view_time)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.had_any_strict_view_time ELSE '0'::bigint END)), (sum(CASE WHEN (t.date < '2015-02-26'::date) THEN (CASE WHEN (t.date >= '2015-01-10'::date) THEN LEAST((COALESCE(f.px_or_strict_js_ots, '0'::bigint) - COALESCE(f.susp_bot_viewable, '0'::bigint)), (COALESCE(f.susp_l, '0'::bigint) - COALESCE(f.susp_bot, '0'::bigint))) ELSE '0'::bigint END)::double precision ELSE floor(((COALESCE(f.px_or_strict_js_ots, '0'::bigint))::double precision - ((COALESCE(f.susp_bot_viewable, '0'::bigint))::double precision * CASE WHEN (COALESCE(f.susp_l_inview_measurable, '0'::bigint) = 0) THEN '1'::double precision ELSE ((COALESCE(f.l_somehow_measurable, '0'::bigint) / COALESCE(f.susp_l_inview_measurable, '0'::bigint)))::double precision END))) END)), (sum(f.ia_loaded)), (sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_loaded ELSE '0'::bigint END)), (sum(f.ia_measurable)), (sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_measurable ELSE '0'::bigint END)), (sum(f.impressions)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.in_vp ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.in_vp ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp_meas ELSE '0'::bigint END)), (sum(f.ir4interactions)), (sum((COALESCE(f.l, '0'::bigint) - COALESCE(f.l_mobile, '0'::bigint)))), (sum(f.msir4sum)), (sum(f.iva)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.iva ELSE '0'::bigint END)), (sum(f.ivb)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivb ELSE '0'::bigint END)), (sum(f.ivc)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivc ELSE '0'::bigint END)), (sum(f.ivd)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivd ELSE '0'::bigint END)), (sum(f.ive)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ive ELSE '0'::bigint END)), (sum(f.l)), (sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-20'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-05-13'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.l_above_fold)), (sum(CASE WHEN (t.date > '2012-11-19'::date) THEN f.l_somehow_measurable ELSE f.l_birds_eye END)), (sum(CASE WHEN (t.date >= '2014-03-18'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(f.l_birds_eye)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_birds_eye ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_measurable, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END)), (sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-01'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-04-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-11-18'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END)), (sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots_1_sec, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_ots ELSE '0'::bigint END)), (sum(f.l_groupm_payable_imp)), (sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_groupm_payable_imp ELSE '0'::bigint END)), (sum(f.l_mobile)), (sum(f.l_mobile_not_iframe)), (sum(f.l_not_iframe)), (sum(f.l_not_iframe_git)), (sum(f.l_not_iframe_unfiltered)), (sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.l_px)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.l_somehow_measurable)), (sum(CASE WHEN (t.date <= '2013-12-13'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2013-12-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-07-29'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-07-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(f.l_somehow_measurable_git)), (sum(CASE WHEN (t.date >= '2012-12-19'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(f.l_somehow_measurable_unfiltered)), (sum(f.l_time)), (sum(CASE WHEN (t.date >= '2012-03-21'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.loads_git)), (sum(CASE WHEN (t.date >= '2018-02-21'::date) THEN f.l ELSE '0'::bigint END)), (sum(f.loads_unfiltered)), (sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (sum(f.mm_history)), (sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_history ELSE '0'::bigint END)), (sum(f.mm_no_referrer)), (sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_no_referrer ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.moat_sdk_measurable_imps ELSE '0'::bigint END)), (sum(f.ms_lax_dwell_sum)), (sum(f.ms_px_or_lax_js_in_viewsum)), (sum(f.ms_px_or_strict_js_in_viewsum)), (sum(f.msdwellsum)), (sum(f.ms_px_or_strict_js_in_viewsum)), (sum(f.msreactionsum)), (sum(f.mstoscrollcount)), (sum(f.mstoscrollsum)), (sum(f.mstoviewsum)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_available_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_measurable_imps ELSE '0'::bigint END)), (sum(f.on_screen_1_continuous_second_imps)), (sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.opacity_ever_non_zero ELSE '0'::bigint END)), (sum(f.ots)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.ots ELSE '0'::bigint END)), (sum(f.px_or_strict_js_ots)), (sum(f.px_or_strict_js_ots)), (sum(f.page_ever_focused)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.page_ever_focused ELSE '0'::bigint END)), (sum(f.passthrough_imps)), (sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.passthrough_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.pixels_received ELSE '0'::bigint END)), (sum(f.px_or_lax_js_ots)), (sum(f.px_or_strict_js_ots)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (sum(f.px_or_strict_js_ots_git)), (sum(f.px_or_strict_js_ots_unfiltered)), (sum(f.px_ots)), (sum(f.pxbe_any_ots)), (sum(f.pxbe_l)), (sum(f.pxbe_lax_ots)), (sum(f.pxbe_ms_lax_in_view_sum)), (sum(f.pxbe_ms_px_in_view_sum)), (sum(f.pxbe_px_ots)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_perc ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_time ELSE '0'::bigint END)), (sum(f.s1)), (sum(f.session_hijacked_imps)), (sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.session_hijacked_imps ELSE '0'::bigint END)), (sum(f.lax_ots)), (sum(f.gen6)), (sum(f.susp_ad_invisible)), (sum(f.susp_ad_onebyone)), (sum(f.susp_ad_stuffed)), (sum(f.susp_bad_domain)), (sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.susp_bad_domain ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_bot ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_browser ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_data_center ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.susp_l END)), (sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.susp_bot_dentsu_display_ots ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_geo ELSE '0'::bigint END)), (sum(f.susp_bot_inview_measurable)), (sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable ELSE '0'::bigint END)), (sum(f.susp_bot_inview_measurable_gm)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.l END)), (sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN (COALESCE(f.loads_unfiltered, '0'::bigint) - COALESCE(f.l, '0'::bigint)) ELSE f.susp_bot END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_proxy ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_spider ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_susp_browser ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END)), (sum(f.susp_bot_viewable_gmp)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gmp ELSE '0'::bigint END)), (sum(f.susp_hidden_ad)), (sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.susp_hidden_ad ELSE '0'::bigint END)), (sum(f.susp_inapp_sivt)), (sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.susp_incentivized_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_late_night ELSE '0'::bigint END)), (sum(f.susp_ms_abf)), (sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.susp_ms_abf ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_old_browser ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_top_hour ELSE '0'::bigint END)), (sum(f.t1)), (sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.throttling_imps ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2013-02-04'::date) THEN f.gen7 ELSE f.msreactionsum END)), (sum(f.total_fully_on_screen_time)), (sum(f.total_on_screen_time)), (sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END)), (sum(CASE WHEN (t.date >= '2016-08-24'::date) THEN COALESCE(f.l_birds_eye, '0'::bigint) WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2016-08-24'::date)) THEN COALESCE(f.l_somehow_measurable, '0'::bigint) ELSE '0'::bigint END))
  • Inner Unique: true
  • Hash Cond: (f.level3 = client_creative_properties.level3)
  • Buffers: shared hit=17688
4. 1,416.950 30,209.929 ↑ 29.7 3,369 1

Finalize GroupAggregate (cost=464,611.09..32,320,134.92 rows=100,000 width=8,954) (actual time=28,349.799..30,209.929 rows=3,369 loops=1)

  • Output: sum(f.active_meas), sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time_impression_count ELSE '0'::bigint END), sum(f.active_viewable), sum(f.ad_not_found_timeout), sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_hidden ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_onebyone ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stacked ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stuffed ELSE '0'::bigint END), sum(f.adtagsfound), sum(f.btf_absolute_l), sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_l ELSE '0'::bigint END), sum(f.btf_absolute_ots), sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_ots ELSE '0'::bigint END), sum(f.c1), sum(f.c1_git), sum(f.c1_unfiltered), sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_inview ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.dentsu_display_ots ELSE '0'::bigint END), sum(f.exceptions), sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_imps ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_time ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.full_vis_2_sec_continuous_inview ELSE '0'::bigint END), sum(f.gen4), NULL::numeric, sum(f.groupm_display_imps), sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.groupm_display_imps ELSE '0'::bigint END), sum(f.gv_adult), sum(f.gv_arms), sum(f.gv_categorized), sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_categorized ELSE '0'::bigint END), sum(f.gv_crime), sum(f.gv_death_injury), sum(f.gv_download), sum(f.gv_drugs), sum(f.gv_hatespeech), sum(f.gv_military), sum(f.gv_obscenity), sum(f.gv_safe), sum(f.gv_terrorism), sum(f.gv_tobacco), sum(f.gv_unsafe), sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_unsafe ELSE (COALESCE(f.gv_categorized, '0'::bigint) - COALESCE(f.gv_safe, '0'::bigint)) END), sum(f.h1), sum(f.had_any_strict_view_time), sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.had_any_strict_view_time ELSE '0'::bigint END), sum(CASE WHEN (t.date < '2015-02-26'::date) THEN (CASE WHEN (t.date >= '2015-01-10'::date) THEN LEAST((COALESCE(f.px_or_strict_js_ots, '0'::bigint) - COALESCE(f.susp_bot_viewable, '0'::bigint)), (COALESCE(f.susp_l, '0'::bigint) - COALESCE(f.susp_bot, '0'::bigint))) ELSE '0'::bigint END)::double precision ELSE floor(((COALESCE(f.px_or_strict_js_ots, '0'::bigint))::double precision - ((COALESCE(f.susp_bot_viewable, '0'::bigint))::double precision * CASE WHEN (COALESCE(f.susp_l_inview_measurable, '0'::bigint) = 0) THEN '1'::double precision ELSE ((COALESCE(f.l_somehow_measurable, '0'::bigint) / COALESCE(f.susp_l_inview_measurable, '0'::bigint)))::double precision END))) END), sum(f.ia_loaded), sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_loaded ELSE '0'::bigint END), sum(f.ia_measurable), sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_measurable ELSE '0'::bigint END), sum(f.impressions), sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.in_vp ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.in_vp ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp_meas ELSE '0'::bigint END), sum(f.ir4interactions), sum((COALESCE(f.l, '0'::bigint) - COALESCE(f.l_mobile, '0'::bigint))), sum(f.msir4sum), sum(f.iva), sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.iva ELSE '0'::bigint END), sum(f.ivb), sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivb ELSE '0'::bigint END), sum(f.ivc), sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivc ELSE '0'::bigint END), sum(f.ivd), sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivd ELSE '0'::bigint END), sum(f.ive), sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ive ELSE '0'::bigint END), sum(f.l), sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-02-20'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-05-13'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l ELSE '0'::bigint END), sum(f.l_above_fold), sum(CASE WHEN (t.date > '2012-11-19'::date) THEN f.l_somehow_measurable ELSE f.l_birds_eye END), sum(CASE WHEN (t.date >= '2014-03-18'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(f.l_birds_eye), sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_birds_eye ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_measurable, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END), sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-09-01'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2018-04-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-11-18'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), NULL::numeric, sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END), sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots_1_sec, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END), sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_ots ELSE '0'::bigint END), sum(f.l_groupm_payable_imp), sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_groupm_payable_imp ELSE '0'::bigint END), sum(f.l_mobile), sum(f.l_mobile_not_iframe), sum(f.l_not_iframe), sum(f.l_not_iframe_git), sum(f.l_not_iframe_unfiltered), sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.l ELSE '0'::bigint END), sum(f.l_px), sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.l ELSE '0'::bigint END), sum(f.l_somehow_measurable), sum(CASE WHEN (t.date <= '2013-12-13'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2013-12-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-07-29'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-07-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(f.l_somehow_measurable_git), sum(CASE WHEN (t.date >= '2012-12-19'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(f.l_somehow_measurable_unfiltered), sum(f.l_time), sum(CASE WHEN (t.date >= '2012-03-21'::date) THEN f.l ELSE '0'::bigint END), t.level0top, f.level1, f.level2, f.level3, f.level4, sum(f.loads_git), sum(CASE WHEN (t.date >= '2018-02-21'::date) THEN f.l ELSE '0'::bigint END), sum(f.loads_unfiltered), sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), sum(f.mm_history), sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_history ELSE '0'::bigint END), sum(f.mm_no_referrer), sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_no_referrer ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.moat_sdk_measurable_imps ELSE '0'::bigint END), sum(f.ms_lax_dwell_sum), sum(f.ms_px_or_lax_js_in_viewsum), sum(f.ms_px_or_strict_js_in_viewsum), sum(f.msdwellsum), sum(f.ms_px_or_strict_js_in_viewsum), sum(f.msreactionsum), sum(f.mstoscrollcount), sum(f.mstoscrollsum), sum(f.mstoviewsum), sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_available_imps ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_measurable_imps ELSE '0'::bigint END), sum(f.on_screen_1_continuous_second_imps), sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.opacity_ever_non_zero ELSE '0'::bigint END), sum(f.ots), sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.ots ELSE '0'::bigint END), sum(f.px_or_strict_js_ots), sum(f.px_or_strict_js_ots), sum(f.page_ever_focused), sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.page_ever_focused ELSE '0'::bigint END), sum(f.passthrough_imps), sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.passthrough_imps ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.pixels_received ELSE '0'::bigint END), sum(f.px_or_lax_js_ots), sum(f.px_or_strict_js_ots), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), sum(f.px_or_strict_js_ots_git), sum(f.px_or_strict_js_ots_unfiltered), sum(f.px_ots), sum(f.pxbe_any_ots), sum(f.pxbe_l), sum(f.pxbe_lax_ots), sum(f.pxbe_ms_lax_in_view_sum), sum(f.pxbe_ms_px_in_view_sum), sum(f.pxbe_px_ots), sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_perc ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_time ELSE '0'::bigint END), sum(f.s1), sum(f.session_hijacked_imps), sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.session_hijacked_imps ELSE '0'::bigint END), (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), sum(f.lax_ots), sum(f.gen6), sum(f.susp_ad_invisible), sum(f.susp_ad_onebyone), sum(f.susp_ad_stuffed), sum(f.susp_bad_domain), sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.susp_bad_domain ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_bot ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_browser ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_data_center ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.susp_l END), sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.susp_bot_dentsu_display_ots ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_geo ELSE '0'::bigint END), sum(f.susp_bot_inview_measurable), sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable ELSE '0'::bigint END), sum(f.susp_bot_inview_measurable_gm), sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.l END), sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN (COALESCE(f.loads_unfiltered, '0'::bigint) - COALESCE(f.l, '0'::bigint)) ELSE f.susp_bot END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_proxy ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_spider ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_susp_browser ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END), sum(f.susp_bot_viewable_gmp), sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gmp ELSE '0'::bigint END), sum(f.susp_hidden_ad), sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.susp_hidden_ad ELSE '0'::bigint END), sum(f.susp_inapp_sivt), sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.susp_incentivized_imps ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_l ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_l ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_late_night ELSE '0'::bigint END), sum(f.susp_ms_abf), sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.susp_ms_abf ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_old_browser ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_top_hour ELSE '0'::bigint END), sum(f.t1), sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.throttling_imps ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2013-02-04'::date) THEN f.gen7 ELSE f.msreactionsum END), sum(f.total_fully_on_screen_time), sum(f.total_on_screen_time), sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END), sum(CASE WHEN (t.date >= '2016-08-24'::date) THEN COALESCE(f.l_birds_eye, '0'::bigint) WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2016-08-24'::date)) THEN COALESCE(f.l_somehow_measurable, '0'::bigint) ELSE '0'::bigint END)
  • Group Key: f.level1, f.level2, f.level3, f.level4, t.level0top, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text))
  • Buffers: shared hit=17057
5. 0.000 28,792.979 ↑ 51.3 17,543 1

Gather Merge (cost=464,611.09..6,139,134.92 rows=900,000 width=8,698) (actual time=28,349.361..28,792.979 rows=17,543 loops=1)

  • Output: t.level0top, f.level1, f.level2, f.level3, f.level4, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), (PARTIAL sum(f.active_meas)), (PARTIAL sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time_impression_count ELSE '0'::bigint END)), (PARTIAL sum(f.active_viewable)), (PARTIAL sum(f.ad_not_found_timeout)), (PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_hidden ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_onebyone ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stacked ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stuffed ELSE '0'::bigint END)), (PARTIAL sum(f.adtagsfound)), (PARTIAL sum(f.btf_absolute_l)), (PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_l ELSE '0'::bigint END)), (PARTIAL sum(f.btf_absolute_ots)), (PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_ots ELSE '0'::bigint END)), (PARTIAL sum(f.c1)), (PARTIAL sum(f.c1_git)), (PARTIAL sum(f.c1_unfiltered)), (PARTIAL sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_inview ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.dentsu_display_ots ELSE '0'::bigint END)), (PARTIAL sum(f.exceptions)), (PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_imps ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_time ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.full_vis_2_sec_continuous_inview ELSE '0'::bigint END)), (PARTIAL sum(f.gen4)), (PARTIAL sum(f.groupm_display_imps)), (PARTIAL sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.groupm_display_imps ELSE '0'::bigint END)), (PARTIAL sum(f.gv_adult)), (PARTIAL sum(f.gv_arms)), (PARTIAL sum(f.gv_categorized)), (PARTIAL sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_categorized ELSE '0'::bigint END)), (PARTIAL sum(f.gv_crime)), (PARTIAL sum(f.gv_death_injury)), (PARTIAL sum(f.gv_download)), (PARTIAL sum(f.gv_drugs)), (PARTIAL sum(f.gv_hatespeech)), (PARTIAL sum(f.gv_military)), (PARTIAL sum(f.gv_obscenity)), (PARTIAL sum(f.gv_safe)), (PARTIAL sum(f.gv_terrorism)), (PARTIAL sum(f.gv_tobacco)), (PARTIAL sum(f.gv_unsafe)), (PARTIAL sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_unsafe ELSE (COALESCE(f.gv_categorized, '0'::bigint) - COALESCE(f.gv_safe, '0'::bigint)) END)), (PARTIAL sum(f.h1)), (PARTIAL sum(f.had_any_strict_view_time)), (PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.had_any_strict_view_time ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date < '2015-02-26'::date) THEN (CASE WHEN (t.date >= '2015-01-10'::date) THEN LEAST((COALESCE(f.px_or_strict_js_ots, '0'::bigint) - COALESCE(f.susp_bot_viewable, '0'::bigint)), (COALESCE(f.susp_l, '0'::bigint) - COALESCE(f.susp_bot, '0'::bigint))) ELSE '0'::bigint END)::double precision ELSE floor(((COALESCE(f.px_or_strict_js_ots, '0'::bigint))::double precision - ((COALESCE(f.susp_bot_viewable, '0'::bigint))::double precision * CASE WHEN (COALESCE(f.susp_l_inview_measurable, '0'::bigint) = 0) THEN '1'::double precision ELSE ((COALESCE(f.l_somehow_measurable, '0'::bigint) / COALESCE(f.susp_l_inview_measurable, '0'::bigint)))::double precision END))) END)), (PARTIAL sum(f.ia_loaded)), (PARTIAL sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_loaded ELSE '0'::bigint END)), (PARTIAL sum(f.ia_measurable)), (PARTIAL sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_measurable ELSE '0'::bigint END)), (PARTIAL sum(f.impressions)), (PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.in_vp ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.in_vp ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp_meas ELSE '0'::bigint END)), (PARTIAL sum(f.ir4interactions)), (PARTIAL sum((COALESCE(f.l, '0'::bigint) - COALESCE(f.l_mobile, '0'::bigint)))), (PARTIAL sum(f.msir4sum)), (PARTIAL sum(f.iva)), (PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.iva ELSE '0'::bigint END)), (PARTIAL sum(f.ivb)), (PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivb ELSE '0'::bigint END)), (PARTIAL sum(f.ivc)), (PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivc ELSE '0'::bigint END)), (PARTIAL sum(f.ivd)), (PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivd ELSE '0'::bigint END)), (PARTIAL sum(f.ive)), (PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ive ELSE '0'::bigint END)), (PARTIAL sum(f.l)), (PARTIAL sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-02-20'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-05-13'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(f.l_above_fold)), (PARTIAL sum(CASE WHEN (t.date > '2012-11-19'::date) THEN f.l_somehow_measurable ELSE f.l_birds_eye END)), (PARTIAL sum(CASE WHEN (t.date >= '2014-03-18'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(f.l_birds_eye)), (PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_birds_eye ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_measurable, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-09-01'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2018-04-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-11-18'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END)), (PARTIAL sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots_1_sec, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_ots ELSE '0'::bigint END)), (PARTIAL sum(f.l_groupm_payable_imp)), (PARTIAL sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_groupm_payable_imp ELSE '0'::bigint END)), (PARTIAL sum(f.l_mobile)), (PARTIAL sum(f.l_mobile_not_iframe)), (PARTIAL sum(f.l_not_iframe)), (PARTIAL sum(f.l_not_iframe_git)), (PARTIAL sum(f.l_not_iframe_unfiltered)), (PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(f.l_px)), (PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(f.l_somehow_measurable)), (PARTIAL sum(CASE WHEN (t.date <= '2013-12-13'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2013-12-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-07-29'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-07-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(f.l_somehow_measurable_git)), (PARTIAL sum(CASE WHEN (t.date >= '2012-12-19'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(f.l_somehow_measurable_unfiltered)), (PARTIAL sum(f.l_time)), (PARTIAL sum(CASE WHEN (t.date >= '2012-03-21'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(f.loads_git)), (PARTIAL sum(CASE WHEN (t.date >= '2018-02-21'::date) THEN f.l ELSE '0'::bigint END)), (PARTIAL sum(f.loads_unfiltered)), (PARTIAL sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.loads_unfiltered ELSE '0'::bigint END)), (PARTIAL sum(f.mm_history)), (PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_history ELSE '0'::bigint END)), (PARTIAL sum(f.mm_no_referrer)), (PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_no_referrer ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.moat_sdk_measurable_imps ELSE '0'::bigint END)), (PARTIAL sum(f.ms_lax_dwell_sum)), (PARTIAL sum(f.ms_px_or_lax_js_in_viewsum)), (PARTIAL sum(f.ms_px_or_strict_js_in_viewsum)), (PARTIAL sum(f.msdwellsum)), (PARTIAL sum(f.msreactionsum)), (PARTIAL sum(f.mstoscrollcount)), (PARTIAL sum(f.mstoscrollsum)), (PARTIAL sum(f.mstoviewsum)), (PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_available_imps ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_measurable_imps ELSE '0'::bigint END)), (PARTIAL sum(f.on_screen_1_continuous_second_imps)), (PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.opacity_ever_non_zero ELSE '0'::bigint END)), (PARTIAL sum(f.ots)), (PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.ots ELSE '0'::bigint END)), (PARTIAL sum(f.px_or_strict_js_ots)), (PARTIAL sum(f.page_ever_focused)), (PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.page_ever_focused ELSE '0'::bigint END)), (PARTIAL sum(f.passthrough_imps)), (PARTIAL sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.passthrough_imps ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.pixels_received ELSE '0'::bigint END)), (PARTIAL sum(f.px_or_lax_js_ots)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END)), (PARTIAL sum(f.px_or_strict_js_ots_git)), (PARTIAL sum(f.px_or_strict_js_ots_unfiltered)), (PARTIAL sum(f.px_ots)), (PARTIAL sum(f.pxbe_any_ots)), (PARTIAL sum(f.pxbe_l)), (PARTIAL sum(f.pxbe_lax_ots)), (PARTIAL sum(f.pxbe_ms_lax_in_view_sum)), (PARTIAL sum(f.pxbe_ms_px_in_view_sum)), (PARTIAL sum(f.pxbe_px_ots)), (PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_perc ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_time ELSE '0'::bigint END)), (PARTIAL sum(f.s1)), (PARTIAL sum(f.session_hijacked_imps)), (PARTIAL sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.session_hijacked_imps ELSE '0'::bigint END)), (PARTIAL sum(f.lax_ots)), (PARTIAL sum(f.gen6)), (PARTIAL sum(f.susp_ad_invisible)), (PARTIAL sum(f.susp_ad_onebyone)), (PARTIAL sum(f.susp_ad_stuffed)), (PARTIAL sum(f.susp_bad_domain)), (PARTIAL sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.susp_bad_domain ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_bot ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_browser ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_data_center ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.susp_l END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.susp_bot_dentsu_display_ots ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_geo ELSE '0'::bigint END)), (PARTIAL sum(f.susp_bot_inview_measurable)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable ELSE '0'::bigint END)), (PARTIAL sum(f.susp_bot_inview_measurable_gm)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.l END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN (COALESCE(f.loads_unfiltered, '0'::bigint) - COALESCE(f.l, '0'::bigint)) ELSE f.susp_bot END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_proxy ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_spider ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_susp_browser ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END)), (PARTIAL sum(f.susp_bot_viewable_gmp)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gmp ELSE '0'::bigint END)), (PARTIAL sum(f.susp_hidden_ad)), (PARTIAL sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.susp_hidden_ad ELSE '0'::bigint END)), (PARTIAL sum(f.susp_inapp_sivt)), (PARTIAL sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.susp_incentivized_imps ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_late_night ELSE '0'::bigint END)), (PARTIAL sum(f.susp_ms_abf)), (PARTIAL sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.susp_ms_abf ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_old_browser ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_top_hour ELSE '0'::bigint END)), (PARTIAL sum(f.t1)), (PARTIAL sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.throttling_imps ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2013-02-04'::date) THEN f.gen7 ELSE f.msreactionsum END)), (PARTIAL sum(f.total_fully_on_screen_time)), (PARTIAL sum(f.total_on_screen_time)), (PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END)), (PARTIAL sum(CASE WHEN (t.date >= '2016-08-24'::date) THEN COALESCE(f.l_birds_eye, '0'::bigint) WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2016-08-24'::date)) THEN COALESCE(f.l_somehow_measurable, '0'::bigint) ELSE '0'::bigint END))
  • Workers Planned: 9
  • Workers Launched: 9
  • Buffers: shared hit=188604
6. 2,833.910 268,135.630 ↑ 57.0 1,754 10

Partial GroupAggregate (cost=464,607.76..5,795,063.56 rows=100,000 width=8,698) (actual time=26,530.147..26,813.563 rows=1,754 loops=10)

  • Output: t.level0top, f.level1, f.level2, f.level3, f.level4, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), PARTIAL sum(f.active_meas), PARTIAL sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time_impression_count ELSE '0'::bigint END), PARTIAL sum(f.active_viewable), PARTIAL sum(f.ad_not_found_timeout), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_hidden ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_onebyone ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stacked ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stuffed ELSE '0'::bigint END), PARTIAL sum(f.adtagsfound), PARTIAL sum(f.btf_absolute_l), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_l ELSE '0'::bigint END), PARTIAL sum(f.btf_absolute_ots), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_ots ELSE '0'::bigint END), PARTIAL sum(f.c1), PARTIAL sum(f.c1_git), PARTIAL sum(f.c1_unfiltered), PARTIAL sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_inview ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.dentsu_display_ots ELSE '0'::bigint END), PARTIAL sum(f.exceptions), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_time ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.full_vis_2_sec_continuous_inview ELSE '0'::bigint END), PARTIAL sum(f.gen4), PARTIAL sum(f.groupm_display_imps), PARTIAL sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.groupm_display_imps ELSE '0'::bigint END), PARTIAL sum(f.gv_adult), PARTIAL sum(f.gv_arms), PARTIAL sum(f.gv_categorized), PARTIAL sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_categorized ELSE '0'::bigint END), PARTIAL sum(f.gv_crime), PARTIAL sum(f.gv_death_injury), PARTIAL sum(f.gv_download), PARTIAL sum(f.gv_drugs), PARTIAL sum(f.gv_hatespeech), PARTIAL sum(f.gv_military), PARTIAL sum(f.gv_obscenity), PARTIAL sum(f.gv_safe), PARTIAL sum(f.gv_terrorism), PARTIAL sum(f.gv_tobacco), PARTIAL sum(f.gv_unsafe), PARTIAL sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_unsafe ELSE (COALESCE(f.gv_categorized, '0'::bigint) - COALESCE(f.gv_safe, '0'::bigint)) END), PARTIAL sum(f.h1), PARTIAL sum(f.had_any_strict_view_time), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.had_any_strict_view_time ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date < '2015-02-26'::date) THEN (CASE WHEN (t.date >= '2015-01-10'::date) THEN LEAST((COALESCE(f.px_or_strict_js_ots, '0'::bigint) - COALESCE(f.susp_bot_viewable, '0'::bigint)), (COALESCE(f.susp_l, '0'::bigint) - COALESCE(f.susp_bot, '0'::bigint))) ELSE '0'::bigint END)::double precision ELSE floor(((COALESCE(f.px_or_strict_js_ots, '0'::bigint))::double precision - ((COALESCE(f.susp_bot_viewable, '0'::bigint))::double precision * CASE WHEN (COALESCE(f.susp_l_inview_measurable, '0'::bigint) = 0) THEN '1'::double precision ELSE ((COALESCE(f.l_somehow_measurable, '0'::bigint) / COALESCE(f.susp_l_inview_measurable, '0'::bigint)))::double precision END))) END), PARTIAL sum(f.ia_loaded), PARTIAL sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_loaded ELSE '0'::bigint END), PARTIAL sum(f.ia_measurable), PARTIAL sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_measurable ELSE '0'::bigint END), PARTIAL sum(f.impressions), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.in_vp ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.in_vp ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp_meas ELSE '0'::bigint END), PARTIAL sum(f.ir4interactions), PARTIAL sum((COALESCE(f.l, '0'::bigint) - COALESCE(f.l_mobile, '0'::bigint))), PARTIAL sum(f.msir4sum), PARTIAL sum(f.iva), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.iva ELSE '0'::bigint END), PARTIAL sum(f.ivb), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivb ELSE '0'::bigint END), PARTIAL sum(f.ivc), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivc ELSE '0'::bigint END), PARTIAL sum(f.ivd), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivd ELSE '0'::bigint END), PARTIAL sum(f.ive), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ive ELSE '0'::bigint END), PARTIAL sum(f.l), PARTIAL sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-20'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-05-13'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.l_above_fold), PARTIAL sum(CASE WHEN (t.date > '2012-11-19'::date) THEN f.l_somehow_measurable ELSE f.l_birds_eye END), PARTIAL sum(CASE WHEN (t.date >= '2014-03-18'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(f.l_birds_eye), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_birds_eye ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_measurable, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END), PARTIAL sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-01'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-04-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-11-18'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END), PARTIAL sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots_1_sec, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_ots ELSE '0'::bigint END), PARTIAL sum(f.l_groupm_payable_imp), PARTIAL sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_groupm_payable_imp ELSE '0'::bigint END), PARTIAL sum(f.l_mobile), PARTIAL sum(f.l_mobile_not_iframe), PARTIAL sum(f.l_not_iframe), PARTIAL sum(f.l_not_iframe_git), PARTIAL sum(f.l_not_iframe_unfiltered), PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.l_px), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.l_somehow_measurable), PARTIAL sum(CASE WHEN (t.date <= '2013-12-13'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2013-12-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-07-29'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-07-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(f.l_somehow_measurable_git), PARTIAL sum(CASE WHEN (t.date >= '2012-12-19'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(f.l_somehow_measurable_unfiltered), PARTIAL sum(f.l_time), PARTIAL sum(CASE WHEN (t.date >= '2012-03-21'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.loads_git), PARTIAL sum(CASE WHEN (t.date >= '2018-02-21'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.loads_unfiltered), PARTIAL sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), PARTIAL sum(f.mm_history), PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_history ELSE '0'::bigint END), PARTIAL sum(f.mm_no_referrer), PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_no_referrer ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.moat_sdk_measurable_imps ELSE '0'::bigint END), PARTIAL sum(f.ms_lax_dwell_sum), PARTIAL sum(f.ms_px_or_lax_js_in_viewsum), PARTIAL sum(f.ms_px_or_strict_js_in_viewsum), PARTIAL sum(f.msdwellsum), PARTIAL sum(f.msreactionsum), PARTIAL sum(f.mstoscrollcount), PARTIAL sum(f.mstoscrollsum), PARTIAL sum(f.mstoviewsum), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_available_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_measurable_imps ELSE '0'::bigint END), PARTIAL sum(f.on_screen_1_continuous_second_imps), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.opacity_ever_non_zero ELSE '0'::bigint END), PARTIAL sum(f.ots), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.ots ELSE '0'::bigint END), PARTIAL sum(f.px_or_strict_js_ots), PARTIAL sum(f.page_ever_focused), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.page_ever_focused ELSE '0'::bigint END), PARTIAL sum(f.passthrough_imps), PARTIAL sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.passthrough_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.pixels_received ELSE '0'::bigint END), PARTIAL sum(f.px_or_lax_js_ots), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), PARTIAL sum(f.px_or_strict_js_ots_git), PARTIAL sum(f.px_or_strict_js_ots_unfiltered), PARTIAL sum(f.px_ots), PARTIAL sum(f.pxbe_any_ots), PARTIAL sum(f.pxbe_l), PARTIAL sum(f.pxbe_lax_ots), PARTIAL sum(f.pxbe_ms_lax_in_view_sum), PARTIAL sum(f.pxbe_ms_px_in_view_sum), PARTIAL sum(f.pxbe_px_ots), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_perc ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_time ELSE '0'::bigint END), PARTIAL sum(f.s1), PARTIAL sum(f.session_hijacked_imps), PARTIAL sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.session_hijacked_imps ELSE '0'::bigint END), PARTIAL sum(f.lax_ots), PARTIAL sum(f.gen6), PARTIAL sum(f.susp_ad_invisible), PARTIAL sum(f.susp_ad_onebyone), PARTIAL sum(f.susp_ad_stuffed), PARTIAL sum(f.susp_bad_domain), PARTIAL sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.susp_bad_domain ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_bot ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_browser ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_data_center ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.susp_l END), PARTIAL sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.susp_bot_dentsu_display_ots ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_geo ELSE '0'::bigint END), PARTIAL sum(f.susp_bot_inview_measurable), PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable ELSE '0'::bigint END), PARTIAL sum(f.susp_bot_inview_measurable_gm), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.l END), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN (COALESCE(f.loads_unfiltered, '0'::bigint) - COALESCE(f.l, '0'::bigint)) ELSE f.susp_bot END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_proxy ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_spider ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_susp_browser ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END), PARTIAL sum(f.susp_bot_viewable_gmp), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gmp ELSE '0'::bigint END), PARTIAL sum(f.susp_hidden_ad), PARTIAL sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.susp_hidden_ad ELSE '0'::bigint END), PARTIAL sum(f.susp_inapp_sivt), PARTIAL sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.susp_incentivized_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_late_night ELSE '0'::bigint END), PARTIAL sum(f.susp_ms_abf), PARTIAL sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.susp_ms_abf ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_old_browser ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_top_hour ELSE '0'::bigint END), PARTIAL sum(f.t1), PARTIAL sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.throttling_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2013-02-04'::date) THEN f.gen7 ELSE f.msreactionsum END), PARTIAL sum(f.total_fully_on_screen_time), PARTIAL sum(f.total_on_screen_time), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-08-24'::date) THEN COALESCE(f.l_birds_eye, '0'::bigint) WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2016-08-24'::date)) THEN COALESCE(f.l_somehow_measurable, '0'::bigint) ELSE '0'::bigint END)
  • Group Key: f.level1, f.level2, f.level3, f.level4, t.level0top, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text))
  • Buffers: shared hit=188604
  • Worker 0: actual time=26922.200..27101.505 rows=1045 loops=1
  • Buffers: shared hit=13466
  • Worker 1: actual time=24744.430..25083.082 rows=2143 loops=1
  • Buffers: shared hit=11945
  • Worker 2: actual time=27629.986..27820.740 rows=1254 loops=1
  • Buffers: shared hit=12108
  • Worker 3: actual time=28307.585..28675.877 rows=2187 loops=1
  • Buffers: shared hit=13408
  • Worker 4: actual time=27774.393..27945.587 rows=1106 loops=1
  • Buffers: shared hit=25735
  • Worker 5: actual time=25517.431..25850.015 rows=2148 loops=1
  • Buffers: shared hit=18918
  • Worker 6: actual time=24675.891..24855.984 rows=814 loops=1
  • Buffers: shared hit=32621
  • Worker 7: actual time=26472.035..26856.311 rows=2422 loops=1
  • Buffers: shared hit=25707
  • Worker 8: actual time=25565.647..25922.869 rows=2082 loops=1
  • Buffers: shared hit=17639
7. 254.560 265,301.720 ↑ 57.9 2,686 10

Sort (cost=464,607.76..472,385.56 rows=155,556 width=1,302) (actual time=26,528.791..26,530.172 rows=2,686 loops=10)

  • Output: t.level0top, f.level1, f.level2, f.level3, f.level4, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), f.active_meas, t.date, f.active_time, f.active_time_impression_count, f.active_viewable, f.ad_not_found_timeout, f.ad_not_hidden, f.ad_not_onebyone, f.ad_not_stacked, f.ad_not_stuffed, f.adtagsfound, f.btf_absolute_l, f.btf_absolute_ots, f.c1, f.c1_git, f.c1_unfiltered, f.custom_inview, f.custom_measurable, f.dentsu_display_ots, f.exceptions, f.fifty_pct_onscreen_imps, f.fifty_pct_onscreen_time, f.full_vis_2_sec_continuous_inview, f.gen4, f.groupm_display_imps, f.gv_adult, f.gv_arms, f.gv_categorized, f.gv_crime, f.gv_death_injury, f.gv_download, f.gv_drugs, f.gv_hatespeech, f.gv_military, f.gv_obscenity, f.gv_safe, f.gv_terrorism, f.gv_tobacco, f.gv_unsafe, f.h1, f.had_any_strict_view_time, f.px_or_strict_js_ots, f.susp_bot_viewable, f.susp_l, f.susp_bot, f.susp_l_inview_measurable, f.l_somehow_measurable, f.ia_loaded, f.ia_measurable, f.impressions, f.in_vp, f.in_vp_meas, f.ir4interactions, f.l, f.l_mobile, f.msir4sum, f.iva, f.ivb, f.ivc, f.ivd, f.ive, f.l_above_fold, f.l_birds_eye, f.l_full_visibility_measurable, f.l_full_visibility_ots, f.l_full_visibility_ots_1_sec, f.l_groupm_payable_imp, f.l_mobile_not_iframe, f.l_not_iframe, f.l_not_iframe_git, f.l_not_iframe_unfiltered, f.l_px, f.l_somehow_measurable_git, f.l_somehow_measurable_unfiltered, f.l_time, f.loads_git, f.loads_unfiltered, f.mm_history, f.mm_no_referrer, f.moat_sdk_measurable_imps, f.ms_lax_dwell_sum, f.ms_px_or_lax_js_in_viewsum, f.ms_px_or_strict_js_in_viewsum, f.msdwellsum, f.msreactionsum, f.mstoscrollcount, f.mstoscrollsum, f.mstoviewsum, f.page_ever_focused, f.ots, f.om_sdk_available_imps, f.om_sdk_measurable_imps, f.on_screen_1_continuous_second_imps, f.opacity_ever_non_zero, f.passthrough_imps, f.pixels_received, f.px_or_lax_js_ots, f.px_or_strict_js_ots_git, f.px_or_strict_js_ots_unfiltered, f.px_ots, f.pxbe_any_ots, f.pxbe_l, f.pxbe_lax_ots, f.pxbe_ms_lax_in_view_sum, f.pxbe_ms_px_in_view_sum, f.pxbe_px_ots, f.real_estate_measurable, f.real_estate_perc, f.real_estate_time, f.s1, f.session_hijacked_imps, f.lax_ots, f.gen6, f.susp_ad_invisible, f.susp_ad_onebyone, f.susp_ad_stuffed, f.susp_bad_domain, f.susp_bot_browser, f.susp_bot_data_center, f.susp_bot_dentsu_display_ots, f.susp_bot_geo, f.susp_bot_inview_measurable, f.susp_bot_inview_measurable_gm, f.susp_bot_proxy, f.susp_bot_spider, f.susp_bot_susp_browser, f.susp_bot_viewable_gm, f.susp_bot_viewable_gmp, f.susp_hidden_ad, f.susp_inapp_sivt, f.susp_incentivized_imps, f.susp_l_inview_measurable_gm, f.susp_late_night, f.susp_ms_abf, f.susp_old_browser, f.susp_top_hour, f.t1, f.throttling_imps, f.gen7, f.total_fully_on_screen_time, f.total_on_screen_time
  • Sort Key: f.level1 COLLATE "C", f.level2 COLLATE "C", f.level3 COLLATE "C", f.level4 COLLATE "C", (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)) COLLATE "C
  • Sort Method: quicksort Memory: 3287kB
  • Buffers: shared hit=188604
  • Worker 0: actual time=26920.274..26921.275 rows=1687 loops=1
  • Buffers: shared hit=13466
  • Worker 1: actual time=24743.859..24745.385 rows=2989 loops=1
  • Buffers: shared hit=11945
  • Worker 2: actual time=27629.419..27630.437 rows=2009 loops=1
  • Buffers: shared hit=12108
  • Worker 3: actual time=28305.809..28307.577 rows=3397 loops=1
  • Buffers: shared hit=13408
  • Worker 4: actual time=27772.671..27773.515 rows=1770 loops=1
  • Buffers: shared hit=25735
  • Worker 5: actual time=25516.858..25518.156 rows=2430 loops=1
  • Buffers: shared hit=18918
  • Worker 6: actual time=24675.325..24676.002 rows=1324 loops=1
  • Buffers: shared hit=32621
  • Worker 7: actual time=26470.053..26472.079 rows=4055 loops=1
  • Buffers: shared hit=25707
  • Worker 8: actual time=25563.653..25565.454 rows=3337 loops=1
  • Buffers: shared hit=17639
8. 83.922 265,047.160 ↑ 57.9 2,686 10

Nested Loop (cost=5,000.15..145,883.17 rows=155,556 width=1,302) (actual time=198.768..26,504.716 rows=2,686 loops=10)

  • Output: t.level0top, f.level1, f.level2, f.level3, f.level4, replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text), f.active_meas, t.date, f.active_time, f.active_time_impression_count, f.active_viewable, f.ad_not_found_timeout, f.ad_not_hidden, f.ad_not_onebyone, f.ad_not_stacked, f.ad_not_stuffed, f.adtagsfound, f.btf_absolute_l, f.btf_absolute_ots, f.c1, f.c1_git, f.c1_unfiltered, f.custom_inview, f.custom_measurable, f.dentsu_display_ots, f.exceptions, f.fifty_pct_onscreen_imps, f.fifty_pct_onscreen_time, f.full_vis_2_sec_continuous_inview, f.gen4, f.groupm_display_imps, f.gv_adult, f.gv_arms, f.gv_categorized, f.gv_crime, f.gv_death_injury, f.gv_download, f.gv_drugs, f.gv_hatespeech, f.gv_military, f.gv_obscenity, f.gv_safe, f.gv_terrorism, f.gv_tobacco, f.gv_unsafe, f.h1, f.had_any_strict_view_time, f.px_or_strict_js_ots, f.susp_bot_viewable, f.susp_l, f.susp_bot, f.susp_l_inview_measurable, f.l_somehow_measurable, f.ia_loaded, f.ia_measurable, f.impressions, f.in_vp, f.in_vp_meas, f.ir4interactions, f.l, f.l_mobile, f.msir4sum, f.iva, f.ivb, f.ivc, f.ivd, f.ive, f.l_above_fold, f.l_birds_eye, f.l_full_visibility_measurable, f.l_full_visibility_ots, f.l_full_visibility_ots_1_sec, f.l_groupm_payable_imp, f.l_mobile_not_iframe, f.l_not_iframe, f.l_not_iframe_git, f.l_not_iframe_unfiltered, f.l_px, f.l_somehow_measurable_git, f.l_somehow_measurable_unfiltered, f.l_time, f.loads_git, f.loads_unfiltered, f.mm_history, f.mm_no_referrer, f.moat_sdk_measurable_imps, f.ms_lax_dwell_sum, f.ms_px_or_lax_js_in_viewsum, f.ms_px_or_strict_js_in_viewsum, f.msdwellsum, f.msreactionsum, f.mstoscrollcount, f.mstoscrollsum, f.mstoviewsum, f.page_ever_focused, f.ots, f.om_sdk_available_imps, f.om_sdk_measurable_imps, f.on_screen_1_continuous_second_imps, f.opacity_ever_non_zero, f.passthrough_imps, f.pixels_received, f.px_or_lax_js_ots, f.px_or_strict_js_ots_git, f.px_or_strict_js_ots_unfiltered, f.px_ots, f.pxbe_any_ots, f.pxbe_l, f.pxbe_lax_ots, f.pxbe_ms_lax_in_view_sum, f.pxbe_ms_px_in_view_sum, f.pxbe_px_ots, f.real_estate_measurable, f.real_estate_perc, f.real_estate_time, f.s1, f.session_hijacked_imps, f.lax_ots, f.gen6, f.susp_ad_invisible, f.susp_ad_onebyone, f.susp_ad_stuffed, f.susp_bad_domain, f.susp_bot_browser, f.susp_bot_data_center, f.susp_bot_dentsu_display_ots, f.susp_bot_geo, f.susp_bot_inview_measurable, f.susp_bot_inview_measurable_gm, f.susp_bot_proxy, f.susp_bot_spider, f.susp_bot_susp_browser, f.susp_bot_viewable_gm, f.susp_bot_viewable_gmp, f.susp_hidden_ad, f.susp_inapp_sivt, f.susp_incentivized_imps, f.susp_l_inview_measurable_gm, f.susp_late_night, f.susp_ms_abf, f.susp_old_browser, f.susp_top_hour, f.t1, f.throttling_imps, f.gen7, f.total_fully_on_screen_time, f.total_on_screen_time
  • Buffers: shared hit=188253
  • Worker 0: actual time=158.198..26904.218 rows=1687 loops=1
  • Buffers: shared hit=13427
  • Worker 1: actual time=178.484..24716.941 rows=2989 loops=1
  • Buffers: shared hit=11906
  • Worker 2: actual time=177.366..27610.329 rows=2009 loops=1
  • Buffers: shared hit=12069
  • Worker 3: actual time=168.631..28276.224 rows=3397 loops=1
  • Buffers: shared hit=13369
  • Worker 4: actual time=346.064..27757.599 rows=1770 loops=1
  • Buffers: shared hit=25696
  • Worker 5: actual time=190.629..25495.573 rows=2430 loops=1
  • Buffers: shared hit=18879
  • Worker 6: actual time=174.648..24663.676 rows=1324 loops=1
  • Buffers: shared hit=32582
  • Worker 7: actual time=138.660..26434.505 rows=4055 loops=1
  • Buffers: shared hit=25668
  • Worker 8: actual time=267.052..25534.123 rows=3337 loops=1
  • Buffers: shared hit=17600
9. 1.970 481.670 ↓ 5.7 178 10

Append (cost=0.00..98,894.02 rows=31 width=49) (actual time=14.837..48.167 rows=178 loops=10)

  • Buffers: shared hit=73839
  • Worker 0: actual time=5.032..16.361 rows=178 loops=1
  • Buffers: shared hit=2024
  • Worker 1: actual time=0.045..4.567 rows=171 loops=1
  • Buffers: shared hit=612
  • Worker 2: actual time=0.049..1.150 rows=187 loops=1
  • Buffers: shared hit=24
  • Worker 3: actual time=0.030..12.810 rows=185 loops=1
  • Buffers: shared hit=1478
  • Worker 4: actual time=88.586..125.684 rows=184 loops=1
  • Buffers: shared hit=13985
  • Worker 5: actual time=8.571..42.926 rows=172 loops=1
  • Buffers: shared hit=7673
  • Worker 6: actual time=7.892..129.731 rows=157 loops=1
  • Buffers: shared hit=22344
  • Worker 7: actual time=6.362..79.732 rows=178 loops=1
  • Buffers: shared hit=14426
  • Worker 8: actual time=1.415..36.581 rows=169 loops=1
  • Buffers: shared hit=6972
10. 0.010 0.010 ↓ 0.0 0 10

Parallel Seq Scan on array_data.display_slicers t (cost=0.00..0.00 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=10)

  • Output: t.date, t.level0top, t.bylevel4s
  • Filter: ((t.date >= '2018-12-01'::date) AND (t.date <= '2018-12-10'::date) AND (t.level0top = 'MASTER_PG_NA_3'::text))
  • Worker 0: actual time=0.001..0.001 rows=0 loops=1
  • Worker 1: actual time=0.001..0.002 rows=0 loops=1
  • Worker 2: actual time=0.001..0.001 rows=0 loops=1
  • Worker 3: actual time=0.001..0.001 rows=0 loops=1
  • Worker 4: actual time=0.001..0.001 rows=0 loops=1
  • Worker 5: actual time=0.001..0.001 rows=0 loops=1
  • Worker 6: actual time=0.001..0.001 rows=0 loops=1
  • Worker 7: actual time=0.001..0.001 rows=0 loops=1
  • Worker 8: actual time=0.001..0.001 rows=0 loops=1
11. 60.690 60.690 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4144_chunk t_1 (cost=0.00..8,896.45 rows=3 width=47) (actual time=5.977..6.069 rows=18 loops=10)

  • Output: t_1.date, t_1.level0top, t_1.bylevel4s
  • Filter: ((t_1.date >= '2018-12-01'::date) AND (t_1.date <= '2018-12-10'::date) AND (t_1.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 12759
  • Buffers: shared hit=6625
  • Worker 0: actual time=5.030..5.102 rows=12 loops=1
  • Buffers: shared hit=364
  • Worker 1: actual time=0.041..0.055 rows=4 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.047..0.133 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.027..0.150 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.002..0.002 rows=0 loops=1
  • Worker 5: actual time=8.568..8.582 rows=4 loops=1
  • Buffers: shared hit=766
  • Worker 6: actual time=7.890..7.988 rows=26 loops=1
  • Buffers: shared hit=642
  • Worker 7: actual time=6.360..6.521 rows=26 loops=1
  • Buffers: shared hit=481
  • Worker 8: actual time=1.412..1.542 rows=26 loops=1
  • Buffers: shared hit=78
12. 89.890 89.890 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4145_chunk t_2 (cost=0.00..9,226.02 rows=3 width=49) (actual time=8.887..8.989 rows=18 loops=10)

  • Output: t_2.date, t_2.level0top, t_2.bylevel4s
  • Filter: ((t_2.date >= '2018-12-01'::date) AND (t_2.date <= '2018-12-10'::date) AND (t_2.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 13212
  • Buffers: shared hit=6874
  • Worker 0: actual time=0.043..0.152 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.037..0.129 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.038..0.120 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.004..0.004 rows=0 loops=1
  • Worker 4: actual time=88.579..88.728 rows=29 loops=1
  • Buffers: shared hit=6866
  • Worker 5: actual time=0.035..0.258 rows=31 loops=1
  • Buffers: shared hit=2
  • Worker 6: actual time=0.030..0.100 rows=20 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.050..0.051 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.004..0.005 rows=0 loops=1
13. 46.790 46.790 ↓ 6.3 19 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4147_chunk t_3 (cost=0.00..10,157.89 rows=3 width=50) (actual time=4.604..4.679 rows=19 loops=10)

  • Output: t_3.date, t_3.level0top, t_3.bylevel4s
  • Filter: ((t_3.date >= '2018-12-01'::date) AND (t_3.date <= '2018-12-10'::date) AND (t_3.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14538
  • Buffers: shared hit=7570
  • Worker 0: actual time=0.053..0.152 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.040..0.185 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.001..0.001 rows=0 loops=1
  • Worker 3: actual time=11.549..11.657 rows=28 loops=1
  • Buffers: shared hit=1453
  • Worker 4: actual time=0.048..0.141 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.036..0.125 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.030..0.030 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=34.223..34.347 rows=31 loops=1
  • Buffers: shared hit=6111
  • Worker 8: actual time=0.056..0.143 rows=26 loops=1
  • Buffers: shared hit=1
14. 44.580 44.580 ↓ 5.7 17 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4148_chunk t_4 (cost=0.00..10,464.30 rows=3 width=50) (actual time=4.397..4.458 rows=17 loops=10)

  • Output: t_4.date, t_4.level0top, t_4.bylevel4s
  • Filter: ((t_4.date >= '2018-12-01'::date) AND (t_4.date <= '2018-12-10'::date) AND (t_4.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14682
  • Buffers: shared hit=7851
  • Worker 0: actual time=0.010..0.010 rows=0 loops=1
  • Worker 1: actual time=0.030..0.113 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.108..0.190 rows=26 loops=1
  • Buffers: shared hit=17
  • Worker 3: actual time=0.101..0.201 rows=26 loops=1
  • Buffers: shared hit=19
  • Worker 4: actual time=0.037..0.114 rows=25 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.002..0.003 rows=0 loops=1
  • Worker 6: actual time=43.570..43.638 rows=20 loops=1
  • Buffers: shared hit=7808
  • Worker 7: actual time=0.035..0.035 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.035..0.127 rows=26 loops=1
  • Buffers: shared hit=1
15. 38.890 38.890 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4149_chunk t_5 (cost=0.00..10,448.58 rows=3 width=50) (actual time=3.818..3.889 rows=18 loops=10)

  • Output: t_5.date, t_5.level0top, t_5.bylevel4s
  • Filter: ((t_5.date >= '2018-12-01'::date) AND (t_5.date <= '2018-12-10'::date) AND (t_5.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14684
  • Buffers: shared hit=7835
  • Worker 0: actual time=0.056..0.151 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.032..0.044 rows=3 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.036..0.122 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.004..0.004 rows=0 loops=1
  • Worker 4: actual time=0.007..0.007 rows=0 loops=1
  • Worker 5: actual time=0.036..0.134 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.042..0.128 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=37.926..38.165 rows=42 loops=1
  • Buffers: shared hit=7829
  • Worker 8: actual time=0.000..0.001 rows=0 loops=1
16. 40.810 40.810 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4150_chunk t_6 (cost=0.00..10,381.46 rows=3 width=50) (actual time=4.015..4.081 rows=18 loops=10)

  • Output: t_6.date, t_6.level0top, t_6.bylevel4s
  • Filter: ((t_6.date >= '2018-12-01'::date) AND (t_6.date <= '2018-12-10'::date) AND (t_6.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14660
  • Buffers: shared hit=7772
  • Worker 0: actual time=0.046..0.135 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.033..0.124 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.001..0.002 rows=0 loops=1
  • Worker 3: actual time=0.050..0.144 rows=26 loops=1
  • Buffers: shared hit=2
  • Worker 4: actual time=5.788..5.906 rows=30 loops=1
  • Buffers: shared hit=875
  • Worker 5: actual time=0.029..0.114 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.031..0.032 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.004..0.004 rows=0 loops=1
  • Worker 8: actual time=34.135..34.288 rows=38 loops=1
  • Buffers: shared hit=6890
17. 44.160 44.160 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4154_chunk t_7 (cost=0.00..9,944.72 rows=3 width=50) (actual time=4.352..4.416 rows=18 loops=10)

  • Output: t_7.date, t_7.level0top, t_7.bylevel4s
  • Filter: ((t_7.date >= '2018-12-01'::date) AND (t_7.date <= '2018-12-10'::date) AND (t_7.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14285
  • Buffers: shared hit=7402
  • Worker 0: actual time=0.005..0.005 rows=0 loops=1
  • Worker 1: actual time=0.034..0.119 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.039..0.128 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.060..0.165 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.052..0.097 rows=12 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.034..0.035 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=43.199..43.328 rows=34 loops=1
  • Buffers: shared hit=7395
  • Worker 7: actual time=0.050..0.143 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.004..0.004 rows=0 loops=1
18. 34.150 34.150 ↓ 5.7 17 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4156_chunk t_8 (cost=0.00..9,249.06 rows=3 width=48) (actual time=3.041..3.415 rows=17 loops=10)

  • Output: t_8.date, t_8.level0top, t_8.bylevel4s
  • Filter: ((t_8.date >= '2018-12-01'::date) AND (t_8.date <= '2018-12-10'::date) AND (t_8.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 13157
  • Buffers: shared hit=6907
  • Worker 0: actual time=0.035..0.156 rows=31 loops=1
  • Buffers: shared hit=2
  • Worker 1: actual time=0.001..0.001 rows=0 loops=1
  • Worker 2: actual time=0.030..0.047 rows=5 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.002..0.002 rows=0 loops=1
  • Worker 4: actual time=0.039..0.121 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=30.153..33.393 rows=32 loops=1
  • Buffers: shared hit=6900
  • Worker 6: actual time=0.004..0.004 rows=0 loops=1
  • Worker 7: actual time=0.042..0.128 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.045..0.140 rows=27 loops=1
  • Buffers: shared hit=1
19. 38.610 38.610 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4158_chunk t_9 (cost=0.00..9,545.69 rows=3 width=48) (actual time=3.792..3.861 rows=18 loops=10)

  • Output: t_9.date, t_9.level0top, t_9.bylevel4s
  • Filter: ((t_9.date >= '2018-12-01'::date) AND (t_9.date <= '2018-12-10'::date) AND (t_9.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 13716
  • Buffers: shared hit=7104
  • Worker 0: actual time=0.001..0.001 rows=0 loops=1
  • Worker 1: actual time=3.491..3.600 rows=28 loops=1
  • Buffers: shared hit=604
  • Worker 2: actual time=0.046..0.130 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.045..0.141 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.051..0.051 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.030..0.116 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=34.145..34.316 rows=31 loops=1
  • Buffers: shared hit=6494
  • Worker 7: actual time=0.009..0.010 rows=0 loops=1
  • Worker 8: actual time=0.041..0.134 rows=26 loops=1
  • Buffers: shared hit=1
20. 41.120 41.120 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4159_chunk t_10 (cost=0.00..10,579.85 rows=3 width=50) (actual time=4.049..4.112 rows=18 loops=10)

  • Output: t_10.date, t_10.level0top, t_10.bylevel4s
  • Filter: ((t_10.date >= '2018-12-01'::date) AND (t_10.date <= '2018-12-10'::date) AND (t_10.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 15062
  • Buffers: shared hit=7899
  • Worker 0: actual time=10.138..10.254 rows=31 loops=1
  • Buffers: shared hit=1654
  • Worker 1: actual time=0.033..0.051 rows=6 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.029..0.112 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.026..0.118 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=30.164..30.292 rows=36 loops=1
  • Buffers: shared hit=6239
  • Worker 5: actual time=0.001..0.001 rows=0 loops=1
  • Worker 6: actual time=0.029..0.029 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.037..0.138 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.001..0.001 rows=0 loops=1
21. 264,481.568 264,481.568 ↑ 333.3 15 1,784

Function Scan on views.get_results f (cost=5,000.15..5,050.15 rows=5,000 width=1,280) (actual time=148.248..148.252 rows=15 loops=1,784)

  • Output: f.level1, f.level2, f.level3, f.level4, f.slicer1, f.slicer2, f.slicer3, f.browser_class, f.ad_not_found_timeout, f.adtagsfound, f.c1, f.call, f.exceptions, f.gen3, f.gen4, f.gen5, f.gen6, f.gen7, f.h1, f.iabinteraction1sec, f.iabinteraction2sec, f.iabinteraction3sec, f.iabinteraction4sec, f.iabinteraction5sec, f.iframeinteractions, f.impressions, f.in_vp, f.ir1binteractions, f.ir4interactions, f.iva, f.ivb, f.ivc, f.ivd, f.ive, f.l, f.l_above_fold, f.l_birds_eye, f.l_mobile, f.l_mobile_not_iframe, f.l_not_iframe, f.l_px, f.l_somehow_measurable, f.lax_ots, f.ms_lax_dwell_sum, f.ms_lax_in_view_sum, f.ms_px_in_view_sum, f.ms_px_or_lax_js_in_viewsum, f.ms_px_or_strict_js_in_viewsum, f.msactiveoveradsum, f.msdwellsum, f.msiframeinteractionsum, f.msinviewsum, f.msir1bsum, f.msir4sum, f.msreactionsum, f.mstoscrollcount, f.mstoscrollsum, f.ots, f.percentviewedsum, f.px_or_lax_js_ots, f.px_or_strict_js_ots, f.px_ots, f.pxbe_any_ots, f.pxbe_l, f.pxbe_lax_ots, f.pxbe_ms_lax_in_view_sum, f.pxbe_ms_px_in_view_sum, f.pxbe_px_ots, f.s1, f.sall, f.t1, f.unloads, f.l_time, f.btf_absolute_ots, f.btf_absolute_l, f.mstoviewsum, f.page_ever_focused, f.had_any_strict_view_time, f.timeoveradints, f.mstimeoveradinteractionsum, f.iabinteractions, f.msiabinteractionsum, f.ocrpixelfired, f.ocrpixelerror, f.l_full_visibility_measurable, f.l_full_visibility_ots, f.l_full_visibility_ots_1_sec, f.susp_bot, f.susp_bot_browser, f.susp_bot_data_center, f.susp_bot_geo, f.susp_bot_proxy, f.susp_bot_spider, f.susp_bot_viewable, f.susp_bot_susp_browser, f.susp_l, f.susp_late_night, f.susp_top_hour, f.susp_old_browser, f.l_groupm_payable_imp, f.susp_bot_viewable_gm, f.susp_l_inview_measurable, f.susp_l_inview_measurable_gm, f.gv_categorized, f.gv_safe, f.gv_adult, f.gv_arms, f.gv_crime, f.gv_death_injury, f.gv_download, f.gv_drugs, f.gv_hatespeech, f.gv_military, f.gv_obscenity, f.gv_terrorism, f.gv_tobacco, f.mm_no_referrer, f.mm_history, f.susp_l_susp_ip, f.mm_iframe_depth, f.susp_bot_viewable_gmp, f.sf_measurable, f.as_nonviewable, f.as_nht, f.ia_loaded, f.ia_measurable, f.susp_bot_inview_measurable_gm, f.susp_bot_inview_measurable, f.dentsu_display_ots, f.susp_bot_dentsu_display_ots, f.in_vp_meas, f.active_time, f.active_impression_count, f.susp_bot_active_impression_count, f.active_time_30sec_cap, f.active_time_impression_count, f.susp_bot_active_time_impression_count, f.c1_git, f.c1_unfiltered, f.l_somehow_measurable_git, f.l_somehow_measurable_unfiltered, f.loads_git, f.loads_unfiltered, f.px_or_strict_js_ots_git, f.px_or_strict_js_ots_unfiltered, f.l_not_iframe_git, f.l_not_iframe_unfiltered, f.gv_sensitive, f.gv_unsafe, f.custom_inview, f.custom_measurable, f.susp_ms_abf, f.fifty_pct_onscreen_imps, f.fifty_pct_onscreen_time, f.real_estate_perc, f.real_estate_time, f.real_estate_measurable, f.full_vis_2_sec_continuous_measurable, f.full_vis_2_sec_continuous_inview, f.susp_bad_domain, f.susp_bot_proxy_dig_envoy, f.susp_checksum_l, f.susp_dc_tor_ip, f.susp_envoy_anonymous, f.susp_envoy_aol, f.active_meas, f.active_viewable, f.ad_not_stacked, f.ad_not_onebyone, f.ad_not_stuffed, f.opacity_ever_non_zero, f.ad_not_hidden, f.total_fully_on_screen_time, f.total_on_screen_time, f.on_screen_1_continuous_second_imps, f.susp_false_domains, f.domain_hidden, f.fully_on_screen_1_continuous_second_publicis_display_imps, f.chrome_driver_imps, f.safari_driver_imps, f.firefox_driver_imps, f.throttling_imps, f.pixels_received, f.fully_on_screen_1sec_groupm_display_new, f.mrc_strong_interaction_imps, f.mrc_display_combined_interaction_and_viewability_imps, f.domain_available, f.l_true_hostile_iframe_imps, f.gv_custom, f.passthrough_imps, f.groupm_display_imps, f.session_hijacked_imps, f.susp_hidden_ad, f.susp_ad_onebyone, f.susp_ad_invisible, f.susp_ad_stuffed, f.susp_incentivized_imps, f.fully_on_screen_1_continuous_second_pmx_display_imps, f.fully_on_screen_5_continuous_seconds, f.susp_inapp_sivt, f.valid_groupm_viewable_and_brand_safe, f.valid_viewable_and_brand_safe, f.measurable_for_viewability_and_brand_safety_unfiltered, f.measurable_for_viewability_and_brand_safety, f.fb_groupm_reach_extension_viewable_imps, f.moat_sdk_measurable_imps, f.om_sdk_available_imps, f.om_sdk_measurable_imps, f.brand_safety_unsure, f.post_bid_blocking_enabled_imps, f.post_bid_ivt_imps, f.post_bid_unsafe_content_imps, f.post_bid_out_of_geo_imps, f.post_bid_blacklisted_domain_imps, f.post_bid_unsure_imps, f.post_bid_safe_imps, f.post_bid_timeout_imps, f.post_bid_nado_error_imps, f.post_bid_missing_url_imps, f.post_bid_filter_url_imps, f.post_bid_adult_imps, f.post_bid_arms_imps, f.post_bid_crime_imps, f.post_bid_death_injury_imps, f.post_bid_download_imps, f.post_bid_drugs_imps, f.post_bid_hatespeech_imps, f.post_bid_military_imps, f.post_bid_obscenity_imps, f.post_bid_terrorism_imps, f.post_bid_tobacco_imps, f.post_bid_custom_unsafe_imps, f.post_bid_blocked_imps, f.susp_ad_backgrounded
  • Function Call: views.get_results(COALESCE(t.bylevel4s), (current_setting('marjory.filter'::text))::jsonb, 'bylevel4slicer'::text)
  • Buffers: shared hit=114414
  • Worker 0: actual time=151.016..151.019 rows=9 loops=178
  • Buffers: shared hit=11403
  • Worker 1: actual time=144.462..144.466 rows=17 loops=171
  • Buffers: shared hit=11294
  • Worker 2: actual time=147.603..147.606 rows=11 loops=187
  • Buffers: shared hit=12045
  • Worker 3: actual time=152.716..152.721 rows=18 loops=185
  • Buffers: shared hit=11891
  • Worker 4: actual time=150.135..150.138 rows=10 loops=184
  • Buffers: shared hit=11711
  • Worker 5: actual time=147.932..147.936 rows=14 loops=172
  • Buffers: shared hit=11206
  • Worker 6: actual time=156.232..156.235 rows=8 loops=157
  • Buffers: shared hit=10238
  • Worker 7: actual time=147.990..147.996 rows=23 loops=178
  • Buffers: shared hit=11242
  • Worker 8: actual time=150.810..150.816 rows=20 loops=169
  • Buffers: shared hit=10628
22. 0.244 1.233 ↓ 2.5 720 1

Hash (cost=517.89..517.89 rows=287 width=24) (actual time=1.233..1.233 rows=720 loops=1)

  • Output: client_creative_properties.x_y, client_creative_properties.level3
  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
  • Buffers: shared hit=631
23. 0.989 0.989 ↓ 2.5 720 1

Index Scan using client_creative_properties_level0top_level1_level2_level3_l_idx on ccp.client_creative_properties (cost=13.95..517.89 rows=287 width=24) (actual time=0.104..0.989 rows=720 loops=1)

  • Output: client_creative_properties.x_y, client_creative_properties.level3
  • Index Cond: ((client_creative_properties.level0top = 'MASTER_PG_NA_3'::text) AND (client_creative_properties.level1 = '-'::text) AND (client_creative_properties.level2 = '-'::text) AND (client_creative_properties.level4 = '-'::text))
  • Buffers: shared hit=631