Query profiler only display recent 10-ish seconds records

Ask Manatees Anything
1

I turned profiler for couple of days, however, I can only see most recent occurrences for about 10 seconds, despite I opts to show 200 records, for result of last 24 hrs.

Also after couple of seconds, when I click one occurrence, there is no query code displayed.

image
image1623×251 15.4 KB

Studio 3T is 2025.5.0 Pro

2

Thanks for reaching out! Based on your description, here are a few possible reasons why you’re only seeing recent query occurrences:

  • Profiler Time Window – The profiler only shows query-type operations. If you’re looking for other slow operations, check currentOp.
  • Threshold Settings – The profiler captures queries slower than 100ms by default. If your MongoDB profiler is set to 1000ms, queries between 100–999ms won’t be recorded.
  • Capped Collection Limitation – system.profile has a fixed size. If too many slow queries are logged, older records get removed.

To investigate further, could you check:

  1. Your MongoDB profiler settings (slowms value).
  2. How many slow queries are logged per second in system.profile.

Let us know, and we’ll be happy to assist!