explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kx73

Settings
# exclusive inclusive rows x rows loops node
1. 168.815 456,097.803 ↓ 16,325.8 293,864 1

GroupAggregate (cost=138,050.69..138,051.19 rows=18 width=48) (actual time=455,898.196..456,097.803 rows=293,864 loops=1)

  • Output: bi_dates.dte_jour, il_dwh_dossier.dossier_id, il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.dte_mouvement, sum(il_dwh_cpt_epa_mouvement.mnt_lpp)
  • Group Key: bi_dates.dte_jour, il_dwh_dossier.dossier_id, il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.dte_mouvement
  • Buffers: shared hit=225615478 read=1
2. 379.983 455,928.988 ↓ 19,339.7 348,115 1

Sort (cost=138,050.69..138,050.74 rows=18 width=21) (actual time=455,898.171..455,928.988 rows=348,115 loops=1)

  • Output: bi_dates.dte_jour, il_dwh_dossier.dossier_id, il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.dte_mouvement, il_dwh_cpt_epa_mouvement.mnt_lpp
  • Sort Key: il_dwh_dossier.dossier_id, il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.dte_mouvement
  • Sort Method: quicksort Memory: 35952kB
  • Buffers: shared hit=225615478 read=1
3. 93.447 455,549.005 ↓ 19,339.7 348,115 1

Nested Loop (cost=1,002.42..138,050.32 rows=18 width=21) (actual time=59.859..455,549.005 rows=348,115 loops=1)

  • Output: bi_dates.dte_jour, il_dwh_dossier.dossier_id, il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.dte_mouvement, il_dwh_cpt_epa_mouvement.mnt_lpp
  • Buffers: shared hit=225615472 read=1
4. 0.044 0.044 ↑ 1.0 1 1

Index Only Scan using bi_dates_pkey on biinfra.bi_dates (cost=0.28..2.50 rows=1 width=4) (actual time=0.042..0.044 rows=1 loops=1)

  • Output: bi_dates.dte_jour
  • Index Cond: (bi_dates.dte_jour = '2020-01-01'::date)
  • Heap Fetches: 1
  • Buffers: shared hit=3
5. 72.546 455,455.514 ↓ 19,339.7 348,115 1

Nested Loop (cost=1,002.13..138,047.64 rows=18 width=21) (actual time=59.815..455,455.514 rows=348,115 loops=1)

  • Output: il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.dte_mouvement, il_dwh_cpt_epa_mouvement.mnt_lpp, il_dwh_dossier.dossier_id, il_dwh_dossier.dl_datextract
  • Buffers: shared hit=225615469 read=1
6. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on biinfra.bi_soc (cost=0.00..1.09 rows=1 width=4) (actual time=0.015..0.019 rows=1 loops=1)

  • 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 = 6)
  • Rows Removed by Filter: 6
  • Buffers: shared hit=1
7. 118.338 455,382.949 ↓ 19,339.7 348,115 1

Nested Loop (cost=1,002.13..138,046.37 rows=18 width=25) (actual time=59.798..455,382.949 rows=348,115 loops=1)

  • Output: il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.dte_mouvement, il_dwh_cpt_epa_mouvement.mnt_lpp, il_dwh_dossier.dossier_id, il_dwh_dossier.dl_datextract, bi_prod.soc_id
  • Buffers: shared hit=225615468 read=1
8. 0.002 0.033 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.40 rows=1 width=8) (actual time=0.025..0.033 rows=1 loops=1)

  • Output: bi_par_flg_bcl.dl_flg_bcl, bi_par_flg_inv.dl_flg_inv
  • Buffers: shared hit=2
9. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on bidwhpar.bi_par_flg_bcl (cost=0.00..1.34 rows=1 width=4) (actual time=0.011..0.015 rows=1 loops=1)

  • Output: bi_par_flg_bcl.dl_flg_bcl, bi_par_flg_bcl.dl_flg_bcl_desc
  • Filter: (bi_par_flg_bcl.dl_flg_bcl = 1)
  • Rows Removed by Filter: 26
  • Buffers: shared hit=1
10. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on bidwhpar.bi_par_flg_inv (cost=0.00..1.05 rows=1 width=4) (actual time=0.013..0.016 rows=1 loops=1)

  • Output: bi_par_flg_inv.dl_flg_inv, bi_par_flg_inv.dl_flg_inv_desc
  • Filter: (bi_par_flg_inv.dl_flg_inv = 1)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1
11. 1,242.235 455,264.578 ↓ 19,339.7 348,115 1

Gather (cost=1,002.13..138,043.79 rows=18 width=33) (actual time=59.771..455,264.578 rows=348,115 loops=1)

  • Output: il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.dte_mouvement, il_dwh_cpt_epa_mouvement.mnt_lpp, il_dwh_dossier.dossier_id, il_dwh_dossier.dl_datextract, il_dwh_dossier.dl_flg_bcl, il_dwh_dossier.dl_flg_inv, bi_prod.soc_id
  • Workers Planned: 4
  • Workers Launched: 3
  • Buffers: shared hit=225615466 read=1
12. 246.028 454,022.343 ↓ 21,757.2 87,029 4 / 4

