| New Order Transactions per Minute (notpm): | 8482.31 |
| Scale Factor: | 1000 |
| Test Duration (min.): | 59.30 |
| Ramp-up Time (min.): | 17.35 |
| Total Unknown Errors: | 0 |
Mon Dec 8 12:34:11 PST 2008
|
|
| Transaction | Response Time | Rollbacks | Charts | |||||
|---|---|---|---|---|---|---|---|---|
| Name | Mix % | Total | Average (s) | 90th % | Total | % | Response Time | Time Distribution |
| Delivery | 3.99 | 44959 | 11.89 | 13.39 | 0 | 0.00 |  |
 |
| New Order | 45.10 | 508055 | 10.67 | 11.89 | 5054 | 0.99 |  |
 |
| Order Status | 4.03 | 45409 | 10.41 | 11.67 | 0 | 0.00 |  |
 |
| Payment | 42.86 | 482790 | 10.40 | 11.69 | 0 | 0.00 |  |
 |
| Stock Level | 4.03 | 45352 | 10.28 | 11.54 | 0 | 0.00 |  |
 |
| Operating System: | Linux 2.6.23-9.ydl6.1 | Settings | ||
| Database: | PostgreSQL 8.3.5 | Settings | Query Plans | Raw Data |
Comment: 1000 warehouse baseline
Command line: /usr/local/bin/dbt2-run-workload -a pgsql -d 3600 -w 1000 -o baseline.1000.1 -H community6 -s 100 -b 1000 -c 100 -z 1000 warehouse baseline
DB:
community9:
| Database System | community9 | |
|---|---|---|
| Overall Processor Utilization |  |
 |
| Individual Processor Utilization |  |
 |
| Processor Context Switches |  |
 |
| Memory Usage |  |
 |
| % Memory Usage |  |
 |
| % Disk Utilization |  |
 |
| I/O Throughput |  |
 |
| I/O Requests per Second |  |
 |
| Network Packets Received |  |
 |
| Network Packets Transmitted |  |
 |
| Network Bytes Received |  |
 |
| Network Bytes Transmitted |  |
 |
| Network Error Receiving |  |
 |
| Network Error Transmitting |  |
 |
| Network Transmission Collisions |  |
 |
| Table Blocks Read |  |
| Table Blocks Hit |  |
| Table Rows Dead |  |
| Sequential Scans |  |
| Inserts |  |
| Updates |  |
| HOT Updates |  |
| Index Blocks Read |  |
| Index Blocks Hit |  |
| Index Scans |  |
| Database System | community9 | |
|---|---|---|
| Swap Reads |  |
|
| Swap Writes |  |
|
| Swap Canceled Writes |  |
|
| Page Cache Reads |  |
|
| Page Cache Writes |  |
|
| Page Cache Cancelled Writes |  |
|
| PostgreSQL Auto Vacuum Reads |  |
|
| PostgreSQL Page Cache Writes |  |
|
| PostgreSQL Page Cache Canceled Writes |  |
|
| PostgreSQL WAL Reads |  |
|
| PostgreSQL WAL Writes |  |
|
| PostgreSQL WAL Canceled Writes |  |
|
| PostgreSQL Writer Reads |  |
|
| PostgreSQL Writer Writes |  |
|
| PostgreSQL Writer Canceled Writes |  |
|
| PostgreSQL Reads |  |
|
| PostgreSQL Writes |  |
|
| PostgreSQL Canceled Writes |  |