Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.04.2024 04:09
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 15387440 kB
MemAvailable 30037632 kB
Buffers 20 kB
Cached 16300404 kB
SwapCached 2752 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-13 04:07:49
DTS_END                         2024-04-13 04:07:49.8650
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/58094
TRN_ID                          169524
ATT_ID                          501
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: 9267.18 22276 926718
customer order: creation 171.85 445 17185
customer order: refuse 15.40 401 1540
order to supplier: creation 45.81 1357 4581
order to supplier: removal 3.39 100238 339
invoice (draft): creation 45.05 3284 4505
invoice (draft): removal 50.04 730 5004
invoice accept: apply 41.82 22588 4182
invoice accept: cancel 45.44 927 4544
customer reserve: creation 4063.45 214 406345
customer reserve: removal 4486.09 61 448609
realization accept: apply 82.54 199 8254
realization accept: cancel 89.15 140 8915
payment from customer: creation 58.46 135 5846
payment from customer: removal 5.72 92 572
payment to supplier: creation 48.47 178 4847
payment to supplier: removal 3.46 126 346
service: total inventory turnovers 3.83 3908 383
service: total monetary turnovers 6.40 642 640
service: aggregate perf. data 0.78 18471 78
service: refresh index statistics 0.03 291386 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-04-2024 04:09:36 to 13-04-2024 04:09:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3574
TEST_TIME 2 3745
TEST_TIME 3 3835
TEST_TIME 4 3437
TEST_TIME 5 3776
TEST_TIME 6 4571
TEST_TIME 7 4603
TEST_TIME 8 5051
TEST_TIME 9 5075
TEST_TIME 10 5970
TEST_TIME 11 6258
TEST_TIME 12 6440
TEST_TIME 13 7040
TEST_TIME 14 7142
TEST_TIME 15 7490
TEST_TIME 16 7359
TEST_TIME 17 7459
TEST_TIME 18 7695
TEST_TIME 19 7646
TEST_TIME 20 7754
TEST_TIME 21 8033
TEST_TIME 22 8074
TEST_TIME 23 8341
TEST_TIME 24 9118
TEST_TIME 25 8933
TEST_TIME 26 9223
TEST_TIME 27 9350
TEST_TIME 28 10115
TEST_TIME 29 9920
TEST_TIME 30 10314
TEST_TIME 31 10322
TEST_TIME 32 10301
TEST_TIME 33 10268
TEST_TIME 34 10134
TEST_TIME 35 9896
TEST_TIME 36 9750
TEST_TIME 37 9633
TEST_TIME 38 9639
TEST_TIME 39 9681
TEST_TIME 40 9619
TEST_TIME 41 9632
TEST_TIME 42 9706
TEST_TIME 43 9619
TEST_TIME 44 9525
TEST_TIME 45 9417
TEST_TIME 46 9376
TEST_TIME 47 9320
TEST_TIME 48 9458
TEST_TIME 49 9424
TEST_TIME 50 9478
TEST_TIME 51 9440
TEST_TIME 52 9473
TEST_TIME 53 9461
TEST_TIME 54 9499
TEST_TIME 55 9618
TEST_TIME 56 9618
TEST_TIME 57 9673
TEST_TIME 58 9584
TEST_TIME 59 9481
TEST_TIME 60 9422
TEST_TIME 61 9402
TEST_TIME 62 9350
TEST_TIME 63 9250
TEST_TIME 64 9199
TEST_TIME 65 9212
TEST_TIME 66 9212
TEST_TIME 67 9257
TEST_TIME 68 9225
TEST_TIME 69 9274
TEST_TIME 70 9221
TEST_TIME 71 9387
TEST_TIME 72 9405
TEST_TIME 73 9345
TEST_TIME 74 9531
TEST_TIME 75 9522
TEST_TIME 76 9495
TEST_TIME 77 9513
TEST_TIME 78 9394
TEST_TIME 79 9369
TEST_TIME 80 9339
TEST_TIME 81 9298
TEST_TIME 82 9274
TEST_TIME 83 9224
TEST_TIME 84 9238
TEST_TIME 85 9266
TEST_TIME 86 9234
TEST_TIME 87 9273
TEST_TIME 88 9312
TEST_TIME 89 9363
TEST_TIME 90 9339
TEST_TIME 91 9380
TEST_TIME 92 9344
TEST_TIME 93 9413
TEST_TIME 94 9421
TEST_TIME 95 9373
TEST_TIME 96 9312
TEST_TIME 97 9286
TEST_TIME 98 9297
TEST_TIME 99 9265
TEST_TIME 100 9272

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-04-2024 04:09:40 to 13-04-2024 04:09:43.

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 1297940 1297940 0 0.00 0 25802 8 0 0
doc_list_biud 1297937 1297937 0 0.00 0 26962 27 0 0
sp_add_invoice_to_stock 4289 4182 107 2.49 34 221537 22588 0 107
sp_cancel_adding_invoice 4544 4544 0 0.00 4 68910 927 0 0
sp_cancel_client_order 1540 1540 0 0.00 4 12041 401 0 0
sp_cancel_customer_reserve 448609 448609 0 0.00 0 26964 61 0 0
sp_cancel_pay_from_customer 572 572 0 0.00 3 11640 93 0 0
sp_cancel_pay_to_supplier 346 346 0 0.00 2 7518 127 0 0
sp_cancel_supplier_invoice 5008 5004 4 0.07 1 20607 730 0 4
sp_cancel_supplier_order 339 339 0 0.00 4 817453 100238 0 0
sp_cancel_write_off 8915 8915 0 0.00 1 22917 141 0 0
sp_client_order 17185 17185 0 0.00 3 26991 446 0 0
sp_customer_reserve 406345 406345 0 0.00 0 45768 214 0 0
sp_fill_shopping_cart 26265 26265 0 0.00 1 14314 35 0 0
sp_fill_shopping_cart_clo_res 406339 406339 0 0.00 0 23603 18 0 0
sp_get_clo_for_invoice 4175 4175 0 0.00 0 29785 386 0 0
sp_kill_cost_storno 14377 14377 0 0.00 0 20439 72 0 0
sp_kill_qstorno_ret_qs2qd 911476 911476 0 0.00 0 26961 33 0 0
sp_kill_qty_storno 481379 481379 0 0.00 0 26961 71 0 0
sp_lock_selected_doc 17426 17426 0 0.00 0 7185 5 0 0
sp_make_cost_storno 23122 23122 0 0.00 0 18068 67 0 0
sp_multiply_rows_for_pdistr 23121 23121 0 0.00 0 20061 39 0 0
sp_multiply_rows_for_qdistr 17185 17185 0 0.00 0 17514 215 0 0
sp_pay_from_customer 5846 5846 0 0.00 4 16574 135 0 0
sp_pay_to_supplier 4847 4847 0 0.00 4 20186 179 0 0
sp_payment_common 10692 10692 0 0.00 1 9943 24 0 0
sp_qd_handle_on_cancel_clo 1540 1540 0 0.00 0 12032 374 0 0
sp_qd_handle_on_invoice_upd_sts 8719 8719 0 0.00 0 26358 338 0 0
sp_qd_handle_on_reserve_upd_sts 8253 8253 0 0.00 0 13697 59 0 0
sp_reserve_write_off 8254 8254 0 0.00 6 19332 200 0 0
sp_supplier_invoice 4505 4505 0 0.00 5 78062 3284 0 0
sp_supplier_order 4581 4581 0 0.00 5 23637 1358 0 0
srv_aggregate_perf_data 78 78 0 0.00 1819 119885 18472 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1640 95131 41009 0 0
srv_find_qd_qs_mism 883857 883857 0 0.00 0 25793 7 0 0
srv_make_invnt_saldo 383 383 0 0.00 55 110722 3909 0 0
srv_make_money_saldo 640 640 0 0.00 1 15036 643 0 0
srv_recalc_idx_stat 3 3 0 0.00 208682 447634 291386 0 0
t$perf-abend:sp_add_invoice_to_stock 107 107 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4182 4182 0 0.00 0 10393 183 0 0
t$perf-norm:sp_cancel_adding_invoice 369 369 0 0.00 0 3524 112 0 0
t$perf-norm:sp_cancel_client_order 1540 1540 0 0.00 0 1759 10 0 0
t$perf-norm:sp_cancel_customer_reserve 622 622 0 0.00 0 540 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 572 572 0 0.00 0 4171 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 346 346 0 0.00 0 499 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 380 380 0 0.00 0 883 13 0 0
t$perf-norm:sp_cancel_supplier_order 339 339 0 0.00 0 21560 1556 0 0
t$perf-norm:sp_cancel_write_off 830 830 0 0.00 0 3837 11 0 0
t$perf-norm:sp_client_order 17185 17185 0 0.00 0 6688 16 0 0
t$perf-norm:sp_customer_reserve 869 869 0 0.00 0 444 3 0 0
t$perf-norm:sp_pay_from_customer 5846 5846 0 0.00 0 7713 11 0 0
t$perf-norm:sp_pay_to_supplier 4847 4847 0 0.00 0 6185 12 0 0
t$perf-norm:sp_reserve_write_off 8254 8254 0 0.00 0 4658 8 0 0
t$perf-norm:sp_supplier_invoice 4505 4505 0 0.00 0 7802 17 0 0
t$perf-norm:sp_supplier_order 4581 4581 0 0.00 0 1841 13 0 0
t$perf-norm:srv_aggregate_perf_data 78 78 0 0.00 0 152 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 479 9 0 0
t$perf-norm:srv_make_invnt_saldo 383 383 0 0.00 0 2865 20 0 0
t$perf-norm:srv_make_money_saldo 640 640 0 0.00 0 3283 12 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8562 8348 214 2.49 0 11303 20 0 214
v_all_customers 32324 32324 0 0.00 0 63 1 0 0
v_all_suppliers 25754 25754 0 0.00 0 63 1 0 0
v_all_wares 34364 34364 0 0.00 0 45 1 0 0
v_cancel_adding_invoice 738 738 0 0.00 0 4756 18 0 0
v_cancel_client_order 3080 3080 0 0.00 0 1878 7 0 0
v_cancel_customer_prepayment 1144 1144 0 0.00 0 11607 16 0 0
v_cancel_customer_reserve 1244 1244 0 0.00 0 2703 11 0 0
v_cancel_payment_to_supplier 692 692 0 0.00 0 1354 11 0 0
v_cancel_supplier_invoice 768 760 8 1.04 0 2353 19 0 8
v_cancel_supplier_order 678 678 0 0.00 0 501 5 0 0
v_cancel_write_off 1660 1660 0 0.00 0 1954 18 0 0
v_max_id_clo_ord 4581 4581 0 0.00 0 774 2 0 0
v_max_id_clo_res 869 869 0 0.00 0 3006 15 0 0
v_max_id_ord_sup 4502 4502 0 0.00 0 4117 5 0 0
v_max_non_paid_invoice 1052 1052 0 0.00 0 476 2 0 0
v_max_non_paid_realizn 2648 2648 0 0.00 0 2182 6 0 0
v_min_id_clo_ord 4581 4581 0 0.00 0 13536 9 0 0
v_min_id_clo_res 869 869 0 0.00 0 5901 14 0 0
v_min_id_ord_sup 4502 4502 0 0.00 0 5876 10 0 0
v_min_non_paid_invoice 4846 4846 0 0.00 0 2684 12 0 0
v_min_non_paid_realizn 5846 5846 0 0.00 0 7951 17 0 0
v_our_firm 8436 8436 0 0.00 0 22 1 0 0
v_reserve_write_off 16506 16506 0 0.00 0 14781 9 0 0
x_lock_depdocs_on_canc_invoice 9168 9168 0 0.00 0 20152 114 0 0
x_lock_depdocs_on_canc_sup_ord 339 339 0 0.00 0 9924 366 0 0
x_make_qstorno_1000_1200 4581 4581 0 0.00 1 23627 1272 0 0
x_make_qstorno_1200_2000 4505 4505 0 0.00 2 78053 3166 0 0
x_make_qstorno_2100_3300 406345 406345 0 0.00 0 40716 194 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-04-2024 04:09:44 to 13-04-2024 04:09:48.

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
02:07:53 7 8192000000 8802886112 8815763456 7824960 0.095 3 1 2 0 7997024 110032 62032
02:08:55 22586 8192000000 9716168976 10012229632 795415872 8.850 100 91 182 0 824102960 7350640 21336448
02:10:38 20900 8192000000 9754752144 10059821056 819268496 9.091 100 92 184 0 852279248 11234032 21776720
02:12:03 10773 8192000000 9775251344 10089447424 847678128 9.377 100 91 182 0 888873600 20521056 20674416
02:13:19 8306 8192000000 9829870816 10162438144 883888272 9.738 100 70 140 0 940622448 41733216 15000960
02:14:31 7909 8192000000 9882400848 10223931392 929215232 10.187 100 74 148 0 988738336 44268128 15254976
02:15:47 4404 8192000000 9930857264 10285420544 973899040 10.625 100 76 151 2 1047685936 59414432 14372464
02:16:54 3077 8192000000 9981189104 10341847040 999883872 10.877 100 86 172 1 1103785344 86644960 17256512
02:18:00 1945 8192000000 9988196736 10354372608 1018947488 11.062 100 88 175 0 1101670384 65988816 16734080
02:19:04 1449 8192000000 10010911552 10382983168 1037477184 11.240 100 90 179 1 1124359520 69400592 17481744
02:20:07 938 8192000000 10014674224 10389524480 1054210256 11.401 100 87 176 1 1127550784 56299312 17041216
02:21:09 8984 8192000000 9982830144 10371035136 1057168816 11.429 100 51 100 1 1094528096 26974384 10384896
02:22:19 8678 8192000000 9974196624 10382770176 1062245584 11.478 100 27 52 0 1084412736 16197216 5969936
02:23:28 5525 8192000000 9981684336 10382565376 1070801632 11.560 100 42 81 1 1102813376 22909664 9102080
02:24:34 46900 8192000000 9990789552 10394537984 1075714784 11.607 100 29 59 1 1107898496 25790912 6392800
02:26:23 7030 8192000000 9995030512 10391564288 1075167792 11.601 99 41 83 0 1113101792 28913840 9020160
02:27:32 8586 8192000000 9988445216 10390994944 1078862448 11.637 100 28 59 1 1107710240 22917648 5930144
02:28:46 42529 8192000000 10017232752 10423832576 1062342624 11.479 97 41 80 2 1106611184 35449456 8819104
02:30:34 78898 8192000000 10076170848 10485436416 1094353936 11.784 99 36 71 1 1182843440 80960128 7529376
02:33:05 18921 8192000000 10125180352 10532376576 1094647696 11.787 99 47 94 1 1220124464 116574720 8902048
02:34:28 16770 8192000000 10131441312 10528428032 1107480064 11.909 100 56 110 0 1229209136 110675616 11053456
02:35:48 20209 8192000000 10129046912 10535137280 1078866064 11.637 98 50 99 1 1228756464 139076496 10813904
02:37:17 56267 8192000000 10107780048 10516566016 1056228480 11.420 96 36 72 0 1217444096 153574512 7641104
02:39:20 8886 8192000000 10127855824 10510225408 1032569392 11.193 96 65 128 0 1191361680 145262608 13529680
02:40:35 4870 8192000000 10144108544 10534019072 1074358304 11.594 99 68 133 1 1237579120 149404464 13816352
02:41:48 1635 8192000000 10171773872 10564018176 1107350128 11.907 100 74 144 2 1276895008 154279936 15264944
02:42:59 8821 8192000000 10163634112 10574524416 1120724224 12.034 100 51 102 1 1267458224 136161104 10572896
02:44:15 2177 8192000000 10271616352 10661220352 1111806336 11.950 99 83 164 3 1364275488 235292400 17176752
02:45:24 4446 8192000000 10268068448 10667134976 1128149984 12.104 100 69 138 1 1369329104 226027712 15151408
02:46:33 3342 8192000000 10310164848 10706735104 1139328288 12.209 100 84 168 0 1406145600 249352352 17464960
02:47:42 2448 8192000000 10338839648 10736984064 1143186784 12.245 100 84 168 0 1444912352 283466112 18259456
02:48:49 2063 8192000000 10380480176 10790686720 1159120064 12.395 100 84 165 1 1471481760 293745248 18616448
02:49:56 4991 8192000000 10389834832 10822324224 1156487728 12.370 100 49 96 0 1492531184 324205040 11838416
02:51:09 11716 8192000000 10300195408 10785087488 1155087872 12.357 100 28 56 0 1432441120 270113888 7239360
02:52:24 7393 8192000000 10304356320 10726457344 1155633808 12.362 100 52 101 0 1387515616 221234448 10647360
02:53:38 39940 8192000000 10259149344 10747637760 1153528304 12.343 100 18 36 0 1393392736 235674928 4189504
02:55:19 38248 8192000000 10080305056 10607198208 1132958880 12.149 100 9 18 0 1222694560 87763504 1972176
02:57:01 39978 8192000000 10153375280 10635063296 1113193344 11.963 98 18 37 0 1224249040 106947136 4108560
02:58:43 41610 8192000000 10073934160 10497101824 1125625776 12.080 99 56 113 0 1163787200 25590224 12571200
03:00:27 62564 8192000000 10104628992 10559700992 1127743056 12.100 99 24 48 0 1186605008 53684912 5177040
03:02:32 94311 8192000000 10175223264 10630316032 1146416512 12.276 100 39 78 0 1251603248 96599408 8587328
03:05:17 65777 8192000000 10132043600 10591789056 1144619184 12.259 100 27 54 0 1242714976 92463808 5631984
03:07:24 50409 8192000000 10156015760 10633478144 1137737552 12.194 99 35 68 2 1230315600 85667904 6910144
03:09:20 61291 8192000000 10070862192 10560389120 1143022448 12.244 100 13 26 0 1194508496 48780064 2705984
03:11:22 31991 8192000000 10070239472 10549682176 1149784928 12.307 100 8 16 0 1197833008 46566400 1481680
03:13:52 47694 8192000000 10116973600 10555846656 1136052848 12.178 99 16 30 0 1191727424 52733184 2941392
03:15:41 67148 8192000000 10087475968 10548150272 1089091856 11.734 95 21 42 0 1136967456 43293744 4581856
03:17:52 15764 8192000000 10062936688 10497929216 1119570576 12.023 99 36 72 2 1153672320 27355376 6746368
03:19:10 29923 8192000000 10063800400 10519961600 1072092912 11.572 96 34 68 0 1121850144 42896864 6860368
03:20:41 50219 8192000000 10088271296 10539634688 1078437408 11.633 97 26 53 0 1161360416 77466656 5456352
03:22:34 95131 8192000000 10053536368 10499325952 1055692896 11.415 95 24 48 0 1095520448 35133456 4694096
03:25:20 94225 8192000000 10039003888 10480037888 1082526672 11.672 99 30 61 0 1130904032 42523392 5853968
03:28:07 19276 8192000000 10028939536 10494251008 1090451232 11.747 99 10 19 0 1128170256 36038208 1680816
03:29:36 43930 8192000000 10012816016 10478411776 1067949504 11.532 97 7 14 0 1104667984 35214688 1503792
03:31:20 63349 8192000000 10044840400 10490310656 1083280368 11.679 99 19 38 0 1127179232 40146960 3751904
03:33:25 34786 8192000000 10050226368 10504142848 1090449056 11.747 99 33 66 1 1148336752 51406896 6480800
03:35:00 33246 8192000000 10034010768 10452439040 1075989200 11.609 98 26 52 0 1115058192 34117280 4951712
03:36:33 76293 8192000000 10093203136 10512293888 1078884256 11.637 97 27 54 0 1158307664 74349792 5073616
03:38:50 66380 8192000000 10096598256 10560835584 1091202912 11.754 98 11 21 0 1133303120 40391664 1708544
03:40:57 54546 8192000000 10057660608 10553995264 1106316384 11.898 99 13 26 0 1209005648 99897040 2792224
03:42:55 34261 8192000000 10090072560 10512642048 1116875712 11.997 99 39 78 0 1163770272 39397456 7497104
03:45:25 80107 8192000000 10071604368 10518532096 1122007072 12.046 99 34 66 0 1164719072 36612608 6099392
03:47:47 38913 8192000000 10056952016 10511646720 1134583136 12.165 100 10 20 0 1172470160 35559600 2327424
03:49:26 59213 8192000000 10087942384 10566447104 1142661936 12.241 100 10 20 0 1191165920 46638128 1865856
03:51:26 44090 8192000000 10099053136 10568978432 1131269360 12.133 99 20 40 0 1228337808 93028048 4040400
03:53:12 30771 8192000000 10107028768 10544373760 1124790336 12.072 98 24 48 0 1190671056 60780960 5099760
03:54:45 67698 8192000000 10096243968 10577829888 1108117984 11.915 97 17 34 0 1190016192 78416848 3481360
03:56:54 33887 8192000000 10079935296 10524700672 1109544160 11.928 98 26 52 0 1158634544 43705328 5385056
03:58:33 64766 8192000000 10092646416 10539585536 1103043440 11.867 97 22 44 1 1154563776 47352832 4167504
04:00:39 74051 8192000000 10072968848 10525298688 1099044496 11.829 98 28 57 0 1171869408 67510704 5314208
04:03:22 69783 8192000000 10065122544 10495987712 1119300032 12.020 99 28 57 0 1198967840 73630512 6037296
04:05:33 67186 8192000000 10099760720 10612748288 1133069232 12.150 100 6 12 1 1211712576 77476992 1166352
04:07:41 17345 8192000000 9486045712 9902845952 598488880 6.808 53 3 6 0 630653408 31821584 342944

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 13-04-2024 04:09:50 to 13-04-2024 04:10:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 107 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-04-2024 04:10:05 to 13-04-2024 04:10:07.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          169698
MON$OLDEST_ACTIVE               170412
MON$OLDEST_SNAPSHOT             170412
MON$NEXT_TRANSACTION            170412
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1919328
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             687
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sat Apr 13 04:10:08 2024 
 
Database header page information: 
    Flags            0 
    Generation        89038 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    169698 
    Oldest active        170412 
    Oldest snapshot        170412 
    Next transaction    170413 
    Sequence number        0 
    Next attachment ID    687 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.51, total records: 7708294 
    Average version length: 48.16, total versions: 75404, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88712 
    Data pages: 88712, average fill: 69% 
    Primary pages: 88711, secondary pages: 1, swept pages: 41183 
    Empty pages: 7, full pages: 64385 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 67 
    40 - 59% = 2200 
    60 - 79% = 86393 
    80 - 99% = 39 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23172, nodes: 7708294 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1672415, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 313 
        20 - 39% = 1952 
        40 - 59% = 3846 
        60 - 79% = 2576 
        80 - 99% = 14485 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13469, nodes: 7708294 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1496708, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1683 
        40 - 59% = 1874 
        60 - 79% = 1175 
        80 - 99% = 8736 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8291, nodes: 7708294 
    Average node length: 6.61, total dup: 5773643, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1489575, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 1026 
        40 - 59% = 1273 
        60 - 79% = 995 
        80 - 99% = 4889 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.57, total records: 2226280 
    Average version length: 58.84, total versions: 39554, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28552 
    Data pages: 28552, average fill: 72% 
    Primary pages: 28550, secondary pages: 2, swept pages: 11626 
    Empty pages: 5, full pages: 16364 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 49 
    40 - 59% = 491 
    60 - 79% = 27935 
    80 - 99% = 54 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4534, nodes: 2226280 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 677808, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 940 
        40 - 59% = 790 
        60 - 79% = 807 
        80 - 99% = 1997 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2396, nodes: 2227321 
    Average node length: 4.97, total dup: 2226422, max dup: 20493 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1264195, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 198 
        40 - 59% = 1374 
        60 - 79% = 578 
        80 - 99% = 246 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1763, nodes: 2226280 
    Average node length: 4.97, total dup: 2226230, max dup: 130005 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1059935, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 11 
        40 - 59% = 609 
        60 - 79% = 44 
        80 - 99% = 1099 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4358, nodes: 2226280 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 677808, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 650 
        40 - 59% = 565 
        60 - 79% = 899 
        80 - 99% = 2139 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.20, total records: 400 
    Average version length: 30.18, total versions: 1589, max versions: 4 
    Average fragment length: 2.00, total fragments: 10, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 59% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 7, full pages: 14 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 25.44, total records: 109652 
    Average version length: 68.28, total versions: 79257, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.46 
    Pointer pages: 7, data page slots: 2576 
    Data pages: 2448, average fill: 58% 
    Primary pages: 2447, secondary pages: 1, swept pages: 0 
    Empty pages: 412, full pages: 1223 
    Fill distribution: 
     0 - 19% = 527 
    20 - 39% = 253 
    40 - 59% = 285 
    60 - 79% = 422 
    80 - 99% = 961 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1706785, depth: 3, leaf buckets: 393, nodes: 109652 
    Average node length: 13.20, total dup: 7821, max dup: 1 
    Average key length: 10.69, compression ratio: 2.53 
    Average prefix length: 19.24, average data length: 7.76 
    Clustering factor: 80209, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 83 
        40 - 59% = 286 
        60 - 79% = 21 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 145, max versions: 5 
    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: 1 
    Data pages: 1, average fill: 66% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 17.41, total records: 1398 
    Average version length: 43.65, total versions: 1073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.33 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 45% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 8 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 1 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91851, depth: 2, leaf buckets: 3, nodes: 1398 
    Average node length: 4.43, total dup: 1301, max dup: 202 
    Average key length: 2.74, compression ratio: 6.93 
    Average prefix length: 18.33, average data length: 0.67 
    Clustering factor: 720, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.67, total records: 73 
    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: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    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: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.63, total records: 821856 
    Average version length: 37.93, total versions: 25165, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8664 
    Data pages: 8664, average fill: 65% 
    Primary pages: 8661, secondary pages: 3, swept pages: 2604 
    Empty pages: 19, full pages: 5962 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 45 
    40 - 59% = 607 
    60 - 79% = 7927 
    80 - 99% = 55 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 865, nodes: 811357 
    Average node length: 4.88, total dup: 811308, max dup: 149293 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91647, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 109 
        40 - 59% = 472 
        60 - 79% = 184 
        80 - 99% = 100 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1000, nodes: 811357 
    Average node length: 5.89, total dup: 722109, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162526, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 626 
        60 - 79% = 118 
        80 - 99% = 212 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1024, nodes: 811357 
    Average node length: 5.89, total dup: 722109, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164432, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 87 
        40 - 59% = 622 
        60 - 79% = 97 
        80 - 99% = 218 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1132, nodes: 811357 
    Average node length: 5.97, total dup: 722109, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157120, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 237 
        40 - 59% = 565 
        60 - 79% = 236 
        80 - 99% = 92 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5424 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.81, total fragments: 37, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 80, secondary pages: 8, swept pages: 59 
    Empty pages: 6, full pages: 64 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5424 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.35, average data length: 1.54 
    Clustering factor: 5040, 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: 1504255, depth: 2, leaf buckets: 10, nodes: 5424 
    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: 156, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 77355 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 803 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 803 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34833, depth: 2, leaf buckets: 99, nodes: 77355 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2984, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 143.68, total records: 182918 
    Average version length: 152.41, total versions: 9693, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.80 
    Pointer pages: 6, data page slots: 6800 
    Data pages: 4624, average fill: 82% 
    Primary pages: 4622, secondary pages: 2, swept pages: 5 
    Empty pages: 109, full pages: 4481 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 11 
    40 - 59% = 11 
    60 - 79% = 9 
    80 - 99% = 4480 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 144.41, total records: 157293 
    Average version length: 151.87, total versions: 7318, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.74 
    Pointer pages: 8, data page slots: 5320 
    Data pages: 3960, average fill: 82% 
    Primary pages: 3957, secondary pages: 3, swept pages: 6 
    Empty pages: 81, full pages: 3848 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 10 
    40 - 59% = 9 
    60 - 79% = 8 
    80 - 99% = 3847 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 127.74, total records: 181087 
    Average version length: 154.63, total versions: 29705, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.28 
    Pointer pages: 9, data page slots: 5968 
    Data pages: 4584, average fill: 84% 
    Primary pages: 4582, secondary pages: 2, swept pages: 1 
    Empty pages: 110, full pages: 4442 
    Fill distribution: 
     0 - 19% = 111 
    20 - 39% = 12 
    40 - 59% = 9 
    60 - 79% = 12 
    80 - 99% = 4440 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 142.16, total records: 165650 
    Average version length: 152.57, total versions: 10256, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 8, data page slots: 5224 
    Data pages: 4160, average fill: 83% 
    Primary pages: 4157, secondary pages: 3, swept pages: 1 
    Empty pages: 87, full pages: 4052 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4053 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 127.62, total records: 187468 
    Average version length: 154.22, total versions: 30837, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.29 
    Pointer pages: 7, data page slots: 6992 
    Data pages: 4752, average fill: 83% 
    Primary pages: 4750, secondary pages: 2, swept pages: 12 
    Empty pages: 121, full pages: 4597 
    Fill distribution: 
     0 - 19% = 125 
    20 - 39% = 16 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 4596 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 139.98, total records: 175342 
    Average version length: 152.96, total versions: 13644, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.12 
    Pointer pages: 5, data page slots: 5640 
    Data pages: 4472, average fill: 82% 
    Primary pages: 4469, secondary pages: 3, swept pages: 1 
    Empty pages: 144, full pages: 4288 
    Fill distribution: 
     0 - 19% = 148 
    20 - 39% = 15 
    40 - 59% = 14 
    60 - 79% = 7 
    80 - 99% = 4288 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 133.89, total records: 180906 
    Average version length: 154.00, total versions: 21876, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.67 
    Pointer pages: 8, data page slots: 5672 
    Data pages: 4512, average fill: 84% 
    Primary pages: 4509, secondary pages: 3, swept pages: 4 
    Empty pages: 54, full pages: 4440 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4440 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 132.32, total records: 175159 
    Average version length: 153.99, total versions: 23302, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.82 
    Pointer pages: 8, data page slots: 5656 
    Data pages: 4376, average fill: 84% 
    Primary pages: 4374, secondary pages: 2, swept pages: 4 
    Empty pages: 55, full pages: 4299 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 9 
    80 - 99% = 4300 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 142.73, total records: 174236 
    Average version length: 151.90, total versions: 10518, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 8, data page slots: 6872 
    Data pages: 4384, average fill: 83% 
    Primary pages: 4382, secondary pages: 2, swept pages: 2 
    Empty pages: 85, full pages: 4268 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 8 
    40 - 59% = 8 
    60 - 79% = 11 
    80 - 99% = 4270 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 109.04, total records: 206134 
    Average version length: 154.82, total versions: 60887, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.55 
    Pointer pages: 8, data page slots: 5576 
    Data pages: 5168, average fill: 86% 
    Primary pages: 5165, secondary pages: 3, swept pages: 3 
    Empty pages: 62, full pages: 5058 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 9 
    40 - 59% = 15 
    60 - 79% = 23 
    80 - 99% = 5058 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.08, total records: 2072490 
    Average version length: 52.96, total versions: 31716, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25704 
    Data pages: 25696, average fill: 69% 
    Primary pages: 25679, secondary pages: 17, swept pages: 12002 
    Empty pages: 183, full pages: 21589 
    Fill distribution: 
     0 - 19% = 400 
    20 - 39% = 353 
    40 - 59% = 1062 
    60 - 79% = 23559 
    80 - 99% = 322 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2566, nodes: 2072490 
    Average node length: 5.44, total dup: 1934178, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180109, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 319 
        40 - 59% = 1647 
        60 - 79% = 306 
        80 - 99% = 292 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2072490 
    Average node length: 5.70, total dup: 1859474, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371319, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2487 
        60 - 79% = 235 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2104, nodes: 2072490 
    Average node length: 4.96, total dup: 2072390, max dup: 28333 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177899, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 198 
        40 - 59% = 1101 
        60 - 79% = 379 
        80 - 99% = 423 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 46.87, total records: 138302 
    Average version length: 69.17, total versions: 51313, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.69 
    Pointer pages: 3, data page slots: 4408 
    Data pages: 3320, average fill: 50% 
    Primary pages: 3320, secondary pages: 0, swept pages: 612 
    Empty pages: 646, full pages: 1100 
    Fill distribution: 
     0 - 19% = 833 
    20 - 39% = 220 
    40 - 59% = 632 
    60 - 79% = 1082 
    80 - 99% = 553 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 357174, depth: 3, leaf buckets: 234, nodes: 138302 
    Average node length: 6.50, total dup: 120331, max dup: 14 
    Average key length: 3.96, compression ratio: 10.60 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 23937, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 67 
        40 - 59% = 126 
        60 - 79% = 38 
        80 - 99% = 3 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.36, total records: 7096634 
    Average version length: 68.76, total versions: 307757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 67, data page slots: 108152 
    Data pages: 108152, average fill: 70% 
    Primary pages: 108151, secondary pages: 1, swept pages: 33581 
    Empty pages: 60, full pages: 65992 
    Fill distribution: 
     0 - 19% = 756 
    20 - 39% = 1648 
    40 - 59% = 6681 
    60 - 79% = 98085 
    80 - 99% = 982 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10759, nodes: 7096634 
    Average node length: 6.51, total dup: 6137623, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1647535, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1629 
        40 - 59% = 5903 
        60 - 79% = 2775 
        80 - 99% = 447 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8605, nodes: 7096634 
    Average node length: 5.40, total dup: 6815218, max dup: 137 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1447957, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1069 
        40 - 59% = 5004 
        60 - 79% = 1579 
        80 - 99% = 946 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8650, nodes: 7096634 
    Average node length: 5.40, total dup: 6815218, max dup: 137 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1450268, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1121 
        40 - 59% = 4984 
        60 - 79% = 1590 
        80 - 99% = 945 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.88, total records: 12112634 
    Average version length: 68.72, total versions: 213515, 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: 108, data page slots: 175096 
    Data pages: 175096, average fill: 73% 
    Primary pages: 175095, secondary pages: 1, swept pages: 74460 
    Empty pages: 5, full pages: 153875 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 301 
    40 - 59% = 4006 
    60 - 79% = 169597 
    80 - 99% = 1171 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18484, nodes: 12110219 
    Average node length: 6.62, total dup: 10556781, max dup: 54 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2479263, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 2276 
        40 - 59% = 10843 
        60 - 79% = 4549 
        80 - 99% = 797 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 48.30, total records: 1441391 
    Average version length: 69.06, total versions: 260113, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.61 
    Pointer pages: 29, data page slots: 45768 
    Data pages: 27568, average fill: 53% 
    Primary pages: 27492, secondary pages: 76, swept pages: 8747 
    Empty pages: 3139, full pages: 15688 
    Fill distribution: 
     0 - 19% = 4991 
    20 - 39% = 4395 
    40 - 59% = 3182 
    60 - 79% = 11906 
    80 - 99% = 3094 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1785, nodes: 1201610 
    Average node length: 5.54, total dup: 1152848, max dup: 49 
    Average key length: 2.58, compression ratio: 16.28 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 82408, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 637 
        40 - 59% = 813 
        60 - 79% = 301 
        80 - 99% = 27 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 40.63, total records: 1175215 
    Average version length: 69.03, total versions: 169609, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.10 
    Pointer pages: 24, data page slots: 38160 
    Data pages: 29696, average fill: 35% 
    Primary pages: 29696, secondary pages: 0, swept pages: 8998 
    Empty pages: 7408, full pages: 8301 
    Fill distribution: 
     0 - 19% = 10819 
    20 - 39% = 4000 
    40 - 59% = 7468 
    60 - 79% = 7118 
    80 - 99% = 291 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1186, nodes: 788927 
    Average node length: 5.97, total dup: 725349, max dup: 73 
    Average key length: 3.03, compression ratio: 13.86 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 116273, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 342 
        40 - 59% = 564 
        60 - 79% = 257 
        80 - 99% = 23 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.30, total records: 9046026 
    Average version length: 68.99, total versions: 387854, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 89, data page slots: 144888 
    Data pages: 144832, average fill: 67% 
    Primary pages: 144810, secondary pages: 22, swept pages: 59084 
    Empty pages: 439, full pages: 68063 
    Fill distribution: 
     0 - 19% = 1361 
    20 - 39% = 6453 
    40 - 59% = 20827 
    60 - 79% = 113929 
    80 - 99% = 2262 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13450, nodes: 9042405 
    Average node length: 6.69, total dup: 7499847, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2052553, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1290 
        40 - 59% = 7161 
        60 - 79% = 4502 
        80 - 99% = 496 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21101989 
    Average version length: 82.55, total versions: 7740, 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: 319088 
    Data pages: 319088, average fill: 81% 
    Primary pages: 319084, secondary pages: 4, swept pages: 13598 
    Empty pages: 43, full pages: 318326 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 37 
    40 - 59% = 96 
    60 - 79% = 48844 
    80 - 99% = 270048 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19030, nodes: 21101989 
    Average node length: 5.72, total dup: 20621915, max dup: 136 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276876, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 7515 
        60 - 79% = 521 
        80 - 99% = 10986 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17128, nodes: 21101989 
    Average node length: 6.31, total dup: 18544958, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916227, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 779 
        60 - 79% = 260 
        80 - 99% = 16083 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20764, nodes: 21101989 
    Average node length: 6.35, total dup: 18463169, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3570034, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 7696 
        60 - 79% = 579 
        80 - 99% = 12482 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16050, nodes: 21101989 
    Average node length: 5.56, total dup: 21101889, max dup: 230448 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944960, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2897 
        60 - 79% = 326 
        80 - 99% = 12820 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.71, total records: 9449562 
    Average version length: 82.62, total versions: 347641, 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: 106, data page slots: 172360 
    Data pages: 172304, average fill: 68% 
    Primary pages: 172263, secondary pages: 41, swept pages: 86600 
    Empty pages: 709, full pages: 92232 
    Fill distribution: 
     0 - 19% = 2197 
    20 - 39% = 9550 
    40 - 59% = 28239 
    60 - 79% = 112666 
    80 - 99% = 19652 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11335, nodes: 9449562 
    Average node length: 5.37, total dup: 9142978, max dup: 231 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2147970, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 90 
        40 - 59% = 8815 
        60 - 79% = 2372 
        80 - 99% = 55 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13414, nodes: 9449562 
    Average node length: 6.23, total dup: 7833452, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1509934, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 3999 
        40 - 59% = 4360 
        60 - 79% = 2724 
        80 - 99% = 2192 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12649, nodes: 9449562 
    Average node length: 5.98, total dup: 8194154, max dup: 44 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2331035, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 96 
        40 - 59% = 9762 
        60 - 79% = 2714 
        80 - 99% = 75 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10001, nodes: 9449562 
    Average node length: 5.13, total dup: 9449462, max dup: 161606 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1540096, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1311 
        40 - 59% = 5022 
        60 - 79% = 1671 
        80 - 99% = 1961 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.47, total records: 11050783 
    Average version length: 82.53, total versions: 274673, 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: 117, data page slots: 190768 
    Data pages: 189400, average fill: 72% 
    Primary pages: 189254, secondary pages: 146, swept pages: 69577 
    Empty pages: 2615, full pages: 141478 
    Fill distribution: 
     0 - 19% = 4633 
    20 - 39% = 7631 
    40 - 59% = 17922 
    60 - 79% = 97012 
    80 - 99% = 62202 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13103, nodes: 11050783 
    Average node length: 5.29, total dup: 10941360, max dup: 638 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2318233, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 184 
        40 - 59% = 9763 
        60 - 79% = 3047 
        80 - 99% = 108 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10243, nodes: 11050783 
    Average node length: 5.49, total dup: 10567354, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 714438, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 169 
        20 - 39% = 858 
        40 - 59% = 2536 
        60 - 79% = 1774 
        80 - 99% = 4906 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14988, nodes: 11050783 
    Average node length: 6.02, total dup: 9636510, max dup: 65 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2334400, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 199 
        40 - 59% = 11367 
        60 - 79% = 3280 
        80 - 99% = 138 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10519, nodes: 11050783 
    Average node length: 5.21, total dup: 11050683, max dup: 210939 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 703244, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 839 
        40 - 59% = 4592 
        60 - 79% = 1545 
        80 - 99% = 3448 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.18, total records: 9545863 
    Average version length: 82.94, total versions: 330568, 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: 108, data page slots: 175768 
    Data pages: 175680, average fill: 67% 
    Primary pages: 175643, secondary pages: 37, swept pages: 90614 
    Empty pages: 724, full pages: 92848 
    Fill distribution: 
     0 - 19% = 2316 
    20 - 39% = 10912 
    40 - 59% = 29788 
    60 - 79% = 113788 
    80 - 99% = 18876 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11624, nodes: 9545863 
    Average node length: 5.18, total dup: 9517180, max dup: 1463 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1961329, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1610 
        40 - 59% = 7633 
        60 - 79% = 1793 
        80 - 99% = 562 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13533, nodes: 9545863 
    Average node length: 6.25, total dup: 7913644, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1481889, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 168 
        20 - 39% = 4095 
        40 - 59% = 4241 
        60 - 79% = 2741 
        80 - 99% = 2288 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12265, nodes: 9545863 
    Average node length: 5.43, total dup: 9114999, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2090216, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1533 
        40 - 59% = 8579 
        60 - 79% = 1604 
        80 - 99% = 522 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10124, nodes: 9545863 
    Average node length: 5.15, total dup: 9545763, max dup: 163940 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1565730, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1282 
        40 - 59% = 5100 
        60 - 79% = 1751 
        80 - 99% = 1944 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.64, total records: 565669 
    Average version length: 68.76, total versions: 4925, 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: 7992 
    Data pages: 7992, average fill: 74% 
    Primary pages: 7992, secondary pages: 0, swept pages: 3682 
    Empty pages: 1, full pages: 6740 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 28 
    40 - 59% = 212 
    60 - 79% = 7676 
    80 - 99% = 72 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45111, depth: 3, leaf buckets: 734, nodes: 565669 
    Average node length: 5.95, total dup: 481443, max dup: 82 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99581, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 34 
        40 - 59% = 531 
        60 - 79% = 83 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33845, depth: 3, leaf buckets: 752, nodes: 565669 
    Average node length: 6.15, total dup: 463877, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99625, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 34 
        40 - 59% = 529 
        60 - 79% = 91 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 559, nodes: 565669 
    Average node length: 4.85, total dup: 565569, max dup: 9688 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88660, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 37 
        40 - 59% = 301 
        60 - 79% = 103 
        80 - 99% = 117 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Apr 13 04:10:32 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7708294 75404 1 0.0000 0.0000
DOC_LIST 2226280 39554 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1589 4 300.0000 0.0000
INVNT_TURNOVER_LOG 109652 79257 1 0.0000 0.0000
MONEY_SALDO 49 145 5 200.0000 0.0000
MONEY_TURNOVER_LOG 1398 1073 1 0.0000 0.0000
PDISTR 821856 25165 2 0.0000 0.0000
PERF_SPLIT_0 182918 9693 1 0.0000 0.0000
PERF_SPLIT_1 157293 7318 1 0.0000 0.0000
PERF_SPLIT_2 181087 29705 1 0.0000 0.0000
PERF_SPLIT_3 165650 10256 1 0.0000 0.0000
PERF_SPLIT_4 187468 30837 1 0.0000 0.0000
PERF_SPLIT_5 175342 13644 1 0.0000 0.0000
PERF_SPLIT_6 180906 21876 1 0.0000 0.0000
PERF_SPLIT_7 175159 23302 1 0.0000 0.0000
PERF_SPLIT_8 174236 10518 1 0.0000 0.0000
PERF_SPLIT_9 206134 60887 1 0.0000 0.0000
PSTORNED 2072490 31716 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 138302 51313 1 0.0000 0.0000
XQD_1000_3300 7096634 307757 1 0.0000 0.0000
XQD_1200_2000 12112634 213515 1 0.0000 0.0000
XQD_2000_3300 1441391 260113 1 0.0000 0.0000
XQD_2100_3300 1175215 169609 1 0.0000 0.0000
XQD_3300_3400 9046026 387854 1 0.0000 0.0000
XQS_1000_1200 21101989 7740 1 0.0000 0.0000
XQS_1000_3300 9449562 347641 1 0.0000 0.0000
XQS_1200_2000 11050783 274673 1 0.0000 0.0000
XQS_2100_3300 9545863 330568 1 0.0000 0.0000
XQS_3300_3400 565669 4925 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

--- start of diff output ---
--- end of diff output ---

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

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