I have installed the influxdb addon at the beginning of the year. I have not enabled any purging (to my knowledge). My config just looks:
influxdb:
host: localhost
port: 8086
database: HomeAssistant
username: HomeAssistant
password: xxxxxxxxx
max_retries: 3
default_measurement: state
tags_attributes:
- entity_id
- friendly_name
- device_class
precision: ms
Yet, sometimes I have a really hard time finding data. For example, I have a Centralite Zigbee thermostat since last year. Yet, magically the data only starts June 5:
Sometimes I am even running into issues that are just “impossible”. For example, I want to plot wattage from my Emporia 2 in-panel meter. I use Apr 1 to Sep 30 as time range and after long time I get:
Then I change the start date to Apr 1 (which should perfectly include the previous data), yet I get:
In general, many queries return “Your query or command is syntactically correct but returned no results.” where I really expect data.
Is there anything I am doing wrong?
Is there a way to get a quick overview which data is actually available in the database?
With mySQL, phpmyadmin, it’s simple to see the content of individual tables and see which are empty, which not and how many data sets each table contains. I am lacking this overview completely for influx.