Firebird 4.0 Performance Logs

ACTION	AVG_TIMES_PER_MINUTE	AVG_ELAPSED_MS	SUCCESSFUL_TIMES_DONE	JOB_BEG	JOB_END
* OVERALL * for 180 minutes:	7001.37	2915	1260247	2017-02-07 08:16	2017-02-07 11:16
customer order: creation	528.00	391	95040	2017-02-07 08:16	2017-02-07 11:16
customer order: refuse	43.24	207	7784	2017-02-07 08:16	2017-02-07 11:16
order to supplier: creation	136.47	1695	24565	2017-02-07 08:16	2017-02-07 11:16
order to supplier: removal	3.27	18397	588	2017-02-07 08:16	2017-02-07 11:16
invoice (draft): creation	135.31	2506	24355	2017-02-07 08:16	2017-02-07 11:16
invoice (draft): removal	48.66	424	8758	2017-02-07 08:16	2017-02-07 11:16
invoice accept: apply	71.46	9409	12863	2017-02-07 08:16	2017-02-07 11:16
invoice accept: cancel	21.68	2699	3903	2017-02-07 08:16	2017-02-07 11:16
customer reserve: creation	3941.27	138	709428	2017-02-07 08:16	2017-02-07 11:16
customer reserve: removal	1350.67	56	243120	2017-02-07 08:16	2017-02-07 11:16
realization accept: apply	246.38	361	44348	2017-02-07 08:16	2017-02-07 11:16
realization accept: cancel	95.17	135	17130	2017-02-07 08:16	2017-02-07 11:16
payment from customer: creation	175.74	944	31634	2017-02-07 08:16	2017-02-07 11:16
payment from customer: removal	16.62	93	2992	2017-02-07 08:16	2017-02-07 11:16
payment to supplier: creation	145.57	539	26203	2017-02-07 08:16	2017-02-07 11:16
payment to supplier: removal	10.22	103	1840	2017-02-07 08:16	2017-02-07 11:16
service: total inventory turnovers	10.87	2585	1956	2017-02-07 08:16	2017-02-07 11:16
service: total monetary turnovers	20.71	49	3728	2017-02-07 08:16	2017-02-07 11:16
service: refresh index statistics	0.07	14645	12	2017-02-07 08:16	2017-02-07 11:16

Done for 121300 ms, from 11:19:14.81 to 11:21:16.11.

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	5658	116039	101839	14200	12.24	08:16:31	08:34:31
interval # 2, overall	2	7223	147475	130009	17466	11.84	08:34:32	08:52:32
interval # 3, overall	3	8067	166157	145207	20950	12.61	08:52:33	09:10:33
interval # 4, overall	4	7660	157321	137871	19450	12.36	09:10:34	09:28:34
interval # 5, overall	5	6917	140995	124511	16484	11.69	09:28:35	09:46:35
interval # 6, overall	6	7224	156840	130026	26814	17.10	09:46:36	10:04:36
interval # 7, overall	7	6548	126965	117857	9108	7.17	10:04:37	10:22:37
interval # 8, overall	8	6318	126719	113721	12998	10.26	10:22:38	10:40:38
interval # 9, overall	9	7220	145162	129959	15203	10.47	10:40:39	10:58:39
interval # 10, overall	10	7180	149096	129247	19849	13.31	10:58:40	11:16:40

Done for 282140 ms, from 11:25:59.61 to 11:30:41.75.

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	4721.27	0.4460	1.4669	1912	100
TEST_TIME	2	4454.30	0.7775	1.2531	1598	100
TEST_TIME	3	4384.64	0.8487	1.1446	1871	100
TEST_TIME	4	4305.28	0.8743	1.1109	1648	100
TEST_TIME	5	4410.04	0.8677	1.1299	2179	100
TEST_TIME	6	4722.34	0.8793	1.0891	1654	100
TEST_TIME	7	4855.28	0.9081	1.0973	2256	100
TEST_TIME	8	4985.63	0.9350	1.0398	2112	100
TEST_TIME	9	4938.07	0.9588	1.0302	1990	100
TEST_TIME	10	4817.23	0.9505	1.0430	1259	100
TEST_TIME	11	4826.03	0.9465	1.0539	1915	100
TEST_TIME	12	4914.10	0.9488	1.0594	1963	100
TEST_TIME	13	5082.14	0.9456	1.0521	1744	100
TEST_TIME	14	5180.53	0.9584	1.0364	1622	100
TEST_TIME	15	5294.75	0.9464	1.0467	2435	100
TEST_TIME	16	5424.27	0.9670	1.0332	2735	100
TEST_TIME	17	5511.53	0.9571	1.0484	2328	54
TEST_TIME	18	5644.75	0.9668	1.0373	2223	22
TEST_TIME	19	5698.70	0.9736	1.0272	1662	99
TEST_TIME	20	5766.24	0.9644	1.0336	2015	100
TEST_TIME	21	5873.85	0.9675	1.0304	2036	100
TEST_TIME	22	5932.13	0.9743	1.0276	2096	100
TEST_TIME	23	5972.52	0.9762	1.0242	1935	100
TEST_TIME	24	6007.98	0.9764	1.0209	1367	100
TEST_TIME	25	6024.24	0.9774	1.0246	1714	100
TEST_TIME	26	6095.71	0.9737	1.0216	1475	100
TEST_TIME	27	6115.04	0.9807	1.0202	1448	100
TEST_TIME	28	6122.65	0.9825	1.0183	1610	100
TEST_TIME	29	6135.26	0.9812	1.0219	1426	100
TEST_TIME	30	6221.66	0.9742	1.0268	2341	100
TEST_TIME	31	6359.09	0.9722	1.0241	2343	100
TEST_TIME	32	6436.70	0.9801	1.0165	2463	100
TEST_TIME	33	6399.73	0.9914	1.0120	1873	93
TEST_TIME	34	6375.29	0.9860	1.0179	1781	90
TEST_TIME	35	6373.36	0.9891	1.0174	1537	63
TEST_TIME	36	6418.80	0.9821	1.0180	1560	18
TEST_TIME	37	6473.86	0.9820	1.0158	1643	25
TEST_TIME	38	6496.14	0.9857	1.0122	1192	19
TEST_TIME	39	6480.80	0.9886	1.0127	1459	99
TEST_TIME	40	6494.43	0.9856	1.0130	1746	100
TEST_TIME	41	6511.47	0.9857	1.0137	1542	100
TEST_TIME	42	6516.87	0.9888	1.0118	1597	100
TEST_TIME	43	6523.07	0.9874	1.0103	1455	100
TEST_TIME	44	6515.49	0.9885	1.0097	1454	100
TEST_TIME	45	6587.84	0.9764	1.0197	2014	100
TEST_TIME	46	6669.68	0.9854	1.0182	2103	100
TEST_TIME	47	6751.16	0.9845	1.0167	2324	100
TEST_TIME	48	6836.22	0.9831	1.0145	1977	100
TEST_TIME	49	6890.88	0.9859	1.0128	2053	100
TEST_TIME	50	6891.44	0.9925	1.0122	1757	100
TEST_TIME	51	6910.32	0.9896	1.0123	1703	100
TEST_TIME	52	6925.74	0.9906	1.0095	1590	100
TEST_TIME	53	6963.15	0.9851	1.0102	1554	100
TEST_TIME	54	6968.91	0.9907	1.0117	1581	100
TEST_TIME	55	6966.01	0.9938	1.0086	1213	100
TEST_TIME	56	6953.39	0.9924	1.0049	1405	100
TEST_TIME	57	6943.97	0.9910	1.0096	1295	100
TEST_TIME	58	6912.85	0.9966	1.0049	1100	98
TEST_TIME	59	6850.31	0.9969	1.0055	1439	96
TEST_TIME	60	6856.29	0.9879	1.0109	1816	100
TEST_TIME	61	6916.17	0.9859	1.0115	1888	100
TEST_TIME	62	6959.26	0.9891	1.0087	1954	100
TEST_TIME	63	6975.96	0.9904	1.0104	2140	100
TEST_TIME	64	7018.86	0.9885	1.0119	1822	100
TEST_TIME	65	7060.89	0.9904	1.0084	1928	100
TEST_TIME	66	7077.08	0.9908	1.0099	1833	100
TEST_TIME	67	7105.51	0.9909	1.0116	1663	100
TEST_TIME	68	7131.09	0.9932	1.0048	1669	100
TEST_TIME	69	7115.14	0.9924	1.0079	1600	100
TEST_TIME	70	7137.45	0.9904	1.0092	1424	100
TEST_TIME	71	7147.28	0.9936	1.0060	1544	100
TEST_TIME	72	7134.79	0.9942	1.0063	1511	100
TEST_TIME	73	7143.70	0.9913	1.0030	1377	100
TEST_TIME	74	7122.30	0.9953	1.0051	1258	98
TEST_TIME	75	7100.71	0.9948	1.0062	2066	98
TEST_TIME	76	7113.33	0.9912	1.0109	2033	75
TEST_TIME	77	7141.55	0.9939	1.0070	2101	48
TEST_TIME	78	7146.65	0.9934	1.0046	1897	87
TEST_TIME	79	7119.52	0.9956	1.0061	2137	97
TEST_TIME	80	7126.85	0.9925	1.0044	2011	95
TEST_TIME	81	7105.51	0.9950	1.0054	1944	93
TEST_TIME	82	7105.33	0.9932	1.0046	1888	95
TEST_TIME	83	7087.73	0.9950	1.0029	1752	93
TEST_TIME	84	7100.29	0.9899	1.0071	1297	100
TEST_TIME	85	7098.32	0.9955	1.0067	1435	100
TEST_TIME	86	7094.46	0.9956	1.0046	1754	100
TEST_TIME	87	7083.29	0.9947	1.0051	1639	100
TEST_TIME	88	7073.44	0.9951	1.0038	1688	100
TEST_TIME	89	7086.57	0.9906	1.0083	1331	100
TEST_TIME	90	7090.90	0.9965	1.0039	1903	98
TEST_TIME	91	7078.48	0.9946	1.0062	2026	89
TEST_TIME	92	7093.32	0.9931	1.0073	1748	100
TEST_TIME	93	7113.76	0.9937	1.0041	2100	99
TEST_TIME	94	7098.90	0.9955	1.0044	1947	85
TEST_TIME	95	7096.25	0.9942	1.0054	1908	70
TEST_TIME	96	7091.82	0.9956	1.0036	1833	61
TEST_TIME	97	7078.69	0.9951	1.0051	1764	55
TEST_TIME	98	7090.22	0.9945	1.0030	1288	68
TEST_TIME	99	7084.46	0.9936	1.0045	1380	100
TEST_TIME	100	7064.59	0.9973	1.0024	1764	97
TEST_TIME	101	7044.88	0.9952	1.0035	1530	96
TEST_TIME	102	7034.98	0.9950	1.0064	1451	99
TEST_TIME	103	7036.21	0.9965	1.0039	1430	100
TEST_TIME	104	7039.47	0.9938	1.0037	1467	100
TEST_TIME	105	7049.49	0.9928	1.0063	2176	100
TEST_TIME	106	7080.66	0.9925	1.0062	2314	100
TEST_TIME	107	7104.44	0.9935	1.0050	2165	100
TEST_TIME	108	7110.33	0.9950	1.0034	2046	99
TEST_TIME	109	7092.03	0.9968	1.0040	1933	89
TEST_TIME	110	7084.84	0.9959	1.0033	2014	91
TEST_TIME	111	7069.25	0.9965	1.0043	1743	91
TEST_TIME	112	7073.07	0.9948	1.0053	1637	94
TEST_TIME	113	7068.41	0.9971	1.0037	1582	95
TEST_TIME	114	7052.94	0.9972	1.0052	1446	96
TEST_TIME	115	7054.69	0.9962	1.0032	1575	97
TEST_TIME	116	7044.15	0.9961	1.0055	1517	97
TEST_TIME	117	7034.62	0.9982	1.0023	1586	98
TEST_TIME	118	7009.93	0.9973	1.0033	1631	90
TEST_TIME	119	6997.95	0.9965	1.0024	1533	90
TEST_TIME	120	6984.14	0.9960	1.0051	1585	99
TEST_TIME	121	6987.27	0.9963	1.0037	2321	97
TEST_TIME	122	7003.21	0.9932	1.0057	1995	99
TEST_TIME	123	7006.97	0.9970	1.0034	2025	93
TEST_TIME	124	7014.00	0.9943	1.0053	1846	99
TEST_TIME	125	7013.98	0.9974	1.0049	1870	100
TEST_TIME	126	7017.46	0.9964	1.0027	2037	99
TEST_TIME	127	6999.81	0.9973	1.0035	1831	96
TEST_TIME	128	7005.68	0.9949	1.0047	1682	92
TEST_TIME	129	7020.94	0.9948	1.0026	1585	98
TEST_TIME	130	7013.63	0.9959	1.0041	1465	100
TEST_TIME	131	7007.57	0.9973	1.0020	1866	100
TEST_TIME	132	6982.65	0.9980	1.0025	1837	91
TEST_TIME	133	6971.18	0.9966	1.0029	1603	90
TEST_TIME	134	6962.02	0.9981	1.0027	1422	98
TEST_TIME	135	6947.73	0.9974	1.0021	1676	99
TEST_TIME	136	6937.32	0.9962	1.0059	2507	95
TEST_TIME	137	6947.69	0.9971	1.0039	2311	89
TEST_TIME	138	6948.12	0.9966	1.0042	2176	87
TEST_TIME	139	6955.46	0.9971	1.0025	2102	97
TEST_TIME	140	6946.25	0.9967	1.0056	1972	100
TEST_TIME	141	6952.95	0.9977	1.0026	2037	99
TEST_TIME	142	6945.74	0.9966	1.0030	1982	86
TEST_TIME	143	6939.25	0.9971	1.0035	1708	83
TEST_TIME	144	6934.02	0.9973	1.0047	1520	90
TEST_TIME	145	6938.86	0.9971	1.0021	1559	99
TEST_TIME	146	6933.84	0.9960	1.0038	1383	100
TEST_TIME	147	6932.38	0.9972	1.0018	1711	100
TEST_TIME	148	6914.04	0.9977	1.0024	1563	93
TEST_TIME	149	6921.28	0.9946	1.0019	1374	100
TEST_TIME	150	6910.28	0.9968	1.0034	2390	96
TEST_TIME	151	6925.13	0.9963	1.0041	2132	100
TEST_TIME	152	6935.45	0.9960	1.0034	2198	98
TEST_TIME	153	6932.23	0.9973	1.0027	2062	90
TEST_TIME	154	6935.76	0.9957	1.0055	1747	91
TEST_TIME	155	6942.89	0.9979	1.0029	1950	92
TEST_TIME	156	6935.85	0.9975	1.0040	1832	91
TEST_TIME	157	6935.94	0.9976	1.0026	1624	98
TEST_TIME	158	6938.60	0.9959	1.0045	1559	100
TEST_TIME	159	6939.41	0.9981	1.0032	1502	100
TEST_TIME	160	6945.19	0.9961	1.0042	1503	100
TEST_TIME	161	6952.46	0.9969	1.0027	1409	100
TEST_TIME	162	6970.55	0.9939	1.0031	1236	100
TEST_TIME	163	6970.53	0.9970	1.0037	1347	100
TEST_TIME	164	6974.56	0.9970	1.0029	1199	100
TEST_TIME	165	6989.09	0.9948	1.0048	1659	100
TEST_TIME	166	7004.19	0.9966	1.0024	2124	100
TEST_TIME	167	7000.03	0.9970	1.0037	1776	98
TEST_TIME	168	7004.47	0.9971	1.0045	1896	100
TEST_TIME	169	7015.16	0.9970	1.0027	1849	100
TEST_TIME	170	7020.12	0.9960	1.0036	1812	99
TEST_TIME	171	7037.46	0.9953	1.0043	1596	100
TEST_TIME	172	7048.72	0.9969	1.0030	1594	100
TEST_TIME	173	7036.88	0.9989	1.0014	1692	98
TEST_TIME	174	7021.37	0.9978	1.0033	1463	98
TEST_TIME	175	7014.44	0.9986	1.0017	1488	93
TEST_TIME	176	7002.43	0.9977	1.0040	1335	94
TEST_TIME	177	7007.44	0.9976	1.0020	1493	98
TEST_TIME	178	6994.87	0.9982	1.0032	1330	98
TEST_TIME	179	7002.02	0.9965	1.0035	1220	100
TEST_TIME	180	6995.85	0.9988	1.0007	741	100

