explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cnwI : test vb

Settings
# exclusive inclusive rows x rows loops node
1. 0.099 12,151.285 ↑ 106.8 122 1

Sort (cost=1,414,429.13..1,414,461.70 rows=13,027 width=68) (actual time=12,151.276..12,151.285 rows=122 loops=1)

  • Output: resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_export_comptable.num_ihis, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code, resalys_a_rubrique_comptabl_57.i_cpt, (sum(ca.montant_ca_comptable_ht)), (sum(ca.montant_ca_comptable_ttc)), (sum(ca.montant_ca_comptable_tva))
  • Sort Key: (sum(ca.montant_ca_comptable_ht)), (sum(ca.montant_ca_comptable_ttc)), (sum(ca.montant_ca_comptable_tva)), resalys_a_rubrique_comptabl_57.i_cpt, resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_export_comptable.num_ihis, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code
  • Sort Method: quicksort Memory: 42kB
2. 5.438 12,151.186 ↑ 106.8 122 1

GroupAggregate (cost=1,413,147.98..1,413,538.79 rows=13,027 width=68) (actual time=12,145.172..12,151.186 rows=122 loops=1)

  • Output: resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_export_comptable.num_ihis, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code, resalys_a_rubrique_comptabl_57.i_cpt, sum(ca.montant_ca_comptable_ht), sum(ca.montant_ca_comptable_ttc), sum(ca.montant_ca_comptable_tva)
  • Group Key: resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_export_comptable.num_ihis, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code, resalys_a_rubrique_comptabl_57.i_cpt
3. 15.916 12,145.748 ↑ 1.1 11,434 1

Sort (cost=1,413,147.98..1,413,180.55 rows=13,027 width=68) (actual time=12,145.099..12,145.748 rows=11,434 loops=1)

  • Output: resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_export_comptable.num_ihis, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code, resalys_a_rubrique_comptabl_57.i_cpt, ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva
  • Sort Key: resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_export_comptable.num_ihis, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code, resalys_a_rubrique_comptabl_57.i_cpt
  • Sort Method: quicksort Memory: 1992kB
4. 66.762 12,129.832 ↑ 1.1 11,434 1

Hash Join (cost=1,376,427.02..1,412,257.63 rows=13,027 width=68) (actual time=10,432.119..12,129.832 rows=11,434 loops=1)

  • Output: resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_export_comptable.num_ihis, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code, resalys_a_rubrique_comptabl_57.i_cpt, ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva
  • Hash Cond: (ca.num_ihis = resalys_a_export_comptable.num_ihis)
  • Join Filter: (resalys_a_export_comptable.num_ihis <> resalys_a_export_comptable__52.num_ihis)
  • Rows Removed by Join Filter: 198452
5. 166.538 12,062.945 ↓ 9.8 210,139 1

Merge Join (cost=1,376,419.57..1,412,006.47 rows=21,388 width=76) (actual time=10,431.896..12,062.945 rows=210,139 loops=1)

  • Output: ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva, ca.num_ihis, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code, resalys_a_export_comptable__52.num_ihis, resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_rubrique_comptabl_57.i_cpt
  • Merge Cond: ((ca.destination_id = resalys_a_rubrique_comptabl_57.etab_num) AND ((ca.cd_rub)::text = (resalys_a_rubrique_comptabl_57.cd_rub)::text))
6. 513.228 11,876.133 ↓ 3.6 862,808 1

Nested Loop (cost=1,376,273.28..1,410,295.81 rows=238,016 width=66) (actual time=10,427.143..11,876.133 rows=862,808 loops=1)

  • Output: ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva, ca.destination_id, ca.cd_rub, ca.num_ihis, resalys_a_rubrique_comptabl_35.etab_num, resalys_a_rubrique_comptabl_35.cd_rub, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code, resalys_a_export_comptable__52.num_ihis
7. 0.000 11,362.905 ↓ 3.6 862,808 1

Gather Merge (cost=1,376,273.28..1,407,315.58 rows=238,016 width=66) (actual time=10,427.010..11,362.905 rows=862,808 loops=1)

  • Output: ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva, ca.destination_id, ca.cd_rub, ca.num_ihis_od2, ca.num_ihis, resalys_a_rubrique_comptabl_35.etab_num, resalys_a_rubrique_comptabl_35.cd_rub, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code
  • Workers Planned: 4
  • Workers Launched: 4
