Symfony Profiler

Query Metrics

16 Database Queries

14 Different statements

127.57 ms Query time

0 Invalid entities

4536 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

85.31 ms
(66.87%)

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:

[
  27147
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 27147;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\PublicController->statsEvolutions (line 1863)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.56 ms
(0.44%)

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:

[
  27147
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 27147;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\PublicController->statsEvolutions (line 1919)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.35 ms
(0.28%)

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:

[
  "44026"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '44026' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\PublicController->statsEvolutions (line 1804)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

osm connection

Time▼

Count

Info

27.17 ms
(21.30%)

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 akeys(tags) && ARRAY['amenity','shop','office','craft','leisure','healthcare','emergency','man_made','power','highway','railway','public_transport','landuse','historic','barrier','tourism','sport','place','waterway','natural','geological','route','military','traffic_sign','traffic_calming','seamark','route_master','water','airway','aerialway','building']::text[]

Parameters:

[
  "MULTIPOLYGON(((-1.443186 47.335698,-1.442678 47.335572,-1.441873 47.335276,-1.441605 47.335157,-1.44089 47.334896,-1.439945 47.334496,-1.439252 47.334023,-1.439051 47.334014,-1.438934 47.333836,-1.438595 47.333843,-1.438412 47.333874,-1.438041 47.333615,-1.438067 47.333548,-1.437974 47.333366,-1.437548 47.33325,-1.437327 47.333,-1.437504 47.33279,-1.437513 47.332643,-1.437402 47.332465,-1.437163 47.332241,-1.437 47.332148,-1.43679 47.332091,-1.436408 47.33209,-1.436247 47.332054,-1.436046 47.331909,-1.435725 47.331562,-1.435512 47.331301,-1.435314 47.331111,-1.434975 47.33091,-1.434768 47.330746,-1.434542 47.330439,-1.434314 47.330091,-1.433934 47.329741,-1.433426 47.32948,-1.432843 47.329037,-1.432506 47.328739,-1.432259 47.328432,-1.432096 47.328032,-1.431983 47.327914,-1.431724 47.327748,-1.431534 47.327551,-1.43137 47.327447,-1.431166 47.327424,-1.430874 47.327435,-1.430733 47.327408,-1.430565 47.327294,-1.43035 47.327059,-1.430301 47.326923,-1.430316 47.326743,-1.4303 47.326398,-1.430221 47.326197,-1.429852 47.325876,-1.429636 47.32575,-1.429047 47.325461,-1.428861 47.32531,-1.428545 47.325174,-1.428029 47.325092,-1.427633 47.325048,-1.427092 47.325039,-1.426891 47.324931,-1.426457 47.324616,-1.426134 47.32432,-1.425968 47.324135,-1.425746 47.323828,-1.425428 47.323553,-1.425187 47.32329,-1.424682 47.322843,-1.424579 47.322683,-1.424563 47.322537,-1.423776 47.321829,-1.423563 47.321603,-1.42346 47.321547,-1.423128 47.321575,-1.42291 47.321531,-1.422724 47.321452,-1.422583 47.321101,-1.422405 47.320944,-1.422038 47.320721,-1.421525 47.320575,-1.421326 47.320409,-1.421189 47.320344,-1.42098 47.32057,-1.420877 47.320478,-1.420697 47.320455,-1.420513 47.320367,-1.420295 47.320405,-1.420087 47.320293,-1.420016 47.320135,-1.420051 47.319933,-1.419925 47.319838,-1.419962 47.319656,-1.419622 47.319474,-1.419744 47.319344,-1.419533 47.319281,-1.419278 47.319151,-1.419211 47.318964,-1.419235 47.318883,-1.419064 47.318788,-1.418999 47.318626,-1.419151 47.318585,-1.419035 47.318438,-1.419056 47.318323,-1.418849 47.31805,-1.418685 47.318048,-1.418286 47.317811,-1.417905 47.31766,-1.417694 47.317527,-1.417132 47.317277,-1.416654 47.317009,-1.416488 47.316858,-1.416378 47.316653,-1.416278 47.316545,-1.415758 47.316175,-1.415452 47.315933,-1.415198 47.31578,-1.415074 47.315663,-1.415035 47.315535,-1.414957 47.314984,-1.414621 47.314478,-1.414152 47.3139,-1.413982 47.313762,-1.413355 47.313735,-1.413061 47.313692,-1.412944 47.313623,-1.412891 47.313476,-1.413021 47.313231,-1.413222 47.312933,-1.413146 47.312809,-1.412339 47.312266,-1.411801 47.312199,-1.411643 47.312121,-1.411533 47.312009,-1.411363 47.311937,-1.411066 47.311876,-1.410987 47.311783,-1.410894 47.311423,-1.410724 47.311158,-1.410442 47.311003,-1.410289 47.31095,-1.410167 47.310723,-1.410232 47.310471,-1.410204 47.310334,-1.410248 47.310196,-1.410372 47.310025,-1.410303 47.309831,-1.410384 47.309603,-1.410416 47.309408,-1.41054 47.309117,-1.410512 47.308877,-1.410329 47.308675,-1.410029 47.308454,-1.409977 47.308321,-1.410045 47.308148,-1.410371 47.30761,-1.410471 47.307135,-1.41044 47.306526,-1.41025 47.306369,-1.41025 47.306172,-1.410163 47.306033,-1.41018 47.305912,-1.410441 47.305826,-1.410512 47.305646,-1.410505 47.305404,-1.410246 47.305184,-1.410205 47.305112,-1.41036 47.304843,-1.409814 47.30398,-1.409638 47.303758,-1.409139 47.303455,-1.408819 47.303085,-1.408685 47.302871,-1.408343 47.302412,-1.407838 47.301933,-1.407503 47.301367,-1.407077 47.300591,-1.406877 47.300141,-1.406675 47.299784,-1.406432 47.299462,-1.406162 47.299177,-1.405919 47.298961,-1.405861 47.298783,-1.406079 47.298515,-1.406064 47.29841,-1.405891 47.298316,-1.405674 47.298151,-1.40531 47.297798,-1.40495 47.297414,-1.405572 47.297171,-1.406628 47.296792,-1.407032 47.296681,-1.407942 47.296337,-1.409884 47.295642,-1.411676 47.294975,-1.412689 47.294608,-1.413601 47.294297,-1.414805 47.293864,-1.415509 47.293662,-1.415989 47.293575,-1.41649 47.293532,-1.417011 47.293541,-1.417737 47.293602,-1.418609 47.293707,-1.418764 47.293737,-1.41953 47.293753,-1.420294 47.293681,-1.420721 47.293595,-1.42126 47.293404,-1.42172 47.293214,-1.424257 47.292094,-1.424902 47.291832,-1.426344 47.291268,-1.428559 47.290409,-1.430193 47.289768,-1.431037 47.289453,-1.431379 47.289342,-1.43199 47.289175,-1.433102 47.288927,-1.43338 47.28885,-1.434548 47.288471,-1.435342 47.288259,-1.435644 47.28822,-1.43674 47.288217,-1.438739 47.288255,-1.440601 47.28828,-1.441189 47.288255,-1.441815 47.288162,-1.442482 47.287979,-1.442784 47.287852,-1.443259 47.287621,-1.443904 47.287288,-1.445092 47.286699,-1.447946 47.285299,-1.450211 47.284171,-1.453078 47.282712,-1.453399 47.282539,-1.454563 47.282012,-1.455243 47.281654,-1.456523 47.281018,-1.457413 47.280565,-1.460947 47.278842,-1.462758 47.277971,-1.466265 47.276272,-1.467871 47.275502,-1.468662 47.275104,-1.469289 47.274828,-1.469758 47.274589,-1.472098 47.273464,-1.473614 47.27274,-1.474843 47.272177,-1.476056 47.27155,-1.477637 47.270785,-1.478257 47.270496,-1.479058 47.270105,-1.479425 47.269914,-1.480197 47.26955,-1.481423 47.268954,-1.482293 47.268522,-1.483052 47.268135,-1.483798 47.267772,-1.48551 47.266974,-1.48705 47.266232,-1.489267 47.265139,-1.489971 47.264802,-1.490899 47.264344,-1.492309 47.263663,-1.495152 47.262273,-1.495815 47.26201,-1.498189 47.260936,-1.499191 47.260488,-1.500701 47.259838,-1.501797 47.25945,-1.502079 47.259479,-1.504411 47.25864,-1.505224 47.258314,-1.505107 47.25819,-1.505648 47.25796,-1.506028 47.258822,-1.506328 47.259194,-1.506213 47.259266,-1.5062 47.259375,-1.506075 47.259436,-1.506239 47.259672,-1.506732 47.26024,-1.50604 47.261459,-1.508194 47.261996,-1.507416 47.263206,-1.506995 47.263831,-1.506627 47.264166,-1.505874 47.264689,-1.503258 47.266468,-1.503021 47.266673,-1.50284 47.266945,-1.502113 47.268402,-1.502045 47.268554,-1.501585 47.269456,-1.501396 47.269744,-1.501024 47.270239,-1.499939 47.271532,-1.499428 47.272162,-1.50212 47.273194,-1.502817 47.273492,-1.503937 47.273927,-1.504197 47.274036,-1.504813 47.274245,-1.50531 47.274379,-1.505654 47.274433,-1.506812 47.274587,-1.507872 47.274736,-1.50964 47.274976,-1.509611 47.276003,-1.509611 47.276386,-1.509545 47.276956,-1.509391 47.277514,-1.508958 47.27896,-1.508797 47.279342,-1.508567 47.279695,-1.508748 47.279748,-1.509324 47.280641,-1.51003 47.281624,-1.510525 47.2831,-1.510097 47.284341,-1.51032 47.284519,-1.509484 47.28509,-1.509097 47.285715,-1.508737 47.286426,-1.508612 47.286776,-1.508546 47.286874,-1.508397 47.287277,-1.508573 47.287342,-1.508175 47.288127,-1.508108 47.288472,-1.508271 47.289411,-1.50827 47.289635,-1.508165 47.289863,-1.508151 47.290002,-1.508205 47.29039,-1.508261 47.290566,-1.508349 47.291486,-1.508268 47.292019,-1.508404 47.292715,-1.508445 47.293508,-1.508511 47.293765,-1.508629 47.293989,-1.509708 47.29561,-1.511094 47.29507,-1.511528 47.294874,-1.512335 47.294558,-1.5127 47.294464,-1.513057 47.294411,-1.513509 47.294294,-1.51413 47.294177,-1.514281 47.294121,-1.514799 47.294143,-1.515347 47.294186,-1.515817 47.294241,-1.516219 47.294353,-1.51725 47.294782,-1.518707 47.295212,-1.519268 47.295465,-1.519733 47.295773,-1.520009 47.295838,-1.520934 47.295839,-1.521796 47.295786,-1.522023 47.295761,-1.522409 47.295774,-1.522915 47.295674,-1.523304 47.295544,-1.524091 47.295001,-1.524506 47.294847,-1.524801 47.294689,-1.525176 47.294562,-1.525454 47.294427,-1.525694 47.294353,-1.526006 47.294338,-1.526356 47.294402,-1.527218 47.29459,-1.530659 47.294872,-1.532423 47.295023,-1.532216 47.295195,-1.532161 47.295912,-1.532158 47.296325,-1.532267 47.297211,-1.532176 47.297472,-1.53203 47.297763,-1.531608 47.298432,-1.531276 47.298867,-1.531099 47.299024,-1.53085 47.299191,-1.530663 47.299364,-1.530312 47.2998,-1.53013 47.30024,-1.5299 47.300743,-1.529726 47.301014,-1.529552 47.301337,-1.529487 47.301883,-1.529276 47.302348,-1.529203 47.302682,-1.529185 47.302992,-1.529235 47.303299,-1.529297 47.303483,-1.529597 47.303894,-1.529818 47.304084,-1.53057 47.304775,-1.530727 47.305005,-1.530855 47.305352,-1.53083 47.305856,-1.530781 47.306269,-1.53071 47.306632,-1.5307 47.30699,-1.530721 47.307455,-1.530808 47.307965,-1.530907 47.308403,-1.531017 47.308782,-1.531449 47.30956,-1.531626 47.309838,-1.531828 47.310061,-1.531723 47.310406,-1.531369 47.311005,-1.531042 47.311356,-1.53068 47.311629,-1.529753 47.312419,-1.529556 47.312642,-1.529365 47.312905,-1.528864 47.313528,-1.528549 47.313792,-1.528159 47.314064,-1.527702 47.314412,-1.52721 47.314872,-1.526815 47.315305,-1.526367 47.315924,-1.526042 47.316327,-1.525768 47.316886,-1.525715 47.317137,-1.525655 47.317877,-1.525575 47.318697,-1.525567 47.318993,-1.525315 47.321351,-1.527478 47.325034,-1.524709 47.325646,-1.523553 47.325876,-1.521365 47.326138,-1.521075 47.326162,-1.520133 47.326012,-1.519838 47.325941,-1.51935 47.325742,-1.519077 47.325682,-1.518564 47.325672,-1.518353 47.325602,-1.517671 47.325223,-1.516889 47.324739,-1.516476 47.324509,-1.51617 47.324377,-1.515764 47.324003,-1.515315 47.32365,-1.514904 47.323377,-1.514606 47.323248,-1.514346 47.323201,-1.513775 47.323143,-1.513335 47.32302,-1.513017 47.322981,-1.512219 47.322994,-1.51198 47.322915,-1.511689 47.322907,-1.511288 47.323039,-1.510716 47.323165,-1.510388 47.323163,-1.510267 47.323238,-1.510015 47.32323,-1.508808 47.3238,-1.507889 47.324115,-1.506552 47.324525,-1.502997 47.326076,-1.501042 47.325996,-1.499319 47.325883,-1.498966 47.325733,-1.497338 47.325394,-1.49663 47.325055,-1.495591 47.324578,-1.495911 47.324302,-1.496122 47.323752,-1.496051 47.323643,-1.49557 47.323604,-1.495124 47.323705,-1.494762 47.323654,-1.493844 47.323386,-1.493383 47.322868,-1.493324 47.322655,-1.49327 47.322631,-1.492688 47.322769,-1.492139 47.322532,-1.492025 47.322438,-1.491543 47.321879,-1.49145 47.3218,-1.491246 47.321734,-1.49123 47.321907,-1.490916 47.321916,-1.490749 47.322021,-1.490611 47.321978,-1.490132 47.321736,-1.489488 47.321487,-1.488191 47.321246,-1.487617 47.321232,-1.487209 47.321133,-1.486635 47.320927,-1.486129 47.320788,-1.486029 47.320716,-1.485847 47.320715,-1.485597 47.320647,-1.485103 47.320572,-1.484827 47.320452,-1.484319 47.320348,-1.483906 47.320321,-1.483596 47.320325,-1.483166 47.32037,-1.482695 47.32057,-1.482525 47.320709,-1.482008 47.32082,-1.481736 47.320901,-1.481587 47.321036,-1.481385 47.321078,-1.480489 47.321041,-1.479727 47.320935,-1.479122 47.320959,-1.478622 47.320857,-1.478791 47.321873,-1.478574 47.321816,-1.478107 47.32164,-1.477623 47.321492,-1.47725 47.321466,-1.476946 47.321485,-1.476595 47.321561,-1.476251 47.321674,-1.475897 47.321694,-1.475698 47.321653,-1.475318 47.321503,-1.475113 47.321665,-1.474838 47.321768,-1.474494 47.321795,-1.473919 47.321951,-1.472974 47.322023,-1.472318 47.32231,-1.472101 47.322648,-1.471343 47.323651,-1.471217 47.324034,-1.471225 47.324708,-1.471166 47.325585,-1.471028 47.32575,-1.470829 47.325624,-1.470662 47.325765,-1.470461 47.325804,-1.470373 47.326004,-1.470151 47.326173,-1.469827 47.326266,-1.469108 47.32635,-1.468461 47.326383,-1.468217 47.32641,-1.467636 47.326532,-1.46715 47.326528,-1.466215 47.326366,-1.465631 47.326134,-1.465358 47.325941,-1.464389 47.325987,-1.464224 47.326129,-1.464112 47.326147,-1.462827 47.32624,-1.462341 47.326321,-1.4619 47.326377,-1.461234 47.326394,-1.459783 47.326266,-1.458385 47.32626,-1.457873 47.326342,-1.457604 47.326474,-1.457413 47.326625,-1.457301 47.326812,-1.457263 47.327074,-1.457091 47.326982,-1.456937 47.326968,-1.456762 47.327065,-1.456452 47.327151,-1.455888 47.327336,-1.455265 47.327419,-1.455225 47.327205,-1.453469 47.327457,-1.451779 47.327686,-1.451632 47.327692,-1.451501 47.327823,-1.451215 47.328011,-1.450032 47.328656,-1.450204 47.328885,-1.449597 47.32962,-1.449554 47.329707,-1.449194 47.330186,-1.448773 47.330716,-1.448725 47.330747,-1.448596 47.331045,-1.447863 47.331753,-1.448218 47.332081,-1.447019 47.333321,-1.446623 47.333612,-1.44651 47.333485,-1.446321 47.333526,-1.445577 47.333878,-1.44502 47.33418,-1.444619 47.334464,-1.443741 47.335194,-1.443309 47.335606,-1.443186 47.335698)))"
]

View formatted query View runnable query Explain query View query backtrace

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 akeys(tags) && ARRAY[ 'amenity',
  'shop',
  'office',
  'craft',
  'leisure',
  'healthcare',
  'emergency',
  'man_made',
  'power',
  'highway',
  'railway',
  'public_transport',
  'landuse',
  'historic',
  'barrier',
  'tourism',
  'sport',
  'place',
  'waterway',
  'natural',
  'geological',
  'route',
  'military',
  'traffic_sign',
  'traffic_calming',
  'seamark',
  'route_master',
  'water',
  'airway',
  'aerialway',
  'building' ] :: text[]

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('MULTIPOLYGON(((-1.443186 47.335698,-1.442678 47.335572,-1.441873 47.335276,-1.441605 47.335157,-1.44089 47.334896,-1.439945 47.334496,-1.439252 47.334023,-1.439051 47.334014,-1.438934 47.333836,-1.438595 47.333843,-1.438412 47.333874,-1.438041 47.333615,-1.438067 47.333548,-1.437974 47.333366,-1.437548 47.33325,-1.437327 47.333,-1.437504 47.33279,-1.437513 47.332643,-1.437402 47.332465,-1.437163 47.332241,-1.437 47.332148,-1.43679 47.332091,-1.436408 47.33209,-1.436247 47.332054,-1.436046 47.331909,-1.435725 47.331562,-1.435512 47.331301,-1.435314 47.331111,-1.434975 47.33091,-1.434768 47.330746,-1.434542 47.330439,-1.434314 47.330091,-1.433934 47.329741,-1.433426 47.32948,-1.432843 47.329037,-1.432506 47.328739,-1.432259 47.328432,-1.432096 47.328032,-1.431983 47.327914,-1.431724 47.327748,-1.431534 47.327551,-1.43137 47.327447,-1.431166 47.327424,-1.430874 47.327435,-1.430733 47.327408,-1.430565 47.327294,-1.43035 47.327059,-1.430301 47.326923,-1.430316 47.326743,-1.4303 47.326398,-1.430221 47.326197,-1.429852 47.325876,-1.429636 47.32575,-1.429047 47.325461,-1.428861 47.32531,-1.428545 47.325174,-1.428029 47.325092,-1.427633 47.325048,-1.427092 47.325039,-1.426891 47.324931,-1.426457 47.324616,-1.426134 47.32432,-1.425968 47.324135,-1.425746 47.323828,-1.425428 47.323553,-1.425187 47.32329,-1.424682 47.322843,-1.424579 47.322683,-1.424563 47.322537,-1.423776 47.321829,-1.423563 47.321603,-1.42346 47.321547,-1.423128 47.321575,-1.42291 47.321531,-1.422724 47.321452,-1.422583 47.321101,-1.422405 47.320944,-1.422038 47.320721,-1.421525 47.320575,-1.421326 47.320409,-1.421189 47.320344,-1.42098 47.32057,-1.420877 47.320478,-1.420697 47.320455,-1.420513 47.320367,-1.420295 47.320405,-1.420087 47.320293,-1.420016 47.320135,-1.420051 47.319933,-1.419925 47.319838,-1.419962 47.319656,-1.419622 47.319474,-1.419744 47.319344,-1.419533 47.319281,-1.419278 47.319151,-1.419211 47.318964,-1.419235 47.318883,-1.419064 47.318788,-1.418999 47.318626,-1.419151 47.318585,-1.419035 47.318438,-1.419056 47.318323,-1.418849 47.31805,-1.418685 47.318048,-1.418286 47.317811,-1.417905 47.31766,-1.417694 47.317527,-1.417132 47.317277,-1.416654 47.317009,-1.416488 47.316858,-1.416378 47.316653,-1.416278 47.316545,-1.415758 47.316175,-1.415452 47.315933,-1.415198 47.31578,-1.415074 47.315663,-1.415035 47.315535,-1.414957 47.314984,-1.414621 47.314478,-1.414152 47.3139,-1.413982 47.313762,-1.413355 47.313735,-1.413061 47.313692,-1.412944 47.313623,-1.412891 47.313476,-1.413021 47.313231,-1.413222 47.312933,-1.413146 47.312809,-1.412339 47.312266,-1.411801 47.312199,-1.411643 47.312121,-1.411533 47.312009,-1.411363 47.311937,-1.411066 47.311876,-1.410987 47.311783,-1.410894 47.311423,-1.410724 47.311158,-1.410442 47.311003,-1.410289 47.31095,-1.410167 47.310723,-1.410232 47.310471,-1.410204 47.310334,-1.410248 47.310196,-1.410372 47.310025,-1.410303 47.309831,-1.410384 47.309603,-1.410416 47.309408,-1.41054 47.309117,-1.410512 47.308877,-1.410329 47.308675,-1.410029 47.308454,-1.409977 47.308321,-1.410045 47.308148,-1.410371 47.30761,-1.410471 47.307135,-1.41044 47.306526,-1.41025 47.306369,-1.41025 47.306172,-1.410163 47.306033,-1.41018 47.305912,-1.410441 47.305826,-1.410512 47.305646,-1.410505 47.305404,-1.410246 47.305184,-1.410205 47.305112,-1.41036 47.304843,-1.409814 47.30398,-1.409638 47.303758,-1.409139 47.303455,-1.408819 47.303085,-1.408685 47.302871,-1.408343 47.302412,-1.407838 47.301933,-1.407503 47.301367,-1.407077 47.300591,-1.406877 47.300141,-1.406675 47.299784,-1.406432 47.299462,-1.406162 47.299177,-1.405919 47.298961,-1.405861 47.298783,-1.406079 47.298515,-1.406064 47.29841,-1.405891 47.298316,-1.405674 47.298151,-1.40531 47.297798,-1.40495 47.297414,-1.405572 47.297171,-1.406628 47.296792,-1.407032 47.296681,-1.407942 47.296337,-1.409884 47.295642,-1.411676 47.294975,-1.412689 47.294608,-1.413601 47.294297,-1.414805 47.293864,-1.415509 47.293662,-1.415989 47.293575,-1.41649 47.293532,-1.417011 47.293541,-1.417737 47.293602,-1.418609 47.293707,-1.418764 47.293737,-1.41953 47.293753,-1.420294 47.293681,-1.420721 47.293595,-1.42126 47.293404,-1.42172 47.293214,-1.424257 47.292094,-1.424902 47.291832,-1.426344 47.291268,-1.428559 47.290409,-1.430193 47.289768,-1.431037 47.289453,-1.431379 47.289342,-1.43199 47.289175,-1.433102 47.288927,-1.43338 47.28885,-1.434548 47.288471,-1.435342 47.288259,-1.435644 47.28822,-1.43674 47.288217,-1.438739 47.288255,-1.440601 47.28828,-1.441189 47.288255,-1.441815 47.288162,-1.442482 47.287979,-1.442784 47.287852,-1.443259 47.287621,-1.443904 47.287288,-1.445092 47.286699,-1.447946 47.285299,-1.450211 47.284171,-1.453078 47.282712,-1.453399 47.282539,-1.454563 47.282012,-1.455243 47.281654,-1.456523 47.281018,-1.457413 47.280565,-1.460947 47.278842,-1.462758 47.277971,-1.466265 47.276272,-1.467871 47.275502,-1.468662 47.275104,-1.469289 47.274828,-1.469758 47.274589,-1.472098 47.273464,-1.473614 47.27274,-1.474843 47.272177,-1.476056 47.27155,-1.477637 47.270785,-1.478257 47.270496,-1.479058 47.270105,-1.479425 47.269914,-1.480197 47.26955,-1.481423 47.268954,-1.482293 47.268522,-1.483052 47.268135,-1.483798 47.267772,-1.48551 47.266974,-1.48705 47.266232,-1.489267 47.265139,-1.489971 47.264802,-1.490899 47.264344,-1.492309 47.263663,-1.495152 47.262273,-1.495815 47.26201,-1.498189 47.260936,-1.499191 47.260488,-1.500701 47.259838,-1.501797 47.25945,-1.502079 47.259479,-1.504411 47.25864,-1.505224 47.258314,-1.505107 47.25819,-1.505648 47.25796,-1.506028 47.258822,-1.506328 47.259194,-1.506213 47.259266,-1.5062 47.259375,-1.506075 47.259436,-1.506239 47.259672,-1.506732 47.26024,-1.50604 47.261459,-1.508194 47.261996,-1.507416 47.263206,-1.506995 47.263831,-1.506627 47.264166,-1.505874 47.264689,-1.503258 47.266468,-1.503021 47.266673,-1.50284 47.266945,-1.502113 47.268402,-1.502045 47.268554,-1.501585 47.269456,-1.501396 47.269744,-1.501024 47.270239,-1.499939 47.271532,-1.499428 47.272162,-1.50212 47.273194,-1.502817 47.273492,-1.503937 47.273927,-1.504197 47.274036,-1.504813 47.274245,-1.50531 47.274379,-1.505654 47.274433,-1.506812 47.274587,-1.507872 47.274736,-1.50964 47.274976,-1.509611 47.276003,-1.509611 47.276386,-1.509545 47.276956,-1.509391 47.277514,-1.508958 47.27896,-1.508797 47.279342,-1.508567 47.279695,-1.508748 47.279748,-1.509324 47.280641,-1.51003 47.281624,-1.510525 47.2831,-1.510097 47.284341,-1.51032 47.284519,-1.509484 47.28509,-1.509097 47.285715,-1.508737 47.286426,-1.508612 47.286776,-1.508546 47.286874,-1.508397 47.287277,-1.508573 47.287342,-1.508175 47.288127,-1.508108 47.288472,-1.508271 47.289411,-1.50827 47.289635,-1.508165 47.289863,-1.508151 47.290002,-1.508205 47.29039,-1.508261 47.290566,-1.508349 47.291486,-1.508268 47.292019,-1.508404 47.292715,-1.508445 47.293508,-1.508511 47.293765,-1.508629 47.293989,-1.509708 47.29561,-1.511094 47.29507,-1.511528 47.294874,-1.512335 47.294558,-1.5127 47.294464,-1.513057 47.294411,-1.513509 47.294294,-1.51413 47.294177,-1.514281 47.294121,-1.514799 47.294143,-1.515347 47.294186,-1.515817 47.294241,-1.516219 47.294353,-1.51725 47.294782,-1.518707 47.295212,-1.519268 47.295465,-1.519733 47.295773,-1.520009 47.295838,-1.520934 47.295839,-1.521796 47.295786,-1.522023 47.295761,-1.522409 47.295774,-1.522915 47.295674,-1.523304 47.295544,-1.524091 47.295001,-1.524506 47.294847,-1.524801 47.294689,-1.525176 47.294562,-1.525454 47.294427,-1.525694 47.294353,-1.526006 47.294338,-1.526356 47.294402,-1.527218 47.29459,-1.530659 47.294872,-1.532423 47.295023,-1.532216 47.295195,-1.532161 47.295912,-1.532158 47.296325,-1.532267 47.297211,-1.532176 47.297472,-1.53203 47.297763,-1.531608 47.298432,-1.531276 47.298867,-1.531099 47.299024,-1.53085 47.299191,-1.530663 47.299364,-1.530312 47.2998,-1.53013 47.30024,-1.5299 47.300743,-1.529726 47.301014,-1.529552 47.301337,-1.529487 47.301883,-1.529276 47.302348,-1.529203 47.302682,-1.529185 47.302992,-1.529235 47.303299,-1.529297 47.303483,-1.529597 47.303894,-1.529818 47.304084,-1.53057 47.304775,-1.530727 47.305005,-1.530855 47.305352,-1.53083 47.305856,-1.530781 47.306269,-1.53071 47.306632,-1.5307 47.30699,-1.530721 47.307455,-1.530808 47.307965,-1.530907 47.308403,-1.531017 47.308782,-1.531449 47.30956,-1.531626 47.309838,-1.531828 47.310061,-1.531723 47.310406,-1.531369 47.311005,-1.531042 47.311356,-1.53068 47.311629,-1.529753 47.312419,-1.529556 47.312642,-1.529365 47.312905,-1.528864 47.313528,-1.528549 47.313792,-1.528159 47.314064,-1.527702 47.314412,-1.52721 47.314872,-1.526815 47.315305,-1.526367 47.315924,-1.526042 47.316327,-1.525768 47.316886,-1.525715 47.317137,-1.525655 47.317877,-1.525575 47.318697,-1.525567 47.318993,-1.525315 47.321351,-1.527478 47.325034,-1.524709 47.325646,-1.523553 47.325876,-1.521365 47.326138,-1.521075 47.326162,-1.520133 47.326012,-1.519838 47.325941,-1.51935 47.325742,-1.519077 47.325682,-1.518564 47.325672,-1.518353 47.325602,-1.517671 47.325223,-1.516889 47.324739,-1.516476 47.324509,-1.51617 47.324377,-1.515764 47.324003,-1.515315 47.32365,-1.514904 47.323377,-1.514606 47.323248,-1.514346 47.323201,-1.513775 47.323143,-1.513335 47.32302,-1.513017 47.322981,-1.512219 47.322994,-1.51198 47.322915,-1.511689 47.322907,-1.511288 47.323039,-1.510716 47.323165,-1.510388 47.323163,-1.510267 47.323238,-1.510015 47.32323,-1.508808 47.3238,-1.507889 47.324115,-1.506552 47.324525,-1.502997 47.326076,-1.501042 47.325996,-1.499319 47.325883,-1.498966 47.325733,-1.497338 47.325394,-1.49663 47.325055,-1.495591 47.324578,-1.495911 47.324302,-1.496122 47.323752,-1.496051 47.323643,-1.49557 47.323604,-1.495124 47.323705,-1.494762 47.323654,-1.493844 47.323386,-1.493383 47.322868,-1.493324 47.322655,-1.49327 47.322631,-1.492688 47.322769,-1.492139 47.322532,-1.492025 47.322438,-1.491543 47.321879,-1.49145 47.3218,-1.491246 47.321734,-1.49123 47.321907,-1.490916 47.321916,-1.490749 47.322021,-1.490611 47.321978,-1.490132 47.321736,-1.489488 47.321487,-1.488191 47.321246,-1.487617 47.321232,-1.487209 47.321133,-1.486635 47.320927,-1.486129 47.320788,-1.486029 47.320716,-1.485847 47.320715,-1.485597 47.320647,-1.485103 47.320572,-1.484827 47.320452,-1.484319 47.320348,-1.483906 47.320321,-1.483596 47.320325,-1.483166 47.32037,-1.482695 47.32057,-1.482525 47.320709,-1.482008 47.32082,-1.481736 47.320901,-1.481587 47.321036,-1.481385 47.321078,-1.480489 47.321041,-1.479727 47.320935,-1.479122 47.320959,-1.478622 47.320857,-1.478791 47.321873,-1.478574 47.321816,-1.478107 47.32164,-1.477623 47.321492,-1.47725 47.321466,-1.476946 47.321485,-1.476595 47.321561,-1.476251 47.321674,-1.475897 47.321694,-1.475698 47.321653,-1.475318 47.321503,-1.475113 47.321665,-1.474838 47.321768,-1.474494 47.321795,-1.473919 47.321951,-1.472974 47.322023,-1.472318 47.32231,-1.472101 47.322648,-1.471343 47.323651,-1.471217 47.324034,-1.471225 47.324708,-1.471166 47.325585,-1.471028 47.32575,-1.470829 47.325624,-1.470662 47.325765,-1.470461 47.325804,-1.470373 47.326004,-1.470151 47.326173,-1.469827 47.326266,-1.469108 47.32635,-1.468461 47.326383,-1.468217 47.32641,-1.467636 47.326532,-1.46715 47.326528,-1.466215 47.326366,-1.465631 47.326134,-1.465358 47.325941,-1.464389 47.325987,-1.464224 47.326129,-1.464112 47.326147,-1.462827 47.32624,-1.462341 47.326321,-1.4619 47.326377,-1.461234 47.326394,-1.459783 47.326266,-1.458385 47.32626,-1.457873 47.326342,-1.457604 47.326474,-1.457413 47.326625,-1.457301 47.326812,-1.457263 47.327074,-1.457091 47.326982,-1.456937 47.326968,-1.456762 47.327065,-1.456452 47.327151,-1.455888 47.327336,-1.455265 47.327419,-1.455225 47.327205,-1.453469 47.327457,-1.451779 47.327686,-1.451632 47.327692,-1.451501 47.327823,-1.451215 47.328011,-1.450032 47.328656,-1.450204 47.328885,-1.449597 47.32962,-1.449554 47.329707,-1.449194 47.330186,-1.448773 47.330716,-1.448725 47.330747,-1.448596 47.331045,-1.447863 47.331753,-1.448218 47.332081,-1.447019 47.333321,-1.446623 47.333612,-1.44651 47.333485,-1.446321 47.333526,-1.445577 47.333878,-1.44502 47.33418,-1.444619 47.334464,-1.443741 47.335194,-1.443309 47.335606,-1.443186 47.335698)))', 4326))
            AND akeys(tags) && ARRAY['amenity','shop','office','craft','leisure','healthcare','emergency','man_made','power','highway','railway','public_transport','landuse','historic','barrier','tourism','sport','place','waterway','natural','geological','route','military','traffic_sign','traffic_calming','seamark','route_master','water','airway','aerialway','building']::text[];

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Service\OsmDatabaseService->getAllObjectsInZone (line 106)
3	App\Service\Motocultrice->getAllObjectsInZone (line 1289)
4	App\Controller\PublicController->statsEvolutions (line 1833)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

6.08 ms
(4.76%)

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:

[
  "44026"
]

View formatted query View runnable query Explain query View query backtrace

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

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'44026'') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->fetchBoundaryWkt (line 292)
3	App\Service\ZonePolygonResolver->fetchBoundaryWktFromMeta (line 236)
4	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():100} (line 100)
5	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
6	App\Service\ZonePolygonResolver->polygonWkt (line 62)
7	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
8	App\Service\OsmDatabaseService->getAllObjectsInZone (line 90)
9	App\Service\Motocultrice->getAllObjectsInZone (line 1289)
10	App\Controller\PublicController->statsEvolutions (line 1833)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

1.93 ms
(1.51%)

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

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->postgresTableExists (line 563)
3	App\Service\ZonePolygonResolver->syncAdminLevel8RelationsFromHistory (line 495)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 97)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getAllObjectsInZone (line 90)
8	App\Service\Motocultrice->getAllObjectsInZone (line 1289)
9	App\Controller\PublicController->statsEvolutions (line 1833)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

