Gladys Plus problem

[guim31]

I think I’m going to bet everything on us calling each other one of these days, because this morning the connection was lost again… even though my Freebox shows no disconnection.
I don’t understand anything anymore!!!

I don’t know if it’s the right day… but HAPPY BIRTHDAY !!!

[pierre-gilles]

Hi @guim31

I don’t know if you managed to investigate a bit more since.

I thought of something, you can use https://healthchecks.io/ to set up a healthcheck for your Gladys.

This will let you know if Gladys itself stays connected to the internet / stays « alive ».

Concretely, you need to create a scene in Gladys that will regularly ping this service, and if Gladys stops pinging the service, you’ll receive an alert (by email by default, but other services are also available)

1. You create a « Check » (it’s free up to 20 checks)

You can customize if you want to set a shorter period, like every minute if you really want to be precise, or every 5 minutes for example.

In your case, starting with every minute / 2 minutes is maybe best to better track the status of your network/instance.

2. You copy-paste the URL:

3. You create a scene in Gladys that at the defined interval (every minute for example) will ping healthcheck using the « HTTP request » action:

this will allow you to know more precisely when/if Gladys is disconnected from the internet/down.

@guim31

I don’t know if it’s the right day… but HAPPY BIRTHDAY!!!

Thanks!!

[guim31]

So I’m going to take a closer look because 10 days ago I had a loss of connection to Gladys Plus every day… VERY annoying.

Last Tuesday there was an internet outage at my place (Freebox that was no longer synchronizing) for 2 or 3 hours.
On reboot the Freebox performed an update and from then on I noticed I no longer had disconnects… I thought everything was better! … until Saturday morning: disconnected again

[pierre-gilles]

Darn, in that case it’s indeed best to run a healthcheck every 1 minute to get precise alerts about when it goes down

[guim31]

Just had to mention it… I just went on my Gladys remotely (I’m at work) and bam, disconnected.

A container restart and I’m going to create my scene! I’ll keep you posted

EDIT: everything is in place… now I’m waiting for the next problem!

[guim31]

This morning I notice that I’m still disconnected.

On healthcheck.io it still pings correctly.

Unfortunately I can’t access more than 100 lines of history, so I can’t tell whether there was a problem at any point during the night.

[pierre-gilles]

@guim31

so I can’t tell if at some point during the night there was a problem.

Yes, you get an email if a check is down (Or any other service if you configured one, like Telegram)

[guim31]

Well, in this case, no email, nothing.

[pierre-gilles]

Ok, so no internet outage if it’s still running (or at least, no outage longer than 1 minute)

Do you have more information about when it happens? Any other logs maybe?

[guim31]

No matter how much I search, I can’t find anything at all.
What’s more, it happens quite randomly: day / night…

[pierre-gilles]

What kind of activity do you have on your instance? Ultra-intense or more like OK?

Could it be one or more sensors that are too aggressive, polluting Gladys and causing your instance to ‹ freeze ›?

Are you using the Google Home or Alexa integration?

[guim31]

So I don’t think there’s very intense activity, but I have a lot of sensors so there might be a chatty one in there. How could I find out?

I don’t use Google Home or Alexa, no.

[pierre-gilles]

@guim31

How could I find out?

We can analyze your database can you export your database and run a few queries on

[guim31]

Let’s say I can easily navigate to the DB, but to download it (wget?) and perform operations on it, I don’t know how to do that.

I can’t find the query you’re talking about…

[pierre-gilles]

You need to stop Gladys, then you can download the database with a tool like Cyberduck or FileZilla

Then you can use TablePlus to run queries on the file!

I’m trying to find the query for you

[pierre-gilles]

Help! Problème avec l'agrégation?

@lmilcent Hop c’est cadeau: SELECT COUNT(t_device_feature_state.id), device_feature_id, t_device_feature.name as feature_name, t_device.name as device_name FROM t_device_feature_state JOIN t_device_feature ON t_device_feature.id = device_feature_id JOIN t_device ON t_device.id = t_device_feature.device_id GROUP BY device_feature_id ORDER BY COUNT(t_device_feature_state.id) DESC;

[guim31]

Great, thanks for your help, I’m in the process of transferring my DB to my laptop… 24GB to transfer, it’s really crawling (thanks to FTP transfer over Wi‑Fi…).

As soon as I have that I’ll run the SQL query and paste the result here

[guim31]

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]

Great, thanks for running the query!

Now that we know the most « chatty » devices, you can check how often they send data to Gladys:

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

This will give you the last 100 states of a feature. Start with the most chatty feature (237016de-746c-4ba5-9e75-7dd7f801a391), and then work your way up.

For each one, the idea is to find at what interval Gladys receives data, and to see if some are too chatty

[guim31]

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 !