• Monitor Your Cluster >
• Analyze Slow Queries

Analyze Slow Queries

Atlas provides several tools to help analyze slow queries being executed on your clusters.

Performance Advisor

The Performance Advisor monitors queries that MongoDB considers slow and suggests new indexes to improve query performance.

Real-Time Performance Panel

The RTPP identifies relevant database operations, evaluates query execution times, and shows the ratio of documents scanned to documents returned during query execution.

Query Profiler

The Query Profiler displays slow-running operations and their key performance statistics.

• Performance Advisor
  • Common Reasons for Slow Queries
  • Index Considerations
  • Access Performance Advisor
    • Click Clusters.
    • Click the replica set where the collection resides.
    • Click Performance Advisor.
    • Select a collection from the Collections dropdown.
    • Select a time period from the Time Range dropdown.
  • Index Suggestions
    • Index Metrics
    • Sample Queries
    • Query Targeting
    • Filter Index Suggestions
    • Limitations of Index Suggestions
      • Timestamp Format
      • Log Size
      • Log Quantity
  • Create Suggested Indexes
    • Behavior and Limitations
    • Procedure
      • For the index you want to create, click Create Index.
      • (Optional) Specify the index options.
      • (Optional) Set the Collation options.
      • (Optional) Enable building indexes in a rolling fashion.
      • Click Review.
      • In the Confirm Operation dialog, confirm your index.
• Query Profiler
  • Considerations
    • Security
    • Data Analysis Limitations
    • Data Display Limitations
  • Enable and Disable Profiling
  • Profiler Interface
    • Profiling Chart
    • Profiling Table
• Real-Time Performance Panel
  • Enable or Disable Real-Time Performance Panel for a Project
    • Click Settings.
    • Toggle the button next to Real-Time Performance Panel.
  • Access Real-Time Performance Panel
    • Click Clusters.
    • Click the cluster whose current operations you want to evaluate.
    • Click the member of the replica set that you want to view.
    • Click Real Time.
    • (Optional) Click Pause to stop RTPP from displaying incoming data. Click Play to resume.
  • Graph View
    • Read Exact Metrics from Graph View
  • Table View

←   Monitor Your Cluster Performance Advisor  →

© MongoDB, Inc 2008-present. MongoDB, Mongo, and the leaf logo are registered trademarks of MongoDB, Inc.