Database Test 7 Results

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

Queries per Hour: 393
Scale: 1
Number of Query Streams: 4

Start and End Times

Test	Start Timestamp	End Timestamp	Elapsed Time
Database Load	2024-06-27 03:05:05	2024-06-27 03:05:39	00:00:33.988806
Power Test	2024-06-27 03:05:43	2024-06-27 05:07:05	02:01:22.306909
Throughput Run 1	2024-06-27 05:07:08	2024-06-27 07:10:41	02:03:32.232196
Refresh Run 1	2024-06-27 07:10:41	2024-06-27 07:11:23	00:00:42.338813
Throughput Run 2	2024-06-27 07:11:23	2024-06-27 09:08:22	01:56:59.404055
Refresh Run 2	2024-06-27 09:08:22	2024-06-27 09:09:04	00:00:41.520357

Timing Intervals (in seconds)

Q	Minimum		25th Percentile		Median		75th Percentile		Maximum
#	Run1	Run2	Run1	Run2	Run1	Run2	Run1	Run2	Run1	Run2
1	208.6	199.0	209.6	202.2	209.9	203.5	214.8	205.5	214.8	205.5
2	0.8	0.7	0.8	0.8	0.8	0.8	0.8	0.8	0.8	0.8
3	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
4	3730.9	3579.8	3779.5	3597.3	3780.5	3626.9	3794.7	3638.6	3794.7	3638.6
5	2.5	2.5	2.5	2.5	2.5	2.5	2.6	2.5	2.6	2.5
6	103.1	92.5	106.8	96.5	108.6	108.8	110.9	114.6	110.9	114.6
7	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0
8	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.2	0.1	0.2
9	2.2	2.2	2.2	2.2	2.3	2.3	2.3	2.3	2.3	2.3
10	7.2	7.7	8.1	7.9	8.4	8.0	8.6	8.7	8.6	8.7
11	2091.8	2029.6	2101.0	2051.3	2143.1	2058.2	2144.3	2062.7	2144.3	2062.7
12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
13	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3
14	29.3	29.2	29.5	29.2	36.2	34.3	38.5	37.0	38.5	37.0
15	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2
16	0.6	0.4	0.6	0.5	0.7	0.7	0.8	1.8	0.8	1.8
17	1.2	1.2	1.2	2.7	2.7	2.7	2.8	2.7	2.8	2.7
18	0.7	0.7	0.7	0.7	0.7	0.7	0.8	0.7	0.8	0.7
19	0.2	0.1	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2
20	0.0	0.0	0.1	0.0	0.1	0.0	0.1	0.1	0.1	0.1
21	0.6	0.6	0.6	0.7	0.7	0.7	0.7	0.7	0.7	0.7
22	4.8	4.8	4.9	4.9	4.9	4.9	4.9	5.0	4.9	5.0
23	7.6	9.3	9.5	9.3	9.5	9.3	9.6	9.4	9.6	9.4
24	0.0	0.0	0.8	1.2	0.9	1.2	1.6	1.6	1.6	1.6
25	1.4	1.5	1.5	1.6	1.8	1.8	1.8	1.8	1.8	1.8
26	0.6	0.6	0.7	0.6	0.7	0.6	0.7	0.6	0.7	0.6
27	0.9	0.8	0.9	0.9	0.9	0.9	0.9	0.9	0.9	0.9
28	1.6	1.6	1.6	1.6	1.6	1.6	1.6	1.6	1.6	1.6
29	0.7	1.1	1.1	1.1	1.1	1.2	1.1	1.3	1.1	1.3
30	15.6	14.9	16.1	15.0	16.6	16.0	17.3	16.1	17.3	16.1
31	9.0	8.9	10.9	9.5	11.0	10.5	11.1	11.2	11.1	11.2
32	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
33	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2
34	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4
35	0.5	0.5	0.5	0.5	0.5	0.5	0.6	0.5	0.6	0.5
36	1.1	1.1	1.1	1.1	1.1	1.1	1.1	1.1	1.1	1.1
37	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
38	2.2	2.2	2.2	2.2	2.2	2.2	2.2	2.2	2.2	2.2
39	4.9	4.9	4.9	5.2	5.0	5.2	5.0	5.4	5.0	5.4
40	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1
41	0.6	0.9	1.0	0.9	1.0	0.9	1.0	1.0	1.0	1.0
42	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2
43	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5
44	0.3	0.2	1.0	0.2	1.0	1.0	1.0	1.0	1.0	1.0
45	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1
46	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5
47	1.9	1.8	1.9	1.8	1.9	1.9	1.9	1.9	1.9	1.9
48	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5
49	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1
50	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.1	0.0	0.1
51	1.4	1.4	1.4	1.4	1.4	1.4	1.4	1.4	1.4	1.4
52	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2
53	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.3	0.2	0.3
54	0.2	0.2	0.2	0.4	0.2	0.4	0.4	0.4	0.4	0.4
55	0.0	0.0	0.0	0.0	0.2	0.1	0.2	0.2	0.2	0.2
56	0.5	0.5	0.5	0.5	0.6	0.5	0.6	0.6	0.6	0.6
57	1.5	1.6	1.6	1.6	1.6	1.6	1.6	1.7	1.6	1.7
58	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1
59	0.9	0.9	0.9	0.9	0.9	0.9	1.0	1.0	1.0	1.0
60	0.3	0.4	0.4	0.4	0.4	0.4	0.4	0.9	0.4	0.9
61	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
62	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2
63	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2
64	0.5	0.5	0.5	0.5	0.5	0.5	1.8	0.6	1.8	0.6
65	1.1	1.1	1.1	1.1	1.1	1.1	1.1	1.2	1.1	1.2
66	0.4	0.4	0.4	0.4	0.4	0.4	0.5	0.5	0.5	0.5
67	2.1	1.7	2.1	2.0	2.1	2.1	2.1	2.1	2.1	2.1
68	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3
69	0.1	0.0	0.1	0.0	0.1	0.0	0.1	0.1	0.1	0.1
70	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.2	1.0	1.2
71	0.3	0.3	0.3	0.3	0.3	0.4	0.3	0.4	0.3	0.4
72	0.5	0.5	0.5	0.5	0.5	0.5	0.6	0.5	0.6	0.5
73	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.3	0.2	0.3
74	808.3	658.8	820.7	663.3	830.6	787.8	842.4	788.8	842.4	788.8
75	1.6	1.6	1.6	1.6	1.6	1.6	1.7	1.6	1.7	1.6
76	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5	0.5
77	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2	0.2
78	2.6	2.6	2.6	2.6	3.0	2.6	3.0	3.0	3.0	3.0
79	0.2	0.2	0.2	0.2	0.3	0.2	0.3	0.2	0.3	0.2
80	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3
81	71.2	12.8	71.3	69.5	73.3	70.6	73.5	72.2	73.5	72.2
82	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
83	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1
84	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1
85	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1
86	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3
87	2.2	2.2	2.2	2.2	2.2	2.2	2.2	2.2	2.2	2.2
88	2.1	2.1	2.1	2.1	2.1	2.1	2.1	2.2	2.1	2.2
89	0.5	0.4	0.6	0.6	0.6	0.6	0.8	0.7	0.8	0.7
90	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
91	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
92	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
93	0.0	0.0	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1
94	0.1	0.2	0.1	0.2	0.2	0.2	0.2	0.2	0.2	0.2
95	7.6	13.6	31.8	34.4	45.7	58.0	94.1	70.9	94.1	70.9
96	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3	0.3
97	1.0	0.9	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0
98	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1	0.1
99	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4	0.4

Power Test

System Configuration

Hardware Information

CPU Type: AMD EPYC 7502P 32-Core Processor
Total Processors: 64
Memory: 263504836 kB KB RAM

Software Information

Operating System: "Debian GNU/Linux 12 (bookworm)" Linux 6.1.0-21-amd64
Database Server: PostgreSQL 15.6 (Debian 15.6-0+deb12u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

System Statistics

PostgreSQL Report

Load Test

Database Settings
Per Process Statistics: autovacuum bgwriter checkpointer logger logical statscollector walwriter

Database Stats Charts	dbt7
Database Table Stats Charts:	public.call_center public.catalog_page public.catalog_returns public.catalog_sales public.customer public.customer_address public.customer_demographics public.date_dim public.household_demographics public.income_band public.inventory public.item public.promotion public.reason public.s_catalog_order public.s_catalog_order_lineitem public.s_catalog_returns public.s_inventory public.s_purchase public.s_purchase_lineitem public.s_store_returns public.s_web_order public.s_web_order_lineitem public.s_web_returns public.ship_mode public.store public.store_returns public.store_sales public.time_dim public.time_statistics public.warehouse public.web_page public.web_returns public.web_sales public.web_site
Database Index Stats Charts:
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

Power Test

Database Settings
Per Process Statistics: autovacuum bgwriter checkpointer logger logical statscollector walwriter

Database Stats Charts	dbt7
Database Table Stats Charts:	public.call_center public.catalog_page public.catalog_returns public.catalog_sales public.customer public.customer_address public.customer_demographics public.date_dim public.household_demographics public.income_band public.inventory public.item public.promotion public.reason public.s_catalog_order public.s_catalog_order_lineitem public.s_catalog_returns public.s_inventory public.s_purchase public.s_purchase_lineitem public.s_store_returns public.s_web_order public.s_web_order_lineitem public.s_web_returns public.ship_mode public.store public.store_returns public.store_sales public.time_dim public.time_statistics public.warehouse public.web_page public.web_returns public.web_sales public.web_site
Database Index Stats Charts:	public.customer.i_c_customer_id public.call_center.i_cc_call_center_id public.call_center.i_cc_rec_end_date public.s_catalog_order_lineitem.i_clin_catalog_number public.s_catalog_order_lineitem.i_clin_catalog_page_number public.s_catalog_order_lineitem.i_clin_item_id public.s_catalog_order_lineitem.i_clin_order_id public.s_catalog_order_lineitem.i_clin_promotion_id public.s_catalog_order_lineitem.i_clin_ship_date public.s_catalog_order_lineitem.i_clin_warehouse_id public.s_catalog_order.i_cord_bill_customer_id public.s_catalog_order.i_cord_call_center_id public.s_catalog_order.i_cord_order_time public.s_catalog_order.i_cord_ship_customer_id public.s_catalog_order.i_cord_ship_mode_id public.catalog_page.i_cp_catalog_number public.catalog_page.i_cp_catalog_page_id public.catalog_page.i_cp_catalog_page_number public.catalog_returns.i_cr_returned_date_sk public.catalog_sales.i_cs_sold_date_sk public.date_dim.i_d_date public.item.i_i_item_id public.item.i_i_rec_end_date public.s_inventory.i_invn_date public.s_inventory.i_invn_item_id public.promotion.i_p_promo_id public.s_purchase_lineitem.i_plin_item_id public.s_purchase_lineitem.i_plin_promotion_id public.s_purchase.i_purc_customer_id public.s_purchase.i_purc_purchase_date public.s_purchase.i_purc_purchase_time public.s_purchase.i_purc_store_id public.reason.i_r_reason_id public.store.i_s_store_id public.ship_mode.i_sm_ship_mode_id public.store_returns.i_sr_returned_date_sk public.s_store_returns.i_sret_customer_id public.s_store_returns.i_sret_reason_id public.s_store_returns.i_sret_return_date public.s_store_returns.i_sret_store_id public.store_sales.i_ss_sold_date_sk public.time_dim.i_t_time public.warehouse.i_w_warehouse_id public.s_web_order_lineitem.i_wlin_order_id public.s_web_order_lineitem.i_wlin_promotion_id public.s_web_order_lineitem.i_wlin_ship_date public.s_web_order_lineitem.i_wlin_warehouse_id public.s_web_order_lineitem.i_wlin_web_page_id public.s_web_order.i_word_ship_customer_id public.s_web_order.i_word_ship_mode_id public.web_page.i_wp_web_page_id public.web_returns.i_wr_returned_date_sk public.s_web_returns.i_wret_return_customer_id public.s_web_returns.i_wret_web_page_id public.web_sales.i_ws_sold_date_sk public.call_center.pk_call_center public.catalog_page.pk_catalog_page public.catalog_returns.pk_catalog_returns public.catalog_sales.pk_catalog_sales public.customer.pk_customer public.customer_address.pk_customer_address public.customer_demographics.pk_customer_demographics public.date_dim.pk_date_dim public.household_demographics.pk_household_demographics public.income_band.pk_income_band public.inventory.pk_inventory public.item.pk_item public.promotion.pk_promotion public.reason.pk_reason public.s_catalog_order.pk_s_catalog_order public.s_inventory.pk_s_inventory public.s_purchase.pk_s_purchase public.s_purchase_lineitem.pk_s_purchase_lineitem public.s_store_returns.pk_s_store_returns public.s_web_order.pk_s_web_order public.s_web_returns.pk_s_web_returns public.ship_mode.pk_ship_mode public.store.pk_store public.store_returns.pk_store_returns public.store_sales.pk_store_sales public.time_dim.pk_time_dim public.warehouse.pk_warehouse public.web_page.pk_web_page public.web_returns.pk_web_returns public.web_sales.pk_web_sales public.web_site.pk_web_site
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

Throughput Test

Database Settings
Per Process Statistics: autovacuum bgwriter checkpointer logger logical statscollector walwriter

Database Stats Charts	dbt7
Database Table Stats Charts:	public.call_center public.catalog_page public.catalog_returns public.catalog_sales public.customer public.customer_address public.customer_demographics public.date_dim public.household_demographics public.income_band public.inventory public.item public.promotion public.reason public.s_catalog_order public.s_catalog_order_lineitem public.s_catalog_returns public.s_inventory public.s_purchase public.s_purchase_lineitem public.s_store_returns public.s_web_order public.s_web_order_lineitem public.s_web_returns public.ship_mode public.store public.store_returns public.store_sales public.time_dim public.time_statistics public.warehouse public.web_page public.web_returns public.web_sales public.web_site
Database Index Stats Charts:	public.customer.i_c_customer_id public.call_center.i_cc_call_center_id public.call_center.i_cc_rec_end_date public.s_catalog_order_lineitem.i_clin_catalog_number public.s_catalog_order_lineitem.i_clin_catalog_page_number public.s_catalog_order_lineitem.i_clin_item_id public.s_catalog_order_lineitem.i_clin_order_id public.s_catalog_order_lineitem.i_clin_promotion_id public.s_catalog_order_lineitem.i_clin_ship_date public.s_catalog_order_lineitem.i_clin_warehouse_id public.s_catalog_order.i_cord_bill_customer_id public.s_catalog_order.i_cord_call_center_id public.s_catalog_order.i_cord_order_time public.s_catalog_order.i_cord_ship_customer_id public.s_catalog_order.i_cord_ship_mode_id public.catalog_page.i_cp_catalog_number public.catalog_page.i_cp_catalog_page_id public.catalog_page.i_cp_catalog_page_number public.catalog_returns.i_cr_returned_date_sk public.catalog_sales.i_cs_sold_date_sk public.date_dim.i_d_date public.item.i_i_item_id public.item.i_i_rec_end_date public.s_inventory.i_invn_date public.s_inventory.i_invn_item_id public.promotion.i_p_promo_id public.s_purchase_lineitem.i_plin_item_id public.s_purchase_lineitem.i_plin_promotion_id public.s_purchase.i_purc_customer_id public.s_purchase.i_purc_purchase_date public.s_purchase.i_purc_purchase_time public.s_purchase.i_purc_store_id public.reason.i_r_reason_id public.store.i_s_store_id public.ship_mode.i_sm_ship_mode_id public.store_returns.i_sr_returned_date_sk public.s_store_returns.i_sret_customer_id public.s_store_returns.i_sret_reason_id public.s_store_returns.i_sret_return_date public.s_store_returns.i_sret_store_id public.store_sales.i_ss_sold_date_sk public.time_dim.i_t_time public.warehouse.i_w_warehouse_id public.s_web_order_lineitem.i_wlin_order_id public.s_web_order_lineitem.i_wlin_promotion_id public.s_web_order_lineitem.i_wlin_ship_date public.s_web_order_lineitem.i_wlin_warehouse_id public.s_web_order_lineitem.i_wlin_web_page_id public.s_web_order.i_word_ship_customer_id public.s_web_order.i_word_ship_mode_id public.web_page.i_wp_web_page_id public.web_returns.i_wr_returned_date_sk public.s_web_returns.i_wret_return_customer_id public.s_web_returns.i_wret_web_page_id public.web_sales.i_ws_sold_date_sk public.call_center.pk_call_center public.catalog_page.pk_catalog_page public.catalog_returns.pk_catalog_returns public.catalog_sales.pk_catalog_sales public.customer.pk_customer public.customer_address.pk_customer_address public.customer_demographics.pk_customer_demographics public.date_dim.pk_date_dim public.household_demographics.pk_household_demographics public.income_band.pk_income_band public.inventory.pk_inventory public.item.pk_item public.promotion.pk_promotion public.reason.pk_reason public.s_catalog_order.pk_s_catalog_order public.s_inventory.pk_s_inventory public.s_purchase.pk_s_purchase public.s_purchase_lineitem.pk_s_purchase_lineitem public.s_store_returns.pk_s_store_returns public.s_web_order.pk_s_web_order public.s_web_returns.pk_s_web_returns public.ship_mode.pk_ship_mode public.store.pk_store public.store_returns.pk_store_returns public.store_sales.pk_store_sales public.time_dim.pk_time_dim public.warehouse.pk_warehouse public.web_page.pk_web_page public.web_returns.pk_web_returns public.web_sales.pk_web_sales public.web_site.pk_web_site
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