GET https://osm-labo.cipherbliss.com/city/34335/zone-places-history?period=all

Response
200 OK
IP
216.73.216.164
Profiled on
Token
c0c9b1

Query Metrics

15 Database Queries
13 Different statements
40.57 ms Query time
0 Invalid entities
4410 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
16.63 ms
(41.00%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  27067
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.77%) 		1 
SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters: 
[
  "34335"
]
View formatted query    View runnable query    Explain query    View query backtrace

osm connection

Time▼ Count Info
9.54 ms
(23.52%) 		1 
SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM osm_object_meta m
WHERE osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags->'ref:INSEE') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1
Parameters: 
[
  "34335"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.26 ms
(8.03%) 		1 
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
2.60 ms
(6.41%) 		3 
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?
Parameters: 
[
  "public"
  "osm_object_meta"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.60 ms
(6.40%) 		1 
SELECT COUNT(*) FROM osm_object_meta WHERE osm_type = 'relation'
                  AND geom IS NOT NULL
                  AND (tags->'admin_level') = '8'
                  AND (tags->'boundary') = 'administrative'
                  AND (tags->'ref:INSEE') IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.33 ms
(3.28%) 		1 
INSERT INTO osm_object_meta (
    osm_type, osm_id, geom, tags, version, osm_timestamp, changeset, osm_user, uid
)
SELECT
    'relation',
    latest.osm_id,
    latest.geom,
    latest.tags,
    latest.version,
    to_char(latest.valid_from AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"'),
    latest.changeset,
    latest.osm_user,
    latest.uid
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.osm_id,
        h.geom,
        h.tags,
        h.version,
        h.valid_from,
        h.changeset,
        h.osm_user,
        h.uid
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'boundary') = 'administrative'
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'ref:INSEE') IS NOT NULL
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) AS latest
WHERE NOT EXISTS (
    SELECT 1 FROM osm_object_meta m
    WHERE m.osm_type = 'relation' AND m.osm_id = latest.osm_id
)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.27 ms
(3.13%) 		1 
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(((3.10648 43.614467,3.106306 43.614706,3.106174 43.614727,3.10592 43.614986,3.105601 43.615225,3.105431 43.615486,3.10537 43.615703,3.105213 43.615948,3.105153 43.616264,3.105126 43.616599,3.104903 43.617156,3.104753 43.61764,3.104602 43.618332,3.104372 43.618604,3.104268 43.618864,3.104327 43.618905,3.104226 43.619144,3.104147 43.619435,3.104218 43.619546,3.10575 43.620924,3.10601 43.620976,3.106458 43.62122,3.106665 43.621407,3.106965 43.621589,3.107125 43.621714,3.10724 43.621862,3.107483 43.62202,3.107813 43.62214,3.108214 43.622376,3.10831 43.622561,3.108544 43.622676,3.108649 43.622776,3.108672 43.622894,3.108969 43.622839,3.109148 43.622841,3.10914 43.623111,3.109205 43.623264,3.109228 43.623901,3.109049 43.624118,3.10881 43.624325,3.108665 43.624573,3.108526 43.624706,3.108325 43.624825,3.107914 43.624866,3.107027 43.62526,3.106619 43.625457,3.106652 43.625699,3.106636 43.625833,3.105601 43.626823,3.105728 43.627051,3.105593 43.627268,3.10541 43.627492,3.10528 43.627592,3.105384 43.627687,3.105283 43.627788,3.105118 43.627788,3.104823 43.627648,3.104478 43.627666,3.104246 43.627708,3.104142 43.627761,3.103909 43.627797,3.103812 43.628052,3.103789 43.628205,3.103797 43.628528,3.103894 43.628851,3.104044 43.628981,3.104169 43.629168,3.104836 43.629355,3.105078 43.629446,3.105061 43.629634,3.10487 43.630264,3.104734 43.630484,3.104723 43.63058,3.104418 43.630869,3.104331 43.630989,3.104311 43.631218,3.104476 43.631456,3.104377 43.632401,3.104337 43.63254,3.104195 43.632776,3.104247 43.632949,3.104435 43.633289,3.104474 43.633641,3.104441 43.634003,3.104354 43.634319,3.103839 43.634512,3.103819 43.63465,3.104381 43.634702,3.104472 43.634856,3.104203 43.63559,3.10405 43.635624,3.103343 43.636012,3.103089 43.636631,3.102742 43.63705,3.102618 43.637134,3.102658 43.637303,3.101936 43.638161,3.101078 43.64176,3.100554 43.644155,3.105927 43.643946,3.10581 43.643751,3.105714 43.643376,3.105719 43.64322,3.105563 43.6426,3.10557 43.642242,3.105308 43.641194,3.105165 43.640831,3.10511 43.640622,3.105087 43.640372,3.105167 43.640072,3.105125 43.639444,3.105139 43.639105,3.105188 43.638897,3.105403 43.638861,3.105989 43.638712,3.106335 43.638409,3.10658 43.637691,3.106529 43.637577,3.106484 43.637022,3.106639 43.636445,3.106889 43.636031,3.106941 43.636,3.106969 43.635033,3.107066 43.63483,3.107039 43.634583,3.107077 43.634038,3.107208 43.633761,3.107359 43.63357,3.107622 43.633117,3.110033 43.63319,3.117981 43.633426,3.119357 43.633455,3.119379 43.63362,3.119605 43.633766,3.119843 43.63383,3.120098 43.633815,3.120549 43.634151,3.121136 43.634374,3.121399 43.634492,3.12186 43.634328,3.122148 43.634177,3.122623 43.63385,3.122833 43.633725,3.123163 43.633618,3.12337 43.633402,3.123364 43.633231,3.12345 43.633111,3.12368 43.632941,3.123895 43.632638,3.123984 43.632443,3.124096 43.632321,3.124323 43.632203,3.124489 43.631698,3.124491 43.631409,3.124557 43.631207,3.124713 43.630957,3.125049 43.630684,3.125335 43.630507,3.125605 43.630483,3.126053 43.630281,3.126539 43.63011,3.126786 43.630157,3.127172 43.630149,3.127513 43.630219,3.127685 43.630147,3.128088 43.630039,3.128292 43.629947,3.130065 43.629555,3.13083 43.629848,3.131953 43.630322,3.132492 43.630447,3.133048 43.630457,3.133293 43.630498,3.133565 43.630582,3.133687 43.630569,3.134099 43.630592,3.134647 43.630549,3.135015 43.630557,3.135378 43.63054,3.135529 43.630492,3.135733 43.630493,3.135824 43.630443,3.136274 43.630411,3.136563 43.630351,3.136994 43.630379,3.137137 43.630173,3.137192 43.629938,3.137256 43.629523,3.137405 43.629222,3.137469 43.629026,3.137615 43.628733,3.137808 43.628177,3.138094 43.627854,3.138197 43.627578,3.138153 43.62739,3.137957 43.626987,3.13798 43.626868,3.138104 43.626581,3.138 43.626286,3.137829 43.626061,3.137855 43.625907,3.137794 43.625777,3.137634 43.625698,3.137543 43.625475,3.137627 43.625318,3.137735 43.625002,3.137944 43.624685,3.137896 43.624393,3.137979 43.624025,3.137915 43.623709,3.137752 43.623392,3.137684 43.623111,3.137542 43.622969,3.137454 43.62243,3.136987 43.62201,3.13679 43.621798,3.136775 43.621697,3.136894 43.621367,3.136921 43.621122,3.137106 43.62083,3.137509 43.62069,3.137974 43.620296,3.138534 43.619866,3.138829 43.619724,3.138967 43.619523,3.139081 43.619261,3.13929 43.618997,3.139486 43.618699,3.139972 43.618149,3.140171 43.618018,3.140169 43.617689,3.140132 43.617555,3.140023 43.61737,3.139839 43.617146,3.139655 43.616789,3.139779 43.616448,3.1399 43.616328,3.140233 43.616155,3.140342 43.616047,3.140453 43.615851,3.140534 43.615505,3.140557 43.615127,3.140654 43.614954,3.14084 43.614856,3.141006 43.614598,3.140832 43.614538,3.140292 43.614479,3.139851 43.614395,3.139441 43.614297,3.139567 43.6141,3.139031 43.613697,3.139157 43.613514,3.138776 43.613237,3.138808 43.612951,3.138709 43.612659,3.138514 43.61275,3.138329 43.612887,3.138043 43.613048,3.137889 43.613107,3.137506 43.613186,3.137041 43.613322,3.136241 43.613721,3.136098 43.61381,3.135709 43.613974,3.135266 43.614191,3.134639 43.614242,3.134397 43.614274,3.133925 43.614371,3.133709 43.614228,3.133415 43.613966,3.133682 43.613661,3.133683 43.613517,3.133619 43.613404,3.133259 43.61323,3.132923 43.613093,3.132488 43.612983,3.132312 43.612844,3.132504 43.612645,3.13278 43.612541,3.132654 43.612365,3.132537 43.612286,3.132237 43.611969,3.131916 43.611684,3.131926 43.611639,3.13161 43.611408,3.132503 43.611114,3.132633 43.610865,3.132727 43.610475,3.13272 43.610356,3.132833 43.610222,3.132775 43.610096,3.132938 43.609628,3.133136 43.609482,3.133355 43.609375,3.133851 43.60899,3.133972 43.608945,3.134278 43.608691,3.134509 43.608345,3.135076 43.608066,3.135426 43.607845,3.135667 43.607453,3.135796 43.607281,3.135885 43.606366,3.135041 43.606311,3.134892 43.606318,3.134766 43.606483,3.133937 43.60658,3.133639 43.606365,3.133556 43.606209,3.133432 43.606179,3.133267 43.606257,3.132795 43.606599,3.132534 43.606375,3.132208 43.606167,3.131857 43.605892,3.131394 43.605597,3.131367 43.605489,3.131034 43.605329,3.130879 43.605162,3.130641 43.605036,3.130303 43.604987,3.130061 43.604919,3.130748 43.604445,3.130849 43.604159,3.131188 43.603837,3.131211 43.603717,3.130884 43.603572,3.130714 43.603539,3.130218 43.603378,3.129924 43.603306,3.129839 43.60324,3.12976 43.60294,3.129046 43.602403,3.129036 43.602278,3.129352 43.602036,3.129915 43.601334,3.130039 43.601153,3.130142 43.600698,3.130234 43.60051,3.13035 43.600373,3.130596 43.59995,3.130735 43.599796,3.131511 43.599178,3.131598 43.599138,3.131812 43.598948,3.132449 43.59847,3.132731 43.598303,3.133002 43.598225,3.133483 43.598324,3.133585 43.598183,3.133576 43.598014,3.133974 43.596984,3.134177 43.59674,3.131228 43.596,3.12986 43.595636,3.128754 43.595362,3.128136 43.595168,3.126747 43.594962,3.125854 43.59486,3.125743 43.594562,3.12567 43.594243,3.125602 43.59417,3.125441 43.594119,3.124276 43.593884,3.123952 43.593828,3.122426 43.593643,3.12241 43.593832,3.122394 43.594711,3.122549 43.595581,3.122835 43.596385,3.123167 43.597058,3.123554 43.598009,3.123671 43.598262,3.123815 43.598766,3.123927 43.599244,3.124012 43.599803,3.124026 43.600043,3.124005 43.600553,3.12381 43.601483,3.12377 43.601625,3.123677 43.603526,3.123564 43.60391,3.122887 43.605734,3.12252 43.60665,3.12085 43.607179,3.120754 43.607176,3.120501 43.607264,3.120295 43.607292,3.11959 43.607597,3.119417 43.607644,3.119159 43.607661,3.118902 43.607852,3.118729 43.607927,3.11829 43.608023,3.117861 43.608163,3.117697 43.607883,3.115878 43.608897,3.115446 43.608803,3.114721 43.608682,3.114607 43.608814,3.11441 43.609119,3.114396 43.609205,3.113915 43.609236,3.113556 43.609284,3.11336 43.609243,3.112858 43.609247,3.112493 43.609285,3.111897 43.609253,3.111703 43.609216,3.11098 43.609211,3.111002 43.609389,3.109406 43.609339,3.109089 43.609368,3.108873 43.609685,3.108432 43.610182,3.108255 43.610337,3.108169 43.610479,3.108168 43.610578,3.108058 43.610815,3.107881 43.611025,3.107791 43.611217,3.107603 43.611434,3.107511 43.611705,3.10742 43.611882,3.107273 43.611989,3.107153 43.612156,3.107047 43.612485,3.107034 43.61271,3.106852 43.612979,3.10681 43.613152,3.10686 43.61322,3.106736 43.613521,3.106763 43.613835,3.106647 43.614134,3.106616 43.614354,3.10648 43.614467)))"
  "1970-01-01 00:00:00+00:00"
  20001
]
View formatted query    View runnable query    Explain query    View query backtrace
1.17 ms
(2.89%) 		1 
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(((3.10648 43.614467,3.106306 43.614706,3.106174 43.614727,3.10592 43.614986,3.105601 43.615225,3.105431 43.615486,3.10537 43.615703,3.105213 43.615948,3.105153 43.616264,3.105126 43.616599,3.104903 43.617156,3.104753 43.61764,3.104602 43.618332,3.104372 43.618604,3.104268 43.618864,3.104327 43.618905,3.104226 43.619144,3.104147 43.619435,3.104218 43.619546,3.10575 43.620924,3.10601 43.620976,3.106458 43.62122,3.106665 43.621407,3.106965 43.621589,3.107125 43.621714,3.10724 43.621862,3.107483 43.62202,3.107813 43.62214,3.108214 43.622376,3.10831 43.622561,3.108544 43.622676,3.108649 43.622776,3.108672 43.622894,3.108969 43.622839,3.109148 43.622841,3.10914 43.623111,3.109205 43.623264,3.109228 43.623901,3.109049 43.624118,3.10881 43.624325,3.108665 43.624573,3.108526 43.624706,3.108325 43.624825,3.107914 43.624866,3.107027 43.62526,3.106619 43.625457,3.106652 43.625699,3.106636 43.625833,3.105601 43.626823,3.105728 43.627051,3.105593 43.627268,3.10541 43.627492,3.10528 43.627592,3.105384 43.627687,3.105283 43.627788,3.105118 43.627788,3.104823 43.627648,3.104478 43.627666,3.104246 43.627708,3.104142 43.627761,3.103909 43.627797,3.103812 43.628052,3.103789 43.628205,3.103797 43.628528,3.103894 43.628851,3.104044 43.628981,3.104169 43.629168,3.104836 43.629355,3.105078 43.629446,3.105061 43.629634,3.10487 43.630264,3.104734 43.630484,3.104723 43.63058,3.104418 43.630869,3.104331 43.630989,3.104311 43.631218,3.104476 43.631456,3.104377 43.632401,3.104337 43.63254,3.104195 43.632776,3.104247 43.632949,3.104435 43.633289,3.104474 43.633641,3.104441 43.634003,3.104354 43.634319,3.103839 43.634512,3.103819 43.63465,3.104381 43.634702,3.104472 43.634856,3.104203 43.63559,3.10405 43.635624,3.103343 43.636012,3.103089 43.636631,3.102742 43.63705,3.102618 43.637134,3.102658 43.637303,3.101936 43.638161,3.101078 43.64176,3.100554 43.644155,3.105927 43.643946,3.10581 43.643751,3.105714 43.643376,3.105719 43.64322,3.105563 43.6426,3.10557 43.642242,3.105308 43.641194,3.105165 43.640831,3.10511 43.640622,3.105087 43.640372,3.105167 43.640072,3.105125 43.639444,3.105139 43.639105,3.105188 43.638897,3.105403 43.638861,3.105989 43.638712,3.106335 43.638409,3.10658 43.637691,3.106529 43.637577,3.106484 43.637022,3.106639 43.636445,3.106889 43.636031,3.106941 43.636,3.106969 43.635033,3.107066 43.63483,3.107039 43.634583,3.107077 43.634038,3.107208 43.633761,3.107359 43.63357,3.107622 43.633117,3.110033 43.63319,3.117981 43.633426,3.119357 43.633455,3.119379 43.63362,3.119605 43.633766,3.119843 43.63383,3.120098 43.633815,3.120549 43.634151,3.121136 43.634374,3.121399 43.634492,3.12186 43.634328,3.122148 43.634177,3.122623 43.63385,3.122833 43.633725,3.123163 43.633618,3.12337 43.633402,3.123364 43.633231,3.12345 43.633111,3.12368 43.632941,3.123895 43.632638,3.123984 43.632443,3.124096 43.632321,3.124323 43.632203,3.124489 43.631698,3.124491 43.631409,3.124557 43.631207,3.124713 43.630957,3.125049 43.630684,3.125335 43.630507,3.125605 43.630483,3.126053 43.630281,3.126539 43.63011,3.126786 43.630157,3.127172 43.630149,3.127513 43.630219,3.127685 43.630147,3.128088 43.630039,3.128292 43.629947,3.130065 43.629555,3.13083 43.629848,3.131953 43.630322,3.132492 43.630447,3.133048 43.630457,3.133293 43.630498,3.133565 43.630582,3.133687 43.630569,3.134099 43.630592,3.134647 43.630549,3.135015 43.630557,3.135378 43.63054,3.135529 43.630492,3.135733 43.630493,3.135824 43.630443,3.136274 43.630411,3.136563 43.630351,3.136994 43.630379,3.137137 43.630173,3.137192 43.629938,3.137256 43.629523,3.137405 43.629222,3.137469 43.629026,3.137615 43.628733,3.137808 43.628177,3.138094 43.627854,3.138197 43.627578,3.138153 43.62739,3.137957 43.626987,3.13798 43.626868,3.138104 43.626581,3.138 43.626286,3.137829 43.626061,3.137855 43.625907,3.137794 43.625777,3.137634 43.625698,3.137543 43.625475,3.137627 43.625318,3.137735 43.625002,3.137944 43.624685,3.137896 43.624393,3.137979 43.624025,3.137915 43.623709,3.137752 43.623392,3.137684 43.623111,3.137542 43.622969,3.137454 43.62243,3.136987 43.62201,3.13679 43.621798,3.136775 43.621697,3.136894 43.621367,3.136921 43.621122,3.137106 43.62083,3.137509 43.62069,3.137974 43.620296,3.138534 43.619866,3.138829 43.619724,3.138967 43.619523,3.139081 43.619261,3.13929 43.618997,3.139486 43.618699,3.139972 43.618149,3.140171 43.618018,3.140169 43.617689,3.140132 43.617555,3.140023 43.61737,3.139839 43.617146,3.139655 43.616789,3.139779 43.616448,3.1399 43.616328,3.140233 43.616155,3.140342 43.616047,3.140453 43.615851,3.140534 43.615505,3.140557 43.615127,3.140654 43.614954,3.14084 43.614856,3.141006 43.614598,3.140832 43.614538,3.140292 43.614479,3.139851 43.614395,3.139441 43.614297,3.139567 43.6141,3.139031 43.613697,3.139157 43.613514,3.138776 43.613237,3.138808 43.612951,3.138709 43.612659,3.138514 43.61275,3.138329 43.612887,3.138043 43.613048,3.137889 43.613107,3.137506 43.613186,3.137041 43.613322,3.136241 43.613721,3.136098 43.61381,3.135709 43.613974,3.135266 43.614191,3.134639 43.614242,3.134397 43.614274,3.133925 43.614371,3.133709 43.614228,3.133415 43.613966,3.133682 43.613661,3.133683 43.613517,3.133619 43.613404,3.133259 43.61323,3.132923 43.613093,3.132488 43.612983,3.132312 43.612844,3.132504 43.612645,3.13278 43.612541,3.132654 43.612365,3.132537 43.612286,3.132237 43.611969,3.131916 43.611684,3.131926 43.611639,3.13161 43.611408,3.132503 43.611114,3.132633 43.610865,3.132727 43.610475,3.13272 43.610356,3.132833 43.610222,3.132775 43.610096,3.132938 43.609628,3.133136 43.609482,3.133355 43.609375,3.133851 43.60899,3.133972 43.608945,3.134278 43.608691,3.134509 43.608345,3.135076 43.608066,3.135426 43.607845,3.135667 43.607453,3.135796 43.607281,3.135885 43.606366,3.135041 43.606311,3.134892 43.606318,3.134766 43.606483,3.133937 43.60658,3.133639 43.606365,3.133556 43.606209,3.133432 43.606179,3.133267 43.606257,3.132795 43.606599,3.132534 43.606375,3.132208 43.606167,3.131857 43.605892,3.131394 43.605597,3.131367 43.605489,3.131034 43.605329,3.130879 43.605162,3.130641 43.605036,3.130303 43.604987,3.130061 43.604919,3.130748 43.604445,3.130849 43.604159,3.131188 43.603837,3.131211 43.603717,3.130884 43.603572,3.130714 43.603539,3.130218 43.603378,3.129924 43.603306,3.129839 43.60324,3.12976 43.60294,3.129046 43.602403,3.129036 43.602278,3.129352 43.602036,3.129915 43.601334,3.130039 43.601153,3.130142 43.600698,3.130234 43.60051,3.13035 43.600373,3.130596 43.59995,3.130735 43.599796,3.131511 43.599178,3.131598 43.599138,3.131812 43.598948,3.132449 43.59847,3.132731 43.598303,3.133002 43.598225,3.133483 43.598324,3.133585 43.598183,3.133576 43.598014,3.133974 43.596984,3.134177 43.59674,3.131228 43.596,3.12986 43.595636,3.128754 43.595362,3.128136 43.595168,3.126747 43.594962,3.125854 43.59486,3.125743 43.594562,3.12567 43.594243,3.125602 43.59417,3.125441 43.594119,3.124276 43.593884,3.123952 43.593828,3.122426 43.593643,3.12241 43.593832,3.122394 43.594711,3.122549 43.595581,3.122835 43.596385,3.123167 43.597058,3.123554 43.598009,3.123671 43.598262,3.123815 43.598766,3.123927 43.599244,3.124012 43.599803,3.124026 43.600043,3.124005 43.600553,3.12381 43.601483,3.12377 43.601625,3.123677 43.603526,3.123564 43.60391,3.122887 43.605734,3.12252 43.60665,3.12085 43.607179,3.120754 43.607176,3.120501 43.607264,3.120295 43.607292,3.11959 43.607597,3.119417 43.607644,3.119159 43.607661,3.118902 43.607852,3.118729 43.607927,3.11829 43.608023,3.117861 43.608163,3.117697 43.607883,3.115878 43.608897,3.115446 43.608803,3.114721 43.608682,3.114607 43.608814,3.11441 43.609119,3.114396 43.609205,3.113915 43.609236,3.113556 43.609284,3.11336 43.609243,3.112858 43.609247,3.112493 43.609285,3.111897 43.609253,3.111703 43.609216,3.11098 43.609211,3.111002 43.609389,3.109406 43.609339,3.109089 43.609368,3.108873 43.609685,3.108432 43.610182,3.108255 43.610337,3.108169 43.610479,3.108168 43.610578,3.108058 43.610815,3.107881 43.611025,3.107791 43.611217,3.107603 43.611434,3.107511 43.611705,3.10742 43.611882,3.107273 43.611989,3.107153 43.612156,3.107047 43.612485,3.107034 43.61271,3.106852 43.612979,3.10681 43.613152,3.10686 43.61322,3.106736 43.613521,3.106763 43.613835,3.106647 43.614134,3.106616 43.614354,3.10648 43.614467)))"
  "1970-01-01 00:00:00+00:00"
  20001
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(1.80%) 		1 
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters: 
[
  "34335"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(1.07%) 		1 
SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.geom
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'ref:INSEE') = ?
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'boundary') = 'administrative'
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) latest
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1
Parameters: 
[
  "34335"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(1.03%) 		1 
CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.66%) 		1 
CREATE TABLE IF NOT EXISTS zone_polygon (
                    insee_code TEXT PRIMARY KEY,
                    geom geometry(MultiPolygon, 4326) NOT NULL,
                    source TEXT NOT NULL,
                    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
                )
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

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

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CityFollowUp 4409
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.