Docs Menu
Docs Home
/
MongoDB Atlas
/
Monitor Clusters
/
Analyze Slow Queries

Monitor Collection-Level Query Latency

On this page

  • Considerations
  • Access Namespace Insights
  • Filter Namespace 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

Only available on M10+ clusters

Monitor collection-level query latency with Namespace Insights. The Namespace Insights page displays two charts and a table with information for each top or pinned namespace. The information includes 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 Namespace Insights tab is supported only for Atlas M10+ clusters.

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

  • Atlas displays top namespaces by default. Depending on the time range, a namespace might fall in and out of the monitored list. Atlas interpolates missing data when at least one host metric exists in both ends of the time range. If 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 Namespace Insights tab doesn't support time series collections.

Access Namespace Insights

To access Namespace Insights:

1

In Atlas, go to the Clusters page for your project.

  1. If it's 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 it's not already displayed, click Clusters in the sidebar.

    The Clusters page displays.

2

Go to Namespace Insights.

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

  2. Click the Query Insights tab.

The Namespace Insights tab display by default.

Filter Namespace Insights

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

To filter Namespace Insights:

1

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

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.

      Note

      Analytics nodes appear with secondary nodes.

  • 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 time 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 box.

To manage pinned namespaces from the dialog box:

1

Open the Pinned Namespaces dialog box.

  • 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

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

Atlas 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 Atlas UI 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

Enable or Disable

Next

Query Performance