Skip to content

Latest commit

 

History

History
109 lines (94 loc) · 4.63 KB

File metadata and controls

109 lines (94 loc) · 4.63 KB

Home Assistant

Automations

Integrations

Retired integrations:

Apps

  • AppDaemon
  • ESPHome Device Builder
  • Home Assistant MCP Server
  • Open Wake World
  • Pipper
  • SQLite Web
  • Studio Code Server
  • Whsiper
  • Zigbee2MQTT Proxy

Retired apps:

  • Music Assistant Server

Dashboard add-ons

Database statistics

Top 50 entities by number of state changes in the last 7 days (604800 seconds):

WITH recent_states AS (
  SELECT
    s.metadata_id,
    s.last_updated_ts
  FROM states s
  WHERE s.last_updated_ts > strftime('%s','now') - 604800
)
SELECT
  sm.entity_id,
  COUNT(*) AS state_rows
FROM recent_states rs
JOIN states_meta sm ON rs.metadata_id = sm.metadata_id
GROUP BY sm.entity_id
ORDER BY state_rows DESC
LIMIT 50;