Symfony Profiler

Query Metrics

15 Database Queries

13 Different statements

39.40 ms Query time

0 Invalid entities

4158 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

16.56 ms
(42.04%)

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:

[
  26025
]

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

#	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.44 ms
(1.12%)

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:

[
  "38416"
]

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 = '38416' 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

8.92 ms
(22.64%)

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:

[
  "38416"
]

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

3.27 ms
(8.29%)

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)

2.65 ms
(6.74%)

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)

2.52 ms
(6.38%)

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)

1.32 ms
(3.34%)

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)

1.09 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.304785 45.157875,5.305181 45.15871,5.305269 45.159045,5.305431 45.159484,5.305845 45.160083,5.305988 45.1602,5.306605 45.160565,5.306839 45.160937,5.307093 45.161561,5.307128 45.161873,5.307142 45.162676,5.307226 45.16296,5.307569 45.163948,5.307814 45.164562,5.307932 45.164771,5.30805 45.165066,5.308244 45.165761,5.308298 45.166008,5.308196 45.166239,5.308167 45.166422,5.308058 45.166623,5.308073 45.16689,5.30814 45.167394,5.308156 45.167688,5.308136 45.168069,5.308186 45.168645,5.308123 45.168942,5.308158 45.169221,5.308231 45.169487,5.308127 45.169772,5.308294 45.169906,5.308362 45.170271,5.307971 45.170654,5.307545 45.17115,5.307167 45.171631,5.30703 45.171841,5.306723 45.172393,5.306372 45.17298,5.306305 45.173166,5.306312 45.173376,5.306468 45.174041,5.306754 45.175066,5.30701 45.175147,5.307225 45.175315,5.307978 45.176056,5.308636 45.176657,5.308844 45.176948,5.309247 45.177647,5.309694 45.178158,5.309892 45.178605,5.310174 45.179168,5.310429 45.179756,5.310606 45.179983,5.310893 45.180226,5.311288 45.180614,5.311744 45.180693,5.312543 45.180759,5.3134 45.180733,5.313989 45.180745,5.314359 45.180786,5.314703 45.180866,5.314925 45.180796,5.315335 45.180812,5.315945 45.180772,5.316203 45.180733,5.317044 45.180549,5.317125 45.180543,5.317145 45.180408,5.317133 45.180056,5.317152 45.179254,5.317145 45.17835,5.316923 45.177578,5.316837 45.177158,5.316863 45.176392,5.316873 45.175404,5.31691 45.174945,5.317056 45.17469,5.31739 45.174456,5.317616 45.174254,5.317724 45.173982,5.31766 45.173592,5.317679 45.17336,5.317825 45.173103,5.318436 45.172546,5.31869 45.172266,5.318915 45.171931,5.318855 45.171777,5.318874 45.171578,5.319095 45.171246,5.319702 45.170633,5.319876 45.170376,5.320029 45.170054,5.320085 45.169872,5.320238 45.169198,5.320418 45.169004,5.320648 45.168702,5.321036 45.16838,5.321348 45.167774,5.321529 45.167496,5.321548 45.167345,5.322374 45.16701,5.322622 45.166868,5.323416 45.16578,5.323437 45.165306,5.323427 45.164305,5.323666 45.163806,5.324154 45.163849,5.324418 45.163909,5.324958 45.16414,5.325303 45.164411,5.325459 45.164694,5.325539 45.164756,5.326105 45.164614,5.328181 45.164054,5.328477 45.163967,5.328828 45.16383,5.329211 45.163764,5.329444 45.163673,5.330212 45.163512,5.331148 45.163177,5.331261 45.163062,5.330771 45.162821,5.330602 45.162657,5.330505 45.162322,5.330335 45.162044,5.330291 45.161881,5.330103 45.161659,5.329886 45.16149,5.329604 45.161331,5.329103 45.161084,5.328895 45.160954,5.328583 45.160602,5.328072 45.159969,5.328013 45.159618,5.327926 45.15948,5.327406 45.159058,5.327129 45.158686,5.327123 45.158221,5.326991 45.157464,5.326749 45.157186,5.326005 45.156707,5.325508 45.156327,5.32543 45.156231,5.325375 45.156049,5.325407 45.155931,5.325553 45.155805,5.325806 45.15548,5.32599 45.15529,5.326255 45.154964,5.326398 45.154696,5.326398 45.154468,5.32628 45.154239,5.326128 45.154075,5.32583 45.153953,5.325436 45.153649,5.325233 45.153251,5.325139 45.152863,5.325214 45.152734,5.32519 45.152437,5.325272 45.152292,5.325275 45.152153,5.325393 45.151866,5.325595 45.151676,5.326121 45.151135,5.326388 45.150884,5.326598 45.150769,5.326787 45.150708,5.327067 45.15056,5.327186 45.150411,5.327183 45.150283,5.327063 45.15015,5.326953 45.149923,5.327098 45.149861,5.327133 45.149749,5.327084 45.149569,5.327388 45.149309,5.327437 45.14917,5.327409 45.148958,5.327909 45.148398,5.327995 45.148165,5.328272 45.147869,5.328342 45.147386,5.328533 45.146997,5.328673 45.146867,5.328847 45.146644,5.328953 45.146383,5.328962 45.14622,5.329068 45.146002,5.329338 45.145723,5.329491 45.145478,5.329442 45.145312,5.32935 45.145209,5.329229 45.144882,5.329137 45.144706,5.329088 45.144336,5.329266 45.144264,5.329686 45.144025,5.329831 45.143849,5.330025 45.143769,5.330335 45.143566,5.330718 45.143255,5.330892 45.14309,5.330921 45.14296,5.330821 45.142729,5.330803 45.142546,5.330877 45.142403,5.330864 45.142308,5.331007 45.142164,5.331151 45.14195,5.331232 45.141756,5.331546 45.141351,5.331845 45.140865,5.332022 45.140525,5.332058 45.14037,5.33202 45.139981,5.332036 45.139804,5.332125 45.139545,5.332072 45.137852,5.331961 45.13757,5.331895 45.137481,5.331719 45.137421,5.331588 45.137304,5.331179 45.137038,5.330894 45.136759,5.330691 45.136683,5.330482 45.136651,5.330335 45.136679,5.32998 45.136691,5.329591 45.136582,5.329316 45.136429,5.328938 45.136046,5.328723 45.135927,5.328399 45.135708,5.328292 45.135601,5.327872 45.13526,5.327786 45.135168,5.327541 45.135078,5.32705 45.134713,5.326852 45.134486,5.326823 45.13427,5.327018 45.133685,5.327044 45.133493,5.327148 45.133241,5.32712 45.133025,5.326906 45.132645,5.3267 45.132333,5.326294 45.131597,5.326239 45.131393,5.326316 45.131273,5.32634 45.131129,5.326191 45.131021,5.326035 45.130827,5.325851 45.130185,5.325721 45.129919,5.325654 45.1296,5.325719 45.129413,5.325605 45.129201,5.325782 45.128805,5.325995 45.128447,5.326105 45.128185,5.326036 45.128052,5.325832 45.127911,5.325576 45.127511,5.325441 45.127443,5.324888 45.127331,5.324698 45.127189,5.324613 45.127043,5.324573 45.126862,5.324553 45.126542,5.324474 45.126404,5.324235 45.126115,5.324124 45.126069,5.323649 45.125997,5.323274 45.125896,5.323139 45.125803,5.322969 45.125523,5.322921 45.125394,5.322791 45.125243,5.322659 45.12491,5.322777 45.124564,5.322775 45.124391,5.322608 45.124514,5.320375 45.126682,5.31936 45.127924,5.317217 45.131924,5.31625 45.132638,5.314865 45.134697,5.314399 45.135475,5.313997 45.136934,5.313419 45.137391,5.31255 45.138032,5.312042 45.138468,5.311806 45.138691,5.309629 45.142528,5.308219 45.144792,5.307241 45.146325,5.306686 45.147226,5.306095 45.147722,5.303862 45.149576,5.304145 45.149774,5.304369 45.149894,5.303619 45.150811,5.302793 45.151809,5.301123 45.153875,5.301439 45.155737,5.302792 45.156604,5.303229 45.156921,5.303595 45.157142,5.303892 45.157269,5.304271 45.157482,5.304785 45.157875)))"
  "2025-07-15 05:20:16+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.304785 45.157875,5.305181 45.15871,5.305269 45.159045,5.305431 45.159484,5.305845 45.160083,5.305988 45.1602,5.306605 45.160565,5.306839 45.160937,5.307093 45.161561,5.307128 45.161873,5.307142 45.162676,5.307226 45.16296,5.307569 45.163948,5.307814 45.164562,5.307932 45.164771,5.30805 45.165066,5.308244 45.165761,5.308298 45.166008,5.308196 45.166239,5.308167 45.166422,5.308058 45.166623,5.308073 45.16689,5.30814 45.167394,5.308156 45.167688,5.308136 45.168069,5.308186 45.168645,5.308123 45.168942,5.308158 45.169221,5.308231 45.169487,5.308127 45.169772,5.308294 45.169906,5.308362 45.170271,5.307971 45.170654,5.307545 45.17115,5.307167 45.171631,5.30703 45.171841,5.306723 45.172393,5.306372 45.17298,5.306305 45.173166,5.306312 45.173376,5.306468 45.174041,5.306754 45.175066,5.30701 45.175147,5.307225 45.175315,5.307978 45.176056,5.308636 45.176657,5.308844 45.176948,5.309247 45.177647,5.309694 45.178158,5.309892 45.178605,5.310174 45.179168,5.310429 45.179756,5.310606 45.179983,5.310893 45.180226,5.311288 45.180614,5.311744 45.180693,5.312543 45.180759,5.3134 45.180733,5.313989 45.180745,5.314359 45.180786,5.314703 45.180866,5.314925 45.180796,5.315335 45.180812,5.315945 45.180772,5.316203 45.180733,5.317044 45.180549,5.317125 45.180543,5.317145 45.180408,5.317133 45.180056,5.317152 45.179254,5.317145 45.17835,5.316923 45.177578,5.316837 45.177158,5.316863 45.176392,5.316873 45.175404,5.31691 45.174945,5.317056 45.17469,5.31739 45.174456,5.317616 45.174254,5.317724 45.173982,5.31766 45.173592,5.317679 45.17336,5.317825 45.173103,5.318436 45.172546,5.31869 45.172266,5.318915 45.171931,5.318855 45.171777,5.318874 45.171578,5.319095 45.171246,5.319702 45.170633,5.319876 45.170376,5.320029 45.170054,5.320085 45.169872,5.320238 45.169198,5.320418 45.169004,5.320648 45.168702,5.321036 45.16838,5.321348 45.167774,5.321529 45.167496,5.321548 45.167345,5.322374 45.16701,5.322622 45.166868,5.323416 45.16578,5.323437 45.165306,5.323427 45.164305,5.323666 45.163806,5.324154 45.163849,5.324418 45.163909,5.324958 45.16414,5.325303 45.164411,5.325459 45.164694,5.325539 45.164756,5.326105 45.164614,5.328181 45.164054,5.328477 45.163967,5.328828 45.16383,5.329211 45.163764,5.329444 45.163673,5.330212 45.163512,5.331148 45.163177,5.331261 45.163062,5.330771 45.162821,5.330602 45.162657,5.330505 45.162322,5.330335 45.162044,5.330291 45.161881,5.330103 45.161659,5.329886 45.16149,5.329604 45.161331,5.329103 45.161084,5.328895 45.160954,5.328583 45.160602,5.328072 45.159969,5.328013 45.159618,5.327926 45.15948,5.327406 45.159058,5.327129 45.158686,5.327123 45.158221,5.326991 45.157464,5.326749 45.157186,5.326005 45.156707,5.325508 45.156327,5.32543 45.156231,5.325375 45.156049,5.325407 45.155931,5.325553 45.155805,5.325806 45.15548,5.32599 45.15529,5.326255 45.154964,5.326398 45.154696,5.326398 45.154468,5.32628 45.154239,5.326128 45.154075,5.32583 45.153953,5.325436 45.153649,5.325233 45.153251,5.325139 45.152863,5.325214 45.152734,5.32519 45.152437,5.325272 45.152292,5.325275 45.152153,5.325393 45.151866,5.325595 45.151676,5.326121 45.151135,5.326388 45.150884,5.326598 45.150769,5.326787 45.150708,5.327067 45.15056,5.327186 45.150411,5.327183 45.150283,5.327063 45.15015,5.326953 45.149923,5.327098 45.149861,5.327133 45.149749,5.327084 45.149569,5.327388 45.149309,5.327437 45.14917,5.327409 45.148958,5.327909 45.148398,5.327995 45.148165,5.328272 45.147869,5.328342 45.147386,5.328533 45.146997,5.328673 45.146867,5.328847 45.146644,5.328953 45.146383,5.328962 45.14622,5.329068 45.146002,5.329338 45.145723,5.329491 45.145478,5.329442 45.145312,5.32935 45.145209,5.329229 45.144882,5.329137 45.144706,5.329088 45.144336,5.329266 45.144264,5.329686 45.144025,5.329831 45.143849,5.330025 45.143769,5.330335 45.143566,5.330718 45.143255,5.330892 45.14309,5.330921 45.14296,5.330821 45.142729,5.330803 45.142546,5.330877 45.142403,5.330864 45.142308,5.331007 45.142164,5.331151 45.14195,5.331232 45.141756,5.331546 45.141351,5.331845 45.140865,5.332022 45.140525,5.332058 45.14037,5.33202 45.139981,5.332036 45.139804,5.332125 45.139545,5.332072 45.137852,5.331961 45.13757,5.331895 45.137481,5.331719 45.137421,5.331588 45.137304,5.331179 45.137038,5.330894 45.136759,5.330691 45.136683,5.330482 45.136651,5.330335 45.136679,5.32998 45.136691,5.329591 45.136582,5.329316 45.136429,5.328938 45.136046,5.328723 45.135927,5.328399 45.135708,5.328292 45.135601,5.327872 45.13526,5.327786 45.135168,5.327541 45.135078,5.32705 45.134713,5.326852 45.134486,5.326823 45.13427,5.327018 45.133685,5.327044 45.133493,5.327148 45.133241,5.32712 45.133025,5.326906 45.132645,5.3267 45.132333,5.326294 45.131597,5.326239 45.131393,5.326316 45.131273,5.32634 45.131129,5.326191 45.131021,5.326035 45.130827,5.325851 45.130185,5.325721 45.129919,5.325654 45.1296,5.325719 45.129413,5.325605 45.129201,5.325782 45.128805,5.325995 45.128447,5.326105 45.128185,5.326036 45.128052,5.325832 45.127911,5.325576 45.127511,5.325441 45.127443,5.324888 45.127331,5.324698 45.127189,5.324613 45.127043,5.324573 45.126862,5.324553 45.126542,5.324474 45.126404,5.324235 45.126115,5.324124 45.126069,5.323649 45.125997,5.323274 45.125896,5.323139 45.125803,5.322969 45.125523,5.322921 45.125394,5.322791 45.125243,5.322659 45.12491,5.322777 45.124564,5.322775 45.124391,5.322608 45.124514,5.320375 45.126682,5.31936 45.127924,5.317217 45.131924,5.31625 45.132638,5.314865 45.134697,5.314399 45.135475,5.313997 45.136934,5.313419 45.137391,5.31255 45.138032,5.312042 45.138468,5.311806 45.138691,5.309629 45.142528,5.308219 45.144792,5.307241 45.146325,5.306686 45.147226,5.306095 45.147722,5.303862 45.149576,5.304145 45.149774,5.304369 45.149894,5.303619 45.150811,5.302793 45.151809,5.301123 45.153875,5.301439 45.155737,5.302792 45.156604,5.303229 45.156921,5.303595 45.157142,5.303892 45.157269,5.304271 45.157482,5.304785 45.157875)))', 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 >= '2025-07-15 05:20:16+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.95 ms
(2.42%)

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.304785 45.157875,5.305181 45.15871,5.305269 45.159045,5.305431 45.159484,5.305845 45.160083,5.305988 45.1602,5.306605 45.160565,5.306839 45.160937,5.307093 45.161561,5.307128 45.161873,5.307142 45.162676,5.307226 45.16296,5.307569 45.163948,5.307814 45.164562,5.307932 45.164771,5.30805 45.165066,5.308244 45.165761,5.308298 45.166008,5.308196 45.166239,5.308167 45.166422,5.308058 45.166623,5.308073 45.16689,5.30814 45.167394,5.308156 45.167688,5.308136 45.168069,5.308186 45.168645,5.308123 45.168942,5.308158 45.169221,5.308231 45.169487,5.308127 45.169772,5.308294 45.169906,5.308362 45.170271,5.307971 45.170654,5.307545 45.17115,5.307167 45.171631,5.30703 45.171841,5.306723 45.172393,5.306372 45.17298,5.306305 45.173166,5.306312 45.173376,5.306468 45.174041,5.306754 45.175066,5.30701 45.175147,5.307225 45.175315,5.307978 45.176056,5.308636 45.176657,5.308844 45.176948,5.309247 45.177647,5.309694 45.178158,5.309892 45.178605,5.310174 45.179168,5.310429 45.179756,5.310606 45.179983,5.310893 45.180226,5.311288 45.180614,5.311744 45.180693,5.312543 45.180759,5.3134 45.180733,5.313989 45.180745,5.314359 45.180786,5.314703 45.180866,5.314925 45.180796,5.315335 45.180812,5.315945 45.180772,5.316203 45.180733,5.317044 45.180549,5.317125 45.180543,5.317145 45.180408,5.317133 45.180056,5.317152 45.179254,5.317145 45.17835,5.316923 45.177578,5.316837 45.177158,5.316863 45.176392,5.316873 45.175404,5.31691 45.174945,5.317056 45.17469,5.31739 45.174456,5.317616 45.174254,5.317724 45.173982,5.31766 45.173592,5.317679 45.17336,5.317825 45.173103,5.318436 45.172546,5.31869 45.172266,5.318915 45.171931,5.318855 45.171777,5.318874 45.171578,5.319095 45.171246,5.319702 45.170633,5.319876 45.170376,5.320029 45.170054,5.320085 45.169872,5.320238 45.169198,5.320418 45.169004,5.320648 45.168702,5.321036 45.16838,5.321348 45.167774,5.321529 45.167496,5.321548 45.167345,5.322374 45.16701,5.322622 45.166868,5.323416 45.16578,5.323437 45.165306,5.323427 45.164305,5.323666 45.163806,5.324154 45.163849,5.324418 45.163909,5.324958 45.16414,5.325303 45.164411,5.325459 45.164694,5.325539 45.164756,5.326105 45.164614,5.328181 45.164054,5.328477 45.163967,5.328828 45.16383,5.329211 45.163764,5.329444 45.163673,5.330212 45.163512,5.331148 45.163177,5.331261 45.163062,5.330771 45.162821,5.330602 45.162657,5.330505 45.162322,5.330335 45.162044,5.330291 45.161881,5.330103 45.161659,5.329886 45.16149,5.329604 45.161331,5.329103 45.161084,5.328895 45.160954,5.328583 45.160602,5.328072 45.159969,5.328013 45.159618,5.327926 45.15948,5.327406 45.159058,5.327129 45.158686,5.327123 45.158221,5.326991 45.157464,5.326749 45.157186,5.326005 45.156707,5.325508 45.156327,5.32543 45.156231,5.325375 45.156049,5.325407 45.155931,5.325553 45.155805,5.325806 45.15548,5.32599 45.15529,5.326255 45.154964,5.326398 45.154696,5.326398 45.154468,5.32628 45.154239,5.326128 45.154075,5.32583 45.153953,5.325436 45.153649,5.325233 45.153251,5.325139 45.152863,5.325214 45.152734,5.32519 45.152437,5.325272 45.152292,5.325275 45.152153,5.325393 45.151866,5.325595 45.151676,5.326121 45.151135,5.326388 45.150884,5.326598 45.150769,5.326787 45.150708,5.327067 45.15056,5.327186 45.150411,5.327183 45.150283,5.327063 45.15015,5.326953 45.149923,5.327098 45.149861,5.327133 45.149749,5.327084 45.149569,5.327388 45.149309,5.327437 45.14917,5.327409 45.148958,5.327909 45.148398,5.327995 45.148165,5.328272 45.147869,5.328342 45.147386,5.328533 45.146997,5.328673 45.146867,5.328847 45.146644,5.328953 45.146383,5.328962 45.14622,5.329068 45.146002,5.329338 45.145723,5.329491 45.145478,5.329442 45.145312,5.32935 45.145209,5.329229 45.144882,5.329137 45.144706,5.329088 45.144336,5.329266 45.144264,5.329686 45.144025,5.329831 45.143849,5.330025 45.143769,5.330335 45.143566,5.330718 45.143255,5.330892 45.14309,5.330921 45.14296,5.330821 45.142729,5.330803 45.142546,5.330877 45.142403,5.330864 45.142308,5.331007 45.142164,5.331151 45.14195,5.331232 45.141756,5.331546 45.141351,5.331845 45.140865,5.332022 45.140525,5.332058 45.14037,5.33202 45.139981,5.332036 45.139804,5.332125 45.139545,5.332072 45.137852,5.331961 45.13757,5.331895 45.137481,5.331719 45.137421,5.331588 45.137304,5.331179 45.137038,5.330894 45.136759,5.330691 45.136683,5.330482 45.136651,5.330335 45.136679,5.32998 45.136691,5.329591 45.136582,5.329316 45.136429,5.328938 45.136046,5.328723 45.135927,5.328399 45.135708,5.328292 45.135601,5.327872 45.13526,5.327786 45.135168,5.327541 45.135078,5.32705 45.134713,5.326852 45.134486,5.326823 45.13427,5.327018 45.133685,5.327044 45.133493,5.327148 45.133241,5.32712 45.133025,5.326906 45.132645,5.3267 45.132333,5.326294 45.131597,5.326239 45.131393,5.326316 45.131273,5.32634 45.131129,5.326191 45.131021,5.326035 45.130827,5.325851 45.130185,5.325721 45.129919,5.325654 45.1296,5.325719 45.129413,5.325605 45.129201,5.325782 45.128805,5.325995 45.128447,5.326105 45.128185,5.326036 45.128052,5.325832 45.127911,5.325576 45.127511,5.325441 45.127443,5.324888 45.127331,5.324698 45.127189,5.324613 45.127043,5.324573 45.126862,5.324553 45.126542,5.324474 45.126404,5.324235 45.126115,5.324124 45.126069,5.323649 45.125997,5.323274 45.125896,5.323139 45.125803,5.322969 45.125523,5.322921 45.125394,5.322791 45.125243,5.322659 45.12491,5.322777 45.124564,5.322775 45.124391,5.322608 45.124514,5.320375 45.126682,5.31936 45.127924,5.317217 45.131924,5.31625 45.132638,5.314865 45.134697,5.314399 45.135475,5.313997 45.136934,5.313419 45.137391,5.31255 45.138032,5.312042 45.138468,5.311806 45.138691,5.309629 45.142528,5.308219 45.144792,5.307241 45.146325,5.306686 45.147226,5.306095 45.147722,5.303862 45.149576,5.304145 45.149774,5.304369 45.149894,5.303619 45.150811,5.302793 45.151809,5.301123 45.153875,5.301439 45.155737,5.302792 45.156604,5.303229 45.156921,5.303595 45.157142,5.303892 45.157269,5.304271 45.157482,5.304785 45.157875)))"
  "2025-07-15 05:20:16+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.304785 45.157875,5.305181 45.15871,5.305269 45.159045,5.305431 45.159484,5.305845 45.160083,5.305988 45.1602,5.306605 45.160565,5.306839 45.160937,5.307093 45.161561,5.307128 45.161873,5.307142 45.162676,5.307226 45.16296,5.307569 45.163948,5.307814 45.164562,5.307932 45.164771,5.30805 45.165066,5.308244 45.165761,5.308298 45.166008,5.308196 45.166239,5.308167 45.166422,5.308058 45.166623,5.308073 45.16689,5.30814 45.167394,5.308156 45.167688,5.308136 45.168069,5.308186 45.168645,5.308123 45.168942,5.308158 45.169221,5.308231 45.169487,5.308127 45.169772,5.308294 45.169906,5.308362 45.170271,5.307971 45.170654,5.307545 45.17115,5.307167 45.171631,5.30703 45.171841,5.306723 45.172393,5.306372 45.17298,5.306305 45.173166,5.306312 45.173376,5.306468 45.174041,5.306754 45.175066,5.30701 45.175147,5.307225 45.175315,5.307978 45.176056,5.308636 45.176657,5.308844 45.176948,5.309247 45.177647,5.309694 45.178158,5.309892 45.178605,5.310174 45.179168,5.310429 45.179756,5.310606 45.179983,5.310893 45.180226,5.311288 45.180614,5.311744 45.180693,5.312543 45.180759,5.3134 45.180733,5.313989 45.180745,5.314359 45.180786,5.314703 45.180866,5.314925 45.180796,5.315335 45.180812,5.315945 45.180772,5.316203 45.180733,5.317044 45.180549,5.317125 45.180543,5.317145 45.180408,5.317133 45.180056,5.317152 45.179254,5.317145 45.17835,5.316923 45.177578,5.316837 45.177158,5.316863 45.176392,5.316873 45.175404,5.31691 45.174945,5.317056 45.17469,5.31739 45.174456,5.317616 45.174254,5.317724 45.173982,5.31766 45.173592,5.317679 45.17336,5.317825 45.173103,5.318436 45.172546,5.31869 45.172266,5.318915 45.171931,5.318855 45.171777,5.318874 45.171578,5.319095 45.171246,5.319702 45.170633,5.319876 45.170376,5.320029 45.170054,5.320085 45.169872,5.320238 45.169198,5.320418 45.169004,5.320648 45.168702,5.321036 45.16838,5.321348 45.167774,5.321529 45.167496,5.321548 45.167345,5.322374 45.16701,5.322622 45.166868,5.323416 45.16578,5.323437 45.165306,5.323427 45.164305,5.323666 45.163806,5.324154 45.163849,5.324418 45.163909,5.324958 45.16414,5.325303 45.164411,5.325459 45.164694,5.325539 45.164756,5.326105 45.164614,5.328181 45.164054,5.328477 45.163967,5.328828 45.16383,5.329211 45.163764,5.329444 45.163673,5.330212 45.163512,5.331148 45.163177,5.331261 45.163062,5.330771 45.162821,5.330602 45.162657,5.330505 45.162322,5.330335 45.162044,5.330291 45.161881,5.330103 45.161659,5.329886 45.16149,5.329604 45.161331,5.329103 45.161084,5.328895 45.160954,5.328583 45.160602,5.328072 45.159969,5.328013 45.159618,5.327926 45.15948,5.327406 45.159058,5.327129 45.158686,5.327123 45.158221,5.326991 45.157464,5.326749 45.157186,5.326005 45.156707,5.325508 45.156327,5.32543 45.156231,5.325375 45.156049,5.325407 45.155931,5.325553 45.155805,5.325806 45.15548,5.32599 45.15529,5.326255 45.154964,5.326398 45.154696,5.326398 45.154468,5.32628 45.154239,5.326128 45.154075,5.32583 45.153953,5.325436 45.153649,5.325233 45.153251,5.325139 45.152863,5.325214 45.152734,5.32519 45.152437,5.325272 45.152292,5.325275 45.152153,5.325393 45.151866,5.325595 45.151676,5.326121 45.151135,5.326388 45.150884,5.326598 45.150769,5.326787 45.150708,5.327067 45.15056,5.327186 45.150411,5.327183 45.150283,5.327063 45.15015,5.326953 45.149923,5.327098 45.149861,5.327133 45.149749,5.327084 45.149569,5.327388 45.149309,5.327437 45.14917,5.327409 45.148958,5.327909 45.148398,5.327995 45.148165,5.328272 45.147869,5.328342 45.147386,5.328533 45.146997,5.328673 45.146867,5.328847 45.146644,5.328953 45.146383,5.328962 45.14622,5.329068 45.146002,5.329338 45.145723,5.329491 45.145478,5.329442 45.145312,5.32935 45.145209,5.329229 45.144882,5.329137 45.144706,5.329088 45.144336,5.329266 45.144264,5.329686 45.144025,5.329831 45.143849,5.330025 45.143769,5.330335 45.143566,5.330718 45.143255,5.330892 45.14309,5.330921 45.14296,5.330821 45.142729,5.330803 45.142546,5.330877 45.142403,5.330864 45.142308,5.331007 45.142164,5.331151 45.14195,5.331232 45.141756,5.331546 45.141351,5.331845 45.140865,5.332022 45.140525,5.332058 45.14037,5.33202 45.139981,5.332036 45.139804,5.332125 45.139545,5.332072 45.137852,5.331961 45.13757,5.331895 45.137481,5.331719 45.137421,5.331588 45.137304,5.331179 45.137038,5.330894 45.136759,5.330691 45.136683,5.330482 45.136651,5.330335 45.136679,5.32998 45.136691,5.329591 45.136582,5.329316 45.136429,5.328938 45.136046,5.328723 45.135927,5.328399 45.135708,5.328292 45.135601,5.327872 45.13526,5.327786 45.135168,5.327541 45.135078,5.32705 45.134713,5.326852 45.134486,5.326823 45.13427,5.327018 45.133685,5.327044 45.133493,5.327148 45.133241,5.32712 45.133025,5.326906 45.132645,5.3267 45.132333,5.326294 45.131597,5.326239 45.131393,5.326316 45.131273,5.32634 45.131129,5.326191 45.131021,5.326035 45.130827,5.325851 45.130185,5.325721 45.129919,5.325654 45.1296,5.325719 45.129413,5.325605 45.129201,5.325782 45.128805,5.325995 45.128447,5.326105 45.128185,5.326036 45.128052,5.325832 45.127911,5.325576 45.127511,5.325441 45.127443,5.324888 45.127331,5.324698 45.127189,5.324613 45.127043,5.324573 45.126862,5.324553 45.126542,5.324474 45.126404,5.324235 45.126115,5.324124 45.126069,5.323649 45.125997,5.323274 45.125896,5.323139 45.125803,5.322969 45.125523,5.322921 45.125394,5.322791 45.125243,5.322659 45.12491,5.322777 45.124564,5.322775 45.124391,5.322608 45.124514,5.320375 45.126682,5.31936 45.127924,5.317217 45.131924,5.31625 45.132638,5.314865 45.134697,5.314399 45.135475,5.313997 45.136934,5.313419 45.137391,5.31255 45.138032,5.312042 45.138468,5.311806 45.138691,5.309629 45.142528,5.308219 45.144792,5.307241 45.146325,5.306686 45.147226,5.306095 45.147722,5.303862 45.149576,5.304145 45.149774,5.304369 45.149894,5.303619 45.150811,5.302793 45.151809,5.301123 45.153875,5.301439 45.155737,5.302792 45.156604,5.303229 45.156921,5.303595 45.157142,5.303892 45.157269,5.304271 45.157482,5.304785 45.157875)))', 4326))
  AND h.valid_from >= '2025-07-15 05:20:16+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.65 ms
(1.64%)

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

Parameters:

[
  "38416"
]

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

#	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.41 ms
(1.05%)

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:

[
  "38416"
]

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'38416'') = ?
      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.38 ms
(0.96%)

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.24 ms
(0.61%)

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	4157
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/38416/zone-places-history?period=12m

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