Performance Advisor -> Schema Anti-patters

MongoDB Atlas
,
1

Hi,

Looking at my cluster I clicked the “Performance Advisor” to see if there were any useful indexes I could create. Appeared I have what I need (no slow queries for now). The I selected the tab “Schema Anti-patters”. This displays a potential problem:

Reduce the size of documents

ISSUES FOUND

  • Average document size is over 2 MB in the collection(s) scanned

However the particular collection has no document in that size range, and the statistic for the colection say:
COLLECTION SIZE: 30.42MB
TOTAL DOCUMENTS: 4838
So I would estimate about 6Kb per document. Which is confirmed when I export a single document as JSON. What could be happening here?

Thanks for any clues,

Leo

2

Hi Leo,

The anti-patern is triggered when there is at-least one document in the sample that exceeds 2MB. So, the messaging is actually wrong in the UI. We will fix that

Thanks for flagging!

Rez

1 Like
3

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.