Done for 13400 ms, from 11:30:44.37 to 11:30:57.77.

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	49341	103483	44809	<null>	41748	2546	45559	120279	41011	66273	62099	64597	68189	60380	110662	59336	276532	645532	<null>	08:16:31	08:34:31
fetches per second	2	51692	67930	54590	<null>	48854	145684	89228	<null>	40216	150252	61736	40691	106208	<null>	86567	33625	86417	<null>	<null>	08:34:32	08:52:32
fetches per second	3	62459	80483	67009	<null>	49100	21843	100795	<null>	20798	71001	57534	33515	86372	32514	150828	126654	145121	<null>	<null>	08:52:33	09:10:33
fetches per second	4	52698	51177	48608	74192	39178	<null>	82440	118987	74856	126291	50885	22022	86603	63009	123514	58538	132445	25355	<null>	09:10:34	09:28:34
fetches per second	5	15773	19280	15543	<null>	20802	<null>	36692	<null>	30913	10491	10222	2259	25685	18611	58050	4287	<null>	119377	<null>	09:28:35	09:46:35
fetches per second	6	23462	58150	19900	5134	32222	<null>	62073	<null>	15189	9952	35070	1652	39012	3234	55646	60816	<null>	<null>	<null>	09:46:36	10:04:36
fetches per second	7	4967	2987	6770	3553	8926	<null>	13854	<null>	13681	12891	5411	9841	7643	5565	11546	2944	108499	141937	<null>	10:04:37	10:22:37
fetches per second	8	6872	4919	9672	<null>	9111	<null>	20510	<null>	2403	4224	5568	2258	14562	3459	7773	4021	<null>	108322	<null>	10:22:38	10:40:38
fetches per second	9	13591	16784	16999	24347	17271	1277	16913	16276	11667	55871	23114	45672	34078	19010	16387	28301	50457	57891	<null>	10:40:39	10:58:39
fetches per second	10	31058	39525	35337	<null>	28020	3869	36147	60611	1833	93385	30412	25652	44890	73192	36481	<null>	215472	180871	<null>	10:58:40	11:16:40
marks per second	1	11108	14605	9531	<null>	8648	551	5846	27043	5211	14178	12517	11185	5964	10019	6206	12282	8585	20234	<null>	08:16:31	08:34:31
marks per second	2	11301	9153	11933	<null>	11003	30562	13156	<null>	6911	24275	12457	5989	4751	<null>	7341	5875	13920	<null>	<null>	08:34:32	08:52:32
marks per second	3	13222	10650	14900	<null>	11122	5223	13484	<null>	2828	15762	10864	5172	6560	3428	11670	22071	14301	<null>	<null>	08:52:33	09:10:33
marks per second	4	11299	6854	10341	13312	8571	<null>	11198	19166	8150	18755	8696	3381	6117	10310	9881	9230	13651	3067	<null>	09:10:34	09:28:34
marks per second	5	3542	2720	3017	<null>	3924	<null>	4070	<null>	4237	2323	1778	352	1030	2958	3168	1022	<null>	1160	<null>	09:28:35	09:46:35
marks per second	6	5051	7281	3866	859	6955	<null>	8958	<null>	2047	1548	6061	323	1975	492	3308	11764	<null>	<null>	<null>	09:46:36	10:04:36
marks per second	7	1064	429	792	909	1405	<null>	1714	<null>	1081	2247	908	1278	249	944	896	500	1756	1154	<null>	10:04:37	10:22:37
marks per second	8	1465	622	1143	<null>	1307	<null>	2845	<null>	317	689	1060	365	512	705	936	595	<null>	773	<null>	10:22:38	10:40:38
marks per second	9	2867	2093	3161	4914	3101	237	2573	2658	1520	11775	3759	5027	1084	3368	2127	7084	1591	1998	<null>	10:40:39	10:58:39
marks per second	10	6691	4102	7067	<null>	5260	708	5077	9556	251	15237	5480	3941	1315	12234	6110	<null>	15814	14166	<null>	10:58:40	11:16:40
reads/fetches*100	1	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	08:16:31	08:34:31
reads/fetches*100	2	0	0	0	<null>	0	0	0	<null>	0	0	0	0	0	<null>	0	0	0	<null>	<null>	08:34:32	08:52:32
reads/fetches*100	3	0	0	0	<null>	0	0	0	<null>	0	0	0	0	0	0	0	0	0	<null>	<null>	08:52:33	09:10:33
reads/fetches*100	4	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	<null>	09:10:34	09:28:34
reads/fetches*100	5	0	0	0	<null>	0	<null>	0	<null>	0	0	0	0	0	0	0	0	<null>	0	<null>	09:28:35	09:46:35
reads/fetches*100	6	0	0	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	0	<null>	<null>	<null>	09:46:36	10:04:36
reads/fetches*100	7	0	0	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	10:04:37	10:22:37
reads/fetches*100	8	0	0	0	<null>	0	<null>	0	<null>	0	0	0	0	0	0	0	0	<null>	0	<null>	10:22:38	10:40:38
reads/fetches*100	9	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	10:40:39	10:58:39
reads/fetches*100	10	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	<null>	0	0	<null>	10:58:40	11:16:40
writes/marks*100	1	0	0	0	<null>	0	0	0	0	1	0	0	0	0	0	0	0	3	0	<null>	08:16:31	08:34:31
writes/marks*100	2	0	0	0	<null>	0	0	0	<null>	1	0	0	0	0	<null>	0	0	2	<null>	<null>	08:34:32	08:52:32
writes/marks*100	3	0	0	1	<null>	0	0	0	<null>	1	0	0	0	0	0	0	0	2	<null>	<null>	08:52:33	09:10:33
writes/marks*100	4	0	0	0	0	0	<null>	0	0	1	1	0	0	0	0	0	0	1	0	<null>	09:10:34	09:28:34
writes/marks*100	5	0	0	0	<null>	0	<null>	0	<null>	1	0	0	0	0	0	0	0	<null>	0	<null>	09:28:35	09:46:35
writes/marks*100	6	0	0	0	0	0	<null>	0	<null>	1	0	0	1	0	0	0	0	<null>	<null>	<null>	09:46:36	10:04:36
writes/marks*100	7	0	0	0	0	0	<null>	0	<null>	1	0	0	1	0	0	0	0	3	0	<null>	10:04:37	10:22:37
writes/marks*100	8	0	0	0	<null>	0	<null>	0	<null>	1	1	0	0	0	0	0	0	<null>	1	<null>	10:22:38	10:40:38
writes/marks*100	9	0	0	0	0	0	1	0	0	1	0	0	0	0	2	0	0	1	0	<null>	10:40:39	10:58:39
writes/marks*100	10	0	0	0	<null>	0	0	0	0	2	0	0	1	0	0	0	<null>	0	0	<null>	10:58:40	11:16:40

