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

Add "Query Efficiency" graph to MongoDB Cluster Summary and Replset dashes

    XMLWordPrintable

    Details

      Description

      Please add a graph showing two ratio metrics that will be used to determine 'efficiency' of queries:

      1. "Scanned Index Key vs Items Returned", Prom metric:

      mongodb_mongod_metrics_query_executor_total{state="scanned"} 3334
      

      2. "Scanned Documents vs Items Returned", Prom metric:

      mongodb_mongod_metrics_query_executor_total{state="scanned_objects"} 7040
      

      Both metrics above (#1 and #2) should be divided by the 'returned document' metric below. The result will be an efficiency ratio. Metric:

      mongodb_mongod_metrics_document_total{state="returned"} 5375
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              tim.vaillancourt Tim Vaillancourt (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: