Can I query the size of a database in influx db?

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.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.