Done for 10640 ms, from 11:30:59.19 to 11:31:09.83.

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	2189341	2030565	158776	7.25	0	19703	43	158776	2017-02-07 08:16	2017-02-07 11:16
doc_list_biud	2189880	2030565	159315	7.27	0	27160	14	159315	2017-02-07 08:16	2017-02-07 11:16
sp_add_invoice_to_stock	22826	12863	9963	43.64	0	122102	9409	9963	2017-02-07 08:16	2017-02-07 11:16
sp_cancel_adding_invoice	4969	3903	1066	21.45	0	75629	2699	1066	2017-02-07 08:16	2017-02-07 11:16
sp_cancel_client_order	7967	7784	183	2.29	0	4540	207	183	2017-02-07 08:16	2017-02-07 11:16
sp_cancel_customer_reserve	393211	243120	150091	38.17	0	5943	56	150091	2017-02-07 08:16	2017-02-07 11:16
sp_cancel_pay_from_customer	3003	2992	11	0.36	0	1139	93	11	2017-02-07 08:16	2017-02-07 11:16
sp_cancel_pay_to_supplier	1844	1840	4	0.21	0	1450	103	4	2017-02-07 08:16	2017-02-07 11:16
sp_cancel_supplier_invoice	11179	8758	2421	21.65	0	27487	424	2421	2017-02-07 08:16	2017-02-07 11:16
sp_cancel_supplier_order	1845	588	1257	68.13	15	218759	18397	1257	2017-02-07 08:16	2017-02-07 11:16
sp_cancel_write_off	23698	17130	6568	27.71	0	3167	135	6568	2017-02-07 08:16	2017-02-07 11:16
sp_client_order	95040	95040	0	0.00	0	11903	391	0	2017-02-07 08:16	2017-02-07 11:16
sp_customer_reserve	709428	709428	0	0.00	0	11403	138	0	2017-02-07 08:16	2017-02-07 11:16
sp_fill_shopping_cart	144303	143960	343	0.23	0	5133	80	0	2017-02-07 08:16	2017-02-07 11:16
sp_fill_shopping_cart_clo_res	709428	709428	0	0.00	0	4446	11	0	2017-02-07 08:16	2017-02-07 11:16
sp_get_clo_for_invoice	12863	12863	0	0.00	0	5632	291	0	2017-02-07 08:16	2017-02-07 11:16
sp_kill_cost_storno	33058	25865	7193	21.75	0	999	10	7193	2017-02-07 08:16	2017-02-07 11:16
sp_kill_qstorno_ret_qs2qd	820900	512716	308184	37.54	0	27144	20	308184	2017-02-07 08:16	2017-02-07 11:16
sp_kill_qty_storno	497703	338494	159209	31.98	0	27160	60	159209	2017-02-07 08:16	2017-02-07 11:16
sp_lock_selected_doc	93745	80546	13199	14.07	0	1560	6	13199	2017-02-07 08:16	2017-02-07 11:16
sp_make_cost_storno	115048	115048	0	0.00	0	16348	393	0	2017-02-07 08:16	2017-02-07 11:16
sp_multiply_rows_for_pdistr	115048	115048	0	0.00	0	3697	34	0	2017-02-07 08:16	2017-02-07 11:16
sp_multiply_rows_for_qdistr	95040	95040	0	0.00	0	11154	132	0	2017-02-07 08:16	2017-02-07 11:16
sp_pay_from_customer	31634	31634	0	0.00	0	13431	944	0	2017-02-07 08:16	2017-02-07 11:16
sp_pay_to_supplier	26203	26203	0	0.00	0	14337	539	0	2017-02-07 08:16	2017-02-07 11:16
sp_payment_common	57837	57837	0	0.00	0	13307	49	0	2017-02-07 08:16	2017-02-07 11:16
sp_qd_handle_on_cancel_clo	7961	7784	177	2.22	0	4540	89	177	2017-02-07 08:16	2017-02-07 11:16
sp_qd_handle_on_invoice_upd_sts	17598	16766	832	4.72	0	6833	296	832	2017-02-07 08:16	2017-02-07 11:16
sp_qd_handle_on_reserve_upd_sts	44348	44348	0	0.00	0	16972	37	0	2017-02-07 08:16	2017-02-07 11:16
sp_reserve_write_off	44963	44348	615	1.36	0	19765	361	615	2017-02-07 08:16	2017-02-07 11:16
sp_supplier_invoice	24483	24355	128	0.52	0	33353	2506	0	2017-02-07 08:16	2017-02-07 11:16
sp_supplier_order	24780	24565	215	0.86	0	22464	1695	0	2017-02-07 08:16	2017-02-07 11:16
srv_find_qd_qs_mism	1311982	1153195	158787	12.10	0	3556	23	158787	2017-02-07 08:16	2017-02-07 11:16
srv_make_invnt_saldo	1956	1956	0	0.00	15	37814	2585	0	2017-02-07 08:16	2017-02-07 11:16
srv_make_money_saldo	3728	3728	0	0.00	0	2465	49	0	2017-02-07 08:16	2017-02-07 11:16
srv_recalc_idx_stat	12	12	0	0.00	1716	52541	14645	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_add_invoice_to_stock	9963	9963	0	0.00	0	1560	64	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_cancel_adding_invoice	1013	1013	0	0.00	0	2605	143	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_cancel_client_order	183	183	0	0.00	0	1419	89	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_cancel_customer_reserve	52	52	0	0.00	0	577	68	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_cancel_pay_from_customer	11	11	0	0.00	0	359	55	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_cancel_pay_to_supplier	4	4	0	0.00	0	94	51	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_cancel_supplier_invoice	771	771	0	0.00	0	967	53	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_cancel_supplier_order	18119	18119	0	0.00	0	4275	101	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_cancel_write_off	30	30	0	0.00	0	343	67	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_reserve_write_off	615	615	0	0.00	0	1186	61	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_supplier_invoice	128	128	0	0.00	0	951	58	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-abend:sp_supplier_order	215	215	0	0.00	0	468	40	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_add_invoice_to_stock	12863	12863	0	0.00	0	15428	502	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_cancel_adding_invoice	1616	1616	0	0.00	0	9142	590	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_cancel_client_order	7784	7784	0	0.00	0	1404	41	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_cancel_customer_reserve	3032	3032	0	0.00	0	1030	38	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_cancel_pay_from_customer	2992	2992	0	0.00	0	1217	31	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_cancel_pay_to_supplier	1840	1840	0	0.00	0	1497	33	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_cancel_supplier_invoice	1075	1075	0	0.00	0	921	36	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_cancel_supplier_order	588	588	0	0.00	0	24055	1395	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_cancel_write_off	4408	4408	0	0.00	0	1685	39	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_client_order	95040	95040	0	0.00	0	2559	47	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_customer_reserve	4449	4449	0	0.00	0	1404	33	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_pay_from_customer	31634	31634	0	0.00	0	1872	40	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_pay_to_supplier	26203	26203	0	0.00	0	1607	36	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_reserve_write_off	44348	44348	0	0.00	0	2387	42	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_supplier_invoice	24355	24355	0	0.00	0	9875	43	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:sp_supplier_order	24565	24565	0	0.00	0	1529	43	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:srv_make_invnt_saldo	1956	1956	0	0.00	0	905	12	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:srv_make_money_saldo	3728	3728	0	0.00	0	1560	16	0	2017-02-07 08:16	2017-02-07 11:16
t$perf-norm:srv_recalc_idx_stat	12	12	0	0.00	0	640	153	0	2017-02-07 08:16	2017-02-07 11:16
v_add_invoice_to_stock	45652	25726	19926	43.64	0	1263	48	19926	2017-02-07 08:16	2017-02-07 11:16
v_all_customers	142336	142336	0	0.00	0	1108	4	0	2017-02-07 08:16	2017-02-07 11:16
v_all_suppliers	100446	99760	686	0.68	0	780	4	0	2017-02-07 08:16	2017-02-07 11:16
v_all_wares	190080	190080	0	0.00	0	671	4	0	2017-02-07 08:16	2017-02-07 11:16
v_cancel_adding_invoice	3858	3232	626	16.22	0	4821	159	626	2017-02-07 08:16	2017-02-07 11:16
v_cancel_client_order	15934	15568	366	2.29	0	874	5	366	2017-02-07 08:16	2017-02-07 11:16
v_cancel_customer_prepayment	6006	5984	22	0.36	0	593	5	22	2017-02-07 08:16	2017-02-07 11:16
v_cancel_customer_reserve	6168	6064	104	1.68	0	343	6	104	2017-02-07 08:16	2017-02-07 11:16
v_cancel_payment_to_supplier	3688	3680	8	0.21	0	1108	7	8	2017-02-07 08:16	2017-02-07 11:16
v_cancel_supplier_invoice	3692	2150	1542	41.76	0	983	45	1542	2017-02-07 08:16	2017-02-07 11:16
v_cancel_supplier_order	3690	1176	2514	68.13	0	375	6	2514	2017-02-07 08:16	2017-02-07 11:16
v_cancel_write_off	8876	8816	60	0.67	0	2294	102	60	2017-02-07 08:16	2017-02-07 11:16
v_max_id_clo_ord	24780	24565	215	0.86	0	483	5	0	2017-02-07 08:16	2017-02-07 11:16
v_max_id_clo_res	4449	4449	0	0.00	0	1076	13	0	2017-02-07 08:16	2017-02-07 11:16
v_max_id_ord_sup	24483	24355	128	0.52	0	483	4	0	2017-02-07 08:16	2017-02-07 11:16
v_max_non_paid_invoice	25243	25243	0	0.00	0	359	4	0	2017-02-07 08:16	2017-02-07 11:16
v_max_non_paid_realizn	31634	31634	0	0.00	0	608	4	0	2017-02-07 08:16	2017-02-07 11:16
v_min_id_clo_ord	24780	24565	215	0.86	0	1092	5	0	2017-02-07 08:16	2017-02-07 11:16
v_min_id_clo_res	4449	4449	0	0.00	0	1341	7	0	2017-02-07 08:16	2017-02-07 11:16
v_min_id_ord_sup	24483	24355	128	0.52	0	1404	6	0	2017-02-07 08:16	2017-02-07 11:16
v_min_non_paid_invoice	26203	26203	0	0.00	0	873	5	0	2017-02-07 08:16	2017-02-07 11:16
v_min_non_paid_realizn	31634	31634	0	0.00	0	546	4	0	2017-02-07 08:16	2017-02-07 11:16
v_our_firm	47744	47744	0	0.00	0	592	4	0	2017-02-07 08:16	2017-02-07 11:16
v_reserve_write_off	89926	88696	1230	1.36	0	968	6	1230	2017-02-07 08:16	2017-02-07 11:16
x_lock_depdocs_on_canc_invoice	21673	11586	10087	46.54	0	3464	31	10087	2017-02-07 08:16	2017-02-07 11:16
x_lock_depdocs_on_canc_sup_ord	1843	588	1255	68.09	0	983	48	1255	2017-02-07 08:16	2017-02-07 11:16
x_make_qstorno_1000_1200	24780	24565	215	0.86	0	21824	1518	0	2017-02-07 08:16	2017-02-07 11:16
x_make_qstorno_1200_2000	24483	24355	128	0.52	0	32869	2328	0	2017-02-07 08:16	2017-02-07 11:16
x_make_qstorno_2100_3300	709428	709428	0	0.00	0	11388	114	0	2017-02-07 08:16	2017-02-07 11:16

Done for 484070 ms, from 11:39:53.59 to 11:47:57.66.

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	72	sp_kill_cost_storno	335544336	2017-02-07 08:16	2017-02-07 11:16
deadlock	92	sp_kill_qstorno_ret_qs2qd	335544336	2017-02-07 08:20	2017-02-07 11:13
deadlock	3261	sp_lock_selected_doc	335544336	2017-02-07 08:16	2017-02-07 11:16
deadlock	177	sp_qd_handle_on_cancel_clo	335544336	2017-02-07 08:16	2017-02-07 11:15
deadlock	194	sp_qd_handle_on_invoice_upd_sts	335544336	2017-02-07 08:17	2017-02-07 11:16
deadlock	63	x_lock_depdocs_on_canc_invoice	335544336	2017-02-07 08:18	2017-02-07 11:01
deadlock	13	x_lock_depdocs_on_canc_sup_ord	335544336	2017-02-07 08:22	2017-02-07 10:34
user_exc	215	x_make_qstorno_1000_1200	335544517	2017-02-07 08:18	2017-02-07 11:16
user_exc	128	x_make_qstorno_1200_2000	335544517	2017-02-07 08:16	2017-02-07 11:13
concurrent_transaction	8188	sp_lock_selected_doc	335544878	2017-02-07 08:16	2017-02-07 11:16
concurrent_transaction	799	x_lock_depdocs_on_canc_invoice	335544878	2017-02-07 08:16	2017-02-07 11:16
concurrent_transaction	333	x_lock_depdocs_on_canc_sup_ord	335544878	2017-02-07 08:17	2017-02-07 11:16

Done for 14810 ms, from 11:48:11.07 to 11:48:25.88.

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 484493
MON$OLDEST_ACTIVE 484494
MON$OLDEST_SNAPSHOT 484494
MON$NEXT_TRANSACTION 484494
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 951040
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.522 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.522 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.522 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.522 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 13.0

Database statistics, full

Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 484560
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 484495
Oldest active 484496
Oldest snapshot 484496
Next transaction 484497
Sequence number 0
Next attachment ID 9502
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.16, total records: 2351258
Average version length: 47.98, total versions: 4874, 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: 16, data page slots: 25536
Data pages: 25536, average fill: 73%
Primary pages: 25536, secondary pages: 0, swept pages: 15112
Empty pages: 1, full pages: 21402
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 87
60 - 79% = 25437
80 - 99% = 6

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 11667, nodes: 2351258
Average node length: 19.35, total dup: 0, max dup: 0
Average key length: 16.39, compression ratio: 1.65
Average prefix length: 13.61, average data length: 13.39
Clustering factor: 487255, ratio: 0.21
Fill distribution:
0 - 19% = 763
20 - 39% = 2845
40 - 59% = 5463
60 - 79% = 1128
80 - 99% = 1468

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 8435, nodes: 2351258
Average node length: 11.61, total dup: 0, max dup: 0
Average key length: 8.65, compression ratio: 1.04
Average prefix length: 3.34, average data length: 5.66
Clustering factor: 462768, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 4025
40 - 59% = 4308
60 - 79% = 86
80 - 99% = 16

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 178292, depth: 3, leaf buckets: 4235, nodes: 2351258
Average node length: 6.84, total dup: 1706478, max dup: 49
Average key length: 3.88, compression ratio: 2.32
Average prefix length: 7.39, average data length: 1.61
Clustering factor: 444794, ratio: 0.19
Fill distribution:
0 - 19% = 175
20 - 39% = 1473
40 - 59% = 1770
60 - 79% = 267
80 - 99% = 550

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.42, total records: 716774
Average version length: 61.76, total versions: 1532, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 9080
Data pages: 9080, average fill: 75%
Primary pages: 9080, secondary pages: 0, swept pages: 8201
Empty pages: 4, full pages: 8273
Fill distribution:
0 - 19% = 5
20 - 39% = 5
40 - 59% = 36
60 - 79% = 9006
80 - 99% = 28

Index DOC_LIST_ID_DESC (1)
Root page: 252981, depth: 3, leaf buckets: 2663, nodes: 716774
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 174217, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 1480
40 - 59% = 1142
60 - 79% = 39
80 - 99% = 1

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 756, nodes: 716774
Average node length: 4.89, total dup: 716724, max dup: 42822
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 324846, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 634
60 - 79% = 98
80 - 99% = 24

Index PK_DOC_LIST (0)
Root page: 330554, depth: 3, leaf buckets: 2149, nodes: 716774
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 174217, ratio: 0.24
Fill distribution:
0 - 19% = 143
20 - 39% = 687
40 - 59% = 757
60 - 79% = 262
80 - 99% = 300

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: 66.78, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 19.02, total fragments: 390, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.56
Pointer pages: 1, data page slots: 864
Data pages: 36, average fill: 19%
Primary pages: 4, secondary pages: 32, swept pages: 4
Empty pages: 18, full pages: 3
Fill distribution:
0 - 19% = 21
20 - 39% = 11
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

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: 4.20, total records: 8064
Average version length: 71.14, total versions: 7588, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 22.83
Pointer pages: 2, data page slots: 1360
Data pages: 296, average fill: 37%
Primary pages: 295, secondary pages: 1, swept pages: 89
Empty pages: 90, full pages: 62
Fill distribution:
0 - 19% = 126
20 - 39% = 31
40 - 59% = 49
60 - 79% = 51
80 - 99% = 39

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 42, nodes: 8064
Average node length: 14.08, total dup: 835, max dup: 1
Average key length: 11.75, compression ratio: 2.30
Average prefix length: 18.15, average data length: 8.85
Clustering factor: 6142, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 34
40 - 59% = 8
60 - 79% = 0
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: 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: 2.13
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
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_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: 10.34, total records: 500
Average version length: 45.11, total versions: 388, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 6.19
Pointer pages: 1, data page slots: 40
Data pages: 32, average fill: 15%
Primary pages: 30, secondary pages: 2, swept pages: 17
Empty pages: 20, full pages: 3
Fill distribution:
0 - 19% = 25
20 - 39% = 1
40 - 59% = 2
60 - 79% = 2
80 - 99% = 2

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 318764, depth: 2, leaf buckets: 1, nodes: 500
Average node length: 5.05, total dup: 438, max dup: 112
Average key length: 3.82, compression ratio: 4.97
Average prefix length: 17.30, average data length: 1.70
Clustering factor: 224, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 1
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: 20.01, total records: 932880
Average version length: 42.60, total versions: 784, max versions: 13
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.20
Pointer pages: 4, data page slots: 5776
Data pages: 5776, average fill: 74%
Primary pages: 5770, secondary pages: 6, swept pages: 4921
Empty pages: 12, full pages: 5044
Fill distribution:
0 - 19% = 28
20 - 39% = 67
40 - 59% = 149
60 - 79% = 5054
80 - 99% = 478

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 321, nodes: 307297
Average node length: 4.90, total dup: 307248, max dup: 16468
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 42182, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 184
60 - 79% = 109
80 - 99% = 11

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 352, nodes: 307297
Average node length: 5.84, total dup: 277114, max dup: 55
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 47625, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 24
40 - 59% = 147
60 - 79% = 107
80 - 99% = 73

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 343, nodes: 307297
Average node length: 5.84, total dup: 277114, max dup: 55
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 47689, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 19
40 - 59% = 124
60 - 79% = 116
80 - 99% = 84

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 347, nodes: 307297
Average node length: 5.63, total dup: 277114, max dup: 55
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 47739, ratio: 0.16
Fill distribution:
0 - 19% = 3
20 - 39% = 22
40 - 59% = 155
60 - 79% = 109
80 - 99% = 58

PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.95, total records: 316458
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: 2704
Data pages: 2704, average fill: 64%
Primary pages: 2704, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 2703
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2703
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 714621, depth: 2, leaf buckets: 261, nodes: 316458
Average node length: 4.60, total dup: 316277, max dup: 2734
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 41884, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 123
60 - 79% = 63
80 - 99% = 74

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.86, total records: 13273958
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: 194, data page slots: 315144
Data pages: 315144, average fill: 87%
Primary pages: 315144, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 315136
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 1
60 - 79% = 0
80 - 99% = 315136

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 15074, nodes: 13273958
Average node length: 5.72, total dup: 12381112, max dup: 144
Average key length: 2.17, compression ratio: 3.69
Average prefix length: 7.87, average data length: 0.12
Clustering factor: 4604557, ratio: 0.35
Fill distribution:
0 - 19% = 18
20 - 39% = 0
40 - 59% = 8321
60 - 79% = 4481
80 - 99% = 2254

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 13321, nodes: 13273958
Average node length: 4.64, total dup: 13273953, max dup: 12095919
Average key length: 1.09, compression ratio: 0.41
Average prefix length: 0.44, average data length: 0.00
Clustering factor: 400153, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 13289
60 - 79% = 2
80 - 99% = 30

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 16230, nodes: 13273958
Average node length: 5.78, total dup: 12865085, max dup: 38806
Average key length: 2.23, compression ratio: 4.04
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 1047666, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 11911
60 - 79% = 2398
80 - 99% = 1916

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 16305, nodes: 13273958
Average node length: 5.62, total dup: 13247002, max dup: 1774520
Average key length: 2.07, compression ratio: 18.30
Average prefix length: 37.77, average data length: 0.07
Clustering factor: 7285210, ratio: 0.55
Fill distribution:
0 - 19% = 16
20 - 39% = 1
40 - 59% = 14084
60 - 79% = 636
80 - 99% = 1568

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.10, total records: 434694
Average version length: 56.13, total versions: 896, 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: 5192
Data pages: 5192, average fill: 74%
Primary pages: 5192, secondary pages: 0, swept pages: 3592
Empty pages: 1, full pages: 4666
Fill distribution:
0 - 19% = 9
20 - 39% = 3
40 - 59% = 36
60 - 79% = 5142
80 - 99% = 2

