Need to get latest 2 records

Elastic Stack Elasticsearch
1

Hi,

i need a query to fetch last and 2nd last record entered the index.

What should be the query other than putting size: 2 after sorting and all?

thanks

2

Do you have a timestamp in your document?

3

yes its there

4

So a sort on timestamp with size=2 should work, right?

5

it's working but another way.....

6

So? Is that ok?

7

is this is not the efficient way,
we are extracting all the documents and just displaying the top one (or two).
how to write a query which just extracts only these 2 records?

8

I don't understand. Why is this not efficient? What is the query you wrote?

9

this is not efficient coz query is fetching ALL the records but displaying only 1.
is it possible that the query only will fetch 1 record from the index (1 or 2 records)

this is according to me,
please let me know if i am not correct on this.

10

This is wrong. Just give it a try and if it's too slow, share what you did.

And if you want it to be super fast, use https://www.elastic.co/guide/en/elasticsearch/reference/current/index-modules-index-sorting.html

11

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