I ran TPCH query 17 with sf 1000. Here is the query:
One of the hash agg operators has resized 6 times. It should have 4M buckets. But the profile shows it has 64K buckets.
I have attached a sample profile. In this profile, the hash agg operator is (04-02).