Loading...

XML

Word

Printable

JSON

Type: New Feature
Resolution: Done
Priority: Minor - P4
Fix Version/s: 3.1.8
Affects Version/s: None
Component/s: None
Labels:

Backwards Compatibility:
Major Change
Sprint:
Query 2.7.8, Quint Iteration 7, QuInt 8 08/28/15, Quint 9 09/18/15
Confidence Status:
None
Work Order:
3

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name:
None
Goal Link:
None

It would be useful to be able to get stats from individual indexes about how often they are used. You can see whether a specific query uses certain indexes using explain() but this would allow you to easily see if the index is being used at all. It could just be a simple incrementing counter every time the index gets used.

depends on

SERVER-19504 Remove indexStats command artifacts

Closed

is duplicated by

SERVER-2006 Flag unused indexes on the database server

Closed

SERVER-15224 Basic index stats

Closed

SERVER-18245 Tracking of indexes being used

Closed

SERVER-20735 Store date of last use for each index

Closed

SERVER-4202 Add a way to get stats on number of queries that hit an index, per collection

Closed

SERVER-7318 Implement index lastUsed timestamp

Closed

is related to

SERVER-23655 CollectionInfoCache is not invalidated when starting an index build

Closed

SERVER-5828 Metric/Stats Tracking

Closed

related to

SERVER-9306 Ability to temporarily forbid query optimizer from using index ("invisible index")

Closed

SERVER-20509 Create shell helper for cluster index stats analysis

Closed

SERVER-2178 Track stats per db/collection

Closed

SERVER-16245 Expose index statistics for WiredTiger

Closed

(2 is duplicated by, 2 is related to, 4 related to)

Assignee:: James Wahlin
Reporter:: David Mytton
Participants:: Avi Vaisenberger, David Mytton, Githook User, James Wahlin, Jeremy, Matthieu Rigal, Matt Wormley, Nader Akhnoukh, Patrick Pittich-Rinnerthaler, Prashanth Kokati, rgpublic, Richard K., Sam Darwin, Thomas DeMille
Votes:: 90 Vote for this issue
Watchers:: 71 Start watching this issue

Created:: Dec 15 2010 10:40:56 AM UTC
Updated:: Dec 11 2019 07:07:00 PM UTC
Resolved:: Sep 03 2015 08:33:21 PM UTC
Confidence Status Last Update:: 01/Oct/14 6:40 PM

Details

Description

Attachments

Issue Links

Activity

People

Dates