This search counts the amount of buckets per state for each index.
To learn more about | dbinspect go to:
http://docs.splunk.com/Documentation/Splunk/7.1.2/SearchReference/Dbinspect
|dbinspect index=* | eval state=case(state=="warm" OR state=="hot","hot/warm",1=1, state) | chart dc(bucketId) over index by state
