CPU is consumed by the manipulation of queries in memory.
It tends to get costly when working with queries that process large amounts of data, and, correspondingly, a lot of memory. The result of the latter is usually that you'll generally care a lot more about memory usage than about CPU usage.