explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WP02

Settings
# exclusive inclusive rows x rows loops node
1. 92,424.895 3,744,196.282 ↓ 357,815.0 357,815 1

Gather (cost=158,546.30..196,652.67 rows=1 width=223) (actual time=1,488.170..3,744,196.282 rows=357,815 loops=1)

  • Output: il_dwh_fact_principal_dossier.dl_datextract, il_dwh_fact_principal_dossier.dl_soc_id, il_dwh_fact_principal_dossier.dl_flg_bcl, il_dwh_fact_principal_dossier.dl_flg_inv, il_dwh_fact_principal_dossier.dossier_id, il_dwh_fact_principal_dossier.dossier_gen_id, il_dwh_fact_principal_dossier.contrat_id, il_dwh_contrat.numero_contrat, il_dwh_fact_detail_dossier.fact_detail_dossier_id, il_dwh_fact_principal_dossier.fact_principal_dossier_id, il_dwh_fact_detail_dossier.pro_id, il_dwh_fact_detail_dossier.numero_dossier, il_dwh_contrat.fonds_gar, il_dwh_contrat.regrpmnt_contrat_fonds_gar, il_dwh_fact_detail_dossier.mnt_fonds_gar, il_dwh_fact_principal_dossier.bonif_epa_lpp, il_dwh_fact_detail_dossier.type_mnt, il_dwh_fact_detail_dossier.type_part, il_dwh_fact_principal_dossier.type_partie, il_dwh_fact_detail_dossier.type_couv, il_dwh_part_comm_dossier_1.independant, il_dwh_part_comm_dossier_1.subside_fonds_gar, il_dwh_part_dossier.ann_naissance, il_dwh_fact_principal_dossier.annee_fact, il_dwh_fact_detail_dossier.type_coti, il_dwh_part_comm_dossier.numero_ub, il_dwh_fact_principal_dossier.mois_fact, il_dwh_part_dossier.dl_soc_id, il_dwh_fact_detail_dossier.dl_soc_id, il_dwh_part_dossier.dl_flg_bcl, il_dwh_fact_detail_dossier.dl_flg_bcl, il_dwh_part_dossier.dl_flg_inv, il_dwh_fact_detail_dossier.dl_flg_inv, il_dwh_part_dossier.dossier_gen_id, il_dwh_fact_detail_dossier.dossier_gen_id, il_dwh_part_dossier.role, il_dwh_part_comm_dossier_1.dl_datextract, il_dwh_fact_detail_dossier.dl_datextract, il_dwh_part_comm_dossier_1.dl_soc_id, il_dwh_part_comm_dossier_1.dl_flg_bcl, il_dwh_part_comm_dossier_1.dl_flg_inv, il_dwh_part_comm_dossier_1.dossier_id, il_dwh_fact_detail_dossier.dossier_id, il_dwh_part_comm_dossier_1.type_part_comm, il_dwh_part_comm_dossier.dl_datextract, il_dwh_part_comm_dossier.dl_soc_id, il_dwh_part_comm_dossier.dl_flg_bcl, il_dwh_part_comm_dossier.dl_flg_inv, il_dwh_part_comm_dossier.part_comm_dossier_id, il_dwh_fact_principal_dossier.part_comm_dossier_id, il_dwh_fact_detail_dossier.fact_principal_dossier_id, il_dwh_contrat.dl_datextract, il_dwh_contrat.dl_soc_id, il_dwh_contrat.dl_flg_bcl, il_dwh_contrat.contrat_id, il_dwh_contrat.dl_flg_inv
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=5,842,783,444 read=359,605 dirtied=32,281
  • I/O Timings: read=308,343.711
2. 503.396 3,651,771.387 ↓ 119,272.0 119,272 3 / 3

Nested Loop Left Join (cost=157,546.30..195,652.57 rows=1 width=223) (actual time=1,480.955..3,651,771.387 rows=119,272 loops=3)

  • Output: il_dwh_fact_principal_dossier.dl_datextract, il_dwh_fact_principal_dossier.dl_soc_id, il_dwh_fact_principal_dossier.dl_flg_bcl, il_dwh_fact_principal_dossier.dl_flg_inv, il_dwh_fact_principal_dossier.dossier_id, il_dwh_fact_principal_dossier.dossier_gen_id, il_dwh_fact_principal_dossier.contrat_id, il_dwh_contrat.numero_contrat, il_dwh_fact_detail_dossier.fact_detail_dossier_id, il_dwh_fact_principal_dossier.fact_principal_dossier_id, il_dwh_fact_detail_dossier.pro_id, il_dwh_fact_detail_dossier.numero_dossier, il_dwh_contrat.fonds_gar, il_dwh_contrat.regrpmnt_contrat_fonds_gar, il_dwh_fact_detail_dossier.mnt_fonds_gar, il_dwh_fact_principal_dossier.bonif_epa_lpp, il_dwh_fact_detail_dossier.type_mnt, il_dwh_fact_detail_dossier.type_part, il_dwh_fact_principal_dossier.type_partie, il_dwh_fact_detail_dossier.type_couv, il_dwh_part_comm_dossier_1.independant, il_dwh_part_comm_dossier_1.subside_fonds_gar, il_dwh_part_dossier.ann_naissance, il_dwh_fact_principal_dossier.annee_fact, il_dwh_fact_detail_dossier.type_coti, il_dwh_part_comm_dossier.numero_ub, il_dwh_fact_principal_dossier.mois_fact, il_dwh_part_dossier.dl_soc_id, il_dwh_fact_detail_dossier.dl_soc_id, il_dwh_part_dossier.dl_flg_bcl, il_dwh_fact_detail_dossier.dl_flg_bcl, il_dwh_part_dossier.dl_flg_inv, il_dwh_fact_detail_dossier.dl_flg_inv, il_dwh_part_dossier.dossier_gen_id, il_dwh_fact_detail_dossier.dossier_gen_id, il_dwh_part_dossier.role, il_dwh_part_comm_dossier_1.dl_datextract, il_dwh_fact_detail_dossier.dl_datextract, il_dwh_part_comm_dossier_1.dl_soc_id, il_dwh_part_comm_dossier_1.dl_flg_bcl, il_dwh_part_comm_dossier_1.dl_flg_inv, il_dwh_part_comm_dossier_1.dossier_id, il_dwh_fact_detail_dossier.dossier_id, il_dwh_part_comm_dossier_1.type_part_comm, il_dwh_part_comm_dossier.dl_datextract, il_dwh_part_comm_dossier.dl_soc_id, il_dwh_part_comm_dossier.dl_flg_bcl, il_dwh_part_comm_dossier.dl_flg_inv, il_dwh_part_comm_dossier.part_comm_dossier_id, il_dwh_fact_principal_dossier.part_comm_dossier_id, il_dwh_fact_detail_dossier.fact_principal_dossier_id, il_dwh_contrat.dl_datextract, il_dwh_contrat.dl_soc_id, il_dwh_contrat.dl_flg_bcl, il_dwh_contrat.contrat_id, il_dwh_contrat.dl_flg_inv
  • Buffers: shared hit=5,842,783,444 read=359,605 dirtied=32,281
  • I/O Timings: read=308,343.711
  • Worker 0: actual time=1,478.494..3677054.799 rows=119,832 loops=1
  • Buffers: shared hit=1,992,730,026 read=134,039 dirtied=11,467
  • I/O Timings: read=96,496.061
  • Worker 1: actual time=1,478.850..3743412.118 rows=120,691 loops=1
  • Buffers: shared hit=2,123,944,620 read=103,748 dirtied=10,435
  • I/O Timings: read=98,753.624
3. 795.326 3,649,001.829 ↓ 119,272.0 119,272 3 / 3

Nested Loop Left Join (cost=157,545.87..195,646.30 rows=1 width=198) (actual time=1,478.675..3,649,001.829 rows=119,272 loops=3)

  • Output: il_dwh_contrat.numero_contrat, il_dwh_contrat.fonds_gar, il_dwh_contrat.regrpmnt_contrat_fonds_gar, il_dwh_contrat.dl_datextract, il_dwh_contrat.dl_soc_id, il_dwh_contrat.dl_flg_bcl, il_dwh_contrat.contrat_id, il_dwh_contrat.dl_flg_inv, il_dwh_fact_principal_dossier.dl_datextract, il_dwh_fact_principal_dossier.dl_soc_id, il_dwh_fact_principal_dossier.dl_flg_bcl, il_dwh_fact_principal_dossier.dl_flg_inv, il_dwh_fact_principal_dossier.dossier_id, il_dwh_fact_principal_dossier.dossier_gen_id, il_dwh_fact_principal_dossier.contrat_id, il_dwh_fact_principal_dossier.fact_principal_dossier_id, il_dwh_fact_principal_dossier.bonif_epa_lpp, il_dwh_fact_principal_dossier.type_partie, il_dwh_fact_principal_dossier.annee_fact, il_dwh_fact_principal_dossier.mois_fact, il_dwh_fact_principal_dossier.part_comm_dossier_id, il_dwh_fact_detail_dossier.fact_detail_dossier_id, il_dwh_fact_detail_dossier.pro_id, il_dwh_fact_detail_dossier.numero_dossier, il_dwh_fact_detail_dossier.mnt_fonds_gar, il_dwh_fact_detail_dossier.type_mnt, il_dwh_fact_detail_dossier.type_part, il_dwh_fact_detail_dossier.type_couv, il_dwh_fact_detail_dossier.type_coti, il_dwh_fact_detail_dossier.dl_soc_id, il_dwh_fact_detail_dossier.dl_flg_bcl, il_dwh_fact_detail_dossier.dl_flg_inv, il_dwh_fact_detail_dossier.dossier_gen_id, il_dwh_fact_detail_dossier.dl_datextract, il_dwh_fact_detail_dossier.dossier_id, il_dwh_fact_detail_dossier.fact_principal_dossier_id, il_dwh_part_comm_dossier.numero_ub, il_dwh_part_comm_dossier.dl_datextract, il_dwh_part_comm_dossier.dl_soc_id, il_dwh_part_comm_dossier.dl_flg_bcl, il_dwh_part_comm_dossier.dl_flg_inv, il_dwh_part_comm_dossier.part_comm_dossier_id, il_dwh_part_comm_dossier_1.independant, il_dwh_part_comm_dossier_1.subside_fonds_gar, il_dwh_part_comm_dossier_1.dl_datextract, il_dwh_part_comm_dossier_1.dl_soc_id, il_dwh_part_comm_dossier_1.dl_flg_bcl, il_dwh_part_comm_dossier_1.dl_flg_inv, il_dwh_part_comm_dossier_1.dossier_id, il_dwh_part_comm_dossier_1.type_part_comm
  • Inner Unique: true
  • Buffers: shared hit=5,841,503,203 read=354,602 dirtied=30,160
  • I/O Timings: read=305,972.092
  • Worker 0: actual time=1,475.811..3674301.721 rows=119,832 loops=1
  • Buffers: shared hit=1,992,293,064 read=132,643 dirtied=10,143
  • I/O Timings: read=95,735.553
  • Worker 1: actual time=1,476.229..3740839.896 rows=120,691 loops=1
  • Buffers: shared hit=2,123,512,720 read=102,825 dirtied=9,898
  • I/O Timings: read=98,298.194
4. 1,243.754 3,647,610.145 ↓ 119,272.0 119,272 3 / 3

Nested Loop (cost=157,545.45..195,645.53 rows=1 width=174) (actual time=1,478.661..3,647,610.145 rows=119,272 loops=3)

  • Output: il_dwh_contrat.numero_contrat, il_dwh_contrat.fonds_gar, il_dwh_contrat.regrpmnt_contrat_fonds_gar, il_dwh_contrat.dl_datextract, il_dwh_contrat.dl_soc_id, il_dwh_contrat.dl_flg_bcl, il_dwh_contrat.contrat_id, il_dwh_contrat.dl_flg_inv, il_dwh_fact_principal_dossier.dl_datextract, il_dwh_fact_principal_dossier.dl_soc_id, il_dwh_fact_principal_dossier.dl_flg_bcl, il_dwh_fact_principal_dossier.dl_flg_inv, il_dwh_fact_principal_dossier.dossier_id, il_dwh_fact_principal_dossier.dossier_gen_id, il_dwh_fact_principal_dossier.contrat_id, il_dwh_fact_principal_dossier.fact_principal_dossier_id, il_dwh_fact_principal_dossier.bonif_epa_lpp, il_dwh_fact_principal_dossier.type_partie, il_dwh_fact_principal_dossier.annee_fact, il_dwh_fact_principal_dossier.mois_fact, il_dwh_fact_principal_dossier.part_comm_dossier_id, il_dwh_fact_detail_dossier.fact_detail_dossier_id, il_dwh_fact_detail_dossier.pro_id, il_dwh_fact_detail_dossier.numero_dossier, il_dwh_fact_detail_dossier.mnt_fonds_gar, il_dwh_fact_detail_dossier.type_mnt, il_dwh_fact_detail_dossier.type_part, il_dwh_fact_detail_dossier.type_couv, il_dwh_fact_detail_dossier.type_coti, il_dwh_fact_detail_dossier.dl_soc_id, il_dwh_fact_detail_dossier.dl_flg_bcl, il_dwh_fact_detail_dossier.dl_flg_inv, il_dwh_fact_detail_dossier.dossier_gen_id, il_dwh_fact_detail_dossier.dl_datextract, il_dwh_fact_detail_dossier.dossier_id, il_dwh_fact_detail_dossier.fact_principal_dossier_id, il_dwh_part_comm_dossier_1.independant, il_dwh_part_comm_dossier_1.subside_fonds_gar, il_dwh_part_comm_dossier_1.dl_datextract, il_dwh_part_comm_dossier_1.dl_soc_id, il_dwh_part_comm_dossier_1.dl_flg_bcl, il_dwh_part_comm_dossier_1.dl_flg_inv, il_dwh_part_comm_dossier_1.dossier_id, il_dwh_part_comm_dossier_1.type_part_comm
  • Join Filter: (il_dwh_contrat.dl_soc_id = il_dwh_part_comm_dossier_1.dl_soc_id)
  • Buffers: shared hit=5,841,314,689 read=351,860 dirtied=30,160
  • I/O Timings: read=305,125.030
  • Worker 0: actual time=1,475.802..3672830.843 rows=119,832 loops=1
  • Buffers: shared hit=1,992,230,937 read=131,842 dirtied=10,143
  • I/O Timings: read=95,270.199
  • Worker 1: actual time=1,476.216..3739514.243 rows=120,691 loops=1
  • Buffers: shared hit=2,123,448,419 read=102,412 dirtied=9,898
  • I/O Timings: read=98,143.276
5. 830.536 109,842.203 ↓ 59,636.0 119,272 3 / 3

Nested Loop (cost=157,545.02..194,994.67 rows=2 width=148) (actual time=838.689..109,842.203 rows=119,272 loops=3)

  • Output: il_dwh_contrat.numero_contrat, il_dwh_contrat.fonds_gar, il_dwh_contrat.regrpmnt_contrat_fonds_gar, il_dwh_contrat.dl_datextract, il_dwh_contrat.dl_soc_id, il_dwh_contrat.dl_flg_bcl, il_dwh_contrat.contrat_id, il_dwh_contrat.dl_flg_inv, il_dwh_fact_principal_dossier.dl_datextract, il_dwh_fact_principal_dossier.dl_soc_id, il_dwh_fact_principal_dossier.dl_flg_bcl, il_dwh_fact_principal_dossier.dl_flg_inv, il_dwh_fact_principal_dossier.dossier_id, il_dwh_fact_principal_dossier.dossier_gen_id, il_dwh_fact_principal_dossier.contrat_id, il_dwh_fact_principal_dossier.fact_principal_dossier_id, il_dwh_fact_principal_dossier.bonif_epa_lpp, il_dwh_fact_principal_dossier.type_partie, il_dwh_fact_principal_dossier.annee_fact, il_dwh_fact_principal_dossier.mois_fact, il_dwh_fact_principal_dossier.part_comm_dossier_id, il_dwh_fact_detail_dossier.fact_detail_dossier_id, il_dwh_fact_detail_dossier.pro_id, il_dwh_fact_detail_dossier.numero_dossier, il_dwh_fact_detail_dossier.mnt_fonds_gar, il_dwh_fact_detail_dossier.type_mnt, il_dwh_fact_detail_dossier.type_part, il_dwh_fact_detail_dossier.type_couv, il_dwh_fact_detail_dossier.type_coti, il_dwh_fact_detail_dossier.dl_soc_id, il_dwh_fact_detail_dossier.dl_flg_bcl, il_dwh_fact_detail_dossier.dl_flg_inv, il_dwh_fact_detail_dossier.dossier_gen_id, il_dwh_fact_detail_dossier.dl_datextract, il_dwh_fact_detail_dossier.dossier_id, il_dwh_fact_detail_dossier.fact_principal_dossier_id
  • Join Filter: (il_dwh_contrat.dl_soc_id = il_dwh_fact_detail_dossier.dl_soc_id)
  • Buffers: shared hit=1,578,837 read=345,462 dirtied=30,160
  • I/O Timings: read=304,179.353
  • Worker 0: actual time=835.657..103111.593 rows=119,832 loops=1
  • Buffers: shared hit=513,505 read=129,659 dirtied=10,143
  • I/O Timings: read=94,951.266
  • Worker 1: actual time=836.444..106120.363 rows=120,691 loops=1
  • Buffers: shared hit=548,641 read=100,389 dirtied=9,898
  • I/O Timings: read=97,755.151
6. 756.016 1,908.738 ↓ 24.7 120,884 3 / 3

Merge Join (cost=157,544.58..158,281.70 rows=4,896 width=83) (actual time=835.661..1,908.738 rows=120,884 loops=3)

  • Output: il_dwh_contrat.numero_contrat, il_dwh_contrat.fonds_gar, il_dwh_contrat.regrpmnt_contrat_fonds_gar, il_dwh_contrat.dl_datextract, il_dwh_contrat.dl_soc_id, il_dwh_contrat.dl_flg_bcl, il_dwh_contrat.contrat_id, il_dwh_contrat.dl_flg_inv, il_dwh_fact_principal_dossier.dl_datextract, il_dwh_fact_principal_dossier.dl_soc_id, il_dwh_fact_principal_dossier.dl_flg_bcl, il_dwh_fact_principal_dossier.dl_flg_inv, il_dwh_fact_principal_dossier.dossier_id, il_dwh_fact_principal_dossier.dossier_gen_id, il_dwh_fact_principal_dossier.contrat_id, il_dwh_fact_principal_dossier.fact_principal_dossier_id, il_dwh_fact_principal_dossier.bonif_epa_lpp, il_dwh_fact_principal_dossier.type_partie, il_dwh_fact_principal_dossier.annee_fact, il_dwh_fact_principal_dossier.mois_fact, il_dwh_fact_principal_dossier.part_comm_dossier_id
  • Merge Cond: ((il_dwh_fact_principal_dossier.dl_soc_id = il_dwh_contrat.dl_soc_id) AND (il_dwh_fact_principal_dossier.contrat_id = il_dwh_contrat.contrat_id))
  • Buffers: shared hit=38,637 read=5,327 dirtied=30,160
  • I/O Timings: read=46.772
  • Worker 0: actual time=832.644..1839.510 rows=121,553 loops=1
  • Buffers: shared hit=12,305 read=1,808 dirtied=10,143
  • I/O Timings: read=14.864
  • Worker 1: actual time=833.027..1953.903 rows=122,273 loops=1
  • Buffers: shared hit=12,282 read=1,768 dirtied=9,898
  • I/O Timings: read=16.286
7. 215.572 810.115 ↓ 1.4 120,884 3 / 3

Sort (cost=156,381.62..156,598.76 rows=86,858 width=51) (actual time=683.263..810.115 rows=120,884 loops=3)

  • Output: il_dwh_fact_principal_dossier.dl_datextract, il_dwh_fact_principal_dossier.dl_soc_id, il_dwh_fact_principal_dossier.dl_flg_bcl, il_dwh_fact_principal_dossier.dl_flg_inv, il_dwh_fact_principal_dossier.dossier_id, il_dwh_fact_principal_dossier.dossier_gen_id, il_dwh_fact_principal_dossier.contrat_id, il_dwh_fact_principal_dossier.fact_principal_dossier_id, il_dwh_fact_principal_dossier.bonif_epa_lpp, il_dwh_fact_principal_dossier.type_partie, il_dwh_fact_principal_dossier.annee_fact, il_dwh_fact_principal_dossier.mois_fact, il_dwh_fact_principal_dossier.part_comm_dossier_id
  • Sort Key: il_dwh_fact_principal_dossier.dl_soc_id, il_dwh_fact_principal_dossier.contrat_id
  • Sort Method: quicksort Memory: 19,610kB
  • Worker 0: Sort Method: quicksort Memory: 19,982kB
  • Worker 1: Sort Method: quicksort Memory: 20,073kB
  • Buffers: shared hit=26,529 read=739 dirtied=25,674
  • I/O Timings: read=5.903
  • Worker 0: actual time=681.851..807.450 rows=121,553 loops=1
  • Buffers: shared hit=8,307 read=241 dirtied=8,544
  • I/O Timings: read=1.885
  • Worker 1: actual time=680.542..807.591 rows=122,273 loops=1
  • Buffers: shared hit=8,244 read=239 dirtied=8,479
  • I/O Timings: read=1.952
8. 578.220 594.543 ↓ 1.4 120,884 3 / 3

Parallel Bitmap Heap Scan on bidwh.il_dwh_fact_principal_dossier (cost=4,076.70..149,256.50 rows=86,858 width=51) (actual time=229.443..594.543 rows=120,884 loops=3)

  • Output: il_dwh_fact_principal_dossier.dl_datextract, il_dwh_fact_principal_dossier.dl_soc_id, il_dwh_fact_principal_dossier.dl_flg_bcl, il_dwh_fact_principal_dossier.dl_flg_inv, il_dwh_fact_principal_dossier.dossier_id, il_dwh_fact_principal_dossier.dossier_gen_id, il_dwh_fact_principal_dossier.contrat_id, il_dwh_fact_principal_dossier.fact_principal_dossier_id, il_dwh_fact_principal_dossier.bonif_epa_lpp, il_dwh_fact_principal_dossier.type_partie, il_dwh_fact_principal_dossier.annee_fact, il_dwh_fact_principal_dossier.mois_fact, il_dwh_fact_principal_dossier.part_comm_dossier_id
  • Recheck Cond: ((il_dwh_fact_principal_dossier.dl_datextract = to_date(' 2018.12.31 '::text, 'YYYY.MM.DD'::text)) AND (il_dwh_fact_principal_dossier.dl_soc_id = ANY ('{3,8}'::integer[])) AND (il_dwh_fact_principal_dossier.dl_flg_bcl = 1))
  • Filter: ((il_dwh_fact_principal_dossier.dl_flg_inv = 1) AND ((il_dwh_fact_principal_dossier.type_partie)::text = 'ACTI'::text) AND ((il_dwh_fact_principal_dossier.type_objet_facturable)::text = 'OUBF'::text) AND ((il_dwh_fact_principal_dossier.type_emission)::text = 'CPER'::text) AND ((il_dwh_fact_principal_dossier.etat)::text = 'FACT'::text))
  • Rows Removed by Filter: 11,682
  • Heap Blocks: exact=8,651
  • Buffers: shared hit=26,517 read=739 dirtied=25,674
  • I/O Timings: read=5.903
  • Worker 0: actual time=226.578..591.223 rows=121,553 loops=1
  • Buffers: shared hit=8,303 read=241 dirtied=8,544
  • I/O Timings: read=1.885
  • Worker 1: actual time=226.913..592.091 rows=122,273 loops=1
  • Buffers: shared hit=8,240 read=239 dirtied=8,479
  • I/O Timings: read=1.952
9. 16.323 16.323 ↓ 1.7 407,483 1 / 3

Bitmap Index Scan on il_dwh_fact_principal_dossier_pkey (cost=0.00..4,024.59 rows=242,963 width=0) (actual time=48.969..48.969 rows=407,483 loops=1)

  • Index Cond: ((il_dwh_fact_principal_dossier.dl_datextract = to_date(' 2018.12.31 '::text, 'YYYY.MM.DD'::text)) AND (il_dwh_fact_principal_dossier.dl_soc_id = ANY ('{3,8}'::integer[])) AND (il_dwh_fact_principal_dossier.dl_flg_bcl = 1))
  • Buffers: shared hit=1,581 read=1
  • I/O Timings: read=0.016
10. 197.262 342.607 ↓ 72.9 123,636 3 / 3

Sort (cost=1,162.96..1,167.20 rows=1,695 width=32) (actual time=152.379..342.607 rows=123,636 loops=3)

  • Output: il_dwh_contrat.numero_contrat, il_dwh_contrat.fonds_gar, il_dwh_contrat.regrpmnt_contrat_fonds_gar, il_dwh_contrat.dl_datextract, il_dwh_contrat.dl_soc_id, il_dwh_contrat.dl_flg_bcl, il_dwh_contrat.contrat_id, il_dwh_contrat.dl_flg_inv
  • Sort Key: il_dwh_contrat.dl_soc_id, il_dwh_contrat.contrat_id
  • Sort Method: quicksort Memory: 569kB
  • Worker 0: Sort Method: quicksort Memory: 569kB
  • Worker 1: Sort Method: quicksort Memory: 569kB
  • Buffers: shared hit=12,108 read=4,588 dirtied=4,486
  • I/O Timings: read=40.869
  • Worker 0: actual time=150.772..304.033 rows=124,283 loops=1
  • Buffers: shared hit=3,998 read=1,567 dirtied=1,599
  • I/O Timings: read=12.979
  • Worker 1: actual time=152.464..300.618 rows=125,021 loops=1
  • Buffers: shared hit=4,038 read=1,529 dirtied=1,419
  • I/O Timings: read=14.334
