GET https://osm-commerces.cipherbliss.com/admin/stats/29106/followup-graph/tree

Response
200 OK
IP
216.73.216.71
Profiled on
Token
7a6c14

Query Metrics

22 Database Queries
20 Different statements
213.17 ms Query time
0 Invalid entities
4664 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
143.44 ms
(67.29%) 		1 
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.zip_code = ?
Parameters: 
[
  "29106"
]
View formatted query    View runnable query    Explain query    View query backtrace
14.60 ms
(6.85%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  25643
]
View formatted query    View runnable query    Explain query    View query backtrace
13.90 ms
(6.52%) 		1 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"tree","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}"
  "2026-07-13 03:28:55"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
13.49 ms
(6.33%) 		1 
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id = ? AND c0_.name IN (?, ?) ORDER BY c0_.date ASC, c0_.id ASC
Parameters: 
[
  25643
  "tree_count"
  "tree_completion"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.73 ms
(1.75%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(0.24%) 		1 
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = ?
Parameters: 
[
  25643
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.22%) 		1 
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ? ORDER BY z0_.id ASC LIMIT 1
Parameters: 
[
  25643
  "tree"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.17%) 		1 
SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters: 
[
  "29106"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.09%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

osm connection

Time▼ Count Info
8.39 ms
(3.94%) 		1 
SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM osm_object_meta m
WHERE osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags->'ref:INSEE') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1
Parameters: 
[
  "29106"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.80 ms
(1.31%) 		1 
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.71 ms
(1.27%) 		1 
SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,
            tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid
            FROM osm_object_meta m
            WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))
            AND ((tags->'natural') = 'tree')
Parameters: 
[
  "MULTIPOLYGON(((-4.106543 48.064735,-4.106322 48.064804,-4.105615 48.064803,-4.105277 48.064935,-4.105139 48.064957,-4.104515 48.064905,-4.104386 48.064984,-4.104248 48.065242,-4.104134 48.065276,-4.103804 48.065229,-4.103684 48.065306,-4.103547 48.065613,-4.103426 48.065813,-4.103274 48.065825,-4.103009 48.065776,-4.102856 48.065834,-4.102716 48.065945,-4.102649 48.066081,-4.102666 48.06622,-4.102881 48.066586,-4.102784 48.066896,-4.102794 48.067187,-4.102649 48.067454,-4.102632 48.067598,-4.102527 48.067965,-4.102349 48.06837,-4.102096 48.069004,-4.102045 48.069076,-4.101739 48.069285,-4.101656 48.069412,-4.101549 48.069726,-4.101335 48.069991,-4.101379 48.07024,-4.101323 48.070575,-4.101255 48.070697,-4.100993 48.071012,-4.100888 48.071327,-4.10068 48.071741,-4.100474 48.07196,-4.100466 48.072076,-4.100199 48.072334,-4.100122 48.072529,-4.099808 48.072575,-4.099624 48.072717,-4.099615 48.072886,-4.099525 48.073081,-4.099579 48.073232,-4.099281 48.073221,-4.099041 48.073299,-4.098712 48.073443,-4.098501 48.073615,-4.098487 48.073854,-4.098598 48.073868,-4.098722 48.074027,-4.098732 48.074152,-4.09864 48.074366,-4.098667 48.074608,-4.098435 48.07498,-4.098471 48.075164,-4.098625 48.075349,-4.098648 48.075559,-4.098525 48.07568,-4.098509 48.075828,-4.098585 48.075883,-4.098956 48.076003,-4.099009 48.076056,-4.098971 48.076241,-4.098793 48.076677,-4.098671 48.076927,-4.098376 48.077667,-4.098308 48.077766,-4.098017 48.077999,-4.097974 48.078191,-4.098012 48.07848,-4.097882 48.078764,-4.097761 48.07896,-4.097731 48.0792,-4.097489 48.07935,-4.097493 48.079602,-4.097315 48.079934,-4.097283 48.080057,-4.097295 48.080386,-4.097258 48.080851,-4.097124 48.081279,-4.097202 48.081993,-4.097199 48.082116,-4.097086 48.082494,-4.096961 48.082662,-4.096989 48.082735,-4.097189 48.082936,-4.097173 48.083197,-4.097052 48.083354,-4.096838 48.083508,-4.096685 48.083683,-4.09663 48.083853,-4.09659 48.084181,-4.096769 48.084323,-4.097106 48.084389,-4.097279 48.084382,-4.097462 48.084483,-4.097553 48.084713,-4.09765 48.085144,-4.097881 48.085444,-4.09793 48.08562,-4.098066 48.085839,-4.098287 48.086009,-4.098397 48.086134,-4.098487 48.086334,-4.098568 48.086649,-4.098586 48.086863,-4.098742 48.087272,-4.098648 48.087376,-4.098582 48.087606,-4.098616 48.087738,-4.098916 48.088105,-4.098927 48.088171,-4.098811 48.08837,-4.098943 48.08855,-4.098944 48.088662,-4.09873 48.088838,-4.098644 48.088972,-4.098668 48.089402,-4.098586 48.089661,-4.098468 48.089882,-4.098429 48.090092,-4.098259 48.090229,-4.097666 48.09039,-4.097025 48.090441,-4.096615 48.090427,-4.096246 48.090594,-4.095948 48.090702,-4.095772 48.090821,-4.095717 48.091016,-4.095695 48.091634,-4.095799 48.091762,-4.095716 48.091939,-4.095786 48.09214,-4.096068 48.09255,-4.096153 48.092794,-4.096342 48.093099,-4.096402 48.093459,-4.096569 48.09385,-4.096576 48.094023,-4.096516 48.094197,-4.09653 48.09461,-4.096583 48.094862,-4.097026 48.09502,-4.097126 48.095139,-4.097148 48.095306,-4.09727 48.095541,-4.097389 48.095629,-4.09752 48.095873,-4.097544 48.096,-4.097506 48.096212,-4.097737 48.096822,-4.097702 48.097438,-4.097775 48.097846,-4.098006 48.09796,-4.0981 48.098089,-4.098088 48.098232,-4.097983 48.098333,-4.097577 48.09853,-4.097568 48.098644,-4.097715 48.098898,-4.097621 48.09898,-4.097247 48.099025,-4.096951 48.099171,-4.096874 48.099296,-4.09691 48.09957,-4.096988 48.099838,-4.096861 48.100017,-4.096722 48.10039,-4.096679 48.100569,-4.096728 48.101078,-4.0967 48.10129,-4.096723 48.101431,-4.096986 48.101678,-4.097072 48.101867,-4.097025 48.102118,-4.096945 48.10227,-4.096934 48.102404,-4.097102 48.102491,-4.097358 48.102542,-4.097608 48.102676,-4.097728 48.102893,-4.097855 48.103013,-4.097988 48.103224,-4.098121 48.103331,-4.098317 48.103331,-4.098409 48.103244,-4.098582 48.103226,-4.098764 48.103368,-4.098963 48.103391,-4.099419 48.103289,-4.09952 48.10336,-4.099796 48.103935,-4.100368 48.104267,-4.100607 48.104307,-4.101048 48.1045,-4.101363 48.104502,-4.101587 48.104642,-4.101696 48.104775,-4.101842 48.105057,-4.101873 48.105328,-4.101998 48.105873,-4.10165 48.105918,-4.101325 48.105996,-4.101221 48.106376,-4.100913 48.106744,-4.100791 48.107059,-4.100857 48.107272,-4.100835 48.107396,-4.100311 48.107638,-4.100324 48.107835,-4.100203 48.107945,-4.100015 48.107987,-4.099708 48.107971,-4.099539 48.108027,-4.099131 48.108356,-4.098869 48.108665,-4.098426 48.10888,-4.098001 48.109175,-4.097766 48.109372,-4.097544 48.109518,-4.096967 48.109811,-4.095915 48.110403,-4.095789 48.11046,-4.095596 48.110368,-4.09543 48.110144,-4.095263 48.110079,-4.094943 48.110077,-4.094622 48.110205,-4.094434 48.110423,-4.094365 48.110701,-4.094213 48.110736,-4.093957 48.110708,-4.09383 48.110806,-4.093644 48.110879,-4.093234 48.110949,-4.092822 48.111108,-4.092571 48.1113,-4.092282 48.111324,-4.092199 48.111583,-4.091846 48.111713,-4.09167 48.111694,-4.091561 48.111774,-4.091557 48.111926,-4.091454 48.112043,-4.09112 48.112125,-4.091012 48.112123,-4.090787 48.111997,-4.090732 48.111867,-4.090493 48.111846,-4.09027 48.111907,-4.090066 48.111904,-4.089757 48.111832,-4.089456 48.111938,-4.089238 48.111932,-4.089046 48.112092,-4.08872 48.111985,-4.0886 48.112045,-4.088672 48.112354,-4.088518 48.112377,-4.088411 48.112317,-4.087691 48.11223,-4.087581 48.112346,-4.087665 48.11265,-4.0876 48.112695,-4.087237 48.112748,-4.086866 48.112696,-4.086765 48.112766,-4.086568 48.11326,-4.086407 48.113319,-4.086205 48.113248,-4.0861 48.113329,-4.08596 48.113342,-4.085755 48.113271,-4.085586 48.113376,-4.085367 48.113315,-4.085056 48.113366,-4.084967 48.113526,-4.084832 48.113612,-4.084543 48.113712,-4.084367 48.113708,-4.084189 48.113557,-4.08399 48.113591,-4.083811 48.113977,-4.083358 48.114082,-4.083246 48.114221,-4.083225 48.114373,-4.083116 48.114429,-4.082957 48.11439,-4.082797 48.114428,-4.082731 48.114514,-4.08239 48.114679,-4.082251 48.1148,-4.082248 48.11501,-4.082164 48.115216,-4.082225 48.115428,-4.08211 48.115639,-4.082134 48.115809,-4.082368 48.11619,-4.082437 48.116407,-4.082374 48.116676,-4.082155 48.117045,-4.081942 48.117342,-4.081781 48.117497,-4.081682 48.117729,-4.08159 48.1178,-4.081192 48.118003,-4.080879 48.118288,-4.080946 48.118445,-4.081202 48.118623,-4.081314 48.118833,-4.081192 48.119129,-4.081273 48.119328,-4.081185 48.119461,-4.08076 48.119607,-4.08073 48.119676,-4.080834 48.119863,-4.080814 48.119959,-4.080658 48.120058,-4.080783 48.120208,-4.08081 48.120334,-4.080718 48.120416,-4.080492 48.120452,-4.080321 48.120518,-4.080108 48.120734,-4.079581 48.120879,-4.079499 48.121015,-4.079005 48.121568,-4.078873 48.121666,-4.078596 48.121773,-4.078362 48.12197,-4.078166 48.122018,-4.078099 48.122224,-4.077599 48.122458,-4.076722 48.122694,-4.076598 48.122786,-4.075977 48.123455,-4.075779 48.123608,-4.075502 48.123896,-4.07535 48.124271,-4.075259 48.124377,-4.075215 48.124526,-4.074998 48.124743,-4.074836 48.125011,-4.074653 48.12519,-4.074379 48.125522,-4.074015 48.125808,-4.073006 48.12623,-4.072981 48.126038,-4.072314 48.12561,-4.070771 48.124679,-4.069723 48.124555,-4.069253 48.124472,-4.068761 48.124355,-4.067781 48.124099,-4.067467 48.123991,-4.066963 48.123754,-4.066383 48.123528,-4.065972 48.123389,-4.065338 48.122686,-4.065218 48.122604,-4.065089 48.122361,-4.064886 48.121881,-4.064671 48.121768,-4.06474 48.121615,-4.065497 48.120381,-4.065729 48.119983,-4.066238 48.11915,-4.066382 48.118935,-4.066616 48.118658,-4.06758 48.117618,-4.06797 48.117075,-4.06824 48.116545,-4.068363 48.116264,-4.068683 48.116019,-4.069171 48.115683,-4.069696 48.11541,-4.069641 48.115341,-4.069706 48.115079,-4.069901 48.114923,-4.069486 48.114299,-4.069772 48.114231,-4.070145 48.114183,-4.070064 48.113992,-4.070022 48.113681,-4.07011 48.113248,-4.069548 48.11281,-4.068997 48.11307,-4.068707 48.112969,-4.068266 48.112998,-4.06757 48.113076,-4.067333 48.113233,-4.066891 48.113393,-4.06581 48.113652,-4.065503 48.113714,-4.064697 48.113782,-4.064341 48.113967,-4.063965 48.114112,-4.063909 48.114208,-4.06346 48.114411,-4.063 48.114852,-4.06307 48.115254,-4.063417 48.115638,-4.06204 48.115796,-4.061982 48.115679,-4.061882 48.115309,-4.061938 48.114828,-4.062015 48.114339,-4.062141 48.113383,-4.062081 48.112887,-4.062078 48.112643,-4.062212 48.112262,-4.061729 48.11232,-4.061512 48.112276,-4.060492 48.111947,-4.060229 48.111843,-4.059897 48.111657,-4.059466 48.11133,-4.057524 48.109731,-4.05714 48.108828,-4.054674 48.108737,-4.053763 48.108278,-4.052184 48.10781,-4.05199 48.107795,-4.0517 48.10783,-4.050421 48.108061,-4.050101 48.108088,-4.049815 48.108084,-4.048899 48.108023,-4.048233 48.107919,-4.048351 48.107815,-4.048953 48.107675,-4.049192 48.107589,-4.048816 48.107255,-4.048368 48.106635,-4.048602 48.106547,-4.049203 48.106382,-4.049512 48.106252,-4.049688 48.106205,-4.049535 48.106088,-4.048132 48.105236,-4.048069 48.105134,-4.047224 48.105205,-4.046974 48.104621,-4.046535 48.104095,-4.046322 48.103703,-4.046027 48.103354,-4.045892 48.103134,-4.045798 48.102876,-4.045722 48.102486,-4.045777 48.102263,-4.046093 48.101655,-4.04627 48.101516,-4.046066 48.101121,-4.046007 48.101062,-4.046162 48.100943,-4.046313 48.100741,-4.04656 48.100273,-4.046636 48.10002,-4.046778 48.099837,-4.047044 48.099718,-4.047247 48.099546,-4.047852 48.099148,-4.048198 48.098844,-4.049459 48.097825,-4.050285 48.097224,-4.050475 48.097126,-4.050953 48.096989,-4.051232 48.096878,-4.051957 48.096537,-4.052726 48.096239,-4.053528 48.095898,-4.053501 48.094981,-4.053523 48.094726,-4.053643 48.094038,-4.053758 48.093498,-4.053933 48.092582,-4.053923 48.092501,-4.053418 48.092589,-4.052929 48.0927,-4.052375 48.092875,-4.051961 48.093045,-4.051279 48.093355,-4.050438 48.093769,-4.050263 48.093568,-4.050126 48.093566,-4.049712 48.093213,-4.049307 48.092997,-4.049075 48.092927,-4.048968 48.092848,-4.048513 48.092675,-4.048348 48.092574,-4.048053 48.092512,-4.047939 48.092398,-4.047741 48.092124,-4.047598 48.091876,-4.047134 48.091436,-4.047028 48.091362,-4.046747 48.091073,-4.046694 48.090708,-4.046498 48.090485,-4.046205 48.090237,-4.046109 48.090077,-4.046191 48.0899,-4.046087 48.08979,-4.046 48.089614,-4.045858 48.089475,-4.045603 48.089335,-4.045462 48.08921,-4.045404 48.089004,-4.045184 48.088914,-4.045143 48.088689,-4.045037 48.088469,-4.044818 48.088253,-4.048975 48.088189,-4.052001 48.08717,-4.051243 48.08677,-4.050689 48.086438,-4.05015 48.086056,-4.04905 48.085205,-4.048814 48.085035,-4.048101 48.08447,-4.048218 48.084411,-4.049058 48.083822,-4.049233 48.083614,-4.049234 48.08348,-4.049167 48.083099,-4.049243 48.082882,-4.049414 48.082553,-4.049456 48.082243,-4.04949 48.082206,-4.050341 48.082114,-4.05085 48.081969,-4.051615 48.081611,-4.052019 48.081375,-4.053004 48.081036,-4.052876 48.080796,-4.052735 48.080614,-4.052704 48.080503,-4.052717 48.080253,-4.052783 48.080087,-4.052781 48.079961,-4.052686 48.079406,-4.052943 48.078805,-4.053235 48.078446,-4.053528 48.078209,-4.053905 48.077949,-4.054033 48.077748,-4.054128 48.077529,-4.054266 48.077365,-4.054738 48.077157,-4.054805 48.077091,-4.054847 48.07679,-4.055011 48.076503,-4.055107 48.076271,-4.055308 48.076095,-4.055541 48.075757,-4.055599 48.075416,-4.055542 48.075152,-4.055458 48.074932,-4.055571 48.074732,-4.055911 48.074432,-4.056267 48.074254,-4.056406 48.074079,-4.056459 48.073881,-4.056876 48.073546,-4.057035 48.073358,-4.057132 48.073151,-4.057537 48.072854,-4.057718 48.072655,-4.057957 48.072543,-4.058248 48.072481,-4.058471 48.072357,-4.05863 48.072146,-4.059054 48.071919,-4.059268 48.071779,-4.059344 48.071572,-4.059612 48.071509,-4.059654 48.071319,-4.05978 48.071305,-4.059881 48.071162,-4.060396 48.071002,-4.060498 48.070939,-4.060625 48.070743,-4.060932 48.070453,-4.061063 48.070371,-4.061341 48.070268,-4.061559 48.069977,-4.061862 48.069743,-4.062307 48.069508,-4.062583 48.069167,-4.062656 48.068978,-4.062624 48.068894,-4.062441 48.068745,-4.062363 48.068548,-4.062513 48.068266,-4.06237 48.067949,-4.062298 48.067578,-4.062255 48.067146,-4.062007 48.066787,-4.061811 48.066325,-4.061728 48.066223,-4.06166 48.06586,-4.061654 48.065646,-4.061714 48.065449,-4.061616 48.065235,-4.061639 48.06503,-4.061597 48.064616,-4.061444 48.06444,-4.06143 48.064183,-4.061623 48.064125,-4.062145 48.064014,-4.062424 48.063913,-4.062921 48.0637,-4.063132 48.063569,-4.063234 48.063433,-4.063368 48.063367,-4.063593 48.063486,-4.063708 48.063442,-4.063946 48.063444,-4.064159 48.063407,-4.064814 48.062958,-4.06489 48.062891,-4.065553 48.062443,-4.066066 48.062016,-4.066349 48.061638,-4.066522 48.061281,-4.066549 48.061108,-4.066819 48.061113,-4.067138 48.060989,-4.067296 48.060718,-4.067467 48.060329,-4.067645 48.059725,-4.067725 48.059376,-4.0678 48.059161,-4.067968 48.058865,-4.068033 48.058573,-4.068006 48.058392,-4.067148 48.058258,-4.065802 48.058108,-4.065909 48.057456,-4.065786 48.057391,-4.065639 48.057153,-4.065436 48.056665,-4.065022 48.056106,-4.06489 48.055757,-4.064884 48.055611,-4.066267 48.055598,-4.066549 48.054144,-4.066405 48.054117,-4.065337 48.054011,-4.06493 48.053891,-4.065104 48.053711,-4.065388 48.053472,-4.065723 48.053256,-4.065776 48.053153,-4.065601 48.053078,-4.065108 48.052983,-4.065032 48.052618,-4.064919 48.052367,-4.064804 48.052201,-4.064513 48.051862,-4.064199 48.051453,-4.064279 48.051346,-4.064895 48.050728,-4.065185 48.050407,-4.065646 48.049931,-4.065477 48.049785,-4.066042 48.049551,-4.06632 48.049511,-4.066735 48.049369,-4.067233 48.049426,-4.067152 48.049761,-4.06732 48.049875,-4.067517 48.050279,-4.067531 48.050635,-4.067589 48.050873,-4.067821 48.0511,-4.068011 48.051193,-4.068189 48.051347,-4.068459 48.051721,-4.068912 48.053024,-4.069407 48.05299,-4.069177 48.05165,-4.069477 48.051656,-4.070025 48.051439,-4.070492 48.051291,-4.070613 48.051433,-4.070818 48.051758,-4.070954 48.052045,-4.071062 48.052705,-4.071244 48.053015,-4.072171 48.052952,-4.072632 48.053838,-4.072846 48.054169,-4.073298 48.054815,-4.073576 48.055304,-4.07368 48.05558,-4.073795 48.055643,-4.07392 48.05591,-4.074037 48.057021,-4.074178 48.057514,-4.074306 48.057868,-4.074383 48.058178,-4.074415 48.058682,-4.074381 48.058988,-4.074389 48.059198,-4.074497 48.059704,-4.074566 48.059887,-4.074751 48.060219,-4.074941 48.06043,-4.075224 48.060613,-4.075402 48.060843,-4.0758 48.061263,-4.076064 48.061402,-4.076344 48.061629,-4.076533 48.061903,-4.076694 48.06202,-4.076809 48.062202,-4.076765 48.062395,-4.076614 48.062557,-4.076594 48.062791,-4.076641 48.062936,-4.076902 48.06331,-4.076914 48.063457,-4.076813 48.063607,-4.076818 48.06381,-4.076958 48.064074,-4.077148 48.064146,-4.077649 48.064242,-4.078053 48.064244,-4.078773 48.064345,-4.07909 48.064467,-4.079754 48.064506,-4.079962 48.064434,-4.080106 48.064433,-4.08057 48.064359,-4.080902 48.064378,-4.08144 48.064239,-4.081839 48.06427,-4.082266 48.064214,-4.082557 48.064216,-4.082905 48.064307,-4.083031 48.064425,-4.083276 48.064485,-4.083754 48.064516,-4.08392 48.06448,-4.084011 48.064338,-4.084167 48.064352,-4.084337 48.06446,-4.084864 48.064676,-4.085139 48.064865,-4.085294 48.065006,-4.08549 48.065128,-4.085765 48.065148,-4.086172 48.065062,-4.086486 48.065019,-4.086665 48.064956,-4.086986 48.064976,-4.087231 48.064815,-4.087351 48.064636,-4.087587 48.064442,-4.087802 48.064452,-4.088 48.064368,-4.088299 48.064195,-4.088636 48.064129,-4.088915 48.063957,-4.089046 48.063918,-4.089392 48.064006,-4.090276 48.064091,-4.090811 48.06403,-4.090989 48.06404,-4.091247 48.064105,-4.092091 48.064215,-4.092272 48.064251,-4.092637 48.064462,-4.092745 48.064575,-4.092963 48.064933,-4.093038 48.065166,-4.092975 48.065222,-4.093069 48.065458,-4.09292 48.065615,-4.092955 48.065703,-4.093206 48.065849,-4.093412 48.065855,-4.093798 48.065747,-4.094093 48.065737,-4.094348 48.065791,-4.094563 48.065789,-4.095028 48.065939,-4.095269 48.065951,-4.09557 48.066027,-4.09623 48.066073,-4.096702 48.066004,-4.096977 48.065912,-4.097123 48.065806,-4.097668 48.065744,-4.098063 48.065539,-4.098292 48.065509,-4.098481 48.065416,-4.098669 48.065225,-4.098846 48.065188,-4.099181 48.065312,-4.099498 48.065312,-4.099849 48.065123,-4.100154 48.064991,-4.100466 48.06489,-4.100636 48.064705,-4.100775 48.064672,-4.100918 48.064523,-4.101208 48.064415,-4.101437 48.064236,-4.10191 48.064092,-4.102339 48.064036,-4.102647 48.063941,-4.102861 48.063837,-4.103102 48.06378,-4.103332 48.063793,-4.10365 48.063763,-4.103984 48.063817,-4.10407 48.064085,-4.10454 48.064179,-4.10476 48.0643,-4.104816 48.064403,-4.105002 48.064322,-4.105607 48.064303,-4.106047 48.064436,-4.106173 48.064563,-4.106543 48.064735)))"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.60 ms
(1.22%) 		3 
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?
Parameters: 
[
  "public"
  "osm_object_meta"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.16 ms
(1.01%) 		1 
SELECT COUNT(*) FROM osm_object_meta WHERE osm_type = 'relation'
                  AND geom IS NOT NULL
                  AND (tags->'admin_level') = '8'
                  AND (tags->'boundary') = 'administrative'
                  AND (tags->'ref:INSEE') IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(0.58%) 		1 
INSERT INTO osm_object_meta (
    osm_type, osm_id, geom, tags, version, osm_timestamp, changeset, osm_user, uid
)
SELECT
    'relation',
    latest.osm_id,
    latest.geom,
    latest.tags,
    latest.version,
    to_char(latest.valid_from AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"'),
    latest.changeset,
    latest.osm_user,
    latest.uid
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.osm_id,
        h.geom,
        h.tags,
        h.version,
        h.valid_from,
        h.changeset,
        h.osm_user,
        h.uid
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'boundary') = 'administrative'
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'ref:INSEE') IS NOT NULL
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) AS latest
WHERE NOT EXISTS (
    SELECT 1 FROM osm_object_meta m
    WHERE m.osm_type = 'relation' AND m.osm_id = latest.osm_id
)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(0.43%) 		1 
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters: 
[
  "29106"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(0.28%) 		1 
CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.21%) 		1 
SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.geom
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'ref:INSEE') = ?
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'boundary') = 'administrative'
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) latest
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1
Parameters: 
[
  "29106"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.19%) 		1 
SELECT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.11%) 		1 
CREATE TABLE IF NOT EXISTS zone_polygon (
                    insee_code TEXT PRIMARY KEY,
                    geom geometry(MultiPolygon, 4326) NOT NULL,
                    source TEXT NOT NULL,
                    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
                )
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection
osm doctrine.dbal.osm_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CityFollowUp 4661
App\Entity\Stats 1
App\Entity\ActionLog 1
App\Entity\ZonePlaces 1

Entities Mapping

Class Mapping errors
App\Entity\Stats No errors.
App\Entity\Place No errors.
App\Entity\StatsHistory No errors.
App\Entity\CityFollowUp No errors.
App\Entity\ZonePlaces No errors.
App\Entity\SireneEntreprise No errors.
App\Entity\ActionLog No errors.