explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fy3d : Distinct

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.226 ↑ 1.0 1 1

Unique (cost=75.42..77.59 rows=1 width=152,085) (actual time=1.221..1.226 rows=1 loops=1)

2. 0.837 1.225 ↑ 1.0 1 1

Sort (cost=75.42..75.42 rows=1 width=152,085) (actual time=1.220..1.225 rows=1 loops=1)

  • Sort Key: t_clititre1_.tit_ident, t_catprof2_.cat_ident, t_professi3_.pro_ident, t_naf4_.tnaf_ident, t_etabliss5_.ta_ident, t_societe6_.ta_code, f_p_c_clie7_.bpcl_ident, t_clifam8_.fam_ident, t_clisfam9_.sfa_ident, f_p_c_assu10_.bpass_ident, f_p_c_cnds16_.bpcnd_ident, f_p_c_corr11_.bpcor_ident, f_p_c_corr12_.bpcor_ident, f_intermed13_.in_ident, f_compagni14_.co_ident, f_p_c_user15_.bput_ident, f_p_person0_.bpp_anonymisee, f_p_person0_.bpp_anonym_date, f_p_person0_.bpp_anonym_ptrbputid, f_p_person0_.bpp_blocage_devis, f_p_person0_.bpp_blocage_pec, f_p_person0_.bpp_commentaire, f_p_person0_.bpp_comment_statut_centre, f_p_person0_.bpp_compatible_tns, f_p_person0_.bpp_contact, f_p_person0_.bpp_crt_date, f_p_person0_.bpp_date_certif, f_p_person0_.bpp_email, f_p_person0_.bpp_email_2, f_p_person0_.bpp_email_3, f_p_person0_.bpp_etablissement, f_p_person0_.bpp_exercice_fiscal, f_p_person0_.bpp_fisc_stat1, f_p_person0_.bpp_fisc_stat2, f_p_person0_.bpp_fisc_terr, f_p_person0_.bpp_fisc_tva_loc, f_p_person0_.bpp_fisc_tva_no, f_p_person0_.bpp_fisc_tva_ptrdom, f_p_person0_.bpp_fisc_tva_recup, f_p_person0_.bpp_gest_centralisee, f_p_person0_.bpp_int_lotexp, f_p_person0_.bpp_int_lotimp, f_p_person0_.bpp_langue_code, f_p_person0_.bpp_langue_libel, f_p_person0_.bpp_lib01, f_p_person0_.bpp_lib02, f_p_person0_.bpp_lib03, f_p_person0_.bpp_lib04, f_p_person0_.bpp_lib05, f_p_person0_.bpp_lib06, f_p_person0_.bpp_lib07, f_p_person0_.bpp_lib08, f_p_person0_.bpp_lib09, f_p_person0_.bpp_lib10, f_p_person0_.bpp_lib11, f_p_person0_.bpp_lib12, f_p_person0_.bpp_lib13, f_p_person0_.bpp_lib14, f_p_person0_.bpp_lib15, f_p_person0_.bpp_lib16, f_p_person0_.bpp_lib17, f_p_person0_.bpp_lib18, f_p_person0_.bpp_lib19, f_p_person0_.bpp_lib20, f_p_person0_.bpp_mailing, f_p_person0_.bpp_maj_date, f_p_person0_.bpp_maj_info, f_p_person0_.bpp_mke_com_courrier, f_p_person0_.bpp_mke_com_courrier_date, f_p_person0_.bpp_mke_com_mail, f_p_person0_.bpp_mke_com_mail_date, f_p_person0_.bpp_mke_com_sms, f_p_person0_.bpp_mke_com_sms_date, f_p_person0_.bpp_mki_com_courrier, f_p_person0_.bpp_mki_com_courrier_date, f_p_person0_.bpp_mki_com_mail, f_p_person0_.bpp_mki_com_mail_date, f_p_person0_.bpp_mki_com_sms, f_p_person0_.bpp_mki_com_sms_date, f_p_person0_.bpp_modele, f_p_person0_.bpp_moderegl, f_p_person0_.bpp_motif_blocage, f_p_person0_.bpp_motif_blocage_centre, f_p_person0_.bpp_motif_blocage_sousc, f_p_person0_.bpp_nir_certifie, f_p_person0_.bpp_nom_1, f_p_person0_.bpp_nom_2, f_p_person0_.bpp_nom_3, f_p_person0_.bpp_nom_alias, f_p_person0_.bpp_nom_appel, f_p_person0_.bpp_nom_tireur, f_p_person0_.bpp_no_societaire, f_p_person0_.bpp_password, f_p_person0_.bpp_pm_capital, f_p_person0_.bpp_pm_ca_tranche, f_p_person0_.bpp_pm_ca_valeur, f_p_person0_.bpp_pm_code_nic, f_p_person0_.bpp_pm_conv_col, f_p_person0_.bpp_pm_date_effet, f_p_person0_.bpp_pm_dest1, f_p_person0_.bpp_pm_dest1_email, f_p_person0_.bpp_pm_dest1_fonct, f_p_person0_.bpp_pm_dest1_tel, f_p_person0_.bpp_pm_dest2, f_p_person0_.bpp_pm_dest3, f_p_person0_.bpp_pm_dt_cess, f_p_person0_.bpp_pm_eff_nombre, f_p_person0_.bpp_pm_eff_tranche, f_p_person0_.bpp_pm_exclu_dsn, f_p_person0_.bpp_pm_formjur, f_p_person0_.bpp_pm_gerance, f_p_person0_.bpp_pm_notation, f_p_person0_.bpp_pm_no_ape, f_p_person0_.bpp_pm_no_nace, f_p_person0_.bpp_pm_no_siren, f_p_person0_.bpp_pm_no_siret, f_p_person0_.bpp_pp_active, f_p_person0_.bpp_pp_cible_menage, f_p_person0_.bpp_pp_cible_panier, f_p_person0_.bpp_pp_cle_social, f_p_person0_.bpp_pp_deces_date, f_p_person0_.bpp_pp_expose, f_p_person0_.bpp_pp_handicape, f_p_person0_.bpp_pp_mrgdvrc_date, f_p_person0_.bpp_pp_nais_date, f_p_person0_.bpp_pp_nais_dpt, f_p_person0_.bpp_pp_nais_pay_code, f_p_person0_.bpp_pp_nais_ville, f_p_person0_.bpp_pp_nais_vil_insee, f_p_person0_.bpp_pp_nationalite, f_p_person0_.bpp_pp_nb_enfants, f_p_person0_.bpp_pp_nom_jf, f_p_person0_.bpp_pp_no_identite, f_p_person0_.bpp_pp_no_social, f_p_person0_.bpp_pp_optmail, f_p_person0_.bpp_pp_rang_naiss, f_p_person0_.bpp_pp_rev_tranche, f_p_person0_.bpp_pp_rev_valeur, f_p_person0_.bpp_pp_sexe, f_p_person0_.bpp_pp_signalement, f_p_person0_.bpp_pp_synch, f_p_person0_.bpp_prod_com_courrier, f_p_person0_.bpp_prod_com_courrier_date, f_p_person0_.bpp_prod_com_mail, f_p_person0_.bpp_prod_com_mail_date, f_p_person0_.bpp_prod_com_sms, f_p_person0_.bpp_prod_com_sms_date, f_p_person0_.bpp_refecho, f_p_person0_.bpp_refexterne2, f_p_person0_.bpp_refexterne3, f_p_person0_.bpp_ref_externe, f_p_person0_.bpp_regime_salarie, f_p_person0_.bpp_reglt_bloque, f_p_person0_.bpp_repertoires, f_p_person0_.bpp_sin_com_courrier, f_p_person0_.bpp_sin_com_courrier_date, f_p_person0_.bpp_sin_com_mail, f_p_person0_.bpp_sin_com_mail_date, f_p_person0_.bpp_sin_com_sms, f_p_person0_.bpp_sin_com_sms_date, f_p_person0_.bpp_sin_period_edt, f_p_person0_.bpp_site_web, f_p_person0_.bpp_slidentif, f_p_person0_.bpp_sousc_bloque, f_p_person0_.bpp_statut_centre, f_p_person0_.bpp_structure, f_p_person0_.bpp_tel_1, f_p_person0_.bpp_tel_2, f_p_person0_.bpp_tel_3, f_p_person0_.bpp_tel_3_poste, f_p_person0_.bpp_tel_fax, f_p_person0_.bpp_tel_fax_2, f_p_person0_.bpp_tel_telex, f_p_person0_.bpp_type, f_p_person0_.bpp_type_juridique, f_p_person0_.bpp_vip, f_p_person0_.bpp_vip_statut, f_p_person0_.bpp_devise, f_p_person0_.bpp_ptr_inident, f_p_person0_.bpp_crt_user, f_p_person0_.bpp_maj_user, f_p_person0_.bpp_ptrcatid, f_p_person0_.bpp_ptrcatsecid, f_p_person0_.bpp_ptrccnid, f_p_person0_.bpp_ptrcliid, f_p_person0_.bpp_ptretabident, f_p_person0_.bpp_pm_ptrmtprid, f_p_person0_.bpp_ptrtnafid, f_p_person0_.bpp_ptrtpegid, f_p_person0_.bpp_ptrproid, f_p_person0_.bpp_ptrrsoid, f_p_person0_.bpp_ptrmarid, f_p_person0_.bpp_societe, t_clititre1_.tit_code, t_clititre1_.tit_interface_1, t_clititre1_.tit_interface_2, t_clititre1_.tit_interface_3, t_clititre1_.tit_libelle2, t_clititre1_.tit_presence, t_clititre1_.tit_codesociete, t_catprof2_.cat_code, t_catprof2_.cat_libelle2, t_catprof2_.cat_codesociete, t_professi3_.pro_code, t_professi3_.pro_libelle1, t_professi3_.pro_libelle2, t_professi3_.pro_codesociete, t_naf4_.tnaf_code, t_naf4_.tnaf_libelle, t_etabliss5_.ta_cle, t_etabliss5_.ta_code, t_etabliss5_.ta_code_sage, t_etabliss5_.ta_ecart_charge, t_etabliss5_.ta_ecart_produi, t_etabliss5_.ta_ecart_seuilp, t_etabliss5_.ta_ecart_seuilv, t_etabliss5_.ta_email, t_etabliss5_.ta_gere_offre, t_etabliss5_.ta_gestion_ecart, t_etabliss5_.ta_indice_v1, t_etabliss5_.ta_indice_v11, t_etabliss5_.ta_indice_v12, t_etabliss5_.ta_lib01, t_etabliss5_.ta_lib02, t_etabliss5_.ta_lib03, t_etabliss5_.ta_lib04, t_etabliss5_.ta_lib05, t_etabliss5_.ta_lib06, t_etabliss5_.ta_lib07, t_etabliss5_.ta_lib08, t_etabliss5_.ta_lib09, t_etabliss5_.ta_lib10, t_etabliss5_.ta_libelle1, t_etabliss5_.ta_libelle2, t_etabliss5_.ta_libelle3, t_etabliss5_.ta_libstat1, t_etabliss5_.ta_pp_charge, t_etabliss5_.ta_pp_produit, t_etabliss5_.ta_socie_adres1, t_etabliss5_.ta_socie_adres2, t_etabliss5_.ta_socie_codpos, t_etabliss5_.ta_socie_locali, t_etabliss5_.ta_socie_siren, t_etabliss5_.ta_socie_siret, t_etabliss5_.ta_socie_teleco, t_etabliss5_.ta_socie_teleph, t_etabliss5_.ta_socie_telex, t_etabliss5_.ta_socie_ville, t_etabliss5_.ta_tvava1tx3, t_etabliss5_.ta_tvaval1tx1, t_etabliss5_.ta_tvaval1tx2, t_etabliss5_.ta_tvaval1tx3, t_etabliss5_.ta_ptrpaid, t_etabliss5_.ta_libstat2, t_etabliss5_.ta_codesociete, t_etabliss5_.ta_ptrtdilvid, t_societe6_.ta_auxavo_max, t_societe6_.ta_auxcie_max, t_societe6_.ta_auxcie_ratt, t_societe6_.ta_auxcie_rtma, t_societe6_.ta_auxcli_max, t_societe6_.ta_auxcli_ratt, t_societe6_.ta_auxcli_rtma, t_societe6_.ta_auxexp_max, t_societe6_.ta_auxexp_ratt, t_societe6_.ta_auxexp_rtma, t_societe6_.ta_auxfou_max, t_societe6_.ta_auxfou_ratt, t_societe6_.ta_auxfou_rtma, t_societe6_.ta_auxint_max, t_societe6_.ta_auxint_ratt, t_societe6_.ta_auxint_rtma, t_societe6_.ta_auxper_max, t_societe6_.ta_auxper_ratt, t_societe6_.ta_auxper_rtma, t_societe6_.ta_auxrea_max, t_societe6_.ta_auxrea_ratt, t_societe6_.ta_aux_auto, t_societe6_.ta_borrev_max, t_societe6_.ta_chgt_chgcpt, t_societe6_.ta_clois_etab, t_societe6_.ta_code_etabl, t_societe6_.ta_code_nic, t_societe6_.ta_cpt_auxavo, t_societe6_.ta_cpt_auxcie, t_societe6_.ta_cpt_auxexp, t_societe6_.ta_cpt_auxfou, t_societe6_.ta_cpt_auxint, t_societe6_.ta_cpt_auxper, t_societe6_.ta_cpt_auxrea, t_societe6_.ta_ctp_auxcli, t_societe6_.ta_date_taxe, t_societe6_.ta_ecart_charge, t_societe6_.ta_ecart_produi, t_societe6_.ta_ecart_seuilp, t_societe6_.ta_ecart_seuilv, t_societe6_.ta_etat, t_societe6_.ta_fastclose, t_societe6_.ta_fccli_nmax, t_societe6_.ta_gestprime_annul_imput, t_societe6_.ta_gest_prospects, t_societe6_.ta_gest_statut_rib, t_societe6_.ta_indice_v11, t_societe6_.ta_indice_v12, t_societe6_.ta_libelle1, t_societe6_.ta_libelle2, t_societe6_.ta_libelle3, t_societe6_.ta_libelle4, t_societe6_.ta_libelle5, t_societe6_.ta_modele11, t_societe6_.ta_modele12, t_societe6_.ta_modele13, t_societe6_.ta_modele15, t_societe6_.ta_modele16, t_societe6_.ta_modele34, t_societe6_.ta_modele35, t_societe6_.ta_multidevise, t_societe6_.ta_numutil, t_societe6_.ta_options, t_societe6_.ta_option_debit, t_societe6_.ta_pp_charge, t_societe6_.ta_pp_produit, t_societe6_.ta_prof_charge, t_societe6_.ta_prof_ecartp, t_societe6_.ta_prof_ecartv, t_societe6_.ta_prof_prod, t_societe6_.ta_regle01, t_societe6_.ta_regle02, t_societe6_.ta_regle03, t_societe6_.ta_regle04, t_societe6_.ta_regle05, t_societe6_.ta_relations_users, t_societe6_.ta_socie_adres1, t_societe6_.ta_socie_adres2, t_societe6_.ta_socie_ape, t_societe6_.ta_socie_capita, t_societe6_.ta_socie_codpos, t_societe6_.ta_socie_formju, t_societe6_.ta_socie_locali, t_societe6_.ta_socie_rcs, t_societe6_.ta_socie_siren, t_societe6_.ta_socie_siret, t_societe6_.ta_socie_teleco, t_societe6_.ta_socie_teleph, t_societe6_.ta_socie_telex, t_societe6_.ta_socie_ville, t_societe6_.ta_taillecar, t_societe6_.ta_type_imp, t_societe6_.ta_valid_auto, t_societe6_.ta_versionchgt_chgcpt, t_societe6_.ta_modele14, t_societe6_.ta_ptrinident, t_societe6_.ta_ptrmcid_dtfincom, t_societe6_.ta_ptrpaid, f_p_c_clie7_.bpcl_cle, f_p_c_clie7_.bpcl_code_auxil, f_p_c_clie7_.bpcl_comp_prmsin, f_p_c_clie7_.bpcl_cote, f_p_c_clie7_.bpcl_crt_date, f_p_c_clie7_.bpcl_date_clo_cpt, f_p_c_clie7_.bpcl_date_ouv_cpt, f_p_c_clie7_.bpcl_dat_excl_recouvr, f_p_c_clie7_.bpcl_decalage_paie, f_p_c_clie7_.bpcl_decalage_paie_type, f_p_c_clie7_.bpcl_derog_eche, f_p_c_clie7_.bpcl_frequence_decais, f_p_c_clie7_.bpcl_g_cptaux_derog, f_p_c_clie7_.bpcl_g_moderegl, f_p_c_clie7_.bpcl_g_recouv_derog, f_p_c_clie7_.bpcl_g_tauxremise, f_p_c_clie7_.bpcl_g_type_prel, f_p_c_clie7_.bpcl_int_ident_dpt, f_p_c_clie7_.bpcl_int_lotexp, f_p_c_clie7_.bpcl_int_lotimp, f_p_c_clie7_.bpcl_jour_prelevement, f_p_c_clie7_.bpcl_lib01, f_p_c_clie7_.bpcl_lib02, f_p_c_clie7_.bpcl_lib03, f_p_c_clie7_.bpcl_lib04, f_p_c_clie7_.bpcl_lib05, f_p_c_clie7_.bpcl_lib06, f_p_c_clie7_.bpcl_lib07, f_p_c_clie7_.bpcl_lib08, f_p_c_clie7_.bpcl_lib09, f_p_c_clie7_.bpcl_lib10, f_p_c_clie7_.bpcl_lib11, f_p_c_clie7_.bpcl_lib12, f_p_c_clie7_.bpcl_lib13, f_p_c_clie7_.bpcl_lib14, f_p_c_clie7_.bpcl_lib15, f_p_c_clie7_.bpcl_lib16, f_p_c_clie7_.bpcl_lib17, f_p_c_clie7_.bpcl_lib18, f_p_c_clie7_.bpcl_lib19, f_p_c_clie7_.bpcl_lib20, f_p_c_clie7_.bpcl_lib21, f_p_c_clie7_.bpcl_lib22, f_p_c_clie7_.bpcl_lib23, f_p_c_clie7_.bpcl_lib24, f_p_c_clie7_.bpcl_lib25, f_p_c_clie7_.bpcl_lib26, f_p_c_clie7_.bpcl_lib27, f_p_c_clie7_.bpcl_lib28, f_p_c_clie7_.bpcl_lib29, f_p_c_clie7_.bpcl_lib30, f_p_c_clie7_.bpcl_lib31, f_p_c_clie7_.bpcl_lib32, f_p_c_clie7_.bpcl_lib33, f_p_c_clie7_.bpcl_lib34, f_p_c_clie7_.bpcl_lib35, f_p_c_clie7_.bpcl_lib36, f_p_c_clie7_.bpcl_lib37, f_p_c_clie7_.bpcl_lib38, f_p_c_clie7_.bpcl_lib39, f_p_c_clie7_.bpcl_lib40, f_p_c_clie7_.bpcl_lib41, f_p_c_clie7_.bpcl_lib42, f_p_c_clie7_.bpcl_lib43, f_p_c_clie7_.bpcl_lib44, f_p_c_clie7_.bpcl_lib45, f_p_c_clie7_.bpcl_lib46, f_p_c_clie7_.bpcl_lib47, f_p_c_clie7_.bpcl_lib48, f_p_c_clie7_.bpcl_lib49, f_p_c_clie7_.bpcl_lib50, f_p_c_clie7_.bpcl_maj_date, f_p_c_clie7_.bpcl_mod_dec_dadsu, f_p_c_clie7_.bpcl_mot_excl_recouvr, f_p_c_clie7_.bpcl_nb_ech, f_p_c_clie7_.bpcl_nonregroup_decais, f_p_c_clie7_.bpcl_refecho, f_p_c_clie7_.bpcl_regcpt, f_p_c_clie7_.bpcl_regcpt_pr, f_p_c_clie7_.bpcl_r_coll_com, f_p_c_clie7_.bpcl_r_coll_cpt, f_p_c_clie7_.bpcl_r_regroup1, f_p_c_clie7_.bpcl_r_regroup2, f_p_c_clie7_.bpcl_r_regroup3, f_p_c_clie7_.bpcl_r_secteur, f_p_c_clie7_.bpcl_ptrbpaident, f_p_c_clie7_.bpcl_ptrbpbident, f_p_c_clie7_.bpcl_ptrchgcptid, f_p_c_clie7_.bpcl_crt_user, f_p_c_clie7_.bpcl_maj_user, f_p_c_clie7_.bpcl_ptrbppident, f_p_c_clie7_.bpcl_ptrribident, f_p_c_clie7_.bpcl_ptrfamid, f_p_c_clie7_.bpcl_ptrsfaid, f_p_c_clie7_.bpcl_ptrtrpaid, t_clifam8_.fam_code, t_clifam8_.fam_libelle2, t_clifam8_.fam_codesociete, t_clisfam9_.sfa_code, t_clisfam9_.sfa_libelle2, t_clisfam9_.sfa_ptrfamid, t_clisfam9_.sfa_codesociete, f_p_c_assu10_.bpass_code_auxil, f_p_c_assu10_.bpass_crt_date, f_p_c_assu10_.bpass_date_derniere_noemie, f_p_c_assu10_.bpass_int_lotexp, f_p_c_assu10_.bpass_int_lotimp, f_p_c_assu10_.bpass_lib01, f_p_c_assu10_.bpass_lib02, f_p_c_assu10_.bpass_lib03, f_p_c_assu10_.bpass_lib04, f_p_c_assu10_.bpass_lib05, f_p_c_assu10_.bpass_lib06, f_p_c_assu10_.bpass_lib07, f_p_c_assu10_.bpass_lib08, f_p_c_assu10_.bpass_lib09, f_p_c_assu10_.bpass_lib10, f_p_c_assu10_.bpass_lib11, f_p_c_assu10_.bpass_lib12, f_p_c_assu10_.bpass_lib13, f_p_c_assu10_.bpass_lib14, f_p_c_assu10_.bpass_lib15, f_p_c_assu10_.bpass_lib16, f_p_c_assu10_.bpass_lib17, f_p_c_assu10_.bpass_lib18, f_p_c_assu10_.bpass_lib19, f_p_c_assu10_.bpass_lib20, f_p_c_assu10_.bpass_maj_date, f_p_c_assu10_.bpass_numero, f_p_c_assu10_.bpass_refecho, f_p_c_assu10_.bpass_ref_externe, f_p_c_assu10_.bpass_service, f_p_c_assu10_.bpass_statut_noemie, f_p_c_assu10_.bpass_ptrbpaident, f_p_c_assu10_.bpass_ptrbpbident, f_p_c_assu10_.bpass_crt_user, f_p_c_assu10_.bpass_maj_user, f_p_c_assu10_.bpass_ptrbppident, f_p_c_assu10_.bpass_ptrribident, f_p_c_cnds16_.bpcnd_int_lot_exp, f_p_c_cnds16_.bpcnd_int_lot_imp, f_p_c_cnds16_.bpcnd_nbenfant, f_p_c_cnds16_.bpcnd_perdtfin, f_p_c_cnds16_.bpcnd_per_2_date, f_p_c_cnds16_.bpcnd_per_categ, f_p_c_cnds16_.bpcnd_per_date, f_p_c_cnds16_.bpcnd_per_dept, f_p_c_cnds16_.bpcnd_per_numero, f_p_c_cnds16_.bpcnd_per_pref, f_p_c_cnds16_.bpcnd_refecho, f_p_c_cnds16_.bpcnd_services, f_p_c_cnds16_.bpcnd_ptrbpassid, f_p_c_corr11_.bpcor_codeauxil, f_p_c_corr11_.bpcor_compta_rgpt, f_p_c_corr11_.bpcor_cote, f_p_c_corr11_.bpcor_cpte_mvt_financier, f_p_c_corr11_.bpcor_crial1, f_p_c_corr11_.bpcor_crial2, f_p_c_corr11_.bpcor_datedeb, f_p_c_corr11_.bpcor_datefin, f_p_c_corr11_.bpcor_date_paiement, f_p_c_corr11_.bpcor_delegation_or, f_p_c_corr11_.bpcor_gestion_code_amc, f_p_c_corr11_.bpcor_g_cptaux_derog, f_p_c_corr11_.bpcor_int_lotexp, f_p_c_corr11_.bpcor_int_lotimp, f_p_c_corr11_.bpcor_jour_rgt, f_p_c_corr11_.bpcor_lib01, f_p_c_corr11_.bpcor_lib02, f_p_c_corr11_.bpcor_lib03, f_p_c_corr11_.bpcor_lib04, f_p_c_corr11_.bpcor_lib05, f_p_c_corr11_.bpcor_lib06, f_p_c_corr11_.bpcor_lib07, f_p_c_corr11_.bpcor_lib08, f_p_c_corr11_.bpcor_lib09, f_p_c_corr11_.bpcor_lib10, f_p_c_corr11_.bpcor_lib11, f_p_c_corr11_.bpcor_lib12, f_p_c_corr11_.bpcor_lib13, f_p_c_corr11_.bpcor_lib14, f_p_c_corr11_.bpcor_lib15, f_p_c_corr11_.bpcor_lib16, f_p_c_corr11_.bpcor_lib17, f_p_c_corr11_.bpcor_lib18, f_p_c_corr11_.bpcor_lib19, f_p_c_corr11_.bpcor_lib20, f_p_c_corr11_.bpcor_lib21, f_p_c_corr11_.bpcor_lib22, f_p_c_corr11_.bpcor_lib23, f_p_c_corr11_.bpcor_lib24, f_p_c_corr11_.bpcor_lib25, f_p_c_corr11_.bpcor_lib26, f_p_c_corr11_.bpcor_lib27, f_p_c_corr11_.bpcor_lib28, f_p_c_corr11_.bpcor_lib29, f_p_c_corr11_.bpcor_lib30, f_p_c_corr11_.bpcor_moderegl, f_p_c_corr11_.bpcor_nature, f_p_c_corr11_.bpcor_numero, f_p_c_corr11_.bpcor_num_client, f_p_c_corr11_.bpcor_num_omc, f_p_c_corr11_.bpcor_num_rpps, f_p_c_corr11_.bpcor_num_sequence, f_p_c_corr11_.bpcor_partenaire, f_p_c_corr11_.bpcor_periodicite, f_p_c_corr11_.bpcor_refecho, f_p_c_corr11_.bpcor_refexterne, f_p_c_corr11_.bpcor_rglt_edi, f_p_c_corr11_.bpcor_zone_geo, f_p_c_corr11_.bpcor_zone_prestataire, f_p_c_corr11_.bpcor_ptrbpaident, f_p_c_corr11_.bpcor_ptrbpbident, f_p_c_corr11_.bpcor_ptrbppident, f_p_c_corr11_.bpcor_ptrribident, f_p_c_corr11_.bpcor_ptrjnid, f_p_c_corr11_.bpcor_ptrmcarid, f_p_c_corr11_.bpcor_ptrtmtpid, f_p_c_corr11_.bpcor_ptrmcerid, f_p_c_corr11_.bpcor_ptrtmcrpid, f_p_c_corr11_.bpcor_ptrtmcid_adrcomp, f_p_c_corr11_.bpcor_ptrtmcid_adrnum, f_p_c_corr11_.bpcor_ptrtmcid_adrrue, f_p_c_corr11_.bpcor_ptrtsiaident, f_p_c_corr11_.bpcor_ptrtypident, f_p_c_corr12_.bpcor_codeauxil, f_p_c_corr12_.bpcor_compta_rgpt, f_p_c_corr12_.bpcor_cote, f_p_c_corr12_.bpcor_cpte_mvt_financier, f_p_c_corr12_.bpcor_crial1, f_p_c_corr12_.bpcor_crial2, f_p_c_corr12_.bpcor_datedeb, f_p_c_corr12_.bpcor_datefin, f_p_c_corr12_.bpcor_date_paiement, f_p_c_corr12_.bpcor_delegation_or, f_p_c_corr12_.bpcor_gestion_code_amc, f_p_c_corr12_.bpcor_g_cptaux_derog, f_p_c_corr12_.bpcor_int_lotexp, f_p_c_corr12_.bpcor_int_lotimp, f_p_c_corr12_.bpcor_jour_rgt, f_p_c_corr12_.bpcor_lib01, f_p_c_corr12_.bpcor_lib02, f_p_c_corr12_.bpcor_lib03, f_p_c_corr12_.bpcor_lib04, f_p_c_corr12_.bpcor_lib05, f_p_c_corr12_.bpcor_lib06, f_p_c_corr12_.bpcor_lib07, f_p_c_corr12_.bpcor_lib08, f_p_c_corr12_.bpcor_lib09, f_p_c_corr12_.bpcor_lib10, f_p_c_corr12_.bpcor_lib11, f_p_c_corr12_.bpcor_lib12, f_p_c_corr12_.bpcor_lib13, f_p_c_corr12_.bpcor_lib14, f_p_c_corr12_.bpcor_lib15, f_p_c_corr12_.bpcor_lib16, f_p_c_corr12_.bpcor_lib17, f_p_c_corr12_.bpcor_lib18, f_p_c_corr12_.bpcor_lib19, f_p_c_corr12_.bpcor_lib20, f_p_c_corr12_.bpcor_lib21, f_p_c_corr12_.bpcor_lib22, f_p_c_corr12_.bpcor_lib23, f_p_c_corr12_.bpcor_lib24, f_p_c_corr12_.bpcor_lib25, f_p_c_corr12_.bpcor_lib26, f_p_c_corr12_.bpcor_lib27, f_p_c_corr12_.bpcor_lib28, f_p_c_corr12_.bpcor_lib29, f_p_c_corr12_.bpcor_lib30, f_p_c_corr12_.bpcor_moderegl, f_p_c_corr12_.bpcor_nature, f_p_c_corr12_.bpcor_numero, f_p_c_corr12_.bpcor_num_client, f_p_c_corr12_.bpcor_num_omc, f_p_c_corr12_.bpcor_num_rpps, f_p_c_corr12_.bpcor_num_sequence, f_p_c_corr12_.bpcor_partenaire, f_p_c_corr12_.bpcor_periodicite, f_p_c_corr12_.bpcor_refecho, f_p_c_corr12_.bpcor_refexterne, f_p_c_corr12_.bpcor_rglt_edi, f_p_c_corr12_.bpcor_zone_geo, f_p_c_corr12_.bpcor_zone_prestataire, f_p_c_corr12_.bpcor_ptrbpaident, f_p_c_corr12_.bpcor_ptrbpbident, f_p_c_corr12_.bpcor_ptrbppident, f_p_c_corr12_.bpcor_ptrribident, f_p_c_corr12_.bpcor_ptrjnid, f_p_c_corr12_.bpcor_ptrmcarid, f_p_c_corr12_.bpcor_ptrtmtpid, f_p_c_corr12_.bpcor_ptrmcerid, f_p_c_corr12_.bpcor_ptrtmcrpid, f_p_c_corr12_.bpcor_ptrtmcid_adrcomp, f_p_c_corr12_.bpcor_ptrtmcid_adrnum, f_p_c_corr12_.bpcor_ptrtmcid_adrrue, f_p_c_corr12_.bpcor_ptrtsiaident, f_p_c_corr12_.bpcor_ptrtypident, f_intermed13_.in_autorisation, f_intermed13_.in_categorie, f_intermed13_.in_cca, f_intermed13_.in_code, f_intermed13_.in_code_etat, f_intermed13_.in_commission01, f_intermed13_.in_cote, f_intermed13_.in_cptaux, f_intermed13_.in_cptaux_derog, f_intermed13_.in_datdebcompte, f_intermed13_.in_datecreation, f_intermed13_.in_datemodif, f_intermed13_.in_datfincompte, f_intermed13_.in_derog_recouv, f_intermed13_.in_encaiss_conf, f_intermed13_.in_encconf_non, f_intermed13_.in_en_gerance, f_intermed13_.in_garfi, f_intermed13_.in_garficie, f_intermed13_.in_garfidatdeb, f_intermed13_.in_garfidatfin, f_intermed13_.in_garfinumpol, f_intermed13_.in_gestion_directe, f_intermed13_.in_jour_rgt, f_intermed13_.in_lib01, f_intermed13_.in_lib02, f_intermed13_.in_lib03, f_intermed13_.in_lib04, f_intermed13_.in_lib05, f_intermed13_.in_lib06, f_intermed13_.in_lib07, f_intermed13_.in_lib08, f_intermed13_.in_lib09, f_intermed13_.in_lib10, f_intermed13_.in_lib11, f_intermed13_.in_lib12, f_intermed13_.in_lib13, f_intermed13_.in_lib14, f_intermed13_.in_lib15, f_intermed13_.in_lib16, f_intermed13_.in_lib17, f_intermed13_.in_lib18, f_intermed13_.in_lib19, f_intermed13_.in_lib20, f_intermed13_.in_lib21, f_intermed13_.in_lib22, f_intermed13_.in_lib23, f_intermed13_.in_lib24, f_intermed13_.in_lib25, f_intermed13_.in_lib26, f_intermed13_.in_lib27, f_intermed13_.in_lib28, f_intermed13_.in_lib29, f_intermed13_.in_lib30, f_intermed13_.in_lib31, f_intermed13_.in_lib32, f_intermed13_.in_lib33, f_intermed13_.in_lib34, f_intermed13_.in_lib35, f_intermed13_.in_lib36, f_intermed13_.in_lib37, f_intermed13_.in_lib38, f_intermed13_.in_lib39, f_intermed13_.in_lib40, f_intermed13_.in_lib41, f_intermed13_.in_lib42, f_intermed13_.in_lot_exp, f_intermed13_.in_lot_imp, f_intermed13_.in_modereg, f_intermed13_.in_motif_fin, f_intermed13_.in_noclient, f_intermed13_.in_numauto, f_intermed13_.in_orias_immat, f_intermed13_.in_orias_inscrip, f_intermed13_.in_pf_prorata_com, f_intermed13_.in_rcpro, f_intermed13_.in_rcprocie, f_intermed13_.in_rcprodatdeb, f_intermed13_.in_rcprodatfin, f_intermed13_.in_rcpronumpol, f_intermed13_.in_refcho, f_intermed13_.in_registre_com, f_intermed13_.in_regroup1, f_intermed13_.in_repartition, f_intermed13_.in_resp, f_intermed13_.in_respcompta, f_intermed13_.in_respprod, f_intermed13_.in_respsinis, f_intermed13_.in_resp_prenom, f_intermed13_.in_retro_cn, f_intermed13_.in_retro_pn, f_intermed13_.in_rgl_comm, f_intermed13_.in_rib_nombnq, f_intermed13_.in_sequentiel, f_intermed13_.in_services, f_intermed13_.in_slreglecom01, f_intermed13_.in_slreglecom02, f_intermed13_.in_slreglecom03, f_intermed13_.in_slsolde, f_intermed13_.in_sl_code, f_intermed13_.in_sl_superieur, f_intermed13_.in_stop_majo, f_intermed13_.in_stop_paiement, f_intermed13_.in_stop_reversement, f_intermed13_.in_type, f_intermed13_.in_zonecom, f_intermed13_.in_ptrcie1, f_intermed13_.in_ptrcie2, f_intermed13_.in_ptrcie3, f_intermed13_.in_ptrciegf, f_intermed13_.in_ptrciercp, f_intermed13_.in_ptrdevcode, f_intermed13_.in_ptruser, f_intermed13_.in_utilcreateur, f_intermed13_.in_utilmodif, f_intermed13_.in_ptrbppident, f_intermed13_.in_ptrjnident_cca, f_compagni14_.co_cd_guichet, f_compagni14_.co_cd_mut, f_compagni14_.co_cle_mut, f_compagni14_.co_codeauxil, f_compagni14_.co_codeauxil_derog, f_compagni14_.co_codebcr, f_compagni14_.co_codegta, f_compagni14_.co_codeventes, f_compagni14_.co_code_cca, f_compagni14_.co_code_court, f_compagni14_.co_code_org_dadsu, f_compagni14_.co_codutcre, f_compagni14_.co_codutmaj, f_compagni14_.co_complementaire, f_compagni14_.co_cote, f_compagni14_.co_cpte_idain_for, f_compagni14_.co_cpte_idain_rel, f_compagni14_.co_cpte_idaout_for, f_compagni14_.co_cpte_idaout_rel, f_compagni14_.co_datcre, f_compagni14_.co_datdeb_activ, f_compagni14_.co_datdeb_cidre, f_compagni14_.co_datdeb_ida, f_compagni14_.co_datfin_activ, f_compagni14_.co_datfin_cidre, f_compagni14_.co_datfin_ida, f_compagni14_.co_datmaj, f_compagni14_.co_famille, f_compagni14_.co_federation, f_compagni14_.co_formjur, f_compagni14_.co_int_lot_exp, f_compagni14_.co_int_lot_imp, f_compagni14_.co_lib01, f_compagni14_.co_lib02, f_compagni14_.co_lib03, f_compagni14_.co_lib04, f_compagni14_.co_lib05, f_compagni14_.co_lib06, f_compagni14_.co_lib07, f_compagni14_.co_lib08, f_compagni14_.co_lib09, f_compagni14_.co_lib10, f_compagni14_.co_modereg, f_compagni14_.co_nature, f_compagni14_.co_nobordereau, f_compagni14_.co_numexterne, f_compagni14_.co_refecho, f_compagni14_.co_regroup1, f_compagni14_.co_regroup2, f_compagni14_.co_regroup3, f_compagni14_.co_sequentiel, f_compagni14_.co_services, f_compagni14_.co_slidentif, f_compagni14_.co_slnoemetteur, f_compagni14_.co_tax_rev, f_compagni14_.co_gestsin, f_compagni14_.co_ptrbppident, f_p_c_user15_.bput_activite, f_p_c_user15_.bput_auth_tech, f_p_c_user15_.bput_clois_eta, f_p_c_user15_.bput_date_locked, f_p_c_user15_.bput_date_login, f_p_c_user15_.bput_droit_prioritaire, f_p_c_user15_.bput_encoded, f_p_c_user15_.bput_etablissement, f_p_c_user15_.bput_externe, f_p_c_user15_.bput_fictif, f_p_c_user15_.bput_groupe, f_p_c_user15_.bput_ident_externe, f_p_c_user15_.bput_lib01, f_p_c_user15_.bput_lib02, f_p_c_user15_.bput_lib03, f_p_c_user15_.bput_lib04, f_p_c_user15_.bput_lib05, f_p_c_user15_.bput_lib06, f_p_c_user15_.bput_lib07, f_p_c_user15_.bput_lib08, f_p_c_user15_.bput_lib09, f_p_c_user15_.bput_lib10, f_p_c_user15_.bput_licence, f_p_c_user15_.bput_login, f_p_c_user15_.bput_login_externe, f_p_c_user15_.bput_multi_societe, f_p_c_user15_.bput_obj_eta, f_p_c_user15_.bput_password, f_p_c_user15_.bput_profil, f_p_c_user15_.bput_timetoidle, f_p_c_user15_.bput_timetolive, f_p_c_user15_.bput_ptrapid, f_p_c_user15_.bput_ptrinid, f_p_c_user15_.bput_ptrbpclid, f_p_c_user15_.bput_resp_bputid, f_p_c_user15_.bput_ptrbppid, f_p_c_user15_.bput_ptrgrprid, f_p_c_user15_.bput_ptrtaid, f_p_c_user15_.bput_societe, f_p_c_user15_.bput_ptrtdiv
  • Sort Method: quicksort Memory: 25kB
