Docs Menu
Docs Home
/
MongoDB Cloud Manager
/
Monitor Your Deployments
/
Analyze Slow Queries

Monitor Collection-Level Query Latency

On this page

  • Considerations
  • Access Query Insights
  • Filter Query Insights
  • View Chart Metrics
  • Manage Pinned Namespaces from the Dialog
  • Manage Pinned Namespaces from the Table
  • Select Namespaces to Chart
  • Edit Columns
  • Go to a Collection

Monitor collection-level query latency with Query Insights. The Query Insights page displays two charts and a table with information for each top or pinned namespace. The information includes query latency metrics and statistics for certain hosts and operation types. You can manage pinned namespaces and choose up to five namespaces to show in the corresponding query latency charts.

Considerations

  • The Query Insights page is supported only for MongoDB 4.4.2 or later and the MongoDB Agent 13.8.1.8563-1 or later.

  • If you have Queryable Encryption enabled for a collection, Query Insights doesn't display the collection in this location. Cloud Manager redacts this information.

  • Cloud Manager displays top namespaces by default. Depending on the time range, a namespace might fall in and out of the monitored list. Cloud Manager interpolates missing data when at least one host metric exists in both ends of the time range. If MongoDB Atlas encounters missing data, dotted lines connect the available data points.

  • If you reach the data limit for a page load, the following error message appears:

    Chart data limit reached. Try a smaller time window or fewer hosts.

  • The Query Insights page doesn't support time series collections.

Access Query Insights

To access Query Insights:

1

In MongoDB Cloud Manager, go to the Deployment page for your project.

  1. If it is not already displayed, select the organization that contains your desired project from the Organizations menu in the navigation bar.

  2. If it's not already displayed, select your desired project from the Projects menu in the navigation bar.

  3. If the Deployment page is not already displayed, click Deployment in the sidebar.

    The Deployment page displays.

2

Go to Query Insights.

  1. Click View Monitoring for that instance in the project panel.

  2. Click the Query Insights tab.

Filter Query Insights

You can filter Namespace Insights by host state, hosts, time intervals, and a time range.

To filter Query Insights:

1

(Optional) Filter by host state, shard, or host.

Note

Filters apply to the host state and shards at the time of metric collection.

Do one of the following:

  • Filter by host state:

    1. Expand the Filter by Hosts drop-down menu.

    2. Click the Select Primaries or Select Secondaries checkbox.

  • Filter by shard:

    1. Specify a shard in the Filter by Hosts search box.

    2. Select a shard from the Filter by Hosts drop-down menu.

  • Filter by hosts:

    1. Specify hosts in the Filter by Hosts search box.

    2. Select hosts from the Filter by Hosts drop-down menu.

2

(Optional) Filter by time interval.

Select one of the following time intervals to filter by:

  • 7 days

  • 24 hours

  • 12 hours

  • 8 hours

  • 1 hour

3

(Optional) Filter by time range.

  1. Click the Filter by time range drop-down menu.

  2. Specify a time range.

  3. Click Apply Dates.

The data in the charts and table that Query Insights displays refreshes.

View Chart Metrics

You can view different metrics and operations.

To adjust the metrics and operation types:

1

Select the metrics to display.

Select one of the following metrics:

Metric
Description
Total latency
Rate that indicates the total combined server operation duration on a collection (total combined server operation duration / collection interval in seconds).
Average latency
Total server operation duration divided by the total server operation count.
P50 latency
50th percentile in the latency histogram.
P95 latency
95th percentile in the latency histogram.
P99 latency
99th percentile in the latency histogram.
Operation count
Rate that indicates the total number of server operations performed on a collection (total server operations / collection interval)
2

Select the operation type to display.

Select one of the following operation types:

  • All operation types

  • Read

  • Write

  • Command

Manage Pinned Namespaces from the Dialog

You can search and pin a maximum of five namespaces to the top of the table from the Pinned Namespace dialog.

To manage pinned namespaces from the dialog:

1

Open the Pinned Namespaces dialog.

  • If you have no pinned namespaces, click the Pin namespaces button that appears in the top center of the table.

  • If you have pinned namespaces, click the Manage pinned namespaces button that appears in the upper-right corner of the table.

2

Search the namespaces.

Specify a namespace in the Enter namespaces to pin search box.

3

Pin the namespace.

Click the namespace that you want to pin.

Note

You can pin a maximum of five namespaces. If you have five namespaces and want to pin another, you must unpin one. You can also pin planned namespaces that don't exist yet.

4

(Optional) Unpin a namespace.

Click Unpin next to the namespace that you want to unpin.

Manage Pinned Namespaces from the Table

You can search and pin a maximum of five namespaces to the top of the table from the table.

To manage pinned namespaces from the table:

1

Search the table.

Specify a namespace in the Search namespaces search box.

2

Pin the namespace.

  1. Click the icon next to the namespace that you want to pin.

  2. Click Pin.

Note

You can pin a maximum of five namespaces. If you have five namespaces and want to pin another, you must unpin one. You can also pin planned namespaces that don't exist yet.

3

(Optional) Unpin a namespace.

  1. Click the icon next to the namespace that you want to unpin.

  2. Click Unpin.

Select Namespaces to Chart

MongoDB Atlas displays up to five namespaces. It displays pinned namespaces (if any) and then top namespaces with the highest total latency by default. You can also manually select the namespaces to chart.

To select namespaces:

1

Search the table.

Specify a namespace in the Search namespaces search box.

2

Select the namespace to display in the charts.

Click the checkbox next to the namespace.

Note

You can select a maximum of five namespaces. If you have five namespaces and want to display another, you must deselect one.

Edit Columns

Cloud Manager displays the following table columns by default for pinned namespaces (if any) and top namespaces:

  • Total latency for all operation types

  • Average latency for all operation types

  • P95 latency for all operation types

  • Operation Count for all operation types

To adjust the metric and operation type columns:

1

Expand the Edit Columns drop-down.

Click the Edit Columns button.

2

Select the columns to display and hide.

  1. Expand the metrics to display or hide.

  2. Select the operation types to display.

  3. Deselect the operation types to hide.

3

View the columns.

  1. Click inside the table to close the drop-down.

  2. Scroll to the right to view columns beyond the edge of the screen width.

Go to a Collection

You can go to a collection in the Data Explorer the from the table.

To go to a collection:

1

Search the table.

Specify a namespace in the Search namespaces search box.

2

Go to a collection.

  1. Click the icon next to the namespace for the collection that you want to view.

  2. Click Go to collection.

Back

Review Drop Index Recommendations

Next

Profile Databases