MixedAggregate
Short Description
The MixedAggregate node uses hash tables to group rows and can provide sorted output
Detailed Description​
The MixedAggregate node builds hash tables to group data at multiple levels and can provide sorted output. MixedAggregate can consume large amounts of memory as the hash tables are built. This node can be seen in CUBE operations.
Additional Links​
- PostgreSQL Documentation - GROUPING SETS, CUBE, and ROLLUP
- 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.