3. 0.027 0.388 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.31..75.41 rows=1 width=152,085) (actual time=0.379..0.388 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_user15_.bput_ptrbppid)
4. 0.025 0.353 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.31..74.08 rows=1 width=144,975) (actual time=0.345..0.353 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_compagni14_.co_ptrbppident)
5. 0.022 0.324 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.31..73.06 rows=1 width=137,363) (actual time=0.316..0.324 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_intermed13_.in_ptrbppident)
6. 0.020 0.293 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..64.90 rows=1 width=112,023) (actual time=0.286..0.293 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_corr12_.bpcor_ptrbppident)
7. 0.016 0.272 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..54.89 rows=1 width=94,991) (actual time=0.265..0.272 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_corr11_.bpcor_ptrbppident)
8. 0.015 0.254 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..44.88 rows=1 width=77,959) (actual time=0.247..0.254 rows=1 loops=1)

  • Join Filter: (f_p_c_assu10_.bpass_ident = f_p_c_cnds16_.bpcnd_ptrbpassid)
  • Rows Removed by Join Filter: 1
9. 0.015 0.236 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..43.86 rows=1 width=76,975) (actual time=0.229..0.236 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_assu10_.bpass_ptrbppident)
10. 0.014 0.215 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.18..42.83 rows=1 width=65,545) (actual time=0.208..0.215 rows=1 loops=1)

