Firebird 4.0 Performance Logs

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-09-13 11:20:43.57.

Common	Performance	Final Results
Test configuration Test Finish details Test workload details Indices DDL for heavy-loaded table(s)	Performance, TOTAL score Performance, DYNAMIC, 10 intervals Performance, per MINUTE, since launch Performance, TRACE data for ISQL #1 Performance, DETAILS per units MON$-analysis, per business units Exceptions during test run	mon$database and 'show version' results Database Statistics, full Ratio "Versions / Records" for tables Database Validation Results New in firebird.log while test was run Final processing of ISQL logs

Server and database settings

Server version: WI-T4.0.0.743 Firebird 4.0 Alpha 1
Server implementation: Firebird/Windows/AMD/Intel/x64

FB_ARCHITECTURE	DB_NAME	FORCED_WRITES	SWEEP_INT	PAGE_BUFFERS	PAGE_SIZE
SuperServer 4.0.0	D:\OLTP-EMUL\OLTP40-SMALL.FDB	ON	0	786432	8192

Test configuration settings

File: E:\OLTP-EMUL\src\oltp40_config.win

PARAM_NAME	PARAM_VALUE
fbc	E:\FB40.TMPINSTANCE
dbnm	D:\OLTP-EMUL\oltp40-small.fdb
host	localhost
port	3400
usr	SYSDBA
pwd	masterkey
tmpdir	e:\temp\logs.oltp40
working_mode	small_03
warm_time	0
test_time	180
idle_time	0
use_mtee	0
is_embed	0
remove_isql_logs	if_no_severe_errors
no_auto_undo	1
detailed_info	0
mon_unit_perf	0
trc_unit_perf	1
init_buff	32768
create_with_fw	sync
create_with_sweep	0
wait_if_not_exists	0
wait_after_create	0
init_docs	100000
wait_for_copy	0
create_with_debug_objects	1
create_with_split_heavy_tabs	1
create_with_separate_qdistr_idx	0
create_with_compound_columns_order	most_selective_first
make_html	1
run_db_statistics	1
run_db_validation	1
file_name_with_test_params	regular
file_name_this_host_info	cpu_8x3Ghz_ram_16gb
upload_report	1
max_snapshots_to_store	720
replace_instance	1
etalon_dbnm	E:\OLTP-EMUL\oltp40-docs_100000-fw__ON.fdb
used_in_replication	0

Test finish info

FINISH_STATE	DTS_END	FB_GDSCODE	FB_MNEMONA	STACK	IP	TRN_ID	ATT_ID	EXC_UNIT
NORMAL: TEST_TIME EXPIRED.	2017-09-13 11:16:59.7750	-1	<null>		::1/61071	423142	9089	2

Current test settings

CATEGORY	SETTING	VAL
COMMON	TRACED_UNITS	,,
COMMON	ENABLE_MON_QUERY	0
COMMON	HALT_TEST_ON_ERRORS	,CK,
COMMON	QMISM_VERIFY_BITSET	1
COMMON	RECALC_IDX_MIN_INTERVAL	15
COMMON	ENABLE_RESERVES_WHEN_ADD_INVOICE	1
COMMON	ORDER_FOR_OUR_FIRM_PERCENT	25
COMMON	ENABLE_FILL_PHRASES	0
COMMON	RANDOM_SEEK_VIA_ROWS_LIMIT	0
COMMON	C_INVOICE_MIN_PURCHASE	1000
COMMON	C_INVOICE_MAX_PURCHASE	2000
COMMON	C_INVOICE_MIN_PROFIT_PRC	35
COMMON	C_INVOICE_MAX_PROFIT_PRC	80
COMMON	C_MIN_COST_TO_BE_SPLITTED	1000
COMMON	C_ROWS_TO_MULTIPLY	10
COMMON	C_PAYMENT_FROM_CLIENT_MIN_TOTAL	1000
COMMON	C_PAYMENT_FROM_CLIENT_MAX_TOTAL	5000
COMMON	C_PAYMENT_TO_SUPPLIER_MIN_TOTAL	2000
COMMON	C_PAYMENT_TO_SUPPLIER_MAX_TOTAL	15000
COMMON	BUILD_WITH_SPLIT_HEAVY_TABS	1
COMMON	BUILD_WITH_SEPAR_QDISTR_IDX	0
COMMON	BUILD_WITH_QD_COMPOUND_ORDR	MOST_SELECTIVE_FIRST
SMALL_03	C_WARES_MAX_ID	400
SMALL_03	C_CUSTOMER_DOC_MAX_ROWS	10
SMALL_03	C_SUPPLIER_DOC_MAX_ROWS	50
SMALL_03	C_CUSTOMER_DOC_MAX_QTY	15
SMALL_03	C_SUPPLIER_DOC_MAX_QTY	50
SMALL_03	C_NUMBER_OF_AGENTS	50

Index(es) for heavy-loaded table(s)

TAB_NAME	IDX_NAME	IDX_KEY
XQD_1000_1200	XQD_1000_1200_WARE_SOP_ROP_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1000_3300	XQD_1000_3300_DOC	DOC_ID
XQD_1000_3300	XQD_1000_3300_WARE_SOP_ROP_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1200_2000	XQD_1200_2000_WARE_SOP_ROP_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2000_3300	XQD_2000_3300_WARE_SOP_ROP_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2100_3300	XQD_2100_3300_WARE_SOP_ROP_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_3300_3400	XQD_3300_3400_WARE_SOP_ROP_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID

Performance reports

Performance in TOTAL:

ACTION	AVG_TIMES_PER_MINUTE	AVG_ELAPSED_MS	SUCCESSFUL_TIMES_DONE	JOB_BEG	JOB_END
* OVERALL * for 180 minutes:	6160.70	1744	1108926	2017-09-13 08:17	2017-09-13 11:17
customer order: creation	426.06	282	76691	2017-09-13 08:17	2017-09-13 11:17
customer order: refuse	34.47	142	6204	2017-09-13 08:17	2017-09-13 11:17
order to supplier: creation	107.95	1248	19431	2017-09-13 08:17	2017-09-13 11:17
order to supplier: removal	2.94	11007	527	2017-09-13 08:17	2017-09-13 11:17
invoice (draft): creation	109.73	1923	19751	2017-09-13 08:17	2017-09-13 11:17
invoice (draft): removal	43.99	255	7874	2017-09-13 08:17	2017-09-13 11:17
invoice accept: apply	60.78	5427	10880	2017-09-13 08:17	2017-09-13 11:17
invoice accept: cancel	19.06	1422	3411	2017-09-13 08:17	2017-09-13 11:17
customer reserve: creation	3549.38	73	635339	2017-09-13 08:17	2017-09-13 11:17
customer reserve: removal	1246.63	29	223147	2017-09-13 08:17	2017-09-13 11:17
realization accept: apply	198.79	279	35783	2017-09-13 08:17	2017-09-13 11:17
realization accept: cancel	82.06	90	14770	2017-09-13 08:17	2017-09-13 11:17
payment from customer: creation	142.33	526	25619	2017-09-13 08:17	2017-09-13 11:17
payment from customer: removal	13.77	83	2464	2017-09-13 08:17	2017-09-13 11:17
payment to supplier: creation	118.30	261	21176	2017-09-13 08:17	2017-09-13 11:17
payment to supplier: removal	8.43	82	1509	2017-09-13 08:17	2017-09-13 11:17
service: total inventory turnovers	10.57	1321	1902	2017-09-13 08:17	2017-09-13 11:17
service: total monetary turnovers	13.61	43	2436	2017-09-13 08:17	2017-09-13 11:17
service: refresh index statistics	0.07	8635	12	2017-09-13 08:17	2017-09-13 11:17

Done for 118590 ms, from 11:23:40.27 to 11:25:38.86.

Performance in DYNAMIC:

ACTION	ITRV_NO	CNT_OK_PER_MINUTE	CNT_ALL	CNT_OK	CNT_ERR	ERR_PRC	ITRV_BEG	ITRV_END
interval # 1, overall	1	4407	95642	79331	16311	17.05	08:17:00	08:35:00
interval # 2, overall	2	6687	142033	120368	21665	15.25	08:35:01	08:53:01
interval # 3, overall	3	6749	144200	121481	22719	15.76	08:53:02	09:11:02
interval # 4, overall	4	6671	139884	120083	19801	14.16	09:11:03	09:29:03
interval # 5, overall	5	6411	149157	115402	33755	22.63	09:29:04	09:47:04
interval # 6, overall	6	6764	147698	121756	25942	17.56	09:47:05	10:05:05
interval # 7, overall	7	6848	145763	123268	22495	15.43	10:05:06	10:23:06
interval # 8, overall	8	5676	116092	102162	13930	12.00	10:23:07	10:41:07
interval # 9, overall	9	5908	128623	106346	22277	17.32	10:41:08	10:59:08
interval # 10, overall	10	5485	112632	98729	13903	12.34	10:59:09	11:17:09

Done for 244570 ms, from 11:29:44.41 to 11:33:48.98.

Performance for every MINUTE:

TEST_PHASE	MINUTE_SINCE_TEST_START	AVG_ESTIMATED	MIN_TO_AVG_RATIO	MAX_TO_AVG_RATIO	ROWS_AGGREGATED	DISTINCT_ATTACHMENTS
TEST_TIME	1	1551.78	0.0006	2.1311	2406	17
TEST_TIME	2	2473.01	0.6686	1.3906	1873	17
TEST_TIME	3	2770.45	0.8276	1.1588	1398	20
TEST_TIME	4	2725.31	0.8846	1.1325	1291	20
TEST_TIME	5	2707.34	0.9121	1.1037	923	100
TEST_TIME	6	2800.27	0.8893	1.1410	1813	100
TEST_TIME	7	3000.74	0.9126	1.0944	1600	100
TEST_TIME	8	3142.16	0.9146	1.0699	1489	100
TEST_TIME	9	3225.74	0.9272	1.0852	1427	100
TEST_TIME	10	3330.70	0.9460	1.0450	1718	100
TEST_TIME	11	3309.00	0.9563	1.0487	1706	96
TEST_TIME	12	3447.38	0.9228	1.0674	1374	100
TEST_TIME	13	3545.97	0.9580	1.0472	1323	100
TEST_TIME	14	3622.03	0.9520	1.0505	1486	100
TEST_TIME	15	3745.21	0.9482	1.0503	1706	100
TEST_TIME	16	3925.90	0.9393	1.0625	2201	100
TEST_TIME	17	4083.46	0.9615	1.0404	1496	100
TEST_TIME	18	4211.94	0.9526	1.0461	1779	100
TEST_TIME	19	4370.61	0.9551	1.0336	1436	100
TEST_TIME	20	4434.41	0.9678	1.0295	1538	100
TEST_TIME	21	4509.02	0.9643	1.0341	1564	100
TEST_TIME	22	4594.95	0.9687	1.0282	1517	100
TEST_TIME	23	4640.73	0.9738	1.0277	1455	100
TEST_TIME	24	4682.04	0.9770	1.0237	1258	100
TEST_TIME	25	4701.61	0.9792	1.0204	1224	100
TEST_TIME	26	4718.21	0.9778	1.0214	1255	100
TEST_TIME	27	4761.42	0.9747	1.0219	1322	100
TEST_TIME	28	4829.93	0.9721	1.0223	1169	100
TEST_TIME	29	4867.02	0.9796	1.0186	1181	100
TEST_TIME	30	4929.48	0.9722	1.0327	1985	100
TEST_TIME	31	5090.73	0.9684	1.0286	2013	100
TEST_TIME	32	5202.38	0.9751	1.0253	1787	100
TEST_TIME	33	5280.64	0.9800	1.0206	1833	100
TEST_TIME	34	5349.69	0.9778	1.0202	1643	100
TEST_TIME	35	5417.23	0.9827	1.0156	1399	100
TEST_TIME	36	5448.20	0.9818	1.0165	1411	100
TEST_TIME	37	5476.71	0.9839	1.0179	1547	100
TEST_TIME	38	5518.96	0.9835	1.0163	1434	100
TEST_TIME	39	5555.56	0.9838	1.0152	1474	100
TEST_TIME	40	5586.34	0.9844	1.0157	1250	100
TEST_TIME	41	5606.80	0.9875	1.0166	1270	100
TEST_TIME	42	5635.82	0.9873	1.0125	1214	100
TEST_TIME	43	5645.06	0.9877	1.0065	1150	100
TEST_TIME	44	5622.12	0.9876	1.0111	983	100
TEST_TIME	45	5623.85	0.9883	1.0088	1775	100
TEST_TIME	46	5602.25	0.9907	1.0164	1336	85
TEST_TIME	47	5645.07	0.9872	1.0121	1376	100
TEST_TIME	48	5681.73	0.9846	1.0155	1707	100
TEST_TIME	49	5735.76	0.9859	1.0124	1510	100
TEST_TIME	50	5766.06	0.9869	1.0125	1699	100
TEST_TIME	51	5789.29	0.9887	1.0102	1577	100
TEST_TIME	52	5822.00	0.9853	1.0116	1455	100
TEST_TIME	53	5846.42	0.9884	1.0150	1320	100
TEST_TIME	54	5885.82	0.9896	1.0095	1372	100
TEST_TIME	55	5898.76	0.9890	1.0126	1374	100
TEST_TIME	56	5919.60	0.9910	1.0096	1215	100
TEST_TIME	57	5932.29	0.9898	1.0081	1208	100
TEST_TIME	58	5927.01	0.9916	1.0094	1217	100
TEST_TIME	59	5929.31	0.9920	1.0085	1299	100
TEST_TIME	60	5959.08	0.9869	1.0118	2171	100
TEST_TIME	61	6017.81	0.9855	1.0114	1967	100
TEST_TIME	62	6043.86	0.9908	1.0096	1560	100
TEST_TIME	63	6067.17	0.9898	1.0088	1439	100
TEST_TIME	64	6076.60	0.9915	1.0104	1499	100
TEST_TIME	65	6091.53	0.9924	1.0084	1478	100
TEST_TIME	66	6104.18	0.9910	1.0052	1399	100
TEST_TIME	67	6074.79	0.9950	1.0058	1265	88
TEST_TIME	68	6072.28	0.9914	1.0098	1030	99
TEST_TIME	69	6088.31	0.9925	1.0101	1270	100
TEST_TIME	70	6100.62	0.9937	1.0058	1356	100
TEST_TIME	71	6088.95	0.9935	1.0070	1442	100
TEST_TIME	72	6080.72	0.9943	1.0074	1306	100
TEST_TIME	73	6074.38	0.9947	1.0076	1248	100
TEST_TIME	74	6076.16	0.9937	1.0083	1108	100
TEST_TIME	75	6097.77	0.9913	1.0083	1656	100
TEST_TIME	76	6119.90	0.9915	1.0068	1884	100
TEST_TIME	77	6131.69	0.9918	1.0081	1761	100
TEST_TIME	78	6138.90	0.9940	1.0069	1692	100
TEST_TIME	79	6173.72	0.9886	1.0084	1620	100
TEST_TIME	80	6187.64	0.9936	1.0079	1548	100
TEST_TIME	81	6196.03	0.9942	1.0068	1498	100
TEST_TIME	82	6212.72	0.9918	1.0087	1369	100
TEST_TIME	83	6225.42	0.9945	1.0083	1165	100
TEST_TIME	84	6233.60	0.9950	1.0046	1022	100
TEST_TIME	85	6210.90	0.9964	1.0036	1337	100
TEST_TIME	86	6186.18	0.9960	1.0036	1127	100
TEST_TIME	87	6174.39	0.9940	1.0036	1224	100
TEST_TIME	88	6162.46	0.9942	1.0046	1096	100
TEST_TIME	89	6146.26	0.9960	1.0037	1149	100
TEST_TIME	90	6144.21	0.9928	1.0056	1599	100
TEST_TIME	91	6137.11	0.9957	1.0068	1809	98
TEST_TIME	92	6157.33	0.9926	1.0051	1645	100
TEST_TIME	93	6164.05	0.9933	1.0048	1496	99
TEST_TIME	94	6145.25	0.9971	1.0101	1325	99
TEST_TIME	95	6166.01	0.9961	1.0039	1591	99
TEST_TIME	96	6164.14	0.9938	1.0081	1467	100
TEST_TIME	97	6177.04	0.9957	1.0048	1642	100
TEST_TIME	98	6181.23	0.9939	1.0060	1494	100
TEST_TIME	99	6206.52	0.9918	1.0063	1227	100
TEST_TIME	100	6223.97	0.9935	1.0074	1290	100
TEST_TIME	101	6236.30	0.9955	1.0043	1200	100
TEST_TIME	102	6228.82	0.9956	1.0036	1193	100
TEST_TIME	103	6223.08	0.9948	1.0039	1156	99
TEST_TIME	104	6210.78	0.9965	1.0031	1086	100
TEST_TIME	105	6221.22	0.9922	1.0067	1653	100
TEST_TIME	106	6232.52	0.9954	1.0040	1587	100
TEST_TIME	107	6229.77	0.9950	1.0042	1511	100
TEST_TIME	108	6238.55	0.9935	1.0063	1630	100
TEST_TIME	109	6249.62	0.9953	1.0050	1412	100
TEST_TIME	110	6259.50	0.9943	1.0054	1430	100
TEST_TIME	111	6254.81	0.9971	1.0036	1416	99
TEST_TIME	112	6238.00	0.9973	1.0032	1561	93
TEST_TIME	113	6244.12	0.9934	1.0034	1302	100
TEST_TIME	114	6222.40	0.9980	1.0048	1324	96
TEST_TIME	115	6220.54	0.9963	1.0027	1280	99
TEST_TIME	116	6212.23	0.9954	1.0045	1252	99
TEST_TIME	117	6208.19	0.9966	1.0036	1309	100
TEST_TIME	118	6206.23	0.9954	1.0051	1356	100
TEST_TIME	119	6208.17	0.9963	1.0057	1137	100
TEST_TIME	120	6229.74	0.9939	1.0047	1612	100
TEST_TIME	121	6242.40	0.9944	1.0071	1962	100
TEST_TIME	122	6266.88	0.9950	1.0060	1858	100
TEST_TIME	123	6291.03	0.9940	1.0061	1504	100
TEST_TIME	124	6313.29	0.9944	1.0046	1288	100
TEST_TIME	125	6321.36	0.9954	1.0033	1338	100
TEST_TIME	126	6331.33	0.9938	1.0039	1314	100
TEST_TIME	127	6326.22	0.9968	1.0029	1180	100
TEST_TIME	128	6323.88	0.9955	1.0041	1149	100
TEST_TIME	129	6319.95	0.9969	1.0022	1295	100
TEST_TIME	130	6300.60	0.9976	1.0027	1124	96
TEST_TIME	131	6282.78	0.9979	1.0030	1052	97
TEST_TIME	132	6277.24	0.9963	1.0017	1218	100
TEST_TIME	133	6255.53	0.9977	1.0046	900	97
TEST_TIME	134	6255.62	0.9973	1.0040	1065	100
TEST_TIME	135	6247.36	0.9979	1.0022	1799	99
TEST_TIME	136	6247.07	0.9949	1.0044	1540	100
TEST_TIME	137	6247.89	0.9970	1.0027	1869	99
TEST_TIME	138	6233.82	0.9977	1.0025	1769	96
TEST_TIME	139	6258.17	0.9938	1.0044	1492	99
TEST_TIME	140	6257.67	0.9973	1.0032	1462	98
TEST_TIME	141	6251.73	0.9971	1.0024	1483	96
TEST_TIME	142	6241.31	0.9970	1.0053	1438	98
TEST_TIME	143	6258.15	0.9956	1.0035	1293	100
TEST_TIME	144	6255.43	0.9969	1.0017	1390	100
TEST_TIME	145	6235.81	0.9979	1.0022	1310	96
TEST_TIME	146	6235.63	0.9953	1.0045	1172	100
TEST_TIME	147	6237.42	0.9974	1.0022	1128	100
TEST_TIME	148	6229.18	0.9967	1.0031	1182	100
TEST_TIME	149	6229.04	0.9964	1.0040	1071	100
TEST_TIME	150	6225.77	0.9978	1.0053	1309	100
TEST_TIME	151	6241.60	0.9962	1.0033	1453	100
TEST_TIME	152	6233.00	0.9980	1.0014	1691	99
TEST_TIME	153	6228.87	0.9955	1.0037	1288	100
TEST_TIME	154	6237.24	0.9958	1.0031	1432	100
TEST_TIME	155	6230.11	0.9978	1.0017	1673	97
TEST_TIME	156	6224.74	0.9961	1.0026	1321	98
TEST_TIME	157	6219.04	0.9972	1.0031	1372	100
TEST_TIME	158	6209.56	0.9983	1.0037	1224	100
TEST_TIME	159	6213.61	0.9967	1.0031	1252	100
TEST_TIME	160	6207.95	0.9978	1.0016	1298	99
TEST_TIME	161	6201.58	0.9970	1.0023	1268	100
TEST_TIME	162	6203.09	0.9959	1.0038	1177	100
TEST_TIME	163	6211.82	0.9963	1.0042	1117	100
TEST_TIME	164	6215.35	0.9976	1.0024	1185	100
TEST_TIME	165	6198.73	0.9990	1.0010	1220	99
TEST_TIME	166	6183.03	0.9975	1.0044	1420	96
TEST_TIME	167	6185.27	0.9981	1.0036	1389	97
TEST_TIME	168	6194.45	0.9964	1.0024	1478	100
TEST_TIME	169	6187.90	0.9975	1.0021	1667	97
TEST_TIME	170	6178.80	0.9977	1.0037	1417	95
TEST_TIME	171	6178.65	0.9979	1.0022	1191	100
TEST_TIME	172	6175.36	0.9969	1.0014	1285	100
TEST_TIME	173	6164.15	0.9974	1.0030	1101	96
TEST_TIME	174	6175.24	0.9955	1.0025	1168	100
TEST_TIME	175	6180.44	0.9959	1.0028	1293	100
TEST_TIME	176	6169.11	0.9990	1.0014	1306	96
TEST_TIME	177	6166.35	0.9962	1.0021	1088	96
TEST_TIME	178	6151.12	0.9989	1.0018	1160	92
TEST_TIME	179	6144.01	0.9974	1.0033	1158	98
TEST_TIME	180	6147.81	0.9972	1.0020	1441	100
TEST_TIME	181	6126.57	0.9999	1.0000	71	71

Done for 10580 ms, from 11:33:50.82 to 11:34:01.40.

Performance from TRACE for ISQL instance #1:

TRACED_DATA	ITRV_NO	SP_CLIENT_ORDER	SP_CANCEL_CLIENT_ORDER	SP_SUPPLIER_ORDER	SP_CANCEL_SUPPLIER_ORDER	SP_SUPPLIER_INVOICE	SP_CANCEL_SUPPLIER_INVOICE	SP_ADD_INVOICE_TO_STOCK	SP_CANCEL_ADDING_INVOICE	SP_CUSTOMER_RESERVE	SP_CANCEL_CUSTOMER_RESERVE	SP_RESERVE_WRITE_OFF	SP_CANCEL_WRITE_OFF	SP_PAY_FROM_CUSTOMER	SP_CANCEL_PAY_FROM_CUSTOMER	SP_PAY_TO_SUPPLIER	SP_CANCEL_PAY_TO_SUPPLIER	SRV_MAKE_INVNT_SALDO	SRV_MAKE_MONEY_SALDO	SRV_RECALC_IDX_STAT	ITRV_BEG	ITRV_END
fetches per second	1	47514	47758	41530	<null>	45833	45517	64957	55460	73062	49900	57703	67371	77795	75954	95343	34798	237211	266649	<null>	08:17:00	08:35:00
fetches per second	2	57538	118470	68385	97807	66483	106852	86732	80484	63700	<null>	80335	50617	92221	137828	92706	83444	283342	576822	<null>	08:35:01	08:53:01
fetches per second	3	64425	44754	58947	61528	52427	91800	91598	85498	26535	62864	79981	64802	71438	126500	144189	<null>	190396	20312	<null>	08:53:02	09:11:02
fetches per second	4	75157	179060	45354	129572	70203	<null>	87775	95734	86119	109909	86795	75063	100104	133800	145735	181500	102551	279185	<null>	09:11:03	09:29:03
fetches per second	5	72206	144279	59744	<null>	66343	<null>	65607	<null>	42044	92458	85102	46044	100682	125638	134014	74909	143634	481745	<null>	09:29:04	09:47:04
fetches per second	6	78553	114797	51645	<null>	54400	<null>	85557	<null>	16827	50633	73117	34841	116200	92625	120745	86533	<null>	201358	<null>	09:47:05	10:05:05
fetches per second	7	43861	96539	32114	38387	62147	<null>	51149	<null>	59274	97956	60817	1976	63898	52635	73780	<null>	184782	842142	<null>	10:05:06	10:23:06
fetches per second	8	19037	5102	16241	3369	18283	80210	25168	<null>	6747	2031	20103	1405	30200	990	9984	1580	25592	48464	<null>	10:23:07	10:41:07
fetches per second	9	30063	36150	39435	5070	49842	43645	40504	49945	2315	31232	59590	29997	61147	74592	76156	6449	<null>	7272	<null>	10:41:08	10:59:08
fetches per second	10	30615	8450	32935	<null>	24000	32940	31270	34971	12884	68600	37476	7404	43585	61524	80406	<null>	<null>	42347	<null>	10:59:09	11:17:09
marks per second	1	10677	6573	8710	<null>	9869	9714	8162	12592	10850	9787	10056	11909	7237	12458	5301	5828	7175	18215	<null>	08:17:00	08:35:00
marks per second	2	12872	16755	15591	20884	15178	25770	12979	13699	10232	<null>	14084	8719	7875	27921	9201	15851	30083	75350	<null>	08:35:01	08:53:01
marks per second	3	14248	6208	13358	16098	11649	25058	14257	14710	3887	10900	11594	11106	6103	25270	10933	<null>	34927	906	<null>	08:53:02	09:11:02
marks per second	4	16275	23510	10072	32905	15859	<null>	12652	17402	11023	17909	13096	13195	9860	21800	11327	26750	10304	14115	<null>	09:11:03	09:29:03
marks per second	5	15506	19028	12794	<null>	14928	<null>	9987	<null>	6355	15337	12909	7484	6582	23176	10853	13090	10689	31555	<null>	09:29:04	09:47:04
marks per second	6	16971	13072	11368	<null>	11841	<null>	12385	<null>	1698	7903	10692	5862	6400	14312	14912	9666	<null>	16322	<null>	09:47:05	10:05:05
marks per second	7	9299	13377	6816	10154	13404	<null>	7370	<null>	9357	12644	8625	352	4080	9685	14584	<null>	12887	186857	<null>	10:05:06	10:23:06
marks per second	8	4096	683	3413	832	3814	17696	3575	<null>	986	353	2450	236	1541	166	1970	310	525	865	<null>	10:23:07	10:41:07
marks per second	9	6460	5689	8320	929	10179	11069	5944	8657	346	5370	7921	4992	3100	12395	15312	1016	<null>	162	<null>	10:41:08	10:59:08
marks per second	10	6612	1205	7013	<null>	5018	8030	4328	5807	1713	11476	3409	1219	1717	9121	13522	<null>	<null>	899	<null>	10:59:09	11:17:09
reads/fetches*100	1	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	08:17:00	08:35:00
reads/fetches*100	2	0	0	0	0	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	<null>	08:35:01	08:53:01
reads/fetches*100	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	0	0	<null>	08:53:02	09:11:02
reads/fetches*100	4	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	<null>	09:11:03	09:29:03
reads/fetches*100	5	0	0	0	<null>	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	09:29:04	09:47:04
reads/fetches*100	6	0	0	0	<null>	0	<null>	0	<null>	0	0	0	0	0	0	0	0	<null>	0	<null>	09:47:05	10:05:05
reads/fetches*100	7	0	0	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	<null>	0	0	<null>	10:05:06	10:23:06
reads/fetches*100	8	0	0	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	10:23:07	10:41:07
reads/fetches*100	9	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	0	<null>	10:41:08	10:59:08
reads/fetches*100	10	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	<null>	<null>	0	<null>	10:59:09	11:17:09
writes/marks*100	1	0	0	0	<null>	0	1	0	0	1	0	0	0	0	0	0	1	5	0	<null>	08:17:00	08:35:00
writes/marks*100	2	0	0	0	0	0	0	0	0	1	<null>	0	0	0	0	0	0	0	0	<null>	08:35:01	08:53:01
writes/marks*100	3	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	<null>	1	0	<null>	08:53:02	09:11:02
writes/marks*100	4	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	4	0	<null>	09:11:03	09:29:03
writes/marks*100	5	0	0	0	<null>	0	<null>	0	<null>	0	1	0	0	0	0	0	0	3	0	<null>	09:29:04	09:47:04
writes/marks*100	6	0	0	0	<null>	0	<null>	0	<null>	0	1	0	0	0	1	0	0	<null>	0	<null>	09:47:05	10:05:05
writes/marks*100	7	0	0	0	0	0	<null>	0	<null>	1	0	0	0	0	1	0	<null>	3	0	<null>	10:05:06	10:23:06
writes/marks*100	8	0	0	0	0	0	0	0	<null>	1	0	0	1	0	0	0	0	0	0	<null>	10:23:07	10:41:07
writes/marks*100	9	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	<null>	0	<null>	10:41:08	10:59:08
writes/marks*100	10	0	0	0	<null>	0	0	0	0	2	1	0	0	0	0	0	<null>	<null>	1	<null>	10:59:09	11:17:09

Done for 9760 ms, from 11:34:02.81 to 11:34:12.57.

Performance in DETAILS:

UNIT	CNT_ALL	CNT_OK	CNT_ERR	ERR_PRC	OK_MIN_MS	OK_MAX_MS	OK_AVG_MS	CNT_LK_CONFL	JOB_BEG	JOB_END
doc_list_aiud	1987062	1784522	202540	10.19	0	8315	24	202540	2017-09-13 08:16	2017-09-13 11:17
doc_list_biud	1987535	1784522	203013	10.21	0	6942	8	203013	2017-09-13 08:16	2017-09-13 11:17
sp_add_invoice_to_stock	18228	10880	7348	40.31	15	98482	5427	7348	2017-09-13 08:16	2017-09-13 11:17
sp_cancel_adding_invoice	4562	3411	1151	25.23	0	61136	1422	1151	2017-09-13 08:16	2017-09-13 11:17
sp_cancel_client_order	6355	6204	151	2.37	0	3026	142	151	2017-09-13 08:16	2017-09-13 11:17
sp_cancel_customer_reserve	413346	223147	190199	46.01	0	3104	29	190199	2017-09-13 08:16	2017-09-13 11:17
sp_cancel_pay_from_customer	2472	2464	8	0.32	0	2106	83	8	2017-09-13 08:16	2017-09-13 11:17
sp_cancel_pay_to_supplier	1514	1509	5	0.33	0	2230	82	5	2017-09-13 08:16	2017-09-13 11:17
sp_cancel_supplier_invoice	10503	7874	2629	25.03	0	8954	255	2629	2017-09-13 08:16	2017-09-13 11:17
sp_cancel_supplier_order	1458	527	931	63.85	15	134753	11007	931	2017-09-13 08:16	2017-09-13 11:17
sp_cancel_write_off	24360	14770	9590	39.36	0	4695	90	9590	2017-09-13 08:16	2017-09-13 11:17
sp_client_order	76691	76691	0	0.00	0	6614	282	0	2017-09-13 08:16	2017-09-13 11:17
sp_customer_reserve	635339	635339	0	0.00	0	6100	73	0	2017-09-13 08:16	2017-09-13 11:17
sp_fill_shopping_cart	116209	115873	336	0.28	0	4025	57	0	2017-09-13 08:16	2017-09-13 11:17
sp_fill_shopping_cart_clo_res	635339	635339	0	0.00	0	3120	6	0	2017-09-13 08:16	2017-09-13 11:17
sp_get_clo_for_invoice	10880	10880	0	0.00	0	7332	182	0	2017-09-13 08:16	2017-09-13 11:17
sp_kill_cost_storno	32554	22154	10400	31.94	0	2199	10	10400	2017-09-13 08:16	2017-09-13 11:17
sp_kill_qstorno_ret_qs2qd	861369	469465	391904	45.49	0	6926	11	391904	2017-09-13 08:16	2017-09-13 11:17
sp_kill_qty_storno	505550	302596	202954	40.14	0	6942	36	202954	2017-09-13 08:16	2017-09-13 11:17
sp_lock_selected_doc	75300	65584	9716	12.90	0	1155	4	9716	2017-09-13 08:16	2017-09-13 11:17
sp_make_cost_storno	93458	93458	0	0.00	0	7488	212	0	2017-09-13 08:16	2017-09-13 11:17
sp_multiply_rows_for_pdistr	93458	93458	0	0.00	0	2745	29	0	2017-09-13 08:16	2017-09-13 11:17
sp_multiply_rows_for_qdistr	76691	76691	0	0.00	0	3556	95	0	2017-09-13 08:16	2017-09-13 11:17
sp_pay_from_customer	25619	25619	0	0.00	0	7629	526	0	2017-09-13 08:16	2017-09-13 11:17
sp_pay_to_supplier	21176	21176	0	0.00	0	6427	261	0	2017-09-13 08:16	2017-09-13 11:17
sp_payment_common	46795	46795	0	0.00	0	2823	37	0	2017-09-13 08:16	2017-09-13 11:17
sp_qd_handle_on_cancel_clo	6351	6204	147	2.31	0	2949	61	147	2017-09-13 08:16	2017-09-13 11:17
sp_qd_handle_on_invoice_upd_sts	15301	14291	1010	6.60	0	6381	198	1010	2017-09-13 08:16	2017-09-13 11:17
sp_qd_handle_on_reserve_upd_sts	35783	35783	0	0.00	0	2699	27	0	2017-09-13 08:16	2017-09-13 11:17
sp_reserve_write_off	36233	35783	450	1.24	0	7753	279	450	2017-09-13 08:16	2017-09-13 11:17
sp_supplier_invoice	19868	19751	117	0.58	0	36863	1923	0	2017-09-13 08:16	2017-09-13 11:17
sp_supplier_order	19650	19431	219	1.11	0	15241	1248	0	2017-09-13 08:16	2017-09-13 11:17
srv_find_qd_qs_mism	1220802	1018175	202627	16.59	0	5023	13	202627	2017-09-13 08:16	2017-09-13 11:17
srv_make_invnt_saldo	1902	1902	0	0.00	0	21606	1321	0	2017-09-13 08:16	2017-09-13 11:17
srv_make_money_saldo	2436	2436	0	0.00	0	1061	43	0	2017-09-13 08:16	2017-09-13 11:17
srv_recalc_idx_stat	12	12	0	0.00	2075	45318	8635	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_add_invoice_to_stock	7348	7348	0	0.00	0	2403	55	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_cancel_adding_invoice	631	631	0	0.00	0	3057	119	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_cancel_client_order	151	151	0	0.00	0	1482	46	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_cancel_customer_reserve	27	27	0	0.00	0	281	24	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_cancel_pay_from_customer	8	8	0	0.00	0	16	2	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_cancel_pay_to_supplier	5	5	0	0.00	0	78	15	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_cancel_supplier_invoice	575	575	0	0.00	0	1232	43	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_cancel_supplier_order	22951	22951	0	0.00	0	2636	45	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_cancel_write_off	19	19	0	0.00	0	203	32	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_reserve_write_off	450	450	0	0.00	0	718	33	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_supplier_invoice	117	117	0	0.00	0	1341	34	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-abend:sp_supplier_order	219	219	0	0.00	0	904	33	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_add_invoice_to_stock	10880	10880	0	0.00	0	12465	291	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_cancel_adding_invoice	1293	1293	0	0.00	0	7893	334	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_cancel_client_order	6204	6204	0	0.00	0	1794	33	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_cancel_customer_reserve	2479	2479	0	0.00	0	1513	30	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_cancel_pay_from_customer	2464	2464	0	0.00	0	2262	27	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_cancel_pay_to_supplier	1509	1509	0	0.00	0	2402	27	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_cancel_supplier_invoice	864	864	0	0.00	0	1263	29	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_cancel_supplier_order	527	527	0	0.00	0	27191	991	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_cancel_write_off	3581	3581	0	0.00	0	1872	32	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_client_order	76691	76691	0	0.00	0	2808	39	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_customer_reserve	3533	3533	0	0.00	0	1497	27	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_pay_from_customer	25619	25619	0	0.00	0	1966	33	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_pay_to_supplier	21176	21176	0	0.00	0	2075	28	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_reserve_write_off	35783	35783	0	0.00	0	2434	35	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_supplier_invoice	19751	19751	0	0.00	0	2698	33	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:sp_supplier_order	19431	19431	0	0.00	0	2808	37	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:srv_make_invnt_saldo	1902	1902	0	0.00	0	936	11	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:srv_make_money_saldo	2436	2436	0	0.00	0	842	17	0	2017-09-13 08:16	2017-09-13 11:17
t$perf-norm:srv_recalc_idx_stat	12	12	0	0.00	0	687	126	0	2017-09-13 08:16	2017-09-13 11:17
v_add_invoice_to_stock	36456	21760	14696	40.31	0	1748	9	14696	2017-09-13 08:16	2017-09-13 11:17
v_all_customers	114992	114992	0	0.00	0	1701	3	0	2017-09-13 08:16	2017-09-13 11:17
v_all_suppliers	80384	79712	672	0.83	0	1139	3	0	2017-09-13 08:16	2017-09-13 11:17
v_all_wares	153382	153382	0	0.00	0	1670	3	0	2017-09-13 08:16	2017-09-13 11:17
v_cancel_adding_invoice	2990	2586	404	13.51	0	3838	101	404	2017-09-13 08:16	2017-09-13 11:17
v_cancel_client_order	12710	12408	302	2.37	0	671	4	302	2017-09-13 08:16	2017-09-13 11:17
v_cancel_customer_prepayment	4944	4928	16	0.32	0	1466	5	16	2017-09-13 08:16	2017-09-13 11:17
v_cancel_customer_reserve	5012	4958	54	1.07	0	1388	6	54	2017-09-13 08:16	2017-09-13 11:17
v_cancel_payment_to_supplier	3028	3018	10	0.33	0	546	5	10	2017-09-13 08:16	2017-09-13 11:17
v_cancel_supplier_invoice	2878	1728	1150	39.95	0	328	7	1150	2017-09-13 08:16	2017-09-13 11:17
v_cancel_supplier_order	2916	1054	1862	63.85	0	312	4	1862	2017-09-13 08:16	2017-09-13 11:17
v_cancel_write_off	7200	7162	38	0.52	0	3728	70	38	2017-09-13 08:16	2017-09-13 11:17
v_max_id_clo_ord	19650	19431	219	1.11	0	639	3	0	2017-09-13 08:16	2017-09-13 11:17
v_max_id_clo_res	3533	3533	0	0.00	0	624	9	0	2017-09-13 08:16	2017-09-13 11:17
v_max_id_ord_sup	19868	19751	117	0.58	0	718	3	0	2017-09-13 08:16	2017-09-13 11:17
v_max_non_paid_invoice	20502	20502	0	0.00	0	920	3	0	2017-09-13 08:16	2017-09-13 11:17
v_max_non_paid_realizn	25619	25619	0	0.00	0	2028	3	0	2017-09-13 08:16	2017-09-13 11:17
v_min_id_clo_ord	19650	19431	219	1.11	0	1092	4	0	2017-09-13 08:16	2017-09-13 11:17
v_min_id_clo_res	3533	3533	0	0.00	0	671	6	0	2017-09-13 08:16	2017-09-13 11:17
v_min_id_ord_sup	19868	19751	117	0.58	0	920	4	0	2017-09-13 08:16	2017-09-13 11:17
v_min_non_paid_invoice	21176	21176	0	0.00	0	1124	4	0	2017-09-13 08:16	2017-09-13 11:17
v_min_non_paid_realizn	25619	25619	0	0.00	0	858	3	0	2017-09-13 08:16	2017-09-13 11:17
v_our_firm	38390	38390	0	0.00	0	873	3	0	2017-09-13 08:16	2017-09-13 11:17
v_reserve_write_off	72466	71566	900	1.24	0	873	4	900	2017-09-13 08:16	2017-09-13 11:17
x_lock_depdocs_on_canc_invoice	20409	10421	9988	48.93	0	2278	17	9988	2017-09-13 08:16	2017-09-13 11:17
x_lock_depdocs_on_canc_sup_ord	1455	527	928	63.78	0	1451	33	928	2017-09-13 08:16	2017-09-13 11:17
x_make_qstorno_1000_1200	19650	19431	219	1.11	0	14087	1119	0	2017-09-13 08:16	2017-09-13 11:17
x_make_qstorno_1200_2000	19868	19751	117	0.58	0	35973	1796	0	2017-09-13 08:16	2017-09-13 11:17
x_make_qstorno_2100_3300	635339	635339	0	0.00	0	5538	60	0	2017-09-13 08:16	2017-09-13 11:17

Done for 486840 ms, from 11:42:01.79 to 11:50:08.63.

Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.

Exceptions occured during test work:

FB_MNEMONA	CNT	UNIT	FB_GDSCODE	DTS_BEG	DTS_END
deadlock	88	sp_kill_cost_storno	335544336	2017-09-13 08:17	2017-09-13 11:16
deadlock	93	sp_kill_qstorno_ret_qs2qd	335544336	2017-09-13 08:20	2017-09-13 11:16
deadlock	8432	sp_lock_selected_doc	335544336	2017-09-13 08:17	2017-09-13 11:17
deadlock	147	sp_qd_handle_on_cancel_clo	335544336	2017-09-13 08:17	2017-09-13 11:16
deadlock	174	sp_qd_handle_on_invoice_upd_sts	335544336	2017-09-13 08:17	2017-09-13 11:12
deadlock	565	x_lock_depdocs_on_canc_invoice	335544336	2017-09-13 08:17	2017-09-13 11:16
deadlock	214	x_lock_depdocs_on_canc_sup_ord	335544336	2017-09-13 08:18	2017-09-13 11:15
user_exc	219	x_make_qstorno_1000_1200	335544517	2017-09-13 08:17	2017-09-13 11:16
user_exc	117	x_make_qstorno_1200_2000	335544517	2017-09-13 08:17	2017-09-13 11:11

Done for 15540 ms, from 11:50:23.61 to 11:50:39.15.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 423666
MON$OLDEST_ACTIVE 423667
MON$OLDEST_SNAPSHOT 423667
MON$NEXT_TRANSACTION 423667
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 836288
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.743 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.743 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.743 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.743 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0

Database statistics, full

Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 423710
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 423668
Oldest active 423669
Oldest snapshot 423669
Next transaction 423670
Sequence number 0
Next attachment ID 9306
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write

Variable header data:
Sweep interval: 0
*END*

Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.27
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Root page: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Root page: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.03, total records: 2055292
Average version length: 47.87, total versions: 2027, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 14, data page slots: 22168
Data pages: 22168, average fill: 73%
Primary pages: 22168, secondary pages: 0, swept pages: 13274
Empty pages: 5, full pages: 20728
Fill distribution:
0 - 19% = 6
20 - 39% = 3
40 - 59% = 77
60 - 79% = 22078
80 - 99% = 4

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 9816, nodes: 2055292
Average node length: 19.35, total dup: 0, max dup: 0
Average key length: 16.39, compression ratio: 1.65
Average prefix length: 13.60, average data length: 13.40
Clustering factor: 316207, ratio: 0.15
Fill distribution:
0 - 19% = 854
20 - 39% = 2380
40 - 59% = 3606
60 - 79% = 1189
80 - 99% = 1787

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7362, nodes: 2055292
Average node length: 11.65, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 305084, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 3391
40 - 59% = 3865
60 - 79% = 97
80 - 99% = 8

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175374, depth: 3, leaf buckets: 3384, nodes: 2055292
Average node length: 6.84, total dup: 1490687, max dup: 49
Average key length: 3.89, compression ratio: 2.32
Average prefix length: 7.39, average data length: 1.61
Clustering factor: 282927, ratio: 0.14
Fill distribution:
0 - 19% = 132
20 - 39% = 1013
40 - 59% = 1209
60 - 79% = 418
80 - 99% = 612

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.50, total records: 627279
Average version length: 61.37, total versions: 478, max versions: 1
Average fragment length: 32.00, total fragments: 2, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7904
Data pages: 7904, average fill: 75%
Primary pages: 7903, secondary pages: 1, swept pages: 6339
Empty pages: 1, full pages: 7683
Fill distribution:
0 - 19% = 2
20 - 39% = 6
40 - 59% = 22
60 - 79% = 7859
80 - 99% = 15

Index DOC_LIST_ID_DESC (1)
Root page: 250817, depth: 3, leaf buckets: 2254, nodes: 627279
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 127574, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 1164
40 - 59% = 1013
60 - 79% = 66
80 - 99% = 11

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 655, nodes: 627279
Average node length: 4.87, total dup: 627229, max dup: 32494
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 283363, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 548
60 - 79% = 87
80 - 99% = 19

Index PK_DOC_LIST (0)
Root page: 330690, depth: 3, leaf buckets: 1619, nodes: 627279
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 127574, ratio: 0.20
Fill distribution:
0 - 19% = 113
20 - 39% = 291
40 - 59% = 509
60 - 79% = 352
80 - 99% = 354

DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 63.66, total records: 400
Average version length: 18.13, total versions: 24201, max versions: 386
Average fragment length: 16.42, total fragments: 339, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.63
Pointer pages: 1, data page slots: 248
Data pages: 248, average fill: 49%
Primary pages: 10, secondary pages: 238, swept pages: 0
Empty pages: 6, full pages: 31
Fill distribution:
0 - 19% = 14
20 - 39% = 99
40 - 59% = 2
60 - 79% = 111
80 - 99% = 22

Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 11.24, total records: 3476
Average version length: 71.15, total versions: 2926, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 8.54
Pointer pages: 1, data page slots: 720
Data pages: 128, average fill: 35%
Primary pages: 128, secondary pages: 0, swept pages: 30
Empty pages: 51, full pages: 30
Fill distribution:
0 - 19% = 61
20 - 39% = 13
40 - 59% = 10
60 - 79% = 23
80 - 99% = 21

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 16, nodes: 3476
Average node length: 15.43, total dup: 2, max dup: 1
Average key length: 13.56, compression ratio: 1.99
Average prefix length: 16.44, average data length: 10.56
Clustering factor: 2927, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 9
40 - 59% = 5
60 - 79% = 2
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.02, total records: 49
Average version length: 9.00, total versions: 552, max versions: 80
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.13
Pointer pages: 1, data page slots: 5
Data pages: 5, average fill: 45%
Primary pages: 1, secondary pages: 4, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 2
60 - 79% = 0
80 - 99% = 1

Index PK_MONEY_SALDO (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 6.96, total records: 190
Average version length: 44.93, total versions: 160, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 9.19
Pointer pages: 1, data page slots: 32
Data pages: 24, average fill: 8%
Primary pages: 24, secondary pages: 0, swept pages: 4
Empty pages: 16, full pages: 0
Fill distribution:
0 - 19% = 21
20 - 39% = 1
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 521752, depth: 2, leaf buckets: 1, nodes: 190
Average node length: 7.35, total dup: 138, max dup: 24
Average key length: 6.03, compression ratio: 3.15
Average prefix length: 15.24, average data length: 3.76
Clustering factor: 92, ratio: 0.48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (165)
Primary pointer page: 356, Index root page: 357
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Root page: 244, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Root page: 243, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 18.93, total records: 757448
Average version length: 42.74, total versions: 679, max versions: 4
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.38
Pointer pages: 3, data page slots: 4544
Data pages: 4544, average fill: 74%
Primary pages: 4540, secondary pages: 4, swept pages: 3816
Empty pages: 11, full pages: 4131
Fill distribution:
0 - 19% = 23
20 - 39% = 63
40 - 59% = 89
60 - 79% = 3976
80 - 99% = 393

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 242, nodes: 224712
Average node length: 4.88, total dup: 224663, max dup: 12329
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 31011, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 165
60 - 79% = 47
80 - 99% = 12

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 260, nodes: 224712
Average node length: 5.81, total dup: 202787, max dup: 75
Average key length: 2.94, compression ratio: 7.48
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 34825, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 109
60 - 79% = 83
80 - 99% = 47

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 249, nodes: 224712
Average node length: 5.81, total dup: 202787, max dup: 75
Average key length: 2.94, compression ratio: 7.48
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 34863, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 13
40 - 59% = 90
60 - 79% = 86
80 - 99% = 58

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 246, nodes: 224712
Average node length: 5.60, total dup: 202787, max dup: 75
Average key length: 2.73, compression ratio: 3.30
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 34854, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 96
60 - 79% = 84
80 - 99% = 49

PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.98, total records: 254997
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2184
Data pages: 2184, average fill: 64%
Primary pages: 2184, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 2179
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2179
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 817217, depth: 2, leaf buckets: 200, nodes: 254997
Average node length: 4.50, total dup: 254816, max dup: 2405
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 64129, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 66
60 - 79% = 69
80 - 99% = 65

PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Root page: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.77, total records: 12193357
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.17
Pointer pages: 178, data page slots: 289600
Data pages: 289600, average fill: 87%
Primary pages: 289600, secondary pages: 0, swept pages: 3
Empty pages: 2, full pages: 289597
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 289597

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 14372, nodes: 12193357
Average node length: 5.69, total dup: 11323302, max dup: 146
Average key length: 2.18, compression ratio: 3.67
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 2725854, ratio: 0.22
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 9305
60 - 79% = 3244
80 - 99% = 1818

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 12235, nodes: 12193357
Average node length: 4.63, total dup: 12193353, max dup: 10723837
Average key length: 1.12, compression ratio: 0.54
Average prefix length: 0.60, average data length: 0.00
Clustering factor: 352933, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 12233
60 - 79% = 0
80 - 99% = 2

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 15278, nodes: 12193357
Average node length: 5.72, total dup: 11844327, max dup: 30382
Average key length: 2.21, compression ratio: 4.07
Average prefix length: 8.81, average data length: 0.19
Clustering factor: 741895, ratio: 0.06
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 12187
60 - 79% = 1772
80 - 99% = 1319

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 14648, nodes: 12193357
Average node length: 5.58, total dup: 12169563, max dup: 1812929
Average key length: 2.07, compression ratio: 18.36
Average prefix length: 37.87, average data length: 0.06
Clustering factor: 5752332, ratio: 0.47
Fill distribution:
0 - 19% = 13
20 - 39% = 2
40 - 59% = 12504
60 - 79% = 404
80 - 99% = 1725

PHRASES (145)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Root page: 283, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.06, total records: 428850
Average version length: 55.76, total versions: 484, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5088
Data pages: 5088, average fill: 75%
Primary pages: 5088, secondary pages: 0, swept pages: 3520
Empty pages: 6, full pages: 4861
Fill distribution:
0 - 19% = 7
20 - 39% = 1
40 - 59% = 16
60 - 79% = 5064
80 - 99% = 0

Index PSTORNED_RCV_ID (2)
Root page: 703296, depth: 3, leaf buckets: 563, nodes: 428850
Average node length: 5.89, total dup: 363528, max dup: 912
Average key length: 3.11, compression ratio: 2.89
Average prefix length: 8.04, average data length: 0.96
Clustering factor: 50207, ratio: 0.12
Fill distribution:
0 - 19% = 10
20 - 39% = 29
40 - 59% = 359
60 - 79% = 114
80 - 99% = 51

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 453, nodes: 428850
Average node length: 5.59, total dup: 382510, max dup: 125
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 102193, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 176
60 - 79% = 201
80 - 99% = 72

RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_PDISTR_UNQ (0)
Root page: 310, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 245, Index root page: 246
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 248, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Root page: 247, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 953, max versions: 860
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 4
Data pages: 4, average fill: 78%
Primary pages: 1, secondary pages: 3, swept pages: 0
Empty pages: 0, full pages: 3
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 2

Index PK_SEMAPHORES (0)
Root page: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Root page: 218, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 226, Index root page: 227
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$RESULT_SET (130)
Primary pointer page: 219, Index root page: 220
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Root page: 222, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 221, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 211, Index root page: 212
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Root page: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.48, total records: 2530
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.54
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 72%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 1, full pages: 30
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 30
80 - 99% = 0

WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 45.07, total records: 8810
Average version length: 72.20, total versions: 3311, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.02
Pointer pages: 1, data page slots: 1016
Data pages: 225, average fill: 47%
Primary pages: 225, secondary pages: 0, swept pages: 43
Empty pages: 77, full pages: 100
Fill distribution:
0 - 19% = 87
20 - 39% = 6
40 - 59% = 15
60 - 79% = 47
80 - 99% = 70

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 14, nodes: 8810
Average node length: 6.31, total dup: 7673, max dup: 14
Average key length: 4.32, compression ratio: 8.56
Average prefix length: 34.80, average data length: 2.20
Clustering factor: 1519, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 9
60 - 79% = 1
80 - 99% = 2

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.90, total records: 796499
Average version length: 72.01, total versions: 3236, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 8, data page slots: 11984
Data pages: 11976, average fill: 73%
Primary pages: 11976, secondary pages: 0, swept pages: 7699
Empty pages: 54, full pages: 8915
Fill distribution:
0 - 19% = 97
20 - 39% = 87
40 - 59% = 575
60 - 79% = 11190
80 - 99% = 27

Index XQD_1000_3300_DOC (1)
Root page: 672570, depth: 3, leaf buckets: 856, nodes: 796499
Average node length: 5.10, total dup: 775291, max dup: 119
Average key length: 2.19, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 89074, ratio: 0.11
Fill distribution:
0 - 19% = 18
20 - 39% = 49
40 - 59% = 564
60 - 79% = 47
80 - 99% = 178

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 298108, depth: 3, leaf buckets: 1097, nodes: 796499
Average node length: 6.22, total dup: 695643, max dup: 17
Average key length: 3.31, compression ratio: 11.17
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 154031, ratio: 0.19
Fill distribution:
0 - 19% = 12
20 - 39% = 142
40 - 59% = 637
60 - 79% = 168
80 - 99% = 138

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 17.64, total records: 94512
Average version length: 72.13, total versions: 6249, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 7.71
Pointer pages: 2, data page slots: 2592
Data pages: 2544, average fill: 20%
Primary pages: 2543, secondary pages: 1, swept pages: 1070
Empty pages: 380, full pages: 150
Fill distribution:
0 - 19% = 1666
20 - 39% = 422
40 - 59% = 220
60 - 79% = 154
80 - 99% = 82

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 36, nodes: 20080
Average node length: 6.20, total dup: 17850, max dup: 46
Average key length: 3.63, compression ratio: 10.20
Average prefix length: 35.48, average data length: 1.52
Clustering factor: 2330, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 13
40 - 59% = 19
60 - 79% = 3
80 - 99% = 1

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 49.43, total records: 2338187
Average version length: 71.49, total versions: 25499, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.75
Pointer pages: 19, data page slots: 29816
Data pages: 29816, average fill: 65%
Primary pages: 29816, secondary pages: 0, swept pages: 12938
Empty pages: 281, full pages: 25613
Fill distribution:
0 - 19% = 544
20 - 39% = 5172
40 - 59% = 2445
60 - 79% = 18769
80 - 99% = 2886

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 189088, depth: 3, leaf buckets: 2349, nodes: 1525095
Average node length: 5.60, total dup: 1437138, max dup: 49
Average key length: 2.63, compression ratio: 14.06
Average prefix length: 36.42, average data length: 0.58
Clustering factor: 162888, ratio: 0.11
Fill distribution:
0 - 19% = 12
20 - 39% = 1061
40 - 59% = 917
60 - 79% = 192
80 - 99% = 167

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.00, total records: 4066486
Average version length: 70.76, total versions: 94, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.10
Pointer pages: 17, data page slots: 26568
Data pages: 26560, average fill: 49%
Primary pages: 26559, secondary pages: 1, swept pages: 8691
Empty pages: 30, full pages: 26132
Fill distribution:
0 - 19% = 121
20 - 39% = 10094
40 - 59% = 6192
60 - 79% = 10021
80 - 99% = 132

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 2, nodes: 424
Average node length: 12.35, total dup: 301, max dup: 13
Average key length: 9.35, compression ratio: 3.96
Average prefix length: 29.94, average data length: 7.06
Clustering factor: 95, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 63.22, total records: 3051952
Average version length: 71.15, total versions: 8188, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.15
Pointer pages: 25, data page slots: 39368
Data pages: 39368, average fill: 77%
Primary pages: 39368, secondary pages: 0, swept pages: 27296
Empty pages: 26, full pages: 37684
Fill distribution:
0 - 19% = 50
20 - 39% = 241
40 - 59% = 817
60 - 79% = 35919
80 - 99% = 2341

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5545, nodes: 2663424
Average node length: 6.85, total dup: 2160182, max dup: 14
Average key length: 3.88, compression ratio: 9.53
Average prefix length: 35.31, average data length: 1.69
Clustering factor: 414180, ratio: 0.16
Fill distribution:
0 - 19% = 6
20 - 39% = 3166
40 - 59% = 1925
60 - 79% = 264
80 - 99% = 184

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.55, total records: 4508504
Average version length: 84.53, total versions: 1090, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 43, data page slots: 69232
Data pages: 69232, average fill: 80%
Primary pages: 69232, secondary pages: 0, swept pages: 24810
Empty pages: 7, full pages: 68812
Fill distribution:
0 - 19% = 11
20 - 39% = 4
40 - 59% = 29
60 - 79% = 19987
80 - 99% = 49201

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4630, nodes: 4508504
Average node length: 5.15, total dup: 4406283, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 692027, ratio: 0.15
Fill distribution:
0 - 19% = 19
20 - 39% = 82
40 - 59% = 2099
60 - 79% = 1885
80 - 99% = 545

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 4321, nodes: 4508504
Average node length: 5.70, total dup: 4034156, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 174799, ratio: 0.04
Fill distribution:
0 - 19% = 27
20 - 39% = 87
40 - 59% = 1631
60 - 79% = 289
80 - 99% = 2287

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5168, nodes: 4508504
Average node length: 5.81, total dup: 3945450, max dup: 22
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 745655, ratio: 0.17
Fill distribution:
0 - 19% = 30
20 - 39% = 91
40 - 59% = 2313
60 - 79% = 2014
80 - 99% = 720

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.09, total records: 2587746
Average version length: 83.74, total versions: 7017, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 25, data page slots: 40176
Data pages: 40176, average fill: 79%
Primary pages: 40176, secondary pages: 0, swept pages: 29026
Empty pages: 14, full pages: 39050
Fill distribution:
0 - 19% = 24
20 - 39% = 32
40 - 59% = 185
60 - 79% = 15271
80 - 99% = 24664

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2753, nodes: 2587746
Average node length: 5.15, total dup: 2527429, max dup: 161
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 397982, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 42
40 - 59% = 1613
60 - 79% = 807
80 - 99% = 290

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 3977, nodes: 2587746
Average node length: 6.23, total dup: 2119704, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 195409, ratio: 0.08
Fill distribution:
0 - 19% = 96
20 - 39% = 1248
40 - 59% = 1504
60 - 79% = 687
80 - 99% = 442

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3125, nodes: 2587746
Average node length: 5.81, total dup: 2264039, max dup: 29
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 479900, ratio: 0.19
Fill distribution:
0 - 19% = 20
20 - 39% = 55
40 - 59% = 1836
60 - 79% = 899
80 - 99% = 315

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.56, total records: 4770221
Average version length: 84.31, total versions: 8382, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 46, data page slots: 73872
Data pages: 73872, average fill: 80%
Primary pages: 73872, secondary pages: 0, swept pages: 19993
Empty pages: 254, full pages: 71376
Fill distribution:
0 - 19% = 343
20 - 39% = 274
40 - 59% = 732
60 - 79% = 13519
80 - 99% = 59004

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 4928, nodes: 4770221
Average node length: 5.04, total dup: 4742541, max dup: 670
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 687145, ratio: 0.14
Fill distribution:
0 - 19% = 5
20 - 39% = 156
40 - 59% = 2695
60 - 79% = 1486
80 - 99% = 586

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5457, nodes: 4770221
Average node length: 5.52, total dup: 4397897, max dup: 49
Average key length: 2.54, compression ratio: 3.55
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 191875, ratio: 0.04
Fill distribution:
0 - 19% = 110
20 - 39% = 1220
40 - 59% = 1959
60 - 79% = 668
80 - 99% = 1500

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5549, nodes: 4770221
Average node length: 5.69, total dup: 4277565, max dup: 77
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 764344, ratio: 0.16
Fill distribution:
0 - 19% = 4
20 - 39% = 136
40 - 59% = 3075
60 - 79% = 1666
80 - 99% = 668

XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_DOC_ID (0)
Root page: 823, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Root page: 825, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Root page: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.24, total records: 3267696
Average version length: 83.56, total versions: 5783, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 31, data page slots: 50552
Data pages: 50552, average fill: 80%
Primary pages: 50552, secondary pages: 0, swept pages: 34878
Empty pages: 20, full pages: 49478
Fill distribution:
0 - 19% = 41
20 - 39% = 46
40 - 59% = 200
60 - 79% = 15756
80 - 99% = 34509

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3568, nodes: 3267696
Average node length: 5.02, total dup: 3251973, max dup: 1329
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 586228, ratio: 0.18
Fill distribution:
0 - 19% = 14
20 - 39% = 367
40 - 59% = 1980
60 - 79% = 810
80 - 99% = 397

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 4985, nodes: 3267696
Average node length: 6.24, total dup: 2675861, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 265259, ratio: 0.08
Fill distribution:
0 - 19% = 166
20 - 39% = 1489
40 - 59% = 1841
60 - 79% = 856
80 - 99% = 633

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 3947, nodes: 3267696
Average node length: 5.59, total dup: 2981584, max dup: 99
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 632051, ratio: 0.19
Fill distribution:
0 - 19% = 20
20 - 39% = 391
40 - 59% = 2117
60 - 79% = 977
80 - 99% = 442

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.39, total records: 607341
Average version length: 69.86, total versions: 664, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 6, data page slots: 8312
Data pages: 8312, average fill: 77%
Primary pages: 8312, secondary pages: 0, swept pages: 6358
Empty pages: 0, full pages: 8202
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 12
60 - 79% = 8275
80 - 99% = 21

Index XQS_3300_3400_DOC_ID (0)
Root page: 25777, depth: 3, leaf buckets: 719, nodes: 607341
Average node length: 5.32, total dup: 570865, max dup: 112
Average key length: 2.46, compression ratio: 3.66
Average prefix length: 8.60, average data length: 0.40
Clustering factor: 52610, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 152
40 - 59% = 285
60 - 79% = 187
80 - 99% = 93

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 797, nodes: 607341
Average node length: 5.92, total dup: 518193, max dup: 14
Average key length: 3.06, compression ratio: 2.95
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 55341, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 153
40 - 59% = 348
60 - 79% = 201
80 - 99% = 94

ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Root page: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Root page: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Root page: 686, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Root page: 689, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Root page: 688, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Root page: 691, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Root page: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Z_USED_VIEWS (146)
Primary pointer page: 271, Index root page: 272
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 85990 ms, from 11:50:39.71 to 11:52:05.70.

Analyzing DB stat log: obtaining values of total records and versions

TABLE_NAME	TOTAL_RECS	TOTAL_VERS	VERS_PERCENT
AGENTS	50	0	0.0000
BUSINESS_OPS	19	0	0.0000
DOC_DATA	2055292	2027	0.0986
DOC_LIST	627279	478	0.0762
DOC_STATES	4	0	0.0000
FB_ERRORS	758	0	0.0000
INVNT_SALDO	400	24201	6050.2500
INVNT_TURNOVER_LOG	3476	2926	84.1772
MONEY_SALDO	49	552	1126.5306
MONEY_TURNOVER_LOG	190	160	84.2105
OPTYPES	9	0	0.0000
PDISTR	757448	679	0.0896
PERF_ESTIMATED	254997	0	0.0000
PERF_LOG	12193357	0	0.0000
PSTORNED	428850	484	0.1128
RULES_FOR_PDISTR	4	0	0.0000
RULES_FOR_QDISTR	7	0	0.0000
SEMAPHORES	4	953	23825.0000
SETTINGS	114	0	0.0000
TRACE_STAT	2530	0	0.0000
WARES	400	0	0.0000
WARE_GROUPS	8	0	0.0000
XQD_1000_1200	8810	3311	37.5822
XQD_1000_3300	796499	3236	0.4062
XQD_1200_2000	94512	6249	6.6118
XQD_2000_3300	2338187	25499	1.0905
XQD_2100_3300	4066486	94	0.0023
XQD_3300_3400	3051952	8188	0.2682
XQS_1000_1200	4508504	1090	0.0241
XQS_1000_3300	2587746	7017	0.2711
XQS_1200_2000	4770221	8382	0.1757
XQS_2100_3300	3267696	5783	0.1769
XQS_3300_3400	607341	664	0.1093
Z_USED_VIEWS	29	0	0.0000

Done for 2340 ms, from 11:52:18.05 to 11:52:20.39.

Database validation

11:52:20.52 Validation started

11:52:20.53 Relation 140 (DOC_LIST)
11:52:20.55 process pointer page 0 of 5
11:52:20.64 process pointer page 1 of 5
11:52:20.74 process pointer page 2 of 5
11:52:20.85 process pointer page 3 of 5
11:52:20.95 process pointer page 4 of 5
11:52:20.99 Index 1 (PK_DOC_LIST)
11:52:21.08 Index 2 (DOC_LIST_ID_DESC)
11:52:21.33 Index 3 (FK_DOC_LIST_AGENTS)
11:52:21.59 Relation 140 (DOC_LIST) is ok

11:52:21.59 Relation 141 (DOC_DATA)
11:52:21.59 process pointer page 0 of 14
11:52:21.67 process pointer page 1 of 14
11:52:21.78 process pointer page 2 of 14
11:52:21.86 process pointer page 3 of 14
11:52:21.95 process pointer page 4 of 14
11:52:22.05 process pointer page 5 of 14
11:52:22.14 process pointer page 6 of 14
11:52:22.23 process pointer page 7 of 14
11:52:22.31 process pointer page 8 of 14
11:52:22.41 process pointer page 9 of 14
11:52:22.50 process pointer page 10 of 14
11:52:22.59 process pointer page 11 of 14
11:52:22.69 process pointer page 12 of 14
11:52:22.76 process pointer page 13 of 14
11:52:22.83 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:52:23.81 Index 3 (DOC_DATA_ID_DESC)
11:52:24.64 Index 4 (FK_DOC_DATA_DOC_LIST)
11:52:25.26 Relation 141 (DOC_DATA) is ok

11:52:25.26 Relation 147 (INVNT_SALDO)
11:52:25.28 process pointer page 0 of 1
11:52:25.35 Index 1 (PK_INVNT_SALDO)
11:52:25.35 Relation 147 (INVNT_SALDO) is ok

11:52:25.35 Relation 150 (PDISTR)
11:52:25.35 process pointer page 0 of 3
11:52:25.43 process pointer page 1 of 3
11:52:25.53 process pointer page 2 of 3
11:52:25.59 Index 2 (PDISTR_SND_ID)
11:52:25.68 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:52:25.76 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:52:25.85 Index 5 (PDISTR_AGENT_ID)
11:52:25.92 Relation 150 (PDISTR) is ok

11:52:25.92 Relation 151 (PSTORNED)
11:52:25.92 process pointer page 0 of 4
11:52:26.01 process pointer page 1 of 4
11:52:26.10 process pointer page 2 of 4
11:52:26.18 process pointer page 3 of 4
11:52:26.20 Index 2 (PSTORNED_SND_ID)
11:52:26.34 Index 3 (PSTORNED_RCV_ID)
11:52:26.48 Relation 151 (PSTORNED) is ok

11:52:26.48 Relation 156 (SEMAPHORES)
11:52:26.48 process pointer page 0 of 1
11:52:26.48 Index 1 (PK_SEMAPHORES)
11:52:26.48 Index 2 (SEMAPHORES_TASK_UNQ)
11:52:26.48 Relation 156 (SEMAPHORES) is ok

11:52:26.48 Relation 157 (INVNT_TURNOVER_LOG)
11:52:26.48 process pointer page 0 of 1
11:52:26.49 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:52:26.49 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:52:26.49 Relation 160 (PERF_ESTIMATED)
11:52:26.49 process pointer page 0 of 2
11:52:26.59 process pointer page 1 of 2
11:52:26.62 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:52:26.70 Relation 160 (PERF_ESTIMATED) is ok

11:52:26.70 Relation 161 (PERF_ISQL_STAT)
11:52:26.70 process pointer page 0 of 1
11:52:26.70 Index 1 (PERF_ISQL_STAT_TRN)
11:52:26.70 Relation 161 (PERF_ISQL_STAT) is ok

11:52:26.70 Relation 162 (TRACE_STAT)
11:52:26.70 process pointer page 0 of 1
11:52:26.70 Relation 162 (TRACE_STAT) is ok

11:52:26.70 Relation 163 (PERF_LOG)
11:52:26.70 process pointer page 0 of 178
11:52:26.79 process pointer page 1 of 178
11:52:26.87 process pointer page 2 of 178
11:52:26.94 process pointer page 3 of 178
11:52:27.04 process pointer page 4 of 178
11:52:27.12 process pointer page 5 of 178
11:52:27.19 process pointer page 6 of 178
11:52:27.29 process pointer page 7 of 178
11:52:27.37 process pointer page 8 of 178
11:52:27.46 process pointer page 9 of 178
11:52:27.54 process pointer page 10 of 178
11:52:27.62 process pointer page 11 of 178
11:52:27.71 process pointer page 12 of 178
11:52:27.79 process pointer page 13 of 178
11:52:27.87 process pointer page 14 of 178
11:52:27.96 process pointer page 15 of 178
11:52:28.04 process pointer page 16 of 178
11:52:28.13 process pointer page 17 of 178
11:52:28.21 process pointer page 18 of 178
11:52:28.29 process pointer page 19 of 178
11:52:28.38 process pointer page 20 of 178
11:52:28.46 process pointer page 21 of 178
11:52:28.54 process pointer page 22 of 178
11:52:28.63 process pointer page 23 of 178
11:52:28.71 process pointer page 24 of 178
11:52:28.79 process pointer page 25 of 178
11:52:28.88 process pointer page 26 of 178
11:52:28.96 process pointer page 27 of 178
11:52:29.04 process pointer page 28 of 178
11:52:29.13 process pointer page 29 of 178
11:52:29.21 process pointer page 30 of 178
11:52:29.30 process pointer page 31 of 178
11:52:29.33 process pointer page 32 of 178
11:52:29.39 process pointer page 33 of 178
11:52:29.47 process pointer page 34 of 178
11:52:29.57 process pointer page 35 of 178
11:52:29.64 process pointer page 36 of 178
11:52:29.72 process pointer page 37 of 178
11:52:29.83 process pointer page 38 of 178
11:52:29.91 process pointer page 39 of 178
11:52:30.00 process pointer page 40 of 178
11:52:30.08 process pointer page 41 of 178
11:52:30.16 process pointer page 42 of 178
11:52:30.25 process pointer page 43 of 178
11:52:30.33 process pointer page 44 of 178
11:52:30.41 process pointer page 45 of 178
11:52:30.50 process pointer page 46 of 178
11:52:30.58 process pointer page 47 of 178
11:52:30.66 process pointer page 48 of 178
11:52:30.75 process pointer page 49 of 178
11:52:30.83 process pointer page 50 of 178
11:52:30.91 process pointer page 51 of 178
11:52:31.00 process pointer page 52 of 178
11:52:31.08 process pointer page 53 of 178
11:52:31.16 process pointer page 54 of 178
11:52:31.23 process pointer page 55 of 178
11:52:31.31 process pointer page 56 of 178
11:52:31.41 process pointer page 57 of 178
11:52:31.48 process pointer page 58 of 178
11:52:31.56 process pointer page 59 of 178
11:52:31.64 process pointer page 60 of 178
11:52:31.72 process pointer page 61 of 178
11:52:31.84 process pointer page 62 of 178
11:52:31.92 process pointer page 63 of 178
11:52:32.00 process pointer page 64 of 178
11:52:32.08 process pointer page 65 of 178
11:52:32.16 process pointer page 66 of 178
11:52:32.23 process pointer page 67 of 178
11:52:32.31 process pointer page 68 of 178
11:52:32.40 process pointer page 69 of 178
11:52:32.45 process pointer page 70 of 178
11:52:32.48 process pointer page 71 of 178
11:52:32.58 process pointer page 72 of 178
11:52:32.65 process pointer page 73 of 178
11:52:32.73 process pointer page 74 of 178
11:52:32.81 process pointer page 75 of 178
11:52:32.89 process pointer page 76 of 178
11:52:32.98 process pointer page 77 of 178
11:52:33.06 process pointer page 78 of 178
11:52:33.14 process pointer page 79 of 178
11:52:33.22 process pointer page 80 of 178
11:52:33.29 process pointer page 81 of 178
11:52:33.39 process pointer page 82 of 178
11:52:33.47 process pointer page 83 of 178
11:52:33.54 process pointer page 84 of 178
11:52:33.62 process pointer page 85 of 178
11:52:33.70 process pointer page 86 of 178
11:52:33.79 process pointer page 87 of 178
11:52:33.87 process pointer page 88 of 178
11:52:33.95 process pointer page 89 of 178
11:52:34.03 process pointer page 90 of 178
11:52:34.12 process pointer page 91 of 178
11:52:34.20 process pointer page 92 of 178
11:52:34.28 process pointer page 93 of 178
11:52:34.35 process pointer page 94 of 178
11:52:34.43 process pointer page 95 of 178
11:52:34.51 process pointer page 96 of 178
11:52:34.60 process pointer page 97 of 178
11:52:34.67 process pointer page 98 of 178
11:52:34.70 process pointer page 99 of 178
11:52:34.73 process pointer page 100 of 178
11:52:34.79 process pointer page 101 of 178
11:52:34.87 process pointer page 102 of 178
11:52:34.95 process pointer page 103 of 178
11:52:35.03 process pointer page 104 of 178
11:52:35.12 process pointer page 105 of 178
11:52:35.20 process pointer page 106 of 178
11:52:35.28 process pointer page 107 of 178
11:52:35.35 process pointer page 108 of 178
11:52:35.43 process pointer page 109 of 178
11:52:35.51 process pointer page 110 of 178
11:52:35.60 process pointer page 111 of 178
11:52:35.68 process pointer page 112 of 178
11:52:35.76 process pointer page 113 of 178
11:52:35.84 process pointer page 114 of 178
11:52:35.91 process pointer page 115 of 178
11:52:35.99 process pointer page 116 of 178
11:52:36.09 process pointer page 117 of 178
11:52:36.16 process pointer page 118 of 178
11:52:36.24 process pointer page 119 of 178
11:52:36.32 process pointer page 120 of 178
11:52:36.40 process pointer page 121 of 178
11:52:36.48 process pointer page 122 of 178
11:52:36.57 process pointer page 123 of 178
11:52:36.65 process pointer page 124 of 178
11:52:36.73 process pointer page 125 of 178
11:52:36.80 process pointer page 126 of 178
11:52:36.88 process pointer page 127 of 178
11:52:36.98 process pointer page 128 of 178
11:52:37.05 process pointer page 129 of 178
11:52:37.13 process pointer page 130 of 178
11:52:37.21 process pointer page 131 of 178
11:52:37.30 process pointer page 132 of 178
11:52:37.38 process pointer page 133 of 178
11:52:37.46 process pointer page 134 of 178
11:52:37.54 process pointer page 135 of 178
11:52:37.62 process pointer page 136 of 178
11:52:37.71 process pointer page 137 of 178
11:52:37.79 process pointer page 138 of 178
11:52:37.86 process pointer page 139 of 178
11:52:37.96 process pointer page 140 of 178
11:52:38.04 process pointer page 141 of 178
11:52:38.11 process pointer page 142 of 178
11:52:38.19 process pointer page 143 of 178
11:52:38.29 process pointer page 144 of 178
11:52:38.36 process pointer page 145 of 178
11:52:38.44 process pointer page 146 of 178
11:52:38.52 process pointer page 147 of 178
11:52:38.61 process pointer page 148 of 178
11:52:38.69 process pointer page 149 of 178
11:52:38.77 process pointer page 150 of 178
11:52:38.85 process pointer page 151 of 178
11:52:38.94 process pointer page 152 of 178
11:52:39.02 process pointer page 153 of 178
11:52:39.10 process pointer page 154 of 178
11:52:39.18 process pointer page 155 of 178
11:52:39.27 process pointer page 156 of 178
11:52:39.35 process pointer page 157 of 178
11:52:39.42 process pointer page 158 of 178
11:52:39.50 process pointer page 159 of 178
11:52:39.60 process pointer page 160 of 178
11:52:39.67 process pointer page 161 of 178
11:52:39.75 process pointer page 162 of 178
11:52:39.83 process pointer page 163 of 178
11:52:39.92 process pointer page 164 of 178
11:52:40.00 process pointer page 165 of 178
11:52:40.08 process pointer page 166 of 178
11:52:40.16 process pointer page 167 of 178
11:52:40.24 process pointer page 168 of 178
11:52:40.33 process pointer page 169 of 178
11:52:40.41 process pointer page 170 of 178
11:52:40.47 process pointer page 171 of 178
11:52:40.50 process pointer page 172 of 178
11:52:40.58 process pointer page 173 of 178
11:52:40.66 process pointer page 174 of 178
11:52:40.75 process pointer page 175 of 178
11:52:40.83 process pointer page 176 of 178
11:52:40.91 process pointer page 177 of 178
11:52:40.95 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:52:44.14 Index 2 (PERF_LOG_UNIT)
11:52:50.14 Index 3 (PERF_LOG_TRN_DESC)
11:52:53.25 Index 4 (PERF_LOG_GDSCODE)
11:52:55.66 Relation 163 (PERF_LOG) is ok

11:52:55.66 Relation 167 (V_STOPTEST)
11:52:55.66 Relation 167 (V_STOPTEST) is ok

11:52:55.66 Relation 184 (V_QDISTR_SOURCE)
11:52:55.66 Relation 184 (V_QDISTR_SOURCE) is ok

11:52:55.66 Relation 185 (V_QSTORNED_SOURCE)
11:52:55.66 Relation 185 (V_QSTORNED_SOURCE) is ok

11:52:55.66 Relation 260 (XQD_1000_1200)
11:52:55.66 process pointer page 0 of 1
11:52:55.68 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:52:55.70 Relation 260 (XQD_1000_1200) is ok

11:52:55.70 Relation 261 (XQD_1200_2000)
11:52:55.70 process pointer page 0 of 2
11:52:55.76 process pointer page 1 of 2
11:52:55.79 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:52:55.80 Relation 261 (XQD_1200_2000) is ok

11:52:55.80 Relation 262 (XQD_1000_3300)
11:52:55.80 process pointer page 0 of 8
11:52:55.90 process pointer page 1 of 8
11:52:55.98 process pointer page 2 of 8
11:52:56.07 process pointer page 3 of 8
11:52:56.15 process pointer page 4 of 8
11:52:56.24 process pointer page 5 of 8
11:52:56.32 process pointer page 6 of 8
11:52:56.40 process pointer page 7 of 8
11:52:56.43 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:52:56.73 Index 2 (XQD_1000_3300_DOC)
11:52:56.96 Relation 262 (XQD_1000_3300) is ok

11:52:56.96 Relation 263 (XQD_2000_3300)
11:52:56.96 process pointer page 0 of 19
11:52:57.04 process pointer page 1 of 19
11:52:57.13 process pointer page 2 of 19
11:52:57.21 process pointer page 3 of 19
11:52:57.29 process pointer page 4 of 19
11:52:57.36 process pointer page 5 of 19
11:52:57.44 process pointer page 6 of 19
11:52:57.54 process pointer page 7 of 19
11:52:57.61 process pointer page 8 of 19
11:52:57.69 process pointer page 9 of 19
11:52:57.79 process pointer page 10 of 19
11:52:57.88 process pointer page 11 of 19
11:52:57.96 process pointer page 12 of 19
11:52:58.05 process pointer page 13 of 19
11:52:58.13 process pointer page 14 of 19
11:52:58.22 process pointer page 15 of 19
11:52:58.30 process pointer page 16 of 19
11:52:58.39 process pointer page 17 of 19
11:52:58.47 process pointer page 18 of 19
11:52:58.50 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:52:59.02 Relation 263 (XQD_2000_3300) is ok

11:52:59.02 Relation 264 (XQD_2100_3300)
11:52:59.02 process pointer page 0 of 17
11:52:59.08 process pointer page 1 of 17
11:52:59.16 process pointer page 2 of 17
11:52:59.22 process pointer page 3 of 17
11:52:59.28 process pointer page 4 of 17
11:52:59.35 process pointer page 5 of 17
11:52:59.42 process pointer page 6 of 17
11:52:59.49 process pointer page 7 of 17
11:52:59.55 process pointer page 8 of 17
11:52:59.61 process pointer page 9 of 17
11:52:59.67 process pointer page 10 of 17
11:52:59.74 process pointer page 11 of 17
11:52:59.80 process pointer page 12 of 17
11:52:59.88 process pointer page 13 of 17
11:52:59.94 process pointer page 14 of 17
11:53:00.00 process pointer page 15 of 17
11:53:00.06 process pointer page 16 of 17
11:53:00.08 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:53:00.08 Relation 264 (XQD_2100_3300) is ok

11:53:00.08 Relation 265 (XQD_3300_3400)
11:53:00.08 process pointer page 0 of 25
11:53:00.17 process pointer page 1 of 25
11:53:00.27 process pointer page 2 of 25
11:53:00.36 process pointer page 3 of 25
11:53:00.45 process pointer page 4 of 25
11:53:00.53 process pointer page 5 of 25
11:53:00.63 process pointer page 6 of 25
11:53:00.72 process pointer page 7 of 25
11:53:00.81 process pointer page 8 of 25
11:53:00.91 process pointer page 9 of 25
11:53:01.00 process pointer page 10 of 25
11:53:01.09 process pointer page 11 of 25
11:53:01.19 process pointer page 12 of 25
11:53:01.26 process pointer page 13 of 25
11:53:01.36 process pointer page 14 of 25
11:53:01.47 process pointer page 15 of 25
11:53:01.59 process pointer page 16 of 25
11:53:01.72 process pointer page 17 of 25
11:53:01.83 process pointer page 18 of 25
11:53:01.95 process pointer page 19 of 25
11:53:02.08 process pointer page 20 of 25
11:53:02.19 process pointer page 21 of 25
11:53:02.31 process pointer page 22 of 25
11:53:02.43 process pointer page 23 of 25
11:53:02.54 process pointer page 24 of 25
11:53:02.56 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:53:03.70 Relation 265 (XQD_3300_3400) is ok

11:53:03.70 Relation 266 (XQS_1000_1200)
11:53:03.71 process pointer page 0 of 43
11:53:03.82 process pointer page 1 of 43
11:53:03.95 process pointer page 2 of 43
11:53:04.07 process pointer page 3 of 43
11:53:04.17 process pointer page 4 of 43
11:53:04.24 process pointer page 5 of 43
11:53:04.37 process pointer page 6 of 43
11:53:04.49 process pointer page 7 of 43
11:53:04.60 process pointer page 8 of 43
11:53:04.73 process pointer page 9 of 43
11:53:04.85 process pointer page 10 of 43
11:53:04.98 process pointer page 11 of 43
11:53:05.10 process pointer page 12 of 43
11:53:05.31 process pointer page 13 of 43
11:53:05.54 process pointer page 14 of 43
11:53:05.85 process pointer page 15 of 43
11:53:06.15 process pointer page 16 of 43
11:53:06.43 process pointer page 17 of 43
11:53:06.72 process pointer page 18 of 43
11:53:07.04 process pointer page 19 of 43
11:53:07.33 process pointer page 20 of 43
11:53:07.63 process pointer page 21 of 43
11:53:07.91 process pointer page 22 of 43
11:53:08.21 process pointer page 23 of 43
11:53:08.50 process pointer page 24 of 43
11:53:08.82 process pointer page 25 of 43
11:53:09.11 process pointer page 26 of 43
11:53:09.39 process pointer page 27 of 43
11:53:09.70 process pointer page 28 of 43
11:53:10.03 process pointer page 29 of 43
11:53:10.33 process pointer page 30 of 43
11:53:10.64 process pointer page 31 of 43
11:53:10.97 process pointer page 32 of 43
11:53:11.30 process pointer page 33 of 43
11:53:11.64 process pointer page 34 of 43
11:53:11.97 process pointer page 35 of 43
11:53:12.31 process pointer page 36 of 43
11:53:12.65 process pointer page 37 of 43
11:53:12.98 process pointer page 38 of 43
11:53:13.29 process pointer page 39 of 43
11:53:13.64 process pointer page 40 of 43
11:53:13.98 process pointer page 41 of 43
11:53:14.31 process pointer page 42 of 43
11:53:14.45 Index 1 (XQS_1000_1200_DOC_ID)
11:53:16.41 Index 2 (XQS_1000_1200_SND_ID)
11:53:18.94 Index 3 (XQS_1000_1200_RCV_ID)
11:53:20.91 Relation 266 (XQS_1000_1200) is ok

11:53:20.91 Relation 267 (XQS_1200_2000)
11:53:20.91 process pointer page 0 of 46
11:53:21.34 process pointer page 1 of 46
11:53:21.79 process pointer page 2 of 46
11:53:22.22 process pointer page 3 of 46
11:53:22.65 process pointer page 4 of 46
11:53:23.07 process pointer page 5 of 46
11:53:23.48 process pointer page 6 of 46
11:53:23.92 process pointer page 7 of 46
11:53:24.34 process pointer page 8 of 46
11:53:24.76 process pointer page 9 of 46
11:53:25.21 process pointer page 10 of 46
11:53:25.65 process pointer page 11 of 46
11:53:26.08 process pointer page 12 of 46
11:53:26.51 process pointer page 13 of 46
11:53:26.96 process pointer page 14 of 46
11:53:27.41 process pointer page 15 of 46
11:53:27.86 process pointer page 16 of 46
11:53:28.33 process pointer page 17 of 46
11:53:28.78 process pointer page 18 of 46
11:53:29.25 process pointer page 19 of 46
11:53:29.64 process pointer page 20 of 46
11:53:30.12 process pointer page 21 of 46
11:53:30.55 process pointer page 22 of 46
11:53:31.00 process pointer page 23 of 46
11:53:31.45 process pointer page 24 of 46
11:53:31.90 process pointer page 25 of 46
11:53:32.36 process pointer page 26 of 46
11:53:32.81 process pointer page 27 of 46
11:53:33.26 process pointer page 28 of 46
11:53:33.70 process pointer page 29 of 46
11:53:34.17 process pointer page 30 of 46
11:53:34.57 process pointer page 31 of 46
11:53:35.02 process pointer page 32 of 46
11:53:35.46 process pointer page 33 of 46
11:53:35.91 process pointer page 34 of 46
11:53:36.35 process pointer page 35 of 46
11:53:36.80 process pointer page 36 of 46
11:53:37.24 process pointer page 37 of 46
11:53:37.66 process pointer page 38 of 46
11:53:38.10 process pointer page 39 of 46
11:53:38.52 process pointer page 40 of 46
11:53:38.95 process pointer page 41 of 46
11:53:39.39 process pointer page 42 of 46
11:53:39.83 process pointer page 43 of 46
11:53:40.26 process pointer page 44 of 46
11:53:40.72 process pointer page 45 of 46
11:53:40.80 Index 1 (XQS_1200_2000_DOC_ID)
11:53:43.56 Index 2 (XQS_1200_2000_SND_ID)
11:53:46.52 Index 3 (XQS_1200_2000_RCV_ID)
11:53:48.95 Relation 267 (XQS_1200_2000) is ok

11:53:48.95 Relation 268 (XQS_1000_3300)
11:53:48.95 process pointer page 0 of 25
11:53:49.47 process pointer page 1 of 25
11:53:49.98 process pointer page 2 of 25
11:53:50.48 process pointer page 3 of 25
11:53:50.98 process pointer page 4 of 25
11:53:51.50 process pointer page 5 of 25
11:53:52.00 process pointer page 6 of 25
11:53:52.51 process pointer page 7 of 25
11:53:53.03 process pointer page 8 of 25
11:53:53.49 process pointer page 9 of 25
11:53:53.99 process pointer page 10 of 25
11:53:54.49 process pointer page 11 of 25
11:53:54.99 process pointer page 12 of 25
11:53:55.47 process pointer page 13 of 25
11:53:55.99 process pointer page 14 of 25
11:53:56.47 process pointer page 15 of 25
11:53:56.96 process pointer page 16 of 25
11:53:57.42 process pointer page 17 of 25
11:53:57.89 process pointer page 18 of 25
11:53:58.38 process pointer page 19 of 25
11:53:58.84 process pointer page 20 of 25
11:53:59.31 process pointer page 21 of 25
11:53:59.78 process pointer page 22 of 25
11:54:00.23 process pointer page 23 of 25
11:54:00.69 process pointer page 24 of 25
11:54:00.89 Index 1 (XQS_1000_3300_DOC_ID)
11:54:02.48 Index 2 (XQS_1000_3300_SND_ID)
11:54:04.20 Index 3 (XQS_1000_3300_RCV_ID)
11:54:05.88 Relation 268 (XQS_1000_3300) is ok

11:54:05.88 Relation 269 (XQS_2000_3300)
11:54:05.90 process pointer page 0 of 1
11:54:05.90 Index 1 (XQS_2000_3300_DOC_ID)
11:54:05.90 Index 2 (XQS_2000_3300_SND_ID)
11:54:05.90 Index 3 (XQS_2000_3300_RCV_ID)
11:54:05.90 Relation 269 (XQS_2000_3300) is ok

11:54:05.90 Relation 270 (XQS_2100_3300)
11:54:05.90 process pointer page 0 of 31
11:54:06.38 process pointer page 1 of 31
11:54:06.89 process pointer page 2 of 31
11:54:07.39 process pointer page 3 of 31
11:54:07.92 process pointer page 4 of 31
11:54:08.42 process pointer page 5 of 31
11:54:08.94 process pointer page 6 of 31
11:54:09.44 process pointer page 7 of 31
11:54:09.94 process pointer page 8 of 31
11:54:10.44 process pointer page 9 of 31
11:54:10.93 process pointer page 10 of 31
11:54:11.40 process pointer page 11 of 31
11:54:11.89 process pointer page 12 of 31
11:54:12.37 process pointer page 13 of 31
11:54:12.84 process pointer page 14 of 31
11:54:13.32 process pointer page 15 of 31
11:54:13.84 process pointer page 16 of 31
11:54:14.29 process pointer page 17 of 31
11:54:14.74 process pointer page 18 of 31
11:54:15.19 process pointer page 19 of 31
11:54:15.65 process pointer page 20 of 31
11:54:16.10 process pointer page 21 of 31
11:54:16.55 process pointer page 22 of 31
11:54:17.02 process pointer page 23 of 31
11:54:17.46 process pointer page 24 of 31
11:54:17.95 process pointer page 25 of 31
11:54:18.41 process pointer page 26 of 31
11:54:18.84 process pointer page 27 of 31
11:54:19.28 process pointer page 28 of 31
11:54:19.72 process pointer page 29 of 31
11:54:20.17 process pointer page 30 of 31
11:54:20.51 Index 1 (XQS_2100_3300_DOC_ID)
11:54:22.34 Index 2 (XQS_2100_3300_SND_ID)
11:54:24.27 Index 3 (XQS_2100_3300_RCV_ID)
11:54:26.32 Relation 270 (XQS_2100_3300) is ok

11:54:26.32 Relation 271 (XQS_3300_3400)
11:54:26.32 process pointer page 0 of 6
11:54:26.80 process pointer page 1 of 6
11:54:27.28 process pointer page 2 of 6
11:54:27.77 process pointer page 3 of 6
11:54:28.25 process pointer page 4 of 6
11:54:28.67 process pointer page 5 of 6
11:54:28.72 Index 1 (XQS_3300_3400_DOC_ID)
11:54:29.06 Index 2 (XQS_3300_3400_SND_ID)
11:54:29.42 Relation 271 (XQS_3300_3400) is ok

11:54:29.47 Validation finished
Done for 129200 ms, from 11:52:20.41 to 11:54:29.61.

Differences between old and current firebird.log

11:54:31.06. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-09-13 11:54 477 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

Comparison of old and new firebird.log (get messages that appeared during test):

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Wed Sep 13 11:52:20 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Wed Sep 13 11:54:29 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

Final processing ISQL logs in e:\temp\logs.oltp40

Remove 401 logs of every ISQL session if there were no serious errors.

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_.:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND

ISQL logs are removed because no severe errors occured during test.
2017-09-13 11:54:40.93 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html

Test configuration settings

Performance reports

Differences between old and current firebird.log

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_.: