Problème Gladys Plus

guim31 · Juillet 5, 2024, 6:06

Je pense que je vais tout miser sur le fait qu’on s’appelle un de ces jours, parce que ce matin la connexion était encore perdue… alors que ma freebox n’indique aucune déconnexion.
Comprends plus rien !!!

Je sais pas si c’est le bon jour… mais JOYEUX ANNIVERSAIRE !!!

pierre-gilles · Juillet 15, 2024, 7:41

Salut @guim31

Je ne sais pas si tu as réussi à investiguer un peu plus depuis.

J’ai pensé à un truc, tu peux utiliser https://healthchecks.io/ pour mettre en place un healthcheck de ton Gladys.

Ca te permettra de savoir si Gladys en elle-même reste connectée à internet / reste « vivante ».

Concrètement, il faut que tu fasse une scène dans Gladys qui va aller ping régulièrement ce service, et si Gladys arrête de ping le service, tu recevras une alerte (par email par défaut, mais d’autres services sont dispo aussi)

Tu créé un « Check » (c’est gratuit jusqu’à 20 checks)

Tu peux personnaliser si tu veux mettre une période plus faible, genre toutes les minutes si tu veux vraiment être précis, ou toutes les 5 minutes par exemple.

Dans ton cas, commencer par toutes les minutes / 2 minutes est peut-être le mieux pour suivre au mieux l’état de ton réseau/instance.

Tu copie colle l’URL :

Tu créé une scène dans Gladys qui à l’interval défini (toutes les minutes par exemple) va faire un ping à healthcheck grâce à l’action « requête HTTP » :

ça te permettra de savoir plus finement quand/si Gladys est déconnecté d’internet/down.

Merci !!

guim31 · Juillet 15, 2024, 7:53

Alors je vais regarder ça de plus près caril y a 10 jours j’ai eu une perte de connexion de Gladys Plus tous les jours… TRES penible.

Mardi dernier une coupure internet chez moi (Freebox qui ne symchronisait plus) pendant 2 ou 3 h.
Au redémarrage la freebox fait une mise à jour et à partir de là je remarque que je n’ai plus de deconnexions… Je me dis que tout va mieux ! … jusqu’à samedi matin : de nouveau déconnecté

pierre-gilles · Juillet 15, 2024, 7:56

Mince, dans ce cas effectivement healthcheck toutes les 1 minutes c’est le mieux pour avoir des alertes précises de quand ça arrive/quand ça revient.

Peut-être que la perte « longue durée » de connexion internet chez toi entraine une accumulation d’évènement à envoyer au serveur Gladys Plus, et ensuite Gladys galère à reprendre la main. Pour ça qu’avoir plus de data précise sur la fréquence et durée des déconnexions peut nous permettre de comprendre le souci

guim31 · Juillet 15, 2024, 8:51

Il suffisait d’en parler… Je viens d’aller sur mon Gladys à distance (je suis au travail) et paf déconnecté.

Un restart du container et je vais créer ma scène ! Je te tiendrai au courant

EDIT : tout est en place… maintenant j’attend le prochain problème !

guim31 · Juillet 16, 2024, 6:43

Ce matin je remarque que je suis encore déconnecté.

Sur healthcheck.io ça ping toujours correctement.

Malheureusement je ne peux pas avoir plus de 100 lignes d’historique, donc je ne peux pas savoir si à un moment donné dans la nuit il y a eu un problème.

pierre-gilles · Juillet 18, 2024, 7:17

Si, tu reçois un email si un check est down (Ou tout autre service si tu as configuré un autre service, genre Telegram)

guim31 · Juillet 18, 2024, 10:15

Bon ben en l’occurrence, pas de mail rien.

pierre-gilles · Juillet 18, 2024, 10:58

Ok, donc pas de coupure internet si ça tourne encore (ou du moins, pas de coupure supérieure à 1 minute)

Tu as plus d’informations sur les moments où ça arrive ? D’autres logs peut être ?

guim31 · Juillet 18, 2024, 11:52

J’ai beau chercher je ne trouve absolument rien.
Surtout que ça arrive finalement de manière assez aléatoire : le jour / la nuit…

pierre-gilles · Juillet 18, 2024, 2:29

Tu as quel genre d’activité sur ton instance ? Ultra intense ou plutôt ok ?

Est ce que ça pourrait être un / plusieurs capteurs trop agressif qui polluent Gladys et qui fait « freeze » ton instance ?

Tu utilise l’intégration Google Home ou Alexa ?

guim31 · Juillet 18, 2024, 2:38

Alors je ne pense pas qu’il y ait une activité ultra intense, mais j’ai beaucoup de capteurs donc y’a peut-être un bavard là dedans. COmment est-ce que je pourrai le savoir ?

Je n’utilise ni Google Home ni Alexa non.

pierre-gilles · Juillet 18, 2024, 2:56

On peut analyser ta DB tu sais extraire ta DB et faire quelques requêtes dessus ?

J’avais partagé une requête SQL sur le forum

guim31 · Juillet 18, 2024, 3:05

Disons que je saurai facilement naviguer jusqu’à la BDD mais pour la télécharger (wget ?) et effectuer des opérations dessus là je ne sais pas faire.

Je n’arrive pas à trouver la requête dont tu parles …

pierre-gilles · Juillet 18, 2024, 5:34

Il faut stopper Gladys, ensuite tu peux télécharger la base de donnée avec un tool style Cyberduck ou FileZilla

Ensuite tu peux utiliser TablePlus pour faire des requêtes sur le fichier !

J’essaie de te retrouver la requête

pierre-gilles · Juillet 18, 2024, 5:36

guim31 · Juillet 18, 2024, 7:17

Super, merci pour ton aide, je suis en train de rapatrier ma DB sur mon ordi portable… 24Go de transfert ça rame copieusement (merci le transfert FTP sur du wifi…).

Dès que j’ai ça je lance la requete SQL et je colle le résultat ici

guim31 · Juillet 18, 2024, 8:12

