Приводим БД в порядок
https://homeusmart.blogspot.com/2024/08/dboptimize.html?m=1
#HomeAssistant #sql
https://homeusmart.blogspot.com/2024/08/dboptimize.html?m=1
SELECT
states_meta.entity_id,
COUNT(states.state_id) AS record_count,
ROUND(SUM(LENGTH(state_attributes.shared_attrs)) / 1024.0 / 1024.0, 2) AS data_size_mb
FROM
states
LEFT JOIN state_attributes ON states.attributes_id = state_attributes.attributes_id
LEFT JOIN states_meta ON states.metadata_id = states_meta.metadata_id
GROUP BY
states_meta.entity_id
ORDER BY
data_size_mb DESC
LIMIT 30;
#HomeAssistant #sql
Blogspot
77. Оптимизация базы данных в Home Assistant.
Оптимизация базы данных Home Assistant