SQL Sensor performance

Regarding sql sensors.
How often/under what conditions are they updated?
I can see some good uses for sql sensors, but I’m a bit worried about the performance.

The sensor platform polls every 30sec by default.

You can change this: Entity integration platform options - Home Assistant

Thanks. I guess the performance hit isn’t going to be noticable with a reasonable interval.

Is it possible to force a sql (or other polling) sensor update outside of the automatic interval updates? That would be useful in many situations.

Sure. Just set a really long update interval (years) then use an automation to update it whenever you want by calling the homeassistant.update_entity service inthe actions.

1 Like