Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.04.2024 13:08
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 15557684 kB
MemAvailable 30046120 kB
Buffers 0 kB
Cached 16158604 kB
SwapCached 2760 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-04-12 13:07:50
DTS_END                         2024-04-12 13:07:50.6410
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/49252
TRN_ID                          170716
ATT_ID                          495
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: 8923.93 19852 892393
customer order: creation 170.21 404 17021
customer order: refuse 14.36 375 1436
order to supplier: creation 45.51 1356 4551
order to supplier: removal 3.26 102028 326
invoice (draft): creation 44.91 3351 4491
invoice (draft): removal 46.63 815 4663
invoice accept: apply 41.60 23994 4160
invoice accept: cancel 42.59 931 4259
customer reserve: creation 4031.62 229 403162
customer reserve: removal 4203.44 62 420344
realization accept: apply 83.02 213 8302
realization accept: cancel 69.22 149 6922
payment from customer: creation 59.14 118 5914
payment from customer: removal 5.60 83 560
payment to supplier: creation 48.63 143 4863
payment to supplier: removal 3.57 103 357
service: total inventory turnovers 3.61 4436 361
service: total monetary turnovers 5.93 641 593
service: aggregate perf. data 1.05 13245 105
service: refresh index statistics 0.03 244354 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 12-04-2024 13:08:33 to 12-04-2024 13:08:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3121
TEST_TIME 2 3193
TEST_TIME 3 3466
TEST_TIME 4 3624
TEST_TIME 5 4305
TEST_TIME 6 4376
TEST_TIME 7 4967
TEST_TIME 8 5386
TEST_TIME 9 5722
TEST_TIME 10 6414
TEST_TIME 11 6366
TEST_TIME 12 6486
TEST_TIME 13 6332
TEST_TIME 14 6860
TEST_TIME 15 6872
TEST_TIME 16 7273
TEST_TIME 17 7324
TEST_TIME 18 7811
TEST_TIME 19 7903
TEST_TIME 20 8235
TEST_TIME 21 8391
TEST_TIME 22 8462
TEST_TIME 23 8940
TEST_TIME 24 9269
TEST_TIME 25 9608
TEST_TIME 26 9422
TEST_TIME 27 9151
TEST_TIME 28 9510
TEST_TIME 29 9635
TEST_TIME 30 9367
TEST_TIME 31 9344
TEST_TIME 32 9209
TEST_TIME 33 9107
TEST_TIME 34 8968
TEST_TIME 35 8873
TEST_TIME 36 8883
TEST_TIME 37 8808
TEST_TIME 38 8720
TEST_TIME 39 8710
TEST_TIME 40 8638
TEST_TIME 41 8619
TEST_TIME 42 8562
TEST_TIME 43 8566
TEST_TIME 44 8551
TEST_TIME 45 8545
TEST_TIME 46 8591
TEST_TIME 47 8579
TEST_TIME 48 8520
TEST_TIME 49 8638
TEST_TIME 50 8543
TEST_TIME 51 8536
TEST_TIME 52 8879
TEST_TIME 53 8826
TEST_TIME 54 8883
TEST_TIME 55 8846
TEST_TIME 56 8808
TEST_TIME 57 8867
TEST_TIME 58 8934
TEST_TIME 59 8803
TEST_TIME 60 8806
TEST_TIME 61 8747
TEST_TIME 62 8707
TEST_TIME 63 8816
TEST_TIME 64 8730
TEST_TIME 65 8723
TEST_TIME 66 8642
TEST_TIME 67 8618
TEST_TIME 68 8574
TEST_TIME 69 8533
TEST_TIME 70 8512
TEST_TIME 71 8574
TEST_TIME 72 8579
TEST_TIME 73 8558
TEST_TIME 74 8636
TEST_TIME 75 8693
TEST_TIME 76 8750
TEST_TIME 77 8720
TEST_TIME 78 8778
TEST_TIME 79 8853
TEST_TIME 80 8849
TEST_TIME 81 8963
TEST_TIME 82 9051
TEST_TIME 83 9027
TEST_TIME 84 8928
TEST_TIME 85 8855
TEST_TIME 86 8826
TEST_TIME 87 8874
TEST_TIME 88 8878
TEST_TIME 89 8813
TEST_TIME 90 8810
TEST_TIME 91 8777
TEST_TIME 92 8754
TEST_TIME 93 8794
TEST_TIME 94 8808
TEST_TIME 95 8832
TEST_TIME 96 8833
TEST_TIME 97 8840
TEST_TIME 98 8861
TEST_TIME 99 8866
TEST_TIME 100 8931

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-04-2024 13:08:37 to 12-04-2024 13:08:40.

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 1260077 1260077 0 0.00 0 21349 9 0 0
doc_list_biud 1260077 1260077 0 0.00 0 40088 27 0 0
sp_add_invoice_to_stock 4280 4160 120 2.80 21 204776 23995 0 120
sp_cancel_adding_invoice 4259 4259 0 0.00 4 61968 932 0 0
sp_cancel_client_order 1436 1436 0 0.00 3 8880 376 0 0
sp_cancel_customer_reserve 420344 420344 0 0.00 0 40091 63 0 0
sp_cancel_pay_from_customer 560 560 0 0.00 2 3389 84 0 0
sp_cancel_pay_to_supplier 357 357 0 0.00 3 5507 104 0 0
sp_cancel_supplier_invoice 4673 4663 10 0.21 1 34684 816 0 10
sp_cancel_supplier_order 326 326 0 0.00 5 777244 102029 0 0
sp_cancel_write_off 6922 6922 0 0.00 1 8289 149 0 0
sp_client_order 17021 17021 0 0.00 3 20095 405 0 0
sp_customer_reserve 403162 403162 0 0.00 0 38716 229 0 0
sp_fill_shopping_cart 26059 26059 0 0.00 1 13453 40 0 0
sp_fill_shopping_cart_clo_res 403160 403160 0 0.00 0 13514 18 0 0
sp_get_clo_for_invoice 4152 4152 0 0.00 0 19897 435 0 0
sp_kill_cost_storno 12098 12098 0 0.00 0 9565 76 0 0
sp_kill_qstorno_ret_qs2qd 852599 852599 0 0.00 0 40086 34 0 0
sp_kill_qty_storno 450403 450403 0 0.00 0 40088 74 0 0
sp_lock_selected_doc 17198 17198 0 0.00 0 10188 6 0 0
sp_make_cost_storno 23230 23230 0 0.00 0 15405 72 0 0
sp_multiply_rows_for_pdistr 23230 23230 0 0.00 0 10714 33 0 0
sp_multiply_rows_for_qdistr 17021 17021 0 0.00 0 12630 205 0 0
sp_pay_from_customer 5914 5914 0 0.00 3 13134 118 0 0
sp_pay_to_supplier 4863 4863 0 0.00 4 15562 144 0 0
sp_payment_common 10777 10777 0 0.00 1 11650 24 0 0
sp_qd_handle_on_cancel_clo 1436 1436 0 0.00 0 8867 349 0 0
sp_qd_handle_on_invoice_upd_sts 8410 8410 0 0.00 0 39291 356 0 0
sp_qd_handle_on_reserve_upd_sts 8302 8302 0 0.00 0 14429 68 0 0
sp_reserve_write_off 8302 8302 0 0.00 6 19566 213 0 0
sp_supplier_invoice 4491 4491 0 0.00 7 67044 3351 0 0
sp_supplier_order 4551 4551 0 0.00 5 55886 1356 0 0
srv_aggregate_perf_data 105 105 0 0.00 1928 278601 13245 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1184 138812 38941 0 0
srv_find_qd_qs_mism 849396 849396 0 0.00 0 21348 8 0 0
srv_make_invnt_saldo 361 361 0 0.00 67 99792 4437 0 0
srv_make_money_saldo 593 593 0 0.00 0 12893 642 0 0
srv_recalc_idx_stat 3 3 0 0.00 191439 350005 244354 0 0
t$perf-abend:sp_add_invoice_to_stock 120 120 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-norm:sp_add_invoice_to_stock 4160 4160 0 0.00 0 34064 229 0 0
t$perf-norm:sp_cancel_adding_invoice 338 338 0 0.00 0 4097 112 0 0
t$perf-norm:sp_cancel_client_order 1436 1436 0 0.00 0 4667 13 0 0
t$perf-norm:sp_cancel_customer_reserve 571 571 0 0.00 0 6320 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 560 560 0 0.00 0 3849 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 357 357 0 0.00 0 781 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 330 330 0 0.00 0 911 17 0 0
t$perf-norm:sp_cancel_supplier_order 326 326 0 0.00 0 26387 1806 0 0
t$perf-norm:sp_cancel_write_off 828 828 0 0.00 0 32179 61 0 0
t$perf-norm:sp_client_order 17021 17021 0 0.00 0 20529 20 0 0
t$perf-norm:sp_customer_reserve 841 841 0 0.00 0 3681 10 0 0
t$perf-norm:sp_pay_from_customer 5914 5914 0 0.00 0 8921 16 0 0
t$perf-norm:sp_pay_to_supplier 4863 4863 0 0.00 0 21660 15 0 0
t$perf-norm:sp_reserve_write_off 8302 8302 0 0.00 0 6821 11 0 0
t$perf-norm:sp_supplier_invoice 4491 4491 0 0.00 0 5460 17 0 0
t$perf-norm:sp_supplier_order 4551 4551 0 0.00 0 34799 26 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 230 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 150 5 0 0
t$perf-norm:srv_make_invnt_saldo 361 361 0 0.00 0 1942 13 0 0
t$perf-norm:srv_make_money_saldo 593 593 0 0.00 0 1918 7 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 8542 8302 240 2.80 0 4994 19 0 240
v_all_customers 31096 31096 0 0.00 0 91 1 0 0
v_all_suppliers 25658 25658 0 0.00 0 43 1 0 0
v_all_wares 34034 34034 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 676 676 0 0.00 0 1527 10 0 0
v_cancel_client_order 2872 2872 0 0.00 0 2086 7 0 0
v_cancel_customer_prepayment 1120 1120 0 0.00 0 3383 8 0 0
v_cancel_customer_reserve 1142 1142 0 0.00 0 1203 5 0 0
v_cancel_payment_to_supplier 714 714 0 0.00 0 426 6 0 0
v_cancel_supplier_invoice 680 660 20 2.94 0 687 17 0 20
v_cancel_supplier_order 652 652 0 0.00 0 3547 10 0 0
v_cancel_write_off 1656 1656 0 0.00 0 656 12 0 0
v_max_id_clo_ord 4551 4551 0 0.00 0 1561 2 0 0
v_max_id_clo_res 841 841 0 0.00 0 2879 10 0 0
v_max_id_ord_sup 4491 4491 0 0.00 0 1846 3 0 0
v_max_non_paid_invoice 1076 1076 0 0.00 0 290 2 0 0
v_max_non_paid_realizn 3086 3086 0 0.00 0 3238 5 0 0
v_min_id_clo_ord 4551 4551 0 0.00 0 3787 5 0 0
v_min_id_clo_res 841 841 0 0.00 0 5026 19 0 0
v_min_id_ord_sup 4491 4491 0 0.00 0 5240 6 0 0
v_min_non_paid_invoice 4863 4863 0 0.00 0 5160 15 0 0
v_min_non_paid_realizn 5914 5914 0 0.00 0 9192 19 0 0
v_our_firm 8594 8594 0 0.00 0 91 1 0 0
v_reserve_write_off 16600 16600 0 0.00 0 4997 7 0 0
x_lock_depdocs_on_canc_invoice 8592 8592 0 0.00 0 7247 115 0 0
x_lock_depdocs_on_canc_sup_ord 326 326 0 0.00 0 4948 357 0 0
x_make_qstorno_1000_1200 4551 4551 0 0.00 1 55869 1280 0 0
x_make_qstorno_1200_2000 4491 4491 0 0.00 3 67001 3200 0 0
x_make_qstorno_2100_3300 403162 403162 0 0.00 0 38662 208 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 12-04-2024 13:08:41 to 12-04-2024 13:08:46.

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
11:07:54 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
11:08:55 28381 8192000000 9702710432 10000568320 782404512 8.718 100 87 175 0 810576576 7154224 21017840
11:10:35 13966 8192000000 9747421392 10054733824 822761360 9.126 100 87 174 0 854234320 11539472 19933488
11:11:53 18060 8192000000 9777419440 10094915584 851621984 9.416 100 81 162 0 887285088 17650992 18012112
11:13:16 13393 8192000000 9838170032 10169561088 895695040 9.856 100 82 164 1 949870272 36922448 17252784
11:14:38 8087 8192000000 9892214864 10233745408 932933824 10.224 100 80 161 1 1000108944 50105520 17069600
11:15:48 4372 8192000000 9929815488 10280022016 966726880 10.555 100 76 152 0 1039073056 57431504 14914672
11:16:56 2402 8192000000 9974950176 10330529792 994129760 10.822 100 84 168 0 1083492656 72646064 16716832
11:18:00 1931 8192000000 9983758368 10347495424 1023606912 11.107 100 83 162 0 1100160608 60772272 15781424
11:19:04 1021 8192000000 10014578176 10387648512 1040868576 11.273 100 86 172 0 1127931136 70031360 17031200
11:20:07 33330 8192000000 10006035120 10390368256 1059113424 11.448 100 69 136 0 1118364688 45725872 13525392
11:21:42 4330 8192000000 9987223296 10386935808 1066649776 11.520 100 36 74 2 1112626640 38446160 7530704
11:22:47 8489 8192000000 10001811568 10414321664 1075135760 11.601 100 27 54 0 1124531184 44076416 5319008
11:23:56 7236 8192000000 9991038400 10399236096 1079455968 11.642 100 29 58 2 1113282480 28439520 5386992
11:25:06 8751 8192000000 10003345008 10402516992 1080008128 11.648 100 57 114 0 1113434608 21238688 12187792
11:26:15 4145 8192000000 10016318960 10416754688 1084777888 11.693 100 41 80 1 1121212048 28259744 8174416
11:27:21 7388 8192000000 9988649904 10393493504 1079315216 11.641 99 36 73 0 1103810064 16235568 8259280
11:28:32 11504 8192000000 10036915760 10438995968 1100900560 11.846 100 48 96 0 1139832704 30142704 8789440
11:29:50 80323 8192000000 10068937120 10477453312 1106765392 11.902 100 53 106 0 1186380176 68620352 10994432
11:32:17 14155 8192000000 10105359696 10508529664 1083112864 11.677 98 49 97 1 1205419968 112198848 10108256
11:33:35 11003 8192000000 10115425248 10504355840 1068569408 11.538 98 54 108 0 1213938528 134742016 10627104
11:35:14 16497 8192000000 10122625936 10518777856 1081947920 11.666 100 43 85 0 1223600416 132963024 8689472
11:36:37 15894 8192000000 10111467360 10525511680 1055602320 11.414 99 38 76 0 1212955184 149409616 7943248
11:37:57 8248 8192000000 10097422800 10486308864 1077202416 11.621 100 62 121 0 1200991808 110916704 12872688
11:39:11 5585 8192000000 10142500752 10532507648 1088919856 11.732 100 64 127 1 1246490064 144267712 13302496
11:40:20 8222 8192000000 10131647824 10520465408 1082450656 11.671 100 60 118 0 1228442992 133295440 12696896
11:41:41 6380 8192000000 10150138144 10544771072 1099755120 11.835 100 58 116 0 1254592720 142742416 12095184
11:42:55 3441 8192000000 10214409648 10608238592 1105458128 11.889 100 69 138 0 1308589904 188039008 15092768
11:44:06 1177 8192000000 10217148208 10597158912 1081392864 11.661 98 84 169 0 1312856352 214009792 17453696
11:45:11 1601 8192000000 10224205568 10642391040 1104808464 11.883 100 69 138 0 1330065728 209950608 15306656
11:46:20 1410 8192000000 10241099088 10629132288 1113822832 11.969 100 92 181 3 1335484848 202224288 19437728
11:47:28 2289 8192000000 10268990672 10666831872 1115326288 11.983 99 86 169 2 1360178304 226050368 18801648
11:48:34 11999 8192000000 10297926368 10716979200 1128758400 12.110 100 52 104 0 1394515840 253625536 12131904
11:49:56 5383 8192000000 10280562768 10688438272 1139138704 12.207 100 62 124 0 1380578272 227384800 14054768
11:51:05 16881 8192000000 10258324080 10705354752 1132851648 12.148 100 28 57 0 1353121968 213379152 6891168
11:52:25 39609 8192000000 10190071088 10655498240 1134694048 12.166 100 14 28 0 1296340624 158127808 3518768
11:54:19 37787 8192000000 10203896384 10641584128 1125900848 12.083 100 27 54 0 1305127968 173065952 6161168
11:56:30 75549 8192000000 10090220944 10541768704 1136589024 12.183 100 24 48 0 1194531968 52648592 5294352
11:59:04 36492 8192000000 10074243232 10528563200 1137173616 12.189 100 14 26 0 1182634352 42499312 2961424
12:00:42 92310 8192000000 10097641696 10562441216 1146872144 12.280 100 24 47 0 1183933200 32395008 4666048
12:03:17 51909 8192000000 10097320608 10569334784 1152326480 12.331 100 17 34 0 1222857296 66588368 3942448
12:05:12 28559 8192000000 10122537936 10571210752 1157863360 12.383 100 55 107 0 1221406288 52301088 11241840
12:06:41 47706 8192000000 10076519920 10519150592 1132450368 12.144 98 16 32 0 1179919952 44294064 3175520
12:08:37 9510 8192000000 10130046912 10572926976 1146583728 12.277 99 39 75 0 1231567872 77944768 7039376
12:10:23 58804 8192000000 10107407440 10583556096 1143604288 12.249 99 11 22 0 1215946576 70120384 2221904
12:12:22 35837 8192000000 10090151840 10545336320 1141939968 12.234 99 12 24 0 1176970112 32895680 2134464
12:14:52 50782 8192000000 10096517952 10537979904 1103798496 11.874 96 20 38 0 1168299968 60829232 3672240
12:16:44 37078 8192000000 10115860256 10576969728 1126401872 12.087 98 25 50 0 1204194528 72604512 5188144
12:18:23 57651 8192000000 10166791744 10684776448 1136641600 12.184 99 16 32 0 1281111264 140886288 3583376
12:20:27 26104 8192000000 10080338224 10517028864 1114397072 11.974 98 37 74 0 1152153872 30205776 7551024
12:21:58 50396 8192000000 10073871968 10496966656 1081447456 11.661 95 23 46 0 1122126784 35497856 5181472
12:23:50 32113 8192000000 10071875232 10522243072 1082969776 11.676 97 34 68 0 1138576448 49348432 6258240
12:25:24 103889 8192000000 10077872400 10516746240 1093145328 11.773 98 35 70 0 1174883328 75010768 6727232
12:28:09 60640 8192000000 10049530864 10465984512 1098176048 11.820 99 34 67 0 1144385488 38768512 7440928
12:30:11 59669 8192000000 10039935072 10526965760 1088510688 11.728 98 16 32 0 1141972144 50450384 3011072
12:32:11 58155 8192000000 10031405856 10491879424 1069918032 11.551 96 16 32 0 1126705792 53166400 3621360
12:34:16 39500 8192000000 10031430144 10474455040 1072854992 11.579 97 14 28 0 1122344560 46809584 2679984
12:35:57 50186 8192000000 10027062176 10475081728 1052226304 11.382 96 9 17 0 1077460768 23639376 1595088
12:37:47 72684 8192000000 10033500736 10453839872 1065887456 11.513 96 21 42 1 1127719248 57541264 4290528
12:40:04 40661 8192000000 10084685696 10509897728 1093360272 11.775 98 36 72 0 1183610464 82980352 7269840
12:41:49 72478 8192000000 10056147248 10551418880 1101838608 11.855 99 14 26 0 1197411104 92868544 2703952
12:44:05 11984 8192000000 10057758144 10481979392 1119422448 12.022 100 40 81 1 1155057120 27974928 7659744
12:45:18 15172 8192000000 10138623440 10560569344 1100520560 11.843 98 44 88 0 1214988544 106032624 8435360
12:46:43 31848 8192000000 10070587056 10480599040 1123434560 12.059 100 40 79 0 1167427792 36282352 7710880
12:48:18 40588 8192000000 10111220240 10590171136 1119445088 12.022 99 23 46 0 1193753504 70077232 4231184
12:49:59 138810 8192000000 10059308960 10525298688 1129266800 12.114 100 12 24 0 1178311648 46730688 2314160
12:53:20 86231 8192000000 10116429840 10620522496 1142890432 12.243 100 24 48 0 1245955504 98099600 4965472
12:55:55 36065 8192000000 10078110288 10628489216 1124432528 12.069 99 4 8 0 1180210912 54947728 830656
12:57:32 48022 8192000000 10057526144 10520240128 1138760704 12.204 100 20 38 0 1186931920 44504960 3666256
12:59:31 47391 8192000000 10120799088 10559549440 1132063200 12.141 99 32 63 0 1195019696 56602016 6354480
13:01:19 120999 8192000000 10070852080 10529710080 1090709312 11.749 96 14 28 0 1127785968 34228576 2848080
13:04:20 26455 8192000000 10056403056 10486857728 1111427440 11.946 99 31 61 0 1151353056 33059872 6865744
13:05:48 58484 8192000000 10099443472 10555056128 1095635520 11.796 97 23 46 0 1190904864 90838064 4431280
13:07:50 9489 8192000000 8857408384 9067556864 13782048 0.167 2 1 2 0 13885376 67920 35408

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-04-2024 13:08:48 to 12-04-2024 13:09:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 120 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-04-2024 13:09:03 to 12-04-2024 13:09:05.

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          171024
MON$OLDEST_ACTIVE               171025
MON$OLDEST_SNAPSHOT             171025
MON$NEXT_TRANSACTION            171025
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                       1912480
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             691
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Fri Apr 12 13:09:06 2024 
 
Database header page information: 
    Flags            0 
    Generation        89460 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    171024 
    Oldest active        171025 
    Oldest snapshot        171025 
    Next transaction    171026 
    Sequence number        0 
    Next attachment ID    691 
    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.12, total records: 7832953 
    Average version length: 48.16, total versions: 155589, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 88968 
    Data pages: 88968, average fill: 71% 
    Primary pages: 88967, secondary pages: 1, swept pages: 27515 
    Empty pages: 3, full pages: 84648 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 35 
    40 - 59% = 419 
    60 - 79% = 88384 
    80 - 99% = 118 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23181, nodes: 7832953 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1715024, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 300 
        20 - 39% = 1382 
        40 - 59% = 4332 
        60 - 79% = 2174 
        80 - 99% = 14993 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13476, nodes: 7832953 
    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: 1539821, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1287 
        40 - 59% = 2239 
        60 - 79% = 979 
        80 - 99% = 8971 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8300, nodes: 7832953 
    Average node length: 6.64, total dup: 5830946, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1532737, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 118 
        20 - 39% = 742 
        40 - 59% = 1534 
        60 - 79% = 810 
        80 - 99% = 5096 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.70, total records: 2292660 
    Average version length: 58.85, total versions: 83519, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28904 
    Data pages: 28880, average fill: 73% 
    Primary pages: 28878, secondary pages: 2, swept pages: 6797 
    Empty pages: 109, full pages: 27192 
    Fill distribution: 
     0 - 19% = 127 
    20 - 39% = 9 
    40 - 59% = 54 
    60 - 79% = 28468 
    80 - 99% = 222 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4540, nodes: 2292660 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 694776, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 822 
        40 - 59% = 890 
        60 - 79% = 615 
        80 - 99% = 2213 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2419, nodes: 2294494 
    Average node length: 4.97, total dup: 2293595, max dup: 19403 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1283069, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 149 
        40 - 59% = 1382 
        60 - 79% = 588 
        80 - 99% = 297 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1774, nodes: 2292660 
    Average node length: 4.97, total dup: 2292610, max dup: 130083 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1079046, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 616 
        60 - 79% = 48 
        80 - 99% = 1110 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4383, nodes: 2292660 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 694776, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 534 
        40 - 59% = 683 
        60 - 79% = 684 
        80 - 99% = 2363 
 
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: 23.69, total versions: 2892, max versions: 8 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 49% 
    Primary pages: 13, secondary pages: 27, swept pages: 0 
    Empty pages: 6, full pages: 14 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 14 
 
    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: 23.04, total records: 101128 
    Average version length: 68.28, total versions: 77188, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.82 
    Pointer pages: 7, data page slots: 3672 
    Data pages: 1984, average fill: 66% 
    Primary pages: 1983, secondary pages: 1, swept pages: 0 
    Empty pages: 337, full pages: 1364 
    Fill distribution: 
     0 - 19% = 423 
    20 - 39% = 105 
    40 - 59% = 57 
    60 - 79% = 235 
    80 - 99% = 1164 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705028, depth: 3, leaf buckets: 312, nodes: 101128 
    Average node length: 13.49, total dup: 6761, max dup: 2 
    Average key length: 10.69, compression ratio: 2.53 
    Average prefix length: 19.24, average data length: 7.76 
    Clustering factor: 73401, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 51 
        40 - 59% = 169 
        60 - 79% = 51 
        80 - 99% = 40 
 
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: 262, max versions: 7 
    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: 6 
    Data pages: 6, average fill: 17% 
    Primary pages: 1, secondary pages: 5, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    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: 12.86, total records: 1937 
    Average version length: 43.33, total versions: 1731, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.51 
    Pointer pages: 1, data page slots: 72 
    Data pages: 32, average fill: 63% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 5, full pages: 19 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90745, depth: 2, leaf buckets: 3, nodes: 1937 
    Average node length: 4.17, total dup: 1839, max dup: 188 
    Average key length: 2.54, compression ratio: 7.49 
    Average prefix length: 18.51, average data length: 0.49 
    Clustering factor: 1064, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.69, 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.45, total records: 828696 
    Average version length: 37.92, total versions: 43020, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 6, data page slots: 8408 
    Data pages: 8400, average fill: 67% 
    Primary pages: 8399, secondary pages: 1, swept pages: 796 
    Empty pages: 3, full pages: 8277 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 4 
    40 - 59% = 22 
    60 - 79% = 8263 
    80 - 99% = 103 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 846, nodes: 801359 
    Average node length: 4.88, total dup: 801310, max dup: 150122 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89544, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 119 
        40 - 59% = 425 
        60 - 79% = 171 
        80 - 99% = 127 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 890, nodes: 801359 
    Average node length: 5.89, total dup: 713410, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158978, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 420 
        60 - 79% = 82 
        80 - 99% = 351 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 936, nodes: 801359 
    Average node length: 5.89, total dup: 713410, max dup: 44 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160868, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 101 
        40 - 59% = 428 
        60 - 79% = 86 
        80 - 99% = 321 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1123, nodes: 801359 
    Average node length: 5.97, total dup: 713410, max dup: 44 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153064, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 224 
        40 - 59% = 583 
        60 - 79% = 214 
        80 - 99% = 98 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5484 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.38, total fragments: 26, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 80, secondary pages: 15, swept pages: 48 
    Empty pages: 13, full pages: 51 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5484 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.04 
    Average prefix length: 34.46, average data length: 1.55 
    Clustering factor: 5246, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5484 
    Average node length: 11.14, 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: 169, 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.06, total records: 77534 
    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: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 805 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 805 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35657, depth: 2, leaf buckets: 99, nodes: 77534 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2968, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 97 
 
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: 110.56, 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.29 
    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.47, total records: 164272 
    Average version length: 152.26, total versions: 2858, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 7, data page slots: 5096 
    Data pages: 4136, average fill: 82% 
    Primary pages: 4133, secondary pages: 3, swept pages: 6 
    Empty pages: 94, full pages: 4021 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 2 
    80 - 99% = 4022 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 148.24, total records: 161163 
    Average version length: 153.21, total versions: 3398, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 8, data page slots: 5208 
    Data pages: 4032, average fill: 83% 
    Primary pages: 4030, secondary pages: 2, swept pages: 4 
    Empty pages: 62, full pages: 3949 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 3949 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 122.74, total records: 193134 
    Average version length: 154.99, total versions: 38432, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.82 
    Pointer pages: 9, data page slots: 6136 
    Data pages: 4856, average fill: 85% 
    Primary pages: 4854, secondary pages: 2, swept pages: 5 
    Empty pages: 79, full pages: 4740 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 14 
    40 - 59% = 17 
    60 - 79% = 4 
    80 - 99% = 4742 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 148.78, total records: 171917 
    Average version length: 152.69, total versions: 2742, 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: 9, data page slots: 5704 
    Data pages: 4256, average fill: 83% 
    Primary pages: 4254, secondary pages: 2, swept pages: 2 
    Empty pages: 35, full pages: 4211 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4211 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 146.43, total records: 153842 
    Average version length: 153.46, total versions: 4826, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 4088 
    Data pages: 3816, average fill: 83% 
    Primary pages: 3815, secondary pages: 1, swept pages: 1 
    Empty pages: 31, full pages: 3767 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3767 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 144.50, total records: 174011 
    Average version length: 154.00, total versions: 8225, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.74 
    Pointer pages: 7, data page slots: 5656 
    Data pages: 4400, average fill: 82% 
    Primary pages: 4398, secondary pages: 2, swept pages: 1 
    Empty pages: 104, full pages: 4262 
    Fill distribution: 
     0 - 19% = 107 
    20 - 39% = 14 
    40 - 59% = 5 
    60 - 79% = 14 
    80 - 99% = 4260 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 128.25, total records: 195142 
    Average version length: 154.85, total versions: 31533, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.22 
    Pointer pages: 8, data page slots: 6472 
    Data pages: 4912, average fill: 84% 
    Primary pages: 4910, secondary pages: 2, swept pages: 4 
    Empty pages: 83, full pages: 4792 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 15 
    40 - 59% = 7 
    60 - 79% = 12 
    80 - 99% = 4792 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 145.34, total records: 152383 
    Average version length: 153.25, total versions: 5753, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 5, data page slots: 5392 
    Data pages: 3872, average fill: 81% 
    Primary pages: 3871, secondary pages: 1, swept pages: 6 
    Empty pages: 119, full pages: 3719 
    Fill distribution: 
     0 - 19% = 122 
    20 - 39% = 8 
    40 - 59% = 12 
    60 - 79% = 13 
    80 - 99% = 3717 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 147.58, total records: 148205 
    Average version length: 153.11, total versions: 3188, 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: 5, data page slots: 4832 
    Data pages: 3688, average fill: 83% 
    Primary pages: 3686, secondary pages: 2, swept pages: 1 
    Empty pages: 49, full pages: 3623 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3623 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 149.22, total records: 142357 
    Average version length: 148.87, total versions: 1402, 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: 7, data page slots: 4968 
    Data pages: 3544, average fill: 83% 
    Primary pages: 3542, secondary pages: 2, swept pages: 2 
    Empty pages: 46, full pages: 3479 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3479 
 
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.25, total records: 2145696 
    Average version length: 52.96, total versions: 73494, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25760 
    Data pages: 25760, average fill: 72% 
    Primary pages: 25744, secondary pages: 16, swept pages: 8401 
    Empty pages: 43, full pages: 24473 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 100 
    40 - 59% = 309 
    60 - 79% = 24433 
    80 - 99% = 814 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2620, nodes: 2145696 
    Average node length: 5.44, total dup: 2002944, max dup: 1182 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184992, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 222 
        40 - 59% = 1799 
        60 - 79% = 303 
        80 - 99% = 292 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2755, nodes: 2145696 
    Average node length: 5.69, total dup: 1927210, max dup: 65 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 383112, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 2306 
        60 - 79% = 407 
        80 - 99% = 39 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2092, nodes: 2145696 
    Average node length: 4.96, total dup: 2145596, max dup: 28589 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 182664, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 120 
        40 - 59% = 1081 
        60 - 79% = 382 
        80 - 99% = 507 
 
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: 38.29, total records: 154846 
    Average version length: 69.19, total versions: 79559, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.29 
    Pointer pages: 3, data page slots: 4384 
    Data pages: 3464, average fill: 55% 
    Primary pages: 3464, secondary pages: 0, swept pages: 581 
    Empty pages: 840, full pages: 2079 
    Fill distribution: 
     0 - 19% = 1060 
    20 - 39% = 69 
    40 - 59% = 77 
    60 - 79% = 923 
    80 - 99% = 1335 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555861, depth: 3, leaf buckets: 230, nodes: 154846 
    Average node length: 6.46, total dup: 134797, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27279, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 98 
        60 - 79% = 73 
        80 - 99% = 15 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 63.37, total records: 7302610 
    Average version length: 68.79, total versions: 680358, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.99 
    Pointer pages: 65, data page slots: 104760 
    Data pages: 104760, average fill: 76% 
    Primary pages: 104759, secondary pages: 1, swept pages: 6139 
    Empty pages: 1, full pages: 103019 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 26 
    40 - 59% = 145 
    60 - 79% = 99071 
    80 - 99% = 5510 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10722, nodes: 7302610 
    Average node length: 6.51, total dup: 6318646, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1720534, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1344 
        40 - 59% = 5799 
        60 - 79% = 2909 
        80 - 99% = 662 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8556, nodes: 7302610 
    Average node length: 5.39, total dup: 7016730, max dup: 164 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1511102, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1019 
        40 - 59% = 4700 
        60 - 79% = 1572 
        80 - 99% = 1262 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8647, nodes: 7302610 
    Average node length: 5.39, total dup: 7016730, max dup: 164 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1513455, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1086 
        40 - 59% = 4757 
        60 - 79% = 1563 
        80 - 99% = 1233 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.45, total records: 12148841 
    Average version length: 68.74, total versions: 502579, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 106, data page slots: 172792 
    Data pages: 172792, average fill: 75% 
    Primary pages: 172790, secondary pages: 2, swept pages: 42022 
    Empty pages: 7, full pages: 172271 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 2 
    40 - 59% = 44 
    60 - 79% = 167959 
    80 - 99% = 4777 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18368, nodes: 12143886 
    Average node length: 6.61, total dup: 10586056, max dup: 67 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2489781, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 2149 
        40 - 59% = 10544 
        60 - 79% = 4840 
        80 - 99% = 803 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 37.71, total records: 2135676 
    Average version length: 69.06, total versions: 619708, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.34 
    Pointer pages: 26, data page slots: 41736 
    Data pages: 30336, average fill: 69% 
    Primary pages: 30267, secondary pages: 69, swept pages: 934 
    Empty pages: 217, full pages: 29884 
    Fill distribution: 
     0 - 19% = 336 
    20 - 39% = 4596 
    40 - 59% = 2449 
    60 - 79% = 13692 
    80 - 99% = 9263 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1979, nodes: 1639072 
    Average node length: 5.52, total dup: 1572366, max dup: 49 
    Average key length: 2.56, compression ratio: 16.44 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 117135, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 242 
        40 - 59% = 930 
        60 - 79% = 612 
        80 - 99% = 183 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 30.94, total records: 1730816 
    Average version length: 69.03, total versions: 205736, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.07 
    Pointer pages: 23, data page slots: 36392 
    Data pages: 31880, average fill: 39% 
    Primary pages: 31880, secondary pages: 0, swept pages: 5815 
    Empty pages: 6802, full pages: 16205 
    Fill distribution: 
     0 - 19% = 10336 
    20 - 39% = 4168 
    40 - 59% = 6639 
    60 - 79% = 10063 
    80 - 99% = 674 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1233, nodes: 838549 
    Average node length: 5.93, total dup: 773180, max dup: 99 
    Average key length: 2.99, compression ratio: 14.02 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 119979, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 289 
        40 - 59% = 649 
        60 - 79% = 271 
        80 - 99% = 23 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.02, total records: 9596293 
    Average version length: 68.96, total versions: 772457, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 89, data page slots: 144344 
    Data pages: 144336, average fill: 72% 
    Primary pages: 144318, secondary pages: 18, swept pages: 21014 
    Empty pages: 182, full pages: 114427 
    Fill distribution: 
     0 - 19% = 567 
    20 - 39% = 2541 
    40 - 59% = 12826 
    60 - 79% = 120844 
    80 - 99% = 7558 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13481, nodes: 9587960 
    Average node length: 6.68, total dup: 7952894, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2202314, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 810 
        40 - 59% = 6423 
        60 - 79% = 5340 
        80 - 99% = 907 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21132702 
    Average version length: 82.97, total versions: 21466, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319336 
    Data pages: 319336, average fill: 81% 
    Primary pages: 319331, secondary pages: 5, swept pages: 10436 
    Empty pages: 19, full pages: 319186 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 47255 
    80 - 99% = 272042 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19267, nodes: 21132702 
    Average node length: 5.72, total dup: 20652250, max dup: 141 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280153, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 7969 
        60 - 79% = 527 
        80 - 99% = 10767 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17128, nodes: 21132702 
    Average node length: 6.31, total dup: 18570856, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916164, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 7 
        40 - 59% = 742 
        60 - 79% = 248 
        80 - 99% = 16128 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21058, nodes: 21132702 
    Average node length: 6.35, total dup: 18490756, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3574546, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8270 
        60 - 79% = 557 
        80 - 99% = 12224 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15985, nodes: 21132702 
    Average node length: 5.56, total dup: 21132602, max dup: 229838 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945031, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 5 
        40 - 59% = 2712 
        60 - 79% = 366 
        80 - 99% = 12900 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 77.04, total records: 10008644 
    Average version length: 82.61, total versions: 731998, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 104, data page slots: 168280 
    Data pages: 168264, average fill: 74% 
    Primary pages: 168238, secondary pages: 26, swept pages: 39003 
    Empty pages: 406, full pages: 130646 
    Fill distribution: 
     0 - 19% = 1035 
    20 - 39% = 2939 
    40 - 59% = 12700 
    60 - 79% = 116876 
    80 - 99% = 34714 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11330, nodes: 10008644 
    Average node length: 5.36, total dup: 9697431, max dup: 205 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2318776, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 7096 
        60 - 79% = 4056 
        80 - 99% = 154 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13583, nodes: 10008644 
    Average node length: 6.24, total dup: 8298017, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1657311, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 3742 
        40 - 59% = 4340 
        60 - 79% = 2498 
        80 - 99% = 2882 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12659, nodes: 10008644 
    Average node length: 5.98, total dup: 8700669, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2516534, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 35 
        40 - 59% = 8054 
        60 - 79% = 4400 
        80 - 99% = 169 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10226, nodes: 10008644 
    Average node length: 5.14, total dup: 10008544, max dup: 161969 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1668199, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1022 
        40 - 59% = 5004 
        60 - 79% = 1883 
        80 - 99% = 2282 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.17, total records: 11704402 
    Average version length: 82.54, total versions: 660485, 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: 118, data page slots: 192496 
    Data pages: 191584, average fill: 76% 
    Primary pages: 191446, secondary pages: 138, swept pages: 43787 
    Empty pages: 1594, full pages: 164714 
    Fill distribution: 
     0 - 19% = 2759 
    20 - 39% = 4164 
    40 - 59% = 10126 
    60 - 79% = 94005 
    80 - 99% = 80530 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13133, nodes: 11704402 
    Average node length: 5.31, total dup: 11594469, max dup: 633 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2453359, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 50 
        40 - 59% = 8075 
        60 - 79% = 4747 
        80 - 99% = 261 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10603, nodes: 11704402 
    Average node length: 5.51, total dup: 11194146, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 751123, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 724 
        40 - 59% = 2576 
        60 - 79% = 1779 
        80 - 99% = 5392 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15019, nodes: 11704402 
    Average node length: 6.03, total dup: 10226587, max dup: 81 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2469959, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 72 
        40 - 59% = 9572 
        60 - 79% = 5080 
        80 - 99% = 293 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10982, nodes: 11704402 
    Average node length: 5.24, total dup: 11704302, max dup: 207263 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 738083, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 72 
        20 - 39% = 680 
        40 - 59% = 4950 
        60 - 79% = 1486 
        80 - 99% = 3794 
 
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: 77.54, total records: 10103563 
    Average version length: 82.91, total versions: 711823, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 106, data page slots: 172880 
    Data pages: 172824, average fill: 73% 
    Primary pages: 172799, secondary pages: 25, swept pages: 44605 
    Empty pages: 454, full pages: 129162 
    Fill distribution: 
     0 - 19% = 1391 
    20 - 39% = 4483 
    40 - 59% = 16470 
    60 - 79% = 117065 
    80 - 99% = 33415 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12003, nodes: 10103563 
    Average node length: 5.17, total dup: 10073970, max dup: 1554 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2120158, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1289 
        40 - 59% = 8060 
        60 - 79% = 1964 
        80 - 99% = 669 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13719, nodes: 10103563 
    Average node length: 6.24, total dup: 8376738, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1619924, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 192 
        20 - 39% = 3694 
        40 - 59% = 4434 
        60 - 79% = 2447 
        80 - 99% = 2952 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12658, nodes: 10103563 
    Average node length: 5.43, total dup: 9655172, max dup: 105 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2256870, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1263 
        40 - 59% = 8970 
        60 - 79% = 1762 
        80 - 99% = 633 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10329, nodes: 10103563 
    Average node length: 5.14, total dup: 10103463, max dup: 164264 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1690714, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1056 
        40 - 59% = 5090 
        60 - 79% = 1902 
        80 - 99% = 2255 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.88, total records: 589110 
    Average version length: 68.82, total versions: 12873, 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: 5, data page slots: 8128 
    Data pages: 8128, average fill: 76% 
    Primary pages: 8128, secondary pages: 0, swept pages: 2287 
    Empty pages: 7, full pages: 7961 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 4 
    40 - 59% = 28 
    60 - 79% = 7718 
    80 - 99% = 371 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 29611, depth: 3, leaf buckets: 746, nodes: 589110 
    Average node length: 5.95, total dup: 501842, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 103029, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 18 
        40 - 59% = 537 
        60 - 79% = 99 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 16347, depth: 3, leaf buckets: 770, nodes: 589110 
    Average node length: 6.15, total dup: 483440, max dup: 29 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 103098, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 18 
        40 - 59% = 555 
        60 - 79% = 100 
        80 - 99% = 97 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 551, nodes: 589110 
    Average node length: 4.86, total dup: 589010, max dup: 9504 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 91473, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 22 
        40 - 59% = 303 
        60 - 79% = 57 
        80 - 99% = 168 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Apr 12 13:09:30 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7832953 155589 1 0.0000 0.0000
DOC_LIST 2292660 83519 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2892 8 700.0000 0.0000
INVNT_TURNOVER_LOG 101128 77188 1 0.0000 0.0000
MONEY_SALDO 49 262 7 500.0000 0.0000
MONEY_TURNOVER_LOG 1937 1731 1 0.0000 0.0000
PDISTR 828696 43020 3 0.0000 0.0000
PERF_SPLIT_0 164272 2858 1 0.0000 0.0000
PERF_SPLIT_1 161163 3398 1 0.0000 0.0000
PERF_SPLIT_2 193134 38432 1 0.0000 0.0000
PERF_SPLIT_3 171917 2742 1 0.0000 0.0000
PERF_SPLIT_4 153842 4826 1 0.0000 0.0000
PERF_SPLIT_5 174011 8225 1 0.0000 0.0000
PERF_SPLIT_6 195142 31533 1 0.0000 0.0000
PERF_SPLIT_7 152383 5753 1 0.0000 0.0000
PERF_SPLIT_8 148205 3188 1 0.0000 0.0000
PERF_SPLIT_9 142357 1402 1 0.0000 0.0000
PSTORNED 2145696 73494 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 154846 79559 1 0.0000 0.0000
XQD_1000_3300 7302610 680358 1 0.0000 0.0000
XQD_1200_2000 12148841 502579 1 0.0000 0.0000
XQD_2000_3300 2135676 619708 1 0.0000 0.0000
XQD_2100_3300 1730816 205736 1 0.0000 0.0000
XQD_3300_3400 9596293 772457 1 0.0000 0.0000
XQS_1000_1200 21132702 21466 1 0.0000 0.0000
XQS_1000_3300 10008644 731998 1 0.0000 0.0000
XQS_1200_2000 11704402 660485 1 0.0000 0.0000
XQS_2100_3300 10103563 711823 1 0.0000 0.0000
XQS_3300_3400 589110 12873 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 ---
--- end of diff output ---

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

12.04.24 13:09:42. 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-04-12 13:09:45 No severe PSQL-related problems occured
12.04.24 13:09:46. End of report.