Optimize Your Home Assistant Database

rm  /home/homeassistant20221103/.homeassistant/.storage/tmp*

The database only has state and event history.
https://community.home-assistant.io/t/wth-is-the-data-in-storage-not-in-the-recorder-database/475527/2?u=msly

Try it with last_updated in your querys.
There were changes in the database.

https://community.home-assistant.io/t/sql-sensor-returned-no-results/431712/2?u=msly

https://data.home-assistant.io/docs/states/#database