explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H74c : Optimization for: plan #fG0d

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.088 727.841 ↑ 1.0 25 1

Limit (cost=1,030,228.73..1,030,234.35 rows=25 width=1,042) (actual time=727.734..727.841 rows=25 loops=1)

  • Output: va.antrag_version_id, va.antrags_nr, va.ausgang, va.beratungs_nr, va.count_of_status_disabling_loeschen, va.creation_source, va.eingang, va.eingangskanal, va.erfasser_id, va.erfasser_name, va.external_kunden_nr, va.finanzierungs_nr, va.geschaeftsfall, va.gesuchsgrund_id, va.gesuchsgrund_bezeichnung_de, va.gesuchsgrund_bezeichnung_en, va.gesuchsgrund_bezeichnung_fr, va.gesuchsgrund_bezeichnung_it, va.is_erfasser_ro, va.kunden_id, va.kunden_key, va.kunden_nr, va.kundenberater_id, va.kundenberater_name, va.kundenbezeichnung, va.kundensegmentpruefung_id, va.kundentyp_id, va.kundentyp_bezeichnung_de, va.kundentyp_bezeichnung_en, va.kundentyp_bezeichnung_fr, va.kundentyp_bezeichnung_it, va.rahmenlimite_menge, va.rahmenlimite_waehrung, va.rating_abschluss_neu_id, va.status, 0
  • Buffers: shared hit=25,297
2. 0.022 727.753 ↑ 431.3 25 1

Unique (cost=1,030,228.73..1,032,654.68 rows=10,782 width=1,042) (actual time=727.729..727.753 rows=25 loops=1)

  • Output: va.antrag_version_id, va.antrags_nr, va.ausgang, va.beratungs_nr, va.count_of_status_disabling_loeschen, va.creation_source, va.eingang, va.eingangskanal, va.erfasser_id, va.erfasser_name, va.external_kunden_nr, va.finanzierungs_nr, va.geschaeftsfall, va.gesuchsgrund_id, va.gesuchsgrund_bezeichnung_de, va.gesuchsgrund_bezeichnung_en, va.gesuchsgrund_bezeichnung_fr, va.gesuchsgrund_bezeichnung_it, va.is_erfasser_ro, va.kunden_id, va.kunden_key, va.kunden_nr, va.kundenberater_id, va.kundenberater_name, va.kundenbezeichnung, va.kundensegmentpruefung_id, va.kundentyp_id, va.kundentyp_bezeichnung_de, va.kundentyp_bezeichnung_en, va.kundentyp_bezeichnung_fr, va.kundentyp_bezeichnung_it, va.rahmenlimite_menge, va.rahmenlimite_waehrung, va.rating_abschluss_neu_id, va.status, 0
  • Buffers: shared hit=25,297
3. 4.512 727.731 ↑ 1,078.2 25 1

Sort (cost=1,030,228.73..1,030,296.12 rows=26,955 width=1,042) (actual time=727.729..727.731 rows=25 loops=1)

  • Output: va.antrag_version_id, va.antrags_nr, va.ausgang, va.beratungs_nr, va.count_of_status_disabling_loeschen, va.creation_source, va.eingang, va.eingangskanal, va.erfasser_id, va.erfasser_name, va.external_kunden_nr, va.finanzierungs_nr, va.geschaeftsfall, va.gesuchsgrund_id, va.gesuchsgrund_bezeichnung_de, va.gesuchsgrund_bezeichnung_en, va.gesuchsgrund_bezeichnung_fr, va.gesuchsgrund_bezeichnung_it, va.is_erfasser_ro, va.kunden_id, va.kunden_key, va.kunden_nr, va.kundenberater_id, va.kundenberater_name, va.kundenbezeichnung, va.kundensegmentpruefung_id, va.kundentyp_id, va.kundentyp_bezeichnung_de, va.kundentyp_bezeichnung_en, va.kundentyp_bezeichnung_fr, va.kundentyp_bezeichnung_it, va.rahmenlimite_menge, va.rahmenlimite_waehrung, va.rating_abschluss_neu_id, va.status, 0
  • Sort Key: va.eingang DESC, va.antrag_version_id, va.antrags_nr, va.ausgang, va.beratungs_nr, va.count_of_status_disabling_loeschen, va.creation_source, va.eingangskanal, va.erfasser_id, va.erfasser_name, va.external_kunden_nr, va.finanzierungs_nr, va.geschaeftsfall, va.gesuchsgrund_id, va.gesuchsgrund_bezeichnung_de, va.gesuchsgrund_bezeichnung_en, va.gesuchsgrund_bezeichnung_fr, va.gesuchsgrund_bezeichnung_it, va.is_erfasser_ro, va.kunden_id, va.kunden_key, va.kunden_nr, va.kundenberater_id, va.kundenberater_name, va.kundenbezeichnung, va.kundensegmentpruefung_id, va.kundentyp_id, va.kundentyp_bezeichnung_de, va.kundentyp_bezeichnung_en, va.kundentyp_bezeichnung_fr, va.kundentyp_bezeichnung_it, va.rahmenlimite_menge, va.rahmenlimite_waehrung, va.rating_abschluss_neu_id, va.status
  • Sort Method: quicksort Memory: 2,139kB
  • Buffers: shared hit=25,297
4. 2.761 723.219 ↑ 6.6 4,076 1

Hash Join (cost=989,983.49..1,015,897.08 rows=26,955 width=1,042) (actual time=716.924..723.219 rows=4,076 loops=1)

  • Output: va.antrag_version_id, va.antrags_nr, va.ausgang, va.beratungs_nr, va.count_of_status_disabling_loeschen, va.creation_source, va.eingang, va.eingangskanal, va.erfasser_id, va.erfasser_name, va.external_kunden_nr, va.finanzierungs_nr, va.geschaeftsfall, va.gesuchsgrund_id, va.gesuchsgrund_bezeichnung_de, va.gesuchsgrund_bezeichnung_en, va.gesuchsgrund_bezeichnung_fr, va.gesuchsgrund_bezeichnung_it, va.is_erfasser_ro, va.kunden_id, va.kunden_key, va.kunden_nr, va.kundenberater_id, va.kundenberater_name, va.kundenbezeichnung, va.kundensegmentpruefung_id, va.kundentyp_id, va.kundentyp_bezeichnung_de, va.kundentyp_bezeichnung_en, va.kundentyp_bezeichnung_fr, va.kundentyp_bezeichnung_it, va.rahmenlimite_menge, va.rahmenlimite_waehrung, va.rating_abschluss_neu_id, va.status, 0
  • Inner Unique: true
  • Hash Cond: (va.antrag_version_id = antragvers1_.antrag_version_id)
  • Buffers: shared hit=25,267
5. 3.201 392.681 ↑ 12.7 4,247 1

Unique (cost=639,437.46..664,370.55 rows=53,910 width=1,054) (actual time=389.125..392.681 rows=4,247 loops=1)

  • Output: va.mandant_id, va.antrag_version_id, va.kunden_id, va.kunden_nr, va.external_kunden_nr, va.kunden_key, va.kundenbezeichnung, va.kundenberater_id, va.kundenberater_name, va.kundentyp_id, va.kundentyp_bezeichnung_de, va.kundentyp_bezeichnung_en, va.kundentyp_bezeichnung_fr, va.kundentyp_bezeichnung_it, va.creation_source, va.rating_abschluss_neu_id, va.geschaeftsfall, va.rahmenlimite_menge, va.rahmenlimite_waehrung, va.gesuchsgrund_id, va.gesuchsgrund_bezeichnung_de, va.gesuchsgrund_bezeichnung_en, va.gesuchsgrund_bezeichnung_fr, va.gesuchsgrund_bezeichnung_it, va.status, va.antrags_nr, va.erfasser_id, va.is_erfasser_ro, va.erfasser_name, va.eingang, va.ausgang, va.eingangskanal, va.finanzierungs_nr, va.count_of_status_disabling_loeschen, va.beratungs_nr, va.kundensegmentpruefung_id
  • Buffers: shared hit=12,803
6. 10.568 389.480 ↑ 55.5 4,853 1

Sort (cost=639,437.46..640,111.32 rows=269,547 width=1,054) (actual time=389.124..389.480 rows=4,853 loops=1)

  • Output: va.mandant_id, va.antrag_version_id, va.kunden_id, va.kunden_nr, va.external_kunden_nr, va.kunden_key, va.kundenbezeichnung, va.kundenberater_id, va.kundenberater_name, va.kundentyp_id, va.kundentyp_bezeichnung_de, va.kundentyp_bezeichnung_en, va.kundentyp_bezeichnung_fr, va.kundentyp_bezeichnung_it, va.creation_source, va.rating_abschluss_neu_id, va.geschaeftsfall, va.rahmenlimite_menge, va.rahmenlimite_waehrung, va.gesuchsgrund_id, va.gesuchsgrund_bezeichnung_de, va.gesuchsgrund_bezeichnung_en, va.gesuchsgrund_bezeichnung_fr, va.gesuchsgrund_bezeichnung_it, va.status, va.antrags_nr, va.erfasser_id, va.is_erfasser_ro, va.erfasser_name, va.eingang, va.ausgang, va.eingangskanal, va.finanzierungs_nr, va.count_of_status_disabling_loeschen, va.beratungs_nr, va.kundensegmentpruefung_id
  • Sort Key: va.mandant_id, va.antrag_version_id, va.kunden_id, va.kunden_nr, va.external_kunden_nr, va.kunden_key, va.kundenbezeichnung, va.kundenberater_id, va.kundenberater_name, va.kundentyp_id, va.kundentyp_bezeichnung_de, va.kundentyp_bezeichnung_en, va.kundentyp_bezeichnung_fr, va.kundentyp_bezeichnung_it, va.creation_source, va.rating_abschluss_neu_id, va.geschaeftsfall, va.rahmenlimite_menge, va.rahmenlimite_waehrung, va.gesuchsgrund_id, va.gesuchsgrund_bezeichnung_de, va.gesuchsgrund_bezeichnung_en, va.gesuchsgrund_bezeichnung_fr, va.gesuchsgrund_bezeichnung_it, va.status, va.antrags_nr, va.erfasser_id, va.is_erfasser_ro, va.erfasser_name, va.eingang, va.ausgang, va.eingangskanal, va.finanzierungs_nr, va.count_of_status_disabling_loeschen, va.beratungs_nr, va.kundensegmentpruefung_id
  • Sort Method: quicksort Memory: 2,630kB
  • Buffers: shared hit=12,803
7. 2.292 378.912 ↑ 55.5 4,853 1

Subquery Scan on va (cost=335,374.17..366,372.08 rows=269,547 width=1,054) (actual time=371.651..378.912 rows=4,853 loops=1)

  • Output: va.mandant_id, va.antrag_version_id, va.kunden_id, va.kunden_nr, va.external_kunden_nr, va.kunden_key, va.kundenbezeichnung, va.kundenberater_id, va.kundenberater_name, va.kundentyp_id, va.kundentyp_bezeichnung_de, va.kundentyp_bezeichnung_en, va.kundentyp_bezeichnung_fr, va.kundentyp_bezeichnung_it, va.creation_source, va.rating_abschluss_neu_id, va.geschaeftsfall, va.rahmenlimite_menge, va.rahmenlimite_waehrung, va.gesuchsgrund_id, va.gesuchsgrund_bezeichnung_de, va.gesuchsgrund_bezeichnung_en, va.gesuchsgrund_bezeichnung_fr, va.gesuchsgrund_bezeichnung_it, va.status, va.antrags_nr, va.erfasser_id, va.is_erfasser_ro, va.erfasser_name, va.eingang, va.ausgang, va.eingangskanal, va.finanzierungs_nr, va.count_of_status_disabling_loeschen, va.beratungs_nr, va.kundensegmentpruefung_id
  • Buffers: shared hit=12,803
8. 4.263 376.620 ↑ 55.5 4,853 1

Unique (cost=335,374.17..363,676.61 rows=269,547 width=1,126) (actual time=371.643..376.620 rows=4,853 loops=1)

  • Output: av.id, k.id, a.mandant_id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (k.kundenbezeichnung IS NULL) THEN (concat(ep.name, ' ', ep.vorname))::citext ELSE (k.kundenbezeichnung)::citext END), k.kundenberater_id, (concat(kb.vorname, ' ', kb.name)), k.kundentyp_id, ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, k.creation_source, k.rating_abschluss_neu_id, av.geschaeftsfall, (CASE WHEN (f.rahmenlimite_wert_neu_menge IS NULL) THEN f.rahmenlimite_wert_bisher_menge ELSE f.rahmenlimite_wert_neu_menge END), (CASE WHEN (f.rahmenlimite_wert_neu_menge IS NULL) THEN f.rahmenlimite_wert_bisher_waehrung ELSE f.rahmenlimite_wert_neu_waehrung END), av.gesuchsgrund_id, g.bezeichnung_de, g.bezeichnung_en, g.bezeichnung_fr, g.bezeichnung_it, av.status, a.antrags_nr, (COALESCE(newest_unrejected_av.einreicher_id, av.sachbearbeiter_id)), ((newest_unrejected_av.id IS NOT NULL)), (CASE WHEN (newest_unrejected_av_einreicher.id IS NOT NULL) THEN concat(newest_unrejected_av_einreicher.vorname, ' ', newest_unrejected_av_einreicher.name) ELSE concat(pb.vorname, ' ', pb.name) END), av.eingang, av.ausgang, a.eingangskanal, f.finanzierungs_nr, (COALESCE((a_st_loeschen.count_of_status_disabling_loeschen)::integer, 0)), a.beratungs_nr, (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), (COALESCE((p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig)::integer, 0)), pbt.team, pba.abteilung, pbb.bereich
  • Buffers: shared hit=12,803
9. 62.345 372.357 ↑ 55.5 4,853 1

Sort (cost=335,374.17..336,048.04 rows=269,547 width=1,126) (actual time=371.641..372.357 rows=4,853 loops=1)

  • Output: av.id, k.id, a.mandant_id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (k.kundenbezeichnung IS NULL) THEN (concat(ep.name, ' ', ep.vorname))::citext ELSE (k.kundenbezeichnung)::citext END), k.kundenberater_id, (concat(kb.vorname, ' ', kb.name)), k.kundentyp_id, ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, k.creation_source, k.rating_abschluss_neu_id, av.geschaeftsfall, (CASE WHEN (f.rahmenlimite_wert_neu_menge IS NULL) THEN f.rahmenlimite_wert_bisher_menge ELSE f.rahmenlimite_wert_neu_menge END), (CASE WHEN (f.rahmenlimite_wert_neu_menge IS NULL) THEN f.rahmenlimite_wert_bisher_waehrung ELSE f.rahmenlimite_wert_neu_waehrung END), av.gesuchsgrund_id, g.bezeichnung_de, g.bezeichnung_en, g.bezeichnung_fr, g.bezeichnung_it, av.status, a.antrags_nr, (COALESCE(newest_unrejected_av.einreicher_id, av.sachbearbeiter_id)), ((newest_unrejected_av.id IS NOT NULL)), (CASE WHEN (newest_unrejected_av_einreicher.id IS NOT NULL) THEN concat(newest_unrejected_av_einreicher.vorname, ' ', newest_unrejected_av_einreicher.name) ELSE concat(pb.vorname, ' ', pb.name) END), av.eingang, av.ausgang, a.eingangskanal, f.finanzierungs_nr, (COALESCE((a_st_loeschen.count_of_status_disabling_loeschen)::integer, 0)), a.beratungs_nr, (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), (COALESCE((p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig)::integer, 0)), pbt.team, pba.abteilung, pbb.bereich
  • Sort Key: av.id, k.id, a.mandant_id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (k.kundenbezeichnung IS NULL) THEN (concat(ep.name, ' ', ep.vorname))::citext ELSE (k.kundenbezeichnung)::citext END), k.kundenberater_id, (concat(kb.vorname, ' ', kb.name)), k.kundentyp_id, ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, k.creation_source, k.rating_abschluss_neu_id, av.geschaeftsfall, (CASE WHEN (f.rahmenlimite_wert_neu_menge IS NULL) THEN f.rahmenlimite_wert_bisher_menge ELSE f.rahmenlimite_wert_neu_menge END), (CASE WHEN (f.rahmenlimite_wert_neu_menge IS NULL) THEN f.rahmenlimite_wert_bisher_waehrung ELSE f.rahmenlimite_wert_neu_waehrung END), av.gesuchsgrund_id, g.bezeichnung_de, g.bezeichnung_en, g.bezeichnung_fr, g.bezeichnung_it, av.status, a.antrags_nr, (COALESCE(newest_unrejected_av.einreicher_id, av.sachbearbeiter_id)), ((newest_unrejected_av.id IS NOT NULL)), (CASE WHEN (newest_unrejected_av_einreicher.id IS NOT NULL) THEN concat(newest_unrejected_av_einreicher.vorname, ' ', newest_unrejected_av_einreicher.name) ELSE concat(pb.vorname, ' ', pb.name) END), av.eingang, av.ausgang, a.eingangskanal, f.finanzierungs_nr, (COALESCE((a_st_loeschen.count_of_status_disabling_loeschen)::integer, 0)), a.beratungs_nr, (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), (COALESCE((p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig)::integer, 0)), pbt.team, pba.abteilung, pbb.bereich
  • Sort Method: quicksort Memory: 2,680kB
  • Buffers: shared hit=12,803
10. 59.038 310.012 ↑ 55.5 4,853 1

Hash Left Join (cost=6,604.29..45,718.79 rows=269,547 width=1,126) (actual time=201.112..310.012 rows=4,853 loops=1)

  • Output: av.id, k.id, a.mandant_id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), CASE WHEN (k.kundenbezeichnung IS NULL) THEN (concat(ep.name, ' ', ep.vorname))::citext ELSE (k.kundenbezeichnung)::citext END, k.kundenberater_id, concat(kb.vorname, ' ', kb.name), k.kundentyp_id, ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, k.creation_source, k.rating_abschluss_neu_id, av.geschaeftsfall, CASE WHEN (f.rahmenlimite_wert_neu_menge IS NULL) THEN f.rahmenlimite_wert_bisher_menge ELSE f.rahmenlimite_wert_neu_menge END, CASE WHEN (f.rahmenlimite_wert_neu_menge IS NULL) THEN f.rahmenlimite_wert_bisher_waehrung ELSE f.rahmenlimite_wert_neu_waehrung END, av.gesuchsgrund_id, g.bezeichnung_de, g.bezeichnung_en, g.bezeichnung_fr, g.bezeichnung_it, av.status, a.antrags_nr, COALESCE(newest_unrejected_av.einreicher_id, av.sachbearbeiter_id), (newest_unrejected_av.id IS NOT NULL), CASE WHEN (newest_unrejected_av_einreicher.id IS NOT NULL) THEN concat(newest_unrejected_av_einreicher.vorname, ' ', newest_unrejected_av_einreicher.name) ELSE concat(pb.vorname, ' ', pb.name) END, av.eingang, av.ausgang, a.eingangskanal, f.finanzierungs_nr, COALESCE((a_st_loeschen.count_of_status_disabling_loeschen)::integer, 0), a.beratungs_nr, (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), COALESCE((p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig)::integer, 0), pbt.team, pba.abteilung, pbb.bereich
  • Hash Cond: (pb.id = pbb.benutzer_id)
  • Buffers: shared hit=12,803
11. 2.271 250.910 ↑ 55.5 4,853 1

