MongoDB Performance Advisor

Generated at: 2025-12-12T13:01:12.644645

432

Profiler entries

Databases scanned

Query shapes with recommendations

Index Recommendations

Efile_Log_Dev.Request_Response_Log (1 samples) — severity: critical

Index missing

Query Diagnostics

Suggested Index:
{'Created_Date_Time': -1}

Create Index Command: db.getSiblingDB('Efile_Log_Dev').getCollection('Request_Response_Log').createIndex({"Created_Date_Time": -1})

Efile_Log_Dev.Request_Response_Log (1 samples) — severity: critical

Index missing

Query Diagnostics

Suggested Index:
{'Created_Date_Time': -1, 'LinkReturnDetailEntryId': 1}

Create Index Command:

db.getSiblingDB('Efile_Log_Dev').getCollection('Request_Response_Log').createIndex({"Created_Date_Time": -1, "LinkReturnDetailEntryId": 1})

Instant_TinMatching_Dev.Instant_TinMatching_Details (1 samples) — severity: medium

Index missing

Query Diagnostics

Suggested Index:
{'Created_Date_Time': -1, 'Status': 1, '_id': 1}

Create Index Command:

db.getSiblingDB('Instant_TinMatching_Dev').getCollection('Instant_TinMatching_Details').createIndex({"Created_Date_Time": -1, "Status": 1, "_id": 1})

SpanPostal_Dev.LetterRequestData (1 samples) — severity: low

Index missing

Query Diagnostics

Suggested Index:
{'UpdatedDate': -1}

Create Index Command: db.getSiblingDB('SpanPostal_Dev').getCollection('LetterRequestData').createIndex({"UpdatedDate": -1})

SpanPostal_Dev.RequestResponseLog (1 samples) — severity: medium

Index missing

Query Diagnostics

Suggested Index:
{'CreatedTimeStamp': -1, 'IsDeleted': 1}

Create Index Command:

db.getSiblingDB('SpanPostal_Dev').getCollection('RequestResponseLog').createIndex({"CreatedTimeStamp": -1, "IsDeleted": 1})

SpanPostal_Dev.LetterRequestData (2 samples) — severity: medium

Index missing

Query Diagnostics

Suggested Index:
{'UpdatedDate': -1}

Create Index Command: db.getSiblingDB('SpanPostal_Dev').getCollection('LetterRequestData').createIndex({"UpdatedDate": -1})

SpanPostal_Dev.LetterRequestData (1 samples) — severity: medium

Index missing

Query Diagnostics

Suggested Index:
{'UpdatedDate': -1}

Create Index Command: db.getSiblingDB('SpanPostal_Dev').getCollection('LetterRequestData').createIndex({"UpdatedDate": -1})