[SERVER-37308] Log queries with high ratio of scanned / returned Created: 25/Sep/18 Updated: 06/Dec/22 Resolved: 23/Sep/20 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Logging |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Tomer Yakir | Assignee: | Backlog - Query Team (Inactive) |
| Resolution: | Duplicate | Votes: | 27 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||
| Assigned Teams: |
Query
|
||||||||||||||||||||
| Participants: | |||||||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||||||
| Description |
|
We should log queries with high ratio of scanned / returned regardless of their execution time to help find inefficient queries. This is now possible with For example, this filter will log queries where the ratio of index keys examined to documents returned is greater than 100:
|
| Comments |
| Comment by David Percy [ 23/Sep/20 ] |
|
This is possible now, with |
| Comment by Sergio Castro [ 01/Mar/19 ] |
|
+1 |