InfluxDB GUI in Supervisor → Explore
Overview:
SHOW MEASUREMENTS ON "homeassistant" SHOW TAG KEYS ON "homeassistant" FROM "<measurement_name> eg: °C"
Query template:
USE "<***db_name***>"; DELETE FROM "<***measurement_name***>" WHERE "<***tag***>" = '***tag_value***' AND time < '2021-04-04'
Example:
USE "homeassistant"; DELETE FROM "°C " WHERE "entity_id" = 'tasmota_analog_temperature_2' AND time < '2021-04-04'
Drop series example
USE "homeassistant"; DROP SERIES FROM "A" WHERE "entity_id"='nh_2_energy_channel_c_current'
Verwandte Artikel
Add Comment