Query Metrics
22
Database Queries
20
Different statements
2612.57 ms
Query time
0
Invalid entities
4538
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
669.66 ms (25.63%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
64.63 ms (2.47%) |
1 |
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.zip_code = ?
Parameters:
[
"01371"
]
|
||||||||||||||||||||||||||||||
|
31.17 ms (1.19%) |
1 |
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "[DEBUG][followupThemeGraph]" "{"theme":"proposed","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}" "2026-07-14 15:57:32" null null ]
|
||||||||||||||||||||||||||||||
|
7.80 ms (0.30%) |
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:
[
26702
]
|
||||||||||||||||||||||||||||||
|
6.39 ms (0.24%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id = ? AND c0_.name IN (?, ?) ORDER BY c0_.date ASC, c0_.id ASC
Parameters:
[ 26702 "proposed_count" "proposed_completion" ]
|
||||||||||||||||||||||||||||||
|
0.48 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = ?
Parameters:
[
26702
]
|
||||||||||||||||||||||||||||||
|
0.46 ms (0.02%) |
1 |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ? ORDER BY z0_.id ASC LIMIT 1
Parameters:
[ 26702 "proposed" ]
|
||||||||||||||||||||||||||||||
|
0.31 ms (0.01%) |
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:
[
"01371"
]
|
||||||||||||||||||||||||||||||
|
0.16 ms (0.01%) |
1 |
"START TRANSACTION"
Parameters:
[]
|
osm connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1662.03 ms (63.62%) |
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:
[
"01371"
]
|
||||||||||||||||||||||||||||||||
|
161.15 ms (6.17%) |
1 |
SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon, tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid FROM osm_object_meta m WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326)) AND (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'proposed:%'))
Parameters:
[
"MULTIPOLYGON(((5.011563 45.934686,5.0109 45.934745,5.010423 45.934765,5.009173 45.934644,5.008964 45.934528,5.008774 45.934008,5.008392 45.932421,5.008057 45.932105,5.007709 45.931921,5.00749 45.931544,5.007111 45.930955,5.006509 45.930206,5.005411 45.928198,5.001036 45.927798,5.000761 45.927827,5.000476 45.927907,4.99939 45.928244,4.998635 45.928647,4.998316 45.928791,4.997991 45.928885,4.996954 45.929349,4.996636 45.929472,4.995882 45.92973,4.995213 45.92991,4.994773 45.930072,4.993995 45.930396,4.993406 45.930673,4.992982 45.930832,4.992744 45.931017,4.991999 45.931505,4.991745 45.931622,4.991053 45.931787,4.990623 45.93186,4.989906 45.932003,4.988497 45.93244,4.987958 45.932532,4.986855 45.93279,4.986305 45.932882,4.985762 45.932996,4.98568 45.93303,4.985093 45.934455,4.983605 45.93438,4.982995 45.93433,4.98258 45.93431,4.982127 45.934358,4.981946 45.934435,4.980878 45.935092,4.980223 45.935483,4.979404 45.935801,4.97866 45.936073,4.977517 45.936455,4.976438 45.936826,4.975496 45.937228,4.975199 45.937405,4.974553 45.937689,4.973963 45.937992,4.973846 45.938008,4.973426 45.937925,4.9732 45.937925,4.972756 45.938107,4.972632 45.938198,4.971956 45.938779,4.971647 45.939026,4.971297 45.939233,4.970361 45.939655,4.970075 45.939822,4.96948 45.940097,4.968186 45.940843,4.968193 45.941179,4.968152 45.941352,4.967922 45.941532,4.967527 45.941783,4.967167 45.942054,4.966187 45.942668,4.964693 45.943524,4.964441 45.943696,4.963808 45.944248,4.963205 45.944954,4.962876 45.945229,4.962409 45.945422,4.961903 45.945717,4.961272 45.946104,4.960623 45.946875,4.960969 45.947076,4.961329 45.947465,4.961439 45.947476,4.961432 45.947597,4.961778 45.94812,4.961833 45.948253,4.961904 45.948603,4.961843 45.948734,4.965777 45.95045,4.96652 45.950985,4.968362 45.954035,4.970433 45.957981,4.97053 45.958025,4.970976 45.958086,4.971701 45.958226,4.972708 45.958466,4.97312 45.958538,4.973401 45.958559,4.973988 45.958546,4.974499 45.958572,4.97484 45.95864,4.974774 45.961533,4.974898 45.962029,4.975136 45.962397,4.975111 45.962743,4.975167 45.962983,4.9754 45.963503,4.975611 45.964066,4.974175 45.965643,4.97418 45.965958,4.974496 45.966328,4.973805 45.969089,4.974995 45.96913,4.975433 45.968624,4.976421 45.968543,4.977138 45.968685,4.978116 45.968756,4.982812 45.968801,4.993338 45.965606,4.994035 45.96518,4.995077 45.964813,4.995369 45.964643,4.9966 45.964032,5.0012 45.962186,5.00149 45.962056,5.001714 45.962044,5.003066 45.962041,5.003299 45.962005,5.004841 45.962327,5.004794 45.961671,5.005413 45.961622,5.006347 45.96159,5.00667 45.961611,5.007946 45.961758,5.008202 45.961773,5.008799 45.961765,5.008019 45.958314,5.00938 45.957354,5.009517 45.956224,5.008818 45.955768,5.008729 45.95496,5.00928 45.954664,5.010291 45.95367,5.011136 45.9533,5.010761 45.951718,5.011152 45.950577,5.011198 45.950406,5.010722 45.946826,5.009828 45.943932,5.011223 45.938952,5.011782 45.9369,5.011628 45.935518,5.011563 45.934686)))"
]
|
||||||||||||||||||||||||||||||||
|
2.05 ms (0.08%) |
3 |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?
Parameters:
[ "public" "osm_object_meta" ]
|
||||||||||||||||||||||||||||||||
|
1.94 ms (0.07%) |
1 |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
1.85 ms (0.07%) |
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:
[]
|
||||||||||||||||||||||||||||||||
|
0.81 ms (0.03%) |
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:
[]
|
||||||||||||||||||||||||||||||||
|
0.47 ms (0.02%) |
1 |
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters:
[
"01371"
]
|
||||||||||||||||||||||||||||||||
|
0.36 ms (0.01%) |
1 |
SELECT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.33 ms (0.01%) |
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:
[
"01371"
]
|
||||||||||||||||||||||||||||||||
|
0.31 ms (0.01%) |
1 |
CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.22 ms (0.01%) |
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:
[]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| osm | doctrine.dbal.osm_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\CityFollowUp | 4535 |
| App\Entity\Stats | 1 |
| App\Entity\ActionLog | 1 |
| App\Entity\ZonePlaces | 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. |
| App\Entity\ActionLog | No errors. |