Index PSTORNED_RCV_ID (2)
Root page: 733968, depth: 3, leaf buckets: 599, nodes: 434694
Average node length: 6.00, total dup: 361706, max dup: 688
Average key length: 3.22, compression ratio: 2.80
Average prefix length: 7.95, average data length: 1.05
Clustering factor: 52295, ratio: 0.12
Fill distribution:
0 - 19% = 11
20 - 39% = 25
40 - 59% = 401
60 - 79% = 124
80 - 99% = 38

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 474, nodes: 434694
Average node length: 5.59, total dup: 388014, max dup: 151
Average key length: 2.81, compression ratio: 3.21
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 99392, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 219
60 - 79% = 173
80 - 99% = 75

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: 0.00, total versions: 0, max versions: 0
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: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
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_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.65, total records: 3028
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.52
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 69%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 36
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 1
60 - 79% = 36
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: 50.41, total records: 6554
Average version length: 72.16, total versions: 1981, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.70
Pointer pages: 2, data page slots: 1784
Data pages: 432, average fill: 19%
Primary pages: 431, secondary pages: 1, swept pages: 204
Empty pages: 199, full pages: 50
Fill distribution:
0 - 19% = 309
20 - 39% = 35
40 - 59% = 22
60 - 79% = 57
80 - 99% = 9

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 18, nodes: 6554
Average node length: 7.06, total dup: 5676, max dup: 14
Average key length: 4.63, compression ratio: 8.00
Average prefix length: 34.50, average data length: 2.50
Clustering factor: 1074, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 3
60 - 79% = 1
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.92, total records: 1313570
Average version length: 71.97, total versions: 4871, 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: 13, data page slots: 19952
Data pages: 19952, average fill: 72%
Primary pages: 19952, secondary pages: 0, swept pages: 13325
Empty pages: 120, full pages: 14663
Fill distribution:
0 - 19% = 225
20 - 39% = 233
40 - 59% = 1208
60 - 79% = 18241
80 - 99% = 45

Index XQD_1000_3300_DOC (1)
Root page: 533927, depth: 3, leaf buckets: 1506, nodes: 1313570
Average node length: 5.13, total dup: 1279854, max dup: 120
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 144026, ratio: 0.11
Fill distribution:
0 - 19% = 17
20 - 39% = 61
40 - 59% = 1167
60 - 79% = 73
80 - 99% = 188

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 237816, depth: 3, leaf buckets: 1898, nodes: 1313570
Average node length: 6.26, total dup: 1147815, max dup: 15
Average key length: 3.31, compression ratio: 11.18
Average prefix length: 35.82, average data length: 1.18
Clustering factor: 248931, ratio: 0.19
Fill distribution:
0 - 19% = 13
20 - 39% = 159
40 - 59% = 1472
60 - 79% = 155
80 - 99% = 99

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 17.28, total records: 104422
Average version length: 71.95, total versions: 7903, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 7.87
Pointer pages: 4, data page slots: 5680
Data pages: 4592, average fill: 13%
Primary pages: 4590, secondary pages: 2, swept pages: 3771
Empty pages: 1027, full pages: 180
Fill distribution:
0 - 19% = 3721
20 - 39% = 470
40 - 59% = 145
60 - 79% = 148
80 - 99% = 108

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 47, nodes: 22735
Average node length: 6.48, total dup: 19758, max dup: 47
Average key length: 3.81, compression ratio: 9.72
Average prefix length: 35.32, average data length: 1.68
Clustering factor: 2388, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 26
40 - 59% = 18
60 - 79% = 3
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 53.27, total records: 2891996
Average version length: 71.72, total versions: 40596, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.55
Pointer pages: 24, data page slots: 38272
Data pages: 38272, average fill: 67%
Primary pages: 38272, secondary pages: 0, swept pages: 19523
Empty pages: 231, full pages: 29343
Fill distribution:
0 - 19% = 538
20 - 39% = 4561
40 - 59% = 4112
60 - 79% = 26216
80 - 99% = 2845

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 197853, depth: 3, leaf buckets: 3388, nodes: 2072323
Average node length: 5.64, total dup: 1947317, max dup: 49
Average key length: 2.66, compression ratio: 13.91
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 259356, ratio: 0.13
Fill distribution:
0 - 19% = 19
20 - 39% = 1618
40 - 59% = 1370
60 - 79% = 250
80 - 99% = 131

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.06, total records: 4477696
Average version length: 70.06, total versions: 1115, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.01
Pointer pages: 18, data page slots: 28128
Data pages: 28016, average fill: 51%
Primary pages: 28016, secondary pages: 0, swept pages: 10067
Empty pages: 55, full pages: 27019
Fill distribution:
0 - 19% = 226
20 - 39% = 8792
40 - 59% = 6893
60 - 79% = 12006
80 - 99% = 99

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 20, nodes: 5625
Average node length: 9.55, total dup: 4043, max dup: 16
Average key length: 6.55, compression ratio: 5.65
Average prefix length: 32.73, average data length: 4.27
Clustering factor: 1038, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 15
40 - 59% = 4
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.10, total records: 3271739
Average version length: 71.19, total versions: 11818, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.16
Pointer pages: 27, data page slots: 42800
Data pages: 42800, average fill: 76%
Primary pages: 42800, secondary pages: 0, swept pages: 32092
Empty pages: 13, full pages: 37503
Fill distribution:
0 - 19% = 34
20 - 39% = 240
40 - 59% = 1210
60 - 79% = 38966
80 - 99% = 2350

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 6133, nodes: 2841534
Average node length: 6.90, total dup: 2291582, max dup: 14
Average key length: 3.93, compression ratio: 9.42
Average prefix length: 35.26, average data length: 1.74
Clustering factor: 525330, ratio: 0.18
Fill distribution:
0 - 19% = 3
20 - 39% = 3827
40 - 59% = 1895
60 - 79% = 240
80 - 99% = 168

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 84.02, total records: 5229550
Average version length: 84.57, total versions: 2252, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 50, data page slots: 80576
Data pages: 80576, average fill: 80%
Primary pages: 80576, secondary pages: 0, swept pages: 30241
Empty pages: 10, full pages: 79812
Fill distribution:
0 - 19% = 14
20 - 39% = 8
40 - 59% = 55
60 - 79% = 22564
80 - 99% = 57935

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 5354, nodes: 5229550
Average node length: 5.16, total dup: 5110342, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 837469, ratio: 0.16
Fill distribution:
0 - 19% = 22
20 - 39% = 110
40 - 59% = 2329
60 - 79% = 2255
80 - 99% = 638

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 5773, nodes: 5229550
Average node length: 5.69, total dup: 4682163, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 271030, ratio: 0.05
Fill distribution:
0 - 19% = 50
20 - 39% = 171
40 - 59% = 3343
60 - 79% = 360
80 - 99% = 1849

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5955, nodes: 5229550
Average node length: 5.80, total dup: 4575464, max dup: 22
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 897006, ratio: 0.17
Fill distribution:
0 - 19% = 26
20 - 39% = 136
40 - 59% = 2558
60 - 79% = 2376
80 - 99% = 859

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.27, total records: 2615261
Average version length: 83.91, total versions: 9820, 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: 26, data page slots: 41288
Data pages: 41288, average fill: 78%
Primary pages: 41288, secondary pages: 0, swept pages: 30970
Empty pages: 22, full pages: 38117
Fill distribution:
0 - 19% = 61
20 - 39% = 123
40 - 59% = 615
60 - 79% = 18423
80 - 99% = 22066

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2836, nodes: 2615261
Average node length: 5.15, total dup: 2553805, max dup: 166
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 429259, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 80
40 - 59% = 1664
60 - 79% = 863
80 - 99% = 228

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4422, nodes: 2615261
Average node length: 6.25, total dup: 2135143, max dup: 14
Average key length: 3.28, compression ratio: 2.74
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 253047, ratio: 0.10
Fill distribution:
0 - 19% = 122
20 - 39% = 1778
40 - 59% = 1645
60 - 79% = 593
80 - 99% = 284

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3196, nodes: 2615261
Average node length: 5.81, total dup: 2287374, max dup: 30
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 510359, ratio: 0.20
Fill distribution:
0 - 19% = 16
20 - 39% = 63
40 - 59% = 1926
60 - 79% = 891
80 - 99% = 300

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.85, total records: 5568312
Average version length: 85.59, total versions: 20371, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 54, data page slots: 87216
Data pages: 87176, average fill: 79%
Primary pages: 87176, secondary pages: 0, swept pages: 24640
Empty pages: 258, full pages: 82708
Fill distribution:
0 - 19% = 450
20 - 39% = 607
40 - 59% = 1270
60 - 79% = 18002
80 - 99% = 66847

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5856, nodes: 5568312
Average node length: 5.04, total dup: 5535545, max dup: 695
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 858685, ratio: 0.15
Fill distribution:
0 - 19% = 8
20 - 39% = 268
40 - 59% = 3201
60 - 79% = 1772
80 - 99% = 607

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 6841, nodes: 5568312
Average node length: 5.52, total dup: 5138424, max dup: 49
Average key length: 2.53, compression ratio: 3.56
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 316968, ratio: 0.06
Fill distribution:
0 - 19% = 97
20 - 39% = 1700
40 - 59% = 2962
60 - 79% = 742
80 - 99% = 1340

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 6557, nodes: 5568312
Average node length: 5.68, total dup: 4996742, max dup: 81
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 942600, ratio: 0.17
Fill distribution:
0 - 19% = 7
20 - 39% = 239
40 - 59% = 3625
60 - 79% = 1952
80 - 99% = 734

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.59, total records: 3519069
Average version length: 84.23, total versions: 7365, 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: 35, data page slots: 55512
Data pages: 55512, average fill: 78%
Primary pages: 55512, secondary pages: 0, swept pages: 41031
Empty pages: 40, full pages: 51320
Fill distribution:
0 - 19% = 78
20 - 39% = 149
40 - 59% = 778
60 - 79% = 23278
80 - 99% = 31229

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3907, nodes: 3519069
Average node length: 5.03, total dup: 3501763, max dup: 1127
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 724430, ratio: 0.21
Fill distribution:
0 - 19% = 20
20 - 39% = 477
40 - 59% = 2114
60 - 79% = 908
80 - 99% = 388

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 6017, nodes: 3519069
Average node length: 6.27, total dup: 2868503, max dup: 14
Average key length: 3.29, compression ratio: 2.74
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 380763, ratio: 0.11
Fill distribution:
0 - 19% = 189
20 - 39% = 2540
40 - 59% = 2130
60 - 79% = 687
80 - 99% = 471

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4297, nodes: 3519069
Average node length: 5.58, total dup: 3212072, max dup: 83
Average key length: 2.60, compression ratio: 3.46
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 770432, ratio: 0.22
Fill distribution:
0 - 19% = 19
20 - 39% = 502
40 - 59% = 2263
60 - 79% = 1050
80 - 99% = 463

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.44, total records: 683617
Average version length: 69.26, total versions: 1629, 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: 9472
Data pages: 9472, average fill: 77%
Primary pages: 9472, secondary pages: 0, swept pages: 6989
Empty pages: 29, full pages: 9064
Fill distribution:
0 - 19% = 42
20 - 39% = 25
40 - 59% = 70
60 - 79% = 9298
80 - 99% = 37