Hash Left Join (cost=6,598.06..38,312.50 rows=269,547 width=1,160) (actual time=201.018..250.910 rows=4,853 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen, pb.vorname, pb.name, pb.id, p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb.vorname, kb.name, ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, g.bezeichnung_de, g.bezeichnung_en, g.bezeichnung_fr, g.bezeichnung_it, newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name, pbt.team, pba.abteilung
  • Hash Cond: (pb.id = pba.benutzer_id)
  • Buffers: shared hit=12,801
12. 2.340 248.575 ↑ 55.6 4,851 1

Hash Left Join (cost=6,591.99..34,699.99 rows=269,547 width=1,137) (actual time=200.940..248.575 rows=4,851 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen, pb.vorname, pb.name, pb.id, p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb.vorname, kb.name, ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, g.bezeichnung_de, g.bezeichnung_en, g.bezeichnung_fr, g.bezeichnung_it, newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name, pbt.team
  • Hash Cond: (pb.id = pbt.benutzer_id)
  • Buffers: shared hit=12,799
13. 2.198 246.174 ↑ 63.5 4,247 1

Hash Left Join (cost=6,585.76..30,663.03 rows=269,547 width=1,112) (actual time=200.866..246.174 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen, pb.vorname, pb.name, pb.id, p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb.vorname, kb.name, ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, g.bezeichnung_de, g.bezeichnung_en, g.bezeichnung_fr, g.bezeichnung_it, newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Inner Unique: true
  • Hash Cond: (av.gesuchsgrund_id = g.id)
  • Buffers: shared hit=12,797
14. 3.045 243.867 ↑ 63.5 4,247 1

Hash Left Join (cost=6,573.55..29,933.07 rows=269,547 width=1,092) (actual time=200.745..243.867 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen, pb.vorname, pb.name, pb.id, p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb.vorname, kb.name, ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Inner Unique: true
  • Hash Cond: ((SubPlan 1) = ks.id)
  • Buffers: shared hit=12,791
15. 1.867 215.321 ↑ 63.5 4,247 1

Hash Left Join (cost=6,571.98..10,371.67 rows=269,547 width=421) (actual time=200.703..215.321 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen, pb.vorname, pb.name, pb.id, p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb.vorname, kb.name, newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Inner Unique: true
  • Hash Cond: (k.kundenberater_id = kb.id)
  • Buffers: shared hit=4,296
16. 1.506 213.343 ↑ 63.5 4,247 1

Hash Left Join (cost=6,554.12..9,636.66 rows=269,547 width=407) (actual time=200.577..213.343 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen, pb.vorname, pb.name, pb.id, p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Inner Unique: true
  • Hash Cond: (f.id = p.finanzierung_id)
  • Buffers: shared hit=4,283
17. 1.707 207.344 ↑ 63.5 4,247 1

Hash Left Join (cost=5,778.64..8,153.17 rows=269,547 width=415) (actual time=196.074..207.344 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen, pb.vorname, pb.name, pb.id, newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Inner Unique: true
  • Hash Cond: (av.sachbearbeiter_id = pb.id)
  • Buffers: shared hit=2,843
18. 1.853 205.538 ↑ 63.5 4,247 1

Hash Left Join (cost=5,760.78..7,414.40 rows=269,547 width=385) (actual time=195.966..205.538 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen, newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Hash Cond: (a.id = newest_unrejected_av.antrag_id)
  • Buffers: shared hit=2,830
19. 4.324 200.588 ↑ 63.5 4,247 1

Hash Join (cost=5,360.54..5,662.91 rows=269,547 width=339) (actual time=192.851..200.588 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen
  • Hash Cond: (k_1.id = k.id)
  • Buffers: shared hit=2,642
20. 6.704 16.112 ↑ 1.0 9,314 1

HashAggregate (cost=1,135.65..1,252.07 rows=9,314 width=34) (actual time=12.657..16.112 rows=9,314 loops=1)

  • Output: k_1.id, CASE WHEN (kt.personalschutz OR (max((ppkt.personalschutz)::integer) = 1)) THEN true ELSE false END, k_1.mandant_id, kt.personalschutz
  • Group Key: k_1.id, kt.personalschutz
  • Buffers: shared hit=579
21. 1.885 9.408 ↓ 1.1 10,560 1

Hash Join (cost=547.60..1,042.51 rows=9,314 width=34) (actual time=4.184..9.408 rows=10,560 loops=1)

  • Output: k_1.id, kt.personalschutz, ppkt.personalschutz, k_1.mandant_id
  • Inner Unique: true
  • Hash Cond: (k_1.kundentyp_id = kt.id)
  • Buffers: shared hit=579
22. 2.303 7.500 ↓ 1.1 10,560 1

Hash Left Join (cost=545.99..1,012.61 rows=9,314 width=49) (actual time=4.150..7.500 rows=10,560 loops=1)

  • Output: k_1.id, k_1.mandant_id, k_1.kundentyp_id, ppkt.personalschutz
  • Hash Cond: (k_1.id = jt.kunde_id)
  • Buffers: shared hit=578
23. 1.070 1.070 ↑ 1.0 9,314 1

Seq Scan on public.kunde k_1 (cost=0.00..372.14 rows=9,314 width=48) (actual time=0.004..1.070 rows=9,314 loops=1)

  • Output: k_1.id, k_1.creation_date, k_1.creation_user, k_1.modification_date, k_1.modification_user, k_1.version, k_1.finanzierung_id, k_1.mandant_id, k_1.kundentyp_id, k_1.kunden_key, k_1.kunden_nr, k_1.external_kunden_nr, k_1.kundenbezeichnung, k_1.korrespondenzsprache, k_1.kundenberater_id, k_1.rating_abschluss_bisher_id, k_1.rating_abschluss_neu_id, k_1.creation_source, k_1.relationship_key, k_1.relationship_code, k_1.relationship_area, k_1.used_in_modul, k_1.original_entity_id, k_1.rechtsstatus, k_1.kundensegment_id, k_1.auspraegung1_id, k_1.auspraegung2_id
  • Buffers: shared hit=279
24. 0.416 4.127 ↑ 1.0 2,463 1

Hash (cost=515.20..515.20 rows=2,463 width=17) (actual time=4.127..4.127 rows=2,463 loops=1)

  • Output: jt.kunde_id, ppkt.personalschutz
  • Buckets: 4,096 Batches: 1 Memory Usage: 150kB
  • Buffers: shared hit=299
25. 0.453 3.711 ↑ 1.0 2,463 1

Hash Left Join (cost=76.02..515.20 rows=2,463 width=17) (actual time=0.670..3.711 rows=2,463 loops=1)

  • Output: jt.kunde_id, ppkt.personalschutz
  • Inner Unique: true
  • Hash Cond: (pp.kundentyp_id = ppkt.id)
  • Buffers: shared hit=299
26. 1.496 3.243 ↑ 1.0 2,463 1

Hash Right Join (cost=74.42..506.12 rows=2,463 width=32) (actual time=0.643..3.243 rows=2,463 loops=1)

  • Output: jt.kunde_id, pp.kundentyp_id
  • Hash Cond: (pp.id = jt.kunde_einzelperson_id)
  • Buffers: shared hit=298
27. 1.129 1.129 ↑ 1.0 9,314 1

Seq Scan on public.kunde pp (cost=0.00..372.14 rows=9,314 width=32) (actual time=0.004..1.129 rows=9,314 loops=1)

  • Output: pp.id, pp.creation_date, pp.creation_user, pp.modification_date, pp.modification_user, pp.version, pp.finanzierung_id, pp.mandant_id, pp.kundentyp_id, pp.kunden_key, pp.kunden_nr, pp.external_kunden_nr, pp.kundenbezeichnung, pp.korrespondenzsprache, pp.kundenberater_id, pp.rating_abschluss_bisher_id, pp.rating_abschluss_neu_id, pp.creation_source, pp.relationship_key, pp.relationship_code, pp.relationship_area, pp.used_in_modul, pp.original_entity_id, pp.rechtsstatus, pp.kundensegment_id, pp.auspraegung1_id, pp.auspraegung2_id
  • Buffers: shared hit=279
28. 0.387 0.618 ↑ 1.0 2,463 1

Hash (cost=43.63..43.63 rows=2,463 width=32) (actual time=0.618..0.618 rows=2,463 loops=1)

  • Output: jt.kunde_id, jt.kunde_einzelperson_id
  • Buckets: 4,096 Batches: 1 Memory Usage: 186kB
  • Buffers: shared hit=19
29. 0.231 0.231 ↑ 1.0 2,463 1

Seq Scan on public.jt_kunde_mehrere_privatpersonen_kunde_einzelperson jt (cost=0.00..43.63 rows=2,463 width=32) (actual time=0.005..0.231 rows=2,463 loops=1)

  • Output: jt.kunde_id, jt.kunde_einzelperson_id
  • Buffers: shared hit=19
30. 0.008 0.015 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=17) (actual time=0.015..0.015 rows=27 loops=1)

  • Output: ppkt.personalschutz, ppkt.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
31. 0.007 0.007 ↑ 1.0 27 1

Seq Scan on public.stamm_kundentyp ppkt (cost=0.00..1.27 rows=27 width=17) (actual time=0.002..0.007 rows=27 loops=1)

  • Output: ppkt.personalschutz, ppkt.id
  • Buffers: shared hit=1
32. 0.010 0.023 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=17) (actual time=0.023..0.023 rows=27 loops=1)

  • Output: kt.personalschutz, kt.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
33. 0.013 0.013 ↑ 1.0 27 1

Seq Scan on public.stamm_kundentyp kt (cost=0.00..1.27 rows=27 width=17) (actual time=0.008..0.013 rows=27 loops=1)

  • Output: kt.personalschutz, kt.id
  • Buffers: shared hit=1
34. 5.710 180.152 ↑ 1.4 4,247 1

Hash (cost=4,152.54..4,152.54 rows=5,788 width=354) (actual time=180.152..180.152 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), k_2.id, ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen
  • Buckets: 8,192 Batches: 1 Memory Usage: 1,414kB
  • Buffers: shared hit=2,063
35. 2.708 174.442 ↑ 1.4 4,247 1

Hash Left Join (cost=3,804.21..4,152.54 rows=5,788 width=354) (actual time=157.409..174.442 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), k_2.id, ep.name, ep.vorname, a_st_loeschen.count_of_status_disabling_loeschen
  • Inner Unique: true
  • Hash Cond: (k.id = ep.kunde_id)
  • Buffers: shared hit=2,063
36. 4.564 118.100 ↑ 1.4 4,247 1

Hash Join (cost=3,526.81..3,859.94 rows=5,788 width=340) (actual time=103.723..118.100 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id, k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), k_2.id, a_st_loeschen.count_of_status_disabling_loeschen
  • Hash Cond: (k.finanzierung_id = f.id)
  • Buffers: shared hit=1,933
37. 6.062 89.481 ↑ 1.0 9,314 1

Hash Join (cost=1,706.68..1,963.99 rows=9,314 width=183) (actual time=79.606..89.481 rows=9,314 loops=1)

  • Output: k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, k.finanzierung_id, (CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END), k_2.id
  • Inner Unique: true
  • Hash Cond: (k_2.id = k.id)
  • Buffers: shared hit=858
38. 9.971 77.651 ↑ 1.0 9,314 1

HashAggregate (cost=1,218.12..1,357.83 rows=9,314 width=64) (actual time=73.783..77.651 rows=9,314 loops=1)

  • Output: k_2.id, CASE WHEN (ksp.id IS NOT NULL) THEN ksp.id ELSE (max(((ppksp.id)::character varying(50))::text))::uuid END, k_2.mandant_id, ksp.id
  • Group Key: k_2.id, ksp.id
  • Buffers: shared hit=579
39. 2.899 67.680 ↓ 1.1 10,560 1

Hash Left Join (cost=554.25..1,078.41 rows=9,314 width=64) (actual time=58.539..67.680 rows=10,560 loops=1)

  • Output: k_2.id, ksp.id, ppksp.id, k_2.mandant_id
  • Hash Cond: (k_2.kundentyp_id = ksp.kundentyp_id)
  • Buffers: shared hit=579
40. 4.489 64.759 ↓ 1.1 10,560 1

Hash Left Join (cost=553.19..1,019.81 rows=9,314 width=64) (actual time=58.493..64.759 rows=10,560 loops=1)

  • Output: k_2.id, k_2.mandant_id, k_2.kundentyp_id, ppksp.id
  • Hash Cond: (k_2.id = jt_1.kunde_id)
  • Buffers: shared hit=578
41. 1.800 1.800 ↑ 1.0 9,314 1

Seq Scan on public.kunde k_2 (cost=0.00..372.14 rows=9,314 width=48) (actual time=0.004..1.800 rows=9,314 loops=1)

  • Output: k_2.id, k_2.creation_date, k_2.creation_user, k_2.modification_date, k_2.modification_user, k_2.version, k_2.finanzierung_id, k_2.mandant_id, k_2.kundentyp_id, k_2.kunden_key, k_2.kunden_nr, k_2.external_kunden_nr, k_2.kundenbezeichnung, k_2.korrespondenzsprache, k_2.kundenberater_id, k_2.rating_abschluss_bisher_id, k_2.rating_abschluss_neu_id, k_2.creation_source, k_2.relationship_key, k_2.relationship_code, k_2.relationship_area, k_2.used_in_modul, k_2.original_entity_id, k_2.rechtsstatus, k_2.kundensegment_id, k_2.auspraegung1_id, k_2.auspraegung2_id
  • Buffers: shared hit=279
42. 51.172 58.470 ↑ 1.0 2,463 1

Hash (cost=522.40..522.40 rows=2,463 width=32) (actual time=58.469..58.470 rows=2,463 loops=1)

  • Output: jt_1.kunde_id, ppksp.id
  • Buckets: 4,096 Batches: 1 Memory Usage: 148kB
  • Buffers: shared hit=299
43. 0.982 7.298 ↑ 1.0 2,463 1

Hash Left Join (cost=75.48..522.40 rows=2,463 width=32) (actual time=0.527..7.298 rows=2,463 loops=1)

  • Output: jt_1.kunde_id, ppksp.id
  • Hash Cond: (pp_1.kundentyp_id = ppksp.kundentyp_id)
  • Buffers: shared hit=299
44. 3.914 6.307 ↑ 1.0 2,463 1

Hash Right Join (cost=74.42..506.12 rows=2,463 width=32) (actual time=0.510..6.307 rows=2,463 loops=1)

  • Output: jt_1.kunde_id, pp_1.kundentyp_id
  • Hash Cond: (pp_1.id = jt_1.kunde_einzelperson_id)
  • Buffers: shared hit=298
45. 1.906 1.906 ↑ 1.0 9,314 1

Seq Scan on public.kunde pp_1 (cost=0.00..372.14 rows=9,314 width=32) (actual time=0.001..1.906 rows=9,314 loops=1)

  • Output: pp_1.id, pp_1.creation_date, pp_1.creation_user, pp_1.modification_date, pp_1.modification_user, pp_1.version, pp_1.finanzierung_id, pp_1.mandant_id, pp_1.kundentyp_id, pp_1.kunden_key, pp_1.kunden_nr, pp_1.external_kunden_nr, pp_1.kundenbezeichnung, pp_1.korrespondenzsprache, pp_1.kundenberater_id, pp_1.rating_abschluss_bisher_id, pp_1.rating_abschluss_neu_id, pp_1.creation_source, pp_1.relationship_key, pp_1.relationship_code, pp_1.relationship_area, pp_1.used_in_modul, pp_1.original_entity_id, pp_1.rechtsstatus, pp_1.kundensegment_id, pp_1.auspraegung1_id, pp_1.auspraegung2_id
  • Buffers: shared hit=279
46. 0.313 0.487 ↑ 1.0 2,463 1

Hash (cost=43.63..43.63 rows=2,463 width=32) (actual time=0.487..0.487 rows=2,463 loops=1)

  • Output: jt_1.kunde_id, jt_1.kunde_einzelperson_id
  • Buckets: 4,096 Batches: 1 Memory Usage: 186kB
  • Buffers: shared hit=19
47. 0.174 0.174 ↑ 1.0 2,463 1

Seq Scan on public.jt_kunde_mehrere_privatpersonen_kunde_einzelperson jt_1 (cost=0.00..43.63 rows=2,463 width=32) (actual time=0.004..0.174 rows=2,463 loops=1)

  • Output: jt_1.kunde_id, jt_1.kunde_einzelperson_id
  • Buffers: shared hit=19
48. 0.005 0.009 ↑ 1.5 2 1

Hash (cost=1.03..1.03 rows=3 width=32) (actual time=0.009..0.009 rows=2 loops=1)

  • Output: ppksp.id, ppksp.kundentyp_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
49. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on public.stamm_kundensegmentpruefung ppksp (cost=0.00..1.03 rows=3 width=32) (actual time=0.003..0.004 rows=3 loops=1)

  • Output: ppksp.id, ppksp.kundentyp_id
  • Buffers: shared hit=1
50. 0.011 0.022 ↑ 1.5 2 1

Hash (cost=1.03..1.03 rows=3 width=32) (actual time=0.022..0.022 rows=2 loops=1)

  • Output: ksp.id, ksp.kundentyp_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
51. 0.011 0.011 ↑ 1.0 3 1

Seq Scan on public.stamm_kundensegmentpruefung ksp (cost=0.00..1.03 rows=3 width=32) (actual time=0.009..0.011 rows=3 loops=1)

  • Output: ksp.id, ksp.kundentyp_id
  • Buffers: shared hit=1
52. 3.673 5.768 ↑ 1.0 9,314 1

Hash (cost=372.14..372.14 rows=9,314 width=151) (actual time=5.768..5.768 rows=9,314 loops=1)

  • Output: k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, k.finanzierung_id
  • Buckets: 16,384 Batches: 1 Memory Usage: 1,537kB
  • Buffers: shared hit=279
53. 2.095 2.095 ↑ 1.0 9,314 1

Seq Scan on public.kunde k (cost=0.00..372.14 rows=9,314 width=151) (actual time=0.005..2.095 rows=9,314 loops=1)

  • Output: k.id, k.kunden_nr, k.external_kunden_nr, k.kunden_key, k.kundenbezeichnung, k.kundenberater_id, k.kundentyp_id, k.creation_source, k.rating_abschluss_neu_id, k.finanzierung_id
  • Buffers: shared hit=279
54. 2.921 24.055 ↑ 1.0 4,247 1

Hash (cost=1,767.02..1,767.02 rows=4,249 width=189) (actual time=24.055..24.055 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, av.finanzierung_id, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id, a_st_loeschen.count_of_status_disabling_loeschen
  • Buckets: 8,192 Batches: 1 Memory Usage: 901kB
  • Buffers: shared hit=1,075
55. 1.412 21.134 ↑ 1.0 4,247 1

Hash Left Join (cost=1,476.03..1,767.02 rows=4,249 width=189) (actual time=14.114..21.134 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, av.finanzierung_id, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id, a_st_loeschen.count_of_status_disabling_loeschen
  • Inner Unique: true
  • Hash Cond: (a.id = a_st_loeschen.antrag_id)
  • Buffers: shared hit=1,075
56. 1.822 12.790 ↑ 1.0 4,247 1

Hash Join (cost=482.42..762.24 rows=4,249 width=181) (actual time=7.153..12.790 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, av.finanzierung_id, f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id
  • Inner Unique: true
  • Hash Cond: (av.finanzierung_id = f.id)
  • Buffers: shared hit=393
57. 2.165 6.476 ↑ 1.0 4,247 1

Hash Join (cost=176.59..445.24 rows=4,249 width=132) (actual time=2.614..6.476 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id, av.id, av.geschaeftsfall, av.gesuchsgrund_id, av.status, av.sachbearbeiter_id, av.eingang, av.ausgang, av.finanzierung_id
  • Inner Unique: true
  • Hash Cond: (av.antrag_id = a.id)
  • Buffers: shared hit=241
58. 1.748 1.748 ↑ 1.0 4,598 1

Seq Scan on public.antrag_version av (cost=0.00..256.57 rows=4,598 width=104) (actual time=0.010..1.748 rows=4,598 loops=1)

  • Output: av.id, av.creation_date, av.creation_user, av.modification_date, av.modification_user, av.version, av.interne_notizen, av.antrags_laufnummer, av.eingang, av.modul, av.status, av.mandant_id, av.antrag_id, av.finanzierung_id, av.sachbearbeiter_id, av.finanzierung_copied_by_reference, av.legacy_version, av.ausgang, av.finanzierung_copied_lazily, av.einreicher_id, av.geschaeftsfall, av.gesuchsgrund_id
  • Filter: (av.modul = 'ANTRAG'::w1100_kbl_modul_enum)
  • Rows Removed by Filter: 1,928
  • Buffers: shared hit=175
59. 1.264 2.563 ↑ 1.0 4,247 1

Hash (cost=123.47..123.47 rows=4,249 width=44) (actual time=2.563..2.563 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 363kB
  • Buffers: shared hit=66
60. 1.299 1.299 ↑ 1.0 4,247 1

Seq Scan on public.antrag a (cost=0.00..123.47 rows=4,249 width=44) (actual time=0.023..1.299 rows=4,247 loops=1)

  • Output: a.mandant_id, a.antrags_nr, a.eingangskanal, a.beratungs_nr, a.id
  • Filter: ((NOT a.permanently_deleted) AND ((a.mandant_id = '84381e52-6691-4000-b762-079bd28fbd47'::uuid) OR (a.mandant_id IS NULL)))
  • Rows Removed by Filter: 351
  • Buffers: shared hit=66
61. 2.021 4.492 ↑ 1.0 6,837 1

Hash (cost=220.37..220.37 rows=6,837 width=49) (actual time=4.492..4.492 rows=6,837 loops=1)

  • Output: f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 538kB
  • Buffers: shared hit=152
62. 2.471 2.471 ↑ 1.0 6,837 1

Seq Scan on public.finanzierung f (cost=0.00..220.37 rows=6,837 width=49) (actual time=0.011..2.471 rows=6,837 loops=1)

  • Output: f.rahmenlimite_wert_neu_menge, f.rahmenlimite_wert_bisher_menge, f.rahmenlimite_wert_bisher_waehrung, f.rahmenlimite_wert_neu_waehrung, f.finanzierungs_nr, f.id
  • Buffers: shared hit=152
63. 0.339 6.932 ↑ 1.7 1,263 1

Hash (cost=966.25..966.25 rows=2,189 width=24) (actual time=6.931..6.932 rows=1,263 loops=1)

  • Output: a_st_loeschen.count_of_status_disabling_loeschen, a_st_loeschen.antrag_id
  • Buckets: 4,096 Batches: 1 Memory Usage: 102kB
  • Buffers: shared hit=682
64. 0.157 6.593 ↑ 1.7 1,263 1

Subquery Scan on a_st_loeschen (cost=922.47..966.25 rows=2,189 width=24) (actual time=6.185..6.593 rows=1,263 loops=1)

  • Output: a_st_loeschen.count_of_status_disabling_loeschen, a_st_loeschen.antrag_id
  • Buffers: shared hit=682
65. 0.917 6.436 ↑ 1.7 1,263 1

HashAggregate (cost=922.47..944.36 rows=2,189 width=24) (actual time=6.184..6.436 rows=1,263 loops=1)

  • Output: av_1.antrag_id, count(*)
  • Group Key: av_1.antrag_id
  • Buffers: shared hit=682
66. 0.921 5.519 ↑ 1.0 2,189 1

Hash Join (cost=371.94..911.52 rows=2,189 width=16) (actual time=3.590..5.519 rows=2,189 loops=1)

  • Output: av_1.antrag_id
  • Inner Unique: true
  • Hash Cond: (ash.antrag_version_id = av_1.id)
  • Buffers: shared hit=682
67. 1.101 1.298 ↑ 1.0 2,189 1

Bitmap Heap Scan on public.antrag_status_history ash (cost=50.11..583.94 rows=2,189 width=16) (actual time=0.253..1.298 rows=2,189 loops=1)

  • Output: ash.id, ash.creation_date, ash.creation_user, ash.modification_date, ash.modification_user, ash.version, ash.status, ash.benutzer_id, ash.bemerkung, ash.mandant_id, ash.antrag_version_id
  • Recheck Cond: (ash.status = ANY ('{BOF_ENTSCHEID_BEANTRAGT,BOF_QUALITAETSSICHERUNG,BOF_IN_VERARBEITUNG,BOF_ABGESCHLOSSEN}'::antrag_status_enum[]))
  • Heap Blocks: exact=493
  • Buffers: shared hit=507
68. 0.197 0.197 ↓ 1.0 2,190 1

Bitmap Index Scan on idx_antrag_status_history_status (cost=0.00..49.56 rows=2,189 width=0) (actual time=0.197..0.197 rows=2,190 loops=1)

  • Index Cond: (ash.status = ANY ('{BOF_ENTSCHEID_BEANTRAGT,BOF_QUALITAETSSICHERUNG,BOF_IN_VERARBEITUNG,BOF_ABGESCHLOSSEN}'::antrag_status_enum[]))
  • Buffers: shared hit=14
69. 1.561 3.300 ↑ 1.0 6,526 1

Hash (cost=240.26..240.26 rows=6,526 width=32) (actual time=3.299..3.300 rows=6,526 loops=1)

  • Output: av_1.antrag_id, av_1.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 472kB
  • Buffers: shared hit=175
70. 1.739 1.739 ↑ 1.0 6,526 1

Seq Scan on public.antrag_version av_1 (cost=0.00..240.26 rows=6,526 width=32) (actual time=0.009..1.739 rows=6,526 loops=1)

  • Output: av_1.antrag_id, av_1.id
  • Buffers: shared hit=175
71. 52.175 53.634 ↑ 1.0 6,551 1

Hash (cost=195.51..195.51 rows=6,551 width=30) (actual time=53.634..53.634 rows=6,551 loops=1)

  • Output: ep.name, ep.vorname, ep.kunde_id
  • Buckets: 8,192 Batches: 1 Memory Usage: 467kB
  • Buffers: shared hit=130
72. 1.459 1.459 ↑ 1.0 6,551 1

Seq Scan on public.kunde_einzelperson ep (cost=0.00..195.51 rows=6,551 width=30) (actual time=0.010..1.459 rows=6,551 loops=1)

  • Output: ep.name, ep.vorname, ep.kunde_id
  • Buffers: shared hit=130
73. 0.268 3.097 ↓ 163.2 979 1

Hash (cost=400.16..400.16 rows=6 width=78) (actual time=3.097..3.097 rows=979 loops=1)

  • Output: newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av.antrag_id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Buckets: 1,024 Batches: 1 Memory Usage: 114kB
  • Buffers: shared hit=188
74. 0.218 2.829 ↓ 163.2 979 1

Hash Left Join (cost=357.93..400.16 rows=6 width=78) (actual time=1.764..2.829 rows=979 loops=1)

  • Output: newest_unrejected_av.einreicher_id, newest_unrejected_av.id, newest_unrejected_av.antrag_id, newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Inner Unique: true
  • Hash Cond: (newest_unrejected_av.einreicher_id = newest_unrejected_av_einreicher.id)
  • Buffers: shared hit=188
75. 0.107 2.504 ↓ 163.2 979 1

Subquery Scan on newest_unrejected_av (cost=340.07..382.29 rows=6 width=48) (actual time=1.641..2.504 rows=979 loops=1)

  • Output: newest_unrejected_av.id, newest_unrejected_av.creation_date, newest_unrejected_av.creation_user, newest_unrejected_av.modification_date, newest_unrejected_av.modification_user, newest_unrejected_av.version, newest_unrejected_av.interne_notizen, newest_unrejected_av.antrags_laufnummer, newest_unrejected_av.eingang, newest_unrejected_av.modul, newest_unrejected_av.status, newest_unrejected_av.mandant_id, newest_unrejected_av.antrag_id, newest_unrejected_av.finanzierung_id, newest_unrejected_av.sachbearbeiter_id, newest_unrejected_av.finanzierung_copied_by_reference, newest_unrejected_av.legacy_version, newest_unrejected_av.ausgang, newest_unrejected_av.finanzierung_copied_lazily, newest_unrejected_av.einreicher_id, newest_unrejected_av.geschaeftsfall, newest_unrejected_av.gesuchsgrund_id, newest_unrejected_av.rownum
  • Filter: (newest_unrejected_av.rownum = 1)
  • Rows Removed by Filter: 210
  • Buffers: shared hit=175
76. 0.699 2.397 ↑ 1.1 1,189 1

WindowAgg (cost=340.07..366.05 rows=1,299 width=443) (actual time=1.639..2.397 rows=1,189 loops=1)

  • Output: newest.id, NULL::timestamp without time zone, NULL::character varying(50), NULL::timestamp without time zone, NULL::character varying(50), NULL::integer, NULL::text, NULL::integer, newest.eingang, NULL::w1100_kbl_modul_enum, NULL::antrag_status_enum, NULL::uuid, newest.antrag_id, NULL::uuid, NULL::uuid, NULL::boolean, NULL::boolean, NULL::timestamp without time zone, NULL::boolean, newest.einreicher_id, NULL::w1112_geschaeftsfall_enum, NULL::uuid, row_number() OVER (?)
  • Buffers: shared hit=175
77. 0.553 1.698 ↑ 1.1 1,189 1

Sort (cost=340.07..343.32 rows=1,299 width=56) (actual time=1.629..1.698 rows=1,189 loops=1)

  • Output: newest.eingang, newest.antrag_id, newest.id, newest.einreicher_id
  • Sort Key: newest.antrag_id, newest.eingang DESC
  • Sort Method: quicksort Memory: 216kB
  • Buffers: shared hit=175
78. 1.145 1.145 ↑ 1.1 1,189 1

Seq Scan on public.antrag_version newest (cost=0.00..272.89 rows=1,299 width=56) (actual time=0.016..1.145 rows=1,189 loops=1)

  • Output: newest.eingang, newest.antrag_id, newest.id, newest.einreicher_id
  • Filter: ((newest.modul = ANY ('{CREDIT_OFFICE,QUALITAETSSICHERUNG}'::w1100_kbl_modul_enum[])) AND (newest.status <> ALL ('{CO_ZURUECKGEWIESEN,QS_ZURUECKGEWIESEN}'::antrag_status_enum[])))
  • Rows Removed by Filter: 5,337
  • Buffers: shared hit=175
79. 0.045 0.107 ↑ 1.0 216 1

Hash (cost=15.16..15.16 rows=216 width=30) (actual time=0.107..0.107 rows=216 loops=1)

  • Output: newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
  • Buffers: shared hit=13
80. 0.062 0.062 ↑ 1.0 216 1

Seq Scan on public.premium_benutzer newest_unrejected_av_einreicher (cost=0.00..15.16 rows=216 width=30) (actual time=0.006..0.062 rows=216 loops=1)

  • Output: newest_unrejected_av_einreicher.id, newest_unrejected_av_einreicher.vorname, newest_unrejected_av_einreicher.name
  • Buffers: shared hit=13
81. 0.050 0.099 ↑ 1.0 216 1

Hash (cost=15.16..15.16 rows=216 width=30) (actual time=0.099..0.099 rows=216 loops=1)

  • Output: pb.vorname, pb.name, pb.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
  • Buffers: shared hit=13
82. 0.049 0.049 ↑ 1.0 216 1

Seq Scan on public.premium_benutzer pb (cost=0.00..15.16 rows=216 width=30) (actual time=0.003..0.049 rows=216 loops=1)

  • Output: pb.vorname, pb.name, pb.id
  • Buffers: shared hit=13
83. 0.012 4.493 ↑ 12.3 19 1

Hash (cost=772.58..772.58 rows=233 width=24) (actual time=4.493..4.493 rows=19 loops=1)

  • Output: p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, p.finanzierung_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1,440
84. 0.004 4.481 ↑ 12.3 19 1

Subquery Scan on p (cost=767.92..772.58 rows=233 width=24) (actual time=4.474..4.481 rows=19 loops=1)

  • Output: p.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, p.finanzierung_id
  • Buffers: shared hit=1,440
85. 0.023 4.477 ↑ 12.3 19 1

HashAggregate (cost=767.92..770.25 rows=233 width=24) (actual time=4.473..4.477 rows=19 loops=1)

  • Output: p_1.finanzierung_id, count(*)
  • Group Key: p_1.finanzierung_id
  • Buffers: shared hit=1,440
86. 0.043 4.454 ↑ 10.7 24 1

Nested Loop (cost=306.40..766.63 rows=257 width=16) (actual time=1.935..4.454 rows=24 loops=1)

  • Output: p_1.finanzierung_id
  • Join Filter: (p_1.bewilliger_id <> k_3.kundenberater_id)
  • Rows Removed by Join Filter: 12
  • Buffers: shared hit=1,440
87. 0.139 4.303 ↑ 5.5 36 1

Nested Loop (cost=306.12..667.77 rows=198 width=64) (actual time=1.880..4.303 rows=36 loops=1)

  • Output: p_1.finanzierung_id, p_1.bewilliger_id, f_1.id, av_2.finanzierung_id
  • Join Filter: (p_1.bewilliger_id <> av_2.sachbearbeiter_id)
  • Rows Removed by Join Filter: 322
  • Buffers: shared hit=1,332
88. 0.125 3.524 ↓ 1.4 320 1

Hash Join (cost=305.83..565.70 rows=237 width=48) (actual time=1.863..3.524 rows=320 loops=1)

  • Output: p_1.finanzierung_id, p_1.bewilliger_id, f_1.id
  • Inner Unique: true
  • Hash Cond: (p_1.finanzierung_id = f_1.id)
  • Buffers: shared hit=332
89. 1.585 1.585 ↓ 1.4 320 1

Seq Scan on public.produkt_fla p_1 (cost=0.00..259.25 rows=237 width=32) (actual time=0.017..1.585 rows=320 loops=1)

  • Output: p_1.id, p_1.creation_date, p_1.creation_user, p_1.modification_date, p_1.modification_user, p_1.version, p_1.basiszins, p_1.bearbeitungsgebuehr_waehrung, p_1.bearbeitungsgebuehr_menge, p_1.betrag_waehrung, p_1.betrag_menge, p_1.bewilligungsstatus, p_1.bruttomarge, p_1.datum, p_1.floatend, p_1.laufzeit, p_1.laufzeit_von, p_1.laufzeit_bis, p_1.periodizitaet, p_1.stand_per, p_1.usanz, p_1.mandant_id, p_1.produktmapping_id, p_1.meldung, p_1.finanzierung_id, p_1.abweichung1_id, p_1.abweichung_satz1, p_1.abweichung2_id, p_1.abweichung_satz2, p_1.abweichung3_id, p_1.abweichung_satz3, p_1.removed, p_1.core_system_loaded, p_1.verlaengern_status, p_1.kundenzins_produkt_core, p_1.bemerkung_abweichungen, p_1.bewilliger_id, p_1.used_in_modul, p_1.original_entity_id, p_1.zinskonto_id, p_1.melder_id, p_1.melde_datum, p_1.tranchen_nr, p_1.staffel_sortierung, p_1.produktkonto_id, p_1.zinszahlung_erstmals_per, p_1.periodizitaet_id, p_1.abweichung4_id, p_1.abweichung_satz4
  • Filter: ((p_1.bewilliger_id IS NOT NULL) AND (p_1.meldung = ANY ('{OFFEN,BEREIT}'::w1090_meldestatus_enum[])) AND (p_1.bewilligungsstatus = 'BEWILLIGT'::w1061_bewillig_status_prod_enum))
  • Rows Removed by Filter: 4,963
  • Buffers: shared hit=180
90. 1.005 1.814 ↑ 1.0 6,837 1

Hash (cost=220.37..220.37 rows=6,837 width=16) (actual time=1.814..1.814 rows=6,837 loops=1)

  • Output: f_1.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 385kB
  • Buffers: shared hit=152
91. 0.809 0.809 ↑ 1.0 6,837 1

Seq Scan on public.finanzierung f_1 (cost=0.00..220.37 rows=6,837 width=16) (actual time=0.005..0.809 rows=6,837 loops=1)

  • Output: f_1.id
  • Buffers: shared hit=152
92. 0.640 0.640 ↑ 1.0 1 320

Index Scan using idx_antrag_version_finanzierung on public.antrag_version av_2 (cost=0.28..0.42 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=320)

  • Output: av_2.id, av_2.creation_date, av_2.creation_user, av_2.modification_date, av_2.modification_user, av_2.version, av_2.interne_notizen, av_2.antrags_laufnummer, av_2.eingang, av_2.modul, av_2.status, av_2.mandant_id, av_2.antrag_id, av_2.finanzierung_id, av_2.sachbearbeiter_id, av_2.finanzierung_copied_by_reference, av_2.legacy_version, av_2.ausgang, av_2.finanzierung_copied_lazily, av_2.einreicher_id, av_2.geschaeftsfall, av_2.gesuchsgrund_id
  • Index Cond: (av_2.finanzierung_id = f_1.id)
  • Buffers: shared hit=1,000
93. 0.108 0.108 ↑ 1.0 1 36

Index Scan using idx_kunde_finanzierung on public.kunde k_3 (cost=0.29..0.49 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=36)

  • Output: k_3.id, k_3.creation_date, k_3.creation_user, k_3.modification_date, k_3.modification_user, k_3.version, k_3.finanzierung_id, k_3.mandant_id, k_3.kundentyp_id, k_3.kunden_key, k_3.kunden_nr, k_3.external_kunden_nr, k_3.kundenbezeichnung, k_3.korrespondenzsprache, k_3.kundenberater_id, k_3.rating_abschluss_bisher_id, k_3.rating_abschluss_neu_id, k_3.creation_source, k_3.relationship_key, k_3.relationship_code, k_3.relationship_area, k_3.used_in_modul, k_3.original_entity_id, k_3.rechtsstatus, k_3.kundensegment_id, k_3.auspraegung1_id, k_3.auspraegung2_id
  • Index Cond: (k_3.finanzierung_id = f_1.id)
  • Buffers: shared hit=108
94. 0.051 0.111 ↑ 1.0 216 1

Hash (cost=15.16..15.16 rows=216 width=30) (actual time=0.110..0.111 rows=216 loops=1)

  • Output: kb.vorname, kb.name, kb.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
  • Buffers: shared hit=13
95. 0.060 0.060 ↑ 1.0 216 1

Seq Scan on public.premium_benutzer kb (cost=0.00..15.16 rows=216 width=30) (actual time=0.005..0.060 rows=216 loops=1)

  • Output: kb.vorname, kb.name, kb.id
  • Buffers: shared hit=13
96. 0.008 0.019 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=687) (actual time=0.018..0.019 rows=25 loops=1)

  • Output: ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, ks.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
97. 0.011 0.011 ↑ 1.0 25 1

Seq Scan on public.stamm_kundensegment ks (cost=0.00..1.25 rows=25 width=687) (actual time=0.006..0.011 rows=25 loops=1)

  • Output: ks.bezeichnung_de, ks.bezeichnung_en, ks.bezeichnung_fr, ks.bezeichnung_it, ks.id
  • Buffers: shared hit=1
98.          

SubPlan (for Hash Left Join)

99. 25.482 25.482 ↑ 1.0 1 8,494

Seq Scan on public.stamm_kundentyp kt_2 (cost=0.00..1.34 rows=1 width=16) (actual time=0.001..0.003 rows=1 loops=8,494)

  • Output: kt_2.kundensegment_id
  • Filter: (k.kundentyp_id = kt_2.id)
  • Rows Removed by Filter: 26
  • Buffers: shared hit=8,494
100. 0.058 0.109 ↑ 1.0 276 1

Hash (cost=8.76..8.76 rows=276 width=36) (actual time=0.109..0.109 rows=276 loops=1)

  • Output: g.bezeichnung_de, g.bezeichnung_en, g.bezeichnung_fr, g.bezeichnung_it, g.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
  • Buffers: shared hit=6
101. 0.051 0.051 ↑ 1.0 276 1

Seq Scan on public.stamm_gesuchsgrund g (cost=0.00..8.76 rows=276 width=36) (actual time=0.004..0.051 rows=276 loops=1)

  • Output: g.bezeichnung_de, g.bezeichnung_en, g.bezeichnung_fr, g.bezeichnung_it, g.id
  • Buffers: shared hit=6
102. 0.038 0.061 ↑ 1.0 188 1

Hash (cost=3.88..3.88 rows=188 width=41) (actual time=0.061..0.061 rows=188 loops=1)

  • Output: pbt.team, pbt.benutzer_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
  • Buffers: shared hit=2
103. 0.023 0.023 ↑ 1.0 188 1

Seq Scan on public.jt_premium_benutzer_teams pbt (cost=0.00..3.88 rows=188 width=41) (actual time=0.004..0.023 rows=188 loops=1)

  • Output: pbt.team, pbt.benutzer_id
  • Buffers: shared hit=2
104. 0.040 0.064 ↑ 1.0 181 1

Hash (cost=3.81..3.81 rows=181 width=39) (actual time=0.064..0.064 rows=181 loops=1)

  • Output: pba.abteilung, pba.benutzer_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
  • Buffers: shared hit=2
105. 0.024 0.024 ↑ 1.0 181 1

Seq Scan on public.jt_premium_benutzer_abteilungen pba (cost=0.00..3.81 rows=181 width=39) (actual time=0.005..0.024 rows=181 loops=1)

  • Output: pba.abteilung, pba.benutzer_id
  • Buffers: shared hit=2
106. 0.039 0.064 ↑ 1.0 188 1

Hash (cost=3.88..3.88 rows=188 width=35) (actual time=0.063..0.064 rows=188 loops=1)

  • Output: pbb.bereich, pbb.benutzer_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
  • Buffers: shared hit=2
107. 0.025 0.025 ↑ 1.0 188 1

Seq Scan on public.jt_premium_benutzer_bereiche pbb (cost=0.00..3.88 rows=188 width=35) (actual time=0.007..0.025 rows=188 loops=1)

  • Output: pbb.bereich, pbb.benutzer_id
  • Buffers: shared hit=2
108. 0.669 327.777 ↓ 20.4 4,076 1

Hash (cost=350,543.53..350,543.53 rows=200 width=16) (actual time=327.777..327.777 rows=4,076 loops=1)

  • Output: antragvers1_.antrag_version_id
  • Buckets: 4,096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 224kB
  • Buffers: shared hit=12,464
109. 1.665 327.108 ↓ 20.4 4,076 1

HashAggregate (cost=350,541.53..350,543.53 rows=200 width=16) (actual time=326.622..327.108 rows=4,076 loops=1)

  • Output: antragvers1_.antrag_version_id
  • Group Key: antragvers1_.antrag_version_id
  • Buffers: shared hit=12,464
110. 0.415 325.443 ↑ 55.3 4,662 1

Subquery Scan on antragvers1_ (cost=320,903.96..349,897.24 rows=257,718 width=16) (actual time=321.820..325.443 rows=4,662 loops=1)

  • Output: antragvers1_.antrag_version_id
  • Buffers: shared hit=12,464
111. 2.864 325.028 ↑ 55.3 4,662 1

Unique (cost=320,903.96..347,320.06 rows=257,718 width=1,126) (actual time=321.818..325.028 rows=4,662 loops=1)

  • Output: av_3.id, k_4.id, a_1.mandant_id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (k_4.kundenbezeichnung IS NULL) THEN (concat(ep_1.name, ' ', ep_1.vorname))::citext ELSE (k_4.kundenbezeichnung)::citext END), k_4.kundenberater_id, (concat(kb_1.vorname, ' ', kb_1.name)), k_4.kundentyp_id, ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, k_4.creation_source, k_4.rating_abschluss_neu_id, av_3.geschaeftsfall, (CASE WHEN (f_2.rahmenlimite_wert_neu_menge IS NULL) THEN f_2.rahmenlimite_wert_bisher_menge ELSE f_2.rahmenlimite_wert_neu_menge END), (CASE WHEN (f_2.rahmenlimite_wert_neu_menge IS NULL) THEN f_2.rahmenlimite_wert_bisher_waehrung ELSE f_2.rahmenlimite_wert_neu_waehrung END), av_3.gesuchsgrund_id, g_1.bezeichnung_de, g_1.bezeichnung_en, g_1.bezeichnung_fr, g_1.bezeichnung_it, av_3.status, a_1.antrags_nr, (COALESCE(newest_unrejected_av_1.einreicher_id, av_3.sachbearbeiter_id)), ((newest_unrejected_av_1.id IS NOT NULL)), (CASE WHEN (newest_unrejected_av_einreicher_1.id IS NOT NULL) THEN concat(newest_unrejected_av_einreicher_1.vorname, ' ', newest_unrejected_av_einreicher_1.name) ELSE concat(pb_1.vorname, ' ', pb_1.name) END), av_3.eingang, av_3.ausgang, a_1.eingangskanal, f_2.finanzierungs_nr, (COALESCE((a_st_loeschen_1.count_of_status_disabling_loeschen)::integer, 0)), a_1.beratungs_nr, (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), (COALESCE((p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig)::integer, 0)), pbt_1.team, pba_1.abteilung, pbb_1.bereich
  • Buffers: shared hit=12,464
112. 10.894 322.164 ↑ 55.3 4,662 1

Sort (cost=320,903.96..321,548.26 rows=257,718 width=1,126) (actual time=321.817..322.164 rows=4,662 loops=1)

  • Output: av_3.id, k_4.id, a_1.mandant_id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (k_4.kundenbezeichnung IS NULL) THEN (concat(ep_1.name, ' ', ep_1.vorname))::citext ELSE (k_4.kundenbezeichnung)::citext END), k_4.kundenberater_id, (concat(kb_1.vorname, ' ', kb_1.name)), k_4.kundentyp_id, ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, k_4.creation_source, k_4.rating_abschluss_neu_id, av_3.geschaeftsfall, (CASE WHEN (f_2.rahmenlimite_wert_neu_menge IS NULL) THEN f_2.rahmenlimite_wert_bisher_menge ELSE f_2.rahmenlimite_wert_neu_menge END), (CASE WHEN (f_2.rahmenlimite_wert_neu_menge IS NULL) THEN f_2.rahmenlimite_wert_bisher_waehrung ELSE f_2.rahmenlimite_wert_neu_waehrung END), av_3.gesuchsgrund_id, g_1.bezeichnung_de, g_1.bezeichnung_en, g_1.bezeichnung_fr, g_1.bezeichnung_it, av_3.status, a_1.antrags_nr, (COALESCE(newest_unrejected_av_1.einreicher_id, av_3.sachbearbeiter_id)), ((newest_unrejected_av_1.id IS NOT NULL)), (CASE WHEN (newest_unrejected_av_einreicher_1.id IS NOT NULL) THEN concat(newest_unrejected_av_einreicher_1.vorname, ' ', newest_unrejected_av_einreicher_1.name) ELSE concat(pb_1.vorname, ' ', pb_1.name) END), av_3.eingang, av_3.ausgang, a_1.eingangskanal, f_2.finanzierungs_nr, (COALESCE((a_st_loeschen_1.count_of_status_disabling_loeschen)::integer, 0)), a_1.beratungs_nr, (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), (COALESCE((p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig)::integer, 0)), pbt_1.team, pba_1.abteilung, pbb_1.bereich
  • Sort Key: av_3.id, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (k_4.kundenbezeichnung IS NULL) THEN (concat(ep_1.name, ' ', ep_1.vorname))::citext ELSE (k_4.kundenbezeichnung)::citext END), k_4.kundenberater_id, (concat(kb_1.vorname, ' ', kb_1.name)), k_4.kundentyp_id, ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, k_4.creation_source, k_4.rating_abschluss_neu_id, av_3.geschaeftsfall, (CASE WHEN (f_2.rahmenlimite_wert_neu_menge IS NULL) THEN f_2.rahmenlimite_wert_bisher_menge ELSE f_2.rahmenlimite_wert_neu_menge END), (CASE WHEN (f_2.rahmenlimite_wert_neu_menge IS NULL) THEN f_2.rahmenlimite_wert_bisher_waehrung ELSE f_2.rahmenlimite_wert_neu_waehrung END), av_3.gesuchsgrund_id, g_1.bezeichnung_de, g_1.bezeichnung_en, g_1.bezeichnung_fr, g_1.bezeichnung_it, av_3.status, a_1.antrags_nr, (COALESCE(newest_unrejected_av_1.einreicher_id, av_3.sachbearbeiter_id)), ((newest_unrejected_av_1.id IS NOT NULL)), (CASE WHEN (newest_unrejected_av_einreicher_1.id IS NOT NULL) THEN concat(newest_unrejected_av_einreicher_1.vorname, ' ', newest_unrejected_av_einreicher_1.name) ELSE concat(pb_1.vorname, ' ', pb_1.name) END), av_3.eingang, av_3.ausgang, a_1.eingangskanal, f_2.finanzierungs_nr, (COALESCE((a_st_loeschen_1.count_of_status_disabling_loeschen)::integer, 0)), a_1.beratungs_nr, (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), (COALESCE((p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig)::integer, 0)), pbt_1.team, pba_1.abteilung, pbb_1.bereich
  • Sort Method: quicksort Memory: 2,582kB
  • Buffers: shared hit=12,464
113. 58.314 311.270 ↑ 55.3 4,662 1

Hash Left Join (cost=6,638.19..44,047.00 rows=257,718 width=1,126) (actual time=202.728..311.270 rows=4,662 loops=1)

  • Output: av_3.id, k_4.id, a_1.mandant_id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), CASE WHEN (k_4.kundenbezeichnung IS NULL) THEN (concat(ep_1.name, ' ', ep_1.vorname))::citext ELSE (k_4.kundenbezeichnung)::citext END, k_4.kundenberater_id, concat(kb_1.vorname, ' ', kb_1.name), k_4.kundentyp_id, ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, k_4.creation_source, k_4.rating_abschluss_neu_id, av_3.geschaeftsfall, CASE WHEN (f_2.rahmenlimite_wert_neu_menge IS NULL) THEN f_2.rahmenlimite_wert_bisher_menge ELSE f_2.rahmenlimite_wert_neu_menge END, CASE WHEN (f_2.rahmenlimite_wert_neu_menge IS NULL) THEN f_2.rahmenlimite_wert_bisher_waehrung ELSE f_2.rahmenlimite_wert_neu_waehrung END, av_3.gesuchsgrund_id, g_1.bezeichnung_de, g_1.bezeichnung_en, g_1.bezeichnung_fr, g_1.bezeichnung_it, av_3.status, a_1.antrags_nr, COALESCE(newest_unrejected_av_1.einreicher_id, av_3.sachbearbeiter_id), (newest_unrejected_av_1.id IS NOT NULL), CASE WHEN (newest_unrejected_av_einreicher_1.id IS NOT NULL) THEN concat(newest_unrejected_av_einreicher_1.vorname, ' ', newest_unrejected_av_einreicher_1.name) ELSE concat(pb_1.vorname, ' ', pb_1.name) END, av_3.eingang, av_3.ausgang, a_1.eingangskanal, f_2.finanzierungs_nr, COALESCE((a_st_loeschen_1.count_of_status_disabling_loeschen)::integer, 0), a_1.beratungs_nr, (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), COALESCE((p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig)::integer, 0), pbt_1.team, pba_1.abteilung, pbb_1.bereich
  • Hash Cond: (pb_1.id = pbb_1.benutzer_id)
  • Buffers: shared hit=12,464
114. 2.309 252.804 ↑ 55.3 4,662 1

Hash Left Join (cost=6,631.96..36,965.46 rows=257,718 width=1,160) (actual time=202.470..252.804 rows=4,662 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen, pb_1.vorname, pb_1.name, pb_1.id, p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb_1.vorname, kb_1.name, ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, g_1.bezeichnung_de, g_1.bezeichnung_en, g_1.bezeichnung_fr, g_1.bezeichnung_it, newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name, pbt_1.team, pba_1.abteilung
  • Hash Cond: (pb_1.id = pba_1.benutzer_id)
  • Buffers: shared hit=12,459
115. 2.470 250.289 ↑ 55.3 4,660 1

Hash Left Join (cost=6,625.89..33,511.21 rows=257,718 width=1,137) (actual time=202.235..250.289 rows=4,660 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen, pb_1.vorname, pb_1.name, pb_1.id, p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb_1.vorname, kb_1.name, ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, g_1.bezeichnung_de, g_1.bezeichnung_en, g_1.bezeichnung_fr, g_1.bezeichnung_it, newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name, pbt_1.team
  • Hash Cond: (pb_1.id = pbt_1.benutzer_id)
  • Buffers: shared hit=12,457
116. 2.224 247.626 ↑ 63.2 4,076 1

Hash Left Join (cost=6,619.66..29,651.15 rows=257,718 width=1,112) (actual time=202.014..247.626 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen, pb_1.vorname, pb_1.name, pb_1.id, p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb_1.vorname, kb_1.name, ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, g_1.bezeichnung_de, g_1.bezeichnung_en, g_1.bezeichnung_fr, g_1.bezeichnung_it, newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Inner Unique: true
  • Hash Cond: (av_3.gesuchsgrund_id = g_1.id)
  • Buffers: shared hit=12,455
117. 4.266 245.052 ↑ 63.2 4,076 1

Hash Left Join (cost=6,607.45..28,952.68 rows=257,718 width=1,092) (actual time=201.627..245.052 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen, pb_1.vorname, pb_1.name, pb_1.id, p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb_1.vorname, kb_1.name, ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Inner Unique: true
  • Hash Cond: ((SubPlan 2) = ks_1.id)
  • Buffers: shared hit=12,449
118. 1.961 216.270 ↑ 63.2 4,076 1

Hash Left Join (cost=6,605.89..10,249.56 rows=257,718 width=421) (actual time=201.498..216.270 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen, pb_1.vorname, pb_1.name, pb_1.id, p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, kb_1.vorname, kb_1.name, newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Inner Unique: true
  • Hash Cond: (k_4.kundenberater_id = kb_1.id)
  • Buffers: shared hit=4,296
119. 1.564 213.911 ↑ 63.2 4,076 1

Hash Left Join (cost=6,588.03..9,546.02 rows=257,718 width=407) (actual time=201.060..213.911 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen, pb_1.vorname, pb_1.name, pb_1.id, p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Inner Unique: true
  • Hash Cond: (f_2.id = p_2.finanzierung_id)
  • Buffers: shared hit=4,283
120. 1.811 155.428 ↑ 63.2 4,076 1

Hash Left Join (cost=5,812.54..8,093.60 rows=257,718 width=415) (actual time=144.127..155.428 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen, pb_1.vorname, pb_1.name, pb_1.id, newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Inner Unique: true
  • Hash Cond: (av_3.sachbearbeiter_id = pb_1.id)
  • Buffers: shared hit=2,843
121. 1.950 153.521 ↑ 63.2 4,076 1

Hash Left Join (cost=5,794.68..7,386.46 rows=257,718 width=385) (actual time=144.022..153.521 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen, newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Hash Cond: (a_1.id = newest_unrejected_av_1.antrag_id)
  • Buffers: shared hit=2,830
122. 4.127 148.446 ↑ 63.2 4,076 1

Hash Join (cost=5,394.44..5,694.28 rows=257,718 width=339) (actual time=140.880..148.446 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END), (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen
  • Hash Cond: (k_5.id = k_4.id)
  • Buffers: shared hit=2,642
123. 11.905 27.802 ↑ 1.0 9,314 1

HashAggregate (cost=1,135.65..1,252.07 rows=9,314 width=34) (actual time=24.305..27.802 rows=9,314 loops=1)

  • Output: k_5.id, CASE WHEN (kt_1.personalschutz OR (max((ppkt_1.personalschutz)::integer) = 1)) THEN true ELSE false END, k_5.mandant_id, kt_1.personalschutz
  • Group Key: k_5.id, kt_1.personalschutz
  • Buffers: shared hit=579
124. 3.453 15.897 ↓ 1.1 10,560 1

Hash Join (cost=547.60..1,042.51 rows=9,314 width=34) (actual time=5.337..15.897 rows=10,560 loops=1)

  • Output: k_5.id, kt_1.personalschutz, ppkt_1.personalschutz, k_5.mandant_id
  • Inner Unique: true
  • Hash Cond: (k_5.kundentyp_id = kt_1.id)
  • Buffers: shared hit=579
125. 5.189 12.420 ↓ 1.1 10,560 1

Hash Left Join (cost=545.99..1,012.61 rows=9,314 width=49) (actual time=5.302..12.420 rows=10,560 loops=1)

  • Output: k_5.id, k_5.mandant_id, k_5.kundentyp_id, ppkt_1.personalschutz
  • Hash Cond: (k_5.id = jt_2.kunde_id)
  • Buffers: shared hit=578
126. 1.961 1.961 ↑ 1.0 9,314 1

Seq Scan on public.kunde k_5 (cost=0.00..372.14 rows=9,314 width=48) (actual time=0.012..1.961 rows=9,314 loops=1)

  • Output: k_5.id, k_5.creation_date, k_5.creation_user, k_5.modification_date, k_5.modification_user, k_5.version, k_5.finanzierung_id, k_5.mandant_id, k_5.kundentyp_id, k_5.kunden_key, k_5.kunden_nr, k_5.external_kunden_nr, k_5.kundenbezeichnung, k_5.korrespondenzsprache, k_5.kundenberater_id, k_5.rating_abschluss_bisher_id, k_5.rating_abschluss_neu_id, k_5.creation_source, k_5.relationship_key, k_5.relationship_code, k_5.relationship_area, k_5.used_in_modul, k_5.original_entity_id, k_5.rechtsstatus, k_5.kundensegment_id, k_5.auspraegung1_id, k_5.auspraegung2_id
  • Buffers: shared hit=279
127. 0.462 5.270 ↑ 1.0 2,463 1

Hash (cost=515.20..515.20 rows=2,463 width=17) (actual time=5.270..5.270 rows=2,463 loops=1)

  • Output: jt_2.kunde_id, ppkt_1.personalschutz
  • Buckets: 4,096 Batches: 1 Memory Usage: 150kB
  • Buffers: shared hit=299
128. 0.646 4.808 ↑ 1.0 2,463 1

Hash Left Join (cost=76.02..515.20 rows=2,463 width=17) (actual time=0.634..4.808 rows=2,463 loops=1)

  • Output: jt_2.kunde_id, ppkt_1.personalschutz
  • Inner Unique: true
  • Hash Cond: (pp_2.kundentyp_id = ppkt_1.id)
  • Buffers: shared hit=299
129. 1.690 4.148 ↑ 1.0 2,463 1

Hash Right Join (cost=74.42..506.12 rows=2,463 width=32) (actual time=0.612..4.148 rows=2,463 loops=1)

  • Output: jt_2.kunde_id, pp_2.kundentyp_id
  • Hash Cond: (pp_2.id = jt_2.kunde_einzelperson_id)
  • Buffers: shared hit=298
130. 1.865 1.865 ↑ 1.0 9,314 1

Seq Scan on public.kunde pp_2 (cost=0.00..372.14 rows=9,314 width=32) (actual time=0.001..1.865 rows=9,314 loops=1)

  • Output: pp_2.id, pp_2.creation_date, pp_2.creation_user, pp_2.modification_date, pp_2.modification_user, pp_2.version, pp_2.finanzierung_id, pp_2.mandant_id, pp_2.kundentyp_id, pp_2.kunden_key, pp_2.kunden_nr, pp_2.external_kunden_nr, pp_2.kundenbezeichnung, pp_2.korrespondenzsprache, pp_2.kundenberater_id, pp_2.rating_abschluss_bisher_id, pp_2.rating_abschluss_neu_id, pp_2.creation_source, pp_2.relationship_key, pp_2.relationship_code, pp_2.relationship_area, pp_2.used_in_modul, pp_2.original_entity_id, pp_2.rechtsstatus, pp_2.kundensegment_id, pp_2.auspraegung1_id, pp_2.auspraegung2_id
  • Buffers: shared hit=279
131. 0.374 0.593 ↑ 1.0 2,463 1

Hash (cost=43.63..43.63 rows=2,463 width=32) (actual time=0.593..0.593 rows=2,463 loops=1)

  • Output: jt_2.kunde_id, jt_2.kunde_einzelperson_id
  • Buckets: 4,096 Batches: 1 Memory Usage: 186kB
  • Buffers: shared hit=19
132. 0.219 0.219 ↑ 1.0 2,463 1

Seq Scan on public.jt_kunde_mehrere_privatpersonen_kunde_einzelperson jt_2 (cost=0.00..43.63 rows=2,463 width=32) (actual time=0.006..0.219 rows=2,463 loops=1)

  • Output: jt_2.kunde_id, jt_2.kunde_einzelperson_id
  • Buffers: shared hit=19
133. 0.008 0.014 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=17) (actual time=0.014..0.014 rows=27 loops=1)

  • Output: ppkt_1.personalschutz, ppkt_1.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
134. 0.006 0.006 ↑ 1.0 27 1

Seq Scan on public.stamm_kundentyp ppkt_1 (cost=0.00..1.27 rows=27 width=17) (actual time=0.002..0.006 rows=27 loops=1)

  • Output: ppkt_1.personalschutz, ppkt_1.id
  • Buffers: shared hit=1
135. 0.009 0.024 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=17) (actual time=0.024..0.024 rows=27 loops=1)

  • Output: kt_1.personalschutz, kt_1.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
136. 0.015 0.015 ↑ 1.0 27 1

Seq Scan on public.stamm_kundentyp kt_1 (cost=0.00..1.27 rows=27 width=17) (actual time=0.009..0.015 rows=27 loops=1)

  • Output: kt_1.personalschutz, kt_1.id
  • Buffers: shared hit=1
137. 3.170 116.517 ↑ 1.4 4,076 1

Hash (cost=4,189.62..4,189.62 rows=5,534 width=354) (actual time=116.517..116.517 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), k_6.id, ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen
  • Buckets: 8,192 Batches: 1 Memory Usage: 1,357kB
  • Buffers: shared hit=2,063
138. 1.416 113.347 ↑ 1.4 4,076 1

Hash Left Join (cost=3,843.75..4,189.62 rows=5,534 width=354) (actual time=102.815..113.347 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), k_6.id, ep_1.name, ep_1.vorname, a_st_loeschen_1.count_of_status_disabling_loeschen
  • Inner Unique: true
  • Hash Cond: (k_4.id = ep_1.kunde_id)
  • Buffers: shared hit=2,063
139. 2.615 109.477 ↑ 1.4 4,076 1

Hash Join (cost=3,566.36..3,897.68 rows=5,534 width=340) (actual time=100.326..109.477 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id, k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), k_6.id, a_st_loeschen_1.count_of_status_disabling_loeschen
  • Hash Cond: (k_4.finanzierung_id = f_2.id)
  • Buffers: shared hit=1,933
140. 4.053 79.734 ↑ 1.0 9,314 1

Hash Join (cost=1,706.68..1,963.99 rows=9,314 width=183) (actual time=73.128..79.734 rows=9,314 loops=1)

  • Output: k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, k_4.finanzierung_id, (CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END), k_6.id
  • Inner Unique: true
  • Hash Cond: (k_6.id = k_4.id)
  • Buffers: shared hit=858
141. 6.303 66.666 ↑ 1.0 9,314 1

HashAggregate (cost=1,218.12..1,357.83 rows=9,314 width=64) (actual time=64.037..66.666 rows=9,314 loops=1)

  • Output: k_6.id, CASE WHEN (ksp_1.id IS NOT NULL) THEN ksp_1.id ELSE (max(((ppksp_1.id)::character varying(50))::text))::uuid END, k_6.mandant_id, ksp_1.id
  • Group Key: k_6.id, ksp_1.id
  • Buffers: shared hit=579
142. 51.774 60.363 ↓ 1.1 10,560 1

Hash Left Join (cost=554.25..1,078.41 rows=9,314 width=64) (actual time=5.007..60.363 rows=10,560 loops=1)

  • Output: k_6.id, ksp_1.id, ppksp_1.id, k_6.mandant_id
  • Hash Cond: (k_6.kundentyp_id = ksp_1.kundentyp_id)
  • Buffers: shared hit=579
143. 2.526 8.579 ↓ 1.1 10,560 1

Hash Left Join (cost=553.19..1,019.81 rows=9,314 width=64) (actual time=4.983..8.579 rows=10,560 loops=1)

  • Output: k_6.id, k_6.mandant_id, k_6.kundentyp_id, ppksp_1.id
  • Hash Cond: (k_6.id = jt_3.kunde_id)
  • Buffers: shared hit=578
144. 1.108 1.108 ↑ 1.0 9,314 1

Seq Scan on public.kunde k_6 (cost=0.00..372.14 rows=9,314 width=48) (actual time=0.008..1.108 rows=9,314 loops=1)

  • Output: k_6.id, k_6.creation_date, k_6.creation_user, k_6.modification_date, k_6.modification_user, k_6.version, k_6.finanzierung_id, k_6.mandant_id, k_6.kundentyp_id, k_6.kunden_key, k_6.kunden_nr, k_6.external_kunden_nr, k_6.kundenbezeichnung, k_6.korrespondenzsprache, k_6.kundenberater_id, k_6.rating_abschluss_bisher_id, k_6.rating_abschluss_neu_id, k_6.creation_source, k_6.relationship_key, k_6.relationship_code, k_6.relationship_area, k_6.used_in_modul, k_6.original_entity_id, k_6.rechtsstatus, k_6.kundensegment_id, k_6.auspraegung1_id, k_6.auspraegung2_id
  • Buffers: shared hit=279
145. 0.528 4.945 ↑ 1.0 2,463 1

Hash (cost=522.40..522.40 rows=2,463 width=32) (actual time=4.945..4.945 rows=2,463 loops=1)

  • Output: jt_3.kunde_id, ppksp_1.id
  • Buckets: 4,096 Batches: 1 Memory Usage: 148kB
  • Buffers: shared hit=299
146. 0.458 4.417 ↑ 1.0 2,463 1

Hash Left Join (cost=75.48..522.40 rows=2,463 width=32) (actual time=0.879..4.417 rows=2,463 loops=1)

  • Output: jt_3.kunde_id, ppksp_1.id
  • Hash Cond: (pp_3.kundentyp_id = ppksp_1.kundentyp_id)
  • Buffers: shared hit=299
147. 1.880 3.941 ↑ 1.0 2,463 1

Hash Right Join (cost=74.42..506.12 rows=2,463 width=32) (actual time=0.839..3.941 rows=2,463 loops=1)

  • Output: jt_3.kunde_id, pp_3.kundentyp_id
  • Hash Cond: (pp_3.id = jt_3.kunde_einzelperson_id)
  • Buffers: shared hit=298
148. 1.253 1.253 ↑ 1.0 9,314 1

Seq Scan on public.kunde pp_3 (cost=0.00..372.14 rows=9,314 width=32) (actual time=0.006..1.253 rows=9,314 loops=1)

  • Output: pp_3.id, pp_3.creation_date, pp_3.creation_user, pp_3.modification_date, pp_3.modification_user, pp_3.version, pp_3.finanzierung_id, pp_3.mandant_id, pp_3.kundentyp_id, pp_3.kunden_key, pp_3.kunden_nr, pp_3.external_kunden_nr, pp_3.kundenbezeichnung, pp_3.korrespondenzsprache, pp_3.kundenberater_id, pp_3.rating_abschluss_bisher_id, pp_3.rating_abschluss_neu_id, pp_3.creation_source, pp_3.relationship_key, pp_3.relationship_code, pp_3.relationship_area, pp_3.used_in_modul, pp_3.original_entity_id, pp_3.rechtsstatus, pp_3.kundensegment_id, pp_3.auspraegung1_id, pp_3.auspraegung2_id
  • Buffers: shared hit=279
149. 0.525 0.808 ↑ 1.0 2,463 1

Hash (cost=43.63..43.63 rows=2,463 width=32) (actual time=0.808..0.808 rows=2,463 loops=1)

  • Output: jt_3.kunde_id, jt_3.kunde_einzelperson_id
  • Buckets: 4,096 Batches: 1 Memory Usage: 186kB
  • Buffers: shared hit=19
150. 0.283 0.283 ↑ 1.0 2,463 1

Seq Scan on public.jt_kunde_mehrere_privatpersonen_kunde_einzelperson jt_3 (cost=0.00..43.63 rows=2,463 width=32) (actual time=0.009..0.283 rows=2,463 loops=1)

  • Output: jt_3.kunde_id, jt_3.kunde_einzelperson_id
  • Buffers: shared hit=19
151. 0.007 0.018 ↑ 1.5 2 1

Hash (cost=1.03..1.03 rows=3 width=32) (actual time=0.018..0.018 rows=2 loops=1)

  • Output: ppksp_1.id, ppksp_1.kundentyp_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
152. 0.011 0.011 ↑ 1.0 3 1

Seq Scan on public.stamm_kundensegmentpruefung ppksp_1 (cost=0.00..1.03 rows=3 width=32) (actual time=0.009..0.011 rows=3 loops=1)

  • Output: ppksp_1.id, ppksp_1.kundentyp_id
  • Buffers: shared hit=1
153. 0.005 0.010 ↑ 1.5 2 1

Hash (cost=1.03..1.03 rows=3 width=32) (actual time=0.010..0.010 rows=2 loops=1)

  • Output: ksp_1.id, ksp_1.kundentyp_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
154. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on public.stamm_kundensegmentpruefung ksp_1 (cost=0.00..1.03 rows=3 width=32) (actual time=0.004..0.005 rows=3 loops=1)

  • Output: ksp_1.id, ksp_1.kundentyp_id
  • Buffers: shared hit=1
155. 5.295 9.015 ↑ 1.0 9,314 1

Hash (cost=372.14..372.14 rows=9,314 width=151) (actual time=9.015..9.015 rows=9,314 loops=1)

  • Output: k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, k_4.finanzierung_id
  • Buckets: 16,384 Batches: 1 Memory Usage: 1,537kB
  • Buffers: shared hit=279
156. 3.720 3.720 ↑ 1.0 9,314 1

Seq Scan on public.kunde k_4 (cost=0.00..372.14 rows=9,314 width=151) (actual time=0.013..3.720 rows=9,314 loops=1)

  • Output: k_4.id, k_4.kunden_nr, k_4.external_kunden_nr, k_4.kunden_key, k_4.kundenbezeichnung, k_4.kundenberater_id, k_4.kundentyp_id, k_4.creation_source, k_4.rating_abschluss_neu_id, k_4.finanzierung_id
  • Buffers: shared hit=279
157. 2.032 27.128 ↓ 1.0 4,076 1

Hash (cost=1,808.90..1,808.90 rows=4,062 width=189) (actual time=27.127..27.128 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, av_3.finanzierung_id, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id, a_st_loeschen_1.count_of_status_disabling_loeschen
  • Buckets: 4,096 Batches: 1 Memory Usage: 833kB
  • Buffers: shared hit=1,075
158. 1.110 25.096 ↓ 1.0 4,076 1

Hash Left Join (cost=1,486.59..1,808.90 rows=4,062 width=189) (actual time=20.070..25.096 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, av_3.finanzierung_id, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id, a_st_loeschen_1.count_of_status_disabling_loeschen
  • Inner Unique: true
  • Hash Cond: (a_1.id = a_st_loeschen_1.antrag_id)
  • Buffers: shared hit=1,075
159. 1.360 17.413 ↓ 1.0 4,076 1

Hash Join (cost=492.98..804.61 rows=4,062 width=181) (actual time=13.451..17.413 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, av_3.finanzierung_id, f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id
  • Inner Unique: true
  • Hash Cond: (av_3.finanzierung_id = f_2.id)
  • Buffers: shared hit=393
160. 1.403 7.935 ↓ 1.0 4,076 1

Hash Join (cost=187.15..488.11 rows=4,062 width=132) (actual time=5.269..7.935 rows=4,076 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id, av_3.id, av_3.geschaeftsfall, av_3.gesuchsgrund_id, av_3.status, av_3.sachbearbeiter_id, av_3.eingang, av_3.ausgang, av_3.finanzierung_id
  • Inner Unique: true
  • Hash Cond: (av_3.antrag_id = a_1.id)
  • Buffers: shared hit=241
161. 1.361 1.361 ↑ 1.0 4,424 1

Seq Scan on public.antrag_version av_3 (cost=0.00..289.21 rows=4,475 width=104) (actual time=0.018..1.361 rows=4,424 loops=1)

  • Output: av_3.id, av_3.creation_date, av_3.creation_user, av_3.modification_date, av_3.modification_user, av_3.version, av_3.interne_notizen, av_3.antrags_laufnummer, av_3.eingang, av_3.modul, av_3.status, av_3.mandant_id, av_3.antrag_id, av_3.finanzierung_id, av_3.sachbearbeiter_id, av_3.finanzierung_copied_by_reference, av_3.legacy_version, av_3.ausgang, av_3.finanzierung_copied_lazily, av_3.einreicher_id, av_3.geschaeftsfall, av_3.gesuchsgrund_id
  • Filter: ((av_3.modul = 'ANTRAG'::w1100_kbl_modul_enum) AND (av_3.status <> ALL ('{BOF_ABGELEHNT_KUNDE,BOF_ABGELEHNT_BANK,BOF_ABGESCHLOSSEN,BO_UEBERMITTELT_UND_ABGESCHLOSSEN}'::antrag_status_enum[])))
  • Rows Removed by Filter: 2,102
  • Buffers: shared hit=175
162. 2.458 5.171 ↓ 1.0 4,247 1

Hash (cost=134.97..134.97 rows=4,174 width=44) (actual time=5.171..5.171 rows=4,247 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 363kB
  • Buffers: shared hit=66
163. 2.713 2.713 ↓ 1.0 4,247 1

Seq Scan on public.antrag a_1 (cost=0.00..134.97 rows=4,174 width=44) (actual time=0.024..2.713 rows=4,247 loops=1)

  • Output: a_1.mandant_id, a_1.antrags_nr, a_1.eingangskanal, a_1.beratungs_nr, a_1.id
  • Filter: ((NOT a_1.permanently_deleted) AND ((a_1.mandant_id = '84381e52-6691-4000-b762-079bd28fbd47'::uuid) OR (a_1.mandant_id IS NULL)) AND (a_1.mandant_id = '84381e52-6691-4000-b762-079bd28fbd47'::uuid))
  • Rows Removed by Filter: 351
  • Buffers: shared hit=66
164. 3.708 8.118 ↑ 1.0 6,837 1

Hash (cost=220.37..220.37 rows=6,837 width=49) (actual time=8.118..8.118 rows=6,837 loops=1)

  • Output: f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 538kB
  • Buffers: shared hit=152
165. 4.410 4.410 ↑ 1.0 6,837 1

Seq Scan on public.finanzierung f_2 (cost=0.00..220.37 rows=6,837 width=49) (actual time=0.015..4.410 rows=6,837 loops=1)

  • Output: f_2.rahmenlimite_wert_neu_menge, f_2.rahmenlimite_wert_bisher_menge, f_2.rahmenlimite_wert_bisher_waehrung, f_2.rahmenlimite_wert_neu_waehrung, f_2.finanzierungs_nr, f_2.id
  • Buffers: shared hit=152
166. 0.206 6.573 ↑ 1.7 1,263 1

Hash (cost=966.25..966.25 rows=2,189 width=24) (actual time=6.573..6.573 rows=1,263 loops=1)

  • Output: a_st_loeschen_1.count_of_status_disabling_loeschen, a_st_loeschen_1.antrag_id
  • Buckets: 4,096 Batches: 1 Memory Usage: 102kB
  • Buffers: shared hit=682
167. 0.108 6.367 ↑ 1.7 1,263 1

Subquery Scan on a_st_loeschen_1 (cost=922.47..966.25 rows=2,189 width=24) (actual time=6.099..6.367 rows=1,263 loops=1)

  • Output: a_st_loeschen_1.count_of_status_disabling_loeschen, a_st_loeschen_1.antrag_id
  • Buffers: shared hit=682
168. 0.676 6.259 ↑ 1.7 1,263 1

HashAggregate (cost=922.47..944.36 rows=2,189 width=24) (actual time=6.098..6.259 rows=1,263 loops=1)

  • Output: av_4.antrag_id, count(*)
  • Group Key: av_4.antrag_id
  • Buffers: shared hit=682
169. 0.762 5.583 ↑ 1.0 2,189 1

Hash Join (cost=371.94..911.52 rows=2,189 width=16) (actual time=3.403..5.583 rows=2,189 loops=1)

  • Output: av_4.antrag_id
  • Inner Unique: true
  • Hash Cond: (ash_1.antrag_version_id = av_4.id)
  • Buffers: shared hit=682
170. 1.606 2.034 ↑ 1.0 2,189 1

Bitmap Heap Scan on public.antrag_status_history ash_1 (cost=50.11..583.94 rows=2,189 width=16) (actual time=0.553..2.034 rows=2,189 loops=1)

  • Output: ash_1.id, ash_1.creation_date, ash_1.creation_user, ash_1.modification_date, ash_1.modification_user, ash_1.version, ash_1.status, ash_1.benutzer_id, ash_1.bemerkung, ash_1.mandant_id, ash_1.antrag_version_id
  • Recheck Cond: (ash_1.status = ANY ('{BOF_ENTSCHEID_BEANTRAGT,BOF_QUALITAETSSICHERUNG,BOF_IN_VERARBEITUNG,BOF_ABGESCHLOSSEN}'::antrag_status_enum[]))
  • Heap Blocks: exact=493
  • Buffers: shared hit=507
171. 0.428 0.428 ↓ 1.0 2,190 1

Bitmap Index Scan on idx_antrag_status_history_status (cost=0.00..49.56 rows=2,189 width=0) (actual time=0.428..0.428 rows=2,190 loops=1)

  • Index Cond: (ash_1.status = ANY ('{BOF_ENTSCHEID_BEANTRAGT,BOF_QUALITAETSSICHERUNG,BOF_IN_VERARBEITUNG,BOF_ABGESCHLOSSEN}'::antrag_status_enum[]))
  • Buffers: shared hit=14
172. 1.234 2.787 ↑ 1.0 6,526 1

Hash (cost=240.26..240.26 rows=6,526 width=32) (actual time=2.787..2.787 rows=6,526 loops=1)

  • Output: av_4.antrag_id, av_4.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 472kB
  • Buffers: shared hit=175
173. 1.553 1.553 ↑ 1.0 6,526 1

Seq Scan on public.antrag_version av_4 (cost=0.00..240.26 rows=6,526 width=32) (actual time=0.011..1.553 rows=6,526 loops=1)

  • Output: av_4.antrag_id, av_4.id
  • Buffers: shared hit=175
174. 1.379 2.454 ↑ 1.0 6,551 1

Hash (cost=195.51..195.51 rows=6,551 width=30) (actual time=2.454..2.454 rows=6,551 loops=1)

  • Output: ep_1.name, ep_1.vorname, ep_1.kunde_id
  • Buckets: 8,192 Batches: 1 Memory Usage: 467kB
  • Buffers: shared hit=130
175. 1.075 1.075 ↑ 1.0 6,551 1

Seq Scan on public.kunde_einzelperson ep_1 (cost=0.00..195.51 rows=6,551 width=30) (actual time=0.012..1.075 rows=6,551 loops=1)

  • Output: ep_1.name, ep_1.vorname, ep_1.kunde_id
  • Buffers: shared hit=130
176. 0.276 3.125 ↓ 163.2 979 1

Hash (cost=400.16..400.16 rows=6 width=78) (actual time=3.125..3.125 rows=979 loops=1)

  • Output: newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_1.antrag_id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Buckets: 1,024 Batches: 1 Memory Usage: 114kB
  • Buffers: shared hit=188
177. 0.212 2.849 ↓ 163.2 979 1

Hash Left Join (cost=357.93..400.16 rows=6 width=78) (actual time=1.782..2.849 rows=979 loops=1)

  • Output: newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.id, newest_unrejected_av_1.antrag_id, newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Inner Unique: true
  • Hash Cond: (newest_unrejected_av_1.einreicher_id = newest_unrejected_av_einreicher_1.id)
  • Buffers: shared hit=188
178. 0.107 2.505 ↓ 163.2 979 1

Subquery Scan on newest_unrejected_av_1 (cost=340.07..382.29 rows=6 width=48) (actual time=1.644..2.505 rows=979 loops=1)

  • Output: newest_unrejected_av_1.id, newest_unrejected_av_1.creation_date, newest_unrejected_av_1.creation_user, newest_unrejected_av_1.modification_date, newest_unrejected_av_1.modification_user, newest_unrejected_av_1.version, newest_unrejected_av_1.interne_notizen, newest_unrejected_av_1.antrags_laufnummer, newest_unrejected_av_1.eingang, newest_unrejected_av_1.modul, newest_unrejected_av_1.status, newest_unrejected_av_1.mandant_id, newest_unrejected_av_1.antrag_id, newest_unrejected_av_1.finanzierung_id, newest_unrejected_av_1.sachbearbeiter_id, newest_unrejected_av_1.finanzierung_copied_by_reference, newest_unrejected_av_1.legacy_version, newest_unrejected_av_1.ausgang, newest_unrejected_av_1.finanzierung_copied_lazily, newest_unrejected_av_1.einreicher_id, newest_unrejected_av_1.geschaeftsfall, newest_unrejected_av_1.gesuchsgrund_id, newest_unrejected_av_1.rownum
  • Filter: (newest_unrejected_av_1.rownum = 1)
  • Rows Removed by Filter: 210
  • Buffers: shared hit=175
179. 0.708 2.398 ↑ 1.1 1,189 1

WindowAgg (cost=340.07..366.05 rows=1,299 width=443) (actual time=1.642..2.398 rows=1,189 loops=1)

  • Output: newest_1.id, NULL::timestamp without time zone, NULL::character varying(50), NULL::timestamp without time zone, NULL::character varying(50), NULL::integer, NULL::text, NULL::integer, newest_1.eingang, NULL::w1100_kbl_modul_enum, NULL::antrag_status_enum, NULL::uuid, newest_1.antrag_id, NULL::uuid, NULL::uuid, NULL::boolean, NULL::boolean, NULL::timestamp without time zone, NULL::boolean, newest_1.einreicher_id, NULL::w1112_geschaeftsfall_enum, NULL::uuid, row_number() OVER (?)
  • Buffers: shared hit=175
180. 0.543 1.690 ↑ 1.1 1,189 1

Sort (cost=340.07..343.32 rows=1,299 width=56) (actual time=1.625..1.690 rows=1,189 loops=1)

  • Output: newest_1.eingang, newest_1.antrag_id, newest_1.id, newest_1.einreicher_id
  • Sort Key: newest_1.antrag_id, newest_1.eingang DESC
  • Sort Method: quicksort Memory: 216kB
  • Buffers: shared hit=175
181. 1.147 1.147 ↑ 1.1 1,189 1

Seq Scan on public.antrag_version newest_1 (cost=0.00..272.89 rows=1,299 width=56) (actual time=0.011..1.147 rows=1,189 loops=1)

  • Output: newest_1.eingang, newest_1.antrag_id, newest_1.id, newest_1.einreicher_id
  • Filter: ((newest_1.modul = ANY ('{CREDIT_OFFICE,QUALITAETSSICHERUNG}'::w1100_kbl_modul_enum[])) AND (newest_1.status <> ALL ('{CO_ZURUECKGEWIESEN,QS_ZURUECKGEWIESEN}'::antrag_status_enum[])))
  • Rows Removed by Filter: 5,337
  • Buffers: shared hit=175
182. 0.047 0.132 ↑ 1.0 216 1

Hash (cost=15.16..15.16 rows=216 width=30) (actual time=0.132..0.132 rows=216 loops=1)

  • Output: newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
  • Buffers: shared hit=13
183. 0.085 0.085 ↑ 1.0 216 1

Seq Scan on public.premium_benutzer newest_unrejected_av_einreicher_1 (cost=0.00..15.16 rows=216 width=30) (actual time=0.010..0.085 rows=216 loops=1)

  • Output: newest_unrejected_av_einreicher_1.id, newest_unrejected_av_einreicher_1.vorname, newest_unrejected_av_einreicher_1.name
  • Buffers: shared hit=13
184. 0.044 0.096 ↑ 1.0 216 1

Hash (cost=15.16..15.16 rows=216 width=30) (actual time=0.096..0.096 rows=216 loops=1)

  • Output: pb_1.vorname, pb_1.name, pb_1.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
  • Buffers: shared hit=13
185. 0.052 0.052 ↑ 1.0 216 1

Seq Scan on public.premium_benutzer pb_1 (cost=0.00..15.16 rows=216 width=30) (actual time=0.004..0.052 rows=216 loops=1)

  • Output: pb_1.vorname, pb_1.name, pb_1.id
  • Buffers: shared hit=13
186. 0.041 56.919 ↑ 12.3 19 1

Hash (cost=772.58..772.58 rows=233 width=24) (actual time=56.919..56.919 rows=19 loops=1)

  • Output: p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, p_2.finanzierung_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1,440
187. 0.011 56.878 ↑ 12.3 19 1

Subquery Scan on p_2 (cost=767.92..772.58 rows=233 width=24) (actual time=56.854..56.878 rows=19 loops=1)

  • Output: p_2.count_of_produkte_with_soko_and_different_erfasser_and_bewillig, p_2.finanzierung_id
  • Buffers: shared hit=1,440
188. 0.048 56.867 ↑ 12.3 19 1

HashAggregate (cost=767.92..770.25 rows=233 width=24) (actual time=56.851..56.867 rows=19 loops=1)

  • Output: p_3.finanzierung_id, count(*)
  • Group Key: p_3.finanzierung_id
  • Buffers: shared hit=1,440
189. 0.028 56.819 ↑ 10.7 24 1

Nested Loop (cost=306.40..766.63 rows=257 width=16) (actual time=1.936..56.819 rows=24 loops=1)

  • Output: p_3.finanzierung_id
  • Join Filter: (p_3.bewilliger_id <> k_7.kundenberater_id)
  • Rows Removed by Join Filter: 12
  • Buffers: shared hit=1,440
190. 0.207 56.611 ↑ 5.5 36 1

Nested Loop (cost=306.12..667.77 rows=198 width=64) (actual time=1.868..56.611 rows=36 loops=1)

  • Output: p_3.finanzierung_id, p_3.bewilliger_id, f_3.id, av_5.finanzierung_id
  • Join Filter: (p_3.bewilliger_id <> av_5.sachbearbeiter_id)
  • Rows Removed by Join Filter: 322
  • Buffers: shared hit=1,332
191. 0.193 55.444 ↓ 1.4 320 1

Hash Join (cost=305.83..565.70 rows=237 width=48) (actual time=1.846..55.444 rows=320 loops=1)

  • Output: p_3.finanzierung_id, p_3.bewilliger_id, f_3.id
  • Inner Unique: true
  • Hash Cond: (p_3.finanzierung_id = f_3.id)
  • Buffers: shared hit=332
192. 53.454 53.454 ↓ 1.4 320 1

Seq Scan on public.produkt_fla p_3 (cost=0.00..259.25 rows=237 width=32) (actual time=0.020..53.454 rows=320 loops=1)

  • Output: p_3.id, p_3.creation_date, p_3.creation_user, p_3.modification_date, p_3.modification_user, p_3.version, p_3.basiszins, p_3.bearbeitungsgebuehr_waehrung, p_3.bearbeitungsgebuehr_menge, p_3.betrag_waehrung, p_3.betrag_menge, p_3.bewilligungsstatus, p_3.bruttomarge, p_3.datum, p_3.floatend, p_3.laufzeit, p_3.laufzeit_von, p_3.laufzeit_bis, p_3.periodizitaet, p_3.stand_per, p_3.usanz, p_3.mandant_id, p_3.produktmapping_id, p_3.meldung, p_3.finanzierung_id, p_3.abweichung1_id, p_3.abweichung_satz1, p_3.abweichung2_id, p_3.abweichung_satz2, p_3.abweichung3_id, p_3.abweichung_satz3, p_3.removed, p_3.core_system_loaded, p_3.verlaengern_status, p_3.kundenzins_produkt_core, p_3.bemerkung_abweichungen, p_3.bewilliger_id, p_3.used_in_modul, p_3.original_entity_id, p_3.zinskonto_id, p_3.melder_id, p_3.melde_datum, p_3.tranchen_nr, p_3.staffel_sortierung, p_3.produktkonto_id, p_3.zinszahlung_erstmals_per, p_3.periodizitaet_id, p_3.abweichung4_id, p_3.abweichung_satz4
  • Filter: ((p_3.bewilliger_id IS NOT NULL) AND (p_3.meldung = ANY ('{OFFEN,BEREIT}'::w1090_meldestatus_enum[])) AND (p_3.bewilligungsstatus = 'BEWILLIGT'::w1061_bewillig_status_prod_enum))
  • Rows Removed by Filter: 4,963
  • Buffers: shared hit=180
193. 0.991 1.797 ↑ 1.0 6,837 1

Hash (cost=220.37..220.37 rows=6,837 width=16) (actual time=1.797..1.797 rows=6,837 loops=1)

  • Output: f_3.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 385kB
  • Buffers: shared hit=152
194. 0.806 0.806 ↑ 1.0 6,837 1

Seq Scan on public.finanzierung f_3 (cost=0.00..220.37 rows=6,837 width=16) (actual time=0.005..0.806 rows=6,837 loops=1)

  • Output: f_3.id
  • Buffers: shared hit=152
195. 0.960 0.960 ↑ 1.0 1 320

Index Scan using idx_antrag_version_finanzierung on public.antrag_version av_5 (cost=0.28..0.42 rows=1 width=48) (actual time=0.003..0.003 rows=1 loops=320)

  • Output: av_5.id, av_5.creation_date, av_5.creation_user, av_5.modification_date, av_5.modification_user, av_5.version, av_5.interne_notizen, av_5.antrags_laufnummer, av_5.eingang, av_5.modul, av_5.status, av_5.mandant_id, av_5.antrag_id, av_5.finanzierung_id, av_5.sachbearbeiter_id, av_5.finanzierung_copied_by_reference, av_5.legacy_version, av_5.ausgang, av_5.finanzierung_copied_lazily, av_5.einreicher_id, av_5.geschaeftsfall, av_5.gesuchsgrund_id
  • Index Cond: (av_5.finanzierung_id = f_3.id)
  • Buffers: shared hit=1,000
196. 0.180 0.180 ↑ 1.0 1 36

Index Scan using idx_kunde_finanzierung on public.kunde k_7 (cost=0.29..0.49 rows=1 width=32) (actual time=0.004..0.005 rows=1 loops=36)

  • Output: k_7.id, k_7.creation_date, k_7.creation_user, k_7.modification_date, k_7.modification_user, k_7.version, k_7.finanzierung_id, k_7.mandant_id, k_7.kundentyp_id, k_7.kunden_key, k_7.kunden_nr, k_7.external_kunden_nr, k_7.kundenbezeichnung, k_7.korrespondenzsprache, k_7.kundenberater_id, k_7.rating_abschluss_bisher_id, k_7.rating_abschluss_neu_id, k_7.creation_source, k_7.relationship_key, k_7.relationship_code, k_7.relationship_area, k_7.used_in_modul, k_7.original_entity_id, k_7.rechtsstatus, k_7.kundensegment_id, k_7.auspraegung1_id, k_7.auspraegung2_id
  • Index Cond: (k_7.finanzierung_id = f_3.id)
  • Buffers: shared hit=108
197. 0.181 0.398 ↑ 1.0 216 1

Hash (cost=15.16..15.16 rows=216 width=30) (actual time=0.398..0.398 rows=216 loops=1)

  • Output: kb_1.vorname, kb_1.name, kb_1.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
  • Buffers: shared hit=13
198. 0.217 0.217 ↑ 1.0 216 1

Seq Scan on public.premium_benutzer kb_1 (cost=0.00..15.16 rows=216 width=30) (actual time=0.010..0.217 rows=216 loops=1)

  • Output: kb_1.vorname, kb_1.name, kb_1.id
  • Buffers: shared hit=13
199. 0.024 0.060 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=687) (actual time=0.060..0.060 rows=25 loops=1)

  • Output: ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, ks_1.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
200. 0.036 0.036 ↑ 1.0 25 1

Seq Scan on public.stamm_kundensegment ks_1 (cost=0.00..1.25 rows=25 width=687) (actual time=0.023..0.036 rows=25 loops=1)

  • Output: ks_1.bezeichnung_de, ks_1.bezeichnung_en, ks_1.bezeichnung_fr, ks_1.bezeichnung_it, ks_1.id
  • Buffers: shared hit=1
201.          

SubPlan (for Hash Left Join)

202. 24.456 24.456 ↑ 1.0 1 8,152

Seq Scan on public.stamm_kundentyp kt_3 (cost=0.00..1.34 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=8,152)

  • Output: kt_3.kundensegment_id
  • Filter: (k_4.kundentyp_id = kt_3.id)
  • Rows Removed by Filter: 26
  • Buffers: shared hit=8,152
203. 0.177 0.350 ↑ 1.0 276 1

Hash (cost=8.76..8.76 rows=276 width=36) (actual time=0.350..0.350 rows=276 loops=1)

  • Output: g_1.bezeichnung_de, g_1.bezeichnung_en, g_1.bezeichnung_fr, g_1.bezeichnung_it, g_1.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
  • Buffers: shared hit=6
204. 0.173 0.173 ↑ 1.0 276 1

Seq Scan on public.stamm_gesuchsgrund g_1 (cost=0.00..8.76 rows=276 width=36) (actual time=0.016..0.173 rows=276 loops=1)

  • Output: g_1.bezeichnung_de, g_1.bezeichnung_en, g_1.bezeichnung_fr, g_1.bezeichnung_it, g_1.id
  • Buffers: shared hit=6
205. 0.118 0.193 ↑ 1.0 188 1

Hash (cost=3.88..3.88 rows=188 width=41) (actual time=0.193..0.193 rows=188 loops=1)

  • Output: pbt_1.team, pbt_1.benutzer_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
  • Buffers: shared hit=2
206. 0.075 0.075 ↑ 1.0 188 1

Seq Scan on public.jt_premium_benutzer_teams pbt_1 (cost=0.00..3.88 rows=188 width=41) (actual time=0.012..0.075 rows=188 loops=1)

  • Output: pbt_1.team, pbt_1.benutzer_id
  • Buffers: shared hit=2
207. 0.124 0.206 ↑ 1.0 181 1

Hash (cost=3.81..3.81 rows=181 width=39) (actual time=0.206..0.206 rows=181 loops=1)

  • Output: pba_1.abteilung, pba_1.benutzer_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
  • Buffers: shared hit=2
208. 0.082 0.082 ↑ 1.0 181 1

Seq Scan on public.jt_premium_benutzer_abteilungen pba_1 (cost=0.00..3.81 rows=181 width=39) (actual time=0.017..0.082 rows=181 loops=1)

  • Output: pba_1.abteilung, pba_1.benutzer_id
  • Buffers: shared hit=2
209. 0.094 0.152 ↑ 1.0 188 1

Hash (cost=3.88..3.88 rows=188 width=35) (actual time=0.152..0.152 rows=188 loops=1)

  • Output: pbb_1.bereich, pbb_1.benutzer_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
  • Buffers: shared hit=2
210. 0.058 0.058 ↑ 1.0 188 1

Seq Scan on public.jt_premium_benutzer_bereiche pbb_1 (cost=0.00..3.88 rows=188 width=35) (actual time=0.011..0.058 rows=188 loops=1)

  • Output: pbb_1.bereich, pbb_1.benutzer_id
  • Buffers: shared hit=2
Planning time : 26.555 ms
Execution time : 736.664 ms