work_mem is the per-sort and per-hash memory budget; small values force temporary files on disk, and the default is 4 MB. SHOW prints the effective value for your session, considering the whole configuration hierarchy.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.