Logs 2.5

Generated by E:\OLTP-HQBIRD\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 10. 2016-04-06 19:26:36.55.

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-V2.5.5.26952 Firebird 2.5 HQbird #20160215
Server implementation: Firebird/x86-64/Windows NT

FB_ARCHITECTURE	DB_NAME	FORCED_WRITES	SWEEP_INT	PAGE_BUFFERS	PAGE_SIZE
SuperClassic 2.5.5	D:\OLTP-HQBIRD\OLTP25-SMALL.FDB	ON	0	1024	8192

Test configuration settings

File: E:\OLTP-HQBIRD\src\oltp25_config.win

PARAM_NAME	PARAM_VALUE
fbc	C:\Firebird\fb25hqbird\bin
dbnm	D:\OLTP-HQBIRD\oltp25-small.fdb
host	localhost
port	3049
usr	SYSDBA
pwd	masterke
tmpdir	e:\temp\logs.hqbird.oltp25
working_mode	small_03
warm_time	10
test_time	30
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	0
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	ak25
upload_report	1

Test finish info

FINISH_STATE	DTS_END	FB_GDSCODE	FB_MNEMONA	STACK	IP	TRN_ID	ATT_ID	EXC_UNIT
NORMAL: TEST_TIME EXPIRED.	2016-04-06 19:25:28.1990	-1	<null>		127.0.0.1	106943	4538	2

Current test settings

CATEGORY	SETTING	VAL
COMMON	TRACED_UNITS	,,
COMMON	LOG_PK_VIOLATION	0
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
COMMON	ENABLE_MON_QUERY	0
COMMON	HALT_TEST_ON_ERRORS	,CK,
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 30 minutes:	6245.63	1970	187369	2016-04-06 18:55	2016-04-06 19:25
customer order: creation	114.40	62	3432	2016-04-06 18:55	2016-04-06 19:25
customer order: refuse	9.63	31	289	2016-04-06 18:55	2016-04-06 19:25
order to supplier: creation	29.37	216	881	2016-04-06 18:55	2016-04-06 19:25
order to supplier: removal	1.66	14836	48	2016-04-06 18:55	2016-04-06 19:25
invoice (draft): creation	29.03	374	871	2016-04-06 18:55	2016-04-06 19:25
invoice (draft): removal	18.97	89	569	2016-04-06 18:55	2016-04-06 19:25
invoice accept: apply	21.43	18849	643	2016-04-06 18:55	2016-04-06 19:25
invoice accept: cancel	7.57	673	227	2016-04-06 18:55	2016-04-06 19:25
customer reserve: creation	5430.70	71	162921	2016-04-06 18:55	2016-04-06 19:25
customer reserve: removal	397.90	54	11937	2016-04-06 18:55	2016-04-06 19:25
realization accept: apply	54.00	59	1620	2016-04-06 18:55	2016-04-06 19:25
realization accept: cancel	39.62	29	1149	2016-04-06 18:55	2016-04-06 19:25
payment from customer: creation	37.90	82	1137	2016-04-06 18:55	2016-04-06 19:25
payment from customer: removal	3.83	19	115	2016-04-06 18:55	2016-04-06 19:25
payment to supplier: creation	30.77	121	923	2016-04-06 18:55	2016-04-06 19:25
payment to supplier: removal	2.28	27	66	2016-04-06 18:55	2016-04-06 19:25
service: total inventory turnovers	11.13	192	334	2016-04-06 18:55	2016-04-06 19:25
service: total monetary turnovers	6.83	5	205	2016-04-06 18:55	2016-04-06 19:25
service: refresh index statistics	0.13	1648	2	2016-04-06 18:55	2016-04-06 19:25

Done for 6760 ms, from 19:26:50.77 to 19:26:57.53.

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	2791	9303	8372	931	10.01	18:55:29	18:58:29
interval # 2, overall	2	3466	10425	10397	28	0.27	18:58:30	19:01:30
interval # 3, overall	3	1255	3774	3765	9	0.24	19:01:31	19:04:31
interval # 4, overall	4	6051	18168	18152	16	0.09	19:04:32	19:07:32
interval # 5, overall	5	15432	46334	46296	38	0.08	19:07:33	19:10:33
interval # 6, overall	6	1411	4446	4233	213	4.79	19:10:34	19:13:34
interval # 7, overall	7	961	3129	2884	245	7.83	19:13:35	19:16:35
interval # 8, overall	8	6165	19589	18496	1093	5.58	19:16:36	19:19:36
interval # 9, overall	9	10899	32938	32696	242	0.73	19:19:37	19:22:37
interval # 10, overall	10	14026	42112	42078	34	0.08	19:22:38	19:25:38

Done for 10550 ms, from 19:27:06.57 to 19:27:17.12.

Performance for every MINUTE:

TEST_PHASE	MINUTE_SINCE_TEST_START	AVG_ESTIMATED	MIN_TO_AVG_RATIO	MAX_TO_AVG_RATIO	ROWS_AGGREGATED	DISTINCT_ATTACHMENTS
WARM_TIME	1	7330.04	0.0241	2.1982	954	10
WARM_TIME	2	8472.81	0.9509	1.0618	265	8
WARM_TIME	3	6160.43	0.9912	1.0359	102	3
WARM_TIME	4	6052.18	0.7908	1.2186	564	10
WARM_TIME	5	7289.72	0.8094	1.1499	849	10
WARM_TIME	6	7931.21	0.8808	1.1743	1220	10
WARM_TIME	7	8560.34	0.9397	1.0449	476	10
WARM_TIME	8	8078.47	0.9708	1.0406	359	8
WARM_TIME	9	7779.90	0.9621	1.0486	321	9
WARM_TIME	10	7644.92	0.9613	1.0246	399	9
TEST_TIME	11	7193.09	0.9900	1.0084	87	3
TEST_TIME	12	6749.64	0.9852	1.0132	103	7
TEST_TIME	13	6678.10	0.9494	1.0328	486	10
TEST_TIME	14	6483.16	0.9879	1.0082	196	7
TEST_TIME	15	6224.77	0.9800	1.0142	273	9
TEST_TIME	16	5983.68	0.9906	1.0057	70	5
TEST_TIME	17	5693.12	0.9949	1.0035	66	4
TEST_TIME	18	5403.03	0.9987	1.0005	79	3
TEST_TIME	19	5231.23	0.9817	1.0181	293	10
TEST_TIME	20	5078.31	0.9968	1.0059	118	5
TEST_TIME	21	5033.59	0.9698	1.0319	319	10
TEST_TIME	22	5310.95	0.9335	1.0665	930	10
TEST_TIME	23	5734.70	0.9447	1.0472	687	10
TEST_TIME	24	6053.84	0.9507	1.0547	797	10
TEST_TIME	25	6422.75	0.9544	1.0446	887	10
TEST_TIME	26	6457.17	0.9991	1.0003	64	2
TEST_TIME	27	6226.14	0.9990	1.0014	38	4
TEST_TIME	28	6028.65	0.9987	1.0003	39	2
TEST_TIME	29	5854.62	0.9945	1.0048	193	7
TEST_TIME	30	5699.68	0.9979	1.0012	42	2
TEST_TIME	31	5565.15	0.9941	1.0036	292	10
TEST_TIME	32	5443.98	0.9949	1.0058	178	6
TEST_TIME	33	5342.66	0.9952	1.0146	135	7
TEST_TIME	34	5569.99	0.9448	1.0364	836	10
TEST_TIME	35	5860.70	0.9568	1.0408	968	10
TEST_TIME	36	6026.79	0.9840	1.0125	524	10
TEST_TIME	37	5988.13	0.9915	1.0060	183	8
TEST_TIME	38	6083.36	0.9642	1.0375	704	10
TEST_TIME	39	6381.39	0.9637	1.0286	1146	10
TEST_TIME	40	6513.99	0.9824	1.0198	477	10

