====== Database Cleanup ======

===== Work out usage =====
From ; https://community.home-assistant.io/t/how-to-keep-your-recorder-database-size-under-control/295795
  SELECT
    COUNT(*) as cnt,
    SUM(LENGTH(event_data)) as bytes,
    event_type
  FROM events
  GROUP BY event_type
  ORDER BY cnt DESC

and 

  SELECT
    COUNT(*) AS cnt,
    COUNT(*) * 100 / (SELECT COUNT(*) FROM states) AS cnt_pct,
    SUM(LENGTH(attributes)) AS bytes,
    SUM(LENGTH(attributes)) * 100 / (SELECT SUM(LENGTH(attributes))  FROM states) AS bytes_pct,
    entity_id
  FROM states
  GROUP BY entity_id
  ORDER BY cnt DESC
Delete enitities records;
  DELETE FROM states where entity_id IN ('sensor.temperature' , 'sensor.battery_temperature' , 'sensor.28_63e8d4122101_temperature', 'sensor.battery_voltage');
Backup the database;
  sudo rm -f /volume2/cctv/backups/1_backup.db
  sudo sqlite3 /volume3/sudo sqlite3 /volume3/docker-storage/home-assistant/config/home-assistant_v2.db ".backup /volume2/cctv/backups/1_backup.db"/home-assistant/config/home-assistant_v2.db ".backup /volume2/cctv/backups/1_backup.db"