optimize_states_table

import utils
delete_states = """
delete FROM hassdb.states where entity_id in (select entity_id from hassdb.states where
entity_id in ('sensor.memory_free', 'sensor.processor_use', 'sensor.time', 'sensor.ram_available', 'sensor.cpu_used', 'sensor.cpu_speed', 'sensor.ram_free')
or entity_id like '%docker%' and last_updated < DATE_SUB( NOW() , INTERVAL 0 DAY ));
"""

utils.execute(delete_states)
utils.execute('optimize TABLE hassdb.states;')