[SERVER-42574] Explain Plan: show regex performance (nr of steps) Created: 01/Aug/19 Updated: 06/Dec/22 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Minor - P4 |
| Reporter: | Massimiliano Marcon | Assignee: | Backlog - Query Execution |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Query Execution
|
||||||||
| Participants: | |||||||||
| Description |
|
The Explain Plan is quite interesting. Maybe use a regex debugging library to compute the number of steps a regex takes to complete. For example: https://metacpan.org/pod/Regexp::Debugger The idea is to give the users the awareness of performance penalties for regular expression queries, especially complex ones that backtrack a lot. |