Firebird 4.0 Performance Logs

ACTION	AVG_TIMES_PER_MINUTE	AVG_ELAPSED_MS	SUCCESSFUL_TIMES_DONE	JOB_BEG	JOB_END
* OVERALL * for 180 minutes:	7433.62	674	1338052	2018-01-07 08:16	2018-01-07 11:16
customer order: creation	456.92	55	82246	2018-01-07 08:16	2018-01-07 11:16
customer order: refuse	37.04	30	6668	2018-01-07 08:16	2018-01-07 11:16
order to supplier: creation	115.27	213	20749	2018-01-07 08:16	2018-01-07 11:16
order to supplier: removal	3.55	4821	632	2018-01-07 08:16	2018-01-07 11:16
invoice (draft): creation	118.58	342	21345	2018-01-07 08:16	2018-01-07 11:16
invoice (draft): removal	55.24	82	9888	2018-01-07 08:16	2018-01-07 11:16
invoice accept: apply	68.93	1277	12407	2018-01-07 08:16	2018-01-07 11:16
invoice accept: cancel	25.36	286	4540	2018-01-07 08:16	2018-01-07 11:16
customer reserve: creation	4197.01	16	755462	2018-01-07 08:16	2018-01-07 11:16
customer reserve: removal	1729.98	8	309666	2018-01-07 08:16	2018-01-07 11:16
realization accept: apply	214.72	56	38650	2018-01-07 08:16	2018-01-07 11:16
realization accept: cancel	96.71	21	17407	2018-01-07 08:16	2018-01-07 11:16
payment from customer: creation	152.28	119	27410	2018-01-07 08:16	2018-01-07 11:16
payment from customer: removal	14.04	16	2513	2018-01-07 08:16	2018-01-07 11:16
payment to supplier: creation	125.06	61	22511	2018-01-07 08:16	2018-01-07 11:16
payment to supplier: removal	9.41	18	1685	2018-01-07 08:16	2018-01-07 11:16
service: total inventory turnovers	12.14	343	2186	2018-01-07 08:16	2018-01-07 11:16
service: total monetary turnovers	11.59	10	2075	2018-01-07 08:16	2018-01-07 11:16
service: refresh index statistics	0.07	5028	12	2018-01-07 08:16	2018-01-07 11:16

Done for 126330 ms, from 11:18:44.14 to 11:20:50.47.

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	5453	113205	98153	15052	13.30	08:16:45	08:34:45
interval # 2, overall	2	7636	160914	137448	23466	14.58	08:34:46	08:52:46
interval # 3, overall	3	7870	166551	141661	24890	14.94	08:52:47	09:10:47
interval # 4, overall	4	7291	157992	131245	26747	16.93	09:10:48	09:28:48
interval # 5, overall	5	6981	157659	125662	31997	20.30	09:28:49	09:46:49
interval # 6, overall	6	7800	171865	140401	31464	18.31	09:46:50	10:04:50
interval # 7, overall	7	8076	183941	145366	38575	20.97	10:04:51	10:22:51
interval # 8, overall	8	7771	169109	139885	29224	17.28	10:22:52	10:40:52
interval # 9, overall	9	8075	166008	145355	20653	12.44	10:40:53	10:58:53
interval # 10, overall	10	7382	159995	132876	27119	16.95	10:58:54	11:16:54

Done for 202490 ms, from 11:24:10.65 to 11:27:33.14.

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	1734.63	0.0443	2.0828	1988	100
TEST_TIME	2	3501.17	0.5169	1.3128	1753	100
TEST_TIME	3	3674.51	0.8339	1.1765	1681	100
TEST_TIME	4	3746.83	0.8690	1.1324	1460	100
TEST_TIME	5	3793.96	0.8948	1.0947	1636	100
TEST_TIME	6	3809.94	0.9085	1.1007	1929	100
TEST_TIME	7	4059.80	0.8854	1.0820	1369	100
TEST_TIME	8	4194.86	0.9162	1.0858	1933	100
TEST_TIME	9	4331.85	0.9346	1.0729	1834	100
TEST_TIME	10	4473.00	0.9351	1.0665	1631	100
TEST_TIME	11	4579.02	0.9471	1.0577	1679	100
TEST_TIME	12	4649.93	0.9548	1.0482	1657	100
TEST_TIME	13	4722.20	0.9543	1.0458	1701	100
TEST_TIME	14	4815.31	0.9523	1.0446	1582	100
TEST_TIME	15	4890.04	0.9600	1.0341	1427	100
TEST_TIME	16	4998.78	0.9483	1.0590	2422	100
TEST_TIME	17	5237.87	0.9513	1.0451	2098	100
TEST_TIME	18	5331.27	0.9698	1.0401	1999	100
TEST_TIME	19	5430.06	0.9675	1.0335	1595	100
TEST_TIME	20	5536.19	0.9631	1.0337	2067	100
TEST_TIME	21	5634.71	0.9683	1.0333	1756	100
TEST_TIME	22	5738.93	0.9684	1.0368	1807	100
TEST_TIME	23	5847.14	0.9733	1.0260	1657	100
TEST_TIME	24	5905.08	0.9736	1.0286	1552	100
TEST_TIME	25	5985.98	0.9741	1.0283	1459	100
TEST_TIME	26	6057.44	0.9771	1.0207	1603	100
TEST_TIME	27	6115.95	0.9735	1.0234	1343	100
TEST_TIME	28	6155.33	0.9809	1.0189	1317	100
TEST_TIME	29	6154.66	0.9839	1.0174	1242	100
TEST_TIME	30	6150.76	0.9841	1.0154	1392	100
TEST_TIME	31	6182.06	0.9776	1.0231	2010	100
TEST_TIME	32	6285.57	0.9749	1.0276	1894	100
TEST_TIME	33	6373.52	0.9827	1.0252	1836	100
TEST_TIME	34	6451.67	0.9830	1.0152	1740	100
TEST_TIME	35	6483.14	0.9814	1.0167	1767	100
TEST_TIME	36	6488.70	0.9876	1.0163	1768	100
TEST_TIME	37	6502.52	0.9867	1.0119	1345	100
TEST_TIME	38	6562.60	0.9763	1.0171	1559	100
TEST_TIME	39	6588.91	0.9871	1.0133	1589	100
TEST_TIME	40	6604.55	0.9856	1.0142	1262	100
TEST_TIME	41	6623.88	0.9866	1.0148	1421	100
TEST_TIME	42	6649.73	0.9868	1.0130	1280	100
TEST_TIME	43	6647.01	0.9903	1.0095	1450	100
TEST_TIME	44	6638.55	0.9878	1.0126	1340	100
TEST_TIME	45	6670.14	0.9854	1.0111	1161	100
TEST_TIME	46	6689.69	0.9862	1.0148	2101	100
TEST_TIME	47	6762.37	0.9825	1.0158	2037	100
TEST_TIME	48	6832.20	0.9844	1.0162	1895	100
TEST_TIME	49	6874.19	0.9894	1.0139	1767	100
TEST_TIME	50	6908.15	0.9887	1.0137	1865	100
TEST_TIME	51	6940.13	0.9892	1.0117	1796	100
TEST_TIME	52	6961.83	0.9892	1.0109	1648	100
TEST_TIME	53	6966.39	0.9912	1.0075	1614	100
TEST_TIME	54	6949.18	0.9913	1.0087	1431	100
TEST_TIME	55	6946.61	0.9909	1.0074	1403	100
TEST_TIME	56	6925.76	0.9924	1.0073	1289	100
TEST_TIME	57	6909.18	0.9920	1.0074	1426	100
TEST_TIME	58	6903.57	0.9909	1.0095	1303	100
TEST_TIME	59	6903.23	0.9928	1.0085	1333	100
TEST_TIME	60	6879.12	0.9951	1.0063	1373	100
TEST_TIME	61	6905.15	0.9861	1.0112	2096	100
TEST_TIME	62	6949.04	0.9886	1.0116	2141	100
TEST_TIME	63	6976.44	0.9916	1.0102	1919	100
TEST_TIME	64	7001.36	0.9908	1.0087	1945	100
TEST_TIME	65	7022.12	0.9902	1.0096	2075	100
TEST_TIME	66	7042.47	0.9914	1.0084	1871	100
TEST_TIME	67	7059.77	0.9910	1.0076	1462	100
TEST_TIME	68	7050.38	0.9944	1.0064	1611	100
TEST_TIME	69	7046.31	0.9924	1.0076	1570	100
TEST_TIME	70	7029.18	0.9956	1.0053	1402	100
TEST_TIME	71	7023.69	0.9919	1.0065	1261	100
TEST_TIME	72	7022.86	0.9927	1.0076	1204	100
TEST_TIME	73	7019.82	0.9943	1.0049	1227	100
TEST_TIME	74	6993.52	0.9951	1.0079	1132	100
TEST_TIME	75	6989.76	0.9950	1.0050	1003	100
TEST_TIME	76	6969.77	0.9946	1.0051	1689	100
TEST_TIME	77	6981.06	0.9905	1.0101	2248	100
TEST_TIME	78	7014.24	0.9924	1.0077	2154	100
TEST_TIME	79	7037.90	0.9916	1.0076	1943	100
TEST_TIME	80	7049.00	0.9934	1.0075	1837	100
TEST_TIME	81	7063.59	0.9930	1.0066	1709	100
TEST_TIME	82	7067.75	0.9938	1.0053	1791	100
TEST_TIME	83	7061.18	0.9941	1.0075	1497	100
TEST_TIME	84	7068.46	0.9945	1.0058	1427	100
TEST_TIME	85	7073.22	0.9933	1.0048	1456	100
TEST_TIME	86	7064.24	0.9943	1.0051	1397	100
TEST_TIME	87	7060.81	0.9941	1.0052	1240	100
TEST_TIME	88	7044.61	0.9961	1.0042	1349	100
TEST_TIME	89	7018.57	0.9967	1.0064	1288	100
TEST_TIME	90	7021.44	0.9948	1.0044	1064	99
TEST_TIME	91	7016.18	0.9941	1.0054	1700	100
TEST_TIME	92	7020.36	0.9939	1.0046	1962	100
TEST_TIME	93	7036.49	0.9916	1.0065	1433	100
TEST_TIME	94	7037.12	0.9958	1.0085	1565	100
TEST_TIME	95	7063.21	0.9943	1.0051	1472	100
TEST_TIME	96	7070.71	0.9935	1.0049	1779	100
TEST_TIME	97	7079.74	0.9933	1.0058	1635	100
TEST_TIME	98	7092.21	0.9938	1.0046	1589	100
TEST_TIME	99	7081.29	0.9960	1.0048	1610	100
TEST_TIME	100	7092.83	0.9932	1.0059	1333	100
TEST_TIME	101	7097.61	0.9952	1.0042	1391	100
TEST_TIME	102	7098.27	0.9943	1.0042	1396	100
TEST_TIME	103	7090.86	0.9955	1.0050	1225	100
TEST_TIME	104	7082.25	0.9965	1.0056	1279	100
TEST_TIME	105	7080.12	0.9963	1.0035	1177	100
TEST_TIME	106	7079.79	0.9941	1.0045	1656	100
TEST_TIME	107	7120.58	0.9894	1.0070	1755	100
TEST_TIME	108	7145.83	0.9943	1.0047	1943	100
TEST_TIME	109	7156.95	0.9940	1.0076	1714	100
TEST_TIME	110	7179.28	0.9954	1.0057	1651	100
TEST_TIME	111	7188.40	0.9954	1.0043	1465	100
TEST_TIME	112	7194.01	0.9946	1.0042	1334	100
TEST_TIME	113	7184.12	0.9967	1.0046	1409	100
TEST_TIME	114	7183.74	0.9959	1.0042	1209	100
TEST_TIME	115	7170.35	0.9973	1.0032	1286	100
TEST_TIME	116	7190.56	0.9917	1.0037	1337	100
TEST_TIME	117	7185.73	0.9958	1.0042	1249	100
TEST_TIME	118	7182.62	0.9961	1.0035	1255	100
TEST_TIME	119	7179.93	0.9954	1.0038	1055	100
TEST_TIME	120	7174.85	0.9961	1.0030	1137	100
TEST_TIME	121	7179.06	0.9942	1.0056	1771	100
TEST_TIME	122	7200.22	0.9945	1.0057	2135	100
TEST_TIME	123	7232.76	0.9931	1.0051	1808	100
TEST_TIME	124	7248.07	0.9949	1.0039	1771	100
TEST_TIME	125	7250.24	0.9956	1.0059	1714	100
TEST_TIME	126	7268.44	0.9954	1.0054	1484	100
TEST_TIME	127	7290.74	0.9944	1.0036	1420	100
TEST_TIME	128	7292.75	0.9955	1.0032	1419	100
TEST_TIME	129	7283.77	0.9967	1.0035	1447	100
TEST_TIME	130	7277.74	0.9966	1.0031	1249	100
TEST_TIME	131	7265.65	0.9971	1.0050	1211	100
TEST_TIME	132	7272.00	0.9965	1.0029	1031	100
TEST_TIME	133	7260.94	0.9969	1.0024	1071	100
TEST_TIME	134	7240.47	0.9978	1.0024	1159	100
TEST_TIME	135	7224.77	0.9971	1.0026	1075	100
TEST_TIME	136	7217.49	0.9962	1.0044	1839	100
TEST_TIME	137	7238.89	0.9941	1.0052	1683	100
TEST_TIME	138	7253.03	0.9960	1.0058	1666	100
TEST_TIME	139	7284.43	0.9943	1.0053	1547	100
TEST_TIME	140	7304.67	0.9953	1.0044	1592	100
TEST_TIME	141	7314.64	0.9959	1.0040	1481	100
TEST_TIME	142	7320.90	0.9961	1.0036	1448	100
TEST_TIME	143	7334.52	0.9948	1.0038	1370	100
TEST_TIME	144	7339.58	0.9961	1.0027	1482	100
TEST_TIME	145	7348.08	0.9947	1.0032	1277	100
TEST_TIME	146	7349.70	0.9961	1.0032	1211	100
TEST_TIME	147	7356.03	0.9955	1.0035	1201	100
TEST_TIME	148	7362.48	0.9958	1.0041	1110	100
TEST_TIME	149	7361.16	0.9975	1.0025	1157	100
TEST_TIME	150	7347.83	0.9976	1.0046	1143	100
TEST_TIME	151	7356.07	0.9969	1.0032	1782	100
TEST_TIME	152	7358.19	0.9963	1.0046	2017	100
TEST_TIME	153	7378.71	0.9952	1.0047	1493	100
TEST_TIME	154	7391.40	0.9965	1.0028	1413	100
TEST_TIME	155	7388.85	0.9967	1.0041	1402	99
TEST_TIME	156	7393.45	0.9971	1.0032	1382	100
TEST_TIME	157	7396.62	0.9965	1.0036	1390	100
TEST_TIME	158	7399.24	0.9969	1.0050	1332	100
TEST_TIME	159	7411.06	0.9971	1.0030	1250	100
TEST_TIME	160	7409.66	0.9969	1.0030	1297	100
TEST_TIME	161	7411.80	0.9965	1.0031	1278	100
TEST_TIME	162	7417.54	0.9962	1.0032	1127	100
TEST_TIME	163	7422.22	0.9965	1.0038	1113	100
TEST_TIME	164	7421.71	0.9978	1.0042	1230	100
TEST_TIME	165	7427.98	0.9972	1.0018	1058	100
TEST_TIME	166	7421.10	0.9966	1.0037	1563	100
TEST_TIME	167	7431.16	0.9964	1.0035	1792	100
TEST_TIME	168	7449.62	0.9950	1.0043	1568	100
TEST_TIME	169	7458.66	0.9972	1.0036	1769	100
TEST_TIME	170	7465.34	0.9969	1.0031	1610	100
TEST_TIME	171	7467.12	0.9970	1.0027	1509	100
TEST_TIME	172	7470.57	0.9964	1.0031	1371	100
TEST_TIME	173	7466.38	0.9978	1.0030	1282	100
TEST_TIME	174	7461.24	0.9979	1.0021	1278	100
TEST_TIME	175	7459.17	0.9967	1.0029	1096	100
TEST_TIME	176	7456.73	0.9976	1.0025	1064	100
TEST_TIME	177	7454.23	0.9972	1.0024	1003	100
TEST_TIME	178	7447.36	0.9977	1.0015	1107	100
TEST_TIME	179	7439.17	0.9970	1.0026	1023	100
TEST_TIME	180	7426.82	0.9987	1.0009	785	100

Done for 9100 ms, from 11:27:34.38 to 11:27:43.48.

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	89874	111067	65510	154040	71180	22790	93817	86783	135150	30534	95303	75810	96296	74989	163043	74144	112096	408600	<null>	08:16:45	08:34:45
fetches per second	2	71837	153121	65513	<null>	54766	<null>	96806	54034	93574	<null>	79468	61579	94220	71086	181067	<null>	129118	<null>	<null>	08:34:46	08:52:46
fetches per second	3	81590	126538	77669	<null>	69046	15600	107258	119065	19220	91632	100876	92608	106371	65432	125108	138833	270431	501306	<null>	08:52:47	09:10:47
fetches per second	4	84031	103961	67790	89811	80378	<null>	110404	121261	70919	65909	97420	54113	129553	141500	186757	112666	67901	84300	<null>	09:10:48	09:28:48
fetches per second	5	77470	119393	64803	<null>	79770	<null>	78763	<null>	66529	70193	97605	67832	128826	113666	159671	<null>	157013	996900	<null>	09:28:49	09:46:49
fetches per second	6	78415	172802	70258	<null>	73972	84078	86799	<null>	38833	60526	101149	37225	135857	247300	129515	40105	178118	1389000	<null>	09:46:50	10:04:50
fetches per second	7	71298	113178	78065	122356	76014	<null>	126155	100983	27276	78607	92019	<null>	139899	126279	103066	<null>	235787	677250	<null>	10:04:51	10:22:51
fetches per second	8	74088	92291	58175	102141	67521	53493	87156	101246	16446	82406	85083	50835	120341	124533	105942	34293	203626	1427000	<null>	10:22:52	10:40:52
fetches per second	9	76265	116518	87869	99997	63642	38366	91641	33397	113702	92927	86687	44500	121927	145800	106273	117638	140005	109615	<null>	10:40:53	10:58:53
fetches per second	10	60420	117227	43688	88582	60522	166466	85988	<null>	84714	60705	66924	<null>	107266	133291	82594	<null>	<null>	<null>	<null>	10:58:54	11:16:54
marks per second	1	20230	13857	14890	36851	16190	4285	13705	19113	17902	5228	18306	13828	8180	10152	11323	14852	12952	38120	<null>	08:16:45	08:34:45
marks per second	2	15804	20586	14573	<null>	12377	<null>	13689	10105	11838	<null>	13396	10568	9957	15722	16442	<null>	22624	<null>	<null>	08:34:46	08:52:46
marks per second	3	17674	16246	17380	<null>	15781	4096	14123	20736	2931	16492	16768	13172	8140	13015	9395	24666	17806	43403	<null>	08:52:47	09:10:47
marks per second	4	18355	13324	15327	23997	18111	<null>	15140	23762	9880	10690	13397	8896	6519	29833	10680	19527	9668	5300	<null>	09:10:48	09:28:48
marks per second	5	16534	16761	14816	<null>	17794	<null>	11389	<null>	8416	12700	11937	12218	4757	18833	14853	<null>	13021	72950	<null>	09:28:49	09:46:49
marks per second	6	17002	21533	14561	<null>	16049	18066	12645	<null>	5666	11675	11919	5586	4739	53233	15174	6368	21305	145000	<null>	09:46:50	10:04:50
marks per second	7	15170	14488	16694	22285	16644	<null>	16201	16732	3848	14447	14744	<null>	4849	19043	16912	<null>	29240	31000	<null>	10:04:51	10:22:51
marks per second	8	16082	14060	12678	20446	15214	11425	11711	16940	2464	12647	13654	7602	3543	14755	20340	5558	25825	155000	<null>	10:22:52	10:40:52
marks per second	9	16395	15379	19357	18935	13896	8377	13132	6005	15332	15885	12803	6863	3368	22000	18335	21507	20528	6461	<null>	10:40:53	10:58:53
marks per second	10	12829	13235	9300	15852	12878	40561	11924	<null>	12142	9764	12491	<null>	2901	22283	13811	<null>	<null>	<null>	<null>	10:58:54	11:16:54
reads/fetches*100	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	<null>	08:16:45	08:34:45
reads/fetches*100	2	0	0	0	<null>	0	<null>	0	0	0	<null>	0	0	0	0	0	<null>	0	<null>	<null>	08:34:46	08:52:46
reads/fetches*100	3	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	08:52:47	09:10:47
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:48	09:28:48
reads/fetches*100	5	0	0	0	<null>	0	<null>	0	<null>	0	0	0	0	0	0	0	<null>	0	0	<null>	09:28:49	09:46:49
reads/fetches*100	6	0	0	0	<null>	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	09:46:50	10:04:50
reads/fetches*100	7	0	0	0	0	0	<null>	0	0	0	0	0	<null>	0	0	0	<null>	0	0	<null>	10:04:51	10:22:51
reads/fetches*100	8	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	10:22:52	10:40:52
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:53	10:58:53
reads/fetches*100	10	0	0	0	0	0	0	0	<null>	0	0	0	<null>	0	0	0	<null>	<null>	<null>	<null>	10:58:54	11:16:54
writes/marks*100	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	2	4	0	<null>	08:16:45	08:34:45
writes/marks*100	2	0	0	1	<null>	0	<null>	0	0	1	<null>	0	0	0	0	0	<null>	2	<null>	<null>	08:34:46	08:52:46
writes/marks*100	3	0	0	0	<null>	0	0	0	0	1	0	0	0	0	0	0	0	2	0	<null>	08:52:47	09:10:47
writes/marks*100	4	0	0	0	0	0	<null>	0	0	1	1	0	0	0	0	0	0	3	0	<null>	09:10:48	09:28:48
writes/marks*100	5	0	0	0	<null>	0	<null>	0	<null>	1	1	0	0	0	0	0	<null>	1	0	<null>	09:28:49	09:46:49
writes/marks*100	6	0	0	0	<null>	0	0	0	<null>	0	0	0	0	0	0	0	0	2	0	<null>	09:46:50	10:04:50
writes/marks*100	7	0	1	0	0	0	<null>	0	0	0	0	0	<null>	0	0	0	<null>	1	0	<null>	10:04:51	10:22:51
writes/marks*100	8	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	2	0	<null>	10:22:52	10:40:52
writes/marks*100	9	0	0	0	0	0	0	0	0	1	0	0	0	0	3	0	0	1	0	<null>	10:40:53	10:58:53
writes/marks*100	10	0	0	0	0	0	0	0	<null>	1	1	0	<null>	0	0	0	<null>	<null>	<null>	<null>	10:58:54	11:16:54

Done for 9170 ms, from 11:27:44.34 to 11:27:53.51.

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	2392836	2134167	258669	10.81	0	6537	4	258669	2018-01-07 08:16	2018-01-07 11:16
doc_list_biud	2393344	2134167	259177	10.82	0	4118	2	259177	2018-01-07 08:16	2018-01-07 11:16
sp_add_invoice_to_stock	19869	12407	7462	37.55	0	30311	1277	7462	2018-01-07 08:16	2018-01-07 11:16
sp_cancel_adding_invoice	6120	4540	1580	25.81	0	19203	286	1580	2018-01-07 08:16	2018-01-07 11:16
sp_cancel_client_order	6824	6668	156	2.28	0	2106	30	156	2018-01-07 08:16	2018-01-07 11:16
sp_cancel_customer_reserve	554295	309666	244629	44.13	0	1826	8	244629	2018-01-07 08:16	2018-01-07 11:16
sp_cancel_pay_from_customer	2525	2513	12	0.47	0	1388	16	12	2018-01-07 08:16	2018-01-07 11:16
sp_cancel_pay_to_supplier	1686	1685	1	0.05	0	718	18	1	2018-01-07 08:16	2018-01-07 11:16
sp_cancel_supplier_invoice	13041	9888	3153	24.17	0	2418	82	3153	2018-01-07 08:16	2018-01-07 11:16
sp_cancel_supplier_order	1595	632	963	60.37	0	44631	4821	963	2018-01-07 08:16	2018-01-07 11:16
sp_cancel_write_off	27800	17407	10393	37.38	0	2543	21	10393	2018-01-07 08:16	2018-01-07 11:16
sp_client_order	82246	82246	0	0.00	0	4508	55	0	2018-01-07 08:16	2018-01-07 11:16
sp_customer_reserve	755462	755462	0	0.00	0	3993	16	0	2018-01-07 08:16	2018-01-07 11:16
sp_fill_shopping_cart	124693	124340	353	0.28	0	1794	13	0	2018-01-07 08:16	2018-01-07 11:16
sp_fill_shopping_cart_clo_res	755462	755462	0	0.00	0	889	0	0	2018-01-07 08:16	2018-01-07 11:16
sp_get_clo_for_invoice	12407	12407	0	0.00	0	2995	46	0	2018-01-07 08:16	2018-01-07 11:16
sp_kill_cost_storno	37728	26145	11583	30.70	0	1030	2	11583	2018-01-07 08:16	2018-01-07 11:16
sp_kill_qstorno_ret_qs2qd	1149297	647259	502038	43.68	0	2200	3	502038	2018-01-07 08:16	2018-01-07 11:16
sp_kill_qty_storno	658958	399858	259100	39.31	0	4118	9	259100	2018-01-07 08:16	2018-01-07 11:16
sp_lock_selected_doc	81355	71403	9952	12.23	0	640	1	9952	2018-01-07 08:16	2018-01-07 11:16
sp_make_cost_storno	100978	100978	0	0.00	0	6521	43	0	2018-01-07 08:16	2018-01-07 11:16
sp_multiply_rows_for_pdistr	100978	100978	0	0.00	0	1654	5	0	2018-01-07 08:16	2018-01-07 11:16
sp_multiply_rows_for_qdistr	82246	82246	0	0.00	0	3369	18	0	2018-01-07 08:16	2018-01-07 11:16
sp_pay_from_customer	27410	27410	0	0.00	0	6084	119	0	2018-01-07 08:16	2018-01-07 11:16
sp_pay_to_supplier	22511	22511	0	0.00	0	3853	61	0	2018-01-07 08:16	2018-01-07 11:16
sp_payment_common	49921	49921	0	0.00	0	1606	12	0	2018-01-07 08:16	2018-01-07 11:16
sp_qd_handle_on_cancel_clo	6824	6668	156	2.28	0	1981	12	156	2018-01-07 08:16	2018-01-07 11:16
sp_qd_handle_on_invoice_upd_sts	18371	16947	1424	7.75	0	2434	51	1424	2018-01-07 08:16	2018-01-07 11:16
sp_qd_handle_on_reserve_upd_sts	38650	38650	0	0.00	0	4118	7	0	2018-01-07 08:16	2018-01-07 11:16
sp_reserve_write_off	39135	38650	485	1.23	0	6568	56	485	2018-01-07 08:16	2018-01-07 11:16
sp_supplier_invoice	21453	21345	108	0.50	0	16458	342	0	2018-01-07 08:16	2018-01-07 11:16
sp_supplier_order	20994	20749	245	1.16	0	8861	213	0	2018-01-07 08:16	2018-01-07 11:16
srv_find_qd_qs_mism	1498617	1239953	258664	17.26	0	2808	2	258664	2018-01-07 08:16	2018-01-07 11:16
srv_make_invnt_saldo	2186	2186	0	0.00	0	11419	343	0	2018-01-07 08:16	2018-01-07 11:16
srv_make_money_saldo	2075	2075	0	0.00	0	561	10	0	2018-01-07 08:16	2018-01-07 11:16
srv_recalc_idx_stat	12	12	0	0.00	2169	12184	5028	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_add_invoice_to_stock	7462	7462	0	0.00	0	1061	8	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_cancel_adding_invoice	680	680	0	0.00	0	671	23	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_cancel_client_order	156	156	0	0.00	0	156	6	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_cancel_customer_reserve	42	42	0	0.00	0	16	1	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_cancel_pay_from_customer	12	12	0	0.00	0	63	11	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_cancel_pay_to_supplier	1	1	0	0.00	16	16	16	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_cancel_supplier_invoice	601	601	0	0.00	0	343	4	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_cancel_supplier_order	29182	29182	0	0.00	0	968	23	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_cancel_write_off	16	16	0	0.00	0	16	3	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_reserve_write_off	485	485	0	0.00	0	1014	9	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_supplier_invoice	108	108	0	0.00	0	62	3	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-abend:sp_supplier_order	245	245	0	0.00	0	421	7	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_add_invoice_to_stock	12407	12407	0	0.00	0	6396	136	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_cancel_adding_invoice	1442	1442	0	0.00	0	2278	116	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_cancel_client_order	6668	6668	0	0.00	0	1654	7	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_cancel_customer_reserve	2560	2560	0	0.00	0	2013	8	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_cancel_pay_from_customer	2513	2513	0	0.00	0	812	5	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_cancel_pay_to_supplier	1685	1685	0	0.00	0	843	7	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_cancel_supplier_invoice	1029	1029	0	0.00	0	826	5	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_cancel_supplier_order	632	632	0	0.00	0	7535	708	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_cancel_write_off	3817	3817	0	0.00	0	1592	8	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_client_order	82246	82246	0	0.00	0	2496	8	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_customer_reserve	3753	3753	0	0.00	0	484	4	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_pay_from_customer	27410	27410	0	0.00	0	1826	6	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_pay_to_supplier	22511	22511	0	0.00	0	1779	6	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_reserve_write_off	38650	38650	0	0.00	0	1997	8	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_supplier_invoice	21345	21345	0	0.00	0	2418	5	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:sp_supplier_order	20749	20749	0	0.00	0	1778	6	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:srv_make_invnt_saldo	2186	2186	0	0.00	0	359	1	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:srv_make_money_saldo	2075	2075	0	0.00	0	405	2	0	2018-01-07 08:16	2018-01-07 11:16
t$perf-norm:srv_recalc_idx_stat	12	12	0	0.00	0	78	22	0	2018-01-07 08:16	2018-01-07 11:16
v_add_invoice_to_stock	39738	24814	14924	37.55	0	890	5	14924	2018-01-07 08:16	2018-01-07 11:16
v_all_customers	123360	123360	0	0.00	0	499	1	0	2018-01-07 08:16	2018-01-07 11:16
v_all_suppliers	85392	84686	706	0.82	0	1092	1	0	2018-01-07 08:16	2018-01-07 11:16
v_all_wares	164492	164492	0	0.00	0	1045	0	0	2018-01-07 08:16	2018-01-07 11:16
v_cancel_adding_invoice	3312	2884	428	12.92	0	1903	19	428	2018-01-07 08:16	2018-01-07 11:16
v_cancel_client_order	13648	13336	312	2.28	0	562	1	312	2018-01-07 08:16	2018-01-07 11:16
v_cancel_customer_prepayment	5050	5026	24	0.47	0	218	1	24	2018-01-07 08:16	2018-01-07 11:16
v_cancel_customer_reserve	5204	5120	84	1.61	0	905	2	84	2018-01-07 08:16	2018-01-07 11:16
v_cancel_payment_to_supplier	3372	3370	2	0.05	0	561	2	2	2018-01-07 08:16	2018-01-07 11:16
v_cancel_supplier_invoice	3260	2058	1202	36.87	0	468	4	1202	2018-01-07 08:16	2018-01-07 11:16
v_cancel_supplier_order	3190	1264	1926	60.37	0	234	1	1926	2018-01-07 08:16	2018-01-07 11:16
v_cancel_write_off	7666	7634	32	0.41	0	1576	15	32	2018-01-07 08:16	2018-01-07 11:16
v_max_id_clo_ord	20994	20749	245	1.16	0	640	1	0	2018-01-07 08:16	2018-01-07 11:16
v_max_id_clo_res	3753	3753	0	0.00	0	328	3	0	2018-01-07 08:16	2018-01-07 11:16
v_max_id_ord_sup	21453	21345	108	0.50	0	796	1	0	2018-01-07 08:16	2018-01-07 11:16
v_max_non_paid_invoice	22262	22262	0	0.00	0	328	1	0	2018-01-07 08:16	2018-01-07 11:16
v_max_non_paid_realizn	27410	27410	0	0.00	0	343	1	0	2018-01-07 08:16	2018-01-07 11:16
v_min_id_clo_ord	20994	20749	245	1.16	0	421	1	0	2018-01-07 08:16	2018-01-07 11:16
v_min_id_clo_res	3753	3753	0	0.00	0	327	2	0	2018-01-07 08:16	2018-01-07 11:16
v_min_id_ord_sup	21453	21345	108	0.50	0	1092	1	0	2018-01-07 08:16	2018-01-07 11:16
v_min_non_paid_invoice	22511	22511	0	0.00	0	437	1	0	2018-01-07 08:16	2018-01-07 11:16
v_min_non_paid_realizn	27410	27410	0	0.00	0	327	1	0	2018-01-07 08:16	2018-01-07 11:16
v_our_firm	41132	41132	0	0.00	0	343	1	0	2018-01-07 08:16	2018-01-07 11:16
v_reserve_write_off	78270	77300	970	1.23	0	858	1	970	2018-01-07 08:16	2018-01-07 11:16
x_lock_depdocs_on_canc_invoice	25270	13399	11871	46.97	0	765	5	11871	2018-01-07 08:16	2018-01-07 11:16
x_lock_depdocs_on_canc_sup_ord	1595	632	963	60.37	0	749	8	963	2018-01-07 08:16	2018-01-07 11:16
x_make_qstorno_1000_1200	20994	20749	245	1.16	0	8190	181	0	2018-01-07 08:16	2018-01-07 11:16
x_make_qstorno_1200_2000	21453	21345	108	0.50	0	16161	309	0	2018-01-07 08:16	2018-01-07 11:16
x_make_qstorno_2100_3300	755462	755462	0	0.00	0	3993	14	0	2018-01-07 08:16	2018-01-07 11:16

