GroupAggregate aggr Operator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off. SORT: Operators and steps used when queries have to sort or merge result sets. Sort sort Sort performs the sorting specified by the ORD...
nodeid integer Plan node identifier, where a node maps to one or more steps in the execution of the query. parentid integer Plan node identifier for a parent node. A parent node has some number of child nodes. For example, a merge join is the parent of the scans on the joined table...