Database Test 3 Load Test Details

Kernel and Application Profiles

[Linux perf: report | annotated source | trace]

Database Details

Charts

Processor

sar-cpu0.png

sar-cpu10.png

sar-cpu11.png

sar-cpu12.png

sar-cpu13.png

sar-cpu14.png

sar-cpu15.png

sar-cpu1.png

sar-cpu2.png

sar-cpu3.png

sar-cpu4.png

sar-cpu5.png

sar-cpu6.png

sar-cpu7.png

sar-cpu8.png

sar-cpu9.png

sar-cpu-all.png

sar-cpu.png

Block Devices

sar-blockdev-avgqu.sz.png

sar-blockdev-avgrq.sz.png

sar-blockdev-await.png

sar-blockdev-sda-rw.png

sar-blockdev-tps.png

sar-blockdev-util.png

Database

db-stat-dbt3-blocks.png

db-stat-dbt3-connections.png

db-stat-dbt3-xacts.png

Tables

table-stat-customer-heap_blks_hit.png

table-stat-customer-heap_blks_read.png

table-stat-customer-idx_blks_hit.png

table-stat-customer-idx_blks_read.png

table-stat-customer-idx_scan.png

table-stat-customer-idx_tup_fetch.png

table-stat-customer-n_dead_tup.png

table-stat-customer-n_live_tup.png

table-stat-customer-n_tup_del.png

table-stat-customer-n_tup_hot_upd.png

table-stat-customer-n_tup_ins.png

table-stat-customer-n_tup_upd.png

table-stat-customer-seq_scan.png

table-stat-customer-seq_tup_read.png

table-stat-customer-toast_blks_read.png

table-stat-lineitem-heap_blks_hit.png

table-stat-lineitem-heap_blks_read.png

table-stat-lineitem-idx_blks_hit.png

table-stat-lineitem-idx_blks_read.png

table-stat-lineitem-idx_scan.png

table-stat-lineitem-idx_tup_fetch.png

table-stat-lineitem-n_dead_tup.png

table-stat-lineitem-n_live_tup.png

table-stat-lineitem-n_tup_del.png

table-stat-lineitem-n_tup_hot_upd.png

table-stat-lineitem-n_tup_ins.png

table-stat-lineitem-n_tup_upd.png

table-stat-lineitem-seq_scan.png

table-stat-lineitem-seq_tup_read.png

table-stat-lineitem-toast_blks_read.png

table-stat-nation-heap_blks_hit.png

table-stat-nation-heap_blks_read.png

table-stat-nation-idx_blks_hit.png

table-stat-nation-idx_blks_read.png

table-stat-nation-idx_scan.png

table-stat-nation-idx_tup_fetch.png

table-stat-nation-n_dead_tup.png

table-stat-nation-n_live_tup.png

table-stat-nation-n_tup_del.png

table-stat-nation-n_tup_hot_upd.png

table-stat-nation-n_tup_ins.png

table-stat-nation-n_tup_upd.png

table-stat-nation-seq_scan.png

table-stat-nation-seq_tup_read.png

table-stat-nation-toast_blks_read.png

table-stat-orders-heap_blks_hit.png

table-stat-orders-heap_blks_read.png

table-stat-orders-idx_blks_hit.png

table-stat-orders-idx_blks_read.png

table-stat-orders-idx_scan.png

table-stat-orders-idx_tup_fetch.png

table-stat-orders-n_dead_tup.png

table-stat-orders-n_live_tup.png

table-stat-orders-n_tup_del.png

table-stat-orders-n_tup_hot_upd.png

table-stat-orders-n_tup_ins.png

table-stat-orders-n_tup_upd.png

table-stat-orders-seq_scan.png

table-stat-orders-seq_tup_read.png

table-stat-orders-toast_blks_read.png

table-stat-part-heap_blks_hit.png

table-stat-part-heap_blks_read.png

table-stat-part-idx_blks_hit.png

table-stat-part-idx_blks_read.png

table-stat-part-idx_scan.png

table-stat-part-idx_tup_fetch.png

table-stat-part-n_dead_tup.png

table-stat-part-n_live_tup.png

table-stat-part-n_tup_del.png

table-stat-part-n_tup_hot_upd.png

table-stat-part-n_tup_ins.png

table-stat-part-n_tup_upd.png

table-stat-part-seq_scan.png

table-stat-part-seq_tup_read.png

table-stat-partsupp-heap_blks_hit.png

table-stat-partsupp-heap_blks_read.png

table-stat-partsupp-idx_blks_hit.png

table-stat-partsupp-idx_blks_read.png

table-stat-partsupp-idx_scan.png

table-stat-partsupp-idx_tup_fetch.png

table-stat-partsupp-n_dead_tup.png

table-stat-partsupp-n_live_tup.png

table-stat-partsupp-n_tup_del.png

table-stat-partsupp-n_tup_hot_upd.png

table-stat-partsupp-n_tup_ins.png

table-stat-partsupp-n_tup_upd.png

table-stat-partsupp-seq_scan.png

table-stat-partsupp-seq_tup_read.png

table-stat-partsupp-toast_blks_read.png

table-stat-part-toast_blks_read.png

table-stat-region-heap_blks_hit.png

table-stat-region-heap_blks_read.png

table-stat-region-idx_blks_hit.png

table-stat-region-idx_blks_read.png

table-stat-region-idx_scan.png

table-stat-region-idx_tup_fetch.png

table-stat-region-n_dead_tup.png

table-stat-region-n_live_tup.png

table-stat-region-n_tup_del.png

table-stat-region-n_tup_hot_upd.png

table-stat-region-n_tup_ins.png

table-stat-region-n_tup_upd.png

table-stat-region-seq_scan.png

table-stat-region-seq_tup_read.png

table-stat-region-toast_blks_read.png

table-stat-supplier-heap_blks_hit.png

table-stat-supplier-heap_blks_read.png

table-stat-supplier-idx_blks_hit.png

table-stat-supplier-idx_blks_read.png

table-stat-supplier-idx_scan.png

table-stat-supplier-idx_tup_fetch.png

table-stat-supplier-n_dead_tup.png

table-stat-supplier-n_live_tup.png

table-stat-supplier-n_tup_del.png

table-stat-supplier-n_tup_hot_upd.png

table-stat-supplier-n_tup_ins.png

table-stat-supplier-n_tup_upd.png

table-stat-supplier-seq_scan.png

table-stat-supplier-seq_tup_read.png

table-stat-supplier-toast_blks_read.png

table-stat-time_statistics-idx_scan.png

table-stat-time_statistics-seq_scan.png

table-stat-time_statistics-seq_tup_read.png

Indexes

index-stat-pk_nation-idx_blks_hit.png

index-stat-pk_nation-idx_blks.png

index-stat-pk_nation-idx_blks_read.png

index-stat-pk_nation-idx_scan.png

index-stat-pk_nation-idx_tup_fetch.png

index-stat-pk_nation-idx_tup_read.png

index-stat-pk_region-idx_blks_hit.png

index-stat-pk_region-idx_blks.png

index-stat-pk_region-idx_blks_read.png

index-stat-pk_region-idx_scan.png

index-stat-pk_region-idx_tup_fetch.png

index-stat-pk_region-idx_tup_read.png