Database Test 2 Report

These results are not comparable to TPC Benchmark(TM) C Results.

Summary

Response Time (s)

Transaction

%

Average

90th %

Total

Rollbacks

%

Delivery

3.99

0.077

0.141

90857

0

0.00

New Order

45.04

0.065

0.118

1026030

10266

1.00

Order Status

4.00

0.026

0.057

91008

0

0.00

Payment

42.99

0.287

0.571

979318

0

0.00

Stock Level

3.98

0.023

0.048

90705

0

0.00

Notes:

Transaction Charts

Transaction

Response Time

Time Distribution

Delivery

txn/td-transaction-rate.png txn/td-distribution.png

New Order

txn/tn-transaction-rate.png txn/tn-distribution.png

Order Status

txn/to-transaction-rate.png txn/to-distribution.png

Payment

txn/tp-transaction-rate.png txn/tp-distribution.png

Stock Level

txn/ts-transaction-rate.png txn/ts-distribution.png

System Summary

Operating System

Charts

Profiling

Driver System(s)

potassium

GNU/Linux x86_64 6.1.12-200.fc37.x86_64

CPU Memory Blockdev Network Paging Swap

perf-report perf-trace perf-annotated-source flame-graph

Client System(s)

sodium

GNU/Linux x86_64 6.1.12-200.fc37.x86_64

CPU Memory Blockdev Network Paging Swap

perf-report perf-trace perf-annotated-source flame-graph

Database System(s)

lithium

GNU/Linux x86_64 6.1.12-200.fc37.x86_64

CPU Memory Blockdev Network Paging Swap

perf-report perf-trace perf-annotated-source flame-graph

Component Statistics per Process

Driver System(s):

Client System(s):

Database System(s):

  • lithium

PostgreSQL Report

lithium

Database Stats Charts

dbt2

Database Table Stats Charts:

public.customer public.district public.history public.item public.new_order public.order_line public.orders public.stock public.warehouse

Database Index Stats Charts:

public.customer.i_customer public.orders.i_orders public.customer.pk_customer public.district.pk_district public.item.pk_item public.new_order.pk_new_order public.order_line.pk_order_line public.orders.pk_orders public.stock.pk_stock public.warehouse.pk_warehouse

Database Tables by Metric:

analyze_count autoanalyze_count autovacuum_count heap_blks_hit heap_blks_read idx_blks_hit idx_blks_read idx_scan idx_tup_fetch n_dead_tup n_ins_since_vacuum n_live_tup n_mod_since_analyze n_tup_del n_tup_hot_upd n_tup_ins n_tup_upd seq_scan seq_tup_read tidx_blks_hit tidx_blks_read toast_blks_hit toast_blks_read vacuum_count

Database Indexs by Metric:

idx_blks_hit idx_blks_read idx_scan idx_tup_fetch idx_tup_read

Per Process Statistics