Monitor Collection-Level Query Latency
On this page
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.
Access Query Insights
To access Query Insights:
Go to the Deployment page for your project.
If it is not already displayed, select the organization that contains your desired project from the Organizations menu in the navigation bar.
If it is not already displayed, select your desired project from the Projects menu in the navigation bar.
If the Deployment page is not already displayed, click Deployment in the sidebar.
Go to Query Insights.
Click View Monitoring for that instance in the project panel.
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:
(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:
Expand the Filter by Hosts drop-down menu.
Click the Select Primaries or Select Secondaries checkbox.
Filter by shard:
Specify a shard in the Filter by Hosts search box.
Select a shard from the Filter by Hosts drop-down menu.
Filter by hosts:
Specify hosts in the Filter by Hosts search box.
Select hosts from the Filter by Hosts drop-down menu.
(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
(Optional) Filter by time range.
Click the Filter by time range drop-down menu.
Specify a time range.
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:
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) |
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:
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.
Search the namespaces.
Specify a namespace in the Enter namespaces to pin search box.
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.
(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:
Search the table.
Specify a namespace in the Search namespaces search box.
Pin the namespace.
Click the icon next to the namespace that you want to pin.
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.
(Optional) Unpin a namespace.
Click the icon next to the namespace that you want to unpin.
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:
Search the table.
Specify a namespace in the Search namespaces search box.
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:
Expand the Edit Columns drop-down.
Click the Edit Columns button.
Select the columns to display and hide.
Expand the metrics to display or hide.
Select the operation types to display.
Deselect the operation types to hide.
View the columns.
Click inside the table to close the drop-down.
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:
Search the table.
Specify a namespace in the Search namespaces search box.
Go to a collection.
Click the icon next to the namespace for the collection that you want to view.
Click Go to collection.