Symfony Profiler

Query Metrics

15 Database Queries

13 Different statements

21.91 ms Query time

0 Invalid entities

4536 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

8.16 ms
(37.23%)

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:

[
  26702
]

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

#	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->zonePlacesHistory (line 2424)
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.40 ms
(1.84%)

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:

[
  "01371"
]

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 = '01371' 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->zonePlacesHistory (line 2301)
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

5.26 ms
(24.01%)

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:

[
  "01371"
]

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'01371'') = ?
  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\OsmHistoryDatabaseService->requirePolygonWkt (line 711)
8	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 603)
9	App\Controller\PublicController->zonePlacesHistory (line 2335)
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.86 ms
(8.48%)

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

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_history'

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

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\OsmHistoryDatabaseService->hasHistoryTable (line 60)
3	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 600)
4	App\Controller\PublicController->zonePlacesHistory (line 2335)
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)

1.75 ms
(8.00%)

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\OsmHistoryDatabaseService->requirePolygonWkt (line 711)
7	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 603)
8	App\Controller\PublicController->zonePlacesHistory (line 2335)
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.47 ms
(6.72%)

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\OsmHistoryDatabaseService->requirePolygonWkt (line 711)
6	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 603)
7	App\Controller\PublicController->zonePlacesHistory (line 2335)
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.74 ms
(3.37%)

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\OsmHistoryDatabaseService->requirePolygonWkt (line 711)
5	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 603)
6	App\Controller\PublicController->zonePlacesHistory (line 2335)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.61 ms
(2.77%)

WITH zone AS (SELECT ST_GeomFromText(?, 4326) AS g),
in_zone_prev AS (
  SELECT h.osm_type, h.osm_id, h.version, h.tags::jsonb AS tags_json
  FROM osm_object_history h, zone z
  WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, z.g)
)
SELECT del.osm_type, del.osm_id::text AS osm_id, del.version,
       prev.tags_json AS tags_json,
       del.valid_from AS osm_timestamp,
       del.changeset, del.osm_user, del.uid::bigint AS uid
FROM osm_object_history del
JOIN in_zone_prev prev
  ON prev.osm_type = del.osm_type
 AND prev.osm_id   = del.osm_id
 AND prev.version  = del.version - 1
WHERE del.visible = false
  AND del.valid_from >= ?::timestamptz
ORDER BY del.valid_from DESC
LIMIT ?

Parameters:

[
  "MULTIPOLYGON(((5.011563 45.934686,5.0109 45.934745,5.010423 45.934765,5.009173 45.934644,5.008964 45.934528,5.008774 45.934008,5.008392 45.932421,5.008057 45.932105,5.007709 45.931921,5.00749 45.931544,5.007111 45.930955,5.006509 45.930206,5.005411 45.928198,5.001036 45.927798,5.000761 45.927827,5.000476 45.927907,4.99939 45.928244,4.998635 45.928647,4.998316 45.928791,4.997991 45.928885,4.996954 45.929349,4.996636 45.929472,4.995882 45.92973,4.995213 45.92991,4.994773 45.930072,4.993995 45.930396,4.993406 45.930673,4.992982 45.930832,4.992744 45.931017,4.991999 45.931505,4.991745 45.931622,4.991053 45.931787,4.990623 45.93186,4.989906 45.932003,4.988497 45.93244,4.987958 45.932532,4.986855 45.93279,4.986305 45.932882,4.985762 45.932996,4.98568 45.93303,4.985093 45.934455,4.983605 45.93438,4.982995 45.93433,4.98258 45.93431,4.982127 45.934358,4.981946 45.934435,4.980878 45.935092,4.980223 45.935483,4.979404 45.935801,4.97866 45.936073,4.977517 45.936455,4.976438 45.936826,4.975496 45.937228,4.975199 45.937405,4.974553 45.937689,4.973963 45.937992,4.973846 45.938008,4.973426 45.937925,4.9732 45.937925,4.972756 45.938107,4.972632 45.938198,4.971956 45.938779,4.971647 45.939026,4.971297 45.939233,4.970361 45.939655,4.970075 45.939822,4.96948 45.940097,4.968186 45.940843,4.968193 45.941179,4.968152 45.941352,4.967922 45.941532,4.967527 45.941783,4.967167 45.942054,4.966187 45.942668,4.964693 45.943524,4.964441 45.943696,4.963808 45.944248,4.963205 45.944954,4.962876 45.945229,4.962409 45.945422,4.961903 45.945717,4.961272 45.946104,4.960623 45.946875,4.960969 45.947076,4.961329 45.947465,4.961439 45.947476,4.961432 45.947597,4.961778 45.94812,4.961833 45.948253,4.961904 45.948603,4.961843 45.948734,4.965777 45.95045,4.96652 45.950985,4.968362 45.954035,4.970433 45.957981,4.97053 45.958025,4.970976 45.958086,4.971701 45.958226,4.972708 45.958466,4.97312 45.958538,4.973401 45.958559,4.973988 45.958546,4.974499 45.958572,4.97484 45.95864,4.974774 45.961533,4.974898 45.962029,4.975136 45.962397,4.975111 45.962743,4.975167 45.962983,4.9754 45.963503,4.975611 45.964066,4.974175 45.965643,4.97418 45.965958,4.974496 45.966328,4.973805 45.969089,4.974995 45.96913,4.975433 45.968624,4.976421 45.968543,4.977138 45.968685,4.978116 45.968756,4.982812 45.968801,4.993338 45.965606,4.994035 45.96518,4.995077 45.964813,4.995369 45.964643,4.9966 45.964032,5.0012 45.962186,5.00149 45.962056,5.001714 45.962044,5.003066 45.962041,5.003299 45.962005,5.004841 45.962327,5.004794 45.961671,5.005413 45.961622,5.006347 45.96159,5.00667 45.961611,5.007946 45.961758,5.008202 45.961773,5.008799 45.961765,5.008019 45.958314,5.00938 45.957354,5.009517 45.956224,5.008818 45.955768,5.008729 45.95496,5.00928 45.954664,5.010291 45.95367,5.011136 45.9533,5.010761 45.951718,5.011152 45.950577,5.011198 45.950406,5.010722 45.946826,5.009828 45.943932,5.011223 45.938952,5.011782 45.9369,5.011628 45.935518,5.011563 45.934686)))"
  "2026-01-14 16:39:06+00:00"
  20001
]

View formatted query View runnable query Explain query View query backtrace

WITH
  zone AS (
    SELECT
      ST_GeomFromText(?, 4326) AS g
  ),
  in_zone_prev AS (
    SELECT
      h.osm_type,
      h.osm_id,
      h.version,
      h.tags :: jsonb AS tags_json
    FROM
      osm_object_history h,
      zone z
    WHERE
      h.geom IS NOT NULL
      AND ST_Intersects(h.geom, z.g)
  )
SELECT
  del.osm_type,
  del.osm_id :: text AS osm_id,
  del.version,
  prev.tags_json AS tags_json,
  del.valid_from AS osm_timestamp,
  del.changeset,
  del.osm_user,
  del.uid :: bigint AS uid
FROM
  osm_object_history del
  JOIN in_zone_prev prev ON prev.osm_type = del.osm_type
  AND prev.osm_id = del.osm_id
  AND prev.version = del.version - 1
WHERE
  del.visible = false
  AND del.valid_from >= ? :: timestamptz
ORDER BY
  del.valid_from DESC
LIMIT
  ?

