explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hwSp

Settings
# exclusive inclusive rows x rows loops node
1. 103.172 2,845,535.545 ↓ 62,023.0 62,023 1

GroupAggregate (cost=1,468.24..1,468.32 rows=1 width=292) (actual time=2,845,422.962..2,845,535.545 rows=62,023 loops=1)

  • Output: bi_dates.dte_jour, bi_par_flg_bcl.dl_flg_bcl, bi_soc.soc_id, bi_fam_prod.fam_id, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol.pol_id, od_dwh_pol.cc_no_police, od_dwh_pa_gen.pa_id, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_pa_gen.etat, od_dwh_mut_pol.dte_mut, od_dwh_pol_gen.pri_type_pe, od_dwh_pa_gen.pa_gen, sum(od_dwh_pa_gen.mnt_tx_reass), sum(od_dwh_attrib_pe.mnt_risq_prov_apres), sum(od_dwh_attrib_pe.mnt_epar_prov_apres), sum(od_dwh_attrib_pe.mnt_risq_acquis), sum(od_dwh_attrib_pe.mnt_epar_acquis)
  • Group Key: bi_dates.dte_jour, bi_par_flg_bcl.dl_flg_bcl, bi_soc.soc_id, bi_fam_prod.fam_id, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol.pol_id, od_dwh_pol.cc_no_police, od_dwh_pa_gen.pa_id, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_pa_gen.etat, od_dwh_mut_pol.dte_mut, od_dwh_pol_gen.pri_type_pe, od_dwh_pa_gen.pa_gen
  • Buffers: shared hit=180447223 read=211455 written=1
2. 663.330 2,845,432.373 ↓ 62,023.0 62,023 1

Sort (cost=1,468.24..1,468.24 rows=1 width=148) (actual time=2,845,422.919..2,845,432.373 rows=62,023 loops=1)

  • Output: bi_dates.dte_jour, bi_par_flg_bcl.dl_flg_bcl, bi_soc.soc_id, bi_fam_prod.fam_id, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol.pol_id, od_dwh_pol.cc_no_police, od_dwh_pa_gen.pa_id, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_pa_gen.etat, od_dwh_mut_pol.dte_mut, od_dwh_pol_gen.pri_type_pe, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis
  • Sort Key: bi_fam_prod.fam_id, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol.pol_id, od_dwh_pol.cc_no_police, od_dwh_pa_gen.pa_id, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_pa_gen.etat, od_dwh_mut_pol.dte_mut, od_dwh_pa_gen.pa_gen
  • Sort Method: quicksort Memory: 18011kB
  • Buffers: shared hit=180447223 read=211455 written=1
3. 180.231 2,844,769.043 ↓ 62,023.0 62,023 1

Nested Loop (cost=156.20..1,468.23 rows=1 width=148) (actual time=234.195..2,844,769.043 rows=62,023 loops=1)

  • Output: bi_dates.dte_jour, bi_par_flg_bcl.dl_flg_bcl, bi_soc.soc_id, bi_fam_prod.fam_id, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol.pol_id, od_dwh_pol.cc_no_police, od_dwh_pa_gen.pa_id, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_pa_gen.etat, od_dwh_mut_pol.dte_mut, od_dwh_pol_gen.pri_type_pe, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis
  • Buffers: shared hit=180447214 read=211455 written=1
4. 219.584 2,844,154.651 ↓ 62,023.0 62,023 1

Nested Loop (cost=155.92..1,465.72 rows=1 width=148) (actual time=233.988..2,844,154.651 rows=62,023 loops=1)

  • Output: od_dwh_pa_gen.pa_id, od_dwh_pa_gen.etat, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, bi_par_flg_bcl.dl_flg_bcl, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_pol.pol_id, od_dwh_pol.cc_no_police, bi_fam_prod.fam_id, bi_soc.soc_id
  • Buffers: shared hit=180261147 read=211453 written=1
5. 490.032 2,843,686.975 ↓ 62,023.0 62,023 1

Nested Loop (cost=155.92..1,464.62 rows=1 width=148) (actual time=233.977..2,843,686.975 rows=62,023 loops=1)

  • Output: od_dwh_pa_gen.pa_id, od_dwh_pa_gen.etat, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, bi_par_flg_bcl.dl_flg_bcl, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_pol.pol_id, od_dwh_pol.cc_no_police, bi_fam_prod.fam_id, bi_fam_prod.soc_id
  • Inner Unique: true
  • Buffers: shared hit=180199124 read=211453 written=1
6. 225.443 2,842,885.903 ↓ 62,208.0 62,208 1

Nested Loop (cost=155.78..1,464.09 rows=1 width=144) (actual time=233.919..2,842,885.903 rows=62,208 loops=1)

  • Output: od_dwh_pa_gen.pa_id, od_dwh_pa_gen.etat, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, bi_par_flg_bcl.dl_flg_bcl, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_pol.pol_id, od_dwh_pol.cc_no_police, bi_prod.fam_id
  • Inner Unique: true
  • Buffers: shared hit=180075076 read=211452 written=1
7. 219.698 2,842,411.628 ↓ 62,208.0 62,208 1

Nested Loop (cost=155.64..1,463.91 rows=1 width=144) (actual time=233.909..2,842,411.628 rows=62,208 loops=1)

  • Output: od_dwh_pa_gen.pa_id, od_dwh_pa_gen.etat, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, bi_par_flg_bcl.dl_flg_bcl, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_pol.pol_id, od_dwh_pol.cc_no_police, od_dwh_pol.pro_id
  • Buffers: shared hit=179950662 read=211450 written=1
8. 316.888 2,836,219.962 ↓ 62,208.0 62,208 1

Nested Loop (cost=155.20..1,461.41 rows=1 width=150) (actual time=232.357..2,836,219.962 rows=62,208 loops=1)

  • Output: od_dwh_pa_gen.pa_id, od_dwh_pa_gen.etat, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_pa_gen.pol_id, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, od_dwh_pol_gen.pol_id, bi_par_flg_bcl.dl_flg_bcl, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_mut_pol.dl_datextract, od_dwh_mut_pol.dl_flg_bcl, od_dwh_mut_pol.pol_id
  • Buffers: shared hit=179729309 read=183728 written=1
9. 414.058 2,835,592.034 ↓ 62,208.0 62,208 1

Nested Loop (cost=155.20..1,460.06 rows=1 width=150) (actual time=232.343..2,835,592.034 rows=62,208 loops=1)

  • Output: od_dwh_pa_gen.pa_id, od_dwh_pa_gen.etat, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_pa_gen.pol_id, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis, bi_vcouv.act_nom_cta, bi_vcouv.tcl_desc_longue, bi_vcouv.type_nat_type_couv, bi_vcouv.col_nom_couv_fr, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, od_dwh_pol_gen.dl_flg_bcl, od_dwh_pol_gen.pol_id, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_mut_pol.dl_datextract, od_dwh_mut_pol.dl_flg_bcl, od_dwh_mut_pol.pol_id
  • Inner Unique: true
  • Buffers: shared hit=179667101 read=183728 written=1
10. 310.978 2,834,680.312 ↓ 62,208.0 62,208 1

Nested Loop (cost=154.92..1,459.71 rows=1 width=76) (actual time=232.322..2,834,680.312 rows=62,208 loops=1)

  • Output: od_dwh_pa_gen.pa_id, od_dwh_pa_gen.etat, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_pa_gen.pol_id, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis, od_dwh_pa.vco_id, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, od_dwh_pol_gen.dl_flg_bcl, od_dwh_pol_gen.pol_id, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_mut_pol.dl_datextract, od_dwh_mut_pol.dl_flg_bcl, od_dwh_mut_pol.pol_id
  • Buffers: shared hit=179481213 read=182992 written=1
11. 514.931 2,815,955.766 ↓ 62,208.0 62,208 1

Nested Loop Left Join (cost=154.36..1,407.91 rows=1 width=80) (actual time=232.258..2,815,955.766 rows=62,208 loops=1)

  • Output: od_dwh_pa_gen.pa_id, od_dwh_pa_gen.etat, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_pa_gen.dl_datextract, od_dwh_pa_gen.dl_flg_bcl, od_dwh_pa_gen.pol_id, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, od_dwh_pol_gen.dl_flg_bcl, od_dwh_pol_gen.pol_id, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_mut_pol.dl_datextract, od_dwh_mut_pol.dl_flg_bcl, od_dwh_mut_pol.pol_id
  • Buffers: shared hit=174887196 read=111811
12. 237.856 750,073.027 ↓ 62,208.0 62,208 1

Nested Loop (cost=94.67..1,347.08 rows=1 width=72) (actual time=173.669..750,073.027 rows=62,208 loops=1)

  • Output: od_dwh_pa_gen.pa_id, od_dwh_pa_gen.etat, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.mnt_tx_reass, od_dwh_pa_gen.dl_datextract, od_dwh_pa_gen.dl_flg_bcl, od_dwh_pa_gen.dl_flg_inv, od_dwh_pa_gen.pol_id, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, od_dwh_pol_gen.dl_flg_bcl, od_dwh_pol_gen.pol_id, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_mut_pol.dl_datextract, od_dwh_mut_pol.dl_flg_bcl, od_dwh_mut_pol.pol_id
  • Join Filter: ((od_dwh_pol_gen.pol_id = od_dwh_pa_gen.pol_id) AND (od_dwh_pol_gen.mupo_gen = od_dwh_pa_gen.mupo_gen))
  • Buffers: shared hit=46626296 read=64900
13. 82.349 8,099.891 ↓ 22,552.0 22,552 1

Nested Loop (cost=0.86..1,252.14 rows=1 width=48) (actual time=102.387..8,099.891 rows=22,552 loops=1)

  • Output: od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.dl_datextract, od_dwh_pol_gen.dl_flg_bcl, od_dwh_pol_gen.pol_id, od_dwh_pol_gen.mupo_gen, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_mut, od_dwh_mut_pol.dl_datextract, od_dwh_mut_pol.dl_flg_bcl, od_dwh_mut_pol.pol_id, od_dwh_mut_pol.mupo_gen
  • Buffers: shared hit=70451 read=29271
14. 304.758 304.758 ↓ 112.2 22,552 1

Index Scan using olm_od_dwh_pol_gen_date_dl_flg_bcl_dl_flg_inv on bidwh.od_dwh_pol_gen (cost=0.43..717.07 rows=201 width=20) (actual time=100.308..304.758 rows=22,552 loops=1)

  • Output: od_dwh_pol_gen.dl_datextract, od_dwh_pol_gen.dl_soc_id, od_dwh_pol_gen.dl_flg_bcl, od_dwh_pol_gen.dl_flg_inv, od_dwh_pol_gen.pol_id, od_dwh_pol_gen.mupo_gen, od_dwh_pol_gen.vpv_id_base, od_dwh_pol_gen.no_pension, od_dwh_pol_gen.no_avenant, od_dwh_pol_gen.benef_deces, od_dwh_pol_gen.benef_vie, od_dwh_pol_gen.benef_irrevoc, od_dwh_pol_gen.confidentiel, od_dwh_pol_gen.pers_rp, od_dwh_pol_gen.fin_monnaie, od_dwh_pol_gen.prov_code, od_dwh_pol_gen.prov_no, od_dwh_pol_gen.pri_primaute_pp, od_dwh_pol_gen.pri_type, od_dwh_pol_gen.pri_freq_paiement, od_dwh_pol_gen.pri_frais_fixes, od_dwh_pol_gen.pri_soumis_drt_timbre, od_dwh_pol_gen.pri_avec_drt_timbre, od_dwh_pol_gen.pri_type_pe, od_dwh_pol_gen.pri_dte_valo_deces, od_dwh_pol_gen.pri_dte_effet, od_dwh_pol_gen.pri_dte_anni, od_dwh_pol_gen.pri_dte_echeance, od_dwh_pol_gen.pri_somme_pp, od_dwh_pol_gen.fin_pret_pol, od_dwh_pol_gen.fin_dte_pret_pol, od_dwh_pol_gen.fin_pret_desc, od_dwh_pol_gen.fin_mise_gage, od_dwh_pol_gen.fin_type_nant, od_dwh_pol_gen.fisc_adapt_opp3, od_dwh_pol_gen.fisc_adapt_opp3_desc, od_dwh_pol_gen.fisc_mnt_opp3_declare, od_dwh_pol_gen.fisc_mnt_opp3_max_sou, od_dwh_pol_gen.fisc_rachetable, od_dwh_pol_gen.fisc_impot_anticipe, od_dwh_pol_gen.fisc_impot_source, od_dwh_pol_gen.fisc_impot_desc_libre, od_dwh_pol_gen.lba_identite, od_dwh_pol_gen.lba_prov, od_dwh_pol_gen.type_annonce, od_dwh_pol_gen.motif_rachat, od_dwh_pol_gen.mnt_rachat_partiel, od_dwh_pol_gen.motif_resiliation, od_dwh_pol_gen.rte_capital, od_dwh_pol_gen.cause_annul, od_dwh_pol_gen.delai_attente_libe, od_dwh_pol_gen.ajour_dte_fin, od_dwh_pol_gen.ajour_annee, od_dwh_pol_gen.code_voir_dossier, od_dwh_pol_gen.tutelle, od_dwh_pol_gen.clause_pilote, od_dwh_pol_gen.clause_resident, od_dwh_pol_gen.code_gerance, od_dwh_pol_gen.no_conseiller, od_dwh_pol_gen.pri_primaute_pu, od_dwh_pol_gen.pri_somme_pu, od_dwh_pol_gen.cc_plan_de_repartition_existe, od_dwh_pol_gen.fisc_cga_id, od_dwh_pol_gen.fisc_cga_dte_deb, od_dwh_pol_gen.accuse_recept_auto, od_dwh_pol_gen.ajournement, od_dwh_pol_gen.cause_mise_pension_manu, od_dwh_pol_gen.dn_incapacite, od_dwh_pol_gen.confirm_mise_pension, od_dwh_pol_gen.date_naissance_verifiee, od_dwh_pol_gen.deces_premiere_tete, od_dwh_pol_gen.dte_proch_ajournement, od_dwh_pol_gen.dte_proch_boucl, od_dwh_pol_gen.dte_proch_prelev, od_dwh_pol_gen.dte_proch_rebalanc, od_dwh_pol_gen.duree_pe, od_dwh_pol_gen.etat_versement, od_dwh_pol_gen.frequence_desiree, od_dwh_pol_gen.mise_en_pension, od_dwh_pol_gen.mise_pension_manu, od_dwh_pol_gen.no_encaissement, od_dwh_pol_gen.no_fe_vers_add, od_dwh_pol_gen.pas_correspondance, od_dwh_pol_gen.pas_extrait_compte, od_dwh_pol_gen.profil_choisi, od_dwh_pol_gen.rebalanc_auto, od_dwh_pol_gen.redressement_envoi_prest, od_dwh_pol_gen.regroupement, od_dwh_pol_gen.stipulation_beneficiaire, od_dwh_pol_gen.type_rachat, od_dwh_pol_gen.res_id, od_dwh_pol_gen.reassurance, od_dwh_pol_gen.rachat_cap_reserve, od_dwh_pol_gen.versement_immediat_pe, od_dwh_pol_gen.fin_dte_nant, od_dwh_pol_gen.procuration, od_dwh_pol_gen.variante_desiree_id, od_dwh_pol_gen.val_transf, od_dwh_pol_gen.corr_except_pp, od_dwh_pol_gen.corr_except_pu, od_dwh_pol_gen.frais_gestion_pp, od_dwh_pol_gen.frais_gestion_pu, od_dwh_pol_gen.majoration_rente, od_dwh_pol_gen.total_vers_annee_ap_mut, od_dwh_pol_gen.val_rachat_apres_mut, od_dwh_pol_gen.val_dec_apres_mut, od_dwh_pol_gen.som_risq_dec_int, od_dwh_pol_gen.som_risq_inv_int, od_dwh_pol_gen.som_risq_dec_reas, od_dwh_pol_gen.som_risq_inv_reas, od_dwh_pol_gen.fisc_type, od_dwh_pol_gen.taux_redressement, od_dwh_pol_gen.base_financement_flexible, od_dwh_pol_gen.date_calcul_avoir, od_dwh_pol_gen.date_precedent_calcul_avoir, od_dwh_pol_gen.type_base_financement_flexible
  • Index Cond: ((od_dwh_pol_gen.dl_datextract = '2020-12-31'::date) AND (od_dwh_pol_gen.dl_flg_bcl = 70))
  • Filter: ((od_dwh_pol_gen.pri_type_pe)::text = 'CPT'::text)
  • Rows Removed by Filter: 51703
  • Buffers: shared hit=14 read=5128
15. 7,712.784 7,712.784 ↑ 1.0 1 22,552

Index Scan using olm_od_dwh_mut_pol_id on bidwh.od_dwh_mut_pol (cost=0.43..2.65 rows=1 width=28) (actual time=0.278..0.342 rows=1 loops=22,552)

  • Output: od_dwh_mut_pol.dl_datextract, od_dwh_mut_pol.dl_soc_id, od_dwh_mut_pol.dl_flg_bcl, od_dwh_mut_pol.dl_flg_inv, od_dwh_mut_pol.pol_id, od_dwh_mut_pol.mupo_gen, od_dwh_mut_pol.peg_id, od_dwh_mut_pol.mut_id, od_dwh_mut_pol.no_mut, od_dwh_mut_pol.no_mut_prec, od_dwh_mut_pol.dte_mut, od_dwh_mut_pol.etat, od_dwh_mut_pol.status, od_dwh_mut_pol.dte_jour, od_dwh_mut_pol.dte_log_u, od_dwh_mut_pol.usr_log_u, od_dwh_mut_pol.dte_log_i, od_dwh_mut_pol.usr_log_i, od_dwh_mut_pol.cc_annulation_effet, od_dwh_mut_pol.droit_attribution_fonds, od_dwh_mut_pol.no_mut_extournee
  • Index Cond: ((od_dwh_mut_pol.pol_id = od_dwh_pol_gen.pol_id) AND (od_dwh_mut_pol.mupo_gen = od_dwh_pol_gen.mupo_gen))
  • Filter: ((od_dwh_mut_pol.dl_datextract = '2020-12-31'::date) AND (od_dwh_mut_pol.dl_flg_bcl = 70))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=70437 read=24143
