MongoDB Performance Advisor

Copied!

Generated at: 2025-12-22T06:16:29.813090

1001

Profiler entries

Databases scanned

Query shapes with recommendations

Index Recommendations

Efile_Log_Dev.Request_Response_Log ( samples) — severity: critical

Index missing

Caused By Query: db.getSiblingDB('Efile_Log_Dev').getCollection('Request_Response_Log').find({}).sort({"Created_Date_Time": -1})

Causing Query Stats:

Execution Time: 723 ms
Docs Examined: 630682
Plan Summary: COLLSCAN

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 ( samples) — severity: critical

Index missing

Caused By Query:

db.getSiblingDB('Efile_Log_Dev').getCollection('Request_Response_Log').find({"LinkReturnDetailEntryId": "cde885d409609d4ab3c76dec017a0471"}).sort({"Created_Date_Time": -1})

Causing Query Stats:

Execution Time: 465 ms
Docs Examined: 630682
Plan Summary: COLLSCAN

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 ( samples) — severity: medium

Index missing

Caused By Query:

db.getSiblingDB('Instant_TinMatching_Dev').getCollection('Instant_TinMatching_Details').find({"Status": {"$ne": "ERROR"}, "_id": {"$ne": "fffd9c8990a60e48bbae65137bec1e14"}, "$or": [{"FullNm": {"$not": {"$regex": "^Robert\\ 85\\ Lucas\\ Martin\\ 85\\ George\\ 85$", "flags": 2}}, "HashTIN": "a91c064581658714acce553100fa8f7ac9db5c043f07c000104fbfbc7e2a2eab", "IsDeleted": false}, {"ShortenedHashTin": null, "FullNm": {"$regex": "^Robert\\ 85\\ Lucas\\ Martin\\ 85\\ George\\ 85$", "flags": 2}, "IsDeleted": false}]}).sort({"Created_Date_Time": -1})

Causing Query Stats:

Execution Time: 56 ms
Docs Examined: 18125
Plan Summary: IXSCAN { Status: -1, IsDeleted: -1 }

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})

LinkDB_Dev_2022.Link_Return_Status ( samples) — severity: medium

Index missing

Caused By Query:

db.getSiblingDB('LinkDB_Dev_2022').getCollection('Link_Return_Status').find({"SubmissionUpdates.StateStatus": {"$in": ["Service_Request_Validated", "Service_Validated_Error"]}, "SubmissionUpdates.BusValStatus": {"$in": ["SUCCESS", "BUSVAL_REJECTED", "ERROR", "SUBMISSIONERROR"]}, "SubmissionUpdates.TaxYear": "2025", "SubmissionUpdates.FormType": {"$in": ["FORMW2", "FORMW2PR", "FORMW2C"]}, "IsDeleted": false, "SubmissionUpdates.UserEmail": {"$nin": ["tbsexceptions1099efile@spantechnologyservices.com"]}})

Causing Query Stats:

Execution Time: 58 ms
Docs Examined: 32203
Plan Summary: COLLSCAN

Suggested Index: {'IsDeleted': 1, 'SubmissionUpdates.BusValStatus': 1, 'SubmissionUpdates.FormType': 1, 'SubmissionUpdates.StateStatus': 1, 'SubmissionUpdates.TaxYear': 1, 'SubmissionUpdates.UserEmail': 1}

Create Index Command:

db.getSiblingDB('LinkDB_Dev_2022').getCollection('Link_Return_Status').createIndex({"IsDeleted": 1, "SubmissionUpdates.BusValStatus": 1, "SubmissionUpdates.FormType": 1, "SubmissionUpdates.StateStatus": 1, "SubmissionUpdates.TaxYear": 1, "SubmissionUpdates.UserEmail": 1})

LinkDB_Dev_2022.Link_Return_Detail ( samples) — severity: medium

Index missing

Caused By Query:

db.getSiblingDB('LinkDB_Dev_2022').getCollection('Link_Return_Detail').find({"SubmissionDetails.SubmissionId": {"$in": ["5d7fc59d7f6cb242bff75e97e792f853", "063d96caaa59b44eb689ca4a7f1e1b02", "9c4a1cb9f383df41a4e61932d8b47dfa", "79f66d631f383d43ba92c3dcfbbf9b62", "97093a836e2ea44f84492c204b86545e", "a2b022e89fb81840a5b8438c19827a8d", "fe9006c500dca44aa540e8dd72472f09", "cd76e492ec04f74aa2f105ec3cbd0679", "25ec99fb8bab0445af43f6d9e1b1bdc6", "b105f3a4b28dd343a8e49970cc7cc9bf", "c7303344d0043a40b30fd47dde8e19a6", "aa09d78b18dc8a41af82afd3395fa7b5"]}, "SubmissionDetails.IsStateFiling": true, "IsDeleted": false})

Causing Query Stats:

Execution Time: 51 ms
Docs Examined: 32248
Plan Summary: COLLSCAN

Suggested Index: {'IsDeleted': 1, 'SubmissionDetails.IsStateFiling': 1, 'SubmissionDetails.SubmissionId': 1}

Create Index Command:

db.getSiblingDB('LinkDB_Dev_2022').getCollection('Link_Return_Detail').createIndex({"IsDeleted": 1, "SubmissionDetails.IsStateFiling": 1, "SubmissionDetails.SubmissionId": 1})