1.84 ms
(1.44%)

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

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->syncAdminLevel8RelationsFromHistory (line 500)
3	App\Service\ZonePolygonResolver->resolvePolygon (line 97)
4	App\Service\ZonePolygonResolver->polygonWkt (line 62)
5	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
6	App\Service\OsmDatabaseService->getAllObjectsInZone (line 90)
7	App\Service\Motocultrice->getAllObjectsInZone (line 1289)
8	App\Controller\PublicController->statsEvolutions (line 1833)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.80 ms
(1.41%)

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

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = 'public'
  AND table_name = 'osm_object_meta'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\OsmDatabaseService->hasOsmObjectMetaTable (line 2375)
3	App\Service\Motocultrice->canQueryPostgisZone (line 255)
4	App\Service\Motocultrice->getAllObjectsInZone (line 1287)
5	App\Controller\PublicController->statsEvolutions (line 1833)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.74 ms
(0.58%)

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

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
  )

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
);

#	File/Call
1	App\Service\ZonePolygonResolver->syncAdminLevel8RelationsFromHistory (line 554)
2	App\Service\ZonePolygonResolver->resolvePolygon (line 97)
3	App\Service\ZonePolygonResolver->polygonWkt (line 62)
4	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
5	App\Service\OsmDatabaseService->getAllObjectsInZone (line 90)
6	App\Service\Motocultrice->getAllObjectsInZone (line 1289)
7	App\Controller\PublicController->statsEvolutions (line 1833)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.63 ms
(0.50%)

SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?

Parameters:

[
  "44026"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  ST_AsText(
    ST_Multi(geom)
  )
FROM
  zone_polygon
WHERE
  insee_code = ?

SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = '44026';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->fetchPolygonFromStore (line 422)
3	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():102} (line 102)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getAllObjectsInZone (line 90)
8	App\Service\Motocultrice->getAllObjectsInZone (line 1289)
9	App\Controller\PublicController->statsEvolutions (line 1833)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.34 ms
(0.27%)

SELECT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1

SELECT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\OsmDatabaseService->isAvailable (line 2364)
3	App\Service\Motocultrice->canQueryPostgisZone (line 254)
4	App\Service\Motocultrice->getAllObjectsInZone (line 1287)
5	App\Controller\PublicController->statsEvolutions (line 1833)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.33 ms
(0.26%)

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:

[
  "44026"
]

View formatted query View runnable query Explain query View query backtrace

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

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'44026'') = ?
      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;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->fetchBoundaryWkt (line 292)
3	App\Service\ZonePolygonResolver->fetchBoundaryWktFromHistory (line 259)
4	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():101} (line 101)
5	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
6	App\Service\ZonePolygonResolver->polygonWkt (line 62)
7	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
8	App\Service\OsmDatabaseService->getAllObjectsInZone (line 90)
9	App\Service\Motocultrice->getAllObjectsInZone (line 1289)
10	App\Controller\PublicController->statsEvolutions (line 1833)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.27 ms
(0.21%)

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

CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)

CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom);

#	File/Call
1	App\Service\ZonePolygonResolver->ensureZonePolygonTable (line 477)
2	App\Service\ZonePolygonResolver->fetchPolygonFromStore (line 417)
3	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():102} (line 102)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getAllObjectsInZone (line 90)
8	App\Service\Motocultrice->getAllObjectsInZone (line 1289)
9	App\Controller\PublicController->statsEvolutions (line 1833)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.23 ms
(0.18%)

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

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()
)

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()
                );

#	File/Call
1	App\Service\ZonePolygonResolver->ensureZonePolygonTable (line 469)
2	App\Service\ZonePolygonResolver->fetchPolygonFromStore (line 417)
3	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():102} (line 102)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getAllObjectsInZone (line 90)
8	App\Service\Motocultrice->getAllObjectsInZone (line 1289)
9	App\Controller\PublicController->statsEvolutions (line 1833)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

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	4535
App\Entity\Stats	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.

Symfony Profiler

GET https://osm-commerces.cipherbliss.com/stats/44026/evolutions

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

osm connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping