explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QURm

Settings
# exclusive inclusive rows x rows loops node
1. 67.744 28,270.208 ↑ 1,000.0 100 1

GroupAggregate (cost=32,707,330.72..35,458,330.72 rows=100,000 width=8,826) (actual time=28,201.998..28,270.208 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=25516
2. 18.547 28,202.464 ↑ 29.7 3,369 1

Sort (cost=32,707,330.72..32,712,330.72 rows=100,000 width=8,826) (actual time=28,201.470..28,202.464 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=25516
3. 6.642 28,183.917 ↑ 29.7 3,369 1

Hash Left Join (cost=420,682.18..32,325,022.31 rows=100,000 width=8,826) (actual time=26,641.740..28,183.917 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=25516
4. 1,211.451 28,174.589 ↑ 29.7 3,369 1

Finalize GroupAggregate (cost=420,140.58..32,318,230.71 rows=100,000 width=8,954) (actual time=26,639.005..28,174.589 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=24867
5. 0.000 26,963.138 ↑ 50.3 17,875 1

Gather Merge (cost=420,140.58..6,137,230.71 rows=900,000 width=8,698) (actual time=26,638.281..26,963.138 rows=17,875 loops=1)

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

Partial GroupAggregate (cost=420,137.26..5,793,159.36 rows=100,000 width=8,698) (actual time=25,257.917..25,565.584 rows=1,788 loops=10)

  • Output: t.level0top, f.level1, f.level2, f.level3, f.level4, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), PARTIAL sum(f.active_meas), PARTIAL sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-02-13'::date) THEN f.active_time_impression_count ELSE '0'::bigint END), PARTIAL sum(f.active_viewable), PARTIAL sum(f.ad_not_found_timeout), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_hidden ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_onebyone ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stacked ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.ad_not_stuffed ELSE '0'::bigint END), PARTIAL sum(f.adtagsfound), PARTIAL sum(f.btf_absolute_l), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_l ELSE '0'::bigint END), PARTIAL sum(f.btf_absolute_ots), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.btf_absolute_ots ELSE '0'::bigint END), PARTIAL sum(f.c1), PARTIAL sum(f.c1_git), PARTIAL sum(f.c1_unfiltered), PARTIAL sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_inview ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.custom_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.dentsu_display_ots ELSE '0'::bigint END), PARTIAL sum(f.exceptions), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.fifty_pct_onscreen_time ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.full_vis_2_sec_continuous_inview ELSE '0'::bigint END), PARTIAL sum(f.gen4), PARTIAL sum(f.groupm_display_imps), PARTIAL sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.groupm_display_imps ELSE '0'::bigint END), PARTIAL sum(f.gv_adult), PARTIAL sum(f.gv_arms), PARTIAL sum(f.gv_categorized), PARTIAL sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_categorized ELSE '0'::bigint END), PARTIAL sum(f.gv_crime), PARTIAL sum(f.gv_death_injury), PARTIAL sum(f.gv_download), PARTIAL sum(f.gv_drugs), PARTIAL sum(f.gv_hatespeech), PARTIAL sum(f.gv_military), PARTIAL sum(f.gv_obscenity), PARTIAL sum(f.gv_safe), PARTIAL sum(f.gv_terrorism), PARTIAL sum(f.gv_tobacco), PARTIAL sum(f.gv_unsafe), PARTIAL sum(CASE WHEN (t.date >= '2016-03-23'::date) THEN f.gv_unsafe ELSE (COALESCE(f.gv_categorized, '0'::bigint) - COALESCE(f.gv_safe, '0'::bigint)) END), PARTIAL sum(f.h1), PARTIAL sum(f.had_any_strict_view_time), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.had_any_strict_view_time ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date < '2015-02-26'::date) THEN (CASE WHEN (t.date >= '2015-01-10'::date) THEN LEAST((COALESCE(f.px_or_strict_js_ots, '0'::bigint) - COALESCE(f.susp_bot_viewable, '0'::bigint)), (COALESCE(f.susp_l, '0'::bigint) - COALESCE(f.susp_bot, '0'::bigint))) ELSE '0'::bigint END)::double precision ELSE floor(((COALESCE(f.px_or_strict_js_ots, '0'::bigint))::double precision - ((COALESCE(f.susp_bot_viewable, '0'::bigint))::double precision * CASE WHEN (COALESCE(f.susp_l_inview_measurable, '0'::bigint) = 0) THEN '1'::double precision ELSE ((COALESCE(f.l_somehow_measurable, '0'::bigint) / COALESCE(f.susp_l_inview_measurable, '0'::bigint)))::double precision END))) END), PARTIAL sum(f.ia_loaded), PARTIAL sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_loaded ELSE '0'::bigint END), PARTIAL sum(f.ia_measurable), PARTIAL sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.ia_measurable ELSE '0'::bigint END), PARTIAL sum(f.impressions), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.in_vp ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.in_vp ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.in_vp_meas ELSE '0'::bigint END), PARTIAL sum(f.ir4interactions), PARTIAL sum((COALESCE(f.l, '0'::bigint) - COALESCE(f.l_mobile, '0'::bigint))), PARTIAL sum(f.msir4sum), PARTIAL sum(f.iva), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.iva ELSE '0'::bigint END), PARTIAL sum(f.ivb), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivb ELSE '0'::bigint END), PARTIAL sum(f.ivc), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivc ELSE '0'::bigint END), PARTIAL sum(f.ivd), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ivd ELSE '0'::bigint END), PARTIAL sum(f.ive), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.ive ELSE '0'::bigint END), PARTIAL sum(f.l), PARTIAL sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-04-06'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-20'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-05-13'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-07-18'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.l_above_fold), PARTIAL sum(CASE WHEN (t.date > '2012-11-19'::date) THEN f.l_somehow_measurable ELSE f.l_birds_eye END), PARTIAL sum(CASE WHEN (t.date >= '2014-03-18'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(f.l_birds_eye), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_birds_eye ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_measurable, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END), PARTIAL sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-07-07'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-01'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-04-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-09-02'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-11-18'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.l_full_visibility_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END), PARTIAL sum(CASE WHEN (t.date >= '2014-10-11'::date) THEN LEAST((COALESCE(f.l_full_visibility_ots_1_sec, '0'::bigint))::numeric, '100000000000000'::numeric) ELSE '0'::numeric END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_full_visibility_ots ELSE '0'::bigint END), PARTIAL sum(f.l_groupm_payable_imp), PARTIAL sum(CASE WHEN (t.date >= '2015-10-15'::date) THEN f.l_groupm_payable_imp ELSE '0'::bigint END), PARTIAL sum(f.l_mobile), PARTIAL sum(f.l_mobile_not_iframe), PARTIAL sum(f.l_not_iframe), PARTIAL sum(f.l_not_iframe_git), PARTIAL sum(f.l_not_iframe_unfiltered), PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.l_px), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.l_somehow_measurable), PARTIAL sum(CASE WHEN (t.date <= '2013-12-13'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2013-12-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-07-29'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-07-15'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(f.l_somehow_measurable_git), PARTIAL sum(CASE WHEN (t.date >= '2012-12-19'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(f.l_somehow_measurable_unfiltered), PARTIAL sum(f.l_time), PARTIAL sum(CASE WHEN (t.date >= '2012-03-21'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.loads_git), PARTIAL sum(CASE WHEN (t.date >= '2018-02-21'::date) THEN f.l ELSE '0'::bigint END), PARTIAL sum(f.loads_unfiltered), PARTIAL sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.loads_unfiltered ELSE '0'::bigint END), PARTIAL sum(f.mm_history), PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_history ELSE '0'::bigint END), PARTIAL sum(f.mm_no_referrer), PARTIAL sum(CASE WHEN (t.date >= '2015-05-15'::date) THEN f.mm_no_referrer ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.moat_sdk_measurable_imps ELSE '0'::bigint END), PARTIAL sum(f.ms_lax_dwell_sum), PARTIAL sum(f.ms_px_or_lax_js_in_viewsum), PARTIAL sum(f.ms_px_or_strict_js_in_viewsum), PARTIAL sum(f.msdwellsum), PARTIAL sum(f.msreactionsum), PARTIAL sum(f.mstoscrollcount), PARTIAL sum(f.mstoscrollsum), PARTIAL sum(f.mstoviewsum), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.had_any_strict_view_time, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.in_vp, '0'::bigint) - COALESCE(f.had_any_strict_view_time, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.page_ever_focused, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.page_ever_focused, '0'::bigint) - COALESCE(f.in_vp, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_available_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2018-09-09'::date) THEN f.om_sdk_measurable_imps ELSE '0'::bigint END), PARTIAL sum(f.on_screen_1_continuous_second_imps), PARTIAL sum(CASE WHEN (t.date >= '2017-09-14'::date) THEN f.opacity_ever_non_zero ELSE '0'::bigint END), PARTIAL sum(f.ots), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.ots ELSE '0'::bigint END), PARTIAL sum(f.px_or_strict_js_ots), PARTIAL sum(f.page_ever_focused), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.page_ever_focused ELSE '0'::bigint END), PARTIAL sum(f.passthrough_imps), PARTIAL sum(CASE WHEN (t.date >= '2018-01-19'::date) THEN f.passthrough_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.pixels_received ELSE '0'::bigint END), PARTIAL sum(f.px_or_lax_js_ots), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2014-02-28'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2013-07-12'::date) THEN f.px_or_strict_js_ots ELSE '0'::bigint END), PARTIAL sum(f.px_or_strict_js_ots_git), PARTIAL sum(f.px_or_strict_js_ots_unfiltered), PARTIAL sum(f.px_ots), PARTIAL sum(f.pxbe_any_ots), PARTIAL sum(f.pxbe_l), PARTIAL sum(f.pxbe_lax_ots), PARTIAL sum(f.pxbe_ms_lax_in_view_sum), PARTIAL sum(f.pxbe_ms_px_in_view_sum), PARTIAL sum(f.pxbe_px_ots), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_perc ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2017-02-10'::date) THEN f.real_estate_time ELSE '0'::bigint END), PARTIAL sum(f.s1), PARTIAL sum(f.session_hijacked_imps), PARTIAL sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.session_hijacked_imps ELSE '0'::bigint END), PARTIAL sum(f.lax_ots), PARTIAL sum(f.gen6), PARTIAL sum(f.susp_ad_invisible), PARTIAL sum(f.susp_ad_onebyone), PARTIAL sum(f.susp_ad_stuffed), PARTIAL sum(f.susp_bad_domain), PARTIAL sum(CASE WHEN (t.date >= '2016-09-28'::date) THEN f.susp_bad_domain ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_bot ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_browser ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_data_center ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.susp_l END), PARTIAL sum(CASE WHEN (t.date >= '2016-02-04'::date) THEN f.susp_bot_dentsu_display_ots ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_geo ELSE '0'::bigint END), PARTIAL sum(f.susp_bot_inview_measurable), PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable ELSE '0'::bigint END), PARTIAL sum(f.susp_bot_inview_measurable_gm), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN f.loads_unfiltered ELSE f.l END), PARTIAL sum(CASE WHEN (t.date >= '2016-03-09'::date) THEN (COALESCE(f.loads_unfiltered, '0'::bigint) - COALESCE(f.l, '0'::bigint)) ELSE f.susp_bot END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_proxy ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_spider ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_susp_browser ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gm ELSE '0'::bigint END), PARTIAL sum(f.susp_bot_viewable_gmp), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_bot_viewable_gmp ELSE '0'::bigint END), PARTIAL sum(f.susp_hidden_ad), PARTIAL sum(CASE WHEN (t.date >= '2017-12-15'::date) THEN f.susp_hidden_ad ELSE '0'::bigint END), PARTIAL sum(f.susp_inapp_sivt), PARTIAL sum(CASE WHEN (t.date >= '2018-02-01'::date) THEN f.susp_incentivized_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-11-25'::date) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-08-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-07-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-02-26'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-10-15'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-11-25'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2016-02-04'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-02-26'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-08-25'::date) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2015-09-02'::date) AND (t.date < '2016-03-09'::date)) THEN f.susp_l_inview_measurable_gm ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_late_night ELSE '0'::bigint END), PARTIAL sum(f.susp_ms_abf), PARTIAL sum(CASE WHEN (t.date >= '2016-05-05'::date) THEN f.susp_ms_abf ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_old_browser ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2015-01-10'::date) THEN f.susp_top_hour ELSE '0'::bigint END), PARTIAL sum(f.t1), PARTIAL sum(CASE WHEN (t.date >= '2017-08-01'::date) THEN f.throttling_imps ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2013-02-04'::date) THEN f.gen7 ELSE f.msreactionsum END), PARTIAL sum(f.total_fully_on_screen_time), PARTIAL sum(f.total_on_screen_time), PARTIAL sum(CASE WHEN (t.date >= '2015-10-09'::date) THEN f.l_somehow_measurable ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_birds_eye, '0'::bigint) - COALESCE(f.ots, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2015-10-09'::date)) THEN (COALESCE(f.l_somehow_measurable, '0'::bigint) - COALESCE(f.px_or_strict_js_ots, '0'::bigint)) ELSE '0'::bigint END), PARTIAL sum(CASE WHEN (t.date >= '2016-08-24'::date) THEN COALESCE(f.l_birds_eye, '0'::bigint) WHEN ((t.date >= '2014-02-28'::date) AND (t.date < '2016-08-24'::date)) THEN COALESCE(f.l_somehow_measurable, '0'::bigint) ELSE '0'::bigint END)
  • Group Key: f.level1, f.level2, f.level3, f.level4, t.level0top, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text))
  • Buffers: shared hit=191876
  • Worker 0: actual time=26159.241..26550.782 rows=2465 loops=1
  • Buffers: shared hit=25741
  • Worker 1: actual time=23275.719..23610.762 rows=2045 loops=1
  • Buffers: shared hit=24679
  • Worker 2: actual time=25538.911..25882.667 rows=2339 loops=1
  • Buffers: shared hit=11019
  • Worker 3: actual time=26183.211..26519.038 rows=1754 loops=1
  • Buffers: shared hit=23670
  • Worker 4: actual time=23929.818..24297.758 rows=1880 loops=1
  • Buffers: shared hit=19175
  • Worker 5: actual time=24309.441..24708.447 rows=2297 loops=1
  • Buffers: shared hit=11841
  • Worker 6: actual time=24995.090..25173.025 rows=1081 loops=1
  • Buffers: shared hit=18748
  • Worker 7: actual time=26596.820..26905.709 rows=1663 loops=1
  • Buffers: shared hit=20474
  • Worker 8: actual time=25594.440..25896.660 rows=1469 loops=1
  • Buffers: shared hit=11662
7. 165.830 252,581.990 ↑ 58.5 2,686 10

Sort (cost=420,137.26..427,998.36 rows=157,222 width=1,302) (actual time=25,256.731..25,258.199 rows=2,686 loops=10)

  • Output: t.level0top, f.level1, f.level2, f.level3, f.level4, (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)), f.active_meas, t.date, f.active_time, f.active_time_impression_count, f.active_viewable, f.ad_not_found_timeout, f.ad_not_hidden, f.ad_not_onebyone, f.ad_not_stacked, f.ad_not_stuffed, f.adtagsfound, f.btf_absolute_l, f.btf_absolute_ots, f.c1, f.c1_git, f.c1_unfiltered, f.custom_inview, f.custom_measurable, f.dentsu_display_ots, f.exceptions, f.fifty_pct_onscreen_imps, f.fifty_pct_onscreen_time, f.full_vis_2_sec_continuous_inview, f.gen4, f.groupm_display_imps, f.gv_adult, f.gv_arms, f.gv_categorized, f.gv_crime, f.gv_death_injury, f.gv_download, f.gv_drugs, f.gv_hatespeech, f.gv_military, f.gv_obscenity, f.gv_safe, f.gv_terrorism, f.gv_tobacco, f.gv_unsafe, f.h1, f.had_any_strict_view_time, f.px_or_strict_js_ots, f.susp_bot_viewable, f.susp_l, f.susp_bot, f.susp_l_inview_measurable, f.l_somehow_measurable, f.ia_loaded, f.ia_measurable, f.impressions, f.in_vp, f.in_vp_meas, f.ir4interactions, f.l, f.l_mobile, f.msir4sum, f.iva, f.ivb, f.ivc, f.ivd, f.ive, f.l_above_fold, f.l_birds_eye, f.l_full_visibility_measurable, f.l_full_visibility_ots, f.l_full_visibility_ots_1_sec, f.l_groupm_payable_imp, f.l_mobile_not_iframe, f.l_not_iframe, f.l_not_iframe_git, f.l_not_iframe_unfiltered, f.l_px, f.l_somehow_measurable_git, f.l_somehow_measurable_unfiltered, f.l_time, f.loads_git, f.loads_unfiltered, f.mm_history, f.mm_no_referrer, f.moat_sdk_measurable_imps, f.ms_lax_dwell_sum, f.ms_px_or_lax_js_in_viewsum, f.ms_px_or_strict_js_in_viewsum, f.msdwellsum, f.msreactionsum, f.mstoscrollcount, f.mstoscrollsum, f.mstoviewsum, f.page_ever_focused, f.ots, f.om_sdk_available_imps, f.om_sdk_measurable_imps, f.on_screen_1_continuous_second_imps, f.opacity_ever_non_zero, f.passthrough_imps, f.pixels_received, f.px_or_lax_js_ots, f.px_or_strict_js_ots_git, f.px_or_strict_js_ots_unfiltered, f.px_ots, f.pxbe_any_ots, f.pxbe_l, f.pxbe_lax_ots, f.pxbe_ms_lax_in_view_sum, f.pxbe_ms_px_in_view_sum, f.pxbe_px_ots, f.real_estate_measurable, f.real_estate_perc, f.real_estate_time, f.s1, f.session_hijacked_imps, f.lax_ots, f.gen6, f.susp_ad_invisible, f.susp_ad_onebyone, f.susp_ad_stuffed, f.susp_bad_domain, f.susp_bot_browser, f.susp_bot_data_center, f.susp_bot_dentsu_display_ots, f.susp_bot_geo, f.susp_bot_inview_measurable, f.susp_bot_inview_measurable_gm, f.susp_bot_proxy, f.susp_bot_spider, f.susp_bot_susp_browser, f.susp_bot_viewable_gm, f.susp_bot_viewable_gmp, f.susp_hidden_ad, f.susp_inapp_sivt, f.susp_incentivized_imps, f.susp_l_inview_measurable_gm, f.susp_late_night, f.susp_ms_abf, f.susp_old_browser, f.susp_top_hour, f.t1, f.throttling_imps, f.gen7, f.total_fully_on_screen_time, f.total_on_screen_time
  • Sort Key: f.level1 COLLATE "C", f.level2 COLLATE "C", f.level3 COLLATE "C", f.level4 COLLATE "C", (replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text)) COLLATE "C
  • Sort Method: quicksort Memory: 1386kB
  • Buffers: shared hit=191876
  • Worker 0: actual time=26157.539..26159.338 rows=3648 loops=1
  • Buffers: shared hit=25741
  • Worker 1: actual time=23275.112..23276.618 rows=3042 loops=1
  • Buffers: shared hit=24679
  • Worker 2: actual time=25538.307..25540.131 rows=4061 loops=1
  • Buffers: shared hit=11019
  • Worker 3: actual time=26180.209..26181.674 rows=2618 loops=1
  • Buffers: shared hit=23670
  • Worker 4: actual time=23929.224..23931.232 rows=2668 loops=1
  • Buffers: shared hit=19175
  • Worker 5: actual time=24308.854..24310.533 rows=3033 loops=1
  • Buffers: shared hit=11841
  • Worker 6: actual time=24993.295..24994.016 rows=1411 loops=1
  • Buffers: shared hit=18748
  • Worker 7: actual time=26596.252..26597.960 rows=2675 loops=1
  • Buffers: shared hit=20474
  • Worker 8: actual time=25592.622..25593.913 rows=2097 loops=1
  • Buffers: shared hit=11662
8. 83.592 252,416.160 ↑ 58.5 2,686 10

Nested Loop (cost=5,000.15..148,733.67 rows=157,222 width=1,302) (actual time=182.971..25,241.616 rows=2,686 loops=10)

  • Output: t.level0top, f.level1, f.level2, f.level3, f.level4, replace(replace(replace(CASE WHEN ((f.slicer1 = '-'::text) OR (f.slicer1 = ''::text)) THEN '(unclassified)'::text ELSE f.slicer1 END, '&gt'::text, '>'::text), '&amp'::text, '&'::text), '%3E'::text, '>'::text), f.active_meas, t.date, f.active_time, f.active_time_impression_count, f.active_viewable, f.ad_not_found_timeout, f.ad_not_hidden, f.ad_not_onebyone, f.ad_not_stacked, f.ad_not_stuffed, f.adtagsfound, f.btf_absolute_l, f.btf_absolute_ots, f.c1, f.c1_git, f.c1_unfiltered, f.custom_inview, f.custom_measurable, f.dentsu_display_ots, f.exceptions, f.fifty_pct_onscreen_imps, f.fifty_pct_onscreen_time, f.full_vis_2_sec_continuous_inview, f.gen4, f.groupm_display_imps, f.gv_adult, f.gv_arms, f.gv_categorized, f.gv_crime, f.gv_death_injury, f.gv_download, f.gv_drugs, f.gv_hatespeech, f.gv_military, f.gv_obscenity, f.gv_safe, f.gv_terrorism, f.gv_tobacco, f.gv_unsafe, f.h1, f.had_any_strict_view_time, f.px_or_strict_js_ots, f.susp_bot_viewable, f.susp_l, f.susp_bot, f.susp_l_inview_measurable, f.l_somehow_measurable, f.ia_loaded, f.ia_measurable, f.impressions, f.in_vp, f.in_vp_meas, f.ir4interactions, f.l, f.l_mobile, f.msir4sum, f.iva, f.ivb, f.ivc, f.ivd, f.ive, f.l_above_fold, f.l_birds_eye, f.l_full_visibility_measurable, f.l_full_visibility_ots, f.l_full_visibility_ots_1_sec, f.l_groupm_payable_imp, f.l_mobile_not_iframe, f.l_not_iframe, f.l_not_iframe_git, f.l_not_iframe_unfiltered, f.l_px, f.l_somehow_measurable_git, f.l_somehow_measurable_unfiltered, f.l_time, f.loads_git, f.loads_unfiltered, f.mm_history, f.mm_no_referrer, f.moat_sdk_measurable_imps, f.ms_lax_dwell_sum, f.ms_px_or_lax_js_in_viewsum, f.ms_px_or_strict_js_in_viewsum, f.msdwellsum, f.msreactionsum, f.mstoscrollcount, f.mstoscrollsum, f.mstoviewsum, f.page_ever_focused, f.ots, f.om_sdk_available_imps, f.om_sdk_measurable_imps, f.on_screen_1_continuous_second_imps, f.opacity_ever_non_zero, f.passthrough_imps, f.pixels_received, f.px_or_lax_js_ots, f.px_or_strict_js_ots_git, f.px_or_strict_js_ots_unfiltered, f.px_ots, f.pxbe_any_ots, f.pxbe_l, f.pxbe_lax_ots, f.pxbe_ms_lax_in_view_sum, f.pxbe_ms_px_in_view_sum, f.pxbe_px_ots, f.real_estate_measurable, f.real_estate_perc, f.real_estate_time, f.s1, f.session_hijacked_imps, f.lax_ots, f.gen6, f.susp_ad_invisible, f.susp_ad_onebyone, f.susp_ad_stuffed, f.susp_bad_domain, f.susp_bot_browser, f.susp_bot_data_center, f.susp_bot_dentsu_display_ots, f.susp_bot_geo, f.susp_bot_inview_measurable, f.susp_bot_inview_measurable_gm, f.susp_bot_proxy, f.susp_bot_spider, f.susp_bot_susp_browser, f.susp_bot_viewable_gm, f.susp_bot_viewable_gmp, f.susp_hidden_ad, f.susp_inapp_sivt, f.susp_incentivized_imps, f.susp_l_inview_measurable_gm, f.susp_late_night, f.susp_ms_abf, f.susp_old_browser, f.susp_top_hour, f.t1, f.throttling_imps, f.gen7, f.total_fully_on_screen_time, f.total_on_screen_time
  • Buffers: shared hit=191525
  • Worker 0: actual time=207.084..26137.665 rows=3648 loops=1
  • Buffers: shared hit=25702
  • Worker 1: actual time=192.236..23258.170 rows=3042 loops=1
  • Buffers: shared hit=24640
  • Worker 2: actual time=192.561..25517.408 rows=4061 loops=1
  • Buffers: shared hit=10980
  • Worker 3: actual time=148.242..26159.614 rows=2618 loops=1
  • Buffers: shared hit=23631
  • Worker 4: actual time=187.973..23915.015 rows=2668 loops=1
  • Buffers: shared hit=19136
  • Worker 5: actual time=167.764..24292.753 rows=3033 loops=1
  • Buffers: shared hit=11802
  • Worker 6: actual time=187.080..24984.977 rows=1411 loops=1
  • Buffers: shared hit=18709
  • Worker 7: actual time=184.204..26581.983 rows=2675 loops=1
  • Buffers: shared hit=20435
  • Worker 8: actual time=189.542..25581.378 rows=2097 loops=1
  • Buffers: shared hit=11623
9. 1.880 446.040 ↓ 5.7 178 10

Append (cost=0.00..101,328.02 rows=31 width=50) (actual time=11.582..44.604 rows=178 loops=10)

  • Buffers: shared hit=76273
  • Worker 0: actual time=37.601..77.905 rows=211 loops=1
  • Buffers: shared hit=12015
  • Worker 1: actual time=36.308..93.260 rows=165 loops=1
  • Buffers: shared hit=13793
  • Worker 2: actual time=0.030..1.240 rows=178 loops=1
  • Buffers: shared hit=25
  • Worker 3: actual time=0.376..63.504 rows=178 loops=1
  • Buffers: shared hit=12266
  • Worker 4: actual time=0.090..49.697 rows=165 loops=1
  • Buffers: shared hit=8570
  • Worker 5: actual time=1.134..2.239 rows=170 loops=1
  • Buffers: shared hit=78
  • Worker 6: actual time=3.980..43.216 rows=174 loops=1
  • Buffers: shared hit=7424
  • Worker 7: actual time=1.468..43.602 rows=186 loops=1
  • Buffers: shared hit=8539
  • Worker 8: actual time=1.859..2.974 rows=179 loops=1
  • Buffers: shared hit=106
10. 0.010 0.010 ↓ 0.0 0 10

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

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

Parallel Seq Scan on _timescaledb_internal._hyper_1_2865_chunk t_1 (cost=0.00..9,274.45 rows=3 width=48) (actual time=4.193..4.273 rows=18 loops=10)

  • Output: t_1.date, t_1.level0top, t_1.bylevel4s
  • Filter: ((t_1.date >= '2018-12-01'::date) AND (t_1.date <= '2018-12-10'::date) AND (t_1.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 12759
  • Buffers: shared hit=7003
  • Worker 0: actual time=0.037..0.037 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.001..0.002 rows=0 loops=1
  • Worker 2: actual time=0.027..0.074 rows=11 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.374..0.507 rows=26 loops=1
  • Buffers: shared hit=17
  • Worker 4: actual time=0.087..0.192 rows=26 loops=1
  • Buffers: shared hit=4
  • Worker 5: actual time=1.131..1.236 rows=26 loops=1
  • Buffers: shared hit=56
  • Worker 6: actual time=3.977..4.116 rows=26 loops=1
  • Buffers: shared hit=233
  • Worker 7: actual time=1.465..1.505 rows=9 loops=1
  • Buffers: shared hit=73
  • Worker 8: actual time=1.856..1.983 rows=26 loops=1
  • Buffers: shared hit=98
12. 74.860 74.860 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_2866_chunk t_2 (cost=0.00..9,529.02 rows=3 width=50) (actual time=7.409..7.486 rows=18 loops=10)

  • Output: t_2.date, t_2.level0top, t_2.bylevel4s
  • Filter: ((t_2.date >= '2018-12-01'::date) AND (t_2.date <= '2018-12-10'::date) AND (t_2.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 13212
  • Buffers: shared hit=7177
  • Worker 0: actual time=37.560..37.778 rows=38 loops=1
  • Buffers: shared hit=3798
  • Worker 1: actual time=36.303..36.445 rows=31 loops=1
  • Buffers: shared hit=3374
  • Worker 2: actual time=0.048..0.146 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.005..0.005 rows=0 loops=1
  • Worker 4: actual time=0.002..0.002 rows=0 loops=1
  • Worker 5: actual time=0.029..0.129 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.046..0.131 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.039..0.133 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.056..0.093 rows=11 loops=1
  • Buffers: shared hit=1
13. 43.150 43.150 ↓ 6.3 19 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_2868_chunk t_3 (cost=0.00..10,406.89 rows=3 width=50) (actual time=4.243..4.315 rows=19 loops=10)

  • Output: t_3.date, t_3.level0top, t_3.bylevel4s
  • Filter: ((t_3.date >= '2018-12-01'::date) AND (t_3.date <= '2018-12-10'::date) AND (t_3.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14538
  • Buffers: shared hit=7819
  • Worker 0: actual time=0.047..0.047 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.035..0.135 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.043..0.139 rows=24 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.047..0.135 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=9.920..10.051 rows=29 loops=1
  • Buffers: shared hit=1221
  • Worker 5: actual time=0.001..0.001 rows=0 loops=1
  • Worker 6: actual time=0.001..0.001 rows=0 loops=1
  • Worker 7: actual time=0.032..0.134 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.041..0.127 rows=26 loops=1
  • Buffers: shared hit=1
14. 40.020 40.020 ↓ 5.7 17 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_2869_chunk t_4 (cost=0.00..10,880.30 rows=3 width=50) (actual time=3.942..4.002 rows=17 loops=10)

  • Output: t_4.date, t_4.level0top, t_4.bylevel4s
  • Filter: ((t_4.date >= '2018-12-01'::date) AND (t_4.date <= '2018-12-10'::date) AND (t_4.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14682
  • Buffers: shared hit=8267
  • Worker 0: actual time=38.900..38.985 rows=26 loops=1
  • Buffers: shared hit=8205
  • Worker 1: actual time=0.036..0.118 rows=21 loops=1
  • Buffers: shared hit=5
  • Worker 2: actual time=0.110..0.169 rows=18 loops=1
  • Buffers: shared hit=17
  • Worker 3: actual time=0.048..0.130 rows=26 loops=1
  • Buffers: shared hit=2
  • Worker 4: actual time=0.033..0.128 rows=26 loops=1
  • Buffers: shared hit=4
  • Worker 5: actual time=0.123..0.215 rows=26 loops=1
  • Buffers: shared hit=17
  • Worker 6: actual time=0.087..0.165 rows=23 loops=1
  • Buffers: shared hit=6
  • Worker 7: actual time=0.024..0.024 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.008..0.009 rows=0 loops=1
15. 39.140 39.140 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_2870_chunk t_5 (cost=0.00..10,616.58 rows=3 width=50) (actual time=3.852..3.914 rows=18 loops=10)

  • Output: t_5.date, t_5.level0top, t_5.bylevel4s
  • Filter: ((t_5.date >= '2018-12-01'::date) AND (t_5.date <= '2018-12-10'::date) AND (t_5.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14684
  • Buffers: shared hit=8003
  • Worker 0: actual time=0.087..0.173 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.001..0.001 rows=0 loops=1
  • Worker 2: actual time=0.028..0.054 rows=4 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.001..0.001 rows=0 loops=1
  • Worker 4: actual time=0.001..0.001 rows=0 loops=1
  • Worker 5: actual time=0.031..0.131 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.049..0.138 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=38.244..38.402 rows=41 loops=1
  • Buffers: shared hit=7997
  • Worker 8: actual time=0.045..0.125 rows=26 loops=1
  • Buffers: shared hit=1
16. 45.230 45.230 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_2872_chunk t_6 (cost=0.00..10,549.46 rows=3 width=51) (actual time=4.459..4.523 rows=18 loops=10)

  • Output: t_6.date, t_6.level0top, t_6.bylevel4s
  • Filter: ((t_6.date >= '2018-12-01'::date) AND (t_6.date <= '2018-12-10'::date) AND (t_6.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14660
  • Buffers: shared hit=7940
  • Worker 0: actual time=0.065..0.150 rows=26 loops=1
  • Buffers: shared hit=5
  • Worker 1: actual time=22.761..22.882 rows=30 loops=1
  • Buffers: shared hit=4090
  • Worker 2: actual time=0.028..0.110 rows=24 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=21.523..21.650 rows=33 loops=1
  • Buffers: shared hit=3817
  • Worker 4: actual time=0.112..0.192 rows=22 loops=1
  • Buffers: shared hit=24
  • Worker 5: actual time=0.001..0.002 rows=0 loops=1
  • Worker 6: actual time=0.032..0.032 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.001..0.002 rows=0 loops=1
  • Worker 8: actual time=0.040..0.125 rows=26 loops=1
  • Buffers: shared hit=1
17. 41.810 41.810 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_2875_chunk t_7 (cost=0.00..10,192.72 rows=3 width=50) (actual time=3.831..4.181 rows=18 loops=10)

  • Output: t_7.date, t_7.level0top, t_7.bylevel4s
  • Filter: ((t_7.date >= '2018-12-01'::date) AND (t_7.date <= '2018-12-10'::date) AND (t_7.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14285
  • Buffers: shared hit=7650
  • Worker 0: actual time=0.042..0.122 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.031..0.032 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.036..0.135 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.001..0.001 rows=0 loops=1
  • Worker 4: actual time=0.036..0.133 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.033..0.129 rows=19 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=37.962..38.201 rows=34 loops=1
  • Buffers: shared hit=7180
  • Worker 7: actual time=0.142..2.987 rows=32 loops=1
  • Buffers: shared hit=464
  • Worker 8: actual time=0.000..0.001 rows=0 loops=1
18. 37.580 37.580 ↓ 5.7 17 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_2877_chunk t_8 (cost=0.00..9,336.06 rows=3 width=48) (actual time=3.691..3.758 rows=17 loops=10)

  • Output: t_8.date, t_8.level0top, t_8.bylevel4s
  • Filter: ((t_8.date >= '2018-12-01'::date) AND (t_8.date <= '2018-12-10'::date) AND (t_8.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 13157
  • Buffers: shared hit=6994
  • Worker 0: actual time=0.036..0.087 rows=16 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=33.153..33.335 rows=31 loops=1
  • Buffers: shared hit=6320
  • Worker 2: actual time=0.003..0.003 rows=0 loops=1
  • Worker 3: actual time=3.569..3.703 rows=36 loops=1
  • Buffers: shared hit=667
  • Worker 4: actual time=0.028..0.029 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.032..0.124 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.015..0.016 rows=0 loops=1
  • Worker 7: actual time=0.003..0.003 rows=0 loops=1
  • Worker 8: actual time=0.046..0.178 rows=38 loops=1
  • Buffers: shared hit=3
19. 39.620 39.620 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_2879_chunk t_9 (cost=0.00..9,763.69 rows=3 width=48) (actual time=3.893..3.962 rows=18 loops=10)

  • Output: t_9.date, t_9.level0top, t_9.bylevel4s
  • Filter: ((t_9.date >= '2018-12-01'::date) AND (t_9.date <= '2018-12-10'::date) AND (t_9.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 13716
  • Buffers: shared hit=7322
  • Worker 0: actual time=0.048..0.134 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.031..0.124 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.031..0.103 rows=19 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.042..0.043 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=38.661..38.815 rows=36 loops=1
  • Buffers: shared hit=7315
  • Worker 5: actual time=0.033..0.113 rows=21 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.041..0.145 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.031..0.127 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.015..0.016 rows=0 loops=1
20. 40.010 40.010 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_2880_chunk t_10 (cost=0.00..10,778.85 rows=3 width=51) (actual time=3.720..4.001 rows=18 loops=10)

  • Output: t_10.date, t_10.level0top, t_10.bylevel4s
  • Filter: ((t_10.date >= '2018-12-01'::date) AND (t_10.date <= '2018-12-10'::date) AND (t_10.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 15062
  • Buffers: shared hit=8098
  • Worker 0: actual time=0.034..0.113 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.029..0.029 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.033..0.120 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=36.914..37.115 rows=31 loops=1
  • Buffers: shared hit=7761
  • Worker 4: actual time=0.001..0.001 rows=0 loops=1
  • Worker 5: actual time=0.001..0.001 rows=0 loops=1
  • Worker 6: actual time=0.028..0.066 rows=13 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.027..0.112 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.043..0.122 rows=26 loops=1
  • Buffers: shared hit=1
21. 251,886.528 251,886.528 ↑ 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=141.188..141.192 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=115252
  • Worker 0: actual time=123.450..123.454 rows=17 loops=211
  • Buffers: shared hit=13687
  • Worker 1: actual time=140.333..140.338 rows=18 loops=165
  • Buffers: shared hit=10847
  • Worker 2: actual time=143.279..143.285 rows=23 loops=178
  • Buffers: shared hit=10955
  • Worker 3: actual time=146.557..146.561 rows=15 loops=178
  • Buffers: shared hit=11365
  • Worker 4: actual time=144.586..144.590 rows=16 loops=165
  • Buffers: shared hit=10566
  • Worker 5: actual time=142.828..142.833 rows=18 loops=170
  • Buffers: shared hit=11724
  • Worker 6: actual time=143.310..143.313 rows=8 loops=174
  • Buffers: shared hit=11285
  • Worker 7: actual time=142.632..142.635 rows=14 loops=186
  • Buffers: shared hit=11896
  • Worker 8: actual time=142.855..142.857 rows=12 loops=179
  • Buffers: shared hit=11517
22. 0.474 2.686 ↓ 2.5 720 1

Hash (cost=524.14..524.14 rows=291 width=24) (actual time=2.685..2.686 rows=720 loops=1)

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

Index Scan using client_creative_properties_level0top_level1_level2_level3_l_idx on ccp.client_creative_properties (cost=13.95..524.14 rows=291 width=24) (actual time=0.166..2.212 rows=720 loops=1)

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