Je colle ici le résultat de la requete (au format JSON désole j’ai pas trouvé mieux pour le coller sur le forum) :

	
0	
COUNT(t_device_feature_state.id)	"2709800"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
feature_name	"Puissance consommée"
device_name	"Mesure Conso"
1	
COUNT(t_device_feature_state.id)	"2709800"
device_feature_id	"5c6f6494-dcf7-4eea-9f5f-1f2f4ea29083"
feature_name	"Intensité du signal"
device_name	"Mesure Conso"
2	
COUNT(t_device_feature_state.id)	"2709800"
device_feature_id	"ad6d2942-a329-4a04-8cd3-5f6328dcd0d2"
feature_name	"Tension moyenne"
device_name	"Mesure Conso"
3	
COUNT(t_device_feature_state.id)	"2709799"
device_feature_id	"34e1765d-a24b-46f1-92db-754062b84567"
feature_name	"Intensité consommée"
device_name	"Mesure Conso"
4	
COUNT(t_device_feature_state.id)	"2709799"
device_feature_id	"f698ae49-fb13-430c-8211-8038157a1890"
feature_name	"Energie consommée"
device_name	"Mesure Conso"
5	
COUNT(t_device_feature_state.id)	"370112"
device_feature_id	"5a228014-4a17-4481-9c20-9a2b5ca2edd5"
feature_name	"Commutateur"
device_name	"Prise NASDOURY"
6	
COUNT(t_device_feature_state.id)	"370112"
device_feature_id	"5e4ce261-7975-4e17-94f7-b1a7a1b4667f"
feature_name	"Consommation NAS"
device_name	"Prise NASDOURY"
7	
COUNT(t_device_feature_state.id)	"369156"
device_feature_id	"6062d7cd-2117-46cb-a05e-977f9f8c2834"
feature_name	"Intensité du signal"
device_name	"Portail Garage"
8	
COUNT(t_device_feature_state.id)	"369156"
device_feature_id	"b73fa27e-8782-46ad-a535-bd12ed11380c"
feature_name	"Commutateur"
device_name	"Portail Garage"
9	
COUNT(t_device_feature_state.id)	"367875"
device_feature_id	"b53bd970-339c-42c6-bc10-c5c6ac063a55"
feature_name	"Commutateur"
device_name	"Portail coulissant"
10	
COUNT(t_device_feature_state.id)	"255295"
device_feature_id	"4bc897ed-684a-42e2-ae5b-6e97d28798af"
feature_name	"Intensité consommée"
device_name	"Frigo"
11	
COUNT(t_device_feature_state.id)	"255295"
device_feature_id	"9bf31899-f6d7-4639-9bf0-54ce43ac1e8d"
feature_name	"Energie consommée"
device_name	"Frigo"
12	
COUNT(t_device_feature_state.id)	"255295"
device_feature_id	"b94bc1eb-780f-4057-81f7-a8794f2295d5"
feature_name	"Puissance Frigo"
device_name	"Frigo"
13	
COUNT(t_device_feature_state.id)	"255295"
device_feature_id	"eab06631-6e85-447b-8d14-55c56838dadb"
feature_name	"Commutateur"
device_name	"Frigo"
14	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"275650f9-084e-4e55-b014-17ab6efd9017"
feature_name	"Puissance consommée"
device_name	"Prise Linge"
15	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"8b67cea5-64b9-435a-94c6-b80d9c4e446b"
feature_name	"Intensité du signal"
device_name	"Prise Linge"
16	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"a3971f66-6994-47d7-9ee1-0fa97892ff28"
feature_name	"Tension moyenne"
device_name	"Prise Linge"
17	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"ad73644b-c4b7-48ac-811d-416fde00ab5e"
feature_name	"Energie consommée"
device_name	"Prise Linge"
18	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"c0af51c9-c569-456b-bebd-d72dbd9246c5"
feature_name	"Commutateur"
device_name	"Prise Linge"
19	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"ebe8d0e6-8ec2-4241-8c4f-7bb51865b1c9"
feature_name	"Intensité consommée"
device_name	"Prise Linge"
20	
COUNT(t_device_feature_state.id)	"176758"
device_feature_id	"60d8d1c4-ea6a-4ee5-a0a4-0bba36c4f195"
feature_name	"Energie consommée"
device_name	"🌀 Pompe Piscine "
21	
COUNT(t_device_feature_state.id)	"176758"
device_feature_id	"897855fb-4604-4dbe-926c-2509cb4ff5a8"
feature_name	"Commutateur"
device_name	"🌀 Pompe Piscine "
22	
COUNT(t_device_feature_state.id)	"176758"
device_feature_id	"8e3bc76b-460e-4a69-8599-6b1a04661068"
feature_name	"Conso Pompe Piscine"
device_name	"🌀 Pompe Piscine "
23	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"03688620-b18e-44bb-8715-41ec7c807dd7"
feature_name	"Intensité du signal"
device_name	"Prise Lisseur"
24	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"254b7fc5-6d2f-455d-8614-fcd4f665f86e"
feature_name	"Tension moyenne"
device_name	"Prise Lisseur"
25	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"62a31453-74cc-4aba-bbef-a540cec4bd5c"
feature_name	"Intensité consommée"
device_name	"Prise Lisseur"
26	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"d0021da7-6b04-483b-8b76-b27241af64a2"
feature_name	"Commutateur"
device_name	"Prise Lisseur"
27	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"db52b727-7137-49b3-9175-11104f2f73b4"
feature_name	"Puissance consommée"
device_name	"Prise Lisseur"
28	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"dea897e2-f877-4e31-9b97-997118d3c687"
feature_name	"Energie consommée"
device_name	"Prise Lisseur"
29	
COUNT(t_device_feature_state.id)	"129776"
device_feature_id	"1c2bc447-7bbd-4eff-9755-a8e360316739"
feature_name	"Production PV (kWh)"
device_name	"Production PV"
30	
COUNT(t_device_feature_state.id)	"129776"
device_feature_id	"49d9e7d3-8c6f-4fdd-9ca8-745b4dcd10be"
feature_name	"Consommation Maison (kWh)"
device_name	"Conso Maison"
31	
COUNT(t_device_feature_state.id)	"129757"
device_feature_id	"6f30443c-8aad-48bd-96c5-391730392abd"
feature_name	"Grid revente"
device_name	"Utilisation GRID revente"
32	
COUNT(t_device_feature_state.id)	"129757"
device_feature_id	"86b1d2cd-c539-4fad-b398-95bc691ff27a"
feature_name	"Réseau EDF (kWh)"
device_name	"Utilisation GRID consommation"
33	
COUNT(t_device_feature_state.id)	"126235"
device_feature_id	"d53e0e17-a9a2-4192-b0e7-636dadeb3451"
feature_name	"Presence"
device_name	"Switch 48 PoE"
34	
COUNT(t_device_feature_state.id)	"126234"
device_feature_id	"6df35bd2-40c1-4b4c-9f76-81fca25ef2fc"
feature_name	"Presence"
device_name	"Imprimante"
35	
COUNT(t_device_feature_state.id)	"126232"
device_feature_id	"c81396be-7603-4b5d-8151-dbe6dad719a9"
feature_name	"Presence"
device_name	"Freebox Server"
36	
COUNT(t_device_feature_state.id)	"126227"
device_feature_id	"dfaf030a-6d1a-46bf-b411-d382c18f39d3"
feature_name	"Presence"
device_name	"CAM 1"
37	
COUNT(t_device_feature_state.id)	"126226"
device_feature_id	"0258f3de-bc05-404f-9ef8-205005b78c6e"
feature_name	"Presence"
device_name	"CAM 2 "
38	
COUNT(t_device_feature_state.id)	"123610"
device_feature_id	"b6203951-70b7-40c2-a5b1-f85e928ffb56"
feature_name	"Sécurité enfant"
device_name	"Prise Lisseur"
39	
COUNT(t_device_feature_state.id)	"118484"
device_feature_id	"fc7525db-9e3f-409e-850f-fb55519fbfd6"
feature_name	"Presence"
device_name	"DENON S650"
40	
COUNT(t_device_feature_state.id)	"114734"
device_feature_id	"602a9d6b-0636-4a34-bbaf-04eb898e3019"
feature_name	"Presence"
device_name	"NASDOURY"
41	
COUNT(t_device_feature_state.id)	"109483"
device_feature_id	"b32c7ffb-32c3-4c0c-b968-5ec7212c38b8"
feature_name	"Commutateur"
device_name	"Prise NUC"
42	
COUNT(t_device_feature_state.id)	"109482"
device_feature_id	"37fe54f3-8eca-420f-b520-50b2cd29bb68"
feature_name	"Consommation NUC"
device_name	"Prise NUC"
43	
COUNT(t_device_feature_state.id)	"102984"
device_feature_id	"d3a07fa5-03d3-4e4e-b083-152bd217bc5f"
feature_name	"Presence"
device_name	"Onduleur"
44	
COUNT(t_device_feature_state.id)	"87635"
device_feature_id	"d192de0d-8268-44ad-a9e6-ae44867e095b"
feature_name	"Energie consommée"
device_name	"Prise Guinguette"
45	
COUNT(t_device_feature_state.id)	"87635"
device_feature_id	"e15cf56b-83e9-4eb9-b13e-ecb3956107cf"
feature_name	"Puissance consommée"
device_name	"Prise Guinguette"
46	
COUNT(t_device_feature_state.id)	"80935"
device_feature_id	"108a0efc-944a-49a5-821c-ff8cbc918989"
feature_name	"Température éclairage"
device_name	"Chevet Guilhem"
47	
COUNT(t_device_feature_state.id)	"80935"
device_feature_id	"655e61ca-0d65-4f97-b8a1-6e7272febec4"
feature_name	"Luminosité éclairage"
device_name	"Chevet Guilhem"
48	
COUNT(t_device_feature_state.id)	"80935"
device_feature_id	"ec820624-b322-47ee-b0d1-9818756facc0"
feature_name	"Eclairage On/Off"
device_name	"Chevet Guilhem"
49	
COUNT(t_device_feature_state.id)	"78001"
device_feature_id	"4cbb5b61-d909-46ad-ae93-b1c2e85ef838"
feature_name	"Luminosité éclairage"
device_name	"Chevet Sophie"
50	
COUNT(t_device_feature_state.id)	"78001"
device_feature_id	"4d17ad37-c266-4b69-9cdb-e2ec47daede4"
feature_name	"Eclairage On/Off"
device_name	"Chevet Sophie"
51	
COUNT(t_device_feature_state.id)	"78001"
device_feature_id	"89867f20-0f3a-4019-8b1f-5468ca23cec4"
feature_name	"Intensité du signal"
device_name	"Chevet Sophie"
52	
COUNT(t_device_feature_state.id)	"78001"
device_feature_id	"ffe20476-c2b2-44ae-ab1a-c75ff1bccee8"
feature_name	"Température éclairage"
device_name	"Chevet Sophie"
53	
COUNT(t_device_feature_state.id)	"74769"
device_feature_id	"9e7ec4cc-022d-4df7-8288-c3983ece0c39"
feature_name	"Presence"
device_name	"Galaxy S23 Sophie"
54	
COUNT(t_device_feature_state.id)	"50426"
device_feature_id	"217c7b6d-81d4-412a-b19b-574de883eb8f"
feature_name	"Commutateur"
device_name	"Vanne Eau"
55	
COUNT(t_device_feature_state.id)	"50426"
device_feature_id	"95b65412-8c6d-4b57-b639-0fafb6e1728b"
feature_name	"Intensité du signal"
device_name	"Vanne Eau"
56	
COUNT(t_device_feature_state.id)	"46434"
device_feature_id	"037fd573-5af5-48d2-b245-283b83806bc2"
feature_name	"Presence"
device_name	"SOLAREDGE"
57	
COUNT(t_device_feature_state.id)	"33185"
device_feature_id	"bbd52a89-202c-490b-939e-a9003d596c88"
feature_name	"Sécurité enfant"
device_name	"Prise Linge"
58	
COUNT(t_device_feature_state.id)	"32055"
device_feature_id	"48a97355-d8e2-4fa2-aa72-166143c4566b"
feature_name	"Salon"
device_name	"Température Salon"
59	
COUNT(t_device_feature_state.id)	"32055"
device_feature_id	"67828420-a788-40db-8a1e-abdfa2b7ec03"
feature_name	"Salon"
device_name	"Température Salon"
60	
COUNT(t_device_feature_state.id)	"32055"
device_feature_id	"a1b3b112-8649-4c14-8a3d-e2933b8d0521"
feature_name	"Valeur décimale pression"
device_name	"Température Salon"
61	
COUNT(t_device_feature_state.id)	"29465"
device_feature_id	"bdc6f0b7-da2e-46dc-9da5-eb8700929ca0"
feature_name	"Presence"
device_name	"TV"
62	
COUNT(t_device_feature_state.id)	"25925"
device_feature_id	"eaa0c4ab-259e-460f-9193-dff52eb416f1"
feature_name	"Consommation du jour"
device_name	"Consommations"
63	
COUNT(t_device_feature_state.id)	"21755"
device_feature_id	"7bab1e21-4696-47a1-aa54-bf5323f1316a"
feature_name	"Température extérieure"
device_name	"Température Jardin"
64	
COUNT(t_device_feature_state.id)	"21755"
device_feature_id	"dab34dcc-836e-437e-beb9-f9cd50ffb834"
feature_name	"Humidité Air"
device_name	"Température Jardin"
65	
COUNT(t_device_feature_state.id)	"19813"
device_feature_id	"6abde235-08ff-4d45-899d-ccbc6c6ea0fa"
feature_name	"Intensité du signal"
device_name	"Luminosité"
66	
COUNT(t_device_feature_state.id)	"19813"
device_feature_id	"743da3c3-f4d1-4dc6-b834-c15a2b36f8fc"
feature_name	"Batterie"
device_name	"Luminosité"
67	
COUNT(t_device_feature_state.id)	"19813"
device_feature_id	"86551ff8-ff10-4a70-bce7-89b4c1d0ef46"
feature_name	"Luminosité décimale"
device_name	"Luminosité"
68	
COUNT(t_device_feature_state.id)	"19813"
device_feature_id	"a41a2be3-08f5-488a-8ba6-81190c36bd3d"
feature_name	"Tension moyenne"
device_name	"Luminosité"
69	
COUNT(t_device_feature_state.id)	"18645"
device_feature_id	"b9e638ca-e50d-443c-8541-25de712462de"
feature_name	"Presence"
device_name	"Mi9T Guilhem"
70	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"1cbfb505-3bcf-47a9-9f50-bb844a9c2f9e"
feature_name	"Sécurité enfant"
device_name	"Prise Subwoofer"
71	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"305f90bb-4f75-4d7f-b202-2e73f72609bb"
feature_name	"Intensité du signal"
device_name	"Prise Subwoofer"
72	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"45e93ca2-0dbc-4d3d-b0ea-90446a4d1870"
feature_name	"Intensité consommée"
device_name	"Prise Subwoofer"
73	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"5891d7a1-be9b-4faa-898e-1da64143d7fe"
feature_name	"Commutateur"
device_name	"Prise Subwoofer"
74	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"bc5cdb7d-e18e-479a-bb5f-8f16b96a84a0"
feature_name	"Puissance consommée"
device_name	"Prise Subwoofer"
75	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"e3dbdc45-8415-424f-83e2-31905b5a4bf9"
feature_name	"Tension moyenne"
device_name	"Prise Subwoofer"
76	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"fc82045f-7ba7-4e2c-b536-bc2ba2162120"
feature_name	"Energie consommée"
device_name	"Prise Subwoofer"
77	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"1e47215c-5ab9-4a14-b07d-92b96ceed9e8"
feature_name	"Intensité consommée"
device_name	"Prise Ampli Denon"
78	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"8b64d5c5-a1f4-4b3f-9c92-9bb3f9e69789"
feature_name	"Intensité du signal"
device_name	"Prise Ampli Denon"
79	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"9621ad34-ab0e-4505-86bb-11f483b2639b"
feature_name	"Sécurité enfant"
device_name	"Prise Ampli Denon"
80	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"a5aa323a-f50e-4d80-98d3-6474236d2427"
feature_name	"Energie consommée"
device_name	"Prise Ampli Denon"
81	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"bac6cd45-cc6b-4e62-9e7a-8ee44bcafa2d"
feature_name	"Tension moyenne"
device_name	"Prise Ampli Denon"
82	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"ddd6cfe4-5448-4e02-ac76-e69452c3c287"
feature_name	"Commutateur"
device_name	"Prise Ampli Denon"
83	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"e3486be6-c61a-44e7-b8a9-02b32587046a"
feature_name	"Puissance consommée"
device_name	"Prise Ampli Denon"
84	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"0aa78d43-a621-4c8b-8233-0b69ff749f5d"
feature_name	"Tension moyenne"
device_name	"Mouvement Entrée"
85	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"2199a794-940c-4ecf-a65a-22356ab0d891"
feature_name	"Température"
device_name	"Mouvement Entrée"
86	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"2cd0395a-a909-4145-bc04-1a1120c1bc35"
feature_name	"Détection mouvement Oui/Non"
device_name	"Mouvement Entrée"
87	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"5b3463f3-5ea9-487d-b4e6-7a5e337a13e0"
feature_name	"Batterie"
device_name	"Mouvement Entrée"
88	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"774e6be3-49d8-4fdf-8d0f-7c1142401cb7"
feature_name	"Intensité du signal"
device_name	"Mouvement Entrée"
89	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"c4524b08-7cd8-4331-b04d-10b25c392fe2"
feature_name	"Luminosité décimale"
device_name	"Mouvement Entrée"
90	
COUNT(t_device_feature_state.id)	"13780"
device_feature_id	"68ac2240-7096-48d5-acce-b677520a5a37"
feature_name	"Valeur décimale pression"
device_name	"Température Garage"
91	
COUNT(t_device_feature_state.id)	"13780"
device_feature_id	"c70aa7d1-13f0-42ae-84f0-8590c7347d18"
feature_name	"Garage"
device_name	"Température Garage"
92	
COUNT(t_device_feature_state.id)	"13780"
device_feature_id	"f65b143f-eaf4-428f-a5ba-409675eb0462"
feature_name	"Garage"
device_name	"Température Garage"
93	
COUNT(t_device_feature_state.id)	"11932"
device_feature_id	"0ceec336-560e-49fe-80cf-b4aed629e152"
feature_name	"Chambre Ruben"
device_name	"Température Chambre Ruben"
94	
COUNT(t_device_feature_state.id)	"11932"
device_feature_id	"326841e0-cba5-4542-a48e-a51d24a6381e"
feature_name	"Chambre Ruben"
device_name	"Température Chambre Ruben"
95	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"0dcfd8ed-29bc-44fc-9983-0fa973ae44bf"
feature_name	"Température"
device_name	"Mouvement Portail Garage"
96	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"0e88bfa5-77b1-4ca9-9ca2-cb0f120c7027"
feature_name	"Luminosité décimale"
device_name	"Mouvement Portail Garage"
97	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"0ef6f592-6d29-42c1-99e2-9f139861160f"
feature_name	"Batterie"
device_name	"Mouvement Portail Garage"
98	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"2222f5da-ddf4-4797-83cf-652faa4134d5"
feature_name	"Intensité du signal"
device_name	"Mouvement Portail Garage"
99	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"42162f60-47bb-4a01-8d90-0c5d0338e6ca"
feature_name	"Tension moyenne"
device_name	"Mouvement Portail Garage"
100	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"99625a0c-2871-400f-84e0-0487c26cc591"
feature_name	"Détection mouvement Oui/Non"
device_name	"Mouvement Portail Garage"
101	
COUNT(t_device_feature_state.id)	"11466"
device_feature_id	"0ec538d5-ea59-4571-8877-c84e661532d7"
feature_name	"Mélodie"
device_name	"Alarme Orange"
102	
COUNT(t_device_feature_state.id)	"11466"
device_feature_id	"2077dd76-6cc8-451f-908b-951deb6e91a2"
feature_name	"Batterie"
device_name	"Alarme Orange"
103	
COUNT(t_device_feature_state.id)	"11466"
device_feature_id	"e789bfed-1404-4cb3-b214-85ec9a04aca6"
feature_name	"Volume de la sirène"
device_name	"Alarme Orange"
104	
COUNT(t_device_feature_state.id)	"11289"
device_feature_id	"24eece28-45a9-411c-9ffa-fbbe5ed9014e"
feature_name	"Ouvrir / Fermer"
device_name	"Remplissage Piscine"
105	
COUNT(t_device_feature_state.id)	"11236"
device_feature_id	"2f1f12be-60ef-42fd-aee2-72fdc366dad1"
feature_name	"Chambre Parents"
device_name	"Température Chambre Parents"
106	
COUNT(t_device_feature_state.id)	"11236"
device_feature_id	"36e279cc-e960-4379-871f-211eec0a5d09"
feature_name	"Chambre Parents"
device_name	"Température Chambre Parents"
107	
COUNT(t_device_feature_state.id)	"10951"
device_feature_id	"3f7209fa-d705-4fef-a29d-b2d06bf932a8"
feature_name	"Chambre d'Amis"
device_name	"Température Chambre d'Amis"
108	
COUNT(t_device_feature_state.id)	"10951"
device_feature_id	"407fcf33-ce7d-4ac6-bb80-b52be9a52b98"
feature_name	"Chambre d'Amis"
device_name	"Température Chambre d'Amis"
109	
COUNT(t_device_feature_state.id)	"10696"
device_feature_id	"73289f39-67d6-4b11-86ed-03590aaf409a"
feature_name	"Bureau"
device_name	"Température Bureau"
110	
COUNT(t_device_feature_state.id)	"10696"
device_feature_id	"e909ecf2-f395-4e1d-a820-267565edb0a0"
feature_name	"Bureau"
device_name	"Température Bureau"
111	
COUNT(t_device_feature_state.id)	"10146"
device_feature_id	"363f22e1-e608-47dc-bad1-7ca6e09abdc1"
feature_name	"Valeur décimale pression"
device_name	"Température Romelie"
112	
COUNT(t_device_feature_state.id)	"10146"
device_feature_id	"4b642b1b-f2cd-47f5-a476-ff716cae9cce"
feature_name	"Chambre Romélie"
device_name	"Température Romelie"
113	
COUNT(t_device_feature_state.id)	"10146"
device_feature_id	"c76abcd0-dbd8-4c25-ab90-3250b913b7fd"
feature_name	"Chambre Romélie"
device_name	"Température Romelie"
114	
COUNT(t_device_feature_state.id)	"9330"
device_feature_id	"81c2f23c-d8cb-4101-8ad7-974081316b9d"
feature_name	"Intensité du signal"
device_name	"Volet roulant - TV"
115	
COUNT(t_device_feature_state.id)	"9330"
device_feature_id	"ac9d99bf-533f-4c82-a45b-b986c78a79d5"
feature_name	"Etat du volet"
device_name	"Volet roulant - TV"
116	
COUNT(t_device_feature_state.id)	"9330"
device_feature_id	"f2a7c728-9952-44d0-b81a-732b1f09807c"
feature_name	"Position du volet"
device_name	"Volet roulant - TV"
117	
COUNT(t_device_feature_state.id)	"8330"
device_feature_id	"1a01f9d2-6d31-4d7b-8ef3-97217f09cebc"
feature_name	"Position du volet"
device_name	"Volet roulant - Chambre"
118	
COUNT(t_device_feature_state.id)	"8330"
device_feature_id	"1ae8c0ce-ce76-471c-a86f-faeac31f6dc3"
feature_name	"Intensité du signal"
device_name	"Volet roulant - Chambre"
119	
COUNT(t_device_feature_state.id)	"8330"
device_feature_id	"906d34a6-64d3-44b8-a007-3c30a1588dae"
feature_name	"Etat du volet"
device_name	"Volet roulant - Chambre"
120	
COUNT(t_device_feature_state.id)	"8214"
device_feature_id	"9fe5b638-ccec-4845-bf27-9afcda995f95"
feature_name	"Azimuth"
device_name	"Position Soleil"
121	
COUNT(t_device_feature_state.id)	"8214"
device_feature_id	"e84f49af-185c-42bf-ae69-20ac2e4eb20e"
feature_name	"Altitude"
device_name	"Position Soleil"
122	
COUNT(t_device_feature_state.id)	"7617"
device_feature_id	"2d8d4fee-aeef-478e-aa8b-d1df6041a6ce"
feature_name	"Etat du volet"
device_name	"Volet roulant - Piscine"
123	
COUNT(t_device_feature_state.id)	"7617"
device_feature_id	"4b9d9940-cbec-4f07-a771-790ae54fc5d2"
feature_name	"Intensité du signal"
device_name	"Volet roulant - Piscine"
124	
COUNT(t_device_feature_state.id)	"7617"
device_feature_id	"b157f868-e016-449c-8e76-8781131e90b0"
feature_name	"Position du volet"
device_name	"Volet roulant - Piscine"
125	
COUNT(t_device_feature_state.id)	"7508"
device_feature_id	"4bda9984-d0e2-4c9a-ad5d-436a957afbb4"
feature_name	"Lumière "
device_name	"Interrupteur Bureau"
126	
COUNT(t_device_feature_state.id)	"7249"
device_feature_id	"18277bdb-2c03-414b-9605-2d13ce5747a7"
feature_name	"Commutateur"
device_name	"💡 Lumiere Salon"
127	
COUNT(t_device_feature_state.id)	"6732"
device_feature_id	"ba4e87b9-7227-41ca-8fae-9267644c268d"
feature_name	"Intensité du signal"
device_name	"Disjoncteur Arrosage"
128	
COUNT(t_device_feature_state.id)	"6732"
device_feature_id	"cabbf1c7-e623-4d0f-96e8-e18fc1a9f1a7"
feature_name	"Commutateur"
device_name	"Disjoncteur Arrosage"
129	
COUNT(t_device_feature_state.id)	"6561"
device_feature_id	"2a927909-adc4-4d00-994f-8061d9093fb4"
feature_name	"Température Piscine"
device_name	"Température Piscine"
130	
COUNT(t_device_feature_state.id)	"6323"
device_feature_id	"3dc53b8f-9f5d-4707-af7d-949dd056bd33"
feature_name	"Intensité du signal"
device_name	"Disjoncteur Goutte à goutte "
131	
COUNT(t_device_feature_state.id)	"6323"
device_feature_id	"6aa1d7dc-4ccd-4d53-9529-bcdedac7400e"
feature_name	"Commutateur"
device_name	"Disjoncteur Goutte à goutte "
132	
COUNT(t_device_feature_state.id)	"5690"
device_feature_id	"38e166e3-9cbf-493f-9f13-66b74a68f126"
feature_name	"Eclairage On/Off"
device_name	"Ampoule Chambre Ruben "
133	
COUNT(t_device_feature_state.id)	"5690"
device_feature_id	"3d53e584-b954-439b-9644-387a3016fae4"
feature_name	"Température éclairage"
device_name	"Ampoule Chambre Ruben "
134	
COUNT(t_device_feature_state.id)	"5690"
device_feature_id	"afeb8c7a-0d72-4f74-a241-6830e05f3044"
feature_name	"Luminosité éclairage"
device_name	"Ampoule Chambre Ruben "
135	
COUNT(t_device_feature_state.id)	"5690"
device_feature_id	"c3d6a2bc-3e86-40c5-89d9-a36ca0dfa9c2"
feature_name	"Intensité du signal"
device_name	"Ampoule Chambre Ruben "
136	
COUNT(t_device_feature_state.id)	"5626"
device_feature_id	"3d6fe393-b942-44d3-bd1c-d7d9204bd547"
feature_name	"Eclairage On/Off"
device_name	"Ampoule Chambre Romélie "
137	
COUNT(t_device_feature_state.id)	"5424"
device_feature_id	"38ecaa9d-b148-410b-9e3a-542606044b23"
feature_name	"Intensité du signal"
device_name	"Router Chambre Parents"
138	
COUNT(t_device_feature_state.id)	"5258"
device_feature_id	"f4216d19-eaee-4455-ad09-de95f164aaa4"
feature_name	"Intensité du signal"
device_name	"Router Jardin"
139	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"00765e20-5323-4886-a40e-8a4349e1971d"
feature_name	"Tension moyenne"
device_name	"Ouverture Baie Vitrée Piscine"
140	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"512b2fc2-bc64-407f-83b2-16df1b4ece65"
feature_name	"Intensité du signal"
device_name	"Ouverture Baie Vitrée Piscine"
141	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"576af393-7248-4f70-830a-9727a6ca8729"
feature_name	"Batterie"
device_name	"Ouverture Baie Vitrée Piscine"
142	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"9a1cb18d-aff6-4525-8320-755fc7a0206f"
feature_name	"Température"
device_name	"Ouverture Baie Vitrée Piscine"
143	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"b60c2eec-7913-475b-a146-7bb96e3fdf08"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Baie Vitrée Piscine"
144	
COUNT(t_device_feature_state.id)	"4333"
device_feature_id	"0e8bb70b-12a5-4adc-84a3-4553e15fd833"
feature_name	"Température"
device_name	"Ouverture Porte Garage"
145	
COUNT(t_device_feature_state.id)	"4333"
device_feature_id	"883640f9-4943-4414-ae0f-52b75d97625f"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Porte Garage"
146	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"375a7fb9-c185-4a3a-bbef-9d66a43f04da"
feature_name	"Tension moyenne"
device_name	"Ouverture Porte Entrée"
147	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"5203a6d0-f66a-434c-b8ea-2cddd5aa2707"
feature_name	"Batterie"
device_name	"Ouverture Porte Entrée"
148	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"7b5abe18-8072-4c7d-98f4-111c5b046f63"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Porte Entrée"
149	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"9c0914bd-b7a1-49bf-b8dd-3872148b03c6"
feature_name	"Intensité du signal"
device_name	"Ouverture Porte Entrée"
150	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"be2ab703-1db6-43a7-af7b-1528b6483963"
feature_name	"Température"
device_name	"Ouverture Porte Entrée"
151	
COUNT(t_device_feature_state.id)	"2887"
device_feature_id	"19c1e1df-103f-4c71-bf34-ea3863622655"
feature_name	"Intensité du signal"
device_name	"Inter 6 boutons"
152	
COUNT(t_device_feature_state.id)	"2887"
device_feature_id	"31992d38-eb95-46dc-8055-261ccb0575b7"
feature_name	"Batterie"
device_name	"Inter 6 boutons"
153	
COUNT(t_device_feature_state.id)	"2887"
device_feature_id	"9ba6c0a2-c6a2-4fde-9573-e90f50dde780"
feature_name	"Tension moyenne"
device_name	"Inter 6 boutons"
154	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"1f74c290-2ed4-4a78-9fd5-debcd326b0c3"
feature_name	"Tension moyenne"
device_name	"Ouverture Chambre Romélie"
155	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"3d2d6a20-dda3-47d7-a5a1-6aec48648310"
feature_name	"Intensité du signal"
device_name	"Ouverture Chambre Romélie"
156	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"8b2bf155-672d-42d8-82ed-438536803ba7"
feature_name	"Température"
device_name	"Ouverture Chambre Romélie"
157	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"ab7153bf-655e-4556-a8d0-c612124a78a3"
feature_name	"Batterie"
device_name	"Ouverture Chambre Romélie"
158	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"d216fafd-cf9f-4715-9c93-e5ce97d4f5d1"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Chambre Romélie"
159	
COUNT(t_device_feature_state.id)	"2703"
device_feature_id	"4ca21dd7-f049-43b4-a62c-efc94eb78368"
feature_name	"Température"
device_name	"Ouverture Portail Garage"
160	
COUNT(t_device_feature_state.id)	"2703"
device_feature_id	"a69b7fe2-6908-4d39-bdde-1eef83c68138"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Portail Garage"
161	
COUNT(t_device_feature_state.id)	"2682"
device_feature_id	"6171088f-e1cf-4ea6-ac7a-39bdb25c14a5"
feature_name	"Eclairage On/Off"
device_name	"Ampoule Chambre Parents "
162	
COUNT(t_device_feature_state.id)	"2673"
device_feature_id	"013529b5-43c8-4dd0-ad01-d3c67dbcbbae"
feature_name	"Intensité du signal"
device_name	"Inter 4 Salon TV"
163	
COUNT(t_device_feature_state.id)	"2673"
device_feature_id	"55b0af49-df11-4982-98fa-86772044c37c"
feature_name	"Batterie"
device_name	"Inter 4 Salon TV"
164	
COUNT(t_device_feature_state.id)	"2673"
device_feature_id	"b4a995ae-1b06-4351-afaa-63085f4932a7"
feature_name	"Tension moyenne"
device_name	"Inter 4 Salon TV"
165	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"097816b1-2763-4200-9235-e93d863815e5"
feature_name	"Tension moyenne"
device_name	"Ouverture Porte-fenêtre Salon"
166	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"1051d11e-86be-40ff-8948-41c29440af44"
feature_name	"Batterie"
device_name	"Ouverture Porte-fenêtre Salon"
167	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"96052a09-8a06-4060-8d54-9a9d02d884e8"
feature_name	"Température"
device_name	"Ouverture Porte-fenêtre Salon"
168	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"cd7ef5db-ff10-426e-8b2e-49b5e4bd5172"
feature_name	"Intensité du signal"
device_name	"Ouverture Porte-fenêtre Salon"
169	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"e1e8254f-02e4-4488-9bed-1153fffa54fe"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Porte-fenêtre Salon"
170	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"2a18625d-cad0-4c20-bc24-fdbb0d664f5d"
feature_name	"Intensité du signal"
device_name	"Ouverture Salle de Bain"
171	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"2d3c8196-84bd-4d9c-b6e0-bb48f2276bc9"
feature_name	"Température"
device_name	"Ouverture Salle de Bain"
172	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"5d15b405-d447-4c73-8d6c-5df0a92dfd27"
feature_name	"Tension moyenne"
device_name	"Ouverture Salle de Bain"
173	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"68fd9390-c8b5-422c-a4cf-eb2523cf8e5d"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Salle de Bain"
174	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"c653c383-7a9a-4d3a-bb97-a9b0e806baf3"
feature_name	"Batterie"
device_name	"Ouverture Salle de Bain"
175	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"0db3ddcb-65d1-4237-8d88-1f0f251ee94d"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Baie vitrée TV"
176	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"56ad57e8-8a26-48e0-a821-8617d209e135"
feature_name	"Batterie"
device_name	"Ouverture Baie vitrée TV"
177	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"7d2e5b01-abba-4df5-920c-3cbed27a3399"
feature_name	"Tension moyenne"
device_name	"Ouverture Baie vitrée TV"
178	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"ba608422-c80d-4dc4-97b4-6b17399d0ca6"
feature_name	"Température"
device_name	"Ouverture Baie vitrée TV"
179	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"d830be06-b962-4c44-960d-954ab9fa4505"
feature_name	"Intensité du signal"
device_name	"Ouverture Baie vitrée TV"
180	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"1bb0feb8-dcd9-4b11-ade5-70224f5fefc1"
feature_name	"Batterie"
device_name	"Ouverture Chambre d'ami"
181	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"8faaafbf-c33d-4737-93c3-4e290228460a"
feature_name	"Tension moyenne"
device_name	"Ouverture Chambre d'ami"
182	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"a0641142-c27e-4391-b9f3-17fb5c13a6da"
feature_name	"Température"
device_name	"Ouverture Chambre d'ami"
183	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"ad7ec7e0-cf9a-4d81-9890-d97566788385"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Chambre d'ami"
184	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"da4dc8c1-1626-4a92-87a7-c617ff423c9f"
feature_name	"Intensité du signal"
device_name	"Ouverture Chambre d'ami"
185	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"06fae8d0-7eee-4c1c-8e22-c1c5f33e23ab"
feature_name	"Tension moyenne"
device_name	"Ouverture Fenetre Bureau"
186	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"6d75528b-390b-40de-aeb8-4ddecc67bb8a"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Fenetre Bureau"
187	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"a62dd698-650c-419a-bcf9-6825a13d5b45"
feature_name	"Batterie"
device_name	"Ouverture Fenetre Bureau"
188	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"d3df4482-c4ff-47e3-b298-d95b8ec98a69"
feature_name	"Intensité du signal"
device_name	"Ouverture Fenetre Bureau"
189	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"eab015b9-c234-4c6a-af20-017f27b3fa8f"
feature_name	"Température"
device_name	"Ouverture Fenetre Bureau"
190	
COUNT(t_device_feature_state.id)	"2584"
device_feature_id	"392ac79b-dd72-4bf6-b7bb-e4b6b6ebc6ae"
feature_name	"Tension moyenne"
device_name	"Fuite Douche"
191	
COUNT(t_device_feature_state.id)	"2584"
device_feature_id	"3d77971a-67df-4999-bf11-3ece2632c3dd"
feature_name	"Fuite (Oui/Non)"
device_name	"Fuite Douche"
192	
COUNT(t_device_feature_state.id)	"2584"
device_feature_id	"ff996d3b-3f6b-434a-aa4d-650079dadda3"
feature_name	"Batterie"
device_name	"Fuite Douche"
193	
COUNT(t_device_feature_state.id)	"2521"
device_feature_id	"21fe9f89-c69d-44a3-9cfe-dcb49d2ed3a2"
feature_name	"Intensité du signal"
device_name	"Ouverture Chambre Ruben"
194	
COUNT(t_device_feature_state.id)	"2521"
device_feature_id	"95a8078a-dbfb-4539-ac65-f6ffb5b26014"
feature_name	"Tension moyenne"
device_name	"Ouverture Chambre Ruben"
195	
COUNT(t_device_feature_state.id)	"2521"
device_feature_id	"d18aac7e-5f7e-44a2-bbc6-fe47d7f3e8f7"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Chambre Ruben"
196	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"2783010e-0702-4e4b-b16a-7b5a8db611ab"
feature_name	"Batterie"
device_name	"Ouverture Chambre Parents"
197	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"2f7b00ca-0a3d-4ebf-b291-70a13f410183"
feature_name	"Ouverture (Oui/Non)"
device_name	"Ouverture Chambre Parents"
198	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"cd63f74a-2cb2-425e-a625-fc1ecf0e8600"
feature_name	"Intensité du signal"
device_name	"Ouverture Chambre Parents"
199	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"d1d918b0-3905-480b-ae4d-3d019301eab6"
feature_name	"Tension moyenne"
device_name	"Ouverture Chambre Parents"
200	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"fb149148-0da8-4173-b767-4d55c85e4e6a"
feature_name	"Température"
device_name	"Ouverture Chambre Parents"
201	
COUNT(t_device_feature_state.id)	"2137"
device_feature_id	"13e702c1-6a9d-492d-bd65-d8d6ccb60f31"
feature_name	"Luminosité éclairage"
device_name	"Ampoule Arrière Cuisine "
202	
COUNT(t_device_feature_state.id)	"2137"
device_feature_id	"398e2714-ce5c-434b-8a73-0185ae1d2eed"
feature_name	"Température éclairage"
device_name	"Ampoule Arrière Cuisine "
203	
COUNT(t_device_feature_state.id)	"2137"
device_feature_id	"a86212c3-be53-49ad-a5b9-602783e35394"
feature_name	"Eclairage On/Off"
device_name	"Ampoule Arrière Cuisine "
204	
COUNT(t_device_feature_state.id)	"2034"
device_feature_id	"36d870c8-bb68-41db-a822-e4df1e524a96"
feature_name	"Humidité du sol"
device_name	"Capteur Humidité Sol"
205	
COUNT(t_device_feature_state.id)	"1710"
device_feature_id	"5986cdf2-c257-48b2-97ba-aa5a64d25aef"
feature_name	"Luminosité éclairage"
device_name	"Ampoule Chambre d'ami"
206	
COUNT(t_device_feature_state.id)	"1710"
device_feature_id	"cb288d6b-7acd-466a-be04-e6ee06543d5c"
feature_name	"Eclairage On/Off"
device_name	"Ampoule Chambre d'ami"
207	
COUNT(t_device_feature_state.id)	"1710"
device_feature_id	"dfda8172-4684-4bc1-b97f-aa3be9a8e5c6"
feature_name	"Température éclairage"
device_name	"Ampoule Chambre d'ami"
208	
COUNT(t_device_feature_state.id)	"1710"
device_feature_id	"e8a816ab-f80f-4b64-abf1-00d3ba92bf30"
feature_name	"Intensité du signal"
device_name	"Ampoule Chambre d'ami"
209	
COUNT(t_device_feature_state.id)	"1130"
device_feature_id	"66114b90-2ff0-479c-b92a-fc1c315b265f"
feature_name	"Eclairage On/Off"
device_name	"Ampoule Bureau 2"
210	
COUNT(t_device_feature_state.id)	"809"
device_feature_id	"7bf1300c-dd9c-4a88-a090-bbb1e24fa4ce"
feature_name	"Intensité du signal"
device_name	"Vanne Arrosage "
211	
COUNT(t_device_feature_state.id)	"809"
device_feature_id	"b31a31d0-0635-4925-ad17-8cf22813320e"
feature_name	"Batterie"
device_name	"Vanne Arrosage "
212	
COUNT(t_device_feature_state.id)	"469"
device_feature_id	"24347efa-7b8b-4129-9e60-44c67c832ce9"
feature_name	"Intensité du signal"
device_name	"Router Chambre d'amis"
213	
COUNT(t_device_feature_state.id)	"469"
device_feature_id	"d9509f28-e5cf-4fdb-88f2-db4975bcc4bb"
feature_name	"Batterie faible (Oui/Non)"
device_name	"Fuite Douche"
214	
COUNT(t_device_feature_state.id)	"435"
device_feature_id	"276b9318-d220-4f8d-8724-b1f6649ca67f"
feature_name	"Température éclairage"
device_name	"Spot Couleur Entrée"
215	
COUNT(t_device_feature_state.id)	"435"
device_feature_id	"6b91319c-46f5-4b60-ae05-542dc24d1a29"
feature_name	"Luminosité éclairage"
device_name	"Spot Couleur Entrée"
216	
COUNT(t_device_feature_state.id)	"435"
device_feature_id	"8dc26644-a6fb-4a14-a575-915eaa370ee5"
feature_name	"Eclairage On/Off"
device_name	"Spot Couleur Entrée"
217	
COUNT(t_device_feature_state.id)	"435"
device_feature_id	"9a7a1332-8c09-4921-86b6-5dea1228da39"
feature_name	"Couleur éclairage"
device_name	"Spot Couleur Entrée"
218	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"03506eca-2d2b-4d24-bd0d-ed6555d731e5"
feature_name	"Eclairage On/Off"
device_name	"Ruban LED"
219	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"2b55d5a2-6729-4eb5-92a0-6d18dc49dc08"
feature_name	"Température éclairage"
device_name	"Ruban LED"
220	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"55c34624-e6ff-40ac-af33-dacb0c2e0186"
feature_name	"Couleur éclairage"
device_name	"Ruban LED"
221	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"a6edbae5-2a21-4ae6-8c98-54501c7d5176"
feature_name	"Intensité du signal"
device_name	"Ruban LED"
222	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"af1bf389-e2e4-40d3-a296-7255b06848af"
feature_name	"Luminosité éclairage"
device_name	"Ruban LED"
223	
COUNT(t_device_feature_state.id)	"88"
device_feature_id	"09634c1d-a8f6-4d04-969c-27245a1d8599"
feature_name	"Consommation de la veille"
device_name	"Consommations"
224	
COUNT(t_device_feature_state.id)	"35"
device_feature_id	"5366a343-5cce-4f2f-ae77-06bfd11db50f"
feature_name	"Remplissage"
device_name	"Outils pompe piscine"
225	
COUNT(t_device_feature_state.id)	"28"
device_feature_id	"f2f59900-df9f-415a-b4e0-dd92deca7260"
feature_name	"Clic bouton"
device_name	"Bouton simple Garage"
226	
COUNT(t_device_feature_state.id)	"9"
device_feature_id	"f92149a1-5b7a-4c01-ad5f-bf29cc29f1aa"
feature_name	"SURVEILLANCE - etat"
device_name	"SURVEILLANCE"
227	
COUNT(t_device_feature_state.id)	"8"
device_feature_id	"6c7cd64f-d620-4128-a69b-9f774294e3be"
feature_name	"Intrusion (état) "
device_name	"Intrusion"
228	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"10e6207a-7756-49aa-81c5-9132cd5afd1a"
feature_name	"Intensité du signal"
device_name	"Bouton Chevet Sophie"
229	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"1b011336-3fd3-4adf-bb6d-adbfd38e6a40"
feature_name	"Intensité du signal"
device_name	"Prise Lumière Garage"
230	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"1e154dba-8167-4fe1-9b34-212ff7849484"
feature_name	"Puissance consommée"
device_name	"Prise Lumière Garage"
231	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"3533b52f-2641-447f-95e2-adc18119810c"
feature_name	"Intensité du signal"
device_name	"Fuite Salle de bain"
232	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"36b7b113-3d8c-4ff4-bc6d-b48ff66145cd"
feature_name	"Température"
device_name	"Bouton Chevet Sophie"
233	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"4498cb4a-6504-4da7-80bb-314d27d06dcd"
feature_name	"Batterie"
device_name	"Bouton Chevet Sophie"
234	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"6327eddc-0b1c-4463-89d4-e7f182523ef1"
feature_name	"Mode de contrôle d'accès"
device_name	"Prise Lumière Garage"
235	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"71656496-df24-466a-aaeb-e923b129ae6e"
feature_name	"Energie consommée"
device_name	"Prise Lumière Garage"
236	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"7478b88e-b406-4970-a24d-cf83ad23ef39"
feature_name	"Batterie"
device_name	"Fuite Salle de bain"
237	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"78fff789-1c83-469c-8583-e51674642c8d"
feature_name	"Marche forcée"
device_name	"Outils pompe piscine"
238	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"8e5d8cb8-f770-453f-9bbf-019d36df8bd9"
feature_name	"Tension moyenne"
device_name	"Prise Lumière Garage"
239	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"b0a51dd3-ae5f-46ef-b99c-066945706a91"
feature_name	"Intensité consommée"
device_name	"Prise Lumière Garage"
240	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"bc653819-ae23-4e74-848c-9d4f86fd9396"
feature_name	"Température"
device_name	"Fuite Salle de bain"
241	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"c7248901-580c-416d-b189-376cc1bdc68f"
feature_name	"Tension moyenne"
device_name	"Bouton Chevet Sophie"
242	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"e87e4c3f-44ed-445a-a7fd-fee4df06028c"
feature_name	"Commutateur"
device_name	"Prise Lumière Garage"
243	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"fa383e7b-9749-41eb-83cf-af021c3c39ca"
feature_name	"Tension moyenne"
device_name	"Fuite Salle de bain"
244	
COUNT(t_device_feature_state.id)	"4"
device_feature_id	"7a1602d9-e033-426b-b5d3-11ec78ee6a27"
feature_name	"Alarme Rouge - Volume"
device_name	"Alarme Rouge - Volume"
245	
COUNT(t_device_feature_state.id)	"4"
device_feature_id	"9930f2eb-78d8-470a-ba1c-9fe573dd3095"
feature_name	"SURVEILLANCE - toggle"
device_name	"SURVEILLANCE"
246	
COUNT(t_device_feature_state.id)	"2"
device_feature_id	"2e968fd5-a318-4a63-9856-e9210da9bf8d"
feature_name	"Pompe (ETAT)"
device_name	"Outils pompe piscine"

Je constate que la partie consommation électrique de la maison (utilisée via Nodered avec l’api de Solaredge) est ce qui envoie beaucoup de données. Parès je sais pas si c’est « trop » ou non !

pierre-gilles · Juillet 19, 2024, 7:29

Top merci d’avoir exécuté la requête !

Maintenant qu’on connait les appareils les plus « bavards », tu peux regarder à quelle fréquence ils envoient des données à Gladys :

SELECT * FROM t_device_feature_state 
WHERE device_feature_id = 'REMPLACE_AVEC_UN_ID'
ORDER BY created_at DESC
LIMIT 100

Cela te donnera les 100 derniers états d’une feature. Commence par la feature la plus bavarde ( 237016de-746c-4ba5-9e75-7dd7f801a391 ), et ensuite remonte progressivement.

Pour chacune, l’idée est de trouver à quel interval Gladys reçoit de la data, et de voir si certaines ne sont pas trop bavardes

guim31 · Juillet 19, 2024, 11:26

Voilà le résultat de la requete que tu m’as donné :

	
0	
id	"da386e55-4d6d-4818-8e4d-8bccbeb06217"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:12:00.359 +00:00"
updated_at	"2024-07-18 19:12:00.359 +00:00"
1	
id	"7291c4c1-ae30-4afc-bbd4-8f3e66ff5d50"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:58.906 +00:00"
updated_at	"2024-07-18 19:11:58.906 +00:00"
2	
id	"0c45c908-5c50-498d-bd42-353dbefc01f8"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:58.889 +00:00"
updated_at	"2024-07-18 19:11:58.889 +00:00"
3	
id	"94a831a5-043a-4158-8778-aea7073a2b6b"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:55.967 +00:00"
updated_at	"2024-07-18 19:11:55.967 +00:00"
4	
id	"76ee29f3-f832-44b0-8390-e779f07cfb75"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:53.555 +00:00"
updated_at	"2024-07-18 19:11:53.555 +00:00"
5	
id	"b7eeec37-2a13-42da-bf45-8edbe0277a11"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:53.539 +00:00"
updated_at	"2024-07-18 19:11:53.539 +00:00"
6	
id	"0631bc75-fad1-4713-a10c-922684d1e8f2"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:48.177 +00:00"
updated_at	"2024-07-18 19:11:48.177 +00:00"
7	
id	"60a312e4-53e4-4646-88e7-c051a5fac9aa"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:48.163 +00:00"
updated_at	"2024-07-18 19:11:48.163 +00:00"
8	
id	"ae24f6cf-8c27-40a2-a345-43a0ce40ce0b"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:42.831 +00:00"
updated_at	"2024-07-18 19:11:42.831 +00:00"
9	
id	"5fea2f51-e451-4fbd-b4a2-fde3a150234d"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:42.817 +00:00"
updated_at	"2024-07-18 19:11:42.817 +00:00"
10	
id	"692f397e-f9a3-4c55-851b-04420dae15b8"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:37.442 +00:00"
updated_at	"2024-07-18 19:11:37.442 +00:00"
11	
id	"ad6cefa4-7d14-4bcd-a161-c9129eeb7773"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:37.426 +00:00"
updated_at	"2024-07-18 19:11:37.426 +00:00"
12	
id	"8b87f330-16c9-4357-ad41-4c79e624ee8f"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:32.090 +00:00"
updated_at	"2024-07-18 19:11:32.090 +00:00"
13	
id	"6beadd39-e122-459f-ae3a-68441d462029"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:32.075 +00:00"
updated_at	"2024-07-18 19:11:32.075 +00:00"
14	
id	"34e53295-c05d-44f0-847c-a490ac94150c"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:29.660 +00:00"
updated_at	"2024-07-18 19:11:29.660 +00:00"
15	
id	"32d12777-375f-4a43-93b8-9cc0b95676d3"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:26.720 +00:00"
updated_at	"2024-07-18 19:11:26.720 +00:00"
16	
id	"e77a9673-dba7-435f-bde2-7fc1f2d8c821"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:26.704 +00:00"
updated_at	"2024-07-18 19:11:26.704 +00:00"
17	
id	"b9ac1c95-b075-4309-9dcc-a7504d4e7568"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:21.369 +00:00"
updated_at	"2024-07-18 19:11:21.369 +00:00"
18	
id	"1bccbd7e-4221-4daa-8cd0-2a1ecd3e87c0"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:21.350 +00:00"
updated_at	"2024-07-18 19:11:21.350 +00:00"
19	
id	"f687f2ca-440e-4fdf-9005-2da32ee7133e"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:16.012 +00:00"
updated_at	"2024-07-18 19:11:16.012 +00:00"
20	
id	"265ac03f-6409-45a3-a451-0aa197efe7bc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:15.983 +00:00"
updated_at	"2024-07-18 19:11:15.983 +00:00"
21	
id	"dc5d1e07-75f7-4ca0-8732-e12e9b65f644"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:12.033 +00:00"
updated_at	"2024-07-18 19:11:12.033 +00:00"
22	
id	"4294cc52-7af3-4723-9313-aa15d03ada26"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:10.648 +00:00"
updated_at	"2024-07-18 19:11:10.648 +00:00"
23	
id	"d271beb8-1443-4932-8c99-cfd5580ca422"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:10.630 +00:00"
updated_at	"2024-07-18 19:11:10.630 +00:00"
24	
id	"d68c4c0e-eecb-4feb-9da2-6473f1c95af8"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:05.288 +00:00"
updated_at	"2024-07-18 19:11:05.288 +00:00"
25	
id	"20d15b93-aeac-4aea-a418-8284bfc6a08d"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:05.268 +00:00"
updated_at	"2024-07-18 19:11:05.268 +00:00"
26	
id	"1d9483f2-79d9-4de3-b27e-3bf8db281518"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:03.342 +00:00"
updated_at	"2024-07-18 19:11:03.342 +00:00"
27	
id	"9747f8df-2bae-4a54-a7f8-f6124e360bc5"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:59.974 +00:00"
updated_at	"2024-07-18 19:10:59.974 +00:00"
28	
id	"1b7afd68-5f06-445b-947f-2e35568b7f72"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:59.956 +00:00"
updated_at	"2024-07-18 19:10:59.956 +00:00"
29	
id	"0bc8a2a0-995d-4f77-bc0f-14153f9dd58e"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:54.572 +00:00"
updated_at	"2024-07-18 19:10:54.572 +00:00"
30	
id	"2228c1ed-f22c-4f64-ac4e-79fc22e1817c"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:54.554 +00:00"
updated_at	"2024-07-18 19:10:54.554 +00:00"
31	
id	"a1ccd984-e1b1-45d9-b834-c03dfce55861"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:49.207 +00:00"
updated_at	"2024-07-18 19:10:49.207 +00:00"
32	
id	"656a34ce-708b-46a5-8133-9bdeaa99cd2a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:49.189 +00:00"
updated_at	"2024-07-18 19:10:49.189 +00:00"
33	
id	"8d2b9891-4178-40a5-a4d3-7b4ba0feccd6"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:45.800 +00:00"
updated_at	"2024-07-18 19:10:45.800 +00:00"
34	
id	"959403e6-1779-41e7-b91a-15d9fdbad176"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:43.848 +00:00"
updated_at	"2024-07-18 19:10:43.848 +00:00"
35	
id	"c12cd9f2-6adb-4d2c-92fa-f7e7d5b31f33"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:43.829 +00:00"
updated_at	"2024-07-18 19:10:43.829 +00:00"
36	
id	"b119a70b-cf4f-43b4-9303-c746f8d7d252"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:38.484 +00:00"
updated_at	"2024-07-18 19:10:38.484 +00:00"
37	
id	"18e3e71e-c7f1-4010-ba64-ef57d169d3cf"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:38.465 +00:00"
updated_at	"2024-07-18 19:10:38.465 +00:00"
38	
id	"4b9d8457-b7c5-46f4-af99-844b6edfe72f"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:33.120 +00:00"
updated_at	"2024-07-18 19:10:33.120 +00:00"
39	
id	"5b7b7094-6541-450f-a95a-dc1c61da668a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:33.104 +00:00"
updated_at	"2024-07-18 19:10:33.104 +00:00"
40	
id	"c4e1ac1b-522c-40f2-a16c-e63aa3e2ebdc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:27.766 +00:00"
updated_at	"2024-07-18 19:10:27.766 +00:00"
41	
id	"30220cd9-61ff-47eb-9930-fd2cb53d2074"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:27.749 +00:00"
updated_at	"2024-07-18 19:10:27.749 +00:00"
42	
id	"83abc19f-9ffb-4b7b-904d-634a63228ef2"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:25.695 +00:00"
updated_at	"2024-07-18 19:10:25.695 +00:00"
43	
id	"adb25582-c5f0-4d28-bef5-9b7e341bb1fc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:22.399 +00:00"
updated_at	"2024-07-18 19:10:22.399 +00:00"
44	
id	"eaeccac5-8fdd-40eb-b1d9-172e655a0895"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:22.388 +00:00"
updated_at	"2024-07-18 19:10:22.388 +00:00"
45	
id	"3e9e5ccd-926c-4cb8-9514-a81d25517268"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:17.053 +00:00"
updated_at	"2024-07-18 19:10:17.053 +00:00"
46	
id	"0b700a26-e785-4270-8829-8c2025a88c8f"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:17.038 +00:00"
updated_at	"2024-07-18 19:10:17.038 +00:00"
47	
id	"1ba9511a-fc1a-4141-8ccf-8c42943b8e04"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:11.706 +00:00"
updated_at	"2024-07-18 19:10:11.706 +00:00"
48	
id	"1a5c8174-e40d-4bba-a61b-a8016457e4fd"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:11.687 +00:00"
updated_at	"2024-07-18 19:10:11.687 +00:00"
49	
id	"399f83d3-6cb9-41ff-94d9-d80a08a636fe"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:06.335 +00:00"
updated_at	"2024-07-18 19:10:06.335 +00:00"
50	
id	"0a687a87-f2c2-4d7b-a7ac-68d4667aaf68"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:06.316 +00:00"
updated_at	"2024-07-18 19:10:06.316 +00:00"
51	
id	"55ed3d67-b045-4990-856c-3bfe25b81703"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:01.946 +00:00"
updated_at	"2024-07-18 19:10:01.946 +00:00"
52	
id	"49ce059d-bc34-4b5e-8e2e-b928dbb166e2"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:00.972 +00:00"
updated_at	"2024-07-18 19:10:00.972 +00:00"
53	
id	"5d3559c5-bc96-43f7-ab8b-c4b36acea46c"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:00.951 +00:00"
updated_at	"2024-07-18 19:10:00.951 +00:00"
54	
id	"1a5703ce-8ee1-42ba-bbb1-be3321e0d6ee"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:57.563 +00:00"
updated_at	"2024-07-18 19:09:57.563 +00:00"
55	
id	"16c9ed02-ff36-4c73-868d-5c206e02b1f6"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:55.605 +00:00"
updated_at	"2024-07-18 19:09:55.605 +00:00"
56	
id	"7f8ed872-9e21-4a9e-816b-312e64b617dc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:55.589 +00:00"
updated_at	"2024-07-18 19:09:55.589 +00:00"
57	
id	"22c62170-87f8-4cd0-8968-208ca51b4e22"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:50.245 +00:00"
updated_at	"2024-07-18 19:09:50.245 +00:00"
58	
id	"def0c52c-c6d6-465f-9ceb-e7d25b9e5acd"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:50.232 +00:00"
updated_at	"2024-07-18 19:09:50.232 +00:00"
59	
id	"2edcb314-c2f7-486c-a95a-3cd58ee86cf2"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:44.886 +00:00"
updated_at	"2024-07-18 19:09:44.886 +00:00"
60	
id	"e8ebacfb-932f-497d-8f6b-196b6aef6463"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:44.869 +00:00"
updated_at	"2024-07-18 19:09:44.869 +00:00"
61	
id	"d7f6947c-b728-4980-a76b-792e35cfbb70"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:39.549 +00:00"
updated_at	"2024-07-18 19:09:39.549 +00:00"
62	
id	"04fec33b-b306-4916-9d3b-2e2f45f7982d"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:39.528 +00:00"
updated_at	"2024-07-18 19:09:39.528 +00:00"
63	
id	"caef7087-96bc-42f3-8c2d-c471c0d0cda9"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:34.178 +00:00"
updated_at	"2024-07-18 19:09:34.178 +00:00"
64	
id	"9e2a5200-823b-4109-b4fd-a637f64d741a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:34.160 +00:00"
updated_at	"2024-07-18 19:09:34.160 +00:00"
65	
id	"f1ae32fd-652f-4c20-9b21-a47fb620b412"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:28.838 +00:00"
updated_at	"2024-07-18 19:09:28.838 +00:00"
66	
id	"ed81bdad-eaaf-43f4-8bb0-9e959ce731ff"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:28.815 +00:00"
updated_at	"2024-07-18 19:09:28.815 +00:00"
67	
id	"fd89c9b0-105c-44ce-8f2b-d273b10ada92"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:23.509 +00:00"
updated_at	"2024-07-18 19:09:23.509 +00:00"
68	
id	"80d74355-5b78-42f2-bf37-5df8519c72f5"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:23.493 +00:00"
updated_at	"2024-07-18 19:09:23.493 +00:00"
69	
id	"e1297fbf-2426-4c6a-9d9d-300712d6a652"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:18.152 +00:00"
updated_at	"2024-07-18 19:09:18.152 +00:00"
70	
id	"dee6031c-212e-4a9b-9a9a-db9ad44b8a31"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:18.135 +00:00"
updated_at	"2024-07-18 19:09:18.135 +00:00"
71	
id	"da4406d4-8183-4cba-af5b-ba754268ebcc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:12.765 +00:00"
updated_at	"2024-07-18 19:09:12.765 +00:00"
72	
id	"2e1a51da-32ba-4083-97ed-741b4753497b"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:12.746 +00:00"
updated_at	"2024-07-18 19:09:12.746 +00:00"
73	
id	"72dbf546-3caf-4fdf-85c3-b1007d3606a7"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:07.399 +00:00"
updated_at	"2024-07-18 19:09:07.399 +00:00"
74	
id	"57366838-e65c-4135-b4c1-ddcc0cf90f98"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:07.378 +00:00"
updated_at	"2024-07-18 19:09:07.378 +00:00"
75	
id	"94e4d31b-4d86-45cd-9fcd-219b9555c551"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:02.046 +00:00"
updated_at	"2024-07-18 19:09:02.046 +00:00"
76	
id	"9c1c510b-0d9e-42be-a379-debf2e5b3231"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:09:02.023 +00:00"
updated_at	"2024-07-18 19:09:02.023 +00:00"
77	
id	"048f6881-460a-478e-bf79-3729996786c9"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:56.666 +00:00"
updated_at	"2024-07-18 19:08:56.666 +00:00"
78	
id	"ed49a861-0712-4071-8685-505a5ff99655"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:56.648 +00:00"
updated_at	"2024-07-18 19:08:56.648 +00:00"
79	
id	"c4e3d331-f489-4414-9c77-ff66f98e0fa1"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:51.797 +00:00"
updated_at	"2024-07-18 19:08:51.797 +00:00"
80	
id	"b4373039-70ed-4620-853e-485a443ac40a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:51.307 +00:00"
updated_at	"2024-07-18 19:08:51.307 +00:00"
81	
id	"4c91b322-8f9d-4bff-89c0-0a093be85ab5"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:51.288 +00:00"
updated_at	"2024-07-18 19:08:51.288 +00:00"
82	
id	"dcde1a47-4aa5-4817-854f-f8af708233ba"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:45.948 +00:00"
updated_at	"2024-07-18 19:08:45.948 +00:00"
83	
id	"86fed140-de68-442b-b977-82c2086bae21"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:45.930 +00:00"
updated_at	"2024-07-18 19:08:45.930 +00:00"
84	
id	"0daa32ef-45c9-4332-a022-b5f2575878b4"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:40.597 +00:00"
updated_at	"2024-07-18 19:08:40.597 +00:00"
85	
id	"cd99bc3d-2998-493b-a0d0-fd20eb4cbdd3"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:40.575 +00:00"
updated_at	"2024-07-18 19:08:40.575 +00:00"
86	
id	"1b327df5-49b6-4296-95f2-1018adc8ce4c"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:35.245 +00:00"
updated_at	"2024-07-18 19:08:35.245 +00:00"
87	
id	"8203ea55-a7c7-458f-bda0-39d0411d3824"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:35.225 +00:00"
updated_at	"2024-07-18 19:08:35.225 +00:00"
88	
id	"c0ba2904-5520-46a8-a8be-d75cfea45bd0"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:34.257 +00:00"
updated_at	"2024-07-18 19:08:34.257 +00:00"
89	
id	"b0d73f06-1b13-4040-a4fb-193c293da917"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:29.861 +00:00"
updated_at	"2024-07-18 19:08:29.861 +00:00"
90	
id	"065f09e6-4ae6-4f2c-ac16-dd0b44ba0508"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:29.848 +00:00"
updated_at	"2024-07-18 19:08:29.848 +00:00"
91	
id	"f89af62b-47cf-49b6-a99b-dd61a49046fc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:24.509 +00:00"
updated_at	"2024-07-18 19:08:24.509 +00:00"
92	
id	"e1fd25c3-f62f-4568-89c6-4abe7219d7ed"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:24.493 +00:00"
updated_at	"2024-07-18 19:08:24.493 +00:00"
93	
id	"9466938c-dce4-4833-ab73-43fa6994793a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:19.161 +00:00"
updated_at	"2024-07-18 19:08:19.161 +00:00"
94	
id	"f0255cb4-bc12-459f-bed5-5a94ee6887b7"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:19.140 +00:00"
updated_at	"2024-07-18 19:08:19.140 +00:00"
95	
id	"f6e7bb1f-a1c4-4f0c-a99c-54261a13a132"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:13.837 +00:00"
updated_at	"2024-07-18 19:08:13.837 +00:00"
96	
id	"854c7833-e5fc-4ea8-8c61-955aba8a5517"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:13.822 +00:00"
updated_at	"2024-07-18 19:08:13.822 +00:00"
97	
id	"d82ff859-e31b-4fa0-b039-c317f039b6e9"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:08.437 +00:00"
updated_at	"2024-07-18 19:08:08.437 +00:00"
98	
id	"0cabefb7-1795-4b0c-be72-8859432468e1"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:08.420 +00:00"
updated_at	"2024-07-18 19:08:08.420 +00:00"
99	
id	"4b6a0bb6-d933-4c37-a64e-006f29de5044"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:03.097 +00:00"
updated_at	"2024-07-18 19:08:03.097 +00:00"

On voit clairement que c’est des appels ULTRA rapprochés (entre 10ms et 1000ms) surtout que la requete n’a regardé qu’un seul appareil.

Il faudrait donc j’imagine que je trouve un moyen d’espacer un peu ces données dans le temps. Peut être une piste interessante !