Nested Loop Left Join (cost=2.13..137,041.99 rows=4 width=33) (actual time=51.775..454,022.343 rows=87,029 loops=4)

  • Output: il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.dte_mouvement, il_dwh_cpt_epa_mouvement.mnt_lpp, il_dwh_dossier.dossier_id, il_dwh_dossier.dl_datextract, il_dwh_dossier.dl_flg_bcl, il_dwh_dossier.dl_flg_inv, bi_prod.soc_id
  • Buffers: shared hit=225615466 read=1
  • Worker 0: actual time=49.771..453383.107 rows=86942 loops=1
  • Buffers: shared hit=56232604
  • Worker 1: actual time=50.005..455652.487 rows=86968 loops=1
  • Buffers: shared hit=56784654
  • Worker 2: actual time=50.011..453000.380 rows=86500 loops=1
  • Buffers: shared hit=56208010 read=1
13. 64.105 941.254 ↓ 9,881.2 39,525 4 / 4

Nested Loop (cost=1.57..131,993.57 rows=4 width=40) (actual time=33.666..941.254 rows=39,525 loops=4)

  • Output: il_dwh_plan_partie.dl_datextract, il_dwh_plan_partie.dl_soc_id, il_dwh_plan_partie.dl_flg_bcl, il_dwh_plan_partie.dl_flg_inv, il_dwh_plan_partie.plan_partie_id, il_dwh_dossier.dossier_id, il_dwh_dossier.dl_datextract, il_dwh_dossier.dl_flg_bcl, il_dwh_dossier.dl_flg_inv, bi_prod.soc_id
  • Buffers: shared hit=896262 read=1
  • Worker 0: actual time=31.635..930.088 rows=39406 loops=1
  • Buffers: shared hit=221570
  • Worker 1: actual time=31.901..949.273 rows=39791 loops=1
  • Buffers: shared hit=227089
  • Worker 2: actual time=31.949..930.920 rows=39389 loops=1
  • Buffers: shared hit=221388 read=1
14. 37.696 502.227 ↓ 226.4 15,622 4 / 4

Nested Loop (cost=1.14..131,563.15 rows=69 width=44) (actual time=33.543..502.227 rows=15,622 loops=4)

  • Output: il_dwh_partie_dossier.dl_datextract, il_dwh_partie_dossier.dl_soc_id, il_dwh_partie_dossier.dl_flg_bcl, il_dwh_partie_dossier.dl_flg_inv, il_dwh_partie_dossier.partie_dossier_id, il_dwh_dossier.dossier_id, il_dwh_dossier.dl_datextract, il_dwh_dossier.dl_soc_id, il_dwh_dossier.dl_flg_bcl, il_dwh_dossier.dl_flg_inv, bi_prod.soc_id
  • Buffers: shared hit=486911 read=1
  • Worker 0: actual time=31.512..499.056 rows=15553 loops=1
  • Buffers: shared hit=120362
  • Worker 1: actual time=31.768..504.348 rows=15770 loops=1
  • Buffers: shared hit=122950
  • Worker 2: actual time=31.816..494.365 rows=15515 loops=1
  • Buffers: shared hit=120099 read=1
15. 72.792 229.307 ↓ 5.2 14,702 4 / 4

Nested Loop (cost=0.70..121,449.17 rows=2,838 width=28) (actual time=33.453..229.307 rows=14,702 loops=4)

  • Output: il_dwh_dossier.dossier_id, il_dwh_dossier.dl_datextract, il_dwh_dossier.dl_soc_id, il_dwh_dossier.dl_flg_bcl, il_dwh_dossier.dl_flg_inv, il_dwh_dossier.dossier_gen_id, bi_prod.soc_id
  • Inner Unique: true
  • Buffers: shared hit=178647 read=1
  • Worker 0: actual time=31.420..226.998 rows=14656 loops=1
  • Buffers: shared hit=44087
  • Worker 1: actual time=31.673..229.131 rows=14819 loops=1
  • Buffers: shared hit=44708
  • Worker 2: actual time=31.718..224.741 rows=14616 loops=1
  • Buffers: shared hit=43908 read=1
16. 75.874 75.874 ↑ 1.6 20,160 4 / 4

