Google App Engine - Tracking Indexes Used

Question

I have an App Engine / Python / Django app that has grown and changed over the past year and currently has 175 indexes. The problem is that I did not clean up / delete indexes that are no longer needed. Now I'm not sure which indexes are active and which are essentially dead, but I assume that about 20% of the indexes are useless.

I'm curious if there are any App Engine tools for tracking / counting the number of index hits?

If no tools are available, then one of the possible ideas is to overload the sampling method to track this information every time you access the index, but I'm not sure if this is a good idea (it can slow down), and I don’t know, t know what the best way to implement this might be.

If someone has already experienced the cleanup (search) of dead indexes, I would be interested to know about your experience.

Answer 1

The App Engine SDK tracks this to automatically create the index. Remove index.yaml and then give your app a good workout. While you click on each individual query in your testing, the SDK will generate a new index.yaml that contains only the indices you need.

Answer 2

Nose, nose-gae-index. IndexYamlUpdater SDK, , .

, ( ).