8. 372.495 53,189.420 ↓ 2.9 173,000 5

Merge Left Join (cost=1,375,273.22..1,377,965.53 rows=59,504 width=66) (actual time=10,367.606..10,637.884 rows=173,000 loops=5)

  • Output: ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva, ca.destination_id, ca.cd_rub, ca.num_ihis_od2, ca.num_ihis, resalys_a_rubrique_comptabl_35.etab_num, resalys_a_rubrique_comptabl_35.cd_rub, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code
  • Inner Unique: true
  • Merge Cond: (ca.destination_id = dw_interm_diaire_a_etabliss_5.etab_num)
  • Worker 0: actual time=10366.959..10662.701 rows=167807 loops=1
  • Worker 1: actual time=10331.497..10636.621 rows=172609 loops=1
  • Worker 2: actual time=10357.701..10658.411 rows=176610 loops=1
  • Worker 3: actual time=10405.088..10664.894 rows=173687 loops=1
9. 752.120 52,814.675 ↓ 2.9 173,000 5

Merge Join (cost=1,375,272.95..1,377,186.29 rows=59,504 width=62) (actual time=10,367.529..10,562.935 rows=173,000 loops=5)

  • Output: ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva, ca.destination_id, ca.cd_rub, ca.num_ihis_od2, ca.num_ihis, resalys_a_rubrique_comptabl_35.etab_num, resalys_a_rubrique_comptabl_35.cd_rub
  • Merge Cond: ((ca.destination_id = resalys_a_rubrique_comptabl_35.etab_num) AND ((ca.cd_rub)::text = (resalys_a_rubrique_comptabl_35.cd_rub)::text))
  • Worker 0: actual time=10366.884..10578.624 rows=167807 loops=1
  • Worker 1: actual time=10331.481..10550.523 rows=172609 loops=1
  • Worker 2: actual time=10357.604..10572.893 rows=176610 loops=1
  • Worker 3: actual time=10405.014..10598.265 rows=173687 loops=1
10. 874.110 51,884.295 ↓ 1.5 173,000 5

Sort (cost=1,374,013.82..1,374,304.49 rows=116,269 width=59) (actual time=10,351.445..10,376.859 rows=173,000 loops=5)

  • Output: ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva, ca.destination_id, ca.cd_rub, ca.num_soc, ca.num_ihis_od2, ca.num_ihis
  • Sort Key: ca.destination_id, ca.cd_rub
  • Sort Method: quicksort Memory: 31484kB
  • Worker 0: Sort Method: quicksort Memory: 30331kB
  • Worker 1: Sort Method: quicksort Memory: 31082kB
  • Worker 2: Sort Method: quicksort Memory: 31657kB
  • Worker 3: Sort Method: quicksort Memory: 31244kB
  • Worker 0: actual time=10353.923..10382.286 rows=167807 loops=1
  • Worker 1: actual time=10311.217..10339.244 rows=172609 loops=1
  • Worker 2: actual time=10344.030..10372.387 rows=176610 loops=1
  • Worker 3: actual time=10384.482..10407.818 rows=173687 loops=1
11. 433.440 51,010.185 ↓ 1.5 177,885 5

Hash Join (cost=820.13..1,364,231.46 rows=116,269 width=59) (actual time=12.415..10,202.037 rows=177,885 loops=5)

  • Output: ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva, ca.destination_id, ca.cd_rub, ca.num_soc, ca.num_ihis_od2, ca.num_ihis
  • Hash Cond: (ca.realisation_date = date_conso.date_)
  • Worker 0: actual time=9.277..10198.090 rows=171996 loops=1
  • Worker 1: actual time=12.764..10198.277 rows=177333 loops=1
  • Worker 2: actual time=11.921..10198.521 rows=181423 loops=1
  • Worker 3: actual time=12.653..10197.750 rows=178483 loops=1
12. 450.250 50,540.825 ↓ 1.5 177,885 5

Hash Join (cost=205.12..1,362,712.51 rows=116,269 width=63) (actual time=5.133..10,108.165 rows=177,885 loops=5)

  • Output: ca.montant_ca_comptable_ht, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva, ca.realisation_date, ca.destination_id, ca.cd_rub, ca.num_soc, ca.num_ihis_od2, ca.num_ihis
  • Inner Unique: true
  • Hash Cond: ((ca.cd_produit)::text = (resalys_a_produit.cd_produit)::text)
  • Worker 0: actual time=2.984..10103.965 rows=171996 loops=1
  • Worker 1: actual time=6.660..10106.456 rows=177333 loops=1
  • Worker 2: actual time=5.037..10105.089 rows=181423 loops=1
  • Worker 3: actual time=6.725..10105.929 rows=178483 loops=1
13. 50,069.650 50,069.650 ↓ 1.6 181,924 5

Parallel Seq Scan on public.sresalys_f_ca ca (cost=0.00..1,362,201.28 rows=116,503 width=69) (actual time=0.784..10,013.930 rows=181,924 loops=5)

  • Output: ca.cl__uh, ca.champ, ca.cle_type_uh_comm, ca.cl__tarif, ca.cle_produit_compose, ca.num_sej, ca.num_tar, ca.num_for, ca.cd_camp, ca.destination_id, ca.booking_id, ca.num_soc, ca.customer_id, ca.partner_id, ca.num_uti, ca.partner_num_ntl, ca.cd_rem, ca.tla_trad, ca.payer_id, ca.num_ntl, ca.realisation_date, ca.sej_dt_deb, ca.sej_dt_fin, ca.ntl_dt_crea, ca.ntl_dt_acc, ca.ntl_dt_deb, ca.ntl_dt_fin, ca.ntf_dt_fact, ca.ntl_mt_rem, ca.ntl_pc_rem, ca.ntl_mt_com, ca.remise_manuelle, ca.date_total_rooms, ca.date_products_sales, ca.num_mor, ca.date_pax_vendus, ca.cd_taxe, ca.real_cd_tax, ca.dur_e_s_jour, ca.ntl_qte, ca.montant_ttc_annul_, ca.montant_ht_comptable_annul_, ca.montant_tva_comptable_annul_, ca.montant_ttc_comptable_annul_2, ca.montant_ttc_vente_annul_2, ca.montant_ca_vente_annule_tva, ca.montant_ttc20, ca.montant_ht20, ca.montant_tva_comptable_annul_2, ca.montant_ttc_vente_annul_20, ca.montant_ht_vente_annul_2, ca.montant_tva_vente_annul_2, ca.offert, ca.montant_ttc_gratuit, ca.montant_ht_gratuit, ca.montant_tva_comptable_offert2, ca.montant_ttc_vente_offert2, ca.montant_ht_vente_offert2, ca.montant_tva_vente_offert2, ca.gratuit, ca.montant_ttc_comptable_prefacture, ca.montant_ht_comptable_prefact, ca.montant_tva_comptable_prefacture, ca.montant_ttc_vente_prefacture, ca.montant_ht_vente_prefacture, ca.montant_tva_vente_prefacture, ca.montant_ca_prereserve_ttc, ca.montant_ca_prereserve_ht, ca.montant_tva, ca.montant_ca_vente_ttc, ca.montant_ca_vente_ht, ca.commercial_cd_currency, ca.ntl_accounting_exchange_rate, ca.montant_ca_comptable_ttc, ca.montant_ca_comptable_tva, ca.montant_ca_comptable_ht, ca.accounting_cd_currency, ca.cd_produit, ca.cd_produit0, ca.cd_rub, ca.cd_tps, ca.ntl_num_lnl, ca.num_ihis, ca.num_ihis_arrhes, ca.num_ihis_charges, ca.num_ihis_od, ca.num_ihis_od2, ca.cd_saison, ca.num_fac, ca.montant_factur_, ca.montant_factur_2, ca.montant_non_factur_, ca.montant_non_factur_2, ca.date_etl
  • Filter: ((ca.num_soc = '3'::double precision) AND (ca.num_ihis_od2 = '310'::double precision))
  • Rows Removed by Filter: 2816592
  • Worker 0: actual time=0.071..10008.796 rows=175799 loops=1
  • Worker 1: actual time=1.268..10012.117 rows=181419 loops=1
  • Worker 2: actual time=0.799..10010.914 rows=185628 loops=1
  • Worker 3: actual time=0.976..10010.721 rows=182504 loops=1
14. 7.455 20.925 ↑ 1.0 4,472 5

Hash (cost=149.22..149.22 rows=4,472 width=7) (actual time=4.185..4.185 rows=4,472 loops=5)

  • Output: resalys_a_produit.cd_produit
  • Buckets: 8192 Batches: 1 Memory Usage: 237kB
  • Worker 0: actual time=2.773..2.773 rows=4472 loops=1
  • Worker 1: actual time=5.178..5.178 rows=4472 loops=1
  • Worker 2: actual time=4.062..4.062 rows=4472 loops=1
  • Worker 3: actual time=5.515..5.515 rows=4472 loops=1
15. 13.470 13.470 ↑ 1.0 4,472 5

Seq Scan on public.sresalys_a_produit resalys_a_produit (cost=0.00..149.22 rows=4,472 width=7) (actual time=0.048..2.694 rows=4,472 loops=5)

  • Output: resalys_a_produit.cd_produit
  • Filter: ((resalys_a_produit.cd_produit)::text <> ALL ('{CXL,CXM,FD,PECOCCCAS,PECOCCCGO,PECPARCAS,PECPARCGO,REMCNAS,REMISECGO}'::text[]))
  • Rows Removed by Filter: 9
  • Worker 0: actual time=0.033..1.801 rows=4472 loops=1
  • Worker 1: actual time=0.077..3.227 rows=4472 loops=1
  • Worker 2: actual time=0.043..2.568 rows=4472 loops=1
  • Worker 3: actual time=0.080..3.520 rows=4472 loops=1
16. 3.705 35.920 ↑ 1.0 3,676 5

Hash (cost=569.06..569.06 rows=3,676 width=8) (actual time=7.184..7.184 rows=3,676 loops=5)

  • Output: date_conso.date_, dw_interm_diaire_a_semaines_18.date_
  • Buckets: 4096 Batches: 1 Memory Usage: 176kB
  • Worker 0: actual time=6.198..6.198 rows=3676 loops=1
  • Worker 1: actual time=5.996..5.996 rows=3676 loops=1
  • Worker 2: actual time=6.800..6.800 rows=3676 loops=1
  • Worker 3: actual time=5.758..5.758 rows=3676 loops=1
17. 11.545 32.215 ↑ 1.0 3,676 5

Hash Join (cost=130.71..569.06 rows=3,676 width=8) (actual time=3.979..6.443 rows=3,676 loops=5)

  • Output: date_conso.date_, dw_interm_diaire_a_semaines_18.date_
  • Hash Cond: (date_conso.date_ = dw_interm_diaire_a_semaines_18.date_)
  • Worker 0: actual time=3.278..5.455 rows=3676 loops=1
  • Worker 1: actual time=3.240..5.283 rows=3676 loops=1
  • Worker 2: actual time=4.002..6.065 rows=3676 loops=1
  • Worker 3: actual time=3.021..5.039 rows=3676 loops=1
18. 12.310 12.310 ↑ 1.0 9,134 5

Seq Scan on public.sdivers_a_temps date_conso (cost=0.00..367.34 rows=9,134 width=4) (actual time=0.035..2.462 rows=9,134 loops=5)

  • Output: date_conso.date_, date_conso.anmoisjour, date_conso.jour, date_conso.jour_semaine, date_conso.moisjour, date_conso.semaine, date_conso.semaine_compa, date_conso.semaine_samsam, date_conso.semaine_sam_sam2, date_conso.semaine_dim_dim2, date_conso.semaine_compa_samsam, date_conso.anmois, date_conso.mois, date_conso.mois_compa, date_conso.libell__mois_compa, date_conso.libelle_mois, date_conso.mois_et_libelle_mois, date_conso.trimestre, date_conso.semestre, date_conso.annee, date_conso.ann_e_compa, date_conso.exercice, date_conso.cperiode_, date_conso.type_jour, date_conso.duree_travail, date_conso.jour_ferie
  • Worker 0: actual time=0.015..1.796 rows=9134 loops=1
  • Worker 1: actual time=0.022..1.460 rows=9134 loops=1
  • Worker 2: actual time=0.021..1.634 rows=9134 loops=1
  • Worker 3: actual time=0.020..1.489 rows=9134 loops=1
19. 3.975 8.360 ↑ 1.0 3,676 5

Hash (cost=84.76..84.76 rows=3,676 width=4) (actual time=1.672..1.672 rows=3,676 loops=5)

  • Output: dw_interm_diaire_a_semaines_18.date_
  • Buckets: 4096 Batches: 1 Memory Usage: 162kB
  • Worker 0: actual time=1.422..1.422 rows=3676 loops=1
  • Worker 1: actual time=1.492..1.492 rows=3676 loops=1
  • Worker 2: actual time=2.078..2.078 rows=3676 loops=1
  • Worker 3: actual time=1.335..1.335 rows=3676 loops=1
20. 4.385 4.385 ↑ 1.0 3,676 5

Seq Scan on public.wmod_les_in_i_semaines_vacance dw_interm_diaire_a_semaines_18 (cost=0.00..84.76 rows=3,676 width=4) (actual time=0.049..0.877 rows=3,676 loops=5)

  • Output: dw_interm_diaire_a_semaines_18.date_
  • Worker 0: actual time=0.015..0.760 rows=3676 loops=1
  • Worker 1: actual time=0.041..0.720 rows=3676 loops=1
  • Worker 2: actual time=0.018..1.020 rows=3676 loops=1
  • Worker 3: actual time=0.016..0.630 rows=3676 loops=1
21. 136.845 178.260 ↓ 45.9 177,962 5

Sort (cost=1,259.13..1,268.82 rows=3,873 width=27) (actual time=16.045..35.652 rows=177,962 loops=5)

  • Output: resalys_a_rubrique_comptabl_35.etab_num, resalys_a_rubrique_comptabl_35.cd_rub, resalys_a_rubrique_comptabl_35.num_soc, resalys_a_soci_t_.num_soc
  • Sort Key: resalys_a_rubrique_comptabl_35.etab_num, resalys_a_rubrique_comptabl_35.cd_rub
  • Sort Method: quicksort Memory: 747kB
  • Worker 0: Sort Method: quicksort Memory: 747kB
  • Worker 1: Sort Method: quicksort Memory: 747kB
  • Worker 2: Sort Method: quicksort Memory: 747kB
  • Worker 3: Sort Method: quicksort Memory: 747kB
  • Worker 0: actual time=12.918..33.571 rows=172823 loops=1
  • Worker 1: actual time=20.256..44.324 rows=177639 loops=1
  • Worker 2: actual time=13.519..34.681 rows=181617 loops=1
  • Worker 3: actual time=20.487..39.146 rows=178710 loops=1
22. 7.575 41.415 ↓ 1.8 7,093 5

Nested Loop (cost=0.00..1,028.32 rows=3,873 width=27) (actual time=0.184..8.283 rows=7,093 loops=5)

  • Output: resalys_a_rubrique_comptabl_35.etab_num, resalys_a_rubrique_comptabl_35.cd_rub, resalys_a_rubrique_comptabl_35.num_soc, resalys_a_soci_t_.num_soc
  • Worker 0: actual time=0.185..6.049 rows=7093 loops=1
  • Worker 1: actual time=0.232..13.025 rows=7093 loops=1
  • Worker 2: actual time=0.162..6.522 rows=7093 loops=1
  • Worker 3: actual time=0.225..9.762 rows=7093 loops=1
23. 0.495 0.495 ↑ 1.0 1 5