Parallel Index Scan using il_dwh_dossier_pkey on bidwh.il_dwh_dossier (cost=0.56..116,227.01 rows=31,652 width=28) (actual time=1.591..75.874 rows=20,160 loops=4)

  • Output: il_dwh_dossier.dl_datextract, il_dwh_dossier.dl_soc_id, il_dwh_dossier.dl_flg_bcl, il_dwh_dossier.dl_flg_inv, il_dwh_dossier.dossier_id, il_dwh_dossier.no_gen_dossier, il_dwh_dossier.dossier_gen_id, il_dwh_dossier.mut_dossier_id, il_dwh_dossier.mut_dossier_id_prec, il_dwh_dossier.numero_dossier, il_dwh_dossier.contrat_id, il_dwh_dossier.numero_contrat, il_dwh_dossier.donnees_mut_dossier_id, il_dwh_dossier.per_gest_id, il_dwh_dossier.mut_id, il_dwh_dossier.dte_mut, il_dwh_dossier.description, il_dwh_dossier.desc_treeview, il_dwh_dossier.etat, il_dwh_dossier.description_etat_mut_dossier, il_dwh_dossier.statut, il_dwh_dossier.description_statut_mut_dossier, il_dwh_dossier.statut_precedent, il_dwh_dossier.description_statut_precedent, il_dwh_dossier.no_mut, il_dwh_dossier.no_mut_precedente, il_dwh_dossier.no_mut_extournee, il_dwh_dossier.maj_cpt_epa, il_dwh_dossier.dte_prochaine_fact_escompte, il_dwh_dossier.visa_cree_par, il_dwh_dossier.dte_creation, il_dwh_dossier.visa_modifie_par, il_dwh_dossier.dte_modification, il_dwh_dossier.visa_ctrl_par, il_dwh_dossier.dte_ctrl, il_dwh_dossier.numero_regrpmnt_mut, il_dwh_dossier.dte_derniere_fact_coti, il_dwh_dossier.dte_derniere_fact_prest, il_dwh_dossier.pro_id, il_dwh_dossier.dossier_parent_id, il_dwh_dossier.dte_affiliation, il_dwh_dossier.mnt_epa_tot, il_dwh_dossier.cd_cpte_epa_tot_d_ext, il_dwh_dossier.cd_cpte_epa_tot_fann, il_dwh_dossier.mnt_epa_min_lpp, il_dwh_dossier.cd_cpte_epa_min_lpp_d_ext, il_dwh_dossier.cd_cpte_epa_min_lpp_fann, il_dwh_dossier.dte_blocage_fact, il_dwh_dossier.raison_blocage_fact, il_dwh_dossier.visa_blocage_fact, il_dwh_dossier.dte_operation_blocage_fact, il_dwh_dossier.envoi_quest_mise_pension, il_dwh_dossier.objet_facturable_cree, il_dwh_dossier.deposant_epa, il_dwh_dossier.confidentiel, il_dwh_dossier.code_voir_dossier, il_dwh_dossier.impots_source, il_dwh_dossier.avoir_50_ans, il_dwh_dossier.retour_avoir_min_lpp, il_dwh_dossier.int_retour_avoir_min_lpp, il_dwh_dossier.retour_avoir_evlp, il_dwh_dossier.int_retour_avoir_evlp, il_dwh_dossier.restitution_avoir_min_lpp, il_dwh_dossier.int_restitution_avoir_min_lpp, il_dwh_dossier.restitution_avoir_evlp, il_dwh_dossier.int_restitution_avoir_evlp, il_dwh_dossier.beneficiaires_deces, il_dwh_dossier.donnees_medicales_introduites, il_dwh_dossier.description_donnees_med_int, il_dwh_dossier.refus_medical, il_dwh_dossier.cause_refus_medical, il_dwh_dossier.non_reponse_etat_sante, il_dwh_dossier.suivi_medical, il_dwh_dossier.description_suivi_medical, il_dwh_dossier.dte_suivi_medical, il_dwh_dossier.surprimes, il_dwh_dossier.reserves, il_dwh_dossier.inva, il_dwh_dossier.tot_rev_paye, il_dwh_dossier.dte_calc_avoir, il_dwh_dossier.dte_precedent_calc_avoir, il_dwh_dossier.dte_derniere_idx, il_dwh_dossier.dte_prochaine_annualisation, il_dwh_dossier.dte_prochain_bouclement, il_dwh_dossier.dte_prochain_recalcul, il_dwh_dossier.prise_cpt_causes_reduc, il_dwh_dossier.somme_tx_validite_inva, il_dwh_dossier.vers_anticipe_effectue, il_dwh_dossier.dte_retraite, il_dwh_dossier.trtmt_partie_active_retraite, il_dwh_dossier.dte_deces_reel, il_dwh_dossier.dte_demission, il_dwh_dossier.freq_paie_rentes, il_dwh_dossier.description_frequence_paiement, il_dwh_dossier.capital_inva, il_dwh_dossier.cd_capital_inva_d_ext, il_dwh_dossier.cd_capital_inva_fann, il_dwh_dossier.tx_inva_externe, il_dwh_dossier.cause_fin_inva, il_dwh_dossier.description_cause_fin_invalidi, il_dwh_dossier.vers_anticipe_en_cours, il_dwh_dossier.dte_demande_vers_anticipe, il_dwh_dossier.dte_der_vers_anticipe, il_dwh_dossier.raison_vers_anticipe, il_dwh_dossier.description_raison_versement_a, il_dwh_dossier.remb_tot_der_vers_anticipe, il_dwh_dossier.remb_tot_ensbl_vers_anticipes, il_dwh_dossier.div_en_cours, il_dwh_dossier.inscription_registre_foncier, il_dwh_dossier.mise_en_gage, il_dwh_dossier.jamais_affilie, il_dwh_dossier.dte_premiere_affiliation, il_dwh_dossier.dte_demande_avance_avs, il_dwh_dossier.avance_avs, il_dwh_dossier.dte_fin_avance_avs, il_dwh_dossier.mnt_avance_avs, il_dwh_dossier.ajournement, il_dwh_dossier.dte_fin_ajournement, il_dwh_dossier.maintien_fina_ajournement, il_dwh_dossier.ajournement_annee_en_annee, il_dwh_dossier.dte_prochain_ajournement, il_dwh_dossier.age_premier_ajournement, il_dwh_dossier.calc_av_terme, il_dwh_dossier.conge, il_dwh_dossier.demande_affiliation_recue, il_dwh_dossier.suri, il_dwh_dossier.dte_der_ctrl_suri, il_dwh_dossier.regles_avert_outrepassees, il_dwh_dossier.adresse_paie_connue, il_dwh_dossier.somme_risquee_reass_deces, il_dwh_dossier.somme_risquee_reass_deces_mvt, il_dwh_dossier.cd_som_risq_reas_d_d_ext, il_dwh_dossier.cd_som_risq_reas_d_fann, il_dwh_dossier.somme_risquee_reass_inva, il_dwh_dossier.somme_risquee_reass_inva_mvt, il_dwh_dossier.cd_som_risq_reas_i_d_ext, il_dwh_dossier.cd_som_risq_reas_i_fann, il_dwh_dossier.annonce_reass_deces, il_dwh_dossier.annonce_reass_inva, il_dwh_dossier.duree_cip_illimitee, il_dwh_dossier.dte_entree_actuarielle, il_dwh_dossier.dte_entree_av_conversion, il_dwh_dossier.dte_deb_conge, il_dwh_dossier.dte_deb_conge_effectif, il_dwh_dossier.dte_retour_conge, il_dwh_dossier.dte_retour_conge_effectif, il_dwh_dossier.conge_administratif, il_dwh_dossier.duree_conges_non_rachetes, il_dwh_dossier.mnt_rachat_excd, il_dwh_dossier.dte_rachat_excd, il_dwh_dossier.dte_echeance_rachat_excd, il_dwh_dossier.dte_fin_fine_entree, il_dwh_dossier.sal_inferieur_min_lpp, il_dwh_dossier.calc_prest_sortie_gar, il_dwh_dossier.dte_demande_retraite_capital, il_dwh_dossier.dte_ren_retraite_capital, il_dwh_dossier.dte_ren_avance_avs, il_dwh_dossier.type_compens, il_dwh_dossier.dte_retraite_compensee, il_dwh_dossier.capital_compens_retraite, il_dwh_dossier.capital_compens_suppltemp, il_dwh_dossier.paie_autr_beneficiaires_deces, il_dwh_dossier.suppltemp_avs, il_dwh_dossier.majo_suppltemp_avs, il_dwh_dossier.dte_fin_suppltemp_avs, il_dwh_dossier.dte_fin_majo_suppltemp_avs, il_dwh_dossier.dte_calc_situation_ass, il_dwh_dossier.majo_tx_pension, il_dwh_dossier.no_gen_dossier_situation_ass, il_dwh_dossier.numero_dossier_etat, il_dwh_dossier.cause_changement_employeur, il_dwh_dossier.type_mut_id, il_dwh_dossier.app_gest_id, il_dwh_dossier.nom_mut, il_dwh_dossier.niveau, il_dwh_dossier.impact_dossiers, il_dwh_dossier.genere_par_contrat, il_dwh_dossier.ged_mut_1, il_dwh_dossier.ged_mut_2, il_dwh_dossier.description_per_ges, il_dwh_dossier.dte_deb_per_ges, il_dwh_dossier.dte_fin_per_ges, il_dwh_dossier.statut_periode_gestion, il_dwh_dossier.description_statut_per_ges, il_dwh_dossier.base_salariale_id, il_dwh_dossier.dte_ref_base_sal, il_dwh_dossier.dte_fin_derniere_moyenne_base_salariale, il_dwh_dossier.base_salariale, il_dwh_dossier.base_coti_empl, il_dwh_dossier.base_coti_employeur, il_dwh_dossier.base_coti_tiers, il_dwh_dossier.base_fine_entree, il_dwh_dossier.op_usr_log_i, il_dwh_dossier.op_dte_log_i, il_dwh_dossier.op_usr_log_u, il_dwh_dossier.op_dte_log_u, il_dwh_dossier.age_terme_vise, il_dwh_dossier.code_urev_urcip, il_dwh_dossier.pas_pu_se_prononcer, il_dwh_dossier.prest_sortie_en_especes, il_dwh_dossier.gest_reservee, il_dwh_dossier.usr_log_i, il_dwh_dossier.dte_log_i, il_dwh_dossier.usr_log_u, il_dwh_dossier.dte_log_u, il_dwh_dossier.reass_deces, il_dwh_dossier.reass_inva, il_dwh_dossier.inva_proportion_reassuree, il_dwh_dossier.annonce_reass_deces_facultatif, il_dwh_dossier.annonce_reass_inva_facultatif, il_dwh_dossier.annonce_reass_deces_sinistre, il_dwh_dossier.annonce_reass_inva_sinistre, il_dwh_dossier.dte_escompte, il_dwh_dossier.part_id, il_dwh_dossier.nom_ou_raison_sociale, il_dwh_dossier.prenom, il_dwh_dossier.sexe, il_dwh_dossier.dte_naissance, il_dwh_dossier.statut_avant, il_dwh_dossier.mvt_actif, il_dwh_dossier.mvt_pens, il_dwh_dossier.mvt_term, il_dwh_dossier.mvt_bloq, il_dwh_dossier.prct_avance_avs, il_dwh_dossier.remb_avance_avs_prime_unique, il_dwh_dossier.paie_remb_avance_avs_effectue, il_dwh_dossier.frais_gest_demission, il_dwh_dossier.difference_cumulee, il_dwh_dossier.dte_calc, il_dwh_dossier.dte_fin_cumul, il_dwh_dossier.ecart_bande_etat_id, il_dwh_dossier.orig_mut, il_dwh_dossier.suivi_demande_affiliation, il_dwh_dossier.dte_suivi_demande_affiliation, il_dwh_dossier.annonce_extranet_id, il_dwh_dossier.blocage_extranet, il_dwh_dossier.responsable_gest, il_dwh_dossier.responsable_gest_medicale, il_dwh_dossier.stipulation_beneficiaire, il_dwh_dossier.pg_mut_ext, il_dwh_dossier.mois_demission_paye, il_dwh_dossier.pleine_capacite_travail, il_dwh_dossier.beneficiaire_rte_ai, il_dwh_dossier.dte_deb_inva_reconnue_ai, il_dwh_dossier.envoi_doc_affiliation, il_dwh_dossier.adresse_paie, il_dwh_dossier.id_mut_blocage_fact, il_dwh_dossier.dte_calc_deroulement, il_dwh_dossier.dte_fina_plus_maintenu, il_dwh_dossier.no_offre, il_dwh_dossier.raison_blocage_mutations, il_dwh_dossier.blocage_mutations, il_dwh_dossier.dte_blocage_mutations, il_dwh_dossier.donnees_retraite_annoncees, il_dwh_dossier.mnt_rachat_deg_pos, il_dwh_dossier.suivi_retraite, il_dwh_dossier.dte_prochain_suivi_retraite, il_dwh_dossier.quest_retraite_employeur_recu
  • Index Cond: ((il_dwh_dossier.dl_datextract = '2020-01-01'::date) AND (il_dwh_dossier.dl_flg_bcl = 1) AND (il_dwh_dossier.dl_flg_inv = 1))
  • Buffers: shared hit=17362 read=1
  • Worker 0: actual time=0.034..74.596 rows=19934 loops=1
  • Buffers: shared hit=4218
  • Worker 1: actual time=0.053..76.048 rows=20152 loops=1
  • Buffers: shared hit=4403
  • Worker 2: actual time=0.031..74.445 rows=19894 loops=1
  • Buffers: shared hit=4119 read=1
17. 80.641 80.641 ↑ 1.0 1 80,641 / 4

Index Scan using bi_prod_pkey on biinfra.bi_prod (cost=0.14..0.17 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=80,641)

  • 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
  • Index Cond: (bi_prod.pro_id = il_dwh_dossier.pro_id)
  • Filter: (bi_prod.soc_id = 6)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=161285
  • Worker 0: actual time=0.004..0.004 rows=1 loops=19934
  • Buffers: shared hit=39869
  • Worker 1: actual time=0.004..0.004 rows=1 loops=20152
  • Buffers: shared hit=40305
  • Worker 2: actual time=0.004..0.004 rows=1 loops=19894
  • Buffers: shared hit=39789
18. 235.224 235.224 ↑ 1.0 1 58,806 / 4

Index Scan using olm_il_dwh_partie_dossier_dossier_gen_id on bidwh.il_dwh_partie_dossier (cost=0.43..3.55 rows=1 width=24) (actual time=0.014..0.016 rows=1 loops=58,806)

  • Output: il_dwh_partie_dossier.dl_datextract, il_dwh_partie_dossier.dl_soc_id, il_dwh_partie_dossier.dl_flg_bcl, il_dwh_partie_dossier.dl_flg_inv, il_dwh_partie_dossier.partie_dossier_id, il_dwh_partie_dossier.partie_liee_partie_dossier_id, il_dwh_partie_dossier.dossier_id, il_dwh_partie_dossier.dossier_gen_id, il_dwh_partie_dossier.no_gen_dossier, il_dwh_partie_dossier.numero_dossier, il_dwh_partie_dossier.mut_dossier_id, il_dwh_partie_dossier.mut_dossier_id_prec, il_dwh_partie_dossier.contrat_id, il_dwh_partie_dossier.numero_contrat, il_dwh_partie_dossier.partie_dossier_orig_id, il_dwh_partie_dossier.etat, il_dwh_partie_dossier.type_partie, il_dwh_partie_dossier.description_type_partie, il_dwh_partie_dossier.type_deces, il_dwh_partie_dossier.description_type_deces, il_dwh_partie_dossier.dte_deb_partie, il_dwh_partie_dossier.dte_effet_idx, il_dwh_partie_dossier.avoir_50_ans, il_dwh_partie_dossier.type_inva, il_dwh_partie_dossier.description_type_invalidite, il_dwh_partie_dossier.dte_deb_inca_gain, il_dwh_partie_dossier.age_deb_inca_gain, il_dwh_partie_dossier.dte_fin_inca_gain, il_dwh_partie_dossier.dte_reexamen, il_dwh_partie_dossier.tx_inca_gain_reel, il_dwh_partie_dossier.tx_inca_gain_reel_mvt, il_dwh_partie_dossier.tx_inca_gain_calc, il_dwh_partie_dossier.tx_inca_gain_calc_mvt, il_dwh_partie_dossier.lib_passee, il_dwh_partie_dossier.inva_passee, il_dwh_partie_dossier.rechute, il_dwh_partie_dossier.dte_rechute, il_dwh_partie_dossier.faute_grave, il_dwh_partie_dossier.tx_reduc_faute_grave, il_dwh_partie_dossier.reticence, il_dwh_partie_dossier.accident, il_dwh_partie_dossier.cause_medicale_sinistre, il_dwh_partie_dossier.cause_risque_special_sinistre, il_dwh_partie_dossier.sal_actif_reparti, il_dwh_partie_dossier.delai_attente_lib_consomme, il_dwh_partie_dossier.delai_attente_ri_consomme, il_dwh_partie_dossier.dte_age_terme, il_dwh_partie_dossier.dte_deb_mise_en_pension, il_dwh_partie_dossier.tx_retraite, il_dwh_partie_dossier.suri_avec_pe, il_dwh_partie_dossier.suri_avec_idx, il_dwh_partie_dossier.dte_revision_ai, il_dwh_partie_dossier.dte_revision_caisse_pension, il_dwh_partie_dossier.tx_sal_suri, il_dwh_partie_dossier.tot_rev_recu, il_dwh_partie_dossier.reprise_ancienne_ip, il_dwh_partie_dossier.deb_paie_effectif, il_dwh_partie_dossier.sal_ann_presume_perdu, il_dwh_partie_dossier.dn_mut_id, il_dwh_partie_dossier.dn_dte_mut, il_dwh_partie_dossier.dn_nom_mut, il_dwh_partie_dossier.pro_id, il_dwh_partie_dossier.dte_echeance_partie, il_dwh_partie_dossier.calc_av_terme, il_dwh_partie_dossier.mnt_cpt_droits_transitoires, il_dwh_partie_dossier.int_cpt_droits_transitoires, il_dwh_partie_dossier.cd_mnt_cpt_droits_transitoires_fin_ann, il_dwh_partie_dossier.cd_mnt_cpt_droits_transitoires_dat_ext, il_dwh_partie_dossier.cd_int_cpt_droits_transitoires_fin_ann, il_dwh_partie_dossier.cd_int_cpt_droits_transitoires_dat_ext, il_dwh_partie_dossier.somme_risquee_reass_deces, il_dwh_partie_dossier.somme_risquee_reass_inva, il_dwh_partie_dossier.annonce_reass_deces, il_dwh_partie_dossier.annonce_reass_inva, il_dwh_partie_dossier.annonce_reass_deces_facultatif, il_dwh_partie_dossier.annonce_reass_inva_facultatif, il_dwh_partie_dossier.annonce_reass_deces_sinistre, il_dwh_partie_dossier.annonce_reass_inva_sinistre, il_dwh_partie_dossier.reass_deces, il_dwh_partie_dossier.reass_inva, il_dwh_partie_dossier.inva_proportion_reassuree, il_dwh_partie_dossier.fo_reass_id, il_dwh_partie_dossier.annonce_deces, il_dwh_partie_dossier.annonce_invalidite, il_dwh_partie_dossier.usr_log_i, il_dwh_partie_dossier.dte_log_i, il_dwh_partie_dossier.usr_log_u, il_dwh_partie_dossier.dte_log_u
  • Index Cond: (il_dwh_partie_dossier.dossier_gen_id = il_dwh_dossier.dossier_gen_id)
  • Filter: ((il_dwh_partie_dossier.dl_datextract = '2020-01-01'::date) AND (il_dwh_partie_dossier.dl_flg_inv = 1) AND (il_dwh_partie_dossier.dl_flg_bcl = 1) AND (il_dwh_dossier.dl_soc_id = il_dwh_partie_dossier.dl_soc_id))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=308264
  • Worker 0: actual time=0.014..0.016 rows=1 loops=14656
  • Buffers: shared hit=76275
  • Worker 1: actual time=0.014..0.016 rows=1 loops=14819
  • Buffers: shared hit=78242
  • Worker 2: actual time=0.014..0.016 rows=1 loops=14616
  • Buffers: shared hit=76191
19. 374.922 374.922 ↓ 3.0 3 62,487 / 4

Index Scan using olm_il_dwh_plan_partie_partie_dossier_id on bidwh.il_dwh_plan_partie (cost=0.44..6.23 rows=1 width=24) (actual time=0.014..0.024 rows=3 loops=62,487)

  • Output: il_dwh_plan_partie.dl_datextract, il_dwh_plan_partie.dl_soc_id, il_dwh_plan_partie.dl_flg_bcl, il_dwh_plan_partie.dl_flg_inv, il_dwh_plan_partie.dossier_id, il_dwh_plan_partie.dossier_gen_id, il_dwh_plan_partie.no_gen_dossier, il_dwh_plan_partie.numero_dossier, il_dwh_plan_partie.mut_dossier_id, il_dwh_plan_partie.contrat_id, il_dwh_plan_partie.numero_contrat, il_dwh_plan_partie.plan_partie_id, il_dwh_plan_partie.partie_dossier_id, il_dwh_plan_partie.plan_employeur_affilie_id, il_dwh_plan_partie.plan_partie_orig_id, il_dwh_plan_partie.plan_base_id, il_dwh_plan_partie.nom_plan, il_dwh_plan_partie.nom_comm, il_dwh_plan_partie.type_plan, il_dwh_plan_partie.description_type_plan, il_dwh_plan_partie.type_prev_lpp, il_dwh_plan_partie.description_type_prevoyance_lp, il_dwh_plan_partie.etat, il_dwh_plan_partie.deduc_1, il_dwh_plan_partie.deduc_2, il_dwh_plan_partie.mnt_capital_retraite, il_dwh_plan_partie.prct_capital_retraite, il_dwh_plan_partie.mnt_rte_retraite, il_dwh_plan_partie.prct_rte_retraite, il_dwh_plan_partie.corrections_manuelles, il_dwh_plan_partie.dte_effet, il_dwh_plan_partie.recalcul_prest_av_terme, il_dwh_plan_partie.figer_recalcul_prest_av_terme, il_dwh_plan_partie.propres_coti, il_dwh_plan_partie.int_propres_coti, il_dwh_plan_partie.propres_coti_prov, il_dwh_plan_partie.propres_coti_majorees, il_dwh_plan_partie.rachats, il_dwh_plan_partie.int_rachats, il_dwh_plan_partie.avoir_transfere, il_dwh_plan_partie.freq_paie_coti, il_dwh_plan_partie.description_frequence_paiement, il_dwh_plan_partie.surp_paie_frac_inclus, il_dwh_plan_partie.valorisable, il_dwh_plan_partie.dte_entree_theorique, il_dwh_plan_partie.dte_entree_av_va, il_dwh_plan_partie.dte_prevue_deb_inva, il_dwh_plan_partie.deduc_gar, il_dwh_plan_partie.deduc_gar_precedent, il_dwh_plan_partie.sal_cotisant_garanti, il_dwh_plan_partie.sal_cotisant_garanti_precedent, il_dwh_plan_partie.propres_coti_ord, il_dwh_plan_partie.propres_coti_maintien, il_dwh_plan_partie.part_suppltemp_rachats, il_dwh_plan_partie.rachats_sans_int, il_dwh_plan_partie.prest_sortie_gar_base, il_dwh_plan_partie.prop_coti_ord_prestsortgar, il_dwh_plan_partie.prop_coti_maint_prestsortgar, il_dwh_plan_partie.prop_coti_maj_prestsortgar, il_dwh_plan_partie.rachats_prestsortgar, il_dwh_plan_partie.vers_anticipes_prestsortgar, il_dwh_plan_partie.prct_capital_lpp_retraite, il_dwh_plan_partie.prest_payees, il_dwh_plan_partie.freq_paie_coti_figee, il_dwh_plan_partie.rachats_prevus, il_dwh_plan_partie.propo_rachats_id, il_dwh_plan_partie.rachat_unique_max, il_dwh_plan_partie.capital_retraite_max, il_dwh_plan_partie.rte_retraite_max, il_dwh_plan_partie.rachat_mens_max, il_dwh_plan_partie.rachat_unique_saisi, il_dwh_plan_partie.capital_retraite_rachat_unique, il_dwh_plan_partie.rte_retraite_rachat_unique, il_dwh_plan_partie.rachat_mens_saisi, il_dwh_plan_partie.capital_retraite_rachat_mens, il_dwh_plan_partie.rte_retraite_rachat_mens, il_dwh_plan_partie.capital_retraite_souhaite, il_dwh_plan_partie.rte_retraite_shtee, il_dwh_plan_partie.rachat_unique_retraite_shtee, il_dwh_plan_partie.rachat_mens_retraite_shtee, il_dwh_plan_partie.dn_mut_id, il_dwh_plan_partie.dn_dte_mut, il_dwh_plan_partie.dn_nom_mut, il_dwh_plan_partie.pro_id, il_dwh_plan_partie.part_suppltemp_rachat_prevu, il_dwh_plan_partie.rachat_prevu_prestsortgar, il_dwh_plan_partie.corrections_manuelles_primes, il_dwh_plan_partie.corrections_manuelles_prest, il_dwh_plan_partie.remb_va_prevus, il_dwh_plan_partie.part_suppltemp_remb_va_prevus, il_dwh_plan_partie.remb_va_prevus_prestsortgar, il_dwh_plan_partie.mnt_max_deb_ajournement, il_dwh_plan_partie.remb_va_a_recevoir, il_dwh_plan_partie.transitoire, il_dwh_plan_partie.max_rachetable_31_12, il_dwh_plan_partie.sal_min_1, il_dwh_plan_partie.sal_min_2, il_dwh_plan_partie.sal_max_1, il_dwh_plan_partie.sal_max_2, il_dwh_plan_partie.duree_gar_sal_retraite, il_dwh_plan_partie.duree_gar_sal_risque, il_dwh_plan_partie.duree_gar_sal_sortie, il_dwh_plan_partie.capital_retraite, il_dwh_plan_partie.correction_ps_rappel, il_dwh_plan_partie.plan_calcul_avant_terme, il_dwh_plan_partie.prct_cpt_pref_retraite, il_dwh_plan_partie.prct_cpt_exc_lp, il_dwh_plan_partie.pref_retraite, il_dwh_plan_partie.int_pref_retraite, il_dwh_plan_partie.excedents_lp, il_dwh_plan_partie.int_excedents_lp, il_dwh_plan_partie.usr_log_i, il_dwh_plan_partie.dte_log_i, il_dwh_plan_partie.usr_log_u, il_dwh_plan_partie.dte_log_u, il_dwh_plan_partie.cd_propres_coti_majorees_dat_ext, il_dwh_plan_partie.cd_propres_coti_majorees_fin_ann, il_dwh_plan_partie.cd_int_rachats_dat_ext, il_dwh_plan_partie.cd_int_rachats_fin_ann, il_dwh_plan_partie.cd_int_pref_retraite_dat_ext, il_dwh_plan_partie.cd_int_pref_retraite_fin_ann, il_dwh_plan_partie.cd_int_excedents_lp_dat_ext, il_dwh_plan_partie.cd_int_excedents_lp_fin_ann
  • Index Cond: (il_dwh_plan_partie.partie_dossier_id = il_dwh_partie_dossier.partie_dossier_id)
  • Filter: ((il_dwh_plan_partie.dl_datextract = '2020-01-01'::date) AND (il_dwh_plan_partie.dl_flg_inv = 1) AND (il_dwh_plan_partie.dl_flg_bcl = 1) AND (il_dwh_partie_dossier.dl_soc_id = il_dwh_plan_partie.dl_soc_id))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=409351
  • Worker 0: actual time=0.014..0.023 rows=3 loops=15553
  • Buffers: shared hit=101208
  • Worker 1: actual time=0.014..0.024 rows=3 loops=15770
  • Buffers: shared hit=104139
  • Worker 2: actual time=0.014..0.024 rows=3 loops=15515
  • Buffers: shared hit=101289
