The following SELECT statement displays, for a given account, total CPU time and total disk accesses for all AMPs:
SELECT AccountName,SUM(CPUTime),SUM(Diskio) FROM DBC.AMPusageV WHERE AccountName=’7654’ GROUP BY AccountName;
Result:
AccountName Sum(CPUTime) Sum(DiskIO) ----------- ------------ ------------- 7654 204,352.88 5,226,742