Show user accumulated query time per query shape in performance tab
Provide a histogram of commonly slow queries since entering the performance tab or pressing PLAY. Same as hottest queries but over time. Sum the query milliseconds over each invocation of the query shape.
While one specific query may be slow at any given time. The best practice in performance troubleshooting is to optimize the queries that are consuming the maximum total time when aggregated together. So, a relatively fast query that is extremely common may consume more resources in the mongod than a very rare query that is relatively slower.
3
votes
AdminMassimiliano
(Admin, MongoDB)
shared this idea
-
Hayi Gak
commented
This would be extremely useful! I posted a related idea here: https://feedback.mongodb.com/forums/924283-compass/suggestions/40963537-historical-log-of-slow-operations