explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bg1J

Settings
# exclusive inclusive rows x rows loops node
1. 69.404 32,690.383 ↑ 1,000.0 100 1

GroupAggregate (cost=32,757,425.13..35,508,425.13 rows=100,000 width=8,826) (actual time=32,620.425..32,690.383 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=15992
2. 21.718 32,620.979 ↑ 29.7 3,369 1

Sort (cost=32,757,425.13..32,762,425.13 rows=100,000 width=8,826) (actual time=32,619.908..32,620.979 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=15992
3. 7.542 32,599.261 ↑ 29.7 3,369 1

Hash Left Join (cost=470,776.59..32,375,116.72 rows=100,000 width=8,826) (actual time=30,827.788..32,599.261 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=15992
4. 1,461.487 32,589.895 ↑ 29.7 3,369 1

Finalize GroupAggregate (cost=470,238.58..32,368,328.71 rows=100,000 width=8,954) (actual time=30,825.795..32,589.895 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=15361
5. 0.000 31,128.408 ↑ 47.7 18,855 1

Gather Merge (cost=470,238.58..6,187,328.71 rows=900,000 width=8,698) (actual time=30,822.633..31,128.408 rows=18,855 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=190819
6. 2,906.330 291,212.770 ↑ 53.0 1,886 10

Partial GroupAggregate (cost=470,235.26..5,843,257.36 rows=100,000 width=8,698) (actual time=28,830.208..29,121.277 rows=1,886 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=190819
  • Worker 0: actual time=30759.818..31151.279 rows=2359 loops=1
  • Buffers: shared hit=20069
  • Worker 1: actual time=29552.984..29889.628 rows=2136 loops=1
  • Buffers: shared hit=15942
  • Worker 2: actual time=28864.344..29100.580 rows=1302 loops=1
  • Buffers: shared hit=21131
  • Worker 3: actual time=29332.092..29617.610 rows=2156 loops=1
  • Buffers: shared hit=31119
  • Worker 4: actual time=27089.113..27347.204 rows=1752 loops=1
  • Buffers: shared hit=13659
  • Worker 5: actual time=28494.741..28852.611 rows=2169 loops=1
  • Buffers: shared hit=11088
  • Worker 6: actual time=29439.318..29686.080 rows=1819 loops=1
  • Buffers: shared hit=24655
  • Worker 7: actual time=27388.993..27620.061 rows=1345 loops=1
  • Buffers: shared hit=18509
  • Worker 8: actual time=27262.704..27637.693 rows=2319 loops=1
  • Buffers: shared hit=19286
7. 166.930 288,306.440 ↑ 58.5 2,686 10

Sort (cost=470,235.26..478,096.36 rows=157,222 width=1,302) (actual time=28,829.090..28,830.644 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: 1482kB
  • Buffers: shared hit=190819
  • Worker 0: actual time=30759.233..30761.929 rows=3763 loops=1
  • Buffers: shared hit=20069
  • Worker 1: actual time=29551.104..29552.633 rows=2715 loops=1
  • Buffers: shared hit=15942
  • Worker 2: actual time=28863.738..28864.795 rows=1838 loops=1
  • Buffers: shared hit=21131
  • Worker 3: actual time=29331.461..29332.634 rows=2641 loops=1
  • Buffers: shared hit=31119
  • Worker 4: actual time=27088.514..27089.883 rows=2915 loops=1
  • Buffers: shared hit=13659
  • Worker 5: actual time=28494.134..28496.066 rows=2890 loops=1
  • Buffers: shared hit=11088
  • Worker 6: actual time=29437.442..29438.654 rows=2595 loops=1
  • Buffers: shared hit=24655
  • Worker 7: actual time=27387.075..27388.167 rows=2044 loops=1
  • Buffers: shared hit=18509
  • Worker 8: actual time=27262.118..27263.875 rows=3465 loops=1
  • Buffers: shared hit=19286
8. 106.548 288,139.510 ↑ 58.5 2,686 10

Nested Loop (cost=5,000.15..147,855.67 rows=157,222 width=1,302) (actual time=230.730..28,813.951 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=190468
  • Worker 0: actual time=300.918..30738.382 rows=3763 loops=1
  • Buffers: shared hit=20030
  • Worker 1: actual time=220.953..29534.962 rows=2715 loops=1
  • Buffers: shared hit=15903
  • Worker 2: actual time=197.912..28853.492 rows=1838 loops=1
  • Buffers: shared hit=21092
  • Worker 3: actual time=304.539..29316.548 rows=2641 loops=1
  • Buffers: shared hit=31080
  • Worker 4: actual time=256.563..27072.854 rows=2915 loops=1
  • Buffers: shared hit=13620
  • Worker 5: actual time=206.343..28478.443 rows=2890 loops=1
  • Buffers: shared hit=11049
  • Worker 6: actual time=235.009..29421.339 rows=2595 loops=1
  • Buffers: shared hit=24616
  • Worker 7: actual time=190.330..27375.354 rows=2044 loops=1
  • Buffers: shared hit=18470
  • Worker 8: actual time=198.092..27243.609 rows=3465 loops=1
  • Buffers: shared hit=19247
9. 1.980 616.290 ↓ 5.7 178 10

Append (cost=0.00..100,450.02 rows=31 width=50) (actual time=18.517..61.629 rows=178 loops=10)

  • Buffers: shared hit=75395
  • Worker 0: actual time=49.286..90.542 rows=185 loops=1
  • Buffers: shared hit=7662
  • Worker 1: actual time=51.912..57.810 rows=180 loops=1
  • Buffers: shared hit=4245
  • Worker 2: actual time=5.243..111.535 rows=174 loops=1
  • Buffers: shared hit=9795
  • Worker 3: actual time=11.255..92.378 rows=207 loops=1
  • Buffers: shared hit=17896
  • Worker 4: actual time=0.049..19.219 rows=164 loops=1
  • Buffers: shared hit=3373
  • Worker 5: actual time=0.049..1.054 rows=173 loops=1
  • Buffers: shared hit=10
  • Worker 6: actual time=6.613..101.433 rows=184 loops=1
  • Buffers: shared hit=12691
  • Worker 7: actual time=7.133..47.744 rows=165 loops=1
  • Buffers: shared hit=7517
  • Worker 8: actual time=16.097..52.794 rows=168 loops=1
  • Buffers: shared hit=8551
10. 0.010 0.010 ↓ 0.0 0 10

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

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

Parallel Seq Scan on _timescaledb_internal._hyper_1_4669_chunk t_1 (cost=0.00..8,944.45 rows=3 width=48) (actual time=8.402..8.481 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=6673
  • Worker 0: actual time=0.002..0.002 rows=0 loops=1
  • Worker 1: actual time=0.064..0.064 rows=0 loops=1
  • Buffers: shared hit=2
  • Worker 2: actual time=5.240..5.303 rows=19 loops=1
  • Buffers: shared hit=303
  • Worker 3: actual time=11.253..11.344 rows=26 loops=1
  • Buffers: shared hit=765
  • Worker 4: actual time=0.046..0.139 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.045..0.144 rows=23 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=6.610..6.626 rows=4 loops=1
  • Buffers: shared hit=378
  • Worker 7: actual time=7.130..7.259 rows=26 loops=1
  • Buffers: shared hit=420
  • Worker 8: actual time=16.095..16.193 rows=26 loops=1
  • Buffers: shared hit=1588
12. 102.110 102.110 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4670_chunk t_2 (cost=0.00..9,265.02 rows=3 width=49) (actual time=10.129..10.211 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=6913
  • Worker 0: actual time=49.280..49.433 rows=38 loops=1
  • Buffers: shared hit=3150
  • Worker 1: actual time=51.844..52.034 rows=29 loops=1
  • Buffers: shared hit=3758
  • Worker 2: actual time=0.033..0.124 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.002..0.002 rows=0 loops=1
  • Worker 4: actual time=0.001..0.002 rows=0 loops=1
  • Worker 5: actual time=0.027..0.107 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.036..0.174 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.005..0.005 rows=0 loops=1
  • Worker 8: actual time=0.025..0.074 rows=13 loops=1
  • Buffers: shared hit=1
13. 44.700 44.700 ↓ 6.3 19 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4672_chunk t_3 (cost=0.00..10,317.89 rows=3 width=51) (actual time=3.972..4.470 rows=19 loops=10)

  • Output: t_3.date, t_3.level0top, t_3.bylevel4s
  • Filter: ((t_3.date >= '2018-12-01'::date) AND (t_3.date <= '2018-12-10'::date) AND (t_3.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14538
  • Buffers: shared hit=7730
  • Worker 0: actual time=0.026..0.122 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.046..0.158 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.120..4.308 rows=15 loops=1
  • Buffers: shared hit=632
  • Worker 4: actual time=0.049..0.226 rows=35 loops=1
  • Buffers: shared hit=5
  • Worker 5: actual time=0.001..0.002 rows=0 loops=1
  • Worker 6: actual time=0.070..0.179 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=39.366..39.575 rows=35 loops=1
  • Buffers: shared hit=7089
  • Worker 8: actual time=0.031..0.123 rows=26 loops=1
  • Buffers: shared hit=1
14. 40.160 40.160 ↓ 5.7 17 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4673_chunk t_4 (cost=0.00..10,464.30 rows=3 width=51) (actual time=3.955..4.016 rows=17 loops=10)

  • Output: t_4.date, t_4.level0top, t_4.bylevel4s
  • Filter: ((t_4.date >= '2018-12-01'::date) AND (t_4.date <= '2018-12-10'::date) AND (t_4.level0top = 'MASTER_PG_NA_3'::text))
  • Rows Removed by Filter: 14682
  • Buffers: shared hit=7851
  • Worker 0: actual time=0.003..0.003 rows=0 loops=1
  • Worker 1: actual time=0.102..0.198 rows=26 loops=1
  • Buffers: shared hit=21
  • Worker 2: actual time=0.049..0.134 rows=26 loops=1
  • Buffers: shared hit=9
  • Worker 3: actual time=38.958..39.048 rows=26 loops=1
  • Buffers: shared hit=7728
  • Worker 4: actual time=0.229..0.283 rows=18 loops=1
  • Buffers: shared hit=75
  • Worker 5: actual time=0.045..0.129 rows=26 loops=1
  • Buffers: shared hit=4
  • Worker 6: actual time=0.067..0.162 rows=26 loops=1
  • Buffers: shared hit=4
  • Worker 7: actual time=0.053..0.068 rows=4 loops=1
  • Buffers: shared hit=4
  • Worker 8: actual time=0.003..0.003 rows=0 loops=1
15. 37.660 37.660 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4674_chunk t_5 (cost=0.00..11,404.58 rows=3 width=50) (actual time=3.698..3.766 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=8791
  • Worker 0: actual time=0.035..0.131 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.001..0.001 rows=0 loops=1
  • Worker 2: actual time=0.033..0.119 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=36.703..36.808 rows=27 loops=1
  • Buffers: shared hit=8766
  • Worker 4: actual time=0.001..0.002 rows=0 loops=1
  • Worker 5: actual time=0.028..0.118 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.005..0.005 rows=0 loops=1
  • Worker 7: actual time=0.044..0.147 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.083..0.163 rows=18 loops=1
  • Buffers: shared hit=20
16. 44.670 44.670 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4676_chunk t_6 (cost=0.00..10,291.46 rows=3 width=50) (actual time=4.398..4.467 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=7682
  • Worker 0: actual time=0.027..0.068 rows=13 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.049..0.155 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.030..0.030 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.029..0.113 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=18.005..18.131 rows=32 loops=1
  • Buffers: shared hit=3289
  • Worker 5: actual time=0.001..0.002 rows=0 loops=1
  • Worker 6: actual time=25.758..25.894 rows=29 loops=1
  • Buffers: shared hit=4387
  • Worker 7: actual time=0.039..0.144 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.040..0.126 rows=26 loops=1
  • Buffers: shared hit=1
17. 40.100 40.100 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4679_chunk t_7 (cost=0.00..10,316.72 rows=3 width=50) (actual time=3.639..4.010 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=7774
  • Worker 0: actual time=0.042..0.158 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.044..0.148 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=36.057..36.473 rows=34 loops=1
  • Buffers: shared hit=7338
  • Worker 3: actual time=0.033..0.114 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.001..0.002 rows=0 loops=1
  • Worker 5: actual time=0.040..0.105 rows=19 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.042..0.089 rows=13 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.001..0.001 rows=0 loops=1
  • Worker 8: actual time=0.026..0.026 rows=0 loops=1
  • Buffers: shared hit=1
18. 36.680 36.680 ↓ 5.7 17 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4681_chunk t_8 (cost=0.00..9,286.06 rows=3 width=48) (actual time=3.588..3.668 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=6944
  • Worker 0: actual time=0.005..0.005 rows=0 loops=1
  • Worker 1: actual time=0.015..0.015 rows=0 loops=1
  • Worker 2: actual time=0.002..0.002 rows=0 loops=1
  • Worker 3: actual time=0.024..0.073 rows=9 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.031..0.130 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.035..0.154 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=0.034..0.191 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.046..0.164 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=35.654..35.778 rows=33 loops=1
  • Buffers: shared hit=6938
19. 114.860 114.860 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4683_chunk t_9 (cost=0.00..9,554.69 rows=3 width=48) (actual time=10.855..11.486 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=7113
  • Worker 0: actual time=39.681..40.306 rows=29 loops=1
  • Buffers: shared hit=4507
  • Worker 1: actual time=0.163..4.654 rows=21 loops=1
  • Buffers: shared hit=460
  • Worker 2: actual time=68.308..69.124 rows=30 loops=1
  • Buffers: shared hit=2141
  • Worker 3: actual time=0.174..0.277 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.050..0.137 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.001..0.001 rows=0 loops=1
  • Worker 6: actual time=0.064..0.064 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 7: actual time=0.065..0.154 rows=22 loops=1
  • Buffers: shared hit=1
  • Worker 8: actual time=0.043..0.145 rows=26 loops=1
  • Buffers: shared hit=1
20. 68.550 68.550 ↓ 6.0 18 10

Parallel Seq Scan on _timescaledb_internal._hyper_1_4684_chunk t_10 (cost=0.00..10,604.85 rows=3 width=52) (actual time=6.789..6.855 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=7924
  • Worker 0: actual time=0.030..0.120 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 1: actual time=0.032..0.131 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 2: actual time=0.024..0.062 rows=13 loops=1
  • Buffers: shared hit=1
  • Worker 3: actual time=0.027..0.106 rows=26 loops=1
  • Buffers: shared hit=1
  • Worker 4: actual time=0.019..0.019 rows=0 loops=1
  • Buffers: shared hit=1
  • Worker 5: actual time=0.040..0.128 rows=27 loops=1
  • Buffers: shared hit=1
  • Worker 6: actual time=67.682..67.817 rows=34 loops=1
  • Buffers: shared hit=7917
  • Worker 7: actual time=0.001..0.001 rows=0 loops=1
  • Worker 8: actual time=0.001..0.001 rows=0 loops=1
21. 287,416.672 287,416.672 ↑ 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=161.104..161.108 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=115073
  • Worker 0: actual time=165.593..165.599 rows=20 loops=185
  • Buffers: shared hit=12368
  • Worker 1: actual time=163.704..163.708 rows=15 loops=180
  • Buffers: shared hit=11658
  • Worker 2: actual time=165.143..165.146 rows=11 loops=174
  • Buffers: shared hit=11297
  • Worker 3: actual time=141.131..141.135 rows=13 loops=207
  • Buffers: shared hit=13184
  • Worker 4: actual time=164.898..164.903 rows=18 loops=164
  • Buffers: shared hit=10247
  • Worker 5: actual time=164.552..164.556 rows=17 loops=173
  • Buffers: shared hit=11039
  • Worker 6: actual time=159.294..159.298 rows=14 loops=184
  • Buffers: shared hit=11925
  • Worker 7: actual time=165.476..165.480 rows=12 loops=165
  • Buffers: shared hit=10953
  • Worker 8: actual time=161.784..161.789 rows=21 loops=168
  • Buffers: shared hit=10696
22. 0.463 1.824 ↓ 2.5 720 1

Hash (cost=520.67..520.67 rows=289 width=24) (actual time=1.823..1.824 rows=720 loops=1)

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

Index Scan using client_creative_properties_level0top_level1_level2_level3_l_idx on ccp.client_creative_properties (cost=13.95..520.67 rows=289 width=24) (actual time=0.229..1.361 rows=720 loops=1)

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