Delete Home Assistant Historic Entity Data

Find the ID number of the entity.

SELECT * FROM "statistics_meta" WHERE statistic_id="sensor.fronius_solar_panels";

Delete statistics related to entity
All

DELETE FROM "statistics" WHERE metadata_id = '144';
DELETE FROM "statistics_short_term" WHERE metadata_id = '144';

Range

DELETE FROM "statistics" WHERE metadata_id = '144' AND start BETWEEN '2025-02-14 10:15:00' AND '2025-02-14 13:15:00';
DELETE FROM "statistics_short_term" WHERE metadata_id = '144' AND start BETWEEN '2025-02-14 10:15:00' AND '2025-02-14 13:15:00';