Problema con Gladys Plus

[guim31]

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]

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)

1. 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.

2. Tu copie colle l’URL :

3. 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.

@guim31

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

Merci !!

[guim31]

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]

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]

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]

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]

@guim31

donc je ne peux pas savoir si à un moment donné dans la nuit il y a eu un problème.

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]

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

[pierre-gilles]

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]

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]

¿Qué tipo de actividad tienes en tu instancia? ¿Ultra intensa o más o menos?

¿Podría ser un sensor o varios sensores demasiado agresivos que contaminan a Gladys y hacen que tu instancia se «congele»?

¿Usas la integración de Google Home o Alexa?

[guim31]

No creo que haya una actividad ultra intensa, pero tengo muchos sensores, así que quizá haya un cotilla ahí dentro. ¿Cómo puedo saberlo?

No uso ni Google Home ni Alexa.

[pierre-gilles]

@guim31

¿Cómo podré saberlo?

Podemos analizar tu base de datos ¿Sabes extraer tu base de datos y hacer algunas consultas?

Compartí una consulta SQL en el foro

[guim31]

Digamos que sé navegar fácilmente hasta la base de datos, pero para descargarla (¿wget?) y realizar operaciones sobre ella, no sé cómo hacerlo.

No consigo encontrar la consulta de la que hablas…

[pierre-gilles]

Hay que detener a Gladys, luego puedes descargar la base de datos con una herramienta como Cyberduck o FileZilla

¡Luego puedes usar TablePlus para hacer consultas en el archivo!

Estoy tratando de encontrarte la consulta

[pierre-gilles]

¡Ayuda! ¿Problema con la agregación?

@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]

¡Genial, gracias por tu ayuda! Estoy transfiriendo mi base de datos a mi portátil… 24 GB de transferencia, va muy lento (gracias al FTP sobre WiFi…).

En cuanto lo tenga, ejecuto la consulta SQL y pego el resultado aquí.

[guim31]

Pego aquí el resultado de la consulta (en formato JSON, lo siento, no encontré mejor manera de pegarlo en el foro):

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

Me doy cuenta de que la parte del consumo eléctrico de la casa (utilizada a través de Nodered con la API de Solaredge) es lo que envía muchos datos. Aunque no sé si es « demasiado » o no.

[pierre-gilles]

¡Muchas gracias por haber ejecutado la consulta!

Ahora que conocemos los dispositivos más « habituales », puedes ver con qué frecuencia envían datos a Gladys:

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

Esto te dará los 100 últimos estados de una característica. Empieza por la característica más habitual (237016de-746c-4ba5-9e75-7dd7f801a391) y luego ve subiendo progresivamente.

Para cada una, la idea es encontrar a qué intervalo Gladys recibe datos y ver si algunas no son demasiado habituales.

[guim31]

Aquí está el resultado de la consulta que me diste:

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

Se ve claramente que son llamadas ULTRA cercanas (entre 10ms y 1000ms), especialmente porque la consulta solo miró un solo dispositivo.

Por lo tanto, imagino que necesito encontrar una manera de espaciar un poco estos datos en el tiempo. ¡Quizás una pista interesante!