2017-11-17 11:50:10 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_88 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"numero_sequentiel"::text,"abscisse"::text,"rotation"::text,"troncon_id"::text,"numero_troncon"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"bp_type_id"::text,"code_type"::text,"longueur"::text,"hauteur"::text,"largeur"::text,"acces_id"::text,"code_acces"::text,"bp_etat_visite_id"::text,"code_etat_visite"::text,"date_derniere_visite"::text,"commentaire"::text,"date_constat"::text,"responsable_constat"::text,"date_rehabilitation"::text,"annee_creation"::text,"bp_entite_rejeteuse_id"::text,"ouvrage_lie_id"::text,"entite_rejeteuse_lib"::text,"distance_troncon"::text,"longueur_troncon"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."bp " WHERE "geometrie" && st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154)) 2017-11-17 11:50:10 CET [29060] pgadmin@tigre LOG: durée : 7.901 ms 2017-11-17 11:50:10 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_88 2017-11-17 11:50:10 CET [29060] pgadmin@tigre LOG: durée : 0.076 ms 2017-11-17 11:50:10 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_89 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"numero_sequentiel"::text,"abscisse"::text,"rotation"::text,"troncon_id"::text,"numero_troncon"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"bp_type_id"::text,"code_type"::text,"longueur"::text,"hauteur"::text,"largeur"::text,"acces_id"::text,"code_acces"::text,"bp_etat_visite_id"::text,"code_etat_visite"::text,"date_derniere_visite"::text,"commentaire"::text,"date_constat"::text,"responsable_constat"::text,"date_rehabilitation"::text,"annee_creation"::text,"bp_entite_rejeteuse_id"::text,"ouvrage_lie_id"::text,"entite_rejeteuse_lib"::text,"distance_troncon"::text,"longueur_troncon"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."bp " WHERE "geometrie" && st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154)) 2017-11-17 11:50:10 CET [29060] pgadmin@tigre LOG: durée : 8.396 ms 2017-11-17 11:50:10 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_89 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 182.725 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_89 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.082 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_90 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"troncon_id"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"rejet_bp_type_id"::text,"rejet_bp_type_canalisation_id"::text,"code_chambre_cpcu"::text,"date_constat"::text,"responsable_constat"::text,"date_derniere_visite"::text,"date_rehabilitation"::text,"annee_creation"::text,"commentaire"::text,boolout("avec_niche")::text,"bp_id"::text,"longueur_troncon"::text FROM "maj_plan"."rejet_bp " WHERE "geometrie" && st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154)) 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 3.409 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_90 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.061 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_91 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"troncon_id"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"rejet_bp_type_id"::text,"rejet_bp_type_canalisation_id"::text,"code_chambre_cpcu"::text,"date_constat"::text,"responsable_constat"::text,"date_derniere_visite"::text,"date_rehabilitation"::text,"annee_creation"::text,"commentaire"::text,boolout("avec_niche")::text,"bp_id"::text,"longueur_troncon"::text FROM "maj_plan"."rejet_bp " WHERE "geometrie" && st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154)) 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 3.439 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_91 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 165.006 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_91 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.121 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_92 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"noeud_amont_id"::text,"noeud_aval_id"::text,"numero"::text,"nom_egout"::text,"largeur_cunette"::text,"profondeur_cunette"::text,"tr_type_id"::text,"code_type"::text,"tr_fonction_id"::text,"tr_type_effluent_id"::text,"code_type_effluent"::text,"fonction"::text,"code_fonction"::text,"tr_type_ovoide_id"::text,"code_type_ovoide"::text,"largeur"::text,"hauteur"::text,"tr_lateralite_cunette_id"::text,"code_lateralite_cunette"::text,"pente"::text,"tr_type_radier_id"::text,"code_type_radier"::text,"circonscription_id"::text,"code_circonscription"::text,"arrondissement_id"::text,"code_arrondissement"::text,"tr_voie_id"::text,"tr_voie_nom_complet"::text,boolout("est_visitable")::text,"commentaire"::text,"frequence_visite"::text,"frequence_visite_proposee"::text,"note_degradation"::text,boolout("est_regule")::text,"tr_gestionnaire_id"::text,"code_gestionnaire"::text,"tr_maitre_ouvrage_id"::text,"code_maitre_ouvrage"::text,"cote_radier_amont"::text,"cote_radier_aval"::text,"derniere_visite_tsp"::text,"derniere_visite_itv"::text,"tr_saturation_id"::text,"code_saturation"::text,"tr_risque_geologique_id"::text,"code_risque_geologique"::text,"description_risque_geologique"::text,"risque_impact_dominant"::text,"tr_risque_impact_id"::text,"code_risque_impact"::text,"tr_etat_rehabilitation_id"::text,"code_etat_rehabilitation"::text,"date_constat"::text,"responsable_constat"::text,boolout("est_principal")::text,"numero_galerie_edp"::text,"sous_zone_regulee_id"::text,boolout("avec_niche")::text,boolout("est_sap_cofinance")::text,"annee_creation"::text,"longueur"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."troncon " WHERE "geometrie" && st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154)) 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 17.653 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_92 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.084 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_93 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"noeud_amont_id"::text,"noeud_aval_id"::text,"numero"::text,"nom_egout"::text,"largeur_cunette"::text,"profondeur_cunette"::text,"tr_type_id"::text,"code_type"::text,"tr_fonction_id"::text,"tr_type_effluent_id"::text,"code_type_effluent"::text,"fonction"::text,"code_fonction"::text,"tr_type_ovoide_id"::text,"code_type_ovoide"::text,"largeur"::text,"hauteur"::text,"tr_lateralite_cunette_id"::text,"code_lateralite_cunette"::text,"pente"::text,"tr_type_radier_id"::text,"code_type_radier"::text,"circonscription_id"::text,"code_circonscription"::text,"arrondissement_id"::text,"code_arrondissement"::text,"tr_voie_id"::text,"tr_voie_nom_complet"::text,boolout("est_visitable")::text,"commentaire"::text,"frequence_visite"::text,"frequence_visite_proposee"::text,"note_degradation"::text,boolout("est_regule")::text,"tr_gestionnaire_id"::text,"code_gestionnaire"::text,"tr_maitre_ouvrage_id"::text,"code_maitre_ouvrage"::text,"cote_radier_amont"::text,"cote_radier_aval"::text,"derniere_visite_tsp"::text,"derniere_visite_itv"::text,"tr_saturation_id"::text,"code_saturation"::text,"tr_risque_geologique_id"::text,"code_risque_geologique"::text,"description_risque_geologique"::text,"risque_impact_dominant"::text,"tr_risque_impact_id"::text,"code_risque_impact"::text,"tr_etat_rehabilitation_id"::text,"code_etat_rehabilitation"::text,"date_constat"::text,"responsable_constat"::text,boolout("est_principal")::text,"numero_galerie_edp"::text,"sous_zone_regulee_id"::text,boolout("avec_niche")::text,boolout("est_sap_cofinance")::text,"annee_creation"::text,"longueur"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."troncon " WHERE "geometrie" && st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154)) 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 19.461 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_93 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.296 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_93 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.084 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_94 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id","numero"::text,boolout("ogc_simple")::text,boolout("ogc_valid")::text,"st_isvalidreason"::text,"st_isvaliddetail"::text FROM "maj_plan"."erreurs_geom " WHERE "geometrie" && st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154)) 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.519 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_94 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.155 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_94 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.063 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_95 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"noeud_amont_id"::text,"noeud_aval_id"::text,"numero"::text,"nom_egout"::text,"largeur_cunette"::text,"profondeur_cunette"::text,"tr_type_id"::text,"tr_fonction_id"::text,"tr_type_effluent_id"::text,"fonction"::text,"tr_type_ovoide_id"::text,"largeur"::text,"hauteur"::text,"tr_lateralite_cunette_id"::text,"pente"::text,"tr_type_radier_id"::text,"circonscription_id"::text,"arrondissement_id"::text,"commentaire"::text,"frequence_visite"::text,"frequence_visite_proposee"::text,"note_degradation"::text,boolout("est_regule")::text,"tr_gestionnaire_id"::text,"tr_maitre_ouvrage_id"::text,"cote_radier_amont"::text,"cote_radier_aval"::text,"derniere_visite_tsp"::text,"derniere_visite_itv"::text,"tr_saturation_id"::text,"tr_risque_geologique_id"::text,"description_risque_geologique"::text,"risque_impact_dominant"::text,"tr_risque_impact_id"::text,"tr_etat_rehabilitation_id"::text,"date_constat"::text,"responsable_constat"::text,boolout("est_principal")::text,"numero_galerie_edp"::text,"sous_zone_regulee_id"::text,"tr_voie_id"::text,boolout("avec_niche")::text,boolout("est_visitable")::text,boolout("est_sap_cofinance")::text,"annee_creation"::text FROM "ouvrage"."troncon " WHERE ("geometrie" && st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154))) AND (((id in (WITH RECURSIVE search_graph(id, noeud_amont, noeud_aval) AS ( SELECT NULL::uuid as id, t.noeud_amont_id as noeud_amont, t.noeud_aval_id as noeud_aval FROM ouvrage.troncon t where id = /*&*/'f0bf4b07-04c1-4ac7-b813-f3726ca7c092'/*&*/ and "tr_type_effluent_id" != '348584d8-7b73-4bd0-8205-e4caf3f3c91f' UNION SELECT t.id, t.noeud_amont_id as noeud_amont, t.noeud_aval_id as noeud_aval FROM ouvrage.troncon t, search_graph sg WHERE ( t.noeud_aval_id = sg.noeud_amont and "tr_type_effluent_id" != '348584d8-7b73-4bd0-8205-e4caf3f3c91f' ) ) SELECT distinct tr.id FROM search_graph join ouvrage.troncon tr on search_graph.id = tr.id limit 10000 )))) 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 1.306 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_95 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.153 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_95 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.052 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_96 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"noeud_amont_id"::text,"noeud_aval_id"::text,"numero"::text,"nom_egout"::text,"largeur_cunette"::text,"profondeur_cunette"::text,"tr_type_id"::text,"tr_fonction_id"::text,"tr_type_effluent_id"::text,"fonction"::text,"tr_type_ovoide_id"::text,"largeur"::text,"hauteur"::text,"tr_lateralite_cunette_id"::text,"pente"::text,"tr_type_radier_id"::text,"circonscription_id"::text,"arrondissement_id"::text,"commentaire"::text,"frequence_visite"::text,"frequence_visite_proposee"::text,"note_degradation"::text,boolout("est_regule")::text,"tr_gestionnaire_id"::text,"tr_maitre_ouvrage_id"::text,"cote_radier_amont"::text,"cote_radier_aval"::text,"derniere_visite_tsp"::text,"derniere_visite_itv"::text,"tr_saturation_id"::text,"tr_risque_geologique_id"::text,"description_risque_geologique"::text,"risque_impact_dominant"::text,"tr_risque_impact_id"::text,"tr_etat_rehabilitation_id"::text,"date_constat"::text,"responsable_constat"::text,boolout("est_principal")::text,"numero_galerie_edp"::text,"sous_zone_regulee_id"::text,"tr_voie_id"::text,boolout("avec_niche")::text,boolout("est_visitable")::text,boolout("est_sap_cofinance")::text,"annee_creation"::text FROM "ouvrage"."troncon " WHERE ("geometrie" && st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.93662352964747697,6863125.22786287683993578,650103.19397112412843853,6863131.48521047178655863,2154))) AND (((id in (WITH RECURSIVE search_graph(id, noeud_amont, noeud_aval) AS ( SELECT id, t.noeud_amont_id as noeud_amont, t.noeud_aval_id as noeud_aval FROM ouvrage.troncon t where id = /*&*/'f0bf4b07-04c1-4ac7-b813-f3726ca7c092'/*&*/ and "tr_type_effluent_id" != 'ed6856cd-c9aa-43f5-ae12-e4fd2a238875' UNION SELECT t.id, t.noeud_amont_id as noeud_amont, t.noeud_aval_id as noeud_aval FROM ouvrage.troncon t, search_graph sg WHERE ( t.noeud_amont_id = sg.noeud_aval and "tr_type_effluent_id" != 'ed6856cd-c9aa-43f5-ae12-e4fd2a238875' ) ) SELECT distinct tr.id FROM search_graph join ouvrage.troncon tr on search_graph.id = tr.id limit 10000 )))) 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 1.218 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_96 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.160 ms 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_96 2017-11-17 11:50:11 CET [29060] pgadmin@tigre LOG: durée : 0.048 ms 2017-11-17 11:50:16 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_97 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"rotation"::text,"numero_postal"::text,"code_type"::text FROM "maj_plan"."bp " WHERE "geometrie" && st_makeenvelope(649998.79838273301720619,6863025.70996384229511023,650232.23655642895027995,6863224.10481831897050142,2154) 2017-11-17 11:50:16 CET [29060] pgadmin@tigre LOG: durée : 1.675 ms 2017-11-17 11:50:16 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_97 2017-11-17 11:50:16 CET [29060] pgadmin@tigre LOG: durée : 0.059 ms 2017-11-17 11:50:16 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_98 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"rotation"::text,"numero_postal"::text,"code_type"::text FROM "maj_plan"."bp " WHERE "geometrie" && st_makeenvelope(649998.79838273301720619,6863025.70996384229511023,650232.23655642895027995,6863224.10481831897050142,2154) 2017-11-17 11:50:16 CET [29060] pgadmin@tigre LOG: durée : 1.457 ms 2017-11-17 11:50:16 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_98 2017-11-17 11:50:17 CET [29060] pgadmin@tigre LOG: durée : 172.506 ms 2017-11-17 11:50:17 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_98 2017-11-17 11:50:17 CET [29060] pgadmin@tigre LOG: durée : 0.075 ms 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_99 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text FROM "maj_plan"."rejet_bp " WHERE "geometrie" && st_makeenvelope(649998.79838273301720619,6863025.70996384229511023,650232.23655642895027995,6863224.10481831897050142,2154) 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: durée : 3.184 ms 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_99 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: durée : 0.082 ms 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_100 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text FROM "maj_plan"."rejet_bp " WHERE "geometrie" && st_makeenvelope(649998.79838273301720619,6863025.70996384229511023,650232.23655642895027995,6863224.10481831897050142,2154) 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: durée : 2.894 ms 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_100 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: durée : 169.092 ms 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_100 2017-11-17 11:50:19 CET [29060] pgadmin@tigre LOG: durée : 0.063 ms 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_101 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"troncon_id"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"rejet_bp_type_id"::text,"rejet_bp_type_canalisation_id"::text,"code_chambre_cpcu"::text,"date_constat"::text,"responsable_constat"::text,"date_derniere_visite"::text,"date_rehabilitation"::text,"annee_creation"::text,"commentaire"::text,boolout("avec_niche")::text,"bp_id"::text,"longueur_troncon"::text FROM "maj_plan"."rejet_bp " WHERE "geometrie" && st_makeenvelope(650097.21255517704412341,6863126.05565781891345978,650103.46990277152508497,6863132.31300541386008263,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650097.21255517704412341,6863126.05565781891345978,650103.46990277152508497,6863132.31300541386008263,2154)) 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: durée : 6.416 ms 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_101 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: durée : 0.084 ms 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_102 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"troncon_id"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"rejet_bp_type_id"::text,"rejet_bp_type_canalisation_id"::text,"code_chambre_cpcu"::text,"date_constat"::text,"responsable_constat"::text,"date_derniere_visite"::text,"date_rehabilitation"::text,"annee_creation"::text,"commentaire"::text,boolout("avec_niche")::text,"bp_id"::text,"longueur_troncon"::text FROM "maj_plan"."rejet_bp " WHERE "geometrie" && st_makeenvelope(650097.21255517704412341,6863126.05565781891345978,650103.46990277152508497,6863132.31300541386008263,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650097.21255517704412341,6863126.05565781891345978,650103.46990277152508497,6863132.31300541386008263,2154)) 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: durée : 7.605 ms 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_102 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: durée : 174.505 ms 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_102 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: durée : 0.166 ms 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_103 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"numero_sequentiel"::text,"abscisse"::text,"rotation"::text,"troncon_id"::text,"numero_troncon"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"bp_type_id"::text,"code_type"::text,"longueur"::text,"hauteur"::text,"largeur"::text,"acces_id"::text,"code_acces"::text,"bp_etat_visite_id"::text,"code_etat_visite"::text,"date_derniere_visite"::text,"commentaire"::text,"date_constat"::text,"responsable_constat"::text,"date_rehabilitation"::text,"annee_creation"::text,"bp_entite_rejeteuse_id"::text,"ouvrage_lie_id"::text,"entite_rejeteuse_lib"::text,"distance_troncon"::text,"longueur_troncon"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."bp" 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: durée : 20.121 ms 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: durée : 104.351 ms 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: durée : 37.293 ms 2017-11-17 11:50:20 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: durée : 37.839 ms 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: durée : 34.645 ms 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: durée : 34.185 ms 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: durée : 34.527 ms 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: durée : 33.446 ms 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: durée : 36.292 ms 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: durée : 45.986 ms 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: durée : 44.786 ms 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:21 CET [29060] pgadmin@tigre LOG: durée : 48.530 ms 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: durée : 36.932 ms 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: durée : 39.520 ms 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: durée : 43.505 ms 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: durée : 40.690 ms 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: durée : 44.112 ms 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: durée : 36.913 ms 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: durée : 37.475 ms 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:22 CET [29060] pgadmin@tigre LOG: durée : 34.421 ms 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: durée : 34.804 ms 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: durée : 32.582 ms 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: durée : 30.140 ms 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: durée : 28.854 ms 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: durée : 29.541 ms 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: durée : 30.259 ms 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: durée : 29.991 ms 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: durée : 35.601 ms 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:23 CET [29060] pgadmin@tigre LOG: durée : 35.174 ms 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: durée : 36.705 ms 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: durée : 34.712 ms 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: durée : 32.637 ms 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: durée : 32.038 ms 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: durée : 32.470 ms 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: durée : 32.117 ms 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: durée : 32.811 ms 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: durée : 31.977 ms 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:24 CET [29060] pgadmin@tigre LOG: durée : 32.217 ms 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: durée : 32.706 ms 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: durée : 32.619 ms 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: durée : 36.672 ms 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: durée : 36.004 ms 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: durée : 36.165 ms 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: durée : 33.044 ms 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: durée : 32.444 ms 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: durée : 32.339 ms 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:25 CET [29060] pgadmin@tigre LOG: durée : 32.802 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 32.855 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 32.566 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 31.974 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 31.824 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 32.615 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_103 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 31.274 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_103 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 0.127 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_104 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"numero_sequentiel"::text,"abscisse"::text,"rotation"::text,"troncon_id"::text,"numero_troncon"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"bp_type_id"::text,"code_type"::text,"longueur"::text,"hauteur"::text,"largeur"::text,"acces_id"::text,"code_acces"::text,"bp_etat_visite_id"::text,"code_etat_visite"::text,"date_derniere_visite"::text,"commentaire"::text,"date_constat"::text,"responsable_constat"::text,"date_rehabilitation"::text,"annee_creation"::text,"bp_entite_rejeteuse_id"::text,"ouvrage_lie_id"::text,"entite_rejeteuse_lib"::text,"distance_troncon"::text,"longueur_troncon"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."bp " WHERE ("id" = '71f0bbfc-424a-49b9-a8df-81827c6de525') 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 19.583 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_104 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 34.161 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_104 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 0.129 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_105 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"numero_sequentiel"::text,"abscisse"::text,"rotation"::text,"troncon_id"::text,"numero_troncon"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"bp_type_id"::text,"code_type"::text,"longueur"::text,"hauteur"::text,"largeur"::text,"acces_id"::text,"code_acces"::text,"bp_etat_visite_id"::text,"code_etat_visite"::text,"date_derniere_visite"::text,"commentaire"::text,"date_constat"::text,"responsable_constat"::text,"date_rehabilitation"::text,"annee_creation"::text,"bp_entite_rejeteuse_id"::text,"ouvrage_lie_id"::text,"entite_rejeteuse_lib"::text,"distance_troncon"::text,"longueur_troncon"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."bp" 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 20.703 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 109.941 ms 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:26 CET [29060] pgadmin@tigre LOG: durée : 41.105 ms 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: durée : 38.281 ms 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: durée : 36.028 ms 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: durée : 34.057 ms 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: durée : 36.668 ms 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: durée : 36.387 ms 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: durée : 36.588 ms 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: durée : 36.442 ms 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: durée : 36.679 ms 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:27 CET [29060] pgadmin@tigre LOG: durée : 36.563 ms 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: durée : 35.825 ms 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: durée : 36.756 ms 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: durée : 37.027 ms 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: durée : 40.085 ms 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: durée : 41.171 ms 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: durée : 40.686 ms 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: durée : 38.438 ms 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:28 CET [29060] pgadmin@tigre LOG: durée : 34.911 ms 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: durée : 34.086 ms 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: durée : 31.891 ms 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: durée : 33.738 ms 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: durée : 34.578 ms 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: durée : 35.760 ms 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: durée : 34.447 ms 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: durée : 32.590 ms 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: durée : 34.002 ms 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:29 CET [29060] pgadmin@tigre LOG: durée : 35.537 ms 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: durée : 34.385 ms 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: durée : 33.416 ms 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: durée : 30.605 ms 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: durée : 30.475 ms 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: durée : 43.815 ms 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: durée : 42.611 ms 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: durée : 44.645 ms 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:30 CET [29060] pgadmin@tigre LOG: durée : 43.315 ms 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: durée : 33.743 ms 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: durée : 48.507 ms 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: durée : 40.581 ms 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: durée : 50.594 ms 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: durée : 38.208 ms 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: durée : 36.146 ms 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: durée : 33.213 ms 2017-11-17 11:50:31 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 30.981 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 33.921 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 31.913 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 32.292 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 31.638 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 33.122 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 30.973 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 31.729 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 30.656 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_105 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 0.137 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_106 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"numero_sequentiel"::text,"abscisse"::text,"rotation"::text,"troncon_id"::text,"numero_troncon"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"bp_type_id"::text,"code_type"::text,"longueur"::text,"hauteur"::text,"largeur"::text,"acces_id"::text,"code_acces"::text,"bp_etat_visite_id"::text,"code_etat_visite"::text,"date_derniere_visite"::text,"commentaire"::text,"date_constat"::text,"responsable_constat"::text,"date_rehabilitation"::text,"annee_creation"::text,"bp_entite_rejeteuse_id"::text,"ouvrage_lie_id"::text,"entite_rejeteuse_lib"::text,"distance_troncon"::text,"longueur_troncon"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."bp " WHERE ("id" = '71f0bbfc-424a-49b9-a8df-81827c6de525') 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: durée : 21.907 ms 2017-11-17 11:50:32 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_106 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 42.458 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_106 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.142 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_107 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"troncon_id"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"rejet_bp_type_id"::text,"rejet_bp_type_canalisation_id"::text,"code_chambre_cpcu"::text,"date_constat"::text,"responsable_constat"::text,"date_derniere_visite"::text,"date_rehabilitation"::text,"annee_creation"::text,"commentaire"::text,boolout("avec_niche")::text,"bp_id"::text,"longueur_troncon"::text FROM "maj_plan"."rejet_bp " WHERE "id"::text='0ecbb184-cba2-408a-b6eb-d0eb63ddb046' 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 3.227 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_107 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 143.240 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_107 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.120 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_108 BINARY CURSOR WITH HOLD FOR SELECT "id"::text,"libelle"::text FROM "ouvrage"."rejet_bp_type" 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.226 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_108 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.052 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_108 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.024 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_109 BINARY CURSOR WITH HOLD FOR SELECT "id"::text,"libelle"::text FROM "ouvrage"."rejet_bp_type" 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.178 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_109 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.066 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_109 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.032 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_110 BINARY CURSOR WITH HOLD FOR SELECT "id"::text,"libelle"::text FROM "ouvrage"."rejet_bp_type_canalisation" 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.156 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_110 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.047 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_110 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.025 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_111 BINARY CURSOR WITH HOLD FOR SELECT "id"::text,"libelle"::text FROM "ouvrage"."rejet_bp_type_canalisation" 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.159 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_111 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.059 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_111 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 0.027 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_112 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"numero_sequentiel"::text,"abscisse"::text,"rotation"::text,"troncon_id"::text,"numero_troncon"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"bp_type_id"::text,"code_type"::text,"longueur"::text,"hauteur"::text,"largeur"::text,"acces_id"::text,"code_acces"::text,"bp_etat_visite_id"::text,"code_etat_visite"::text,"date_derniere_visite"::text,"commentaire"::text,"date_constat"::text,"responsable_constat"::text,"date_rehabilitation"::text,"annee_creation"::text,"bp_entite_rejeteuse_id"::text,"ouvrage_lie_id"::text,"entite_rejeteuse_lib"::text,"distance_troncon"::text,"longueur_troncon"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."bp" 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 19.883 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 103.883 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 42.740 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 43.732 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 38.083 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 38.213 ms 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:33 CET [29060] pgadmin@tigre LOG: durée : 38.049 ms 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: durée : 40.629 ms 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: durée : 39.456 ms 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: durée : 39.464 ms 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: durée : 39.432 ms 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: durée : 38.072 ms 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: durée : 37.994 ms 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: durée : 38.508 ms 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:34 CET [29060] pgadmin@tigre LOG: durée : 38.546 ms 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: durée : 39.639 ms 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: durée : 39.012 ms 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: durée : 38.075 ms 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: durée : 32.809 ms 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: durée : 33.616 ms 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: durée : 32.621 ms 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: durée : 33.289 ms 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: durée : 35.184 ms 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:35 CET [29060] pgadmin@tigre LOG: durée : 35.192 ms 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: durée : 35.621 ms 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: durée : 34.642 ms 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: durée : 34.695 ms 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: durée : 36.459 ms 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: durée : 35.084 ms 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: durée : 39.846 ms 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: durée : 38.481 ms 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: durée : 33.998 ms 2017-11-17 11:50:36 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: durée : 33.040 ms 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: durée : 32.159 ms 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: durée : 32.643 ms 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: durée : 32.958 ms 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: durée : 32.529 ms 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: durée : 39.566 ms 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: durée : 31.973 ms 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: durée : 31.704 ms 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: durée : 36.648 ms 2017-11-17 11:50:37 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: durée : 37.279 ms 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: durée : 35.075 ms 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: durée : 34.058 ms 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: durée : 31.300 ms 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: durée : 31.450 ms 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: durée : 31.343 ms 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: durée : 30.547 ms 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: durée : 33.961 ms 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: durée : 28.502 ms 2017-11-17 11:50:38 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 32.569 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 33.170 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_112 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 31.768 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_112 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 0.143 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_113 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"numero_sequentiel"::text,"abscisse"::text,"rotation"::text,"troncon_id"::text,"numero_troncon"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"bp_type_id"::text,"code_type"::text,"longueur"::text,"hauteur"::text,"largeur"::text,"acces_id"::text,"code_acces"::text,"bp_etat_visite_id"::text,"code_etat_visite"::text,"date_derniere_visite"::text,"commentaire"::text,"date_constat"::text,"responsable_constat"::text,"date_rehabilitation"::text,"annee_creation"::text,"bp_entite_rejeteuse_id"::text,"ouvrage_lie_id"::text,"entite_rejeteuse_lib"::text,"distance_troncon"::text,"longueur_troncon"::text,boolout("a_verrou_intervention")::text FROM "maj_plan"."bp " WHERE ("id" = '71f0bbfc-424a-49b9-a8df-81827c6de525') 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 20.354 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_113 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 34.210 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_113 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 0.103 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_114 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"troncon_id"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"rejet_bp_type_id"::text,"rejet_bp_type_canalisation_id"::text,"code_chambre_cpcu"::text,"date_constat"::text,"responsable_constat"::text,"date_derniere_visite"::text,"date_rehabilitation"::text,"annee_creation"::text,"commentaire"::text,boolout("avec_niche")::text,"bp_id"::text,"longueur_troncon"::text FROM "maj_plan"."rejet_bp " WHERE "geometrie" && st_makeenvelope(650096.66069188225083053,6863126.05565781891345978,650102.91803947673179209,6863132.31300541386008263,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.66069188225083053,6863126.05565781891345978,650102.91803947673179209,6863132.31300541386008263,2154)) 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 3.882 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_114 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 0.057 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : DECLARE qgis_115 BINARY CURSOR WITH HOLD FOR SELECT st_asbinary("geometrie",'NDR'),"id"::text,"troncon_id"::text,"tr_fonction"::text,"tr_nom_egout"::text,"tr_type"::text,"numero_postal"::text,"tr_voie_nom_complet"::text,"code_circonscription"::text,"code_arrondissement"::text,"rejet_bp_type_id"::text,"rejet_bp_type_canalisation_id"::text,"code_chambre_cpcu"::text,"date_constat"::text,"responsable_constat"::text,"date_derniere_visite"::text,"date_rehabilitation"::text,"annee_creation"::text,"commentaire"::text,boolout("avec_niche")::text,"bp_id"::text,"longueur_troncon"::text FROM "maj_plan"."rejet_bp " WHERE "geometrie" && st_makeenvelope(650096.66069188225083053,6863126.05565781891345978,650102.91803947673179209,6863132.31300541386008263,2154) AND st_intersects(st_curvetoline("geometrie"),st_makeenvelope(650096.66069188225083053,6863126.05565781891345978,650102.91803947673179209,6863132.31300541386008263,2154)) 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 3.302 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : FETCH FORWARD 2000 FROM qgis_115 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 168.699 ms 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: instruction : CLOSE qgis_115 2017-11-17 11:50:39 CET [29060] pgadmin@tigre LOG: durée : 0.130 ms