Advertisement
techblog

optimize_events_table

Aug 16th, 2019
526
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.21 KB | None | 0 0
  1. import utils
  2. utils.execute('DELETE FROM hassdb.events WHERE time_fired < DATE_SUB( NOW() , INTERVAL 0 DAY) and context_id not in (select context_id from states);')
  3. utils.execute('OPTIMIZE TABLE hassdb.event;')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement