Powerwall_Monitor

Monitoring the Tesla Powerwall with the TICK framework

Requirements

• docker
• docker-compose

Installation

Docker Containers

• Edit powerwall.yml and look for the section under pypowerall and update the following details for your Powerwall:

            PW_PASSWORD: "password"
            PW_EMAIL: "[email protected]"
            PW_HOST: "192.168.91.1"
            PW_TIMEZONE: "Australia/Adelaide"

• Start the docker containers: docker-compose -f powerwall.yml up -d

InfluxDB

• Connect to the Influx database shell: docker exec -it influxdb influx
• At the database prompt, you will need to enter (copy/paste) the following commands after you adjust the timezone (tz) as appropriate:

   USE powerwall
   CREATE RETENTION POLICY raw ON powerwall duration 3d replication 1
   ALTER RETENTION POLICY autogen ON powerwall duration 365d
   CREATE RETENTION POLICY kwh ON powerwall duration INF replication 1
   CREATE RETENTION POLICY daily ON powerwall duration INF replication 1
   CREATE RETENTION POLICY monthly ON powerwall duration INF replication 1
   CREATE CONTINUOUS QUERY cq_autogen ON powerwall BEGIN SELECT mean(home) AS home, mean(solar) AS solar, mean(from_pw) AS from_pw, mean(to_pw) AS to_pw, mean(from_grid) AS from_grid, mean(to_grid) AS to_grid, last(percentage) AS percentage INTO powerwall.autogen.:MEASUREMENT FROM (SELECT load_instant_power AS home, solar_instant_power AS solar, abs((1+battery_instant_power/abs(battery_instant_power))*battery_instant_power/2) AS from_pw, abs((1-battery_instant_power/abs(battery_instant_power))*battery_instant_power/2) AS to_pw, abs((1+site_instant_power/abs(site_instant_power))*site_instant_power/2) AS from_grid, abs((1-site_instant_power/abs(site_instant_power))*site_instant_power/2) AS to_grid, percentage FROM raw.http) GROUP BY time(1m), month, year fill(linear) END
   CREATE CONTINUOUS QUERY cq_kwh ON powerwall RESAMPLE EVERY 1m BEGIN SELECT integral(home)/1000/3600 AS home, integral(solar)/1000/3600 AS solar, integral(from_pw)/1000/3600 AS from_pw, integral(to_pw)/1000/3600 AS to_pw, integral(from_grid)/1000/3600 AS from_grid, integral(to_grid)/1000/3600 AS to_grid INTO powerwall.kwh.:MEASUREMENT FROM autogen.http GROUP BY time(1h), month, year tz('Australia/Adelaide') END
   CREATE CONTINUOUS QUERY cq_daily ON powerwall RESAMPLE EVERY 1h BEGIN SELECT sum(home) AS home, sum(solar) AS solar, sum(from_pw) AS from_pw, sum(to_pw) AS to_pw, sum(from_grid) AS from_grid, sum(to_grid) AS to_grid INTO powerwall.daily.:MEASUREMENT FROM powerwall.kwh.http GROUP BY time(1d), month, year tz('Australia/Adelaide') END 
   CREATE CONTINUOUS QUERY cq_monthly ON powerwall RESAMPLE EVERY 1h BEGIN SELECT sum(home) AS home, sum(solar) AS solar, sum(from_pw) AS from_pw, sum(to_pw) AS to_pw, sum(from_grid) AS from_grid, sum(to_grid) AS to_grid INTO powerwall.monthly.:MEASUREMENT FROM powerwall.daily.http GROUP BY time(365d), month, year END

Note: the database queries are set to use Australia/Adelaide as timezone. Edit the database commands above to replace Australia/Adelaide with your own timezone.

Grafana Setup

• Open up Grafana in a browser at http://<server ip>:9000 and login with admin/admin
• From Configuration\Data Sources, add InfluxDB database with:
  • name: InfluxDB
  • url: http://influxdb:8086
  • database: powerwall
  • min time interval: 5s
• From Configuration\Data Sources, add Sun and Moon database with:
  • name: Sun and Moon
  • your latitude and longitude
• Edit dashboard.json to replace Australia/Adelaide with your own timezone.
• From Dashboard\Manage, select Import, and upload dashboard.json

Notes

• The database queries and dashboard are set to use Australia/Adelaide as the timezone. Remember to edit the database commands and the dashboard.json file to replace Australia/Adelaide with your own timezone.

• InfluxDB does not run reliably on older models of Raspberry Pi, resulting in the Docker container terminating with error 139.

Enjoy!

---

If you found this useful, say Thank You! with a beer.