11. 0.015 0.196 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..34.55 rows=1 width=65,009) (actual time=0.190..0.196 rows=1 loops=1)

  • Join Filter: (f_p_c_clie7_.bpcl_ptrfamid = t_clifam8_.fam_ident)
  • Rows Removed by Join Filter: 26
12. 0.013 0.171 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..32.97 rows=1 width=64,491) (actual time=0.165..0.171 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ident = f_p_c_clie7_.bpcl_ptrbppident)
13. 0.014 0.154 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..31.94 rows=1 width=37,311) (actual time=0.148..0.154 rows=1 loops=1)

  • Join Filter: ((f_p_person0_.bpp_societe)::text = (t_societe6_.ta_code)::text)
  • Rows Removed by Join Filter: 2
14. 0.011 0.135 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..30.88 rows=1 width=30,281) (actual time=0.130..0.135 rows=1 loops=1)

  • Join Filter: (f_p_person0_.bpp_ptrcatid = t_catprof2_.cat_ident)
  • Rows Removed by Join Filter: 29
15. 0.007 0.119 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.04..29.22 rows=1 width=29,763) (actual time=0.114..0.119 rows=1 loops=1)

16. 0.007 0.107 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.90..19.61 rows=1 width=21,687) (actual time=0.102..0.107 rows=1 loops=1)

17. 0.008 0.096 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.62..11.31 rows=1 width=21,630) (actual time=0.092..0.096 rows=1 loops=1)

18. 0.043 0.082 ↑ 1.0 1 1

Hash Right Join (cost=1.35..2.98 rows=1 width=21,450) (actual time=0.078..0.082 rows=1 loops=1)

  • Hash Cond: (t_clititre1_.tit_ident = f_p_person0_.bpp_ptrcliid)
19. 0.007 0.007 ↑ 1.0 49 1

Seq Scan on t_clititre t_clititre1_ (cost=0.00..1.49 rows=49 width=708) (actual time=0.004..0.007 rows=49 loops=1)

20. 0.007 0.032 ↑ 1.0 1 1

Hash (cost=1.34..1.34 rows=1 width=20,742) (actual time=0.031..0.032 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
21. 0.025 0.025 ↑ 1.0 1 1

Seq Scan on f_p_personne f_p_person0_ (cost=0.00..1.34 rows=1 width=20,742) (actual time=0.024..0.025 rows=1 loops=1)

  • Filter: (bpp_ident = '1'::numeric)
  • Rows Removed by Filter: 26
22. 0.006 0.006 ↓ 0.0 0 1

Index Scan using pk_pro_ident on t_profession t_professi3_ (cost=0.27..8.29 rows=1 width=180) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (pro_ident = f_p_person0_.bpp_ptrproid)
23. 0.004 0.004 ↓ 0.0 0 1

Index Scan using pk_tnaf_ident on t_naf t_naf4_ (cost=0.28..8.29 rows=1 width=57) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (tnaf_ident = f_p_person0_.bpp_ptrtnafid)
24. 0.005 0.005 ↓ 0.0 0 1

Index Scan using t_etabliss_pk on t_etabliss t_etabliss5_ (cost=0.14..8.15 rows=1 width=8,076) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (ta_ident = f_p_person0_.bpp_ptretabident)
25. 0.005 0.005 ↑ 1.0 29 1

Seq Scan on t_catprof t_catprof2_ (cost=0.00..1.29 rows=29 width=518) (actual time=0.004..0.005 rows=29 loops=1)

26. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on t_societe t_societe6_ (cost=0.00..1.03 rows=3 width=7,030) (actual time=0.005..0.005 rows=3 loops=1)

27. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on f_p_c_client f_p_c_clie7_ (cost=0.00..1.01 rows=1 width=27,180) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (bpcl_ptrbppident = '1'::numeric)
  • Rows Removed by Filter: 1
28. 0.010 0.010 ↑ 1.0 26 1

Seq Scan on t_clifam t_clifam8_ (cost=0.00..1.26 rows=26 width=518) (actual time=0.009..0.010 rows=26 loops=1)

29. 0.005 0.005 ↓ 0.0 0 1

Index Scan using pk_sfa_ident on t_clisfam t_clisfam9_ (cost=0.14..8.16 rows=1 width=536) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (sfa_ident = f_p_c_clie7_.bpcl_ptrsfaid)
30. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on f_p_c_assure f_p_c_assu10_ (cost=0.00..1.01 rows=1 width=11,430) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (bpass_ptrbppident = '1'::numeric)
  • Rows Removed by Filter: 1
31. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on f_p_c_cnd f_p_c_cnds16_ (cost=0.00..1.01 rows=1 width=984) (actual time=0.002..0.003 rows=1 loops=1)

32. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on f_p_c_corresp f_p_c_corr11_ (cost=0.00..10.00 rows=1 width=17,032) (actual time=0.001..0.002 rows=0 loops=1)

  • Filter: (bpcor_ptrbppident = '1'::numeric)
33. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on f_p_c_corresp f_p_c_corr12_ (cost=0.00..10.00 rows=1 width=17,032) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (bpcor_ptrbppident = '1'::numeric)
34. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ind_in_ptrbppident on f_intermediaire f_intermed13_ (cost=0.12..8.14 rows=1 width=25,340) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (in_ptrbppident = '1'::numeric)
35. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on f_compagnies f_compagni14_ (cost=0.00..1.01 rows=1 width=7,612) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (co_ptrbppident = '1'::numeric)
  • Rows Removed by Filter: 1
36. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on f_p_c_user f_p_c_user15_ (cost=0.00..1.31 rows=1 width=6,822) (actual time=0.007..0.008 rows=1 loops=1)

  • Filter: (bput_ptrbppid = '1'::numeric)
  • Rows Removed by Filter: 24