You can configure OpenLIT dashboards to automatically refresh data at set intervals. This feature is essential for live monitoring dashboards, status boards, and any view that requires up-to-date metrics from ClickHouse.
Why use refresh intervals? Refresh intervals allow you to:
Keep data fresh without manual reloads and automatically re-run queries behind the scenes
Power live dashboards for operations and support teams
Monitor real-time metrics
How to enable auto-refresh VIDEO
Once set, the dashboard will automatically re-fetch data from ClickHouse at the selected interval.
Available refresh rate Interval Use Case Never Static dashboards 30 seconds Live dashboards, production stats 1 minute Standard monitoring (default) 5 minutes Low-frequency updates 10 minutes Less load on db
Available time intervals Range Description Example Use Case 24H Last 24 hours from now Real-time metrics, active users, API logs 7D Last 7 calendar days Weekly trends, retention, issue tracking 1M Last 1 calendar month Revenue analysis, product adoption 3M Last 3 calendar months Quarterly metrics, strategic reviews Custom Select any start and end date manually Audits, investigations, historical views
Snippet to make use of the time interval in the query:
WHERE event_time BETWEEN {{ filter . timeLimit . start }} AND {{ filter . timeLimit . end }} Use shorter intervals only for optimized queries. Long-running queries + high refresh rates can overload your ClickHouse backend.
Best practices
Use dynamic bindings like {{filter.timeLimit.start}}, {{filter.timeLimit.end}} to make your chart respond to dashboard time filters.
Avoid using LIMIT 1000 or wide result sets on high-frequency updates
Use refresh intervals in combination with pinned dashboards for kiosk or ops setups
