Skip to main content

EXPRESS_CLUSTERED_IXSCAN

Short Description

Optimized clustered index scan

Detailed Description​

EXPRESS_CLUSTERED_IXSCAN is a specialized execution stage in MongoDB (introduced in 8.0) that stands for "express clustered index scan."

What does it mean?

  • When you have a collection with a clustered index (data physically organized according to the order of a specific field, often _id), MongoDB can perform extremely efficient scans through the collection using this index.
  • If your query is simple enough, MongoDB can bypass the normal, full query planning process and use this express path, labeled as EXPRESS_CLUSTERED_IXSCAN in your explain plan.

In simple terms:

EXPRESS_CLUSTERED_IXSCAN means:

  • MongoDB quickly scanned your collection using its clustered index.
  • Your query was handled in a highly optimized way, making the operation faster and more resource-efficient.
  • This is even more direct than a regular index scan because all the data is already organized along the indexed field.

When will you see it?

  • You’ll see EXPRESS_CLUSTERED_IXSCAN for queries that can be satisfied by a simple, direct lookup or scan on a clustered collection, usually where the query is on the clustered field.

Do you need to do anything?

  • No action is needed! If your collection uses a clustered index and your query fits the pattern, MongoDB automatically uses this optimization.

Summary:

EXPRESS_CLUSTERED_IXSCAN means MongoDB handled your query in the fastest way possible by leveraging the clustered index, skipping the normal query planning, and scanning data in an optimized, express manner.

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.