Index XQS_3300_3400_DOC_ID (0)
Root page: 98623, depth: 3, leaf buckets: 792, nodes: 683617
Average node length: 5.36, total dup: 640882, max dup: 113
Average key length: 2.47, compression ratio: 3.64
Average prefix length: 8.59, average data length: 0.41
Clustering factor: 61388, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 141
40 - 59% = 336
60 - 79% = 220
80 - 99% = 94

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 887, nodes: 683617
Average node length: 5.95, total dup: 581914, max dup: 29
Average key length: 3.07, compression ratio: 2.93
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 66433, ratio: 0.10
Fill distribution:
0 - 19% = 2
20 - 39% = 154
40 - 59% = 389
60 - 79% = 231
80 - 99% = 111

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 193850 ms, from 11:48:26.22 to 11:51:40.07.

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	2351258	4874	0.2072
DOC_LIST	716774	1532	0.2137
DOC_STATES	4	0	0.0000
FB_ERRORS	758	0	0.0000
INVNT_SALDO	400	0	0.0000
INVNT_TURNOVER_LOG	8064	7588	94.0972
MONEY_SALDO	49	0	0.0000
MONEY_TURNOVER_LOG	500	388	77.6000
OPTYPES	9	0	0.0000
PDISTR	932880	784	0.0840
PERF_ESTIMATED	316458	0	0.0000
PERF_LOG	13273958	0	0.0000
PSTORNED	434694	896	0.2061
RULES_FOR_PDISTR	4	0	0.0000
RULES_FOR_QDISTR	7	0	0.0000
SEMAPHORES	4	0	0.0000
SETTINGS	114	0	0.0000
TRACE_STAT	3028	0	0.0000
WARES	400	0	0.0000
WARE_GROUPS	8	0	0.0000
XQD_1000_1200	6554	1981	30.2258
XQD_1000_3300	1313570	4871	0.3708
XQD_1200_2000	104422	7903	7.5683
XQD_2000_3300	2891996	40596	1.4037
XQD_2100_3300	4477696	1115	0.0249
XQD_3300_3400	3271739	11818	0.3612
XQS_1000_1200	5229550	2252	0.0430
XQS_1000_3300	2615261	9820	0.3754
XQS_1200_2000	5568312	20371	0.3658
XQS_2100_3300	3519069	7365	0.2092
XQS_3300_3400	683617	1629	0.2382
Z_USED_VIEWS	29	0	0.0000

Done for 2650 ms, from 11:51:51.14 to 11:51:53.79.

Database validation

11:51:54.06 Validation started

11:51:54.09 Relation 140 (DOC_LIST)
11:51:54.09 process pointer page 0 of 6
11:51:54.20 process pointer page 1 of 6
11:51:54.29 process pointer page 2 of 6
11:51:54.40 process pointer page 3 of 6
11:51:54.50 process pointer page 4 of 6
11:51:54.59 process pointer page 5 of 6
11:51:54.61 Index 1 (PK_DOC_LIST)
11:51:54.73 Index 2 (DOC_LIST_ID_DESC)
11:51:54.87 Index 3 (FK_DOC_LIST_AGENTS)
11:51:55.17 Relation 140 (DOC_LIST) is ok

11:51:55.17 Relation 141 (DOC_DATA)
11:51:55.17 process pointer page 0 of 16
11:51:55.26 process pointer page 1 of 16
11:51:55.35 process pointer page 2 of 16
11:51:55.45 process pointer page 3 of 16
11:51:55.54 process pointer page 4 of 16
11:51:55.64 process pointer page 5 of 16
11:51:55.73 process pointer page 6 of 16
11:51:55.82 process pointer page 7 of 16
11:51:55.92 process pointer page 8 of 16
11:51:56.01 process pointer page 9 of 16
11:51:56.10 process pointer page 10 of 16
11:51:56.20 process pointer page 11 of 16
11:51:56.29 process pointer page 12 of 16
11:51:56.38 process pointer page 13 of 16
11:51:56.48 process pointer page 14 of 16
11:51:56.57 process pointer page 15 of 16
11:51:56.63 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:51:57.84 Index 3 (DOC_DATA_ID_DESC)
11:51:58.66 Index 4 (FK_DOC_DATA_DOC_LIST)
11:51:59.46 Relation 141 (DOC_DATA) is ok

11:51:59.47 Relation 147 (INVNT_SALDO)
11:51:59.47 process pointer page 0 of 1
11:51:59.47 Index 1 (PK_INVNT_SALDO)
11:51:59.47 Relation 147 (INVNT_SALDO) is ok

11:51:59.47 Relation 150 (PDISTR)
11:51:59.47 process pointer page 0 of 4
11:51:59.55 process pointer page 1 of 4
11:51:59.64 process pointer page 2 of 4
11:51:59.69 process pointer page 3 of 4
11:51:59.72 Index 2 (PDISTR_SND_ID)
11:51:59.83 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:51:59.96 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:52:00.07 Index 5 (PDISTR_AGENT_ID)
11:52:00.18 Relation 150 (PDISTR) is ok

11:52:00.18 Relation 151 (PSTORNED)
11:52:00.18 process pointer page 0 of 4
11:52:00.27 process pointer page 1 of 4
11:52:00.36 process pointer page 2 of 4
11:52:00.46 process pointer page 3 of 4
11:52:00.47 Index 2 (PSTORNED_SND_ID)
11:52:00.61 Index 3 (PSTORNED_RCV_ID)
11:52:00.74 Relation 151 (PSTORNED) is ok

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

11:52:00.74 Relation 157 (INVNT_TURNOVER_LOG)
11:52:00.74 process pointer page 0 of 2
11:52:00.77 process pointer page 1 of 2
11:52:00.77 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:52:00.77 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:52:00.77 Relation 160 (PERF_ESTIMATED)
11:52:00.77 process pointer page 0 of 2
11:52:00.86 process pointer page 1 of 2
11:52:00.94 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:52:01.02 Relation 160 (PERF_ESTIMATED) is ok

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

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

11:52:01.03 Relation 163 (PERF_LOG)
11:52:01.03 process pointer page 0 of 194
11:52:01.11 process pointer page 1 of 194
11:52:01.19 process pointer page 2 of 194
11:52:01.24 process pointer page 3 of 194
11:52:01.27 process pointer page 4 of 194
11:52:01.30 process pointer page 5 of 194
11:52:01.35 process pointer page 6 of 194
11:52:01.38 process pointer page 7 of 194
11:52:01.41 process pointer page 8 of 194
11:52:01.47 process pointer page 9 of 194
11:52:01.53 process pointer page 10 of 194
11:52:01.56 process pointer page 11 of 194
11:52:01.59 process pointer page 12 of 194
11:52:01.63 process pointer page 13 of 194
11:52:01.66 process pointer page 14 of 194
11:52:01.74 process pointer page 15 of 194
11:52:01.81 process pointer page 16 of 194
11:52:01.91 process pointer page 17 of 194
11:52:01.98 process pointer page 18 of 194
11:52:02.08 process pointer page 19 of 194
11:52:02.16 process pointer page 20 of 194
11:52:02.23 process pointer page 21 of 194
11:52:02.31 process pointer page 22 of 194
11:52:02.41 process pointer page 23 of 194
11:52:02.48 process pointer page 24 of 194
11:52:02.56 process pointer page 25 of 194
11:52:02.66 process pointer page 26 of 194
11:52:02.73 process pointer page 27 of 194
11:52:02.81 process pointer page 28 of 194
11:52:02.89 process pointer page 29 of 194
11:52:02.98 process pointer page 30 of 194
11:52:03.06 process pointer page 31 of 194
11:52:03.14 process pointer page 32 of 194
11:52:03.23 process pointer page 33 of 194
11:52:03.31 process pointer page 34 of 194
11:52:03.39 process pointer page 35 of 194
11:52:03.47 process pointer page 36 of 194
11:52:03.50 process pointer page 37 of 194
11:52:03.53 process pointer page 38 of 194
11:52:03.56 process pointer page 39 of 194
11:52:03.59 process pointer page 40 of 194
11:52:03.64 process pointer page 41 of 194
11:52:03.72 process pointer page 42 of 194
11:52:03.81 process pointer page 43 of 194
11:52:03.89 process pointer page 44 of 194
11:52:03.97 process pointer page 45 of 194
11:52:04.04 process pointer page 46 of 194
11:52:04.12 process pointer page 47 of 194
11:52:04.22 process pointer page 48 of 194
11:52:04.29 process pointer page 49 of 194
11:52:04.37 process pointer page 50 of 194
11:52:04.47 process pointer page 51 of 194
11:52:04.50 process pointer page 52 of 194
11:52:04.53 process pointer page 53 of 194
11:52:04.61 process pointer page 54 of 194
11:52:04.64 process pointer page 55 of 194
11:52:04.68 process pointer page 56 of 194
11:52:04.71 process pointer page 57 of 194
11:52:04.75 process pointer page 58 of 194
11:52:04.78 process pointer page 59 of 194
11:52:04.86 process pointer page 60 of 194
11:52:04.93 process pointer page 61 of 194
11:52:05.03 process pointer page 62 of 194
11:52:05.10 process pointer page 63 of 194
11:52:05.14 process pointer page 64 of 194
11:52:05.17 process pointer page 65 of 194
11:52:05.20 process pointer page 66 of 194
11:52:05.28 process pointer page 67 of 194
11:52:05.35 process pointer page 68 of 194
11:52:05.45 process pointer page 69 of 194
11:52:05.53 process pointer page 70 of 194
11:52:05.60 process pointer page 71 of 194
11:52:05.68 process pointer page 72 of 194
11:52:05.78 process pointer page 73 of 194
11:52:05.85 process pointer page 74 of 194
11:52:05.93 process pointer page 75 of 194
11:52:06.03 process pointer page 76 of 194
11:52:06.10 process pointer page 77 of 194
11:52:06.18 process pointer page 78 of 194
11:52:06.27 process pointer page 79 of 194
11:52:06.35 process pointer page 80 of 194
11:52:06.43 process pointer page 81 of 194
11:52:06.52 process pointer page 82 of 194
11:52:06.60 process pointer page 83 of 194
11:52:06.68 process pointer page 84 of 194
11:52:06.76 process pointer page 85 of 194
11:52:06.84 process pointer page 86 of 194
11:52:06.93 process pointer page 87 of 194
11:52:07.01 process pointer page 88 of 194
11:52:07.09 process pointer page 89 of 194
11:52:07.16 process pointer page 90 of 194
11:52:07.26 process pointer page 91 of 194
11:52:07.34 process pointer page 92 of 194
11:52:07.43 process pointer page 93 of 194
11:52:07.51 process pointer page 94 of 194
11:52:07.59 process pointer page 95 of 194
11:52:07.68 process pointer page 96 of 194
11:52:07.76 process pointer page 97 of 194
11:52:07.79 process pointer page 98 of 194
11:52:07.85 process pointer page 99 of 194
11:52:07.93 process pointer page 100 of 194
11:52:08.02 process pointer page 101 of 194
11:52:08.10 process pointer page 102 of 194
11:52:08.18 process pointer page 103 of 194
11:52:08.27 process pointer page 104 of 194
11:52:08.35 process pointer page 105 of 194
11:52:08.43 process pointer page 106 of 194
11:52:08.51 process pointer page 107 of 194
11:52:08.58 process pointer page 108 of 194
11:52:08.68 process pointer page 109 of 194
11:52:08.76 process pointer page 110 of 194
11:52:08.83 process pointer page 111 of 194
11:52:08.93 process pointer page 112 of 194
11:52:09.01 process pointer page 113 of 194
11:52:09.08 process pointer page 114 of 194
11:52:09.18 process pointer page 115 of 194
11:52:09.25 process pointer page 116 of 194
11:52:09.33 process pointer page 117 of 194
11:52:09.43 process pointer page 118 of 194
11:52:09.50 process pointer page 119 of 194
11:52:09.58 process pointer page 120 of 194
11:52:09.68 process pointer page 121 of 194
11:52:09.75 process pointer page 122 of 194
11:52:09.83 process pointer page 123 of 194
11:52:09.91 process pointer page 124 of 194
11:52:10.00 process pointer page 125 of 194
11:52:10.08 process pointer page 126 of 194
11:52:10.16 process pointer page 127 of 194
11:52:10.25 process pointer page 128 of 194
11:52:10.33 process pointer page 129 of 194
11:52:10.41 process pointer page 130 of 194
11:52:10.50 process pointer page 131 of 194
11:52:10.58 process pointer page 132 of 194
11:52:10.66 process pointer page 133 of 194
11:52:10.72 process pointer page 134 of 194
11:52:10.75 process pointer page 135 of 194
11:52:10.78 process pointer page 136 of 194
11:52:10.83 process pointer page 137 of 194
11:52:10.86 process pointer page 138 of 194
11:52:10.92 process pointer page 139 of 194
11:52:11.00 process pointer page 140 of 194
11:52:11.08 process pointer page 141 of 194
11:52:11.17 process pointer page 142 of 194
11:52:11.25 process pointer page 143 of 194
11:52:11.33 process pointer page 144 of 194
11:52:11.41 process pointer page 145 of 194
11:52:11.50 process pointer page 146 of 194
11:52:11.58 process pointer page 147 of 194
11:52:11.66 process pointer page 148 of 194
11:52:11.75 process pointer page 149 of 194
11:52:11.81 process pointer page 150 of 194
11:52:11.84 process pointer page 151 of 194
11:52:11.88 process pointer page 152 of 194
11:52:11.91 process pointer page 153 of 194
11:52:11.94 process pointer page 154 of 194
11:52:12.00 process pointer page 155 of 194
11:52:12.09 process pointer page 156 of 194
11:52:12.17 process pointer page 157 of 194
11:52:12.25 process pointer page 158 of 194
11:52:12.34 process pointer page 159 of 194
11:52:12.42 process pointer page 160 of 194
11:52:12.50 process pointer page 161 of 194
11:52:12.58 process pointer page 162 of 194
11:52:12.67 process pointer page 163 of 194
11:52:12.75 process pointer page 164 of 194
11:52:12.83 process pointer page 165 of 194
11:52:12.92 process pointer page 166 of 194
11:52:13.00 process pointer page 167 of 194
11:52:13.08 process pointer page 168 of 194
11:52:13.17 process pointer page 169 of 194
11:52:13.25 process pointer page 170 of 194
11:52:13.33 process pointer page 171 of 194
11:52:13.42 process pointer page 172 of 194
11:52:13.50 process pointer page 173 of 194
11:52:13.58 process pointer page 174 of 194
11:52:13.61 process pointer page 175 of 194
11:52:13.64 process pointer page 176 of 194
11:52:13.67 process pointer page 177 of 194
11:52:13.70 process pointer page 178 of 194
11:52:13.76 process pointer page 179 of 194
11:52:13.86 process pointer page 180 of 194
11:52:13.93 process pointer page 181 of 194
11:52:14.01 process pointer page 182 of 194
11:52:14.09 process pointer page 183 of 194
11:52:14.17 process pointer page 184 of 194
11:52:14.25 process pointer page 185 of 194
11:52:14.34 process pointer page 186 of 194
11:52:14.42 process pointer page 187 of 194
11:52:14.50 process pointer page 188 of 194
11:52:14.59 process pointer page 189 of 194
11:52:14.67 process pointer page 190 of 194
11:52:14.75 process pointer page 191 of 194
11:52:14.82 process pointer page 192 of 194
11:52:14.92 process pointer page 193 of 194
11:52:14.92 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:52:19.25 Index 2 (PERF_LOG_UNIT)
11:52:25.43 Index 3 (PERF_LOG_TRN_DESC)
11:52:28.97 Index 4 (PERF_LOG_GDSCODE)
11:52:31.31 Relation 163 (PERF_LOG) is ok

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

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

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

11:52:31.31 Relation 260 (XQD_1000_1200)
11:52:31.33 process pointer page 0 of 2
11:52:31.33 process pointer page 1 of 2
11:52:31.34 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:52:31.34 Relation 260 (XQD_1000_1200) is ok

11:52:31.34 Relation 261 (XQD_1200_2000)
11:52:31.34 process pointer page 0 of 4
11:52:31.41 process pointer page 1 of 4
11:52:31.45 process pointer page 2 of 4
11:52:31.50 process pointer page 3 of 4
11:52:31.52 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:52:31.53 Relation 261 (XQD_1200_2000) is ok

11:52:31.53 Relation 262 (XQD_1000_3300)
11:52:31.53 process pointer page 0 of 13
11:52:31.63 process pointer page 1 of 13
11:52:31.72 process pointer page 2 of 13
11:52:31.80 process pointer page 3 of 13
11:52:31.89 process pointer page 4 of 13
11:52:31.98 process pointer page 5 of 13
11:52:32.06 process pointer page 6 of 13
11:52:32.17 process pointer page 7 of 13
11:52:32.25 process pointer page 8 of 13
11:52:32.34 process pointer page 9 of 13
11:52:32.39 process pointer page 10 of 13
11:52:32.47 process pointer page 11 of 13
11:52:32.50 process pointer page 12 of 13
11:52:32.50 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:52:32.89 Index 2 (XQD_1000_3300_DOC)
11:52:33.28 Relation 262 (XQD_1000_3300) is ok

11:52:33.28 Relation 263 (XQD_2000_3300)
11:52:33.28 process pointer page 0 of 24
11:52:33.36 process pointer page 1 of 24
11:52:33.42 process pointer page 2 of 24
11:52:33.47 process pointer page 3 of 24
11:52:33.50 process pointer page 4 of 24
11:52:33.56 process pointer page 5 of 24
11:52:33.64 process pointer page 6 of 24
11:52:33.73 process pointer page 7 of 24
11:52:33.82 process pointer page 8 of 24
11:52:33.92 process pointer page 9 of 24
11:52:34.00 process pointer page 10 of 24
11:52:34.09 process pointer page 11 of 24
11:52:34.18 process pointer page 12 of 24
11:52:34.28 process pointer page 13 of 24
11:52:34.37 process pointer page 14 of 24
11:52:34.40 process pointer page 15 of 24
11:52:34.48 process pointer page 16 of 24
11:52:34.57 process pointer page 17 of 24
11:52:34.67 process pointer page 18 of 24
11:52:34.70 process pointer page 19 of 24
11:52:34.73 process pointer page 20 of 24
11:52:34.76 process pointer page 21 of 24
11:52:34.84 process pointer page 22 of 24
11:52:34.93 process pointer page 23 of 24
11:52:34.98 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:52:35.65 Relation 263 (XQD_2000_3300) is ok

11:52:35.65 Relation 264 (XQD_2100_3300)
11:52:35.67 process pointer page 0 of 18
11:52:35.73 process pointer page 1 of 18
11:52:35.81 process pointer page 2 of 18
11:52:35.87 process pointer page 3 of 18
11:52:35.95 process pointer page 4 of 18
11:52:36.01 process pointer page 5 of 18
11:52:36.07 process pointer page 6 of 18
11:52:36.15 process pointer page 7 of 18
11:52:36.18 process pointer page 8 of 18
11:52:36.21 process pointer page 9 of 18
11:52:36.23 process pointer page 10 of 18
11:52:36.26 process pointer page 11 of 18
11:52:36.32 process pointer page 12 of 18
11:52:36.38 process pointer page 13 of 18
11:52:36.46 process pointer page 14 of 18
11:52:36.52 process pointer page 15 of 18
11:52:36.59 process pointer page 16 of 18
11:52:36.65 process pointer page 17 of 18
11:52:36.66 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:52:36.66 Relation 264 (XQD_2100_3300) is ok

11:52:36.66 Relation 265 (XQD_3300_3400)
11:52:36.66 process pointer page 0 of 27
11:52:36.76 process pointer page 1 of 27
11:52:36.85 process pointer page 2 of 27
11:52:36.94 process pointer page 3 of 27
11:52:37.04 process pointer page 4 of 27
11:52:37.13 process pointer page 5 of 27
11:52:37.23 process pointer page 6 of 27
11:52:37.32 process pointer page 7 of 27
11:52:37.41 process pointer page 8 of 27
11:52:37.51 process pointer page 9 of 27
11:52:37.60 process pointer page 10 of 27
11:52:37.69 process pointer page 11 of 27
11:52:37.79 process pointer page 12 of 27
11:52:37.83 process pointer page 13 of 27
11:52:37.88 process pointer page 14 of 27
11:52:37.91 process pointer page 15 of 27
11:52:37.99 process pointer page 16 of 27
11:52:38.08 process pointer page 17 of 27
11:52:38.18 process pointer page 18 of 27
11:52:38.27 process pointer page 19 of 27
11:52:38.36 process pointer page 20 of 27
11:52:38.46 process pointer page 21 of 27
11:52:38.55 process pointer page 22 of 27
11:52:38.65 process pointer page 23 of 27
11:52:38.74 process pointer page 24 of 27
11:52:38.83 process pointer page 25 of 27
11:52:38.94 process pointer page 26 of 27
11:52:38.96 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:52:40.03 Relation 265 (XQD_3300_3400) is ok

11:52:40.03 Relation 266 (XQS_1000_1200)
11:52:40.03 process pointer page 0 of 50
11:52:40.13 process pointer page 1 of 50
11:52:40.22 process pointer page 2 of 50
11:52:40.31 process pointer page 3 of 50
11:52:40.41 process pointer page 4 of 50
11:52:40.50 process pointer page 5 of 50
11:52:40.55 process pointer page 6 of 50
11:52:40.58 process pointer page 7 of 50
11:52:40.61 process pointer page 8 of 50
11:52:40.64 process pointer page 9 of 50
11:52:40.69 process pointer page 10 of 50
11:52:40.72 process pointer page 11 of 50
11:52:40.77 process pointer page 12 of 50
11:52:40.78 process pointer page 13 of 50
11:52:40.84 process pointer page 14 of 50
11:52:40.95 process pointer page 15 of 50
11:52:41.06 process pointer page 16 of 50
11:52:41.16 process pointer page 17 of 50
11:52:41.27 process pointer page 18 of 50
11:52:41.38 process pointer page 19 of 50
11:52:41.48 process pointer page 20 of 50
11:52:41.58 process pointer page 21 of 50
11:52:41.69 process pointer page 22 of 50
11:52:41.80 process pointer page 23 of 50
11:52:41.86 process pointer page 24 of 50
11:52:41.94 process pointer page 25 of 50
11:52:42.19 process pointer page 26 of 50
11:52:42.45 process pointer page 27 of 50
11:52:42.76 process pointer page 28 of 50
11:52:43.04 process pointer page 29 of 50
11:52:43.37 process pointer page 30 of 50
11:52:43.64 process pointer page 31 of 50
11:52:43.96 process pointer page 32 of 50
11:52:44.25 process pointer page 33 of 50
11:52:44.53 process pointer page 34 of 50
11:52:44.84 process pointer page 35 of 50
11:52:45.15 process pointer page 36 of 50
11:52:45.43 process pointer page 37 of 50
11:52:45.76 process pointer page 38 of 50
11:52:46.13 process pointer page 39 of 50
11:52:46.46 process pointer page 40 of 50
11:52:46.80 process pointer page 41 of 50
11:52:47.15 process pointer page 42 of 50
11:52:47.51 process pointer page 43 of 50
11:52:47.85 process pointer page 44 of 50
11:52:48.19 process pointer page 45 of 50
11:52:48.54 process pointer page 46 of 50
11:52:48.86 process pointer page 47 of 50
11:52:49.19 process pointer page 48 of 50
11:52:49.50 process pointer page 49 of 50
11:52:49.61 Index 1 (XQS_1000_1200_DOC_ID)
11:52:52.23 Index 2 (XQS_1000_1200_SND_ID)
11:52:54.85 Index 3 (XQS_1000_1200_RCV_ID)
11:52:56.87 Relation 266 (XQS_1000_1200) is ok

11:52:56.87 Relation 267 (XQS_1200_2000)
11:52:56.87 process pointer page 0 of 54
11:52:57.24 process pointer page 1 of 54
11:52:57.58 process pointer page 2 of 54
11:52:57.99 process pointer page 3 of 54
11:52:58.43 process pointer page 4 of 54
11:52:58.85 process pointer page 5 of 54
11:52:59.27 process pointer page 6 of 54
11:52:59.69 process pointer page 7 of 54
11:53:00.13 process pointer page 8 of 54
11:53:00.55 process pointer page 9 of 54
11:53:00.97 process pointer page 10 of 54
11:53:01.42 process pointer page 11 of 54
11:53:01.86 process pointer page 12 of 54
11:53:02.31 process pointer page 13 of 54
11:53:02.78 process pointer page 14 of 54
11:53:03.26 process pointer page 15 of 54
11:53:03.73 process pointer page 16 of 54
11:53:04.20 process pointer page 17 of 54
11:53:04.68 process pointer page 18 of 54
11:53:05.15 process pointer page 19 of 54
11:53:05.63 process pointer page 20 of 54
11:53:06.10 process pointer page 21 of 54
11:53:06.57 process pointer page 22 of 54
11:53:07.05 process pointer page 23 of 54
11:53:07.54 process pointer page 24 of 54
11:53:08.00 process pointer page 25 of 54
11:53:08.47 process pointer page 26 of 54
11:53:08.91 process pointer page 27 of 54
11:53:09.36 process pointer page 28 of 54
11:53:09.81 process pointer page 29 of 54
11:53:10.27 process pointer page 30 of 54
11:53:10.73 process pointer page 31 of 54
11:53:11.20 process pointer page 32 of 54
11:53:11.67 process pointer page 33 of 54
11:53:12.11 process pointer page 34 of 54
11:53:12.54 process pointer page 35 of 54
11:53:12.98 process pointer page 36 of 54
11:53:13.43 process pointer page 37 of 54
11:53:13.87 process pointer page 38 of 54
11:53:14.32 process pointer page 39 of 54
11:53:14.76 process pointer page 40 of 54
11:53:15.20 process pointer page 41 of 54
11:53:15.66 process pointer page 42 of 54
11:53:16.10 process pointer page 43 of 54
11:53:16.52 process pointer page 44 of 54
11:53:16.97 process pointer page 45 of 54
11:53:17.41 process pointer page 46 of 54
11:53:17.83 process pointer page 47 of 54
11:53:18.25 process pointer page 48 of 54
11:53:18.71 process pointer page 49 of 54
11:53:19.14 process pointer page 50 of 54
11:53:19.61 process pointer page 51 of 54
11:53:20.02 process pointer page 52 of 54
11:53:20.39 process pointer page 53 of 54
11:53:20.55 Index 1 (XQS_1200_2000_DOC_ID)
11:53:23.45 Index 2 (XQS_1200_2000_SND_ID)
11:53:26.49 Index 3 (XQS_1200_2000_RCV_ID)
11:53:29.16 Relation 267 (XQS_1200_2000) is ok

11:53:29.16 Relation 268 (XQS_1000_3300)
11:53:29.16 process pointer page 0 of 26
11:53:29.64 process pointer page 1 of 26
11:53:30.13 process pointer page 2 of 26
11:53:30.61 process pointer page 3 of 26
11:53:31.09 process pointer page 4 of 26
11:53:31.58 process pointer page 5 of 26
11:53:32.06 process pointer page 6 of 26
11:53:32.54 process pointer page 7 of 26
11:53:33.03 process pointer page 8 of 26
11:53:33.49 process pointer page 9 of 26
11:53:33.96 process pointer page 10 of 26
11:53:34.45 process pointer page 11 of 26
11:53:34.93 process pointer page 12 of 26
11:53:35.41 process pointer page 13 of 26
11:53:35.88 process pointer page 14 of 26
11:53:36.35 process pointer page 15 of 26
11:53:36.83 process pointer page 16 of 26
11:53:37.29 process pointer page 17 of 26
11:53:37.74 process pointer page 18 of 26
11:53:38.17 process pointer page 19 of 26
11:53:38.64 process pointer page 20 of 26
11:53:39.08 process pointer page 21 of 26
11:53:39.53 process pointer page 22 of 26
11:53:39.95 process pointer page 23 of 26
11:53:40.37 process pointer page 24 of 26
11:53:40.73 process pointer page 25 of 26
11:53:40.83 Index 1 (XQS_1000_3300_DOC_ID)
11:53:42.29 Index 2 (XQS_1000_3300_SND_ID)
11:53:43.74 Index 3 (XQS_1000_3300_RCV_ID)
11:53:45.55 Relation 268 (XQS_1000_3300) is ok

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

11:53:45.55 Relation 270 (XQS_2100_3300)
11:53:45.55 process pointer page 0 of 35
11:53:46.04 process pointer page 1 of 35
11:53:46.52 process pointer page 2 of 35
11:53:47.00 process pointer page 3 of 35
11:53:47.49 process pointer page 4 of 35
11:53:47.96 process pointer page 5 of 35
11:53:48.46 process pointer page 6 of 35
11:53:48.94 process pointer page 7 of 35
11:53:49.42 process pointer page 8 of 35
11:53:49.91 process pointer page 9 of 35
11:53:50.39 process pointer page 10 of 35
11:53:50.86 process pointer page 11 of 35
11:53:51.33 process pointer page 12 of 35
11:53:51.81 process pointer page 13 of 35
11:53:52.29 process pointer page 14 of 35
11:53:52.78 process pointer page 15 of 35
11:53:53.23 process pointer page 16 of 35
11:53:53.70 process pointer page 17 of 35
11:53:54.16 process pointer page 18 of 35
11:53:54.65 process pointer page 19 of 35
11:53:55.12 process pointer page 20 of 35
11:53:55.58 process pointer page 21 of 35
11:53:56.02 process pointer page 22 of 35
11:53:56.46 process pointer page 23 of 35
11:53:56.91 process pointer page 24 of 35
11:53:57.35 process pointer page 25 of 35
11:53:57.78 process pointer page 26 of 35
11:53:58.22 process pointer page 27 of 35
11:53:58.66 process pointer page 28 of 35
11:53:59.09 process pointer page 29 of 35
11:53:59.52 process pointer page 30 of 35
11:53:59.94 process pointer page 31 of 35
11:54:00.34 process pointer page 32 of 35
11:54:00.76 process pointer page 33 of 35
11:54:01.12 process pointer page 34 of 35
11:54:01.12 Index 1 (XQS_2100_3300_DOC_ID)
11:54:03.34 Index 2 (XQS_2100_3300_SND_ID)
11:54:05.55 Index 3 (XQS_2100_3300_RCV_ID)
11:54:07.85 Relation 270 (XQS_2100_3300) is ok

11:54:07.85 Relation 271 (XQS_3300_3400)
11:54:07.85 process pointer page 0 of 6
11:54:08.33 process pointer page 1 of 6
11:54:08.81 process pointer page 2 of 6
11:54:09.30 process pointer page 3 of 6
11:54:09.80 process pointer page 4 of 6
11:54:10.25 process pointer page 5 of 6
11:54:10.58 Index 1 (XQS_3300_3400_DOC_ID)
11:54:10.97 Index 2 (XQS_3300_3400_SND_ID)
11:54:11.39 Relation 271 (XQS_3300_3400) is ok

11:54:11.42 Validation finished
Done for 137760 ms, from 11:51:53.83 to 11:54:11.59.

Differences between old and current firebird.log

11:54:13.73. 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-02-07 11:54 509 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 Tue Feb 07 11:51:54 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Tue Feb 07 11:54:11 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-02-07 11:54:25.08 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html

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_.: