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

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • 1.6.0
    • None
    • 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.

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              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

                  Smart Checklist