Tests

ACTION	AVG_TIMES_PER_MINUTE	AVG_ELAPSED_MS	SUCCESSFUL_TIMES_DONE	JOB_BEG	JOB_END
* OVERALL * for 180 minutes:	5760.01	1138	1036801	2018-08-02 03:46	2018-08-02 06:46
customer order: creation	379.00	171	68220	2018-08-02 03:46	2018-08-02 06:46
customer order: refuse	31.04	93	5588	2018-08-02 03:46	2018-08-02 06:46
order to supplier: creation	96.89	672	17440	2018-08-02 03:46	2018-08-02 06:46
order to supplier: removal	2.79	8670	502	2018-08-02 03:46	2018-08-02 06:46
invoice (draft): creation	97.93	997	17627	2018-08-02 03:46	2018-08-02 06:46
invoice (draft): removal	41.47	174	7464	2018-08-02 03:46	2018-08-02 06:46
invoice accept: apply	56.12	3697	10045	2018-08-02 03:46	2018-08-02 06:46
invoice accept: cancel	18.44	898	3319	2018-08-02 03:46	2018-08-02 06:46
customer reserve: creation	3274.97	50	589495	2018-08-02 03:46	2018-08-02 06:46
customer reserve: removal	1218.49	21	219328	2018-08-02 03:46	2018-08-02 06:46
realization accept: apply	174.21	192	31358	2018-08-02 03:46	2018-08-02 06:46
realization accept: cancel	90.54	55	16297	2018-08-02 03:46	2018-08-02 06:46
payment from customer: creation	126.45	282	22761	2018-08-02 03:46	2018-08-02 06:46
payment from customer: removal	12.05	53	2169	2018-08-02 03:46	2018-08-02 06:46
payment to supplier: creation	104.84	185	18871	2018-08-02 03:46	2018-08-02 06:46
payment to supplier: removal	7.15	50	1279	2018-08-02 03:46	2018-08-02 06:46
service: total inventory turnovers	13.88	786	2499	2018-08-02 03:46	2018-08-02 06:46
service: total monetary turnovers	14.03	28	2525	2018-08-02 03:46	2018-08-02 06:46
service: refresh index statistics	0.08	4546	14	2018-08-02 03:46	2018-08-02 06:46

Done for 92570 ms, from 6:48:55.70 to 6:50:28.27.

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	4274	88273	76926	11347	12.85	03:46:50	04:04:49
interval # 2, overall	2	5973	121334	107518	13816	11.39	04:04:50	04:22:49
interval # 3, overall	3	5907	127940	106330	21610	16.89	04:22:50	04:40:49
interval # 4, overall	4	6049	131238	108885	22353	17.03	04:40:50	04:58:49
interval # 5, overall	5	5616	119015	101089	17926	15.06	04:58:50	05:16:49
interval # 6, overall	6	6181	135922	111256	24666	18.15	05:16:50	05:34:49
interval # 7, overall	7	6247	136629	112437	24192	17.71	05:34:50	05:52:49
interval # 8, overall	8	5977	131007	107581	23426	17.88	05:52:50	06:10:49
interval # 9, overall	9	5844	125085	105186	19899	15.91	06:10:50	06:28:49
interval # 10, overall	10	5533	114843	99593	15250	13.28	06:28:50	06:46:49

Done for 217330 ms, from 6:54:11.44 to 6:57:48.77.

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	2332.02	0.0458	2.1320	2242	15
TEST_TIME	2	3111.30	0.7993	1.1726	1599	20
TEST_TIME	3	2739.18	0.8884	1.1505	1062	100
TEST_TIME	4	2745.33	0.8611	1.1480	1456	100
TEST_TIME	5	2846.96	0.8861	1.1022	1311	100
TEST_TIME	6	2918.45	0.9003	1.0951	1146	100
TEST_TIME	7	2968.52	0.9230	1.0810	1289	100
TEST_TIME	8	3086.14	0.9100	1.0624	1510	100
TEST_TIME	9	3172.21	0.9187	1.0837	1339	100
TEST_TIME	10	3303.89	0.9377	1.0586	1221	100
TEST_TIME	11	3362.42	0.9456	1.0676	1346	100
TEST_TIME	12	3465.37	0.9496	1.0517	1316	100
TEST_TIME	13	3536.25	0.9514	1.0539	1179	100
TEST_TIME	14	3620.10	0.9560	1.0493	1196	100
TEST_TIME	15	3762.28	0.9424	1.0536	1875	100
TEST_TIME	16	3935.62	0.9443	1.0503	1793	100
TEST_TIME	17	4069.92	0.9559	1.0481	1404	100
TEST_TIME	18	4172.33	0.9657	1.0330	1167	100
TEST_TIME	19	4224.03	0.9667	1.0483	1737	100
TEST_TIME	20	4325.29	0.9739	1.0271	1127	100
TEST_TIME	21	4381.93	0.9664	1.0240	1232	100
TEST_TIME	22	4409.98	0.9712	1.0275	1402	100
TEST_TIME	23	4467.64	0.9709	1.0309	1365	100
TEST_TIME	24	4528.96	0.9751	1.0247	1173	100
TEST_TIME	25	4518.62	0.9868	1.0247	1241	100
TEST_TIME	26	4546.43	0.9793	1.0171	1210	100
TEST_TIME	27	4552.62	0.9781	1.0219	1119	100
TEST_TIME	28	4560.74	0.9837	1.0183	1184	100
TEST_TIME	29	4580.49	0.9789	1.0185	1135	100
TEST_TIME	30	4636.38	0.9727	1.0291	1653	100
TEST_TIME	31	4736.21	0.9749	1.0247	1649	100
TEST_TIME	32	4836.99	0.9720	1.0240	1544	100
TEST_TIME	33	4892.83	0.9817	1.0260	1704	100
TEST_TIME	34	4968.51	0.9807	1.0193	1484	100
TEST_TIME	35	5008.25	0.9823	1.0227	1365	100
TEST_TIME	36	5065.81	0.9830	1.0186	1275	100
TEST_TIME	37	5077.44	0.9888	1.0118	1215	100
TEST_TIME	38	5086.25	0.9835	1.0146	1126	100
TEST_TIME	39	5097.69	0.9864	1.0144	1281	100
TEST_TIME	40	5125.02	0.9839	1.0149	1116	100
TEST_TIME	41	5136.09	0.9880	1.0116	869	100
TEST_TIME	42	5147.45	0.9858	1.0187	1000	100
TEST_TIME	43	5190.55	0.9868	1.0087	956	100
TEST_TIME	44	5197.68	0.9845	1.0104	1090	100
TEST_TIME	45	5217.93	0.9842	1.0182	1843	100
TEST_TIME	46	5272.05	0.9859	1.0138	1736	100
TEST_TIME	47	5265.20	0.9935	1.0110	1748	96
TEST_TIME	48	5301.67	0.9831	1.0155	1545	65
TEST_TIME	49	5323.58	0.9907	1.0073	1134	36
TEST_TIME	50	5335.87	0.9849	1.0092	1053	100
TEST_TIME	51	5344.46	0.9879	1.0129	1367	100
TEST_TIME	52	5369.25	0.9888	1.0112	1313	100
TEST_TIME	53	5374.63	0.9914	1.0069	1400	100
TEST_TIME	54	5355.72	0.9918	1.0083	1334	100
TEST_TIME	55	5355.95	0.9899	1.0118	1200	100
TEST_TIME	56	5368.46	0.9914	1.0082	1065	100
TEST_TIME	57	5357.97	0.9924	1.0072	1208	100
TEST_TIME	58	5359.44	0.9896	1.0105	1048	100
TEST_TIME	59	5363.84	0.9926	1.0083	1105	100
TEST_TIME	60	5372.29	0.9900	1.0097	1092	100
TEST_TIME	61	5405.37	0.9871	1.0145	1605	100
TEST_TIME	62	5451.67	0.9897	1.0090	1565	100
TEST_TIME	63	5470.18	0.9896	1.0085	1393	100
TEST_TIME	64	5476.24	0.9916	1.0088	1447	100
TEST_TIME	65	5496.47	0.9896	1.0092	1206	100
TEST_TIME	66	5502.64	0.9928	1.0074	1294	100
TEST_TIME	67	5520.27	0.9892	1.0097	1187	100
TEST_TIME	68	5542.62	0.9908	1.0072	1290	100
TEST_TIME	69	5545.10	0.9931	1.0058	1171	100
TEST_TIME	70	5537.90	0.9928	1.0069	1185	100
TEST_TIME	71	5532.42	0.9937	1.0053	1155	100
TEST_TIME	72	5519.30	0.9937	1.0083	1084	100
TEST_TIME	73	5513.31	0.9956	1.0051	1011	100
TEST_TIME	74	5481.90	0.9973	1.0028	1086	100
TEST_TIME	75	5492.56	0.9928	1.0063	1279	99
TEST_TIME	76	5504.81	0.9908	1.0088	1593	100
TEST_TIME	77	5537.11	0.9899	1.0076	1540	100
TEST_TIME	78	5557.01	0.9911	1.0080	1496	100
TEST_TIME	79	5564.41	0.9939	1.0062	1246	100
TEST_TIME	80	5565.94	0.9934	1.0060	1238	100
TEST_TIME	81	5565.18	0.9937	1.0066	1377	100
TEST_TIME	82	5563.13	0.9947	1.0063	1391	100
TEST_TIME	83	5559.94	0.9947	1.0056	1449	100
TEST_TIME	84	5551.77	0.9951	1.0051	1239	100
TEST_TIME	85	5560.60	0.9917	1.0037	1091	100
TEST_TIME	86	5548.16	0.9943	1.0052	1187	100
TEST_TIME	87	5539.13	0.9953	1.0054	1262	100
TEST_TIME	88	5535.87	0.9946	1.0057	1218	100
TEST_TIME	89	5532.39	0.9951	1.0046	1076	100
TEST_TIME	90	5533.70	0.9932	1.0075	1736	100
TEST_TIME	91	5550.61	0.9933	1.0085	1420	100
TEST_TIME	92	5574.38	0.9933	1.0064	1554	100
TEST_TIME	93	5596.78	0.9916	1.0075	1517	100
TEST_TIME	94	5612.36	0.9941	1.0057	1452	100
TEST_TIME	95	5609.04	0.9961	1.0031	1492	100
TEST_TIME	96	5594.88	0.9952	1.0053	1205	81
TEST_TIME	97	5589.19	0.9959	1.0043	1085	100
TEST_TIME	98	5586.09	0.9946	1.0061	1139	100
TEST_TIME	99	5585.10	0.9961	1.0043	1309	100
TEST_TIME	100	5598.00	0.9920	1.0072	1124	100
TEST_TIME	101	5601.39	0.9966	1.0045	1072	100
TEST_TIME	102	5596.63	0.9956	1.0039	1042	100
TEST_TIME	103	5590.09	0.9953	1.0052	1038	100
TEST_TIME	104	5586.37	0.9962	1.0039	1058	100
TEST_TIME	105	5590.77	0.9936	1.0063	1563	100
TEST_TIME	106	5609.07	0.9935	1.0069	1399	100
TEST_TIME	107	5625.71	0.9945	1.0062	1303	100
TEST_TIME	108	5645.61	0.9934	1.0052	1380	100
TEST_TIME	109	5658.74	0.9938	1.0049	1431	100
TEST_TIME	110	5666.08	0.9945	1.0042	1370	100
TEST_TIME	111	5670.01	0.9944	1.0079	1200	100
TEST_TIME	112	5695.69	0.9944	1.0054	1123	100
TEST_TIME	113	5702.91	0.9953	1.0046	1290	100
TEST_TIME	114	5708.09	0.9949	1.0056	1060	100
TEST_TIME	115	5710.87	0.9963	1.0036	1104	100
TEST_TIME	116	5714.81	0.9943	1.0036	1012	100
TEST_TIME	117	5714.98	0.9950	1.0032	945	100
TEST_TIME	118	5716.43	0.9945	1.0028	916	100
TEST_TIME	119	5699.38	0.9974	1.0023	1021	100
TEST_TIME	120	5703.74	0.9932	1.0050	1391	100
TEST_TIME	121	5715.09	0.9947	1.0044	1443	100
TEST_TIME	122	5717.30	0.9958	1.0027	1424	90
TEST_TIME	123	5715.68	0.9948	1.0036	1232	63
TEST_TIME	124	5731.23	0.9961	1.0038	1070	100
TEST_TIME	125	5731.15	0.9958	1.0035	1413	100
TEST_TIME	126	5732.21	0.9953	1.0039	1338	100
TEST_TIME	127	5724.84	0.9972	1.0031	1287	100
TEST_TIME	128	5719.72	0.9961	1.0043	1249	100
TEST_TIME	129	5719.88	0.9965	1.0037	1172	100
TEST_TIME	130	5721.86	0.9957	1.0043	1148	100
TEST_TIME	131	5727.40	0.9957	1.0049	1010	100
TEST_TIME	132	5730.89	0.9969	1.0032	928	100
TEST_TIME	133	5723.31	0.9969	1.0029	1040	100
TEST_TIME	134	5723.56	0.9953	1.0039	988	100
TEST_TIME	135	5731.19	0.9952	1.0039	1523	100
TEST_TIME	136	5751.68	0.9930	1.0044	1497	100
TEST_TIME	137	5763.84	0.9950	1.0045	1275	100
TEST_TIME	138	5777.07	0.9949	1.0023	1299	100
TEST_TIME	139	5775.25	0.9954	1.0049	1264	100
TEST_TIME	140	5791.89	0.9949	1.0028	1317	100
TEST_TIME	141	5773.72	0.9988	1.0017	1281	93
TEST_TIME	142	5779.59	0.9937	1.0045	980	100
TEST_TIME	143	5775.37	0.9982	1.0013	1239	100
TEST_TIME	144	5754.16	0.9980	1.0056	1161	89
TEST_TIME	145	5765.68	0.9967	1.0023	1035	100
TEST_TIME	146	5762.01	0.9963	1.0027	1122	100
TEST_TIME	147	5752.05	0.9976	1.0014	1146	100
TEST_TIME	148	5734.52	0.9976	1.0044	989	93
TEST_TIME	149	5730.53	0.9983	1.0022	1014	94
TEST_TIME	150	5727.69	0.9960	1.0025	1336	98
TEST_TIME	151	5730.15	0.9954	1.0038	1422	99
TEST_TIME	152	5734.15	0.9965	1.0049	1212	100
TEST_TIME	153	5743.75	0.9966	1.0035	1257	100
TEST_TIME	154	5755.78	0.9949	1.0041	1172	100
TEST_TIME	155	5766.84	0.9957	1.0031	1209	100
TEST_TIME	156	5763.27	0.9973	1.0039	1292	100
TEST_TIME	157	5766.86	0.9969	1.0039	1201	100
TEST_TIME	158	5771.85	0.9967	1.0043	978	100
TEST_TIME	159	5777.64	0.9971	1.0025	976	100
TEST_TIME	160	5773.16	0.9970	1.0022	1116	100
TEST_TIME	161	5777.18	0.9953	1.0041	1026	100
TEST_TIME	162	5777.13	0.9979	1.0022	903	100
TEST_TIME	163	5772.70	0.9968	1.0029	919	100
TEST_TIME	164	5770.21	0.9973	1.0029	1044	100
TEST_TIME	165	5769.91	0.9969	1.0066	1341	100
TEST_TIME	166	5791.52	0.9969	1.0039	1326	100
TEST_TIME	167	5803.95	0.9957	1.0030	1292	100
TEST_TIME	168	5802.46	0.9973	1.0025	1321	100
TEST_TIME	169	5799.01	0.9973	1.0018	1446	99
TEST_TIME	170	5783.72	0.9986	1.0023	1373	93
TEST_TIME	171	5781.68	0.9970	1.0019	1276	89
TEST_TIME	172	5770.68	0.9979	1.0014	1226	99
TEST_TIME	173	5758.71	0.9978	1.0016	1238	98
TEST_TIME	174	5749.39	0.9975	1.0017	1133	89
TEST_TIME	175	5744.84	0.9968	1.0041	1033	77
TEST_TIME	176	5742.86	0.9987	1.0016	1147	72
TEST_TIME	177	5741.30	0.9962	1.0025	888	84
TEST_TIME	178	5744.06	0.9964	1.0022	901	100
TEST_TIME	179	5744.15	0.9966	1.0029	892	100
TEST_TIME	180	5746.59	0.9969	1.0023	1239	100

