currentOp is a MongoDB admin command that returns a document with information on operations in progress.
Studio 3T replaces the
currentOp command with a Current Operations feature, which you can access by right-clicking on any collection in the Connection Tree.
This opens a new Current Operations tab which displays data for in-progress and expired ops – if you so choose.
An effective way of spotting slow MongoDB queries is to check the Show Only Slow Ops box.
You can define what “slow” is by choosing one of four default settings: 1, 3, 10 or 30 seconds. The queries that meet this criteria will appear as results – think of it as your collection’s slow query log.
Once you’ve identified your slow MongoDB queries, choose the operation(s) you want to cancel from the results. Then, click on the Kill operation button.
In addition to current operations, you can also choose to show expired operations by checking the Retain Expired Ops box. Expired operations will appear greyed out.
You can retain all expired operations or only those executed in the last 10 seconds, 30 seconds, 1, 2, 5, or 10 minutes.
If there are multiple current operations running against your collection and you only want to show those you’ve started, check on the Show own ops only box.
To show system operations alongside user operations, check the Show Sys Ops box.
You can also decide how often to refresh current operations:
To filter only a certain type of operation, click on the corresponding icon. From left to right, the options are:
- n – none
- u – update
- i – insert
- q – query
- g – getmore
- r – remove
- k – killcursors
The Current Operations feature in Studio 3T displays this data for all operation types: