Long term Data

Configuration
1

Hi Guys
I want to keep my Solar data for a year or so, how do i go about keeping that data. I have charts etc already that shows a couple of days.
I have read that HA only retains10 days ? Is this true ,
Thanks

2

HA retains it for as long as you have your recorder configured for and then a bit. If you really want long term data then think about putting up InfluxDB, but make sure you have plenty of storage for it because it can add up very fast.

1 Like
3

Can you get InfluxDB to store the data on a external drive ?thanks

4

I’ve never tried but I don’t see why you can’t. Although if I were going to do that I would set up an entirely different computer with InfluxDB on it (or Proxmox virtual or something). My HA drive is 1TB so I’m good for a while but my backups are huge.

1 Like
5

I try look for a Youtube video, hopefully there is someone that gives a tutorial
Thanks for your advice
My HA runs on Dell wyse 5070 mini pc . Maybe can add a usb drive to it.
Thanks

6

There are some good tutorials out there on it both on YouTube as well as write-ups, it can be a bit daunting at first but it makes sense rapidly. Then you get some really cool graphing with Grafina to add to it and you have a power statistics system. I only keep my Influx data for 1 year, that was my butter zone for DB size versus actual need of the data, YMMV.

1 Like
7

Thanks , you star

8

Tell @MissyQ :joy::joy::joy::joy::joy::joy:

9

This is probably the best tutorial

The only thing it misses it to make sure you only include the sensors you are actually interested in recording long term in the HA config. Otherwise it records everything and that’s when it can become huge.

1 Like
10

Also be aware that if the entities you are interested in are configured in a way that allows the generation of statistics, you’ll have long term statistics data that is retained indefinitely, regardless of your recorder settings.

If you are only interested in things like daily energy production, the long term statistics should be sufficient.

1 Like
11

I’m going to throw a low-tech option out there. Not for everyone, but…

You can simply output data, at whatever interval and whatever detail you need, to a flat text file like a .csv or whatever. Then, read, analyze, graph or interpret it using whatever data analytics tools you’re comfortable with.

Create an entity in the File integration, then use service: notify.send_message to send a line to the file.

This gets the whole data storage and analysis process outside of HA, where you can use tools specifically designed for that purpose.

12

Thanks appreciate it will watch