Done for 368670 ms, from 11:34:13.42 to 11:40:22.09.

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	77	sp_kill_cost_storno	335544336	2018-01-07 08:17	2018-01-07 11:10
deadlock	91	sp_kill_qstorno_ret_qs2qd	335544336	2018-01-07 08:17	2018-01-07 11:16
deadlock	8612	sp_lock_selected_doc	335544336	2018-01-07 08:17	2018-01-07 11:16
deadlock	156	sp_qd_handle_on_cancel_clo	335544336	2018-01-07 08:17	2018-01-07 11:16
deadlock	219	sp_qd_handle_on_invoice_upd_sts	335544336	2018-01-07 08:17	2018-01-07 11:16
deadlock	596	x_lock_depdocs_on_canc_invoice	335544336	2018-01-07 08:17	2018-01-07 11:16
deadlock	196	x_lock_depdocs_on_canc_sup_ord	335544336	2018-01-07 08:18	2018-01-07 11:14
user_exc	245	x_make_qstorno_1000_1200	335544517	2018-01-07 08:17	2018-01-07 11:15
user_exc	108	x_make_qstorno_1200_2000	335544517	2018-01-07 08:17	2018-01-07 11:10

Done for 13850 ms, from 11:40:34.34 to 11:40:48.19.

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 449355
MON$OLDEST_ACTIVE 449356
MON$OLDEST_SNAPSHOT 449356
MON$NEXT_TRANSACTION 449356
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 934656
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.840 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.840 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.840 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.840 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0

Database statistics, full

Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Gstat execution time Sun Jan 07 11:40:48 2018

Database header page information:
Flags 0
Generation 449383
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 449357
Oldest active 449358
Oldest snapshot 449358
Next transaction 449359
Sequence number 0
Next attachment ID 9376
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.14, total records: 2140713
Average version length: 47.66, total versions: 870, 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: 15, data page slots: 23120
Data pages: 23120, average fill: 73%
Primary pages: 23120, secondary pages: 0, swept pages: 14616
Empty pages: 4, full pages: 22387
Fill distribution:
0 - 19% = 8
20 - 39% = 21
40 - 59% = 91
60 - 79% = 22994
80 - 99% = 6

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 10515, nodes: 2140713
Average node length: 19.40, total dup: 0, max dup: 0
Average key length: 16.45, compression ratio: 1.64
Average prefix length: 13.55, average data length: 13.45
Clustering factor: 278003, ratio: 0.13
Fill distribution:
0 - 19% = 924
20 - 39% = 2958
40 - 59% = 3524
60 - 79% = 1215
80 - 99% = 1894

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7699, nodes: 2140713
Average node length: 11.63, total dup: 0, max dup: 0
Average key length: 8.68, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 283446, ratio: 0.13
Fill distribution:
0 - 19% = 5
20 - 39% = 3772
40 - 59% = 3711
60 - 79% = 188
80 - 99% = 23

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 178276, depth: 3, leaf buckets: 3479, nodes: 2140713
Average node length: 6.87, total dup: 1540779, max dup: 49
Average key length: 3.92, compression ratio: 2.30
Average prefix length: 7.36, average data length: 1.64
Clustering factor: 243667, ratio: 0.11
Fill distribution:
0 - 19% = 141
20 - 39% = 1127
40 - 59% = 983
60 - 79% = 524
80 - 99% = 704

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.57, total records: 665681
Average version length: 60.90, total versions: 42, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.58
Pointer pages: 6, data page slots: 8416
Data pages: 8416, average fill: 75%
Primary pages: 8415, secondary pages: 1, swept pages: 7972
Empty pages: 5, full pages: 8226
Fill distribution:
0 - 19% = 11
20 - 39% = 14
40 - 59% = 59
60 - 79% = 8312
80 - 99% = 20

Index DOC_LIST_ID_DESC (1)
Root page: 249240, depth: 3, leaf buckets: 2406, nodes: 665681
Average node length: 11.67, total dup: 0, max dup: 0
Average key length: 8.80, compression ratio: 1.02
Average prefix length: 3.20, average data length: 5.80
Clustering factor: 135450, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 1264
40 - 59% = 1037
60 - 79% = 90
80 - 99% = 14

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 694, nodes: 665681
Average node length: 4.88, total dup: 665631, max dup: 35314
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 300920, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 575
60 - 79% = 93
80 - 99% = 26

Index PK_DOC_LIST (0)
Root page: 352282, depth: 3, leaf buckets: 1608, nodes: 665681
Average node length: 11.66, total dup: 0, max dup: 0
Average key length: 8.79, compression ratio: 1.02
Average prefix length: 3.20, average data length: 5.80
Clustering factor: 135450, ratio: 0.20
Fill distribution:
0 - 19% = 92
20 - 39% = 218
40 - 59% = 450
60 - 79% = 464
80 - 99% = 384

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

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

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

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

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

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

INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 63.90, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 16.42, total fragments: 358, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.63
Pointer pages: 1, data page slots: 152
Data pages: 20, average fill: 32%
Primary pages: 7, secondary pages: 13, swept pages: 4
Empty pages: 7, full pages: 3
Fill distribution:
0 - 19% = 9
20 - 39% = 5
40 - 59% = 2
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: 24.18, total records: 2581
Average version length: 71.17, total versions: 1705, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 3.97
Pointer pages: 1, data page slots: 400
Data pages: 200, average fill: 18%
Primary pages: 199, secondary pages: 1, swept pages: 85
Empty pages: 74, full pages: 3
Fill distribution:
0 - 19% = 110
20 - 39% = 62
40 - 59% = 20
60 - 79% = 6
80 - 99% = 2

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 14, nodes: 2581
Average node length: 16.10, total dup: 12, max dup: 1
Average key length: 14.09, compression ratio: 1.92
Average prefix length: 15.90, average data length: 11.10
Clustering factor: 2018, ratio: 0.78
Fill distribution:
0 - 19% = 0
20 - 39% = 11
40 - 59% = 2
60 - 79% = 0
80 - 99% = 1

MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.04, 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% = 0
20 - 39% = 1
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: 45.77, total records: 62
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: 64.00, compression ratio: 1.40
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 5%
Primary pages: 15, secondary pages: 1, swept pages: 8
Empty pages: 9, full pages: 0
Fill distribution:
0 - 19% = 15
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 275, depth: 1, leaf buckets: 1, nodes: 62
Average node length: 9.73, total dup: 35, max dup: 12
Average key length: 8.63, compression ratio: 2.20
Average prefix length: 12.79, average data length: 6.21
Clustering factor: 37, ratio: 0.60
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 19.04, total records: 808110
Average version length: 43.22, total versions: 680, max versions: 6
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.36
Pointer pages: 3, data page slots: 4744
Data pages: 4744, average fill: 76%
Primary pages: 4743, secondary pages: 1, swept pages: 4201
Empty pages: 2, full pages: 4630
Fill distribution:
0 - 19% = 4
20 - 39% = 2
40 - 59% = 8
60 - 79% = 4288
80 - 99% = 442

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 261, nodes: 242230
Average node length: 4.89, total dup: 242181, max dup: 14663
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 33086, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 177
60 - 79% = 48
80 - 99% = 15

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 272, nodes: 242230
Average node length: 5.82, total dup: 218619, max dup: 54
Average key length: 2.94, compression ratio: 7.49
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 37144, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 19
40 - 59% = 95
60 - 79% = 98
80 - 99% = 59

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 276, nodes: 242230
Average node length: 5.82, total dup: 218619, max dup: 54
Average key length: 2.94, compression ratio: 7.49
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 37190, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 15
40 - 59% = 102
60 - 79% = 115
80 - 99% = 43

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 271, nodes: 242230
Average node length: 5.61, total dup: 218619, max dup: 54
Average key length: 2.73, compression ratio: 3.30
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 37176, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 14
40 - 59% = 125
60 - 79% = 88
80 - 99% = 43

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 568206, depth: 2, leaf buckets: 219, nodes: 273705
Average node length: 4.53, total dup: 273524, max dup: 2421
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 31914, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 83
60 - 79% = 72
80 - 99% = 64

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: 152.21, total records: 14385510
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.14
Pointer pages: 210, data page slots: 342504
Data pages: 342504, average fill: 87%
Primary pages: 342504, secondary pages: 0, swept pages: 3
Empty pages: 0, full pages: 342503
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 342503

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 17476, nodes: 14385510
Average node length: 5.74, total dup: 13519001, max dup: 144
Average key length: 2.15, compression ratio: 3.72
Average prefix length: 7.88, average data length: 0.11
Clustering factor: 1930142, ratio: 0.13
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 12255
60 - 79% = 3249
80 - 99% = 1970

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 14695, nodes: 14385510
Average node length: 4.71, total dup: 14385506, max dup: 12520657
Average key length: 1.13, compression ratio: 0.57
Average prefix length: 0.65, average data length: 0.00
Clustering factor: 411174, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 14691
60 - 79% = 2
80 - 99% = 1

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 18361, nodes: 14385510
Average node length: 5.78, total dup: 14018672, max dup: 29645
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 712030, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 15060
60 - 79% = 1944
80 - 99% = 1355

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 17682, nodes: 14385510
Average node length: 5.64, total dup: 14374693, max dup: 2334545
Average key length: 2.06, compression ratio: 18.50
Average prefix length: 37.96, average data length: 0.05
Clustering factor: 5851851, ratio: 0.41
Fill distribution:
0 - 19% = 12
20 - 39% = 1
40 - 59% = 15532
60 - 79% = 237
80 - 99% = 1900

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: 403286
Average version length: 56.23, total versions: 122, 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: 3, data page slots: 4776
Data pages: 4776, average fill: 75%
Primary pages: 4776, secondary pages: 0, swept pages: 3504
Empty pages: 7, full pages: 4684
Fill distribution:
0 - 19% = 8
20 - 39% = 1
40 - 59% = 4
60 - 79% = 4763
80 - 99% = 0

Index PSTORNED_RCV_ID (2)
Root page: 830575, depth: 3, leaf buckets: 537, nodes: 403286
Average node length: 6.00, total dup: 334680, max dup: 555
Average key length: 3.24, compression ratio: 2.78
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 49321, ratio: 0.12
Fill distribution:
0 - 19% = 7
20 - 39% = 27
40 - 59% = 335
60 - 79% = 120
80 - 99% = 48

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 437, nodes: 403286
Average node length: 5.58, total dup: 359470, max dup: 150
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 101813, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 200
60 - 79% = 169
80 - 99% = 63

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.41, total records: 2704
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.55
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 62%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 32
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: 40.25, total records: 7784
Average version length: 72.17, total versions: 3447, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.38
Pointer pages: 1, data page slots: 392
Data pages: 331, average fill: 30%
Primary pages: 330, secondary pages: 1, swept pages: 144
Empty pages: 45, full pages: 37
Fill distribution:
0 - 19% = 141
20 - 39% = 91
40 - 59% = 45
60 - 79% = 47
80 - 99% = 7

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 19, nodes: 7784
Average node length: 6.48, total dup: 6722, max dup: 14
Average key length: 4.48, compression ratio: 8.26
Average prefix length: 34.65, average data length: 2.35
Clustering factor: 1231, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 5
60 - 79% = 0
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.87, total records: 764169
Average version length: 72.01, total versions: 3333, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 8, data page slots: 11552
Data pages: 11552, average fill: 73%
Primary pages: 11552, secondary pages: 0, swept pages: 7141
Empty pages: 8, full pages: 8485
Fill distribution:
0 - 19% = 45
20 - 39% = 184
40 - 59% = 727
60 - 79% = 10576
80 - 99% = 20

Index XQD_1000_3300_DOC (1)
Root page: 669595, depth: 3, leaf buckets: 658, nodes: 764169
Average node length: 5.11, total dup: 742403, max dup: 119
Average key length: 2.21, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 84729, ratio: 0.11
Fill distribution:
0 - 19% = 6
20 - 39% = 68
40 - 59% = 195
60 - 79% = 42
80 - 99% = 347

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 277751, depth: 3, leaf buckets: 1066, nodes: 764169
Average node length: 6.23, total dup: 666738, max dup: 14
Average key length: 3.33, compression ratio: 11.12
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 151992, ratio: 0.20
Fill distribution:
0 - 19% = 11
20 - 39% = 141
40 - 59% = 610
60 - 79% = 189
80 - 99% = 115

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 16.46, total records: 116336
Average version length: 71.99, total versions: 12608, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 8.26
Pointer pages: 2, data page slots: 2224
Data pages: 2128, average fill: 30%
Primary pages: 2119, secondary pages: 9, swept pages: 1188
Empty pages: 477, full pages: 315
Fill distribution:
0 - 19% = 1085
20 - 39% = 229
40 - 59% = 312
60 - 79% = 328
80 - 99% = 174

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 54, nodes: 28110
Average node length: 5.73, total dup: 24657, max dup: 47
Average key length: 3.65, compression ratio: 10.14
Average prefix length: 35.47, average data length: 1.53
Clustering factor: 2819, ratio: 0.10
Fill distribution:
0 - 19% = 0
20 - 39% = 33
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: 45.61, total records: 2811983
Average version length: 71.07, total versions: 12957, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.98
Pointer pages: 22, data page slots: 34488
Data pages: 34464, average fill: 63%
Primary pages: 34464, secondary pages: 0, swept pages: 8883
Empty pages: 201, full pages: 33617
Fill distribution:
0 - 19% = 295
20 - 39% = 8589
40 - 59% = 1882
60 - 79% = 19916
80 - 99% = 3782

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 167476, depth: 3, leaf buckets: 2366, nodes: 1643989
Average node length: 5.52, total dup: 1562536, max dup: 49
Average key length: 2.55, compression ratio: 14.53
Average prefix length: 36.50, average data length: 0.50
Clustering factor: 118352, ratio: 0.07
Fill distribution:
0 - 19% = 26
20 - 39% = 780
40 - 59% = 1124
60 - 79% = 243
80 - 99% = 193

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.01, total records: 4937171
Average version length: 71.54, total versions: 797, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.10
Pointer pages: 20, data page slots: 31984
Data pages: 31952, average fill: 49%
Primary pages: 31952, secondary pages: 0, swept pages: 11161
Empty pages: 28, full pages: 31510
Fill distribution:
0 - 19% = 94
20 - 39% = 12353
40 - 59% = 6521
60 - 79% = 12766
80 - 99% = 218

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 6, nodes: 1387
Average node length: 11.06, total dup: 989, max dup: 14
Average key length: 8.06, compression ratio: 4.59
Average prefix length: 31.23, average data length: 5.77
Clustering factor: 321, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 63.10, total records: 3211689
Average version length: 70.88, total versions: 4864, 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: 26, data page slots: 41272
Data pages: 41272, average fill: 77%
Primary pages: 41272, secondary pages: 0, swept pages: 28946
Empty pages: 40, full pages: 40082
Fill distribution:
0 - 19% = 66
20 - 39% = 357
40 - 59% = 819
60 - 79% = 37740
80 - 99% = 2290

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5750, nodes: 2787869
Average node length: 6.89, total dup: 2249087, max dup: 14
Average key length: 3.91, compression ratio: 9.46
Average prefix length: 35.28, average data length: 1.72
Clustering factor: 394267, ratio: 0.14
Fill distribution:
0 - 19% = 2
20 - 39% = 3044
40 - 59% = 2128
60 - 79% = 400
80 - 99% = 176

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.74, total records: 4729430
Average version length: 83.73, total versions: 245, 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: 45, data page slots: 72624
Data pages: 72624, average fill: 80%
Primary pages: 72624, secondary pages: 0, swept pages: 26493
Empty pages: 3, full pages: 72532
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 3
60 - 79% = 20289
80 - 99% = 52328

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4896, nodes: 4729430
Average node length: 5.16, total dup: 4622125, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 701715, ratio: 0.15
Fill distribution:
0 - 19% = 21
20 - 39% = 74
40 - 59% = 2218
60 - 79% = 2156
80 - 99% = 427

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 4113, nodes: 4729430
Average node length: 5.70, total dup: 4231435, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 122558, ratio: 0.03
Fill distribution:
0 - 19% = 18
20 - 39% = 68
40 - 59% = 914
60 - 79% = 279
80 - 99% = 2834

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5423, nodes: 4729430
Average node length: 5.81, total dup: 4138533, max dup: 14
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 755218, ratio: 0.16
Fill distribution:
0 - 19% = 28
20 - 39% = 92
40 - 59% = 2331
60 - 79% = 2312
80 - 99% = 660

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.52, total records: 2788868
Average version length: 83.85, total versions: 4163, 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: 27, data page slots: 43344
Data pages: 43344, average fill: 79%
Primary pages: 43344, secondary pages: 0, swept pages: 31863
Empty pages: 50, full pages: 42520
Fill distribution:
0 - 19% = 82
20 - 39% = 59
40 - 59% = 179
60 - 79% = 14298
80 - 99% = 28726

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2935, nodes: 2788868
Average node length: 5.15, total dup: 2723586, max dup: 150
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 446336, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 59
40 - 59% = 1647
60 - 79% = 888
80 - 99% = 339

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4186, nodes: 2788868
Average node length: 6.27, total dup: 2269405, max dup: 14
Average key length: 3.29, compression ratio: 2.73
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 190403, ratio: 0.07
Fill distribution:
0 - 19% = 75
20 - 39% = 1276
40 - 59% = 1565
60 - 79% = 722
80 - 99% = 548

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3323, nodes: 2788868
Average node length: 5.81, total dup: 2438975, max dup: 29
Average key length: 2.83, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 535951, ratio: 0.19
Fill distribution:
0 - 19% = 19
20 - 39% = 48
40 - 59% = 1925
60 - 79% = 924
80 - 99% = 407

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.88, total records: 5003028
Average version length: 85.05, total versions: 2407, 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: 48, data page slots: 76760
Data pages: 76752, average fill: 81%
Primary pages: 76752, secondary pages: 0, swept pages: 16697
Empty pages: 221, full pages: 76137
Fill distribution:
0 - 19% = 256
20 - 39% = 101
40 - 59% = 149
60 - 79% = 9790
80 - 99% = 66456

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5066, nodes: 5003028
Average node length: 5.04, total dup: 4974143, max dup: 690
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 719867, ratio: 0.14
Fill distribution:
0 - 19% = 7
20 - 39% = 108
40 - 59% = 2650
60 - 79% = 1653
80 - 99% = 648

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5420, nodes: 5003028
Average node length: 5.49, total dup: 4635055, max dup: 49
Average key length: 2.50, compression ratio: 3.60
Average prefix length: 8.57, average data length: 0.43
Clustering factor: 122557, ratio: 0.02
Fill distribution:
0 - 19% = 140
20 - 39% = 1114
40 - 59% = 1648
60 - 79% = 743
80 - 99% = 1775

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5710, nodes: 5003028
Average node length: 5.69, total dup: 4485044, max dup: 83
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 791126, ratio: 0.16
Fill distribution:
0 - 19% = 5
20 - 39% = 104
40 - 59% = 3014
60 - 79% = 1798
80 - 99% = 789

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.56, total records: 3372861
Average version length: 83.87, total versions: 3862, 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: 32, data page slots: 52192
Data pages: 52192, average fill: 80%
Primary pages: 52192, secondary pages: 0, swept pages: 36445
Empty pages: 69, full pages: 51384
Fill distribution:
0 - 19% = 104
20 - 39% = 69
40 - 59% = 240
60 - 79% = 13570
80 - 99% = 38209

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3731, nodes: 3372861
Average node length: 5.02, total dup: 3356743, max dup: 1220
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 566788, ratio: 0.17
Fill distribution:
0 - 19% = 20
20 - 39% = 456
40 - 59% = 2015
60 - 79% = 853
80 - 99% = 387

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 4965, nodes: 3372861
Average node length: 6.27, total dup: 2747073, max dup: 14
Average key length: 3.29, compression ratio: 2.74
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 238992, ratio: 0.07
Fill distribution:
0 - 19% = 121
20 - 39% = 1400
40 - 59% = 1839
60 - 79% = 862
80 - 99% = 743

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4114, nodes: 3372861
Average node length: 5.57, total dup: 3085278, max dup: 73
Average key length: 2.59, compression ratio: 3.47
Average prefix length: 8.49, average data length: 0.51
Clustering factor: 616079, ratio: 0.18
Fill distribution:
0 - 19% = 17
20 - 39% = 479
40 - 59% = 2204
60 - 79% = 968
80 - 99% = 446

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: 586555
Average version length: 69.44, total versions: 561, 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: 5, data page slots: 8032
Data pages: 8032, average fill: 77%
Primary pages: 8032, secondary pages: 0, swept pages: 6353
Empty pages: 3, full pages: 8001
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 9
60 - 79% = 8012
80 - 99% = 7

Index XQS_3300_3400_DOC_ID (0)
Root page: 238098, depth: 3, leaf buckets: 693, nodes: 586555
Average node length: 5.34, total dup: 549872, max dup: 113
Average key length: 2.47, compression ratio: 3.64
Average prefix length: 8.59, average data length: 0.41
Clustering factor: 52320, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 125
40 - 59% = 307
60 - 79% = 185
80 - 99% = 74

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 776, nodes: 586555
Average node length: 5.93, total dup: 499291, max dup: 14
Average key length: 3.07, compression ratio: 2.93
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 55247, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 153
40 - 59% = 330
60 - 79% = 208
80 - 99% = 83

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

Gstat completion time Sun Jan 07 11:43:49 2018

Done for 180740 ms, from 11:40:48.49 to 11:43:49.23.

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	2140713	870	0.0406
DOC_LIST	665681	42	0.0063
DOC_STATES	4	0	0.0000
FB_ERRORS	758	0	0.0000
INVNT_SALDO	400	0	0.0000
INVNT_TURNOVER_LOG	2581	1705	66.0596
MONEY_SALDO	49	0	0.0000
MONEY_TURNOVER_LOG	62	0	0.0000
OPTYPES	9	0	0.0000
PDISTR	808110	680	0.0841
PERF_ESTIMATED	273705	0	0.0000
PERF_LOG	14385510	0	0.0000
PSTORNED	403286	122	0.0302
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	2704	0	0.0000
WARES	400	0	0.0000
WARE_GROUPS	8	0	0.0000
XQD_1000_1200	7784	3447	44.2831
XQD_1000_3300	764169	3333	0.4361
XQD_1200_2000	116336	12608	10.8375
XQD_2000_3300	2811983	12957	0.4607
XQD_2100_3300	4937171	797	0.0161
XQD_3300_3400	3211689	4864	0.1514
XQS_1000_1200	4729430	245	0.0051
XQS_1000_3300	2788868	4163	0.1492
XQS_1200_2000	5003028	2407	0.0481
XQS_2100_3300	3372861	3862	0.1145
XQS_3300_3400	586555	561	0.0956
Z_USED_VIEWS	29	0	0.0000

Done for 2070 ms, from 11:43:59.70 to 11:44:01.77.

Database validation

11:44:01.91 Validation started

11:44:01.93 Relation 140 (DOC_LIST)
11:44:01.93 process pointer page 0 of 6
11:44:02.04 process pointer page 1 of 6
11:44:02.11 process pointer page 2 of 6
11:44:02.16 process pointer page 3 of 6
11:44:02.22 process pointer page 4 of 6
11:44:02.27 process pointer page 5 of 6
11:44:02.27 Index 1 (PK_DOC_LIST)
11:44:02.35 Index 2 (DOC_LIST_ID_DESC)
11:44:02.43 Index 3 (FK_DOC_LIST_AGENTS)
11:44:02.50 Relation 140 (DOC_LIST) is ok

11:44:02.50 Relation 141 (DOC_DATA)
11:44:02.50 process pointer page 0 of 15
11:44:02.54 process pointer page 1 of 15
11:44:02.61 process pointer page 2 of 15
11:44:02.66 process pointer page 3 of 15
11:44:02.69 process pointer page 4 of 15
11:44:02.74 process pointer page 5 of 15
11:44:02.77 process pointer page 6 of 15
11:44:02.83 process pointer page 7 of 15
11:44:02.91 process pointer page 8 of 15
11:44:03.00 process pointer page 9 of 15
11:44:03.10 process pointer page 10 of 15
11:44:03.19 process pointer page 11 of 15
11:44:03.22 process pointer page 12 of 15
11:44:03.25 process pointer page 13 of 15
11:44:03.28 process pointer page 14 of 15
11:44:03.30 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:44:03.77 Index 3 (DOC_DATA_ID_DESC)
11:44:04.13 Index 4 (FK_DOC_DATA_DOC_LIST)
11:44:04.42 Relation 141 (DOC_DATA) is ok

11:44:04.42 Relation 147 (INVNT_SALDO)
11:44:04.44 process pointer page 0 of 1
11:44:04.44 Index 1 (PK_INVNT_SALDO)
11:44:04.44 Relation 147 (INVNT_SALDO) is ok

11:44:04.44 Relation 150 (PDISTR)
11:44:04.44 process pointer page 0 of 3
11:44:04.47 process pointer page 1 of 3
11:44:04.50 process pointer page 2 of 3
11:44:04.53 Index 2 (PDISTR_SND_ID)
11:44:04.60 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:44:04.66 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:44:04.69 Index 5 (PDISTR_AGENT_ID)
11:44:04.72 Relation 150 (PDISTR) is ok

11:44:04.72 Relation 151 (PSTORNED)
11:44:04.72 process pointer page 0 of 3
11:44:04.78 process pointer page 1 of 3
11:44:04.86 process pointer page 2 of 3
11:44:04.95 Index 2 (PSTORNED_SND_ID)
11:44:05.03 Index 3 (PSTORNED_RCV_ID)
11:44:05.08 Relation 151 (PSTORNED) is ok

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

11:44:05.08 Relation 157 (INVNT_TURNOVER_LOG)
11:44:05.08 process pointer page 0 of 1
11:44:05.08 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:44:05.08 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:44:05.08 Relation 160 (PERF_ESTIMATED)
11:44:05.08 process pointer page 0 of 2
11:44:05.13 process pointer page 1 of 2
11:44:05.13 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:44:05.20 Relation 160 (PERF_ESTIMATED) is ok

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

11:44:05.20 Relation 162 (TRACE_STAT)
11:44:05.20 process pointer page 0 of 1
11:44:05.20 Relation 162 (TRACE_STAT) is ok

11:44:05.20 Relation 163 (PERF_LOG)
11:44:05.20 process pointer page 0 of 210
11:44:05.28 process pointer page 1 of 210
11:44:05.38 process pointer page 2 of 210
11:44:05.45 process pointer page 3 of 210
11:44:05.55 process pointer page 4 of 210
11:44:05.62 process pointer page 5 of 210
11:44:05.70 process pointer page 6 of 210
11:44:05.77 process pointer page 7 of 210
11:44:05.80 process pointer page 8 of 210
11:44:05.83 process pointer page 9 of 210
11:44:05.87 process pointer page 10 of 210
11:44:05.92 process pointer page 11 of 210
11:44:06.02 process pointer page 12 of 210
11:44:06.09 process pointer page 13 of 210
11:44:06.12 process pointer page 14 of 210
11:44:06.16 process pointer page 15 of 210
11:44:06.19 process pointer page 16 of 210
11:44:06.22 process pointer page 17 of 210
11:44:06.25 process pointer page 18 of 210
11:44:06.28 process pointer page 19 of 210
11:44:06.31 process pointer page 20 of 210
11:44:06.34 process pointer page 21 of 210
11:44:06.37 process pointer page 22 of 210
11:44:06.41 process pointer page 23 of 210
11:44:06.44 process pointer page 24 of 210
11:44:06.51 process pointer page 25 of 210
11:44:06.59 process pointer page 26 of 210
11:44:06.69 process pointer page 27 of 210
11:44:06.75 process pointer page 28 of 210
11:44:06.78 process pointer page 29 of 210
11:44:06.81 process pointer page 30 of 210
11:44:06.84 process pointer page 31 of 210
11:44:06.87 process pointer page 32 of 210
11:44:06.90 process pointer page 33 of 210
11:44:06.94 process pointer page 34 of 210
11:44:06.98 process pointer page 35 of 210
11:44:07.01 process pointer page 36 of 210
11:44:07.04 process pointer page 37 of 210
11:44:07.06 process pointer page 38 of 210
11:44:07.11 process pointer page 39 of 210
11:44:07.19 process pointer page 40 of 210
11:44:07.28 process pointer page 41 of 210
11:44:07.31 process pointer page 42 of 210
11:44:07.36 process pointer page 43 of 210
11:44:07.43 process pointer page 44 of 210
11:44:07.53 process pointer page 45 of 210
11:44:07.61 process pointer page 46 of 210
11:44:07.68 process pointer page 47 of 210
11:44:07.76 process pointer page 48 of 210
11:44:07.84 process pointer page 49 of 210
11:44:07.93 process pointer page 50 of 210
11:44:07.97 process pointer page 51 of 210
11:44:08.00 process pointer page 52 of 210
11:44:08.04 process pointer page 53 of 210
11:44:08.12 process pointer page 54 of 210
11:44:08.15 process pointer page 55 of 210
11:44:08.18 process pointer page 56 of 210
11:44:08.21 process pointer page 57 of 210
11:44:08.25 process pointer page 58 of 210
11:44:08.28 process pointer page 59 of 210
11:44:08.31 process pointer page 60 of 210
11:44:08.36 process pointer page 61 of 210
11:44:08.43 process pointer page 62 of 210
11:44:08.51 process pointer page 63 of 210
11:44:08.59 process pointer page 64 of 210
11:44:08.67 process pointer page 65 of 210
11:44:08.71 process pointer page 66 of 210
11:44:08.75 process pointer page 67 of 210
11:44:08.78 process pointer page 68 of 210
11:44:08.81 process pointer page 69 of 210
11:44:08.84 process pointer page 70 of 210
11:44:08.87 process pointer page 71 of 210
11:44:08.90 process pointer page 72 of 210
11:44:08.92 process pointer page 73 of 210
11:44:08.95 process pointer page 74 of 210
11:44:08.98 process pointer page 75 of 210
11:44:09.01 process pointer page 76 of 210
11:44:09.03 process pointer page 77 of 210
11:44:09.06 process pointer page 78 of 210
11:44:09.07 process pointer page 79 of 210
11:44:09.10 process pointer page 80 of 210
11:44:09.12 process pointer page 81 of 210
11:44:09.15 process pointer page 82 of 210
11:44:09.18 process pointer page 83 of 210
11:44:09.21 process pointer page 84 of 210
11:44:09.24 process pointer page 85 of 210
11:44:09.26 process pointer page 86 of 210
11:44:09.29 process pointer page 87 of 210
11:44:09.31 process pointer page 88 of 210
11:44:09.34 process pointer page 89 of 210
11:44:09.37 process pointer page 90 of 210
11:44:09.42 process pointer page 91 of 210
11:44:09.49 process pointer page 92 of 210
11:44:09.57 process pointer page 93 of 210
11:44:09.65 process pointer page 94 of 210
11:44:09.73 process pointer page 95 of 210
11:44:09.79 process pointer page 96 of 210
11:44:09.82 process pointer page 97 of 210
11:44:09.90 process pointer page 98 of 210
11:44:09.98 process pointer page 99 of 210
11:44:10.02 process pointer page 100 of 210
11:44:10.06 process pointer page 101 of 210
11:44:10.09 process pointer page 102 of 210
11:44:10.12 process pointer page 103 of 210
11:44:10.15 process pointer page 104 of 210
11:44:10.16 process pointer page 105 of 210
11:44:10.21 process pointer page 106 of 210
11:44:10.31 process pointer page 107 of 210
11:44:10.38 process pointer page 108 of 210
11:44:10.46 process pointer page 109 of 210
11:44:10.54 process pointer page 110 of 210
11:44:10.57 process pointer page 111 of 210
11:44:10.60 process pointer page 112 of 210
11:44:10.63 process pointer page 113 of 210
11:44:10.70 process pointer page 114 of 210
11:44:10.77 process pointer page 115 of 210
11:44:10.80 process pointer page 116 of 210
11:44:10.84 process pointer page 117 of 210
11:44:10.88 process pointer page 118 of 210
11:44:10.91 process pointer page 119 of 210
11:44:10.94 process pointer page 120 of 210
11:44:10.98 process pointer page 121 of 210
11:44:11.01 process pointer page 122 of 210
11:44:11.04 process pointer page 123 of 210
11:44:11.07 process pointer page 124 of 210
11:44:11.10 process pointer page 125 of 210
11:44:11.13 process pointer page 126 of 210
11:44:11.15 process pointer page 127 of 210
11:44:11.18 process pointer page 128 of 210
11:44:11.24 process pointer page 129 of 210
11:44:11.30 process pointer page 130 of 210
11:44:11.33 process pointer page 131 of 210
11:44:11.37 process pointer page 132 of 210
11:44:11.40 process pointer page 133 of 210
11:44:11.43 process pointer page 134 of 210
11:44:11.49 process pointer page 135 of 210
11:44:11.54 process pointer page 136 of 210
11:44:11.57 process pointer page 137 of 210
11:44:11.63 process pointer page 138 of 210
11:44:11.71 process pointer page 139 of 210
11:44:11.76 process pointer page 140 of 210
11:44:11.79 process pointer page 141 of 210
11:44:11.82 process pointer page 142 of 210
11:44:11.87 process pointer page 143 of 210
11:44:11.94 process pointer page 144 of 210
11:44:11.97 process pointer page 145 of 210
11:44:12.04 process pointer page 146 of 210
11:44:12.11 process pointer page 147 of 210
11:44:12.19 process pointer page 148 of 210
11:44:12.22 process pointer page 149 of 210
11:44:12.29 process pointer page 150 of 210
11:44:12.32 process pointer page 151 of 210
11:44:12.35 process pointer page 152 of 210
11:44:12.38 process pointer page 153 of 210
11:44:12.46 process pointer page 154 of 210
11:44:12.54 process pointer page 155 of 210
11:44:12.61 process pointer page 156 of 210
11:44:12.71 process pointer page 157 of 210
11:44:12.79 process pointer page 158 of 210
11:44:12.86 process pointer page 159 of 210
11:44:12.94 process pointer page 160 of 210
11:44:13.02 process pointer page 161 of 210
11:44:13.07 process pointer page 162 of 210
11:44:13.10 process pointer page 163 of 210
11:44:13.19 process pointer page 164 of 210
11:44:13.27 process pointer page 165 of 210
11:44:13.35 process pointer page 166 of 210
11:44:13.43 process pointer page 167 of 210
11:44:13.50 process pointer page 168 of 210
11:44:13.57 process pointer page 169 of 210
11:44:13.60 process pointer page 170 of 210
11:44:13.63 process pointer page 171 of 210
11:44:13.66 process pointer page 172 of 210
11:44:13.69 process pointer page 173 of 210
11:44:13.77 process pointer page 174 of 210
11:44:13.85 process pointer page 175 of 210
11:44:13.92 process pointer page 176 of 210
11:44:14.02 process pointer page 177 of 210
11:44:14.10 process pointer page 178 of 210
11:44:14.16 process pointer page 179 of 210
11:44:14.19 process pointer page 180 of 210
11:44:14.22 process pointer page 181 of 210
11:44:14.25 process pointer page 182 of 210
11:44:14.28 process pointer page 183 of 210
11:44:14.35 process pointer page 184 of 210
11:44:14.42 process pointer page 185 of 210
11:44:14.50 process pointer page 186 of 210
11:44:14.58 process pointer page 187 of 210
11:44:14.63 process pointer page 188 of 210
11:44:14.66 process pointer page 189 of 210
11:44:14.69 process pointer page 190 of 210
11:44:14.72 process pointer page 191 of 210
11:44:14.75 process pointer page 192 of 210
11:44:14.78 process pointer page 193 of 210
11:44:14.81 process pointer page 194 of 210
11:44:14.84 process pointer page 195 of 210
11:44:14.86 process pointer page 196 of 210
11:44:14.89 process pointer page 197 of 210
11:44:14.92 process pointer page 198 of 210
11:44:14.94 process pointer page 199 of 210
11:44:14.97 process pointer page 200 of 210
11:44:14.99 process pointer page 201 of 210
11:44:15.02 process pointer page 202 of 210
11:44:15.05 process pointer page 203 of 210
11:44:15.06 process pointer page 204 of 210
11:44:15.09 process pointer page 205 of 210
11:44:15.13 process pointer page 206 of 210
11:44:15.14 process pointer page 207 of 210
11:44:15.17 process pointer page 208 of 210
11:44:15.19 process pointer page 209 of 210
11:44:15.22 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:44:17.64 Index 2 (PERF_LOG_UNIT)
11:44:20.32 Index 3 (PERF_LOG_TRN_DESC)
11:44:22.21 Index 4 (PERF_LOG_GDSCODE)
11:44:24.66 Relation 163 (PERF_LOG) is ok

11:44:24.66 Relation 167 (V_STOPTEST)
11:44:24.66 Relation 167 (V_STOPTEST) is ok

11:44:24.66 Relation 184 (V_QDISTR_SOURCE)
11:44:24.66 Relation 184 (V_QDISTR_SOURCE) is ok

11:44:24.66 Relation 185 (V_QSTORNED_SOURCE)
11:44:24.66 Relation 185 (V_QSTORNED_SOURCE) is ok

11:44:24.66 Relation 260 (XQD_1000_1200)
11:44:24.66 process pointer page 0 of 1
11:44:24.69 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:44:24.69 Relation 260 (XQD_1000_1200) is ok

11:44:24.69 Relation 261 (XQD_1200_2000)
11:44:24.69 process pointer page 0 of 2
11:44:24.75 process pointer page 1 of 2
11:44:24.77 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:44:24.77 Relation 261 (XQD_1200_2000) is ok

11:44:24.77 Relation 262 (XQD_1000_3300)
11:44:24.77 process pointer page 0 of 8
11:44:24.80 process pointer page 1 of 8
11:44:24.83 process pointer page 2 of 8
11:44:24.88 process pointer page 3 of 8
11:44:24.91 process pointer page 4 of 8
11:44:24.94 process pointer page 5 of 8
11:44:24.97 process pointer page 6 of 8
11:44:25.00 process pointer page 7 of 8
11:44:25.00 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:44:25.08 Index 2 (XQD_1000_3300_DOC)
11:44:25.30 Relation 262 (XQD_1000_3300) is ok

11:44:25.30 Relation 263 (XQD_2000_3300)
11:44:25.30 process pointer page 0 of 22
11:44:25.33 process pointer page 1 of 22
11:44:25.36 process pointer page 2 of 22
11:44:25.39 process pointer page 3 of 22
11:44:25.42 process pointer page 4 of 22
11:44:25.45 process pointer page 5 of 22
11:44:25.47 process pointer page 6 of 22
11:44:25.50 process pointer page 7 of 22
11:44:25.53 process pointer page 8 of 22
11:44:25.56 process pointer page 9 of 22
11:44:25.58 process pointer page 10 of 22
11:44:25.61 process pointer page 11 of 22
11:44:25.62 process pointer page 12 of 22
11:44:25.66 process pointer page 13 of 22
11:44:25.67 process pointer page 14 of 22
11:44:25.70 process pointer page 15 of 22
11:44:25.73 process pointer page 16 of 22
11:44:25.75 process pointer page 17 of 22
11:44:25.78 process pointer page 18 of 22
11:44:25.81 process pointer page 19 of 22
11:44:25.84 process pointer page 20 of 22
11:44:25.87 process pointer page 21 of 22
11:44:25.87 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:44:26.01 Relation 263 (XQD_2000_3300) is ok

11:44:26.01 Relation 264 (XQD_2100_3300)
11:44:26.01 process pointer page 0 of 20
11:44:26.03 process pointer page 1 of 20
11:44:26.05 process pointer page 2 of 20
11:44:26.08 process pointer page 3 of 20
11:44:26.09 process pointer page 4 of 20
11:44:26.12 process pointer page 5 of 20
11:44:26.14 process pointer page 6 of 20
11:44:26.17 process pointer page 7 of 20
11:44:26.20 process pointer page 8 of 20
11:44:26.25 process pointer page 9 of 20
11:44:26.28 process pointer page 10 of 20
11:44:26.30 process pointer page 11 of 20
11:44:26.33 process pointer page 12 of 20
11:44:26.36 process pointer page 13 of 20
11:44:26.39 process pointer page 14 of 20
11:44:26.40 process pointer page 15 of 20
11:44:26.42 process pointer page 16 of 20
11:44:26.45 process pointer page 17 of 20
11:44:26.47 process pointer page 18 of 20
11:44:26.50 process pointer page 19 of 20
11:44:26.51 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:44:26.51 Relation 264 (XQD_2100_3300) is ok

11:44:26.51 Relation 265 (XQD_3300_3400)
11:44:26.51 process pointer page 0 of 26
11:44:26.54 process pointer page 1 of 26
11:44:26.56 process pointer page 2 of 26
11:44:26.59 process pointer page 3 of 26
11:44:26.62 process pointer page 4 of 26
11:44:26.64 process pointer page 5 of 26
11:44:26.67 process pointer page 6 of 26
11:44:26.70 process pointer page 7 of 26
11:44:26.72 process pointer page 8 of 26
11:44:26.75 process pointer page 9 of 26
11:44:26.78 process pointer page 10 of 26
11:44:26.81 process pointer page 11 of 26
11:44:26.87 process pointer page 12 of 26
11:44:26.97 process pointer page 13 of 26
11:44:27.06 process pointer page 14 of 26
11:44:27.14 process pointer page 15 of 26
11:44:27.17 process pointer page 16 of 26
11:44:27.22 process pointer page 17 of 26
11:44:27.25 process pointer page 18 of 26
11:44:27.34 process pointer page 19 of 26
11:44:27.37 process pointer page 20 of 26
11:44:27.40 process pointer page 21 of 26
11:44:27.43 process pointer page 22 of 26
11:44:27.47 process pointer page 23 of 26
11:44:27.51 process pointer page 24 of 26
11:44:27.53 process pointer page 25 of 26
11:44:27.54 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:44:28.12 Relation 265 (XQD_3300_3400) is ok

11:44:28.12 Relation 266 (XQS_1000_1200)
11:44:28.12 process pointer page 0 of 45
11:44:28.17 process pointer page 1 of 45
11:44:28.25 process pointer page 2 of 45
11:44:28.34 process pointer page 3 of 45
11:44:28.42 process pointer page 4 of 45
11:44:28.51 process pointer page 5 of 45
11:44:28.60 process pointer page 6 of 45
11:44:28.67 process pointer page 7 of 45
11:44:28.70 process pointer page 8 of 45
11:44:28.73 process pointer page 9 of 45
11:44:28.76 process pointer page 10 of 45
11:44:28.79 process pointer page 11 of 45
11:44:28.82 process pointer page 12 of 45
11:44:28.85 process pointer page 13 of 45
11:44:28.88 process pointer page 14 of 45
11:44:28.95 process pointer page 15 of 45
11:44:29.01 process pointer page 16 of 45
11:44:29.04 process pointer page 17 of 45
11:44:29.07 process pointer page 18 of 45
11:44:29.15 process pointer page 19 of 45
11:44:29.21 process pointer page 20 of 45
11:44:29.24 process pointer page 21 of 45
11:44:29.27 process pointer page 22 of 45
11:44:29.31 process pointer page 23 of 45
11:44:29.34 process pointer page 24 of 45
11:44:29.37 process pointer page 25 of 45
11:44:29.40 process pointer page 26 of 45
11:44:29.43 process pointer page 27 of 45
11:44:29.51 process pointer page 28 of 45
11:44:29.63 process pointer page 29 of 45
11:44:29.90 process pointer page 30 of 45
11:44:30.15 process pointer page 31 of 45
11:44:30.44 process pointer page 32 of 45
11:44:30.73 process pointer page 33 of 45
11:44:31.01 process pointer page 34 of 45
11:44:31.26 process pointer page 35 of 45
11:44:31.52 process pointer page 36 of 45
11:44:31.80 process pointer page 37 of 45
11:44:32.07 process pointer page 38 of 45
11:44:32.36 process pointer page 39 of 45
11:44:32.68 process pointer page 40 of 45
11:44:32.97 process pointer page 41 of 45
11:44:33.27 process pointer page 42 of 45
11:44:33.58 process pointer page 43 of 45
11:44:33.88 process pointer page 44 of 45
11:44:34.02 Index 1 (XQS_1000_1200_DOC_ID)
11:44:35.83 Index 2 (XQS_1000_1200_SND_ID)
11:44:37.95 Index 3 (XQS_1000_1200_RCV_ID)
11:44:39.70 Relation 266 (XQS_1000_1200) is ok

11:44:39.70 Relation 267 (XQS_1200_2000)
11:44:39.70 process pointer page 0 of 48
11:44:39.74 process pointer page 1 of 48
11:44:39.77 process pointer page 2 of 48
11:44:40.01 process pointer page 3 of 48
11:44:40.41 process pointer page 4 of 48
11:44:40.82 process pointer page 5 of 48
11:44:41.22 process pointer page 6 of 48
11:44:41.65 process pointer page 7 of 48
11:44:42.05 process pointer page 8 of 48
11:44:42.44 process pointer page 9 of 48
11:44:42.85 process pointer page 10 of 48
11:44:43.25 process pointer page 11 of 48
11:44:43.66 process pointer page 12 of 48
11:44:44.08 process pointer page 13 of 48
11:44:44.50 process pointer page 14 of 48
11:44:44.92 process pointer page 15 of 48
11:44:45.36 process pointer page 16 of 48
11:44:45.81 process pointer page 17 of 48
11:44:46.22 process pointer page 18 of 48
11:44:46.64 process pointer page 19 of 48
11:44:47.04 process pointer page 20 of 48
11:44:47.45 process pointer page 21 of 48
11:44:47.87 process pointer page 22 of 48
11:44:48.24 process pointer page 23 of 48
11:44:48.63 process pointer page 24 of 48
11:44:48.99 process pointer page 25 of 48
11:44:49.45 process pointer page 26 of 48
11:44:49.93 process pointer page 27 of 48
11:44:50.40 process pointer page 28 of 48
11:44:50.85 process pointer page 29 of 48
11:44:51.29 process pointer page 30 of 48
11:44:51.71 process pointer page 31 of 48
11:44:52.13 process pointer page 32 of 48
11:44:52.55 process pointer page 33 of 48
11:44:53.00 process pointer page 34 of 48
11:44:53.42 process pointer page 35 of 48
11:44:53.86 process pointer page 36 of 48
11:44:54.28 process pointer page 37 of 48
11:44:54.70 process pointer page 38 of 48
11:44:55.14 process pointer page 39 of 48
11:44:55.56 process pointer page 40 of 48
11:44:55.97 process pointer page 41 of 48
11:44:56.40 process pointer page 42 of 48
11:44:56.82 process pointer page 43 of 48
11:44:57.25 process pointer page 44 of 48
11:44:57.67 process pointer page 45 of 48
11:44:58.10 process pointer page 46 of 48
11:44:58.52 process pointer page 47 of 48
11:44:58.54 Index 1 (XQS_1200_2000_DOC_ID)
11:45:00.55 Index 2 (XQS_1200_2000_SND_ID)
11:45:02.89 Index 3 (XQS_1200_2000_RCV_ID)
11:45:04.84 Relation 267 (XQS_1200_2000) is ok

11:45:04.84 Relation 268 (XQS_1000_3300)
11:45:04.84 process pointer page 0 of 27
11:45:05.28 process pointer page 1 of 27
11:45:05.73 process pointer page 2 of 27
11:45:06.20 process pointer page 3 of 27
11:45:06.65 process pointer page 4 of 27
11:45:07.10 process pointer page 5 of 27
11:45:07.54 process pointer page 6 of 27
11:45:07.99 process pointer page 7 of 27
11:45:08.46 process pointer page 8 of 27
11:45:08.91 process pointer page 9 of 27
11:45:09.37 process pointer page 10 of 27
11:45:09.82 process pointer page 11 of 27
11:45:10.27 process pointer page 12 of 27
11:45:10.71 process pointer page 13 of 27
11:45:11.16 process pointer page 14 of 27
11:45:11.52 process pointer page 15 of 27
11:45:11.89 process pointer page 16 of 27
11:45:12.36 process pointer page 17 of 27
11:45:12.80 process pointer page 18 of 27
11:45:13.24 process pointer page 19 of 27
11:45:13.67 process pointer page 20 of 27
11:45:14.11 process pointer page 21 of 27
11:45:14.53 process pointer page 22 of 27
11:45:14.95 process pointer page 23 of 27
11:45:15.37 process pointer page 24 of 27
11:45:15.78 process pointer page 25 of 27
11:45:16.18 process pointer page 26 of 27
11:45:16.39 Index 1 (XQS_1000_3300_DOC_ID)
11:45:17.79 Index 2 (XQS_1000_3300_SND_ID)
11:45:19.34 Index 3 (XQS_1000_3300_RCV_ID)
11:45:20.88 Relation 268 (XQS_1000_3300) is ok

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

11:45:20.88 Relation 270 (XQS_2100_3300)
11:45:20.88 process pointer page 0 of 32
11:45:21.33 process pointer page 1 of 32
11:45:21.78 process pointer page 2 of 32
11:45:22.25 process pointer page 3 of 32
11:45:22.72 process pointer page 4 of 32
11:45:23.13 process pointer page 5 of 32
11:45:23.61 process pointer page 6 of 32
11:45:24.12 process pointer page 7 of 32
11:45:24.58 process pointer page 8 of 32
11:45:25.03 process pointer page 9 of 32
11:45:25.48 process pointer page 10 of 32
11:45:25.93 process pointer page 11 of 32
11:45:26.39 process pointer page 12 of 32
11:45:26.84 process pointer page 13 of 32
11:45:27.28 process pointer page 14 of 32
11:45:27.73 process pointer page 15 of 32
11:45:28.18 process pointer page 16 of 32
11:45:28.63 process pointer page 17 of 32
11:45:29.07 process pointer page 18 of 32
11:45:29.51 process pointer page 19 of 32
11:45:29.94 process pointer page 20 of 32
11:45:30.36 process pointer page 21 of 32
11:45:30.82 process pointer page 22 of 32
11:45:31.24 process pointer page 23 of 32
11:45:31.66 process pointer page 24 of 32
11:45:32.06 process pointer page 25 of 32
11:45:32.49 process pointer page 26 of 32
11:45:32.89 process pointer page 27 of 32
11:45:33.31 process pointer page 28 of 32
11:45:33.72 process pointer page 29 of 32
11:45:34.12 process pointer page 30 of 32
11:45:34.55 process pointer page 31 of 32
11:45:34.92 Index 1 (XQS_2100_3300_DOC_ID)
11:45:36.31 Index 2 (XQS_2100_3300_SND_ID)
11:45:38.01 Index 3 (XQS_2100_3300_RCV_ID)
11:45:39.80 Relation 270 (XQS_2100_3300) is ok

11:45:39.80 Relation 271 (XQS_3300_3400)
11:45:39.80 process pointer page 0 of 5
11:45:40.24 process pointer page 1 of 5
11:45:40.71 process pointer page 2 of 5
11:45:41.16 process pointer page 3 of 5
11:45:41.61 process pointer page 4 of 5
11:45:41.97 Index 1 (XQS_3300_3400_DOC_ID)
11:45:42.31 Index 2 (XQS_3300_3400_SND_ID)
11:45:42.66 Relation 271 (XQS_3300_3400) is ok

11:45:42.69 Validation finished
Done for 100980 ms, from 11:44:01.80 to 11:45:42.78.

Differences between old and current firebird.log

11:45:44.51. 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:
2018-01-07 11:45 477 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Sun Jan 07 11:44:01 2018
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sun Jan 07 11:45:42 2018
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.
2018-01-07 11:45:50.75 - 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_.: