Grafana Dashboard Panel Query with join over longer duration timeout

  • What Grafana version and what operating system are you using?
    9.03
  • What are you trying to achieve?
    query that uses the service display_name to view process_cpu metrics from windows_exporter
  • How are you trying to achieve it?
    using a join query (and other similar):
sum((rate(windows_process_cpu_time_total{process!="Idle"}[$__rate_interval])) * on(instance, process_id) group_left(display_name) windows_service_info{display_name=~"$process"}) without (mode,process_id)
  • What happened?
    Panel timeout when time duration is longer like 2 days

  • What did you expect to happen?
    that it works

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    net/http: timeout awaiting response headers

  • Did you follow any online instructions? If so, what is the URL?
    this query was recommended solution from this forum and windows_exporter project