explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GTSP

Settings
# exclusive inclusive rows x rows loops node
1. 3.596 8,129,073.244 ↓ 1,106.0 1,106 1

GroupAggregate (cost=5,370,010.70..5,370,019.12 rows=1 width=1,045) (actual time=8,129,069.630..8,129,073.244 rows=1,106 loops=1)

  • Output: bi_soc.soc_id, plan_employeur_affilie.plan_employeur_affilie_id, contrat.contrat_id, contrat.numero_contrat, a1_bi_partenaire_ili_dos_affi.nom_prenom, a1_bi_partenaire_ili_dos_affi.sexe, sum(COALESCE(part_comm_dossier.sal_avs, '0'::numeric)), sum(COALESCE(part_comm_dossier.sal_cotisant_garanti, '0'::numeric)), sum(COALESCE(pa_gen_prest.prest_tot, '0'::numeric)), sum(COALESCE(sal_plan_partie.sal, '0'::numeric)), sum(COALESCE(pa_gen_prest.avoir_31_12, '0'::numeric)), sum(COALESCE(pa_gen_prest.prest_projetee_avec_int, '0'::numeric)), sum(COALESCE(prest_sortie.prest_sortie, '0'::numeric)), sum(COALESCE(prest_sortie.avoir_min_lpp, '0'::numeric)), sum(COALESCE(coti_plan_part_comm.coti_tot, '0'::numeric)), pa_gen_prest.pa_gen_prest_id, a1_bi_partenaire_ili_cont_empl.nom_prenom, dossier.numero_dossier, dossier.dossier_id, a1_bi_partenaire_ili_dos_affi.date_naissance, plan_partie.nom_plan, plan_partie.nom_comm, sum(COALESCE(cpt_epa_tot.mnt_lpp, '0'::numeric)), sum(COALESCE(cpt_epa_tot.mnt_tot, '0'::numeric)), bi_couv.avant_apres_terme, pa_gen.type_couv, bi_couv.tco_desc_courte, part_comm_dossier.tx_act, tx_inva.tx_validite, partie_dossier.dte_age_terme, plan_partie.type_plan, ((SubPlan 1)), plan_partie.type_prev_lpp, plan_partie.plan_partie_id
  • Group Key: bi_soc.soc_id, plan_employeur_affilie.plan_employeur_affilie_id, contrat.contrat_id, a1_bi_partenaire_ili_dos_affi.nom_prenom, a1_bi_partenaire_ili_dos_affi.sexe, pa_gen_prest.pa_gen_prest_id, a1_bi_partenaire_ili_cont_empl.nom_prenom, dossier.dossier_id, a1_bi_partenaire_ili_dos_affi.date_naissance, bi_couv.avant_apres_terme, pa_gen.type_couv, bi_couv.tco_desc_courte, part_comm_dossier.tx_act, tx_inva.tx_validite, partie_dossier.dte_age_terme, ((SubPlan 1)), plan_partie.plan_partie_id
  • Buffers: shared hit=982,587,538 read=42,041,495 dirtied=94 written=47,056, temp read=195,966 written=196,516
2. 5.186 8,129,069.648 ↓ 1,106.0 1,106 1

Sort (cost=5,370,010.70..5,370,010.71 rows=1 width=750) (actual time=8,129,069.576..8,129,069.648 rows=1,106 loops=1)

  • Output: bi_soc.soc_id, plan_employeur_affilie.plan_employeur_affilie_id, contrat.contrat_id, a1_bi_partenaire_ili_dos_affi.nom_prenom, a1_bi_partenaire_ili_dos_affi.sexe, pa_gen_prest.pa_gen_prest_id, a1_bi_partenaire_ili_cont_empl.nom_prenom, dossier.dossier_id, a1_bi_partenaire_ili_dos_affi.date_naissance, bi_couv.avant_apres_terme, pa_gen.type_couv, bi_couv.tco_desc_courte, part_comm_dossier.tx_act, tx_inva.tx_validite, partie_dossier.dte_age_terme, ((SubPlan 1)), plan_partie.plan_partie_id, contrat.numero_contrat, part_comm_dossier.sal_avs, part_comm_dossier.sal_cotisant_garanti, pa_gen_prest.prest_tot, sal_plan_partie.sal, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, prest_sortie.prest_sortie, prest_sortie.avoir_min_lpp, coti_plan_part_comm.coti_tot, dossier.numero_dossier, plan_partie.nom_plan, plan_partie.nom_comm, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, plan_partie.type_plan, plan_partie.type_prev_lpp
  • Sort Key: plan_employeur_affilie.plan_employeur_affilie_id, contrat.contrat_id, a1_bi_partenaire_ili_dos_affi.nom_prenom, a1_bi_partenaire_ili_dos_affi.sexe, pa_gen_prest.pa_gen_prest_id, a1_bi_partenaire_ili_cont_empl.nom_prenom, dossier.dossier_id, a1_bi_partenaire_ili_dos_affi.date_naissance, bi_couv.avant_apres_terme, pa_gen.type_couv, bi_couv.tco_desc_courte, part_comm_dossier.tx_act, tx_inva.tx_validite, partie_dossier.dte_age_terme, ((SubPlan 1)), plan_partie.plan_partie_id
  • Sort Method: quicksort Memory: 619kB
  • Buffers: shared hit=982,587,538 read=42,041,495 dirtied=94 written=47,056, temp read=195,966 written=196,516
3. 3.088 8,129,064.462 ↓ 1,106.0 1,106 1

Nested Loop (cost=616,927.33..5,370,010.69 rows=1 width=750) (actual time=189,836.813..8,129,064.462 rows=1,106 loops=1)

  • Output: bi_soc.soc_id, plan_employeur_affilie.plan_employeur_affilie_id, contrat.contrat_id, a1_bi_partenaire_ili_dos_affi.nom_prenom, a1_bi_partenaire_ili_dos_affi.sexe, pa_gen_prest.pa_gen_prest_id, a1_bi_partenaire_ili_cont_empl.nom_prenom, dossier.dossier_id, a1_bi_partenaire_ili_dos_affi.date_naissance, bi_couv.avant_apres_terme, pa_gen.type_couv, bi_couv.tco_desc_courte, part_comm_dossier.tx_act, tx_inva.tx_validite, partie_dossier.dte_age_terme, (SubPlan 1), plan_partie.plan_partie_id, contrat.numero_contrat, part_comm_dossier.sal_avs, part_comm_dossier.sal_cotisant_garanti, pa_gen_prest.prest_tot, sal_plan_partie.sal, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, prest_sortie.prest_sortie, prest_sortie.avoir_min_lpp, coti_plan_part_comm.coti_tot, dossier.numero_dossier, plan_partie.nom_plan, plan_partie.nom_comm, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, plan_partie.type_plan, plan_partie.type_prev_lpp
  • Buffers: shared hit=982,587,526 read=42,041,495 dirtied=94 written=47,056, temp read=195,966 written=196,516
4. 2.690 8,128,800.358 ↓ 1,106.0 1,106 1

Nested Loop (cost=616,926.90..5,369,976.11 rows=1 width=230) (actual time=189,832.004..8,128,800.358 rows=1,106 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, coti_plan_part_comm.coti_tot, sal_plan_partie.sal, tx_inva.tx_validite, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, dossier.numero_dossier, dossier.dossier_id, contrat.contrat_id, contrat.numero_contrat, bi_soc.soc_id, a1_bi_partenaire_ili_cont_empl.nom_prenom, part_comm_dossier.sal_avs, part_comm_dossier.sal_cotisant_garanti, part_comm_dossier.tx_act, a1_bi_partenaire_ili_dos_affi.nom_prenom, a1_bi_partenaire_ili_dos_affi.sexe, a1_bi_partenaire_ili_dos_affi.date_naissance
  • Inner Unique: true
  • Buffers: shared hit=982,580,161 read=42,041,078 dirtied=94 written=47,056, temp read=195,966 written=196,516
5. 2.311 8,128,609.648 ↓ 1,106.0 1,106 1

Nested Loop (cost=616,926.48..5,369,968.22 rows=1 width=205) (actual time=189,830.401..8,128,609.648 rows=1,106 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, coti_plan_part_comm.coti_tot, sal_plan_partie.sal, tx_inva.tx_validite, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, dossier.numero_dossier, dossier.dossier_id, contrat.contrat_id, contrat.numero_contrat, bi_soc.soc_id, a1_bi_partenaire_ili_cont_empl.nom_prenom, part_comm_dossier.sal_avs, part_comm_dossier.sal_cotisant_garanti, part_comm_dossier.tx_act, a1_part_ili_dos_affi.numero_contact
  • Inner Unique: true
  • Buffers: shared hit=982,576,016 read=42,040,799 dirtied=94 written=47,056, temp read=195,966 written=196,516
6. 1.738 8,128,430.377 ↓ 1,106.0 1,106 1

Nested Loop (cost=616,926.05..5,369,960.32 rows=1 width=205) (actual time=189,829.161..8,128,430.377 rows=1,106 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, coti_plan_part_comm.coti_tot, sal_plan_partie.sal, tx_inva.tx_validite, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, dossier.numero_dossier, dossier.dossier_id, contrat.contrat_id, contrat.numero_contrat, bi_soc.soc_id, a1_bi_partenaire_ili_cont_empl.nom_prenom, part_comm_dossier.sal_avs, part_comm_dossier.sal_cotisant_garanti, part_comm_dossier.tx_act, a1_part_dossier_ili_affi.part_dossier_part_id
  • Buffers: shared hit=982,571,866 read=42,040,515 dirtied=94 written=47,056, temp read=195,966 written=196,516
7. 1.371 8,128,271.587 ↓ 1,106.0 1,106 1

Nested Loop (cost=616,925.62..5,369,905.34 rows=1 width=213) (actual time=189,827.479..8,128,271.587 rows=1,106 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, coti_plan_part_comm.coti_tot, sal_plan_partie.sal, tx_inva.tx_validite, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id, dossier_gen.dossier_gen_id, dossier.numero_dossier, dossier.dossier_id, contrat.contrat_id, contrat.numero_contrat, bi_soc.soc_id, a1_bi_partenaire_ili_cont_empl.nom_prenom, part_comm_dossier.sal_avs, part_comm_dossier.sal_cotisant_garanti, part_comm_dossier.tx_act, part_comm_dossier.dossier_gen_id
  • Inner Unique: true
  • Join Filter: (dossier_gen.dossier_gen_id = part_comm_dossier.dossier_gen_id)
  • Buffers: shared hit=982,567,698 read=42,040,209 dirtied=94 written=47,056, temp read=195,966 written=196,516
8. 2.408 8,128,058.970 ↓ 1,106.0 1,106 1

Nested Loop Left Join (cost=616,925.19..5,369,897.41 rows=1 width=203) (actual time=189,824.508..8,128,058.970 rows=1,106 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id, dossier_gen.dossier_gen_id, dossier.numero_dossier, dossier.dossier_id, contrat.contrat_id, contrat.numero_contrat, bi_soc.soc_id, a1_bi_partenaire_ili_cont_empl.nom_prenom
  • Inner Unique: true
  • Buffers: shared hit=982,563,567 read=42,039,916 dirtied=94 written=47,056, temp read=195,966 written=196,516
9. 2.523 8,127,972.506 ↓ 1,106.0 1,106 1

Nested Loop (cost=616,924.76..5,369,889.52 rows=1 width=190) (actual time=189,823.424..8,127,972.506 rows=1,106 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id, dossier_gen.dossier_gen_id, dossier.numero_dossier, dossier.dossier_id, contrat.contrat_id, contrat.numero_contrat, bi_soc.soc_id, a1_part_ili_cont_empl.numero_contact
  • Inner Unique: true
  • Buffers: shared hit=982,559,298 read=42,039,761 dirtied=94 written=47,056, temp read=195,966 written=196,516
10. 2.435 8,127,903.623 ↓ 1,106.0 1,106 1

Nested Loop (cost=616,924.34..5,369,881.62 rows=1 width=190) (actual time=189,822.664..8,127,903.623 rows=1,106 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id, dossier_gen.dossier_gen_id, dossier.numero_dossier, dossier.dossier_id, contrat.contrat_id, contrat.numero_contrat, bi_soc.soc_id, a1_part_contrat_ili_empl.part_id
  • Buffers: shared hit=982,555,003 read=42,039,632 dirtied=94 written=47,056, temp read=195,966 written=196,516
11. 2.140 8,127,858.054 ↓ 1,106.0 1,106 1

Nested Loop (cost=616,924.34..5,369,880.52 rows=1 width=190) (actual time=189,821.422..8,127,858.054 rows=1,106 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id, dossier_gen.dossier_gen_id, dossier.numero_dossier, dossier.dossier_id, contrat.contrat_id, contrat.numero_contrat, bi_prod.soc_id, a1_part_contrat_ili_empl.part_id
  • Inner Unique: true
  • Buffers: shared hit=982,553,950 read=42,039,579 dirtied=94 written=47,056, temp read=195,966 written=196,516
12. 64.807 8,127,827.158 ↓ 1,106.0 1,106 1

Nested Loop (cost=616,924.20..5,369,872.16 rows=1 width=190) (actual time=189,821.385..8,127,827.158 rows=1,106 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id, dossier_gen.dossier_gen_id, dossier.numero_dossier, dossier.dossier_id, contrat.contrat_id, contrat.numero_contrat, contrat.pro_id, a1_part_contrat_ili_empl.part_id
  • Join Filter: (contrat.contrat_id = dossier.contrat_id)
  • Rows Removed by Join Filter: 386,103
  • Buffers: shared hit=982,551,790 read=42,039,527 dirtied=94 written=47,056, temp read=195,966 written=196,516
13. 0.005 10.546 ↑ 1.0 1 1

Nested Loop (cost=5.25..321.52 rows=1 width=20) (actual time=0.708..10.546 rows=1 loops=1)

  • Output: contrat.contrat_id, contrat.numero_contrat, contrat.pro_id, mut_contrat.contrat_id, a1_part_contrat_ili_empl.part_id
  • Buffers: shared hit=224 read=87
14. 0.004 10.507 ↑ 1.0 1 1

Nested Loop (cost=4.82..313.30 rows=1 width=20) (actual time=0.679..10.507 rows=1 loops=1)

  • Output: contrat.contrat_id, contrat.numero_contrat, contrat.pro_id, mut_contrat.contrat_id, contrat_gen.contrat_gen_id
  • Buffers: shared hit=220 read=87
15. 0.010 10.475 ↑ 1.0 1 1

Nested Loop (cost=4.53..305.47 rows=1 width=20) (actual time=0.650..10.475 rows=1 loops=1)

  • Output: contrat.contrat_id, contrat.numero_contrat, contrat.pro_id, mut_contrat.contrat_id, mut_contrat.mut_contrat_id
  • Buffers: shared hit=217 read=87
16. 6.415 6.415 ↑ 1.0 1 1

Seq Scan on iliade.contrat (cost=0.00..170.93 rows=1 width=12) (actual time=0.252..6.415 rows=1 loops=1)

  • Output: contrat.contrat_id, contrat.employeur_part_id, contrat.mut_dossier_autorisee_id, contrat.pro_id, contrat.numero_contrat, contrat.dte_effet, contrat.dte_effet_pe, contrat.blocage_dossiers, contrat.blocage_fact, contrat.raison_blocage_fact, contrat.visa_blocage_fact, contrat.dte_operation_blocage_fact, contrat.dte_derniere_fact, contrat.responsable_gest, contrat.responsable_gest_medicale, contrat.ancien_numero_contrat, contrat.reass, contrat.usr_log_i, contrat.dte_log_i, contrat.usr_log_u, contrat.dte_log_u, contrat.dte_entree, contrat.quotite_apport_initial, contrat.comp_cmt_pari, contrat.calc_dte_affiliation, contrat.objet_facturable_allocemp_cree, contrat.dte_derniere_fact_prest, contrat.reass_complete, contrat.audit, contrat.blocage_extranet, contrat.secteur_gestion
  • Filter: (contrat.numero_contrat = 1,936)
  • Rows Removed by Filter: 5,673
  • Buffers: shared hit=20 read=80
17. 1.635 4.050 ↑ 1.0 1 1

Bitmap Heap Scan on iliade.mut_contrat (cost=4.53..134.54 rows=1 width=8) (actual time=0.392..4.050 rows=1 loops=1)

  • Output: mut_contrat.contrat_id, mut_contrat.mut_contrat_id
  • Recheck Cond: (mut_contrat.contrat_id = contrat.contrat_id)
  • Filter: (mut_contrat.no_gen_contrat = (SubPlan 5))
  • Rows Removed by Filter: 33
  • Heap Blocks: exact=31
  • Buffers: shared hit=197 read=7
18. 0.035 0.035 ↓ 2.3 34 1

Bitmap Index Scan on olm_perf_i_2020_02097_2 (cost=0.00..4.53 rows=15 width=0) (actual time=0.035..0.035 rows=34 loops=1)

  • Index Cond: (mut_contrat.contrat_id = contrat.contrat_id)
  • Buffers: shared hit=3
19.          

SubPlan (for Bitmap Heap Scan)

20. 0.034 2.380 ↑ 1.0 1 34

Result (cost=4.91..4.92 rows=1 width=4) (actual time=0.070..0.070 rows=1 loops=34)

  • Output: $4
  • Buffers: shared hit=166 read=4
21.          

Initplan (for Result)

22. 0.000 2.346 ↑ 1.0 1 34

Limit (cost=0.42..4.91 rows=1 width=4) (actual time=0.069..0.069 rows=1 loops=34)

  • Output: a_1.no_gen_contrat
  • Buffers: shared hit=166 read=4
23. 2.346 2.346 ↑ 14.0 1 34

Index Scan Backward using olm_perf_i_2020_02097_2 on iliade.mut_contrat a_1 (cost=0.42..63.37 rows=14 width=4) (actual time=0.069..0.069 rows=1 loops=34)

  • Output: a_1.no_gen_contrat
  • Index Cond: ((mut_contrat.contrat_id = a_1.contrat_id) AND (a_1.no_gen_contrat IS NOT NULL) AND ((a_1.etat)::text = 'VALI'::text))
  • Filter: (a_1.dte_mut <= '2019-12-31'::date)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=166 read=4
24. 0.028 0.028 ↑ 1.0 1 1

Index Scan using mu_c_in_c_g_fk on iliade.contrat_gen (cost=0.29..7.82 rows=1 width=8) (actual time=0.026..0.028 rows=1 loops=1)

  • Output: contrat_gen.contrat_gen_id, contrat_gen.contrat_pilote_fonds_gar_id, contrat_gen.mut_contrat_id, contrat_gen.nouvelle_ip_part_id, contrat_gen.contrat_pilote_regrp_gest_id, contrat_gen.secteur_act_predominant_id, contrat_gen.contrat_id, contrat_gen.no_gen_contrat, contrat_gen.type_rattr, contrat_gen.gest_reservee, contrat_gen.code_voir_dossier, contrat_gen.confidentiel, contrat_gen.effectif_pour_rab, contrat_gen.nombre_affilies_reel, contrat_gen.appliquer_tx_validite, contrat_gen.appliquer_tx_act, contrat_gen.bonif_escomptee, contrat_gen.fonds_gar, contrat_gen.pilote_regrpmnt_gest, contrat_gen.age_terme_vise, contrat_gen.regrpmnt_contrat_fonds_gar, contrat_gen.statut_cmt_pari, contrat_gen.dte_prochaine_maj_effectif, contrat_gen.numero_avenant, contrat_gen.dte_entree_vigueur_avenant, contrat_gen.type_avenant, contrat_gen.suivi_contentieux, contrat_gen.contrat_resilie_cours_annee, contrat_gen.correspondance_employeur_seul, contrat_gen.envoi_liste_annuelle_salaires, contrat_gen.envoi_extrait_rapport_annuel, contrat_gen.envoi_situation_prev, contrat_gen.envoi_courrier_va_logement, contrat_gen.dte_ctrl_cmt_pari, contrat_gen.nombre_repr_employeur_requis, contrat_gen.nombre_repr_empl_requis, contrat_gen.grand_contrat, contrat_gen.tx_coti_laa, contrat_gen.usr_log_i, contrat_gen.dte_log_i, contrat_gen.usr_log_u, contrat_gen.dte_log_u, contrat_gen.idx_particuliere, contrat_gen.fact_rattr, contrat_gen.audit, contrat_gen.envoi_bordereau_fact, contrat_gen.dte_echeance, contrat_gen.choix_plan_complementaire, contrat_gen.declaration_fiscale, contrat_gen.soumis_cct, contrat_gen.groupement_cct, contrat_gen.particularites_contrat, contrat_gen.impression_documents_facturation, contrat_gen.impot_source
  • Index Cond: (contrat_gen.mut_contrat_id = mut_contrat.mut_contrat_id)
  • Buffers: shared hit=3
25. 0.034 0.034 ↑ 1.0 1 1

Index Scan using c_g_in_pt_c_fk on iliade.part_contrat a1_part_contrat_ili_empl (cost=0.42..8.20 rows=1 width=8) (actual time=0.027..0.034 rows=1 loops=1)

  • Output: a1_part_contrat_ili_empl.part_contrat_id, a1_part_contrat_ili_empl.contrat_gen_id, a1_part_contrat_ili_empl.part_id, a1_part_contrat_ili_empl.contrat_id, a1_part_contrat_ili_empl.no_gen_contrat, a1_part_contrat_ili_empl.role, a1_part_contrat_ili_empl.usr_log_i, a1_part_contrat_ili_empl.dte_log_i, a1_part_contrat_ili_empl.usr_log_u, a1_part_contrat_ili_empl.dte_log_u, a1_part_contrat_ili_empl.audit, a1_part_contrat_ili_empl.adresse_facturation_id, a1_part_contrat_ili_empl.region, a1_part_contrat_ili_empl.type_aprt_aff, a1_part_contrat_ili_empl.type_intmd_ext, a1_part_contrat_ili_empl.type_intmd_intn
  • Index Cond: (a1_part_contrat_ili_empl.contrat_gen_id = contrat_gen.contrat_gen_id)
  • Filter: ((a1_part_contrat_ili_empl.role)::text = 'EMPL'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=4
26. 195.776 8,127,751.805 ↓ 387,209.0 387,209 1

Nested Loop (cost=616,918.95..5,369,550.63 rows=1 width=178) (actual time=60,481.252..8,127,751.805 rows=387,209 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id, dossier_gen.dossier_gen_id, dossier.numero_dossier, dossier.dossier_id, dossier.contrat_id
  • Inner Unique: true
  • Buffers: shared hit=982,551,566 read=42,039,440 dirtied=94 written=47,056, temp read=195,966 written=196,516
27. 16,068.044 8,119,811.849 ↓ 387,209.0 387,209 1

Nested Loop (cost=616,918.53..5,369,542.73 rows=1 width=170) (actual time=60,478.951..8,119,811.849 rows=387,209 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id, dossier_gen.dossier_gen_id, mut_dossier.dossier_id
  • Inner Unique: true
  • Buffers: shared hit=981,064,283 read=41,976,969 dirtied=94 written=47,044, temp read=195,966 written=196,516
28. 20,560.626 7,778,159.845 ↓ 16,279,198.0 16,279,198 1

Nested Loop (cost=616,918.10..5,369,529.94 rows=1 width=170) (actual time=40,697.735..7,778,159.845 rows=16,279,198 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id, dossier_gen.dossier_gen_id, dossier_gen.mut_dossier_id
  • Inner Unique: true
  • Buffers: shared hit=838,704,018 read=39,086,343 dirtied=94 written=43,085, temp read=195,966 written=196,516
29. 20,189.648 7,480,852.853 ↓ 16,279,198.0 16,279,198 1

Nested Loop (cost=616,917.67..5,369,522.03 rows=1 width=162) (actual time=40,695.478..7,480,852.853 rows=16,279,198 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id, partie_dossier.dte_age_terme, partie_dossier.partie_dossier_id, partie_dossier.dossier_gen_id
  • Inner Unique: true
  • Buffers: shared hit=775,547,983 read=37,081,353 dirtied=94 written=40,653, temp read=195,966 written=196,516
30. 8,404.710 7,305,274.965 ↓ 17,265,360.0 17,265,360 1

Nested Loop (cost=616,917.23..5,369,514.12 rows=1 width=150) (actual time=40,692.761..7,305,274.965 rows=17,265,360 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id, plan_employeur_affilie.plan_employeur_affilie_id
  • Inner Unique: true
  • Buffers: shared hit=708,362,517 read=35,154,864 dirtied=91 written=38,355, temp read=195,966 written=196,516
31. 20,455.737 7,262,339.535 ↓ 17,265,360.0 17,265,360 1

Nested Loop (cost=616,916.95..5,369,510.10 rows=1 width=150) (actual time=40,692.733..7,262,339.535 rows=17,265,360 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.plan_employeur_affilie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.part_comm_dossier_id, sal_plan_partie.sal, tx_inva.tx_validite, tx_inva.part_comm_dossier_id
  • Buffers: shared hit=673,802,565 read=35,154,584 dirtied=91 written=38,355, temp read=195,966 written=196,516
32. 20,152.592 6,001,915.206 ↓ 17,221,786.0 17,221,786 1

Nested Loop (cost=616,916.38..5,368,668.75 rows=1 width=164) (actual time=40,687.574..6,001,915.206 rows=17,221,786 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen.plan_partie_id, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.plan_employeur_affilie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, cpt_epa_tot.plan_partie_id, part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id, tx_inva.tx_validite, tx_inva.plan_partie_id, tx_inva.part_comm_dossier_id
  • Join Filter: (coti_plan_part_comm.part_comm_dossier_id = tx_inva.part_comm_dossier_id)
  • Rows Removed by Join Filter: 6,345,315
  • Buffers: shared hit=588,584,169 read=31,394,468 dirtied=84 written=34,011, temp read=195,966 written=196,516
33. 17,747.056 5,632,270.256 ↓ 6,852,791.3 20,558,374 1

Nested Loop (cost=616,915.94..5,368,644.97 rows=3 width=152) (actual time=40,684.156..5,632,270.256 rows=20,558,374 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen.plan_partie_id, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.pa_gen_prest_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.plan_employeur_affilie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, cpt_epa_tot.plan_partie_id, part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id
  • Buffers: shared hit=508,808,567 read=28,738,940 dirtied=84 written=30,828, temp read=195,966 written=196,516
34. 17,961.645 4,113,761.898 ↓ 6,852,791.3 20,558,374 1

Nested Loop (cost=616,915.38..5,368,620.76 rows=3 width=140) (actual time=40,678.346..4,113,761.898 rows=20,558,374 loops=1)

  • Output: bi_couv.avant_apres_terme, bi_couv.tco_desc_courte, pa_gen.type_couv, pa_gen.pa_gen_id, pa_gen.plan_partie_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.plan_employeur_affilie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, cpt_epa_tot.plan_partie_id, part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id
  • Inner Unique: true
  • Buffers: shared hit=410,039,439 read=24,603,036 dirtied=83 written=26,027, temp read=195,966 written=196,516
35. 33,436.863 4,054,683.505 ↓ 6,852,791.3 20,558,374 1

Nested Loop (cost=616,915.10..5,368,599.21 rows=3 width=119) (actual time=40,678.321..4,054,683.505 rows=20,558,374 loops=1)

  • Output: bi_vcouv.cou_id, pa_gen.type_couv, pa_gen.pa_gen_id, pa_gen.plan_partie_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.plan_employeur_affilie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, cpt_epa_tot.plan_partie_id, part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id
  • Inner Unique: true
  • Buffers: shared hit=348,364,507 read=24,602,846 dirtied=83 written=26,027, temp read=195,966 written=196,516
36. 10,527.438 3,980,129.894 ↓ 6,852,791.3 20,558,374 1

Nested Loop (cost=616,914.82..5,368,576.06 rows=3 width=119) (actual time=40,676.064..3,980,129.894 rows=20,558,374 loops=1)

  • Output: pa_gen.type_couv, pa_gen.vco_id, pa_gen.pa_gen_id, pa_gen.plan_partie_id, plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.plan_employeur_affilie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, cpt_epa_tot.plan_partie_id, part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id
  • Buffers: shared hit=286,340,054 read=24,601,825 dirtied=83 written=26,027, temp read=195,966 written=196,516
37. 10,478.186 2,495,581.012 ↓ 2,867,746.0 2,867,746 1

Nested Loop (cost=616,914.25..5,367,153.30 rows=1 width=103) (actual time=40,672.662..2,495,581.012 rows=2,867,746 loops=1)

  • Output: plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.plan_employeur_affilie_id, plan_partie.partie_dossier_id, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_tot, cpt_epa_tot.plan_partie_id, part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id
  • Buffers: shared hit=275,430,108 read=20,372,403 dirtied=52 written=21,146, temp read=195,966 written=196,516
38. 0.000 50,488.475 ↓ 777,335.4 27,984,073 1

Gather (cost=616,913.69..4,988,240.21 rows=36 width=89) (actual time=40,654.914..50,488.475 rows=27,984,073 loops=1)

  • Output: plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.plan_employeur_affilie_id, plan_partie.partie_dossier_id, part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=120,970,084 read=12,316,549 dirtied=52 written=11,300, temp read=195,966 written=196,516
39. 4,152.020 312,409.907 ↓ 621,868.3 9,328,024 3 / 3

Nested Loop (cost=615,913.69..4,987,236.61 rows=15 width=89) (actual time=40,622.901..312,409.907 rows=9,328,024 loops=3)

  • Output: plan_partie.nom_plan, plan_partie.nom_comm, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.plan_partie_id, plan_partie.plan_employeur_affilie_id, plan_partie.partie_dossier_id, part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id
  • Inner Unique: true
  • Buffers: shared hit=120,970,084 read=12,316,549 dirtied=52 written=11,300, temp read=195,966 written=196,516
  • Worker 0: actual time=40,562.053..439643.180 rows=13,683,140 loops=1
  • Buffers: shared hit=59,106,046 read=5,505,762 dirtied=25 written=968, temp read=94,078 written=64,600
  • Worker 1: actual time=40,655.086..456896.886 rows=14,300,160 loops=1
  • Buffers: shared hit=61,860,489 read=5,667,244 dirtied=25 written=10,332, temp read=100,926 written=69,256
40. 11,610.104 48,881.311 ↓ 63,572.7 10,807,357 3 / 3

Parallel Hash Join (cost=615,913.25..4,985,890.30 rows=170 width=20) (actual time=40,615.299..48,881.311 rows=10,807,357 loops=3)

  • Output: part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id, coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id
  • Hash Cond: ((coti_plan_part_comm.plan_partie_id = part_comm_plan_partie.plan_partie_id) AND (coti_plan_part_comm.part_comm_dossier_id = part_comm_plan_partie.part_comm_dossier_id))
  • Buffers: shared hit=218 read=3,496,107 dirtied=37, temp read=195,966 written=196,516
  • Worker 0: actual time=40,542.679..52614.989 rows=15,849,309 loops=1
  • Buffers: shared hit=66 read=1,164,655 dirtied=20, temp read=94,078 written=64,600
  • Worker 1: actual time=40,652.554..53375.385 rows=16,571,808 loops=1
  • Buffers: shared hit=107 read=1,188,237 dirtied=15, temp read=100,926 written=69,256
41. 31,681.556 31,681.556 ↑ 1.3 10,809,114 3 / 3

Parallel Seq Scan on iliade.coti_plan_part_comm (cost=0.00..3,903,263.15 rows=13,565,342 width=12) (actual time=2.291..31,681.556 rows=10,809,114 loops=3)

  • Output: coti_plan_part_comm.coti_tot, coti_plan_part_comm.plan_partie_id, coti_plan_part_comm.part_comm_dossier_id
  • Filter: (((coti_plan_part_comm.type_part)::text = 'TOTA'::text) AND ((coti_plan_part_comm.type_mnt)::text = 'TOTA'::text))
  • Rows Removed by Filter: 32,281,991
  • Buffers: shared hit=29 read=3,095,019 dirtied=28
  • Worker 0: actual time=3.529..31761.647 rows=10,887,994 loops=1
  • Buffers: shared hit=17 read=1,039,082 dirtied=13
  • Worker 1: actual time=1.724..31616.356 rows=10,783,607 loops=1
  • Buffers: shared hit=12 read=1,029,243 dirtied=15
42. 2,025.788 5,589.651 ↑ 1.2 5,958,031 3 / 3

Parallel Hash (cost=475,471.90..475,471.90 rows=7,428,290 width=8) (actual time=5,589.651..5,589.651 rows=5,958,031 loops=3)

  • Output: part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id
  • Buckets: 524,288 Batches: 64 Memory Usage: 15,104kB
  • Buffers: shared hit=101 read=401,088 dirtied=9, temp written=60,580
  • Worker 0: actual time=5,579.169..5579.169 rows=5,597,505 loops=1
  • Buffers: shared hit=5 read=125,573 dirtied=7, temp written=18,956
  • Worker 1: actual time=5,590.675..5590.675 rows=7,102,131 loops=1
  • Buffers: shared hit=51 read=158,994, temp written=24,048
43. 3,563.863 3,563.863 ↑ 1.2 5,958,031 3 / 3

Parallel Seq Scan on iliade.part_comm_plan_partie (cost=0.00..475,471.90 rows=7,428,290 width=8) (actual time=0.038..3,563.863 rows=5,958,031 loops=3)

  • Output: part_comm_plan_partie.plan_partie_id, part_comm_plan_partie.part_comm_dossier_id
  • Buffers: shared hit=101 read=401,088 dirtied=9
  • Worker 0: actual time=0.044..3545.649 rows=5,597,505 loops=1
  • Buffers: shared hit=5 read=125,573 dirtied=7
  • Worker 1: actual time=0.047..3672.248 rows=7,102,131 loops=1
  • Buffers: shared hit=51 read=158,994
44. 259,376.576 259,376.576 ↑ 1.0 1 32,422,072 / 3

Index Scan using p_plan_partie on iliade.plan_partie (cost=0.43..7.92 rows=1 width=69) (actual time=0.024..0.024 rows=1 loops=32,422,072)

  • Output: plan_partie.plan_partie_id, plan_partie.partie_dossier_id, plan_partie.plan_employeur_affilie_id, plan_partie.plan_partie_orig_id, plan_partie.dossier_id, plan_partie.no_gen_dossier, plan_partie.plan_base_id, plan_partie.nom_plan, plan_partie.type_plan, plan_partie.type_prev_lpp, plan_partie.etat, plan_partie.deduc_1, plan_partie.deduc_2, plan_partie.mnt_capital_retraite, plan_partie.prct_capital_retraite, plan_partie.mnt_rte_retraite, plan_partie.prct_rte_retraite, plan_partie.corrections_manuelles, plan_partie.dte_effet, plan_partie.recalcul_prest_av_terme, plan_partie.figer_recalcul_prest_av_terme, plan_partie.propres_coti, plan_partie.int_propres_coti, plan_partie.propres_coti_prov, plan_partie.propres_coti_majorees, plan_partie.rachats, plan_partie.int_rachats, plan_partie.avoir_transfere, plan_partie.freq_paie_coti, plan_partie.surp_paie_frac_inclus, plan_partie.valorisable, plan_partie.dte_entree_theorique, plan_partie.dte_entree_av_va, plan_partie.dte_prevue_deb_inva, plan_partie.deduc_gar, plan_partie.deduc_gar_precedent, plan_partie.sal_cotisant_garanti, plan_partie.sal_cotisant_garanti_precedent, plan_partie.propres_coti_ord, plan_partie.propres_coti_maintien, plan_partie.part_suppltemp_rachats, plan_partie.rachats_sans_int, plan_partie.prest_sortie_gar_base, plan_partie.prop_coti_ord_prestsortgar, plan_partie.prop_coti_maint_prestsortgar, plan_partie.prop_coti_maj_prestsortgar, plan_partie.rachats_prestsortgar, plan_partie.vers_anticipes_prestsortgar, plan_partie.prct_capital_lpp_retraite, plan_partie.prest_payees, plan_partie.usr_log_i, plan_partie.dte_log_i, plan_partie.usr_log_u, plan_partie.dte_log_u, plan_partie.nom_comm, plan_partie.freq_paie_coti_fige, plan_partie.rachats_prevus, plan_partie.part_suppltemp_rachats_prevus, plan_partie.rachats_prevus_prestsortgar, plan_partie.corrections_manuelles_primes, plan_partie.corrections_manuelles_prest, plan_partie.remb_va_prevus, plan_partie.part_suppltemp_remb_va_prevus, plan_partie.remb_va_prevus_prestsortgar, plan_partie.mnt_max_deb_ajournement, plan_partie.remb_va_a_recevoir, plan_partie.audit, plan_partie.max_rachetable_31_12, plan_partie.sal_min_1, plan_partie.sal_min_2, plan_partie.sal_max_1, plan_partie.sal_max_2, plan_partie.duree_gar_sal_retraite, plan_partie.duree_gar_sal_risque, plan_partie.duree_gar_sal_sortie, plan_partie.capital_retraite, plan_partie.correction_ps_rappel, plan_partie.plan_calcul_avant_terme, plan_partie.deduc_3, plan_partie.deduc_4, plan_partie.sal_min_3, plan_partie.sal_min_4, plan_partie.sal_max_3, plan_partie.sal_max_4, plan_partie.prct_cpt_pref_retraite, plan_partie.prct_cpt_exc_lp, plan_partie.pref_retraite, plan_partie.int_pref_retraite, plan_partie.excedents_lp, plan_partie.int_excedents_lp, plan_partie.propres_cotisations_ordinaires_part_epargne, plan_partie.propres_cotisations_ordinaires_interets_part_epargne, plan_partie.propres_cotisations_ordinaires_provisoires_part_epargne, plan_partie.propres_cotisations_maintien_part_epargne, plan_partie.propres_cotisations_maintien_interets_part_epargne, plan_partie.propres_cotisations_maintien_provisoires_part_epargne, plan_partie.max_rachetable_31_12_sans_cpr, plan_partie.correction_ps_rappel_restauration_remb_va
  • Index Cond: (plan_partie.plan_partie_id = part_comm_plan_partie.plan_partie_id)
  • Filter: (((plan_partie.type_plan)::text <> 'MLPP'::text) AND ((plan_partie.etat)::text = 'VALI'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=120,969,866 read=8,820,442 dirtied=15 written=11,300
  • Worker 0: actual time=0.024..0.024 rows=1 loops=15,849,309
  • Buffers: shared hit=59,105,980 read=4,341,107 dirtied=5 written=968
  • Worker 1: actual time=0.024..0.024 rows=1 loops=16,571,808
  • Buffers: shared hit=61,860,382 read=4,479,007 dirtied=10 written=10,332
45. 2,259,399.411 2,434,614.351 ↓ 0.0 0 27,984,073

Index Scan using p_pi_in_cet_fk on iliade.cpt_epa_tot (cost=0.57..10,525.35 rows=1 width=14) (actual time=0.071..0.087 rows=0 loops=27,984,073)

  • Output: cpt_epa_tot.cpt_epa_tot_id, cpt_epa_tot.plan_partie_id, cpt_epa_tot.nat_cpt_epa_id, cpt_epa_tot.partie_dossier_id, cpt_epa_tot.dossier_id, cpt_epa_tot.no_gen_dossier, cpt_epa_tot.dte_tot, cpt_epa_tot.type_av_ap, cpt_epa_tot.mnt_lpp, cpt_epa_tot.mnt_supplementaire, cpt_epa_tot.mnt_tot, cpt_epa_tot.usr_log_i, cpt_epa_tot.dte_log_i, cpt_epa_tot.usr_log_u, cpt_epa_tot.dte_log_u, cpt_epa_tot.audit, cpt_epa_tot.mnt_supplementaire_bck, cpt_epa_tot.mnt_lpp_bck, cpt_epa_tot.mnt_tot_bck
  • Index Cond: (cpt_epa_tot.plan_partie_id = plan_partie.plan_partie_id)
  • Filter: (((cpt_epa_tot.type_av_ap)::text = 'APRE'::text) AND (((SubPlan 6))::text = 'Total'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=154,460,024 read=8,055,854 written=9,846
46.          

SubPlan (for Index Scan)

47. 35,042.988 175,214.940 ↑ 1.0 1 11,680,996

Nested Loop (cost=0.28..10.26 rows=1 width=16) (actual time=0.013..0.015 rows=1 loops=11,680,996)

  • Output: bic_1.texte
  • Inner Unique: true
  • Buffers: shared hit=46,763,257 read=5
48. 46,723.984 46,723.984 ↑ 1.0 1 11,680,996

Seq Scan on produit.nature_cpt_epa nce (cost=0.00..1.66 rows=1 width=4) (actual time=0.002..0.004 rows=1 loops=11,680,996)

  • Output: nce.nature_cpt_epa_id, nce.nature, nce.porte_int, nce.jour_deb_calcul_int, nce.usr_log_i, nce.dte_log_i, nce.usr_log_u, nce.dte_log_u, nce.nature_3ep
  • Filter: (cpt_epa_tot.nat_cpt_epa_id = nce.nature_cpt_epa_id)
  • Rows Removed by Filter: 52
  • Buffers: shared hit=11,680,996
49. 93,447.968 93,447.968 ↑ 1.0 1 11,680,996

Index Scan using idx_bi_code_cde_lan_type_cle on biinfra.bi_code bic_1 (cost=0.28..8.30 rows=1 width=22) (actual time=0.008..0.008 rows=1 loops=11,680,996)

  • Output: bic_1.dl_dte_load, bic_1.dl_flg_src_deleted, bic_1.code_type, bic_1.code_cle, bic_1.texte, bic_1.cde_lan
  • Index Cond: (((bic_1.cde_lan)::text = 'FR'::text) AND ((bic_1.code_type)::text = 'TypeNatureCompteEpargne'::text) AND ((bic_1.code_cle)::text = (nce.nature)::text))
  • Buffers: shared hit=35,082,261 read=5
50. 1,474,021.444 1,474,021.444 ↑ 45.0 7 2,867,746

Index Scan using p_pi_in_pag_fk on iliade.pa_gen (cost=0.57..1,419.61 rows=315 width=16) (actual time=0.430..0.514 rows=7 loops=2,867,746)

  • Output: pa_gen.pa_gen_id, pa_gen.assure_part_dossier_id, pa_gen.vco_id, pa_gen.plan_partie_id, pa_gen.pa_gen_orig_id, pa_gen.pa_gen_base_prest_id, pa_gen.pa_gen_base_coti_id, pa_gen.pa_gen_base_plan_base_prest_id, pa_gen.pa_gen_base_plan_base_coti_id, pa_gen.partie_dossier_id, pa_gen.dossier_id, pa_gen.no_gen_dossier, pa_gen.type_couv, pa_gen.etat, pa_gen.dte_effet, pa_gen.dte_echeance, pa_gen.dte_effet_pe, pa_gen.dte_effet_idx, pa_gen.dte_base_calc, pa_gen.dte_fin_differe, pa_gen.dte_deb_inca_gain, pa_gen.age_deb_inca_gain, pa_gen.delai_attente, pa_gen.capital_rte, pa_gen.doublement_rte_enfant, pa_gen.freq_paie_rte, pa_gen.sal, pa_gen.classe_risque, pa_gen.tx_prest_base, pa_gen.usr_log_i, pa_gen.dte_log_i, pa_gen.usr_log_u, pa_gen.dte_log_u, pa_gen.dte_derniere_idx_liee_avs, pa_gen.numero_ub_refact_base, pa_gen.numero_ub_refact_idx, pa_gen.audit, pa_gen.type_fina_avance_avs, pa_gen.prct_avance_avs, pa_gen.type_numerando, pa_gen.vco_precedente_id, pa_gen.delai_lib, pa_gen.categorie_empl_secteur_act_id
  • Index Cond: (pa_gen.plan_partie_id = plan_partie.plan_partie_id)
  • Filter: (((pa_gen.etat)::text = 'VAL'::text) AND ((pa_gen.type_couv)::text = ANY ('{EPGN,DCON,RCON,REIN,RERT,RIG,RORF,RTRE}'::text[])))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=10,909,946 read=4,229,422 dirtied=31 written=4,881
51. 41,116.748 41,116.748 ↑ 1.0 1 20,558,374

Index Scan using bi_vcouv_pkey on biinfra.bi_vcouv (cost=0.28..7.72 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=20,558,374)

  • Output: bi_vcouv.vco_id, bi_vcouv.vco_no_vari, bi_vcouv.tde1x_nom_table, bi_vcouv.tde1y_nom_table, bi_vcouv.tde2x_nom_table, bi_vcouv.tde2y_nom_table, bi_vcouv.tin1x_nom_table, bi_vcouv.tin1y_nom_table, bi_vcouv.tin_p1x_nom_table, bi_vcouv.tin_p1y_nom_table, bi_vcouv.tma1x_nom_table, bi_vcouv.tma1y_nom_table, bi_vcouv.tca_d1x_nom_table, bi_vcouv.tca_d1y_nom_table, bi_vcouv.tca_i1x_nom_table, bi_vcouv.tca_i1y_nom_table, bi_vcouv.tcc_id, bi_vcouv.vco_dte_deb, bi_vcouv.vco_dte_fin, bi_vcouv.tx_interet_tec, bi_vcouv.alpha1, bi_vcouv.alpha2, bi_vcouv.alpha3, bi_vcouv.beta, bi_vcouv.gamma1, bi_vcouv.gamma2, bi_vcouv.sigma, bi_vcouv.cste1, bi_vcouv.cste2, bi_vcouv.cste_pri_pure, bi_vcouv.penalite_rachat, bi_vcouv.maj_prest, bi_vcouv.use_table_maj, bi_vcouv.duree_red_paie_pri, bi_vcouv.fo_vap, bi_vcouv.fo_vas, bi_vcouv.fo_alpha, bi_vcouv.fo_age_a1_n_aff, bi_vcouv.fo_age_a2_n_aff, bi_vcouv.fo_age_couple_n_aff, bi_vcouv.fo_age_a1_tran, bi_vcouv.fo_age_a2_tran, bi_vcouv.fo_age_couple_tran, bi_vcouv.fo_age_a1_val, bi_vcouv.fo_age_a2_val, bi_vcouv.fo_age_couple_val, bi_vcouv.fo_rachat, bi_vcouv.fo_pri, bi_vcouv.fo_duree_restit, bi_vcouv.fo_interpol, bi_vcouv.fo_deces, bi_vcouv.fo_invalidite, bi_vcouv.fo_echeance, bi_vcouv.fo_prest_subord, bi_vcouv.fo_reserve, bi_vcouv.fo_som_risq_deces_int, bi_vcouv.fo_som_risq_invalid_int, bi_vcouv.fo_som_risq_deces_reass, bi_vcouv.fo_som_risq_invalidite_reass, bi_vcouv.fo_pe1, bi_vcouv.fo_pe2, bi_vcouv.fo_ajournement, bi_vcouv.fo_fin_paiement, bi_vcouv.fo_pri_pure, bi_vcouv.fo_bonus_calcul, bi_vcouv.fo_report_prime, bi_vcouv.fo_report_prest, bi_vcouv.fo_zillmer, bi_vcouv.fo_alpha_zillmer, bi_vcouv.fo_prestation_minimale, bi_vcouv.fo_prestation_pe, bi_vcouv.duree_garantie_differe, bi_vcouv.age_terme_indexation, bi_vcouv.type_calcul_indexation, bi_vcouv.fo_age_terme_indexation, bi_vcouv.fo_somme_risquee, bi_vcouv.fo_va, bi_vcouv.fo_rente_en_capital, bi_vcouv.fo_prest_compretravan, bi_vcouv.fo_capital_compretravan, bi_vcouv.prest_a_facturer, bi_vcouv.tarif_classe_risque, bi_vcouv.type_var_cou, bi_vcouv.vco_standard_id, bi_vcouv.fo_val_residuelle, bi_vcouv.fo_rachat_fiscal, bi_vcouv.fo_capital_fin_differe, bi_vcouv.fo_valeur_fonds_placement, bi_vcouv.alpha4, bi_vcouv.cou_id, bi_vcouv.soc_id, bi_vcouv.act_nom_cta, bi_vcouv.cta_id, bi_vcouv.cta_nom_fr, bi_vcouv.pec_id, bi_vcouv.pec_nom, bi_vcouv.pcc_id, bi_vcouv.pcc_dte_deb, bi_vcouv.pcc_dte_fin, bi_vcouv.pcc_nom, bi_vcouv.pcc_delai_car1, bi_vcouv.pcc_delai_car2
  • Index Cond: (bi_vcouv.vco_id = pa_gen.vco_id)
  • Buffers: shared hit=62,024,453 read=1,021
52. 41,116.748 41,116.748 ↑ 1.0 1 20,558,374

Index Scan using bi_couv_pkey on biinfra.bi_couv (cost=0.28..7.18 rows=1 width=29) (actual time=0.002..0.002 rows=1 loops=20,558,374)

  • Output: bi_couv.cou_id, bi_couv.soc_id, bi_couv.desc_courte, bi_couv.type_calc_pri, bi_couv.type_calc_prest, bi_couv.type_pror_fina_rte, bi_couv.type_pror_init_rte, bi_couv.type_pri, bi_couv.type_int, bi_couv.type_echeance_prest, bi_couv.arrondi_pri, bi_couv.arrondi_prest, bi_couv.arrondi_res, bi_couv.soumis_drt_timbre, bi_couv.type_prestation, bi_couv.fo_remplissage_date, bi_couv.fo_remplissage_date_age, bi_couv.type_mal_acc, bi_couv.ged_definition1, bi_couv.ged_definition2, bi_couv.type_prest_2p, bi_couv.avant_apres_terme, bi_couv.inclus_suri, bi_couv.type_rte_conjoint, bi_couv.type_arrondi_prest, bi_couv.nombre_tetes, bi_couv.ordre_tri, bi_couv.col_nom_couv_fr, bi_couv.col_nom_pour_gest_fr, bi_couv.col_desc_longue_fr, bi_couv.col_nom_commercial_fr, bi_couv.act_nom_couv, bi_couv.act_nom_type_couv, bi_couv.act_nom_cat_couv, bi_couv.type_nat_type_couv, bi_couv.tco_desc_courte, bi_couv.tco_type_sal, bi_couv.tco_type_risque, bi_couv.tco_ctrl_min_lpp, bi_couv.tco_regroupement_envoi_prestations, bi_couv.tco_rente_en_cours, bi_couv.tco_complement_avs, bi_couv.tco_prest_compl, bi_couv.tco_tri_couv_avant_terme, bi_couv.tco_tri_couv_apres_terme, bi_couv.tcl_desc_longue, bi_couv.ccc_cca_dte_deb, bi_couv.ccc_cca_dte_fin, bi_couv.cca_id, bi_couv.cca_ref_cca, bi_couv.cca_description, bi_couv.cca_doc_url, bi_couv.ccl_nom_commercial_cca_fr, bi_couv.ccl_doc_name_cca_fr, bi_couv.ges_flg_couv_deces, bi_couv.ges_flg_couv_epargne, bi_couv.ges_flg_couv_rig, bi_couv.ges_flg_couv_liberation
  • Index Cond: (bi_couv.cou_id = bi_vcouv.cou_id)
  • Buffers: shared hit=61,674,932 read=190
53. 1,500,761.302 1,500,761.302 ↑ 1.0 1 20,558,374

Index Scan using idx4fk_f_pag_in_pagprest on iliade.pa_gen_prest (cost=0.57..8.06 rows=1 width=20) (actual time=0.073..0.073 rows=1 loops=20,558,374)

  • Output: pa_gen_prest.pa_gen_prest_id, pa_gen_prest.pa_gen_id, pa_gen_prest.dossier_id, pa_gen_prest.no_gen_dossier, pa_gen_prest.corrections_manuelles, pa_gen_prest.prest_reglementaire, pa_gen_prest.prest_base, pa_gen_prest.supplement_lpp, pa_gen_prest.prest_tot, pa_gen_prest.avoir_31_12, pa_gen_prest.prest_projetee_avec_int, pa_gen_prest.prest_projetee_sans_int, pa_gen_prest.idx, pa_gen_prest.participation_excedents, pa_gen_prest.reduc_base, pa_gen_prest.reduc_supplement_lpp, pa_gen_prest.reduc_idx, pa_gen_prest.reduc_participation_excedents, pa_gen_prest.supplement_propres_coti, pa_gen_prest.prest_due, pa_gen_prest.prest_reversee_par_reass, pa_gen_prest.allocation_menage, pa_gen_prest.supplement_droits_acquis, pa_gen_prest.compens_retraite_avancee, pa_gen_prest.idx_employeur_fine_capi, pa_gen_prest.idx_employeur_fine_perio, pa_gen_prest.supplement_prest_sortie_gar, pa_gen_prest.reduc_allocation_menage, pa_gen_prest.reduc_idx_employeur_fine_capi, pa_gen_prest.reduc_idx_employeur_fine_perio, pa_gen_prest.reduc_supplement_droits_acquis, pa_gen_prest.usr_log_i, pa_gen_prest.dte_log_i, pa_gen_prest.usr_log_u, pa_gen_prest.dte_log_u, pa_gen_prest.audit, pa_gen_prest.complement_fine_employeur, pa_gen_prest.reduc_compl_fine_employeur, pa_gen_prest.reduc_compens_retraite_avancee, pa_gen_prest.prest_gar, pa_gen_prest.supplement_garanti, pa_gen_prest.reduc_supplement_garanti, pa_gen_prest.reduc_divorce, pa_gen_prest.compl_exc_libre_passage
  • Index Cond: (pa_gen_prest.pa_gen_id = pa_gen.pa_gen_id)
  • Buffers: shared hit=98,769,128 read=4,135,904 dirtied=1 written=4,801
54. 349,492.358 349,492.358 ↑ 1.0 1 20,558,374

Index Scan using p_pi_in_tx_inva_fk on iliade.tx_inva (cost=0.43..7.91 rows=1 width=12) (actual time=0.017..0.017 rows=1 loops=20,558,374)

  • Output: tx_inva.tx_inva_id, tx_inva.part_comm_dossier_id, tx_inva.plan_partie_id, tx_inva.nom_plan, tx_inva.dossier_id, tx_inva.no_gen_dossier, tx_inva.tx_inva_initial, tx_inva.tx_inva_reel, tx_inva.tx_inva_calc, tx_inva.tx_inva_fige, tx_inva.tx_validite, tx_inva.usr_log_i, tx_inva.dte_log_i, tx_inva.usr_log_u, tx_inva.dte_log_u, tx_inva.nom_comm, tx_inva.audit
  • Index Cond: (tx_inva.plan_partie_id = plan_partie.plan_partie_id)
  • Buffers: shared hit=79,775,602 read=2,655,528 written=3,183
55. 1,239,968.592 1,239,968.592 ↑ 31.0 1 17,221,786

Index Scan using p_pi_in_sal_fk on iliade.sal_plan_partie (cost=0.57..841.04 rows=31 width=10) (actual time=0.067..0.072 rows=1 loops=17,221,786)

  • Output: sal_plan_partie.sal_plan_partie_id, sal_plan_partie.plan_partie_id, sal_plan_partie.partie_dossier_id, sal_plan_partie.dossier_id, sal_plan_partie.no_gen_dossier, sal_plan_partie.type_sal, sal_plan_partie.fige, sal_plan_partie.sal, sal_plan_partie.usr_log_i, sal_plan_partie.dte_log_i, sal_plan_partie.usr_log_u, sal_plan_partie.dte_log_u, sal_plan_partie.audit
  • Index Cond: (sal_plan_partie.plan_partie_id = plan_partie.plan_partie_id)
  • Filter: ((sal_plan_partie.type_sal)::text = 'PRRE'::text)
  • Rows Removed by Filter: 7
  • Buffers: shared hit=85,218,396 read=3,760,116 dirtied=7 written=4,344
56. 34,530.720 34,530.720 ↑ 1.0 1 17,265,360

Index Only Scan using p_plan_empl_affil on iliade.plan_employeur_affilie (cost=0.29..4.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=17,265,360)

  • Output: plan_employeur_affilie.plan_employeur_affilie_id
  • Index Cond: (plan_employeur_affilie.plan_employeur_affilie_id = plan_partie.plan_employeur_affilie_id)
  • Heap Fetches: 0
  • Buffers: shared hit=34,559,952 read=280
57. 155,388.240 155,388.240 ↑ 1.0 1 17,265,360

Index Scan using p_partie_dossier on iliade.partie_dossier (cost=0.43..7.91 rows=1 width=12) (actual time=0.009..0.009 rows=1 loops=17,265,360)

  • Output: partie_dossier.partie_dossier_id, partie_dossier.partie_liee_partie_dossier_id, partie_dossier.dossier_gen_id, partie_dossier.partie_dossier_orig_id, partie_dossier.dossier_id, partie_dossier.no_gen_dossier, partie_dossier.etat, partie_dossier.type_partie, partie_dossier.type_deces, partie_dossier.dte_deb_partie, partie_dossier.dte_effet_idx, partie_dossier.avoir_50_ans, partie_dossier.type_inva, partie_dossier.dte_deb_inca_gain, partie_dossier.age_deb_inca_gain, partie_dossier.dte_fin_inca_gain, partie_dossier.dte_reexamen, partie_dossier.tx_inca_gain_reel, partie_dossier.tx_inca_gain_calc, partie_dossier.lib_passee, partie_dossier.inva_passee, partie_dossier.rechute, partie_dossier.dte_rechute, partie_dossier.faute_grave, partie_dossier.tx_reduc_faute_grave, partie_dossier.reticence, partie_dossier.accident, partie_dossier.cause_medicale_sinistre, partie_dossier.cause_risque_special_sinistre, partie_dossier.sal_actif_reparti, partie_dossier.delai_attente_lib_consomme, partie_dossier.delai_attente_ri_consomme, partie_dossier.dte_age_terme, partie_dossier.dte_deb_mise_en_pension, partie_dossier.tx_retraite, partie_dossier.suri_avec_pe, partie_dossier.suri_avec_idx, partie_dossier.dte_revision_ai, partie_dossier.dte_revision_caisse_pension, partie_dossier.tx_sal_suri, partie_dossier.tot_rev_recu, partie_dossier.reprise_ancienne_ip, partie_dossier.deb_paie_effectif, partie_dossier.sal_presume_perdu, partie_dossier.usr_log_i, partie_dossier.dte_log_i, partie_dossier.usr_log_u, partie_dossier.dte_log_u, partie_dossier.audit, partie_dossier.dte_echeance_partie, partie_dossier.calc_av_terme, partie_dossier.mnt_cpt_droits_transitoires, partie_dossier.int_cpt_droits_transitoires, partie_dossier.somme_risquee_reass_deces, partie_dossier.somme_risquee_reass_inva, partie_dossier.annonce_reass_deces, partie_dossier.annonce_reass_inva, partie_dossier.annonce_reass_deces_facultatif, partie_dossier.annonce_reass_inva_facultatif, partie_dossier.annonce_reass_deces_sinistre, partie_dossier.annonce_reass_inva_sinistre, partie_dossier.reass_deces, partie_dossier.reass_inva, partie_dossier.inva_proportion_reassuree, partie_dossier.fo_reass_id, partie_dossier.avoir_50_ans_lpp, partie_dossier.annonce_deces, partie_dossier.annonce_invalidite
  • Index Cond: (partie_dossier.partie_dossier_id = plan_partie.partie_dossier_id)
  • Filter: ((partie_dossier.type_partie)::text = 'ACTI'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=67,185,466 read=1,926,489 dirtied=3 written=2,298
58. 276,746.366 276,746.366 ↑ 1.0 1 16,279,198

Index Scan using p_dossier_gen on iliade.dossier_gen (cost=0.43..7.91 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=16,279,198)

  • Output: dossier_gen.dossier_gen_id, dossier_gen.mut_dossier_id, dossier_gen.somme_tx_validite_inva, dossier_gen.vers_anticipe_effectue, dossier_gen.dossier_id, dossier_gen.no_gen_dossier, dossier_gen.confidentiel, dossier_gen.code_voir_dossier, dossier_gen.impots_source, dossier_gen.avoir_50_ans, dossier_gen.retour_avoir_min_lpp, dossier_gen.int_retour_avoir_min_lpp, dossier_gen.retour_avoir_evlp, dossier_gen.int_retour_avoir_evlp, dossier_gen.restitution_avoir_min_lpp, dossier_gen.int_restitution_avoir_min_lpp, dossier_gen.restitution_avoir_evlp, dossier_gen.int_restitution_avoir_evlp, dossier_gen.beneficiaires_deces, dossier_gen.donnees_medicales_introduites, dossier_gen.refus_medical, dossier_gen.non_reponse_etat_sante, dossier_gen.suivi_medical, dossier_gen.dte_suivi_medical, dossier_gen.surprimes, dossier_gen.reserves, dossier_gen.inva, dossier_gen.tot_rev_paye, dossier_gen.dte_calc_avoir, dossier_gen.dte_precedent_calc_avoir, dossier_gen.dte_derniere_idx, dossier_gen.dte_prochaine_annualisation, dossier_gen.dte_prochain_bouclement, dossier_gen.dte_prochain_recalcul, dossier_gen.prise_cpt_causes_reduc, dossier_gen.dte_retraite, dossier_gen.trtmt_partie_active_retraite, dossier_gen.dte_deces_reel, dossier_gen.dte_demission, dossier_gen.freq_paie_rentes, dossier_gen.capital_inva, dossier_gen.tx_inva_externe, dossier_gen.cause_fin_inva, dossier_gen.vers_anticipe_en_cours, dossier_gen.dte_demande_vers_anticipe, dossier_gen.dte_der_vers_anticipe, dossier_gen.raison_vers_anticipe, dossier_gen.remb_tot_der_vers_anticipe, dossier_gen.remb_tot_ensbl_vers_anticipes, dossier_gen.div_en_cours, dossier_gen.inscription_registre_foncier, dossier_gen.mise_en_gage, dossier_gen.jamais_affilie, dossier_gen.dte_premiere_affiliation, dossier_gen.dte_demande_avance_avs, dossier_gen.avance_avs, dossier_gen.dte_fin_avance_avs, dossier_gen.mnt_avance_avs, dossier_gen.ajournement, dossier_gen.dte_fin_ajournement, dossier_gen.maintien_fina_ajournement, dossier_gen.ajournement_annee_en_annee, dossier_gen.dte_prochain_ajournement, dossier_gen.age_premier_ajournement, dossier_gen.calc_av_terme, dossier_gen.conge, dossier_gen.demande_affiliation_recue, dossier_gen.suri, dossier_gen.dte_der_ctrl_suri, dossier_gen.regles_avert_outrepassees, dossier_gen.adresse_paie_connue, dossier_gen.somme_risquee_reass_deces, dossier_gen.somme_risquee_reass_inva, dossier_gen.annonce_reass_deces, dossier_gen.annonce_reass_inva, dossier_gen.duree_cip_illimitee, dossier_gen.dte_entree_actuarielle, dossier_gen.dte_entree_av_conversion, dossier_gen.dte_deb_conge, dossier_gen.dte_deb_conge_effectif, dossier_gen.dte_retour_conge, dossier_gen.dte_retour_conge_effectif, dossier_gen.conge_administratif, dossier_gen.duree_conges_non_rachetes, dossier_gen.mnt_rachat_excd, dossier_gen.dte_rachat_excd, dossier_gen.dte_echeance_rachat_excd, dossier_gen.dte_fin_fine_entree, dossier_gen.sal_inferieur_min_lpp, dossier_gen.calc_prest_sortie_gar, dossier_gen.dte_demande_retraite_capital, dossier_gen.dte_ren_retraite_capital, dossier_gen.dte_ren_avance_avs, dossier_gen.type_compens, dossier_gen.dte_retraite_compensee, dossier_gen.capital_compens_retraite, dossier_gen.capital_compens_suppltemp, dossier_gen.paie_autr_beneficiaires_deces, dossier_gen.suppltemp_avs, dossier_gen.majo_suppltemp_avs, dossier_gen.dte_fin_suppltemp_avs, dossier_gen.dte_fin_majo_suppltemp_avs, dossier_gen.dte_calc_situation_ass, dossier_gen.cause_refus_medical, dossier_gen.majo_tx_pension, dossier_gen.no_gen_dossier_situation_ass, dossier_gen.numero_dossier_etat, dossier_gen.usr_log_i, dossier_gen.dte_log_i, dossier_gen.usr_log_u, dossier_gen.dte_log_u, dossier_gen.cause_changement_employeur, dossier_gen.age_terme_vise, dossier_gen.code_urev_urcip, dossier_gen.pas_pu_se_prononcer, dossier_gen.prest_sortie_en_especes, dossier_gen.gest_reservee, dossier_gen.reass_deces, dossier_gen.reass_inva, dossier_gen.inva_proportion_reassuree, dossier_gen.annonce_reass_deces_facultatif, dossier_gen.annonce_reass_inva_facultatif, dossier_gen.annonce_reass_deces_sinistre, dossier_gen.annonce_reass_inva_sinistre, dossier_gen.prct_avance_avs, dossier_gen.remb_avance_avs_prime_unique, dossier_gen.paie_remb_avance_avs_effectue, dossier_gen.frais_gest_demission, dossier_gen.audit, dossier_gen.suivi_demande_affiliation, dossier_gen.dte_suivi_demande_affiliation, dossier_gen.stipulation_beneficiaire, dossier_gen.mois_demission_paye, dossier_gen.pleine_capacite_travail, dossier_gen.beneficiaire_rte_ai, dossier_gen.dte_deb_inva_reconnue_ai, dossier_gen.envoi_doc_affiliation, dossier_gen.adresse_paie, dossier_gen.dte_calc_deroulement, dossier_gen.dte_fina_plus_maintenu, dossier_gen.donnees_retraite_annoncees, dossier_gen.mnt_rachat_deg_pos, dossier_gen.suivi_retraite, dossier_gen.dte_prochain_suivi_retraite, dossier_gen.quest_retraite_employeur_recu, dossier_gen.migration_hermes, dossier_gen.motif_paiement, dossier_gen.avoir_50_ans_lpp, dossier_gen.dossier_cible_id, dossier_gen.transfert_dossier_possible, dossier_gen.transfert_plan_minimum
  • Index Cond: (dossier_gen.dossier_gen_id = partie_dossier.dossier_gen_id)
  • Buffers: shared hit=63,156,035 read=2,004,990 written=2,432
59. 149,209.795 325,583.960 ↓ 0.0 0 16,279,198

Index Scan using p_mut_dossier on iliade.mut_dossier (cost=0.43..12.79 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=16,279,198)

  • Output: mut_dossier.mut_dossier_id, mut_dossier.dossier_id
  • Index Cond: (mut_dossier.mut_dossier_id = dossier_gen.mut_dossier_id)
  • Filter: (((mut_dossier.statut)::text = ANY ('{MIXT,ACTI,ATTE}'::text[])) AND (mut_dossier.no_gen_dossier = (SubPlan 3)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=142,360,265 read=2,890,626 written=3,959
60.          

SubPlan (for Index Scan)

61. 0.000 176,374.165 ↑ 1.0 1 16,034,015

Result (cost=4.87..4.88 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=16,034,015)

  • Output: $2
  • Buffers: shared hit=78,885,357 read=1,160,449 written=1,718
62.          

Initplan (for Result)

63. 16,034.015 176,374.165 ↑ 1.0 1 16,034,015

Limit (cost=0.43..4.87 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=16,034,015)

  • Output: a.no_gen_dossier
  • Buffers: shared hit=78,885,357 read=1,160,449 written=1,718
64. 160,340.150 160,340.150 ↑ 28.0 1 16,034,015

Index Scan Backward using olm_perf_i_2020_02097_1 on iliade.mut_dossier a (cost=0.43..124.57 rows=28 width=4) (actual time=0.010..0.010 rows=1 loops=16,034,015)

  • Output: a.no_gen_dossier
  • Index Cond: ((mut_dossier.dossier_id = a.dossier_id) AND (a.no_gen_dossier IS NOT NULL) AND ((a.etat)::text = 'VALI'::text))
  • Filter: (a.dte_mut <= '2019-12-31'::date)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=78,885,357 read=1,160,449 written=1,718
65. 7,744.180 7,744.180 ↑ 1.0 1 387,209

Index Scan using p_dossier on iliade.dossier (cost=0.42..7.90 rows=1 width=12) (actual time=0.020..0.020 rows=1 loops=387,209)

  • Output: dossier.dossier_id, dossier.contrat_id, dossier.dossier_parent_id, dossier.pro_id, dossier.numero_dossier, dossier.dte_affiliation, dossier.mnt_epa_tot, dossier.mnt_epa_min_lpp, dossier.dte_blocage_fact, dossier.raison_blocage_fact, dossier.visa_blocage_fact, dossier.dte_operation_blocage_fact, dossier.envoi_quest_mise_pension, dossier.objet_facturable_cree, dossier.deposant_epa, dossier.usr_log_i, dossier.dte_log_i, dossier.usr_log_u, dossier.dte_log_u, dossier.audit, dossier.blocage_extranet, dossier.responsable_gest, dossier.responsable_gest_medicale, dossier.id_mut_blocage_fact, dossier.raison_blocage_mutations, dossier.visa_blocage_mutations, dossier.blocage_mutations, dossier.dte_blocage_mutations, dossier.business_warning, dossier.sexe_affilie, dossier.dte_naissance_affilie
  • Index Cond: (dossier.dossier_id = mut_dossier.dossier_id)
  • Buffers: shared hit=1,487,283 read=62,471 written=12
66. 28.756 28.756 ↑ 1.0 1 1,106

Index Scan using bi_prod_pkey on biinfra.bi_prod (cost=0.14..8.16 rows=1 width=8) (actual time=0.026..0.026 rows=1 loops=1,106)

  • Output: bi_prod.pro_id, bi_prod.fam_id, bi_prod.soc_id, bi_prod.pro_dte_deb_app, bi_prod.pro_dte_fin_app, bi_prod.pro_desc_courte, bi_prod.pro_default_nbr_bvr, bi_prod.pro_ged_definition1, bi_prod.pro_ged_definition2, bi_prod.pro_dernier_num_police_utilise, bi_prod.pro_type_prod, bi_prod.pro_ged_type_caisse, bi_prod.prl_nom_prod_fr, bi_prod.prl_desc_longue_fr, bi_prod.prl_desc_portail_fr, bi_prod.prl_ged_definition_fiscale_fr, bi_prod.act_nom_prod, bi_prod.act_regr_prod, bi_prod.pvi_type_prev, bi_prod.pvi_type_dte_annual, bi_prod.pvi_type_libe_pri, bi_prod.pvi_type_versement_add, bi_prod.pvi_seuil_red, bi_prod.pvi_seuil_paiement, bi_prod.pvi_droit_pe_redu, bi_prod.pvi_plan_repart, bi_prod.pvi_fo_agregation, bi_prod.pvi_arrondi_pu, bi_prod.pvi_arrondi_pp, bi_prod.pvi_periodicite_prelevement, bi_prod.pvi_periodicite_rebalancement, bi_prod.pvi_arrondi_fonds_parts, bi_prod.pvi_arrondi_fonds_montants, bi_prod.pvi_pe_couv_id, bi_prod.pvi_type_interpolation, bi_prod.pvi_montant_limite_versement, bi_prod.pvi_montant_limite_versement_add, bi_prod.pvi_fam_prod_informatique, bi_prod.pvi_rachetable, bi_prod.pvi_liber_assure1_obli, bi_prod.pvi_surprime_exploitant, bi_prod.pvi_categorie_prod, bi_prod.pvi_proj_plusieurs_tx, bi_prod.pvi_type_pro, bi_prod.pvi_parametrage_capital_reserve, bi_prod.pvi_anti_selection_rachat, bi_prod.pvi_pe_prest_reduction, bi_prod.pvi_parametrage_capital_ddecr, bi_prod.pvi_option_capital_rente_deces, bi_prod.pvi_type_pe_apres_differe, bi_prod.pvi_frais_gestion_min_max, bi_prod.pvl_benef_deces_fr, bi_prod.pvl_benef_vie_fr, bi_prod.pvl_preneur_success_fr, bi_prod.pvl_benef_deces_2t_fr, bi_prod.pvl_benef_vie_2t_fr, bi_prod.ges_type_prod_desc, bi_prod.ges_groupe_produit
  • Index Cond: (bi_prod.pro_id = contrat.pro_id)
  • Filter: (bi_prod.soc_id = 3)
  • Buffers: shared hit=2,160 read=52
67. 43.134 43.134 ↑ 1.0 1 1,106

Seq Scan on biinfra.bi_soc (cost=0.00..1.09 rows=1 width=4) (actual time=0.038..0.039 rows=1 loops=1,106)

  • Output: bi_soc.soc_id, bi_soc.soc_desc_courte, bi_soc.sol_nom_soc_fr, bi_soc.sol_nom_soc_ged_fr, bi_soc.sol_sign_soc_fr, bi_soc.sol_desc_voies_recours_fr
  • Filter: (bi_soc.soc_id = 3)
  • Rows Removed by Filter: 6
  • Buffers: shared hit=1,053 read=53
68. 66.360 66.360 ↑ 1.0 1 1,106

Index Scan using p_part on iliade.part a1_part_ili_cont_empl (cost=0.42..7.90 rows=1 width=8) (actual time=0.060..0.060 rows=1 loops=1,106)

  • Output: a1_part_ili_cont_empl.part_id, a1_part_ili_cont_empl.type_part, a1_part_ili_cont_empl.nom_ou_raison_sociale, a1_part_ili_cont_empl.nom_complementaire, a1_part_ili_cont_empl.nom_alliance, a1_part_ili_cont_empl.prenom, a1_part_ili_cont_empl.dte_naissance, a1_part_ili_cont_empl.dte_deces, a1_part_ili_cont_empl.sexe, a1_part_ili_cont_empl.etat_civil, a1_part_ili_cont_empl.no_avs, a1_part_ili_cont_empl.langue_correspondance, a1_part_ili_cont_empl.usr_log_i, a1_part_ili_cont_empl.dte_log_i, a1_part_ili_cont_empl.usr_log_u, a1_part_ili_cont_empl.dte_log_u, a1_part_ili_cont_empl.audit, a1_part_ili_cont_empl.visa, a1_part_ili_cont_empl.numero_contact
  • Index Cond: (a1_part_ili_cont_empl.part_id = a1_part_contrat_ili_empl.part_id)
  • Buffers: shared hit=4,295 read=129
69. 84.056 84.056 ↑ 1.0 1 1,106

Index Scan using bi_partenaire_uk1 on biinfra.bi_partenaire a1_bi_partenaire_ili_cont_empl (cost=0.42..7.90 rows=1 width=21) (actual time=0.076..0.076 rows=1 loops=1,106)

  • Output: a1_bi_partenaire_ili_cont_empl.contact_id, a1_bi_partenaire_ili_cont_empl.numero_contact, a1_bi_partenaire_ili_cont_empl.partenaire_id, a1_bi_partenaire_ili_cont_empl.prenom, a1_bi_partenaire_ili_cont_empl.nom_raison_sociale, a1_bi_partenaire_ili_cont_empl.complement_raison_sociale, a1_bi_partenaire_ili_cont_empl.flg_personne_physique, a1_bi_partenaire_ili_cont_empl.flg_collaborateur, a1_bi_partenaire_ili_cont_empl.date_naissance, a1_bi_partenaire_ili_cont_empl.titre_civil, a1_bi_partenaire_ili_cont_empl.date_deces, a1_bi_partenaire_ili_cont_empl.etat_civil, a1_bi_partenaire_ili_cont_empl.numero_avs_upi, a1_bi_partenaire_ili_cont_empl.sexe, a1_bi_partenaire_ili_cont_empl.curatelle, a1_bi_partenaire_ili_cont_empl.statut_partenaire, a1_bi_partenaire_ili_cont_empl.designation_complementaire, a1_bi_partenaire_ili_cont_empl.apporteur_affaire, a1_bi_partenaire_ili_cont_empl.cause_radiation, a1_bi_partenaire_ili_cont_empl.classe, a1_bi_partenaire_ili_cont_empl.code_succession, a1_bi_partenaire_ili_cont_empl.numero_agent, a1_bi_partenaire_ili_cont_empl.statut_agent, a1_bi_partenaire_ili_cont_empl.numero_immobilier, a1_bi_partenaire_ili_cont_empl.role_relation, a1_bi_partenaire_ili_cont_empl.type_contact, a1_bi_partenaire_ili_cont_empl.texte_libre_1, a1_bi_partenaire_ili_cont_empl.texte_libre_2, a1_bi_partenaire_ili_cont_empl.email, a1_bi_partenaire_ili_cont_empl.email_confidentiel, a1_bi_partenaire_ili_cont_empl.email_prive, a1_bi_partenaire_ili_cont_empl.email_prive_confidentiel, a1_bi_partenaire_ili_cont_empl.email_mailing, a1_bi_partenaire_ili_cont_empl.email_mailing_confidentiel, a1_bi_partenaire_ili_cont_empl.email_delegue_cip, a1_bi_partenaire_ili_cont_empl.email_delegue_cip_confidentiel, a1_bi_partenaire_ili_cont_empl.email_professionnel, a1_bi_partenaire_ili_cont_empl.email_professionnel_confidentiel, a1_bi_partenaire_ili_cont_empl.email_cv_internet, a1_bi_partenaire_ili_cont_empl.email_cv_internet_confidentiel, a1_bi_partenaire_ili_cont_empl.email_autre, a1_bi_partenaire_ili_cont_empl.email_autre_confidentiel, a1_bi_partenaire_ili_cont_empl.fax, a1_bi_partenaire_ili_cont_empl.telephone_portable, a1_bi_partenaire_ili_cont_empl.telephone_prive, a1_bi_partenaire_ili_cont_empl.nationalite_1, a1_bi_partenaire_ili_cont_empl.nationalite_2, a1_bi_partenaire_ili_cont_empl.cause_exemption_fatca, a1_bi_partenaire_ili_cont_empl.declaration_fatca, a1_bi_partenaire_ili_cont_empl.etranger_soumis_avs, a1_bi_partenaire_ili_cont_empl.code_fiscalite_fatca, a1_bi_partenaire_ili_cont_empl.intermediaire_lba, a1_bi_partenaire_ili_cont_empl.niveau_lba, a1_bi_partenaire_ili_cont_empl.numero_contribuable_etranger, a1_bi_partenaire_ili_cont_empl.numero_contribuable_usa, a1_bi_partenaire_ili_cont_empl.dte_log_u, a1_bi_partenaire_ili_cont_empl.dte_log_i, a1_bi_partenaire_ili_cont_empl.certificat_vie_internet, a1_bi_partenaire_ili_cont_empl.dte_extraction, a1_bi_partenaire_ili_cont_empl.texte_recherche, a1_bi_partenaire_ili_cont_empl.courrier_ear, a1_bi_partenaire_ili_cont_empl.langue, a1_bi_partenaire_ili_cont_empl.flg_apporteur_affaire, a1_bi_partenaire_ili_cont_empl.email_portail_client, a1_bi_partenaire_ili_cont_empl.email_portail_client_confidentiel, a1_bi_partenaire_ili_cont_empl.fax_confidentiel, a1_bi_partenaire_ili_cont_empl.telephone_portable_confidentiel, a1_bi_partenaire_ili_cont_empl.telephone_professionnel, a1_bi_partenaire_ili_cont_empl.telephone_professionnel_confidentiel, a1_bi_partenaire_ili_cont_empl.telephone_prive_confidentiel, a1_bi_partenaire_ili_cont_empl.telephone_principal, a1_bi_partenaire_ili_cont_empl.telephone_principal_confidentiel, a1_bi_partenaire_ili_cont_empl.telephone_cv_internet, a1_bi_partenaire_ili_cont_empl.telephone_cv_internet_confidentiel, a1_bi_partenaire_ili_cont_empl.telephone_autre, a1_bi_partenaire_ili_cont_empl.telephone_autre_confidentiel, a1_bi_partenaire_ili_cont_empl.nationalite_3, a1_bi_partenaire_ili_cont_empl.proprietaire, a1_bi_partenaire_ili_cont_empl.type_fiscalite, a1_bi_partenaire_ili_cont_empl.tranche_revenu, a1_bi_partenaire_ili_cont_empl.flg_conseiller, a1_bi_partenaire_ili_cont_empl.collaborateur_rp, a1_bi_partenaire_ili_cont_empl.visa, a1_bi_partenaire_ili_cont_empl.fonction_id, a1_bi_partenaire_ili_cont_empl.fonction_desc, a1_bi_partenaire_ili_cont_empl.secteur_id, a1_bi_partenaire_ili_cont_empl.secteur_desc, a1_bi_partenaire_ili_cont_empl.numero_contact_conseiller_principal, a1_bi_partenaire_ili_cont_empl.flg_ne_pas_contacter, a1_bi_partenaire_ili_cont_empl.nb_relations_2e_pilier, a1_bi_partenaire_ili_cont_empl.nb_relations_3e_pilier, a1_bi_partenaire_ili_cont_empl.nb_relations_locataire_rp, a1_bi_partenaire_ili_cont_empl.nb_relations_prets, a1_bi_partenaire_ili_cont_empl.flg_bellavita_papier, a1_bi_partenaire_ili_cont_empl.flg_bellavita_electronique, a1_bi_partenaire_ili_cont_empl.flg_offres_speciales, a1_bi_partenaire_ili_cont_empl.flg_savoir_faire, a1_bi_partenaire_ili_cont_empl.flg_bulletin_2ep_cpev, a1_bi_partenaire_ili_cont_empl.flg_bulletin_2ep_cip, a1_bi_partenaire_ili_cont_empl.flg_bulletin_2ep_rp, a1_bi_partenaire_ili_cont_empl.flg_bulletin_2ep_profelia, a1_bi_partenaire_ili_cont_empl.flg_bulletin_2ep_ecarp, a1_bi_partenaire_ili_cont_empl.canal_diffusion, a1_bi_partenaire_ili_cont_empl.civilite_multilingue, a1_bi_partenaire_ili_cont_empl.nom_prenom, a1_bi_partenaire_ili_cont_empl.nationalite_1_nom_officiel, a1_bi_partenaire_ili_cont_empl.nationalite_2_nom_officiel, a1_bi_partenaire_ili_cont_empl.nationalite_3_nom_officiel, a1_bi_partenaire_ili_cont_empl.statut_contact, a1_bi_partenaire_ili_cont_empl.dte_creation_partenaire, a1_bi_partenaire_ili_cont_empl.numero_contact_fournisseur_immo
  • Index Cond: (a1_part_ili_cont_empl.numero_contact = a1_bi_partenaire_ili_cont_empl.numero_contact)
  • Buffers: shared hit=4,269 read=155
70. 211.246 211.246 ↑ 1.0 1 1,106

Index Scan using p_part_comm_d on iliade.part_comm_dossier (cost=0.43..7.92 rows=1 width=26) (actual time=0.191..0.191 rows=1 loops=1,106)

  • Output: part_comm_dossier.sal_avs, part_comm_dossier.sal_cotisant_garanti, part_comm_dossier.tx_act, part_comm_dossier.dossier_gen_id, part_comm_dossier.part_comm_dossier_id
  • Index Cond: (part_comm_dossier.part_comm_dossier_id = coti_plan_part_comm.part_comm_dossier_id)
  • Filter: ((part_comm_dossier.type_part_comm)::text = 'EMPL'::text)
  • Buffers: shared hit=4,131 read=293
71. 157.052 157.052 ↑ 5.0 1 1,106

Index Scan using d_g_in_pt_d_fk on iliade.part_dossier a1_part_dossier_ili_affi (cost=0.43..54.93 rows=5 width=8) (actual time=0.139..0.142 rows=1 loops=1,106)

  • Output: a1_part_dossier_ili_affi.part_dossier_id, a1_part_dossier_ili_affi.dossier_gen_id, a1_part_dossier_ili_affi.part_dossier_part_id, a1_part_dossier_ili_affi.dossier_id, a1_part_dossier_ili_affi.no_gen_dossier, a1_part_dossier_ili_affi.role, a1_part_dossier_ili_affi.usr_log_i, a1_part_dossier_ili_affi.dte_log_i, a1_part_dossier_ili_affi.usr_log_u, a1_part_dossier_ili_affi.dte_log_u, a1_part_dossier_ili_affi.audit
  • Index Cond: (a1_part_dossier_ili_affi.dossier_gen_id = dossier_gen.dossier_gen_id)
  • Filter: ((a1_part_dossier_ili_affi.role)::text = 'AFFI'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4,168 read=306
72. 176.960 176.960 ↑ 1.0 1 1,106

Index Scan using p_part on iliade.part a1_part_ili_dos_affi (cost=0.42..7.90 rows=1 width=8) (actual time=0.160..0.160 rows=1 loops=1,106)

  • Output: a1_part_ili_dos_affi.part_id, a1_part_ili_dos_affi.type_part, a1_part_ili_dos_affi.nom_ou_raison_sociale, a1_part_ili_dos_affi.nom_complementaire, a1_part_ili_dos_affi.nom_alliance, a1_part_ili_dos_affi.prenom, a1_part_ili_dos_affi.dte_naissance, a1_part_ili_dos_affi.dte_deces, a1_part_ili_dos_affi.sexe, a1_part_ili_dos_affi.etat_civil, a1_part_ili_dos_affi.no_avs, a1_part_ili_dos_affi.langue_correspondance, a1_part_ili_dos_affi.usr_log_i, a1_part_ili_dos_affi.dte_log_i, a1_part_ili_dos_affi.usr_log_u, a1_part_ili_dos_affi.dte_log_u, a1_part_ili_dos_affi.audit, a1_part_ili_dos_affi.visa, a1_part_ili_dos_affi.numero_contact
  • Index Cond: (a1_part_ili_dos_affi.part_id = a1_part_dossier_ili_affi.part_dossier_part_id)
  • Buffers: shared hit=4,150 read=284
73. 188.020 188.020 ↑ 1.0 1 1,106

Index Scan using bi_partenaire_uk1 on biinfra.bi_partenaire a1_bi_partenaire_ili_dos_affi (cost=0.42..7.90 rows=1 width=33) (actual time=0.170..0.170 rows=1 loops=1,106)

  • Output: a1_bi_partenaire_ili_dos_affi.contact_id, a1_bi_partenaire_ili_dos_affi.numero_contact, a1_bi_partenaire_ili_dos_affi.partenaire_id, a1_bi_partenaire_ili_dos_affi.prenom, a1_bi_partenaire_ili_dos_affi.nom_raison_sociale, a1_bi_partenaire_ili_dos_affi.complement_raison_sociale, a1_bi_partenaire_ili_dos_affi.flg_personne_physique, a1_bi_partenaire_ili_dos_affi.flg_collaborateur, a1_bi_partenaire_ili_dos_affi.date_naissance, a1_bi_partenaire_ili_dos_affi.titre_civil, a1_bi_partenaire_ili_dos_affi.date_deces, a1_bi_partenaire_ili_dos_affi.etat_civil, a1_bi_partenaire_ili_dos_affi.numero_avs_upi, a1_bi_partenaire_ili_dos_affi.sexe, a1_bi_partenaire_ili_dos_affi.curatelle, a1_bi_partenaire_ili_dos_affi.statut_partenaire, a1_bi_partenaire_ili_dos_affi.designation_complementaire, a1_bi_partenaire_ili_dos_affi.apporteur_affaire, a1_bi_partenaire_ili_dos_affi.cause_radiation, a1_bi_partenaire_ili_dos_affi.classe, a1_bi_partenaire_ili_dos_affi.code_succession, a1_bi_partenaire_ili_dos_affi.numero_agent, a1_bi_partenaire_ili_dos_affi.statut_agent, a1_bi_partenaire_ili_dos_affi.numero_immobilier, a1_bi_partenaire_ili_dos_affi.role_relation, a1_bi_partenaire_ili_dos_affi.type_contact, a1_bi_partenaire_ili_dos_affi.texte_libre_1, a1_bi_partenaire_ili_dos_affi.texte_libre_2, a1_bi_partenaire_ili_dos_affi.email, a1_bi_partenaire_ili_dos_affi.email_confidentiel, a1_bi_partenaire_ili_dos_affi.email_prive, a1_bi_partenaire_ili_dos_affi.email_prive_confidentiel, a1_bi_partenaire_ili_dos_affi.email_mailing, a1_bi_partenaire_ili_dos_affi.email_mailing_confidentiel, a1_bi_partenaire_ili_dos_affi.email_delegue_cip, a1_bi_partenaire_ili_dos_affi.email_delegue_cip_confidentiel, a1_bi_partenaire_ili_dos_affi.email_professionnel, a1_bi_partenaire_ili_dos_affi.email_professionnel_confidentiel, a1_bi_partenaire_ili_dos_affi.email_cv_internet, a1_bi_partenaire_ili_dos_affi.email_cv_internet_confidentiel, a1_bi_partenaire_ili_dos_affi.email_autre, a1_bi_partenaire_ili_dos_affi.email_autre_confidentiel, a1_bi_partenaire_ili_dos_affi.fax, a1_bi_partenaire_ili_dos_affi.telephone_portable, a1_bi_partenaire_ili_dos_affi.telephone_prive, a1_bi_partenaire_ili_dos_affi.nationalite_1, a1_bi_partenaire_ili_dos_affi.nationalite_2, a1_bi_partenaire_ili_dos_affi.cause_exemption_fatca, a1_bi_partenaire_ili_dos_affi.declaration_fatca, a1_bi_partenaire_ili_dos_affi.etranger_soumis_avs, a1_bi_partenaire_ili_dos_affi.code_fiscalite_fatca, a1_bi_partenaire_ili_dos_affi.intermediaire_lba, a1_bi_partenaire_ili_dos_affi.niveau_lba, a1_bi_partenaire_ili_dos_affi.numero_contribuable_etranger, a1_bi_partenaire_ili_dos_affi.numero_contribuable_usa, a1_bi_partenaire_ili_dos_affi.dte_log_u, a1_bi_partenaire_ili_dos_affi.dte_log_i, a1_bi_partenaire_ili_dos_affi.certificat_vie_internet, a1_bi_partenaire_ili_dos_affi.dte_extraction, a1_bi_partenaire_ili_dos_affi.texte_recherche, a1_bi_partenaire_ili_dos_affi.courrier_ear, a1_bi_partenaire_ili_dos_affi.langue, a1_bi_partenaire_ili_dos_affi.flg_apporteur_affaire, a1_bi_partenaire_ili_dos_affi.email_portail_client, a1_bi_partenaire_ili_dos_affi.email_portail_client_confidentiel, a1_bi_partenaire_ili_dos_affi.fax_confidentiel, a1_bi_partenaire_ili_dos_affi.telephone_portable_confidentiel, a1_bi_partenaire_ili_dos_affi.telephone_professionnel, a1_bi_partenaire_ili_dos_affi.telephone_professionnel_confidentiel, a1_bi_partenaire_ili_dos_affi.telephone_prive_confidentiel, a1_bi_partenaire_ili_dos_affi.telephone_principal, a1_bi_partenaire_ili_dos_affi.telephone_principal_confidentiel, a1_bi_partenaire_ili_dos_affi.telephone_cv_internet, a1_bi_partenaire_ili_dos_affi.telephone_cv_internet_confidentiel, a1_bi_partenaire_ili_dos_affi.telephone_autre, a1_bi_partenaire_ili_dos_affi.telephone_autre_confidentiel, a1_bi_partenaire_ili_dos_affi.nationalite_3, a1_bi_partenaire_ili_dos_affi.proprietaire, a1_bi_partenaire_ili_dos_affi.type_fiscalite, a1_bi_partenaire_ili_dos_affi.tranche_revenu, a1_bi_partenaire_ili_dos_affi.flg_conseiller, a1_bi_partenaire_ili_dos_affi.collaborateur_rp, a1_bi_partenaire_ili_dos_affi.visa, a1_bi_partenaire_ili_dos_affi.fonction_id, a1_bi_partenaire_ili_dos_affi.fonction_desc, a1_bi_partenaire_ili_dos_affi.secteur_id, a1_bi_partenaire_ili_dos_affi.secteur_desc, a1_bi_partenaire_ili_dos_affi.numero_contact_conseiller_principal, a1_bi_partenaire_ili_dos_affi.flg_ne_pas_contacter, a1_bi_partenaire_ili_dos_affi.nb_relations_2e_pilier, a1_bi_partenaire_ili_dos_affi.nb_relations_3e_pilier, a1_bi_partenaire_ili_dos_affi.nb_relations_locataire_rp, a1_bi_partenaire_ili_dos_affi.nb_relations_prets, a1_bi_partenaire_ili_dos_affi.flg_bellavita_papier, a1_bi_partenaire_ili_dos_affi.flg_bellavita_electronique, a1_bi_partenaire_ili_dos_affi.flg_offres_speciales, a1_bi_partenaire_ili_dos_affi.flg_savoir_faire, a1_bi_partenaire_ili_dos_affi.flg_bulletin_2ep_cpev, a1_bi_partenaire_ili_dos_affi.flg_bulletin_2ep_cip, a1_bi_partenaire_ili_dos_affi.flg_bulletin_2ep_rp, a1_bi_partenaire_ili_dos_affi.flg_bulletin_2ep_profelia, a1_bi_partenaire_ili_dos_affi.flg_bulletin_2ep_ecarp, a1_bi_partenaire_ili_dos_affi.canal_diffusion, a1_bi_partenaire_ili_dos_affi.civilite_multilingue, a1_bi_partenaire_ili_dos_affi.nom_prenom, a1_bi_partenaire_ili_dos_affi.nationalite_1_nom_officiel, a1_bi_partenaire_ili_dos_affi.nationalite_2_nom_officiel, a1_bi_partenaire_ili_dos_affi.nationalite_3_nom_officiel, a1_bi_partenaire_ili_dos_affi.statut_contact, a1_bi_partenaire_ili_dos_affi.dte_creation_partenaire, a1_bi_partenaire_ili_dos_affi.numero_contact_fournisseur_immo
  • Index Cond: (a1_bi_partenaire_ili_dos_affi.numero_contact = a1_part_ili_dos_affi.numero_contact)
  • Buffers: shared hit=4,145 read=279
74. 189.126 189.126 ↑ 3.0 1 1,106

Index Scan using pi_in_prestso_fk on iliade.prest_sortie (cost=0.43..26.24 rows=3 width=16) (actual time=0.171..0.171 rows=1 loops=1,106)

  • Output: prest_sortie.prest_sortie_id, prest_sortie.partie_dossier_id, prest_sortie.dossier_id, prest_sortie.no_gen_dossier, prest_sortie.type_av_ap, prest_sortie.avoir_min_lpp, prest_sortie.avoir_reglementaire, prest_sortie.prest_propres_coti, prest_sortie.prest_sortie, prest_sortie.usr_log_i, prest_sortie.dte_log_i, prest_sortie.usr_log_u, prest_sortie.dte_log_u, prest_sortie.tx_impot_source, prest_sortie.mnt_impot_source, prest_sortie.prest_sortie_ms_impot_source, prest_sortie.avoir_plan_droits_acquis, prest_sortie.prest_sortie_gar, prest_sortie.prest_sortie_avec_rachats_nacq, prest_sortie.rachats_nacq, prest_sortie.audit, prest_sortie.mnt_max_va_logement, prest_sortie.mnt_pref_lp, prest_sortie.rachat_suppl_temporaire, prest_sortie.mnt_lpp_pref_lp
  • Index Cond: (prest_sortie.partie_dossier_id = partie_dossier.partie_dossier_id)
  • Filter: ((prest_sortie.type_av_ap)::text = 'APRE'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4,155 read=309
75.          

SubPlan (for Nested Loop)

76. 71.890 71.890 ↑ 1.0 1 1,106

Index Scan using idx_bi_code_cde_lan_type_cle on biinfra.bi_code bic (cost=0.28..8.30 rows=1 width=16) (actual time=0.064..0.065 rows=1 loops=1,106)

  • Output: bic.texte
  • Index Cond: (((bic.cde_lan)::text = 'FR'::text) AND ((bic.code_type)::text = 'TypePlan'::text) AND ((plan_partie.type_plan)::text = (bic.code_cle)::text))
  • Buffers: shared hit=3,210 read=108
Planning time : 38.404 ms
Execution time : 8,129,188.547 ms