Database Test 3 Report

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

Summary

Metrics

Composite Score

6583.532

Load Test Time (hours)

.13

CPU Memory Blockdev Network Swap

Power Test Score

9130.818

CPU Memory Blockdev Network Swap

Throughput Test Score

4746.88

CPU Memory Blockdev Network Swap

Query Times

q_time.png

Power Test

  • Seed: 601232222

Duration (seconds)

Query Start Time

RF1 Start Time

RF2 Start Time

Query End Time

RF1 End Time

RF2 End Time

216.21

2022-06-01 23:22:43.55

2022-06-01 23:22:26.91

2022-06-01 23:26:02.94

2022-06-01 23:26:02.72

2022-06-01 23:22:43.54

2022-06-01 23:26:03.10

Query

Response Time (seconds)

1

31.50

Plan | Result

2

4.42

Plan | Result

3

10.99

Plan | Result

4

1.57

Plan | Result

5

10.42

Plan | Result

6

4.43

Plan | Result

7

7.76

Plan | Result

8

2.39

Plan | Result

9

18.41

Plan | Result

10

9.18

Plan | Result

11

1.67

Plan | Result

12

8.73

Plan | Result

13

27.21

Plan | Result

14

4.40

Plan | Result

15

11.09

Plan | Result

16

3.45

Plan | Result

17

0.11

Plan | Result

18

31.19

Plan | Result

19

0.14

Plan | Result

20

2.89

Plan | Result

21

5.04

Plan | Result

22

0.46

Plan | Result

RF1

16.63

Result

RF2

0.16

Result

Throughput Test

Stream execution summary:

Stream

Duration (seconds)

Query Start Time

RF1 Start Time

RF2 Start Time

Seed

Query End Time

RF1 End Time

RF2 End Time

1

499.24

2022-06-01 23:26:21.62

2022-06-01 23:26:04.48

2022-06-01 23:26:45.84

601232223

2022-06-01 23:26:50.20

2022-06-01 23:26:45.75

2022-06-01 23:26:46.80

2

490.30

2022-06-01 23:26:04.75

2022-06-01 23:26:46.86

2022-06-01 23:27:30.45

601232224

2022-06-01 23:26:16.41

2022-06-01 23:27:30.37

2022-06-01 23:27:31.55

3

491.61

2022-06-01 23:26:04.75

2022-06-01 23:27:31.71

2022-06-01 23:28:12.06

601232225

2022-06-01 23:26:11.05

2022-06-01 23:28:11.97

2022-06-01 23:28:13.29

Query execution duration (seconds) (Click P for plans and R for results):

Stream

Q1

Q2

Q3

Q4

Q5

Q6

Q7

1

62.60 P R

11.57 P R

28.58 P R

1.34 P R

30.22 P R

13.08 P R

25.72 P R

2

59.63 P R

16.76 P R

29.10 P R

4.19 P R

27.22 P R

11.66 P R

18.31 P R

3

73.72 P R

12.25 P R

24.12 P R

5.36 P R

27.28 P R

14.05 P R

20.05 P R

Min

59.63

11.57

24.12

1.34

27.22

11.66

18.31

Max

73.72

16.76

29.10

5.36

30.22

14.05

25.72

Avg

65.32

13.53

27.27

3.63

28.24

12.93

21.36

Stream

Q8

Q9

Q10

Q11

Q12

Q13

Q14

1

6.35 P R

48.58 P R

21.26 P R

7.96 P R

22.24 P R

65.33 P R

12.20 P R

2

7.47 P R

69.91 P R

25.65 P R

6.36 P R

19.38 P R

68.19 P R

11.94 P R

3

6.30 P R

41.32 P R

18.81 P R

4.37 P R

25.43 P R

79.16 P R

12.23 P R

Min

6.30

41.32

18.81

4.37

19.38

65.33

11.94

Max

7.47

69.91

25.65

7.96

25.43

79.16

12.23

Avg

6.70

53.27

21.91

6.23

22.35

70.89

12.12

Stream

Q15

Q16

Q17

Q18

Q19

Q20

Q21

1

27.69 P R

6.71 P R

0.26 P R

77.03 P R

0.59 P R

7.32 P R

16.76 P R

2

22.54 P R

10.51 P R

0.35 P R

53.94 P R

0.64 P R

7.61 P R

15.94 P R

3

27.53 P R

6.35 P R

0.42 P R

62.81 P R

0.36 P R

8.44 P R

14.80 P R

Min

22.54

6.35

0.26

53.94

0.36

7.32

14.80

Max

27.69

10.51

0.42

77.03

0.64

8.44

16.76

Avg

25.92

7.86

0.34

64.59

0.53

7.79

15.83

Stream

Q22

RF1

RF2

1

1.07 P R

41.27 R

0.96 R

2

1.28 P R

43.50 R

1.09 R

3

1.74 P R

40.26 R

1.23 R

Min

1.07

40.26

0.96

Max

1.74

43.50

1.23

Avg

1.36

41.68

1.09

PostgreSQL Report

Load Test

Database Stats Charts

Database Table Stats Charts:

customer lineitem nation orders part partsupp region supplier time_statistics

Database Index Stats Charts:

Database Tables by Metric:

heap_blks_hit heap_blks_read idx_blks_hit idx_blks_read idx_scan idx_tup_fetch n_dead_tup n_live_tup n_tup_del n_tup_hot_upd n_tup_ins n_tup_upd seq_scan seq_tup_read tidx_blks_read toast_blks_hit toast_blks_read

Database Indexs by Metric:

Power Test

Database Stats Charts

Database Table Stats Charts:

customer lineitem nation orders part partsupp region supplier time_statistics

Database Index Stats Charts:

customer_c_mktsegment_c_custkey_idx customer_c_nationkey_c_custkey_idx customer_c_phone_c_acctbal_c_custkey_idx customer_c_phone_idx_c_acctbal lineitem_l_orderkey_idx_l_returnflag lineitem_l_orderkey_idx_part2 lineitem_l_orderkey_l_suppkey_idx lineitem_l_orderkey_l_suppkey_l_quantity_idx lineitem_l_partkey_l_quantity_l_shipmode_idx lineitem_l_partkey_l_suppkey_l_shipdate_l_quantity_idx lineitem_l_receiptdate_idx lineitem_l_shipdate_idx orders_o_custkey_idx orders_o_orderdate_idx orders_o_orderkey_o_orderdate_idx part_ios_test1 part_p_container_p_brand_p_partkey_idx part_p_size_idx part_p_type_p_partkey_idx partsupp_ps_suppkey_idx pk_customer pk_lineitem pk_nation pk_orders pk_part pk_partsupp pk_region pk_supplier supplier_s_nationkey_s_suppkey_idx supplier_s_suppkey_idx_like

Database Tables by Metric:

heap_blks_hit heap_blks_read idx_blks_hit idx_blks_read idx_scan idx_tup_fetch n_dead_tup n_live_tup n_tup_del n_tup_hot_upd n_tup_ins n_tup_upd seq_scan seq_tup_read tidx_blks_read toast_blks_hit toast_blks_read

Database Indexs by Metric:

idx_blks idx_blks_hit idx_blks_read idx_scan idx_tup_fetch idx_tup_read

Throughput Test

Database Stats Charts

Database Table Stats Charts:

customer lineitem nation orders part partsupp region supplier time_statistics

Database Index Stats Charts:

customer_c_mktsegment_c_custkey_idx customer_c_nationkey_c_custkey_idx customer_c_phone_c_acctbal_c_custkey_idx customer_c_phone_idx_c_acctbal lineitem_l_orderkey_idx_l_returnflag lineitem_l_orderkey_idx_part2 lineitem_l_orderkey_l_suppkey_idx lineitem_l_orderkey_l_suppkey_l_quantity_idx lineitem_l_partkey_l_quantity_l_shipmode_idx lineitem_l_partkey_l_suppkey_l_shipdate_l_quantity_idx lineitem_l_receiptdate_idx lineitem_l_shipdate_idx orders_o_custkey_idx orders_o_orderdate_idx orders_o_orderkey_o_orderdate_idx part_ios_test1 part_p_container_p_brand_p_partkey_idx part_p_size_idx part_p_type_p_partkey_idx partsupp_ps_suppkey_idx pk_customer pk_lineitem pk_nation pk_orders pk_part pk_partsupp pk_region pk_supplier supplier_s_nationkey_s_suppkey_idx supplier_s_suppkey_idx_like

Database Tables by Metric:

heap_blks_hit heap_blks_read idx_blks_hit idx_blks_read idx_scan idx_tup_fetch n_dead_tup n_live_tup n_tup_del n_tup_hot_upd n_tup_ins n_tup_upd seq_scan seq_tup_read tidx_blks_read toast_blks_hit toast_blks_read

Database Indexs by Metric:

idx_blks idx_blks_hit idx_blks_read idx_scan idx_tup_fetch idx_tup_read