Sort
Short Description
The Sort node takes data from a child node and outputs sorted data
Detailed Description
The Sort node takes data from a child node and outputs sorted data. The sort will be performed in memory if it fits within the memory allocated by thework_mem setting, otherwise it will be ‘spilled’ to disc. If the required sort order and columns are satisfied by an available index, the actual sorting step may be avoided altogether.
Additional Links
- PostgreSQL Documentation - Using Explain
- pgAnalyze - Explain
- eTutorials - Understanding How PostgreSQL Executes a Query
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.