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 !!! 
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)
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.
this will allow you to know more precisely when/if Gladys is disconnected from the internet/down.
Thanks!!
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 
Darn, in that case it’s indeed best to run a healthcheck every 1 minute to get precise alerts about when it goes down
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!
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.
Yes, you get an email if a check is down (Or any other service if you configured one, like Telegram)
Well, in this case, no email, nothing.
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?
No matter how much I search, I can’t find anything at all.
What’s more, it happens quite randomly: day / night…
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?
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.
We can analyze your database can you export your database and run a few queries on
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… 
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
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
I’m pasting the query result here (in JSON format, sorry I couldn’t find a better way to paste it on the forum):
0
COUNT(t_device_feature_state.id) "2709800"
device_feature_id "237016de-746c-4ba5-9e75-7dd7f801a391"
feature_name "Power consumed"
device_name "Mesure Conso"
1
COUNT(t_device_feature_state.id) "2709800"
device_feature_id "5c6f6494-dcf7-4eea-9f5f-1f2f4ea29083"
feature_name "Signal strength"
device_name "Mesure Conso"
2
COUNT(t_device_feature_state.id) "2709800"
device_feature_id "ad6d2942-a329-4a04-8cd3-5f6328dcd0d2"
feature_name "Average voltage"
device_name "Mesure Conso"
3
COUNT(t_device_feature_state.id) "2709799"
device_feature_id "34e1765d-a24b-46f1-92db-754062b84567"
feature_name "Consumed intensity"
device_name "Mesure Conso"
4
COUNT(t_device_feature_state.id) "2709799"
device_feature_id "f698ae49-fb13-430c-8211-8038157a1890"
feature_name "Energy consumed"
device_name "Mesure Conso"
5
COUNT(t_device_feature_state.id) "370112"
device_feature_id "5a228014-4a17-4481-9c20-9a2b5ca2edd5"
feature_name "Switch"
device_name "Prise NASDOURY"
6
COUNT(t_device_feature_state.id) "370112"
device_feature_id "5e4ce261-7975-4e17-94f7-b1a7a1b4667f"
feature_name "NAS Consumption"
device_name "Prise NASDOURY"
7
COUNT(t_device_feature_state.id) "369156"
device_feature_id "6062d7cd-2117-46cb-a05e-977f9f8c2834"
feature_name "Signal strength"
device_name "Garage Portal"
8
COUNT(t_device_feature_state.id) "369156"
device_feature_id "b73fa27e-8782-46ad-a535-bd12ed11380c"
feature_name "Switch"
device_name "Garage Portal"
9
COUNT(t_device_feature_state.id) "367875"
device_feature_id "b53bd970-339c-42c6-bc10-c5c6ac063a55"
feature_name "Switch"
device_name "Sliding Portal"
10
COUNT(t_device_feature_state.id) "255295"
device_feature_id "4bc897ed-684a-42e2-ae5b-6e97d28798af"
feature_name "Consumed intensity"
device_name "Fridge"
11
COUNT(t_device_feature_state.id) "255295"
device_feature_id "9bf31899-f6d7-4639-9bf0-54ce43ac1e8d"
feature_name "Energy consumed"
device_name "Fridge"
12
COUNT(t_device_feature_state.id) "255295"
device_feature_id "b94bc1eb-780f-4057-81f7-a8794f2295d5"
feature_name "Fridge Power"
device_name "Fridge"
13
COUNT(t_device_feature_state.id) "255295"
device_feature_id "eab06631-6e85-447b-8d14-55c56838dadb"
feature_name "Switch"
device_name "Fridge"
14
COUNT(t_device_feature_state.id) "187123"
device_feature_id "275650f9-084e-4e55-b014-17ab6efd9017"
feature_name "Power consumed"
device_name "Laundry Socket"
15
COUNT(t_device_feature_state.id) "187123"
device_feature_id "8b67cea5-64b9-435a-94c6-b80d9c4e446b"
feature_name "Signal strength"
device_name "Laundry Socket"
16
COUNT(t_device_feature_state.id) "187123"
device_feature_id "a3971f66-6994-47d7-9ee1-0fa97892ff28"
feature_name "Average voltage"
device_name "Laundry Socket"
17
COUNT(t_device_feature_state.id) "187123"
device_feature_id "ad73644b-c4b7-48ac-811d-416fde00ab5e"
feature_name "Energy consumed"
device_name "Laundry Socket"
18
COUNT(t_device_feature_state.id) "187123"
device_feature_id "c0af51c9-c569-456b-bebd-d72dbd9246c5"
feature_name "Switch"
device_name "Laundry Socket"
19
COUNT(t_device_feature_state.id) "187123"
device_feature_id "ebe8d0e6-8ec2-4241-8c4f-7bb51865b1c9"
feature_name "Consumed intensity"
device_name "Laundry Socket"
20
COUNT(t_device_feature_state.id) "176758"
device_feature_id "60d8d1c4-ea6a-4ee5-a0a4-0bba36c4f195"
feature_name "Energy consumed"
device_name "🌀 Pool Pump "
21
COUNT(t_device_feature_state.id) "176758"
device_feature_id "897855fb-4604-4dbe-926c-2509cb4ff5a8"
feature_name "Switch"
device_name "🌀 Pool Pump "
22
COUNT(t_device_feature_state.id) "176758"
device_feature_id "8e3bc76b-460e-4a69-8599-6b1a04661068"
feature_name "Pool Pump Consumption"
device_name "🌀 Pool Pump "
23
COUNT(t_device_feature_state.id) "169718"
device_feature_id "03688620-b18e-44bb-8715-41ec7c807dd7"
feature_name "Signal strength"
device_name "Straightener Socket"
24
COUNT(t_device_feature_state.id) "169718"
device_feature_id "254b7fc5-6d2f-455d-8614-fcd4f665f86e"
feature_name "Average voltage"
device_name "Straightener Socket"
25
COUNT(t_device_feature_state.id) "169718"
device_feature_id "62a31453-74cc-4aba-bbef-a540cec4bd5c"
feature_name "Consumed intensity"
device_name "Straightener Socket"
26
COUNT(t_device_feature_state.id) "169718"
device_feature_id "d0021da7-6b04-483b-8b76-b27241af64a2"
feature_name "Switch"
device_name "Straightener Socket"
27
COUNT(t_device_feature_state.id) "169718"
device_feature_id "db52b727-7137-49b3-9175-11104f2f73b4"
feature_name "Power consumed"
device_name "Straightener Socket"
28
COUNT(t_device_feature_state.id) "169718"
device_feature_id "dea897e2-f877-4e31-9b97-997118d3c687"
feature_name "Energy consumed"
device_name "Straightener Socket"
29
COUNT(t_device_feature_state.id) "129776"
device_feature_id "1c2bc447-7bbd-4eff-9755-a8e360316739"
feature_name "PV Production (kWh)"
device_name "PV Production"
30
COUNT(t_device_feature_state.id) "129776"
device_feature_id "49d9e7d3-8c6f-4fdd-9ca8-745b4dcd10be"
feature_name "House Consumption (kWh)"
device_name "House Consumption"
31
COUNT(t_device_feature_state.id) "129757"
device_feature_id "6f30443c-8aad-48bd-96c5-391730392abd"
feature_name "Grid resale"
device_name "Grid Resale Usage"
32
COUNT(t_device_feature_state.id) "129757"
device_feature_id "86b1d2cd-c539-4fad-b398-95bc691ff27a"
feature_name "EDF Grid (kWh)"
device_name "Grid Consumption Usage"
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 "Printer"
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 "Child safety"
device_name "Straightener Socket"
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 "Switch"
device_name "NUC Socket"
42
COUNT(t_device_feature_state.id) "109482"
device_feature_id "37fe54f3-8eca-420f-b520-50b2cd29bb68"
feature_name "NUC Consumption"
device_name "NUC Socket"
43
COUNT(t_device_feature_state.id) "102984"
device_feature_id "d3a07fa5-03d3-4e4e-b083-152bd217bc5f"
feature_name "Presence"
device_name "Inverter"
44
COUNT(t_device_feature_state.id) "87635"
device_feature_id "d192de0d-8268-44ad-a9e6-ae44867e095b"
feature_name "Energy consumed"
device_name "Guinguette Socket"
45
COUNT(t_device_feature_state.id) "87635"
device_feature_id "e15cf56b-83e9-4eb9-b13e-ecb3956107cf"
feature_name "Power consumed"
device_name "Guinguette Socket"
46
COUNT(t_device_feature_state.id) "80935"
device_feature_id "108a0efc-944a-49a5-821c-ff8cbc918989"
feature_name "Lighting temperature"
device_name "Guilhem Nightstand"
47
COUNT(t_device_feature_state.id) "80935"
device_feature_id "655e61ca-0d65-4f97-b8a1-6e7272febec4"
feature_name "Lighting brightness"
device_name "Guilhem Nightstand"
48
COUNT(t_device_feature_state.id) "80935"
device_feature_id "ec820624-b322-47ee-b0d1-9818756facc0"
feature_name "Lighting On/Off"
device_name "Guilhem Nightstand"
49
COUNT(t_device_feature_state.id) "78001"
device_feature_id "4cbb5b61-d909-46ad-ae93-b1c2e85ef838"
feature_name "Lighting brightness"
device_name "Sophie Nightstand"
50
COUNT(t_device_feature_state.id) "78001"
device_feature_id "4d17ad37-c266-4b69-9cdb-e2ec47daede4"
feature_name "Light On/Off"
device_name "Sophie's Bedside"
51
COUNT(t_device_feature_state.id) "78001"
device_feature_id "89867f20-0f3a-4019-8b1f-5468ca23cec4"
feature_name "Signal Strength"
device_name "Sophie's Bedside"
52
COUNT(t_device_feature_state.id) "78001"
device_feature_id "ffe20476-c2b2-44ae-ab1a-c75ff1bccee8"
feature_name "Light Temperature"
device_name "Sophie's Bedside"
53
COUNT(t_device_feature_state.id) "74769"
device_feature_id "9e7ec4cc-022d-4df7-8288-c3983ece0c39"
feature_name "Presence"
device_name "Sophie's Galaxy S23"
54
COUNT(t_device_feature_state.id) "50426"
device_feature_id "217c7b6d-81d4-412a-b19b-574de883eb8f"
feature_name "Switch"
device_name "Water Valve"
55
COUNT(t_device_feature_state.id) "50426"
device_feature_id "95b65412-8c6d-4b57-b639-0fafb6e1728b"
feature_name "Signal Strength"
device_name "Water Valve"
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 "Child Safety"
device_name "Laundry Outlet"
58
COUNT(t_device_feature_state.id) "32055"
device_feature_id "48a97355-d8e2-4fa2-aa72-166143c4566b"
feature_name "Living Room"
device_name "Living Room Temperature"
59
COUNT(t_device_feature_state.id) "32055"
device_feature_id "67828420-a788-40db-8a1e-abdfa2b7ec03"
feature_name "Living Room"
device_name "Living Room Temperature"
60
COUNT(t_device_feature_state.id) "32055"
device_feature_id "a1b3b112-8649-4c14-8a3d-e2933b8d0521"
feature_name "Decimal Pressure Value"
device_name "Living Room Temperature"
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 "Daily Consumption"
device_name "Consumption"
63
COUNT(t_device_feature_state.id) "21755"
device_feature_id "7bab1e21-4696-47a1-aa54-bf5323f1316a"
feature_name "Outside Temperature"
device_name "Garden Temperature"
64
COUNT(t_device_feature_state.id) "21755"
device_feature_id "dab34dcc-836e-437e-beb9-f9cd50ffb834"
feature_name "Air Humidity"
device_name "Garden Temperature"
65
COUNT(t_device_feature_state.id) "19813"
device_feature_id "6abde235-08ff-4d45-899d-ccbc6c6ea0fa"
feature_name "Signal Strength"
device_name "Brightness"
66
COUNT(t_device_feature_state.id) "19813"
device_feature_id "743da3c3-f4d1-4dc6-b834-c15a2b36f8fc"
feature_name "Battery"
device_name "Brightness"
67
COUNT(t_device_feature_state.id) "19813"
device_feature_id "86551ff8-ff10-4a70-bce7-89b4c1d0ef46"
feature_name "Decimal Brightness"
device_name "Brightness"
68
COUNT(t_device_feature_state.id) "19813"
device_feature_id "a41a2be3-08f5-488a-8ba6-81190c36bd3d"
feature_name "Average Voltage"
device_name "Brightness"
69
COUNT(t_device_feature_state.id) "18645"
device_feature_id "b9e638ca-e50d-443c-8541-25de712462de"
feature_name "Presence"
device_name "Guilhem's Mi9T"
70
COUNT(t_device_feature_state.id) "16515"
device_feature_id "1cbfb505-3bcf-47a9-9f50-bb844a9c2f9e"
feature_name "Child Safety"
device_name "Subwoofer Outlet"
71
COUNT(t_device_feature_state.id) "16515"
device_feature_id "305f90bb-4f75-4d7f-b202-2e73f72609bb"
feature_name "Signal Strength"
device_name "Subwoofer Outlet"
72
COUNT(t_device_feature_state.id) "16515"
device_feature_id "45e93ca2-0dbc-4d3d-b0ea-90446a4d1870"
feature_name "Consumed Current"
device_name "Subwoofer Outlet"
73
COUNT(t_device_feature_state.id) "16515"
device_feature_id "5891d7a1-be9b-4faa-898e-1da64143d7fe"
feature_name "Switch"
device_name "Subwoofer Outlet"
74
COUNT(t_device_feature_state.id) "16515"
device_feature_id "bc5cdb7d-e18e-479a-bb5f-8f16b96a84a0"
feature_name "Consumed Power"
device_name "Subwoofer Outlet"
75
COUNT(t_device_feature_state.id) "16515"
device_feature_id "e3dbdc45-8415-424f-83e2-31905b5a4bf9"
feature_name "Average Voltage"
device_name "Subwoofer Outlet"
76
COUNT(t_device_feature_state.id) "16515"
device_feature_id "fc82045f-7ba7-4e2c-b536-bc2ba2162120"
feature_name "Consumed Energy"
device_name "Subwoofer Outlet"
77
COUNT(t_device_feature_state.id) "15082"
device_feature_id "1e47215c-5ab9-4a14-b07d-92b96ceed9e8"
feature_name "Consumed Current"
device_name "Denon Amp Outlet"
78
COUNT(t_device_feature_state.id) "15082"
device_feature_id "8b64d5c5-a1f4-4b3f-9c92-9bb3f9e69789"
feature_name "Signal Strength"
device_name "Denon Amp Outlet"
79
COUNT(t_device_feature_state.id) "15082"
device_feature_id "9621ad34-ab0e-4505-86bb-11f483b2639b"
feature_name "Child Safety"
device_name "Denon Amp Outlet"
80
COUNT(t_device_feature_state.id) "15082"
device_feature_id "a5aa323a-f50e-4d80-98d3-6474236d2427"
feature_name "Consumed Energy"
device_name "Denon Amp Outlet"
81
COUNT(t_device_feature_state.id) "15082"
device_feature_id "bac6cd45-cc6b-4e62-9e7a-8ee44bcafa2d"
feature_name "Average Voltage"
device_name "Denon Amp Outlet"
82
COUNT(t_device_feature_state.id) "15082"
device_feature_id "ddd6cfe4-5448-4e02-ac76-e69452c3c287"
feature_name "Switch"
device_name "Denon Amp Outlet"
83
COUNT(t_device_feature_state.id) "15082"
device_feature_id "e3486be6-c61a-44e7-b8a9-02b32587046a"
feature_name "Consumed Power"
device_name "Denon Amp Outlet"
84
COUNT(t_device_feature_state.id) "14610"
device_feature_id "0aa78d43-a621-4c8b-8233-0b69ff749f5d"
feature_name "Average Voltage"
device_name "Entrance Motion"
85
COUNT(t_device_feature_state.id) "14610"
device_feature_id "2199a794-940c-4ecf-a65a-22356ab0d891"
feature_name "Temperature"
device_name "Entrance Motion"
86
COUNT(t_device_feature_state.id) "14610"
device_feature_id "2cd0395a-a909-4145-bc04-1a1120c1bc35"
feature_name "Motion Detection Yes/No"
device_name "Entrance Motion"
87
COUNT(t_device_feature_state.id) "14610"
device_feature_id "5b3463f3-5ea9-487d-b4e6-7a5e337a13e0"
feature_name "Battery"
device_name "Entrance Motion"
88
COUNT(t_device_feature_state.id) "14610"
device_feature_id "774e6be3-49d8-4fdf-8d0f-7c1142401cb7"
feature_name "Signal Strength"
device_name "Entrance Motion"
89
COUNT(t_device_feature_state.id) "14610"
device_feature_id "c4524b08-7cd8-4331-b04d-10b25c392fe2"
feature_name "Decimal Brightness"
device_name "Entrance Motion"
90
COUNT(t_device_feature_state.id) "13780"
device_feature_id "68ac2240-7096-48d5-acce-b677520a5a37"
feature_name "Decimal Pressure Value"
device_name "Garage Temperature"
91
COUNT(t_device_feature_state.id) "13780"
device_feature_id "c70aa7d1-13f0-42ae-84f0-8590c7347d18"
feature_name "Garage"
device_name "Garage Temperature"
92
COUNT(t_device_feature_state.id) "13780"
device_feature_id "f65b143f-eaf4-428f-a5ba-409675eb0462"
feature_name "Garage"
device_name "Garage Temperature"
93
COUNT(t_device_feature_state.id) "11932"
device_feature_id "0ceec336-560e-49fe-80cf-b4aed629e152"
feature_name "Ruben's Room"
device_name "Ruben's Room Temperature"
94
COUNT(t_device_feature_state.id) "11932"
device_feature_id "326841e0-cba5-4542-a48e-a51d24a6381e"
feature_name "Ruben's Room"
device_name "Ruben's Room Temperature"
95
COUNT(t_device_feature_state.id) "11806"
device_feature_id "0dcfd8ed-29bc-44fc-9983-0fa973ae44bf"
feature_name "Temperature"
device_name "Garage Gate Motion"
96
COUNT(t_device_feature_state.id) "11806"
device_feature_id "0e88bfa5-77b1-4ca9-9ca2-cb0f120c7027"
feature_name "Decimal Brightness"
device_name "Garage Gate Motion"
97
COUNT(t_device_feature_state.id) "11806"
device_feature_id "0ef6f592-6d29-42c1-99e2-9f139861160f"
feature_name "Battery"
device_name "Garage Gate Motion"
98
COUNT(t_device_feature_state.id) "11806"
device_feature_id "2222f5da-ddf4-4797-83cf-652faa4134d5"
feature_name "Signal Strength"
device_name "Garage Gate Motion"
99
COUNT(t_device_feature_state.id) "11806"
device_feature_id "42162f60-47bb-4a01-8d90-0c5d0338e6ca"
feature_name "Average Voltage"
device_name "Garage Gate Motion"
100
COUNT(t_device_feature_state.id) "11806"
device_feature_id "99625a0c-2871-400f-84e0-0487c26cc591"
feature_name "Motion Detection Yes/No"
device_name "Garage Portal Movement"
101
COUNT(t_device_feature_state.id) "11466"
device_feature_id "0ec538d5-ea59-4571-8877-c84e661532d7"
feature_name "Melody"
device_name "Orange Alarm"
102
COUNT(t_device_feature_state.id) "11466"
device_feature_id "2077dd76-6cc8-451f-908b-951deb6e91a2"
feature_name "Battery"
device_name "Orange Alarm"
103
COUNT(t_device_feature_state.id) "11466"
device_feature_id "e789bfed-1404-4cb3-b214-85ec9a04aca6"
feature_name "Siren Volume"
device_name "Orange Alarm"
104
COUNT(t_device_feature_state.id) "11289"
device_feature_id "24eece28-45a9-411c-9ffa-fbbe5ed9014e"
feature_name "Open / Close"
device_name "Pool Filling"
105
COUNT(t_device_feature_state.id) "11236"
device_feature_id "2f1f12be-60ef-42fd-aee2-72fdc366dad1"
feature_name "Parents' Room"
device_name "Parents' Room Temperature"
106
COUNT(t_device_feature_state.id) "11236"
device_feature_id "36e279cc-e960-4379-871f-211eec0a5d09"
feature_name "Parents' Room"
device_name "Parents' Room Temperature"
107
COUNT(t_device_feature_state.id) "10951"
device_feature_id "3f7209fa-d705-4fef-a29d-b2d06bf932a8"
feature_name "Friends' Room"
device_name "Friends' Room Temperature"
108
COUNT(t_device_feature_state.id) "10951"
device_feature_id "407fcf33-ce7d-4ac6-bb80-b52be9a52b98"
feature_name "Friends' Room"
device_name "Friends' Room Temperature"
109
COUNT(t_device_feature_state.id) "10696"
device_feature_id "73289f39-67d6-4b11-86ed-03590aaf409a"
feature_name "Office"
device_name "Office Temperature"
110
COUNT(t_device_feature_state.id) "10696"
device_feature_id "e909ecf2-f395-4e1d-a820-267565edb0a0"
feature_name "Office"
device_name "Office Temperature"
111
COUNT(t_device_feature_state.id) "10146"
device_feature_id "363f22e1-e608-47dc-bad1-7ca6e09abdc1"
feature_name "Decimal Pressure Value"
device_name "Romelie Temperature"
112
COUNT(t_device_feature_state.id) "10146"
device_feature_id "4b642b1b-f2cd-47f5-a476-ff716cae9cce"
feature_name "Romélie Room"
device_name "Romelie Temperature"
113
COUNT(t_device_feature_state.id) "10146"
device_feature_id "c76abcd0-dbd8-4c25-ab90-3250b913b7fd"
feature_name "Romélie Room"
device_name "Romelie Temperature"
114
COUNT(t_device_feature_state.id) "9330"
device_feature_id "81c2f23c-d8cb-4101-8ad7-974081316b9d"
feature_name "Signal Strength"
device_name "TV Roller Shutter"
115
COUNT(t_device_feature_state.id) "9330"
device_feature_id "ac9d99bf-533f-4c82-a45b-b986c78a79d5"
feature_name "Shutter State"
device_name "TV Roller Shutter"
116
COUNT(t_device_feature_state.id) "9330"
device_feature_id "f2a7c728-9952-44d0-b81a-732b1f09807c"
feature_name "Shutter Position"
device_name "TV Roller Shutter"
117
COUNT(t_device_feature_state.id) "8330"
device_feature_id "1a01f9d2-6d31-4d7b-8ef3-97217f09cebc"
feature_name "Shutter Position"
device_name "Bedroom Roller Shutter"
118
COUNT(t_device_feature_state.id) "8330"
device_feature_id "1ae8c0ce-ce76-471c-a86f-faeac31f6dc3"
feature_name "Signal Strength"
device_name "Bedroom Roller Shutter"
119
COUNT(t_device_feature_state.id) "8330"
device_feature_id "906d34a6-64d3-44b8-a007-3c30a1588dae"
feature_name "Shutter State"
device_name "Bedroom Roller Shutter"
120
COUNT(t_device_feature_state.id) "8214"
device_feature_id "9fe5b638-ccec-4845-bf27-9afcda995f95"
feature_name "Azimuth"
device_name "Sun Position"
121
COUNT(t_device_feature_state.id) "8214"
device_feature_id "e84f49af-185c-42bf-ae69-20ac2e4eb20e"
feature_name "Altitude"
device_name "Sun Position"
122
COUNT(t_device_feature_state.id) "7617"
device_feature_id "2d8d4fee-aeef-478e-aa8b-d1df6041a6ce"
feature_name "Shutter State"
device_name "Pool Roller Shutter"
123
COUNT(t_device_feature_state.id) "7617"
device_feature_id "4b9d9940-cbec-4f07-a771-790ae54fc5d2"
feature_name "Signal Strength"
device_name "Pool Roller Shutter"
124
COUNT(t_device_feature_state.id) "7617"
device_feature_id "b157f868-e016-449c-8e76-8781131e90b0"
feature_name "Shutter Position"
device_name "Pool Roller Shutter"
125
COUNT(t_device_feature_state.id) "7508"
device_feature_id "4bda9984-d0e2-4c9a-ad5d-436a957afbb4"
feature_name "Light"
device_name "Office Switch"
126
COUNT(t_device_feature_state.id) "7249"
device_feature_id "18277bdb-2c03-414b-9605-2d13ce5747a7"
feature_name "Switch"
device_name "💡 Living Room Light"
127
COUNT(t_device_feature_state.id) "6732"
device_feature_id "ba4e87b9-7227-41ca-8fae-9267644c268d"
feature_name "Signal Strength"
device_name "Sprinkler Circuit Breaker"
128
COUNT(t_device_feature_state.id) "6732"
device_feature_id "cabbf1c7-e623-4d0f-96e8-e18fc1a9f1a7"
feature_name "Switch"
device_name "Sprinkler Circuit Breaker"
129
COUNT(t_device_feature_state.id) "6561"
device_feature_id "2a927909-adc4-4d00-994f-8061d9093fb4"
feature_name "Pool Temperature"
device_name "Pool Temperature"
130
COUNT(t_device_feature_state.id) "6323"
device_feature_id "3dc53b8f-9f5d-4707-af7d-949dd056bd33"
feature_name "Signal Strength"
device_name "Drip Irrigation Circuit Breaker"
131
COUNT(t_device_feature_state.id) "6323"
device_feature_id "6aa1d7dc-4ccd-4d53-9529-bcdedac7400e"
feature_name "Switch"
device_name "Drip Irrigation Circuit Breaker"
132
COUNT(t_device_feature_state.id) "5690"
device_feature_id "38e166e3-9cbf-493f-9f13-66b74a68f126"
feature_name "Lighting On/Off"
device_name "Ruben's Room Bulb"
133
COUNT(t_device_feature_state.id) "5690"
device_feature_id "3d53e584-b954-439b-9644-387a3016fae4"
feature_name "Lighting Temperature"
device_name "Ruben's Room Bulb"
134
COUNT(t_device_feature_state.id) "5690"
device_feature_id "afeb8c7a-0d72-4f74-a241-6830e05f3044"
feature_name "Lighting Brightness"
device_name "Ruben's Room Bulb"
135
COUNT(t_device_feature_state.id) "5690"
device_feature_id "c3d6a2bc-3e86-40c5-89d9-a36ca0dfa9c2"
feature_name "Signal Strength"
device_name "Ruben's Room Bulb"
136
COUNT(t_device_feature_state.id) "5626"
device_feature_id "3d6fe393-b942-44d3-bd1c-d7d9204bd547"
feature_name "Lighting On/Off"
device_name "Romélie's Room Bulb"
137
COUNT(t_device_feature_state.id) "5424"
device_feature_id "38ecaa9d-b148-410b-9e3a-542606044b23"
feature_name "Signal Strength"
device_name "Parents' Room Router"
138
COUNT(t_device_feature_state.id) "5258"
device_feature_id "f4216d19-eaee-4455-ad09-de95f164aaa4"
feature_name "Signal Strength"
device_name "Garden Router"
139
COUNT(t_device_feature_state.id) "4695"
device_feature_id "00765e20-5323-4886-a40e-8a4349e1971d"
feature_name "Average Voltage"
device_name "Pool Glass Wall Opening"
140
COUNT(t_device_feature_state.id) "4695"
device_feature_id "512b2fc2-bc64-407f-83b2-16df1b4ece65"
feature_name "Signal Strength"
device_name "Pool Glass Wall Opening"
141
COUNT(t_device_feature_state.id) "4695"
device_feature_id "576af393-7248-4f70-830a-9727a6ca8729"
feature_name "Battery"
device_name "Pool Glass Wall Opening"
142
COUNT(t_device_feature_state.id) "4695"
device_feature_id "9a1cb18d-aff6-4525-8320-755fc7a0206f"
feature_name "Temperature"
device_name "Pool Glass Wall Opening"
143
COUNT(t_device_feature_state.id) "4695"
device_feature_id "b60c2eec-7913-475b-a146-7bb96e3fdf08"
feature_name "Opening (Yes/No)"
device_name "Pool Glass Wall Opening"
144
COUNT(t_device_feature_state.id) "4333"
device_feature_id "0e8bb70b-12a5-4adc-84a3-4553e15fd833"
feature_name "Temperature"
device_name "Garage Door Opening"
145
COUNT(t_device_feature_state.id) "4333"
device_feature_id "883640f9-4943-4414-ae0f-52b75d97625f"
feature_name "Opening (Yes/No)"
device_name "Garage Door Opening"
146
COUNT(t_device_feature_state.id) "4283"
device_feature_id "375a7fb9-c185-4a3a-bbef-9d66a43f04da"
feature_name "Average Voltage"
device_name "Entrance Door Opening"
147
COUNT(t_device_feature_state.id) "4283"
device_feature_id "5203a6d0-f66a-434c-b8ea-2cddd5aa2707"
feature_name "Battery"
device_name "Entrance Door Opening"
148
COUNT(t_device_feature_state.id) "4283"
device_feature_id "7b5abe18-8072-4c7d-98f4-111c5b046f63"
feature_name "Opening (Yes/No)"device_name "Front Door Opening"
149
COUNT(t_device_feature_state.id) "4283"
device_feature_id "9c0914bd-b7a1-49bf-b8dd-3872148b03c6"
feature_name "Signal Strength"
device_name "Front Door Opening"
150
COUNT(t_device_feature_state.id) "4283"
device_feature_id "be2ab703-1db6-43a7-af7b-1528b6483963"
feature_name "Temperature"
device_name "Front Door Opening"
151
COUNT(t_device_feature_state.id) "2887"
device_feature_id "19c1e1df-103f-4c71-bf34-ea3863622655"
feature_name "Signal Strength"
device_name "6-Button Intercom"
152
COUNT(t_device_feature_state.id) "2887"
device_feature_id "31992d38-eb95-46dc-8055-261ccb0575b7"
feature_name "Battery"
device_name "6-Button Intercom"
153
COUNT(t_device_feature_state.id) "2887"
device_feature_id "9ba6c0a2-c6a2-4fde-9573-e90f50dde780"
feature_name "Average Voltage"
device_name "6-Button Intercom"
154
COUNT(t_device_feature_state.id) "2808"
device_feature_id "1f74c290-2ed4-4a78-9fd5-debcd326b0c3"
feature_name "Average Voltage"
device_name "Romélie's Bedroom Window"
155
COUNT(t_device_feature_state.id) "2808"
device_feature_id "3d2d6a20-dda3-47d7-a5a1-6aec48648310"
feature_name "Signal Strength"
device_name "Romélie's Bedroom Window"
156
COUNT(t_device_feature_state.id) "2808"
device_feature_id "8b2bf155-672d-42d8-82ed-438536803ba7"
feature_name "Temperature"
device_name "Romélie's Bedroom Window"
157
COUNT(t_device_feature_state.id) "2808"
device_feature_id "ab7153bf-655e-4556-a8d0-c612124a78a3"
feature_name "Battery"
device_name "Romélie's Bedroom Window"
158
COUNT(t_device_feature_state.id) "2808"
device_feature_id "d216fafd-cf9f-4715-9c93-e5ce97d4f5d1"
feature_name "Opening (Yes/No)"
device_name "Romélie's Bedroom Window"
159
COUNT(t_device_feature_state.id) "2703"
device_feature_id "4ca21dd7-f049-43b4-a62c-efc94eb78368"
feature_name "Temperature"
device_name "Garage Gate Opening"
160
COUNT(t_device_feature_state.id) "2703"
device_feature_id "a69b7fe2-6908-4d39-bdde-1eef83c68138"
feature_name "Opening (Yes/No)"
device_name "Garage Gate Opening"
161
COUNT(t_device_feature_state.id) "2682"
device_feature_id "6171088f-e1cf-4ea6-ac7a-39bdb25c14a5"
feature_name "Lighting On/Off"
device_name "Parents' Bedroom Bulb"
162
COUNT(t_device_feature_state.id) "2673"
device_feature_id "013529b5-43c8-4dd0-ad01-d3c67dbcbbae"
feature_name "Signal Strength"
device_name "Living Room TV 4-Button Intercom"
163
COUNT(t_device_feature_state.id) "2673"
device_feature_id "55b0af49-df11-4982-98fa-86772044c37c"
feature_name "Battery"
device_name "Living Room TV 4-Button Intercom"
164
COUNT(t_device_feature_state.id) "2673"
device_feature_id "b4a995ae-1b06-4351-afaa-63085f4932a7"
feature_name "Average Voltage"
device_name "Living Room TV 4-Button Intercom"
165
COUNT(t_device_feature_state.id) "2662"
device_feature_id "097816b1-2763-4200-9235-e93d863815e5"
feature_name "Average Voltage"
device_name "Living Room French Door Opening"
166
COUNT(t_device_feature_state.id) "2662"
device_feature_id "1051d11e-86be-40ff-8948-41c29440af44"
feature_name "Battery"
device_name "Living Room French Door Opening"
167
COUNT(t_device_feature_state.id) "2662"
device_feature_id "96052a09-8a06-4060-8d54-9a9d02d884e8"
feature_name "Temperature"
device_name "Living Room French Door Opening"
168
COUNT(t_device_feature_state.id) "2662"
device_feature_id "cd7ef5db-ff10-426e-8b2e-49b5e4bd5172"
feature_name "Signal Strength"
device_name "Living Room French Door Opening"
169
COUNT(t_device_feature_state.id) "2662"
device_feature_id "e1e8254f-02e4-4488-9bed-1153fffa54fe"
feature_name "Opening (Yes/No)"
device_name "Living Room French Door Opening"
170
COUNT(t_device_feature_state.id) "2652"
device_feature_id "2a18625d-cad0-4c20-bc24-fdbb0d664f5d"
feature_name "Signal Strength"
device_name "Bathroom Door Opening"
171
COUNT(t_device_feature_state.id) "2652"
device_feature_id "2d3c8196-84bd-4d9c-b6e0-bb48f2276bc9"
feature_name "Temperature"
device_name "Bathroom Door Opening"
172
COUNT(t_device_feature_state.id) "2652"
device_feature_id "5d15b405-d447-4c73-8d6c-5df0a92dfd27"
feature_name "Average Voltage"
device_name "Bathroom Door Opening"
173
COUNT(t_device_feature_state.id) "2652"
device_feature_id "68fd9390-c8b5-422c-a4cf-eb2523cf8e5d"
feature_name "Opening (Yes/No)"
device_name "Bathroom Door Opening"
174
COUNT(t_device_feature_state.id) "2652"
device_feature_id "c653c383-7a9a-4d3a-bb97-a9b0e806baf3"
feature_name "Battery"
device_name "Bathroom Door Opening"
175
COUNT(t_device_feature_state.id) "2649"
device_feature_id "0db3ddcb-65d1-4237-8d88-1f0f251ee94d"
feature_name "Opening (Yes/No)"
device_name "TV Bay Window Opening"
176
COUNT(t_device_feature_state.id) "2649"
device_feature_id "56ad57e8-8a26-48e0-a821-8617d209e135"
feature_name "Battery"
device_name "TV Bay Window Opening"
177
COUNT(t_device_feature_state.id) "2649"
device_feature_id "7d2e5b01-abba-4df5-920c-3cbed27a3399"
feature_name "Average Voltage"
device_name "TV Bay Window Opening"
178
COUNT(t_device_feature_state.id) "2649"
device_feature_id "ba608422-c80d-4dc4-97b4-6b17399d0ca6"
feature_name "Temperature"
device_name "TV Bay Window Opening"
179
COUNT(t_device_feature_state.id) "2649"
device_feature_id "d830be06-b962-4c44-960d-954ab9fa4505"
feature_name "Signal Strength"
device_name "TV Bay Window Opening"
180
COUNT(t_device_feature_state.id) "2619"
device_feature_id "1bb0feb8-dcd9-4b11-ade5-70224f5fefc1"
feature_name "Battery"
device_name "Guest Room Window Opening"
181
COUNT(t_device_feature_state.id) "2619"
device_feature_id "8faaafbf-c33d-4737-93c3-4e290228460a"
feature_name "Average Voltage"
device_name "Guest Room Window Opening"
182
COUNT(t_device_feature_state.id) "2619"
device_feature_id "a0641142-c27e-4391-b9f3-17fb5c13a6da"
feature_name "Temperature"
device_name "Guest Room Window Opening"
183
COUNT(t_device_feature_state.id) "2619"
device_feature_id "ad7ec7e0-cf9a-4d81-9890-d97566788385"
feature_name "Opening (Yes/No)"
device_name "Guest Room Window Opening"
184
COUNT(t_device_feature_state.id) "2619"
device_feature_id "da4dc8c1-1626-4a92-87a7-c617ff423c9f"
feature_name "Signal Strength"
device_name "Guest Room Window Opening"
185
COUNT(t_device_feature_state.id) "2605"
device_feature_id "06fae8d0-7eee-4c1c-8e22-c1c5f33e23ab"
feature_name "Average Voltage"
device_name "Office Window Opening"
186
COUNT(t_device_feature_state.id) "2605"
device_feature_id "6d75528b-390b-40de-aeb8-4ddecc67bb8a"
feature_name "Opening (Yes/No)"
device_name "Office Window Opening"
187
COUNT(t_device_feature_state.id) "2605"
device_feature_id "a62dd698-650c-419a-bcf9-6825a13d5b45"
feature_name "Battery"
device_name "Office Window Opening"
188
COUNT(t_device_feature_state.id) "2605"
device_feature_id "d3df4482-c4ff-47e3-b298-d95b8ec98a69"
feature_name "Signal Strength"
device_name "Office Window Opening"
189
COUNT(t_device_feature_state.id) "2605"
device_feature_id "eab015b9-c234-4c6a-af20-017f27b3fa8f"
feature_name "Temperature"
device_name "Office Window Opening"
190
COUNT(t_device_feature_state.id) "2584"
device_feature_id "392ac79b-dd72-4bf6-b7bb-e4b6b6ebc6ae"
feature_name "Average Voltage"
device_name "Shower Leak"
191
COUNT(t_device_feature_state.id) "2584"
device_feature_id "3d77971a-67df-4999-bf11-3ece2632c3dd"
feature_name "Leak (Yes/No)"
device_name "Shower Leak"
192
COUNT(t_device_feature_state.id) "2584"
device_feature_id "ff996d3b-3f6b-434a-aa4d-650079dadda3"
feature_name "Battery"
device_name "Shower Leak"
193
COUNT(t_device_feature_state.id) "2521"
device_feature_id "21fe9f89-c69d-44a3-9cfe-dcb49d2ed3a2"
feature_name "Signal Strength"
device_name "Ruben's Bedroom Window Opening"
194
COUNT(t_device_feature_state.id) "2521"
device_feature_id "95a8078a-dbfb-4539-ac65-f6ffb5b26014"
feature_name "Average Voltage"
device_name "Ruben's Bedroom Window Opening"
195
COUNT(t_device_feature_state.id) "2521"
device_feature_id "d18aac7e-5f7e-44a2-bbc6-fe47d7f3e8f7"
feature_name "Opening (Yes/No)"
device_name "Ruben's Bedroom Window Opening"
196
COUNT(t_device_feature_state.id) "2351"
device_feature_id "2783010e-0702-4e4b-b16a-7b5a8db611ab"
feature_name "Battery"
device_name "Parents' Bedroom Door Opening"
197
COUNT(t_device_feature_state.id) "2351"
device_feature_id "2f7b00ca-0a3d-4ebf-b291-70a13f410183"
feature_name "Opening (Yes/No)"
device_name "Parents' Bedroom Opening"
198
COUNT(t_device_feature_state.id) "2351"
device_feature_id "cd63f74a-2cb2-425e-a625-fc1ecf0e8600"
feature_name "Signal Strength"
device_name "Parents' Bedroom Opening"
199
COUNT(t_device_feature_state.id) "2351"
device_feature_id "d1d918b0-3905-480b-ae4d-3d019301eab6"
feature_name "Average Voltage"
device_name "Parents' Bedroom Opening"
200
COUNT(t_device_feature_state.id) "2351"
device_feature_id "fb149148-0da8-4173-b767-4d55c85e4e6a"
feature_name "Temperature"
device_name "Parents' Bedroom Opening"
201
COUNT(t_device_feature_state.id) "2137"
device_feature_id "13e702c1-6a9d-492d-bd65-d8d6ccb60f31"
feature_name "Light Brightness"
device_name "Kitchen Back Bulb"
202
COUNT(t_device_feature_state.id) "2137"
device_feature_id "398e2714-ce5c-434b-8a73-0185ae1d2eed"
feature_name "Light Temperature"
device_name "Kitchen Back Bulb"
203
COUNT(t_device_feature_state.id) "2137"
device_feature_id "a86212c3-be53-49ad-a5b9-602783e35394"
feature_name "Light On/Off"
device_name "Kitchen Back Bulb"
204
COUNT(t_device_feature_state.id) "2034"
device_feature_id "36d870c8-bb68-41db-a822-e4df1e524a96"
feature_name "Soil Humidity"
device_name "Soil Humidity Sensor"
205
COUNT(t_device_feature_state.id) "1710"
device_feature_id "5986cdf2-c257-48b2-97ba-aa5a64d25aef"
feature_name "Light Brightness"
device_name "Guest Room Bulb"
206
COUNT(t_device_feature_state.id) "1710"
device_feature_id "cb288d6b-7acd-466a-be04-e6ee06543d5c"
feature_name "Light On/Off"
device_name "Guest Room Bulb"
207
COUNT(t_device_feature_state.id) "1710"
device_feature_id "dfda8172-4684-4bc1-b97f-aa3be9a8e5c6"
feature_name "Light Temperature"
device_name "Guest Room Bulb"
208
COUNT(t_device_feature_state.id) "1710"
device_feature_id "e8a816ab-f80f-4b64-abf1-00d3ba92bf30"
feature_name "Signal Strength"
device_name "Guest Room Bulb"
209
COUNT(t_device_feature_state.id) "1130"
device_feature_id "66114b90-2ff0-479c-b92a-fc1c315b265f"
feature_name "Light On/Off"
device_name "Office 2 Bulb"
210
COUNT(t_device_feature_state.id) "809"
device_feature_id "7bf1300c-dd9c-4a88-a090-bbb1e24fa4ce"
feature_name "Signal Strength"
device_name "Watering Valve"
211
COUNT(t_device_feature_state.id) "809"
device_feature_id "b31a31d0-0635-4925-ad17-8cf22813320e"
feature_name "Battery"
device_name "Watering Valve"
212
COUNT(t_device_feature_state.id) "469"
device_feature_id "24347efa-7b8b-4129-9e60-44c67c832ce9"
feature_name "Signal Strength"
device_name "Guest Room Router"
213
COUNT(t_device_feature_state.id) "469"
device_feature_id "d9509f28-e5cf-4fdb-88f2-db4975bcc4bb"
feature_name "Low Battery (Yes/No)"
device_name "Shower Leak"
214
COUNT(t_device_feature_state.id) "435"
device_feature_id "276b9318-d220-4f8d-8724-b1f6649ca67f"
feature_name "Light Temperature"
device_name "Entrance Color Spot"
215
COUNT(t_device_feature_state.id) "435"
device_feature_id "6b91319c-46f5-4b60-ae05-542dc24d1a29"
feature_name "Light Brightness"
device_name "Entrance Color Spot"
216
COUNT(t_device_feature_state.id) "435"
device_feature_id "8dc26644-a6fb-4a14-a575-915eaa370ee5"
feature_name "Light On/Off"
device_name "Entrance Color Spot"
217
COUNT(t_device_feature_state.id) "435"
device_feature_id "9a7a1332-8c09-4921-86b6-5dea1228da39"
feature_name "Light Color"
device_name "Entrance Color Spot"
218
COUNT(t_device_feature_state.id) "395"
device_feature_id "03506eca-2d2b-4d24-bd0d-ed6555d731e5"
feature_name "Light On/Off"
device_name "LED Strip"
219
COUNT(t_device_feature_state.id) "395"
device_feature_id "2b55d5a2-6729-4eb5-92a0-6d18dc49dc08"
feature_name "Light Temperature"
device_name "LED Strip"
220
COUNT(t_device_feature_state.id) "395"
device_feature_id "55c34624-e6ff-40ac-af33-dacb0c2e0186"
feature_name "Light Color"
device_name "LED Strip"
221
COUNT(t_device_feature_state.id) "395"
device_feature_id "a6edbae5-2a21-4ae6-8c98-54501c7d5176"
feature_name "Signal Strength"
device_name "LED Strip"
222
COUNT(t_device_feature_state.id) "395"
device_feature_id "af1bf389-e2e4-40d3-a296-7255b06848af"
feature_name "Light Brightness"
device_name "LED Strip"
223
COUNT(t_device_feature_state.id) "88"
device_feature_id "09634c1d-a8f6-4d04-969c-27245a1d8599"
feature_name "Previous Day Consumption"
device_name "Consumption"
224
COUNT(t_device_feature_state.id) "35"
device_feature_id "5366a343-5cce-4f2f-ae77-06bfd11db50f"
feature_name "Filling"
device_name "Pool Pump Tools"
225
COUNT(t_device_feature_state.id) "28"
device_feature_id "f2f59900-df9f-415a-b4e0-dd92deca7260"
feature_name "Button Click"
device_name "Garage Simple Button"
226
COUNT(t_device_feature_state.id) "9"
device_feature_id "f92149a1-5b7a-4c01-ad5f-bf29cc29f1aa"
feature_name "SURVEILLANCE - state"
device_name "SURVEILLANCE"
227
COUNT(t_device_feature_state.id) "8"
device_feature_id "6c7cd64f-d620-4128-a69b-9f774294e3be"
feature_name "Intrusion (state) "
device_name "Intrusion"
228
COUNT(t_device_feature_state.id) "5"
device_feature_id "10e6207a-7756-49aa-81c5-9132cd5afd1a"
feature_name "Signal Strength"
device_name "Sophie's Nightstand Button"
229
COUNT(t_device_feature_state.id) "5"
device_feature_id "1b011336-3fd3-4adf-bb6d-adbfd38e6a40"
feature_name "Signal Strength"
device_name "Garage Light Outlet"
230
COUNT(t_device_feature_state.id) "5"
device_feature_id "1e154dba-8167-4fe1-9b34-212ff7849484"
feature_name "Power Consumed"
device_name "Garage Light Outlet"
231
COUNT(t_device_feature_state.id) "5"
device_feature_id "3533b52f-2641-447f-95e2-adc18119810c"
feature_name "Signal Strength"
device_name "Bathroom Leak"
232
COUNT(t_device_feature_state.id) "5"
device_feature_id "36b7b113-3d8c-4ff4-bc6d-b48ff66145cd"
feature_name "Temperature"
device_name "Sophie's Nightstand Button"
233
COUNT(t_device_feature_state.id) "5"
device_feature_id "4498cb4a-6504-4da7-80bb-314d27d06dcd"
feature_name "Battery"
device_name "Sophie's Nightstand Button"
234
COUNT(t_device_feature_state.id) "5"
device_feature_id "6327eddc-0b1c-4463-89d4-e7f182523ef1"
feature_name "Access Control Mode"
device_name "Garage Light Outlet"
235
COUNT(t_device_feature_state.id) "5"
device_feature_id "71656496-df24-466a-aaeb-e923b129ae6e"
feature_name "Energy Consumed"
device_name "Garage Light Outlet"
236
COUNT(t_device_feature_state.id) "5"
device_feature_id "7478b88e-b406-4970-a24d-cf83ad23ef39"
feature_name "Battery"
device_name "Bathroom Leak"
237
COUNT(t_device_feature_state.id) "5"
device_feature_id "78fff789-1c83-469c-8583-e51674642c8d"
feature_name "Forced Operation"
device_name "Pool Pump Tools"
238
COUNT(t_device_feature_state.id) "5"
device_feature_id "8e5d8cb8-f770-453f-9bbf-019d36df8bd9"
feature_name "Average Voltage"
device_name "Garage Light Outlet"
239
COUNT(t_device_feature_state.id) "5"
device_feature_id "b0a51dd3-ae5f-46ef-b99c-066945706a91"
feature_name "Power Consumed"
device_name "Garage Light Outlet"
240
COUNT(t_device_feature_state.id) "5"
device_feature_id "bc653819-ae23-4e74-848c-9d4f86fd9396"
feature_name "Temperature"
device_name "Bathroom Leak"
241
COUNT(t_device_feature_state.id) "5"
device_feature_id "c7248901-580c-416d-b189-376cc1bdc68f"
feature_name "Average Voltage"
device_name "Sophie's Nightstand Button"
242
COUNT(t_device_feature_state.id) "5"
device_feature_id "e87e4c3f-44ed-445a-a7fd-fee4df06028c"
feature_name "Switch"
device_name "Garage Light Outlet"
243
COUNT(t_device_feature_state.id) "5"
device_feature_id "fa383e7b-9749-41eb-83cf-af021c3c39ca"
feature_name "Average Voltage"
device_name "Bathroom Leak"
244
COUNT(t_device_feature_state.id) "4"
device_feature_id "7a1602d9-e033-426b-b5d3-11ec78ee6a27"
feature_name "Red Alarm - Volume"
device_name "Red Alarm - 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 "Pump (STATUS)"
device_name "Pool pump tools"
I see that the electricity consumption part of the house (used via Nodered with the Solaredge API) is what sends a lot of data. I don’t know if it’s « too much » or not!
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
Here is the result of the query you gave me:
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"
It is clearly seen that these are ULTRA close calls (between 10ms and 1000ms), especially since the request only looked at one device.
I would therefore imagine that I need to find a way to space these data points out over time. Maybe an interesting lead!