Seq Scan on public.sresalys_a_soci_t_ resalys_a_soci_t_ (cost=0.00..1.06 rows=1 width=8) (actual time=0.099..0.099 rows=1 loops=5)

  • Output: resalys_a_soci_t_.num_soc, resalys_a_soci_t_.bac_nom, resalys_a_soci_t_.cd_currency, resalys_a_soci_t_.bac_fac_souche, resalys_a_soci_t_.bac_buy_workspace, resalys_a_soci_t_.invoice_padding, resalys_a_soci_t_.fl_default, resalys_a_soci_t_.ade_adresse1, resalys_a_soci_t_.ade_adresse2, resalys_a_soci_t_.ade_ville, resalys_a_soci_t_.ade_postal, resalys_a_soci_t_.ade_tel1, resalys_a_soci_t_.ade_fax, resalys_a_soci_t_.ade_mail, resalys_a_soci_t_.ade_tel2, resalys_a_soci_t_.ade_pays, resalys_a_soci_t_.cd_country, resalys_a_soci_t_.ade_tel3, resalys_a_soci_t_.ade_street_number, resalys_a_soci_t_.ade_street, resalys_a_soci_t_.ade_building, resalys_a_soci_t_.ade_stairs, resalys_a_soci_t_.ade_apart_num, resalys_a_soci_t_.ade_no_mail, resalys_a_soci_t_.postal_locality, resalys_a_soci_t_.ade_longitude, resalys_a_soci_t_.ade_latitude, resalys_a_soci_t_.account_number, resalys_a_soci_t_.rib_key, resalys_a_soci_t_.type0, resalys_a_soci_t_.label, resalys_a_soci_t_.bank_code, resalys_a_soci_t_.agency_code, resalys_a_soci_t_.bic_code, resalys_a_soci_t_.iban, resalys_a_soci_t_.valid, resalys_a_soci_t_.compte_comptable_sp_cifique, resalys_a_soci_t_.code_tiers_sp_cifique, resalys_a_soci_t_.activer_la_refacturation, resalys_a_soci_t_.reinvoicing_cd_client, resalys_a_soci_t_.reinvoicing_cd_tax, resalys_a_soci_t_.reinvoicing_num_cli
  • Filter: (resalys_a_soci_t_.num_soc = '3'::double precision)
  • Rows Removed by Filter: 4
  • Worker 0: actual time=0.127..0.127 rows=1 loops=1
  • Worker 1: actual time=0.071..0.071 rows=1 loops=1
  • Worker 2: actual time=0.096..0.096 rows=1 loops=1
  • Worker 3: actual time=0.141..0.141 rows=1 loops=1
24. 33.345 33.345 ↓ 1.8 7,093 5

Seq Scan on public.sresalys_a_rubrique_comptab resalys_a_rubrique_comptabl_35 (cost=0.00..988.52 rows=3,873 width=19) (actual time=0.057..6.669 rows=7,093 loops=5)

  • Output: resalys_a_rubrique_comptabl_35.etab_num, resalys_a_rubrique_comptabl_35.num_soc, resalys_a_rubrique_comptabl_35.num_export_type, resalys_a_rubrique_comptabl_35.cd_rub, resalys_a_rubrique_comptabl_35.i_cpt, resalys_a_rubrique_comptabl_35.i_lb_rub, resalys_a_rubrique_comptabl_35.cd_jour, resalys_a_rubrique_comptabl_35.lb_jour, resalys_a_rubrique_comptabl_35.rub_analytic_cpt, resalys_a_rubrique_comptabl_35.cd_jour_realized, resalys_a_rubrique_comptabl_35.lb_jour0
  • Filter: ((resalys_a_rubrique_comptabl_35.num_soc = '3'::double precision) AND (resalys_a_rubrique_comptabl_35.num_export_type = '6'::double precision))
  • Rows Removed by Filter: 24742
  • Worker 0: actual time=0.026..4.474 rows=7093 loops=1
  • Worker 1: actual time=0.159..11.550 rows=7093 loops=1
  • Worker 2: actual time=0.033..5.030 rows=7093 loops=1
  • Worker 3: actual time=0.045..7.693 rows=7093 loops=1
25. 2.250 2.250 ↑ 1.5 294 5

