The reports in the following sections are sample output reports from the ResPsByNode and ResPsByGroup macros.
The following table describes the statistics columns, after the Date and Time columns, in the ResPsByNode output report.
| Statistics columns | Description |
|---|---|
| 1 | Node ID. |
| 2 | pWDId. |
| 3 through 12 | Summary of the Priority Scheduler statistics. |
The following table describes the statistics columns, after the Date and Time columns, in the ResPsByGroup output report.
| Statistics columns | Description |
|---|---|
| 1 | Node type. |
| 2 through 11 | Summary of the Priority Scheduler statistics. |
The following table describes the statistics columns in all output reports (with the exception of ResSpsByNode, which reports by NodeID columns, and ResSpsByGroup, which reports by NodeType column).
| Column... | Reports the... |
|---|---|
| CPU Bsy % | percent of time the CPUs are busy, based on average CPU usage per node. |
| IO Blks Sec | number of logical data blocks read or written. |
| Num Procs | average number of tasks of online nodes. |
| Num Requests | number of AMP Worker Task messages or requests that got assigned AMP Worker Tasks to them. |
| Avg QWait Time | average time in milliseconds that work requests waited on an input queue before being serviced. |
| Max QWait Time | maximum time in milliseconds that work requests waited on an input queue before being serviced. |
| Q Length | average number of messages queued for output to the host. |
| Q Len Max | maximum number of messages queued for output to the host. |
| Avg Svc Time | average time in milliseconds that work requests required for service |
| Max Svc Time | maximum time in milliseconds that work requests required for service. |
For a complete description of the above columns, see ResUsageSps Table.
ResPs Examples
exec resPsByNode(,,,,,); exec resPsByGroup(,,,);