Sorting results in Elasticsearch - Step-by-Step Execution

Concept Flow - Sorting results

Receive search query

↓

Parse query and sort parameters

↓

Execute search on index

↓

Sort results by specified field(s)

↓

Return sorted results to user

The search query is received and parsed, then the results are sorted by the specified field(s) before returning.

Execution Sample

Elasticsearch

{
  "query": { "match_all": {} },
  "sort": [ { "price": { "order": "asc" } } ]
}

This query fetches all documents and sorts them by the 'price' field in ascending order.

Execution Table

Step	Action	Sort Field	Sort Order	Result Order (IDs)
1	Receive query	-	-	-
2	Parse query and sort	price	asc	-
3	Execute search	-	-	[doc1, doc2, doc3, doc4] (unsorted)
4	Sort results by price ascending	price	asc	[doc3 (10), doc1 (20), doc4 (30), doc2 (40)]
5	Return sorted results	-	-	[doc3, doc1, doc4, doc2]

💡 All documents sorted by price ascending and returned.

Variable Tracker

Variable	Start	After Step 3	After Step 4	Final
query	null	{"match_all":{}}	{"match_all":{}}	{"match_all":{}}
sort	null	[{"price":{"order":"asc"}}]	[{"price":{"order":"asc"}}]	[{"price":{"order":"asc"}}]
results	null	[doc1(20), doc2(40), doc3(10), doc4(30)]	[doc3(10), doc1(20), doc4(30), doc2(40)]	[doc3(10), doc1(20), doc4(30), doc2(40)]

Key Moments - 2 Insights

Why do the results change order only after step 4?

Because the search execution (step 3) returns unsorted results, and only at step 4 does the sorting by the specified field happen, changing the order.

What happens if no sort parameter is given?

If no sort is specified, Elasticsearch returns results in its default relevance order, so no explicit sorting step occurs as shown in the table.

Visual Quiz - 3 Questions

Look at the execution table, what is the order of document IDs after step 4?

A [doc2, doc4, doc1, doc3]

B [doc3, doc1, doc4, doc2]

C [doc1, doc2, doc3, doc4]

D [doc4, doc3, doc2, doc1]

💡 Hint

Check the 'Result Order (IDs)' column at step 4 in the execution_table.

At which step does Elasticsearch parse the sort parameters?

A Step 3

B Step 1

C Step 2

D Step 5

💡 Hint

Look at the 'Action' column in the execution_table for parsing actions.

If the sort order changed to descending, how would the final order look?

A [doc2, doc4, doc1, doc3]

B [doc3, doc1, doc4, doc2]

C [doc1, doc2, doc3, doc4]

D [doc4, doc3, doc2, doc1]

💡 Hint

Descending order means highest price first; check the prices in variable_tracker.

Concept Snapshot

Sorting results in Elasticsearch:
- Use the 'sort' field in the query JSON.
- Specify field and order (asc or desc).
- Elasticsearch sorts results after search execution.
- Default is relevance if no sort given.
- Multiple fields can be used for sorting.

Full Transcript

This visual execution trace shows how Elasticsearch processes a search query with sorting. First, the query and sort parameters are received and parsed. Then the search executes, returning unsorted results. Next, Elasticsearch sorts these results by the specified field and order. Finally, the sorted results are returned to the user. Variables like 'query', 'sort', and 'results' change state through these steps. Key points include understanding when sorting happens and what default behavior is if no sort is specified. The quiz questions help reinforce these steps by referencing the execution table and variable states.