I looked through the influx nodes and I can't find an example of how to get the total size of a particular db. Is this possible, I'm using 1.x databases.
Influx doesn't report its size directly I don't think but something like the following command should do the trick:
sudo du -sh /var/lib/influxdb/data/
It is possible to run that from node-red if you add the command to sudoers so that it doesn't require a password to run.
You can get the the total size of the dbase InfluxDb usage statistics - Store - InfluxData Community from the _internal database.
However I think the solution provided by TotallyInformation is much easier.
I want to thank everyone for the replies. I am already using a sudo du sensor in home assistant which works. Because of HA's container structure it's a bit convoluted.
I was hoping that this was built into one of the nodes, I'm surprised how difficult it is. Executing a command from NR to influx under HA's OS will probably be worse, so I'm just going to leave it as is.
