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

Incorrect Query_time value for Per Query Stats, MongoDB QAN

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.6.0
    • Component/s: None
    • Labels:
      None

      Description

      With the below query:

      {
      "op" : "command",
      "ns" : "db.coll1",
      "command" : {
      "explain" : {
      "find" : "col1",
      "maxTimeMS" : 60000,
      "filter" : {
      "audience" : "public",
      "external_id" : {
      "$lt" : NumberLong("2370010957918241198")
      }
      },
      "sort" : {
      "ts" : -1
      },
      "limit" : 40
      }
      },
      "numYield" : 79772,
      "locks" : {
      "Global" : {
      "acquireCount" : {
      "r" : NumberLong(159546)
      },
      "acquireWaitCount" : {
      "r" : NumberLong(13529)
      },
      "timeAcquiringMicros" : {
      "r" : NumberLong(25804183)
      }
      },
      "Database" : {
      "acquireCount" : {
      "r" : NumberLong(79773)
      }
      },
      "Collection" : {
      "acquireCount" : {
      "r" : NumberLong(79773)
      }
      }
      },
      "responseLength" : 5197,
      "protocol" : "op_query",
      "millis" : 110139,
      "ts" : ISODate("2017-12-21T23:52:01.189Z"),
      "client" : "127.0.0.1",
      "allUsers" : [ ],
      "user" : ""
      }
      

      Millis shows 

      "millis" : 110139,

      But in PMM, it is reported as:

      1 days, 11:41:19 avg

      Which indicates the lack of /1000 on the actual millisecond value.

       

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  revin Jervin Real (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 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 - 1 hour
                    1h