DBQL tables have a column ProcID which identifies the owner VPROC for running the logged query. We only have the number of AMPs involved, max AMPs etc. columns in every row but we don't know if the AMPs listed in the # of AMPs belong to the same node that the owner VPROC belongs to.
I observed that the owner VPROC is always the PE. Is it always the case?
And does the DBQLStepTbl provide the ProcID of all the VPROCs responsible for the execution of queries involving AMPs as well?