Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.03.2024 07:17
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database Statistics, full
  3. Record versions statistics    as table    as chart
  4. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  5. New in firebird.log while test was run
  6. 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 15637232 kB
MemAvailable 30232996 kB
Buffers 0 kB
Cached 16048084 kB
SwapCached 2332 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-03-12 07:16:34
DTS_END                         2024-03-12 07:16:34.7390
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/39222
TRN_ID                          169030
ATT_ID                          470
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: 9168.86 26584 916886
customer order: creation 172.81 389 17281
customer order: refuse 15.28 366 1528
order to supplier: creation 47.75 1427 4775
order to supplier: removal 3.81 92079 381
invoice (draft): creation 46.37 3472 4637
invoice (draft): removal 48.85 861 4885
invoice accept: apply 43.09 22544 4309
invoice accept: cancel 43.58 870 4358
customer reserve: creation 4150.61 216 415061
customer reserve: removal 4305.03 64 430503
realization accept: apply 84.28 216 8428
realization accept: cancel 77.21 134 7721
payment from customer: creation 60.22 133 6022
payment from customer: removal 6.45 99 645
payment to supplier: creation 48.63 141 4863
payment to supplier: removal 3.34 129 334
service: total inventory turnovers 4.01 4641 401
service: total monetary turnovers 6.49 716 649
service: aggregate perf. data 1.01 13701 101
service: refresh index statistics 0.04 389474 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 12-03-2024 07:17:32 to 12-03-2024 07:17:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4567
TEST_TIME 2 3959
TEST_TIME 3 4620
TEST_TIME 4 5077
TEST_TIME 5 4689
TEST_TIME 6 5419
TEST_TIME 7 5959
TEST_TIME 8 5868
TEST_TIME 9 6243
TEST_TIME 10 6169
TEST_TIME 11 6030
TEST_TIME 12 6014
TEST_TIME 13 5979
TEST_TIME 14 5843
TEST_TIME 15 5635
TEST_TIME 16 5562
TEST_TIME 17 5644
TEST_TIME 18 5722
TEST_TIME 19 5802
TEST_TIME 20 6045
TEST_TIME 21 6083
TEST_TIME 22 6365
TEST_TIME 23 6764
TEST_TIME 24 6857
TEST_TIME 25 7363
TEST_TIME 26 7583
TEST_TIME 27 8366
TEST_TIME 28 8193
TEST_TIME 29 8355
TEST_TIME 30 8614
TEST_TIME 31 8664
TEST_TIME 32 9102
TEST_TIME 33 9141
TEST_TIME 34 9021
TEST_TIME 35 9158
TEST_TIME 36 9224
TEST_TIME 37 9306
TEST_TIME 38 9364
TEST_TIME 39 9413
TEST_TIME 40 9231
TEST_TIME 41 9133
TEST_TIME 42 9115
TEST_TIME 43 9043
TEST_TIME 44 9078
TEST_TIME 45 9133
TEST_TIME 46 9063
TEST_TIME 47 9065
TEST_TIME 48 9081
TEST_TIME 49 9050
TEST_TIME 50 8923
TEST_TIME 51 9002
TEST_TIME 52 9082
TEST_TIME 53 9123
TEST_TIME 54 9253
TEST_TIME 55 9239
TEST_TIME 56 9218
TEST_TIME 57 9329
TEST_TIME 58 9273
TEST_TIME 59 9352
TEST_TIME 60 9400
TEST_TIME 61 9358
TEST_TIME 62 9428
TEST_TIME 63 9372
TEST_TIME 64 9254
TEST_TIME 65 9242
TEST_TIME 66 9207
TEST_TIME 67 9226
TEST_TIME 68 9160
TEST_TIME 69 9095
TEST_TIME 70 9105
TEST_TIME 71 9043
TEST_TIME 72 8998
TEST_TIME 73 9035
TEST_TIME 74 9016
TEST_TIME 75 9087
TEST_TIME 76 9080
TEST_TIME 77 9070
TEST_TIME 78 9150
TEST_TIME 79 9211
TEST_TIME 80 9217
TEST_TIME 81 9197
TEST_TIME 82 9280
TEST_TIME 83 9344
TEST_TIME 84 9327
TEST_TIME 85 9339
TEST_TIME 86 9421
TEST_TIME 87 9340
TEST_TIME 88 9273
TEST_TIME 89 9257
TEST_TIME 90 9275
TEST_TIME 91 9237
TEST_TIME 92 9185
TEST_TIME 93 9156
TEST_TIME 94 9103
TEST_TIME 95 9087
TEST_TIME 96 9124
TEST_TIME 97 9133
TEST_TIME 98 9143
TEST_TIME 99 9221
TEST_TIME 100 9175

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-03-2024 07:17:36 to 12-03-2024 07:17:39.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1295106 1295106 0 0.00 0 30970 8 0 0
doc_list_biud 1295100 1295100 0 0.00 0 43590 27 0 0
sp_add_invoice_to_stock 4401 4309 92 2.09 43 231786 22544 0 92
sp_cancel_adding_invoice 4358 4358 0 0.00 4 62944 871 0 0
sp_cancel_client_order 1528 1528 0 0.00 4 11536 367 0 0
sp_cancel_customer_reserve 430503 430503 0 0.00 0 43591 65 0 0
sp_cancel_pay_from_customer 645 645 0 0.00 2 6688 100 0 0
sp_cancel_pay_to_supplier 334 334 0 0.00 3 8611 130 0 0
sp_cancel_supplier_invoice 4895 4885 10 0.20 1 29168 861 0 10
sp_cancel_supplier_order 381 381 0 0.00 7 988451 92079 0 0
sp_cancel_write_off 7721 7721 0 0.00 1 9294 135 0 0
sp_client_order 17281 17281 0 0.00 3 32028 389 0 0
sp_customer_reserve 415061 415061 0 0.00 0 108197 216 0 0
sp_fill_shopping_cart 26681 26681 0 0.00 1 12314 41 0 0
sp_fill_shopping_cart_clo_res 415055 415055 0 0.00 0 17387 17 0 0
sp_get_clo_for_invoice 4303 4303 0 0.00 0 28309 320 0 0
sp_kill_cost_storno 13058 13058 0 0.00 0 30961 75 0 0
sp_kill_qstorno_ret_qs2qd 873993 873993 0 0.00 0 43538 35 0 0
sp_kill_qty_storno 462101 462101 0 0.00 0 43590 75 0 0
sp_lock_selected_doc 17684 17684 0 0.00 0 7000 5 0 0
sp_make_cost_storno 23614 23614 0 0.00 0 13062 71 0 0
sp_multiply_rows_for_pdistr 23612 23612 0 0.00 0 10124 43 0 0
sp_multiply_rows_for_qdistr 17281 17281 0 0.00 0 17684 189 0 0
sp_pay_from_customer 6022 6022 0 0.00 3 18362 134 0 0
sp_pay_to_supplier 4863 4863 0 0.00 4 8876 141 0 0
sp_payment_common 10883 10883 0 0.00 1 7915 26 0 0
sp_qd_handle_on_cancel_clo 1528 1528 0 0.00 0 11529 339 0 0
sp_qd_handle_on_invoice_upd_sts 8658 8658 0 0.00 0 29754 318 0 0
sp_qd_handle_on_reserve_upd_sts 8425 8425 0 0.00 0 23949 68 0 0
sp_reserve_write_off 8428 8428 0 0.00 5 23973 217 0 0
sp_supplier_invoice 4637 4637 0 0.00 5 84250 3473 0 0
sp_supplier_order 4775 4775 0 0.00 3 34509 1427 0 0
srv_aggregate_perf_data 102 101 1 0.98 1588 106835 13701 0 1
srv_fill_mon_cache_memory 57 57 0 0.00 1217 148788 39342 0 0
srv_find_qd_qs_mism 872678 872678 0 0.00 0 18306 7 0 0
srv_make_invnt_saldo 401 401 0 0.00 42 110506 4642 0 0
srv_make_money_saldo 649 649 0 0.00 1 17749 716 0 0
srv_recalc_idx_stat 4 4 0 0.00 244917 519149 389475 0 0
t$perf-abend:sp_add_invoice_to_stock 92 92 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4309 4309 0 0.00 0 7529 191 0 0
t$perf-norm:sp_cancel_adding_invoice 335 335 0 0.00 0 7990 173 0 0
t$perf-norm:sp_cancel_client_order 1528 1528 0 0.00 0 1179 11 0 0
t$perf-norm:sp_cancel_customer_reserve 577 577 0 0.00 0 1680 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 645 645 0 0.00 0 694 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 334 334 0 0.00 0 1474 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 355 355 0 0.00 0 3647 27 0 0
t$perf-norm:sp_cancel_supplier_order 381 381 0 0.00 0 19950 1545 0 0
t$perf-norm:sp_cancel_write_off 805 805 0 0.00 0 4632 22 0 0
t$perf-norm:sp_client_order 17281 17281 0 0.00 0 4578 16 0 0
t$perf-norm:sp_customer_reserve 800 800 0 0.00 0 813 5 0 0
t$perf-norm:sp_pay_from_customer 6022 6022 0 0.00 0 6549 11 0 0
t$perf-norm:sp_pay_to_supplier 4863 4863 0 0.00 0 2751 12 0 0
t$perf-norm:sp_reserve_write_off 8428 8428 0 0.00 0 9206 15 0 0
t$perf-norm:sp_supplier_invoice 4637 4637 0 0.00 0 1948 17 0 0
t$perf-norm:sp_supplier_order 4775 4775 0 0.00 0 2908 17 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 289 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 5 1 0 0
t$perf-norm:srv_make_invnt_saldo 401 401 0 0.00 0 1344 14 0 0
t$perf-norm:srv_make_money_saldo 649 649 0 0.00 0 1826 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 12 5 0 0
v_add_invoice_to_stock 8784 8600 184 2.09 0 6876 16 0 184
v_all_customers 31892 31892 0 0.00 0 20 1 0 0
v_all_suppliers 26358 26358 0 0.00 0 35 1 0 0
v_all_wares 34556 34556 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 670 670 0 0.00 0 300 6 0 0
v_cancel_client_order 3056 3056 0 0.00 0 3350 5 0 0
v_cancel_customer_prepayment 1290 1290 0 0.00 0 6683 14 0 0
v_cancel_customer_reserve 1154 1154 0 0.00 0 1595 5 0 0
v_cancel_payment_to_supplier 668 668 0 0.00 0 2137 9 0 0
v_cancel_supplier_invoice 730 710 20 2.73 0 1906 18 0 20
v_cancel_supplier_order 762 762 0 0.00 0 2340 11 0 0
v_cancel_write_off 1610 1610 0 0.00 0 1737 14 0 0
v_max_id_clo_ord 4771 4771 0 0.00 0 331 1 0 0
v_max_id_clo_res 799 799 0 0.00 0 2879 9 0 0
v_max_id_ord_sup 4631 4631 0 0.00 0 3899 5 0 0
v_max_non_paid_invoice 1085 1085 0 0.00 0 861 3 0 0
v_max_non_paid_realizn 3034 3034 0 0.00 0 5872 7 0 0
v_min_id_clo_ord 4771 4771 0 0.00 0 5093 8 0 0
v_min_id_clo_res 799 799 0 0.00 0 6406 16 0 0
v_min_id_ord_sup 4631 4631 0 0.00 0 6477 12 0 0
v_min_non_paid_invoice 4862 4862 0 0.00 0 7105 14 0 0
v_min_non_paid_realizn 6020 6020 0 0.00 0 7906 20 0 0
v_our_firm 8634 8634 0 0.00 0 28 1 0 0
v_reserve_write_off 16846 16846 0 0.00 0 4025 5 0 0
x_lock_depdocs_on_canc_invoice 8888 8888 0 0.00 0 12801 148 0 0
x_lock_depdocs_on_canc_sup_ord 381 381 0 0.00 0 7757 301 0 0
x_make_qstorno_1000_1200 4775 4775 0 0.00 1 34450 1341 0 0
x_make_qstorno_1200_2000 4637 4637 0 0.00 2 84243 3319 0 0
x_make_qstorno_2100_3300 415061 415061 0 0.00 0 108195 196 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 12-03-2024 07:17:40 to 12-03-2024 07:17:45.

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:16:38 3 8192000000 8800650512 8812683264 5725248 0.069 3 1 2 0 5826448 65424 35776
05:17:39 27000 8192000000 9699183552 9992978432 775957456 8.652 100 89 178 0 805636624 7082416 22596752
05:19:12 8406 8192000000 9741253456 10043088896 818749184 9.086 100 92 184 0 851360848 10846608 21765056
05:20:27 14505 8192000000 9770863936 10079490048 845143088 9.351 100 89 178 0 881467280 15994880 20329312
05:21:52 10349 8192000000 9832748208 10158399488 895758352 9.856 100 87 174 1 943694464 28727504 19208608
05:23:06 12537 8192000000 9896054160 10234945536 935155312 10.245 100 85 169 1 1007366752 54045808 18165632
05:24:20 4338 8192000000 9928021360 10277457920 972628592 10.612 100 72 144 1 1039286800 51906496 14751712
05:25:31 5432 8192000000 9981389984 10339782656 1009202320 10.968 100 77 155 0 1094544496 69767952 15574224
05:26:39 1969 8192000000 10001225904 10365976576 1024901280 11.119 100 80 156 0 1120930272 80062496 15966496
05:27:43 2952 8192000000 10006535056 10373832704 1040910656 11.273 100 82 162 1 1117486016 61001888 15573472
05:28:48 1490 8192000000 10035780560 10410348544 1062853680 11.484 100 84 167 1 1151299760 71979424 16466656
05:29:51 1230 8192000000 10037220960 10417528832 1074717264 11.597 100 82 163 2 1155899536 64947200 16235072
05:30:53 17242 8192000000 9983504448 10391912448 1073612656 11.587 100 32 65 1 1095572000 14030176 7929168
05:32:11 9474 8192000000 9993234320 10400096256 1084336352 11.689 100 23 43 0 1110475264 21196304 4942608
05:33:22 3123 8192000000 10005938496 10399592448 1093205856 11.773 100 47 91 1 1120826800 17629040 9991904
05:34:28 48170 8192000000 10005428384 10412888064 1097409568 11.813 100 34 66 1 1121029680 16371872 7248240
05:36:19 6347 8192000000 10051430576 10466275328 1100739056 11.845 100 33 67 1 1150760464 43512144 6509264
05:37:29 17641 8192000000 10052810336 10454310912 1110876032 11.941 100 45 91 0 1150745488 30550208 9319248
05:38:52 22523 8192000000 10067806656 10474991616 1107042496 11.904 99 61 119 2 1177955536 57918880 12994160
05:40:17 7947 8192000000 10063726160 10469490688 1110922320 11.941 99 45 89 0 1163271024 43129056 9219648
05:41:29 20028 8192000000 10102132832 10505928704 1106985376 11.904 99 47 94 0 1208184368 91515072 9683920
05:43:00 12344 8192000000 10138879456 10535436288 1123569920 12.061 100 67 135 0 1232875424 95584368 13721136
05:44:19 18122 8192000000 10093175600 10487373824 1079566992 11.643 97 55 107 1 1176808720 86065136 11176592
05:45:46 16915 8192000000 10062381328 10467377152 1079373168 11.641 97 46 87 1 1159211568 70859136 8979264
05:47:07 37354 8192000000 10068294880 10474901504 1070009728 11.552 97 38 76 0 1148885984 70569664 8306592
05:48:52 31008 8192000000 10135194096 10540781568 1114002032 11.970 100 52 104 0 1238490544 113195984 11292528
05:50:34 26865 8192000000 10125527872 10520895488 1084212832 11.688 98 45 90 0 1222294000 128216864 9864304
05:52:08 10552 8192000000 10173617984 10573684736 1106620640 11.900 100 47 93 2 1275769536 158908384 10240512
05:53:31 3477 8192000000 10209638384 10600853504 1094960160 11.790 100 60 119 0 1313778416 205822864 12995392
05:54:43 7497 8192000000 10264813616 10660270080 1101707280 11.854 100 63 126 0 1362750000 246966384 14076336
05:56:08 4607 8192000000 10211550352 10609397760 1107999104 11.913 100 58 114 2 1318269472 198018576 12251792
05:57:17 2963 8192000000 10289877472 10690138112 1115866528 11.988 100 68 136 0 1390383328 259414992 15101808
05:58:25 1217 8192000000 10308094800 10716561408 1125916544 12.083 100 83 163 2 1405881200 261442192 18522464
05:59:32 2715 8192000000 10326042176 10718400512 1123045232 12.056 100 82 159 2 1427135616 285964160 18126224
06:00:38 1647 8192000000 10359996432 10757435392 1138805120 12.204 100 74 148 2 1453156688 297547120 16804448
06:01:44 8350 8192000000 10314301712 10757042176 1136512080 12.183 100 32 65 0 1423182720 278120320 8550320
06:02:55 5811 8192000000 10311520512 10742702080 1140525984 12.220 100 53 106 0 1409380352 256581200 12273168
06:04:05 33044 8192000000 10212598912 10636828672 1142542448 12.239 100 58 116 0 1320206512 164547328 13116736
06:05:46 11647 8192000000 10206709552 10654924800 1132450000 12.144 100 37 72 1 1311475424 170458256 8567168
06:07:03 23366 8192000000 10144625184 10597437440 1128736048 12.109 99 14 28 0 1239994368 108076368 3181952
06:08:28 31602 8192000000 10099911488 10568536064 1142016112 12.234 100 16 32 0 1206640704 60782784 3841808
06:10:01 12326 8192000000 10093906720 10520936448 1149083504 12.301 100 42 84 1 1178662224 21047440 8531280
06:11:21 8461 8192000000 10147083920 10575982592 1152190272 12.330 100 43 86 0 1237305616 76603024 8512320
06:12:35 85942 8192000000 10125004576 10610577408 1159639440 12.400 100 17 29 1 1262536112 99003232 3893440
06:15:09 90706 8192000000 10075288144 10517778432 1159105936 12.395 100 14 26 0 1212752720 50913488 2733296
06:17:50 132750 8192000000 10137813920 10595696640 1144586848 12.259 98 22 44 0 1211743728 63224336 3932544
06:21:03 40403 8192000000 10143395104 10614886400 1147046032 12.282 98 30 60 0 1227462576 74239856 6176688
06:22:48 32007 8192000000 10148433888 10612187136 1159704736 12.400 99 38 78 1 1249878576 82185312 7988528
06:24:36 24980 8192000000 10147190992 10637008896 1162277520 12.425 100 16 32 1 1254160416 87947744 3935152
06:26:13 8825 8192000000 10136071152 10580746240 1151972384 12.328 99 32 64 2 1235400096 76310880 7116832
06:27:40 47579 8192000000 10116314032 10582061056 1105000944 11.885 96 11 22 0 1207685600 100481840 2202816
06:29:29 52963 8192000000 10123104352 10585473024 1140899840 12.224 99 29 58 0 1224502848 77960352 5642656
06:31:26 47167 8192000000 10098605744 10537373696 1092421536 11.766 97 22 44 0 1175050256 77479184 5149536
06:33:17 32216 8192000000 10082368416 10544181248 1131593344 12.136 100 36 72 0 1192689840 53657776 7438720
06:34:54 14795 8192000000 10135267712 10552233984 1109395264 11.927 99 47 94 0 1215977184 97056528 9525392
06:36:12 69051 8192000000 10044674432 10509684736 1026903184 11.139 92 19 38 0 1064840720 33980816 3956720
06:38:21 50095 8192000000 10017927264 10460614656 1051912672 11.379 96 15 30 0 1096650224 41952992 2784560
06:40:12 148787 8192000000 10009751424 10480889856 1067396224 11.527 97 26 51 1 1123737728 50864960 5476544
06:43:43 28596 8192000000 10022671296 10484412416 1076898944 11.618 98 9 18 0 1110794400 32294240 1601216
06:45:15 65173 8192000000 10061009680 10516992000 1103999664 11.876 99 16 32 0 1158427424 50871552 3556208
06:47:25 66449 8192000000 10050950432 10516340736 1108310848 11.916 99 19 39 0 1166240464 53467632 4461984
06:49:34 68842 8192000000 10087106096 10573271040 1119058880 12.018 100 10 20 0 1174700624 53413440 2228304
06:51:43 60377 8192000000 10071500224 10517471232 1089545392 11.738 96 18 37 0 1143301648 49961952 3794304
06:53:44 71362 8192000000 10088434688 10554134528 1126721680 12.090 99 18 36 0 1214318960 83723168 3874112
06:55:56 45358 8192000000 10102941056 10541531136 1105569536 11.890 97 23 46 0 1140941680 30471648 4900496
06:57:44 42232 8192000000 10089150880 10558877696 1132079792 12.141 99 23 46 0 1180778320 43250176 5448352
06:59:26 94885 8192000000 10092112784 10534277120 1149069168 12.301 99 21 42 0 1209711776 56417632 4224976
07:02:02 70682 8192000000 10112314544 10613686272 1133582064 12.155 98 19 38 0 1203843936 66317120 3944752
07:04:13 92462 8192000000 10104360224 10555990016 1159990368 12.403 100 25 50 1 1204021088 38929632 5101088
07:07:35 32456 8192000000 10069898096 10556407808 1142631296 12.240 99 10 20 0 1179594208 34908688 2054224
07:09:08 57673 8192000000 10108553328 10580156416 1143727392 12.251 99 16 32 0 1192123648 44192560 4203696
07:11:09 76522 8192000000 10083550016 10560348160 1143260288 12.246 99 20 40 1 1220707488 72869552 4577648
07:13:37 44174 8192000000 10087204368 10549362688 1103246512 11.868 96 24 48 0 1158861264 50474912 5139840
07:15:32 66924 8192000000 9126399984 9394716672 255132864 3.020 23 3 6 0 281618656 25963760 522032

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 12-03-2024 07:17:47 to 12-03-2024 07:18:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 92 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-03-2024 07:18:02 to 12-03-2024 07:18:04.

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          169029
MON$OLDEST_ACTIVE               169441
MON$OLDEST_SNAPSHOT             169441
MON$NEXT_TRANSACTION            169441
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                       1919328
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             683
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3065 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3065 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3065 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3065 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 Tue Mar 12 07:18:05 2024 
 
Database header page information: 
    Flags            0 
    Generation        88666 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    169029 
    Oldest active        169441 
    Oldest snapshot        169441 
    Next transaction    169442 
    Sequence number        0 
    Next attachment ID    683 
    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.37, total records: 7755771 
    Average version length: 48.16, total versions: 103883, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 89192 
    Data pages: 89192, average fill: 70% 
    Primary pages: 89190, secondary pages: 2, swept pages: 33503 
    Empty pages: 2, full pages: 76661 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 257 
    40 - 59% = 3013 
    60 - 79% = 85848 
    80 - 99% = 40 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23126, nodes: 7755771 
    Average node length: 18.90, 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: 1684210, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 317 
        20 - 39% = 1618 
        40 - 59% = 4176 
        60 - 79% = 2299 
        80 - 99% = 14716 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13425, nodes: 7755771 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1509338, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1427 
        40 - 59% = 2083 
        60 - 79% = 1070 
        80 - 99% = 8845 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8287, nodes: 7755771 
    Average node length: 6.62, total dup: 5793600, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1502447, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 875 
        40 - 59% = 1391 
        60 - 79% = 896 
        80 - 99% = 4990 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.29, total records: 2253200 
    Average version length: 58.87, total versions: 53988, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28960 
    Data pages: 28960, average fill: 72% 
    Primary pages: 28958, secondary pages: 2, swept pages: 9368 
    Empty pages: 5, full pages: 22044 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 72 
    40 - 59% = 1102 
    60 - 79% = 27666 
    80 - 99% = 101 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4535, nodes: 2253200 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 678201, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 894 
        40 - 59% = 840 
        60 - 79% = 710 
        80 - 99% = 2091 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2447, nodes: 2254611 
    Average node length: 4.97, total dup: 2253712, max dup: 18729 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1265690, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 199 
        40 - 59% = 1455 
        60 - 79% = 562 
        80 - 99% = 231 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1791, nodes: 2253200 
    Average node length: 4.97, total dup: 2253150, max dup: 130105 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1073263, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 637 
        60 - 79% = 47 
        80 - 99% = 1101 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4328, nodes: 2253200 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 678201, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 570 
        40 - 59% = 600 
        60 - 79% = 782 
        80 - 99% = 2269 
 
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.97, total versions: 3196, max versions: 9 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 54% 
    Primary pages: 10, secondary pages: 30, swept pages: 0 
    Empty pages: 3, full pages: 16 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 18 
 
    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: 33.01, total records: 116768 
    Average version length: 68.28, total versions: 69476, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 2.67 
    Pointer pages: 8, data page slots: 2152 
    Data pages: 1760, average fill: 82% 
    Primary pages: 1759, secondary pages: 1, swept pages: 0 
    Empty pages: 47, full pages: 1685 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 7 
    40 - 59% = 10 
    60 - 79% = 520 
    80 - 99% = 1166 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700831, depth: 3, leaf buckets: 338, nodes: 116768 
    Average node length: 13.48, total dup: 8431, max dup: 2 
    Average key length: 10.65, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 85928, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 4 
        40 - 59% = 235 
        60 - 79% = 49 
        80 - 99% = 47 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 139, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 32% 
    Primary pages: 1, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    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: 18.88, total records: 2136 
    Average version length: 43.62, total versions: 1548, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.07 
    Pointer pages: 1, data page slots: 64 
    Data pages: 32, average fill: 66% 
    Primary pages: 31, secondary pages: 1, swept pages: 4 
    Empty pages: 5, full pages: 23 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92453, depth: 2, leaf buckets: 5, nodes: 2136 
    Average node length: 4.14, total dup: 2039, max dup: 221 
    Average key length: 2.51, compression ratio: 7.56 
    Average prefix length: 18.53, average data length: 0.47 
    Clustering factor: 1054, ratio: 0.49 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 1 
        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.68, total records: 74 
    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: 52% 
    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: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    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: 35.99, total records: 817852 
    Average version length: 37.91, total versions: 34707, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8336 
    Data pages: 8336, average fill: 67% 
    Primary pages: 8335, secondary pages: 1, swept pages: 1133 
    Empty pages: 0, full pages: 8305 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 8263 
    80 - 99% = 72 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 862, nodes: 798923 
    Average node length: 4.88, total dup: 798874, max dup: 152358 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90768, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 133 
        40 - 59% = 444 
        60 - 79% = 183 
        80 - 99% = 99 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 878, nodes: 798923 
    Average node length: 5.89, total dup: 711247, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161176, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 21 
        40 - 59% = 412 
        60 - 79% = 101 
        80 - 99% = 342 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 916, nodes: 798923 
    Average node length: 5.89, total dup: 711247, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163087, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 84 
        40 - 59% = 405 
        60 - 79% = 104 
        80 - 99% = 322 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1108, nodes: 798923 
    Average node length: 5.97, total dup: 711247, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155713, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 203 
        40 - 59% = 599 
        60 - 79% = 198 
        80 - 99% = 106 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 63.06, total records: 5530 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.46, total fragments: 13, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.01 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 63% 
    Primary pages: 76, secondary pages: 11, swept pages: 53 
    Empty pages: 7, full pages: 58 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5530 
    Average node length: 5.53, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.08 
    Average prefix length: 34.62, average data length: 1.55 
    Clustering factor: 5244, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 2 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5530 
    Average node length: 11.15, 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: 173, 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.09, total records: 76974 
    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: 808 
    Data pages: 808, average fill: 65% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 800 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 800 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37015, depth: 2, leaf buckets: 99, nodes: 76974 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3002, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 1 
        80 - 99% = 95 
 
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: 148.64, total records: 148462 
    Average version length: 152.74, total versions: 2694, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 7, data page slots: 4640 
    Data pages: 3680, average fill: 83% 
    Primary pages: 3677, secondary pages: 3, swept pages: 4 
    Empty pages: 26, full pages: 3644 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3644 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 149.15, total records: 134481 
    Average version length: 149.76, total versions: 2000, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 8, data page slots: 5832 
    Data pages: 3384, average fill: 82% 
    Primary pages: 3383, secondary pages: 1, swept pages: 4 
    Empty pages: 66, full pages: 3292 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 7 
    40 - 59% = 12 
    60 - 79% = 4 
    80 - 99% = 3292 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.83, total records: 137338 
    Average version length: 149.03, total versions: 1925, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 6, data page slots: 3928 
    Data pages: 3456, average fill: 82% 
    Primary pages: 3454, secondary pages: 2, swept pages: 4 
    Empty pages: 59, full pages: 3335 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 6 
    40 - 59% = 44 
    60 - 79% = 8 
    80 - 99% = 3334 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.95, total records: 157305 
    Average version length: 151.41, total versions: 3448, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 6, data page slots: 5728 
    Data pages: 3936, average fill: 83% 
    Primary pages: 3933, secondary pages: 3, swept pages: 3 
    Empty pages: 65, full pages: 3854 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3856 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 146.20, total records: 157672 
    Average version length: 153.23, total versions: 5592, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 7, data page slots: 5608 
    Data pages: 4016, average fill: 81% 
    Primary pages: 4014, secondary pages: 2, swept pages: 2 
    Empty pages: 119, full pages: 3861 
    Fill distribution: 
     0 - 19% = 125 
    20 - 39% = 13 
    40 - 59% = 6 
    60 - 79% = 10 
    80 - 99% = 3862 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 122.89, total records: 172852 
    Average version length: 155.01, total versions: 34294, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.80 
    Pointer pages: 8, data page slots: 5208 
    Data pages: 4336, average fill: 85% 
    Primary pages: 4334, secondary pages: 2, swept pages: 4 
    Empty pages: 68, full pages: 4243 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 4242 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 134.79, total records: 165167 
    Average version length: 155.17, total versions: 18747, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.58 
    Pointer pages: 8, data page slots: 4448 
    Data pages: 4112, average fill: 84% 
    Primary pages: 4110, secondary pages: 2, swept pages: 2 
    Empty pages: 33, full pages: 4042 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 6 
    40 - 59% = 20 
    60 - 79% = 6 
    80 - 99% = 4042 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 147.61, total records: 154648 
    Average version length: 151.54, total versions: 3723, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 8, data page slots: 5504 
    Data pages: 3936, average fill: 81% 
    Primary pages: 3933, secondary pages: 3, swept pages: 3 
    Empty pages: 122, full pages: 3784 
    Fill distribution: 
     0 - 19% = 125 
    20 - 39% = 14 
    40 - 59% = 4 
    60 - 79% = 12 
    80 - 99% = 3781 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 148.32, total records: 148884 
    Average version length: 151.88, total versions: 2936, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 6, data page slots: 5408 
    Data pages: 3768, average fill: 82% 
    Primary pages: 3766, secondary pages: 2, swept pages: 8 
    Empty pages: 93, full pages: 3637 
    Fill distribution: 
     0 - 19% = 100 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 19 
    80 - 99% = 3635 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 127.42, total records: 176041 
    Average version length: 154.25, total versions: 29250, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.31 
    Pointer pages: 7, data page slots: 6696 
    Data pages: 4472, average fill: 83% 
    Primary pages: 4469, secondary pages: 3, swept pages: 3 
    Empty pages: 104, full pages: 4290 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 9 
    40 - 59% = 51 
    60 - 79% = 18 
    80 - 99% = 4289 
 
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: 51.77, total records: 2110863 
    Average version length: 52.88, total versions: 47056, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25856 
    Data pages: 25856, average fill: 70% 
    Primary pages: 25842, secondary pages: 14, swept pages: 10450 
    Empty pages: 137, full pages: 22504 
    Fill distribution: 
     0 - 19% = 283 
    20 - 39% = 291 
    40 - 59% = 809 
    60 - 79% = 23986 
    80 - 99% = 487 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2579, nodes: 2110863 
    Average node length: 5.44, total dup: 1969931, max dup: 1638 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182346, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 245 
        40 - 59% = 1730 
        60 - 79% = 305 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2752, nodes: 2110863 
    Average node length: 5.69, total dup: 1894886, max dup: 68 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377165, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2350 
        60 - 79% = 365 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2125, nodes: 2110863 
    Average node length: 4.96, total dup: 2110763, max dup: 28327 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180173, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 190 
        40 - 59% = 1131 
        60 - 79% = 340 
        80 - 99% = 461 
 
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.62, 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: 42.27, total records: 143953 
    Average version length: 69.17, total versions: 64416, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.98 
    Pointer pages: 3, data page slots: 4056 
    Data pages: 3168, average fill: 55% 
    Primary pages: 3168, secondary pages: 0, swept pages: 560 
    Empty pages: 707, full pages: 1988 
    Fill distribution: 
     0 - 19% = 953 
    20 - 39% = 113 
    40 - 59% = 68 
    60 - 79% = 856 
    80 - 99% = 1178 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102519, depth: 3, leaf buckets: 222, nodes: 143953 
    Average node length: 6.43, total dup: 125282, max dup: 14 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 24724, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 44 
        40 - 59% = 110 
        60 - 79% = 54 
        80 - 99% = 13 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.90, total records: 7164871 
    Average version length: 68.76, total versions: 484499, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 65, data page slots: 105224 
    Data pages: 105224, average fill: 73% 
    Primary pages: 105224, secondary pages: 0, swept pages: 12685 
    Empty pages: 10, full pages: 90351 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 528 
    40 - 59% = 4081 
    60 - 79% = 98490 
    80 - 99% = 2057 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10674, nodes: 7164871 
    Average node length: 6.51, total dup: 6196955, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1677315, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1494 
        40 - 59% = 5805 
        60 - 79% = 2734 
        80 - 99% = 632 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8411, nodes: 7164871 
    Average node length: 5.39, total dup: 6882475, max dup: 175 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1475346, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 863 
        40 - 59% = 4791 
        60 - 79% = 1632 
        80 - 99% = 1108 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8409, nodes: 7164871 
    Average node length: 5.39, total dup: 6882475, max dup: 175 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1477619, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 892 
        40 - 59% = 4713 
        60 - 79% = 1671 
        80 - 99% = 1130 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.18, total records: 12240720 
    Average version length: 68.73, total versions: 357583, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 107, data page slots: 174528 
    Data pages: 174528, average fill: 75% 
    Primary pages: 174528, secondary pages: 0, swept pages: 52450 
    Empty pages: 8, full pages: 172013 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 150 
    40 - 59% = 716 
    60 - 79% = 170694 
    80 - 99% = 2934 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18506, nodes: 12237539 
    Average node length: 6.62, total dup: 10667598, max dup: 73 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2501225, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 2136 
        40 - 59% = 10734 
        60 - 79% = 4708 
        80 - 99% = 906 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 40.73, total records: 1604908 
    Average version length: 69.09, total versions: 430243, 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: 27, data page slots: 43704 
    Data pages: 27375, average fill: 59% 
    Primary pages: 27294, secondary pages: 81, swept pages: 4377 
    Empty pages: 2055, full pages: 20355 
    Fill distribution: 
     0 - 19% = 3653 
    20 - 39% = 4311 
    40 - 59% = 2447 
    60 - 79% = 11184 
    80 - 99% = 5780 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1709, nodes: 1276697 
    Average node length: 5.52, total dup: 1224736, max dup: 49 
    Average key length: 2.58, compression ratio: 16.31 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 89032, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 403 
        40 - 59% = 815 
        60 - 79% = 388 
        80 - 99% = 91 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 35.39, total records: 1436133 
    Average version length: 69.06, total versions: 190972, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.56 
    Pointer pages: 20, data page slots: 32320 
    Data pages: 28800, average fill: 40% 
    Primary pages: 28800, secondary pages: 0, swept pages: 5998 
    Empty pages: 5440, full pages: 15166 
    Fill distribution: 
     0 - 19% = 9185 
    20 - 39% = 3861 
    40 - 59% = 5850 
    60 - 79% = 9263 
    80 - 99% = 641 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1210, nodes: 822513 
    Average node length: 5.97, total dup: 756077, max dup: 73 
    Average key length: 3.03, compression ratio: 13.85 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 121186, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 276 
        40 - 59% = 623 
        60 - 79% = 287 
        80 - 99% = 24 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.21, total records: 9318707 
    Average version length: 68.95, total versions: 563839, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 90, data page slots: 146216 
    Data pages: 146192, average fill: 69% 
    Primary pages: 146175, secondary pages: 17, swept pages: 40127 
    Empty pages: 290, full pages: 82876 
    Fill distribution: 
     0 - 19% = 958 
    20 - 39% = 4515 
    40 - 59% = 19953 
    60 - 79% = 116700 
    80 - 99% = 4066 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13461, nodes: 9310595 
    Average node length: 6.69, total dup: 7723052, max dup: 23 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2091925, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1193 
        40 - 59% = 6603 
        60 - 79% = 4937 
        80 - 99% = 728 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21110968 
    Average version length: 83.01, total versions: 15326, 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: 319184 
    Data pages: 319184, average fill: 81% 
    Primary pages: 319179, secondary pages: 5, swept pages: 12859 
    Empty pages: 33, full pages: 318528 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 33 
    40 - 59% = 95 
    60 - 79% = 48432 
    80 - 99% = 270565 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19414, nodes: 21110968 
    Average node length: 5.72, total dup: 20631056, max dup: 129 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277162, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 0 
        40 - 59% = 8279 
        60 - 79% = 525 
        80 - 99% = 10601 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17127, nodes: 21110968 
    Average node length: 6.31, total dup: 18551786, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916854, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 5 
        40 - 59% = 749 
        60 - 79% = 277 
        80 - 99% = 16094 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21170, nodes: 21110968 
    Average node length: 6.35, total dup: 18471704, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571165, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 8516 
        60 - 79% = 561 
        80 - 99% = 12087 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16146, nodes: 21110968 
    Average node length: 5.56, total dup: 21110868, max dup: 229046 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945500, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 15 
        40 - 59% = 3054 
        60 - 79% = 350 
        80 - 99% = 12726 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 78.47, total records: 9722576 
    Average version length: 82.58, total versions: 521385, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 107, data page slots: 173704 
    Data pages: 173672, average fill: 70% 
    Primary pages: 173645, secondary pages: 27, swept pages: 67097 
    Empty pages: 469, full pages: 97357 
    Fill distribution: 
     0 - 19% = 1520 
    20 - 39% = 6693 
    40 - 59% = 26220 
    60 - 79% = 115222 
    80 - 99% = 24017 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11358, nodes: 9722576 
    Average node length: 5.38, total dup: 9413701, max dup: 199 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2185712, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 67 
        40 - 59% = 8015 
        60 - 79% = 3195 
        80 - 99% = 80 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13444, nodes: 9722576 
    Average node length: 6.25, total dup: 8059972, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1530599, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 3827 
        40 - 59% = 4398 
        60 - 79% = 2481 
        80 - 99% = 2611 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12671, nodes: 9722576 
    Average node length: 5.99, total dup: 8438437, max dup: 45 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2376302, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 86 
        40 - 59% = 8993 
        60 - 79% = 3475 
        80 - 99% = 117 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10306, nodes: 9722576 
    Average node length: 5.15, total dup: 9722476, max dup: 148228 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1562799, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1328 
        40 - 59% = 5216 
        60 - 79% = 1725 
        80 - 99% = 1996 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.26, total records: 11259616 
    Average version length: 82.60, total versions: 465508, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 119, data page slots: 193904 
    Data pages: 192144, average fill: 72% 
    Primary pages: 191998, secondary pages: 146, swept pages: 63577 
    Empty pages: 3039, full pages: 146718 
    Fill distribution: 
     0 - 19% = 4961 
    20 - 39% = 7302 
    40 - 59% = 17081 
    60 - 79% = 92942 
    80 - 99% = 69858 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13107, nodes: 11259616 
    Average node length: 5.30, total dup: 11150340, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2359893, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 133 
        40 - 59% = 9179 
        60 - 79% = 3688 
        80 - 99% = 106 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10275, nodes: 11259616 
    Average node length: 5.49, total dup: 10767841, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 725805, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 825 
        40 - 59% = 2431 
        60 - 79% = 1721 
        80 - 99% = 5152 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14993, nodes: 11259616 
    Average node length: 6.02, total dup: 9825739, max dup: 70 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2376294, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 179 
        40 - 59% = 10676 
        60 - 79% = 3994 
        80 - 99% = 142 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10627, nodes: 11259616 
    Average node length: 5.22, total dup: 11259516, max dup: 187374 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 713949, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 799 
        40 - 59% = 4675 
        60 - 79% = 1419 
        80 - 99% = 3642 
 
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: 78.86, total records: 9832410 
    Average version length: 82.91, total versions: 516297, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 109, data page slots: 177544 
    Data pages: 177504, average fill: 69% 
    Primary pages: 177478, secondary pages: 26, swept pages: 70014 
    Empty pages: 474, full pages: 99147 
    Fill distribution: 
     0 - 19% = 1604 
    20 - 39% = 7609 
    40 - 59% = 29859 
    60 - 79% = 114596 
    80 - 99% = 23836 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11840, nodes: 9832410 
    Average node length: 5.19, total dup: 9803347, max dup: 1719 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1983479, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1391 
        40 - 59% = 7946 
        60 - 79% = 1887 
        80 - 99% = 590 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13597, nodes: 9832410 
    Average node length: 6.26, total dup: 8151083, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1487532, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 192 
        20 - 39% = 3848 
        40 - 59% = 4351 
        60 - 79% = 2440 
        80 - 99% = 2766 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12473, nodes: 9832410 
    Average node length: 5.45, total dup: 9393081, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2117343, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1350 
        40 - 59% = 8850 
        60 - 79% = 1677 
        80 - 99% = 575 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10420, nodes: 9832410 
    Average node length: 5.16, total dup: 9832310, max dup: 150110 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1573388, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1326 
        40 - 59% = 5361 
        60 - 79% = 1630 
        80 - 99% = 2064 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.26, total records: 578285 
    Average version length: 68.68, total versions: 8928, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8112 
    Data pages: 8112, average fill: 75% 
    Primary pages: 8112, secondary pages: 0, swept pages: 3320 
    Empty pages: 5, full pages: 7009 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 7 
    40 - 59% = 136 
    60 - 79% = 7803 
    80 - 99% = 160 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44269, depth: 3, leaf buckets: 729, nodes: 578285 
    Average node length: 5.95, total dup: 492474, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101050, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 512 
        60 - 79% = 93 
        80 - 99% = 100 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32149, depth: 3, leaf buckets: 752, nodes: 578285 
    Average node length: 6.15, total dup: 474345, max dup: 15 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101096, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 528 
        60 - 79% = 93 
        80 - 99% = 109 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 561, nodes: 578285 
    Average node length: 4.86, total dup: 578185, max dup: 9700 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89818, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 325 
        60 - 79% = 63 
        80 - 99% = 141 
 
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 Tue Mar 12 07:18:29 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7755771 103883 1 0.0000 0.0000
DOC_LIST 2253200 53988 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3196 9 700.0000 0.0000
INVNT_TURNOVER_LOG 116768 69476 1 0.0000 0.0000
MONEY_SALDO 49 139 6 200.0000 0.0000
MONEY_TURNOVER_LOG 2136 1548 1 0.0000 0.0000
PDISTR 817852 34707 3 0.0000 0.0000
PERF_SPLIT_0 148462 2694 1 0.0000 0.0000
PERF_SPLIT_1 134481 2000 1 0.0000 0.0000
PERF_SPLIT_2 137338 1925 1 0.0000 0.0000
PERF_SPLIT_3 157305 3448 1 0.0000 0.0000
PERF_SPLIT_4 157672 5592 1 0.0000 0.0000
PERF_SPLIT_5 172852 34294 1 0.0000 0.0000
PERF_SPLIT_6 165167 18747 1 0.0000 0.0000
PERF_SPLIT_7 154648 3723 1 0.0000 0.0000
PERF_SPLIT_8 148884 2936 1 0.0000 0.0000
PERF_SPLIT_9 176041 29250 1 0.0000 0.0000
PSTORNED 2110863 47056 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 143953 64416 1 0.0000 0.0000
XQD_1000_3300 7164871 484499 1 0.0000 0.0000
XQD_1200_2000 12240720 357583 1 0.0000 0.0000
XQD_2000_3300 1604908 430243 1 0.0000 0.0000
XQD_2100_3300 1436133 190972 1 0.0000 0.0000
XQD_3300_3400 9318707 563839 1 0.0000 0.0000
XQS_1000_1200 21110968 15326 1 0.0000 0.0000
XQS_1000_3300 9722576 521385 1 0.0000 0.0000
XQS_1200_2000 11259616 465508 1 0.0000 0.0000
XQS_2100_3300 9832410 516297 1 0.0000 0.0000
XQS_3300_3400 578285 8928 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Tue Mar 12 07:16:43 2024
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:9: 
--- end of diff output ---

 Final processing ISQL logs in /var/tmp/logs-oltp40 according to config parameter 'remove_isql_logs'  

12.03.24 07:18:41. 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-03-12 07:18:44 No severe PSQL-related problems occured
12.03.24 07:18:45. End of report.