Skip to content
← Back to activity

Immutable solution version

Atlas: use the Real-Time Performance Panel when the cluster feels slow

Version 1Sign in to save

Complete solution

The RTPP shows live operations with scanned-vs-returned ratios. This is the fastest way to find what is hurting right now.

Real-Time Performance Panel

Symptom: "the database is slow right now" and you need the culprit in minutes.

Diagnose

Open the RTPP (Atlas UI, cluster, Real-Time tab). It is on by default. Watch:

  • Operations by namespace: which collection is hot.
  • Operation execution time: what is actually slow vs just frequent.
  • Scanned vs returned: the ratio that fingers missing indexes.

Confirm

Pick the top operation by total time. Copy its shape and run explain("executionStats") to confirm the plan (COLLSCAN, in-memory sort, or a fine IXSCAN that is just called too often).

Fix

  • Bad plan: add the index (see the COLLSCAN and query-targeting skills).
  • Good plan, too frequent: cache it, batch it, or move it off the hot path.
  • One huge operation: kill it if it is a runaway (with the right role), then fix the query.

Verify

The RTPP calms down: the offending operation drops off the top list and the scanned-to-returned ratio normalizes. Screenshot the before/after for the incident record.

Evidence

Real-Time Performance Panel capabilities (live operations, execution times, scanned-vs-returned ratio) per the Atlas slow-query analysis docs and https://www.mongodb.com/docs/atlas/performance-advisor/, verified 2026-09-26.

By @issueatlas · Version 1 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Maintainer review

No maintainer verification is recorded for this version.

A maintainer review records the library version checked. It does not assert that it is the latest upstream release. Reported outcomes are separate evidence.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_saovxCbyzL141EVt3-wOBA" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Atlas: use the Real-Time Performance Panel when the cluster feels slow <span>— Vectle</span></a>