11. 145.345 145.345 ↓ 2.8 4,823 3 / 3

Index Scan using olm_il_dwh_contrat_date_dl_flg_bcl_dl_flg_inv on bidwh.il_dwh_contrat (cost=0.42..1,072.05 rows=1,695 width=32) (actual time=0.105..145.345 rows=4,823 loops=3)

  • Output: il_dwh_contrat.numero_contrat, il_dwh_contrat.fonds_gar, il_dwh_contrat.regrpmnt_contrat_fonds_gar, il_dwh_contrat.dl_datextract, il_dwh_contrat.dl_soc_id, il_dwh_contrat.dl_flg_bcl, il_dwh_contrat.contrat_id, il_dwh_contrat.dl_flg_inv
  • Index Cond: ((il_dwh_contrat.dl_datextract = to_date(' 2018.12.31 '::text, 'YYYY.MM.DD'::text)) AND (il_dwh_contrat.dl_flg_bcl = 1) AND (il_dwh_contrat.dl_flg_inv = 1))
  • Buffers: shared hit=12,108 read=4,588 dirtied=4,486
  • I/O Timings: read=40.869
  • Worker 0: actual time=0.086..144.109 rows=4,823 loops=1
  • Buffers: shared hit=3,998 read=1,567 dirtied=1,599
  • I/O Timings: read=12.979
  • Worker 1: actual time=0.093..145.414 rows=4,823 loops=1
  • Buffers: shared hit=4,038 read=1,529 dirtied=1,419
  • I/O Timings: read=14.334
12. 107,102.929 107,102.929 ↑ 1.0 1 362,651 / 3

Index Scan using olm_bidwh_il_dwh_fact_detail_dossier_fact_principal_dossier_id on bidwh.il_dwh_fact_detail_dossier (cost=0.44..7.49 rows=1 width=65) (actual time=0.738..0.886 rows=1 loops=362,651)

  • Output: il_dwh_fact_detail_dossier.dl_datextract, il_dwh_fact_detail_dossier.dl_soc_id, il_dwh_fact_detail_dossier.dl_flg_bcl, il_dwh_fact_detail_dossier.dl_flg_inv, il_dwh_fact_detail_dossier.fact_detail_dossier_id, il_dwh_fact_detail_dossier.fact_principal_dossier_id, il_dwh_fact_detail_dossier.type_mnt, il_dwh_fact_detail_dossier.description_type_montant, il_dwh_fact_detail_dossier.type_part, il_dwh_fact_detail_dossier.description_type_part, il_dwh_fact_detail_dossier.type_couv, il_dwh_fact_detail_dossier.description_type_couverture, il_dwh_fact_detail_dossier.mnt_mouvement_capitaux, il_dwh_fact_detail_dossier.mnt_pri_annuelle, il_dwh_fact_detail_dossier.mnt_coord_accident, il_dwh_fact_detail_dossier.mnt_frais_fixes, il_dwh_fact_detail_dossier.mnt_frais_epa, il_dwh_fact_detail_dossier.mnt_frais_risque, il_dwh_fact_detail_dossier.mnt_frais_rev, il_dwh_fact_detail_dossier.mnt_mesures_speciales, il_dwh_fact_detail_dossier.mnt_fonds_gar, il_dwh_fact_detail_dossier.mnt_rnch, il_dwh_fact_detail_dossier.mnt_assainissement, il_dwh_fact_detail_dossier.mnt_coti_rev, il_dwh_fact_detail_dossier.mnt_surp_paie_frac, il_dwh_fact_detail_dossier.mnt_coti_lib, il_dwh_fact_detail_dossier.mnt_contrib, il_dwh_fact_detail_dossier.mnt_contrib_speciale, il_dwh_fact_detail_dossier.mnt_fine_entree, il_dwh_fact_detail_dossier.type_coti, il_dwh_fact_detail_dossier.mnt_prest, il_dwh_fact_detail_dossier.dte_fact_prevue, il_dwh_fact_detail_dossier.dossier_id, il_dwh_fact_detail_dossier.dossier_gen_id, il_dwh_fact_detail_dossier.contrat_id, il_dwh_fact_detail_dossier.plan_partie_id, il_dwh_fact_detail_dossier.mut_dossier_id, il_dwh_fact_detail_dossier.partie_dossier_id, il_dwh_fact_detail_dossier.pa_gen_id, il_dwh_fact_detail_dossier.nombre_jours, il_dwh_fact_detail_dossier.mnt_total, il_dwh_fact_detail_dossier.numero_contrat, il_dwh_fact_detail_dossier.numero_dossier, il_dwh_fact_detail_dossier.contrat_pilote_fonds_gar_id, il_dwh_fact_detail_dossier.fonds_gar, il_dwh_fact_detail_dossier.description_fonds_garantie, il_dwh_fact_detail_dossier.regrpmnt_contrat_fonds_gar, il_dwh_fact_detail_dossier.description_regroupement_contr, il_dwh_fact_detail_dossier.nom_ou_raison_sociale, il_dwh_fact_detail_dossier.mnt_coti_risque, il_dwh_fact_detail_dossier.mnt_correction_arrondis, il_dwh_fact_detail_dossier.usr_log_i, il_dwh_fact_detail_dossier.dte_log_i, il_dwh_fact_detail_dossier.usr_log_u, il_dwh_fact_detail_dossier.dte_log_u, il_dwh_fact_detail_dossier.pro_id, il_dwh_fact_detail_dossier.enc_total, il_dwh_fact_detail_dossier.mnt_prelev_avoir, il_dwh_fact_detail_dossier.mnt_recapitalisation
  • Index Cond: (il_dwh_fact_detail_dossier.fact_principal_dossier_id = il_dwh_fact_principal_dossier.fact_principal_dossier_id)
  • Filter: ((il_dwh_fact_detail_dossier.type_couv IS NULL) AND (il_dwh_fact_detail_dossier.dl_flg_inv = 1) AND (il_dwh_fact_detail_dossier.dl_flg_bcl = 1) AND ((COALESCE(il_dwh_fact_detail_dossier.type_coti, 'BASE'::character varying))::text = 'BASE'::text) AND ((il_dwh_fact_detail_dossier.type_part)::text = 'TOTA'::text) AND ((il_dwh_fact_detail_dossier.type_mnt)::text = 'TOTA'::text) AND (il_dwh_fact_principal_dossier.dl_soc_id = il_dwh_fact_detail_dossier.dl_soc_id) AND (il_dwh_fact_detail_dossier.dl_datextract = to_date(' 2018.12.31 '::text, 'YYYY.MM.DD'::text)))
  • Rows Removed by Filter: 16
  • Buffers: shared hit=1,540,200 read=340,135
  • I/O Timings: read=304,132.581
  • Worker 0: actual time=0.682..0.827 rows=1 loops=121,553
  • Buffers: shared hit=501,200 read=127,851
  • I/O Timings: read=94,936.402
  • Worker 1: actual time=0.708..0.846 rows=1 loops=122,273
  • Buffers: shared hit=536,359 read=98,621
  • I/O Timings: read=97,738.865
