Correct use of indicies


(Paul Cardy) #1

Hello all,

We're currently using logstash's one-day-per-index model of indices. This is working well within Kibana but I'm struggling to find information on how we should be limiting the number indices queried when writing our own queries. From what I understand, I can either list the filters, potentially with wildcards, in the query URI or add them to the Indices filter in the query itself. My first question is, are these two ways of specifying indices analogous? This post suggests that best practice is to put them on the URI:

This leads to my second question, if my indices are time based, how should I restrict the query to indices falling within the date range I'm interested in? If this is a whole month or year it's easy (just use a wildcard), but what if it's four weeks out of the month, do I have to list each of the 28 indicies within that range to the URI and/or filter? What does Kibana do?


(Mark Walkom) #2

KB 4.2 (will) handles that via https://www.elastic.co/guide/en/elasticsearch/reference/2.0/search-field-stats.html


(Paul Cardy) #3

Hi Warklom, thanks for the reply. I was aware of that new feature, but I'm struggling to understand how it will help. Could you explain?


(Mark Walkom) #4

It's a shortcut that lets someone look into any index and find (eg) the min and max documents within a timeframe.


(system) #5