GET https://osm-labo.cipherbliss.com/admin/stats/01350/followup-graph/microbibliotheque

Response
200 OK
IP
216.73.216.110
Profiled on
Token
351030

Query Metrics

22 Database Queries
20 Different statements
1068.98 ms Query time
0 Invalid entities
3908 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
495.16 ms
(46.32%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
79.89 ms
(7.47%) 		1 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"microbibliotheque","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}"
  "2026-07-14 19:37:28"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
70.66 ms
(6.61%) 		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: 
[
  "01350"
]
View formatted query    View runnable query    Explain query    View query backtrace
25.22 ms
(2.36%) 		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: 
[
  26512
]
View formatted query    View runnable query    Explain query    View query backtrace
6.59 ms
(0.62%) 		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: 
[
  26512
  "microbibliotheque_count"
  "microbibliotheque_completion"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.08 ms
(0.10%) 		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: 
[
  26512
  "microbibliotheque"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.04%) 		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: 
[
  26512
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.03%) 		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: 
[
  "01350"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.01%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

osm connection

Time▼ Count Info
372.88 ms
(34.88%) 		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->'amenity') = 'public_bookcase')
Parameters: 
[
  "MULTIPOLYGON(((5.285194 46.240941,5.284735 46.240863,5.284339 46.240738,5.283837 46.240772,5.283604 46.24086,5.282686 46.241469,5.282492 46.241489,5.28236 46.241304,5.28214 46.241277,5.281828 46.241349,5.281766 46.241541,5.281649 46.241639,5.281245 46.241822,5.281156 46.242,5.280916 46.242037,5.280859 46.242339,5.280891 46.242481,5.280554 46.242521,5.280218 46.242511,5.279899 46.24261,5.279856 46.243016,5.279112 46.243191,5.278897 46.243276,5.278706 46.243163,5.278448 46.243368,5.27784 46.243526,5.277159 46.243596,5.27699 46.243715,5.276767 46.243662,5.276092 46.243822,5.275845 46.243836,5.275631 46.243747,5.275304 46.24368,5.275157 46.243764,5.275122 46.243911,5.27516 46.244105,5.275394 46.244124,5.275327 46.244248,5.275061 46.244229,5.274992 46.244323,5.275022 46.244576,5.274489 46.24455,5.273671 46.245022,5.272908 46.245374,5.272711 46.245418,5.272515 46.245673,5.271885 46.246062,5.271329 46.24651,5.271184 46.246818,5.270819 46.247097,5.27032 46.247595,5.269814 46.248149,5.269403 46.248741,5.269136 46.249253,5.268824 46.250281,5.268642 46.250909,5.268589 46.251038,5.268168 46.251609,5.268031 46.25174,5.266994 46.252917,5.26681 46.253272,5.266598 46.253634,5.266482 46.253714,5.266232 46.253792,5.26605 46.253883,5.265619 46.254296,5.265405 46.254311,5.265302 46.254737,5.264877 46.255288,5.264509 46.255703,5.264147 46.256207,5.263486 46.256702,5.262981 46.256939,5.262892 46.257077,5.26253 46.257104,5.262144 46.257324,5.261752 46.257429,5.261576 46.257497,5.26127 46.257702,5.261126 46.257951,5.260908 46.258722,5.26073 46.259042,5.260472 46.259794,5.260313 46.260058,5.26004 46.260291,5.259631 46.260498,5.259521 46.260711,5.259348 46.260851,5.258941 46.261058,5.25883 46.261214,5.258765 46.261427,5.258744 46.262059,5.258872 46.262322,5.259023 46.262431,5.259331 46.26286,5.259513 46.263082,5.259645 46.263287,5.259997 46.263517,5.260125 46.263747,5.260139 46.263894,5.260056 46.264004,5.260169 46.264564,5.260113 46.264664,5.259943 46.264762,5.25981 46.264999,5.259463 46.265093,5.259383 46.265157,5.259164 46.265136,5.259069 46.265201,5.258998 46.265362,5.259114 46.265482,5.259302 46.265572,5.259399 46.265744,5.259282 46.265842,5.25922 46.265968,5.259297 46.266191,5.2595 46.266366,5.259446 46.266496,5.259341 46.266569,5.259334 46.266678,5.259505 46.266884,5.259496 46.26705,5.259299 46.267317,5.258965 46.267565,5.258881 46.267655,5.258715 46.267944,5.258567 46.268051,5.258135 46.267919,5.257802 46.267752,5.257445 46.267773,5.2567 46.267692,5.256461 46.268016,5.255619 46.267729,5.254794 46.26848,5.252912 46.268232,5.252774 46.268367,5.252218 46.268531,5.252036 46.268618,5.251778 46.268891,5.251624 46.268975,5.251094 46.269023,5.250076 46.26923,5.250126 46.269091,5.250115 46.268911,5.249606 46.268075,5.249473 46.267832,5.249267 46.267392,5.24913 46.267206,5.247516 46.267677,5.247212 46.267906,5.246222 46.268257,5.24636 46.268479,5.245804 46.268508,5.244246 46.268785,5.244281 46.270611,5.244099 46.270798,5.243256 46.270795,5.242571 46.272324,5.242361 46.272389,5.241892 46.272576,5.241089 46.273315,5.241087 46.273484,5.241152 46.274857,5.240554 46.275256,5.239289 46.275311,5.239255 46.275787,5.239775 46.275807,5.240022 46.275867,5.240189 46.276024,5.240179 46.276215,5.240356 46.276335,5.240361 46.27663,5.240087 46.27707,5.240125 46.277241,5.240388 46.277573,5.240976 46.278008,5.241069 46.278024,5.241223 46.27817,5.241264 46.278334,5.241305 46.278704,5.241277 46.27913,5.2413 46.279478,5.241361 46.279548,5.241429 46.279867,5.241406 46.279978,5.241176 46.280108,5.241153 46.28021,5.241789 46.281017,5.241913 46.281703,5.241822 46.281779,5.241589 46.28184,5.241405 46.281941,5.240897 46.282321,5.239989 46.283024,5.239413 46.283327,5.239177 46.283518,5.2388 46.283958,5.238524 46.284132,5.237919 46.284307,5.237625 46.284425,5.237485 46.284571,5.237439 46.284749,5.237248 46.284977,5.237003 46.285099,5.237204 46.285262,5.237528 46.285407,5.237734 46.286539,5.237793 46.287043,5.238416 46.286739,5.238788 46.286667,5.238979 46.286684,5.239142 46.286747,5.239333 46.286884,5.240041 46.286903,5.240062 46.286666,5.242422 46.286917,5.242686 46.28701,5.243052 46.287766,5.243101 46.288039,5.243383 46.28827,5.244551 46.288865,5.245309 46.289221,5.245831 46.28921,5.24641 46.288907,5.247079 46.290229,5.247703 46.291772,5.247449 46.29229,5.247099 46.292919,5.247181 46.293129,5.247313 46.294268,5.247625 46.294358,5.24859 46.294444,5.248956 46.294432,5.249391 46.294452,5.24962 46.294492,5.250393 46.294673,5.250886 46.294482,5.252 46.294207,5.252759 46.294081,5.254808 46.29396,5.255888 46.293973,5.256931 46.293792,5.257661 46.293753,5.25829 46.293707,5.258879 46.293648,5.260808 46.293437,5.261201 46.293301,5.261399 46.293271,5.26158 46.293137,5.262272 46.292768,5.262918 46.292401,5.263194 46.292223,5.263672 46.291752,5.265483 46.289982,5.265545 46.289918,5.266084 46.290588,5.268201 46.293052,5.269777 46.294923,5.270247 46.294764,5.271114 46.29451,5.271957 46.294356,5.27349 46.293973,5.273901 46.293826,5.273609 46.293547,5.273943 46.293452,5.274426 46.293584,5.275174 46.294029,5.27589 46.294548,5.276142 46.294476,5.2778 46.29405,5.278479 46.294989,5.279217 46.295942,5.280258 46.297146,5.280751 46.29711,5.281332 46.297409,5.281622 46.297493,5.282021 46.297508,5.282356 46.297492,5.283176 46.297833,5.28287 46.297122,5.283119 46.29708,5.283285 46.297495,5.283756 46.297473,5.283933 46.297594,5.284782 46.298122,5.285586 46.298597,5.285783 46.298637,5.28702 46.298695,5.28657 46.299948,5.286526 46.300503,5.28696 46.300871,5.286868 46.301427,5.286832 46.301524,5.286791 46.301866,5.286848 46.302036,5.287019 46.302137,5.286539 46.302426,5.286267 46.302632,5.286159 46.302821,5.286261 46.303003,5.286167 46.30315,5.286193 46.303412,5.286362 46.303472,5.287951 46.302677,5.288525 46.302482,5.288588 46.303651,5.288663 46.303829,5.289578 46.30394,5.290014 46.304163,5.291026 46.303978,5.291789 46.304133,5.292185 46.304097,5.292843 46.30426,5.293367 46.304336,5.293517 46.3048,5.294016 46.304948,5.294627 46.30503,5.296221 46.304097,5.297457 46.303954,5.299703 46.304053,5.300365 46.303853,5.300781 46.303661,5.301776 46.304883,5.30181 46.305512,5.301585 46.306148,5.301481 46.307816,5.301937 46.307849,5.30319 46.309392,5.303691 46.310234,5.303637 46.310416,5.303085 46.311015,5.303167 46.311328,5.303375 46.311593,5.304216 46.311526,5.305233 46.311094,5.306113 46.310576,5.306752 46.31065,5.306602 46.311194,5.306701 46.311821,5.307192 46.312483,5.307621 46.313193,5.307715 46.31373,5.307495 46.314457,5.307519 46.314906,5.307846 46.314942,5.309403 46.314902,5.310948 46.314636,5.311329 46.314491,5.311423 46.314485,5.311683 46.314707,5.31276 46.314498,5.314042 46.314194,5.314261 46.314639,5.314843 46.314579,5.31497 46.31453,5.314947 46.314125,5.315455 46.313887,5.31531 46.313621,5.314085 46.313201,5.313953 46.313031,5.314725 46.312421,5.315269 46.311686,5.315514 46.310822,5.315322 46.310415,5.31566 46.309335,5.315259 46.308391,5.315058 46.307857,5.316207 46.307479,5.316413 46.307221,5.316966 46.307095,5.316934 46.306554,5.317066 46.306521,5.317584 46.306493,5.318663 46.306506,5.318633 46.306319,5.318414 46.305974,5.318211 46.305702,5.317783 46.305172,5.317622 46.304868,5.31747 46.304408,5.31725 46.303804,5.316896 46.303095,5.316707 46.30269,5.316456 46.302102,5.316332 46.301773,5.316144 46.301555,5.31568 46.301238,5.315841 46.300777,5.315605 46.300018,5.315598 46.299883,5.316695 46.299879,5.316567 46.299483,5.316598 46.299382,5.316914 46.299196,5.316775 46.298327,5.317109 46.297818,5.314765 46.297699,5.313141 46.297697,5.312485 46.297579,5.311771 46.297598,5.311901 46.296915,5.311969 46.296468,5.312089 46.296284,5.311506 46.296299,5.311424 46.295986,5.31058 46.296008,5.310513 46.295965,5.309554 46.292801,5.308951 46.292886,5.308624 46.292986,5.308432 46.293072,5.308176 46.293069,5.307775 46.29221,5.307048 46.291824,5.307027 46.291421,5.306917 46.291308,5.308555 46.289182,5.308805 46.288978,5.308614 46.288542,5.309336 46.286317,5.309489 46.284333,5.309244 46.282223,5.309149 46.281686,5.308877 46.281468,5.308349 46.281301,5.306953 46.280708,5.305774 46.280453,5.305198 46.279905,5.303914 46.27866,5.303863 46.278527,5.303742 46.278529,5.303293 46.277958,5.303042 46.277666,5.302576 46.276783,5.303278 46.276392,5.303855 46.276287,5.304417 46.275867,5.304988 46.275962,5.305171 46.275916,5.305207 46.275685,5.305371 46.27559,5.305639 46.275547,5.306408 46.275574,5.30647 46.275496,5.306352 46.275331,5.306399 46.275147,5.306715 46.275107,5.307226 46.274967,5.307567 46.274598,5.30778 46.274428,5.308296 46.27437,5.308608 46.274137,5.308921 46.274205,5.309285 46.273929,5.309339 46.27382,5.309685 46.273712,5.309689 46.273861,5.309807 46.273888,5.310053 46.27383,5.310121 46.273652,5.310707 46.273362,5.310967 46.273355,5.311361 46.273499,5.311605 46.273525,5.31173 46.27341,5.311922 46.2734,5.312215 46.273515,5.31243 46.273489,5.312484 46.273358,5.312323 46.273265,5.31232 46.273169,5.312537 46.273063,5.312534 46.272987,5.313393 46.272615,5.313907 46.272512,5.315271 46.271801,5.315974 46.271486,5.316468 46.271415,5.317029 46.27144,5.317591 46.27102,5.318489 46.270816,5.319561 46.270247,5.319945 46.270148,5.319868 46.269924,5.320043 46.269559,5.320534 46.269051,5.320701 46.268552,5.320798 46.267962,5.320709 46.267516,5.320638 46.267383,5.320615 46.266978,5.32073 46.266706,5.320446 46.266263,5.320437 46.266083,5.320618 46.265853,5.320536 46.26554,5.320524 46.265315,5.320708 46.265131,5.320816 46.264722,5.320931 46.26445,5.320984 46.264223,5.321293 46.263945,5.321341 46.263629,5.321256 46.26327,5.321242 46.263001,5.321551 46.262723,5.321537 46.262453,5.3212 46.262236,5.32132 46.262053,5.321304 46.261783,5.320973 46.261657,5.320904 46.260393,5.320916 46.260064,5.319925 46.260135,5.319558 46.260231,5.319399 46.260246,5.318523 46.26027,5.317269 46.2602,5.316508 46.2602,5.316155 46.260177,5.315517 46.260065,5.314955 46.259935,5.314178 46.259712,5.313491 46.259489,5.312182 46.25923,5.311808 46.259139,5.310661 46.258467,5.309749 46.258171,5.304266 46.257595,5.300577 46.257781,5.297819 46.257177,5.296183 46.25695,5.29558 46.256843,5.29577 46.256511,5.295712 46.255433,5.295884 46.255023,5.296069 46.254838,5.296456 46.254782,5.296508 46.254556,5.2967 46.254506,5.296818 46.254278,5.297132 46.25409,5.297247 46.253816,5.297561 46.253629,5.297554 46.253494,5.297484 46.253405,5.297527 46.252999,5.297776 46.252813,5.299002 46.252691,5.299314 46.252457,5.299302 46.252232,5.299688 46.252177,5.299937 46.251991,5.299669 46.251818,5.299597 46.251684,5.299787 46.251589,5.300096 46.251311,5.30042 46.251303,5.300748 46.251384,5.300736 46.251159,5.30119 46.251147,5.301178 46.250922,5.301501 46.250914,5.302437 46.250214,5.302619 46.249984,5.302592 46.24949,5.302762 46.249035,5.303605 46.247843,5.303631 46.247122,5.303747 46.246849,5.30418 46.246477,5.30423 46.246206,5.30453 46.245748,5.305281 46.245233,5.305395 46.244953,5.30534 46.244574,5.304726 46.243402,5.304892 46.243058,5.303883 46.242731,5.304076 46.242056,5.304075 46.24181,5.304026 46.241242,5.304242 46.241178,5.305314 46.241153,5.306058 46.241092,5.306238 46.241044,5.305664 46.240361,5.305174 46.239699,5.305147 46.239205,5.304445 46.238232,5.304406 46.237513,5.304426 46.237246,5.304438 46.237128,5.304351 46.237006,5.304027 46.236939,5.303493 46.236893,5.302761 46.236982,5.301845 46.23695,5.301517 46.236868,5.300775 46.236347,5.300147 46.236235,5.299302 46.236139,5.298847 46.236191,5.298572 46.236271,5.298248 46.236532,5.298144 46.236787,5.298146 46.236918,5.298231 46.237095,5.298096 46.237179,5.297778 46.237306,5.297323 46.237301,5.29702 46.237263,5.296668 46.237175,5.295376 46.237248,5.294716 46.237216,5.294666 46.237471,5.294319 46.237714,5.29401 46.23797,5.2938 46.238191,5.293615 46.238291,5.29299 46.238757,5.291582 46.239109,5.291017 46.239439,5.290759 46.239491,5.289858 46.239604,5.289562 46.23996,5.289498 46.240089,5.288591 46.240178,5.28643 46.241307,5.286033 46.241287,5.285921 46.241193,5.285532 46.241202,5.285194 46.240941)))"
]
View formatted query    View runnable query    Explain query    View query backtrace
7.96 ms
(0.74%) 		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: 
[
  "01350"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.98 ms
(0.19%) 		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
1.89 ms
(0.18%) 		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.77 ms
(0.17%) 		1 
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.05 ms
(0.10%) 		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
0.72 ms
(0.07%) 		1 
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters: 
[
  "01350"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.03%) 		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: 
[
  "01350"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.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.32 ms
(0.03%) 		1 
SELECT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.02%) 		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 3905
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.