Docs Menu
Docs Home
/
MongoDB Atlas
/ /

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.

  • The Namespace Insights tab is supported only for Atlas M10+ clusters running MongoDB 4.4.2 or later.

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

To access Namespace Insights:

1
  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 is not already displayed, select your desired project from the Projects menu in the navigation bar.

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

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

  2. Click the Query Insights tab.

The Namespace Insights tab display by default.

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

To filter Namespace Insights:

1

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

Select one of the following time intervals to filter by:

  • 7 days

  • 24 hours

  • 12 hours

  • 8 hours

  • 1 hour

3
  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.

You can view different metrics and operations.

To adjust the metrics and operation types:

1

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 one of the following operation types:

  • All operation types

  • Read

  • Write

  • Command

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
  • 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

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

3

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

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

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

Specify a namespace in the Search namespaces search box.

2
  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
  1. Click the icon next to the namespace that you want to unpin.

  2. Click Unpin.

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

Specify a namespace in the Search namespaces search box.

2

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.

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

Click the Edit Columns button.

2
  1. Expand the metrics to display or hide.

  2. Select the operation types to display.

  3. Deselect the operation types to hide.

3
  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.

You can go to a collection in the Atlas UI from the table.

To go to a collection:

1

Specify a namespace in the Search namespaces search box.

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

  2. Click Go to collection.

← Enable or Disable