How can curator delete empty indices?

We are using rollover with curator with max_age + max_size. In our automated index creation process we create multiple indices (think environments like like, dev, test, pre-prod etc ) BUT all of these indices are not always used so there can be 0 documents in them.

When an index is rolled over (creation_date > max_age) our index is not removed since we use field_stats filter and remove indices by timestamp.

I have not found a way to remove empty indices, can anyone help we out with this?

Regards /Johan

Field stats can’t do a document count on an empty index. You’ll have to figure out a different attribute to identity your indices. creation_date is still available, and index name.

You may also have to use your own scripting with the _cat API to identify empty indices and delete them with curl, or a similar tool.

Thanks @theuntergeek,

I only want to check if doc_count is 0, nothing else. I already exclude all indices with a write alias. Is it still not possible?

I could easily fix this with ansible and the http api but it would be nice if curator could fix it for me.

Regards /Johan

There is no doc count filter, so you'd have to do some other clever work with filters to use other metrics if you wanted to use Curator. Either that, or script up some python using the Curator API.


Ok, I understand. Is a doc count filter something that would be of interest for curator if I try to add this feature?
Regards /Johan


I can see from the code that there already is a filter_empty function but it is not exposed as a filter (
A simple (not sure if it is the best though) would be to expose this as a new filter

- filtertype: empty
exclude: False

Or is there any reason why this would not fit in curator?

Regards /Johan

Oh, yeah. I did make that. It's used on line 301. I haven't exposed it for general use, but I suppose since it's there, it could be.

It would need to be added to:

  • Documentation
  • The filter schema(s)
  • ???

There are already tests for it, so I think that might be all that's required to add it.

Great! I am on it, I will send and PR.


This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.