explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zfyT

Settings
# exclusive inclusive rows x rows loops node
1. 70.681 43,442.381 ↑ 100.0 100 1

GroupAggregate (cost=67,451,077.74..68,977,177.74 rows=10,000 width=8,826) (actual time=43,371.486..43,442.381 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=17731
2. 19.582 43,371.700 ↑ 29.7 3,369 1

Sort (cost=67,451,077.74..67,456,077.74 rows=100,000 width=8,826) (actual time=43,369.939..43,371.700 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=17731
3. 7.653 43,352.118 ↑ 29.7 3,369 1

Hash Left Join (cost=4,784,452.46..67,068,769.33 rows=100,000 width=8,826) (actual time=42,124.869..43,352.118 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=17731
4. 1,005.896 43,344.434 ↑ 29.7 3,369 1

Finalize GroupAggregate (cost=4,784,447.28..67,062,497.91 rows=100,000 width=8,954) (actual time=42,124.766..43,344.434 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=17730
5. 0.000 42,338.538 ↑ 37.6 13,297 1

Gather Merge (cost=4,784,447.28..51,901,497.91 rows=500,000 width=8,698) (actual time=42,123.510..42,338.538 rows=13,297 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: 5
  • Workers Launched: 5
  • Buffers: shared hit=111423
6. 2,075.688 246,027.612 ↑ 45.1 2,216 6

Partial GroupAggregate (cost=4,784,445.73..51,747,195.73 rows=100,000 width=8,698) (actual time=40,656.418..41,004.602 rows=2,216 loops=6)

  • 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=111423
  • Worker 0: actual time=40473.515..40839.776 rows=2518 loops=1
  • Buffers: shared hit=17766
  • Worker 1: actual time=40002.619..40456.711 rows=2461 loops=1
  • Buffers: shared hit=19562
  • Worker 2: actual time=40771.638..41065.778 rows=2304 loops=1
  • Buffers: shared hit=18175
  • Worker 3: actual time=39827.499..40341.525 rows=2797 loops=1
  • Buffers: shared hit=19619
  • Worker 4: actual time=42081.539..42399.793 rows=2167 loops=1
  • Buffers: shared hit=18571
7. 177.414 243,951.924 ↑ 398.7 4,477 6

Sort (cost=4,784,445.73..4,873,695.73 rows=1,785,000 width=1,302) (actual time=40,655.272..40,658.654 rows=4,477 loops=6)

  • 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: 1698kB
  • Buffers: shared hit=111423
  • Worker 0: actual time=40471.376..40475.549 rows=6305 loops=1
  • Buffers: shared hit=17766
  • Worker 1: actual time=40001.942..40006.769 rows=5715 loops=1
  • Buffers: shared hit=19562
  • Worker 2: actual time=40769.623..40772.179 rows=3796 loops=1
  • Buffers: shared hit=18175
  • Worker 3: actual time=39826.829..39831.415 rows=5496 loops=1
  • Buffers: shared hit=19619
  • Worker 4: actual time=42080.879..42083.535 rows=3263 loops=1
  • Buffers: shared hit=18571
8. 97.952 243,774.510 ↑ 398.7 4,477 6

Nested Loop (cost=5,000.15..498,716.29 rows=1,785,000 width=1,302) (actual time=181.115..40,629.085 rows=4,477 loops=6)

  • 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=111263
  • Worker 0: actual time=184.923..40435.867 rows=6305 loops=1
  • Buffers: shared hit=17734
  • Worker 1: actual time=169.861..39967.774 rows=5715 loops=1
  • Buffers: shared hit=19530
  • Worker 2: actual time=185.764..40747.804 rows=3796 loops=1
  • Buffers: shared hit=18143
  • Worker 3: actual time=189.562..39794.280 rows=5496 loops=1
  • Buffers: shared hit=19587
  • Worker 4: actual time=193.349..42061.525 rows=3263 loops=1
  • Buffers: shared hit=18539
9. 2.862 17.838 ↑ 1.6 297 6

Append (cost=0.00..1,066.14 rows=464 width=54) (actual time=0.304..2.973 rows=297 loops=6)

  • Buffers: shared hit=605
  • Worker 0: actual time=0.024..2.941 rows=283 loops=1
  • Buffers: shared hit=106
  • Worker 1: actual time=0.028..2.198 rows=317 loops=1
  • Buffers: shared hit=18
  • Worker 2: actual time=0.043..3.740 rows=286 loops=1
  • Buffers: shared hit=209
  • Worker 3: actual time=0.038..2.279 rows=321 loops=1
  • Buffers: shared hit=21
  • Worker 4: actual time=0.046..3.058 rows=291 loops=1
  • Buffers: shared hit=130
10. 0.012 0.012 ↓ 0.0 0 6

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

  • 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.002 rows=0 loops=1
  • Worker 3: actual time=0.002..0.002 rows=0 loops=1
  • Worker 4: actual time=0.002..0.002 rows=0 loops=1
11. 2.736 2.736 ↑ 1.2 29 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_48_chunk t_1 (cost=0.00..200.55 rows=35 width=51) (actual time=0.300..0.456 rows=29 loops=6)

  • 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: 406
  • Buffers: shared hit=117
  • Worker 0: actual time=0.021..0.165 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.024..0.132 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.038..0.186 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.033..0.159 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.041..0.187 rows=28 loops=1
  • Buffers: shared hit=2
12. 1.020 1.020 ↑ 1.9 29 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_58_chunk t_2 (cost=0.00..24.68 rows=56 width=52) (actual time=0.050..0.170 rows=29 loops=6)

  • 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: 15
  • Buffers: shared hit=11
  • Worker 0: actual time=0.055..0.151 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.041..0.145 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.051..0.148 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.093..0.296 rows=44 loops=1
  • Buffers: shared hit=6
  • Worker 4: actual time=0.028..0.155 rows=26 loops=1
  • Buffers: shared hit=1
13. 2.292 2.292 ↑ 1.2 30 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_42_chunk t_3 (cost=0.00..278.64 rows=36 width=62) (actual time=0.250..0.382 rows=30 loops=6)

  • 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: 578
  • Buffers: shared hit=162
  • Worker 0: actual time=0.041..0.147 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.038..0.238 rows=35 loops=1
  • Buffers: shared hit=2
  • Worker 2: actual time=1.312..1.491 rows=39 loops=1
  • Buffers: shared hit=156
  • Worker 3: actual time=0.034..0.135 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.032..0.137 rows=26 loops=1
  • Buffers: shared hit=1
14. 1.602 1.602 ↑ 1.2 30 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_4_chunk t_4 (cost=0.00..140.54 rows=36 width=56) (actual time=0.142..0.267 rows=30 loops=6)

  • 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: 270
  • Buffers: shared hit=83
  • Worker 0: actual time=0.045..0.150 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.017..0.176 rows=38 loops=1
  • Buffers: shared hit=2
  • Worker 2: actual time=0.043..0.135 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.030..0.137 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.677..0.872 rows=37 loops=1
  • Buffers: shared hit=77
15. 0.948 0.948 ↑ 1.9 32 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_60_chunk t_5 (cost=0.00..26.35 rows=61 width=52) (actual time=0.037..0.158 rows=32 loops=6)

  • 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: 15
  • Buffers: shared hit=12
  • Worker 0: actual time=0.090..0.226 rows=33 loops=1
  • Buffers: shared hit=6
  • Worker 1: actual time=0.027..0.131 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.032..0.126 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.027..0.237 rows=52 loops=1
  • Buffers: shared hit=2
  • Worker 4: actual time=0.017..0.106 rows=26 loops=1
  • Buffers: shared hit=1
16. 1.026 1.026 ↑ 1.9 31 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_57_chunk t_6 (cost=0.00..24.99 rows=59 width=52) (actual time=0.048..0.171 rows=31 loops=6)

  • 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: 14
  • Buffers: shared hit=11
  • Worker 0: actual time=0.043..0.141 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.064..0.308 rows=54 loops=1
  • Buffers: shared hit=6
  • Worker 2: actual time=0.051..0.156 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.062..0.165 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.030..0.132 rows=26 loops=1
  • Buffers: shared hit=1
17. 1.734 1.734 ↑ 1.2 30 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_47_chunk t_7 (cost=0.00..163.04 rows=36 width=54) (actual time=0.174..0.289 rows=30 loops=6)

  • 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: 320
  • Buffers: shared hit=96
  • Worker 0: actual time=0.887..1.047 rows=40 loops=1
  • Buffers: shared hit=90
  • Worker 1: actual time=0.027..0.134 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.034..0.172 rows=34 loops=1
  • Buffers: shared hit=2
  • Worker 3: actual time=0.028..0.123 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.026..0.121 rows=26 loops=1
  • Buffers: shared hit=1
18. 1.476 1.476 ↑ 1.5 29 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_41_chunk t_8 (cost=0.00..109.20 rows=43 width=55) (actual time=0.115..0.246 rows=29 loops=6)

  • 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: 176
  • Buffers: shared hit=60
  • Worker 0: actual time=0.061..0.150 rows=26 loops=1
  • Buffers: shared hit=3
  • Worker 1: actual time=0.030..0.138 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.080..0.150 rows=15 loops=1
  • Buffers: shared hit=5
  • Worker 3: actual time=0.046..0.186 rows=27 loops=1
  • Buffers: shared hit=5
  • Worker 4: actual time=0.436..0.673 rows=44 loops=1
  • Buffers: shared hit=44
19. 0.936 0.936 ↑ 2.0 29 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_61_chunk t_9 (cost=0.00..24.52 rows=57 width=52) (actual time=0.039..0.156 rows=29 loops=6)

  • 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: 14
  • Buffers: shared hit=11
  • Worker 0: actual time=0.037..0.138 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.025..0.137 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.093..0.207 rows=30 loops=1
  • Buffers: shared hit=5
  • Worker 3: actual time=0.024..0.199 rows=42 loops=1
  • Buffers: shared hit=2
  • Worker 4: actual time=0.028..0.131 rows=26 loops=1
  • Buffers: shared hit=1
20. 1.194 1.194 ↑ 1.5 29 6

Parallel Seq Scan on _timescaledb_internal._hyper_1_31_chunk t_10 (cost=0.00..73.64 rows=44 width=53) (actual time=0.082..0.199 rows=29 loops=6)

  • 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: 102
  • Buffers: shared hit=42
  • Worker 0: actual time=0.042..0.134 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.029..0.181 rows=34 loops=1
  • Buffers: shared hit=2
  • Worker 2: actual time=0.320..0.483 rows=38 loops=1
  • Buffers: shared hit=36
  • Worker 3: actual time=0.029..0.136 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.032..0.125 rows=26 loops=1
  • Buffers: shared hit=1
21. 243,658.720 243,658.720 ↑ 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=136.573..136.580 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=110658
  • Worker 0: actual time=142.787..142.798 rows=22 loops=283
  • Buffers: shared hit=17628
  • Worker 1: actual time=126.002..126.011 rows=18 loops=317
  • Buffers: shared hit=19512
  • Worker 2: actual time=142.406..142.413 rows=13 loops=286
  • Buffers: shared hit=17934
  • Worker 3: actual time=123.893..123.902 rows=17 loops=321
  • Buffers: shared hit=19566
  • Worker 4: actual time=144.481..144.487 rows=11 loops=291
  • Buffers: shared hit=18409
22. 0.001 0.031 ↓ 0.0 0 1

Hash (cost=5.12..5.12 rows=1 width=64) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: client_creative_properties.x_y, client_creative_properties.level3
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=1
23. 0.030 0.030 ↓ 0.0 0 1

Index Scan using client_creative_properties_level0top_level1_level2_level3_l_idx on ccp.client_creative_properties (cost=2.90..5.12 rows=1 width=64) (actual time=0.030..0.030 rows=0 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=1