SELECT process.processKey,user,cmd,
MAX(readHeld+writeHeld)-MAX(readWait+writeWait)
AS compute
FROM tableUse JOIN process USING (processKey)
GROUP BY tableUse.processKey
ORDER BY compute DESC LIMIT 200;
| # | Change | User | Description | Committed | |
|---|---|---|---|---|---|
| #1 | 6466 | Stephen Moon | track2sql and other script files added |