How to get the last update of the index in elasticsearch

Question

How can I find datetime of last update of the elsasticsearch index? Elasticsearch index last update time I tried to follow the example , but nothing happened .

curl -XGET 'http://localhost:9200/_all/_mapping'
{"haystack":{"mappings":{"modelresult":{"_all":{"auto_boost":true},"_boost":{"name":"boost","null_value":1.0},"properties":{"act_name":{"type":"string","boost":1.3,"index_analyzer":"index_ngram","search_analyzer":"search_ngram"},"django_ct":{"type":"string","index":"not_analyzed","include_in_all":false},"django_id":{"type":"string","index":"not_analyzed","include_in_all":false},"hometown":{"type":"string","boost":0.9,"index_analyzer":"index_ngram","search_analyzer":"search_ngram"},"id":{"type":"string"},"text":{"type":"string","analyzer":"ngram_analyzer"}}},"mytype":{"_timestamp":{"enabled":true,"store":true},"properties":{}}}}}

curl -XPOST localhost:9200/your_index/your_type/_search -d '{
  "size": 1,
  "sort": {
    "_timestamp": "desc"
  },
  "fields": [
    "_timestamp"
  ]
}'
{"took":2,"timed_out":false,"_shards":{"total":5,"successful":5,"failed":0},"hits":{"total":99,"max_score":null,"hits":[{"_index":"haystack","_type":"modelresult","_id":"account.user.96","_score":null,"sort":[-9223372036854775808]}]}}

What is wrong?

Val · Answer 1 · 2015-09-18T04:00:43.890

0

First, what you need to do is to proceed like in that linked question and enable the _timestamp field in your mapping.

{
    "modelresult" : {
        "_timestamp" : { "enabled" : true }
    }
}

Then you can query your index for a single document with the most recent timestamp like this:

curl -XPOST localhost:9200/haystack/modelresult/_search -d '{
  "size": 1,
  "sort": {
    "_timestamp": "desc"
  },
  "fields": [
    "_timestamp"
  ]
}'

edited Sep 18 '15 at 04:00

answered Sep 16 '15 at 03:29

Val

207,596
13
358
360

which means your_type? Where can I see it? – Иван Янковой Sep 16 '15 at 07:45
It's the name of your mapping type, but since it wasn't mentioned in your question, I just added a placeholder. You may replace it with whatever mapping type name you have. – Val Sep 16 '15 at 10:56
I added requests to the question – Иван Янковой Sep 17 '15 at 10:17
Have you re-indexed your data after adding the `_timestamp` field? – Val Sep 18 '15 at 04:01
Yes, I did it. The result has not changed. – Иван Янковой Sep 18 '15 at 06:32
Can you provide the steps you did, with the exact index and type names you've used in your queries? – Val Sep 18 '15 at 06:34
No I can not. I use the haystack with django and I do not see direct requests . – Иван Янковой Sep 18 '15 at 11:09

How to get the last update of the index in elasticsearch

1 Answers1