Erik Darling points out that CXCONSUMER is now a wait type in SQL Server:
According to Pedro’s slide, but not the ENTIRELY MISSING DOCUMENTATION, this wait is the “safe” type of parallelism wait.
It’s a good thing Pedro is a dutiful blogger, so we don’t have to pull our hair out while unfurling these mysteries.
Speaking of documentation, our new CXCONSUMER friend isn’t mentioned in Query Store Wait Stats, either.
This is a very useful addition.