Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.02.2024 07:08

Common	Performance	Final Results
Hardware and OS info Test configuration Test Finish details Test workload details Indices DDL for heavy-loaded table(s)	Performance, TOTAL score: as table as chart Performance per MINUTE, during test_time phase: as table as chart Performance, DETAILS per units Memory consumption, metadata cache, attachments activity as table as chart Monitoring data: STATEMENTS activity, as chart Exceptions during test run	mon$database and 'show version' results Database Statistics, full Record versions statistics as table as chart Database validation was not performed. Change config parameter 'run_db_validation' to 1. New in firebird.log while test was run Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname	mscs-test-161.budzdorov.ru
Icon name	computer-server
Chassis	server
Machine ID	aeee285d2cca40bf84c40a748f599e77
Boot ID	2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System	CentOS Linux 7 (Core)
CPE OS Name	cpe:/o:centos:centos:7
Kernel	Linux 3.10.0-1127.10.1.el7.x86_64
Architecture	x86-64
Command: who -b
bootup_info	system boot 2021-11-11 18:28
Command: dmidecode -t system\|grep -i -e 'manufacturer\\|product\\|hypervisor'
Manufacturer	HP
Product Name	ProLiant DL380 Gen9
Command: dmesg \| grep DMI
[ 0.000000] DMI	HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu \| grep -i -v flags
Architecture	x86_64
CPU op-mode(s)	32-bit, 64-bit
Byte Order	Little Endian
CPU(s)	24
On-line CPU(s) list	0-23
Thread(s) per core	2
Core(s) per socket	6
Socket(s)	2
NUMA node(s)	2
Vendor ID	GenuineIntel
CPU family	6
Model	63
Model name	Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping	2
CPU MHz	1200.000
CPU max MHz	2400.0000
CPU min MHz	1200.0000
BogoMIPS	4794.33
Virtualization	VT-x
L1d cache	32K
L1i cache	32K
L2 cache	256K
L3 cache	15360K
NUMA node0 CPU(s)	0-5,12-17
NUMA node1 CPU(s)	6-11,18-23
Command: cat /proc/meminfo \| grep -i -e 'memtotal\\|memfree\\|memavail\\|buffers\\|cached\\|swapcached'
MemTotal	32643792 kB
MemFree	15750908 kB
MemAvailable	30309168 kB
Buffers	0 kB
Cached	15974620 kB
SwapCached	2752 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs


SERVER_MODE                     SuperServer 4.0.5
DB_NAME                         /home/bases/oltp40-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-16 07:07:47
DTS_END                         2024-02-16 07:07:47.7630
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/33718
TRN_ID                          174630
ATT_ID                          567
EXC_UNIT                        2

Test workload details

SETTING_NAME	SETTING_VALUE
WORKING_MODE	SMALL_03
C_WARES_MAX_ID	400
C_CUSTOMER_DOC_MAX_ROWS	10
C_SUPPLIER_DOC_MAX_ROWS	50
C_CUSTOMER_DOC_MAX_QTY	15
C_SUPPLIER_DOC_MAX_QTY	50
C_NUMBER_OF_AGENTS	50

Indexes for heavy-loaded tables

TAB_NAME	IDX_NAME	IDX_KEY
XQD_1000_1200	XQD_1000_1200_WA_SO_RO_WKR_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300	XQD_1000_3300_WA_SO_RO_WKR_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300	XQD_1000_3300_WKR_DOC_ASC	WORKER_ID,DOC_ID
XQD_1000_3300	XQD_1000_3300_WKR_DOC_DEC	WORKER_ID,DOC_ID
XQD_1200_2000	XQD_1200_2000_WA_SO_RO_WKR_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300	XQD_2000_3300_WA_SO_RO_WKR_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300	XQD_2100_3300_WA_SO_RO_WKR_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400	XQD_3300_3400_WA_SO_RO_WKR_SND	WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION	AVG_TIMES_PER_MINUTE	AVG_ELAPSED_MS	SUCCESSFUL_TIMES_DONE
* OVERALL * for 100 minutes:	9229.92	21634	922992
customer order: creation	175.39	418	17539
customer order: refuse	15.21	369	1521
order to supplier: creation	46.78	1399	4678
order to supplier: removal	3.38	81477	338
invoice (draft): creation	47.32	3230	4732
invoice (draft): removal	48.43	620	4843
invoice accept: apply	44.05	19398	4405
invoice accept: cancel	43.43	813	4343
customer reserve: creation	4243.66	183	424366
customer reserve: removal	4268.80	52	426880
realization accept: apply	86.61	222	8661
realization accept: cancel	76.24	135	7624
payment from customer: creation	59.84	171	5984
payment from customer: removal	6.15	140	615
payment to supplier: creation	49.59	160	4959
payment to supplier: removal	3.42	103	342
service: total inventory turnovers	3.97	3899	397
service: total monetary turnovers	6.67	421	667
service: aggregate perf. data	0.95	14289	95
service: refresh index statistics	0.03	305188	3

Performance in TOTAL, chart

Completed "Performance in TOTAL". Done for 00:00:02, from 16-02-2024 07:09:21 to 16-02-2024 07:09:23.

Performance for every MINUTE

TEST_PHASE_NAME	MINUTES_PASSED	PERF_SCORE
TEST_TIME	1	2546
TEST_TIME	2	3516
TEST_TIME	3	2821
TEST_TIME	4	3445
TEST_TIME	5	3642
TEST_TIME	6	4057
TEST_TIME	7	4518
TEST_TIME	8	4821
TEST_TIME	9	5477
TEST_TIME	10	5599
TEST_TIME	11	6616
TEST_TIME	12	6522
TEST_TIME	13	6485
TEST_TIME	14	6935
TEST_TIME	15	7006
TEST_TIME	16	7289
TEST_TIME	17	7555
TEST_TIME	18	7598
TEST_TIME	19	7641
TEST_TIME	20	7860
TEST_TIME	21	7875
TEST_TIME	22	7913
TEST_TIME	23	8117
TEST_TIME	24	8324
TEST_TIME	25	8895
TEST_TIME	26	9126
TEST_TIME	27	9036
TEST_TIME	28	9035
TEST_TIME	29	9080
TEST_TIME	30	9001
TEST_TIME	31	9165
TEST_TIME	32	9367
TEST_TIME	33	9394
TEST_TIME	34	9410
TEST_TIME	35	9310
TEST_TIME	36	9229
TEST_TIME	37	9099
TEST_TIME	38	9030
TEST_TIME	39	9074
TEST_TIME	40	9043
TEST_TIME	41	9066
TEST_TIME	42	8961
TEST_TIME	43	8893
TEST_TIME	44	8820
TEST_TIME	45	8889
TEST_TIME	46	9019
TEST_TIME	47	9061
TEST_TIME	48	9238
TEST_TIME	49	9232
TEST_TIME	50	9299
TEST_TIME	51	9257
TEST_TIME	52	9316
TEST_TIME	53	9427
TEST_TIME	54	9566
TEST_TIME	55	9564
TEST_TIME	56	9496
TEST_TIME	57	9378
TEST_TIME	58	9372
TEST_TIME	59	9268
TEST_TIME	60	9307
TEST_TIME	61	9278
TEST_TIME	62	9216
TEST_TIME	63	9179
TEST_TIME	64	9128
TEST_TIME	65	9127
TEST_TIME	66	9098
TEST_TIME	67	9048
TEST_TIME	68	9161
TEST_TIME	69	9205
TEST_TIME	70	9258
TEST_TIME	71	9230
TEST_TIME	72	9314
TEST_TIME	73	9384
TEST_TIME	74	9415
TEST_TIME	75	9434
TEST_TIME	76	9473
TEST_TIME	77	9371
TEST_TIME	78	9312
TEST_TIME	79	9268
TEST_TIME	80	9252
TEST_TIME	81	9192
TEST_TIME	82	9217
TEST_TIME	83	9164
TEST_TIME	84	9134
TEST_TIME	85	9215
TEST_TIME	86	9235
TEST_TIME	87	9326
TEST_TIME	88	9396
TEST_TIME	89	9368
TEST_TIME	90	9399
TEST_TIME	91	9364
TEST_TIME	92	9441
TEST_TIME	93	9560
TEST_TIME	94	9501
TEST_TIME	95	9407
TEST_TIME	96	9381
TEST_TIME	97	9337
TEST_TIME	98	9291
TEST_TIME	99	9247
TEST_TIME	100	9235

Performance per minute, chart

Completed "Performance for every MINUTE". Done for 00:00:03, from 16-02-2024 07:09:25 to 16-02-2024 07:09:28.

Performance in DETAILS

UNIT	CNT_ALL	CNT_OK	CNT_ERR	ERR_PRC	OK_MIN_MS	OK_MAX_MS	OK_AVG_MS	CNT_USER_EXC
doc_list_aiud	1309094	1309094	0	0.00	0	20195	7	0
doc_list_biud	1309094	1309094	0	0.00	0	35348	22	0
sp_add_invoice_to_stock	4534	4405	129	2.84	32	197144	19398	129
sp_cancel_adding_invoice	4343	4343	0	0.00	5	86183	814	0
sp_cancel_client_order	1521	1521	0	0.00	4	11270	369	0
sp_cancel_customer_reserve	426880	426880	0	0.00	0	22040	52	0
sp_cancel_pay_from_customer	615	615	0	0.00	2	11492	141	0
sp_cancel_pay_to_supplier	342	342	0	0.00	2	3718	103	0
sp_cancel_supplier_invoice	4852	4843	9	0.18	1	35312	621	9
sp_cancel_supplier_order	338	338	0	0.00	14	812209	81477	0
sp_cancel_write_off	7624	7624	0	0.00	0	13826	135	0
sp_client_order	17539	17539	0	0.00	3	16215	418	0
sp_customer_reserve	424366	424366	0	0.00	0	46596	184	0
sp_fill_shopping_cart	26947	26947	0	0.00	1	20658	38	0
sp_fill_shopping_cart_clo_res	424358	424358	0	0.00	0	18395	18	0
sp_get_clo_for_invoice	4397	4397	0	0.00	0	43752	397	0
sp_kill_cost_storno	12924	12924	0	0.00	0	11487	67	0
sp_kill_qstorno_ret_qs2qd	866565	866565	0	0.00	0	35243	28	0
sp_kill_qty_storno	458607	458607	0	0.00	0	35348	61	0
sp_lock_selected_doc	17931	17931	0	0.00	0	10714	7	0
sp_make_cost_storno	24001	24001	0	0.00	0	20187	83	0
sp_multiply_rows_for_pdistr	24001	24001	0	0.00	0	12330	38	0
sp_multiply_rows_for_qdistr	17539	17539	0	0.00	0	16196	222	0
sp_pay_from_customer	5984	5984	0	0.00	3	18935	171	0
sp_pay_to_supplier	4959	4959	0	0.00	3	19128	161	0
sp_payment_common	10943	10943	0	0.00	1	11738	38	0
sp_qd_handle_on_cancel_clo	1521	1521	0	0.00	0	11239	343	0
sp_qd_handle_on_invoice_upd_sts	8740	8740	0	0.00	0	35348	288	0
sp_qd_handle_on_reserve_upd_sts	8661	8661	0	0.00	0	19158	59	0
sp_reserve_write_off	8661	8661	0	0.00	6	19276	222	0
sp_supplier_invoice	4732	4732	0	0.00	6	84631	3230	0
sp_supplier_order	4678	4678	0	0.00	5	22710	1399	0
srv_aggregate_perf_data	95	95	0	0.00	1884	138117	14289	0
srv_fill_mon_cache_memory	54	54	0	0.00	710	115815	42699	0
srv_find_qd_qs_mism	877904	877904	0	0.00	0	18944	6	0
srv_make_invnt_saldo	397	397	0	0.00	52	80994	3899	0
srv_make_money_saldo	667	667	0	0.00	1	8518	421	0
srv_recalc_idx_stat	3	3	0	0.00	247455	359631	305189	0
t$perf-abend:sp_add_invoice_to_stock	129	129	0	0.00	0	0	0	0
t$perf-abend:sp_cancel_supplier_invoice	9	9	0	0.00	0	0	0	0
t$perf-norm:sp_add_invoice_to_stock	4405	4405	0	0.00	0	8319	157	0
t$perf-norm:sp_cancel_adding_invoice	328	328	0	0.00	0	7780	117	0
t$perf-norm:sp_cancel_client_order	1521	1521	0	0.00	0	3485	16	0
t$perf-norm:sp_cancel_customer_reserve	576	576	0	0.00	0	681	5	0
t$perf-norm:sp_cancel_pay_from_customer	615	615	0	0.00	0	2855	14	0
t$perf-norm:sp_cancel_pay_to_supplier	342	342	0	0.00	0	1843	9	0
t$perf-norm:sp_cancel_supplier_invoice	310	310	0	0.00	0	1423	20	0
t$perf-norm:sp_cancel_supplier_order	338	338	0	0.00	0	36674	1553	0
t$perf-norm:sp_cancel_write_off	846	846	0	0.00	0	2599	12	0
t$perf-norm:sp_client_order	17539	17539	0	0.00	0	12398	19	0
t$perf-norm:sp_customer_reserve	819	819	0	0.00	0	3777	10	0
t$perf-norm:sp_pay_from_customer	5984	5984	0	0.00	0	6972	7	0
t$perf-norm:sp_pay_to_supplier	4959	4959	0	0.00	0	7302	11	0
t$perf-norm:sp_reserve_write_off	8661	8661	0	0.00	0	8726	13	0
t$perf-norm:sp_supplier_invoice	4732	4732	0	0.00	0	6201	22	0
t$perf-norm:sp_supplier_order	4678	4678	0	0.00	0	14266	16	0
t$perf-norm:srv_aggregate_perf_data	95	95	0	0.00	0	1521	21	0
t$perf-norm:srv_fill_mon_cache_memory	54	54	0	0.00	0	397	12	0
t$perf-norm:srv_make_invnt_saldo	397	397	0	0.00	0	1530	12	0
t$perf-norm:srv_make_money_saldo	667	667	0	0.00	0	2344	7	0
t$perf-norm:srv_recalc_idx_stat	3	3	0	0.00	1	15	6	0
v_add_invoice_to_stock	9046	8788	258	2.85	0	9728	22	258
v_all_customers	32154	32154	0	0.00	0	20	1	0
v_all_suppliers	26284	26284	0	0.00	0	118	1	0
v_all_wares	35078	35078	0	0.00	0	21	1	0
v_cancel_adding_invoice	656	656	0	0.00	0	5036	19	0
v_cancel_client_order	3042	3042	0	0.00	0	2610	4	0
v_cancel_customer_prepayment	1230	1230	0	0.00	0	2606	10	0
v_cancel_customer_reserve	1152	1152	0	0.00	0	4759	9	0
v_cancel_payment_to_supplier	684	684	0	0.00	0	192	3	0
v_cancel_supplier_invoice	638	620	18	2.82	0	6738	32	18
v_cancel_supplier_order	676	676	0	0.00	0	8786	15	0
v_cancel_write_off	1692	1692	0	0.00	0	4319	18	0
v_max_id_clo_ord	4678	4678	0	0.00	0	485	1	0
v_max_id_clo_res	819	819	0	0.00	0	1240	10	0
v_max_id_ord_sup	4730	4730	0	0.00	0	6309	4	0
v_max_non_paid_invoice	1225	1225	0	0.00	0	2084	4	0
v_max_non_paid_realizn	3121	3121	0	0.00	0	8465	6	0
v_min_id_clo_ord	4678	4678	0	0.00	0	10720	11	0
v_min_id_clo_res	819	819	0	0.00	0	7983	25	0
v_min_id_ord_sup	4730	4730	0	0.00	0	4713	7	0
v_min_non_paid_invoice	4959	4959	0	0.00	0	11413	24	0
v_min_non_paid_realizn	5984	5984	0	0.00	0	11733	36	0
v_our_firm	8650	8650	0	0.00	0	19	1	0
v_reserve_write_off	17322	17322	0	0.00	0	9578	8	0
x_lock_depdocs_on_canc_invoice	8876	8876	0	0.00	0	26510	121	0
x_lock_depdocs_on_canc_sup_ord	338	338	0	0.00	0	4428	318	0
x_make_qstorno_1000_1200	4678	4678	0	0.00	2	22698	1321	0
x_make_qstorno_1200_2000	4732	4732	0	0.00	3	84592	3090	0
x_make_qstorno_2100_3300	424366	424366	0	0.00	0	36935	163	0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-02-2024 07:09:29 to 16-02-2024 07:09:33.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000

measurement_dts	measurement duration ms	page cache memo used	memo used, total	memo allocated, total	metadata cache	metadata cache percent of total	total attachments cnt	active attachments cnt	running statements cnt	stalled statements cnt	memo used by attachments	memo used by transactions	memo used by statements
05:07:51	3	8192000000	8799940816	8811700224	5619968	0.068	2	2	2	0	5738720	82976	35776
05:08:52	36437	8192000000	9731842480	10031988736	807786368	8.975	100	91	181	0	836735280	7594240	21354672
05:10:33	17197	8192000000	9761385776	10068189184	836142016	9.261	100	93	186	0	870756432	12338656	22275760
05:12:02	2167	8192000000	9797245440	10113912832	869781616	9.598	100	87	174	0	908444016	18761232	19901168
05:13:06	15591	8192000000	9840284160	10174771200	897523936	9.874	100	72	144	0	964155392	50188400	16443056
05:14:24	5569	8192000000	9898463456	10241245184	939162624	10.285	100	79	158	1	1011993696	56242192	16588880
05:15:35	4293	8192000000	9949833024	10301607936	974229264	10.628	100	80	160	1	1061521248	71059328	16232656
05:16:42	2815	8192000000	9979762464	10339442688	1014596128	11.020	100	80	154	0	1091475312	61442208	15436976
05:17:47	1634	8192000000	10045708752	10413268992	1036491504	11.231	100	84	165	0	1158539456	105807808	16240144
05:18:50	1692	8192000000	10029992016	10403823616	1058617776	11.443	100	81	162	0	1143745872	68838688	16289408
05:19:52	11331	8192000000	10051969616	10430676992	1075227168	11.602	100	80	158	0	1153965744	62240544	16498032
05:21:05	3046	8192000000	10041454576	10435973120	1077376768	11.622	100	58	115	0	1156858096	68234592	11246736
05:22:13	8297	8192000000	9998214672	10399719424	1084775536	11.693	100	34	70	0	1109266528	17345072	7145920
05:23:22	5113	8192000000	9999616032	10408910848	1089541616	11.738	100	36	73	0	1120732384	24074608	7116160
05:24:28	27060	8192000000	10014968912	10418221056	1091441776	11.756	100	45	88	0	1113870384	12904736	9523872
05:25:55	4190	8192000000	10003151424	10406408192	1095067664	11.791	100	24	47	2	1110589552	10205344	5316544
05:27:00	5275	8192000000	9996053792	10407788544	1076836928	11.617	98	40	75	1	1102682576	17607616	8238032
05:28:08	9358	8192000000	10013976288	10417934336	1096886864	11.808	100	42	82	0	1124050480	18793648	8369968
05:29:24	46227	8192000000	10063899296	10480328704	1112307696	11.954	100	48	98	0	1179297024	56358528	10630800
05:31:11	54818	8192000000	10081019632	10515148800	1123149200	12.057	100	36	70	1	1208143216	77244928	7749088
05:33:16	12234	8192000000	10111609744	10526179328	1111508320	11.947	99	43	85	0	1199325552	78337888	9479344
05:34:36	21514	8192000000	10112590416	10526445568	1103066976	11.867	99	40	80	1	1225556656	113361360	9128320
05:36:05	19826	8192000000	10105265472	10505662464	1056790672	11.426	95	39	78	0	1169744288	104882240	8071376
05:37:30	56618	8192000000	10064235040	10480484352	1044314240	11.306	94	39	78	1	1190254752	137816144	8124368
05:39:34	15763	8192000000	10077716800	10476982272	1065903024	11.513	98	52	104	0	1169090912	92306112	10881776
05:40:52	10483	8192000000	10106690720	10513924096	1091047632	11.753	100	56	112	0	1217685888	115344320	11293936
05:42:09	710	8192000000	10088078560	10485583872	1097568944	11.815	100	63	122	0	1193370496	83366224	12435328
05:43:15	3090	8192000000	10122169568	10508394496	1092627024	11.768	100	82	162	1	1219585632	108647280	18311328
05:44:24	4358	8192000000	10144148128	10544832512	1103514736	11.871	100	53	104	1	1246057232	131345680	11196816
05:45:30	9222	8192000000	10153865520	10561085440	1116614480	11.995	100	39	77	0	1264224560	138880832	8729248
05:46:48	1407	8192000000	10232625600	10627743744	1127202912	12.095	100	75	151	1	1330104384	184319200	18582272
05:47:56	2801	8192000000	10272249008	10679128064	1141562128	12.230	100	72	142	0	1369465456	211773472	16129856
05:49:04	58021	8192000000	10268784352	10720124928	1138642064	12.203	100	28	56	0	1389089328	243310880	7136384
05:51:03	15191	8192000000	10219195648	10683719680	1135326736	12.172	100	13	26	0	1328187072	189681904	3178432
05:52:22	40087	8192000000	10100304560	10629623808	1114221792	11.972	99	11	22	0	1244912848	128284992	2406064
05:54:03	26469	8192000000	10083429408	10534518784	1130967984	12.130	100	29	58	0	1184085648	46835120	6282544
05:55:30	40599	8192000000	10074750704	10508484608	1112779136	11.959	98	23	46	0	1155249632	38212768	4257728
05:57:35	26875	8192000000	10129384000	10568372224	1130920976	12.130	99	18	36	0	1196289440	61708304	3660160
05:59:05	75029	8192000000	10081096496	10534629376	1142995552	12.244	100	15	30	0	1189183424	43008544	3179328
06:01:23	30538	8192000000	10119841136	10556575744	1157283360	12.378	100	25	51	1	1208764064	46207984	5272720
06:02:55	85130	8192000000	10083046272	10540281856	1156626496	12.372	100	41	79	0	1212448032	47721712	8099824
06:05:23	25005	8192000000	10102399952	10551705600	1159083216	12.395	100	19	38	0	1203468912	40481552	3904144
06:06:50	29205	8192000000	10103774576	10543915008	1140785120	12.223	98	37	73	0	1193969744	44883392	8301232
06:08:30	54903	8192000000	10140954544	10611265536	1160416240	12.407	99	16	32	0	1246076800	82100496	3560064
06:10:28	52710	8192000000	10161849264	10623045632	1138789520	12.204	98	24	49	0	1254660128	110518736	5351872
06:12:35	69815	8192000000	10106336832	10572152832	1106842288	11.903	97	19	38	0	1196832080	85935872	4053920
06:14:45	51688	8192000000	10086212272	10574913536	1106866336	11.903	97	32	65	0	1209404224	95761104	6776784
06:17:12	33320	8192000000	10086786080	10521686016	1100084880	11.838	97	38	75	0	1156270208	48242384	7942944
06:18:53	26330	8192000000	10083702944	10530951168	1082145008	11.668	96	44	86	2	1142724464	52033456	8546000
06:21:06	71632	8192000000	10051924816	10486808576	1064731584	11.502	95	21	42	0	1119306768	49776352	4798832
06:23:21	115815	8192000000	10044685872	10484322304	1070127392	11.553	96	33	64	0	1088448032	11485264	6835376
06:26:18	20695	8192000000	10068312128	10525138944	1106585264	11.900	100	29	57	0	1174154208	62024992	5543952
06:27:41	48539	8192000000	10028151584	10485071872	1085575952	11.701	98	12	25	0	1117129248	29178352	2374944
06:29:29	40253	8192000000	10025789040	10482941952	1079715760	11.645	98	8	16	0	1114569296	33118896	1734640
06:31:20	39089	8192000000	10010233040	10463580160	1056118576	11.419	96	6	12	0	1078125152	20927344	1079232
06:33:01	59389	8192000000	10073877216	10537152512	1077104496	11.620	97	16	32	0	1151680064	71449312	3126256
06:35:05	55946	8192000000	10068569840	10577883136	1102726928	11.864	100	12	24	0	1182253536	76959072	2567536
06:37:03	64288	8192000000	10069482384	10518532096	1117656624	12.005	100	30	60	0	1184326064	60820896	5848544
06:39:11	75555	8192000000	10113458624	10610896896	1111033184	11.942	98	21	42	0	1176562752	60998976	4530592
06:41:27	40947	8192000000	10087767312	10563489792	1125512032	12.079	99	31	62	0	1177252560	45786848	5953680
06:43:08	47166	8192000000	10087889600	10554974208	1142652832	12.240	100	20	40	0	1189430720	43033872	3744016
06:45:03	75212	8192000000	10079434704	10530848768	1151016816	12.319	100	23	46	0	1181593584	25513936	5062832
06:47:20	48489	8192000000	10110487744	10572197888	1158362208	12.388	100	11	22	0	1230371376	69881360	2127808
06:50:52	65319	8192000000	10176107280	10625134592	1145827376	12.270	98	17	34	0	1238826576	89352480	3646720
06:53:08	34237	8192000000	10162039440	10648580096	1166913520	12.468	100	32	63	1	1272498720	98544992	7040208
06:54:51	100249	8192000000	10116603648	10558152704	1141996672	12.234	98	29	59	0	1209093520	61425184	5671664
06:57:39	55553	8192000000	10130155712	10571067392	1117278208	12.001	96	22	44	1	1167397280	45926016	4193056
06:59:37	35696	8192000000	10148706944	10626088960	1124765024	12.072	98	26	52	0	1200833232	71033264	5034944
07:01:17	99930	8192000000	10048811680	10490580992	1116621536	11.995	98	21	42	0	1151318608	30507552	4189520
07:03:58	37762	8192000000	10046647360	10511187968	1110955296	11.941	99	7	14	0	1154516224	42081520	1479408
07:05:48	64566	8192000000	10058034208	10520915968	1076549376	11.615	95	9	18	0	1117767984	39560688	1657920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart

Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 16-02-2024 07:09:35 to 16-02-2024 07:09:49.

Exceptions occured during test was in run

FB_MNEMONA	CNT	UNIT	FB_GDSCODE
except	129	v_add_invoice_to_stock	335544517
except	9	v_cancel_supplier_invoice	335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-02-2024 07:09:50 to 16-02-2024 07:09:52.

Content of mon$database and FB version


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          173703
MON$OLDEST_ACTIVE               174778
MON$OLDEST_SNAPSHOT             174778
MON$NEXT_TRANSACTION            174778
MON$PAGE_BUFFERS                1000000
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               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1916832
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             697
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3059 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3059 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3059 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3059 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Fri Feb 16 07:09:53 2024 
 
Database header page information: 
    Flags            0 
    Generation        91195 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    173703 
    Oldest active        174778 
    Oldest snapshot        174778 
    Next transaction    174779 
    Sequence number        0 
    Next attachment ID    697 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, 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: 1504335, 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: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    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: 1504331, 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 (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    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: 1235.00, compression ratio: 11.41 
    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 BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    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_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    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: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.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 RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    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 (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.73, total records: 7736131 
    Average version length: 48.16, total versions: 32957, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89064 
    Data pages: 89064, average fill: 69% 
    Primary pages: 89064, secondary pages: 0, swept pages: 48182 
    Empty pages: 4, full pages: 65588 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 38 
    40 - 59% = 2326 
    60 - 79% = 86687 
    80 - 99% = 7 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23360, nodes: 7736131 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1680596, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 368 
        20 - 39% = 2063 
        40 - 59% = 4012 
        60 - 79% = 2298 
        80 - 99% = 14619 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13522, nodes: 7736131 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1505056, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1736 
        40 - 59% = 1893 
        60 - 79% = 1108 
        80 - 99% = 8785 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8375, nodes: 7736131 
    Average node length: 6.62, total dup: 5781375, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1498131, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 133 
        20 - 39% = 1070 
        40 - 59% = 1316 
        60 - 79% = 948 
        80 - 99% = 4908 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.06, total records: 2245913 
    Average version length: 58.81, total versions: 18237, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28888 
    Data pages: 28888, average fill: 71% 
    Primary pages: 28886, secondary pages: 2, swept pages: 14274 
    Empty pages: 2, full pages: 16866 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 41 
    40 - 59% = 554 
    60 - 79% = 28261 
    80 - 99% = 26 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4589, nodes: 2245913 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 680797, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 995 
        40 - 59% = 804 
        60 - 79% = 737 
        80 - 99% = 2053 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2419, nodes: 2246724 
    Average node length: 4.97, total dup: 2245825, max dup: 19861 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1264464, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 194 
        40 - 59% = 1411 
        60 - 79% = 552 
        80 - 99% = 260 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1791, nodes: 2245913 
    Average node length: 4.97, total dup: 2245863, max dup: 130208 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1070957, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 639 
        60 - 79% = 45 
        80 - 99% = 1103 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4390, nodes: 2245913 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 680797, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 671 
        40 - 59% = 575 
        60 - 79% = 819 
        80 - 99% = 2218 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    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: 1504337, 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: 1504338, 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: 1504336, 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 (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.39, total records: 400 
    Average version length: 24.13, total versions: 1617, max versions: 5 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 55% 
    Primary pages: 13, secondary pages: 11, swept pages: 0 
    Empty pages: 6, full pages: 11 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 11 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, 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: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 15.85, total records: 91374 
    Average version length: 68.28, total versions: 80828, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.55 
    Pointer pages: 6, data page slots: 3040 
    Data pages: 1672, average fill: 73% 
    Primary pages: 1671, secondary pages: 1, swept pages: 11 
    Empty pages: 210, full pages: 1239 
    Fill distribution: 
     0 - 19% = 258 
    20 - 39% = 71 
    40 - 59% = 60 
    60 - 79% = 155 
    80 - 99% = 1128 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708522, depth: 3, leaf buckets: 296, nodes: 91374 
    Average node length: 13.57, total dup: 5348, max dup: 1 
    Average key length: 10.70, compression ratio: 2.52 
    Average prefix length: 19.24, average data length: 7.76 
    Clustering factor: 64068, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 70 
        40 - 59% = 136 
        60 - 79% = 79 
        80 - 99% = 11 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.16, total records: 49 
    Average version length: 9.00, total versions: 138, max versions: 7 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 63% 
    Primary pages: 1, 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% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, 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 (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 14.61, total records: 1178 
    Average version length: 42.81, total versions: 993, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.97 
    Pointer pages: 1, data page slots: 48 
    Data pages: 32, average fill: 38% 
    Primary pages: 31, secondary pages: 1, swept pages: 3 
    Empty pages: 13, full pages: 7 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 8 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92858, depth: 2, leaf buckets: 3, nodes: 1178 
    Average node length: 4.37, total dup: 1080, max dup: 117 
    Average key length: 2.88, compression ratio: 6.59 
    Average prefix length: 18.20, average data length: 0.80 
    Clustering factor: 639, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.61, total records: 71 
    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: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, 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: 1504251, 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: 1504249, 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: 1504248, 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: 1504250, 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: 1504247, 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 (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    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: 611.00, compression ratio: 9.10 
    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 MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    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: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    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: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    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: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    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: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, 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: 386.00, compression ratio: 5.71 
    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: 1544827, 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: 1544826, 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 (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.59, total records: 785526 
    Average version length: 37.97, total versions: 24442, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8392 
    Data pages: 8392, average fill: 64% 
    Primary pages: 8389, secondary pages: 3, swept pages: 2865 
    Empty pages: 18, full pages: 4736 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 57 
    40 - 59% = 943 
    60 - 79% = 7303 
    80 - 99% = 53 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 835, nodes: 774893 
    Average node length: 4.88, total dup: 774844, max dup: 139826 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88878, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 135 
        40 - 59% = 441 
        60 - 79% = 157 
        80 - 99% = 102 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 848, nodes: 774893 
    Average node length: 5.88, total dup: 689778, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155604, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 25 
        40 - 59% = 362 
        60 - 79% = 130 
        80 - 99% = 330 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 888, nodes: 774893 
    Average node length: 5.89, total dup: 689778, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157443, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 90 
        40 - 59% = 361 
        60 - 79% = 117 
        80 - 99% = 319 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1102, nodes: 774893 
    Average node length: 5.97, total dup: 689778, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150423, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 242 
        40 - 59% = 561 
        60 - 79% = 217 
        80 - 99% = 80 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5467 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.09, total fragments: 35, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 84, average fill: 64% 
    Primary pages: 75, secondary pages: 9, swept pages: 57 
    Empty pages: 4, full pages: 58 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5467 
    Average node length: 5.54, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.43, average data length: 1.54 
    Clustering factor: 5322, ratio: 0.97 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5467 
    Average node length: 11.17, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 166, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.08, total records: 79138 
    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: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 824 
    Data pages: 824, average fill: 66% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 822 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 822 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36251, depth: 2, leaf buckets: 102, nodes: 79138 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3084, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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: 1504261, 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 (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.06, total records: 71 
    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: 1691.00, compression ratio: 15.23 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.38, total records: 161852 
    Average version length: 153.33, total versions: 2022, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 4208 
    Data pages: 3992, average fill: 84% 
    Primary pages: 3991, secondary pages: 1, swept pages: 3 
    Empty pages: 14, full pages: 3971 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3973 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 148.86, total records: 144839 
    Average version length: 153.28, total versions: 2151, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 5, data page slots: 5152 
    Data pages: 3648, average fill: 82% 
    Primary pages: 3647, secondary pages: 1, swept pages: 2 
    Empty pages: 79, full pages: 3545 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 11 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3545 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.63, total records: 148497 
    Average version length: 138.64, total versions: 99, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 6, data page slots: 3944 
    Data pages: 3704, average fill: 82% 
    Primary pages: 3701, secondary pages: 3, swept pages: 3 
    Empty pages: 55, full pages: 3634 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3633 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 150.92, total records: 160925 
    Average version length: 139.47, total versions: 118, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 6, data page slots: 4336 
    Data pages: 3984, average fill: 83% 
    Primary pages: 3983, secondary pages: 1, swept pages: 1 
    Empty pages: 31, full pages: 3947 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 3947 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 149.55, total records: 156156 
    Average version length: 153.40, total versions: 1687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 7, data page slots: 4664 
    Data pages: 3904, average fill: 82% 
    Primary pages: 3902, secondary pages: 2, swept pages: 8 
    Empty pages: 57, full pages: 3824 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 3824 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 150.20, total records: 177507 
    Average version length: 152.13, total versions: 1386, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 4928 
    Data pages: 4392, average fill: 83% 
    Primary pages: 4391, secondary pages: 1, swept pages: 5 
    Empty pages: 22, full pages: 4360 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4360 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 149.81, total records: 148201 
    Average version length: 152.35, total versions: 1136, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 6, data page slots: 3872 
    Data pages: 3656, average fill: 83% 
    Primary pages: 3655, secondary pages: 1, swept pages: 2 
    Empty pages: 18, full pages: 3632 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3631 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 150.79, total records: 163762 
    Average version length: 151.30, total versions: 439, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 7, data page slots: 4784 
    Data pages: 4056, average fill: 83% 
    Primary pages: 4054, secondary pages: 2, swept pages: 3 
    Empty pages: 31, full pages: 4017 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4018 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 151.12, total records: 160494 
    Average version length: 145.70, total versions: 182, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.22 
    Pointer pages: 6, data page slots: 5624 
    Data pages: 3992, average fill: 83% 
    Primary pages: 3990, secondary pages: 2, swept pages: 1 
    Empty pages: 41, full pages: 3941 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 0 
    80 - 99% = 3941 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 132.53, total records: 197178 
    Average version length: 154.86, total versions: 25952, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.80 
    Pointer pages: 7, data page slots: 5616 
    Data pages: 4936, average fill: 84% 
    Primary pages: 4935, secondary pages: 1, swept pages: 1 
    Empty pages: 71, full pages: 4846 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4846 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    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: 1510376, 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: 1510375, 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: 1510374, 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: 1510373, 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 (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.51, total records: 2089783 
    Average version length: 52.97, total versions: 11632, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25824 
    Data pages: 25816, average fill: 69% 
    Primary pages: 25807, secondary pages: 9, swept pages: 12960 
    Empty pages: 170, full pages: 21301 
    Fill distribution: 
     0 - 19% = 340 
    20 - 39% = 326 
    40 - 59% = 1085 
    60 - 79% = 23966 
    80 - 99% = 99 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2593, nodes: 2089783 
    Average node length: 5.44, total dup: 1949491, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181959, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 293 
        40 - 59% = 1725 
        60 - 79% = 293 
        80 - 99% = 278 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2089783 
    Average node length: 5.69, total dup: 1875400, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374331, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2424 
        60 - 79% = 305 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2143, nodes: 2089783 
    Average node length: 4.96, total dup: 2089683, max dup: 27585 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179769, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 235 
        40 - 59% = 1119 
        60 - 79% = 389 
        80 - 99% = 399 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.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: 334.00, compression ratio: 19.65 
    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: 1504339, 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 (137) 
    Primary pointer page: 498, Index root page: 499 
    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: 1544825, 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: 1544824, 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 (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    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 PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.60, total records: 149 
    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.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    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: 1544832, 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: 488, Index root page: 489 
    Total formats: 2, 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: 1544829, 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: 490, Index root page: 491 
    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: 492, Index root page: 493 
    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_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    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 (160) 
    Primary pointer page: 544, Index root page: 545 
    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: 1504252, 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: 486, Index root page: 487 
    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: 484, Index root page: 485 
    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: 1544831, 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: 1544830, 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: 480, Index root page: 481 
    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: 1544833, 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 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    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 RDB$PRIMARY2 (0) 
    Root page: 1504237, 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 (157) 
    Primary pointer page: 538, Index root page: 539 
    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 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, 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: 444.00, compression ratio: 5.73 
    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% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, 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: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, 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: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, 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: 346.00, compression ratio: 10.77 
    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: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    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: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 48.57, total records: 126708 
    Average version length: 69.15, total versions: 43451, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.59 
    Pointer pages: 3, data page slots: 4040 
    Data pages: 2976, average fill: 51% 
    Primary pages: 2976, secondary pages: 0, swept pages: 529 
    Empty pages: 527, full pages: 1179 
    Fill distribution: 
     0 - 19% = 731 
    20 - 39% = 280 
    40 - 59% = 471 
    60 - 79% = 931 
    80 - 99% = 563 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104943, depth: 3, leaf buckets: 211, nodes: 126708 
    Average node length: 6.40, total dup: 110286, max dup: 14 
    Average key length: 3.97, compression ratio: 10.57 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 21635, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 63 
        40 - 59% = 103 
        60 - 79% = 41 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.30, total records: 6790728 
    Average version length: 68.77, total versions: 301794, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 64, data page slots: 103640 
    Data pages: 103640, average fill: 70% 
    Primary pages: 103638, secondary pages: 2, swept pages: 34446 
    Empty pages: 33, full pages: 51986 
    Fill distribution: 
     0 - 19% = 116 
    20 - 39% = 519 
    40 - 59% = 7746 
    60 - 79% = 94495 
    80 - 99% = 764 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10575, nodes: 6790728 
    Average node length: 6.52, total dup: 5869252, max dup: 29 
    Average key length: 3.53, compression ratio: 11.90 
    Average prefix length: 40.60, average data length: 1.40 
    Clustering factor: 1590292, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1989 
        40 - 59% = 5815 
        60 - 79% = 2287 
        80 - 99% = 474 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8239, nodes: 6790728 
    Average node length: 5.41, total dup: 6513815, max dup: 136 
    Average key length: 2.42, compression ratio: 7.04 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1410626, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1261 
        40 - 59% = 4453 
        60 - 79% = 1459 
        80 - 99% = 1063 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8286, nodes: 6790728 
    Average node length: 5.41, total dup: 6513815, max dup: 136 
    Average key length: 2.42, compression ratio: 7.04 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1412971, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1347 
        40 - 59% = 4358 
        60 - 79% = 1506 
        80 - 99% = 1067 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.04, total records: 11833289 
    Average version length: 68.74, total versions: 179832, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 107, data page slots: 173000 
    Data pages: 173000, average fill: 73% 
    Primary pages: 173000, secondary pages: 0, swept pages: 87728 
    Empty pages: 4, full pages: 132714 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 438 
    40 - 59% = 5707 
    60 - 79% = 165940 
    80 - 99% = 877 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18252, nodes: 11832574 
    Average node length: 6.61, total dup: 10313065, max dup: 53 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2433657, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 2530 
        40 - 59% = 10655 
        60 - 79% = 4165 
        80 - 99% = 866 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 51.43, total records: 1268506 
    Average version length: 69.08, total versions: 288108, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.45 
    Pointer pages: 27, data page slots: 42928 
    Data pages: 27440, average fill: 51% 
    Primary pages: 27274, secondary pages: 166, swept pages: 10578 
    Empty pages: 4576, full pages: 13457 
    Fill distribution: 
     0 - 19% = 6971 
    20 - 39% = 3186 
    40 - 59% = 2478 
    60 - 79% = 11370 
    80 - 99% = 3435 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1741, nodes: 1182791 
    Average node length: 5.53, total dup: 1134648, max dup: 49 
    Average key length: 2.58, compression ratio: 16.26 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 79155, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 627 
        40 - 59% = 781 
        60 - 79% = 286 
        80 - 99% = 43 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 40.74, total records: 1168358 
    Average version length: 69.05, total versions: 148370, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.09 
    Pointer pages: 19, data page slots: 30360 
    Data pages: 26280, average fill: 39% 
    Primary pages: 26280, secondary pages: 0, swept pages: 5523 
    Empty pages: 3237, full pages: 6702 
    Fill distribution: 
     0 - 19% = 6275 
    20 - 39% = 6159 
    40 - 59% = 7906 
    60 - 79% = 5825 
    80 - 99% = 115 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1184, nodes: 766266 
    Average node length: 5.90, total dup: 708750, max dup: 51 
    Average key length: 2.97, compression ratio: 14.15 
    Average prefix length: 41.11, average data length: 0.89 
    Clustering factor: 107736, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 364 
        40 - 59% = 598 
        60 - 79% = 209 
        80 - 99% = 13 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.72, total records: 9139614 
    Average version length: 68.93, total versions: 177299, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 90, data page slots: 145456 
    Data pages: 145432, average fill: 67% 
    Primary pages: 145417, secondary pages: 15, swept pages: 76419 
    Empty pages: 319, full pages: 67021 
    Fill distribution: 
     0 - 19% = 1134 
    20 - 39% = 5702 
    40 - 59% = 20833 
    60 - 79% = 117085 
    80 - 99% = 678 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13481, nodes: 9137730 
    Average node length: 6.69, total dup: 7578123, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2062409, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1293 
        40 - 59% = 7036 
        60 - 79% = 4530 
        80 - 99% = 619 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21122369 
    Average version length: 82.96, total versions: 3677, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319336 
    Data pages: 319336, average fill: 81% 
    Primary pages: 319334, secondary pages: 2, swept pages: 13193 
    Empty pages: 16, full pages: 318930 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 36 
    40 - 59% = 55 
    60 - 79% = 49104 
    80 - 99% = 270111 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19269, nodes: 21122369 
    Average node length: 5.72, total dup: 20641802, max dup: 129 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281514, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 7954 
        60 - 79% = 526 
        80 - 99% = 10782 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17142, nodes: 21122369 
    Average node length: 6.31, total dup: 18562437, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918235, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 739 
        60 - 79% = 293 
        80 - 99% = 16104 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21056, nodes: 21122369 
    Average node length: 6.35, total dup: 18481167, max dup: 27 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3574579, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 8210 
        60 - 79% = 632 
        80 - 99% = 12205 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16199, nodes: 21122369 
    Average node length: 5.56, total dup: 21122269, max dup: 230849 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946875, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 15 
        40 - 59% = 3127 
        60 - 79% = 353 
        80 - 99% = 12703 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.93, total records: 9613687 
    Average version length: 82.60, total versions: 196006, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 106, data page slots: 171808 
    Data pages: 171752, average fill: 69% 
    Primary pages: 171726, secondary pages: 26, swept pages: 96365 
    Empty pages: 651, full pages: 96097 
    Fill distribution: 
     0 - 19% = 1901 
    20 - 39% = 6990 
    40 - 59% = 24481 
    60 - 79% = 122182 
    80 - 99% = 16198 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11372, nodes: 9613687 
    Average node length: 5.37, total dup: 9304130, max dup: 185 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2161075, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 80 
        40 - 59% = 8456 
        60 - 79% = 2738 
        80 - 99% = 98 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13428, nodes: 9613687 
    Average node length: 6.24, total dup: 7968748, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1507525, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 4067 
        40 - 59% = 4080 
        60 - 79% = 2695 
        80 - 99% = 2465 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12704, nodes: 9613687 
    Average node length: 5.99, total dup: 8335228, max dup: 29 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2348358, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 87 
        40 - 59% = 9520 
        60 - 79% = 2991 
        80 - 99% = 105 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10216, nodes: 9613687 
    Average node length: 5.14, total dup: 9613587, max dup: 154022 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1533039, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1379 
        40 - 59% = 5059 
        60 - 79% = 1767 
        80 - 99% = 1968 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.61, total records: 11150900 
    Average version length: 82.67, total versions: 105422, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 120, data page slots: 194544 
    Data pages: 193128, average fill: 71% 
    Primary pages: 193034, secondary pages: 94, swept pages: 79638 
    Empty pages: 2760, full pages: 137932 
    Fill distribution: 
     0 - 19% = 4950 
    20 - 39% = 8747 
    40 - 59% = 20780 
    60 - 79% = 98825 
    80 - 99% = 59826 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13127, nodes: 11150900 
    Average node length: 5.31, total dup: 11041096, max dup: 642 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2331247, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 124 
        40 - 59% = 9493 
        60 - 79% = 3377 
        80 - 99% = 132 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10381, nodes: 11150900 
    Average node length: 5.51, total dup: 10664278, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 712697, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 164 
        20 - 39% = 826 
        40 - 59% = 2671 
        60 - 79% = 1781 
        80 - 99% = 4939 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15017, nodes: 11150900 
    Average node length: 6.04, total dup: 9721525, max dup: 76 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2347381, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 163 
        40 - 59% = 11108 
        60 - 79% = 3594 
        80 - 99% = 151 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10723, nodes: 11150900 
    Average node length: 5.23, total dup: 11150800, max dup: 199327 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 702255, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 923 
        40 - 59% = 4693 
        60 - 79% = 1517 
        80 - 99% = 3480 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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 (1) 
    Root page: 1361775, 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 (3) 
    Root page: 1361777, 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 (2) 
    Root page: 1361776, 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_WORKER_ID (0) 
    Root page: 1361774, 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 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.45, total records: 9702937 
    Average version length: 82.91, total versions: 170038, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 108, data page slots: 175760 
    Data pages: 175744, average fill: 68% 
    Primary pages: 175716, secondary pages: 28, swept pages: 103659 
    Empty pages: 650, full pages: 91615 
    Fill distribution: 
     0 - 19% = 2022 
    20 - 39% = 7853 
    40 - 59% = 27546 
    60 - 79% = 123385 
    80 - 99% = 14938 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11854, nodes: 9702937 
    Average node length: 5.19, total dup: 9674212, max dup: 2184 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1948826, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1532 
        40 - 59% = 7951 
        60 - 79% = 1753 
        80 - 99% = 584 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13612, nodes: 9702937 
    Average node length: 6.26, total dup: 8042314, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1462540, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 174 
        20 - 39% = 4125 
        40 - 59% = 4039 
        60 - 79% = 2716 
        80 - 99% = 2558 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12512, nodes: 9702937 
    Average node length: 5.44, total dup: 9266102, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2082033, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1521 
        40 - 59% = 8835 
        60 - 79% = 1583 
        80 - 99% = 540 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10351, nodes: 9702937 
    Average node length: 5.16, total dup: 9702837, max dup: 155791 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1544202, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1465 
        40 - 59% = 5079 
        60 - 79% = 1734 
        80 - 99% = 2025 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.97, total records: 574506 
    Average version length: 68.85, total versions: 2038, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8096 
    Data pages: 8096, average fill: 74% 
    Primary pages: 8096, secondary pages: 0, swept pages: 4273 
    Empty pages: 2, full pages: 6598 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 4 
    40 - 59% = 169 
    60 - 79% = 7907 
    80 - 99% = 14 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40004, depth: 3, leaf buckets: 739, nodes: 574506 
    Average node length: 5.95, total dup: 489055, max dup: 84 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101064, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 524 
        60 - 79% = 93 
        80 - 99% = 91 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30472, depth: 3, leaf buckets: 761, nodes: 574506 
    Average node length: 6.15, total dup: 471129, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101112, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 536 
        60 - 79% = 93 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 584, nodes: 574506 
    Average node length: 4.86, total dup: 574406, max dup: 8848 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89931, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 49 
        40 - 59% = 357 
        60 - 79% = 60 
        80 - 99% = 118 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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 (169) 
    Primary pointer page: 563, Index root page: 564 
    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 (171) 
    Primary pointer page: 567, Index root page: 568 
    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 (174) 
    Primary pointer page: 573, Index root page: 574 
    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: 1504230, 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 (175) 
    Primary pointer page: 575, Index root page: 576 
    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: 1504229, 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 (172) 
    Primary pointer page: 569, Index root page: 570 
    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: 1504235, 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: 1504236, 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 (173) 
    Primary pointer page: 571, Index root page: 572 
    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: 1504232, 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: 1504231, 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: 1504234, 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: 1504233, 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 (168) 
    Primary pointer page: 561, Index root page: 562 
    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 (167) 
    Primary pointer page: 559, Index root page: 560 
    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 (144) 
    Primary pointer page: 512, Index root page: 513 
    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: 1510372, 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 Fri Feb 16 07:10:17 2024

Record versions statistics, table

TABLE_NAME	TOTAL_RECS	TOTAL_VERS	MAX_VERSIONS	VERS_TO_RECS_PRC	MAXV_TO_VERS_PRC
DOC_DATA	7736131	32957	1	0.0000	0.0000
DOC_LIST	2245913	18237	2	0.0000	0.0000
FB_ERRORS	2182	757	1	0.0000	0.0000
INVNT_SALDO	400	1617	5	400.0000	0.0000
INVNT_TURNOVER_LOG	91374	80828	1	0.0000	0.0000
MONEY_SALDO	49	138	7	200.0000	0.0000
MONEY_TURNOVER_LOG	1178	993	1	0.0000	0.0000
PDISTR	785526	24442	2	0.0000	0.0000
PERF_SPLIT_0	161852	2022	1	0.0000	0.0000
PERF_SPLIT_1	144839	2151	1	0.0000	0.0000
PERF_SPLIT_2	148497	99	1	0.0000	0.0000
PERF_SPLIT_3	160925	118	1	0.0000	0.0000
PERF_SPLIT_4	156156	1687	1	0.0000	0.0000
PERF_SPLIT_5	177507	1386	1	0.0000	0.0000
PERF_SPLIT_6	148201	1136	1	0.0000	0.0000
PERF_SPLIT_7	163762	439	1	0.0000	0.0000
PERF_SPLIT_8	160494	182	1	0.0000	0.0000
PERF_SPLIT_9	197178	25952	1	0.0000	0.0000
PSTORNED	2089783	11632	1	0.0000	0.0000
SEMAPHORES	5	1	1	0.0000	100.0000
XQD_1000_1200	126708	43451	1	0.0000	0.0000
XQD_1000_3300	6790728	301794	1	0.0000	0.0000
XQD_1200_2000	11833289	179832	1	0.0000	0.0000
XQD_2000_3300	1268506	288108	1	0.0000	0.0000
XQD_2100_3300	1168358	148370	1	0.0000	0.0000
XQD_3300_3400	9139614	177299	1	0.0000	0.0000
XQS_1000_1200	21122369	3677	1	0.0000	0.0000
XQS_1000_3300	9613687	196006	1	0.0000	0.0000
XQS_1200_2000	11150900	105422	1	0.0000	0.0000
XQS_2100_3300	9702937	170038	1	0.0000	0.0000
XQS_3300_3400	574506	2038	1	0.0000	0.0000


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

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

--- start of diff output ---
:50: 
:51: mscs-test-161.budzdorov.ru    Fri Feb 16 07:07:54 2024
:52:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:53: 
:54: 
:55: mscs-test-161.budzdorov.ru    Fri Feb 16 07:08:00 2024
:56:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:57: 
:58: 
:59: mscs-test-161.budzdorov.ru    Fri Feb 16 07:08:00 2024
:60:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:61: 
:62: 
:63: mscs-test-161.budzdorov.ru    Fri Feb 16 07:08:00 2024
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:65: 
:66: 
:67: mscs-test-161.budzdorov.ru    Fri Feb 16 07:08:00 2024
:68:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:69: 
--- end of diff output ---

 Final processing ISQL logs in /var/tmp/logs-oltp40 according to config parameter 'remove_isql_logs'  
16.02.24 07:10:29. There are 3 logs in /var/tmp/logs-oltp40 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
            0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
    335544321 'string truncation'. Attempt to assign too long text into string variable.
    335544347 'not_valid'. Validation error for column.
    335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
    335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
    335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
    335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
    335544839 'foreign_key_references_present'. Foreign key references are present for the record.

FINISHED_AT	ERRORS_RESULT
2024-02-16 07:10:32	No severe PSQL-related problems occured

16.02.24 07:10:33. End of report.