explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tId

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather Motion 128:1 (slice40; segments: 128) (cost=379,319.14..379,319.33 rows=19 width=6,677) (actual rows= loops=)

  • Rows out: 36928 rows at destination with 16015 ms to first row, 16074 ms to end, start offset by 47332 ms.
  • (slice0) Executor memory: 25078K bytes.
  • (slice1) Executor memory: 18239K bytes avg x 128 workers, 18239K bytes max (seg0).
  • (slice2) Executor memory: 18214K bytes avg x 128 workers, 18214K bytes max (seg0).
  • (slice3) Executor memory: 18214K bytes avg x 128 workers, 18214K bytes max (seg0).
  • (slice4) Executor memory: 20232K bytes avg x 128 workers, 20290K bytes max (seg6). Work_mem: 642K bytes max.
  • (slice5) * Executor memory: 26998K bytes avg x 128 workers, 27292K bytes max (seg78). Work_mem: 3928K bytes max, 8236K bytes wanted.
  • (slice6) Executor memory: 18214K bytes avg x 128 workers, 18214K bytes max (seg0).
  • (slice7) Executor memory: 19050K bytes avg x 128 workers, 20009K bytes max (seg51). Work_mem: 37K bytes max.
  • (slice8) Executor memory: 18239K bytes avg x 128 workers, 18239K bytes max (seg0).
  • (slice9) Executor memory: 18942K bytes avg x 128 workers, 20057K bytes max (seg41). Work_mem: 1K bytes max.
  • (slice10) Executor memory: 18239K bytes avg x 128 workers, 18239K bytes max (seg0).
  • (slice11) Executor memory: 18955K bytes avg x 128 workers, 20097K bytes max (seg44). Work_mem: 1K bytes max.
  • (slice12) Executor memory: 18256K bytes avg x 128 workers, 18256K bytes max (seg0).
  • (slice13) Executor memory: 18957K bytes avg x 128 workers, 20050K bytes max (seg45). Work_mem: 1K bytes max.
  • (slice14) Executor memory: 18272K bytes avg x 128 workers, 18272K bytes max (seg0).
  • (slice15) Executor memory: 19011K bytes avg x 128 workers, 20018K bytes max (seg15). Work_mem: 1K bytes max.
  • (slice16) * Executor memory: 23194K bytes avg x 128 workers, 35464K bytes max (seg119). Work_mem: 5702K bytes max, 23590K bytes wanted.
  • (slice17) Executor memory: 18289K bytes avg x 128 workers, 18318K bytes max (seg4).
  • (slice18) Executor memory: 20051K bytes avg x 128 workers, 20118K bytes max (seg49). Work_mem: 382K bytes max.
  • (slice19) Executor memory: 18287K bytes avg x 128 workers, 18287K bytes max (seg0).
  • (slice20) Executor memory: 19390K bytes avg x 128 workers, 19442K bytes max (seg125). Work_mem: 220K bytes max.
  • (slice21) Executor memory: 18720K bytes avg x 128 workers, 19749K bytes max (seg10). Work_mem: 10K bytes max.
  • (slice22) Executor memory: 19069K bytes avg x 128 workers, 19072K bytes max (seg0). Work_mem: 66K bytes max.
  • (slice23) Executor memory: 19403K bytes avg x 128 workers, 20386K bytes max (seg10). Work_mem: 220K bytes max.
  • (slice24) Executor memory: 18319K bytes avg x 128 workers, 18319K bytes max (seg0).
  • (slice25) Executor memory: 19364K bytes avg x 128 workers, 19364K bytes max (seg0).
  • (slice26) Executor memory: 18336K bytes avg x 128 workers, 18336K bytes max (seg0).
  • (slice27) Executor memory: 18344K bytes avg x 128 workers, 18344K bytes max (seg0).
  • (slice28) * Executor memory: 25572K bytes avg x 128 workers, 25641K bytes max (seg110). Work_mem: 942K bytes max, 6301K bytes wanted.
  • (slice29) Executor memory: 18889K bytes avg x 128 workers, 19902K bytes max (seg3). Work_mem: 98K bytes max.
  • (slice30) Executor memory: 18402K bytes avg x 128 workers, 18402K bytes max (seg0).
  • (slice31) Executor memory: 19219K bytes avg x 128 workers, 19791K bytes max (seg93). Work_mem: 60K bytes max.
  • (slice32) Executor memory: 19027K bytes avg x 128 workers, 19951K bytes max (seg92). Work_mem: 28K bytes max.
  • (slice33) Executor memory: 18392K bytes avg x 128 workers, 18392K bytes max (seg0).
  • (slice34) Executor memory: 18955K bytes avg x 128 workers, 19972K bytes max (seg35). Work_mem: 1K bytes max.
  • (slice35) Executor memory: 18409K bytes avg x 128 workers, 18409K bytes max (seg0).
  • (slice36) Executor memory: 18417K bytes avg x 128 workers, 18417K bytes max (seg0).
  • (slice37) Executor memory: 18425K bytes avg x 128 workers, 18425K bytes max (seg0).
  • (slice38) Executor memory: 22405K bytes avg x 128 workers, 23527K bytes max (seg35). Work_mem: 655K bytes max.
  • (slice39) Executor memory: 21850K bytes avg x 128 workers, 36804K bytes max (seg41). Work_mem: 320K bytes max.
  • (slice40) Executor memory: 18009K bytes avg x 128 workers, 18049K bytes max (seg67).
  • Memory used: 131072K bytes
  • Memory wanted: 3299871K bytes
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=379,319.14..379,319.33 rows=1 width=6,677) (actual rows= loops=)

  • Group By: organization_data.organization_code, "?column2?", pll.quantity_received, wen.wip_entity_name, "?column5?", "?column6?", "?column7?", "?column8?", "?column9?", "?column10?", "?column11?", fnu2.description, aps.segment1, "?column14?", ph.segment1, pl.line_num, "?column17?", misd.subinventory_code, msib.segment1, "?column20?", pl.item_description, organization_data.organization_name, "?column23?", pl.unit_price, "?column25?", "?column26?", "?column27?", lmbc.meaning, msib.minimum_order_quantity, msib.maximum_order_quantity, "?column31?", msib.planner_code, user_names.person_id, "?column34?", abc_classes.abc_class_name, "?column36?", lity.meaning, "?column38?", "?column39?", "?column40?", "?column41?", organization_data.organization_name, "?column43?", msib.planner_code, sup.exception_message, "?column46?", sup.exception_type, "?column48?", sup.order_type, "?column50?", "?column51?", "?column52?", "?column53?", "?column54?", "?column55?", "?column56?", "?column57?", "?column58?", "?column59?", "?column60?", "?column61?", apss.vendor_site_code, "?column63?", "?column64?", "?column65?", "?column66?", "?column67?", "?column68?", "?column69?", "?column70?", "?column71?", "?column72?", "?column73?", "?column74?", "?column75?", "?column76?", "?column77?", "?column78?", pll.closed_code, "?column80?", lity.meaning, ph.type_lookup_code, pll.shipment_num, ph.currency_code, "?column85?", r.segment1, "?column87?", "?column88?", "?column89?", "?column90?", ppa.name, "?column92?", ppa.segment1, "?column94?", "?column95?", "?column96?", "?column97?", "?column98?", onbd.need_by_date, "?column100?", "?column101?", "?column102?", "?column103?", "?column104?", "?column105?", "?column106?", "?column107?", "?column108?", "?column109?", pll.unit_meas_lookup_code, "?column111?", mos_ext.supplier_ready_to_ship, mos_ext.leg_1_scheduled_pickup, mos_ext.leg_1_actual_pickup, mos_ext.leg_1_scheduled_delivery, mos_ext.leg_1_actual_delivery, mos_ext.leg_2_scheduled_pickup, mos_ext.leg_2_actual_pickup, mos_ext.leg_2_scheduled_delivery, mos_ext.leg_2_actual_delivery, mos_ext.leg_3_scheduled_pickup, mos_ext.leg_3_actual_pickup, mos_ext.leg_3_scheduled_delivery, mos_ext.leg_3_actual_delivery
  • Rows out: Avg 288.5 rows x 128 workers. Max 336 rows (seg67) with 9635 ms to first row, 9637 ms to end, start offset by 53713 ms.
  • Executor memory: 290K bytes avg, 361K bytes max (seg27).
3. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice39; segments: 128) (cost=329,112.76..379,313.06 rows=1 width=6,677) (actual rows= loops=)

  • Hash Key: organization_data.organization_code, unnamed_attr_2, pll.quantity_received, wen.wip_entity_name, unnamed_attr_5, unnamed_attr_5, unnamed_attr_5, unnamed_attr_5, unnamed_attr_5, unnamed_attr_5, unnamed_attr_11, fnu2.description, aps.segment1, unnamed_attr_5, ph.segment1, pl.line_num, unnamed_attr_5, misd.subinventory_code, msib.segment1, unnamed_attr_20, pl.item_description, organization_data.organization_name, unnamed_attr_20, pl.unit_price, unnamed_attr_25, unnamed_attr_26, unnamed_attr_5, lmbc.meaning, msib.minimum_order_quantity, msib.maximum_order_quantity, unnamed_attr_5, msib.planner_code, user_names.person_id, unnamed_attr_5, abc_classes.abc_class_name, unnamed_attr_36, lity.meaning, unnamed_attr_38, unnamed_attr_39, unnamed_attr_40, unnamed_attr_41, organization_data.organization_name, unnamed_attr_43, msib.planner_code, sup.exception_message, unnamed_attr_5, sup.exception_type, unnamed_attr_48, sup.order_type, unnamed_attr_50, unnamed_attr_51, unnamed_attr_52, unnamed_attr_53, unnamed_attr_51, unnamed_attr_55, unnamed_attr_56, unnamed_attr_57, unnamed_attr_58, unnamed_attr_59, unnamed_attr_60, unnamed_attr_5, apss.vendor_site_code, unnamed_attr_63, unnamed_attr_64, unnamed_attr_65, unnamed_attr_66, unnamed_attr_5, unnamed_attr_5, unnamed_attr_69, unnamed_attr_70, unnamed_attr_5, unnamed_attr_72, unnamed_attr_73, unnamed_attr_74, unnamed_attr_75, unnamed_attr_76, unnamed_attr_77, unnamed_attr_78, pll.closed_code, unnamed_attr_80, lity.meaning, ph.type_lookup_code, pll.shipment_num, ph.currency_code, unnamed_attr_85, r.segment1, unnamed_attr_87, unnamed_attr_88, unnamed_attr_5, unnamed_attr_5, ppa.name, unnamed_attr_5, ppa.segment1, unnamed_attr_94, unnamed_attr_95, unnamed_attr_5, unnamed_attr_5, unnamed_attr_5, onbd.need_by_date, unnamed_attr_100, unnamed_attr_85, unnamed_attr_85, unnamed_attr_103, unnamed_attr_104, unnamed_attr_103, unnamed_attr_103, unnamed_attr_107, unnamed_attr_108, unnamed_attr_103, pll.unit_meas_lookup_code, unnamed_attr_111, mos_ext.supplier_ready_to_ship, mos_ext.leg_1_scheduled_pickup, mos_ext.leg_1_actual_pickup, mos_ext.leg_1_scheduled_delivery, mos_ext.leg_1_actual_delivery, mos_ext.leg_2_scheduled_pickup, mos_ext.leg_2_actual_pickup, mos_ext.leg_2_scheduled_delivery, mos_ext.leg_2_actual_delivery, mos_ext.leg_3_scheduled_pickup, mos_ext.leg_3_actual_pickup, mos_ext.leg_3_scheduled_delivery, mos_ext.leg_3_actual_delivery
  • Rows out: Avg 288.5 rows x 128 workers at destination. Max 336 rows (seg67) with 8636 ms to first row, 9628 ms to end, start offset by 53713 ms.
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=329,112.76..379,312.68 rows=1 width=6,677) (actual rows= loops=)

  • Group By: organization_data.organization_code, pll.need_by_date::date, pll.quantity_received, wen.wip_entity_name, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, pll.creation_date::date, fnu2.description, aps.segment1, NULL::text, ph.segment1, pl.line_num, NULL::text, misd.subinventory_code, msib.segment1, round(pll.quantity, 3), pl.item_description, organization_data.organization_name, round(pll.quantity, 3), pl.unit_price, pll.quantity * pl.unit_price, CASE WHEN length(btrim(pasup.vendor_name::text)) = 0 OR pasup.vendor_name IS NULL THEN 'No Source'::character varying ELSE pasup.vendor_name END, NULL::text, lmbc.meaning, msib.minimum_order_quantity, msib.maximum_order_quantity, NULL::text, msib.planner_code, user_names.person_id, NULL::text, abc_classes.abc_class_name, COALESCE(pasup.processing_lead_time, COALESCE(msib.full_lead_time, 0::numeric)), lity.meaning, COALESCE(msib.postprocessing_lead_time, 0::numeric), COALESCE(pasup.processing_lead_time, COALESCE(msib.full_lead_time, 0::numeric)) + msc_si.postprocessing_lead_time::numeric, round(COALESCE(material_cost.item_cost, 0::numeric), 2), 1, organization_data.organization_name, CASE WHEN user_names.full_name IS NULL OR length(btrim(user_names.full_name::text)) = 0 THEN 'Not Assigned'::character varying ELSE user_names.full_name END, msib.planner_code, sup.exception_message, NULL::text, sup.exception_type, CASE WHEN date_part('dow'::text, (CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END, sup.order_type, CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END, round(CASE WHEN sup.new_order_quantity IS NOT NULL THEN sup.new_order_quantity ELSE (pll.quantity - pll.quantity_received - pll.quantity_cancelled)::double precision END::numeric, 3), CASE WHEN ph.currency_code::text = 'USD'::text THEN 1::double precision WHEN curr_ref.from_currency IS NULL THEN 1::double precision ELSE curr_ref.conversion_rate END, pll.promised_date::date, round(CASE WHEN sup.new_order_quantity IS NOT NULL THEN sup.new_order_quantity ELSE (pll.quantity - pll.quantity_received - pll.quantity_cancelled)::double precision END::numeric, 3), pl.unit_price::double precision * CASE WHEN ph.currency_code::text = 'USD'::text THEN 1::double precision WHEN curr_ref.from_currency IS NULL THEN 1::double precision ELSE curr_ref.conversion_rate END, round(COALESCE(material_cost.item_cost, 0::numeric) * CASE WHEN organization_data.currency_code::text = 'USD'::text THEN 1::double precision WHEN curr_ref_org.from_currency IS NULL THEN 1::double precision ELSE curr_ref_org.conversion_rate END::numeric, 2), round((pl.unit_price::double precision * CASE WHEN sup.new_order_quantity IS NOT NULL THEN sup.new_order_quantity ELSE (pll.quantity - pll.quantity_received - pll.quantity_cancelled)::double precision END)::numeric, 3), round(COALESCE(material_cost.item_cost, 0::numeric) * CASE WHEN sup.new_order_quantity IS NOT NULL THEN sup.new_order_quantity ELSE (pll.quantity - pll.quantity_received - pll.quantity_cancelled)::double precision END::numeric, 2), round((pl.unit_price::double precision * CASE WHEN sup.new_order_quantity IS NOT NULL THEN sup.new_order_quantity ELSE (pll.quantity - pll.quantity_received - pll.quantity_cancelled)::double precision END * CASE WHEN ph.currency_code::text = 'USD'::text THEN 1::double precision WHEN curr_ref.from_currency IS NULL THEN 1::double precision ELSE curr_ref.conversion_rate END)::numeric, 3), round(COALESCE(material_cost.item_cost, 0::numeric) * CASE WHEN sup.new_order_quantity IS NOT NULL THEN sup.new_order_quantity ELSE (pll.quantity - pll.quantity_received - pll.quantity_cancelled)::double precision END::numeric * CASE WHEN organization_data.currency_code::text = 'USD'::text THEN 1::double precision WHEN curr_ref_org.from_currency IS NULL THEN 1::double precision ELSE curr_ref_org.conversion_rate END::numeric, 2), NULL::text, apss.vendor_site_code, CASE WHEN '2019-03-08'::date > CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END THEN '2019-03-08'::date - CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END ELSE 0 END, CASE WHEN ('2019-03-08'::date - CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END) >= 60 THEN '60+'::text WHEN ('2019-03-08'::date - CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END) >= 30 THEN '30+'::text WHEN ('2019-03-08'::date - CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END) >= 1 THEN '<30'::text ELSE 'Future'::text END, CASE WHEN (COALESCE(pasup.processing_lead_time, COALESCE(msib.full_lead_time, 0::numeric))::integer - (pll.need_by_date::date - pll.creation_date::date)) > 0 THEN 'Yes'::text ELSE 'No'::text END, CASE WHEN (COALESCE(pasup.processing_lead_time, COALESCE(msib.full_lead_time, 0::numeric))::integer - (pll.need_by_date::date - pll.creation_date::date)) > 0 THEN COALESCE(pasup.processing_lead_time, COALESCE(msib.full_lead_time, 0::numeric))::integer - (pll.need_by_date::date - pll.creation_date::date) ELSE 0 END, NULL::text, NULL::text, CASE sup.exception_message WHEN 'Cancel process'::text THEN 1 WHEN 'Reschedule in'::text THEN 2 WHEN 'Reschedule out'::text THEN 3 WHEN 'Overdue'::text THEN 4 WHEN 'Finish date in the past'::text THEN 5 WHEN 'No Exceptions'::text THEN 6 WHEN 'Excess in individual segment'::text THEN 7 ELSE 0 END, CASE WHEN sup.exception_message = 'Cancel process'::text THEN 'Cancel process'::text WHEN CASE WHEN sup.exception_message = 'Reschedule in'::text OR sup.exception_message = 'Reschedule out'::text THEN CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END < '2019-03-08'::date THEN 'Overdue'::text WHEN sup.exception_message IS NULL THEN 'No Exception'::text WHEN sup.exception_message IS NOT NULL THEN CASE WHEN sup.exception_message = 'Reschedule in'::text THEN 'Reschedule in'::text WHEN sup.exception_message = 'Reschedule out'::text THEN 'Reschedule out'::text WHEN sup.exception_message = 'Cancel process'::text THEN 'Cancel process'::text WHEN sup.exception_message = 'None'::text THEN 'No Exception'::text ELSE 'No Exception'::text END ELSE 'Other'::text END, NULL::text, CASE WHEN aps.vendor_name IS NULL OR length(btrim(aps.vendor_name::text)) = 0 THEN 'No Source'::character varying ELSE aps.vendor_name END, (pll.quantity * pl.unit_price)::double precision * CASE WHEN ph.currency_code::text = 'USD'::text THEN 1::double precision WHEN curr_ref.from_currency IS NULL THEN 1::double precision ELSE curr_ref.conversion_rate END, 'racesbi_ods'::text, 'N/A'::text, '2019-03-08 12:36:41.472662'::timestamp without time zone, CASE WHEN sup.exception_message = 'Cancel process'::text THEN 'Action Required'::text WHEN CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END > '2019-03-08'::date THEN CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END < '2019-03-01'::date THEN 'Action Required'::text WHEN (CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END - CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END > '2019-03-08'::date THEN CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END) > 7 THEN 'Action Required'::text WHEN (date_part('year'::text, CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END::timestamp without time zone)::text || date_part('quarter'::text, CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END::timestamp without time zone)::text) > (date_part('year'::text, CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END::timestamp without time zone)::text || date_part('quarter'::text, CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END::timestamp without time zone)::text) OR (date_part('year'::text, (CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END + CASE WHEN CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE apt.due_days END < 5::numeric THEN CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE apt.due_days END ELSE CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE apt.due_days END + (floor(CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE apt.due_days END::numeric(18,0) / 5::numeric) * 2::numeric)::numeric(18,0) END::integer)::timestamp without time zone)::text || date_part('quarter'::text, (CASE WHEN sup.exception_message = 'None'::text OR sup.exception_message IS NULL OR sup.exception_message = 'Cancel process'::text THEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END WHEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END > '2019-03-08'::date THEN CASE WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 6::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 1 WHEN date_part('dow'::text, (sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer))::timestamp without time zone) = 0::double precision THEN sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) - 2 ELSE sup.new_dock_date::date + (COALESCE(msib.postprocessing_lead_time, 0::numeric)::integer + ((subplan))::integer) END WHEN CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END >= '2019-03-08'::date THEN '2019-03-08'::date ELSE CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END END + CASE WHEN CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END < 5::numeric THEN CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END ELSE CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END + (floor(CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END::numeric(18,0) / 5::numeric) * 2::numeric)::numeric(18,0) END::integer)::timestamp without time zone)::text) > (date_part('year'::text, (CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END + CASE WHEN CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END < 5::numeric THEN CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END ELSE CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END + (floor(CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END::numeric(18,0) / 5::numeric) * 2::numeric)::numeric(18,0) END::integer)::timestamp without time zone)::text || date_part('quarter'::text, (CASE WHEN pll.promised_date IS NOT NULL THEN pll.promised_date::date ELSE pll.need_by_date::date END + CASE WHEN CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END < 5::numeric THEN CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END ELSE CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END + (floor(CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END::numeric(18,0) / 5::numeric) * 2::numeric)::numeric(18,0) END::integer)::timestamp without time zone)::text) THEN 'Action Required'::text ELSE 'No Error'::text END, CASE WHEN apt.due_days = 0::numeric THEN 30::numeric ELSE COALESCE(apt.due_days, 30::numeric) END, pll.closed_code, 'Not Assigned'::text, lity.meaning, ph.type_lookup_code, pll.shipment_num, ph.currency_code, NULL::date, r.segment1, CASE WHEN lmpc.meaning IS NULL OR length(btrim(lmpc.meaning::text)) = 0 THEN 'Not Assigned'::character varying ELSE lmpc.meaning END, CASE WHEN ph.type_lookup_code::text = 'BLANKET'::text THEN CASE WHEN ph.approved_flag::text = 'Y'::text AND pll.approved_flag::text = 'Y'::text AND pra.approved_flag::text = 'Y'::text THEN 'Approved'::text WHEN ph.approved_flag::text = 'F'::text OR pll.approved_flag::text = 'F'::text OR pra.approved_flag::text = 'F'::text THEN 'Rejected'::text WHEN ph.approved_flag::text = 'R'::text OR pll.approved_flag::text = 'R'::text OR pra.approved_flag::text = 'R'::text THEN 'Requires Approval'::text ELSE 'In Process'::text END ELSE CASE WHEN ph.approved_flag::text = 'Y'::text AND pll.approved_flag::text = 'Y'::text THEN 'Approved'::text WHEN ph.approved_flag::text = 'F'::text OR pll.approved_flag::text = 'F'::text THEN 'Rejected'::text WHEN ph.approved_flag::text = 'R'::text OR pll.approved_flag::text = 'R'::text THEN 'Requires Approval'::text ELSE 'In Process'::text END END, NULL::text, NULL::text, ppa.name, NULL::text, ppa.segment1, COALESCE(ph.attribute2, 'Not assigned'::character varying), pra.release_num::character varying, NULL::text, NULL::text, NULL::text, onbd.need_by_date, NULL::numeric, NULL::date, NULL::date, NULL::character varying, CASE WHEN sup.order_type = ANY ('{8,11,12}'::double precision[]) THEN 'LA'::character varying ELSE NULL::character varying END, NULL::character varying, NULL::character varying, CASE WHEN length(pll.attribute1::text) = 9 AND ("substring"(pll.attribute1::text, 4, 3) = ANY ('{JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC}'::text[])) THEN to_char(to_date(pll.attribute1::text, 'dd-mon-yy'::text)::timestamp with time zone, 'yyyy-mm-dd'::text)::character varying WHEN length(pll.attribute1::text) = 11 AND ("substring"(pll.attribute1::text, 4, 3) = ANY ('{JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC}'::text[])) THEN to_char(to_date(pll.attribute1::text, 'dd-mon-yyyy'::text)::timestamp with time zone, 'yyyy-mm-dd'::text)::character varying ELSE pll.attribute1 END, CASE WHEN length(pll.attribute2::text) = 9 AND ("substring"(pll.attribute2::text, 4, 3) = ANY ('{JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC}'::text[])) THEN to_char(to_date(pll.attribute2::text, 'dd-mon-yy'::text)::timestamp with time zone, 'yyyy-mm-dd'::text)::character varying WHEN length(pll.attribute2::text) = 11 AND ("substring"(pll.attribute2::text, 4, 3) = ANY ('{JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC}'::text[])) THEN to_char(to_date(pll.attribute2::text, 'dd-mon-yyyy'::text)::timestamp with time zone, 'yyyy-mm-dd'::text)::character varying ELSE pll.attribute2 END, NULL::character varying, pll.unit_meas_lookup_code, COALESCE(enovia.qual_status, 'Not Qualified'::character varying), mos_ext.supplier_ready_to_ship, mos_ext.leg_1_scheduled_pickup, mos_ext.leg_1_actual_pickup, mos_ext.leg_1_scheduled_delivery, mos_ext.leg_1_actual_delivery, mos_ext.leg_2_scheduled_pickup, mos_ext.leg_2_actual_pickup, mos_ext.leg_2_scheduled_delivery, mos_ext.leg_2_actual_delivery, mos_ext.leg_3_scheduled_pickup, mos_ext.leg_3_actual_pickup, mos_ext.leg_3_scheduled_delivery, mos_ext.leg_3_actual_delivery
  • Rows out: Avg 288.5 rows x 128 workers. Max 695 rows (seg4) with 13935 ms to first row, 13937 ms to end, start offset by 48430 ms.
  • Executor memory: 291K bytes avg, 617K bytes max (seg4).
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=278,262.03..329,106.81 rows=1 width=4,879) (actual rows= loops=)

  • Hash Cond: ph.po_header_id = onbd.po_header_id AND pll.line_location_id = onbd.line_location_id
  • Rows out: Avg 528.5 rows x 128 workers. Max 1390 rows (seg4) with 11736 ms to first row, 13908 ms to end, start offset by 48430 ms.
  • Executor memory: 260K bytes avg, 320K bytes max (seg4).
  • Work_mem used: 260K bytes avg, 320K bytes max (seg4). Workfile: (0 spilling)
  • (seg4) Hash chain length 2.2 avg, 13 max, using 2666 of 4111 buckets.
  • (seg41) Hash chain length 2.1 avg, 12 max, using 2443 of 4111 buckets.
6. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice38; segments: 128) (cost=261,575.30..261,661.57 rows=1 width=4,935) (actual rows= loops=)

  • Hash Key: ph.po_header_id
  • Rows out: Avg 371.1 rows x 128 workers at destination. Max 836 rows (seg4) with 11719 ms to first row, 13253 ms to end, start offset by 48442 ms.
7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=261,575.30..261,661.19 rows=1 width=4,935) (actual rows= loops=)

  • Hash Cond: ph.created_by = fnu.user_id
  • Rows out: Avg 3958.2 rows x 12 workers. Max 25971 rows (seg19) with 9896 ms to first row, 11623 ms to end, start offset by 49820 ms.
  • Executor memory: 403K bytes avg, 403K bytes max (seg0).
  • Work_mem used: 403K bytes avg, 403K bytes max (seg0). Workfile: (0 spilling)
  • (seg19) Hash chain length 3.3 avg, 10 max, using 3929 of 4111 buckets.
  • (seg35) Hash chain length 3.3 avg, 10 max, using 3929 of 4111 buckets.
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=261,571.41..261,657.05 rows=1 width=4,967) (actual rows= loops=)

  • Hash Cond: pll.created_by = fnu2.user_id
  • Rows out: Avg 3958.2 rows x 12 workers. Max 25971 rows (seg19) with 1661 ms to first row, 3129 ms to end, start offset by 58055 ms.
  • Executor memory: 655K bytes avg, 655K bytes max (seg0).
  • Work_mem used: 655K bytes avg, 655K bytes max (seg0). Workfile: (0 spilling)
  • (seg19) Hash chain length 12.5 avg, 25 max, using 1033 of 1033 buckets.
  • (seg35) Hash chain length 12.5 avg, 25 max, using 1033 of 1033 buckets.
9. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=261,567.52..261,652.92 rows=1 width=4,501) (actual rows= loops=)

  • Hash Cond: ph.currency_code::text = curr_ref.from_currency::text
  • Rows out: Avg 3958.2 rows x 12 workers. Max 25971 rows (seg19) with 1642 ms to first row, 2755 ms to end, start offset by 58074 ms.
  • Executor memory: 1K bytes avg, 1K bytes max (seg46).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg46). Workfile: (0 spilling)
  • (seg19) Hash chain length 1.0 avg, 1 max, using 1 of 4111 buckets.
  • (seg35) Hash chain length 1.0 avg, 1 max, using 2 of 4111 buckets.
  • (seg46) Hash chain length 1.0 avg, 1 max, using 5 of 4111 buckets.
10. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice34; segments: 128) (cost=261,468.51..261,553.66 rows=1 width=4,489) (actual rows= loops=)

  • Hash Key: ph.currency_code::text
  • Rows out: Avg 3958.2 rows x 12 workers at destination. Max 25971 rows (seg19) with 1601 ms to first row, 2223 ms to end, start offset by 58115 ms.
11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=261,468.51..261,553.28 rows=1 width=4,489) (actual rows= loops=)

  • Hash Cond: organization_data.currency_code::text = curr_ref_org.from_currency::text
  • Rows out: Avg 6785.4 rows x 7 workers. Max 23105 rows (seg19) with 9503 ms to first row, 10035 ms to end, start offset by 50210 ms.
  • Executor memory: 1K bytes avg, 1K bytes max (seg46).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg46). Workfile: (0 spilling)
  • (seg19) Hash chain length 1.0 avg, 1 max, using 1 of 4111 buckets.
  • (seg35) Hash chain length 1.0 avg, 1 max, using 2 of 4111 buckets.
  • (seg46) Hash chain length 1.0 avg, 1 max, using 5 of 4111 buckets.
12. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice32; segments: 128) (cost=261,369.50..261,453.99 rows=1 width=4,477) (actual rows= loops=)

  • Hash Key: organization_data.currency_code::text
  • Rows out: Avg 6785.4 rows x 7 workers at destination. Max 23105 rows (seg19) with 1609 ms to first row, 2048 ms to end, start offset by 58104 ms.
13. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=261,369.50..261,453.61 rows=1 width=4,477) (actual rows= loops=)

  • Hash Cond: ph.agent_id = user_names.person_id
  • Rows out: Avg 659.7 rows x 72 workers. Max 3628 rows (seg97) with 3924 ms to first row, 4360 ms to end, start offset by 55781 ms.
  • Executor memory: 27K bytes avg, 28K bytes max (seg31).
  • Work_mem used: 27K bytes avg, 28K bytes max (seg31). Workfile: (0 spilling)
  • (seg97) Hash chain length 1.1 avg, 3 max, using 439 of 2063 buckets.
14. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice31; segments: 128) (cost=259,813.98..259,897.81 rows=1 width=4,465) (actual rows= loops=)

  • Hash Key: ph.agent_id
  • Rows out: Avg 659.7 rows x 72 workers at destination. Max 3628 rows (seg97) with 3923 ms to first row, 4347 ms to end, start offset by 55782 ms.
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=259,813.98..259,897.43 rows=1 width=4,465) (actual rows= loops=)

  • Hash Cond: msib.organization_id = misd.organization_id AND msib.inventory_item_id = misd.inventory_item_id
  • Rows out: Avg 371.1 rows x 128 workers. Max 1242 rows (seg71) with 5529 ms to first row, 5951 ms to end, start offset by 54183 ms.
  • Executor memory: 2K bytes avg, 3K bytes max (seg51).
  • Work_mem used: 2K bytes avg, 3K bytes max (seg51). Workfile: (0 spilling)
  • (seg51) Hash chain length 1.0 avg, 2 max, using 40 of 1033 buckets.
  • (seg71) Hash chain length 1.0 avg, 1 max, using 36 of 1033 buckets.
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=259,812.95..259,896.11 rows=1 width=4,491) (actual rows= loops=)

  • Hash Cond: msib.inventory_item_id = abc_classes.inventory_item_id AND msib.organization_id = abc_classes.organization_id
  • Rows out: Avg 371.1 rows x 128 workers. Max 1242 rows (seg71) with 1612 ms to first row, 2032 ms to end, start offset by 58101 ms.
  • Executor memory: 57K bytes avg, 60K bytes max (seg57).
  • Work_mem used: 57K bytes avg, 60K bytes max (seg57). Workfile: (0 spilling)
  • (seg57) Hash chain length 1.1 avg, 4 max, using 1071 of 4111 buckets.
  • (seg71) Hash chain length 1.1 avg, 4 max, using 1002 of 4111 buckets.
17. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice29; segments: 128) (cost=255,750.95..255,833.82 rows=1 width=4,488) (actual rows= loops=)

  • Hash Key: msib.inventory_item_id, msib.organization_id
  • Rows out: Avg 371.1 rows x 128 workers at destination. Max 1242 rows (seg71) with 1611 ms to first row, 2026 ms to end, start offset by 58102 ms.
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=255,750.95..255,833.44 rows=1 width=4,488) (actual rows= loops=)

  • Hash Cond: msib.organization_id = pasup.using_organization_id AND msib.inventory_item_id = pasup.item_id AND ph.vendor_id = pasup.vendor_id AND ph.vendor_site_id = pasup.vendor_site_id
  • Rows out: Avg 371.1 rows x 128 workers. Max 3563 rows (seg3) with 11327 ms to first row, 11807 ms to end, start offset by 48304 ms.
  • Executor memory: 8K bytes avg, 98K bytes max (seg97).
  • Work_mem used: 8K bytes avg, 98K bytes max (seg97). Workfile: (0 spilling)
  • (seg3) Hash chain length 1.0 avg, 2 max, using 138 of 2063 buckets.
  • (seg97) Hash chain length 1.3 avg, 4 max, using 744 of 2063 buckets.
19. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice28; segments: 128) (cost=255,334.22..255,416.32 rows=1 width=4,518) (actual rows= loops=)

  • Hash Key: ph.vendor_id
  • Rows out: Avg 371.1 rows x 128 workers at destination. Max 3563 rows (seg3) with 11326 ms to first row, 11790 ms to end, start offset by 48305 ms.
20. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=255,334.22..255,415.94 rows=1 width=4,518) (actual rows= loops=)

  • Hash Cond: ph.terms_id = apt.term_id
  • Rows out: Avg 371.1 rows x 128 workers. Max 19822 rows (seg101) with 3237 ms to first row, 3446 ms to end, start offset by 56449 ms.
  • Executor memory: 72K bytes avg, 72K bytes max (seg0).
  • Work_mem used: 72K bytes avg, 72K bytes max (seg0). Workfile: (0 spilling)
  • (seg101) Hash chain length 1.3 avg, 5 max, using 982 of 2063 buckets.
21. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=255,330.33..255,411.81 rows=1 width=4,518) (actual rows= loops=)

  • Hash Cond: msib.segment1::text = enovia.item::text AND ph.segment1::text = enovia.po_number::text AND aps.segment1::text = enovia.gsl
  • Rows out: Avg 371.1 rows x 128 workers. Max 19822 rows (seg101) with 1633 ms to first row, 1824 ms to end, start offset by 58054 ms.
  • Executor memory: 266K bytes avg, 266K bytes max (seg0).
  • Work_mem used: 266K bytes avg, 266K bytes max (seg0). Workfile: (0 spilling)
  • (seg101) Hash chain length 3.9 avg, 11 max, using 1003 of 1033 buckets.
22. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=255,325.80..255,406.94 rows=1 width=4,486) (actual rows= loops=)

  • Hash Cond: ph.segment1::text = mos_ext.po_num::text AND pl.line_num::text = mos_ext.po_line::text AND pll.shipment_num::text = mos_ext.po_ship::text AND msib.segment1::text = mos_ext.item_id::text
  • Rows out: Avg 371.1 rows x 128 workers. Max 19822 rows (seg101) with 1569 ms to first row, 1744 ms to end, start offset by 58117 ms.
  • Executor memory: 942K bytes avg, 942K bytes max (seg23).
  • Work_mem used: 942K bytes avg, 942K bytes max (seg23). Workfile: (128 spilling)
  • Work_mem wanted: 6301K bytes avg, 6301K bytes max (seg0) to lessen workfile I/O affecting 128 workers.
  • (seg0) Initial batch 0:
  • (seg0) Wrote 5072K bytes to inner workfile.
  • (seg0) Wrote 32K bytes to outer workfile.
  • (seg0) Overflow batches 1..7:
  • (seg0) Read 6703K bytes from inner workfile: 958K avg x 7 nonempty batches, 1597K max.
  • (seg0) Wrote 1552K bytes to inner workfile: 518K avg x 3 overflowing batches, 896K max.
  • (seg0) Read 77K bytes from outer workfile: 11K avg x 7 nonempty batches, 18K max.
  • (seg0) Hash chain length 6.3 avg, 440 max, using 5039 of 8264 buckets.
  • (seg101) Initial batch 0:
  • (seg101) Wrote 5088K bytes to inner workfile.
  • (seg101) Wrote 7600K bytes to outer workfile.
  • (seg101) Overflow batches 1..7:
  • (seg101) Read 6694K bytes from inner workfile: 957K avg x 7 nonempty batches, 1593K max.
  • (seg101) Wrote 1536K bytes to inner workfile: 512K avg x 3 overflowing batches, 896K max.
  • (seg101) Read 7649K bytes from outer workfile: 1093K avg x 7 nonempty batches, 1153K max.
  • (seg101) Hash chain length 6.3 avg, 440 max, using 5039 of 8264 buckets.
23. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=255,320.95..255,401.69 rows=1 width=4,070) (actual rows= loops=)

  • Hash Cond: pda.project_id = ppa.project_id
  • Rows out: Avg 333.9 rows x 128 workers. Max 17703 rows (seg101) with 1194 ms to first row, 1314 ms to end, start offset by 58434 ms.
  • Executor memory: 513K bytes avg, 513K bytes max (seg0).
  • Work_mem used: 513K bytes avg, 513K bytes max (seg0). Workfile: (0 spilling)
  • (seg101) Hash chain length 6.5 avg, 17 max, using 1031 of 1033 buckets.
24. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=255,317.06..255,397.56 rows=1 width=3,932) (actual rows= loops=)

  • Hash Cond: sup.plan_id::double precision = msc_si.plan_id AND sup.sr_instance_id::double precision = msc_si.sr_instance_id AND sup.organization_id::double precision = msc_si.organization_id AND sup.inventory_item_id::double precision = msc_si.inventory_item_id
  • Rows out: Avg 333.9 rows x 128 workers. Max 17703 rows (seg101) with 1185 ms to first row, 1294 ms to end, start offset by 58443 ms.
  • Executor memory: 942K bytes avg, 942K bytes max (seg0).
  • Work_mem used: 942K bytes avg, 942K bytes max (seg0). Workfile: (128 spilling)
  • Work_mem wanted: 4555K bytes avg, 4578K bytes max (seg56) to lessen workfile I/O affecting 128 workers.
  • (seg56) Initial batch 0:
  • (seg56) Wrote 3200K bytes to inner workfile.
  • (seg56) Wrote 16K bytes to outer workfile.
  • (seg56) Overflow batches 1..7:
  • (seg56) Read 4601K bytes from inner workfile: 658K avg x 7 nonempty batches, 1231K max.
  • (seg56) Wrote 1344K bytes to inner workfile: 448K avg x 3 overflowing batches, 768K max.
  • (seg56) Read 49K bytes from outer workfile: 7K avg x 7 nonempty batches, 17K max.
  • (seg56) Hash chain length 4.5 avg, 14 max, using 16287 of 16504 buckets.
  • (seg101) Initial batch 0:
  • (seg101) Wrote 3184K bytes to inner workfile.
  • (seg101) Wrote 8608K bytes to outer workfile.
  • (seg101) Overflow batches 1..7:
  • (seg101) Read 4567K bytes from inner workfile: 653K avg x 7 nonempty batches, 1219K max.
  • (seg101) Wrote 1312K bytes to inner workfile: 438K avg x 3 overflowing batches, 736K max.
  • (seg101) Read 8652K bytes from outer workfile: 1236K avg x 7 nonempty batches, 8584K max.
  • (seg101) Hash chain length 4.5 avg, 15 max, using 16302 of 16504 buckets.
25. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice23; segments: 128) (cost=255,208.06..255,288.16 rows=1 width=3,956) (actual rows= loops=)

  • Hash Key: sup.sr_instance_id::double precision, sup.plan_id::double precision, sup.inventory_item_id::double precision, sup.organization_id::double precision
  • Rows out: Avg 333.9 rows x 128 workers at destination. Max 17703 rows (seg101) with 750 ms to first row, 1091 ms to end, start offset by 58555 ms.
26. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=255,208.06..255,287.78 rows=1 width=3,956) (actual rows= loops=)

  • Hash Cond: pda.req_distribution_id = rd.distribution_id
  • Rows out: Avg 333.9 rows x 128 workers. Max 9945 rows (seg10) with 10300 ms to first row, 10578 ms to end, start offset by 49004 ms.
  • Executor memory: 217K bytes avg, 220K bytes max (seg30).
  • Work_mem used: 217K bytes avg, 220K bytes max (seg30). Workfile: (0 spilling)
  • (seg10) Hash chain length 4.5 avg, 15 max, using 1025 of 1033 buckets.
27. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice18; segments: 128) (cost=255,203.63..255,283.12 rows=1 width=3,408) (actual rows= loops=)

  • Hash Key: pda.req_distribution_id
  • Rows out: Avg 333.9 rows x 128 workers at destination. Max 9945 rows (seg10) with 871 ms to first row, 1114 ms to end, start offset by 58433 ms.
28. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=255,203.63..255,282.74 rows=1 width=3,408) (actual rows= loops=)

  • Hash Cond: ph.po_header_id = sup.disposition_id::numeric AND pl.po_line_id = sup.po_line_id::numeric AND pll.line_location_id = sup.po_line_location_id::numeric AND (pll.quantity - pll.quantity_received - pll.quantity_cancelled)::double precision = sup.new_order_quantity
  • Rows out: Avg 333.9 rows x 128 workers. Max 405 rows (seg71) with 5132 ms to first row, 5449 ms to end, start offset by 54171 ms.
  • Executor memory: 30K bytes avg, 39K bytes max (seg71).
  • Work_mem used: 30K bytes avg, 39K bytes max (seg71). Workfile: (0 spilling)
  • (seg71) Hash chain length 1.6 avg, 14 max, using 172 of 1033 buckets.
29. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=253,614.83..253,693.54 rows=1 width=3,362) (actual rows= loops=)

  • Hash Cond: ph.po_header_id = pda.po_header_id AND pl.po_line_id = pda.po_line_id AND pll.line_location_id = pda.line_location_id AND COALESCE(pll.po_release_id, 0::numeric) = COALESCE(pda.po_release_id, 0::numeric)
  • Filter: (COALESCE(pda.quantity_ordered, 0::numeric) - COALESCE(pda.quantity_delivered, 0::numeric) - COALESCE(pda.quantity_cancelled, 0::numeric)) > 0::numeric
  • Rows out: Avg 288.5 rows x 128 workers. Max 340 rows (seg117) with 1199 ms to first row, 1522 ms to end, start offset by 58101 ms.
  • Executor memory: 365K bytes avg, 382K bytes max (seg121).
  • Work_mem used: 365K bytes avg, 382K bytes max (seg121). Workfile: (0 spilling)
  • (seg117) Hash chain length 2.3 avg, 8 max, using 1793 of 2063 buckets.
30. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice16; segments: 128) (cost=236,796.51..236,874.96 rows=1 width=3,378) (actual rows= loops=)

  • Hash Key: ph.po_header_id, pl.po_line_id, pll.line_location_id
  • Rows out: Avg 375.7 rows x 128 workers at destination. Max 444 rows (seg117) with 1189 ms to first row, 1505 ms to end, start offset by 58110 ms.
31. 0.000 0.000 ↓ 0.0

Hash Join (cost=236,796.51..236,874.87 rows=1 width=3,378) (actual rows= loops=)

  • Hash Cond: organization_data.organization_id = pll.ship_to_organization_id
  • Rows out: Avg 1299.8 rows x 37 workers. Max 11574 rows (seg24) with 9220 ms to first row, 9262 ms to end, start offset by 50279 ms.
  • Executor memory: 623K bytes avg, 5702K bytes max (seg119).
  • Work_mem used: 623K bytes avg, 5702K bytes max (seg119). Workfile: (7 spilling)
  • Work_mem wanted: 2846K bytes avg, 5702K bytes max (seg119) to lessen workfile I/O affecting 7 workers.
  • (seg24) Initial batch 0:
  • (seg24) Wrote 5520K bytes to inner workfile.
  • (seg24) Overflow batch 1:
  • (seg24) Read 5530K bytes from inner workfile.
  • (seg24) Read 1K bytes from outer workfile.
  • (seg24) Hash chain length 11574.0 avg, 11574 max, using 1 of 1033 buckets. Skipped 1 empty batches.
  • (seg119) Hash chain length 11516.0 avg, 11516 max, using 1 of 1033 buckets. Skipped 1 empty batches.
32. 0.000 0.000 ↓ 0.0

Seq Scan on temp_organization_data_po_rac organization_data (cost=0.00..78.05 rows=1 width=41) (actual rows= loops=)

  • Rows out: Avg 1.6 rows x 37 workers. Max 4 rows (seg67) with 0.165 ms to first row, 0.172 ms to end, start offset by 59409 ms.
33. 0.000 0.000 ↓ 0.0

Hash (cost=236,796.46..236,796.46 rows=1 width=3,376) (actual rows= loops=)

  • Rows in: Avg 688.5 rows x 32 workers. Max 11516 rows (seg119) with 2666 ms to end, start offset by 56736 ms.
34. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=236,794.35..236,796.46 rows=1 width=3,376) (actual rows= loops=)

  • Hash Cond: msib.organization_id = material_cost.organization_id AND msib.inventory_item_id = material_cost.inventory_item_id
  • Rows out: Avg 1299.8 rows x 37 workers. Max 11574 rows (seg24) with 8034 ms to first row, 9142 ms to end, start offset by 50279 ms.
  • Executor memory: 3237K bytes avg, 3928K bytes max (seg2).
  • Work_mem used: 3237K bytes avg, 3928K bytes max (seg2). Workfile: (42 spilling)
  • Work_mem wanted: 7311K bytes avg, 23590K bytes max (seg67) to lessen workfile I/O affecting 42 workers.
  • (seg2) Initial batch 0:
  • (seg2) Wrote 6384K bytes to inner workfile.
  • (seg2) Wrote 1232K bytes to outer workfile.
  • (seg2) Overflow batches 1..3:
  • (seg2) Read 7908K bytes from inner workfile: 2636K avg x 3 nonempty batches, 3634K max.
  • (seg2) Wrote 1504K bytes to inner workfile.
  • (seg2) Read 1268K bytes from outer workfile: 423K avg x 3 nonempty batches, 439K max.
  • (seg2) Hash chain length 3.6 avg, 15 max, using 63814 of 65668 buckets.
  • (seg24) Initial batch 0:
  • (seg24) Wrote 5232K bytes to inner workfile.
  • (seg24) Wrote 4176K bytes to outer workfile.
  • (seg24) Overflow batches 1..3:
  • (seg24) Read 6776K bytes from inner workfile: 2259K avg x 3 nonempty batches, 3280K max.
  • (seg24) Wrote 1520K bytes to inner workfile.
  • (seg24) Read 4196K bytes from outer workfile: 1399K avg x 3 nonempty batches, 1428K max.
  • (seg24) Hash chain length 2.9 avg, 12 max, using 61463 of 65668 buckets.
  • (seg67) Initial batch 0:
  • (seg67) Wrote 15472K bytes to inner workfile.
  • (seg67) Overflow batches 1..7:
  • (seg67) Read 20716K bytes from inner workfile: 2960K avg x 7 nonempty batches, 5200K max.
  • (seg67) Wrote 5200K bytes to inner workfile: 1734K avg x 3 overflowing batches, 2976K max.
  • (seg67) Read 1K bytes from outer workfile.
  • (seg67) Hash chain length 3.9 avg, 15 max, using 128296 of 131336 buckets.
  • (seg119) Initial batch 0:
  • (seg119) Wrote 7328K bytes to inner workfile.
  • (seg119) Wrote 4112K bytes to outer workfile.
  • (seg119) Overflow batches 1..3:
  • (seg119) Read 8834K bytes from inner workfile: 2945K avg x 3 nonempty batches, 3942K max.
  • (seg119) Wrote 1488K bytes to inner workfile.
  • (seg119) Read 4120K bytes from outer workfile: 1374K avg x 3 nonempty batches, 1426K max.
  • (seg119) Hash chain length 4.2 avg, 15 max, using 64653 of 65668 buckets.
35. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice15; segments: 128) (cost=22,059.50..22,061.54 rows=1 width=3,371) (actual rows= loops=)

  • Hash Key: pll.ship_to_organization_id
  • Rows out: Avg 1299.8 rows x 37 workers at destination. Max 11574 rows (seg24) with 7669 ms to first row, 8619 ms to end, start offset by 50643 ms.
36. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=22,059.50..22,061.47 rows=1 width=3,371) (actual rows= loops=)

  • Hash Cond: msib.item_type::text = lity.lookup_code::text
  • Filter: lity.meaning::text <> ALL ('{"MMF Indirect","MMF Consumable"}'::text[])
  • Rows out: Avg 1781.3 rows x 27 workers. Max 17573 rows (seg121) with 904 ms to first row, 1816 ms to end, start offset by 57353 ms.
  • Executor memory: 1K bytes avg, 1K bytes max (seg21).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg21). Workfile: (0 spilling)
  • (seg15) Hash chain length 1.0 avg, 1 max, using 1 of 16417 buckets.
  • (seg21) Hash chain length 1.0 avg, 1 max, using 4 of 16417 buckets.
  • (seg121) Hash chain length 1.0 avg, 1 max, using 1 of 16417 buckets.
37. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice13; segments: 128) (cost=16,546.16..16,548.09 rows=1 width=3,435) (actual rows= loops=)

  • Hash Key: msib.item_type::text
  • Rows out: Avg 1781.3 rows x 27 workers at destination. Max 17573 rows (seg121) with 135 ms to first row, 993 ms to end, start offset by 58122 ms.
38. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=16,546.16..16,548.02 rows=1 width=3,435) (actual rows= loops=)

  • Hash Cond: msib.planning_make_buy_code::text = lmbc.lookup_code::text
  • Rows out: Avg 24047.5 rows x 2 workers. Max 48082 rows (seg45) with 6320 ms to first row, 7229 ms to end, start offset by 51823 ms.
  • Executor memory: 1K bytes avg, 1K bytes max (seg45).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg45). Workfile: (0 spilling)
  • (seg45) Hash chain length 1.0 avg, 1 max, using 1 of 16417 buckets.
39. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice11; segments: 128) (cost=11,032.82..11,034.64 rows=1 width=3,453) (actual rows= loops=)

  • Hash Key: msib.planning_make_buy_code::text
  • Rows out: Avg 24047.5 rows x 2 workers at destination. Max 48082 rows (seg45) with 57 ms to first row, 800 ms to end, start offset by 58086 ms.
40. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=11,032.82..11,034.57 rows=1 width=3,453) (actual rows= loops=)

  • Hash Cond: msib.mrp_planning_code::text = lmpc.lookup_code::text
  • Filter: NOT CASE WHEN msib.inventory_item_flag::text = 'N'::text AND CASE WHEN lmpc.meaning IS NULL OR length(btrim(lmpc.meaning::text)) = 0 THEN 'Not Assigned'::character varying ELSE lmpc.meaning END::text = 'Not planned'::text AND CASE WHEN lipc.meaning IS NULL OR length(btrim(lipc.meaning::text)) = 0 THEN 'Not Assigned'::character varying ELSE lipc.meaning END::text = 'Not planned'::text THEN true ELSE false END
  • Rows out: Avg 8015.8 rows x 6 workers. Max 25577 rows (seg40) with 6518 ms to first row, 7453 ms to end, start offset by 51625 ms.
  • Executor memory: 1K bytes avg, 1K bytes max (seg39).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg39). Workfile: (0 spilling)
  • (seg39) Hash chain length 1.0 avg, 1 max, using 1 of 16417 buckets.
  • (seg40) Hash chain length 1.0 avg, 1 max, using 1 of 16417 buckets.
  • (seg44) Hash chain length 1.0 avg, 1 max, using 1 of 16417 buckets.
41. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice9; segments: 128) (cost=5,519.48..5,521.16 rows=1 width=3,493) (actual rows= loops=)

  • Hash Key: msib.mrp_planning_code::text
  • Rows out: Avg 8035.2 rows x 6 workers at destination. Max 25577 rows (seg40) with 53 ms to first row, 860 ms to end, start offset by 58090 ms.
42. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,519.48..5,521.10 rows=1 width=3,493) (actual rows= loops=)

  • Hash Cond: msib.inventory_planning_code::text = lipc.lookup_code::text
  • Rows out: Avg 24105.5 rows x 2 workers. Max 42921 rows (seg41) with 6146 ms to first row, 6821 ms to end, start offset by 51996 ms.
  • Executor memory: 1K bytes avg, 1K bytes max (seg46).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg46). Workfile: (0 spilling)
  • (seg41) Hash chain length 1.0 avg, 1 max, using 1 of 16417 buckets.
  • (seg46) Hash chain length 1.0 avg, 1 max, using 1 of 16417 buckets.
43. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice7; segments: 128) (cost=6.14..7.71 rows=1 width=3,511) (actual rows= loops=)

  • Hash Key: msib.inventory_planning_code::text
  • Rows out: Avg 24105.5 rows x 2 workers at destination. Max 42921 rows (seg41) with 62 ms to first row, 453 ms to end, start offset by 58080 ms.
44. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6.14..7.64 rows=1 width=3,511) (actual rows= loops=)

  • Hash Cond: ph.vendor_id = apss.vendor_id AND ph.vendor_site_id = apss.vendor_site_id
  • Rows out: Avg 376.6 rows x 128 workers. Max 3419 rows (seg51) with 5106 ms to first row, 5449 ms to end, start offset by 53036 ms.
  • Executor memory: 16K bytes avg, 37K bytes max (seg91).
  • Work_mem used: 16K bytes avg, 37K bytes max (seg91). Workfile: (0 spilling)
  • (seg51) Hash chain length 1.1 avg, 2 max, using 369 of 4111 buckets.
  • (seg91) Hash chain length 1.1 avg, 4 max, using 586 of 4111 buckets.
45. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5.11..6.55 rows=1 width=3,463) (actual rows= loops=)

  • Hash Cond: ph.vendor_id = aps.vendor_id
  • Rows out: Avg 376.6 rows x 128 workers. Max 3419 rows (seg51) with 58 ms to first row, 393 ms to end, start offset by 58085 ms.
  • Executor memory: 7K bytes avg, 7K bytes max (seg60).
  • Work_mem used: 7K bytes avg, 7K bytes max (seg60). Workfile: (0 spilling)
  • (seg51) Hash chain length 1.0 avg, 2 max, using 84 of 1033 buckets.
  • (seg60) Hash chain length 1.0 avg, 2 max, using 92 of 1033 buckets.
46. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice5; segments: 128) (cost=4.10..5.50 rows=1 width=2,887) (actual rows= loops=)

  • Hash Key: ph.vendor_id
  • Rows out: Avg 376.6 rows x 128 workers at destination. Max 3419 rows (seg51) with 57 ms to first row, 381 ms to end, start offset by 58085 ms.
47. 0.000 0.000 ↓ 0.0

Hash Join (cost=4.10..5.43 rows=1 width=2,887) (actual rows= loops=)

  • Hash Cond: pll.ship_to_organization_id = msib.organization_id AND pl.item_id = msib.inventory_item_id
  • Rows out: Avg 376.6 rows x 128 workers. Max 1204 rows (seg71) with 4159 ms to first row, 4251 ms to end, start offset by 53980 ms.
  • Executor memory: 3928K bytes avg, 3928K bytes max (seg16).
  • Work_mem used: 3928K bytes avg, 3928K bytes max (seg16). Workfile: (128 spilling)
  • Work_mem wanted: 8181K bytes avg, 8236K bytes max (seg126) to lessen workfile I/O affecting 128 workers.
  • (seg71) Initial batch 0:
  • (seg71) Wrote 5504K bytes to inner workfile.
  • (seg71) Wrote 304K bytes to outer workfile.
  • (seg71) Overflow batches 1..3:
  • (seg71) Read 7325K bytes from inner workfile: 2442K avg x 3 nonempty batches, 3650K max.
  • (seg71) Wrote 1792K bytes to inner workfile.
  • (seg71) Read 343K bytes from outer workfile: 115K avg x 3 nonempty batches, 270K max.
  • (seg71) Hash chain length 16.2 avg, 32 max, using 4132 of 4132 buckets.
  • (seg126) Initial batch 0:
  • (seg126) Wrote 5552K bytes to inner workfile.
  • (seg126) Wrote 48K bytes to outer workfile.
  • (seg126) Overflow batches 1..3:
  • (seg126) Read 7335K bytes from inner workfile: 2445K avg x 3 nonempty batches, 3606K max.
  • (seg126) Wrote 1760K bytes to inner workfile.
  • (seg126) Read 71K bytes from outer workfile: 24K avg x 3 nonempty batches, 26K max.
  • (seg126) Hash chain length 16.4 avg, 32 max, using 4132 of 4132 buckets.
48. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice4; segments: 128) (cost=3.08..4.36 rows=1 width=2,409) (actual rows= loops=)

  • Hash Key: pl.item_id, pll.ship_to_organization_id
  • Rows out: Avg 596.4 rows x 128 workers at destination. Max 5129 rows (seg91) with 2147 ms to first row, 2210 ms to end, start offset by 55990 ms.
49. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.08..4.30 rows=1 width=2,409) (actual rows= loops=)

  • Hash Cond: ph.po_header_id = pl.po_header_id AND pll.po_line_id = pl.po_line_id
  • Rows out: Avg 596.4 rows x 128 workers. Max 1044 rows (seg4) with 9433 ms to first row, 9438 ms to end, start offset by 48702 ms.
  • Executor memory: 487K bytes avg, 642K bytes max (seg72).
  • Work_mem used: 487K bytes avg, 642K bytes max (seg72). Workfile: (0 spilling)
  • (seg4) Hash chain length 4.3 avg, 14 max, using 1016 of 1033 buckets.
  • (seg72) Hash chain length 5.2 avg, 13 max, using 1027 of 1033 buckets.
50. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2.05..3.21 rows=1 width=1,847) (actual rows= loops=)

  • Hash Cond: ph.po_header_id = pra.po_header_id AND pll.po_release_id = pra.po_release_id
  • Filter: CASE WHEN ph.type_lookup_code::text = 'BLANKET'::text THEN CASE WHEN ph.approved_flag::text = 'Y'::text AND pll.approved_flag::text = 'Y'::text AND pra.approved_flag::text = 'Y'::text THEN 'Approved'::text WHEN ph.approved_flag::text = 'F'::text OR pll.approved_flag::text = 'F'::text OR pra.approved_flag::text = 'F'::text THEN 'Rejected'::text WHEN ph.approved_flag::text = 'R'::text OR pll.approved_flag::text = 'R'::text OR pra.approved_flag::text = 'R'::text THEN 'Requires Approval'::text ELSE 'In Process'::text END ELSE CASE WHEN ph.approved_flag::text = 'Y'::text AND pll.approved_flag::text = 'Y'::text THEN 'Approved'::text WHEN ph.approved_flag::text = 'F'::text OR pll.approved_flag::text = 'F'::text THEN 'Rejected'::text WHEN ph.approved_flag::text = 'R'::text OR pll.approved_flag::text = 'R'::text THEN 'Requires Approval'::text ELSE 'In Process'::text END END <> 'Rejected'::text
  • Rows out: Avg 596.4 rows x 128 workers. Max 1044 rows (seg4) with 3.539 ms to first row, 6.758 ms to end, start offset by 58132 ms.
  • Executor memory: 8K bytes avg, 15K bytes max (seg34).
  • Work_mem used: 8K bytes avg, 15K bytes max (seg34). Workfile: (0 spilling)
  • (seg4) Hash chain length 1.0 avg, 2 max, using 89 of 4111 buckets.
  • (seg34) Hash chain length 1.0 avg, 2 max, using 261 of 4111 buckets.
51. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.01..2.07 rows=1 width=1,807) (actual rows= loops=)

  • Hash Cond: pll.po_header_id = ph.po_header_id
  • Join Filter: (ph.authorization_status::text <> 'INCOMPLETE'::text AND NOT ph.authorization_status IS NULL) OR (NOT pll.approved_flag IS NULL)
  • Rows out: Avg 596.5 rows x 128 workers. Max 1044 rows (seg4) with 3.193 ms to first row, 5.570 ms to end, start offset by 58132 ms.
  • Executor memory: 47K bytes avg, 53K bytes max (seg44).
  • Work_mem used: 47K bytes avg, 53K bytes max (seg44). Workfile: (0 spilling)
  • (seg4) Hash chain length 1.2 avg, 3 max, using 309 of 1033 buckets.
  • (seg44) Hash chain length 1.2 avg, 3 max, using 345 of 1033 buckets.
52. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice1; segments: 128) (cost=0.00..1.02 rows=1 width=1,134) (actual rows= loops=)

  • Hash Key: pll.po_header_id
  • Rows out: Avg 855.1 rows x 128 workers at destination. Max 2278 rows (seg72) with 0.030 ms to first row, 1.896 ms to end, start offset by 58140 ms.
53. 0.000 0.000 ↓ 0.0

Seq Scan on ods_po_line_locations_all pll (cost=0.00..1.00 rows=1 width=1,134) (actual rows= loops=)

  • Filter: (COALESCE(closed_code, 'X'::character varying)::text <> ALL ('{CLOSED,"FINALLY CLOSED"}'::text[])) AND COALESCE(cancel_flag, 'N'::character varying)::text = 'N'::text AND md_deleted_flag IS NULL
  • Rows out: Avg 855.1 rows x 128 workers. Max 904 rows (seg40) with 0.357 ms to first row, 7.913 ms to end, start offset by 51532 ms.
54. 0.000 0.000 ↓ 0.0

Hash (cost=1.00..1.00 rows=1 width=741) (actual rows= loops=)

  • Rows in: Avg 365.2 rows x 128 workers. Max 411 rows (seg44) with 3.272 ms to end, start offset by 58132 ms.
55. 0.000 0.000 ↓ 0.0

Seq Scan on ods_po_headers_all ph (cost=0.00..1.00 rows=1 width=741) (actual rows= loops=)

  • Filter: md_deleted_flag IS NULL AND (COALESCE(closed_code, 'X'::character varying)::text <> ALL ('{CLOSED,"FINALLY CLOSED"}'::text[]))
  • Rows out: Avg 365.2 rows x 128 workers. Max 411 rows (seg44) with 0.320 ms to first row, 2.918 ms to end, start offset by 58132 ms.
56. 0.000 0.000 ↓ 0.0

Hash (cost=1.02..1.02 rows=1 width=104) (actual rows= loops=)

  • Rows in: Avg 138.0 rows x 128 workers. Max 271 rows (seg34) with 1.767 ms to end, start offset by 58134 ms.
57. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice2; segments: 128) (cost=0.00..1.02 rows=1 width=104) (actual rows= loops=)

  • Hash Key: pra.po_header_id
  • Rows out: Avg 138.0 rows x 128 workers at destination. Max 271 rows (seg34) with 0.050 ms to first row, 1.547 ms to end, start offset by 58134 ms.
58. 0.000 0.000 ↓ 0.0

Seq Scan on ods_po_releases_all pra (cost=0.00..1.00 rows=1 width=104) (actual rows= loops=)

  • Filter: md_deleted_flag IS NULL
  • Rows out: Avg 138.0 rows x 128 workers. Max 167 rows (seg117) with 0.179 ms to first row, 0.388 ms to end, start offset by 57031 ms.
59. 0.000 0.000 ↓ 0.0

Hash (cost=1.02..1.02 rows=1 width=658) (actual rows= loops=)

  • Rows in: Avg 3884.8 rows x 128 workers. Max 5307 rows (seg72) with 3614 ms to end, start offset by 54519 ms.
60. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice3; segments: 128) (cost=0.00..1.02 rows=1 width=658) (actual rows= loops=)

  • Hash Key: pl.po_header_id
  • Rows out: Avg 3884.8 rows x 128 workers at destination. Max 5307 rows (seg72) with 0.073 ms to first row, 3604 ms to end, start offset by 54519 ms.
61. 0.000 0.000 ↓ 0.0

Seq Scan on ods_po_lines_all pl (cost=0.00..1.00 rows=1 width=658) (actual rows= loops=)

  • Filter: md_deleted_flag IS NULL
  • Rows out: Avg 3884.8 rows x 128 workers. Max 4004 rows (seg8) with 0.313 ms to first row, 36 ms to end, start offset by 49122 ms.
62. 0.000 0.000 ↓ 0.0

Hash (cost=1.00..1.00 rows=1 width=510) (actual rows= loops=)

  • Rows in: Avg 16779.2 rows x 128 workers. Max 17056 rows (seg10) with 821 ms to end, start offset by 48855 ms.
63. 0.000 0.000 ↓ 0.0

Seq Scan on ods_mtl_system_items_b msib (cost=0.00..1.00 rows=1 width=510) (actual rows= loops=)

  • Filter: upper(segment1::text) !~~ 'SPECIAL_CHARGE%'::text AND upper(segment1::text) !~~ 'EXP_MISC_HARDWARE_INTERCOMPANY%'::text
  • Rows out: Avg 67139.8 rows x 128 workers. Max 67602 rows (seg126) with 2.834 ms to first row, 245 ms to end, start offset by 57967 ms.
64. 0.000 0.000 ↓ 0.0

Hash (cost=1.00..1.00 rows=1 width=608) (actual rows= loops=)

  • Rows in: Avg 89.8 rows x 128 workers. Max 99 rows (seg100) with 0.636 ms to end, start offset by 58085 ms.
65. 0.000 0.000 ↓ 0.0

Seq Scan on ods_ap_suppliers aps (cost=0.00..1.00 rows=1 width=608) (actual rows= loops=)

  • Rows out: Avg 89.8 rows x 128 workers. Max 99 rows (seg100) with 0.270 ms to first row, 0.417 ms to end, start offset by 58085 ms.
66. 0.000 0.000 ↓ 0.0

Hash (cost=1.02..1.02 rows=1 width=112) (actual rows= loops=)

  • Rows in: Avg 277.9 rows x 128 workers. Max 652 rows (seg91) with 3263 ms to end, start offset by 54823 ms.
67. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice6; segments: 128) (cost=0.00..1.02 rows=1 width=112) (actual rows= loops=)

  • Hash Key: apss.vendor_id
  • Rows out: Avg 277.9 rows x 128 workers at destination. Max 652 rows (seg91) with 0.050 ms to first row, 3262 ms to end, start offset by 54823 ms.
68. 0.000 0.000 ↓ 0.0

Seq Scan on ods_ap_supplier_sites_all apss (cost=0.00..1.00 rows=1 width=112) (actual rows= loops=)

  • Rows out: Avg 277.9 rows x 128 workers. Max 288 rows (seg108) with 0.241 ms to first row, 0.476 ms to end, start offset by 56712 ms.
69. 0.000 0.000 ↓ 0.0

Hash (cost=5,513.03..5,513.03 rows=1 width=21) (actual rows= loops=)

  • Rows in: Avg 1.0 rows x 4 workers. Max 1 rows (seg40) with 6410 ms to end, start offset by 51670 ms.
70. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice8; segments: 128) (cost=0.00..5,513.03 rows=1 width=21) (actual rows= loops=)

  • Hash Key: lipc.lookup_code::text
  • Rows out: Avg 1.0 rows x 4 workers at destination. Max 1 rows (seg40) with 3610 ms to first row, 6410 ms to end, start offset by 51670 ms.
71. 0.000 0.000 ↓ 0.0

Seq Scan on temp_mfg_lookups_po_rac lipc (cost=0.00..5,512.54 rows=1 width=21) (actual rows= loops=)

  • Filter: lookup_type::text = 'MTL_MATERIAL_PLANNING'::text
  • Rows out: Avg 1.0 rows x 4 workers. Max 1 rows (seg10) with 0.807 ms to first row, 0.972 ms to end, start offset by 49138 ms.
72. 0.000 0.000 ↓ 0.0

Hash (cost=5,513.03..5,513.03 rows=1 width=21) (actual rows= loops=)

  • Rows in: Avg 1.0 rows x 6 workers. Max 1 rows (seg38) with 6389 ms to end, start offset by 51701 ms.
73. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice10; segments: 128) (cost=0.00..5,513.03 rows=1 width=21) (actual rows= loops=)

  • Hash Key: lmpc.lookup_code::text
  • Rows out: Avg 1.0 rows x 6 workers at destination. Max 1 rows (seg38) with 0.046 ms to first row, 6389 ms to end, start offset by 51701 ms.
74. 0.000 0.000 ↓ 0.0

Seq Scan on temp_mfg_lookups_po_rac lmpc (cost=0.00..5,512.54 rows=1 width=21) (actual rows= loops=)

  • Filter: lookup_type::text = 'MRP_PLANNING_CODE'::text
  • Rows out: Avg 1.0 rows x 6 workers. Max 1 rows (seg22) with 0.292 ms to first row, 0.948 ms to end, start offset by 50433 ms.
75. 0.000 0.000 ↓ 0.0

Hash (cost=5,513.03..5,513.03 rows=1 width=21) (actual rows= loops=)

  • Rows in: Avg 1.0 rows x 2 workers. Max 1 rows (seg45) with 6263 ms to end, start offset by 51823 ms.
76. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice12; segments: 128) (cost=0.00..5,513.03 rows=1 width=21) (actual rows= loops=)

  • Hash Key: lmbc.lookup_code::text
  • Rows out: Avg 1.0 rows x 2 workers at destination. Max 1 rows (seg45) with 360 ms to first row, 6263 ms to end, start offset by 51823 ms.
77. 0.000 0.000 ↓ 0.0

Seq Scan on temp_mfg_lookups_po_rac lmbc (cost=0.00..5,512.54 rows=1 width=21) (actual rows= loops=)

  • Filter: lookup_type::text = 'MTL_PLANNING_MAKE_BUY'::text
  • Rows out: Avg 1.0 rows x 2 workers. Max 1 rows (seg10) with 10 ms to first row, 11 ms to end, start offset by 48862 ms.
78. 0.000 0.000 ↓ 0.0

Hash (cost=5,513.03..5,513.03 rows=1 width=21) (actual rows= loops=)

  • Rows in: Avg 1.4 rows x 80 workers. Max 4 rows (seg21) with 7840 ms to end, start offset by 50280 ms.
79. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice14; segments: 128) (cost=0.00..5,513.03 rows=1 width=21) (actual rows= loops=)

  • Hash Key: lity.lookup_code::text
  • Rows out: Avg 1.4 rows x 80 workers at destination. Max 4 rows (seg21) with 1045 ms to first row, 7840 ms to end, start offset by 50280 ms.
80. 0.000 0.000 ↓ 0.0

Seq Scan on temp_mfg_lookups_po_rac lity (cost=0.00..5,512.54 rows=1 width=21) (actual rows= loops=)

  • Filter: lookup_type::text = 'ITEM_TYPE'::text
  • Rows out: Avg 1.7 rows x 63 workers. Max 5 rows (seg4) with 0.296 ms to first row, 0.634 ms to end, start offset by 48746 ms.
81. 0.000 0.000 ↓ 0.0

Hash (cost=93,731.74..93,731.74 rows=63,023 width=20) (actual rows= loops=)

  • Rows in: Avg 53398.8 rows x 75 workers. Max 83601 rows (seg79) with 57 ms to end, start offset by 54793 ms.
82. 0.000 0.000 ↓ 0.0

Seq Scan on temp_material_cost_po_rac material_cost (cost=0.00..93,731.74 rows=63,023 width=20) (actual rows= loops=)

  • Rows out: Avg 107545.5 rows x 75 workers. Max 499687 rows (seg67) with 0.289 ms to first row, 129 ms to end, start offset by 54066 ms.
83. 0.000 0.000 ↓ 0.0

Hash (cost=6,595.44..6,595.44 rows=3,994 width=66) (actual rows= loops=)

  • Rows in: Avg 3993.3 rows x 128 workers. Max 4170 rows (seg121) with 6.681 ms to end, start offset by 58101 ms.
84. 0.000 0.000 ↓ 0.0

Seq Scan on temp_distinctdisttributions_po_rac pda (cost=0.00..6,595.44 rows=3,994 width=66) (actual rows= loops=)

  • Rows out: Avg 3993.3 rows x 128 workers. Max 4170 rows (seg121) with 0.281 ms to first row, 1.872 ms to end, start offset by 58101 ms.
85. 0.000 0.000 ↓ 0.0

Hash (cost=1,055.68..1,055.68 rows=209 width=102) (actual rows= loops=)

  • Rows in: Avg 206.5 rows x 128 workers. Max 270 rows (seg71) with 3930 ms to end, start offset by 54171 ms.
86. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice17; segments: 128) (cost=0.00..1,055.68 rows=209 width=102) (actual rows= loops=)

  • Hash Key: sup.disposition_id::numeric, sup.po_line_id::numeric, sup.po_line_location_id::numeric
  • Rows out: Avg 208.2 rows x 128 workers at destination. Max 271 rows (seg71) with 0.040 ms to first row, 3929 ms to end, start offset by 54171 ms.
87. 0.000 0.000 ↓ 0.0

Seq Scan on temp_ascp_actions_po_rac sup (cost=0.00..522.56 rows=209 width=102) (actual rows= loops=)

  • Rows out: Avg 208.2 rows x 128 workers. Max 277 rows (seg97) with 0.280 ms to first row, 0.593 ms to end, start offset by 55790 ms.
88. 0.000 0.000 ↓ 0.0

Hash (cost=4.38..4.38 rows=1 width=588) (actual rows= loops=)

  • Rows in: Avg 4618.0 rows x 128 workers. Max 4687 rows (seg30) with 7135 ms to end, start offset by 51301 ms.
89. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice22; segments: 128) (cost=3.04..4.38 rows=1 width=588) (actual rows= loops=)

  • Hash Key: rd.distribution_id
  • Rows out: Avg 4618.0 rows x 128 workers at destination. Max 4687 rows (seg30) with 7129 ms to first row, 7132 ms to end, start offset by 51301 ms.
90. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3.04..4.32 rows=1 width=588) (actual rows= loops=)

  • Hash Cond: rl.requisition_header_id = r.requisition_header_id
  • Rows out: Avg 4618.0 rows x 128 workers. Max 6686 rows (seg36) with 2.504 ms to first row, 6937 ms to end, start offset by 51484 ms.
  • Executor memory: 64K bytes avg, 66K bytes max (seg10).
  • Work_mem used: 64K bytes avg, 66K bytes max (seg10). Workfile: (0 spilling)
  • (seg36) Hash chain length 1.2 avg, 6 max, using 1359 of 4111 buckets.
91. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice21; segments: 128) (cost=2.03..3.26 rows=1 width=562) (actual rows= loops=)

  • Hash Key: rl.requisition_header_id
  • Rows out: Avg 4618.0 rows x 128 workers at destination. Max 6686 rows (seg36) with 0.131 ms to first row, 6924 ms to end, start offset by 51487 ms.
92. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2.03..3.19 rows=1 width=562) (actual rows= loops=)

  • Hash Cond: rl.wip_entity_id = wen.wip_entity_id
  • Rows out: Avg 4618.0 rows x 128 workers. Max 589140 rows (seg10) with 2.525 ms to first row, 4691 ms to end, start offset by 48941 ms.
  • Executor memory: 9K bytes avg, 10K bytes max (seg89).
  • Work_mem used: 9K bytes avg, 10K bytes max (seg89). Workfile: (0 spilling)
  • (seg10) Hash chain length 1.1 avg, 2 max, using 198 of 1033 buckets.
  • (seg89) Hash chain length 1.1 avg, 3 max, using 204 of 1033 buckets.
93. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice20; segments: 128) (cost=1.01..2.14 rows=1 width=96) (actual rows= loops=)

  • Hash Key: rl.wip_entity_id
  • Rows out: Avg 4618.0 rows x 128 workers at destination. Max 589140 rows (seg10) with 0.999 ms to first row, 4348 ms to end, start offset by 48942 ms.
94. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.01..2.07 rows=1 width=96) (actual rows= loops=)

  • Hash Cond: rd.requisition_line_id = rl.requisition_line_id
  • Rows out: Avg 4618.0 rows x 128 workers. Max 4681 rows (seg120) with 28 ms to first row, 779 ms to end, start offset by 57308 ms.
  • Executor memory: 217K bytes avg, 220K bytes max (seg120).
  • Work_mem used: 217K bytes avg, 220K bytes max (seg120). Workfile: (0 spilling)
  • (seg120) Hash chain length 1.7 avg, 7 max, using 2831 of 4111 buckets.
95. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice19; segments: 128) (cost=0.00..1.02 rows=1 width=64) (actual rows= loops=)

  • Hash Key: rd.requisition_line_id
  • Rows out: Avg 4618.0 rows x 128 workers at destination. Max 4681 rows (seg120) with 0.079 ms to first row, 741 ms to end, start offset by 57336 ms.
96. 0.000 0.000 ↓ 0.0

Seq Scan on ods_po_req_distributions_all rd (cost=0.00..1.00 rows=1 width=64) (actual rows= loops=)

  • Rows out: Avg 4618.0 rows x 128 workers. Max 4687 rows (seg30) with 0.186 ms to first row, 2.737 ms to end, start offset by 51299 ms.
97. 0.000 0.000 ↓ 0.0

Hash (cost=1.00..1.00 rows=1 width=96) (actual rows= loops=)

  • Rows in: Avg 4618.5 rows x 128 workers. Max 4682 rows (seg120) with 28 ms to end, start offset by 57308 ms.
98. 0.000 0.000 ↓ 0.0

Seq Scan on ods_po_requisition_lines_all rl (cost=0.00..1.00 rows=1 width=96) (actual rows= loops=)

  • Rows out: Avg 4618.5 rows x 128 workers. Max 4682 rows (seg120) with 0.200 ms to first row, 11 ms to end, start offset by 57308 ms.
99. 0.000 0.000 ↓ 0.0

Hash (cost=1.00..1.00 rows=1 width=530) (actual rows= loops=)

  • Rows in: Avg 211.1 rows x 128 workers. Max 233 rows (seg89) with 0.427 ms to end, start offset by 55363 ms.
100. 0.000 0.000 ↓ 0.0

Seq Scan on ods_wip_entities wen (cost=0.00..1.00 rows=1 width=530) (actual rows= loops=)

  • Rows out: Avg 211.1 rows x 128 workers. Max 233 rows (seg89) with 0.158 ms to first row, 0.286 ms to end, start offset by 55363 ms.
101. 0.000 0.000 ↓ 0.0

Hash (cost=1.00..1.00 rows=1 width=90) (actual rows= loops=)

  • Rows in: Avg 1604.9 rows x 128 workers. Max 1666 rows (seg10) with 2.068 ms to end, start offset by 49080 ms.
102. 0.000 0.000 ↓ 0.0

Seq Scan on ods_po_requisition_headers_all r (cost=0.00..1.00 rows=1 width=90) (actual rows= loops=)

  • Rows out: Avg 1604.9 rows x 128 workers. Max 1666 rows (seg10) with 0.186 ms to first row, 1.145 ms to end, start offset by 49080 ms.
103. 0.000 0.000 ↓ 0.0

Hash (cost=103.00..103.00 rows=3 width=40) (actual rows= loops=)

  • Rows in: Avg 9098.9 rows x 128 workers. Max 9294 rows (seg22) with 258 ms to end, start offset by 58454 ms.
104. 0.000 0.000 ↓ 0.0

Seq Scan on ods_msc_system_items msc_si (cost=0.00..103.00 rows=3 width=40) (actual rows= loops=)

  • Rows out: Avg 72891.8 rows x 128 workers. Max 73260 rows (seg56) with 0.203 ms to first row, 97 ms to end, start offset by 58442 ms.
105. 0.000 0.000 ↓ 0.0

Hash (cost=2.29..2.29 rows=1 width=162) (actual rows= loops=)

  • Rows in: Avg 6703.0 rows x 128 workers. Max 6703 rows (seg0) with 7.852 ms to end, start offset by 58428 ms.
106. 0.000 0.000 ↓ 0.0

Broadcast Motion 128:128 (slice24; segments: 128) (cost=0.00..2.29 rows=1 width=162) (actual rows= loops=)

  • Rows out: Avg 6703.0 rows x 128 workers at destination. Max 6703 rows (seg0) with 0.102 ms to first row, 3.971 ms to end, start offset by 58428 ms.
107. 0.000 0.000 ↓ 0.0

Seq Scan on ods_pa_projects_all ppa (cost=0.00..1.00 rows=1 width=162) (actual rows= loops=)

  • Rows out: Avg 52.4 rows x 128 workers. Max 68 rows (seg90) with 22 ms to end, start offset by 55611 ms.
108. 0.000 0.000 ↓ 0.0

Hash (cost=2.29..2.29 rows=1 width=544) (actual rows= loops=)

  • Rows in: Avg 4071.0 rows x 128 workers. Max 4071 rows (seg0) with 310 ms to end, start offset by 58118 ms.
109. 0.000 0.000 ↓ 0.0

Broadcast Motion 128:128 (slice25; segments: 128) (cost=0.00..2.29 rows=1 width=544) (actual rows= loops=)

  • Rows out: Avg 64114.0 rows x 128 workers at destination. Max 64114 rows (seg0) with 0.059 ms to first row, 260 ms to end, start offset by 58118 ms.
110. 0.000 0.000 ↓ 0.0

Seq Scan on cx_races_otm_mos_extract mos_ext (cost=0.00..1.00 rows=1 width=544) (actual rows= loops=)

  • Rows out: Avg 500.9 rows x 128 workers. Max 1504 rows (seg53) with 0.177 ms to first row, 9.845 ms to end, start offset by 53177 ms.
111. 0.000 0.000 ↓ 0.0

Hash (cost=2.29..2.29 rows=1 width=220) (actual rows= loops=)

  • Rows in: Avg 3955.0 rows x 128 workers. Max 3955 rows (seg0) with 62 ms to end, start offset by 58056 ms.
112. 0.000 0.000 ↓ 0.0

Broadcast Motion 128:128 (slice26; segments: 128) (cost=0.00..2.29 rows=1 width=220) (actual rows= loops=)

  • Rows out: Avg 4120.0 rows x 128 workers at destination. Max 4120 rows (seg0) with 0.039 ms to first row, 60 ms to end, start offset by 58056 ms.
113. 0.000 0.000 ↓ 0.0

Seq Scan on t_gere_cx_enovia_plm_qual_rpt enovia (cost=0.00..1.00 rows=1 width=220) (actual rows= loops=)

  • Rows out: Avg 32.2 rows x 128 workers. Max 43 rows (seg62) with 0.211 ms to first row, 0.251 ms to end, start offset by 53518 ms.
114. 0.000 0.000 ↓ 0.0

Hash (cost=2.29..2.29 rows=1 width=64) (actual rows= loops=)

  • Rows in: Avg 1313.0 rows x 128 workers. Max 1313 rows (seg0) with 9530 ms to end, start offset by 48526 ms.
115. 0.000 0.000 ↓ 0.0

Broadcast Motion 128:128 (slice27; segments: 128) (cost=0.00..2.29 rows=1 width=64) (actual rows= loops=)

  • Rows out: Avg 1313.0 rows x 128 workers at destination. Max 1313 rows (seg0) with 0.049 ms to first row, 9528 ms to end, start offset by 48526 ms.
116. 0.000 0.000 ↓ 0.0

Seq Scan on ods_ap_terms_lines apt (cost=0.00..1.00 rows=1 width=64) (actual rows= loops=)

  • Rows out: Avg 10.3 rows x 128 workers. Max 15 rows (seg51) with 0.158 ms to first row, 0.173 ms to end, start offset by 52745 ms.
117. 0.000 0.000 ↓ 0.0

Hash (cost=226.91..226.91 rows=75 width=63) (actual rows= loops=)

  • Rows in: Avg 79.8 rows x 119 workers. Max 941 rows (seg97) with 2.121 ms to end, start offset by 56089 ms.
118. 0.000 0.000 ↓ 0.0

Seq Scan on temp_pasl_unique_po_rac pasup (cost=0.00..226.91 rows=75 width=63) (actual rows= loops=)

  • Rows out: Avg 79.8 rows x 119 workers. Max 941 rows (seg97) with 0.229 ms to first row, 0.912 ms to end, start offset by 56089 ms.
119. 0.000 0.000 ↓ 0.0

Hash (cost=1,852.20..1,852.20 rows=1,151 width=18) (actual rows= loops=)

  • Rows in: Avg 1150.9 rows x 128 workers. Max 1227 rows (seg57) with 5.755 ms to end, start offset by 58100 ms.
120. 0.000 0.000 ↓ 0.0

Seq Scan on temp_abc_classes_po_rac abc_classes (cost=0.00..1,852.20 rows=1,151 width=18) (actual rows= loops=)

  • Rows out: Avg 1150.9 rows x 128 workers. Max 1227 rows (seg57) with 0.357 ms to first row, 4.439 ms to end, start offset by 58100 ms.
121. 0.000 0.000 ↓ 0.0

Hash (cost=1.02..1.02 rows=1 width=102) (actual rows= loops=)

  • Rows in: Avg 29.6 rows x 128 workers. Max 41 rows (seg38) with 6464 ms to end, start offset by 51636 ms.
122. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice30; segments: 128) (cost=0.00..1.02 rows=1 width=102) (actual rows= loops=)

  • Hash Key: misd.inventory_item_id, misd.organization_id
  • Rows out: Avg 29.6 rows x 128 workers at destination. Max 41 rows (seg38) with 0.145 ms to first row, 6464 ms to end, start offset by 51636 ms.
123. 0.000 0.000 ↓ 0.0

Seq Scan on ods_mtl_item_sub_defaults misd (cost=0.00..1.00 rows=1 width=102) (actual rows= loops=)

  • Filter: default_type = 2::numeric
  • Rows out: Avg 29.6 rows x 128 workers. Max 43 rows (seg21) with 0.213 ms to first row, 0.226 ms to end, start offset by 50383 ms.
124. 0.000 0.000 ↓ 0.0

Hash (cost=762.45..762.45 rows=496 width=25) (actual rows= loops=)

  • Rows in: Avg 495.7 rows x 128 workers. Max 517 rows (seg31) with 0.711 ms to end, start offset by 51218 ms.
125. 0.000 0.000 ↓ 0.0

Seq Scan on temp_user_names_po_rac user_names (cost=0.00..762.45 rows=496 width=25) (actual rows= loops=)

  • Rows out: Avg 495.7 rows x 128 workers. Max 517 rows (seg31) with 0.289 ms to first row, 0.344 ms to end, start offset by 51218 ms.
126. 0.000 0.000 ↓ 0.0

Hash (cost=96.95..96.95 rows=2 width=12) (actual rows= loops=)

  • Rows in: Avg 1.8 rows x 92 workers. Max 5 rows (seg46) with 5854 ms to end, start offset by 52250 ms.
127. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice33; segments: 128) (cost=0.00..96.95 rows=2 width=12) (actual rows= loops=)

  • Hash Key: curr_ref_org.from_currency::text
  • Rows out: Avg 1.8 rows x 92 workers at destination. Max 5 rows (seg46) with 0.082 ms to first row, 5854 ms to end, start offset by 52250 ms.
128. 0.000 0.000 ↓ 0.0

Seq Scan on temp_curr_ref_po_rac curr_ref_org (cost=0.00..93.65 rows=2 width=12) (actual rows= loops=)

  • Rows out: Avg 1.8 rows x 92 workers. Max 5 rows (seg30) with 0.387 ms to first row, 0.395 ms to end, start offset by 51146 ms.
129. 0.000 0.000 ↓ 0.0

Hash (cost=96.95..96.95 rows=2 width=12) (actual rows= loops=)

  • Rows in: Avg 1.8 rows x 92 workers. Max 5 rows (seg46) with 43 ms to end, start offset by 58071 ms.
130. 0.000 0.000 ↓ 0.0

Redistribute Motion 128:128 (slice35; segments: 128) (cost=0.00..96.95 rows=2 width=12) (actual rows= loops=)

  • Hash Key: curr_ref.from_currency::text
  • Rows out: Avg 1.8 rows x 92 workers at destination. Max 5 rows (seg46) with 0.036 ms to first row, 43 ms to end, start offset by 58071 ms.
131. 0.000 0.000 ↓ 0.0

Seq Scan on temp_curr_ref_po_rac curr_ref (cost=0.00..93.65 rows=2 width=12) (actual rows= loops=)

  • Rows out: Avg 1.8 rows x 92 workers. Max 5 rows (seg30) with 0.168 ms to first row, 0.172 ms to end, start offset by 51288 ms.
132. 0.000 0.000 ↓ 0.0

Hash (cost=2.29..2.29 rows=1 width=514) (actual rows= loops=)

  • Rows in: Avg 12893.0 rows x 128 workers. Max 12893 rows (seg0) with 17 ms to end, start offset by 58054 ms.
133. 0.000 0.000 ↓ 0.0

Broadcast Motion 128:128 (slice36; segments: 128) (cost=0.00..2.29 rows=1 width=514) (actual rows= loops=)

  • Rows out: Avg 12893.0 rows x 128 workers at destination. Max 12893 rows (seg0) with 0.036 ms to first row, 13 ms to end, start offset by 58054 ms.
134. 0.000 0.000 ↓ 0.0

Seq Scan on ods_fnd_user fnu2 (cost=0.00..1.00 rows=1 width=514) (actual rows= loops=)

  • Rows out: Avg 100.7 rows x 128 workers. Max 115 rows (seg37) with 0.155 ms to first row, 0.252 ms to end, start offset by 51636 ms.
135. 0.000 0.000 ↓ 0.0

Hash (cost=2.29..2.29 rows=1 width=16) (actual rows= loops=)

  • Rows in: Avg 12893.0 rows x 128 workers. Max 12893 rows (seg0) with 9656 ms to end, start offset by 48398 ms.
136. 0.000 0.000 ↓ 0.0

Broadcast Motion 128:128 (slice37; segments: 128) (cost=0.00..2.29 rows=1 width=16) (actual rows= loops=)

  • Rows out: Avg 12893.0 rows x 128 workers at destination. Max 12893 rows (seg0) with 0.081 ms to first row, 9645 ms to end, start offset by 48398 ms.
137. 0.000 0.000 ↓ 0.0

Seq Scan on ods_fnd_user fnu (cost=0.00..1.00 rows=1 width=16) (actual rows= loops=)

  • Rows out: Avg 100.7 rows x 128 workers. Max 115 rows (seg37) with 0.203 ms to first row, 0.273 ms to end, start offset by 51561 ms.
138. 0.000 0.000 ↓ 0.0

Hash (cost=7,581.89..7,581.89 rows=4,743 width=25) (actual rows= loops=)

  • Rows in: Avg 4742.1 rows x 128 workers. Max 5842 rows (seg4) with 12 ms to end, start offset by 48430 ms.
139. 0.000 0.000 ↓ 0.0

Seq Scan on temp_original_need_by_dt_po_rac onbd (cost=0.00..7,581.89 rows=4,743 width=25) (actual rows= loops=)

  • Rows out: Avg 4742.1 rows x 128 workers. Max 5842 rows (seg4) with 0.244 ms to first row, 2.527 ms to end, start offset by 48430 ms.
140.          

SubPlan (forHash Left Join)

141. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 85.4 rows x 128 workers. Max 422 rows (seg15) with 0.076 ms to first row, 13 ms to end of 422 scans, start offset by 62345 ms.
142. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 290.9 rows x 128 workers. Max 1630 rows (seg15) with 0.050 ms to first row, 11 ms to end of 422 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
143. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 6.1 rows x 126 workers. Max 26 rows (seg67) with 0.076 ms to first row, 0.560 ms to end of 26 scans, start offset by 61794 ms.
144. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 15.3 rows x 126 workers. Max 64 rows (seg67) with 0.051 ms to first row, 0.459 ms to end of 26 scans, start offset by 61794 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
145. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 91.4 rows x 128 workers. Max 425 rows (seg15) with 0.088 ms to first row, 13 ms to end of 425 scans, start offset by 62345 ms.
146. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 306.0 rows x 128 workers. Max 1639 rows (seg15) with 0.049 ms to first row, 11 ms to end of 425 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
147. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
148. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
149. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 91.4 rows x 128 workers. Max 425 rows (seg15) with 0.092 ms to first row, 13 ms to end of 425 scans, start offset by 62345 ms.
150. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 306.0 rows x 128 workers. Max 1639 rows (seg15) with 0.060 ms to first row, 11 ms to end of 425 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
151. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 86.4 rows x 128 workers. Max 422 rows (seg15) with 0.075 ms to first row, 13 ms to end of 422 scans, start offset by 62345 ms.
152. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 291.2 rows x 128 workers. Max 1630 rows (seg15) with 0.047 ms to first row, 11 ms to end of 422 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
153. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 6.1 rows x 126 workers. Max 26 rows (seg67) with 0.083 ms to first row, 0.546 ms to end of 26 scans, start offset by 61794 ms.
154. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 15.4 rows x 126 workers. Max 64 rows (seg67) with 0.060 ms to first row, 0.448 ms to end of 26 scans, start offset by 61794 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
155. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 92.4 rows x 128 workers. Max 425 rows (seg15) with 0.076 ms to first row, 13 ms to end of 425 scans, start offset by 62345 ms.
156. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 306.3 rows x 128 workers. Max 1639 rows (seg15) with 0.049 ms to first row, 11 ms to end of 425 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
157. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
158. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
159. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 92.4 rows x 128 workers. Max 425 rows (seg15) with 0.078 ms to first row, 14 ms to end of 425 scans, start offset by 62345 ms.
160. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 306.3 rows x 128 workers. Max 1639 rows (seg15) with 0.050 ms to first row, 12 ms to end of 425 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
161. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 85.4 rows x 128 workers. Max 422 rows (seg15) with 0.095 ms to first row, 13 ms to end of 422 scans, start offset by 62345 ms.
162. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 290.9 rows x 128 workers. Max 1630 rows (seg15) with 0.053 ms to first row, 12 ms to end of 422 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
163. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 6.1 rows x 126 workers. Max 26 rows (seg67) with 0.071 ms to first row, 0.552 ms to end of 26 scans, start offset by 61793 ms.
164. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 15.3 rows x 126 workers. Max 64 rows (seg67) with 0.049 ms to first row, 0.458 ms to end of 26 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
165. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 91.4 rows x 128 workers. Max 425 rows (seg15) with 0.082 ms to first row, 13 ms to end of 425 scans, start offset by 62345 ms.
166. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 306.0 rows x 128 workers. Max 1639 rows (seg15) with 0.055 ms to first row, 11 ms to end of 425 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
167. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
168. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
169. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 91.4 rows x 128 workers. Max 425 rows (seg15) with 0.125 ms to first row, 13 ms to end of 425 scans, start offset by 62345 ms.
170. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 306.0 rows x 128 workers. Max 1639 rows (seg15) with 0.097 ms to first row, 11 ms to end of 425 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
171. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 86.4 rows x 128 workers. Max 422 rows (seg15) with 0.085 ms to first row, 13 ms to end of 422 scans, start offset by 62345 ms.
172. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 291.2 rows x 128 workers. Max 1630 rows (seg15) with 0.058 ms to first row, 11 ms to end of 422 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
173. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 6.1 rows x 126 workers. Max 26 rows (seg67) with 0.090 ms to first row, 0.564 ms to end of 26 scans, start offset by 61793 ms.
174. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 15.4 rows x 126 workers. Max 64 rows (seg67) with 0.057 ms to first row, 0.459 ms to end of 26 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
175. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 92.4 rows x 128 workers. Max 425 rows (seg15) with 0.080 ms to first row, 13 ms to end of 425 scans, start offset by 62345 ms.
176. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 306.3 rows x 128 workers. Max 1639 rows (seg15) with 0.054 ms to first row, 12 ms to end of 425 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
177. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
178. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
179. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 92.4 rows x 128 workers. Max 425 rows (seg15) with 0.112 ms to first row, 14 ms to end of 425 scans, start offset by 62345 ms.
180. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 306.3 rows x 128 workers. Max 1639 rows (seg15) with 0.080 ms to first row, 12 ms to end of 425 scans, start offset by 62345 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
181. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 165.4 rows x 128 workers. Max 962 rows (seg127) with 0.040 ms to first row, 5.597 ms to end of 962 scans, start offset by 62360 ms.
182. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 544.9 rows x 128 workers. Max 1942 rows (seg41) with 0.027 ms to first row, 19 ms to end of 501 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
183. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 7.5 rows x 126 workers. Max 29 rows (seg67) with 0.079 ms to first row, 0.592 ms to end of 29 scans, start offset by 61793 ms.
184. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 18.0 rows x 126 workers. Max 73 rows (seg67) with 0.057 ms to first row, 0.499 ms to end of 29 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
185. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 172.8 rows x 128 workers. Max 972 rows (seg127) with 0.038 ms to first row, 5.880 ms to end of 972 scans, start offset by 62360 ms.
186. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 562.7 rows x 128 workers. Max 1955 rows (seg41) with 0.028 ms to first row, 19 ms to end of 510 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
187. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
188. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
189. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 172.8 rows x 128 workers. Max 972 rows (seg127) with 0.042 ms to first row, 5.750 ms to end of 972 scans, start offset by 62360 ms.
190. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 562.7 rows x 128 workers. Max 1955 rows (seg41) with 0.028 ms to first row, 18 ms to end of 510 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
191. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 166.4 rows x 128 workers. Max 991 rows (seg127) with 0.042 ms to first row, 5.851 ms to end of 991 scans, start offset by 62360 ms.
192. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 545.2 rows x 128 workers. Max 1946 rows (seg41) with 0.029 ms to first row, 19 ms to end of 503 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
193. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 7.6 rows x 126 workers. Max 29 rows (seg67) with 0.083 ms to first row, 0.571 ms to end of 29 scans, start offset by 61793 ms.
194. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 18.2 rows x 126 workers. Max 73 rows (seg67) with 0.060 ms to first row, 0.486 ms to end of 29 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
195. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 173.9 rows x 128 workers. Max 1001 rows (seg127) with 0.038 ms to first row, 6.180 ms to end of 1001 scans, start offset by 62359 ms.
196. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 563.1 rows x 128 workers. Max 1959 rows (seg41) with 0.027 ms to first row, 19 ms to end of 512 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
197. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
198. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
199. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 173.9 rows x 128 workers. Max 1001 rows (seg127) with 0.045 ms to first row, 6.794 ms to end of 1001 scans, start offset by 62359 ms.
200. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 563.1 rows x 128 workers. Max 1959 rows (seg41) with 0.029 ms to first row, 20 ms to end of 512 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
201. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 165.4 rows x 128 workers. Max 962 rows (seg127) with 0.039 ms to first row, 5.676 ms to end of 962 scans, start offset by 62359 ms.
202. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 544.9 rows x 128 workers. Max 1942 rows (seg41) with 0.026 ms to first row, 18 ms to end of 501 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
203. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 7.5 rows x 126 workers. Max 29 rows (seg67) with 0.096 ms to first row, 0.750 ms to end of 29 scans, start offset by 61793 ms.
204. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 18.0 rows x 126 workers. Max 73 rows (seg67) with 0.074 ms to first row, 0.661 ms to end of 29 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
205. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 172.8 rows x 128 workers. Max 972 rows (seg127) with 0.043 ms to first row, 5.971 ms to end of 972 scans, start offset by 62359 ms.
206. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 562.7 rows x 128 workers. Max 1955 rows (seg41) with 0.030 ms to first row, 19 ms to end of 510 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
207. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
208. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
209. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 172.8 rows x 128 workers. Max 972 rows (seg127) with 0.055 ms to first row, 5.837 ms to end of 972 scans, start offset by 62359 ms.
210. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 562.7 rows x 128 workers. Max 1955 rows (seg41) with 0.028 ms to first row, 19 ms to end of 510 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
211. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 166.4 rows x 128 workers. Max 991 rows (seg127) with 0.041 ms to first row, 5.706 ms to end of 991 scans, start offset by 62359 ms.
212. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 545.2 rows x 128 workers. Max 1946 rows (seg41) with 0.036 ms to first row, 19 ms to end of 503 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
213. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 7.6 rows x 126 workers. Max 29 rows (seg67) with 0.074 ms to first row, 0.566 ms to end of 29 scans, start offset by 61793 ms.
214. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 18.2 rows x 126 workers. Max 73 rows (seg67) with 0.052 ms to first row, 0.466 ms to end of 29 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
215. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 173.9 rows x 128 workers. Max 1001 rows (seg127) with 0.042 ms to first row, 5.784 ms to end of 1001 scans, start offset by 62359 ms.
216. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 563.1 rows x 128 workers. Max 1959 rows (seg41) with 0.032 ms to first row, 19 ms to end of 512 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
217. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
218. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
219. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 173.9 rows x 128 workers. Max 1001 rows (seg127) with 0.050 ms to first row, 5.990 ms to end of 1001 scans, start offset by 62359 ms.
220. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 563.1 rows x 128 workers. Max 1959 rows (seg41) with 0.028 ms to first row, 19 ms to end of 512 scans, start offset by 63340 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
221. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 178.8 rows x 128 workers. Max 966 rows (seg127) with 0.042 ms to first row, 5.651 ms to end of 966 scans, start offset by 62359 ms.
222. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 594.6 rows x 128 workers. Max 2002 rows (seg41) with 0.027 ms to first row, 20 ms to end of 517 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
223. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.5 rows x 126 workers. Max 31 rows (seg67) with 0.091 ms to first row, 0.555 ms to end of 31 scans, start offset by 61793 ms.
224. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.2 rows x 126 workers. Max 75 rows (seg67) with 0.069 ms to first row, 0.467 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
225. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.045 ms to first row, 5.872 ms to end of 976 scans, start offset by 62359 ms.
226. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.026 ms to first row, 20 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
227. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
228. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
229. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.043 ms to first row, 5.814 ms to end of 976 scans, start offset by 62359 ms.
230. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.027 ms to first row, 20 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
231. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 178.8 rows x 128 workers. Max 966 rows (seg127) with 0.045 ms to first row, 5.735 ms to end of 966 scans, start offset by 62359 ms.
232. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 594.6 rows x 128 workers. Max 2002 rows (seg41) with 0.026 ms to first row, 19 ms to end of 517 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
233. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.5 rows x 126 workers. Max 31 rows (seg67) with 0.065 ms to first row, 0.564 ms to end of 31 scans, start offset by 61793 ms.
234. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.2 rows x 126 workers. Max 75 rows (seg67) with 0.044 ms to first row, 0.487 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
235. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.041 ms to first row, 6.050 ms to end of 976 scans, start offset by 62359 ms.
236. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.027 ms to first row, 19 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
237. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
238. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
239. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.041 ms to first row, 6.164 ms to end of 976 scans, start offset by 62359 ms.
240. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.027 ms to first row, 20 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
241. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 178.8 rows x 128 workers. Max 966 rows (seg127) with 0.043 ms to first row, 5.749 ms to end of 966 scans, start offset by 62359 ms.
242. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 594.6 rows x 128 workers. Max 2002 rows (seg41) with 0.028 ms to first row, 19 ms to end of 517 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
243. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.5 rows x 126 workers. Max 31 rows (seg67) with 0.066 ms to first row, 0.579 ms to end of 31 scans, start offset by 61793 ms.
244. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.2 rows x 126 workers. Max 75 rows (seg67) with 0.046 ms to first row, 0.489 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
245. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.042 ms to first row, 6.036 ms to end of 976 scans, start offset by 62359 ms.
246. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.027 ms to first row, 20 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
247. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
248. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
249. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.041 ms to first row, 5.855 ms to end of 976 scans, start offset by 62359 ms.
250. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.032 ms to first row, 21 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
251. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 180.8 rows x 128 workers. Max 995 rows (seg127) with 0.040 ms to first row, 5.738 ms to end of 995 scans, start offset by 62359 ms.
252. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 595.0 rows x 128 workers. Max 2006 rows (seg41) with 0.027 ms to first row, 20 ms to end of 519 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
253. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.7 rows x 126 workers. Max 31 rows (seg67) with 0.075 ms to first row, 0.553 ms to end of 31 scans, start offset by 61793 ms.
254. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.5 rows x 126 workers. Max 75 rows (seg67) with 0.054 ms to first row, 0.465 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
255. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 189.4 rows x 128 workers. Max 1005 rows (seg127) with 0.042 ms to first row, 6.056 ms to end of 1005 scans, start offset by 62359 ms.
256. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 614.2 rows x 128 workers. Max 2019 rows (seg41) with 0.026 ms to first row, 20 ms to end of 528 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
257. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
258. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
259. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 189.4 rows x 128 workers. Max 1005 rows (seg127) with 0.043 ms to first row, 6.221 ms to end of 1005 scans, start offset by 62359 ms.
260. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 614.2 rows x 128 workers. Max 2019 rows (seg41) with 0.028 ms to first row, 21 ms to end of 528 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
261. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 178.8 rows x 128 workers. Max 966 rows (seg127) with 0.040 ms to first row, 5.750 ms to end of 966 scans, start offset by 62359 ms.
262. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 594.6 rows x 128 workers. Max 2002 rows (seg41) with 0.027 ms to first row, 19 ms to end of 517 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
263. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.5 rows x 126 workers. Max 31 rows (seg67) with 0.066 ms to first row, 0.565 ms to end of 31 scans, start offset by 61793 ms.
264. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.2 rows x 126 workers. Max 75 rows (seg67) with 0.046 ms to first row, 0.470 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
265. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.041 ms to first row, 5.759 ms to end of 976 scans, start offset by 62359 ms.
266. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.027 ms to first row, 19 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
267. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
268. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
269. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.046 ms to first row, 5.989 ms to end of 976 scans, start offset by 62359 ms.
270. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.030 ms to first row, 21 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
271. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 178.8 rows x 128 workers. Max 966 rows (seg127) with 0.043 ms to first row, 5.781 ms to end of 966 scans, start offset by 62359 ms.
272. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 594.6 rows x 128 workers. Max 2002 rows (seg41) with 0.034 ms to first row, 20 ms to end of 517 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
273. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.5 rows x 126 workers. Max 31 rows (seg67) with 0.091 ms to first row, 0.602 ms to end of 31 scans, start offset by 61793 ms.
274. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.2 rows x 126 workers. Max 75 rows (seg67) with 0.057 ms to first row, 0.503 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
275. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.041 ms to first row, 5.949 ms to end of 976 scans, start offset by 62359 ms.
276. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.027 ms to first row, 19 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
277. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
278. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
279. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.046 ms to first row, 5.925 ms to end of 976 scans, start offset by 62359 ms.
280. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.027 ms to first row, 20 ms to end of 526 scans, start offset by 63339 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
281. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 178.8 rows x 128 workers. Max 966 rows (seg127) with 0.041 ms to first row, 5.800 ms to end of 966 scans, start offset by 62359 ms.
282. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 594.6 rows x 128 workers. Max 2002 rows (seg41) with 0.026 ms to first row, 19 ms to end of 517 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
283. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.5 rows x 126 workers. Max 31 rows (seg67) with 0.087 ms to first row, 0.583 ms to end of 31 scans, start offset by 61793 ms.
284. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.2 rows x 126 workers. Max 75 rows (seg67) with 0.064 ms to first row, 0.492 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
285. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.042 ms to first row, 6.206 ms to end of 976 scans, start offset by 62359 ms.
286. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.027 ms to first row, 20 ms to end of 526 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
287. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
288. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
289. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.041 ms to first row, 5.754 ms to end of 976 scans, start offset by 62358 ms.
290. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.031 ms to first row, 20 ms to end of 526 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
291. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 183.6 rows x 128 workers. Max 996 rows (seg127) with 0.044 ms to first row, 6.001 ms to end of 996 scans, start offset by 62358 ms.
292. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 595.8 rows x 128 workers. Max 2006 rows (seg41) with 0.033 ms to first row, 19 ms to end of 522 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
293. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.7 rows x 126 workers. Max 31 rows (seg67) with 0.071 ms to first row, 0.562 ms to end of 31 scans, start offset by 61793 ms.
294. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.5 rows x 126 workers. Max 75 rows (seg67) with 0.050 ms to first row, 0.474 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
295. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 192.2 rows x 128 workers. Max 1006 rows (seg127) with 0.039 ms to first row, 6.149 ms to end of 1006 scans, start offset by 62358 ms.
296. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 615.0 rows x 128 workers. Max 2019 rows (seg41) with 0.031 ms to first row, 20 ms to end of 531 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
297. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
298. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
299. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 192.2 rows x 128 workers. Max 1006 rows (seg127) with 0.042 ms to first row, 6.833 ms to end of 1006 scans, start offset by 62358 ms.
300. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 615.0 rows x 128 workers. Max 2019 rows (seg41) with 0.029 ms to first row, 21 ms to end of 531 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
301. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 172.2 rows x 128 workers. Max 966 rows (seg127) with 0.041 ms to first row, 5.707 ms to end of 966 scans, start offset by 62358 ms.
302. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 567.9 rows x 128 workers. Max 2002 rows (seg41) with 0.029 ms to first row, 20 ms to end of 517 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
303. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.5 rows x 126 workers. Max 31 rows (seg67) with 0.069 ms to first row, 0.574 ms to end of 31 scans, start offset by 61793 ms.
304. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.2 rows x 126 workers. Max 75 rows (seg67) with 0.048 ms to first row, 0.482 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
305. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 180.6 rows x 128 workers. Max 976 rows (seg127) with 0.044 ms to first row, 5.861 ms to end of 976 scans, start offset by 62358 ms.
306. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 586.9 rows x 128 workers. Max 2015 rows (seg41) with 0.030 ms to first row, 21 ms to end of 526 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
307. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
308. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
309. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 180.6 rows x 128 workers. Max 976 rows (seg127) with 0.043 ms to first row, 5.901 ms to end of 976 scans, start offset by 62358 ms.
310. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 586.9 rows x 128 workers. Max 2015 rows (seg41) with 0.028 ms to first row, 20 ms to end of 526 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
311. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 174.1 rows x 128 workers. Max 995 rows (seg127) with 0.042 ms to first row, 5.899 ms to end of 995 scans, start offset by 62358 ms.
312. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 568.5 rows x 128 workers. Max 2006 rows (seg41) with 0.030 ms to first row, 20 ms to end of 519 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
313. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.7 rows x 126 workers. Max 31 rows (seg67) with 0.076 ms to first row, 0.584 ms to end of 31 scans, start offset by 61793 ms.
314. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.5 rows x 126 workers. Max 75 rows (seg67) with 0.052 ms to first row, 0.496 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
315. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 182.7 rows x 128 workers. Max 1005 rows (seg127) with 0.047 ms to first row, 6.199 ms to end of 1005 scans, start offset by 62358 ms.
316. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 587.7 rows x 128 workers. Max 2019 rows (seg41) with 0.025 ms to first row, 21 ms to end of 528 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
317. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
318. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
319. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 182.7 rows x 128 workers. Max 1005 rows (seg127) with 0.042 ms to first row, 8.280 ms to end of 1005 scans, start offset by 62358 ms.
320. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 587.7 rows x 128 workers. Max 2019 rows (seg41) with 0.032 ms to first row, 22 ms to end of 528 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
321. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 178.8 rows x 128 workers. Max 966 rows (seg127) with 0.049 ms to first row, 5.761 ms to end of 966 scans, start offset by 62358 ms.
322. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 594.6 rows x 128 workers. Max 2002 rows (seg41) with 0.030 ms to first row, 20 ms to end of 517 scans, start offset by 63338 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
323. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.5 rows x 126 workers. Max 31 rows (seg67) with 0.069 ms to first row, 0.610 ms to end of 31 scans, start offset by 61793 ms.
324. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.2 rows x 126 workers. Max 75 rows (seg67) with 0.049 ms to first row, 0.509 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
325. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.044 ms to first row, 5.991 ms to end of 976 scans, start offset by 62358 ms.
326. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.033 ms to first row, 20 ms to end of 526 scans, start offset by 63337 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
327. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
328. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
329. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 187.2 rows x 128 workers. Max 976 rows (seg127) with 0.041 ms to first row, 5.807 ms to end of 976 scans, start offset by 62358 ms.
330. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 613.5 rows x 128 workers. Max 2015 rows (seg41) with 0.027 ms to first row, 21 ms to end of 526 scans, start offset by 63337 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
331. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 183.6 rows x 128 workers. Max 996 rows (seg127) with 0.043 ms to first row, 5.858 ms to end of 996 scans, start offset by 62358 ms.
332. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 595.8 rows x 128 workers. Max 2006 rows (seg41) with 0.027 ms to first row, 20 ms to end of 522 scans, start offset by 63337 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
333. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 8.7 rows x 126 workers. Max 31 rows (seg67) with 0.073 ms to first row, 0.564 ms to end of 31 scans, start offset by 61793 ms.
334. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 19.5 rows x 126 workers. Max 75 rows (seg67) with 0.050 ms to first row, 0.469 ms to end of 31 scans, start offset by 61793 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
335. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 192.2 rows x 128 workers. Max 1006 rows (seg127) with 0.052 ms to first row, 6.061 ms to end of 1006 scans, start offset by 62358 ms.
336. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 615.0 rows x 128 workers. Max 2019 rows (seg41) with 0.027 ms to first row, 20 ms to end of 531 scans, start offset by 63337 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
337. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
338. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: (No row requested) 0 rows (seg0) with 0 ms to end.
339. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.01..25.02 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 192.2 rows x 128 workers. Max 1006 rows (seg127) with 0.047 ms to first row, 6.189 ms to end of 1006 scans, start offset by 62358 ms.
340. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..25.00 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, ($3::date + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 615.0 rows x 128 workers. Max 2019 rows (seg41) with 0.029 ms to first row, 22 ms to end of 531 scans, start offset by 63337 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
341. 0.000 0.000 ↓ 0.0

Aggregate (cost=27.51..27.52 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 481.1 rows x 128 workers. Max 1336 rows (seg4) with 0.036 ms to first row, 13 ms to end of 1336 scans, start offset by 62363 ms.
342. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..27.50 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, (CASE WHEN $0 IS NOT NULL THEN $0::date ELSE $1::date END + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 1269.8 rows x 128 workers. Max 2794 rows (seg79) with 0.032 ms to first row, 13 ms to end of 884 scans, start offset by 62359 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
343. 0.000 0.000 ↓ 0.0

Aggregate (cost=27.51..27.52 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 45.5 rows x 128 workers. Max 173 rows (seg97) with 0.051 ms to first row, 3.163 ms to end of 173 scans, start offset by 62197 ms.
344. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..27.50 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, (CASE WHEN $0 IS NOT NULL THEN $0::date ELSE $1::date END + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 96.0 rows x 128 workers. Max 454 rows (seg97) with 0.033 ms to first row, 2.712 ms to end of 173 scans, start offset by 62197 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
345. 0.000 0.000 ↓ 0.0

Aggregate (cost=27.51..27.52 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 526.6 rows x 128 workers. Max 1389 rows (seg4) with 0.053 ms to first row, 14 ms to end of 1389 scans, start offset by 62363 ms.
346. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..27.50 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, (CASE WHEN $0 IS NOT NULL THEN $0::date ELSE $1::date END + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 1365.8 rows x 128 workers. Max 2942 rows (seg79) with 0.037 ms to first row, 14 ms to end of 938 scans, start offset by 62359 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
347. 0.000 0.000 ↓ 0.0

Aggregate (cost=27.51..27.52 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 3.4 rows x 73 workers. Max 36 rows (seg111) with 0.081 ms to first row, 0.224 ms to end of 36 scans, start offset by 62215 ms.
348. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..27.50 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, (CASE WHEN $0 IS NOT NULL THEN $0::date ELSE $1::date END + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 14.0 rows x 7 workers. Max 72 rows (seg112) with 0.016 ms to first row, 0.611 ms to end of 36 scans, start offset by 62188 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).
349. 0.000 0.000 ↓ 0.0

Aggregate (cost=27.51..27.52 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 528.5 rows x 128 workers. Max 1390 rows (seg4) with 0.095 ms to first row, 21 ms to end of 1390 scans, start offset by 62363 ms.
350. 0.000 0.000 ↓ 0.0

Function Scan on generate_series i (cost=0.00..27.50 rows=2 width=0) (actual rows= loops=)

  • Filter: date_part('dow'::text, (CASE WHEN $0 IS NOT NULL THEN $0::date ELSE $1::date END + i)::timestamp without time zone) = ANY ('{0,6}'::double precision[])
  • Rows out: Avg 1366.6 rows x 128 workers. Max 2942 rows (seg79) with 0.074 ms to first row, 19 ms to end of 938 scans, start offset by 62359 ms.
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0).