Symfony Profiler

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 = '01276' LIMIT 1;

SELECT
  1

SELECT 1;

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

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

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

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

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

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

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

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

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 akeys(tags) && ARRAY[ 'amenity',
  'shop',
  'office',
  'craft',
  'leisure',
  'healthcare',
  'emergency',
  'man_made',
  'power',
  'highway',
  'railway',
  'public_transport',
  'landuse',
  'historic',
  'barrier',
  'tourism',
  'sport',
  'place',
  'waterway',
  'natural',
  'geological',
  'route',
  'military',
  'traffic_sign',
  'traffic_calming',
  'seamark',
  'route_master',
  'water',
  'airway',
  'aerialway',
  'building' ] :: text[]

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(((5.092364 45.812076,5.089338 45.811562,5.086051 45.812415,5.076352 45.811054,5.064339 45.809496,5.063458 45.8094,5.062773 45.80939,5.061766 45.809395,5.060969 45.809451,5.06038 45.809554,5.059516 45.809827,5.058442 45.810321,5.057229 45.81088,5.055535 45.811352,5.054268 45.811589,5.053422 45.811699,5.050988 45.811819,5.049337 45.81211,5.047774 45.812093,5.045401 45.811843,5.041039 45.810507,5.038057 45.808599,5.036981 45.809768,5.036653 45.810088,5.035358 45.811441,5.034233 45.812762,5.032894 45.814199,5.03274 45.814431,5.032446 45.81477,5.032115 45.815122,5.031933 45.815458,5.031588 45.81564,5.031565 45.815737,5.031579 45.816057,5.031348 45.816733,5.030765 45.818011,5.030726 45.818277,5.030789 45.81899,5.030785 45.819133,5.030705 45.819237,5.030789 45.819384,5.030825 45.819573,5.030906 45.821034,5.030944 45.821404,5.030999 45.821596,5.031193 45.822059,5.031599 45.822923,5.031869 45.82333,5.032143 45.823632,5.032439 45.823916,5.032928 45.824341,5.033205 45.824539,5.033878 45.824975,5.034614 45.825372,5.034801 45.825488,5.035252 45.825699,5.03541 45.825772,5.03618 45.826013,5.036405 45.826103,5.037841 45.827178,5.038357 45.827571,5.040523 45.829192,5.040786 45.829428,5.042302 45.830979,5.042724 45.831367,5.043987 45.832202,5.044673 45.832668,5.046341 45.834143,5.046329 45.834483,5.046342 45.836364,5.046378 45.836839,5.046548 45.838025,5.04665 45.838278,5.046994 45.838962,5.047041 45.838969,5.047375 45.839587,5.049505 45.838829,5.050024 45.838688,5.050458 45.83862,5.051498 45.838367,5.052485 45.838262,5.054811 45.837674,5.056322 45.837432,5.057218 45.837274,5.058019 45.837147,5.058776 45.837008,5.059515 45.836861,5.060447 45.836755,5.060937 45.836716,5.061963 45.836656,5.062549 45.836581,5.063019 45.836538,5.063249 45.836398,5.063492 45.836529,5.063749 45.836487,5.064761 45.836241,5.065718 45.836044,5.066153 45.835998,5.066687 45.835891,5.067413 45.835799,5.068413 45.835692,5.069016 45.835662,5.06978 45.835671,5.070478 45.835707,5.071114 45.835724,5.071362 45.835708,5.072291 45.835593,5.073027 45.83552,5.073648 45.835448,5.074077 45.83537,5.074254 45.835333,5.074824 45.835295,5.076157 45.835257,5.076672 45.835255,5.077735 45.835274,5.079548 45.831738,5.080105 45.832017,5.079831 45.827238,5.08046 45.826984,5.078831 45.826271,5.078753 45.825994,5.078778 45.825939,5.078746 45.825668,5.078602 45.824715,5.078603 45.824367,5.078682 45.824235,5.078801 45.824162,5.080055 45.823519,5.08095 45.823048,5.081385 45.822828,5.081721 45.822622,5.08277 45.822085,5.082922 45.821976,5.083064 45.821819,5.084267 45.820967,5.088335 45.818079,5.088465 45.817971,5.088678 45.81757,5.089078 45.816607,5.089106 45.816587,5.08986 45.815321,5.090794 45.814119,5.092364 45.812076)))', 4326))
            AND akeys(tags) && ARRAY['amenity','shop','office','craft','leisure','healthcare','emergency','man_made','power','highway','railway','public_transport','landuse','historic','barrier','tourism','sport','place','waterway','natural','geological','route','military','traffic_sign','traffic_calming','seamark','route_master','water','airway','aerialway','building']::text[];