Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-1967

Inconsistent formulas in Prometheus Dashboards

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.7.0
    • Component/s: Grafana Dashboards
    • Labels:
      None

      Description

      Hi,

      https://pmmstage.percona.com/dashboard/db/prometheus-exporters-overview?refresh=1m&orgId=1&var-interval=$__auto_interval&var-host=mongors1wt&var-host=mongors2mmapv1

      If we specify only couple of hosts not "All" the Avg CPU Usage Per Host
      shows all hosts still, rather than specified hosts, while Prometheus
      Prometheus Exporter Use By Host shows only selected ones which produce
      inconsistent picture as above

      We need to adjust formulas for singlestat panels such as

      avg((sum(rate(process_cpu_seconds_total

      {job!="prometheus"}[$interval])) by
      (instance) or sum(irate(process_cpu_seconds_total{job!="prometheus"}

      [5m]))
      by (instance)) / count(node_cpu

      {mode="user"}

      ) by (instance)) by ()*100

      To filter by Instance as well:

      process_cpu_seconds_total

      {instance=~"$host",job!="prometheus"}

      [$interval])

      [image: Inline image 1]


      Peter Zaitsev, CEO, Percona
      Tel: +1 888 401 3401 ext 7360 Skype: peter_zaitsev

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                pz Peter Zaitsev
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 20 minutes
                    20m