Done for 3400 ms, from 19:27:17.42 to 19:27:20.82.

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	33090	<null>	<null>	37234	<null>	89600	26505	<null>	<null>	<null>	51448	<null>	41366	<null>	<null>	<null>	490259	<null>	<null>	18:55:29	18:58:29
fetches per second	2	57872	89563	74739	230208	138345	<null>	50771	45092	25595	19857	61535	<null>	132002	<null>	194953	<null>	<null>	<null>	<null>	18:58:30	19:01:30
fetches per second	3	56621	92375	67930	46556	23363	<null>	17255	<null>	12029	<null>	60327	53338	76420	44916	60553	<null>	770540	495515	<null>	19:01:31	19:04:31
fetches per second	4	29128	<null>	66550	<null>	90889	59894	124701	73470	23264	46416	60145	<null>	86303	37843	201478	<null>	426807	351345	<null>	19:04:32	19:07:32
fetches per second	5	25986	30850	38364	<null>	82655	<null>	389345	78483	16518	<null>	40270	17201	73403	18649	129404	14983	352333	156343	<null>	19:07:33	19:10:33
fetches per second	6	48498	67517	22627	<null>	<null>	<null>	340383	<null>	<null>	<null>	56138	<null>	115750	<null>	167739	<null>	364169	<null>	<null>	19:10:34	19:13:34
fetches per second	7	41901	96769	49476	40083	67195	<null>	34532	54116	<null>	31816	50450	<null>	62509	<null>	132638	<null>	794831	339708	<null>	19:13:35	19:16:35
fetches per second	8	44515	<null>	137898	146828	116122	<null>	76651	49024	60115	<null>	98589	37450	100988	<null>	147595	<null>	<null>	164460	<null>	19:16:36	19:19:36
fetches per second	9	34503	61598	49505	<null>	81339	60355	189334	<null>	34420	32736	52214	30611	70649	42120	158700	18390	544318	504705	<null>	19:19:37	19:22:37
fetches per second	10	27388	29727	42000	<null>	66594	<null>	212895	<null>	44681	35325	31745	19033	61557	37093	162454	<null>	356309	243365	<null>	19:22:38	19:25:38
marks per second	1	5891	<null>	<null>	3729	<null>	14914	1236	<null>	<null>	<null>	3065	<null>	2163	<null>	<null>	<null>	82789	<null>	<null>	18:55:29	18:58:29
marks per second	2	10534	8153	13178	43049	27299	<null>	2315	4650	3063	2168	9050	<null>	5201	<null>	4516	<null>	<null>	<null>	<null>	18:58:30	19:01:30
marks per second	3	10426	8984	11328	4831	3465	<null>	814	<null>	1179	<null>	4813	9239	2779	3916	1105	<null>	8035	17401	<null>	19:01:31	19:04:31
marks per second	4	5346	<null>	11762	<null>	17951	10410	3457	7383	4011	4868	6568	<null>	4450	4562	2804	<null>	10996	16225	<null>	19:04:32	19:07:32
marks per second	5	4828	4305	6948	<null>	15301	<null>	3962	8010	1375	<null>	5393	1894	2380	2263	2254	1896	16811	5064	<null>	19:07:33	19:10:33
marks per second	6	9198	6907	4006	<null>	<null>	<null>	3258	<null>	<null>	<null>	7886	<null>	3910	<null>	5191	<null>	9735	<null>	<null>	19:10:34	19:13:34
marks per second	7	7131	10692	7724	5191	10723	<null>	1014	5778	<null>	4383	7312	<null>	2009	<null>	2993	<null>	19705	9738	<null>	19:13:35	19:16:35
marks per second	8	8048	<null>	26753	16468	21666	<null>	5669	4888	8091	<null>	14813	4050	4054	<null>	5227	<null>	<null>	10716	<null>	19:16:36	19:19:36
marks per second	9	6346	6503	8667	<null>	14517	10873	3808	<null>	2888	3416	10602	3832	3363	5080	2836	2000	36017	25987	<null>	19:19:37	19:22:37
marks per second	10	5097	2886	7197	<null>	11857	<null>	4617	<null>	3907	4037	4862	1933	2914	5375	3960	<null>	14467	6972	<null>	19:22:38	19:25:38
reads/fetches*100	1	4	<null>	<null>	2	<null>	3	4	<null>	<null>	<null>	8	<null>	6	<null>	<null>	<null>	0	<null>	<null>	18:55:29	18:58:29
reads/fetches*100	2	5	5	3	1	2	<null>	3	2	5	4	6	<null>	6	<null>	4	<null>	<null>	<null>	<null>	18:58:30	19:01:30
reads/fetches*100	3	4	4	3	4	3	<null>	3	<null>	7	<null>	8	3	8	6	4	<null>	0	1	<null>	19:01:31	19:04:31
reads/fetches*100	4	7	<null>	4	<null>	3	4	2	3	5	5	7	<null>	7	8	4	<null>	1	1	<null>	19:04:32	19:07:32
reads/fetches*100	5	7	6	5	<null>	3	<null>	1	2	6	<null>	8	10	7	4	4	5	1	2	<null>	19:07:33	19:10:33
reads/fetches*100	6	7	3	3	<null>	<null>	<null>	3	<null>	<null>	<null>	6	<null>	2	<null>	3	<null>	1	<null>	<null>	19:10:34	19:13:34
reads/fetches*100	7	3	5	1	2	2	<null>	2	1	<null>	3	5	<null>	5	<null>	4	<null>	0	0	<null>	19:13:35	19:16:35
reads/fetches*100	8	6	<null>	2	1	3	<null>	3	1	4	<null>	6	5	4	<null>	4	<null>	<null>	1	<null>	19:16:36	19:19:36
reads/fetches*100	9	7	6	4	<null>	4	2	2	<null>	4	6	8	7	7	5	4	5	0	1	<null>	19:19:37	19:22:37
reads/fetches*100	10	7	7	4	<null>	4	<null>	2	<null>	5	5	8	4	8	5	4	<null>	1	2	<null>	19:22:38	19:25:38
writes/marks*100	1	12	<null>	<null>	1	<null>	1	3	<null>	<null>	<null>	6	<null>	0	<null>	<null>	<null>	2	<null>	<null>	18:55:29	18:58:29
writes/marks*100	2	12	14	10	2	7	<null>	2	0	6	7	7	<null>	0	<null>	0	<null>	<null>	<null>	<null>	18:58:30	19:01:30
writes/marks*100	3	12	13	8	1	8	<null>	1	<null>	2	<null>	5	5	0	0	0	<null>	14	1	<null>	19:01:31	19:04:31
writes/marks*100	4	11	<null>	7	<null>	6	1	2	2	3	8	5	<null>	0	0	0	<null>	15	0	<null>	19:04:32	19:07:32
writes/marks*100	5	10	13	7	<null>	7	<null>	2	1	6	<null>	7	9	0	0	0	0	10	2	<null>	19:07:33	19:10:33
writes/marks*100	6	12	13	8	<null>	<null>	<null>	1	<null>	<null>	<null>	6	<null>	0	<null>	0	<null>	17	<null>	<null>	19:10:34	19:13:34
writes/marks*100	7	13	13	5	2	9	<null>	1	1	<null>	5	8	<null>	0	<null>	0	<null>	12	0	<null>	19:13:35	19:16:35
writes/marks*100	8	11	<null>	9	2	7	<null>	2	0	8	<null>	5	10	0	<null>	0	<null>	<null>	10	<null>	19:16:36	19:19:36
writes/marks*100	9	10	13	7	<null>	7	1	2	<null>	17	7	6	9	0	0	0	0	10	0	<null>	19:19:37	19:22:37
writes/marks*100	10	10	15	6	<null>	7	<null>	2	<null>	8	6	7	11	0	0	0	<null>	9	2	<null>	19:22:38	19:25:38

Done for 7880 ms, from 19:27:21.16 to 19:27:29.04.

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
<null>	<null>	<null>	<null>	<null>	<null>	<null>	<null>	<null>	<null>	<null>

Done for 950 ms, from 19:27:41.11 to 19:27:42.06.

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
<null>	<null>	<null>	<null>	<null>	<null>

Done for 650 ms, from 19:27:42.19 to 19:27:42.84.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-HQBIRD\OLTP25-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 100509
MON$OLDEST_ACTIVE 107209
MON$OLDEST_SNAPSHOT 107088
MON$NEXT_TRANSACTION 107344
MON$PAGE_BUFFERS 1024
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 2015-12-11 10:02:47.3010
MON$PAGES 235324
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.5.26952 Firebird 2.5 HQbird #20160215
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.5.26952 Firebird 2.5 HQbird #20160215"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.5.26952 Firebird 2.5 HQbird #20160215/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.5.26952 Firebird 2.5 HQbird #20160215/tcp (WIN-2BE1UI8LGDL)/P12
on disk structure version 11.2

Database statistics, full

Database "D:\OLTP-HQBIRD\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 112003
Page size 8192
ODS version 11.2
Oldest transaction 100509
Oldest active 107209
Oldest snapshot 107088
Next transaction 107351
Bumped transaction 1
Sequence number 0
Next attachment ID 4610
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes force write

Variable header data:
Sweep interval: 0
Database GUID: {9DE52B4C-5F48-45BB-FC86-E1F63A260D94}
*END*

Database file sequence:
File D:\OLTP-HQBIRD\oltp25-small.fdb is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 40.42, total records: 623127
Average version length: 46.49, total versions: 79197, max versions: 1
Data pages: 6588, data page slots: 6588, average fill: 76%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5839
80 - 99% = 748

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 2243, nodes: 623125
Average data length: 12.53, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 221
20 - 39% = 33
40 - 59% = 1120
60 - 79% = 58
80 - 99% = 811

Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 1812, nodes: 623126
Average data length: 5.85, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 19
40 - 59% = 1790
60 - 79% = 3
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 703, nodes: 623132
Average data length: 1.24, total dup: 498680, max dup: 49
Fill distribution:
0 - 19% = 33
20 - 39% = 14
40 - 59% = 349
60 - 79% = 1
80 - 99% = 306

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 57.51, total records: 126515
Average version length: 36.04, total versions: 13080, max versions: 3
Data pages: 1576, data page slots: 1576, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1242
80 - 99% = 333

Index DOC_LIST_ID_DESC (1)
Depth: 2, leaf buckets: 402, nodes: 126514
Average data length: 6.19, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 56
40 - 59% = 345
60 - 79% = 1
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 114, nodes: 126474
Average data length: 0.01, total dup: 126424, max dup: 20666
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 78
60 - 79% = 20
80 - 99% = 16

Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 288, nodes: 126515
Average data length: 6.19, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 29
20 - 39% = 24
40 - 59% = 91
60 - 79% = 16
80 - 99% = 128

DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 63.53, total records: 400
Average version length: 16.50, total versions: 1504, max versions: 76
Data pages: 106, data page slots: 107, average fill: 20%
Fill distribution:
0 - 19% = 96
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9

Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 25.89, total records: 4641
Average version length: 68.99, total versions: 2900, max versions: 1
Data pages: 80, data page slots: 349, average fill: 70%
Fill distribution:
0 - 19% = 6
20 - 39% = 11
40 - 59% = 5
60 - 79% = 22
80 - 99% = 36

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 23, nodes: 4593
Average data length: 9.76, total dup: 365, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 7
60 - 79% = 2
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 15.86, total records: 49
Average version length: 9.00, total versions: 88, max versions: 6
Data pages: 2, data page slots: 2, average fill: 28%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 9.62, total records: 205
Average version length: 45.32, total versions: 163, max versions: 1
Data pages: 3, data page slots: 3, average fill: 65%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 2

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 2, leaf buckets: 1, nodes: 205
Average data length: 3.84, total dup: 150, max dup: 31
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (165)
Primary pointer page: 316, Index root page: 317
Average record length: 0.00, total records: 58
Average version length: 56.93, total versions: 58, max versions: 1
Data pages: 1, data page slots: 1, average fill: 65%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

Index MON_LOG_TABLE_STATS_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 58
Average data length: 0.22, total dup: 54, max dup: 19
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 58
Average data length: 0.00, total dup: 57, max dup: 57
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 58
Average data length: 0.16, total dup: 57, max dup: 57
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)
Depth: 1, leaf buckets: 1, nodes: 58
Average data length: 12.33, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 58
Average data length: 5.26, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 40.15, total records: 76261
Average version length: 32.73, total versions: 6770, max versions: 7
Data pages: 1370, data page slots: 1405, average fill: 44%
Fill distribution:
0 - 19% = 277
20 - 39% = 469
40 - 59% = 92
60 - 79% = 526
80 - 99% = 6

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 73, nodes: 76262
Average data length: 0.01, total dup: 76213, max dup: 5387
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 37
60 - 79% = 10
80 - 99% = 8

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 93, nodes: 76264
Average data length: 0.88, total dup: 68784, max dup: 39
Fill distribution:
0 - 19% = 1
20 - 39% = 23
40 - 59% = 42
60 - 79% = 22
80 - 99% = 5

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 96, nodes: 76264
Average data length: 0.89, total dup: 68784, max dup: 39
Fill distribution:
0 - 19% = 0
20 - 39% = 30
40 - 59% = 47
60 - 79% = 11
80 - 99% = 8

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 100, nodes: 76264
Average data length: 0.67, total dup: 68784, max dup: 39
Fill distribution:
0 - 19% = 1
20 - 39% = 43
40 - 59% = 32
60 - 79% = 20
80 - 99% = 4

PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 0.00, total records: 16808
Average version length: 27.94, total versions: 16808, max versions: 1
Data pages: 145, data page slots: 311, average fill: 88%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 143

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 28, nodes: 16808
Average data length: 0.00, total dup: 16767, max dup: 1219
Fill distribution:
0 - 19% = 10
20 - 39% = 8
40 - 59% = 7
60 - 79% = 3
80 - 99% = 0

PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 148.01, total records: 2478604
Average version length: 139.33, total versions: 3, max versions: 1
Data pages: 57762, data page slots: 57762, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 57761

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 2704, nodes: 2478604
Average data length: 0.38, total dup: 1804766, max dup: 66
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1615
60 - 79% = 664
80 - 99% = 423

Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 2463, nodes: 2478632
Average data length: 0.00, total dup: 2478627, max dup: 2400131
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2461
60 - 79% = 2
80 - 99% = 0

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 2855, nodes: 2478632
Average data length: 0.23, total dup: 2390525, max dup: 7743
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2235
60 - 79% = 329
80 - 99% = 291

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 2822, nodes: 2478669
Average data length: 0.23, total dup: 2426654, max dup: 259675
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 2232
60 - 79% = 268
80 - 99% = 318

PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 48.46, total records: 111074
Average version length: 54.92, total versions: 13085, max versions: 1
Data pages: 1299, data page slots: 1299, average fill: 77%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1119
80 - 99% = 179

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 134, nodes: 111074
Average data length: 1.10, total dup: 92672, max dup: 427
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 108
60 - 79% = 20
80 - 99% = 4

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 100, nodes: 111074
Average data length: 0.64, total dup: 100691, max dup: 90
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 36
60 - 79% = 43
80 - 99% = 21

RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 8, max versions: 4
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
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: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (163)
Primary pointer page: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 0.00, total records: 3078
Average version length: 58.94, total versions: 3078, max versions: 1
Data pages: 39, data page slots: 42, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 0
60 - 79% = 0
80 - 99% = 37

WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 3.11, total records: 3467
Average version length: 71.09, total versions: 3316, max versions: 1
Data pages: 48, data page slots: 197, average fill: 92%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 47

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 6, nodes: 3485
Average data length: 3.11, total dup: 3043, max dup: 14
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 4
60 - 79% = 1
80 - 99% = 0

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 66.10, total records: 207035
Average version length: 69.78, total versions: 12263, max versions: 1
Data pages: 3171, data page slots: 3592, average fill: 72%
Fill distribution:
0 - 19% = 116
20 - 39% = 202
40 - 59% = 214
60 - 79% = 1822
80 - 99% = 817

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 223, nodes: 206371
Average data length: 0.26, total dup: 198543, max dup: 106
Fill distribution:
0 - 19% = 0
20 - 39% = 63
40 - 59% = 89
60 - 79% = 15
80 - 99% = 56

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 306, nodes: 206877
Average data length: 1.32, total dup: 179450, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 76
40 - 59% = 141
60 - 79% = 70
80 - 99% = 19

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 40.42, total records: 26447
Average version length: 70.29, total versions: 11305, max versions: 1
Data pages: 487, data page slots: 927, average fill: 64%
Fill distribution:
0 - 19% = 19
20 - 39% = 53
40 - 59% = 118
60 - 79% = 112
80 - 99% = 185

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 38, nodes: 26447
Average data length: 1.74, total dup: 22677, max dup: 45
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 13
60 - 79% = 10
80 - 99% = 3

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 14.76, total records: 1536014
Average version length: 68.92, total versions: 1213865, max versions: 1
Data pages: 20746, data page slots: 20746, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3770
80 - 99% = 16975

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1994, nodes: 1536014
Average data length: 0.94, total dup: 1388057, max dup: 99
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1715
60 - 79% = 143
80 - 99% = 135

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 40.23, total records: 11447
Average version length: 69.80, total versions: 4899, max versions: 1
Data pages: 159, data page slots: 1280, average fill: 83%
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 2
60 - 79% = 41
80 - 99% = 113

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 13, nodes: 11420
Average data length: 2.17, total dup: 9839, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 9
80 - 99% = 2

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 35.94, total records: 1157311
Average version length: 68.88, total versions: 561498, max versions: 1
Data pages: 15639, data page slots: 15639, average fill: 86%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3054
80 - 99% = 12583

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1649, nodes: 1156430
Average data length: 1.43, total dup: 982184, max dup: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 1347
60 - 79% = 162
80 - 99% = 137

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 77.42, total records: 1199719
Average version length: 81.17, total versions: 52709, max versions: 1
Data pages: 17953, data page slots: 17953, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6362
80 - 99% = 11590

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 1322, nodes: 1199719
Average data length: 0.15, total dup: 1172803, max dup: 172
Fill distribution:
0 - 19% = 10
20 - 39% = 0
40 - 59% = 932
60 - 79% = 327
80 - 99% = 53

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 940, nodes: 1199719
Average data length: 0.70, total dup: 1055719, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 139
60 - 79% = 22
80 - 99% = 778

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1488, nodes: 1199719
Average data length: 0.73, total dup: 1051769, max dup: 44
Fill distribution:
0 - 19% = 11
20 - 39% = 0
40 - 59% = 1021
60 - 79% = 390
80 - 99% = 66

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 55.35, total records: 992377
Average version length: 80.74, total versions: 314753, max versions: 1
Data pages: 14808, data page slots: 14808, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1
60 - 79% = 2548
80 - 99% = 12258

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 884, nodes: 991873
Average data length: 0.12, total dup: 974708, max dup: 494
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 276
60 - 79% = 348
80 - 99% = 259

Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 936, nodes: 992455
Average data length: 0.92, total dup: 843744, max dup: 14
Fill distribution:
0 - 19% = 31
20 - 39% = 11
40 - 59% = 296
60 - 79% = 4
80 - 99% = 594

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 1014, nodes: 991880
Average data length: 0.55, total dup: 902249, max dup: 83
Fill distribution:
0 - 19% = 33
20 - 39% = 0
40 - 59% = 312
60 - 79% = 404
80 - 99% = 265

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 61.67, total records: 1536373
Average version length: 82.17, total versions: 367492, max versions: 1
Data pages: 23014, data page slots: 23014, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7271
80 - 99% = 15742

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 1527, nodes: 1536373
Average data length: 0.04, total dup: 1529113, max dup: 1468
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 868
60 - 79% = 467
80 - 99% = 187

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 1154, nodes: 1536373
Average data length: 0.56, total dup: 1387786, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 132
60 - 79% = 21
80 - 99% = 1000

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 1689, nodes: 1536373
Average data length: 0.55, total dup: 1393314, max dup: 211
Fill distribution:
0 - 19% = 4
20 - 39% = 2
40 - 59% = 902
60 - 79% = 534
80 - 99% = 247

XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 57.99, total records: 1186116
Average version length: 80.92, total versions: 339284, max versions: 1
Data pages: 17735, data page slots: 17735, average fill: 84%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2794
80 - 99% = 14940

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 1090, nodes: 1184891
Average data length: 0.04, total dup: 1179590, max dup: 1163
Fill distribution:
0 - 19% = 2
20 - 39% = 12
40 - 59% = 439
60 - 79% = 374
80 - 99% = 263

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 1230, nodes: 1186335
Average data length: 0.93, total dup: 1007611, max dup: 14
Fill distribution:
0 - 19% = 37
20 - 39% = 45
40 - 59% = 504
60 - 79% = 14
80 - 99% = 630

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 1215, nodes: 1184544
Average data length: 0.53, total dup: 1079987, max dup: 101
Fill distribution:
0 - 19% = 2
20 - 39% = 8
40 - 59% = 465
60 - 79% = 449
80 - 99% = 291

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 46.66, total records: 372590
Average version length: 68.46, total versions: 118782, max versions: 1
Data pages: 5018, data page slots: 5018, average fill: 83%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2370
80 - 99% = 2647

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 344, nodes: 372590
Average data length: 0.23, total dup: 360041, max dup: 213
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 129
60 - 79% = 135
80 - 99% = 80

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 396, nodes: 372590
Average data length: 0.83, total dup: 323776, max dup: 44
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 150
60 - 79% = 163
80 - 99% = 83

ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 2900 ms, from 19:27:43.08 to 19:27:45.98.

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	623127	79197	12.7096
DOC_LIST	126515	13080	10.3386
DOC_STATES	4	0	0.0000
FB_ERRORS	758	0	0.0000
INVNT_SALDO	400	1504	376.0000
INVNT_TURNOVER_LOG	4641	2900	62.4865
MONEY_SALDO	49	88	179.5918
MONEY_TURNOVER_LOG	205	163	79.5121
MON_LOG_TABLE_STATS	58	58	100.0000
OPTYPES	9	0	0.0000
PDISTR	76261	6770	8.8774
PERF_ESTIMATED	16808	16808	100.0000
PERF_LOG	2478604	3	0.0001
PSTORNED	111074	13085	11.7804
RULES_FOR_PDISTR	4	0	0.0000
RULES_FOR_QDISTR	7	0	0.0000
SEMAPHORES	4	8	200.0000
SETTINGS	114	0	0.0000
TRACE_STAT	3078	3078	100.0000
WARES	400	0	0.0000
WARE_GROUPS	8	0	0.0000
XQD_1000_1200	3467	3316	95.6446
XQD_1000_3300	207035	12263	5.9231
XQD_1200_2000	26447	11305	42.7458
XQD_2000_3300	1536014	1213865	79.0269
XQD_2100_3300	11447	4899	42.7972
XQD_3300_3400	1157311	561498	48.5174
XQS_1000_1200	1199719	52709	4.3934
XQS_1000_3300	992377	314753	31.7170
XQS_1200_2000	1536373	367492	23.9194
XQS_2100_3300	1186116	339284	28.6046
XQS_3300_3400	372590	118782	31.8800
Z_USED_VIEWS	32	0	0.0000

Done for 2050 ms, from 19:27:51.08 to 19:27:53.13.

Database validation

19:27:53.24 Validation started

19:27:53.24 Relation 140 (DOC_LIST)
19:27:54.01 Acquire relation lock failed
19:27:54.01 Relation 140 (DOC_LIST) : 1 ERRORS found

19:27:54.01 Relation 141 (DOC_DATA)
19:27:55.01 Acquire relation lock failed
19:27:55.01 Relation 141 (DOC_DATA) : 1 ERRORS found

19:27:55.01 Relation 147 (INVNT_SALDO)
19:27:55.01 process pointer page 0 of 1
19:27:55.01 Index 1 (PK_INVNT_SALDO)
19:27:55.01 Relation 147 (INVNT_SALDO) is ok

19:27:55.01 Relation 150 (PDISTR)
19:27:56.11 Acquire relation lock failed
19:27:56.11 Relation 150 (PDISTR) : 1 ERRORS found

19:27:56.11 Relation 151 (PSTORNED)
19:27:57.00 Acquire relation lock failed
19:27:57.00 Relation 151 (PSTORNED) : 1 ERRORS found

19:27:57.00 Relation 156 (SEMAPHORES)
19:27:57.00 process pointer page 0 of 1
19:27:57.00 Index 1 (PK_SEMAPHORES)
19:27:57.00 Index 2 (SEMAPHORES_TASK_UNQ)
19:27:57.00 Relation 156 (SEMAPHORES) is ok

19:27:57.00 Relation 157 (INVNT_TURNOVER_LOG)
19:27:58.01 Acquire relation lock failed
19:27:58.01 Relation 157 (INVNT_TURNOVER_LOG) : 1 ERRORS found

19:27:58.01 Relation 160 (PERF_ESTIMATED)
19:27:58.01 process pointer page 0 of 1
19:27:58.03 Index 1 (PERF_EST_MINUTE_SINCE_START)
19:27:58.03 Relation 160 (PERF_ESTIMATED) is ok

19:27:58.03 Relation 161 (PERF_ISQL_STAT)
19:27:58.03 process pointer page 0 of 1
19:27:58.03 Index 1 (PERF_ISQL_STAT_TRN)
19:27:58.03 Relation 161 (PERF_ISQL_STAT) is ok

19:27:58.03 Relation 162 (PERF_LOG)
19:27:58.82 process pointer page 0 of 31
19:27:58.87 process pointer page 1 of 31
19:27:58.92 process pointer page 2 of 31
19:27:58.95 process pointer page 3 of 31
19:27:58.99 process pointer page 4 of 31
19:27:59.02 process pointer page 5 of 31
19:27:59.07 process pointer page 6 of 31
19:27:59.12 process pointer page 7 of 31
19:27:59.16 process pointer page 8 of 31
19:27:59.20 process pointer page 9 of 31
19:27:59.24 process pointer page 10 of 31
19:27:59.29 process pointer page 11 of 31
19:27:59.32 process pointer page 12 of 31
19:27:59.35 process pointer page 13 of 31
19:27:59.40 process pointer page 14 of 31
19:27:59.43 process pointer page 15 of 31
19:27:59.48 process pointer page 16 of 31
19:27:59.52 process pointer page 17 of 31
19:27:59.55 process pointer page 18 of 31
19:27:59.59 process pointer page 19 of 31
19:27:59.63 process pointer page 20 of 31
19:27:59.66 process pointer page 21 of 31
19:27:59.71 process pointer page 22 of 31
19:27:59.74 process pointer page 23 of 31
19:27:59.79 process pointer page 24 of 31
19:28:00.51 process pointer page 25 of 31
19:28:01.43 process pointer page 26 of 31
19:28:02.08 process pointer page 27 of 31
19:28:02.91 process pointer page 28 of 31
19:28:03.69 process pointer page 29 of 31
19:28:04.47 process pointer page 30 of 31
19:28:04.72 Index 1 (PERF_LOG_DTS_BEG_DESC)
19:28:05.00 Index 2 (PERF_LOG_UNIT)
19:28:05.45 Index 3 (PERF_LOG_TRN_DESC)
19:28:05.70 Index 4 (PERF_LOG_GDSCODE)
19:28:05.94 Relation 162 (PERF_LOG) is ok

19:28:05.94 Relation 166 (V_STOPTEST)
19:28:05.94 Relation 166 (V_STOPTEST) is ok

19:28:05.94 Relation 183 (V_QDISTR_SOURCE)
19:28:05.94 Relation 183 (V_QDISTR_SOURCE) is ok

19:28:05.94 Relation 184 (V_QSTORNED_SOURCE)
19:28:05.94 Relation 184 (V_QSTORNED_SOURCE) is ok

19:28:05.94 Relation 258 (XQD_1000_1200)
19:28:05.94 process pointer page 0 of 2
19:28:05.94 process pointer page 1 of 2
19:28:05.94 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
19:28:05.95 Relation 258 (XQD_1000_1200) is ok

19:28:05.95 Relation 259 (XQD_1200_2000)
19:28:06.04 Acquire relation lock failed
19:28:06.04 Relation 259 (XQD_1200_2000) : 1 ERRORS found

19:28:06.04 Relation 260 (XQD_1000_3300)
19:28:07.00 Acquire relation lock failed
19:28:07.00 Relation 260 (XQD_1000_3300) : 1 ERRORS found

19:28:07.00 Relation 261 (XQD_2000_3300)
19:28:08.01 Acquire relation lock failed
19:28:08.01 Relation 261 (XQD_2000_3300) : 1 ERRORS found

19:28:08.01 Relation 262 (XQD_2100_3300)
19:28:09.04 Acquire relation lock failed
19:28:09.04 Relation 262 (XQD_2100_3300) : 1 ERRORS found

19:28:09.04 Relation 263 (XQD_3300_3400)
19:28:10.01 Acquire relation lock failed
19:28:10.01 Relation 263 (XQD_3300_3400) : 1 ERRORS found

19:28:10.01 Relation 264 (XQS_1000_1200)
19:28:10.01 process pointer page 0 of 10
19:28:10.05 process pointer page 1 of 10
19:28:10.10 process pointer page 2 of 10
19:28:10.15 process pointer page 3 of 10
19:28:10.19 process pointer page 4 of 10
19:28:10.24 process pointer page 5 of 10
19:28:10.29 process pointer page 6 of 10
19:28:10.33 process pointer page 7 of 10
19:28:10.40 process pointer page 8 of 10
19:28:10.86 process pointer page 9 of 10
19:28:11.43 Index 1 (XQS_1000_1200_DOC_ID)
19:28:11.55 Index 2 (XQS_1000_1200_SND_ID)
19:28:11.68 Index 3 (XQS_1000_1200_RCV_ID)
19:28:11.77 Relation 264 (XQS_1000_1200) is ok

19:28:11.77 Relation 265 (XQS_1200_2000)
19:28:11.83 process pointer page 0 of 13
19:28:11.88 process pointer page 1 of 13
19:28:11.93 process pointer page 2 of 13
19:28:11.97 process pointer page 3 of 13
19:28:12.00 process pointer page 4 of 13
19:28:12.05 process pointer page 5 of 13
19:28:12.11 process pointer page 6 of 13
19:28:12.16 process pointer page 7 of 13
19:28:12.22 process pointer page 8 of 13
19:28:12.30 process pointer page 9 of 13
19:28:12.38 process pointer page 10 of 13
19:28:12.64 process pointer page 11 of 13
19:28:13.88 process pointer page 12 of 13
19:28:13.94 Index 1 (XQS_1200_2000_DOC_ID)
19:28:14.08 Index 2 (XQS_1200_2000_SND_ID)
19:28:14.23 Index 3 (XQS_1200_2000_RCV_ID)
19:28:14.36 Relation 265 (XQS_1200_2000) is ok

19:28:14.36 Relation 266 (XQS_1000_3300)
19:28:15.37 Acquire relation lock failed
19:28:15.37 Relation 266 (XQS_1000_3300) : 1 ERRORS found

19:28:15.37 Relation 267 (XQS_2000_3300)
19:28:15.37 process pointer page 0 of 1
19:28:15.37 Index 1 (XQS_2000_3300_DOC_ID)
19:28:15.37 Index 2 (XQS_2000_3300_SND_ID)
19:28:15.37 Index 3 (XQS_2000_3300_RCV_ID)
19:28:15.37 Relation 267 (XQS_2000_3300) is ok

19:28:15.37 Relation 268 (XQS_2100_3300)
19:28:16.39 Acquire relation lock failed
19:28:16.39 Relation 268 (XQS_2100_3300) : 1 ERRORS found

19:28:16.39 Relation 269 (XQS_3300_3400)
19:28:16.39 process pointer page 0 of 3
19:28:16.43 process pointer page 1 of 3
19:28:16.50 process pointer page 2 of 3
19:28:16.64 Index 1 (XQS_3300_3400_DOC_ID)
19:28:16.67 Index 2 (XQS_3300_3400_SND_ID)
19:28:16.78 Relation 269 (XQS_3300_3400) is ok

19:28:16.78 Relation 276 (TRACE_STAT)
19:28:16.78 process pointer page 0 of 1
19:28:16.78 Relation 276 (TRACE_STAT) is ok

19:28:16.78 Validation finished
Done for 23620 ms, from 19:27:53.17 to 19:28:16.79.

Differences between old and current firebird.log

19:28:17.10. Got:
STDOUT: ---------- E:\TEMP\LOGS.HQBIRD.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 2 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-04-06 19:28 87 oltp25_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 +++
***** E:\TEMP\LOGS.HQBIRD.OLTP25\oltp25_fb_log_when_test_started.log
***** E:\TEMP\LOGS.HQBIRD.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
1: operating system directive fopen failed
2: -The system cannot find the file specified.
*****
+++ End of comparison +++

Final processing ISQL logs in e:\temp\logs.hqbird.oltp25

Remove 31 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.hqbird.oltp25\oltp25_.:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND

ISQL logs are removed because no severe errors occured during test.
2016-04-06 19:28:17.85 - end of report, text file: e:\temp\logs.hqbird.oltp25\oltp25.report.txt, html: e:\temp\logs.hqbird.oltp25\oltp25.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.hqbird.oltp25\oltp25_*.*:

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.hqbird.oltp25\oltp25_.: