Can we get an idea of the amount of memory being consumed by category, for instance, the amount  used to store the results of the sub-query, the amount consumed by intermediate joint results, the amount used by the sort, the amount used by the grouping and aggregation.  The more detail the better of course, but I understand there may be a limit to how much detail we can  have available.


[Non-text portions of this message have been removed]