16. 654.008 741,735.280 ↓ 3.0 3 22,552

Bitmap Heap Scan on bidwh.od_dwh_pa_gen (cost=93.81..94.93 rows=1 width=36) (actual time=32.882..32.890 rows=3 loops=22,552)

  • Output: od_dwh_pa_gen.dl_datextract, od_dwh_pa_gen.dl_soc_id, od_dwh_pa_gen.dl_flg_bcl, od_dwh_pa_gen.dl_flg_inv, od_dwh_pa_gen.pa_id, od_dwh_pa_gen.pa_gen, od_dwh_pa_gen.pol_id, od_dwh_pa_gen.mupo_gen, od_dwh_pa_gen.etat, od_dwh_pa_gen.princ_compl, od_dwh_pa_gen.dte_deb, od_dwh_pa_gen.dte_fin, od_dwh_pa_gen.dte_fin_paiement, od_dwh_pa_gen.mnt_tx_reass, od_dwh_pa_gen.mode_capital, od_dwh_pa_gen.type_pri, od_dwh_pa_gen.mnt_prest, od_dwh_pa_gen.type_prest, od_dwh_pa_gen.dte_fin_prest, od_dwh_pa_gen.dte_fin_differe, od_dwh_pa_gen.dte_base_calc, od_dwh_pa_gen.age_ass1, od_dwh_pa_gen.part_assure1, od_dwh_pa_gen.age_ass2, od_dwh_pa_gen.part_assure2, od_dwh_pa_gen.tx_ass1_revers, od_dwh_pa_gen.tx_ass2_revers, od_dwh_pa_gen.tx_ass1_prob_r_aggrave, od_dwh_pa_gen.tx_ass2_prob_r_aggrave, od_dwh_pa_gen.delai_attente, od_dwh_pa_gen.dte_effet_pe, od_dwh_pa_gen.duree_decroissance, od_dwh_pa_gen.pal_pa_id, od_dwh_pa_gen.pal_pa_gen, od_dwh_pa_gen.pal2_pa_id, od_dwh_pa_gen.pal2_pa_gen, od_dwh_pa_gen.rte_freq_paiement, od_dwh_pa_gen.rte_sub_pa_id, od_dwh_pa_gen.rte_sub_pa_gen, od_dwh_pa_gen.sub_pa_id, od_dwh_pa_gen.sub_pa_generation, od_dwh_pa_gen.vpv_id, od_dwh_pa_gen.cc_vpv_id, od_dwh_pa_gen.tpde_classe_risque, od_dwh_pa_gen.cc_vco_boucl_id, od_dwh_pa_gen.rev_pure_apres_mut, od_dwh_pa_gen.rev_invent_apres_mut, od_dwh_pa_gen.rev_com_apres_mut, od_dwh_pa_gen.som_risq_dec_int_apres_mut, od_dwh_pa_gen.som_risq_inv_int_apres_mut, od_dwh_pa_gen.som_risq_dec_reas_apres_mut, od_dwh_pa_gen.som_risq_inv_reas_apres_mut, od_dwh_pa_gen.frais_dispatche, od_dwh_pa_gen.calc_pri_tot_proratee, od_dwh_pa_gen.val_rac_apres_mut, od_dwh_pa_gen.val_dec_apres_mut, od_dwh_pa_gen.val_trans, od_dwh_pa_gen.val_age_effet_1t, od_dwh_pa_gen.val_age_effet_2t, od_dwh_pa_gen.val_age_effet_moy, od_dwh_pa_gen.val_age_eche_1t, od_dwh_pa_gen.val_age_eche_2t, od_dwh_pa_gen.val_age_eche_moy, od_dwh_pa_gen.calc_ass1_surpri, od_dwh_pa_gen.calc_ass2_surpri, od_dwh_pa_gen.calcul_rabais_somm, od_dwh_pa_gen.calc_surpri_special, od_dwh_pa_gen.transfert_opp3, od_dwh_pa_gen.rte, od_dwh_pa_gen.calc_frais_acqu_activ_ap, od_dwh_pa_gen.calc_report_prime_pure_ap, od_dwh_pa_gen.calc_report_prime_invent_ap, od_dwh_pa_gen.calc_report_prime_commer_ap, od_dwh_pa_gen.calc_pri_invent, od_dwh_pa_gen.calc_pri_commer, od_dwh_pa_gen.calc_pri_pure, od_dwh_pa_gen.calc_corr_except, od_dwh_pa_gen.calc_corr_except_out, od_dwh_pa_gen.calc_pri_tot_an, od_dwh_pa_gen.val_inv_apres_mut, od_dwh_pa_gen.val_vie_apres_mut, od_dwh_pa_gen.val_rachat_fiscal_avant_mut, od_dwh_pa_gen.val_rachat_fiscal_apres_mut, od_dwh_pa_gen.rev_boucl_pure_apres_mut, od_dwh_pa_gen.rev_boucl_com_apres_mut, od_dwh_pa_gen.rev_boucl_invent_apres_mut, od_dwh_pa_gen.flg_pa_disparue, od_dwh_pa_gen.profession_swiss_re_id, od_dwh_pa_gen.cc_profession_swiss_re, od_dwh_pa_gen.classe_risque_profession, od_dwh_pa_gen.cca_id, od_dwh_pa_gen.capital_deces_minimum, od_dwh_pa_gen.calcul_report_prestation_apres_mut, od_dwh_pa_gen.interet_deces_garanti
  • Recheck Cond: ((od_dwh_pa_gen.pol_id = od_dwh_mut_pol.pol_id) AND (od_dwh_pa_gen.dl_datextract = '2020-12-31'::date) AND (od_dwh_pa_gen.dl_flg_bcl = 70))
  • Filter: (od_dwh_mut_pol.mupo_gen = od_dwh_pa_gen.mupo_gen)
  • Heap Blocks: exact=29896
  • Buffers: shared hit=46555845 read=35629
17. 4,893.784 741,081.272 ↓ 0.0 0 22,552

BitmapAnd (cost=93.81..93.81 rows=1 width=0) (actual time=32.861..32.861 rows=0 loops=22,552)

  • Buffers: shared hit=46530233 read=31345
18. 4,465.296 4,465.296 ↑ 4.7 231 22,552

Bitmap Index Scan on olm_od_dwh_pa_gen_pol_id (cost=0.00..11.92 rows=1,078 width=0) (actual time=0.198..0.198 rows=231 loops=22,552)

  • Index Cond: (od_dwh_pa_gen.pol_id = od_dwh_mut_pol.pol_id)
  • Buffers: shared hit=75173 read=29285
19. 731,722.192 731,722.192 ↓ 96.7 536,578 22,552

Bitmap Index Scan on olm_od_dwh_pa_gen_date_dl_flg_bcl_dl_flg_inv (cost=0.00..80.25 rows=5,548 width=0) (actual time=32.446..32.446 rows=536,578 loops=22,552)

  • Index Cond: ((od_dwh_pa_gen.dl_datextract = '2020-12-31'::date) AND (od_dwh_pa_gen.dl_flg_bcl = 70))
  • Buffers: shared hit=46455060 read=2060
20. 933.120 2,065,367.808 ↑ 1.0 1 62,208

Bitmap Heap Scan on bidwh.od_dwh_attrib_pe (cost=59.69..60.82 rows=1 width=32) (actual time=33.200..33.201 rows=1 loops=62,208)

  • Output: od_dwh_attrib_pe.dl_datextract, od_dwh_attrib_pe.dl_soc_id, od_dwh_attrib_pe.dl_flg_bcl, od_dwh_attrib_pe.dl_flg_inv, od_dwh_attrib_pe.pa_id, od_dwh_attrib_pe.pa_gen, od_dwh_attrib_pe.mnt_risq_prov_apres, od_dwh_attrib_pe.mnt_epar_prov_apres, od_dwh_attrib_pe.mnt_risq_acquis, od_dwh_attrib_pe.mnt_epar_acquis, od_dwh_attrib_pe.mnt_bonus_final
  • Recheck Cond: ((od_dwh_attrib_pe.pa_id = od_dwh_pa_gen.pa_id) AND (od_dwh_attrib_pe.dl_datextract = od_dwh_pa_gen.dl_datextract) AND (od_dwh_attrib_pe.dl_datextract = '2020-12-31'::date) AND (od_dwh_attrib_pe.dl_flg_bcl = od_dwh_pa_gen.dl_flg_bcl) AND (od_dwh_attrib_pe.dl_flg_bcl = 70) AND (od_dwh_attrib_pe.dl_flg_inv = od_dwh_pa_gen.dl_flg_inv))
  • Filter: (od_dwh_attrib_pe.pa_gen = od_dwh_pa_gen.pa_gen)
  • Heap Blocks: exact=62188
  • Buffers: shared hit=128260900 read=46911
21. 906.432 2,064,434.688 ↓ 0.0 0 62,208

BitmapAnd (cost=59.69..59.69 rows=1 width=0) (actual time=33.186..33.186 rows=0 loops=62,208)

  • Buffers: shared hit=128200374 read=45249
22. 18,786.816 18,786.816 ↑ 1.2 81 62,208

Bitmap Index Scan on olm_od_dwh_attrib_pe_pa_id (cost=0.00..2.38 rows=98 width=0) (actual time=0.302..0.302 rows=81 loops=62,208)

  • Index Cond: (od_dwh_attrib_pe.pa_id = od_dwh_pa_gen.pa_id)
  • Buffers: shared hit=219528 read=43191
23. 2,044,741.440 2,044,741.440 ↓ 204.0 535,943 62,188

Bitmap Index Scan on olm_od_dwh_attrib_pe_date_dl_flg_bcl_dl_flg_inv (cost=0.00..57.06 rows=2,627 width=0) (actual time=32.880..32.880 rows=535,943 loops=62,188)

  • Index Cond: ((od_dwh_attrib_pe.dl_datextract = od_dwh_pa_gen.dl_datextract) AND (od_dwh_attrib_pe.dl_datextract = '2020-12-31'::date) AND (od_dwh_attrib_pe.dl_flg_bcl = od_dwh_pa_gen.dl_flg_bcl) AND (od_dwh_attrib_pe.dl_flg_bcl = 70) AND (od_dwh_attrib_pe.dl_flg_inv = od_dwh_pa_gen.dl_flg_inv))
  • Buffers: shared hit=127980846 read=2058
24. 18,413.568 18,413.568 ↑ 1.0 1 62,208

Index Scan using olm_od_dwh_pa_pa_id on bidwh.od_dwh_pa (cost=0.56..51.79 rows=1 width=16) (actual time=0.089..0.296 rows=1 loops=62,208)

  • Output: od_dwh_pa.dl_datextract, od_dwh_pa.dl_soc_id, od_dwh_pa.dl_flg_bcl, od_dwh_pa.pa_id, od_dwh_pa.vco_id
  • Index Cond: (od_dwh_pa.pa_id = od_dwh_pa_gen.pa_id)
  • Filter: ((od_dwh_pa.dl_datextract = '2020-12-31'::date) AND (od_dwh_pa.dl_flg_bcl = 70))
  • Rows Removed by Filter: 70
  • Buffers: shared hit=4594017 read=71181 written=1
25. 497.664 497.664 ↑ 1.0 1 62,208

Index Scan using bi_vcouv_pkey on biinfra.bi_vcouv (cost=0.28..0.35 rows=1 width=82) (actual time=0.008..0.008 rows=1 loops=62,208)

  • 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.cou_desc_courte, bi_vcouv.cou_type_calc_pri, bi_vcouv.cou_type_calc_prest, bi_vcouv.cou_type_pror_fina_rte, bi_vcouv.cou_type_pror_init_rte, bi_vcouv.cou_type_pri, bi_vcouv.cou_type_int, bi_vcouv.cou_type_echeance_prest, bi_vcouv.cou_arrondi_pri, bi_vcouv.cou_arrondi_prest, bi_vcouv.cou_arrondi_res, bi_vcouv.cou_soumis_drt_timbre, bi_vcouv.cou_type_prestation, bi_vcouv.cou_fo_remplissage_date, bi_vcouv.cou_fo_remplissage_date_age, bi_vcouv.cou_type_mal_acc, bi_vcouv.cou_ged_definition1, bi_vcouv.cou_ged_definition2, bi_vcouv.cou_type_prest_2p, bi_vcouv.cou_avant_apres_terme, bi_vcouv.cou_inclus_suri, bi_vcouv.cou_type_rte_conjoint, bi_vcouv.cou_type_arrondi_prest, bi_vcouv.cou_nombre_tetes, bi_vcouv.cou_ordre_tri, bi_vcouv.col_nom_couv_fr, bi_vcouv.col_nom_pour_gest_fr, bi_vcouv.col_desc_longue_fr, bi_vcouv.col_nom_commercial_fr, bi_vcouv.act_nom_couv, bi_vcouv.act_nom_type_couv, bi_vcouv.act_nom_cat_couv, bi_vcouv.act_nom_cta, bi_vcouv.type_nat_type_couv, bi_vcouv.tco_desc_courte, bi_vcouv.tco_type_sal, bi_vcouv.tco_type_risque, bi_vcouv.tco_ctrl_min_lpp, bi_vcouv.tco_regroupement_envoi_prestations, bi_vcouv.tco_rente_en_cours, bi_vcouv.tco_complement_avs, bi_vcouv.tco_prest_compl, bi_vcouv.tco_tri_couv_avant_terme, bi_vcouv.tco_tri_couv_apres_terme, bi_vcouv.tcl_desc_longue, 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, bi_vcouv.ccc_cca_dte_deb, bi_vcouv.ccc_cca_dte_fin, bi_vcouv.cca_id, bi_vcouv.cca_ref_cca, bi_vcouv.cca_description, bi_vcouv.cca_doc_url, bi_vcouv.ccl_nom_commercial_cca_fr, bi_vcouv.ccl_doc_name_cca_fr
  • Index Cond: (bi_vcouv.vco_id = od_dwh_pa.vco_id)
  • Buffers: shared hit=185888 read=736
26. 311.040 311.040 ↑ 1.0 1 62,208

Seq Scan on bidwhpar.bi_par_flg_bcl (cost=0.00..1.34 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=62,208)

  • Output: bi_par_flg_bcl.dl_flg_bcl, bi_par_flg_bcl.dl_flg_bcl_desc
  • Filter: (bi_par_flg_bcl.dl_flg_bcl = 70)
  • Rows Removed by Filter: 26
  • Buffers: shared hit=62208
27. 5,971.968 5,971.968 ↑ 1.0 1 62,208

Index Scan using olm_ody0122_2 on bidwh.od_dwh_pol (cost=0.43..2.49 rows=1 width=22) (actual time=0.096..0.096 rows=1 loops=62,208)

  • Output: od_dwh_pol.dl_datextract, od_dwh_pol.dl_soc_id, od_dwh_pol.dl_flg_bcl, od_dwh_pol.pol_id, od_dwh_pol.pro_id, od_dwh_pol.cc_no_police, od_dwh_pol.pol_id_orig, od_dwh_pol.pol_id_dest, od_dwh_pol.pri_cpt_dep, od_dwh_pol.dte_reception_propo, od_dwh_pol.dte_signature_propo, od_dwh_pol.no_propo_ulysse
  • Index Cond: ((od_dwh_pol.pol_id = od_dwh_pa_gen.pol_id) AND (od_dwh_pol.dl_flg_bcl = 70) AND (od_dwh_pol.dl_datextract = '2020-12-31'::date))
  • Buffers: shared hit=221353 read=27722
28. 248.832 248.832 ↑ 1.0 1 62,208

Index Scan using bi_prod_pkey on biinfra.bi_prod (cost=0.14..0.18 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=62,208)

  • 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 = od_dwh_pol.pro_id)
  • Buffers: shared hit=124414 read=2
29. 311.040 311.040 ↑ 1.0 1 62,208

Index Scan using bi_fam_prod_pkey on biinfra.bi_fam_prod (cost=0.14..0.34 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=62,208)

  • Output: bi_fam_prod.fam_id, bi_fam_prod.soc_id, bi_fam_prod.fam_desc_courte, bi_fam_prod.fam_type_famille, bi_fam_prod.fam_app_gest_id, bi_fam_prod.fam_dernier_num_police_utilise, bi_fam_prod.fal_nom_fam_fr, bi_fam_prod.fal_desc_longue_fr, bi_fam_prod.apg_nom_app, bi_fam_prod.apg_desc_courte, bi_fam_prod.apg_type_app
  • Index Cond: ((bi_fam_prod.fam_id = bi_prod.fam_id) AND (bi_fam_prod.fam_id = ANY ('{2,39}'::integer[])))
  • Filter: (bi_fam_prod.soc_id = 3)
  • Buffers: shared hit=124048 read=1
30. 248.092 248.092 ↑ 1.0 1 62,023

Seq Scan on biinfra.bi_soc (cost=0.00..1.09 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=62,023)

  • 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=62023
31. 434.161 434.161 ↑ 1.0 1 62,023

Index Only Scan using bi_dates_pkey on biinfra.bi_dates (cost=0.28..2.50 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=62,023)

  • Output: bi_dates.dte_jour
  • Index Cond: (bi_dates.dte_jour = '2020-12-31'::date)
  • Heap Fetches: 62023
  • Buffers: shared hit=186067 read=2
Planning time : 184.126 ms
Execution time : 2,845,540.381 ms