20. 452,835.061 452,835.061 ↑ 1.0 1 158,099 / 4

Index Scan using olm_il_dwh_cpt_epa_mouvement_perf_act_miv on bidwh.il_dwh_cpt_epa_mouvement (cost=0.56..1,262.10 rows=1 width=33) (actual time=8.955..11.457 rows=1 loops=158,099)

  • Output: il_dwh_cpt_epa_mouvement.dl_datextract, il_dwh_cpt_epa_mouvement.dl_soc_id, il_dwh_cpt_epa_mouvement.dl_flg_bcl, il_dwh_cpt_epa_mouvement.dl_flg_inv, il_dwh_cpt_epa_mouvement.cpt_epa_mouvement_id, il_dwh_cpt_epa_mouvement.plan_partie_id, il_dwh_cpt_epa_mouvement.nat_cpt_epa_id, il_dwh_cpt_epa_mouvement.partie_dossier_id, il_dwh_cpt_epa_mouvement.dossier_id, il_dwh_cpt_epa_mouvement.no_gen_dossier, il_dwh_cpt_epa_mouvement.dossier_gen_id, il_dwh_cpt_epa_mouvement.dte_mouvement, il_dwh_cpt_epa_mouvement.mouvement_mut, il_dwh_cpt_epa_mouvement.transfert_actif_pensionne, il_dwh_cpt_epa_mouvement.mnt_lpp, il_dwh_cpt_epa_mouvement.mnt_supplementaire, il_dwh_cpt_epa_mouvement.mnt_tot, il_dwh_cpt_epa_mouvement.nat, il_dwh_cpt_epa_mouvement.description_nature, il_dwh_cpt_epa_mouvement.porte_int, il_dwh_cpt_epa_mouvement.jour_deb_calc_int, il_dwh_cpt_epa_mouvement.dn_mut_id, il_dwh_cpt_epa_mouvement.dn_dte_mut, il_dwh_cpt_epa_mouvement.dn_nom_mut, il_dwh_cpt_epa_mouvement.type_plan, il_dwh_cpt_epa_mouvement.description_type_plan, il_dwh_cpt_epa_mouvement.usr_log_i, il_dwh_cpt_epa_mouvement.dte_log_i, il_dwh_cpt_epa_mouvement.usr_log_u, il_dwh_cpt_epa_mouvement.dte_log_u
  • Index Cond: ((il_dwh_plan_partie.dl_datextract = il_dwh_cpt_epa_mouvement.dl_datextract) AND (il_dwh_cpt_epa_mouvement.dl_datextract = '2020-01-01'::date) AND (il_dwh_plan_partie.dl_soc_id = il_dwh_cpt_epa_mouvement.dl_soc_id) AND (il_dwh_plan_partie.dl_flg_bcl = il_dwh_cpt_epa_mouvement.dl_flg_bcl) AND (il_dwh_cpt_epa_mouvement.dl_flg_bcl = 1) AND (il_dwh_plan_partie.dl_flg_inv = il_dwh_cpt_epa_mouvement.dl_flg_inv) AND (il_dwh_cpt_epa_mouvement.dl_flg_inv = 1) AND (il_dwh_plan_partie.plan_partie_id = il_dwh_cpt_epa_mouvement.plan_partie_id))
  • Buffers: shared hit=224719204
  • Worker 0: actual time=8.980..11.476 rows=1 loops=39406
  • Buffers: shared hit=56011034
  • Worker 1: actual time=8.930..11.421 rows=1 loops=39791
  • Buffers: shared hit=56557565
  • Worker 2: actual time=8.984..11.471 rows=1 loops=39389
  • Buffers: shared hit=55986622
Planning time : 10.685 ms
Execution time : 456,116.273 ms