Executed in parallel with a N-way hash scan.
Executed in parallel with a N-way partition scan.
For each step in the query that accesses data in parallel, showplan prints the number of worker processes used for the scan, and the type of scan, either “hash” or “partition.”