Done for 10320 ms, from 6:57:50.23 to 6:58:00.55.

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	70003	75942	63915	56554	65328	31053	72878	78280	51106	50532	84776	71978	88280	57817	137511	49545	278797	267007	<null>	03:46:50	04:04:49
fetches per second	2	70057	49135	46513	<null>	60301	29714	67250	93958	69392	89455	69287	49946	73265	37510	172852	87500	71001	470769	<null>	04:04:50	04:22:49
fetches per second	3	65755	64069	33590	<null>	50137	<null>	82182	94980	42577	69097	61859	10180	89252	17736	102011	34336	23957	138517	<null>	04:22:50	04:40:49
fetches per second	4	73086	84782	65970	<null>	55560	114252	57032	<null>	68713	15771	104252	25830	115512	129107	102717	121500	124267	609250	<null>	04:40:50	04:58:49
fetches per second	5	67218	159709	46310	91649	55680	<null>	69818	65161	43108	26207	81317	18000	99991	91033	103729	91166	24517	246000	<null>	04:58:50	05:16:49
fetches per second	6	49024	57629	30854	<null>	64405	<null>	75636	72838	39981	59700	69466	3838	103042	<null>	54874	6740	111129	275600	<null>	05:16:50	05:34:49
fetches per second	7	53315	33385	48948	63965	47447	<null>	76275	58586	49354	24774	81663	27754	84423	43177	100798	83700	<null>	213500	<null>	05:34:50	05:52:49
fetches per second	8	56745	116873	34956	<null>	47116	<null>	49223	<null>	36453	<null>	76383	9186	63431	23458	74036	<null>	20943	257000	<null>	05:52:50	06:10:49
fetches per second	9	36525	57921	37370	<null>	36802	85775	47210	57401	25506	102125	53589	14796	67274	31892	78967	<null>	96583	280063	<null>	06:10:50	06:28:49
fetches per second	10	36773	56400	23062	<null>	37379	2375	23283	<null>	18331	11459	58595	2419	54148	33312	52165	20428	186710	173415	<null>	06:28:50	06:46:49
marks per second	1	15977	11354	14338	9755	15351	7166	9245	14483	5336	12626	14972	14881	6998	14588	5546	12545	15647	27282	<null>	03:46:50	04:04:49
marks per second	2	15442	7030	11052	<null>	14116	7461	10811	18221	8553	20661	10895	11970	7513	8544	8984	19812	14180	66630	<null>	04:04:50	04:22:49
marks per second	3	14493	11417	7806	<null>	11324	<null>	11295	17634	8760	15729	8922	2205	8521	4921	7424	8565	2076	13788	<null>	04:22:50	04:40:49
marks per second	4	16197	12326	15405	<null>	13152	32241	8404	<null>	12720	3403	12274	5100	5693	35589	10184	34500	23796	59125	<null>	04:40:50	04:58:49
marks per second	5	14434	23691	10806	16413	12787	<null>	8980	12409	9045	5624	9824	3980	6829	26222	16787	22833	4768	34800	<null>	04:58:50	05:16:49
marks per second	6	10997	8554	6715	<null>	14577	<null>	9571	13762	6197	13063	9669	876	6106	<null>	9845	1666	13270	30600	<null>	05:16:50	05:34:49
marks per second	7	11924	5086	11206	11653	10941	<null>	9932	11536	9258	5322	10616	5226	5479	9594	17775	25000	<null>	11750	<null>	05:34:50	05:52:49
marks per second	8	12215	16716	7428	<null>	10755	<null>	7276	<null>	5550	<null>	7872	2041	3253	5297	12565	<null>	1271	26500	<null>	05:52:50	06:10:49
marks per second	9	7835	8245	8495	<null>	8193	18982	6123	11516	6082	22500	5314	2442	3157	7438	10547	<null>	9838	37804	<null>	06:10:50	06:28:49
marks per second	10	8001	8892	5112	<null>	7870	679	2657	<null>	3857	2564	6593	547	2392	7408	6590	5755	12942	10729	<null>	06:28:50	06:46:49
reads/fetches*100	1	0	1	0	0	0	1	0	0	2	0	0	0	0	0	0	0	0	0	<null>	03:46:50	04:04:49
reads/fetches*100	2	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	04:04:50	04:22:49
reads/fetches*100	3	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	<null>	04:22:50	04:40:49
reads/fetches*100	4	0	0	0	<null>	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	04:40:50	04:58:49
reads/fetches*100	5	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	<null>	04:58:50	05:16:49
reads/fetches*100	6	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	<null>	0	0	0	0	<null>	05:16:50	05:34:49
reads/fetches*100	7	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	0	<null>	05:34:50	05:52:49
reads/fetches*100	8	0	0	0	<null>	0	<null>	0	<null>	0	<null>	0	0	0	0	0	<null>	0	0	<null>	05:52:50	06:10:49
reads/fetches*100	9	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	<null>	0	0	<null>	06:10:50	06:28:49
reads/fetches*100	10	0	0	0	<null>	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	06:28:50	06:46:49
writes/marks*100	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	4	0	<null>	03:46:50	04:04:49
writes/marks*100	2	0	0	0	<null>	0	0	0	0	1	0	0	0	0	1	0	0	4	0	<null>	04:04:50	04:22:49
writes/marks*100	3	0	0	0	<null>	0	<null>	0	0	1	1	0	0	0	1	0	0	6	0	<null>	04:22:50	04:40:49
writes/marks*100	4	0	0	0	<null>	0	0	0	<null>	1	2	0	0	0	0	0	0	0	1	<null>	04:40:50	04:58:49
writes/marks*100	5	0	0	0	0	0	<null>	0	0	1	1	0	0	0	0	1	1	11	0	<null>	04:58:50	05:16:49
writes/marks*100	6	0	0	0	<null>	0	<null>	0	0	1	1	0	0	0	<null>	0	0	2	1	<null>	05:16:50	05:34:49
writes/marks*100	7	0	0	1	0	0	<null>	1	0	0	1	0	0	0	0	0	0	<null>	0	<null>	05:34:50	05:52:49
writes/marks*100	8	0	0	0	<null>	0	<null>	0	<null>	1	<null>	0	1	1	1	0	<null>	6	0	<null>	05:52:50	06:10:49
writes/marks*100	9	0	0	0	<null>	0	0	0	0	0	1	0	0	0	0	0	<null>	5	0	<null>	06:10:50	06:28:49
writes/marks*100	10	0	0	0	<null>	0	0	0	<null>	1	0	0	0	0	1	0	0	1	1	<null>	06:28:50	06:46:49

Done for 9820 ms, from 6:58:01.82 to 6:58:11.64.

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	1846045	1660939	185106	10.02	0	7519	14	185106	2018-08-02 03:46	2018-08-02 06:46
doc_list_biud	1846403	1660939	185464	10.04	0	7613	6	185464	2018-08-02 03:46	2018-08-02 06:46
sp_add_invoice_to_stock	16582	10045	6537	39.42	15	94427	3697	6537	2018-08-02 03:46	2018-08-02 06:46
sp_cancel_adding_invoice	4328	3319	1009	23.31	0	52276	898	1009	2018-08-02 03:46	2018-08-02 06:46
sp_cancel_client_order	5699	5588	111	1.94	0	1903	93	111	2018-08-02 03:46	2018-08-02 06:46
sp_cancel_customer_reserve	395487	219328	176159	44.54	0	2698	21	176159	2018-08-02 03:46	2018-08-02 06:46
sp_cancel_pay_from_customer	2180	2169	11	0.50	0	1107	53	11	2018-08-02 03:46	2018-08-02 06:46
sp_cancel_pay_to_supplier	1285	1279	6	0.46	0	1482	50	6	2018-08-02 03:46	2018-08-02 06:46
sp_cancel_supplier_invoice	9283	7464	1819	19.59	0	8331	174	1819	2018-08-02 03:46	2018-08-02 06:46
sp_cancel_supplier_order	1331	502	829	62.28	0	194611	8670	829	2018-08-02 03:46	2018-08-02 06:46
sp_cancel_write_off	23368	16297	7071	30.25	0	3245	55	7071	2018-08-02 03:46	2018-08-02 06:46
sp_client_order	68220	68220	0	0.00	0	5819	171	0	2018-08-02 03:46	2018-08-02 06:46
sp_customer_reserve	589495	589495	0	0.00	0	5585	50	0	2018-08-02 03:46	2018-08-02 06:46
sp_fill_shopping_cart	103528	103287	241	0.23	0	3650	39	0	2018-08-02 03:46	2018-08-02 06:46
sp_fill_shopping_cart_clo_res	589495	589495	0	0.00	0	2246	3	0	2018-08-02 03:46	2018-08-02 06:46
sp_get_clo_for_invoice	10045	10045	0	0.00	0	4337	126	0	2018-08-02 03:46	2018-08-02 06:46
sp_kill_cost_storno	30821	23064	7757	25.16	0	1342	6	7757	2018-08-02 03:46	2018-08-02 06:46
sp_kill_qstorno_ret_qs2qd	823415	462919	360496	43.78	0	7597	8	360496	2018-08-02 03:46	2018-08-02 06:46
sp_kill_qty_storno	479302	293901	185401	38.68	0	7597	24	185401	2018-08-02 03:46	2018-08-02 06:46
sp_lock_selected_doc	67169	58223	8946	13.31	0	951	3	8946	2018-08-02 03:46	2018-08-02 06:46
sp_make_cost_storno	83035	83035	0	0.00	0	7285	125	0	2018-08-02 03:46	2018-08-02 06:46
sp_multiply_rows_for_pdistr	83035	83035	0	0.00	0	2293	17	0	2018-08-02 03:46	2018-08-02 06:46
sp_multiply_rows_for_qdistr	68220	68220	0	0.00	0	5039	54	0	2018-08-02 03:46	2018-08-02 06:46
sp_pay_from_customer	22761	22761	0	0.00	0	7504	282	0	2018-08-02 03:46	2018-08-02 06:46
sp_pay_to_supplier	18871	18871	0	0.00	0	7113	185	0	2018-08-02 03:46	2018-08-02 06:46
sp_payment_common	41632	41632	0	0.00	0	2028	27	0	2018-08-02 03:46	2018-08-02 06:46
sp_qd_handle_on_cancel_clo	5698	5588	110	1.93	0	1684	38	110	2018-08-02 03:46	2018-08-02 06:46
sp_qd_handle_on_invoice_upd_sts	14224	13364	860	6.04	0	4961	140	860	2018-08-02 03:46	2018-08-02 06:46
sp_qd_handle_on_reserve_upd_sts	31358	31358	0	0.00	0	1389	17	0	2018-08-02 03:46	2018-08-02 06:46
sp_reserve_write_off	32050	31358	692	2.15	0	8580	192	692	2018-08-02 03:46	2018-08-02 06:46
sp_supplier_invoice	17704	17627	77	0.43	0	23744	997	0	2018-08-02 03:46	2018-08-02 06:46
sp_supplier_order	17604	17440	164	0.93	0	12667	672	0	2018-08-02 03:46	2018-08-02 06:46
srv_find_qd_qs_mism	1140003	954880	185123	16.23	0	4024	8	185123	2018-08-02 03:46	2018-08-02 06:46
srv_make_invnt_saldo	2499	2499	0	0.00	15	17893	786	0	2018-08-02 03:46	2018-08-02 06:46
srv_make_money_saldo	2525	2525	0	0.00	0	1389	28	0	2018-08-02 03:46	2018-08-02 06:46
srv_recalc_idx_stat	14	14	0	0.00	2184	21981	4546	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_add_invoice_to_stock	6537	6537	0	0.00	0	1965	24	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_cancel_adding_invoice	536	536	0	0.00	0	1341	47	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_cancel_client_order	111	111	0	0.00	0	874	35	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_cancel_customer_reserve	47	47	0	0.00	0	453	32	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_cancel_pay_from_customer	11	11	0	0.00	0	109	12	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_cancel_pay_to_supplier	6	6	0	0.00	0	15	2	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_cancel_supplier_invoice	501	501	0	0.00	0	905	23	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_cancel_supplier_order	21030	21030	0	0.00	0	2901	34	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_cancel_write_off	22	22	0	0.00	0	172	17	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_reserve_write_off	692	692	0	0.00	0	718	13	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_supplier_invoice	77	77	0	0.00	0	437	53	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-abend:sp_supplier_order	164	164	0	0.00	0	484	13	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_add_invoice_to_stock	10045	10045	0	0.00	0	9906	246	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_cancel_adding_invoice	1087	1087	0	0.00	0	5210	261	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_cancel_client_order	5588	5588	0	0.00	0	1685	17	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_cancel_customer_reserve	2107	2107	0	0.00	0	1108	15	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_cancel_pay_from_customer	2169	2169	0	0.00	0	1201	12	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_cancel_pay_to_supplier	1279	1279	0	0.00	0	1232	11	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_cancel_supplier_invoice	824	824	0	0.00	0	640	14	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_cancel_supplier_order	502	502	0	0.00	0	23618	931	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_cancel_write_off	3264	3264	0	0.00	0	1248	18	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_client_order	68220	68220	0	0.00	0	2246	20	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_customer_reserve	3117	3117	0	0.00	0	936	14	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_pay_from_customer	22761	22761	0	0.00	0	1982	16	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_pay_to_supplier	18871	18871	0	0.00	0	1545	14	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_reserve_write_off	31358	31358	0	0.00	0	2168	18	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_supplier_invoice	17627	17627	0	0.00	0	1700	17	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:sp_supplier_order	17440	17440	0	0.00	0	2137	18	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:srv_make_invnt_saldo	2499	2499	0	0.00	0	795	5	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:srv_make_money_saldo	2525	2525	0	0.00	0	843	8	0	2018-08-02 03:46	2018-08-02 06:46
t$perf-norm:srv_recalc_idx_stat	14	14	0	0.00	0	31	10	0	2018-08-02 03:46	2018-08-02 06:46
v_add_invoice_to_stock	33164	20090	13074	39.42	0	1217	7	13074	2018-08-02 03:46	2018-08-02 06:46
v_all_customers	102582	102582	0	0.00	0	904	2	0	2018-08-02 03:46	2018-08-02 06:46
v_all_suppliers	74108	73626	482	0.65	0	843	2	0	2018-08-02 03:46	2018-08-02 06:46
v_all_wares	136440	136440	0	0.00	0	717	2	0	2018-08-02 03:46	2018-08-02 06:46
v_cancel_adding_invoice	2554	2174	380	14.87	0	2559	64	380	2018-08-02 03:46	2018-08-02 06:46
v_cancel_client_order	11398	11176	222	1.94	0	265	2	222	2018-08-02 03:46	2018-08-02 06:46
v_cancel_customer_prepayment	4360	4338	22	0.50	0	327	3	22	2018-08-02 03:46	2018-08-02 06:46
v_cancel_customer_reserve	4308	4214	94	2.18	0	249	3	94	2018-08-02 03:46	2018-08-02 06:46
v_cancel_payment_to_supplier	2570	2558	12	0.46	0	952	3	12	2018-08-02 03:46	2018-08-02 06:46
v_cancel_supplier_invoice	2650	1648	1002	37.81	0	1310	8	1002	2018-08-02 03:46	2018-08-02 06:46
v_cancel_supplier_order	2662	1004	1658	62.28	0	250	3	1658	2018-08-02 03:46	2018-08-02 06:46
v_cancel_write_off	6572	6528	44	0.66	0	2684	49	44	2018-08-02 03:46	2018-08-02 06:46
v_max_id_clo_ord	17604	17440	164	0.93	0	452	2	0	2018-08-02 03:46	2018-08-02 06:46
v_max_id_clo_res	3117	3117	0	0.00	0	374	6	0	2018-08-02 03:46	2018-08-02 06:46
v_max_id_ord_sup	17704	17627	77	0.43	0	390	2	0	2018-08-02 03:46	2018-08-02 06:46
v_max_non_paid_invoice	17125	17125	0	0.00	0	904	2	0	2018-08-02 03:46	2018-08-02 06:46
v_max_non_paid_realizn	22761	22761	0	0.00	0	577	2	0	2018-08-02 03:46	2018-08-02 06:46
v_min_id_clo_ord	17604	17440	164	0.93	0	609	2	0	2018-08-02 03:46	2018-08-02 06:46
v_min_id_clo_res	3117	3117	0	0.00	0	515	4	0	2018-08-02 03:46	2018-08-02 06:46
v_min_id_ord_sup	17704	17627	77	0.43	0	1061	3	0	2018-08-02 03:46	2018-08-02 06:46
v_min_non_paid_invoice	18871	18871	0	0.00	0	1747	4	0	2018-08-02 03:46	2018-08-02 06:46
v_min_non_paid_realizn	22761	22761	0	0.00	0	1310	3	0	2018-08-02 03:46	2018-08-02 06:46
v_our_firm	33858	33858	0	0.00	0	920	3	0	2018-08-02 03:46	2018-08-02 06:46
v_reserve_write_off	64100	62716	1384	2.15	0	842	3	1384	2018-08-02 03:46	2018-08-02 06:46
x_lock_depdocs_on_canc_invoice	18725	9959	8766	46.81	0	1264	11	8766	2018-08-02 03:46	2018-08-02 06:46
x_lock_depdocs_on_canc_sup_ord	1330	502	828	62.25	0	687	18	828	2018-08-02 03:46	2018-08-02 06:46
x_make_qstorno_1000_1200	17604	17440	164	0.93	0	12246	583	0	2018-08-02 03:46	2018-08-02 06:46
x_make_qstorno_1200_2000	17704	17627	77	0.43	0	22465	907	0	2018-08-02 03:46	2018-08-02 06:46
x_make_qstorno_2100_3300	589495	589495	0	0.00	0	5024	41	0	2018-08-02 03:46	2018-08-02 06:46

Done for 337120 ms, from 7:03:37.18 to 7:09:14.30.

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	51	sp_kill_cost_storno	335544336	2018-08-02 03:47	2018-08-02 06:33
deadlock	58	sp_kill_qstorno_ret_qs2qd	335544336	2018-08-02 03:51	2018-08-02 06:43
deadlock	7808	sp_lock_selected_doc	335544336	2018-08-02 03:47	2018-08-02 06:46
deadlock	110	sp_qd_handle_on_cancel_clo	335544336	2018-08-02 03:49	2018-08-02 06:40
deadlock	168	sp_qd_handle_on_invoice_upd_sts	335544336	2018-08-02 03:48	2018-08-02 06:46
deadlock	595	x_lock_depdocs_on_canc_invoice	335544336	2018-08-02 03:47	2018-08-02 06:46
deadlock	149	x_lock_depdocs_on_canc_sup_ord	335544336	2018-08-02 03:55	2018-08-02 06:39
user_exc	164	x_make_qstorno_1000_1200	335544517	2018-08-02 03:47	2018-08-02 06:44
user_exc	77	x_make_qstorno_1200_2000	335544517	2018-08-02 03:48	2018-08-02 06:38

Done for 11790 ms, from 7:09:24.36 to 7:09:36.15.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 848429
MON$OLDEST_ACTIVE 848430
MON$OLDEST_SNAPSHOT 848430
MON$NEXT_TRANSACTION 848430
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:12:20.4040
MON$PAGES 754336
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.4.33020 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.4.33020 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.4.33020 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.4.33020 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0

Database statistics, full

Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Gstat execution time Thu Aug 02 07:09:36 2018

Database header page information:
Flags 0
Generation 848536
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 848431
Oldest active 848432
Oldest snapshot 848432
Next transaction 848433
Sequence number 0
Next attachment ID 9388
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:12:20
Attributes force write

Variable header data:
Sweep interval: 0
*END*

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

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, 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.24
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: 322, 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: 324, 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: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, 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: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
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: 320, 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: 332, Index root page: 333
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: 336, 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: 337, 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: 335, 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: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 46.98, total records: 1939786
Average version length: 47.61, total versions: 1185, 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: 13, data page slots: 20848
Data pages: 20848, average fill: 73%
Primary pages: 20848, secondary pages: 0, swept pages: 11650
Empty pages: 1, full pages: 20438
Fill distribution:
0 - 19% = 2
20 - 39% = 9
40 - 59% = 47
60 - 79% = 20788
80 - 99% = 2

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 9292, nodes: 1939786
Average node length: 19.22, total dup: 0, max dup: 0
Average key length: 16.27, compression ratio: 1.66
Average prefix length: 13.73, average data length: 13.27
Clustering factor: 276653, ratio: 0.14
Fill distribution:
0 - 19% = 790
20 - 39% = 2466
40 - 59% = 3188
60 - 79% = 1125
80 - 99% = 1723

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7005, nodes: 1939786
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.69, compression ratio: 1.04
Average prefix length: 3.31, average data length: 5.69
Clustering factor: 272466, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 3415
40 - 59% = 3455
60 - 79% = 123
80 - 99% = 12

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175569, depth: 3, leaf buckets: 3107, nodes: 1939786
Average node length: 6.77, total dup: 1426525, max dup: 49
Average key length: 3.82, compression ratio: 2.36
Average prefix length: 7.44, average data length: 1.56
Clustering factor: 246115, ratio: 0.13
Fill distribution:
0 - 19% = 124
20 - 39% = 973
40 - 59% = 915
60 - 79% = 464
80 - 99% = 631

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.41, total records: 572047
Average version length: 35.87, total versions: 344, max versions: 2
Average fragment length: 47.63, total fragments: 19, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7208
Data pages: 7208, average fill: 75%
Primary pages: 7203, secondary pages: 5, swept pages: 6686
Empty pages: 1, full pages: 7087
Fill distribution:
0 - 19% = 6
20 - 39% = 4
40 - 59% = 13
60 - 79% = 7177
80 - 99% = 8

Index DOC_LIST_ID_DESC (1)
Root page: 244298, depth: 3, leaf buckets: 2091, nodes: 572047
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.15, average data length: 5.85
Clustering factor: 116305, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 1119
40 - 59% = 900
60 - 79% = 67
80 - 99% = 5

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 590, nodes: 572047
Average node length: 4.86, total dup: 571997, max dup: 40208
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 260923, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 493
60 - 79% = 75
80 - 99% = 22

Index PK_DOC_LIST (0)
Root page: 333977, depth: 3, leaf buckets: 1415, nodes: 572047
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 116305, ratio: 0.20
Fill distribution:
0 - 19% = 89
20 - 39% = 224
40 - 59% = 399
60 - 79% = 346
80 - 99% = 357

DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
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: 318, 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: 319, 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: 317, 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: 338, Index root page: 339
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: 340, 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: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 64.76, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.04, total fragments: 343, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.61
Pointer pages: 1, data page slots: 32
Data pages: 20, average fill: 31%
Primary pages: 10, secondary pages: 10, swept pages: 4
Empty pages: 6, full pages: 3
Fill distribution:
0 - 19% = 9
20 - 39% = 6
40 - 59% = 1
60 - 79% = 1
80 - 99% = 3

Index PK_INVNT_SALDO (0)
Root page: 282, 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: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 25.66, total records: 1635
Average version length: 71.10, total versions: 1046, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 3.74
Pointer pages: 1, data page slots: 272
Data pages: 128, average fill: 18%
Primary pages: 127, secondary pages: 1, swept pages: 62
Empty pages: 55, full pages: 0
Fill distribution:
0 - 19% = 74
20 - 39% = 31
40 - 59% = 19
60 - 79% = 4
80 - 99% = 0

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 7, nodes: 1635
Average node length: 17.12, total dup: 23, max dup: 1
Average key length: 15.16, compression ratio: 1.78
Average prefix length: 14.83, average data length: 12.17
Clustering factor: 1312, ratio: 0.80
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 2
60 - 79% = 3
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 14.98, 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.14
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MONEY_SALDO (0)
Root page: 273, 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: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 29.84, total records: 96
Average version length: 45.82, total versions: 33, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 2.14
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 6%
Primary pages: 14, secondary pages: 2, swept pages: 8
Empty pages: 12, full pages: 0
Fill distribution:
0 - 19% = 13
20 - 39% = 3
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 715671, depth: 2, leaf buckets: 1, nodes: 96
Average node length: 9.25, total dup: 59, max dup: 16
Average key length: 8.13, compression ratio: 2.34
Average prefix length: 13.25, average data length: 5.75
Clustering factor: 51, ratio: 0.53
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (165)
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 MON_LOG_DTS (4)
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_GDSCODE (2)
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

Index MON_LOG_ROWSET_DESC (1)
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

Index MON_LOG_UNIT (3)
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 PK_MON_LOG (0)
Root page: 361, 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: 366, Index root page: 367
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: 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_GDSCODE (2)
Root page: 371, 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: 370, 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: 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

Index PK_MON_LOG_TABLE_STATS (0)
Root page: 369, 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: 239, Index root page: 240
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: 242, 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: 241, 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: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.57, total records: 138928
Average version length: 29.26, total versions: 733, max versions: 5
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.50
Pointer pages: 1, data page slots: 1600
Data pages: 1600, average fill: 65%
Primary pages: 1590, secondary pages: 10, swept pages: 1212
Empty pages: 13, full pages: 655
Fill distribution:
0 - 19% = 38
20 - 39% = 124
40 - 59% = 138
60 - 79% = 1299
80 - 99% = 1

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 124, nodes: 138928
Average node length: 4.25, total dup: 138879, max dup: 6918
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 24580, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 13
40 - 59% = 61
60 - 79% = 31
80 - 99% = 19

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 145, nodes: 138928
Average node length: 5.18, total dup: 125343, max dup: 60
Average key length: 2.95, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 33561, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 19
40 - 59% = 54
60 - 79% = 41
80 - 99% = 30

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 147, nodes: 138928
Average node length: 5.18, total dup: 125343, max dup: 60
Average key length: 2.95, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 33609, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 12
40 - 59% = 62
60 - 79% = 48
80 - 99% = 24

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 144, nodes: 138928
Average node length: 4.97, total dup: 125343, max dup: 60
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 33577, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 16
40 - 59% = 65
60 - 79% = 43
80 - 99% = 20

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 390898, depth: 2, leaf buckets: 176, nodes: 227094
Average node length: 4.44, total dup: 226913, max dup: 2241
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 23798, ratio: 0.10
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 49
60 - 79% = 72
80 - 99% = 54

PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
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: 346, 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: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.65, total records: 11420503
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.18
Pointer pages: 167, data page slots: 271120
Data pages: 271120, average fill: 87%
Primary pages: 271120, secondary pages: 0, swept pages: 3
Empty pages: 5, full pages: 271114
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 271114

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 13535, nodes: 11420503
Average node length: 5.65, total dup: 10578049, max dup: 153
Average key length: 2.18, compression ratio: 3.67
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 2199511, ratio: 0.19
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 9062
60 - 79% = 2905
80 - 99% = 1562

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11368, nodes: 11420503
Average node length: 4.59, total dup: 11420499, max dup: 10077785
Average key length: 1.12, compression ratio: 0.53
Average prefix length: 0.59, average data length: 0.00
Clustering factor: 323680, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11365
60 - 79% = 0
80 - 99% = 3

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 14279, nodes: 11420503
Average node length: 5.69, total dup: 11095038, max dup: 37703
Average key length: 2.21, compression ratio: 4.07
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 619444, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 11507
60 - 79% = 1567
80 - 99% = 1203

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 13823, nodes: 11420503
Average node length: 5.54, total dup: 11402195, max dup: 1743725
Average key length: 2.06, compression ratio: 18.39
Average prefix length: 37.88, average data length: 0.06
Clustering factor: 5211986, ratio: 0.46
Fill distribution:
0 - 19% = 17
20 - 39% = 2
40 - 59% = 12040
60 - 79% = 373
80 - 99% = 1391

PHRASES (145)
Primary pointer page: 266, Index root page: 267
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: 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

Index PHRASES_NAME (2)
Root page: 279, 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: 278, 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: 277, 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: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 55.09, total records: 446603
Average version length: 56.20, total versions: 378, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5280
Data pages: 5280, average fill: 75%
Primary pages: 5280, secondary pages: 0, swept pages: 3477
Empty pages: 3, full pages: 5127
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 14
60 - 79% = 5260
80 - 99% = 3

Index PSTORNED_RCV_ID (2)
Root page: 648275, depth: 3, leaf buckets: 565, nodes: 446603
Average node length: 5.80, total dup: 384813, max dup: 742
Average key length: 3.01, compression ratio: 2.99
Average prefix length: 8.12, average data length: 0.88
Clustering factor: 54413, ratio: 0.12
Fill distribution:
0 - 19% = 4
20 - 39% = 54
40 - 59% = 297
60 - 79% = 150
80 - 99% = 60

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 484, nodes: 446603
Average node length: 5.60, total dup: 398176, max dup: 117
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 105755, ratio: 0.24
Fill distribution:
0 - 19% = 3
20 - 39% = 12
40 - 59% = 205
60 - 79% = 185
80 - 99% = 79

RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
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: 308, 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: 243, Index root page: 244
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: 246, 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: 245, 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: 315, Index root page: 316
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: 327, 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: 328, 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: 236, Index root page: 237
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: 238, 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: 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$AUTOGEN$SOURCE (135)
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$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
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: 200, 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: 207, Index root page: 224
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: 226, 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: 227, Index root page: 228
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: 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$PERF_LOG (164)
Primary pointer page: 352, Index root page: 353
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: 360, 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: 205, Index root page: 206
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: 201, Index root page: 202
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: 204, 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: 203, 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: 193, Index root page: 194
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: 197, 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: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.76, total records: 2427
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.51
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 69%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 29
80 - 99% = 0

WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, 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.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
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: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, 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: 274, 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: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 276, 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: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
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: 325, 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: 326, 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: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 40.31, total records: 4773
Average version length: 72.18, total versions: 2111, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 488
Data pages: 208, average fill: 29%
Primary pages: 206, secondary pages: 2, swept pages: 94
Empty pages: 62, full pages: 41
Fill distribution:
0 - 19% = 105
20 - 39% = 40
40 - 59% = 18
60 - 79% = 31
80 - 99% = 14

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 12, nodes: 4773
Average node length: 7.03, total dup: 4123, max dup: 14
Average key length: 5.04, compression ratio: 7.35
Average prefix length: 34.10, average data length: 2.90
Clustering factor: 737, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 5
60 - 79% = 0
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.83, total records: 588725
Average version length: 71.71, total versions: 2862, 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: 6, data page slots: 9248
Data pages: 9232, average fill: 70%
Primary pages: 9232, secondary pages: 0, swept pages: 6155
Empty pages: 131, full pages: 6518
Fill distribution:
0 - 19% = 282
20 - 39% = 274
40 - 59% = 658
60 - 79% = 7993
80 - 99% = 25

Index XQD_1000_3300_DOC (1)
Root page: 656256, depth: 3, leaf buckets: 586, nodes: 588725
Average node length: 5.08, total dup: 571821, max dup: 119
Average key length: 2.21, compression ratio: 4.07
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 65744, ratio: 0.11
Fill distribution:
0 - 19% = 5
20 - 39% = 52
40 - 59% = 317
60 - 79% = 36
80 - 99% = 176

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 320092, depth: 3, leaf buckets: 810, nodes: 588725
Average node length: 6.20, total dup: 513516, max dup: 29
Average key length: 3.32, compression ratio: 11.13
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 114552, ratio: 0.19
Fill distribution:
0 - 19% = 29
20 - 39% = 149
40 - 59% = 329
60 - 79% = 159
80 - 99% = 144

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 65.24, total records: 65789
Average version length: 72.01, total versions: 6315, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.08
Pointer pages: 2, data page slots: 1880
Data pages: 1448, average fill: 52%
Primary pages: 1448, secondary pages: 0, swept pages: 951
Empty pages: 20, full pages: 265
Fill distribution:
0 - 19% = 103
20 - 39% = 294
40 - 59% = 472
60 - 79% = 511
80 - 99% = 68

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 106, nodes: 65789
Average node length: 5.67, total dup: 57521, max dup: 49
Average key length: 3.45, compression ratio: 10.72
Average prefix length: 35.67, average data length: 1.33
Clustering factor: 8480, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 45
40 - 59% = 47
60 - 79% = 14
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 71.13, total records: 1270532
Average version length: 71.28, total versions: 18462, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 13, data page slots: 20032
Data pages: 19912, average fill: 70%
Primary pages: 19912, secondary pages: 0, swept pages: 8165
Empty pages: 828, full pages: 15999
Fill distribution:
0 - 19% = 1117
20 - 39% = 691
40 - 59% = 1130
60 - 79% = 16668
80 - 99% = 306

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 197173, depth: 3, leaf buckets: 1968, nodes: 1270532
Average node length: 5.57, total dup: 1197665, max dup: 49
Average key length: 2.63, compression ratio: 14.07
Average prefix length: 36.43, average data length: 0.57
Clustering factor: 119318, ratio: 0.09
Fill distribution:
0 - 19% = 14
20 - 39% = 1000
40 - 59% = 622
60 - 79% = 158
80 - 99% = 174

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 8.20, total records: 2155
Average version length: 71.90, total versions: 1908, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 16.59
Pointer pages: 3, data page slots: 1120
Data pages: 264, average fill: 12%
Primary pages: 263, secondary pages: 1, swept pages: 138
Empty pages: 165, full pages: 17
Fill distribution:
0 - 19% = 219
20 - 39% = 18
40 - 59% = 4
60 - 79% = 10
80 - 99% = 13

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 5, nodes: 2155
Average node length: 7.46, total dup: 1849, max dup: 47
Average key length: 5.47, compression ratio: 6.76
Average prefix length: 33.66, average data length: 3.34
Clustering factor: 255, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 71.13, total records: 2550304
Average version length: 70.99, total versions: 7615, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 23, data page slots: 36048
Data pages: 36048, average fill: 77%
Primary pages: 36048, secondary pages: 0, swept pages: 25844
Empty pages: 40, full pages: 33924
Fill distribution:
0 - 19% = 99
20 - 39% = 124
40 - 59% = 518
60 - 79% = 35075
80 - 99% = 232

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5148, nodes: 2550304
Average node length: 6.84, total dup: 2071493, max dup: 14
Average key length: 3.87, compression ratio: 9.56
Average prefix length: 35.32, average data length: 1.68
Clustering factor: 408952, ratio: 0.16
Fill distribution:
0 - 19% = 3
20 - 39% = 2631
40 - 59% = 1992
60 - 79% = 345
80 - 99% = 177

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.29, total records: 4166851
Average version length: 83.68, total versions: 307, 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: 40, data page slots: 63808
Data pages: 63808, average fill: 80%
Primary pages: 63808, secondary pages: 0, swept pages: 21843
Empty pages: 4, full pages: 63725
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 2
60 - 79% = 18406
80 - 99% = 45396

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4461, nodes: 4166851
Average node length: 5.16, total dup: 4071771, max dup: 123
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 613892, ratio: 0.15
Fill distribution:
0 - 19% = 18
20 - 39% = 78
40 - 59% = 2349
60 - 79% = 1755
80 - 99% = 261

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 3786, nodes: 4166851
Average node length: 5.73, total dup: 3707715, max dup: 49
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 124964, ratio: 0.03
Fill distribution:
0 - 19% = 20
20 - 39% = 66
40 - 59% = 1115
60 - 79% = 228
80 - 99% = 2357

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 4971, nodes: 4166851
Average node length: 5.81, total dup: 3644992, max dup: 14
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 669115, ratio: 0.16
Fill distribution:
0 - 19% = 23
20 - 39% = 92
40 - 59% = 2494
60 - 79% = 1997
80 - 99% = 365

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 83.06, total records: 2558146
Average version length: 83.42, total versions: 6337, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 25, data page slots: 39944
Data pages: 39944, average fill: 79%
Primary pages: 39944, secondary pages: 0, swept pages: 28676
Empty pages: 51, full pages: 38242
Fill distribution:
0 - 19% = 101
20 - 39% = 129
40 - 59% = 407
60 - 79% = 14521
80 - 99% = 24786

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2708, nodes: 2558146
Average node length: 5.15, total dup: 2498204, max dup: 148
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 387133, ratio: 0.15
Fill distribution:
0 - 19% = 3
20 - 39% = 33
40 - 59% = 1565
60 - 79% = 827
80 - 99% = 280

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 3988, nodes: 2558146
Average node length: 6.23, total dup: 2095447, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 191701, ratio: 0.07
Fill distribution:
0 - 19% = 78
20 - 39% = 1407
40 - 59% = 1468
60 - 79% = 573
80 - 99% = 462

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 3089, nodes: 2558146
Average node length: 5.81, total dup: 2237192, max dup: 29
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 476700, ratio: 0.19
Fill distribution:
0 - 19% = 20
20 - 39% = 41
40 - 59% = 1821
60 - 79% = 904
80 - 99% = 303

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.36, total records: 4349877
Average version length: 83.84, total versions: 4959, 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: 42, data page slots: 68248
Data pages: 67904, average fill: 79%
Primary pages: 67904, secondary pages: 0, swept pages: 14259
Empty pages: 775, full pages: 64914
Fill distribution:
0 - 19% = 925
20 - 39% = 413
40 - 59% = 868
60 - 79% = 10965
80 - 99% = 54733

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 4472, nodes: 4349877
Average node length: 5.04, total dup: 4324029, max dup: 658
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 604964, ratio: 0.14
Fill distribution:
0 - 19% = 6
20 - 39% = 146
40 - 59% = 2408
60 - 79% = 1399
80 - 99% = 513

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 4756, nodes: 4349877
Average node length: 5.54, total dup: 3998114, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 127547, ratio: 0.03
Fill distribution:
0 - 19% = 100
20 - 39% = 983
40 - 59% = 1531
60 - 79% = 598
80 - 99% = 1544

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5059, nodes: 4349877
Average node length: 5.72, total dup: 3876597, max dup: 66
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 681561, ratio: 0.16
Fill distribution:
0 - 19% = 6
20 - 39% = 119
40 - 59% = 2743
60 - 79% = 1572
80 - 99% = 619

XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
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: 763, 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: 765, 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: 764, 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: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 83.12, total records: 3099730
Average version length: 83.46, total versions: 7129, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 30, data page slots: 48336
Data pages: 48336, average fill: 79%
Primary pages: 48336, secondary pages: 0, swept pages: 33884
Empty pages: 70, full pages: 46184
Fill distribution:
0 - 19% = 126
20 - 39% = 156
40 - 59% = 567
60 - 79% = 15444
80 - 99% = 32043

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3361, nodes: 3099730
Average node length: 5.02, total dup: 3084544, max dup: 1155
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 604917, ratio: 0.20
Fill distribution:
0 - 19% = 13
20 - 39% = 343
40 - 59% = 1810
60 - 79% = 815
80 - 99% = 380

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 4796, nodes: 3099730
Average node length: 6.23, total dup: 2541494, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 245624, ratio: 0.08
Fill distribution:
0 - 19% = 139
20 - 39% = 1651
40 - 59% = 1657
60 - 79% = 760
80 - 99% = 589

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3724, nodes: 3099730
Average node length: 5.60, total dup: 2819337, max dup: 64
Average key length: 2.62, compression ratio: 3.43
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 647034, ratio: 0.21
Fill distribution:
0 - 19% = 9
20 - 39% = 344
40 - 59% = 1999
60 - 79% = 944
80 - 99% = 428

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.39, total records: 550211
Average version length: 69.84, total versions: 299, 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: 7520
Data pages: 7520, average fill: 78%
Primary pages: 7520, secondary pages: 0, swept pages: 5157
Empty pages: 6, full pages: 7493
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 2
60 - 79% = 7503
80 - 99% = 9

Index XQS_3300_3400_DOC_ID (0)
Root page: 177003, depth: 3, leaf buckets: 693, nodes: 550211
Average node length: 5.28, total dup: 519415, max dup: 115
Average key length: 2.43, compression ratio: 3.71
Average prefix length: 8.63, average data length: 0.37
Clustering factor: 46238, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 204
40 - 59% = 276
60 - 79% = 146
80 - 99% = 64

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 776, nodes: 550211
Average node length: 5.89, total dup: 470611, max dup: 14
Average key length: 3.04, compression ratio: 2.96
Average prefix length: 8.10, average data length: 0.90
Clustering factor: 48551, ratio: 0.09
Fill distribution:
0 - 19% = 5
20 - 39% = 225
40 - 59% = 304
60 - 79% = 167
80 - 99% = 75

ZDOC_DATA (230)
Primary pointer page: 644, Index root page: 645
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: 642, Index root page: 643
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: 646, Index root page: 647
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: 652, Index root page: 653
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: 662, 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: 654, Index root page: 655
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: 663, 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: 648, Index root page: 649
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: 656, 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: 657, 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: 650, Index root page: 651
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: 659, 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: 658, 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: 661, 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: 660, 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: 640, Index root page: 641
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: 614, Index root page: 615
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: 268, Index root page: 269
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: 281, 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 Thu Aug 02 07:12:04 2018

Done for 147670 ms, from 7:09:36.53 to 7:12:04.20.

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	1939786	1185	0.0610
DOC_LIST	572047	344	0.0601
DOC_STATES	4	0	0.0000
FB_ERRORS	758	0	0.0000
INVNT_SALDO	400	0	0.0000
INVNT_TURNOVER_LOG	1635	1046	63.9755
MONEY_SALDO	49	0	0.0000
MONEY_TURNOVER_LOG	96	33	34.3750
OPTYPES	9	0	0.0000
PDISTR	138928	733	0.5276
PERF_ESTIMATED	227094	0	0.0000
PERF_LOG	11420503	0	0.0000
PSTORNED	446603	378	0.0846
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	2427	0	0.0000
WARES	400	0	0.0000
WARE_GROUPS	8	0	0.0000
XQD_1000_1200	4773	2111	44.2279
XQD_1000_3300	588725	2862	0.4861
XQD_1200_2000	65789	6315	9.5988
XQD_2000_3300	1270532	18462	1.4530
XQD_2100_3300	2155	1908	88.5382
XQD_3300_3400	2550304	7615	0.2985
XQS_1000_1200	4166851	307	0.0073
XQS_1000_3300	2558146	6337	0.2477
XQS_1200_2000	4349877	4959	0.1140
XQS_2100_3300	3099730	7129	0.2299
XQS_3300_3400	550211	299	0.0543
Z_USED_VIEWS	29	0	0.0000

Done for 2160 ms, from 7:12:14.59 to 7:12:16.75.

Database validation

07:12:16.88 Validation started

07:12:16.91 Relation 140 (DOC_LIST)
07:12:16.91 process pointer page 0 of 5
07:12:17.02 process pointer page 1 of 5
07:12:17.13 process pointer page 2 of 5
07:12:17.24 process pointer page 3 of 5
07:12:17.36 process pointer page 4 of 5
07:12:17.39 Index 1 (PK_DOC_LIST)
07:12:17.61 Index 2 (DOC_LIST_ID_DESC)
07:12:17.86 Index 3 (FK_DOC_LIST_AGENTS)
07:12:18.08 Relation 140 (DOC_LIST) is ok

07:12:18.08 Relation 141 (DOC_DATA)
07:12:18.08 process pointer page 0 of 13
07:12:18.19 process pointer page 1 of 13
07:12:18.28 process pointer page 2 of 13
07:12:18.38 process pointer page 3 of 13
07:12:18.49 process pointer page 4 of 13
07:12:18.58 process pointer page 5 of 13
07:12:18.67 process pointer page 6 of 13
07:12:18.77 process pointer page 7 of 13
07:12:18.86 process pointer page 8 of 13
07:12:18.95 process pointer page 9 of 13
07:12:19.05 process pointer page 10 of 13
07:12:19.14 process pointer page 11 of 13
07:12:19.23 process pointer page 12 of 13
07:12:19.31 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:12:20.09 Index 3 (DOC_DATA_ID_DESC)
07:12:20.78 Index 4 (FK_DOC_DATA_DOC_LIST)
07:12:21.22 Relation 141 (DOC_DATA) is ok

07:12:21.22 Relation 147 (INVNT_SALDO)
07:12:21.22 process pointer page 0 of 1
07:12:21.22 Index 1 (PK_INVNT_SALDO)
07:12:21.22 Relation 147 (INVNT_SALDO) is ok

07:12:21.22 Relation 150 (PDISTR)
07:12:21.23 process pointer page 0 of 1
07:12:21.29 Index 2 (PDISTR_SND_ID)
07:12:21.34 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:12:21.39 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:12:21.43 Index 5 (PDISTR_AGENT_ID)
07:12:21.46 Relation 150 (PDISTR) is ok

07:12:21.46 Relation 151 (PSTORNED)
07:12:21.46 process pointer page 0 of 4
07:12:21.57 process pointer page 1 of 4
07:12:21.67 process pointer page 2 of 4
07:12:21.76 process pointer page 3 of 4
07:12:21.79 Index 2 (PSTORNED_SND_ID)
07:12:21.92 Index 3 (PSTORNED_RCV_ID)
07:12:21.96 Relation 151 (PSTORNED) is ok

07:12:21.96 Relation 156 (SEMAPHORES)
07:12:21.96 process pointer page 0 of 1
07:12:21.96 Index 1 (PK_SEMAPHORES)
07:12:21.96 Index 2 (SEMAPHORES_TASK_UNQ)
07:12:21.96 Relation 156 (SEMAPHORES) is ok

07:12:21.96 Relation 157 (INVNT_TURNOVER_LOG)
07:12:21.96 process pointer page 0 of 1
07:12:21.96 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:12:21.96 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:12:21.96 Relation 160 (PERF_ESTIMATED)
07:12:21.96 process pointer page 0 of 2
07:12:22.00 process pointer page 1 of 2
07:12:22.01 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:12:22.03 Relation 160 (PERF_ESTIMATED) is ok

07:12:22.03 Relation 161 (PERF_ISQL_STAT)
07:12:22.03 process pointer page 0 of 1
07:12:22.03 Index 1 (PERF_ISQL_STAT_TRN)
07:12:22.03 Relation 161 (PERF_ISQL_STAT) is ok

07:12:22.03 Relation 162 (TRACE_STAT)
07:12:22.03 process pointer page 0 of 1
07:12:22.03 Relation 162 (TRACE_STAT) is ok

07:12:22.03 Relation 163 (PERF_LOG)
07:12:22.03 process pointer page 0 of 167
07:12:22.06 process pointer page 1 of 167
07:12:22.09 process pointer page 2 of 167
07:12:22.12 process pointer page 3 of 167
07:12:22.15 process pointer page 4 of 167
07:12:22.20 process pointer page 5 of 167
07:12:22.23 process pointer page 6 of 167
07:12:22.26 process pointer page 7 of 167
07:12:22.29 process pointer page 8 of 167
07:12:22.32 process pointer page 9 of 167
07:12:22.35 process pointer page 10 of 167
07:12:22.39 process pointer page 11 of 167
07:12:22.43 process pointer page 12 of 167
07:12:22.49 process pointer page 13 of 167
07:12:22.53 process pointer page 14 of 167
07:12:22.56 process pointer page 15 of 167
07:12:22.59 process pointer page 16 of 167
07:12:22.63 process pointer page 17 of 167
07:12:22.67 process pointer page 18 of 167
07:12:22.71 process pointer page 19 of 167
07:12:22.79 process pointer page 20 of 167
07:12:22.82 process pointer page 21 of 167
07:12:22.85 process pointer page 22 of 167
07:12:22.90 process pointer page 23 of 167
07:12:22.93 process pointer page 24 of 167
07:12:22.96 process pointer page 25 of 167
07:12:23.01 process pointer page 26 of 167
07:12:23.09 process pointer page 27 of 167
07:12:23.18 process pointer page 28 of 167
07:12:23.26 process pointer page 29 of 167
07:12:23.34 process pointer page 30 of 167
07:12:23.43 process pointer page 31 of 167
07:12:23.49 process pointer page 32 of 167
07:12:23.52 process pointer page 33 of 167
07:12:23.56 process pointer page 34 of 167
07:12:23.60 process pointer page 35 of 167
07:12:23.68 process pointer page 36 of 167
07:12:23.73 process pointer page 37 of 167
07:12:23.80 process pointer page 38 of 167
07:12:23.88 process pointer page 39 of 167
07:12:23.96 process pointer page 40 of 167
07:12:24.05 process pointer page 41 of 167
07:12:24.13 process pointer page 42 of 167
07:12:24.19 process pointer page 43 of 167
07:12:24.24 process pointer page 44 of 167
07:12:24.27 process pointer page 45 of 167
07:12:24.34 process pointer page 46 of 167
07:12:24.41 process pointer page 47 of 167
07:12:24.46 process pointer page 48 of 167
07:12:24.49 process pointer page 49 of 167
07:12:24.52 process pointer page 50 of 167
07:12:24.57 process pointer page 51 of 167
07:12:24.60 process pointer page 52 of 167
07:12:24.63 process pointer page 53 of 167
07:12:24.66 process pointer page 54 of 167
07:12:24.69 process pointer page 55 of 167
07:12:24.73 process pointer page 56 of 167
07:12:24.76 process pointer page 57 of 167
07:12:24.80 process pointer page 58 of 167
07:12:24.83 process pointer page 59 of 167
07:12:24.87 process pointer page 60 of 167
07:12:24.88 process pointer page 61 of 167
07:12:24.97 process pointer page 62 of 167
07:12:25.05 process pointer page 63 of 167
07:12:25.13 process pointer page 64 of 167
07:12:25.22 process pointer page 65 of 167
07:12:25.30 process pointer page 66 of 167
07:12:25.38 process pointer page 67 of 167
07:12:25.47 process pointer page 68 of 167
07:12:25.55 process pointer page 69 of 167
07:12:25.65 process pointer page 70 of 167
07:12:25.72 process pointer page 71 of 167
07:12:25.80 process pointer page 72 of 167
07:12:25.90 process pointer page 73 of 167
07:12:25.97 process pointer page 74 of 167
07:12:26.07 process pointer page 75 of 167
07:12:26.14 process pointer page 76 of 167
07:12:26.18 process pointer page 77 of 167
07:12:26.21 process pointer page 78 of 167
07:12:26.24 process pointer page 79 of 167
07:12:26.27 process pointer page 80 of 167
07:12:26.30 process pointer page 81 of 167
07:12:26.35 process pointer page 82 of 167
07:12:26.43 process pointer page 83 of 167
07:12:26.46 process pointer page 84 of 167
07:12:26.50 process pointer page 85 of 167
07:12:26.58 process pointer page 86 of 167
07:12:26.66 process pointer page 87 of 167
07:12:26.75 process pointer page 88 of 167
07:12:26.83 process pointer page 89 of 167
07:12:26.91 process pointer page 90 of 167
07:12:27.00 process pointer page 91 of 167
07:12:27.08 process pointer page 92 of 167
07:12:27.16 process pointer page 93 of 167
07:12:27.25 process pointer page 94 of 167
07:12:27.28 process pointer page 95 of 167
07:12:27.31 process pointer page 96 of 167
07:12:27.35 process pointer page 97 of 167
07:12:27.38 process pointer page 98 of 167
07:12:27.41 process pointer page 99 of 167
07:12:27.44 process pointer page 100 of 167
07:12:27.47 process pointer page 101 of 167
07:12:27.50 process pointer page 102 of 167
07:12:27.52 process pointer page 103 of 167
07:12:27.55 process pointer page 104 of 167
07:12:27.58 process pointer page 105 of 167
07:12:27.66 process pointer page 106 of 167
07:12:27.74 process pointer page 107 of 167
07:12:27.83 process pointer page 108 of 167
07:12:27.91 process pointer page 109 of 167
07:12:27.99 process pointer page 110 of 167
07:12:28.08 process pointer page 111 of 167
07:12:28.16 process pointer page 112 of 167
07:12:28.25 process pointer page 113 of 167
07:12:28.33 process pointer page 114 of 167
07:12:28.36 process pointer page 115 of 167
07:12:28.42 process pointer page 116 of 167
07:12:28.52 process pointer page 117 of 167
07:12:28.56 process pointer page 118 of 167
07:12:28.59 process pointer page 119 of 167
07:12:28.63 process pointer page 120 of 167
07:12:28.70 process pointer page 121 of 167
07:12:28.80 process pointer page 122 of 167
07:12:28.87 process pointer page 123 of 167
07:12:28.95 process pointer page 124 of 167
07:12:29.05 process pointer page 125 of 167
07:12:29.12 process pointer page 126 of 167
07:12:29.20 process pointer page 127 of 167
07:12:29.30 process pointer page 128 of 167
07:12:29.37 process pointer page 129 of 167
07:12:29.47 process pointer page 130 of 167
07:12:29.55 process pointer page 131 of 167
07:12:29.62 process pointer page 132 of 167
07:12:29.72 process pointer page 133 of 167
07:12:29.80 process pointer page 134 of 167
07:12:29.89 process pointer page 135 of 167
07:12:29.97 process pointer page 136 of 167
07:12:30.04 process pointer page 137 of 167
07:12:30.14 process pointer page 138 of 167
07:12:30.17 process pointer page 139 of 167
07:12:30.22 process pointer page 140 of 167
07:12:30.29 process pointer page 141 of 167
07:12:30.39 process pointer page 142 of 167
07:12:30.47 process pointer page 143 of 167
07:12:30.51 process pointer page 144 of 167
07:12:30.56 process pointer page 145 of 167
07:12:30.64 process pointer page 146 of 167
07:12:30.73 process pointer page 147 of 167
07:12:30.81 process pointer page 148 of 167
07:12:30.89 process pointer page 149 of 167
07:12:30.97 process pointer page 150 of 167
07:12:31.06 process pointer page 151 of 167
07:12:31.14 process pointer page 152 of 167
07:12:31.21 process pointer page 153 of 167
07:12:31.29 process pointer page 154 of 167
07:12:31.32 process pointer page 155 of 167
07:12:31.40 process pointer page 156 of 167
07:12:31.48 process pointer page 157 of 167
07:12:31.57 process pointer page 158 of 167
07:12:31.65 process pointer page 159 of 167
07:12:31.75 process pointer page 160 of 167
07:12:31.84 process pointer page 161 of 167
07:12:31.92 process pointer page 162 of 167
07:12:31.99 process pointer page 163 of 167
07:12:32.03 process pointer page 164 of 167
07:12:32.06 process pointer page 165 of 167
07:12:32.09 process pointer page 166 of 167
07:12:32.10 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:12:34.37 Index 2 (PERF_LOG_UNIT)
07:12:38.34 Index 3 (PERF_LOG_TRN_DESC)
07:12:40.17 Index 4 (PERF_LOG_GDSCODE)
07:12:42.26 Relation 163 (PERF_LOG) is ok

07:12:42.26 Relation 167 (V_STOPTEST)
07:12:42.26 Relation 167 (V_STOPTEST) is ok

07:12:42.26 Relation 184 (V_QDISTR_SOURCE)
07:12:42.26 Relation 184 (V_QDISTR_SOURCE) is ok

07:12:42.26 Relation 185 (V_QSTORNED_SOURCE)
07:12:42.26 Relation 185 (V_QSTORNED_SOURCE) is ok

07:12:42.26 Relation 260 (XQD_1000_1200)
07:12:42.26 process pointer page 0 of 1
07:12:42.28 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:12:42.28 Relation 260 (XQD_1000_1200) is ok

07:12:42.28 Relation 261 (XQD_1200_2000)
07:12:42.28 process pointer page 0 of 2
07:12:42.35 process pointer page 1 of 2
07:12:42.37 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:12:42.38 Relation 261 (XQD_1200_2000) is ok

07:12:42.38 Relation 262 (XQD_1000_3300)
07:12:42.38 process pointer page 0 of 6
07:12:42.48 process pointer page 1 of 6
07:12:42.57 process pointer page 2 of 6
07:12:42.67 process pointer page 3 of 6
07:12:42.76 process pointer page 4 of 6
07:12:42.84 process pointer page 5 of 6
07:12:42.90 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:12:43.12 Index 2 (XQD_1000_3300_DOC)
07:12:43.27 Relation 262 (XQD_1000_3300) is ok

07:12:43.27 Relation 263 (XQD_2000_3300)
07:12:43.27 process pointer page 0 of 13
07:12:43.38 process pointer page 1 of 13
07:12:43.45 process pointer page 2 of 13
07:12:43.49 process pointer page 3 of 13
07:12:43.60 process pointer page 4 of 13
07:12:43.63 process pointer page 5 of 13
07:12:43.66 process pointer page 6 of 13
07:12:43.71 process pointer page 7 of 13
07:12:43.74 process pointer page 8 of 13
07:12:43.84 process pointer page 9 of 13
07:12:43.93 process pointer page 10 of 13
07:12:43.99 process pointer page 11 of 13
07:12:44.02 process pointer page 12 of 13
07:12:44.04 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:12:44.19 Relation 263 (XQD_2000_3300) is ok

07:12:44.19 Relation 264 (XQD_2100_3300)
07:12:44.19 process pointer page 0 of 3
07:12:44.19 process pointer page 1 of 3
07:12:44.19 process pointer page 2 of 3
07:12:44.19 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:12:44.19 Relation 264 (XQD_2100_3300) is ok

07:12:44.19 Relation 265 (XQD_3300_3400)
07:12:44.19 process pointer page 0 of 23
07:12:44.24 process pointer page 1 of 23
07:12:44.27 process pointer page 2 of 23
07:12:44.32 process pointer page 3 of 23
07:12:44.35 process pointer page 4 of 23
07:12:44.38 process pointer page 5 of 23
07:12:44.41 process pointer page 6 of 23
07:12:44.44 process pointer page 7 of 23
07:12:44.49 process pointer page 8 of 23
07:12:44.51 process pointer page 9 of 23
07:12:44.54 process pointer page 10 of 23
07:12:44.57 process pointer page 11 of 23
07:12:44.60 process pointer page 12 of 23
07:12:44.63 process pointer page 13 of 23
07:12:44.66 process pointer page 14 of 23
07:12:44.69 process pointer page 15 of 23
07:12:44.72 process pointer page 16 of 23
07:12:44.76 process pointer page 17 of 23
07:12:44.80 process pointer page 18 of 23
07:12:44.83 process pointer page 19 of 23
07:12:44.93 process pointer page 20 of 23
07:12:45.02 process pointer page 21 of 23
07:12:45.11 process pointer page 22 of 23
07:12:45.11 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:12:46.05 Relation 265 (XQD_3300_3400) is ok

07:12:46.05 Relation 266 (XQS_1000_1200)
07:12:46.05 process pointer page 0 of 40
07:12:46.14 process pointer page 1 of 40
07:12:46.25 process pointer page 2 of 40
07:12:46.32 process pointer page 3 of 40
07:12:46.38 process pointer page 4 of 40
07:12:46.47 process pointer page 5 of 40
07:12:46.57 process pointer page 6 of 40
07:12:46.67 process pointer page 7 of 40
07:12:46.77 process pointer page 8 of 40
07:12:46.86 process pointer page 9 of 40
07:12:46.97 process pointer page 10 of 40
07:12:47.05 process pointer page 11 of 40
07:12:47.10 process pointer page 12 of 40
07:12:47.13 process pointer page 13 of 40
07:12:47.17 process pointer page 14 of 40
07:12:47.20 process pointer page 15 of 40
07:12:47.24 process pointer page 16 of 40
07:12:47.35 process pointer page 17 of 40
07:12:47.44 process pointer page 18 of 40
07:12:47.53 process pointer page 19 of 40
07:12:47.63 process pointer page 20 of 40
07:12:47.72 process pointer page 21 of 40
07:12:47.81 process pointer page 22 of 40
07:12:47.86 process pointer page 23 of 40
07:12:47.94 process pointer page 24 of 40
07:12:48.03 process pointer page 25 of 40
07:12:48.13 process pointer page 26 of 40
07:12:48.20 process pointer page 27 of 40
07:12:48.25 process pointer page 28 of 40
07:12:48.28 process pointer page 29 of 40
07:12:48.33 process pointer page 30 of 40
07:12:48.36 process pointer page 31 of 40
07:12:48.42 process pointer page 32 of 40
07:12:48.52 process pointer page 33 of 40
07:12:48.61 process pointer page 34 of 40
07:12:48.67 process pointer page 35 of 40
07:12:48.72 process pointer page 36 of 40
07:12:48.81 process pointer page 37 of 40
07:12:48.91 process pointer page 38 of 40
07:12:49.00 process pointer page 39 of 40
07:12:49.01 Index 1 (XQS_1000_1200_DOC_ID)
07:12:49.73 Index 2 (XQS_1000_1200_SND_ID)
07:12:50.78 Index 3 (XQS_1000_1200_RCV_ID)
07:12:51.56 Relation 266 (XQS_1000_1200) is ok

07:12:51.56 Relation 267 (XQS_1200_2000)
07:12:51.56 process pointer page 0 of 42
07:12:51.59 process pointer page 1 of 42
07:12:51.64 process pointer page 2 of 42
07:12:51.67 process pointer page 3 of 42
07:12:51.70 process pointer page 4 of 42
07:12:51.73 process pointer page 5 of 42
07:12:51.76 process pointer page 6 of 42
07:12:51.84 process pointer page 7 of 42
07:12:51.90 process pointer page 8 of 42
07:12:51.95 process pointer page 9 of 42
07:12:51.98 process pointer page 10 of 42
07:12:52.09 process pointer page 11 of 42
07:12:52.18 process pointer page 12 of 42
07:12:52.27 process pointer page 13 of 42
07:12:52.32 process pointer page 14 of 42
07:12:52.37 process pointer page 15 of 42
07:12:52.40 process pointer page 16 of 42
07:12:52.45 process pointer page 17 of 42
07:12:52.54 process pointer page 18 of 42
07:12:52.63 process pointer page 19 of 42
07:12:52.73 process pointer page 20 of 42
07:12:52.84 process pointer page 21 of 42
07:12:52.88 process pointer page 22 of 42
07:12:52.96 process pointer page 23 of 42
07:12:53.05 process pointer page 24 of 42
07:12:53.15 process pointer page 25 of 42
07:12:53.24 process pointer page 26 of 42
07:12:53.34 process pointer page 27 of 42
07:12:53.44 process pointer page 28 of 42
07:12:53.54 process pointer page 29 of 42
07:12:53.63 process pointer page 30 of 42
07:12:53.73 process pointer page 31 of 42
07:12:53.82 process pointer page 32 of 42
07:12:53.91 process pointer page 33 of 42
07:12:54.01 process pointer page 34 of 42
07:12:54.07 process pointer page 35 of 42
07:12:54.10 process pointer page 36 of 42
07:12:54.13 process pointer page 37 of 42
07:12:54.18 process pointer page 38 of 42
07:12:54.24 process pointer page 39 of 42
07:12:54.32 process pointer page 40 of 42
07:12:54.41 process pointer page 41 of 42
07:12:54.49 Index 1 (XQS_1200_2000_DOC_ID)
07:12:55.32 Index 2 (XQS_1200_2000_SND_ID)
07:12:55.93 Index 3 (XQS_1200_2000_RCV_ID)
07:12:56.97 Relation 267 (XQS_1200_2000) is ok

07:12:56.97 Relation 268 (XQS_1000_3300)
07:12:56.97 process pointer page 0 of 25
07:12:57.06 process pointer page 1 of 25
07:12:57.16 process pointer page 2 of 25
07:12:57.25 process pointer page 3 of 25
07:12:57.34 process pointer page 4 of 25
07:12:57.38 process pointer page 5 of 25
07:12:57.42 process pointer page 6 of 25
07:12:57.49 process pointer page 7 of 25
07:12:57.59 process pointer page 8 of 25
07:12:57.63 process pointer page 9 of 25
07:12:57.66 process pointer page 10 of 25
07:12:57.70 process pointer page 11 of 25
07:12:57.80 process pointer page 12 of 25
07:12:57.86 process pointer page 13 of 25
07:12:57.91 process pointer page 14 of 25
07:12:57.94 process pointer page 15 of 25
07:12:57.97 process pointer page 16 of 25
07:12:58.02 process pointer page 17 of 25
07:12:58.06 process pointer page 18 of 25
07:12:58.16 process pointer page 19 of 25
07:12:58.25 process pointer page 20 of 25
07:12:58.34 process pointer page 21 of 25
07:12:58.44 process pointer page 22 of 25
07:12:58.53 process pointer page 23 of 25
07:12:58.62 process pointer page 24 of 25
07:12:58.67 Index 1 (XQS_1000_3300_DOC_ID)
07:12:59.22 Index 2 (XQS_1000_3300_SND_ID)
07:13:00.17 Index 3 (XQS_1000_3300_RCV_ID)
07:13:00.62 Relation 268 (XQS_1000_3300) is ok

07:13:00.62 Relation 269 (XQS_2000_3300)
07:13:00.62 process pointer page 0 of 1
07:13:00.62 Index 1 (XQS_2000_3300_DOC_ID)
07:13:00.62 Index 2 (XQS_2000_3300_SND_ID)
07:13:00.62 Index 3 (XQS_2000_3300_RCV_ID)
07:13:00.62 Relation 269 (XQS_2000_3300) is ok

07:13:00.62 Relation 270 (XQS_2100_3300)
07:13:00.62 process pointer page 0 of 30
07:13:00.65 process pointer page 1 of 30
07:13:00.70 process pointer page 2 of 30
07:13:00.81 process pointer page 3 of 30
07:13:00.90 process pointer page 4 of 30
07:13:00.95 process pointer page 5 of 30
07:13:01.06 process pointer page 6 of 30
07:13:01.18 process pointer page 7 of 30
07:13:01.23 process pointer page 8 of 30
07:13:01.32 process pointer page 9 of 30
07:13:01.51 process pointer page 10 of 30
07:13:01.78 process pointer page 11 of 30
07:13:02.06 process pointer page 12 of 30
07:13:02.32 process pointer page 13 of 30
07:13:02.57 process pointer page 14 of 30
07:13:02.84 process pointer page 15 of 30
07:13:03.10 process pointer page 16 of 30
07:13:03.35 process pointer page 17 of 30
07:13:03.62 process pointer page 18 of 30
07:13:03.93 process pointer page 19 of 30
07:13:04.40 process pointer page 20 of 30
07:13:04.71 process pointer page 21 of 30
07:13:05.04 process pointer page 22 of 30
07:13:05.39 process pointer page 23 of 30
07:13:05.80 process pointer page 24 of 30
07:13:06.28 process pointer page 25 of 30
07:13:06.75 process pointer page 26 of 30
07:13:07.13 process pointer page 27 of 30
07:13:07.47 process pointer page 28 of 30
07:13:07.83 process pointer page 29 of 30
07:13:08.05 Index 1 (XQS_2100_3300_DOC_ID)
07:13:09.87 Index 2 (XQS_2100_3300_SND_ID)
07:13:11.92 Index 3 (XQS_2100_3300_RCV_ID)
07:13:13.77 Relation 270 (XQS_2100_3300) is ok

07:13:13.77 Relation 271 (XQS_3300_3400)
07:13:13.77 process pointer page 0 of 5
07:13:14.27 process pointer page 1 of 5
07:13:14.77 process pointer page 2 of 5
07:13:15.27 process pointer page 3 of 5
07:13:15.77 process pointer page 4 of 5
07:13:16.05 Index 1 (XQS_3300_3400_DOC_ID)
07:13:16.39 Index 2 (XQS_3300_3400_SND_ID)
07:13:16.75 Relation 271 (XQS_3300_3400) is ok

07:13:16.77 Validation finished
Done for 60060 ms, from 7:12:16.77 to 7:13:16.83.

Differences between old and current firebird.log

7:13:18.42. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_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-08-02 07:13 471 oltp30_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.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Thu Aug 02 07:12:16 2018
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Thu Aug 02 07:13:16 2018
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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

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.oltp30\oltp30_.:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND

ISQL logs are removed because no severe errors occured during test.
2018-08-02 7:13:26.53 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.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.oltp30\oltp30_*.*:

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