time consuming binding elevé pgbadger

Bonjour à tous,

j' utilise pgbadger pour analyser un problème de performance ( postgresql 9.5, code hibernate ),
j ai une requête qui présente un temps de binding ( time consuming binding) entre 7ms et 20ms => Exécutée 23757 fois, ça me fait un total de 3m19s.
question :
Est-ce normal pour un prédicat simpliste avec une seule bind variable (WHERE csgdto0_.DTO_ID = $1; )
si oui comment je peux faire tomber ce temps de binding ?
ci joint

* la capture pgbadger,
* le requête,
* plan d exécution

merci d avance pour les éclaircissements.

[cid:e4253bfa-5b72-476b-a97d-ea6f0e4b1eb9]

SELECT
csgdto0_.ID AS ID1_8_19_,
csgdto0_.alert_description AS alert_de2_8_19_,
csgdto0_.alert_type AS alert_ty3_8_19_,
csgdto0_.beam_id AS beam_id4_8_19_,
csgdto0_.cost AS cost5_8_19_,
csgdto0_.csg_dto_id AS csg_dto_6_8_19_,
csgdto0_.DI2SDTOINFOS_CSGDTO_ID AS DI19_8_19_,
csgdto0_.download_end_date AS download7_8_19_,
csgdto0_.download_start_date AS download8_8_19_,
csgdto0_.look_angle AS look_ang9_8_19_,
csgdto0_.look_side AS look_si10_8_19_,
csgdto0_.nb_level_one_expected AS nb_leve11_8_19_,
csgdto0_.nb_level_one_received AS nb_leve12_8_19_,
csgdto0_.nb_level_zero_received AS nb_leve13_8_19_,
csgdto0_.nb_prod_with_known_nb_of_level_one_expected AS nb_prod14_8_19_,
csgdto0_.DTO_ID AS DTO_ID20_8_19_,
csgdto0_.polarization_channels AS polariz15_8_19_,
csgdto0_.shooting_mode AS shootin16_8_19_,
csgdto0_.sparc_info AS sparc_i17_8_19_,
csgdto0_.sub_mode_id AS sub_mod18_8_19_,
csgdto0_.ZICSG_CSGDTO_ID AS ZICSG_C21_8_19_,
di2sdto1_.ID AS ID1_16_0_,
di2sdto1_.ZIDI2S_DI2SDTO_ID AS ZIDI9_16_0_,
di2sdto1_.beam_id AS beam_id2_16_0_,
di2sdto1_.interleaved_channel AS interlea3_16_0_,
di2sdto1_.look_angle AS look_ang4_16_0_,
di2sdto1_.look_side AS look_sid5_16_0_,
di2sdto1_.polarization_channels AS polariza6_16_0_,
di2sdto1_.sensing_end_time AS sensing_7_16_0_,
di2sdto1_.sensing_start_time AS sensing_8_16_0_,
zi2_.ID AS ID1_83_1_,
zi2_.band_cap AS band_cap2_83_1_,
zi2_.band_length AS band_len3_83_1_,
zi2_.band_width AS band_wid4_83_1_,
zi2_.CIRCLE_CENTER AS CIRCLE_C5_83_1_,
zi2_.circle_radius AS circle_r6_83_1_,
zi2_.COVERAGE AS COVERAGE7_83_1_,
zi2_.zone_type AS zone_typ8_83_1_,
dto3_.ID AS ID1_19_2_,
dto3_.reject_status AS reject_s2_19_2_,
dto3_.status_prog AS status_p3_19_2_,
dto3_.utility AS utility4_19_2_,
dto3_.is_backup AS is_backu5_19_2_,
dto3_.domain AS domain6_19_2_,
dto3_.dto_rank AS dto_rank7_19_2_,
dto3_.earliest_begin_date AS earliest8_19_2_,
dto3_.earliest_end_date AS earliest9_19_2_,
dto3_.election_rank AS electio10_19_2_,
dto3_.hier_compartment AS hier_co11_19_2_,
dto3_.hier_level AS hier_le12_19_2_,
dto3_.hier_rank AS hier_ra13_19_2_,
dto3_.id_cacq AS id_cacq14_19_2_,
dto3_.id_cacqlist AS id_cacq15_19_2_,
dto3_.id_regroup AS id_regr16_19_2_,
dto3_.indisponibility_status AS indispo17_19_2_,
dto3_.is_urgent AS is_urge18_19_2_,
dto3_.latest_begin_date AS latest_19_19_2_,
dto3_.latest_end_date AS latest_20_19_2_,
dto3_.latest_sending_date AS latest_21_19_2_,
dto3_.mission_orbit_number AS mission22_19_2_,
dto3_.mplib_info AS mplib_i23_19_2_,
dto3_.note_meteo AS note_me24_19_2_,
dto3_.orbit_cycle_number AS orbit_c25_19_2_,
dto3_.orbital_direction AS orbital26_19_2_,
dto3_.ACQR_ID AS ACQR_ID50_19_2_,
dto3_.plan_status AS plan_st27_19_2_,
dto3_.pso_max AS pso_max28_19_2_,
dto3_.pso_min AS pso_min29_19_2_,
dto3_.ref_orbit_number AS ref_orb30_19_2_,
dto3_.reject_ssu_cause AS reject_31_19_2_,
dto3_.rejected_cause_details_high_prio AS rejecte32_19_2_,
dto3_.rejected_cause_details_prio AS rejecte33_19_2_,
dto3_.rejected_cause_details_routine AS rejecte34_19_2_,
dto3_.rejected_cause_high_prio AS rejecte35_19_2_,
dto3_.rejected_cause_prio AS rejecte36_19_2_,
dto3_.rejected_cause_routine AS rejecte37_19_2_,
dto3_.sarah_incidence_angle AS sarah_i38_19_2_,
dto3_.sarah_look_side AS sarah_l39_19_2_,
dto3_.sarah_system_part_selection AS sarah_s40_19_2_,
dto3_.satellite AS satelli41_19_2_,
dto3_.shared_cost AS shared_42_19_2_,
dto3_.solar_angle AS solar_a43_19_2_,
dto3_.stat_last_modification AS stat_la44_19_2_,
dto3_.status AS status45_19_2_,
dto3_.sub_id AS sub_id46_19_2_,
dto3_.CSGSUBSCRIPTION_ID AS CSGSUBS51_19_2_,
dto3_.type_acces AS type_ac47_19_2_,
dto3_.urgent_origin_id AS urgent_48_19_2_,
dto3_.validation_comment AS validat49_19_2_,
acqr4_.ID AS ID1_0_3_,
acqr4_.ident_cost AS ident_co2_0_3_,
acqr4_.reco_cost AS reco_cos3_0_3_,
acqr4_.acq_filter AS acq_filt4_0_3_,
acqr4_.acq_programmation AS acq_prog5_0_3_,
acqr4_.alternative_flag AS alternat6_0_3_,
acqr4_.ACQR_CENTER AS ACQR_CEN7_0_3_,
acqr4_.group_indicator AS group_in8_0_3_,
acqr4_.HIERHZM_ACQR_ID AS HIERHZM29_0_3_,
acqr4_.hier_weight AS hier_wei9_0_3_,
acqr4_.CSGCOMMENT AS CSGCOMM10_0_3_,
acqr4_.IDENTCOMMENT AS IDENTCO11_0_3_,
acqr4_.RECOCOMMENT AS RECOCOM12_0_3_,
acqr4_.id_acqr_origine AS id_acqr13_0_3_,
acqr4_.index_inter_period AS index_i14_0_3_,
acqr4_.is_ascending AS is_asce15_0_3_,
acqr4_.last_dto_date AS last_dt16_0_3_,
acqr4_.LOCALID AS LOCALID17_0_3_,
acqr4_.luminosity AS luminos18_0_3_,
acqr4_.nextDtoAnglePDV AS nextDto19_0_3_,
acqr4_.next_dto_date AS next_dt20_0_3_,
acqr4_.next_dto_weather_note AS next_dt21_0_3_,
acqr4_.PROGR_ID AS PROGR_I30_0_3_,
acqr4_.PERIOD_ID AS PERIOD_31_0_3_,
acqr4_.revision AS revisio22_0_3_,
acqr4_.stat_last_modification AS stat_la23_0_3_,
acqr4_.stat_zi_area AS stat_zi24_0_3_,
acqr4_.status AS status25_0_3_,
acqr4_.sub_id AS sub_id26_0_3_,
acqr4_.urgent_origin_id AS urgent_27_0_3_,
acqr4_.validation_date AS validat28_0_3_,
perioddate5_.ID AS ID1_56_4_,
perioddate5_.ENDDATE AS ENDDATE2_56_4_,
perioddate5_.STARTDATE AS STARTDAT3_56_4_,
progr6_.ID AS ID1_63_5_,
progr6_.all_nat_priority_rank AS all_nat_2_63_5_,
progr6_.automatic_delivery AS automati3_63_5_,
progr6_.automatic_prod AS automati4_63_5_,
progr6_.begin_period AS begin_pe5_63_5_,
progr6_.capture_parameter AS capture_6_63_5_,
progr6_.change_date AS change_d7_63_5_,
progr6_.cloned_from_cil AS cloned_f8_63_5_,
progr6_.completion_percentage AS completi9_63_5_,
progr6_.cor_last_prio_date AS cor_las10_63_5_,
progr6_.cor_login AS cor_log11_63_5_,
progr6_.cor_priority_class AS cor_pri12_63_5_,
progr6_.cor_priority_comment AS cor_pri13_63_5_,
progr6_.cor_priority_note AS cor_pri14_63_5_,
progr6_.cor_priority_rank AS cor_pri15_63_5_,
progr6_.country_name AS country16_63_5_,
progr6_.creation_date AS creatio17_63_5_,
progr6_.dto_left AS dto_lef18_63_5_,
progr6_.end_date_first_period_pir AS end_dat19_63_5_,
progr6_.end_period AS end_per20_63_5_,
progr6_.generic_site_name AS generic21_63_5_,
progr6_.interval_hour_bewteen_acq AS interva22_63_5_,
progr6_.interval_hour_bewteen_pir AS interva23_63_5_,
progr6_.is_expired AS is_expi24_63_5_,
progr6_.is_pir AS is_pir25_63_5_,
progr6_.is_system_part_specific AS is_syst26_63_5_,
progr6_.last_dto_date AS last_dt27_63_5_,
progr6_.last_prio_organism AS last_pr28_63_5_,
progr6_.max_angle_between_dto_of_pir AS max_ang29_63_5_,
progr6_.maximum_baseline AS maximum30_63_5_,
progr6_.modification_date AS modific31_63_5_,
progr6_.modification_op_id AS modific32_63_5_,
progr6_.nat_last_prio_date AS nat_las33_63_5_,
progr6_.nat_priority_comment AS nat_pri34_63_5_,
progr6_.nat_priority_note AS nat_pri35_63_5_,
progr6_.nationality AS nationa36_63_5_,
progr6_.nb_acq AS nb_acq37_63_5_,
progr6_.PROG_PARAM_ID AS PROG_PA52_63_5_,
progr6_.DIR_ID AS DIR_ID53_63_5_,
progr6_.priority_class AS priorit38_63_5_,
progr6_.progress_status AS progres39_63_5_,
progr6_.realisation_date AS realisa40_63_5_,
progr6_.ref_prog_urgente_SSUI AS ref_pro41_63_5_,
progr6_.reject_reason AS reject_42_63_5_,
progr6_.revision AS revisio43_63_5_,
progr6_.sarah_altitude AS sarah_a44_63_5_,
progr6_.sarah_estimated_cost AS sarah_e45_63_5_,
progr6_.sensor_nat_priority_rank AS sensor_46_63_5_,
progr6_.stat_last_modification AS stat_la47_63_5_,
progr6_.stat_zi_area AS stat_zi48_63_5_,
progr6_.status_prog AS status_49_63_5_,
progr6_.sub_id AS sub_id50_63_5_,
progr6_.validation_date AS validat51_63_5_,
progr6_.ZIDI2S_PROGR_ID AS ZIDI54_63_5_,
progr6_.ZIPROG_ID AS ZIPROG_55_63_5_,
progparam7_.ID AS ID1_62_6_,
progparam7_.dtm_selection AS dtm_sele2_62_6_,
progparam7_.acquisition_mode AS acquisit3_62_6_,
progparam7_.analysis_method AS analysis4_62_6_,
progparam7_.angular_constraint_type AS angular_5_62_6_,
progparam7_.antenna_look_direction AS antenna_6_62_6_,
progparam7_.baseline_max AS baseline7_62_6_,
progparam7_.baseline_min AS baseline8_62_6_,
progparam7_.bh_max AS bh_max9_62_6_,
progparam7_.bh_min AS bh_min10_62_6_,
progparam7_.cap AS cap11_62_6_,
progparam7_.cap_jour AS cap_jou12_62_6_,
progparam7_.cap_nuit AS cap_nui13_62_6_,
progparam7_.cloudcover_max AS cloudco14_62_6_,
progparam7_.cloud_max_validation AS cloud_m15_62_6_,
progparam7_.coverage_required AS coverag16_62_6_,
progparam7_.delay AS delay17_62_6_,
progparam7_.di2s_flag AS di18_62_6_,
progparam7_.division_authorisation AS divisio19_62_6_,
progparam7_.domain AS domain20_62_6_,
progparam7_.elevation_max AS elevati21_62_6_,
progparam7_.elevation_min AS elevati22_62_6_,
progparam7_.flight_direction AS flight_23_62_6_,
progparam7_.geodetic_azimuth_max AS geodeti24_62_6_,
progparam7_.geodetic_azimuth_min AS geodeti25_62_6_,
progparam7_.group_authorisation AS group_a26_62_6_,
progparam7_.haze_accepted AS haze_ac27_62_6_,
progparam7_.inv_priority AS inv_pri28_62_6_,
progparam7_.inventory_center AS invento29_62_6_,
progparam7_.ir_mandatory AS ir_mand30_62_6_,
progparam7_.LOCALPERIOD_ID AS LOCALPE76_62_6_,
progparam7_.look_direction AS look_di31_62_6_,
progparam7_.luminosity_indicator AS luminos32_62_6_,
progparam7_.luminosity_type AS luminos33_62_6_,
progparam7_.match_allowed AS match_a34_62_6_,
progparam7_.mesh_length AS mesh_le35_62_6_,
progparam7_.mission AS mission36_62_6_,
progparam7_.mission_type AS mission37_62_6_,
progparam7_.mono_pass AS mono_pa38_62_6_,
progparam7_.psi_xy AS psi_xy39_62_6_,
progparam7_.lambda_max_mono AS lambda_40_62_6_,
progparam7_.lambda_min_mono AS lambda_41_62_6_,
progparam7_.phi_max_mono AS phi_max42_62_6_,
progparam7_.phi_min_mono AS phi_min43_62_6_,
progparam7_.polarisation_channels AS polaris44_62_6_,
progparam7_.relief_type AS relief_45_62_6_,
progparam7_.sandwind_accepted AS sandwin46_62_6_,
progparam7_.sarah_capture_type AS sarah_c47_62_6_,
progparam7_.sarah_system_part_selection AS sarah_s48_62_6_,
progparam7_.sensor AS sensor49_62_6_,
progparam7_.sharable AS sharabl50_62_6_,
progparam7_.shooting_mode AS shootin51_62_6_,
progparam7_.snowcover_max AS snowcov52_62_6_,
progparam7_.specularity_indicator AS specula53_62_6_,
progparam7_.stat_last_modification AS stat_la54_62_6_,
progparam7_.elevation_max_stereo AS elevati55_62_6_,
progparam7_.elevation_min_stereo AS elevati56_62_6_,
progparam7_.geodetic_azimuth_max_stereo AS geodeti57_62_6_,
progparam7_.geodetic_azimuth_min_stereo AS geodeti58_62_6_,
progparam7_.stereo_type AS stereo_59_62_6_,
progparam7_.psi_xy_stereo AS psi_xy_60_62_6_,
progparam7_.lambda_max_stereo AS lambda_61_62_6_,
progparam7_.lambda_min_stereo AS lambda_62_62_6_,
progparam7_.phi_max_stereo AS phi_max63_62_6_,
progparam7_.phi_min_stereo AS phi_min64_62_6_,
progparam7_.elevation_max_tri_stereo AS elevati65_62_6_,
progparam7_.elevation_min_tri_stereo AS elevati66_62_6_,
progparam7_.geodetic_azimuth_max_tri_stereo AS geodeti67_62_6_,
progparam7_.geodetic_azimuth_min_tri_stereo AS geodeti68_62_6_,
progparam7_.psi_xy_tri_stereo AS psi_xy_69_62_6_,
progparam7_.lambda_max_tri_stereo AS lambda_70_62_6_,
progparam7_.lambda_min_tri_stereo AS lambda_71_62_6_,
progparam7_.phi_max_tri_stereo AS phi_max72_62_6_,
progparam7_.phi_min_tri_stereo AS phi_min73_62_6_,
progparam7_.type_cap AS type_ca74_62_6_,
progparam7_.validation_mode AS validat75_62_6_,
periodtime8_.ID AS ID1_57_7_,
periodtime8_.ENDTIMEITEM AS ENDTIMEI2_57_7_,
periodtime8_.STARTTIMEITEM AS STARTTIM3_57_7_,
dir9_.ID AS ID1_17_8_,
dir9_.automatic_delivery AS automati2_17_8_,
dir9_.automatic_prod AS automati3_17_8_,
dir9_.category_id AS category4_17_8_,
dir9_.country_name AS country_5_17_8_,
dir9_.creation_date AS creation6_17_8_,
dir9_.del_type AS del_type7_17_8_,
dir9_.deposit_cell AS deposit_8_17_8_,
dir9_.deposit_comment AS deposit_9_17_8_,
dir9_.deposit_country AS deposit10_17_8_,
dir9_.deposit_organisation AS deposit11_17_8_,
dir9_.ipr_Id AS ipr_Id12_17_8_,
dir9_.is_expired AS is_expi13_17_8_,
dir9_.mission_id AS mission14_17_8_,
dir9_.modification_date AS modific15_17_8_,
dir9_.modification_op_id AS modific16_17_8_,
dir9_.ms_indicator AS ms_indi17_17_8_,
dir9_.name AS name18_17_8_,
dir9_.nationality AS nationa19_17_8_,
dir9_.creator_name AS creator20_17_8_,
dir9_.DEL_PARAM_ID AS DEL_PAR43_17_8_,
dir9_.period_type AS period_21_17_8_,
dir9_.priority_class AS priorit22_17_8_,
dir9_.od_priority_comment AS od_prio23_17_8_,
dir9_.priority_level AS priorit24_17_8_,
dir9_.progress_status AS progres25_17_8_,
dir9_.reject_reason AS reject_26_17_8_,
dir9_.remarkable_event AS remarka27_17_8_,
dir9_.classification AS classif28_17_8_,
dir9_.resolution AS resolut29_17_8_,
dir9_.revision AS revisio30_17_8_,
dir9_.sensor_type AS sensor_31_17_8_,
dir9_.site_name AS site_na32_17_8_,
dir9_.sleeping_days AS sleepin33_17_8_,
dir9_.stat_last_modification AS stat_la34_17_8_,
dir9_.stat_zi_area AS stat_zi35_17_8_,
dir9_.status AS status36_17_8_,
dir9_.toponym AS toponym37_17_8_,
dir9_.urgent_initiator_country AS urgent_38_17_8_,
dir9_.urgent_origin_dirid AS urgent_39_17_8_,
dir9_.validity_begin_date AS validit40_17_8_,
dir9_.validity_end_date AS validit41_17_8_,
dir9_.ZIGEO_ID AS ZIGEO_I44_17_8_,
dir9_.zone_id AS zone_id42_17_8_,
delparam10_.ID AS ID1_14_9_,
delparam10_.del_priority AS del_prio2_14_9_,
delparam10_.delivery_address AS delivery3_14_9_,
delparam10_.delivery_cell AS delivery4_14_9_,
delparam10_.delivery_comment AS delivery5_14_9_,
delparam10_.delivery_country AS delivery6_14_9_,
delparam10_.delivery_mode AS delivery7_14_9_,
delparam10_.delivery_organisation AS delivery8_14_9_,
delparam10_.interconnection_spaceCD AS intercon9_14_9_,
delparam10_.interconnection_spaceSD AS interco10_14_9_,
delparam10_.recipient_information AS recipie11_14_9_,
delparam10_.stat_last_modification AS stat_la12_14_9_,
zi11_.ID AS ID1_83_10_,
zi11_.band_cap AS band_cap2_83_10_,
zi11_.band_length AS band_len3_83_10_,
zi11_.band_width AS band_wid4_83_10_,
zi11_.CIRCLE_CENTER AS CIRCLE_C5_83_10_,
zi11_.circle_radius AS circle_r6_83_10_,
zi11_.COVERAGE AS COVERAGE7_83_10_,
zi11_.zone_type AS zone_typ8_83_10_,
zi12_.ID AS ID1_83_11_,
zi12_.band_cap AS band_cap2_83_11_,
zi12_.band_length AS band_len3_83_11_,
zi12_.band_width AS band_wid4_83_11_,
zi12_.CIRCLE_CENTER AS CIRCLE_C5_83_11_,
zi12_.circle_radius AS circle_r6_83_11_,
zi12_.COVERAGE AS COVERAGE7_83_11_,
zi12_.zone_type AS zone_typ8_83_11_,
zi13_.ID AS ID1_83_12_,
zi13_.band_cap AS band_cap2_83_12_,
zi13_.band_length AS band_len3_83_12_,
zi13_.band_width AS band_wid4_83_12_,
zi13_.CIRCLE_CENTER AS CIRCLE_C5_83_12_,
zi13_.circle_radius AS circle_r6_83_12_,
zi13_.COVERAGE AS COVERAGE7_83_12_,
zi13_.zone_type AS zone_typ8_83_12_,
perioddate14_.ID AS ID1_56_13_,
perioddate14_.ENDDATE AS ENDDATE2_56_13_,
perioddate14_.STARTDATE AS STARTDAT3_56_13_,
csgacqr15_.ID AS ID1_7_14_,
csgacqr15_.csg_acqr_id AS csg_acqr2_7_14_,
csgacqr15_.csg_request_id AS csg_requ3_7_14_,
csgacqr15_.csg_unique_identifier AS csg_uniq4_7_14_,
csgacqr15_.di2s_availibility_confirmation AS di5_7_14_,
csgacqr15_.ACQR_ID AS ACQR_ID7_7_14_,
csgacqr15_.urgent_processing_state AS urgent_p6_7_14_,
csgacqr15_.ZICSG_CSGQACR_ID AS ZICSG_CS8_7_14_,
zi16_.ID AS ID1_83_15_,
zi16_.band_cap AS band_cap2_83_15_,
zi16_.band_length AS band_len3_83_15_,
zi16_.band_width AS band_wid4_83_15_,
zi16_.CIRCLE_CENTER AS CIRCLE_C5_83_15_,
zi16_.circle_radius AS circle_r6_83_15_,
zi16_.COVERAGE AS COVERAGE7_83_15_,
zi16_.zone_type AS zone_typ8_83_15_,
csgsubscri17_.ID AS ID1_12_16_,
csgsubscri17_.acquisition_stations AS acquisit2_12_16_,
csgsubscri17_.beging_hz_date AS beging_h3_12_16_,
csgsubscri17_.end_hz_date AS end_hz_d4_12_16_,
csgsubscri17_.is_originator_fra AS is_origi5_12_16_,
csgsubscri17_.owner_id AS owner_id6_12_16_,
csgsubscri17_.CSGACQR_ID AS CSGACQR13_12_16_,
csgsubscri17_.status AS status7_12_16_,
csgsubscri17_.sub_id AS sub_id8_12_16_,
csgsubscri17_.subscribed_acqr AS subscrib9_12_16_,
csgsubscri17_.subscribed_progr AS subscri10_12_16_,
csgsubscri17_.unique_id AS unique_11_12_16_,
csgsubscri17_.user_class AS user_cl12_12_16_,
csgacqr18_.ID AS ID1_7_17_,
csgacqr18_.csg_acqr_id AS csg_acqr2_7_17_,
csgacqr18_.csg_request_id AS csg_requ3_7_17_,
csgacqr18_.csg_unique_identifier AS csg_uniq4_7_17_,
csgacqr18_.di2s_availibility_confirmation AS di5_7_17_,
csgacqr18_.ACQR_ID AS ACQR_ID7_7_17_,
csgacqr18_.urgent_processing_state AS urgent_p6_7_17_,
csgacqr18_.ZICSG_CSGQACR_ID AS ZICSG_CS8_7_17_,
zi19_.ID AS ID1_83_18_,
zi19_.band_cap AS band_cap2_83_18_,
zi19_.band_length AS band_len3_83_18_,
zi19_.band_width AS band_wid4_83_18_,
zi19_.CIRCLE_CENTER AS CIRCLE_C5_83_18_,
zi19_.circle_radius AS circle_r6_83_18_,
zi19_.COVERAGE AS COVERAGE7_83_18_,
zi19_.zone_type AS zone_typ8_83_18_
FROM
CSGDTO csgdto0_
LEFT OUTER JOIN DI2SDTO di2sdto1_ ON csgdto0_.DI2SDTOINFOS_CSGDTO_ID = di2sdto1_.ID
LEFT OUTER JOIN ZI zi2_ ON di2sdto1_.ZIDI2S_DI2SDTO_ID = zi2_.ID
LEFT OUTER JOIN DTO dto3_ ON csgdto0_.DTO_ID = dto3_.ID
LEFT OUTER JOIN ACQR acqr4_ ON dto3_.ACQR_ID = acqr4_.ID
LEFT OUTER JOIN PERIODDATE perioddate5_ ON acqr4_.HIERHZM_ACQR_ID = perioddate5_.ID
LEFT OUTER JOIN PROGR progr6_ ON acqr4_.PROGR_ID = progr6_.ID
LEFT OUTER JOIN PROGPARAM progparam7_ ON progr6_.PROG_PARAM_ID = progparam7_.ID
LEFT OUTER JOIN PERIODTIME periodtime8_ ON progparam7_.LOCALPERIOD_ID = periodtime8_.ID
LEFT OUTER JOIN DIR dir9_ ON progr6_.DIR_ID = dir9_.ID
LEFT OUTER JOIN DELPARAM delparam10_ ON dir9_.DEL_PARAM_ID = delparam10_.ID
LEFT OUTER JOIN ZI zi11_ ON dir9_.ZIGEO_ID = zi11_.ID
LEFT OUTER JOIN ZI zi12_ ON progr6_.ZIDI2S_PROGR_ID = zi12_.ID
LEFT OUTER JOIN ZI zi13_ ON progr6_.ZIPROG_ID = zi13_.ID
LEFT OUTER JOIN PERIODDATE perioddate14_ ON acqr4_.PERIOD_ID = perioddate14_.ID
LEFT OUTER JOIN CSGACQR csgacqr15_ ON acqr4_.ID = csgacqr15_.ACQR_ID
LEFT OUTER JOIN ZI zi16_ ON csgacqr15_.ZICSG_CSGQACR_ID = zi16_.ID
LEFT OUTER JOIN CSGSUBSCRIPTION csgsubscri17_ ON dto3_.CSGSUBSCRIPTION_ID = csgsubscri17_.ID
LEFT OUTER JOIN CSGACQR csgacqr18_ ON csgsubscri17_.CSGACQR_ID = csgacqr18_.ID
LEFT OUTER JOIN ZI zi19_ ON csgdto0_.ZICSG_CSGDTO_ID = zi19_.ID
WHERE
csgdto0_.DTO_ID = $1;

"Nested Loop Left Join (cost=48.49..82.62 rows=1 width=18561) (actual time=0.098..0.098 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=48.34..81.95 rows=1 width=18507) (actual time=0.097..0.097 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=48.20..73.78 rows=1 width=17640) (actual time=0.097..0.097 rows=0 loops=1)"
" -> Hash Right Join (cost=47.92..71.27 rows=1 width=17231) (actual time=0.096..0.096 rows=0 loops=1)"
" Hash Cond: (csgacqr15_.acqr_id = acqr4_.id)"
" -> Seq Scan on csgacqr csgacqr15_ (cost=0.00..19.70 rows=970 width=54) (never executed)"
" -> Hash (cost=47.91..47.91 rows=1 width=17177) (actual time=0.061..0.061 rows=0 loops=1)"
" Buckets: 1024 Batches: 1 Memory Usage: 0kB"
" -> Merge Right Join (cost=45.29..47.91 rows=1 width=17177) (actual time=0.061..0.061 rows=0 loops=1)"
" Merge Cond: (zi19_.id = csgdto0_.zicsg_csgdto_id)"
" -> Index Scan using zi_pkey on zi zi19_ (cost=0.28..1217.28 rows=3778 width=409) (actual time=0.015..0.015 rows=1 loops=1)"
" -> Sort (cost=45.01..45.02 rows=1 width=16768) (actual time=0.040..0.040 rows=0 loops=1)"
" Sort Key: csgdto0_.zicsg_csgdto_id"
" Sort Method: quicksort Memory: 25kB"
" -> Nested Loop Left Join (cost=3.78..45.00 rows=1 width=16768) (actual time=0.018..0.018 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=3.51..44.68 rows=1 width=16744) (actual time=0.017..0.017 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=3.23..43.22 rows=1 width=16335) (actual time=0.017..0.017 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=2.95..41.77 rows=1 width=15926) (actual time=0.017..0.017 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=2.67..40.32 rows=1 width=15517) (actual time=0.015..0.015 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=2.39..39.73 rows=1 width=15441) (actual time=0.015..0.015 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=2.11..38.93 rows=1 width=13373) (actual time=0.014..0.014 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=1.96..38.73 rows=1 width=13349) (actual time=0.014..0.014 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=1.68..37.71 rows=1 width=12900) (actual time=0.014..0.014 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=1.40..36.93 rows=1 width=9808) (actual time=0.012..0.012 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=1.13..36.60 rows=1 width=9784) (actual time=0.012..0.012 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=0.85..28.29 rows=1 width=6924) (actual time=0.011..0.011 rows=0 loops=1)"
" Join Filter: (csgdto0_.dto_id = dto3_.id)"
" -> Nested Loop Left Join (cost=0.57..19.98 rows=1 width=1922) (actual time=0.011..0.011 rows=0 loops=1)"
" -> Nested Loop Left Join (cost=0.29..16.33 rows=1 width=1513) (actual time=0.010..0.010 rows=0 loops=1)"
" -> Index Scan using dto_id_csgdto on csgdto csgdto0_ (cost=0.14..8.16 rows=1 width=1323) (actual time=0.010..0.010 rows=0 loops=1)"
" Index Cond: (dto_id = 1)"
" -> Index Scan using di2sdto_pkey on di2sdto di2sdto1_ (cost=0.15..8.17 rows=1 width=190) (never executed)"
" Index Cond: (csgdto0_.di2sdtoinfos_csgdto_id = id)"
" -> Index Scan using zi_pkey on zi zi2_ (cost=0.28..3.64 rows=1 width=409) (never executed)"
" Index Cond: (di2sdto1_.zidi2s_di2sdto_id = id)"
" -> Index Scan using dto_pkey on dto dto3_ (cost=0.28..8.30 rows=1 width=5002) (never executed)"
" Index Cond: (id = 1)"
" -> Index Scan using acqr_pkey on acqr acqr4_ (cost=0.28..8.30 rows=1 width=2860) (never executed)"
" Index Cond: (dto3_.acqr_id = id)"
" -> Index Scan using perioddate_pkey on perioddate perioddate5_ (cost=0.28..0.32 rows=1 width=24) (never executed)"
" Index Cond: (acqr4_.hierhzm_acqr_id = id)"
" -> Index Scan using progr_pkey on progr progr6_ (cost=0.28..0.77 rows=1 width=3092) (never executed)"
" Index Cond: (acqr4_.progr_id = id)"
" -> Index Scan using progparam_pkey on progparam progparam7_ (cost=0.28..1.01 rows=1 width=449) (never executed)"
" Index Cond: (progr6_.prog_param_id = id)"
" -> Index Scan using periodtime_pkey on periodtime periodtime8_ (cost=0.15..0.18 rows=1 width=24) (never executed)"
" Index Cond: (progparam7_.localperiod_id = id)"
" -> Index Scan using dir_pkey on dir dir9_ (cost=0.28..0.80 rows=1 width=2068) (never executed)"
" Index Cond: (progr6_.dir_id = id)"
" -> Index Scan using delparam_pkey on delparam delparam10_ (cost=0.28..0.58 rows=1 width=76) (never executed)"
" Index Cond: (dir9_.del_param_id = id)"
" -> Index Scan using zi_pkey on zi zi11_ (cost=0.28..1.44 rows=1 width=409) (never executed)"
" Index Cond: (dir9_.zigeo_id = id)"
" -> Index Scan using zi_pkey on zi zi12_ (cost=0.28..1.44 rows=1 width=409) (never executed)"
" Index Cond: (progr6_.zidi2s_progr_id = id)"
" -> Index Scan using zi_pkey on zi zi13_ (cost=0.28..1.44 rows=1 width=409) (never executed)"
" Index Cond: (progr6_.ziprog_id = id)"
" -> Index Scan using perioddate_pkey on perioddate perioddate14_ (cost=0.28..0.32 rows=1 width=24) (never executed)"
" Index Cond: (acqr4_.period_id = id)"
" -> Index Scan using zi_pkey on zi zi16_ (cost=0.28..2.51 rows=1 width=409) (never executed)"
" Index Cond: (csgacqr15_.zicsg_csgqacr_id = id)"
" -> Index Scan using csgsubscription_pkey on csgsubscription csgsubscri17_ (cost=0.14..8.16 rows=1 width=867) (never executed)"
" Index Cond: (dto3_.csgsubscription_id = id)"
" -> Index Scan using csgacqr_pkey on csgacqr csgacqr18_ (cost=0.15..0.66 rows=1 width=54) (never executed)"
" Index Cond: (csgsubscri17_.csgacqr_id = id)"
"Total runtime: 7.469 ms"