andrii29 / mongodb-profiler-exporter Goto Github PK

As can be seen in the image, the panel where slow queries should be displayed is not showing the data.

Upon checking the panel configuration, there is an error that I couldn't fix.

Query:
sum(rate(slow_queries_count_total{job=~"$job", ns=~"$ns", query_hash=~"$query_hash" }[$__range])) by (query_hash, ns) * on (query_hash, ns) group_left(op, plan_summary, query_framework, query_shape) slow_queries_info

execution: found duplicate series for the match group {ns="maischat_db.contacts", query_hash="FB0D13D4"} on the right hand-side of the operation: [{__name__="slow_queries_info", db="maischat_db", instance="monitor-eveo.maischat.io:80", job="mongodb-exporter-maischat-new-0", ns="maischat_db.contacts", op="query", plan_summary="IXSCAN { tenant: 1 }", query_hash="FB0D13D4", query_shape="{'find': '?', 'filter': {'tenant': '?', '$or': [{'whatsappId': {'$exists': '?'}}, {'messengerId': {'$exists': '?'}}, {'instagramId': {'$exists': '?'}}]}, 'sort': {'name': '?'}, 'returnKey': '?', 'showRecordId': '?'}"}, {__name__="slow_queries_info", db="maischat_db", instance="monitor-eveo.maischat.io:80", job="mongodb-exporter-maischat-new-0", ns="maischat_db.contacts", op="query", plan_summary="IXSCAN { name: 1 }", query_hash="FB0D13D4", query_shape="{'find': '?', 'filter': {'tenant': '?', '$or': [{'whatsappId': {'$exists': '?'}}, {'messengerId': {'$exists': '?'}}, {'instagramId': {'$exists': '?'}}]}, 'sort': {'name': '?'}, 'returnKey': '?', 'showRecordId': '?'}"}];many-to-many matching not allowed: matching labels must be unique on one side

i'm getting this error on grafana dashboard "slow queries panel" both query A & B
would you please suggest?

execution: found duplicate series for the match group {ns="nytaxi.nyGreenTaxi", query_hash="8880B5AF"} on the right hand-side of the operation: [{db="nytaxi", instance="10.63.20.14:9179", job="mongodb-profiler", ns="nytaxi.nyGreenTaxi", op="command", query_framework="classic", query_hash="8880B5AF", query_shape="{'explain': {'find': '?', 'filter': {}, 'skip': '?', 'maxTimeMS': '?'}, 'verbosity': '?'}"}, {db="nytaxi", instance="10.63.20.14:9179", job="mongodb-profiler", ns="nytaxi.nyGreenTaxi", op="command", plan_summary="COUNT_SCAN { _id: 1 }", query_framework="classic", query_hash="8880B5AF", query_shape="{'aggregate': '?', 'pipeline': [{'$match': {}}, {'$count': '?'}], 'hint': '?', 'maxTimeMS': '?'}"}];many-to-many matching not allowed: matching labels must be unique on one side

query A

query B

My MongoDB server version: 5.0.5

#84 query_framework = result[0]["queryFramework"]

This option is not available in our mongo slow log, which indicator is it?

My English is not very good, thank you for your help