SQLite database recorder, statistics FIX PROBLEM delete/hide

Configuration
1

Hello everyone,

I need support regarding SQLite database and deleting/hiding in Developer Tools>Statistics (This entity is excluded from collection.
This entity is no longer recorded.)

The whole thing is intended to reduce the size of the SQLite database. Currently the size according to the “Add-on SQLite Web” is 2.5 GB

I adapted my database recorder in .yaml form to my needs and only selected the required sensors for the statistics recorder.

recorder:
  db_url: sqlite:////config/home-assistant_v2.db
  include:
    entities:
      - sensor.badezimmer_temperatur
      - sensor.badezimmer_luftfeuchtigkeit
    entity_globs:
      - sensor.kwh_*
      - sensor.power_*

Questions:

  1. How can you delete the old ones that were previously saved, i.e. only keep the ones you want and delete the rest?
  2. Under Developer Tools>Statistics there is a larger list with “FIX ISSUE” (This entity is excluded from collection and This entity is no longer collected.). Is it possible to delete or hide the entries?
  3. How to create the size of the database as a sensor for monitoring?
  4. Is InfluxDB necessary for long-term storage?
  5. There is an integration SQL the entries required in it are completely unfamiliar to me, does anyone know?
    a) Column for the returned query to be displayed as status
    b) Query to be executed must start with ‘SELECT’
    c) Unit of measurement (optional)

Thank you for any help!