You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT mean("diskBytes") AS "mean_diskBytes" FROM "_internal"."monitor"."tsm1_filestore" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND "database"='home_assistant' GROUP BY time(:interval: ) FILL(null)
or
SELECT mean("diskBytes") AS "mean_diskBytes" FROM "_internal"."monitor"."shard" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND "database"='home_assistant' GROUP BY time(:interval:) FILL(null)
shows 47 mb
Sensor in Home Assistant:
sensor:
- platform: influxdb
username: homeassistant
password: xxxxxxxxxxx
scan_interval: 10 #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() - 5m'
where: '"database"=''homeassistant'' AND time > now() - 5m'
field: diskBytes
shows 32 195,6 MB
The actual size of the database on disk is 1.17 Gb
Expected behavior
The actual size of the database on disk is 1.17 Gb
Before the addon influxdb update, the sensor showed the correct database size
Problem/Motivation
Query in influxdb Explorer
SELECT mean("diskBytes") AS "mean_diskBytes" FROM "_internal"."monitor"."tsm1_filestore" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND "database"='home_assistant' GROUP BY time(:interval: ) FILL(null)
or
SELECT mean("diskBytes") AS "mean_diskBytes" FROM "_internal"."monitor"."shard" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND "database"='home_assistant' GROUP BY time(:interval:) FILL(null)
shows 47 mb
Sensor in Home Assistant:
sensor:
- platform: influxdb
username: homeassistant
password: xxxxxxxxxxx
scan_interval: 10 #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() - 5m'
where: '"database"=''homeassistant'' AND time > now() - 5m'
field: diskBytes
shows 32 195,6 MB
The actual size of the database on disk is 1.17 Gb
Expected behavior
The actual size of the database on disk is 1.17 Gb
Before the addon influxdb update, the sensor showed the correct database size
Actual behavior
shows 47 mb or 32 gb
Steps to reproduce
Rpi 3, 1 Mb RAM, 32 Gb SD
Swap 1 gb
HA Supervisor 2024.06.0
Core 2024.4.2
InfluxDB addon 5.0.0
DB influxdb ~1.2 gb, duration 1200d
Proposed changes
The text was updated successfully, but these errors were encountered: