Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.03.2024 16:10
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 15715676 kB
MemAvailable 30263424 kB
Buffers 0 kB
Cached 16023100 kB
SwapCached 2476 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 3.0.12
DB_NAME                         /home/bases/oltp30-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/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/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=3333
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/oltp30-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-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-26 16:09:41
DTS_END                         2024-03-26 16:09:41.1820
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54342
TRN_ID                          168968
ATT_ID                          502
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: 9089.27 18382 908927
customer order: creation 168.13 363 16813
customer order: refuse 14.64 378 1464
order to supplier: creation 44.89 1376 4489
order to supplier: removal 3.75 100688 375
invoice (draft): creation 45.22 3659 4522
invoice (draft): removal 50.83 853 5083
invoice accept: apply 40.78 23921 4078
invoice accept: cancel 46.15 921 4615
customer reserve: creation 3856.73 232 385673
customer reserve: removal 4534.82 65 453482
realization accept: apply 81.17 247 8117
realization accept: cancel 76.42 133 7642
payment from customer: creation 57.65 154 5765
payment from customer: removal 5.77 92 577
payment to supplier: creation 47.08 179 4708
payment to supplier: removal 3.47 99 347
service: total inventory turnovers 4.36 1248 436
service: total monetary turnovers 6.71 27 671
service: aggregate perf. data 0.67 27678 67
service: refresh index statistics 0.03 205333 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 26-03-2024 16:10:49 to 26-03-2024 16:10:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2201
TEST_TIME 2 2415
TEST_TIME 3 2769
TEST_TIME 4 3562
TEST_TIME 5 3619
TEST_TIME 6 4843
TEST_TIME 7 4717
TEST_TIME 8 4811
TEST_TIME 9 4750
TEST_TIME 10 5013
TEST_TIME 11 4949
TEST_TIME 12 5870
TEST_TIME 13 5811
TEST_TIME 14 5921
TEST_TIME 15 5934
TEST_TIME 16 6057
TEST_TIME 17 6215
TEST_TIME 18 6139
TEST_TIME 19 6782
TEST_TIME 20 6866
TEST_TIME 21 6803
TEST_TIME 22 6932
TEST_TIME 23 7074
TEST_TIME 24 7180
TEST_TIME 25 7198
TEST_TIME 26 7288
TEST_TIME 27 7855
TEST_TIME 28 8094
TEST_TIME 29 8095
TEST_TIME 30 8800
TEST_TIME 31 8955
TEST_TIME 32 9426
TEST_TIME 33 9319
TEST_TIME 34 9183
TEST_TIME 35 9186
TEST_TIME 36 9191
TEST_TIME 37 9106
TEST_TIME 38 8940
TEST_TIME 39 9066
TEST_TIME 40 9055
TEST_TIME 41 8922
TEST_TIME 42 8976
TEST_TIME 43 9060
TEST_TIME 44 9183
TEST_TIME 45 9171
TEST_TIME 46 9132
TEST_TIME 47 9030
TEST_TIME 48 9034
TEST_TIME 49 8960
TEST_TIME 50 8866
TEST_TIME 51 8968
TEST_TIME 52 9037
TEST_TIME 53 8992
TEST_TIME 54 8986
TEST_TIME 55 8944
TEST_TIME 56 8940
TEST_TIME 57 9000
TEST_TIME 58 8950
TEST_TIME 59 8898
TEST_TIME 60 8996
TEST_TIME 61 9042
TEST_TIME 62 9146
TEST_TIME 63 9165
TEST_TIME 64 9249
TEST_TIME 65 9202
TEST_TIME 66 9257
TEST_TIME 67 9302
TEST_TIME 68 9276
TEST_TIME 69 9194
TEST_TIME 70 9168
TEST_TIME 71 9076
TEST_TIME 72 9118
TEST_TIME 73 9075
TEST_TIME 74 8994
TEST_TIME 75 8930
TEST_TIME 76 8910
TEST_TIME 77 8987
TEST_TIME 78 9041
TEST_TIME 79 9158
TEST_TIME 80 9154
TEST_TIME 81 9174
TEST_TIME 82 9207
TEST_TIME 83 9263
TEST_TIME 84 9235
TEST_TIME 85 9317
TEST_TIME 86 9421
TEST_TIME 87 9411
TEST_TIME 88 9399
TEST_TIME 89 9325
TEST_TIME 90 9250
TEST_TIME 91 9240
TEST_TIME 92 9196
TEST_TIME 93 9150
TEST_TIME 94 9138
TEST_TIME 95 9085
TEST_TIME 96 9113
TEST_TIME 97 9098
TEST_TIME 98 9124
TEST_TIME 99 9148
TEST_TIME 100 9089

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-03-2024 16:10:53 to 26-03-2024 16:10:56.

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 1262553 1262553 0 0.00 0 30234 8 0 0
doc_list_biud 1262553 1262553 0 0.00 0 52513 30 0 0
sp_add_invoice_to_stock 4168 4078 90 2.15 56 208956 23921 0 90
sp_cancel_adding_invoice 4615 4615 0 0.00 4 60308 921 0 0
sp_cancel_client_order 1464 1464 0 0.00 4 11938 378 0 0
sp_cancel_customer_reserve 453482 453482 0 0.00 0 30463 66 0 0
sp_cancel_pay_from_customer 577 577 0 0.00 3 5722 93 0 0
sp_cancel_pay_to_supplier 347 347 0 0.00 2 2808 99 0 0
sp_cancel_supplier_invoice 5092 5083 9 0.17 1 52516 853 0 9
sp_cancel_supplier_order 375 375 0 0.00 8 1078971 100688 0 0
sp_cancel_write_off 7642 7642 0 0.00 1 10437 133 0 0
sp_client_order 16813 16813 0 0.00 3 19622 364 0 0
sp_customer_reserve 385673 385673 0 0.00 0 51185 233 0 0
sp_fill_shopping_cart 25824 25824 0 0.00 1 10336 37 0 0
sp_fill_shopping_cart_clo_res 385672 385672 0 0.00 0 17910 17 0 0
sp_get_clo_for_invoice 4077 4077 0 0.00 0 17628 277 0 0
sp_kill_cost_storno 13181 13181 0 0.00 0 11848 71 0 0
sp_kill_qstorno_ret_qs2qd 920064 920064 0 0.00 0 52512 35 0 0
sp_kill_qty_storno 484855 484855 0 0.00 0 52513 77 0 0
sp_lock_selected_doc 16923 16923 0 0.00 0 8906 7 0 0
sp_make_cost_storno 22667 22667 0 0.00 0 28603 90 0 0
sp_multiply_rows_for_pdistr 22667 22667 0 0.00 0 18975 36 0 0
sp_multiply_rows_for_qdistr 16813 16813 0 0.00 0 10319 165 0 0
sp_pay_from_customer 5765 5765 0 0.00 4 28701 155 0 0
sp_pay_to_supplier 4708 4708 0 0.00 5 28714 180 0 0
sp_payment_common 10473 10473 0 0.00 1 19271 42 0 0
sp_qd_handle_on_cancel_clo 1464 1464 0 0.00 0 11932 351 0 0
sp_qd_handle_on_invoice_upd_sts 8692 8692 0 0.00 0 25580 375 0 0
sp_qd_handle_on_reserve_upd_sts 8117 8117 0 0.00 0 22036 67 0 0
sp_reserve_write_off 8117 8117 0 0.00 6 30255 247 0 0
sp_supplier_invoice 4522 4522 0 0.00 6 115638 3659 0 0
sp_supplier_order 4489 4489 0 0.00 5 38169 1377 0 0
srv_aggregate_perf_data 67 67 0 0.00 2208 266362 27679 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 2114 124788 35977 0 0
srv_find_qd_qs_mism 868006 868006 0 0.00 0 12202 7 0 0
srv_make_invnt_saldo 436 436 0 0.00 29 85016 1249 0 0
srv_make_money_saldo 671 671 0 0.00 0 591 28 0 0
srv_recalc_idx_stat 3 3 0 0.00 159375 254141 205333 0 0
t$perf-abend:sp_add_invoice_to_stock 90 90 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4078 4078 0 0.00 0 9777 206 0 0
t$perf-norm:sp_cancel_adding_invoice 321 321 0 0.00 0 3789 123 0 0
t$perf-norm:sp_cancel_client_order 1464 1464 0 0.00 0 6943 21 0 0
t$perf-norm:sp_cancel_customer_reserve 550 550 0 0.00 0 2558 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 577 577 0 0.00 0 3232 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 347 347 0 0.00 0 3287 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 320 320 0 0.00 0 3491 30 0 0
t$perf-norm:sp_cancel_supplier_order 375 375 0 0.00 0 22984 1779 0 0
t$perf-norm:sp_cancel_write_off 776 776 0 0.00 0 873 6 0 0
t$perf-norm:sp_client_order 16813 16813 0 0.00 0 14504 19 0 0
t$perf-norm:sp_customer_reserve 771 771 0 0.00 0 1323 5 0 0
t$perf-norm:sp_pay_from_customer 5765 5765 0 0.00 0 22464 14 0 0
t$perf-norm:sp_pay_to_supplier 4708 4708 0 0.00 0 3845 9 0 0
t$perf-norm:sp_reserve_write_off 8117 8117 0 0.00 0 4793 12 0 0
t$perf-norm:sp_supplier_invoice 4522 4522 0 0.00 0 5004 25 0 0
t$perf-norm:sp_supplier_order 4489 4489 0 0.00 0 3101 18 0 0
t$perf-norm:srv_aggregate_perf_data 67 67 0 0.00 0 237 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 822 17 0 0
t$perf-norm:srv_make_invnt_saldo 436 436 0 0.00 0 2671 41 0 0
t$perf-norm:srv_make_money_saldo 671 671 0 0.00 0 3287 29 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 5 4 0 0
v_add_invoice_to_stock 8334 8154 180 2.15 0 10170 22 0 180
v_all_customers 30844 30844 0 0.00 0 19 1 0 0
v_all_suppliers 25324 25324 0 0.00 0 114 1 0 0
v_all_wares 33626 33626 0 0.00 0 30 1 0 0
v_cancel_adding_invoice 642 642 0 0.00 0 1858 10 0 0
v_cancel_client_order 2928 2928 0 0.00 0 2301 5 0 0
v_cancel_customer_prepayment 1154 1154 0 0.00 0 2848 7 0 0
v_cancel_customer_reserve 1100 1100 0 0.00 0 7581 12 0 0
v_cancel_payment_to_supplier 694 694 0 0.00 0 2152 12 0 0
v_cancel_supplier_invoice 658 640 18 2.73 0 1123 17 0 18
v_cancel_supplier_order 750 750 0 0.00 0 660 6 0 0
v_cancel_write_off 1552 1552 0 0.00 0 1336 13 0 0
v_max_id_clo_ord 4489 4489 0 0.00 0 4071 2 0 0
v_max_id_clo_res 771 771 0 0.00 0 2281 13 0 0
v_max_id_ord_sup 4522 4522 0 0.00 0 7093 6 0 0
v_max_non_paid_invoice 1057 1057 0 0.00 0 604 3 0 0
v_max_non_paid_realizn 2878 2878 0 0.00 0 18870 13 0 0
v_min_id_clo_ord 4489 4489 0 0.00 0 2322 6 0 0
v_min_id_clo_res 771 771 0 0.00 0 2696 6 0 0
v_min_id_ord_sup 4522 4522 0 0.00 0 5088 9 0 0
v_min_non_paid_invoice 4708 4708 0 0.00 0 18896 26 0 0
v_min_non_paid_realizn 5765 5765 0 0.00 0 18951 26 0 0
v_our_firm 8556 8556 0 0.00 0 20 1 0 0
v_reserve_write_off 16232 16232 0 0.00 0 10179 7 0 0
x_lock_depdocs_on_canc_invoice 9378 9378 0 0.00 0 19202 170 0 0
x_lock_depdocs_on_canc_sup_ord 375 375 0 0.00 0 9346 359 0 0
x_make_qstorno_1000_1200 4489 4489 0 0.00 1 38162 1296 0 0
x_make_qstorno_1200_2000 4522 4522 0 0.00 3 115616 3522 0 0
x_make_qstorno_2100_3300 385673 385673 0 0.00 0 45018 212 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-03-2024 16:10:57 to 26-03-2024 16:11:01.

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
14:09:44 3 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:46 29215 8192000000 9903753904 10213072896 979170000 10.676 100 89 178 0 1007869616 5864784 22834832
14:12:24 8509 8192000000 9949088496 10271875072 1034334352 11.210 100 89 178 0 1065218832 8522928 22361552
14:13:40 15826 8192000000 9980579904 10311610368 1062816352 11.483 100 88 177 0 1095253664 10135728 22301584
14:15:22 11262 8192000000 10022369168 10369314816 1108628592 11.919 100 75 149 1 1137302688 10254320 18419776
14:16:36 5573 8192000000 10065855792 10421157888 1155819584 12.364 100 78 156 1 1186067760 12288832 17959344
14:17:43 5985 8192000000 10122138000 10493628416 1212669520 12.894 100 72 144 0 1241189008 12832336 15687152
14:18:50 1993 8192000000 10158721392 10534629376 1247792064 13.218 100 86 169 2 1280359616 14035856 18531696
14:19:53 1452 8192000000 10193581840 10575409152 1275566048 13.473 100 90 180 2 1311960656 16521792 19872816
14:20:56 1133 8192000000 10209890016 10595528704 1298000144 13.677 100 86 170 0 1330526256 13248736 19277376
14:21:58 1861 8192000000 10211884528 10605518848 1305462560 13.745 100 59 118 0 1325933584 7720688 12750336
14:23:01 3559 8192000000 10205621824 10614243328 1316972960 13.849 100 29 53 0 1329504432 5314752 7216720
14:24:07 7249 8192000000 10205439856 10622316544 1321140128 13.887 100 32 63 2 1334170608 6211680 6818800
14:25:15 9680 8192000000 10214582752 10634014720 1330353120 13.970 100 14 27 1 1339445072 5701392 3390560
14:26:25 51986 8192000000 10250169408 10657751040 1339629392 14.054 100 55 110 0 1358734416 5331872 13773152
14:28:18 4909 8192000000 10229468800 10649903104 1340861216 14.065 100 31 62 0 1354064304 6594944 6608144
14:29:24 5183 8192000000 10225761104 10646978560 1331115792 13.977 99 26 50 0 1342619904 5614896 5889216
14:30:35 23443 8192000000 10249817856 10660347904 1343772464 14.091 100 47 94 1 1363955472 9165360 11017648
14:32:03 50118 8192000000 10239684416 10650603520 1320181184 13.878 99 51 101 1 1341101616 9891392 11029040
14:34:03 39981 8192000000 10227695600 10637721600 1292925616 13.631 97 34 67 0 1309538256 9235888 7376752
14:35:56 27321 8192000000 10240094000 10644447232 1327298032 13.943 100 52 103 0 1348693552 10023616 11371904
14:37:30 7120 8192000000 10256663968 10662457344 1341707952 14.073 100 65 128 1 1368983920 12830624 14445344
14:38:41 7799 8192000000 10259932336 10670530560 1329414128 13.962 99 48 93 1 1359197120 18740592 11042400
14:39:56 8648 8192000000 10236824032 10640314368 1325061648 13.923 100 46 92 0 1351365824 15737712 10566464
14:41:09 14572 8192000000 10259414336 10670329856 1330345872 13.970 99 61 122 0 1363179264 19215824 13617568
14:42:28 10440 8192000000 10233323760 10634600448 1310868096 13.794 99 52 104 0 1343197392 20030064 12299232
14:43:43 10327 8192000000 10247238656 10650034176 1325865984 13.930 100 45 88 0 1354105296 17365680 10873632
14:44:57 20355 8192000000 10253095408 10664505344 1323146144 13.905 99 40 80 1 1353523232 20733136 9643952
14:46:30 2659 8192000000 10262275296 10665439232 1323571600 13.909 99 57 110 0 1362447904 25644832 13231472
14:47:36 4790 8192000000 10288378992 10688032768 1345899136 14.111 100 75 148 0 1393511296 29849536 17762624
14:48:44 16067 8192000000 10285919872 10705739776 1363344400 14.267 100 41 79 0 1396780688 24262880 9173408
14:50:06 5461 8192000000 10302753776 10717040640 1372774880 14.352 100 56 108 1 1411585232 25013040 13797312
14:51:18 2113 8192000000 10323221504 10724499456 1374801904 14.370 100 80 159 0 1425668928 32105600 18761424
14:52:29 5017 8192000000 10324822320 10738380800 1391010016 14.515 100 62 123 1 1434594800 28854752 14730032
14:53:45 12990 8192000000 10337506928 10763300864 1400688608 14.601 100 49 97 1 1449604864 36217104 12699152
14:55:34 9943 8192000000 10360164736 10781990912 1407642880 14.663 100 59 118 1 1465807152 41973120 16191152
14:56:48 8048 8192000000 10349922752 10779049984 1410999376 14.693 100 48 94 1 1455285872 32067728 12218768
14:58:00 5736 8192000000 10336007472 10775875584 1399211600 14.588 100 31 62 0 1440318336 32747760 8358976
14:59:12 11037 8192000000 10346030416 10781200384 1406539856 14.653 100 50 99 1 1459223840 39892720 12791264
15:00:36 33749 8192000000 10309418032 10767257600 1377453152 14.394 99 13 26 1 1409529984 28190368 3886464
15:02:11 6365 8192000000 10312785808 10744143872 1394699008 14.548 100 57 112 0 1414312272 6810576 12802688
15:03:30 13433 8192000000 10325460000 10765369344 1405614944 14.645 100 30 60 0 1426272736 13671648 6986144
15:04:47 118173 8192000000 10315784000 10766802944 1392751680 14.530 99 29 59 1 1417086944 16940240 7395024
15:08:50 19817 8192000000 10316029120 10756902912 1388888384 14.496 99 57 114 1 1412951088 11441456 12621248
15:10:16 71527 8192000000 10335006592 10782195712 1419420640 14.768 100 25 50 1 1438203120 13331648 5450832
15:12:31 40367 8192000000 10325427408 10779348992 1404771264 14.637 99 31 59 0 1421446160 9812608 6862288
15:14:19 49374 8192000000 10314334224 10772062208 1406567696 14.653 99 27 54 1 1427548032 13920400 7059936
15:16:44 37862 8192000000 10288359488 10749149184 1363503840 14.269 97 15 30 0 1379921232 12389280 4028112
15:18:22 66818 8192000000 10303369424 10754809856 1397321856 14.571 100 22 44 0 1416708544 13842768 5543920
15:20:39 61656 8192000000 10275629936 10739486720 1373962592 14.363 100 15 28 1 1394106736 16566384 3577760
15:22:51 72596 8192000000 10251205008 10709667840 1340965696 14.066 98 20 40 0 1355129744 9453136 4710912
15:25:05 45139 8192000000 10239368400 10687967232 1311891744 13.803 96 17 32 0 1324493920 9015392 3586784
15:27:00 32530 8192000000 10255675696 10680246272 1277249024 13.488 94 37 72 4 1292468288 6866416 8352848
15:28:38 17579 8192000000 10261414928 10694725632 1345851584 14.110 100 37 73 0 1367673552 13787680 8034288
15:29:58 52885 8192000000 10256527552 10704392192 1318873440 13.867 97 15 30 0 1339437424 17174304 3389680
15:31:52 77263 8192000000 10265414448 10714312704 1326179456 13.933 97 14 28 0 1344881200 15557840 3143904
15:34:10 34191 8192000000 10259740896 10682826752 1322396560 13.898 97 32 64 0 1340181200 10846256 6938384
15:35:48 16160 8192000000 10276693744 10696929280 1328979296 13.958 98 46 90 1 1351897872 12310816 10607760
15:37:08 42557 8192000000 10263409632 10677952512 1294309232 13.643 96 50 98 1 1316216800 11856096 10051472
15:38:52 63669 8192000000 10236716784 10669813760 1316671696 13.847 98 40 80 0 1334808368 9015440 9121232
15:40:58 16454 8192000000 10273576048 10702082048 1358666992 14.225 100 47 89 0 1381324336 12959408 9697936
15:42:17 15904 8192000000 10255297712 10711171072 1363737216 14.271 100 8 18 0 1374281664 8846368 1698080
15:43:33 36356 8192000000 10273791312 10724257792 1370920768 14.335 100 11 22 0 1382030176 8537376 2572032
15:45:09 61627 8192000000 10308570816 10754457600 1385875968 14.469 100 18 36 0 1412556592 22022816 4657808
15:47:19 80612 8192000000 10312248480 10758078464 1366773968 14.298 98 15 31 0 1395146224 24662688 3709568
15:49:46 74298 8192000000 10300581792 10762850304 1377731248 14.396 99 8 16 0 1395492544 16032512 1728784
15:52:00 54466 8192000000 10306625136 10764726272 1399116128 14.587 100 15 30 0 1413179648 10908480 3155040
15:54:00 25163 8192000000 10323222288 10766802944 1406420208 14.652 100 38 76 0 1431551920 17041376 8090336
15:55:32 124788 8192000000 10319751856 10762637312 1372732320 14.352 98 19 37 0 1392629328 16063344 3833664
15:58:37 72815 8192000000 10307964512 10763403264 1402921664 14.621 100 23 46 0 1415245792 7017120 5307008
16:00:51 29881 8192000000 10302654112 10763653120 1394485584 14.546 99 15 29 2 1402750784 5669440 2595760
16:02:21 35569 8192000000 10302962544 10765647872 1408895344 14.674 100 8 16 0 1419329280 8506528 1927408
16:04:27 50935 8192000000 10331877648 10787110912 1413798384 14.718 100 17 34 0 1429053056 11036128 4218544
16:06:20 64089 8192000000 10306727824 10770276352 1373681920 14.360 97 17 34 0 1387424288 10059616 3682752
16:08:28 66010 8192000000 10287802432 10732204032 1349164608 14.140 96 23 46 0 1363351952 9532592 4654752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 26-03-2024 16:11:03 to 26-03-2024 16:11:17.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-03-2024 16:11:18 to 26-03-2024 16:11:20.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          167187
MON$OLDEST_ACTIVE               169166
MON$OLDEST_SNAPSHOT             169166
MON$NEXT_TRANSACTION            169166
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-03 16:41:55.3470
MON$PAGES                       1912416
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.12.33740 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33740 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Tue Mar 26 16:11:21 2024 
 
Database header page information: 
    Flags            0 
    Generation        88380 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    167187 
    Oldest active        169166 
    Oldest snapshot        169166 
    Next transaction    169167 
    Sequence number        0 
    Next attachment ID    692 
    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 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    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: 1504311, 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: 1504313, 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: 1504312, 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: 1504310, 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: 1504309, 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: 504, Index root page: 505 
    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: 1504242, 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: 1504244, 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: 1504243, 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: 1504241, 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: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.35, total records: 7698849 
    Average version length: 48.16, total versions: 87452, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86992 
    Data pages: 86992, average fill: 71% 
    Primary pages: 86992, secondary pages: 0, swept pages: 19412 
    Empty pages: 2, full pages: 65477 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 365 
    40 - 59% = 5269 
    60 - 79% = 81311 
    80 - 99% = 32 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23116, nodes: 7698849 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1710671, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 300 
        20 - 39% = 1947 
        40 - 59% = 3994 
        60 - 79% = 2396 
        80 - 99% = 14479 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13438, nodes: 7698849 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1534189, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1668 
        40 - 59% = 1901 
        60 - 79% = 1142 
        80 - 99% = 8726 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8295, nodes: 7698849 
    Average node length: 6.60, total dup: 5774906, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1527100, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 1025 
        40 - 59% = 1310 
        60 - 79% = 942 
        80 - 99% = 4889 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.28, total records: 2214289 
    Average version length: 34.53, total versions: 88119, max versions: 3 
    Average fragment length: 8.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28552 
    Data pages: 28552, average fill: 72% 
    Primary pages: 28547, secondary pages: 5, swept pages: 10333 
    Empty pages: 3, full pages: 19490 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 215 
    40 - 59% = 2940 
    60 - 79% = 24773 
    80 - 99% = 593 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4510, nodes: 2214289 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 688246, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 951 
        40 - 59% = 771 
        60 - 79% = 760 
        80 - 99% = 2028 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2510, nodes: 2216503 
    Average node length: 4.97, total dup: 2215604, max dup: 18321 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1235317, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 294 
        40 - 59% = 1542 
        60 - 79% = 488 
        80 - 99% = 184 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2041, nodes: 2214289 
    Average node length: 4.97, total dup: 2214239, max dup: 130213 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1053740, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 236 
        40 - 59% = 918 
        60 - 79% = 72 
        80 - 99% = 812 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4328, nodes: 2214289 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 688246, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 651 
        40 - 59% = 580 
        60 - 79% = 822 
        80 - 99% = 2174 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    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: 1504315, 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: 1504316, 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: 1504314, 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: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, 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.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, 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: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.53, total records: 400 
    Average version length: 23.30, total versions: 221804, max versions: 580 
    Average fragment length: 2.00, total fragments: 44, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1232 
    Data pages: 1232, average fill: 90% 
    Primary pages: 11, secondary pages: 1221, swept pages: 0 
    Empty pages: 4, full pages: 1227 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1227 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 1.35, total records: 77157 
    Average version length: 68.27, total versions: 75635, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 65.30 
    Pointer pages: 7, data page slots: 2768 
    Data pages: 1360, average fill: 71% 
    Primary pages: 1359, secondary pages: 1, swept pages: 0 
    Empty pages: 150, full pages: 944 
    Fill distribution: 
     0 - 19% = 205 
    20 - 39% = 63 
    40 - 59% = 81 
    60 - 79% = 123 
    80 - 99% = 888 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704742, depth: 3, leaf buckets: 265, nodes: 77157 
    Average node length: 13.38, total dup: 4298, max dup: 2 
    Average key length: 10.75, compression ratio: 2.51 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 56331, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 111 
        40 - 59% = 66 
        60 - 79% = 87 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 17192, max versions: 943 
    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: 64 
    Data pages: 64, average fill: 86% 
    Primary pages: 3, secondary pages: 61, swept pages: 0 
    Empty pages: 2, full pages: 61 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 10 
    80 - 99% = 51 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, 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: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.07, total records: 1369 
    Average version length: 43.14, total versions: 1269, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 18.89 
    Pointer pages: 1, data page slots: 32 
    Data pages: 30, average fill: 43% 
    Primary pages: 29, secondary pages: 1, swept pages: 1 
    Empty pages: 11, full pages: 11 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92853, depth: 2, leaf buckets: 3, nodes: 1369 
    Average node length: 4.37, total dup: 1271, max dup: 145 
    Average key length: 2.76, compression ratio: 6.89 
    Average prefix length: 18.31, average data length: 0.69 
    Clustering factor: 737, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 75 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    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: 520, Index root page: 521 
    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: 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 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, 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: 1504226, 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: 1504228, 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: 1504225, 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: 522, Index root page: 523 
    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: 1504224, 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: 1504222, 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: 1504221, 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: 1504223, 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: 1504220, 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: 468, Index root page: 469 
    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: 1544805, 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: 1544804, 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: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.19, total records: 829939 
    Average version length: 25.50, total versions: 66887, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8264 
    Data pages: 8264, average fill: 70% 
    Primary pages: 8243, secondary pages: 21, swept pages: 1844 
    Empty pages: 23, full pages: 6865 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 86 
    40 - 59% = 274 
    60 - 79% = 7578 
    80 - 99% = 266 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 914, nodes: 829939 
    Average node length: 4.87, total dup: 829890, max dup: 152570 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90114, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 114 
        40 - 59% = 533 
        60 - 79% = 207 
        80 - 99% = 60 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 963, nodes: 829939 
    Average node length: 5.88, total dup: 739049, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163291, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 77 
        40 - 59% = 489 
        60 - 79% = 83 
        80 - 99% = 313 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1014, nodes: 829939 
    Average node length: 5.88, total dup: 739049, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165264, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 186 
        40 - 59% = 453 
        60 - 79% = 76 
        80 - 99% = 299 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1180, nodes: 829939 
    Average node length: 5.96, total dup: 739049, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157643, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 252 
        40 - 59% = 613 
        60 - 79% = 229 
        80 - 99% = 79 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.79, total records: 5440 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.60, total fragments: 77, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 62% 
    Primary pages: 73, secondary pages: 14, swept pages: 59 
    Empty pages: 2, full pages: 63 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5440 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.39, average data length: 1.55 
    Clustering factor: 5046, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5440 
    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: 138, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.09, total records: 77660 
    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: 752 
    Data pages: 752, average fill: 71% 
    Primary pages: 752, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 748 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 748 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 39916, depth: 2, leaf buckets: 99, nodes: 77660 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3156, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    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: 1504239, 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: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    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.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 129.26, total records: 183819 
    Average version length: 153.77, total versions: 26195, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.12 
    Pointer pages: 7, data page slots: 5512 
    Data pages: 4440, average fill: 86% 
    Primary pages: 4440, secondary pages: 0, swept pages: 1 
    Empty pages: 65, full pages: 4346 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 5 
    40 - 59% = 8 
    60 - 79% = 14 
    80 - 99% = 4345 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 147.32, total records: 189254 
    Average version length: 150.18, total versions: 5114, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 6672 
    Data pages: 4632, average fill: 84% 
    Primary pages: 4632, secondary pages: 0, swept pages: 1 
    Empty pages: 110, full pages: 4469 
    Fill distribution: 
     0 - 19% = 119 
    20 - 39% = 10 
    40 - 59% = 25 
    60 - 79% = 8 
    80 - 99% = 4470 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 145.87, total records: 157060 
    Average version length: 149.82, total versions: 5078, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 6, data page slots: 4712 
    Data pages: 3784, average fill: 86% 
    Primary pages: 3784, secondary pages: 0, swept pages: 2 
    Empty pages: 59, full pages: 3707 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3707 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.80, total records: 174952 
    Average version length: 150.39, total versions: 4865, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 6, data page slots: 4864 
    Data pages: 4240, average fill: 85% 
    Primary pages: 4240, secondary pages: 0, swept pages: 3 
    Empty pages: 81, full pages: 4130 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 3 
    40 - 59% = 13 
    60 - 79% = 9 
    80 - 99% = 4129 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 145.96, total records: 160737 
    Average version length: 151.23, total versions: 5489, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 6, data page slots: 4736 
    Data pages: 3976, average fill: 84% 
    Primary pages: 3975, secondary pages: 1, swept pages: 1 
    Empty pages: 137, full pages: 3789 
    Fill distribution: 
     0 - 19% = 149 
    20 - 39% = 13 
    40 - 59% = 10 
    60 - 79% = 14 
    80 - 99% = 3790 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 145.84, total records: 169190 
    Average version length: 150.43, total versions: 5483, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 7, data page slots: 5744 
    Data pages: 4112, average fill: 85% 
    Primary pages: 4112, secondary pages: 0, swept pages: 1 
    Empty pages: 90, full pages: 3984 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 11 
    40 - 59% = 19 
    60 - 79% = 8 
    80 - 99% = 3982 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 130.50, total records: 197332 
    Average version length: 154.36, total versions: 26857, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.00 
    Pointer pages: 8, data page slots: 6448 
    Data pages: 4800, average fill: 86% 
    Primary pages: 4800, secondary pages: 0, swept pages: 1 
    Empty pages: 101, full pages: 4679 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4677 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 147.35, total records: 161080 
    Average version length: 148.12, total versions: 3686, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 7144 
    Data pages: 3864, average fill: 86% 
    Primary pages: 3864, secondary pages: 0, swept pages: 1 
    Empty pages: 42, full pages: 3802 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 8 
    80 - 99% = 3800 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 128.43, total records: 185853 
    Average version length: 154.38, total versions: 27793, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.21 
    Pointer pages: 8, data page slots: 5288 
    Data pages: 4488, average fill: 87% 
    Primary pages: 4488, secondary pages: 0, swept pages: 2 
    Empty pages: 58, full pages: 4409 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 7 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 4407 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.05, total records: 175775 
    Average version length: 149.48, total versions: 4827, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 7, data page slots: 5960 
    Data pages: 4240, average fill: 86% 
    Primary pages: 4239, secondary pages: 1, swept pages: 1 
    Empty pages: 62, full pages: 4157 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 4 
    40 - 59% = 8 
    60 - 79% = 8 
    80 - 99% = 4156 
 
PHRASES (143) 
    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 PHRASES_ID_DESC (3) 
    Root page: 1510354, 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: 1510353, 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: 1510352, 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: 1510351, 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: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.95, total records: 2067614 
    Average version length: 52.94, total versions: 31143, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25536 
    Data pages: 25536, average fill: 70% 
    Primary pages: 25536, secondary pages: 0, swept pages: 11770 
    Empty pages: 394, full pages: 19681 
    Fill distribution: 
     0 - 19% = 773 
    20 - 39% = 590 
    40 - 59% = 1286 
    60 - 79% = 22658 
    80 - 99% = 229 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2542, nodes: 2067614 
    Average node length: 5.45, total dup: 1927653, max dup: 1337 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 180306, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 309 
        40 - 59% = 1640 
        60 - 79% = 281 
        80 - 99% = 307 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2749, nodes: 2067614 
    Average node length: 5.69, total dup: 1855318, max dup: 69 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370618, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2502 
        60 - 79% = 212 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2150, nodes: 2067614 
    Average node length: 4.96, total dup: 2067514, max dup: 26928 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178303, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 244 
        40 - 59% = 1144 
        60 - 79% = 370 
        80 - 99% = 390 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    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: 1504317, 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: 470, Index root page: 471 
    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: 1544803, 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: 1544802, 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: 500, Index root page: 501 
    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: 1504305, 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: 1504306, 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: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, 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: 525, 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: 1544806, 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: 454, Index root page: 455 
    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: 1544810, 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: 460, Index root page: 461 
    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: 1544807, 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: 462, Index root page: 463 
    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: 464, Index root page: 465 
    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: 518, Index root page: 519 
    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: 516, Index root page: 517 
    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: 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 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    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: 456, Index root page: 457 
    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: 1544809, 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: 1544808, 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: 452, Index root page: 453 
    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: 1544811, 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: 528, Index root page: 529 
    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: 1504214, 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: 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 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    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: 1552159, 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: 1510355, 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: 1510360, 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: 1510358, 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: 498, Index root page: 499 
    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: 1504307, 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: 1504308, 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: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 40.44, total records: 133936 
    Average version length: 69.17, total versions: 55695, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 3, data page slots: 4416 
    Data pages: 3408, average fill: 46% 
    Primary pages: 3408, secondary pages: 0, swept pages: 736 
    Empty pages: 948, full pages: 1551 
    Fill distribution: 
     0 - 19% = 1314 
    20 - 39% = 220 
    40 - 59% = 198 
    60 - 79% = 621 
    80 - 99% = 1055 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101536, depth: 3, leaf buckets: 214, nodes: 133936 
    Average node length: 6.39, total dup: 116409, max dup: 14 
    Average key length: 3.98, compression ratio: 10.56 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 22740, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 60 
        40 - 59% = 95 
        60 - 79% = 51 
        80 - 99% = 7 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.43, total records: 7314659 
    Average version length: 68.78, total versions: 374860, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 65, data page slots: 105256 
    Data pages: 105256, average fill: 74% 
    Primary pages: 105256, secondary pages: 0, swept pages: 30376 
    Empty pages: 16, full pages: 81753 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 697 
    40 - 59% = 6140 
    60 - 79% = 93025 
    80 - 99% = 5322 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10846, nodes: 7314659 
    Average node length: 6.51, total dup: 6325607, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1619004, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1398 
        40 - 59% = 5927 
        60 - 79% = 2944 
        80 - 99% = 569 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8805, nodes: 7314659 
    Average node length: 5.39, total dup: 7027879, max dup: 193 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1410299, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1076 
        40 - 59% = 5139 
        60 - 79% = 1537 
        80 - 99% = 1042 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8906, nodes: 7314659 
    Average node length: 5.39, total dup: 7027879, max dup: 193 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1412704, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1143 
        40 - 59% = 5218 
        60 - 79% = 1541 
        80 - 99% = 992 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.17, total records: 12271996 
    Average version length: 68.72, total versions: 317109, 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: 105, data page slots: 171080 
    Data pages: 171080, average fill: 76% 
    Primary pages: 171080, secondary pages: 0, swept pages: 80634 
    Empty pages: 8, full pages: 156679 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 526 
    40 - 59% = 3727 
    60 - 79% = 161278 
    80 - 99% = 5508 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18476, nodes: 12271996 
    Average node length: 6.60, total dup: 10693140, max dup: 61 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2395440, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1941 
        40 - 59% = 10914 
        60 - 79% = 4724 
        80 - 99% = 869 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 44.25, total records: 1621874 
    Average version length: 69.10, total versions: 584120, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.85 
    Pointer pages: 27, data page slots: 42392 
    Data pages: 28815, average fill: 64% 
    Primary pages: 28814, secondary pages: 1, swept pages: 7631 
    Empty pages: 2517, full pages: 18933 
    Fill distribution: 
     0 - 19% = 4364 
    20 - 39% = 2100 
    40 - 59% = 1898 
    60 - 79% = 10970 
    80 - 99% = 9483 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2185, nodes: 1621874 
    Average node length: 5.52, total dup: 1555827, max dup: 99 
    Average key length: 2.56, compression ratio: 16.39 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 112330, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 570 
        40 - 59% = 1027 
        60 - 79% = 466 
        80 - 99% = 115 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 40.48, total records: 1069297 
    Average version length: 69.13, total versions: 442130, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.11 
    Pointer pages: 21, data page slots: 33992 
    Data pages: 28312, average fill: 44% 
    Primary pages: 28312, secondary pages: 0, swept pages: 5888 
    Empty pages: 5396, full pages: 10464 
    Fill distribution: 
     0 - 19% = 9521 
    20 - 39% = 4538 
    40 - 59% = 2604 
    60 - 79% = 4418 
    80 - 99% = 7231 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1588, nodes: 1069297 
    Average node length: 5.81, total dup: 996396, max dup: 116 
    Average key length: 2.88, compression ratio: 14.58 
    Average prefix length: 41.19, average data length: 0.81 
    Clustering factor: 150995, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 494 
        40 - 59% = 742 
        60 - 79% = 292 
        80 - 99% = 57 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.16, total records: 8983932 
    Average version length: 68.98, total versions: 485545, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 89, data page slots: 144728 
    Data pages: 144712, average fill: 67% 
    Primary pages: 144712, secondary pages: 0, swept pages: 55427 
    Empty pages: 523, full pages: 77145 
    Fill distribution: 
     0 - 19% = 1841 
    20 - 39% = 10294 
    40 - 59% = 26922 
    60 - 79% = 98384 
    80 - 99% = 7271 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13433, nodes: 8983932 
    Average node length: 6.69, total dup: 7450622, max dup: 21 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1946629, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1397 
        40 - 59% = 7183 
        60 - 79% = 4382 
        80 - 99% = 470 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21124400 
    Average version length: 83.00, total versions: 12099, 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: 318280 
    Data pages: 318280, average fill: 81% 
    Primary pages: 318280, secondary pages: 0, swept pages: 11635 
    Empty pages: 10, full pages: 317877 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 20 
    40 - 59% = 66 
    60 - 79% = 26981 
    80 - 99% = 291198 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19414, nodes: 21124400 
    Average node length: 5.72, total dup: 20643992, max dup: 138 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280584, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 3 
        40 - 59% = 8250 
        60 - 79% = 541 
        80 - 99% = 10613 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17169, nodes: 21124400 
    Average node length: 6.31, total dup: 18564403, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916758, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 4 
        40 - 59% = 804 
        60 - 79% = 301 
        80 - 99% = 16056 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21216, nodes: 21124400 
    Average node length: 6.35, total dup: 18483330, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573970, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2 
        40 - 59% = 8582 
        60 - 79% = 558 
        80 - 99% = 12067 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16156, nodes: 21124400 
    Average node length: 5.56, total dup: 21124300, max dup: 227242 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945115, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 19 
        40 - 59% = 2995 
        60 - 79% = 423 
        80 - 99% = 12718 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.21, total records: 9312371 
    Average version length: 82.64, total versions: 359506, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 105, data page slots: 171128 
    Data pages: 171088, average fill: 67% 
    Primary pages: 171088, secondary pages: 0, swept pages: 84575 
    Empty pages: 778, full pages: 86385 
    Fill distribution: 
     0 - 19% = 2610 
    20 - 39% = 11866 
    40 - 59% = 32966 
    60 - 79% = 70324 
    80 - 99% = 53322 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11353, nodes: 9312371 
    Average node length: 5.38, total dup: 9007362, max dup: 178 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2053909, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 184 
        40 - 59% = 9116 
        60 - 79% = 2027 
        80 - 99% = 24 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13223, nodes: 9312371 
    Average node length: 6.24, total dup: 7719025, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1419228, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 4173 
        40 - 59% = 4164 
        60 - 79% = 2552 
        80 - 99% = 2221 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12668, nodes: 9312371 
    Average node length: 5.99, total dup: 8072339, max dup: 37 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2235718, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 202 
        40 - 59% = 10121 
        60 - 79% = 2307 
        80 - 99% = 34 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9928, nodes: 9312371 
    Average node length: 5.14, total dup: 9312271, max dup: 141867 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1463398, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1391 
        40 - 59% = 5027 
        60 - 79% = 1578 
        80 - 99% = 1898 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.21, total records: 11009825 
    Average version length: 82.55, total versions: 277629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 118, data page slots: 191992 
    Data pages: 190592, average fill: 71% 
    Primary pages: 190592, secondary pages: 0, swept pages: 79715 
    Empty pages: 3838, full pages: 133746 
    Fill distribution: 
     0 - 19% = 6736 
    20 - 39% = 9703 
    40 - 59% = 21042 
    60 - 79% = 44420 
    80 - 99% = 108691 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13118, nodes: 11009825 
    Average node length: 5.30, total dup: 10900452, max dup: 628 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2295120, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 182 
        40 - 59% = 9909 
        60 - 79% = 2946 
        80 - 99% = 80 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10286, nodes: 11009825 
    Average node length: 5.50, total dup: 10527415, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 694717, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 913 
        40 - 59% = 2532 
        60 - 79% = 1866 
        80 - 99% = 4799 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14999, nodes: 11009825 
    Average node length: 6.03, total dup: 9598756, max dup: 65 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2311460, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 228 
        40 - 59% = 11487 
        60 - 79% = 3198 
        80 - 99% = 86 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10537, nodes: 11009825 
    Average node length: 5.22, total dup: 11009725, max dup: 172400 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 683909, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 910 
        40 - 59% = 4597 
        60 - 79% = 1495 
        80 - 99% = 3443 
 
XQS_2000_3300 (185) 
    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 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, 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: 1361755, 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: 1361754, 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: 1361752, 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: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.82, total records: 9397535 
    Average version length: 82.91, total versions: 330260, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 108, data page slots: 175208 
    Data pages: 175152, average fill: 67% 
    Primary pages: 175152, secondary pages: 0, swept pages: 92863 
    Empty pages: 771, full pages: 82761 
    Fill distribution: 
     0 - 19% = 2707 
    20 - 39% = 12821 
    40 - 59% = 36222 
    60 - 79% = 73062 
    80 - 99% = 50340 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11502, nodes: 9397535 
    Average node length: 5.19, total dup: 9369241, max dup: 2194 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1859633, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1595 
        40 - 59% = 7585 
        60 - 79% = 1722 
        80 - 99% = 567 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13345, nodes: 9397535 
    Average node length: 6.26, total dup: 7789448, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1371561, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 161 
        20 - 39% = 4172 
        40 - 59% = 4103 
        60 - 79% = 2570 
        80 - 99% = 2339 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12146, nodes: 9397535 
    Average node length: 5.45, total dup: 8973519, max dup: 101 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 1986989, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1494 
        40 - 59% = 8562 
        60 - 79% = 1559 
        80 - 99% = 497 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10014, nodes: 9397535 
    Average node length: 5.16, total dup: 9397435, max dup: 143654 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1474658, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1357 
        40 - 59% = 5053 
        60 - 79% = 1618 
        80 - 99% = 1939 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.65, total records: 573299 
    Average version length: 68.75, total versions: 4411, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 75% 
    Primary pages: 8000, secondary pages: 0, swept pages: 3997 
    Empty pages: 2, full pages: 6604 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 37 
    40 - 59% = 272 
    60 - 79% = 7633 
    80 - 99% = 52 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 49390, depth: 3, leaf buckets: 735, nodes: 573299 
    Average node length: 5.95, total dup: 487931, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99769, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 25 
        40 - 59% = 530 
        60 - 79% = 92 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 38236, depth: 3, leaf buckets: 752, nodes: 573299 
    Average node length: 6.15, total dup: 470002, max dup: 27 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99813, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 534 
        60 - 79% = 80 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 584, nodes: 573299 
    Average node length: 4.86, total dup: 573199, max dup: 9945 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88664, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 41 
        40 - 59% = 350 
        60 - 79% = 85 
        80 - 99% = 108 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    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: 535, Index root page: 536 
    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: 539, Index root page: 540 
    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: 545, Index root page: 546 
    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: 1504207, 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: 547, Index root page: 548 
    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: 1504206, 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: 541, Index root page: 542 
    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: 1504212, 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: 1504213, 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: 543, Index root page: 544 
    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: 1504209, 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: 1504208, 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: 1504211, 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: 1504210, 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: 533, Index root page: 534 
    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: 531, Index root page: 532 
    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: 484, Index root page: 485 
    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: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar 26 16:11:45 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7698849 87452 1 0.0000 0.0000
DOC_LIST 2214289 88119 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 221804 580 55400.0000 0.0000
INVNT_TURNOVER_LOG 77157 75635 1 0.0000 0.0000
MONEY_SALDO 49 17192 943 35000.0000 0.0000
MONEY_TURNOVER_LOG 1369 1269 1 0.0000 0.0000
PDISTR 829939 66887 4 0.0000 0.0000
PERF_SPLIT_0 183819 26195 1 0.0000 0.0000
PERF_SPLIT_1 189254 5114 1 0.0000 0.0000
PERF_SPLIT_2 157060 5078 1 0.0000 0.0000
PERF_SPLIT_3 174952 4865 1 0.0000 0.0000
PERF_SPLIT_4 160737 5489 1 0.0000 0.0000
PERF_SPLIT_5 169190 5483 1 0.0000 0.0000
PERF_SPLIT_6 197332 26857 1 0.0000 0.0000
PERF_SPLIT_7 161080 3686 1 0.0000 0.0000
PERF_SPLIT_8 185853 27793 1 0.0000 0.0000
PERF_SPLIT_9 175775 4827 1 0.0000 0.0000
PSTORNED 2067614 31143 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 133936 55695 1 0.0000 0.0000
XQD_1000_3300 7314659 374860 1 0.0000 0.0000
XQD_1200_2000 12271996 317109 1 0.0000 0.0000
XQD_2000_3300 1621874 584120 1 0.0000 0.0000
XQD_2100_3300 1069297 442130 1 0.0000 0.0000
XQD_3300_3400 8983932 485545 1 0.0000 0.0000
XQS_1000_1200 21124400 12099 1 0.0000 0.0000
XQS_1000_3300 9312371 359506 1 0.0000 0.0000
XQS_1200_2000 11009825 277629 1 0.0000 0.0000
XQS_2100_3300 9397535 330260 1 0.0000 0.0000
XQS_3300_3400 573299 4411 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 ---
:362: 
:363: mscs-test-161.budzdorov.ru    Tue Mar 26 16:09:45 2024
:364:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:365: 
:366: 
:367: mscs-test-161.budzdorov.ru    Tue Mar 26 16:09:45 2024
:368:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:369: 
:370: 
:371: mscs-test-161.budzdorov.ru    Tue Mar 26 16:09:45 2024
:372:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:373: 
--- end of diff output ---

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

26.03.24 16:11:56. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
            0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
    335544321 'string truncation'. Attempt to assign too long text into string variable.
    335544347 'not_valid'. Validation error for column.
    335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
    335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
    335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
    335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
    335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2024-03-26 16:11:59 No severe PSQL-related problems occured
26.03.24 16:12:00. End of report.