The sump used to always be a stressor for me. This time of year I would hear it go off all the time and I would worry what if it got stuck? How many times is it really running?
One point of monitoring the sump is tracking it from an energy reporting smart outlet. I use the energy reports to flip a virtual switch on/off via RM, which goes to InfluxDB, and then count the on/off changes in Grafana to make a chart. Can you tell when it warmed up, started raining and all the snow started melting? Thats a lot of water!
Updated Screenshot:
My other monitoring point is a leak sensor mounted just above the high point before the sump runs. If this ever goes off I should have a few hours at least to prevent flooding. The excess water will start filling up the feeder pipes so there is a lot of room for extra water before it overflows the pit. Pictures Below.
Rules to help monitor:
Rule Machine
This rule flips the virtual switch on/off for tracking and also watches for it to become stuck running (if the float broke or got stuck)
Since the smart plug has the ability to turn off this rule makes sure it stays on
Thanks to @bill.d for the Flux query for Grafana
Flux Query
You will need to change the time zone, bucket, and deviceName to match your setup.
May need to change the measurement name also if its not a switch status.
import "timezone"
option location = timezone.location(name: "America/Chicago")
from(bucket: "BUCKET_NAME")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "switch" and r["_field"] == "value")
|> filter(fn: (r) => r["deviceName"] == "NAME_OF_DEVICE")
|> filter(fn: (r) => r._value == "on")
|> aggregateWindow(every: 1d, fn: count, createEmpty: false, timeSrc: "_start")
