EXPLAIN - Limit
Takes data from a child node and produces sorted output, using either memory if available (depending on the
work_mem setting) or “spilling” to disk. This is obviously necessary if the output needs to be sorted, though sometimes the input can be scanned in an already-sorted manner instead—e.g., if scanning a btree index compatible with the desired sort order.
- Sort Key
- Sort Method
- Sort Space Type
- Sort Space Used
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →