Page 1 of 1
boiler monitoring
Posted: Wednesday 23 September 2015 15:48
by ola
Hello,
I want to record the operating time of my gas boiler (the time that my thermostat told the circulator: go !
)
I do not see what type of meter, I have to use,
I would like :
- A graph giving me the duration of use ( on / off) as a switch ( 24h or 48h graph)
- A cumulative graph giving me the total operating time per day , week, month, much like the water meter .
Suggestions ?
Thank you !
Re: boiler monitoring
Posted: Wednesday 23 September 2015 22:16
by mongoose
Could be a great addition, how long say a light has been on this month compared to last month etc
Re: boiler monitoring
Posted: Thursday 24 September 2015 8:37
by pj-r
I wanted to know how much the TV was on so I made this SQL query for that. Its quite heavy but does the work.
Just replace T.DeviceRowID = Idx with your device id.
If you want to chance calculation start date you must add something like this AND T.Date > '2015-09-01 00:00:00' to where caluse.
And of course it wont calculate last turn on sequence if the switch is still on. For example if your switch has been on for two days its missing from this calculation.
Code: Select all
SELECT
MIN(T.Date) as From_Date,
SUM(strftime('%s', (SELECT MIN(X.Date) FROM LightingLog X WHERE X.Date > T.Date AND X.nValue = 0 )) - strftime('%s', T.Date)) / 3600.0 as On_Hours
FROM
LightingLog T
WHERE
T.nValue = 1
AND
T.DeviceRowID = Idx
ORDER BY
T.Date;
The result is first day found in log and time the switch has been on since:
Code: Select all
rock@pjr:~$ sudo sqlite3 domoticz/domoticz.db < ./switch_on_time.sql
2015-08-25 01:33:19|22.1652777777778
But this ON-time per day, month, year would be wery nice addition.
Re: boiler monitoring
Posted: Thursday 24 September 2015 12:12
by ola
Thanks for the answer, I will make a try...
Do you know here i should ask for this implementation, in the "Suggestions" forum or in "Feature tracker" forum ?
Re: boiler monitoring
Posted: Monday 05 September 2016 11:47
by ayasystems
Please add this feature as standard option into domoticz!!