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

QPS/Sum values don't match with QPS/Sum on Query details

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 2.28.0
    • 2.30.0
    • QAN App
    • Yes
    • 3
    • Yes
    • Yes
    • Yes
    • [obsolete] C/S Core

    Description

      STR:

      1. Install PMM 2.28.0
      2. Add PDPGSQL to monitoring
      3. Run sysbench read-only script, for example:
         /usr/share/sysbench/oltp_point_select.lua  --rate=0 --db-driver=pgsql --pgsql-user=postgres
        --pgsql-db=sbtest  --percentile=99 --time=1000 --threads=1 --report-interval=10 --tables=1
        --table_size=1000000 --rand-type=uniform run
      4. Open QAN page in a few minutes and select last 30 min period
      5. Click on Total
      6. Compare QPS values

      Actual result:
      See QPS, Sum and and Query time:

      Expected result: Values should match.

      I checked the same for not so intensive load and in this case the values were the same.
      See:

      Additional information: With pg_statements everything looks ok

      I checked the same scenario for MySQL and found that we have the same problem

      And the same problem exists for Mongo. I think all DB are affected in case of time range like from 2022-06-10 06:20:00 to 2022-06-10 06:20:00

      Attachments

        Issue Links

          Activity

            People

              nurlan.moldomurov Nurlan Moldomurov
              nailya.kutlubaeva Nailya Kutlubaeva
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist