Firebird 4.0 Performance Logs

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2018-05-22 11:20:59.76.

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

Server and database settings

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

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

Test configuration settings

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

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

Test finish info

FINISH_STATE	DTS_END	FB_GDSCODE	FB_MNEMONA	STACK	IP	TRN_ID	ATT_ID	EXC_UNIT
NORMAL: TEST_TIME EXPIRED.	2018-05-22 11:17:56.7170	-1	<null>		::1/58564	451960	9124	2

Current test settings

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

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

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

Performance reports

Performance in TOTAL:

ACTION	AVG_TIMES_PER_MINUTE	AVG_ELAPSED_MS	SUCCESSFUL_TIMES_DONE	JOB_BEG	JOB_END
* OVERALL * for 179 minutes:	7265.23	997	1300477	2018-05-22 08:18	2018-05-22 11:17
customer order: creation	467.19	112	83627	2018-05-22 08:18	2018-05-22 11:17
customer order: refuse	38.56	68	6902	2018-05-22 08:18	2018-05-22 11:17
order to supplier: creation	120.74	452	21612	2018-05-22 08:18	2018-05-22 11:17
order to supplier: removal	3.39	6657	607	2018-05-22 08:18	2018-05-22 11:17
invoice (draft): creation	122.47	651	21923	2018-05-22 08:18	2018-05-22 11:17
invoice (draft): removal	49.50	126	8861	2018-05-22 08:18	2018-05-22 11:17
invoice accept: apply	71.12	2547	12730	2018-05-22 08:18	2018-05-22 11:17
invoice accept: cancel	24.02	544	4300	2018-05-22 08:18	2018-05-22 11:17
customer reserve: creation	4129.32	35	739149	2018-05-22 08:18	2018-05-22 11:17
customer reserve: removal	1582.47	14	283262	2018-05-22 08:18	2018-05-22 11:17
realization accept: apply	220.11	115	39400	2018-05-22 08:18	2018-05-22 11:17
realization accept: cancel	100.46	38	17983	2018-05-22 08:18	2018-05-22 11:17
payment from customer: creation	157.40	189	28174	2018-05-22 08:18	2018-05-22 11:17
payment from customer: removal	15.20	45	2720	2018-05-22 08:18	2018-05-22 11:17
payment to supplier: creation	128.08	90	22927	2018-05-22 08:18	2018-05-22 11:17
payment to supplier: removal	9.35	34	1673	2018-05-22 08:18	2018-05-22 11:17
service: total inventory turnovers	12.43	648	2225	2018-05-22 08:18	2018-05-22 11:17
service: total monetary turnovers	13.35	19	2390	2018-05-22 08:18	2018-05-22 11:17
service: refresh index statistics	0.07	6557	12	2018-05-22 08:18	2018-05-22 11:17

Done for 132560 ms, from 11:24:22.81 to 11:26:35.37.

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	5621	118115	101170	16945	14.35	08:17:57	08:35:57
interval # 2, overall	2	7573	152170	136312	15858	10.42	08:35:58	08:53:58
interval # 3, overall	3	7191	152138	129429	22709	14.93	08:53:59	09:11:59
interval # 4, overall	4	7735	166330	139221	27109	16.30	09:12:00	09:30:00
interval # 5, overall	5	7345	154103	132205	21898	14.21	09:30:01	09:48:01
interval # 6, overall	6	7291	152239	131241	20998	13.79	09:48:02	10:06:02
interval # 7, overall	7	7596	171455	136735	34720	20.25	10:06:03	10:24:03
interval # 8, overall	8	7673	161642	138112	23530	14.56	10:24:04	10:42:04
interval # 9, overall	9	7396	159851	133132	26719	16.71	10:42:05	11:00:05
interval # 10, overall	10	6829	151513	122920	28593	18.87	11:00:06	11:18:06

Done for 280470 ms, from 11:31:14.58 to 11:35:55.05.

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	2083.29	0.0004	2.0501	2315	19
TEST_TIME	2	3221.74	0.6628	1.2915	1658	100
TEST_TIME	3	3453.77	0.8033	1.1999	2347	100
TEST_TIME	4	3793.46	0.8195	1.1538	1850	100
TEST_TIME	5	3937.98	0.8892	1.1016	1689	100
TEST_TIME	6	4037.90	0.8954	1.1120	1875	100
TEST_TIME	7	4259.61	0.9038	1.0897	1926	100
TEST_TIME	8	4442.10	0.9149	1.0723	2117	100
TEST_TIME	9	4563.13	0.9279	1.0716	1760	100
TEST_TIME	10	4723.03	0.9318	1.0595	1831	100
TEST_TIME	11	4816.85	0.9445	1.0588	1945	100
TEST_TIME	12	4916.94	0.9509	1.0467	1640	100
TEST_TIME	13	5044.38	0.9418	1.0550	1580	100
TEST_TIME	14	5143.59	0.9607	1.0382	1609	100
TEST_TIME	15	5191.43	0.9600	1.0350	1432	100
TEST_TIME	16	5206.23	0.9676	1.0363	1514	100
TEST_TIME	17	5329.24	0.9539	1.0419	2055	100
TEST_TIME	18	5456.82	0.9610	1.0316	1556	100
TEST_TIME	19	5548.21	0.9620	1.0369	1789	100
TEST_TIME	20	5659.96	0.9656	1.0330	2158	100
TEST_TIME	21	5766.52	0.9656	1.0287	1743	100
TEST_TIME	22	5822.27	0.9729	1.0295	2032	100
TEST_TIME	23	5917.94	0.9689	1.0256	2006	100
TEST_TIME	24	6001.39	0.9704	1.0273	1588	100
TEST_TIME	25	6064.83	0.9760	1.0176	1796	100
TEST_TIME	26	6081.72	0.9758	1.0282	1409	99
TEST_TIME	27	6126.87	0.9828	1.0168	1401	100
TEST_TIME	28	6122.58	0.9813	1.0193	1570	100
TEST_TIME	29	6141.44	0.9812	1.0213	1399	100
TEST_TIME	30	6171.00	0.9826	1.0155	1430	100
TEST_TIME	31	6157.82	0.9852	1.0131	1350	100
TEST_TIME	32	6171.27	0.9794	1.0227	1868	100
TEST_TIME	33	6275.44	0.9753	1.0221	2226	100
TEST_TIME	34	6350.13	0.9804	1.0194	2210	100
TEST_TIME	35	6398.48	0.9830	1.0205	1662	100
TEST_TIME	36	6475.03	0.9804	1.0191	1708	100
TEST_TIME	37	6543.72	0.9811	1.0142	1808	100
TEST_TIME	38	6561.61	0.9849	1.0130	1674	100
TEST_TIME	39	6566.98	0.9862	1.0165	1706	100
TEST_TIME	40	6596.19	0.9867	1.0122	1488	100
TEST_TIME	41	6610.42	0.9854	1.0120	1517	100
TEST_TIME	42	6601.99	0.9892	1.0116	1543	100
TEST_TIME	43	6603.31	0.9878	1.0124	1396	100
TEST_TIME	44	6629.80	0.9854	1.0097	1335	100
TEST_TIME	45	6637.66	0.9860	1.0112	1354	100
TEST_TIME	46	6622.22	0.9915	1.0090	1355	99
TEST_TIME	47	6573.20	0.9949	1.0045	562	100
TEST_TIME	48	6554.68	0.9863	1.0131	2114	100
TEST_TIME	49	6611.91	0.9839	1.0140	2334	100
TEST_TIME	50	6658.78	0.9869	1.0121	2259	100
TEST_TIME	51	6699.09	0.9863	1.0111	1863	100
TEST_TIME	52	6714.97	0.9894	1.0109	1985	100
TEST_TIME	53	6734.00	0.9890	1.0097	1645	100
TEST_TIME	54	6727.19	0.9920	1.0101	1524	100
TEST_TIME	55	6722.69	0.9924	1.0100	1606	100
TEST_TIME	56	6751.17	0.9880	1.0121	1507	100
TEST_TIME	57	6756.43	0.9936	1.0078	1433	100
TEST_TIME	58	6756.01	0.9905	1.0082	1437	100
TEST_TIME	59	6750.14	0.9920	1.0077	1344	100
TEST_TIME	60	6753.54	0.9904	1.0066	1394	100
TEST_TIME	61	6731.32	0.9937	1.0083	1259	100
TEST_TIME	62	6753.21	0.9888	1.0122	2124	100
TEST_TIME	63	6801.17	0.9891	1.0106	2053	100
TEST_TIME	64	6797.98	0.9953	1.0050	972	100
TEST_TIME	65	6826.12	0.9858	1.0134	2057	100
TEST_TIME	66	6872.15	0.9915	1.0084	1753	100
TEST_TIME	67	6892.78	0.9907	1.0102	1804	100
TEST_TIME	68	6919.48	0.9916	1.0088	1460	100
TEST_TIME	69	6933.46	0.9922	1.0072	1439	100
TEST_TIME	70	6941.42	0.9917	1.0099	1563	100
TEST_TIME	71	6971.80	0.9913	1.0089	1365	100
TEST_TIME	72	6985.06	0.9930	1.0062	1365	100
TEST_TIME	73	6962.35	0.9956	1.0034	1502	100
TEST_TIME	74	6941.90	0.9957	1.0022	668	94
TEST_TIME	75	6919.25	0.9921	1.0079	1246	100
TEST_TIME	76	6924.48	0.9939	1.0076	1272	100
TEST_TIME	77	6945.87	0.9916	1.0082	2188	100
TEST_TIME	78	6966.26	0.9924	1.0046	2131	100
TEST_TIME	79	6958.80	0.9946	1.0064	2117	97
TEST_TIME	80	6982.48	0.9907	1.0072	1840	100
TEST_TIME	81	7004.92	0.9916	1.0073	1968	100
TEST_TIME	82	7024.62	0.9922	1.0073	1872	100
TEST_TIME	83	7031.23	0.9942	1.0052	1749	100
TEST_TIME	84	7032.15	0.9931	1.0080	1518	100
TEST_TIME	85	7039.48	0.9951	1.0050	1665	100
TEST_TIME	86	7039.86	0.9933	1.0082	1431	100
TEST_TIME	87	7054.73	0.9945	1.0055	1320	100
TEST_TIME	88	7054.20	0.9941	1.0044	1217	100
TEST_TIME	89	7046.21	0.9942	1.0060	1250	100
TEST_TIME	90	7043.26	0.9952	1.0068	1184	100
TEST_TIME	91	7028.83	0.9978	1.0026	756	99
TEST_TIME	92	6979.38	0.9987	1.0011	843	99
TEST_TIME	93	6962.12	0.9928	1.0079	2244	85
TEST_TIME	94	6994.48	0.9925	1.0070	2097	53
TEST_TIME	95	7013.76	0.9937	1.0075	1569	44
TEST_TIME	96	7034.33	0.9942	1.0071	1437	100
TEST_TIME	97	7053.81	0.9940	1.0054	1787	100
TEST_TIME	98	7048.74	0.9958	1.0033	1140	100
TEST_TIME	99	7048.01	0.9932	1.0062	1761	100
TEST_TIME	100	7059.16	0.9949	1.0070	1518	100
TEST_TIME	101	7080.18	0.9941	1.0053	1311	100
TEST_TIME	102	7079.44	0.9956	1.0031	1154	100
TEST_TIME	103	7048.66	0.9977	1.0021	1560	99
TEST_TIME	104	7029.28	0.9952	1.0061	1288	100
TEST_TIME	105	7030.89	0.9964	1.0035	1236	100
TEST_TIME	106	7032.08	0.9939	1.0042	1136	100
TEST_TIME	107	7035.92	0.9943	1.0052	1887	100
TEST_TIME	108	7067.21	0.9914	1.0076	1844	100
TEST_TIME	109	7090.83	0.9950	1.0052	1951	100
TEST_TIME	110	7103.60	0.9943	1.0067	1763	100
TEST_TIME	111	7125.75	0.9945	1.0054	1463	100
TEST_TIME	112	7135.37	0.9951	1.0050	1610	100
TEST_TIME	113	7149.81	0.9942	1.0037	1426	100
TEST_TIME	114	7146.77	0.9953	1.0056	1356	100
TEST_TIME	115	7151.67	0.9962	1.0045	1394	100
TEST_TIME	116	7135.35	0.9982	1.0013	633	100
TEST_TIME	117	7110.31	0.9962	1.0039	1282	100
TEST_TIME	118	7114.43	0.9948	1.0035	1334	100
TEST_TIME	119	7109.67	0.9957	1.0048	1177	100
TEST_TIME	120	7116.26	0.9955	1.0042	1065	100
TEST_TIME	121	7114.44	0.9962	1.0028	1053	100
TEST_TIME	122	7113.32	0.9948	1.0052	1793	100
TEST_TIME	123	7128.34	0.9949	1.0057	1939	100
TEST_TIME	124	7147.46	0.9949	1.0050	1853	100
TEST_TIME	125	7156.82	0.9956	1.0035	1743	100
TEST_TIME	126	7163.74	0.9945	1.0035	1614	100
TEST_TIME	127	7166.90	0.9952	1.0040	1425	100
TEST_TIME	128	7172.64	0.9954	1.0040	1433	100
TEST_TIME	129	7173.04	0.9961	1.0033	1455	100
TEST_TIME	130	7177.54	0.9949	1.0037	1422	100
TEST_TIME	131	7175.84	0.9963	1.0045	1378	100
TEST_TIME	132	7178.72	0.9965	1.0025	1342	100
TEST_TIME	133	7171.87	0.9959	1.0046	1240	100
TEST_TIME	134	7181.84	0.9958	1.0043	1209	100
TEST_TIME	135	7181.18	0.9970	1.0032	1197	100
TEST_TIME	136	7176.69	0.9964	1.0039	1129	100
TEST_TIME	137	7169.39	0.9978	1.0016	913	100
TEST_TIME	138	7150.00	0.9970	1.0057	2118	92
TEST_TIME	139	7173.49	0.9952	1.0057	1717	61
TEST_TIME	140	7200.94	0.9947	1.0060	1681	47
TEST_TIME	141	7217.98	0.9965	1.0031	1344	100
TEST_TIME	142	7212.98	0.9968	1.0064	1725	100
TEST_TIME	143	7226.65	0.9974	1.0028	1523	100
TEST_TIME	144	7221.21	0.9966	1.0040	1570	100
TEST_TIME	145	7223.82	0.9967	1.0061	1394	100
TEST_TIME	146	7239.52	0.9971	1.0030	1343	100
TEST_TIME	147	7231.30	0.9973	1.0036	1362	100
TEST_TIME	148	7225.24	0.9977	1.0024	1296	100
TEST_TIME	149	7222.78	0.9960	1.0036	1300	100
TEST_TIME	150	7224.38	0.9967	1.0031	1297	100
TEST_TIME	151	7221.47	0.9969	1.0026	1231	100
TEST_TIME	152	7223.20	0.9958	1.0038	1818	100
TEST_TIME	153	7235.12	0.9956	1.0037	2035	100
TEST_TIME	154	7249.21	0.9953	1.0048	1768	100
TEST_TIME	155	7261.15	0.9967	1.0035	1631	100
TEST_TIME	156	7270.41	0.9958	1.0044	1680	100
TEST_TIME	157	7284.88	0.9960	1.0029	1624	100
TEST_TIME	158	7289.12	0.9960	1.0028	1501	100
TEST_TIME	159	7287.03	0.9968	1.0043	1547	100
TEST_TIME	160	7277.24	0.9994	1.0009	584	97
TEST_TIME	161	7255.70	0.9976	1.0010	1296	98
TEST_TIME	162	7235.56	0.9976	1.0023	1373	73
TEST_TIME	163	7228.45	0.9972	1.0042	1102	95
TEST_TIME	164	7229.36	0.9979	1.0024	1229	99
TEST_TIME	165	7221.00	0.9975	1.0022	1124	100
TEST_TIME	166	7211.05	0.9977	1.0024	1270	100
TEST_TIME	167	7213.81	0.9961	1.0030	1802	100
TEST_TIME	168	7223.01	0.9958	1.0047	1811	100
TEST_TIME	169	7236.08	0.9969	1.0031	1851	100
TEST_TIME	170	7249.02	0.9954	1.0034	1709	100
TEST_TIME	171	7251.59	0.9972	1.0030	1733	99
TEST_TIME	172	7257.41	0.9964	1.0041	1518	100
TEST_TIME	173	7253.92	0.9988	1.0015	1592	97
TEST_TIME	174	7253.99	0.9957	1.0023	1329	100
TEST_TIME	175	7247.15	0.9975	1.0024	1306	100
TEST_TIME	176	7244.56	0.9970	1.0024	1281	100
TEST_TIME	177	7238.48	0.9976	1.0024	1303	100
TEST_TIME	178	7233.74	0.9974	1.0023	1242	100
TEST_TIME	179	7224.74	0.9979	1.0023	1226	100
TEST_TIME	180	7213.60	0.9983	1.0015	1221	100

Done for 10780 ms, from 11:35:57.06 to 11:36:07.84.

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	87320	120723	88469	115719	77304	82096	104887	114278	90289	94886	97046	69919	110502	88144	175291	114888	229097	892000	<null>	08:17:57	08:35:57
fetches per second	2	65244	101052	66802	<null>	56163	119400	71875	91824	77210	107692	78277	49130	94036	121551	139029	86054	158020	<null>	<null>	08:35:58	08:53:58
fetches per second	3	83474	116623	94880	127815	79020	<null>	91546	<null>	86239	100164	90899	<null>	94604	148566	132263	120555	205296	169833	<null>	08:53:59	09:11:59
fetches per second	4	81277	106984	69606	<null>	54647	<null>	96818	86566	81317	77214	87567	54773	104606	32123	101114	61841	261294	303100	<null>	09:12:00	09:30:00
fetches per second	5	50439	95586	52824	<null>	53329	7718	72662	91647	67977	55823	66502	43691	87338	135125	71056	154833	230571	260288	<null>	09:30:01	09:48:01
fetches per second	6	51659	107881	44153	63307	46112	<null>	70320	<null>	75854	1315	60010	34623	66438	58979	65014	1704	48767	496795	<null>	09:48:02	10:06:02
fetches per second	7	73722	157904	53245	<null>	70540	147412	102368	<null>	31813	88483	83532	37390	86298	98807	74838	18031	108696	828000	<null>	10:06:03	10:24:03
fetches per second	8	74233	222333	56813	<null>	72872	148880	89296	86602	33109	86098	67706	44058	93541	20760	57487	37958	157884	248107	557	10:24:04	10:42:04
fetches per second	9	67713	73240	77006	150815	69279	44134	98489	<null>	88909	66979	74650	23113	100713	70089	106684	145000	133103	8919	<null>	10:42:05	11:00:05
fetches per second	10	55636	97540	53549	<null>	52168	<null>	76548	78824	24054	45848	93898	49802	85374	164625	63875	<null>	188179	1024500	<null>	11:00:06	11:18:06
marks per second	1	19452	16272	19322	24174	17411	16802	14797	21469	10617	19053	19057	12063	8608	15511	9979	20654	12776	61000	<null>	08:17:57	08:35:57
marks per second	2	14485	13327	14714	<null>	12990	29837	11107	15052	12661	19076	13555	9464	8183	18205	13988	13370	20065	<null>	<null>	08:35:58	08:53:58
marks per second	3	18040	15917	21448	24723	17941	<null>	13573	<null>	13617	22145	12495	<null>	8491	27950	23309	22444	43600	26000	<null>	08:53:59	09:11:59
marks per second	4	17499	14881	15328	<null>	12253	<null>	13726	15460	12195	13000	11382	8603	9249	5261	19208	12325	25502	26511	<null>	09:12:00	09:30:00
marks per second	5	10996	13107	11389	<null>	11673	1446	10409	17608	10186	6964	10054	8284	6715	30625	12288	31416	33586	25679	<null>	09:30:01	09:48:01
marks per second	6	11341	14923	9788	12751	10071	<null>	10991	<null>	8836	207	7123	5524	4059	11978	11348	270	4209	22177	<null>	09:48:02	10:06:02
marks per second	7	16203	20588	11744	<null>	14497	36619	13948	<null>	5165	13633	11203	6762	5099	18479	15843	2449	21158	48166	<null>	10:06:03	10:24:03
marks per second	8	15284	32555	12530	<null>	15803	26440	12958	14786	5015	14112	10081	7207	4072	4739	9692	7541	16993	22519	83	10:24:04	10:42:04
marks per second	9	14473	9905	17091	35945	14406	11169	13749	<null>	10136	11516	11799	2596	4659	11990	19188	21400	22509	859	<null>	10:42:05	11:00:05
marks per second	10	11950	13457	11088	<null>	11407	<null>	10682	13157	3275	8673	10079	8730	3505	13250	13497	<null>	36507	58000	<null>	11:00:06	11:18:06
reads/fetches*100	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	<null>	08:17:57	08:35:57
reads/fetches*100	2	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	<null>	08:35:58	08:53:58
reads/fetches*100	3	0	0	0	0	0	<null>	0	<null>	0	0	0	<null>	0	0	0	0	0	0	<null>	08:53:59	09:11:59
reads/fetches*100	4	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	<null>	09:12:00	09:30:00
reads/fetches*100	5	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	09:30:01	09:48:01
reads/fetches*100	6	0	0	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	09:48:02	10:06:02
reads/fetches*100	7	0	0	0	<null>	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	10:06:03	10:24:03
reads/fetches*100	8	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	10:24:04	10:42:04
reads/fetches*100	9	0	0	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	10:42:05	11:00:05
reads/fetches*100	10	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	<null>	0	0	<null>	11:00:06	11:18:06
writes/marks*100	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	7	0	<null>	08:17:57	08:35:57
writes/marks*100	2	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	1	<null>	<null>	08:35:58	08:53:58
writes/marks*100	3	0	0	0	0	0	<null>	0	<null>	0	0	0	<null>	0	0	0	0	1	0	<null>	08:53:59	09:11:59
writes/marks*100	4	0	0	0	<null>	0	<null>	0	0	1	1	1	1	0	0	0	0	1	0	<null>	09:12:00	09:30:00
writes/marks*100	5	0	0	0	<null>	0	0	0	0	1	1	0	0	0	0	0	0	3	0	<null>	09:30:01	09:48:01
writes/marks*100	6	0	0	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	09:48:02	10:06:02
writes/marks*100	7	0	0	0	<null>	0	0	0	<null>	0	0	0	0	0	0	0	0	2	0	<null>	10:06:03	10:24:03
writes/marks*100	8	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	2	1	0	2	10:24:04	10:42:04
writes/marks*100	9	0	0	0	0	0	0	0	<null>	0	1	0	0	0	1	0	0	2	0	<null>	10:42:05	11:00:05
writes/marks*100	10	0	3	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	<null>	0	0	<null>	11:00:06	11:18:06

Done for 11770 ms, from 11:36:09.38 to 11:36:21.15.

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	2314560	2086021	228539	9.87	0	10593	8	228539	2018-05-22 08:17	2018-05-22 11:17
doc_list_biud	2315055	2086021	229034	9.89	0	31903	4	229034	2018-05-22 08:17	2018-05-22 11:17
sp_add_invoice_to_stock	20155	12730	7425	36.83	0	89965	2547	7425	2018-05-22 08:17	2018-05-22 11:17
sp_cancel_adding_invoice	5674	4300	1374	24.21	0	51324	544	1374	2018-05-22 08:17	2018-05-22 11:17
sp_cancel_client_order	7041	6902	139	1.97	0	35865	68	139	2018-05-22 08:17	2018-05-22 11:17
sp_cancel_customer_reserve	498319	283262	215057	43.15	0	33509	14	215057	2018-05-22 08:17	2018-05-22 11:17
sp_cancel_pay_from_customer	2734	2720	14	0.51	0	25522	45	14	2018-05-22 08:17	2018-05-22 11:17
sp_cancel_pay_to_supplier	1676	1673	3	0.17	0	2527	34	3	2018-05-22 08:17	2018-05-22 11:17
sp_cancel_supplier_invoice	11377	8861	2516	22.11	0	14664	126	2516	2018-05-22 08:17	2018-05-22 11:17
sp_cancel_supplier_order	1551	607	944	60.86	0	128092	6657	944	2018-05-22 08:17	2018-05-22 11:17
sp_cancel_write_off	28707	17983	10724	37.35	0	22744	38	10724	2018-05-22 08:17	2018-05-22 11:17
sp_client_order	83627	83627	0	0.00	0	25725	112	0	2018-05-22 08:17	2018-05-22 11:17
sp_customer_reserve	739149	739149	0	0.00	0	36816	35	0	2018-05-22 08:17	2018-05-22 11:17
sp_fill_shopping_cart	127542	127162	380	0.29	0	18580	23	0	2018-05-22 08:17	2018-05-22 11:17
sp_fill_shopping_cart_clo_res	739149	739149	0	0.00	0	35959	2	0	2018-05-22 08:17	2018-05-22 11:17
sp_get_clo_for_invoice	12730	12730	0	0.00	0	12495	87	0	2018-05-22 08:17	2018-05-22 11:17
sp_kill_cost_storno	38403	26676	11727	30.53	0	10593	4	11727	2018-05-22 08:17	2018-05-22 11:17
sp_kill_qstorno_ret_qs2qd	1036553	593975	442578	42.69	0	14664	5	442578	2018-05-22 08:17	2018-05-22 11:17
sp_kill_qty_storno	602991	374045	228946	37.96	0	31903	16	228946	2018-05-22 08:17	2018-05-22 11:17
sp_lock_selected_doc	82974	73063	9911	11.94	0	34913	2	9911	2018-05-22 08:17	2018-05-22 11:17
sp_make_cost_storno	103231	103231	0	0.00	0	5912	74	0	2018-05-22 08:17	2018-05-22 11:17
sp_multiply_rows_for_pdistr	103231	103231	0	0.00	0	8205	10	0	2018-05-22 08:17	2018-05-22 11:17
sp_multiply_rows_for_qdistr	83627	83627	0	0.00	0	25538	38	0	2018-05-22 08:17	2018-05-22 11:17
sp_pay_from_customer	28174	28174	0	0.00	0	13229	189	0	2018-05-22 08:17	2018-05-22 11:17
sp_pay_to_supplier	22927	22927	0	0.00	0	8938	90	0	2018-05-22 08:17	2018-05-22 11:17
sp_payment_common	51101	51101	0	0.00	0	4945	18	0	2018-05-22 08:17	2018-05-22 11:17
sp_qd_handle_on_cancel_clo	7040	6902	138	1.96	0	7286	24	138	2018-05-22 08:17	2018-05-22 11:17
sp_qd_handle_on_invoice_upd_sts	18238	17030	1208	6.62	0	31903	94	1208	2018-05-22 08:17	2018-05-22 11:17
sp_qd_handle_on_reserve_upd_sts	39400	39400	0	0.00	0	12090	12	0	2018-05-22 08:17	2018-05-22 11:17
sp_reserve_write_off	39903	39400	503	1.26	0	33728	115	503	2018-05-22 08:17	2018-05-22 11:17
sp_supplier_invoice	22059	21923	136	0.61	0	51855	651	0	2018-05-22 08:17	2018-05-22 11:17
sp_supplier_order	21856	21612	244	1.11	0	49546	452	0	2018-05-22 08:17	2018-05-22 11:17
srv_find_qd_qs_mism	1430874	1202286	228588	15.97	0	4899	4	228588	2018-05-22 08:17	2018-05-22 11:17
srv_make_invnt_saldo	2225	2225	0	0.00	15	64927	648	0	2018-05-22 08:17	2018-05-22 11:17
srv_make_money_saldo	2390	2390	0	0.00	0	811	19	0	2018-05-22 08:17	2018-05-22 11:17
srv_recalc_idx_stat	12	12	0	0.00	1841	41387	6557	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_add_invoice_to_stock	7425	7425	0	0.00	0	9375	22	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_cancel_adding_invoice	591	591	0	0.00	0	4290	44	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_cancel_client_order	139	139	0	0.00	0	640	16	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_cancel_customer_reserve	33	33	0	0.00	0	328	18	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_cancel_pay_from_customer	14	14	0	0.00	0	172	15	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_cancel_pay_to_supplier	3	3	0	0.00	0	32	10	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_cancel_supplier_invoice	621	621	0	0.00	0	4056	26	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_cancel_supplier_order	25917	25917	0	0.00	0	4368	27	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_cancel_write_off	19	19	0	0.00	0	172	18	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_reserve_write_off	503	503	0	0.00	0	4883	29	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_supplier_invoice	136	136	0	0.00	0	344	11	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-abend:sp_supplier_order	244	244	0	0.00	0	1778	16	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_add_invoice_to_stock	12730	12730	0	0.00	0	31871	211	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_cancel_adding_invoice	1432	1432	0	0.00	0	38969	219	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_cancel_client_order	6902	6902	0	0.00	0	21762	27	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_cancel_customer_reserve	2631	2631	0	0.00	0	23759	34	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_cancel_pay_from_customer	2720	2720	0	0.00	0	19173	21	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_cancel_pay_to_supplier	1673	1673	0	0.00	0	21481	31	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_cancel_supplier_invoice	1081	1081	0	0.00	0	562	8	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_cancel_supplier_order	607	607	0	0.00	0	40217	743	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_cancel_write_off	3887	3887	0	0.00	0	12480	22	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_client_order	83627	83627	0	0.00	0	30217	28	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_customer_reserve	3992	3992	0	0.00	0	20733	21	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_pay_from_customer	28174	28174	0	0.00	0	20826	18	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_pay_to_supplier	22927	22927	0	0.00	0	23229	20	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_reserve_write_off	39400	39400	0	0.00	0	28002	27	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_supplier_invoice	21923	21923	0	0.00	0	29391	23	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:sp_supplier_order	21612	21612	0	0.00	0	27940	24	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:srv_make_invnt_saldo	2225	2225	0	0.00	0	780	2	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:srv_make_money_saldo	2390	2390	0	0.00	0	5725	13	0	2018-05-22 08:17	2018-05-22 11:17
t$perf-norm:srv_recalc_idx_stat	12	12	0	0.00	0	437	56	0	2018-05-22 08:17	2018-05-22 11:17
v_add_invoice_to_stock	40310	25460	14850	36.83	0	14352	9	14850	2018-05-22 08:17	2018-05-22 11:17
v_all_customers	125414	125414	0	0.00	0	531	1	0	2018-05-22 08:17	2018-05-22 11:17
v_all_suppliers	89584	88824	760	0.84	0	406	1	0	2018-05-22 08:17	2018-05-22 11:17
v_all_wares	167254	167254	0	0.00	0	468	1	0	2018-05-22 08:17	2018-05-22 11:17
v_cancel_adding_invoice	3284	2864	420	12.78	0	2776	39	420	2018-05-22 08:17	2018-05-22 11:17
v_cancel_client_order	14082	13804	278	1.97	0	13993	3	278	2018-05-22 08:17	2018-05-22 11:17
v_cancel_customer_prepayment	5468	5440	28	0.51	0	25100	10	28	2018-05-22 08:17	2018-05-22 11:17
v_cancel_customer_reserve	5328	5262	66	1.23	0	796	2	66	2018-05-22 08:17	2018-05-22 11:17
v_cancel_payment_to_supplier	3352	3346	6	0.17	0	765	3	6	2018-05-22 08:17	2018-05-22 11:17
v_cancel_supplier_invoice	3404	2162	1242	36.48	0	592	7	1242	2018-05-22 08:17	2018-05-22 11:17
v_cancel_supplier_order	3102	1214	1888	60.86	0	374	2	1888	2018-05-22 08:17	2018-05-22 11:17
v_cancel_write_off	7812	7774	38	0.48	0	21668	29	38	2018-05-22 08:17	2018-05-22 11:17
v_max_id_clo_ord	21856	21612	244	1.11	0	468	1	0	2018-05-22 08:17	2018-05-22 11:17
v_max_id_clo_res	3992	3992	0	0.00	0	10452	7	0	2018-05-22 08:17	2018-05-22 11:17
v_max_id_ord_sup	22059	21923	136	0.61	0	12574	2	0	2018-05-22 08:17	2018-05-22 11:17
v_max_non_paid_invoice	22050	22050	0	0.00	0	608	1	0	2018-05-22 08:17	2018-05-22 11:17
v_max_non_paid_realizn	28174	28174	0	0.00	0	2683	1	0	2018-05-22 08:17	2018-05-22 11:17
v_min_id_clo_ord	21856	21612	244	1.11	0	1934	2	0	2018-05-22 08:17	2018-05-22 11:17
v_min_id_clo_res	3992	3992	0	0.00	0	6630	9	0	2018-05-22 08:17	2018-05-22 11:17
v_min_id_ord_sup	22059	21923	136	0.61	0	11638	4	0	2018-05-22 08:17	2018-05-22 11:17
v_min_non_paid_invoice	22927	22927	0	0.00	0	1622	1	0	2018-05-22 08:17	2018-05-22 11:17
v_min_non_paid_realizn	28174	28174	0	0.00	0	530	1	0	2018-05-22 08:17	2018-05-22 11:17
v_our_firm	41840	41840	0	0.00	0	531	1	0	2018-05-22 08:17	2018-05-22 11:17
v_reserve_write_off	79806	78800	1006	1.26	0	32589	4	1006	2018-05-22 08:17	2018-05-22 11:17
x_lock_depdocs_on_canc_invoice	22760	12080	10680	46.92	0	1779	7	10680	2018-05-22 08:17	2018-05-22 11:17
x_lock_depdocs_on_canc_sup_ord	1550	607	943	60.83	0	593	14	943	2018-05-22 08:17	2018-05-22 11:17
x_make_qstorno_1000_1200	21856	21612	244	1.11	0	49281	401	0	2018-05-22 08:17	2018-05-22 11:17
x_make_qstorno_1200_2000	22059	21923	136	0.61	0	51605	595	0	2018-05-22 08:17	2018-05-22 11:17
x_make_qstorno_2100_3300	739149	739149	0	0.00	0	36801	29	0	2018-05-22 08:17	2018-05-22 11:17

Done for 541120 ms, from 11:45:06.24 to 11:54:07.36.

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

Exceptions occured during test work:

FB_MNEMONA	CNT	UNIT	FB_GDSCODE	DTS_BEG	DTS_END
deadlock	72	sp_kill_cost_storno	335544336	2018-05-22 08:18	2018-05-22 11:15
deadlock	69	sp_kill_qstorno_ret_qs2qd	335544336	2018-05-22 08:18	2018-05-22 11:12
deadlock	8613	sp_lock_selected_doc	335544336	2018-05-22 08:18	2018-05-22 11:17
deadlock	138	sp_qd_handle_on_cancel_clo	335544336	2018-05-22 08:19	2018-05-22 11:16
deadlock	216	sp_qd_handle_on_invoice_upd_sts	335544336	2018-05-22 08:18	2018-05-22 11:17
deadlock	626	x_lock_depdocs_on_canc_invoice	335544336	2018-05-22 08:18	2018-05-22 11:15
deadlock	171	x_lock_depdocs_on_canc_sup_ord	335544336	2018-05-22 08:22	2018-05-22 11:17
user_exc	244	x_make_qstorno_1000_1200	335544517	2018-05-22 08:19	2018-05-22 11:17
user_exc	136	x_make_qstorno_1200_2000	335544517	2018-05-22 08:18	2018-05-22 11:17

Done for 16920 ms, from 11:54:22.81 to 11:54:39.73.

MON$DATABASE and FB VERSION info

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

Database statistics, full

Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Gstat execution time Tue May 22 11:54:40 2018

Database header page information:
Flags 0
Generation 452487
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 452447
Oldest active 452448
Oldest snapshot 452448
Next transaction 452449
Sequence number 0
Next attachment ID 9365
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write

Variable header data:
Sweep interval: 0
*END*

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

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

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

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

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

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

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

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

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

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

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

DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.16, total records: 2195437
Average version length: 47.90, total versions: 1044, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 15, data page slots: 23656
Data pages: 23656, average fill: 73%
Primary pages: 23656, secondary pages: 0, swept pages: 14436
Empty pages: 2, full pages: 23588
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 4
60 - 79% = 23647
80 - 99% = 2

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 10803, nodes: 2195437
Average node length: 19.41, total dup: 0, max dup: 0
Average key length: 16.45, compression ratio: 1.64
Average prefix length: 13.54, average data length: 13.46
Clustering factor: 316578, ratio: 0.14
Fill distribution:
0 - 19% = 961
20 - 39% = 3000
40 - 59% = 3745
60 - 79% = 1185
80 - 99% = 1912

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7877, nodes: 2195437
Average node length: 11.63, total dup: 0, max dup: 0
Average key length: 8.67, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 316545, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 3832
40 - 59% = 3850
60 - 79% = 184
80 - 99% = 11

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175345, depth: 3, leaf buckets: 3626, nodes: 2195437
Average node length: 6.87, total dup: 1579971, max dup: 49
Average key length: 3.92, compression ratio: 2.30
Average prefix length: 7.36, average data length: 1.64
Clustering factor: 280421, ratio: 0.13
Fill distribution:
0 - 19% = 152
20 - 39% = 1167
40 - 59% = 1111
60 - 79% = 511
80 - 99% = 685

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.54, total records: 682426
Average version length: 61.60, total versions: 200, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8584
Data pages: 8584, average fill: 76%
Primary pages: 8584, secondary pages: 0, swept pages: 7947
Empty pages: 3, full pages: 8549
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 1
60 - 79% = 8568
80 - 99% = 11

Index DOC_LIST_ID_DESC (1)
Root page: 244310, depth: 3, leaf buckets: 2479, nodes: 682426
Average node length: 11.67, total dup: 0, max dup: 0
Average key length: 8.80, compression ratio: 1.02
Average prefix length: 3.20, average data length: 5.80
Clustering factor: 143201, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 1304
40 - 59% = 1079
60 - 79% = 89
80 - 99% = 7

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 709, nodes: 682426
Average node length: 4.88, total dup: 682376, max dup: 35543
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 309389, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 588
60 - 79% = 94
80 - 99% = 27

Index PK_DOC_LIST (0)
Root page: 336322, depth: 3, leaf buckets: 1654, nodes: 682426
Average node length: 11.67, total dup: 0, max dup: 0
Average key length: 8.80, compression ratio: 1.02
Average prefix length: 3.20, average data length: 5.80
Clustering factor: 143201, ratio: 0.21
Fill distribution:
0 - 19% = 74
20 - 39% = 278
40 - 59% = 476
60 - 79% = 408
80 - 99% = 418

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

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

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

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

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

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

INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 62.60, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 15.32, total fragments: 339, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.66
Pointer pages: 1, data page slots: 88
Data pages: 40, average fill: 17%
Primary pages: 4, secondary pages: 36, swept pages: 4
Empty pages: 18, full pages: 3
Fill distribution:
0 - 19% = 29
20 - 39% = 7
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 71.15, total records: 640
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: 96.00, compression ratio: 1.35
Pointer pages: 1, data page slots: 248
Data pages: 88, average fill: 9%
Primary pages: 88, secondary pages: 0, swept pages: 74
Empty pages: 49, full pages: 0
Fill distribution:
0 - 19% = 72
20 - 39% = 13
40 - 59% = 3
60 - 79% = 0
80 - 99% = 0

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 5, nodes: 640
Average node length: 20.26, total dup: 0, max dup: 0
Average key length: 18.35, compression ratio: 1.47
Average prefix length: 11.64, average data length: 15.36
Clustering factor: 492, ratio: 0.77
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0

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

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

MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 40.62, total records: 69
Average version length: 43.29, total versions: 7, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.58
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 5%
Primary pages: 14, secondary pages: 2, swept pages: 12
Empty pages: 6, full pages: 0
Fill distribution:
0 - 19% = 15
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 558717, depth: 2, leaf buckets: 1, nodes: 69
Average node length: 10.12, total dup: 38, max dup: 11
Average key length: 8.99, compression ratio: 2.11
Average prefix length: 12.45, average data length: 6.55
Clustering factor: 55, ratio: 0.80
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 18.29, total records: 760430
Average version length: 42.97, total versions: 151, max versions: 3
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.50
Pointer pages: 3, data page slots: 4384
Data pages: 4384, average fill: 75%
Primary pages: 4383, secondary pages: 1, swept pages: 3815
Empty pages: 1, full pages: 4189
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 15
60 - 79% = 3974
80 - 99% = 390

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 229, nodes: 210049
Average node length: 4.89, total dup: 210000, max dup: 8248
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 28963, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 29
40 - 59% = 136
60 - 79% = 50
80 - 99% = 13

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 247, nodes: 210049
Average node length: 5.82, total dup: 189568, max dup: 40
Average key length: 2.94, compression ratio: 7.48
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 32256, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 19
40 - 59% = 115
60 - 79% = 72
80 - 99% = 41

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 242, nodes: 210049
Average node length: 5.82, total dup: 189568, max dup: 40
Average key length: 2.94, compression ratio: 7.48
Average prefix length: 21.16, average data length: 0.84
Clustering factor: 32265, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 23
40 - 59% = 91
60 - 79% = 81
80 - 99% = 46

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 240, nodes: 210049
Average node length: 5.61, total dup: 189568, max dup: 40
Average key length: 2.73, compression ratio: 3.30
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 32284, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 23
40 - 59% = 97
60 - 79% = 78
80 - 99% = 42

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 625454, depth: 2, leaf buckets: 232, nodes: 280146
Average node length: 4.54, total dup: 279966, max dup: 2346
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 41254, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 101
60 - 79% = 71
80 - 99% = 59

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

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

PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.98, total records: 13925471
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.16
Pointer pages: 203, data page slots: 331136
Data pages: 331136, average fill: 87%
Primary pages: 331136, secondary pages: 0, swept pages: 3
Empty pages: 4, full pages: 331131
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 331131

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 16728, nodes: 13925471
Average node length: 5.72, total dup: 13070819, max dup: 144
Average key length: 2.15, compression ratio: 3.71
Average prefix length: 7.88, average data length: 0.11
Clustering factor: 2303415, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 11286
60 - 79% = 3499
80 - 99% = 1941

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 14149, nodes: 13925471
Average node length: 4.69, total dup: 13925467, max dup: 12271951
Average key length: 1.12, compression ratio: 0.53
Average prefix length: 0.59, average data length: 0.00
Clustering factor: 395530, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 14146
60 - 79% = 0
80 - 99% = 3

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 17704, nodes: 13925471
Average node length: 5.77, total dup: 13552392, max dup: 28772
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 742031, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 14321
60 - 79% = 1938
80 - 99% = 1443

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 17120, nodes: 13925471
Average node length: 5.63, total dup: 13908767, max dup: 2209302
Average key length: 2.06, compression ratio: 18.43
Average prefix length: 37.90, average data length: 0.06
Clustering factor: 5983778, ratio: 0.43
Fill distribution:
0 - 19% = 16
20 - 39% = 0
40 - 59% = 15008
60 - 79% = 333
80 - 99% = 1763

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

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

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

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

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

PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.20, total records: 467178
Average version length: 55.48, total versions: 431, 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: 5528
Data pages: 5528, average fill: 75%
Primary pages: 5528, secondary pages: 0, swept pages: 3761
Empty pages: 3, full pages: 5479
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 4
60 - 79% = 5518
80 - 99% = 3

Index PSTORNED_RCV_ID (2)
Root page: 723704, depth: 3, leaf buckets: 587, nodes: 467178
Average node length: 5.87, total dup: 398382, max dup: 630
Average key length: 3.08, compression ratio: 2.93
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 58681, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 45
40 - 59% = 325
60 - 79% = 143
80 - 99% = 74

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 496, nodes: 467178
Average node length: 5.62, total dup: 415733, max dup: 150
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 115266, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 196
60 - 79% = 203
80 - 99% = 93

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 46.63, total records: 4155
Average version length: 72.21, total versions: 1471, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.92
Pointer pages: 1, data page slots: 312
Data pages: 296, average fill: 18%
Primary pages: 295, secondary pages: 1, swept pages: 121
Empty pages: 134, full pages: 18
Fill distribution:
0 - 19% = 198
20 - 39% = 43
40 - 59% = 30
60 - 79% = 23
80 - 99% = 2

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 7, nodes: 4155
Average node length: 6.96, total dup: 3596, max dup: 14
Average key length: 5.04, compression ratio: 7.34
Average prefix length: 34.09, average data length: 2.91
Clustering factor: 633, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 3
60 - 79% = 1
80 - 99% = 1

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 72.04, total records: 764094
Average version length: 71.96, total versions: 1627, 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: 7, data page slots: 11392
Data pages: 11392, average fill: 74%
Primary pages: 11392, secondary pages: 0, swept pages: 7612
Empty pages: 11, full pages: 8763
Fill distribution:
0 - 19% = 31
20 - 39% = 129
40 - 59% = 464
60 - 79% = 10757
80 - 99% = 11

Index XQD_1000_3300_DOC (1)
Root page: 670215, depth: 3, leaf buckets: 665, nodes: 764094
Average node length: 5.10, total dup: 743616, max dup: 126
Average key length: 2.19, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 80842, ratio: 0.11
Fill distribution:
0 - 19% = 7
20 - 39% = 39
40 - 59% = 253
60 - 79% = 40
80 - 99% = 326

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 255536, depth: 3, leaf buckets: 1072, nodes: 764094
Average node length: 6.21, total dup: 667599, max dup: 14
Average key length: 3.31, compression ratio: 11.18
Average prefix length: 35.82, average data length: 1.18
Clustering factor: 149625, ratio: 0.20
Fill distribution:
0 - 19% = 25
20 - 39% = 137
40 - 59% = 626
60 - 79% = 149
80 - 99% = 135

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 12.23, total records: 91658
Average version length: 72.14, total versions: 1623, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 11.12
Pointer pages: 2, data page slots: 2616
Data pages: 2232, average fill: 17%
Primary pages: 2229, secondary pages: 3, swept pages: 1480
Empty pages: 625, full pages: 83
Fill distribution:
0 - 19% = 1577
20 - 39% = 269
40 - 59% = 240
60 - 79% = 92
80 - 99% = 54

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 12, nodes: 6541
Average node length: 6.24, total dup: 5820, max dup: 42
Average key length: 4.30, compression ratio: 8.61
Average prefix length: 34.81, average data length: 2.19
Clustering factor: 811, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 6
60 - 79% = 1
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 47.36, total records: 2656508
Average version length: 71.52, total versions: 15755, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.87
Pointer pages: 20, data page slots: 32552
Data pages: 32528, average fill: 65%
Primary pages: 32528, secondary pages: 0, swept pages: 8208
Empty pages: 182, full pages: 31277
Fill distribution:
0 - 19% = 313
20 - 39% = 6895
40 - 59% = 1719
60 - 79% = 19588
80 - 99% = 4013

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 193171, depth: 3, leaf buckets: 2506, nodes: 1630392
Average node length: 5.61, total dup: 1535226, max dup: 49
Average key length: 2.64, compression ratio: 14.03
Average prefix length: 36.42, average data length: 0.58
Clustering factor: 138758, ratio: 0.09
Fill distribution:
0 - 19% = 23
20 - 39% = 1098
40 - 59% = 984
60 - 79% = 217
80 - 99% = 184

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.00, total records: 4672605
Average version length: 71.98, total versions: 43, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.11
Pointer pages: 19, data page slots: 29448
Data pages: 29432, average fill: 51%
Primary pages: 29432, secondary pages: 0, swept pages: 10709
Empty pages: 122, full pages: 29075
Fill distribution:
0 - 19% = 243
20 - 39% = 10103
40 - 59% = 6173
60 - 79% = 12763
80 - 99% = 150

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 1, nodes: 109
Average node length: 12.06, total dup: 82, max dup: 12
Average key length: 9.05, compression ratio: 4.09
Average prefix length: 30.19, average data length: 6.81
Clustering factor: 26, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 62.66, total records: 3367139
Average version length: 71.37, total versions: 5887, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.17
Pointer pages: 27, data page slots: 42776
Data pages: 42776, average fill: 77%
Primary pages: 42776, secondary pages: 0, swept pages: 30205
Empty pages: 0, full pages: 42633
Fill distribution:
0 - 19% = 0
20 - 39% = 231
40 - 59% = 631
60 - 79% = 39190
80 - 99% = 2724

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5991, nodes: 2894941
Average node length: 6.89, total dup: 2336919, max dup: 14
Average key length: 3.91, compression ratio: 9.46
Average prefix length: 35.28, average data length: 1.72
Clustering factor: 440850, ratio: 0.15
Fill distribution:
0 - 19% = 10
20 - 39% = 3211
40 - 59% = 2234
60 - 79% = 313
80 - 99% = 223

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.73, total records: 4767113
Average version length: 84.21, total versions: 470, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 45, data page slots: 73208
Data pages: 73208, average fill: 80%
Primary pages: 73208, secondary pages: 0, swept pages: 26595
Empty pages: 2, full pages: 73091
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 7
60 - 79% = 20502
80 - 99% = 52696

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4963, nodes: 4767113
Average node length: 5.16, total dup: 4658641, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 714034, ratio: 0.15
Fill distribution:
0 - 19% = 21
20 - 39% = 86
40 - 59% = 2301
60 - 79% = 2138
80 - 99% = 417

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 4306, nodes: 4767113
Average node length: 5.70, total dup: 4260853, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 143462, ratio: 0.03
Fill distribution:
0 - 19% = 22
20 - 39% = 95
40 - 59% = 1196
60 - 79% = 288
80 - 99% = 2705

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5477, nodes: 4767113
Average node length: 5.81, total dup: 4171245, max dup: 27
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 769372, ratio: 0.16
Fill distribution:
0 - 19% = 30
20 - 39% = 97
40 - 59% = 2358
60 - 79% = 2367
80 - 99% = 625

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.55, total records: 2812172
Average version length: 83.49, total versions: 4987, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 27, data page slots: 43504
Data pages: 43504, average fill: 80%
Primary pages: 43504, secondary pages: 0, swept pages: 31655
Empty pages: 6, full pages: 43424
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 14
60 - 79% = 14384
80 - 99% = 29100

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2938, nodes: 2812172
Average node length: 5.15, total dup: 2746608, max dup: 150
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 454660, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 32
40 - 59% = 1616
60 - 79% = 945
80 - 99% = 344

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4256, nodes: 2812172
Average node length: 6.27, total dup: 2289146, max dup: 14
Average key length: 3.29, compression ratio: 2.73
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 210124, ratio: 0.07
Fill distribution:
0 - 19% = 101
20 - 39% = 1336
40 - 59% = 1539
60 - 79% = 679
80 - 99% = 601

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3346, nodes: 2812172
Average node length: 5.81, total dup: 2460264, max dup: 38
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 546966, ratio: 0.19
Fill distribution:
0 - 19% = 17
20 - 39% = 45
40 - 59% = 1854
60 - 79% = 1067
80 - 99% = 363

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.89, total records: 5062876
Average version length: 84.40, total versions: 1606, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 48, data page slots: 78096
Data pages: 77960, average fill: 80%
Primary pages: 77960, secondary pages: 0, swept pages: 15116
Empty pages: 426, full pages: 76975
Fill distribution:
0 - 19% = 509
20 - 39% = 128
40 - 59% = 185
60 - 79% = 10254
80 - 99% = 66884

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5116, nodes: 5062876
Average node length: 5.04, total dup: 5033105, max dup: 660
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 710672, ratio: 0.14
Fill distribution:
0 - 19% = 4
20 - 39% = 128
40 - 59% = 2610
60 - 79% = 1677
80 - 99% = 697

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5507, nodes: 5062876
Average node length: 5.51, total dup: 4671498, max dup: 49
Average key length: 2.53, compression ratio: 3.56
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 143269, ratio: 0.03
Fill distribution:
0 - 19% = 106
20 - 39% = 1116
40 - 59% = 1770
60 - 79% = 756
80 - 99% = 1759

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5795, nodes: 5062876
Average node length: 5.69, total dup: 4535113, max dup: 62
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 787088, ratio: 0.16
Fill distribution:
0 - 19% = 5
20 - 39% = 109
40 - 59% = 3081
60 - 79% = 1808
80 - 99% = 792

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

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

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

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

XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.65, total records: 3451181
Average version length: 83.64, total versions: 4614, 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: 33, data page slots: 53424
Data pages: 53424, average fill: 80%
Primary pages: 53424, secondary pages: 0, swept pages: 38265
Empty pages: 29, full pages: 52792
Fill distribution:
0 - 19% = 47
20 - 39% = 51
40 - 59% = 153
60 - 79% = 15108
80 - 99% = 38065

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3815, nodes: 3451181
Average node length: 5.03, total dup: 3434493, max dup: 1223
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 621452, ratio: 0.18
Fill distribution:
0 - 19% = 25
20 - 39% = 454
40 - 59% = 2081
60 - 79% = 835
80 - 99% = 420

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 5170, nodes: 3451181
Average node length: 6.27, total dup: 2809217, max dup: 14
Average key length: 3.29, compression ratio: 2.73
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 275025, ratio: 0.08
Fill distribution:
0 - 19% = 135
20 - 39% = 1624
40 - 59% = 1791
60 - 79% = 815
80 - 99% = 805

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4167, nodes: 3451181
Average node length: 5.58, total dup: 3153579, max dup: 59
Average key length: 2.60, compression ratio: 3.47
Average prefix length: 8.49, average data length: 0.51
Clustering factor: 672190, ratio: 0.19
Fill distribution:
0 - 19% = 13
20 - 39% = 437
40 - 59% = 2238
60 - 79% = 993
80 - 99% = 486

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.46, total records: 558210
Average version length: 69.56, total versions: 697, 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: 7672
Data pages: 7672, average fill: 77%
Primary pages: 7672, secondary pages: 0, swept pages: 5975
Empty pages: 4, full pages: 7509
Fill distribution:
0 - 19% = 7
20 - 39% = 11
40 - 59% = 31
60 - 79% = 7607
80 - 99% = 16

Index XQS_3300_3400_DOC_ID (0)
Root page: 226214, depth: 3, leaf buckets: 699, nodes: 558210
Average node length: 5.36, total dup: 521342, max dup: 119
Average key length: 2.50, compression ratio: 3.60
Average prefix length: 8.56, average data length: 0.44
Clustering factor: 52876, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 184
40 - 59% = 274
60 - 79% = 169
80 - 99% = 69

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 784, nodes: 558210
Average node length: 5.94, total dup: 473917, max dup: 14
Average key length: 3.09, compression ratio: 2.92
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 55294, ratio: 0.10
Fill distribution:
0 - 19% = 4
20 - 39% = 203
40 - 59% = 335
60 - 79% = 180
80 - 99% = 62

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Gstat completion time Tue May 22 11:56:31 2018

Done for 111010 ms, from 11:54:40.25 to 11:56:31.26.

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	2195437	1044	0.0475
DOC_LIST	682426	200	0.0293
DOC_STATES	4	0	0.0000
FB_ERRORS	758	0	0.0000
INVNT_SALDO	400	0	0.0000
INVNT_TURNOVER_LOG	640	0	0.0000
MONEY_SALDO	49	0	0.0000
MONEY_TURNOVER_LOG	69	7	10.1449
OPTYPES	9	0	0.0000
PDISTR	760430	151	0.0198
PERF_ESTIMATED	280146	0	0.0000
PERF_LOG	13925471	0	0.0000
PSTORNED	467178	431	0.0922
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	2922	0	0.0000
WARES	400	0	0.0000
WARE_GROUPS	8	0	0.0000
XQD_1000_1200	4155	1471	35.4031
XQD_1000_3300	764094	1627	0.2129
XQD_1200_2000	91658	1623	1.7707
XQD_2000_3300	2656508	15755	0.5930
XQD_2100_3300	4672605	43	0.0009
XQD_3300_3400	3367139	5887	0.1748
XQS_1000_1200	4767113	470	0.0098
XQS_1000_3300	2812172	4987	0.1773
XQS_1200_2000	5062876	1606	0.0317
XQS_2100_3300	3451181	4614	0.1336
XQS_3300_3400	558210	697	0.1248
Z_USED_VIEWS	29	0	0.0000

Done for 2630 ms, from 11:56:42.85 to 11:56:45.48.

Database validation

11:56:45.61 Validation started

11:56:45.61 Relation 140 (DOC_LIST)
11:56:45.62 process pointer page 0 of 6
11:56:45.72 process pointer page 1 of 6
11:56:45.81 process pointer page 2 of 6
11:56:45.92 process pointer page 3 of 6
11:56:46.01 process pointer page 4 of 6
11:56:46.11 process pointer page 5 of 6
11:56:46.12 Index 1 (PK_DOC_LIST)
11:56:46.39 Index 2 (DOC_LIST_ID_DESC)
11:56:46.59 Index 3 (FK_DOC_LIST_AGENTS)
11:56:46.79 Relation 140 (DOC_LIST) is ok

11:56:46.79 Relation 141 (DOC_DATA)
11:56:46.79 process pointer page 0 of 15
11:56:46.89 process pointer page 1 of 15
11:56:46.98 process pointer page 2 of 15
11:56:47.08 process pointer page 3 of 15
11:56:47.17 process pointer page 4 of 15
11:56:47.25 process pointer page 5 of 15
11:56:47.34 process pointer page 6 of 15
11:56:47.43 process pointer page 7 of 15
11:56:47.53 process pointer page 8 of 15
11:56:47.62 process pointer page 9 of 15
11:56:47.72 process pointer page 10 of 15
11:56:47.81 process pointer page 11 of 15
11:56:47.90 process pointer page 12 of 15
11:56:47.98 process pointer page 13 of 15
11:56:48.07 process pointer page 14 of 15
11:56:48.12 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:56:49.18 Index 3 (DOC_DATA_ID_DESC)
11:56:49.82 Index 4 (FK_DOC_DATA_DOC_LIST)
11:56:50.16 Relation 141 (DOC_DATA) is ok

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

11:56:50.16 Relation 150 (PDISTR)
11:56:50.16 process pointer page 0 of 3
11:56:50.20 process pointer page 1 of 3
11:56:50.24 process pointer page 2 of 3
11:56:50.27 Index 2 (PDISTR_SND_ID)
11:56:50.35 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:56:50.38 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:56:50.41 Index 5 (PDISTR_AGENT_ID)
11:56:50.45 Relation 150 (PDISTR) is ok

11:56:50.45 Relation 151 (PSTORNED)
11:56:50.45 process pointer page 0 of 4
11:56:50.54 process pointer page 1 of 4
11:56:50.66 process pointer page 2 of 4
11:56:50.74 process pointer page 3 of 4
11:56:50.79 Index 2 (PSTORNED_SND_ID)
11:56:50.94 Index 3 (PSTORNED_RCV_ID)
11:56:51.08 Relation 151 (PSTORNED) is ok

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

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

11:56:51.08 Relation 160 (PERF_ESTIMATED)
11:56:51.08 process pointer page 0 of 2
11:56:51.18 process pointer page 1 of 2
11:56:51.23 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:56:51.30 Relation 160 (PERF_ESTIMATED) is ok

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

11:56:51.30 Relation 162 (TRACE_STAT)
11:56:51.30 process pointer page 0 of 1
11:56:51.30 Relation 162 (TRACE_STAT) is ok

11:56:51.30 Relation 163 (PERF_LOG)
11:56:51.30 process pointer page 0 of 203
11:56:51.38 process pointer page 1 of 203
11:56:51.47 process pointer page 2 of 203
11:56:51.55 process pointer page 3 of 203
11:56:51.65 process pointer page 4 of 203
11:56:51.72 process pointer page 5 of 203
11:56:51.80 process pointer page 6 of 203
11:56:51.90 process pointer page 7 of 203
11:56:51.97 process pointer page 8 of 203
11:56:52.07 process pointer page 9 of 203
11:56:52.15 process pointer page 10 of 203
11:56:52.22 process pointer page 11 of 203
11:56:52.32 process pointer page 12 of 203
11:56:52.40 process pointer page 13 of 203
11:56:52.49 process pointer page 14 of 203
11:56:52.57 process pointer page 15 of 203
11:56:52.64 process pointer page 16 of 203
11:56:52.74 process pointer page 17 of 203
11:56:52.82 process pointer page 18 of 203
11:56:52.91 process pointer page 19 of 203
11:56:52.99 process pointer page 20 of 203
11:56:53.08 process pointer page 21 of 203
11:56:53.16 process pointer page 22 of 203
11:56:53.24 process pointer page 23 of 203
11:56:53.33 process pointer page 24 of 203
11:56:53.41 process pointer page 25 of 203
11:56:53.50 process pointer page 26 of 203
11:56:53.58 process pointer page 27 of 203
11:56:53.67 process pointer page 28 of 203
11:56:53.75 process pointer page 29 of 203
11:56:53.83 process pointer page 30 of 203
11:56:53.92 process pointer page 31 of 203
11:56:54.00 process pointer page 32 of 203
11:56:54.10 process pointer page 33 of 203
11:56:54.17 process pointer page 34 of 203
11:56:54.25 process pointer page 35 of 203
11:56:54.35 process pointer page 36 of 203
11:56:54.42 process pointer page 37 of 203
11:56:54.50 process pointer page 38 of 203
11:56:54.58 process pointer page 39 of 203
11:56:54.67 process pointer page 40 of 203
11:56:54.75 process pointer page 41 of 203
11:56:54.83 process pointer page 42 of 203
11:56:54.91 process pointer page 43 of 203
11:56:54.98 process pointer page 44 of 203
11:56:55.08 process pointer page 45 of 203
11:56:55.16 process pointer page 46 of 203
11:56:55.23 process pointer page 47 of 203
11:56:55.31 process pointer page 48 of 203
11:56:55.39 process pointer page 49 of 203
11:56:55.48 process pointer page 50 of 203
11:56:55.56 process pointer page 51 of 203
11:56:55.64 process pointer page 52 of 203
11:56:55.72 process pointer page 53 of 203
11:56:55.81 process pointer page 54 of 203
11:56:55.89 process pointer page 55 of 203
11:56:55.97 process pointer page 56 of 203
11:56:56.05 process pointer page 57 of 203
11:56:56.12 process pointer page 58 of 203
11:56:56.22 process pointer page 59 of 203
11:56:56.30 process pointer page 60 of 203
11:56:56.37 process pointer page 61 of 203
11:56:56.45 process pointer page 62 of 203
11:56:56.53 process pointer page 63 of 203
11:56:56.62 process pointer page 64 of 203
11:56:56.70 process pointer page 65 of 203
11:56:56.78 process pointer page 66 of 203
11:56:56.86 process pointer page 67 of 203
11:56:56.95 process pointer page 68 of 203
11:56:57.03 process pointer page 69 of 203
11:56:57.11 process pointer page 70 of 203
11:56:57.18 process pointer page 71 of 203
11:56:57.26 process pointer page 72 of 203
11:56:57.36 process pointer page 73 of 203
11:56:57.43 process pointer page 74 of 203
11:56:57.51 process pointer page 75 of 203
11:56:57.59 process pointer page 76 of 203
11:56:57.68 process pointer page 77 of 203
11:56:57.76 process pointer page 78 of 203
11:56:57.84 process pointer page 79 of 203
11:56:57.92 process pointer page 80 of 203
11:56:58.00 process pointer page 81 of 203
11:56:58.09 process pointer page 82 of 203
11:56:58.17 process pointer page 83 of 203
11:56:58.25 process pointer page 84 of 203
11:56:58.32 process pointer page 85 of 203
11:56:58.42 process pointer page 86 of 203
11:56:58.49 process pointer page 87 of 203
11:56:58.57 process pointer page 88 of 203
11:56:58.65 process pointer page 89 of 203
11:56:58.74 process pointer page 90 of 203
11:56:58.82 process pointer page 91 of 203
11:56:58.90 process pointer page 92 of 203
11:56:58.98 process pointer page 93 of 203
11:56:59.07 process pointer page 94 of 203
11:56:59.15 process pointer page 95 of 203
11:56:59.23 process pointer page 96 of 203
11:56:59.31 process pointer page 97 of 203
11:56:59.40 process pointer page 98 of 203
11:56:59.48 process pointer page 99 of 203
11:56:59.56 process pointer page 100 of 203
11:56:59.63 process pointer page 101 of 203
11:56:59.73 process pointer page 102 of 203
11:56:59.81 process pointer page 103 of 203
11:56:59.88 process pointer page 104 of 203
11:56:59.96 process pointer page 105 of 203
11:57:00.04 process pointer page 106 of 203
11:57:00.13 process pointer page 107 of 203
11:57:00.21 process pointer page 108 of 203
11:57:00.29 process pointer page 109 of 203
11:57:00.37 process pointer page 110 of 203
11:57:00.46 process pointer page 111 of 203
11:57:00.54 process pointer page 112 of 203
11:57:00.62 process pointer page 113 of 203
11:57:00.71 process pointer page 114 of 203
11:57:00.79 process pointer page 115 of 203
11:57:00.83 process pointer page 116 of 203
11:57:00.87 process pointer page 117 of 203
11:57:00.90 process pointer page 118 of 203
11:57:00.93 process pointer page 119 of 203
11:57:00.96 process pointer page 120 of 203
11:57:00.99 process pointer page 121 of 203
11:57:01.02 process pointer page 122 of 203
11:57:01.05 process pointer page 123 of 203
11:57:01.08 process pointer page 124 of 203
11:57:01.12 process pointer page 125 of 203
11:57:01.13 process pointer page 126 of 203
11:57:01.16 process pointer page 127 of 203
11:57:01.19 process pointer page 128 of 203
11:57:01.21 process pointer page 129 of 203
11:57:01.24 process pointer page 130 of 203
11:57:01.27 process pointer page 131 of 203
11:57:01.30 process pointer page 132 of 203
11:57:01.33 process pointer page 133 of 203
11:57:01.35 process pointer page 134 of 203
11:57:01.38 process pointer page 135 of 203
11:57:01.41 process pointer page 136 of 203
11:57:01.44 process pointer page 137 of 203
11:57:01.47 process pointer page 138 of 203
11:57:01.51 process pointer page 139 of 203
11:57:01.54 process pointer page 140 of 203
11:57:01.58 process pointer page 141 of 203
11:57:01.66 process pointer page 142 of 203
11:57:01.74 process pointer page 143 of 203
11:57:01.82 process pointer page 144 of 203
11:57:01.91 process pointer page 145 of 203
11:57:01.99 process pointer page 146 of 203
11:57:02.07 process pointer page 147 of 203
11:57:02.15 process pointer page 148 of 203
11:57:02.22 process pointer page 149 of 203
11:57:02.32 process pointer page 150 of 203
11:57:02.39 process pointer page 151 of 203
11:57:02.47 process pointer page 152 of 203
11:57:02.55 process pointer page 153 of 203
11:57:02.66 process pointer page 154 of 203
11:57:02.74 process pointer page 155 of 203
11:57:02.83 process pointer page 156 of 203
11:57:02.91 process pointer page 157 of 203
11:57:02.99 process pointer page 158 of 203
11:57:03.08 process pointer page 159 of 203
11:57:03.16 process pointer page 160 of 203
11:57:03.24 process pointer page 161 of 203
11:57:03.32 process pointer page 162 of 203
11:57:03.41 process pointer page 163 of 203
11:57:03.49 process pointer page 164 of 203
11:57:03.56 process pointer page 165 of 203
11:57:03.64 process pointer page 166 of 203
11:57:03.72 process pointer page 167 of 203
11:57:03.81 process pointer page 168 of 203
11:57:03.89 process pointer page 169 of 203
11:57:03.97 process pointer page 170 of 203
11:57:04.05 process pointer page 171 of 203
11:57:04.14 process pointer page 172 of 203
11:57:04.22 process pointer page 173 of 203
11:57:04.30 process pointer page 174 of 203
11:57:04.38 process pointer page 175 of 203
11:57:04.47 process pointer page 176 of 203
11:57:04.55 process pointer page 177 of 203
11:57:04.63 process pointer page 178 of 203
11:57:04.70 process pointer page 179 of 203
11:57:04.80 process pointer page 180 of 203
11:57:04.88 process pointer page 181 of 203
11:57:04.95 process pointer page 182 of 203
11:57:05.03 process pointer page 183 of 203
11:57:05.12 process pointer page 184 of 203
11:57:05.20 process pointer page 185 of 203
11:57:05.28 process pointer page 186 of 203
11:57:05.37 process pointer page 187 of 203
11:57:05.45 process pointer page 188 of 203
11:57:05.53 process pointer page 189 of 203
11:57:05.61 process pointer page 190 of 203
11:57:05.70 process pointer page 191 of 203
11:57:05.78 process pointer page 192 of 203
11:57:05.86 process pointer page 193 of 203
11:57:05.95 process pointer page 194 of 203
11:57:06.03 process pointer page 195 of 203
11:57:06.11 process pointer page 196 of 203
11:57:06.19 process pointer page 197 of 203
11:57:06.28 process pointer page 198 of 203
11:57:06.36 process pointer page 199 of 203
11:57:06.44 process pointer page 200 of 203
11:57:06.51 process pointer page 201 of 203
11:57:06.59 process pointer page 202 of 203
11:57:06.67 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:57:11.02 Index 2 (PERF_LOG_UNIT)
11:57:17.23 Index 3 (PERF_LOG_TRN_DESC)
11:57:21.05 Index 4 (PERF_LOG_GDSCODE)
11:57:24.09 Relation 163 (PERF_LOG) is ok

11:57:24.09 Relation 167 (V_STOPTEST)
11:57:24.09 Relation 167 (V_STOPTEST) is ok

11:57:24.09 Relation 184 (V_QDISTR_SOURCE)
11:57:24.09 Relation 184 (V_QDISTR_SOURCE) is ok

11:57:24.09 Relation 185 (V_QSTORNED_SOURCE)
11:57:24.09 Relation 185 (V_QSTORNED_SOURCE) is ok

11:57:24.09 Relation 260 (XQD_1000_1200)
11:57:24.09 process pointer page 0 of 1
11:57:24.11 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:57:24.13 Relation 260 (XQD_1000_1200) is ok

11:57:24.13 Relation 261 (XQD_1200_2000)
11:57:24.13 process pointer page 0 of 2
11:57:24.17 process pointer page 1 of 2
11:57:24.20 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:57:24.20 Relation 261 (XQD_1200_2000) is ok

11:57:24.20 Relation 262 (XQD_1000_3300)
11:57:24.20 process pointer page 0 of 7
11:57:24.30 process pointer page 1 of 7
11:57:24.39 process pointer page 2 of 7
11:57:24.47 process pointer page 3 of 7
11:57:24.50 process pointer page 4 of 7
11:57:24.55 process pointer page 5 of 7
11:57:24.62 process pointer page 6 of 7
11:57:24.67 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:57:24.97 Index 2 (XQD_1000_3300_DOC)
11:57:25.19 Relation 262 (XQD_1000_3300) is ok

11:57:25.19 Relation 263 (XQD_2000_3300)
11:57:25.19 process pointer page 0 of 20
11:57:25.26 process pointer page 1 of 20
11:57:25.36 process pointer page 2 of 20
11:57:25.44 process pointer page 3 of 20
11:57:25.51 process pointer page 4 of 20
11:57:25.59 process pointer page 5 of 20
11:57:25.69 process pointer page 6 of 20
11:57:25.76 process pointer page 7 of 20
11:57:25.84 process pointer page 8 of 20
11:57:25.92 process pointer page 9 of 20
11:57:26.01 process pointer page 10 of 20
11:57:26.09 process pointer page 11 of 20
11:57:26.18 process pointer page 12 of 20
11:57:26.26 process pointer page 13 of 20
11:57:26.34 process pointer page 14 of 20
11:57:26.43 process pointer page 15 of 20
11:57:26.51 process pointer page 16 of 20
11:57:26.59 process pointer page 17 of 20
11:57:26.70 process pointer page 18 of 20
11:57:26.78 process pointer page 19 of 20
11:57:26.87 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:57:27.40 Relation 263 (XQD_2000_3300) is ok

11:57:27.40 Relation 264 (XQD_2100_3300)
11:57:27.40 process pointer page 0 of 19
11:57:27.46 process pointer page 1 of 19
11:57:27.54 process pointer page 2 of 19
11:57:27.60 process pointer page 3 of 19
11:57:27.68 process pointer page 4 of 19
11:57:27.74 process pointer page 5 of 19
11:57:27.81 process pointer page 6 of 19
11:57:27.89 process pointer page 7 of 19
11:57:27.95 process pointer page 8 of 19
11:57:28.03 process pointer page 9 of 19
11:57:28.09 process pointer page 10 of 19
11:57:28.15 process pointer page 11 of 19
11:57:28.21 process pointer page 12 of 19
11:57:28.29 process pointer page 13 of 19
11:57:28.35 process pointer page 14 of 19
11:57:28.42 process pointer page 15 of 19
11:57:28.49 process pointer page 16 of 19
11:57:28.56 process pointer page 17 of 19
11:57:28.62 process pointer page 18 of 19
11:57:28.62 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:57:28.63 Relation 264 (XQD_2100_3300) is ok

11:57:28.63 Relation 265 (XQD_3300_3400)
11:57:28.63 process pointer page 0 of 27
11:57:28.71 process pointer page 1 of 27
11:57:28.81 process pointer page 2 of 27
11:57:28.90 process pointer page 3 of 27
11:57:28.99 process pointer page 4 of 27
11:57:29.09 process pointer page 5 of 27
11:57:29.16 process pointer page 6 of 27
11:57:29.26 process pointer page 7 of 27
11:57:29.35 process pointer page 8 of 27
11:57:29.48 process pointer page 9 of 27
11:57:29.85 process pointer page 10 of 27
11:57:30.26 process pointer page 11 of 27
11:57:30.63 process pointer page 12 of 27
11:57:31.01 process pointer page 13 of 27
11:57:31.33 process pointer page 14 of 27
11:57:31.69 process pointer page 15 of 27
11:57:32.07 process pointer page 16 of 27
11:57:32.46 process pointer page 17 of 27
11:57:32.89 process pointer page 18 of 27
11:57:33.33 process pointer page 19 of 27
11:57:33.75 process pointer page 20 of 27
11:57:34.17 process pointer page 21 of 27
11:57:34.58 process pointer page 22 of 27
11:57:34.92 process pointer page 23 of 27
11:57:35.22 process pointer page 24 of 27
11:57:35.51 process pointer page 25 of 27
11:57:35.79 process pointer page 26 of 27
11:57:35.84 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:57:38.01 Relation 265 (XQD_3300_3400) is ok

11:57:38.01 Relation 266 (XQS_1000_1200)
11:57:38.01 process pointer page 0 of 45
11:57:38.31 process pointer page 1 of 45
11:57:38.57 process pointer page 2 of 45
11:57:38.88 process pointer page 3 of 45
11:57:39.15 process pointer page 4 of 45
11:57:39.43 process pointer page 5 of 45
11:57:39.71 process pointer page 6 of 45
11:57:39.99 process pointer page 7 of 45
11:57:40.27 process pointer page 8 of 45
11:57:40.57 process pointer page 9 of 45
11:57:40.86 process pointer page 10 of 45
11:57:41.16 process pointer page 11 of 45
11:57:41.46 process pointer page 12 of 45
11:57:41.75 process pointer page 13 of 45
11:57:42.07 process pointer page 14 of 45
11:57:42.39 process pointer page 15 of 45
11:57:42.69 process pointer page 16 of 45
11:57:43.02 process pointer page 17 of 45
11:57:43.33 process pointer page 18 of 45
11:57:43.66 process pointer page 19 of 45
11:57:43.97 process pointer page 20 of 45
11:57:44.31 process pointer page 21 of 45
11:57:44.62 process pointer page 22 of 45
11:57:44.97 process pointer page 23 of 45
11:57:45.28 process pointer page 24 of 45
11:57:45.61 process pointer page 25 of 45
11:57:45.93 process pointer page 26 of 45
11:57:46.28 process pointer page 27 of 45
11:57:46.62 process pointer page 28 of 45
11:57:46.93 process pointer page 29 of 45
11:57:47.26 process pointer page 30 of 45
11:57:47.60 process pointer page 31 of 45
11:57:47.93 process pointer page 32 of 45
11:57:48.27 process pointer page 33 of 45
11:57:48.65 process pointer page 34 of 45
11:57:48.98 process pointer page 35 of 45
11:57:49.32 process pointer page 36 of 45
11:57:49.65 process pointer page 37 of 45
11:57:49.96 process pointer page 38 of 45
11:57:50.29 process pointer page 39 of 45
11:57:50.60 process pointer page 40 of 45
11:57:50.94 process pointer page 41 of 45
11:57:51.25 process pointer page 42 of 45
11:57:51.57 process pointer page 43 of 45
11:57:51.89 process pointer page 44 of 45
11:57:52.16 Index 1 (XQS_1000_1200_DOC_ID)
11:57:54.41 Index 2 (XQS_1000_1200_SND_ID)
11:57:56.81 Index 3 (XQS_1000_1200_RCV_ID)
11:57:58.66 Relation 266 (XQS_1000_1200) is ok

11:57:58.66 Relation 267 (XQS_1200_2000)
11:57:58.68 process pointer page 0 of 48
11:57:59.05 process pointer page 1 of 48
11:57:59.43 process pointer page 2 of 48
11:57:59.80 process pointer page 3 of 48
11:58:00.18 process pointer page 4 of 48
11:58:00.57 process pointer page 5 of 48
11:58:00.96 process pointer page 6 of 48
11:58:01.30 process pointer page 7 of 48
11:58:01.67 process pointer page 8 of 48
11:58:02.03 process pointer page 9 of 48
11:58:02.39 process pointer page 10 of 48
11:58:02.78 process pointer page 11 of 48
11:58:03.14 process pointer page 12 of 48
11:58:03.55 process pointer page 13 of 48
11:58:03.98 process pointer page 14 of 48
11:58:04.42 process pointer page 15 of 48
11:58:04.84 process pointer page 16 of 48
11:58:05.26 process pointer page 17 of 48
11:58:05.67 process pointer page 18 of 48
11:58:06.09 process pointer page 19 of 48
11:58:06.50 process pointer page 20 of 48
11:58:06.92 process pointer page 21 of 48
11:58:07.34 process pointer page 22 of 48
11:58:07.76 process pointer page 23 of 48
11:58:08.18 process pointer page 24 of 48
11:58:08.62 process pointer page 25 of 48
11:58:09.02 process pointer page 26 of 48
11:58:09.46 process pointer page 27 of 48
11:58:09.86 process pointer page 28 of 48
11:58:10.27 process pointer page 29 of 48
11:58:10.69 process pointer page 30 of 48
11:58:11.10 process pointer page 31 of 48
11:58:11.52 process pointer page 32 of 48
11:58:11.94 process pointer page 33 of 48
11:58:12.35 process pointer page 34 of 48
11:58:12.78 process pointer page 35 of 48
11:58:13.20 process pointer page 36 of 48
11:58:13.64 process pointer page 37 of 48
11:58:14.08 process pointer page 38 of 48
11:58:14.48 process pointer page 39 of 48
11:58:14.92 process pointer page 40 of 48
11:58:15.32 process pointer page 41 of 48
11:58:15.73 process pointer page 42 of 48
11:58:16.14 process pointer page 43 of 48
11:58:16.54 process pointer page 44 of 48
11:58:16.96 process pointer page 45 of 48
11:58:17.37 process pointer page 46 of 48
11:58:17.77 process pointer page 47 of 48
11:58:18.09 Index 1 (XQS_1200_2000_DOC_ID)
11:58:20.66 Index 2 (XQS_1200_2000_SND_ID)
11:58:23.50 Index 3 (XQS_1200_2000_RCV_ID)
11:58:25.42 Relation 267 (XQS_1200_2000) is ok

11:58:25.42 Relation 268 (XQS_1000_3300)
11:58:25.42 process pointer page 0 of 27
11:58:25.85 process pointer page 1 of 27
11:58:26.32 process pointer page 2 of 27
11:58:26.76 process pointer page 3 of 27
11:58:27.18 process pointer page 4 of 27
11:58:27.60 process pointer page 5 of 27
11:58:28.05 process pointer page 6 of 27
11:58:28.49 process pointer page 7 of 27
11:58:28.94 process pointer page 8 of 27
11:58:29.38 process pointer page 9 of 27
11:58:29.82 process pointer page 10 of 27
11:58:30.24 process pointer page 11 of 27
11:58:30.66 process pointer page 12 of 27
11:58:31.08 process pointer page 13 of 27
11:58:31.46 process pointer page 14 of 27
11:58:31.83 process pointer page 15 of 27
11:58:32.19 process pointer page 16 of 27
11:58:32.56 process pointer page 17 of 27
11:58:32.94 process pointer page 18 of 27
11:58:33.30 process pointer page 19 of 27
11:58:33.69 process pointer page 20 of 27
11:58:34.06 process pointer page 21 of 27
11:58:34.43 process pointer page 22 of 27
11:58:34.81 process pointer page 23 of 27
11:58:35.17 process pointer page 24 of 27
11:58:35.53 process pointer page 25 of 27
11:58:35.81 process pointer page 26 of 27
11:58:35.99 Index 1 (XQS_1000_3300_DOC_ID)
11:58:37.57 Index 2 (XQS_1000_3300_SND_ID)
11:58:39.29 Index 3 (XQS_1000_3300_RCV_ID)
11:58:40.83 Relation 268 (XQS_1000_3300) is ok

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

11:58:40.83 Relation 270 (XQS_2100_3300)
11:58:40.83 process pointer page 0 of 33
11:58:41.25 process pointer page 1 of 33
11:58:41.69 process pointer page 2 of 33
11:58:42.13 process pointer page 3 of 33
11:58:42.56 process pointer page 4 of 33
11:58:43.00 process pointer page 5 of 33
11:58:43.42 process pointer page 6 of 33
11:58:43.84 process pointer page 7 of 33
11:58:44.25 process pointer page 8 of 33
11:58:44.67 process pointer page 9 of 33
11:58:45.07 process pointer page 10 of 33
11:58:45.51 process pointer page 11 of 33
11:58:45.92 process pointer page 12 of 33
11:58:46.34 process pointer page 13 of 33
11:58:46.74 process pointer page 14 of 33
11:58:47.16 process pointer page 15 of 33
11:58:47.55 process pointer page 16 of 33
11:58:47.91 process pointer page 17 of 33
11:58:48.32 process pointer page 18 of 33
11:58:48.76 process pointer page 19 of 33
11:58:49.16 process pointer page 20 of 33
11:58:49.55 process pointer page 21 of 33
11:58:49.93 process pointer page 22 of 33
11:58:50.28 process pointer page 23 of 33
11:58:50.58 process pointer page 24 of 33
11:58:50.88 process pointer page 25 of 33
11:58:51.20 process pointer page 26 of 33
11:58:51.61 process pointer page 27 of 33
11:58:52.00 process pointer page 28 of 33
11:58:52.33 process pointer page 29 of 33
11:58:52.62 process pointer page 30 of 33
11:58:52.87 process pointer page 31 of 33
11:58:53.11 process pointer page 32 of 33
11:58:53.28 Index 1 (XQS_2100_3300_DOC_ID)
11:58:55.18 Index 2 (XQS_2100_3300_SND_ID)
11:58:57.23 Index 3 (XQS_2100_3300_RCV_ID)
11:58:59.11 Relation 270 (XQS_2100_3300) is ok

11:58:59.11 Relation 271 (XQS_3300_3400)
11:58:59.11 process pointer page 0 of 5
11:58:59.52 process pointer page 1 of 5
11:58:59.91 process pointer page 2 of 5
11:59:00.33 process pointer page 3 of 5
11:59:00.75 process pointer page 4 of 5
11:59:00.97 Index 1 (XQS_3300_3400_DOC_ID)
11:59:01.27 Index 2 (XQS_3300_3400_SND_ID)
11:59:01.49 Relation 271 (XQS_3300_3400) is ok

11:59:01.52 Validation finished
Done for 136340 ms, from 11:56:45.50 to 11:59:01.84.

Differences between old and current firebird.log

11:59:03.51. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2018-05-22 11:59 477 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Tue May 22 11:56:45 2018
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Tue May 22 11:59:01 2018
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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

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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND

ISQL logs are removed because no severe errors occured during test.
2018-05-22 11:59:13.70 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html

Test configuration settings

Performance reports

Differences between old and current firebird.log

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

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