WITH zone AS (SELECT ST_GeomFromText('MULTIPOLYGON(((5.011563 45.934686,5.0109 45.934745,5.010423 45.934765,5.009173 45.934644,5.008964 45.934528,5.008774 45.934008,5.008392 45.932421,5.008057 45.932105,5.007709 45.931921,5.00749 45.931544,5.007111 45.930955,5.006509 45.930206,5.005411 45.928198,5.001036 45.927798,5.000761 45.927827,5.000476 45.927907,4.99939 45.928244,4.998635 45.928647,4.998316 45.928791,4.997991 45.928885,4.996954 45.929349,4.996636 45.929472,4.995882 45.92973,4.995213 45.92991,4.994773 45.930072,4.993995 45.930396,4.993406 45.930673,4.992982 45.930832,4.992744 45.931017,4.991999 45.931505,4.991745 45.931622,4.991053 45.931787,4.990623 45.93186,4.989906 45.932003,4.988497 45.93244,4.987958 45.932532,4.986855 45.93279,4.986305 45.932882,4.985762 45.932996,4.98568 45.93303,4.985093 45.934455,4.983605 45.93438,4.982995 45.93433,4.98258 45.93431,4.982127 45.934358,4.981946 45.934435,4.980878 45.935092,4.980223 45.935483,4.979404 45.935801,4.97866 45.936073,4.977517 45.936455,4.976438 45.936826,4.975496 45.937228,4.975199 45.937405,4.974553 45.937689,4.973963 45.937992,4.973846 45.938008,4.973426 45.937925,4.9732 45.937925,4.972756 45.938107,4.972632 45.938198,4.971956 45.938779,4.971647 45.939026,4.971297 45.939233,4.970361 45.939655,4.970075 45.939822,4.96948 45.940097,4.968186 45.940843,4.968193 45.941179,4.968152 45.941352,4.967922 45.941532,4.967527 45.941783,4.967167 45.942054,4.966187 45.942668,4.964693 45.943524,4.964441 45.943696,4.963808 45.944248,4.963205 45.944954,4.962876 45.945229,4.962409 45.945422,4.961903 45.945717,4.961272 45.946104,4.960623 45.946875,4.960969 45.947076,4.961329 45.947465,4.961439 45.947476,4.961432 45.947597,4.961778 45.94812,4.961833 45.948253,4.961904 45.948603,4.961843 45.948734,4.965777 45.95045,4.96652 45.950985,4.968362 45.954035,4.970433 45.957981,4.97053 45.958025,4.970976 45.958086,4.971701 45.958226,4.972708 45.958466,4.97312 45.958538,4.973401 45.958559,4.973988 45.958546,4.974499 45.958572,4.97484 45.95864,4.974774 45.961533,4.974898 45.962029,4.975136 45.962397,4.975111 45.962743,4.975167 45.962983,4.9754 45.963503,4.975611 45.964066,4.974175 45.965643,4.97418 45.965958,4.974496 45.966328,4.973805 45.969089,4.974995 45.96913,4.975433 45.968624,4.976421 45.968543,4.977138 45.968685,4.978116 45.968756,4.982812 45.968801,4.993338 45.965606,4.994035 45.96518,4.995077 45.964813,4.995369 45.964643,4.9966 45.964032,5.0012 45.962186,5.00149 45.962056,5.001714 45.962044,5.003066 45.962041,5.003299 45.962005,5.004841 45.962327,5.004794 45.961671,5.005413 45.961622,5.006347 45.96159,5.00667 45.961611,5.007946 45.961758,5.008202 45.961773,5.008799 45.961765,5.008019 45.958314,5.00938 45.957354,5.009517 45.956224,5.008818 45.955768,5.008729 45.95496,5.00928 45.954664,5.010291 45.95367,5.011136 45.9533,5.010761 45.951718,5.011152 45.950577,5.011198 45.950406,5.010722 45.946826,5.009828 45.943932,5.011223 45.938952,5.011782 45.9369,5.011628 45.935518,5.011563 45.934686)))', 4326) AS g),
in_zone_prev AS (
  SELECT h.osm_type, h.osm_id, h.version, h.tags::jsonb AS tags_json
  FROM osm_object_history h, zone z
  WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, z.g)
)
SELECT del.osm_type, del.osm_id::text AS osm_id, del.version,
       prev.tags_json AS tags_json,
       del.valid_from AS osm_timestamp,
       del.changeset, del.osm_user, del.uid::bigint AS uid
FROM osm_object_history del
JOIN in_zone_prev prev
  ON prev.osm_type = del.osm_type
 AND prev.osm_id   = del.osm_id
 AND prev.version  = del.version - 1
WHERE del.visible = false
  AND del.valid_from >= '2026-01-14 16:39:06+00:00'::timestamptz
ORDER BY del.valid_from DESC
LIMIT 20001;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 673)
3	App\Controller\PublicController->zonePlacesHistory (line 2335)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.49 ms
(2.24%)

SELECT h.osm_type, h.osm_id::text AS osm_id, h.version,
       h.tags::jsonb AS tags_json,
       h.valid_from AS osm_timestamp,
       h.changeset, h.osm_user, h.uid::bigint AS uid
FROM osm_object_history h
WHERE h.visible = true
  AND h.geom IS NOT NULL
  AND ST_Intersects(h.geom, ST_GeomFromText(?, 4326))
  AND h.valid_from >= ?::timestamptz
ORDER BY h.valid_from DESC
LIMIT ?

Parameters:

[
  "MULTIPOLYGON(((5.011563 45.934686,5.0109 45.934745,5.010423 45.934765,5.009173 45.934644,5.008964 45.934528,5.008774 45.934008,5.008392 45.932421,5.008057 45.932105,5.007709 45.931921,5.00749 45.931544,5.007111 45.930955,5.006509 45.930206,5.005411 45.928198,5.001036 45.927798,5.000761 45.927827,5.000476 45.927907,4.99939 45.928244,4.998635 45.928647,4.998316 45.928791,4.997991 45.928885,4.996954 45.929349,4.996636 45.929472,4.995882 45.92973,4.995213 45.92991,4.994773 45.930072,4.993995 45.930396,4.993406 45.930673,4.992982 45.930832,4.992744 45.931017,4.991999 45.931505,4.991745 45.931622,4.991053 45.931787,4.990623 45.93186,4.989906 45.932003,4.988497 45.93244,4.987958 45.932532,4.986855 45.93279,4.986305 45.932882,4.985762 45.932996,4.98568 45.93303,4.985093 45.934455,4.983605 45.93438,4.982995 45.93433,4.98258 45.93431,4.982127 45.934358,4.981946 45.934435,4.980878 45.935092,4.980223 45.935483,4.979404 45.935801,4.97866 45.936073,4.977517 45.936455,4.976438 45.936826,4.975496 45.937228,4.975199 45.937405,4.974553 45.937689,4.973963 45.937992,4.973846 45.938008,4.973426 45.937925,4.9732 45.937925,4.972756 45.938107,4.972632 45.938198,4.971956 45.938779,4.971647 45.939026,4.971297 45.939233,4.970361 45.939655,4.970075 45.939822,4.96948 45.940097,4.968186 45.940843,4.968193 45.941179,4.968152 45.941352,4.967922 45.941532,4.967527 45.941783,4.967167 45.942054,4.966187 45.942668,4.964693 45.943524,4.964441 45.943696,4.963808 45.944248,4.963205 45.944954,4.962876 45.945229,4.962409 45.945422,4.961903 45.945717,4.961272 45.946104,4.960623 45.946875,4.960969 45.947076,4.961329 45.947465,4.961439 45.947476,4.961432 45.947597,4.961778 45.94812,4.961833 45.948253,4.961904 45.948603,4.961843 45.948734,4.965777 45.95045,4.96652 45.950985,4.968362 45.954035,4.970433 45.957981,4.97053 45.958025,4.970976 45.958086,4.971701 45.958226,4.972708 45.958466,4.97312 45.958538,4.973401 45.958559,4.973988 45.958546,4.974499 45.958572,4.97484 45.95864,4.974774 45.961533,4.974898 45.962029,4.975136 45.962397,4.975111 45.962743,4.975167 45.962983,4.9754 45.963503,4.975611 45.964066,4.974175 45.965643,4.97418 45.965958,4.974496 45.966328,4.973805 45.969089,4.974995 45.96913,4.975433 45.968624,4.976421 45.968543,4.977138 45.968685,4.978116 45.968756,4.982812 45.968801,4.993338 45.965606,4.994035 45.96518,4.995077 45.964813,4.995369 45.964643,4.9966 45.964032,5.0012 45.962186,5.00149 45.962056,5.001714 45.962044,5.003066 45.962041,5.003299 45.962005,5.004841 45.962327,5.004794 45.961671,5.005413 45.961622,5.006347 45.96159,5.00667 45.961611,5.007946 45.961758,5.008202 45.961773,5.008799 45.961765,5.008019 45.958314,5.00938 45.957354,5.009517 45.956224,5.008818 45.955768,5.008729 45.95496,5.00928 45.954664,5.010291 45.95367,5.011136 45.9533,5.010761 45.951718,5.011152 45.950577,5.011198 45.950406,5.010722 45.946826,5.009828 45.943932,5.011223 45.938952,5.011782 45.9369,5.011628 45.935518,5.011563 45.934686)))"
  "2026-01-14 16:39:06+00:00"
  20001
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h.osm_type,
  h.osm_id :: text AS osm_id,
  h.version,
  h.tags :: jsonb AS tags_json,
  h.valid_from AS osm_timestamp,
  h.changeset,
  h.osm_user,
  h.uid :: bigint AS uid
FROM
  osm_object_history h
WHERE
  h.visible = true
  AND h.geom IS NOT NULL
  AND ST_Intersects(
    h.geom,
    ST_GeomFromText(?, 4326)
  )
  AND h.valid_from >= ? :: timestamptz
ORDER BY
  h.valid_from DESC
LIMIT
  ?

SELECT h.osm_type, h.osm_id::text AS osm_id, h.version,
       h.tags::jsonb AS tags_json,
       h.valid_from AS osm_timestamp,
       h.changeset, h.osm_user, h.uid::bigint AS uid
FROM osm_object_history h
WHERE h.visible = true
  AND h.geom IS NOT NULL
  AND ST_Intersects(h.geom, ST_GeomFromText('MULTIPOLYGON(((5.011563 45.934686,5.0109 45.934745,5.010423 45.934765,5.009173 45.934644,5.008964 45.934528,5.008774 45.934008,5.008392 45.932421,5.008057 45.932105,5.007709 45.931921,5.00749 45.931544,5.007111 45.930955,5.006509 45.930206,5.005411 45.928198,5.001036 45.927798,5.000761 45.927827,5.000476 45.927907,4.99939 45.928244,4.998635 45.928647,4.998316 45.928791,4.997991 45.928885,4.996954 45.929349,4.996636 45.929472,4.995882 45.92973,4.995213 45.92991,4.994773 45.930072,4.993995 45.930396,4.993406 45.930673,4.992982 45.930832,4.992744 45.931017,4.991999 45.931505,4.991745 45.931622,4.991053 45.931787,4.990623 45.93186,4.989906 45.932003,4.988497 45.93244,4.987958 45.932532,4.986855 45.93279,4.986305 45.932882,4.985762 45.932996,4.98568 45.93303,4.985093 45.934455,4.983605 45.93438,4.982995 45.93433,4.98258 45.93431,4.982127 45.934358,4.981946 45.934435,4.980878 45.935092,4.980223 45.935483,4.979404 45.935801,4.97866 45.936073,4.977517 45.936455,4.976438 45.936826,4.975496 45.937228,4.975199 45.937405,4.974553 45.937689,4.973963 45.937992,4.973846 45.938008,4.973426 45.937925,4.9732 45.937925,4.972756 45.938107,4.972632 45.938198,4.971956 45.938779,4.971647 45.939026,4.971297 45.939233,4.970361 45.939655,4.970075 45.939822,4.96948 45.940097,4.968186 45.940843,4.968193 45.941179,4.968152 45.941352,4.967922 45.941532,4.967527 45.941783,4.967167 45.942054,4.966187 45.942668,4.964693 45.943524,4.964441 45.943696,4.963808 45.944248,4.963205 45.944954,4.962876 45.945229,4.962409 45.945422,4.961903 45.945717,4.961272 45.946104,4.960623 45.946875,4.960969 45.947076,4.961329 45.947465,4.961439 45.947476,4.961432 45.947597,4.961778 45.94812,4.961833 45.948253,4.961904 45.948603,4.961843 45.948734,4.965777 45.95045,4.96652 45.950985,4.968362 45.954035,4.970433 45.957981,4.97053 45.958025,4.970976 45.958086,4.971701 45.958226,4.972708 45.958466,4.97312 45.958538,4.973401 45.958559,4.973988 45.958546,4.974499 45.958572,4.97484 45.95864,4.974774 45.961533,4.974898 45.962029,4.975136 45.962397,4.975111 45.962743,4.975167 45.962983,4.9754 45.963503,4.975611 45.964066,4.974175 45.965643,4.97418 45.965958,4.974496 45.966328,4.973805 45.969089,4.974995 45.96913,4.975433 45.968624,4.976421 45.968543,4.977138 45.968685,4.978116 45.968756,4.982812 45.968801,4.993338 45.965606,4.994035 45.96518,4.995077 45.964813,4.995369 45.964643,4.9966 45.964032,5.0012 45.962186,5.00149 45.962056,5.001714 45.962044,5.003066 45.962041,5.003299 45.962005,5.004841 45.962327,5.004794 45.961671,5.005413 45.961622,5.006347 45.96159,5.00667 45.961611,5.007946 45.961758,5.008202 45.961773,5.008799 45.961765,5.008019 45.958314,5.00938 45.957354,5.009517 45.956224,5.008818 45.955768,5.008729 45.95496,5.00928 45.954664,5.010291 45.95367,5.011136 45.9533,5.010761 45.951718,5.011152 45.950577,5.011198 45.950406,5.010722 45.946826,5.009828 45.943932,5.011223 45.938952,5.011782 45.9369,5.011628 45.935518,5.011563 45.934686)))', 4326))
  AND h.valid_from >= '2026-01-14 16:39:06+00:00'::timestamptz
ORDER BY h.valid_from DESC
LIMIT 20001;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 630)
3	App\Controller\PublicController->zonePlacesHistory (line 2335)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.39 ms
(1.78%)

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

Parameters:

[
  "01371"
]

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 = '01371';

#	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\OsmHistoryDatabaseService->requirePolygonWkt (line 711)
7	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 603)
8	App\Controller\PublicController->zonePlacesHistory (line 2335)
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)

0.32 ms
(1.47%)

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:

[
  "01371"
]

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'01371'') = ?
      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\OsmHistoryDatabaseService->requirePolygonWkt (line 711)
8	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 603)
9	App\Controller\PublicController->zonePlacesHistory (line 2335)
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.27 ms
(1.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\OsmHistoryDatabaseService->requirePolygonWkt (line 711)
7	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 603)
8	App\Controller\PublicController->zonePlacesHistory (line 2335)
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)

0.19 ms
(0.87%)

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\OsmHistoryDatabaseService->requirePolygonWkt (line 711)
7	App\Service\OsmHistoryDatabaseService->getZoneChangesByDay (line 603)
8	App\Controller\PublicController->zonePlacesHistory (line 2335)
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)

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-labo.cipherbliss.com/city/01371/zone-places-history?period=6m

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