Real Time Dashboard - Refresh rate under 30 Seconds

dazzer78 · January 28, 2020, 2:59pm

Hi

I am trying to get into the data dashboard as real time as possible, currently i can get the refresh rate at 30 seconds ( ?refresh=30 ) .
The queries behind the data take less than 0.5 secs to return data so are very ligytweight

Is there anyway to get this to say 5 seconds ?

jesse · January 29, 2020, 4:38am

Redash limits the minimum refresh rate to 30 seconds. I tried unsuccessfully to overwrite the settings on my local build. The JS hard limits to 30 seconds even when the Python allows a lower limit. If you want to tinker further the files are linked below.

Javascript

github.com

getredash/redash/blob/master/client/app/pages/dashboards/hooks/useRefreshRateHandler.js

import { isNaN, max, min } from "lodash";
import { useEffect, useState, useRef, useMemo } from "react";
import location from "@/services/location";
import { policy } from "@/services/policy";

function getLimitedRefreshRate(refreshRate) {
  const allowedIntervals = policy.getDashboardRefreshIntervals();
  return max([30, min(allowedIntervals), refreshRate]);
}

function getRefreshRateFromUrl() {
  const refreshRate = parseFloat(location.search.refresh);
  return isNaN(refreshRate) ? null : getLimitedRefreshRate(refreshRate);
}

export default function useRefreshRateHandler(refreshDashboard) {
  const [refreshRate, setRefreshRate] = useState(getRefreshRateFromUrl());

  // `refreshDashboard` may change quite frequently (on every update of `dashboard` instance), but we
  // have to keep the same timer running, because timer will restart when re-creating, and instead of

This file has been truncated. show original

Python

https://github.com/getredash/redash/blob/master/redash/settings/init.py#L409

vocong25 · March 24, 2020, 3:03am

Hi @jesse, your solution works. Now refresh rate in my dashboard is 10sec. Thank you so much!

mstfldmr · May 21, 2020, 10:22pm

Hi @vocong25,
How did you refresh in 10s? Is it possible to refresh even quicker?
Can you share your code?

stefan · June 1, 2020, 11:38pm

Hi @vocong25 - I’m also interested in how you got a faster refresh time.

artemacuev · May 11, 2021, 7:44pm

Hi! Maybe you understood how to fix it?

▼Categories

▼Tags

Real Time Dashboard - Refresh rate under 30 Seconds

Javascript

Python