InfluxDB information (database size) as sensor in Home Assistant

Configuration
8

Me too. So my sensor definition currently looks like:

sensor:
  - platform: influxdb
    host: a0d7b954-influxdb
    port: 8086
    username: !secret influxdb_user
    password: !secret influxdb_pass
    scan_interval: 3600
    queries:
      - name: InfluxDB DB size
        unit_of_measurement: MB
        value_template: "{{ (value|float / 1024 /1024)|round(1) }}"
        group_function: sum
        measurement: '"monitor"."shard"'
        database: _internal
        where: "time > now() - 10s"
        field: diskBytes

Additionally I excluded this sensor in my general InfluxDB integration part to not have redundant information in the InfluxDB (same information two times with different names - nope, I don´t need that :-))

influxdb:
  host: a0d7b954-influxdb
  port: 8086
  database: !secret influxdb_daba
  username: !secret influxdb_user
  password: !secret influxdb_pass
  max_retries: 5
  default_measurement: state
  exclude:
    entities:
      - sensor.influxdb_db_size

Too bad all those information only give an estimation. Well, at least the differences (growing of the database) can be monitored/used in HA.