This is a rough list of things that have been observed to have an obvious impact in performance.

• Listing tag visits with excludeBots=true. When the condition is added, the sub-query no longer uses the index and performance drops dramatically.
• Matching a short URL in loose mode. In this case, the short code index is not used.