[SERVER-3401] Add faults/idx-miss to explain and profiler output Created: 09/Jul/11  Updated: 06/Dec/22  Resolved: 22/May/18

Status: Closed
Project: Core Server
Component/s: Index Maintenance, Querying
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Scott Hernandez (Inactive) Assignee: Backlog - Query Team (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-8108 add page faults to profile output Closed
is duplicated by SERVER-17360 Log when a query causes a page fault Closed
Related
related to SERVER-10448 Revamp explain() formatting Closed
Assigned Teams:
Query
Participants:

 Description   

It would be helpful to have the number of soft/hard faults which happen during an op/query (including index misses) so we can better understand the cost, and performance anomalies.



 Comments   
Comment by Eric Milkie [ 22/May/18 ]

Tracking page faults at this granularity will not be useful.

Comment by Scott Hernandez (Inactive) [ 08/Jan/13 ]

Currently we track faults per process not during operations because many can be running concurrently and it is hard (possibly impossible) to tell which operation is the cause of the fault.

Generated at Thu Feb 08 03:02:58 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.