• Alerts and Monitoring >
• Analyze Slow Queries

Analyze Slow Queries

Cloud Manager 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.

Profile Databases

The database profiler highlights slow-running operations and key performance statistics for a specific mongod instance.

• Performance Advisor
  • Enable or Disable Performance Advisor for a Project
    • In the left navigation, click Settings under the Project section.
    • Toggle the button next to Performance Advisor and Profiler.
  • Common Reasons for Slow Queries
  • Index Considerations
  • Access Performance Advisor
    • Click Deployment.
    • 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 for Indexes
      • Log Size
  • Create Suggested Indexes
    • Behavior
    • 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.
• Profile Databases
  • Considerations
    • Security
    • system.profile Collection
    • Resource Consumption Impact
      • Data Collection
      • Data Display
    • Time to Propagate Changes to the MongoDB Agent
    • Rolling Restart of mongod Processes
  • Enable Profiling
  • Profiler Interface
    • Profiling Chart
      • Set Chart Filters
      • Change Slow Operations Threshold
      • Request Index Suggestions
    • Profiling Table

←   Monitor a Deployment Performance Advisor  →

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