explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cqVg

Settings
# exclusive inclusive rows x rows loops node
1. 272.794 157,921.273 ↑ 1,000.0 100 1

GroupAggregate (cost=32,709,430.04..35,460,430.04 rows=100,000 width=8,826) (actual time=157,647.073..157,921.273 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=9898 read=9541
2. 50.751 157,648.479 ↑ 29.7 3,369 1

Sort (cost=32,709,430.04..32,714,430.04 rows=100,000 width=8,826) (actual time=157,646.335..157,648.479 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=9898 read=9541
3. 27.021 157,597.728 ↑ 29.7 3,369 1

Hash Left Join (cost=465,347.80..32,327,121.63 rows=100,000 width=8,826) (actual time=141,425.953..157,597.728 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=9898 read=9541
4. 4,542.282 157,161.138 ↑ 29.7 3,369 1

Finalize GroupAggregate (cost=464,809.37..32,320,333.20 rows=100,000 width=8,954) (actual time=141,016.288..157,161.138 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=9315 read=9495
5. 0.000 152,618.856 ↑ 50.3 17,878 1

Gather Merge (cost=464,809.37..6,139,333.20 rows=900,000 width=8,698) (actual time=141,013.658..152,618.856 rows=17,878 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=86986 read=102417 dirtied=2
6. 5,671.820 1,318,518.010 ↑ 55.9 1,788 10

Partial GroupAggregate (cost=464,806.05..5,795,261.85 rows=100,000 width=8,698) (actual time=131,283.322..131,851.801 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=86986 read=102417 dirtied=2
  • Worker 0: actual time=132479.880..132982.794 rows=1981 loops=1
  • Buffers: shared hit=1447 read=10443
  • Worker 1: actual time=131293.272..131858.894 rows=2167 loops=1
  • Buffers: shared hit=1524 read=9801 dirtied=1
  • Worker 2: actual time=140793.998..141166.645 rows=1329 loops=1
  • Buffers: shared hit=9657 read=10900
  • Worker 3: actual time=123560.060..124133.923 rows=2077 loops=1
  • Buffers: shared hit=1248 read=9337
  • Worker 4: actual time=132465.004..133159.947 rows=2358 loops=1
  • Buffers: shared hit=1702 read=11583
  • Worker 5: actual time=135446.564..135972.451 rows=1866 loops=1
  • Buffers: shared hit=31670 read=9753
  • Worker 6: actual time=122295.326..122899.904 rows=2154 loops=1
  • Buffers: shared hit=5000 read=10187
  • Worker 7: actual time=136848.247..137155.451 rows=1099 loops=1
  • Buffers: shared hit=24058 read=10430 dirtied=1
  • Worker 8: actual time=133949.975..134178.530 rows=783 loops=1
  • Buffers: shared hit=1365 read=10488
7. 704.580 1,312,846.190 ↑ 57.9 2,686 10

Sort (cost=464,806.05..472,583.85 rows=155,556 width=1,302) (actual time=131,279.587..131,284.619 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: 2023kB
  • Buffers: shared hit=86986 read=102417 dirtied=2
  • Worker 0: actual time=132478.941..132480.887 rows=2574 loops=1
  • Buffers: shared hit=1447 read=10443
  • Worker 1: actual time=131290.180..131292.721 rows=3235 loops=1
  • Buffers: shared hit=1524 read=9801 dirtied=1
  • Worker 2: actual time=140791.356..140792.767 rows=1684 loops=1
  • Buffers: shared hit=9657 read=10900
  • Worker 3: actual time=123559.203..123561.509 rows=2549 loops=1
  • Buffers: shared hit=1248 read=9337
  • Worker 4: actual time=132462.200..132484.210 rows=3270 loops=1
  • Buffers: shared hit=1702 read=11583
  • Worker 5: actual time=135444.433..135447.171 rows=3825 loops=1
  • Buffers: shared hit=31670 read=9753
  • Worker 6: actual time=122274.337..122284.152 rows=3305 loops=1
  • Buffers: shared hit=5000 read=10187
  • Worker 7: actual time=136847.257..136848.741 rows=2069 loops=1
  • Buffers: shared hit=24058 read=10430 dirtied=1
  • Worker 8: actual time=133947.914..133949.139 rows=1840 loops=1
  • Buffers: shared hit=1365 read=10488
8. 344.876 1,312,141.610 ↑ 57.9 2,686 10

Nested Loop (cost=5,000.15..146,081.46 rows=155,556 width=1,302) (actual time=1,114.305..131,214.161 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=86635 read=102417 dirtied=2
  • Worker 0: actual time=1173.142..132423.024 rows=2574 loops=1
  • Buffers: shared hit=1408 read=10443
  • Worker 1: actual time=1141.257..131260.673 rows=3235 loops=1
  • Buffers: shared hit=1485 read=9801 dirtied=1
  • Worker 2: actual time=1004.338..140766.392 rows=1684 loops=1
  • Buffers: shared hit=9618 read=10900
  • Worker 3: actual time=1137.986..123511.303 rows=2549 loops=1
  • Buffers: shared hit=1209 read=9337
  • Worker 4: actual time=1314.674..132344.605 rows=3270 loops=1
  • Buffers: shared hit=1663 read=11583
  • Worker 5: actual time=1066.293..135393.626 rows=3825 loops=1
  • Buffers: shared hit=31631 read=9753
  • Worker 6: actual time=1023.600..122168.156 rows=3305 loops=1
  • Buffers: shared hit=4961 read=10187
  • Worker 7: actual time=1047.974..136801.756 rows=2069 loops=1
  • Buffers: shared hit=24019 read=10430 dirtied=1
  • Worker 8: actual time=1176.543..133879.433 rows=1840 loops=1
  • Buffers: shared hit=1326 read=10488
9. 44.840 2,392.470 ↓ 5.7 178 10

Append (cost=0.00..99,092.31 rows=31 width=50) (actual time=51.715..239.247 rows=178 loops=10)

  • Buffers: shared hit=74045
  • Worker 0: actual time=0.117..24.259 rows=184 loops=1
  • Buffers: shared hit=129
  • Worker 1: actual time=28.199..30.301 rows=171 loops=1
  • Buffers: shared hit=225
  • Worker 2: actual time=0.038..151.354 rows=188 loops=1
  • Buffers: shared hit=8313
  • Worker 3: actual time=0.038..1.541 rows=160 loops=1
  • Buffers: shared hit=7
  • Worker 4: actual time=0.036..29.707 rows=204 loops=1
  • Buffers: shared hit=242
  • Worker 5: actual time=320.156..1073.637 rows=173 loops=1
  • Buffers: shared hit=30382
  • Worker 6: actual time=28.198..149.877 rows=174 loops=1
  • Buffers: shared hit=3666
  • Worker 7: actual time=0.034..659.515 rows=184 loops=1
  • Buffers: shared hit=22758
  • Worker 8: actual time=0.036..1.902 rows=182 loops=1
  • Buffers: shared hit=25
10. 0.020 0.020 ↓ 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.002 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.002 rows=0 loops=1
  • Worker 1: actual time=0.001..0.002 rows=0 loops=1
  • Worker 2: actual time=0.001..0.001 rows=0 loops=1
  • Worker 3: actual time=0.001..0.002 rows=0 loops=1
  • Worker 4: actual time=0.001..0.002 rows=0 loops=1
  • Worker 5: actual time=0.001..0.002 rows=0 loops=1
  • Worker 6: actual time=0.001..0.002 rows=0 loops=1
  • Worker 7: actual time=0.002..0.002 rows=0 loops=1
  • Worker 8: actual time=0.001..0.001 rows=0 loops=1
11. 198.390 198.390 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4418_chunk t_1 (cost=0.00..9,142.45 rows=3 width=47) (actual time=19.700..19.839 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=6871
  • Worker 0: actual time=0.114..0.326 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=28.195..28.416 rows=26 loops=1
  • Buffers: shared hit=188
  • Worker 2: actual time=0.035..0.205 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.035..0.205 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.034..0.194 rows=21 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.039..0.039 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=28.194..28.299 rows=8 loops=1
  • Buffers: shared hit=1115
  • Worker 7: actual time=0.031..0.130 rows=12 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.034..0.225 rows=26 loops=1
  • Buffers: shared hit=1
12. 322.120 322.120 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4419_chunk t_2 (cost=0.00..9,154.02 rows=3 width=49) (actual time=32.064..32.212 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=6802
  • Worker 0: actual time=0.002..0.002 rows=0 loops=1
  • Worker 1: actual time=0.072..0.197 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.006..0.006 rows=0 loops=1
  • Worker 3: actual time=0.052..0.124 rows=11 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.098..0.265 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=320.113..320.492 rows=17 loops=1
  • Buffers: shared hit=6795
  • Worker 6: actual time=0.078..0.359 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.116..0.247 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.060..0.176 rows=26 loops=1
  • Buffers: shared hit=1
13. 186.540 186.540 ↓ 6.3 19 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4421_chunk t_3 (cost=0.00..10,274.18 rows=3 width=51) (actual time=16.312..18.654 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: 14495
  • Buffers: shared hit=7694
  • Worker 0: actual time=0.170..18.029 rows=40 loops=1
  • Buffers: shared hit=121
  • Worker 1: actual time=0.001..0.001 rows=0 loops=1
  • Worker 2: actual time=0.215..0.751 rows=28 loops=1
  • Buffers: shared hit=38
  • Worker 3: actual time=0.047..0.175 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.006..0.007 rows=0 loops=1
  • Worker 5: actual time=162.456..166.844 rows=17 loops=1
  • Buffers: shared hit=7531
  • Worker 6: actual time=0.044..0.238 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.124..0.299 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.005..0.006 rows=0 loops=1
14. 236.840 236.840 ↓ 5.7 17 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4422_chunk t_4 (cost=0.00..10,641.30 rows=3 width=50) (actual time=23.573..23.684 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=8028
  • Worker 0: actual time=0.003..0.003 rows=0 loops=1
  • Worker 1: actual time=0.077..0.205 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.054..0.196 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.004..0.004 rows=0 loops=1
  • Worker 4: actual time=0.080..0.311 rows=27 loops=1
  • Buffers: shared hit=4
  • Worker 5: actual time=235.128..235.277 rows=19 loops=1
  • Buffers: shared hit=8000
  • Worker 6: actual time=0.064..0.263 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.054..0.055 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.225..0.360 rows=26 loops=1
  • Buffers: shared hit=19
15. 129.570 129.570 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4423_chunk t_5 (cost=0.00..10,355.58 rows=3 width=51) (actual time=12.859..12.957 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=7742
  • Worker 0: actual time=0.050..0.176 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.001..0.001 rows=0 loops=1
  • Worker 2: actual time=0.006..0.006 rows=0 loops=1
  • Worker 3: actual time=0.069..0.216 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.097..0.248 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.079..0.225 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.069..0.142 rows=8 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=128.167..128.363 rows=37 loops=1
  • Buffers: shared hit=7736
  • Worker 8: actual time=0.055..0.188 rows=26 loops=1
  • Buffers: shared hit=1
16. 96.260 96.260 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4425_chunk t_6 (cost=0.00..10,281.46 rows=3 width=50) (actual time=9.486..9.626 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=7672
  • Worker 0: actual time=0.045..0.186 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.062..0.258 rows=26 loops=1
  • Buffers: shared hit=2
  • Worker 2: actual time=94.464..94.643 rows=30 loops=1
  • Buffers: shared hit=7664
  • Worker 3: actual time=0.047..0.133 rows=18 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.006..0.006 rows=0 loops=1
  • Worker 5: actual time=0.049..0.186 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.071..0.219 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.056..0.056 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.005..0.005 rows=0 loops=1
17. 219.870 219.870 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4428_chunk t_7 (cost=0.00..9,972.72 rows=3 width=50) (actual time=21.887..21.987 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=7430
  • Worker 0: actual time=4.772..4.838 rows=13 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.057..0.204 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.001..0.001 rows=0 loops=1
  • Worker 3: actual time=0.065..0.208 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=3.536..3.695 rows=26 loops=1
  • Buffers: shared hit=232
  • Worker 5: actual time=0.080..0.081 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.002..0.003 rows=0 loops=1
  • Worker 7: actual time=210.186..210.386 rows=33 loops=1
  • Buffers: shared hit=7192
  • Worker 8: actual time=0.056..0.195 rows=26 loops=1
  • Buffers: shared hit=1
18. 345.410 345.410 ↓ 5.7 17 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4430_chunk t_8 (cost=0.00..9,126.06 rows=3 width=48) (actual time=34.424..34.541 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=6784
  • Worker 0: actual time=0.086..0.225 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.018..0.018 rows=0 loops=1
  • Worker 2: actual time=54.601..54.808 rows=30 loops=1
  • Buffers: shared hit=607
  • Worker 3: actual time=0.003..0.003 rows=0 loops=1
  • Worker 4: actual time=0.045..0.189 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=169.926..170.074 rows=21 loops=1
  • Buffers: shared hit=3629
  • Worker 6: actual time=119.450..119.767 rows=28 loops=1
  • Buffers: shared hit=2544
  • Worker 7: actual time=0.048..0.124 rows=16 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.059..0.202 rows=26 loops=1
  • Buffers: shared hit=1
19. 291.850 291.850 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4432_chunk t_9 (cost=0.00..9,631.69 rows=3 width=49) (actual time=26.632..29.185 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=7190
  • Worker 0: actual time=0.003..0.003 rows=0 loops=1
  • Worker 1: actual time=0.219..0.635 rows=28 loops=1
  • Buffers: shared hit=31
  • Worker 2: actual time=0.082..0.204 rows=22 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.058..0.184 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.073..0.221 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=142.683..162.008 rows=21 loops=1
  • Buffers: shared hit=4422
  • Worker 6: actual time=0.040..0.193 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.041..0.041 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.001..0.001 rows=0 loops=1
20. 320.760 320.760 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4433_chunk t_10 (cost=0.00..10,512.85 rows=3 width=50) (actual time=31.456..32.076 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=7832
  • Worker 0: actual time=0.069..0.216 rows=27 loops=1
  • Buffers: shared hit=3
  • Worker 1: actual time=0.053..0.114 rows=13 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.100..0.231 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.061..0.193 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.063..0.191 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.038..0.038 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=314.121..319.588 rows=34 loops=1
  • Buffers: shared hit=7823
  • Worker 8: actual time=0.056..0.183 rows=26 loops=1
  • Buffers: shared hit=1
21. 1,309,404.264 1,309,404.264 ↑ 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=733.964..733.971 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=12590 read=102417 dirtied=2
  • Worker 0: actual time=719.387..719.393 rows=14 loops=184
  • Buffers: shared hit=1279 read=10443
  • Worker 1: actual time=767.170..767.177 rows=19 loops=171
  • Buffers: shared hit=1260 read=9801 dirtied=1
  • Worker 2: actual time=747.894..747.898 rows=9 loops=188
  • Buffers: shared hit=1305 read=10900
  • Worker 3: actual time=771.701..771.707 rows=16 loops=160
  • Buffers: shared hit=1202 read=9337
  • Worker 4: actual time=648.397..648.403 rows=16 loops=204
  • Buffers: shared hit=1421 read=11583
  • Worker 5: actual time=776.119..776.128 rows=22 loops=173
  • Buffers: shared hit=1249 read=9753
  • Worker 6: actual time=700.943..700.952 rows=19 loops=174
  • Buffers: shared hit=1295 read=10187
  • Worker 7: actual time=739.839..739.844 rows=11 loops=184
  • Buffers: shared hit=1261 read=10430 dirtied=1
  • Worker 8: actual time=735.422..735.426 rows=10 loops=182
  • Buffers: shared hit=1301 read=10488
22. 0.664 409.569 ↓ 2.5 720 1

Hash (cost=521.09..521.09 rows=289 width=24) (actual time=409.569..409.569 rows=720 loops=1)

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

Index Scan using client_creative_properties_level0top_level1_level2_level3_l_idx on ccp.client_creative_properties (cost=13.95..521.09 rows=289 width=24) (actual time=39.005..408.905 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=583 read=46