Index Scan using w_a_etablissement_pkey on public.w_a_etablissement dw_interm_diaire_a_etabliss_5 (cost=0.27..34.34 rows=438 width=12) (actual time=0.045..0.450 rows=294 loops=5)

  • Output: dw_interm_diaire_a_etabliss_5.etab_num, dw_interm_diaire_a_etabliss_5.etab_nom, dw_interm_diaire_a_etabliss_5.eta_nom, dw_interm_diaire_a_etabliss_5.eta_buy_workspace, dw_interm_diaire_a_etabliss_5.etab_nom_web, dw_interm_diaire_a_etabliss_5.text_value, dw_interm_diaire_a_etabliss_5.date_value, dw_interm_diaire_a_etabliss_5.date_value0, dw_interm_diaire_a_etabliss_5.trigramme, dw_interm_diaire_a_etabliss_5.cat_destination, dw_interm_diaire_a_etabliss_5.tla_trad00, dw_interm_diaire_a_etabliss_5.tla_trad01, dw_interm_diaire_a_etabliss_5.tla_trad02, dw_interm_diaire_a_etabliss_5.tla_trad03, dw_interm_diaire_a_etabliss_5.pays, dw_interm_diaire_a_etabliss_5.ade_postal, dw_interm_diaire_a_etabliss_5.ade_ville, dw_interm_diaire_a_etabliss_5.capacite_n1, dw_interm_diaire_a_etabliss_5.eta_client_sell_aux_code, dw_interm_diaire_a_etabliss_5.eta_ca_sell_aux_code, dw_interm_diaire_a_etabliss_5.eta_client_payment_aux_code, dw_interm_diaire_a_etabliss_5.eta_ca_payment_aux_code, dw_interm_diaire_a_etabliss_5.eta_client_arrhes_aux_code, dw_interm_diaire_a_etabliss_5.etab_analytic_cpt, dw_interm_diaire_a_etabliss_5.num_soc, dw_interm_diaire_a_etabliss_5.bac_nom, dw_interm_diaire_a_etabliss_5.num_export_type
  • Worker 0: actual time=0.044..0.545 rows=298 loops=1
  • Worker 1: actual time=0.013..0.672 rows=300 loops=1
  • Worker 2: actual time=0.052..0.407 rows=298 loops=1
  • Worker 3: actual time=0.044..0.392 rows=300 loops=1
26. 0.000 0.000 ↑ 1.0 1 862,808

Materialize (cost=0.00..5.03 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=862,808)

  • Output: resalys_a_export_comptable__52.num_ihis
27. 0.082 0.082 ↑ 1.0 1 1

Seq Scan on public.sresalys_a_export_comptab1le resalys_a_export_comptable__52 (cost=0.00..5.03 rows=1 width=8) (actual time=0.079..0.082 rows=1 loops=1)

  • Output: resalys_a_export_comptable__52.num_ihis
  • Filter: (resalys_a_export_comptable__52.num_ihis = '310'::double precision)
  • Rows Removed by Filter: 241
28. 17.540 20.274 ↓ 375.3 210,570 1

Sort (cost=146.29..147.69 rows=561 width=43) (actual time=4.691..20.274 rows=210,570 loops=1)

  • Output: resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_rubrique_comptabl_57.i_cpt, resalys_a_rubrique_comptabl_57.etab_num, resalys_a_rubrique_comptabl_57.cd_rub
  • Sort Key: resalys_a_rubrique_comptabl_57.etab_num, resalys_a_rubrique_comptabl_57.cd_rub
  • Sort Method: quicksort Memory: 68kB
29. 2.734 2.734 ↑ 1.0 561 1

Seq Scan on public.sresalys_a_rubrique_compt2ab resalys_a_rubrique_comptabl_57 (cost=0.00..120.68 rows=561 width=43) (actual time=0.395..2.734 rows=561 loops=1)

  • Output: resalys_a_rubrique_comptabl_57.bac_nom, resalys_a_rubrique_comptabl_57.i_cpt, resalys_a_rubrique_comptabl_57.etab_num, resalys_a_rubrique_comptabl_57.cd_rub
  • Filter: (resalys_a_rubrique_comptabl_57.num_soc = '12'::double precision)
  • Rows Removed by Filter: 3013
30. 0.067 0.125 ↑ 1.0 242 1

Hash (cost=4.42..4.42 rows=242 width=8) (actual time=0.124..0.125 rows=242 loops=1)

  • Output: resalys_a_export_comptable.num_ihis
  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
31. 0.058 0.058 ↑ 1.0 242 1

Seq Scan on public.sresalys_a_export_comptab1le resalys_a_export_comptable (cost=0.00..4.42 rows=242 width=8) (actual time=0.033..0.058 rows=242 loops=1)

  • Output: resalys_a_export_comptable.num_ihis