Symfony Profiler

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

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

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 = 27146 AND c0_.name IN ('street_lamp_count', 'street_lamp_completion') ORDER BY c0_.date ASC, c0_.id ASC;

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

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 = 27146 AND z0_.theme = 'street_lamp' ORDER BY z0_.id ASC 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 = ?
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 = '02056' LIMIT 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

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
  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'02056'') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 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 (
    (tags -> 'highway') = 'street_lamp'
  )

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('MULTIPOLYGON(((3.118317 49.705969,3.119478 49.705847,3.120799 49.705724,3.121613 49.705639,3.122222 49.70562,3.123117 49.705551,3.123307 49.705587,3.123388 49.705545,3.123961 49.705569,3.124537 49.705609,3.125615 49.705635,3.125671 49.705648,3.125823 49.706196,3.126358 49.706253,3.127069 49.706276,3.128134 49.706398,3.129959 49.706479,3.130008 49.705968,3.129984 49.70586,3.129774 49.705449,3.129552 49.704963,3.129473 49.70465,3.12946 49.704422,3.129569 49.704001,3.129755 49.703572,3.130157 49.703052,3.13046 49.702253,3.130792 49.701494,3.131157 49.701668,3.131672 49.701183,3.13249 49.700432,3.133288 49.700285,3.132674 49.698508,3.133032 49.698479,3.132847 49.69755,3.132537 49.697193,3.132396 49.696077,3.133349 49.69626,3.134256 49.696458,3.134024 49.697897,3.134285 49.697979,3.135291 49.698115,3.138904 49.698629,3.138593 49.699891,3.138183 49.701506,3.137651 49.701463,3.137939 49.702079,3.137795 49.702615,3.137287 49.70263,3.13738 49.702939,3.140205 49.703226,3.140211 49.703407,3.140784 49.703404,3.140814 49.703848,3.142212 49.703863,3.142492 49.702838,3.142869 49.701785,3.143814 49.700466,3.143228 49.700075,3.142701 49.699812,3.142756 49.699554,3.142885 49.698064,3.144395 49.698203,3.14477 49.697204,3.147081 49.697617,3.148657 49.696599,3.149042 49.695739,3.149054 49.695425,3.148877 49.694913,3.148402 49.694219,3.148615 49.693893,3.148588 49.693806,3.148177 49.693326,3.147859 49.692788,3.146447 49.692347,3.145629 49.692077,3.144617 49.691756,3.14407 49.69157,3.144226 49.691205,3.1443 49.690889,3.144247 49.690815,3.144335 49.689655,3.144351 49.68851,3.144378 49.687813,3.144356 49.687425,3.144387 49.687357,3.144368 49.687097,3.144446 49.686356,3.144439 49.685907,3.14452 49.684708,3.145509 49.683274,3.144931 49.682952,3.144481 49.682636,3.144093 49.682305,3.143595 49.681669,3.143175 49.681373,3.141828 49.680255,3.140733 49.679353,3.13885 49.677789,3.13801 49.677104,3.135973 49.676906,3.134391 49.675506,3.134375 49.673684,3.13448 49.673308,3.135383 49.672628,3.135904 49.672172,3.136226 49.670492,3.136633 49.668799,3.127361 49.669567,3.126633 49.670625,3.12587 49.671715,3.125201 49.672683,3.125101 49.67284,3.124946 49.673233,3.124733 49.674555,3.124185 49.676891,3.121908 49.678005,3.119665 49.679073,3.119737 49.679101,3.118911 49.679319,3.116694 49.68059,3.116643 49.680555,3.11549 49.681226,3.115039 49.681892,3.115197 49.68194,3.115005 49.682195,3.115004 49.682314,3.115207 49.682574,3.115258 49.682689,3.115044 49.683031,3.114683 49.683456,3.114354 49.683737,3.114762 49.683868,3.11573 49.684137,3.115811 49.684067,3.115975 49.68411,3.115981 49.684527,3.115967 49.685111,3.115993 49.685847,3.116044 49.68595,3.117344 49.686411,3.119652 49.687262,3.120292 49.687383,3.122049 49.688272,3.122108 49.688446,3.122377 49.688864,3.122708 49.689417,3.122864 49.689737,3.122718 49.690081,3.122568 49.690528,3.122563 49.690615,3.123604 49.691926,3.124037 49.692456,3.123859 49.6926,3.124472 49.69293,3.124743 49.69356,3.124792 49.693728,3.124889 49.694924,3.124949 49.696104,3.12618 49.696546,3.126365 49.696672,3.124923 49.697834,3.124453 49.698191,3.123796 49.698829,3.123522 49.699364,3.123303 49.699899,3.123031 49.700458,3.122627 49.701234,3.122239 49.701849,3.121774 49.70234,3.120715 49.703514,3.118451 49.705885,3.118317 49.705969)))', 4326))
            AND ((tags->'highway') = 'street_lamp');

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

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

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

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'02056'') = ?
      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)
  )
FROM
  zone_polygon
WHERE
  insee_code = ?

SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = '02056';

SELECT
  1

SELECT 1;

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);

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()
                );