13. 3,536,524.188 3,536,524.188 ↑ 1.0 1 357,815 / 3

Index Scan using il_dwh_part_comm_dossier_pkey on bidwh.il_dwh_part_comm_dossier il_dwh_part_comm_dossier_1 (cost=0.43..325.41 rows=1 width=26) (actual time=11.496..29.651 rows=1 loops=357,815)

  • Output: il_dwh_part_comm_dossier_1.dl_datextract, il_dwh_part_comm_dossier_1.dl_soc_id, il_dwh_part_comm_dossier_1.dl_flg_bcl, il_dwh_part_comm_dossier_1.dl_flg_inv, il_dwh_part_comm_dossier_1.part_comm_dossier_id, il_dwh_part_comm_dossier_1.dossier_id, il_dwh_part_comm_dossier_1.dossier_gen_id, il_dwh_part_comm_dossier_1.no_gen_dossier, il_dwh_part_comm_dossier_1.numero_dossier, il_dwh_part_comm_dossier_1.mut_dossier_id, il_dwh_part_comm_dossier_1.mut_dossier_id_prec, il_dwh_part_comm_dossier_1.contrat_id, il_dwh_part_comm_dossier_1.numero_contrat, il_dwh_part_comm_dossier_1.unite_budgetaire_contrat_id, il_dwh_part_comm_dossier_1.categorie_empl_id, il_dwh_part_comm_dossier_1.part_comm_dossier_orig_id, il_dwh_part_comm_dossier_1.numero_ub, il_dwh_part_comm_dossier_1.numero_decompte, il_dwh_part_comm_dossier_1.type_part_comm, il_dwh_part_comm_dossier_1.description_type_partenaire_co, il_dwh_part_comm_dossier_1.type_employeur, il_dwh_part_comm_dossier_1.description_type_employeur, il_dwh_part_comm_dossier_1.tx_coti_maintien_sal_dossier, il_dwh_part_comm_dossier_1.tx_coti_maintien_deg_dossier, il_dwh_part_comm_dossier_1.maintien_sal_cotisant, il_dwh_part_comm_dossier_1.sal_cotisant_garanti, il_dwh_part_comm_dossier_1.sal_avs, il_dwh_part_comm_dossier_1.sal_avs_mvt, il_dwh_part_comm_dossier_1.sal_avs_precedent, il_dwh_part_comm_dossier_1.type_sal, il_dwh_part_comm_dossier_1.description_type_salaire, il_dwh_part_comm_dossier_1.dte_embauche, il_dwh_part_comm_dossier_1.tx_act, il_dwh_part_comm_dossier_1.tx_act_mvt, il_dwh_part_comm_dossier_1.tx_retraite, il_dwh_part_comm_dossier_1.sal_base, il_dwh_part_comm_dossier_1.supplement_assure, il_dwh_part_comm_dossier_1.provision_13e_sal, il_dwh_part_comm_dossier_1.maintien_coti_conge, il_dwh_part_comm_dossier_1.maintien_deg_ass, il_dwh_part_comm_dossier_1.deg_ass, il_dwh_part_comm_dossier_1.tx_maintenu, il_dwh_part_comm_dossier_1.tx_act_precedent, il_dwh_part_comm_dossier_1.type_categorie_empl_id, il_dwh_part_comm_dossier_1.desc_courte, il_dwh_part_comm_dossier_1.desc_longue, il_dwh_part_comm_dossier_1.age_retraite_min, il_dwh_part_comm_dossier_1.dte_deb, il_dwh_part_comm_dossier_1.dte_fin, il_dwh_part_comm_dossier_1.dn_mut_id, il_dwh_part_comm_dossier_1.dn_dte_mut, il_dwh_part_comm_dossier_1.dn_nom_mut, il_dwh_part_comm_dossier_1.pro_id, il_dwh_part_comm_dossier_1.usr_log_i, il_dwh_part_comm_dossier_1.dte_log_i, il_dwh_part_comm_dossier_1.usr_log_u, il_dwh_part_comm_dossier_1.dte_log_u, il_dwh_part_comm_dossier_1.dte_derniere_fact_coti, il_dwh_part_comm_dossier_1.independant, il_dwh_part_comm_dossier_1.rev_trois_ans, il_dwh_part_comm_dossier_1.subside_fonds_gar, il_dwh_part_comm_dossier_1.part_facture_maintien_sal, il_dwh_part_comm_dossier_1.part_facture_maintien_deg, il_dwh_part_comm_dossier_1.desc_longue_feminine, il_dwh_part_comm_dossier_1.code_fonction, il_dwh_part_comm_dossier_1.code_bilan, il_dwh_part_comm_dossier_1.classe_sal_inferieure, il_dwh_part_comm_dossier_1.classe_sal_superieure, il_dwh_part_comm_dossier_1.fonction_nps, il_dwh_part_comm_dossier_1.type_categorie_desc_courte, il_dwh_part_comm_dossier_1.type_categorie_desc_longue, il_dwh_part_comm_dossier_1.type_activite, il_dwh_part_comm_dossier_1.type_act, il_dwh_part_comm_dossier_1.dte_fin_maintien
  • Index Cond: ((il_dwh_part_comm_dossier_1.dl_datextract = to_date(' 2018.12.31 '::text, 'YYYY.MM.DD'::text)) AND (il_dwh_part_comm_dossier_1.dl_soc_id = il_dwh_fact_detail_dossier.dl_soc_id) AND (il_dwh_part_comm_dossier_1.dl_flg_bcl = 1) AND (il_dwh_part_comm_dossier_1.dl_flg_inv = 1))
  • Filter: (((il_dwh_part_comm_dossier_1.type_part_comm)::text = 'EMPL'::text) AND (il_dwh_fact_detail_dossier.dossier_id = il_dwh_part_comm_dossier_1.dossier_id))
  • Rows Removed by Filter: 47,321
  • Buffers: shared hit=5,839,735,852 read=6,398
  • I/O Timings: read=945.677
  • Worker 0: actual time=11.627..29.780 rows=1 loops=119,832
  • Buffers: shared hit=1,991,717,432 read=2,183
  • I/O Timings: read=318.933
  • Worker 1: actual time=11.566..30.095 rows=1 loops=120,691
  • Buffers: shared hit=2,122,899,778 read=2,023
  • I/O Timings: read=388.124
14. 596.358 596.358 ↓ 0.0 0 357,815 / 3

Index Scan using olm_il_dwh_part_comm_dossier_part_comm_dossier_id on bidwh.il_dwh_part_comm_dossier (cost=0.42..0.76 rows=1 width=24) (actual time=0.005..0.005 rows=0 loops=357,815)

  • Output: il_dwh_part_comm_dossier.dl_datextract, il_dwh_part_comm_dossier.dl_soc_id, il_dwh_part_comm_dossier.dl_flg_bcl, il_dwh_part_comm_dossier.dl_flg_inv, il_dwh_part_comm_dossier.part_comm_dossier_id, il_dwh_part_comm_dossier.dossier_id, il_dwh_part_comm_dossier.dossier_gen_id, il_dwh_part_comm_dossier.no_gen_dossier, il_dwh_part_comm_dossier.numero_dossier, il_dwh_part_comm_dossier.mut_dossier_id, il_dwh_part_comm_dossier.mut_dossier_id_prec, il_dwh_part_comm_dossier.contrat_id, il_dwh_part_comm_dossier.numero_contrat, il_dwh_part_comm_dossier.unite_budgetaire_contrat_id, il_dwh_part_comm_dossier.categorie_empl_id, il_dwh_part_comm_dossier.part_comm_dossier_orig_id, il_dwh_part_comm_dossier.numero_ub, il_dwh_part_comm_dossier.numero_decompte, il_dwh_part_comm_dossier.type_part_comm, il_dwh_part_comm_dossier.description_type_partenaire_co, il_dwh_part_comm_dossier.type_employeur, il_dwh_part_comm_dossier.description_type_employeur, il_dwh_part_comm_dossier.tx_coti_maintien_sal_dossier, il_dwh_part_comm_dossier.tx_coti_maintien_deg_dossier, il_dwh_part_comm_dossier.maintien_sal_cotisant, il_dwh_part_comm_dossier.sal_cotisant_garanti, il_dwh_part_comm_dossier.sal_avs, il_dwh_part_comm_dossier.sal_avs_mvt, il_dwh_part_comm_dossier.sal_avs_precedent, il_dwh_part_comm_dossier.type_sal, il_dwh_part_comm_dossier.description_type_salaire, il_dwh_part_comm_dossier.dte_embauche, il_dwh_part_comm_dossier.tx_act, il_dwh_part_comm_dossier.tx_act_mvt, il_dwh_part_comm_dossier.tx_retraite, il_dwh_part_comm_dossier.sal_base, il_dwh_part_comm_dossier.supplement_assure, il_dwh_part_comm_dossier.provision_13e_sal, il_dwh_part_comm_dossier.maintien_coti_conge, il_dwh_part_comm_dossier.maintien_deg_ass, il_dwh_part_comm_dossier.deg_ass, il_dwh_part_comm_dossier.tx_maintenu, il_dwh_part_comm_dossier.tx_act_precedent, il_dwh_part_comm_dossier.type_categorie_empl_id, il_dwh_part_comm_dossier.desc_courte, il_dwh_part_comm_dossier.desc_longue, il_dwh_part_comm_dossier.age_retraite_min, il_dwh_part_comm_dossier.dte_deb, il_dwh_part_comm_dossier.dte_fin, il_dwh_part_comm_dossier.dn_mut_id, il_dwh_part_comm_dossier.dn_dte_mut, il_dwh_part_comm_dossier.dn_nom_mut, il_dwh_part_comm_dossier.pro_id, il_dwh_part_comm_dossier.usr_log_i, il_dwh_part_comm_dossier.dte_log_i, il_dwh_part_comm_dossier.usr_log_u, il_dwh_part_comm_dossier.dte_log_u, il_dwh_part_comm_dossier.dte_derniere_fact_coti, il_dwh_part_comm_dossier.independant, il_dwh_part_comm_dossier.rev_trois_ans, il_dwh_part_comm_dossier.subside_fonds_gar, il_dwh_part_comm_dossier.part_facture_maintien_sal, il_dwh_part_comm_dossier.part_facture_maintien_deg, il_dwh_part_comm_dossier.desc_longue_feminine, il_dwh_part_comm_dossier.code_fonction, il_dwh_part_comm_dossier.code_bilan, il_dwh_part_comm_dossier.classe_sal_inferieure, il_dwh_part_comm_dossier.classe_sal_superieure, il_dwh_part_comm_dossier.fonction_nps, il_dwh_part_comm_dossier.type_categorie_desc_courte, il_dwh_part_comm_dossier.type_categorie_desc_longue, il_dwh_part_comm_dossier.type_activite, il_dwh_part_comm_dossier.type_act, il_dwh_part_comm_dossier.dte_fin_maintien
  • Index Cond: (il_dwh_part_comm_dossier.part_comm_dossier_id = il_dwh_fact_principal_dossier.part_comm_dossier_id)
  • Filter: ((il_dwh_part_comm_dossier.dl_flg_bcl = 1) AND (il_dwh_part_comm_dossier.dl_flg_inv = 1) AND (il_dwh_part_comm_dossier.dl_datextract = il_dwh_fact_principal_dossier.dl_datextract) AND (il_dwh_part_comm_dossier.dl_flg_bcl = il_dwh_fact_principal_dossier.dl_flg_bcl) AND (il_dwh_part_comm_dossier.dl_flg_inv = il_dwh_fact_principal_dossier.dl_flg_inv) AND (il_dwh_part_comm_dossier.dl_soc_id = il_dwh_fact_principal_dossier.dl_soc_id) AND (il_dwh_part_comm_dossier.dl_datextract = to_date(' 2018.12.31 '::text, 'YYYY.MM.DD'::text)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=188,514 read=2,742
  • I/O Timings: read=847.062
  • Worker 0: actual time=0.007..0.007 rows=0 loops=119,832
  • Buffers: shared hit=62,127 read=801
  • I/O Timings: read=465.354
  • Worker 1: actual time=0.004..0.004 rows=0 loops=120,691
  • Buffers: shared hit=64,301 read=413
  • I/O Timings: read=154.919
15. 2,266.162 2,266.162 ↓ 0.0 0 357,815 / 3

Index Scan using olm_il_dwh_part_dossier_dossier_gen_id on bidwh.il_dwh_part_dossier (cost=0.43..6.26 rows=1 width=25) (actual time=0.019..0.019 rows=0 loops=357,815)

  • Output: il_dwh_part_dossier.dl_datextract, il_dwh_part_dossier.dl_soc_id, il_dwh_part_dossier.dl_flg_bcl, il_dwh_part_dossier.dl_flg_inv, il_dwh_part_dossier.part_dossier_id, il_dwh_part_dossier.personne_contact_part_id, il_dwh_part_dossier.part_dossier_part_id, il_dwh_part_dossier.dossier_id, il_dwh_part_dossier.no_gen_dossier, il_dwh_part_dossier.dossier_gen_id, il_dwh_part_dossier.role, il_dwh_part_dossier.description_role, il_dwh_part_dossier.personne_contact, il_dwh_part_dossier.role_personne_contact, il_dwh_part_dossier.description_role_personne_cont, il_dwh_part_dossier.lien_parente_personne_contact, il_dwh_part_dossier.description_lien_parente, il_dwh_part_dossier.oc_principal_id, il_dwh_part_dossier.oc_secondaire_id, il_dwh_part_dossier.type_part, il_dwh_part_dossier.description_type_partenaire, il_dwh_part_dossier.nom_ou_raison_sociale, il_dwh_part_dossier.nom_complementaire, il_dwh_part_dossier.nom_alliance, il_dwh_part_dossier.prenom, il_dwh_part_dossier.dte_naissance, il_dwh_part_dossier.ann_naissance, il_dwh_part_dossier.dte_deces, il_dwh_part_dossier.sexe, il_dwh_part_dossier.description_sexe, il_dwh_part_dossier.etat_civil, il_dwh_part_dossier.description_etat_civil, il_dwh_part_dossier.no_avs, il_dwh_part_dossier.langue_correspondance, il_dwh_part_dossier.description_langue_corresponda, il_dwh_part_dossier.telephone, il_dwh_part_dossier.telephone_mobile, il_dwh_part_dossier.fax, il_dwh_part_dossier.e_mail, il_dwh_part_dossier.dte_deb_concubinage, il_dwh_part_dossier.indemnite_unique_conc, il_dwh_part_dossier.reduc_prest_deces_conc, il_dwh_part_dossier.reduc_allocation_deces_conc, il_dwh_part_dossier.dte_mar_conj, il_dwh_part_dossier.dte_div_conj, il_dwh_part_dossier.prest_libre_pass_lpp_mar_conj, il_dwh_part_dossier.prest_libre_pass_tot_mar_conj, il_dwh_part_dossier.choix_capital_conj, il_dwh_part_dossier.indemnite_unique_conj, il_dwh_part_dossier.reduc_prest_deces_conj, il_dwh_part_dossier.provenance_bande_etat_conj, il_dwh_part_dossier.reduc_allocation_deces_conj, il_dwh_part_dossier.rentes_non_indexables_conj, il_dwh_part_dossier.invalide_enfant, il_dwh_part_dossier.a_charge_enfant, il_dwh_part_dossier.type_charge_enfant, il_dwh_part_dossier.description_type_charge_enfant, il_dwh_part_dossier.dte_fin_charge_enfant, il_dwh_part_dossier.doublement_rte_enfant, il_dwh_part_dossier.index_bande_etat_enfant, il_dwh_part_dossier.dte_pacs, il_dwh_part_dossier.dte_dis_pacs, il_dwh_part_dossier.prest_libre_pass_lpp_pacs, il_dwh_part_dossier.prest_libre_pass_tot_pacs, il_dwh_part_dossier.choix_capital_pacs, il_dwh_part_dossier.indemnite_unique_pacs, il_dwh_part_dossier.reduc_prest_deces_pacs, il_dwh_part_dossier.rentes_non_indexables_pacs, il_dwh_part_dossier.reduc_allocation_deces_pacs, il_dwh_part_dossier.provenance_bande_etat_pacs, il_dwh_part_dossier.dn_mut_id, il_dwh_part_dossier.dn_dte_mut, il_dwh_part_dossier.dn_nom_mut, il_dwh_part_dossier.cree_par_batch, il_dwh_part_dossier.type_eff, il_dwh_part_dossier.type_eff_prec, il_dwh_part_dossier.effcal, il_dwh_part_dossier.numero_contact, il_dwh_part_dossier.usr_log_i, il_dwh_part_dossier.dte_log_i, il_dwh_part_dossier.usr_log_u, il_dwh_part_dossier.dte_log_u
  • Index Cond: (il_dwh_part_dossier.dossier_gen_id = il_dwh_fact_detail_dossier.dossier_gen_id)
  • Filter: ((il_dwh_part_dossier.dl_flg_bcl = 1) AND (il_dwh_part_dossier.dl_flg_inv = 1) AND ((il_dwh_part_dossier.role)::text = 'AFFI'::text) AND (il_dwh_part_dossier.dl_flg_bcl = il_dwh_fact_detail_dossier.dl_flg_bcl) AND (il_dwh_part_dossier.dl_flg_inv = il_dwh_fact_detail_dossier.dl_flg_inv) AND (il_dwh_part_dossier.dl_soc_id = il_dwh_fact_detail_dossier.dl_soc_id))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,280,241 read=5,003 dirtied=2,121
  • I/O Timings: read=2,371.620
  • Worker 0: actual time=0.018..0.018 rows=0 loops=119,832
  • Buffers: shared hit=436,962 read=1,396 dirtied=1,324
  • I/O Timings: read=760.508
  • Worker 1: actual time=0.017..0.017 rows=0 loops=120,691
  • Buffers: shared hit=431,900 read=923 dirtied=537
  • I/O Timings: read=455.429
Planning time : 60.384 ms
Execution time : 3,744,360.145 ms