Slow Query Log¶
Scenarios¶
Slow query logs record statements whose execution period exceeds the value of operationProfiling.slowOpThresholdMs (100 ms by default). With slow query logs, you can identify and optimize slowly executed statements.
Note
If the user would like to change this, they can do this in Section Modifying a Parameter Template.
Procedure¶
On the Instance Management page, click the target DB instance.
In the navigation pane on the left, click Slow Query Logs.
On the Slow Query Logs page, set search criteria and click Search to view log information.
Log records of all shards or a shard-specific node of a cluster instance
Log records of all nodes of a replica set instance
Slow query statements of the following level
All statements
INSERT
QUERY
UPDATE
REMOVE
GETMORE
COMMAND
You can view up to 2,000 slow query logs of a specified node type, of a specified statement type, and within a specified period.