GroupAggregate (cost=10008280752.32..10008281029.52 rows=7920 width=68) Group Key: (COALESCE(adres_pe.id_s, '-1'::integer)), (COALESCE(tijd.tijdkey, 'Unknown'::character varying)), (COALESCE(di01905cluster.id_s, '-1'::integer)), (COALESCE(di02697relatie_pe.id_s, '-1'::integer)), (COALESCE(di04238cluster.id_s, '-1'::integer)), (COALESCE(di04306natuurlijkpersoon.id_s, '-1'::integer)), (COALESCE(eenheid_pe.id_s, '-1'::integer)), (COALESCE(s_h_huurovereenkomst_ssm.id_s, '-1'::integer)) -> Sort (cost=10008280752.32..10008280772.12 rows=7920 width=81) Sort Key: (COALESCE(adres_pe.id_s, '-1'::integer)), (COALESCE(tijd.tijdkey, 'Unknown'::character varying)), (COALESCE(di01905cluster.id_s, '-1'::integer)), (COALESCE(di02697relatie_pe.id_s, '-1'::integer)), (COALESCE(di04238cluster.id_s, '-1'::integer)), (COALESCE(di04306natuurlijkpersoon.id_s, '-1'::integer)), (COALESCE(eenheid_pe.id_s, '-1'::integer)), (COALESCE(s_h_huurovereenkomst_ssm.id_s, '-1'::integer)) -> Hash Right Join (cost=10008276299.12..10008280239.45 rows=7920 width=81) Hash Cond: (adres_pe.id_h_adres = l_adres_eenheid_ssm_pe.id_h_adres) Join Filter: ((adres_pe.dv_start_dts <= tijd.einddatum) AND (adres_pe.dv_end_dts > tijd.einddatum)) -> Seq Scan on s_h_adres_ssm adres_pe (cost=0.00..3448.57 rows=99457 width=24) -> Hash (cost=10008276200.12..10008276200.12 rows=7920 width=87) -> Hash Right Join (cost=10008270566.20..10008276200.12 rows=7920 width=87) Hash Cond: (l_cluster_eenheid_ssm.id_h_eenheid = l_huurovk_eenheid_ssm_pe.id_h_eenheid) Join Filter: ((di01905cluster.dv_start_dts <= tijd.einddatum) AND (di01905cluster.dv_end_dts > tijd.einddatum)) -> Hash Join (cost=168.45..5335.54 rows=50936 width=24) Hash Cond: (l_cluster_eenheid_ssm.id_h_cluster = di01905cluster.id_h_cluster) -> Seq Scan on l_cluster_eenheid_ssm (cost=0.00..3901.53 rows=201653 width=8) -> Hash (cost=155.05..155.05 rows=1072 width=24) -> Seq Scan on s_h_cluster_ssm di01905cluster (cost=0.00..155.05 rows=1072 width=24) Filter: (soort = 'FIN'::text) -> Hash (cost=10008270298.75..10008270298.75 rows=7920 width=87) -> Merge Left Join (cost=10008269702.10..10008270298.75 rows=7920 width=87) Merge Cond: (l_huurovk_eenheid_ssm_pe.id_h_eenheid = l_adres_eenheid_ssm_pe.id_h_eenheid) Join Filter: ((l_adres_eenheid_ssm_pe.dv_start_dts <= tijd.einddatum) AND (l_adres_eenheid_ssm_pe.dv_end_dts > tijd.einddatum)) -> Merge Left Join (cost=10008266881.95..10008267200.29 rows=7920 width=83) Merge Cond: (l_huurovk_eenheid_ssm_pe.id_h_eenheid = eenheid_pe.id_h_eenheid) Join Filter: ((eenheid_pe.dv_start_dts <= tijd.einddatum) AND (eenheid_pe.dv_end_dts > tijd.einddatum)) -> Merge Left Join (cost=10008262760.80..10008262800.83 rows=7920 width=79) Merge Cond: (l_huurovk_eenheid_ssm_pe.id_h_eenheid = l_cluster_eenheid_ssm_1.id_h_eenheid) Join Filter: ((di04238cluster.dv_start_dts <= tijd.einddatum) AND (di04238cluster.dv_end_dts > tijd.einddatum)) -> Sort (cost=10008257946.19..10008257965.99 rows=7920 width=75) Sort Key: l_huurovk_eenheid_ssm_pe.id_h_eenheid -> Hash Right Join (cost=10008256464.89..10008257433.32 rows=7920 width=75) Hash Cond: (l_huurovk_eenheid_ssm_pe.id_h_huurovereenkomst = s_h_huurovereenkomst_ssm.id_h_huurovereenkomst) Join Filter: ((l_huurovk_eenheid_ssm_pe.dv_start_dts <= tijd.einddatum) AND (l_huurovk_eenheid_ssm_pe.dv_end_dts > tijd.einddatum)) -> Seq Scan on l_huurovk_eenheid_ssm l_huurovk_eenheid_ssm_pe (cost=0.00..711.73 rows=36773 width=24) -> Hash (cost=10008256365.89..10008256365.89 rows=7920 width=75) -> Merge Join (cost=10008254756.36..10008256365.89 rows=7920 width=75) Merge Cond: (s_h_huurovereenkomst_ssm.id_h_huurovereenkomst = l_huurovk_ovk_ssm_pe.id_h_huurovereenkomst) Join Filter: ((s_h_huurovereenkomst_ssm.dv_start_dts <= tijd.einddatum) AND (s_h_huurovereenkomst_ssm.dv_end_dts > tijd.einddatum)) -> Sort (cost=4365.23..4457.16 rows=36773 width=45) Sort Key: s_h_huurovereenkomst_ssm.id_h_huurovereenkomst -> Seq Scan on s_h_huurovereenkomst_ssm (cost=0.00..1576.66 rows=36773 width=45) Filter: (soort = 'HUU'::text) -> Sort (cost=10008250391.14..10008250569.35 rows=71283 width=50) Sort Key: l_huurovk_ovk_ssm_pe.id_h_huurovereenkomst -> Nested Loop (cost=10000034476.78..10008244645.28 rows=71283 width=50) -> Seq Scan on tijd (cost=0.00..16.00 rows=600 width=38) -> Hash Right Join (cost=34476.78..48159.17 rows=119 width=52) Hash Cond: (l_ovk_ovkrel_ssm.id_h_overeenkomst = l_huurovk_ovk_ssm_pe.id_h_overeenkomst) -> Hash Join (cost=9980.35..23662.73 rows=1 width=8) Hash Cond: ((l_ovk_ovkrel_ssm.id_h_overeenkomst = l_huurovk_ovk_ssm.id_h_overeenkomst) AND (ve02698.huurovereenkomst_id = huurovereenkomst_pe.id_s)) -> Hash Join (cost=7308.91..20979.66 rows=1548 width=12) Hash Cond: (ve02698.ve02698 = di04306natuurlijkpersoon.identificatie) -> Seq Scan on mv_ve0269801 ve02698 (cost=0.00..13559.04 rows=25663 width=15) Filter: ((ve02698 IS NOT NULL) AND ((calender_id)::text = (COALESCE(tijd.tijdkey, 'Unknown'::character varying))::text)) -> Hash (cost=7243.78..7243.78 rows=5210 width=18) -> Hash Join (cost=6107.87..7243.78 rows=5210 width=18) Hash Cond: (l_ovk_ovkrel_ssm.id_h_overeenkomstrelatie = l_ovkrel_rel_ssm.id_h_overeenkomstrelatie) -> Seq Scan on l_ovk_ovkrel_ssm (cost=0.00..907.95 rows=46895 width=8) -> Hash (cost=6042.75..6042.75 rows=5210 width=18) -> Hash Join (cost=4906.83..6042.75 rows=5210 width=18) Hash Cond: (l_ovkrel_rel_ssm.id_h_relatie = l_natuurlijkpersoon_rel_ssm.id_h_relatie) -> Seq Scan on l_ovkrel_rel_ssm (cost=0.00..907.95 rows=46895 width=8) -> Hash (cost=4795.86..4795.86 rows=8878 width=18) -> Hash Join (cost=2861.42..4795.86 rows=8878 width=18) Hash Cond: (l_natuurlijkpersoon_rel_ssm.id_h_natuurlijkpersoon = di04306natuurlijkpersoon.id_h_natuurlijkpersoon) -> Seq Scan on l_natuurlijkpersoon_rel_ssm (cost=0.00..1546.02 rows=79902 width=8) -> Hash (cost=2741.47..2741.47 rows=9596 width=18) -> Seq Scan on s_h_natuurlijkpersoon_ssm di04306natuurlijkpersoon (cost=0.00..2741.47 rows=9596 width=18) Filter: ((dv_start_dts <= tijd.einddatum) AND (dv_end_dts > tijd.einddatum)) -> Hash (cost=2610.16..2610.16 rows=4086 width=8) -> Hash Join (cost=1719.67..2610.16 rows=4086 width=8) Hash Cond: (l_huurovk_ovk_ssm.id_h_huurovereenkomst = huurovereenkomst_pe.id_h_huurovereenkomst) -> Seq Scan on l_huurovk_ovk_ssm (cost=0.00..711.73 rows=36773 width=8) -> Hash (cost=1668.60..1668.60 rows=4086 width=8) -> Seq Scan on s_h_huurovereenkomst_ssm huurovereenkomst_pe (cost=0.00..1668.60 rows=4086 width=8) Filter: ((dv_start_dts <= tijd.einddatum) AND (dv_end_dts > tijd.einddatum)) -> Hash (cost=24494.94..24494.94 rows=119 width=52) -> Hash Join (cost=22963.59..24494.94 rows=119 width=52) Hash Cond: (overeenkomst_pe.id_h_overeenkomst = l_huurovk_ovk_ssm_pe.id_h_overeenkomst) Join Filter: ((overeenkomst_pe.dv_start_dts <= tijd.einddatum) AND (overeenkomst_pe.dv_end_dts > tijd.einddatum) AND (overeenkomst_pe.begindatum <= tijd.einddatum) AND ((overeenkomst_pe.einddatum >= tijd.einddatum) OR (overeenkomst_pe.einddatum IS NULL))) -> Seq Scan on s_h_overeenkomst_ssm overeenkomst_pe (cost=0.00..1311.73 rows=36773 width=28) -> Hash (cost=22912.51..22912.51 rows=4086 width=28) -> Hash Left Join (cost=22062.87..22912.51 rows=4086 width=28) Hash Cond: (l_huurovk_ovk_ssm_pe.id_h_overeenkomst = di02697relatie_pe.id_h_overeenkomst) Filter: ((l_huurovk_ovk_ssm_pe.dv_start_dts <= tijd.einddatum) AND (l_huurovk_ovk_ssm_pe.dv_end_dts > tijd.einddatum)) -> Seq Scan on l_huurovk_ovk_ssm l_huurovk_ovk_ssm_pe (cost=0.00..711.73 rows=36773 width=24) -> Hash (cost=22062.85..22062.85 rows=1 width=8) -> Subquery Scan on di02697relatie_pe (cost=8381.54..22062.85 rows=1 width=8) -> Hash Join (cost=8381.54..22062.85 rows=1 width=8) Hash Cond: ((l_ovk_ovkrel_ssm_1.id_h_overeenkomst = l_huurovk_ovk_ssm_1.id_h_overeenkomst) AND (ve02698_1.huurovereenkomst_id = huurovereenkomst_pe_1.id_s)) -> Hash Join (cost=5710.09..19380.23 rows=1487 width=12) Hash Cond: (ve02698_1.ve02698 = di02697relatie.identificatie) -> Seq Scan on mv_ve0269801 ve02698_1 (cost=0.00..13559.04 rows=25663 width=15) Filter: ((ve02698 IS NOT NULL) AND ((calender_id)::text = (COALESCE(tijd.tijdkey, 'Unknown'::character varying))::text)) -> Hash (cost=5644.97..5644.97 rows=5210 width=18) -> Hash Join (cost=4509.06..5644.97 rows=5210 width=18) Hash Cond: (l_ovk_ovkrel_ssm_1.id_h_overeenkomstrelatie = l_ovkrel_rel_ssm_1.id_h_overeenkomstrelatie) -> Seq Scan on l_ovk_ovkrel_ssm l_ovk_ovkrel_ssm_1 (cost=0.00..907.95 rows=46895 width=8) -> Hash (cost=4443.93..4443.93 rows=5210 width=18) -> Hash Join (cost=3308.03..4443.93 rows=5210 width=18) Hash Cond: (l_ovkrel_rel_ssm_1.id_h_relatie = di02697relatie.id_h_relatie) -> Seq Scan on l_ovkrel_rel_ssm l_ovkrel_rel_ssm_1 (cost=0.00..907.95 rows=46895 width=8) -> Hash (cost=3183.11..3183.11 rows=9993 width=18) -> Seq Scan on s_h_relatie_ssm di02697relatie (cost=0.00..3183.11 rows=9993 width=18) Filter: ((dv_start_dts <= tijd.einddatum) AND (dv_end_dts > tijd.einddatum)) -> Hash (cost=2610.16..2610.16 rows=4086 width=8) -> Hash Join (cost=1719.67..2610.16 rows=4086 width=8) Hash Cond: (l_huurovk_ovk_ssm_1.id_h_huurovereenkomst = huurovereenkomst_pe_1.id_h_huurovereenkomst) -> Seq Scan on l_huurovk_ovk_ssm l_huurovk_ovk_ssm_1 (cost=0.00..711.73 rows=36773 width=8) -> Hash (cost=1668.60..1668.60 rows=4086 width=8) -> Seq Scan on s_h_huurovereenkomst_ssm huurovereenkomst_pe_1 (cost=0.00..1668.60 rows=4086 width=8) Filter: ((dv_start_dts <= tijd.einddatum) AND (dv_end_dts > tijd.einddatum)) -> Sort (cost=4814.61..4814.73 rows=48 width=24) Sort Key: l_cluster_eenheid_ssm_1.id_h_eenheid -> Hash Join (cost=155.06..4813.27 rows=48 width=24) Hash Cond: (l_cluster_eenheid_ssm_1.id_h_cluster = di04238cluster.id_h_cluster) -> Seq Scan on l_cluster_eenheid_ssm l_cluster_eenheid_ssm_1 (cost=0.00..3901.53 rows=201653 width=8) -> Hash (cost=155.05..155.05 rows=1 width=24) -> Seq Scan on s_h_cluster_ssm di04238cluster (cost=0.00..155.05 rows=1 width=24) Filter: (soort = 'OND'::text) -> Sort (cost=4121.14..4196.33 rows=30079 width=24) Sort Key: eenheid_pe.id_h_eenheid -> Seq Scan on s_h_eenheid_ssm eenheid_pe (cost=0.00..1883.79 rows=30079 width=24) -> Sort (cost=2820.14..2895.33 rows=30079 width=24) Sort Key: l_adres_eenheid_ssm_pe.id_h_eenheid -> Seq Scan on l_adres_eenheid_ssm l_adres_eenheid_ssm_pe (cost=0.00..582.79 rows=30079 width=24)