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

        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

                    Smart Checklist