Symfony Profiler

Query Metrics

15 Database Queries

13 Different statements

28.09 ms Query time

0 Invalid entities

5166 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

12.51 ms
(44.53%)

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:

[
  26610
]

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

#	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.32 ms
(1.14%)

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:

[
  "37161"
]

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 = '37161' 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.76 ms
(20.51%)

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:

[
  "37161"
]

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

2.39 ms
(8.50%)

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.89 ms
(6.74%)

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.89 ms
(6.71%)

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)

0.86 ms
(3.08%)

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.66 ms
(2.34%)

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(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
  "2026-04-15 04:11:04+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(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))', 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-04-15 04:11:04+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.55 ms
(1.96%)

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(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))"
  "2026-04-15 04:11:04+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(((1.087111 47.46182,1.08909 47.462246,1.092332 47.462641,1.092727 47.462735,1.097419 47.463505,1.098936 47.463881,1.101506 47.464276,1.101781 47.464271,1.102317 47.464316,1.103111 47.464445,1.104379 47.464635,1.105454 47.464751,1.106391 47.464808,1.107206 47.464936,1.10826 47.465189,1.110461 47.465728,1.112817 47.466109,1.113381 47.464294,1.113513 47.464126,1.113964 47.463055,1.114071 47.462741,1.113794 47.462605,1.114473 47.46203,1.114903 47.46173,1.114985 47.461732,1.115472 47.461593,1.115968 47.46138,1.116321 47.461159,1.116928 47.460452,1.117042 47.4604,1.11704 47.460282,1.116933 47.460044,1.116965 47.459839,1.116925 47.459778,1.117368 47.459246,1.117443 47.459017,1.118027 47.458908,1.118495 47.458767,1.11939 47.458349,1.119656 47.458289,1.120199 47.4582,1.120415 47.458111,1.120719 47.457884,1.120875 47.457655,1.120873 47.45734,1.120651 47.456797,1.121194 47.455606,1.121927 47.454859,1.122425 47.454412,1.122927 47.45403,1.123357 47.453679,1.123952 47.453131,1.124907 47.452293,1.125089 47.452157,1.126006 47.451518,1.126377 47.451269,1.126896 47.451069,1.127978 47.450724,1.128017 47.450683,1.128967 47.449939,1.12957 47.449631,1.130637 47.449417,1.131571 47.449112,1.132834 47.44899,1.133466 47.448979,1.13331 47.448543,1.133039 47.448055,1.132811 47.447101,1.13236 47.446467,1.131789 47.445381,1.131124 47.445418,1.130411 47.444737,1.129368 47.443916,1.129203 47.443688,1.128268 47.442735,1.126571 47.441548,1.125731 47.441028,1.124897 47.440526,1.123783 47.439797,1.123311 47.439447,1.122901 47.439026,1.12218 47.438219,1.121841 47.437749,1.121621 47.43737,1.1215 47.436836,1.121392 47.436568,1.121113 47.435443,1.120921 47.435084,1.120785 47.434901,1.119945 47.433588,1.119338 47.432567,1.119076 47.432165,1.11867 47.431598,1.118387 47.431275,1.118186 47.431098,1.117132 47.430316,1.116901 47.430117,1.116291 47.429483,1.115839 47.429127,1.115521 47.428979,1.115232 47.428888,1.114677 47.428629,1.113787 47.428168,1.11365 47.428024,1.112005 47.42916,1.110264 47.429861,1.10822 47.430323,1.107946 47.43041,1.105716 47.431461,1.105221 47.431668,1.105049 47.431665,1.104811 47.43131,1.10449 47.430874,1.104162 47.430485,1.103967 47.430341,1.103558 47.430251,1.103088 47.43024,1.102223 47.430253,1.097606 47.429535,1.095524 47.429232,1.093631 47.428931,1.093506 47.428922,1.090873 47.429263,1.087938 47.429606,1.086315 47.429787,1.085493 47.429886,1.085249 47.429865,1.084904 47.429694,1.084535 47.429396,1.083925 47.428869,1.082447 47.427648,1.082039 47.427881,1.08165 47.428165,1.080755 47.428852,1.080411 47.429103,1.080311 47.429151,1.079566 47.429379,1.078468 47.429727,1.078376 47.429776,1.076567 47.431017,1.075953 47.431466,1.075591 47.431866,1.075091 47.43223,1.074834 47.432567,1.073985 47.433577,1.073837 47.433703,1.073026 47.434645,1.072682 47.435507,1.072429 47.436065,1.072193 47.436546,1.07203 47.436825,1.071874 47.437291,1.071604 47.437838,1.071569 47.437982,1.071088 47.438199,1.070643 47.439024,1.070472 47.439412,1.070304 47.439734,1.069874 47.440495,1.069744 47.440877,1.069643 47.441083,1.069412 47.441448,1.068678 47.442464,1.068271 47.442968,1.067894 47.443303,1.067609 47.443622,1.067599 47.443697,1.067368 47.443992,1.067125 47.444379,1.067073 47.444497,1.066874 47.444554,1.066175 47.445276,1.06593 47.445481,1.065741 47.445559,1.065297 47.445543,1.064968 47.445835,1.064745 47.445961,1.06432 47.446425,1.064119 47.446776,1.064069 47.447061,1.063974 47.447117,1.06396 47.448416,1.06447 47.449312,1.06497 47.449758,1.065375 47.450039,1.065811 47.450291,1.066453 47.450745,1.066905 47.451022,1.067203 47.451177,1.068428 47.451881,1.068973 47.452164,1.069937 47.452832,1.070654 47.453151,1.071011 47.453193,1.071369 47.453047,1.075437 47.455225,1.07856 47.457054,1.080347 47.458204,1.083111 47.460008,1.083558 47.460205,1.085007 47.461078,1.086781 47.461771,1.087111 47.46182)))', 4326))
  AND h.valid_from >= '2026-04-15 04:11:04+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.43 ms
(1.53%)

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

Parameters:

[
  "37161"
]

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

#	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.33 ms
(1.19%)

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:

[
  "37161"
]

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'37161'') = ?
      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.28 ms
(1.01%)

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.21 ms
(0.76%)

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	5165
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/37161/zone-places-history

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