Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 31.03.2024 22:10
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database Statistics, full
  3. Record versions statistics    as table    as chart
  4. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  5. New in firebird.log while test was run
  6. Final processing of ISQL logs

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-31 22:09:46
DTS_END                         2024-03-31 22:09:46.6470
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43066
TRN_ID                          177897
ATT_ID                          586
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: 9092.36 19658 909236
customer order: creation 180.36 349 18036
customer order: refuse 15.64 359 1564
order to supplier: creation 46.48 1353 4648
order to supplier: removal 3.50 94496 350
invoice (draft): creation 47.45 3142 4745
invoice (draft): removal 47.61 850 4761
invoice accept: apply 43.71 19804 4371
invoice accept: cancel 43.07 901 4307
customer reserve: creation 4090.83 193 409083
customer reserve: removal 4275.64 60 427564
realization accept: apply 86.03 196 8603
realization accept: cancel 77.66 130 7766
payment from customer: creation 61.37 115 6137
payment from customer: removal 5.92 111 592
payment to supplier: creation 51.33 144 5133
payment to supplier: removal 3.47 55 347
service: total inventory turnovers 4.72 1096 472
service: total monetary turnovers 6.62 28 662
service: aggregate perf. data 0.92 17146 92
service: refresh index statistics 0.03 252637 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-03-2024 22:11:04 to 31-03-2024 22:11:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2514
TEST_TIME 2 2729
TEST_TIME 3 3493
TEST_TIME 4 3244
TEST_TIME 5 3586
TEST_TIME 6 4008
TEST_TIME 7 4121
TEST_TIME 8 4122
TEST_TIME 9 4857
TEST_TIME 10 5220
TEST_TIME 11 5469
TEST_TIME 12 5622
TEST_TIME 13 5708
TEST_TIME 14 5836
TEST_TIME 15 6003
TEST_TIME 16 6089
TEST_TIME 17 6591
TEST_TIME 18 6740
TEST_TIME 19 7291
TEST_TIME 20 7797
TEST_TIME 21 7920
TEST_TIME 22 7918
TEST_TIME 23 8043
TEST_TIME 24 8033
TEST_TIME 25 8358
TEST_TIME 26 8403
TEST_TIME 27 9005
TEST_TIME 28 9646
TEST_TIME 29 9502
TEST_TIME 30 9407
TEST_TIME 31 9183
TEST_TIME 32 8929
TEST_TIME 33 9008
TEST_TIME 34 9135
TEST_TIME 35 9187
TEST_TIME 36 9083
TEST_TIME 37 9124
TEST_TIME 38 8995
TEST_TIME 39 8928
TEST_TIME 40 8801
TEST_TIME 41 9014
TEST_TIME 42 9013
TEST_TIME 43 8878
TEST_TIME 44 9078
TEST_TIME 45 8994
TEST_TIME 46 8921
TEST_TIME 47 8926
TEST_TIME 48 8867
TEST_TIME 49 8899
TEST_TIME 50 8812
TEST_TIME 51 8774
TEST_TIME 52 8770
TEST_TIME 53 8706
TEST_TIME 54 8729
TEST_TIME 55 8793
TEST_TIME 56 8750
TEST_TIME 57 8799
TEST_TIME 58 8900
TEST_TIME 59 8861
TEST_TIME 60 8975
TEST_TIME 61 8939
TEST_TIME 62 8995
TEST_TIME 63 9055
TEST_TIME 64 9109
TEST_TIME 65 9128
TEST_TIME 66 9137
TEST_TIME 67 9045
TEST_TIME 68 9054
TEST_TIME 69 8960
TEST_TIME 70 8990
TEST_TIME 71 8898
TEST_TIME 72 8970
TEST_TIME 73 8962
TEST_TIME 74 9032
TEST_TIME 75 9070
TEST_TIME 76 9037
TEST_TIME 77 9058
TEST_TIME 78 9070
TEST_TIME 79 9081
TEST_TIME 80 9128
TEST_TIME 81 9225
TEST_TIME 82 9221
TEST_TIME 83 9249
TEST_TIME 84 9257
TEST_TIME 85 9274
TEST_TIME 86 9271
TEST_TIME 87 9312
TEST_TIME 88 9218
TEST_TIME 89 9186
TEST_TIME 90 9216
TEST_TIME 91 9178
TEST_TIME 92 9180
TEST_TIME 93 9155
TEST_TIME 94 9120
TEST_TIME 95 9080
TEST_TIME 96 9049
TEST_TIME 97 9099
TEST_TIME 98 9089
TEST_TIME 99 9076
TEST_TIME 100 9103

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 31-03-2024 22:11:08 to 31-03-2024 22:11:11.

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 1284333 1284333 0 0.00 0 30209 7 0 0
doc_list_biud 1284333 1284333 0 0.00 0 41970 26 0 0
sp_add_invoice_to_stock 4508 4371 137 3.03 27 225346 19804 0 137
sp_cancel_adding_invoice 4307 4307 0 0.00 5 69945 901 0 0
sp_cancel_client_order 1564 1564 0 0.00 4 16826 359 0 0
sp_cancel_customer_reserve 427564 427564 0 0.00 0 41974 61 0 0
sp_cancel_pay_from_customer 592 592 0 0.00 2 6157 111 0 0
sp_cancel_pay_to_supplier 347 347 0 0.00 3 2050 55 0 0
sp_cancel_supplier_invoice 4772 4761 11 0.23 2 39274 851 0 11
sp_cancel_supplier_order 350 350 0 0.00 8 886573 94497 0 0
sp_cancel_write_off 7766 7766 0 0.00 1 22512 130 0 0
sp_client_order 18036 18036 0 0.00 3 22517 350 0 0
sp_customer_reserve 409083 409083 0 0.00 0 53489 194 0 0
sp_fill_shopping_cart 27427 27427 0 0.00 1 17603 37 0 0
sp_fill_shopping_cart_clo_res 409073 409073 0 0.00 0 20641 17 0 0
sp_get_clo_for_invoice 4358 4358 0 0.00 0 38460 356 0 0
sp_kill_cost_storno 13012 13012 0 0.00 0 13195 68 0 0
sp_kill_qstorno_ret_qs2qd 868005 868005 0 0.00 0 41781 33 0 0
sp_kill_qty_storno 459273 459273 0 0.00 0 41970 72 0 0
sp_lock_selected_doc 17970 17970 0 0.00 0 8278 5 0 0
sp_make_cost_storno 24231 24231 0 0.00 0 30193 64 0 0
sp_multiply_rows_for_pdistr 24231 24231 0 0.00 0 10798 32 0 0
sp_multiply_rows_for_qdistr 18036 18036 0 0.00 0 22050 169 0 0
sp_pay_from_customer 6137 6137 0 0.00 4 10815 115 0 0
sp_pay_to_supplier 5133 5133 0 0.00 5 10848 145 0 0
sp_payment_common 11270 11270 0 0.00 1 9813 31 0 0
sp_qd_handle_on_cancel_clo 1564 1564 0 0.00 0 16816 335 0 0
sp_qd_handle_on_invoice_upd_sts 8665 8665 0 0.00 0 24616 344 0 0
sp_qd_handle_on_reserve_upd_sts 8603 8603 0 0.00 0 14944 64 0 0
sp_reserve_write_off 8603 8603 0 0.00 6 18065 196 0 0
sp_supplier_invoice 4745 4745 0 0.00 5 56332 3142 0 0
sp_supplier_order 4648 4648 0 0.00 5 32205 1353 0 0
srv_aggregate_perf_data 92 92 0 0.00 1914 304609 17146 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 925 106821 42178 0 0
srv_find_qd_qs_mism 865702 865702 0 0.00 0 22399 6 0 0
srv_make_invnt_saldo 472 472 0 0.00 30 30973 1096 0 0
srv_make_money_saldo 662 662 0 0.00 0 913 28 0 0
srv_recalc_idx_stat 3 3 0 0.00 157989 324748 252638 0 0
t$perf-abend:sp_add_invoice_to_stock 137 137 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4371 4371 0 0.00 0 8505 190 0 0
t$perf-norm:sp_cancel_adding_invoice 353 353 0 0.00 0 5147 152 0 0
t$perf-norm:sp_cancel_client_order 1564 1564 0 0.00 0 3911 16 0 0
t$perf-norm:sp_cancel_customer_reserve 579 579 0 0.00 0 2819 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 592 592 0 0.00 0 345 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 347 347 0 0.00 0 2268 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 330 330 0 0.00 0 1469 19 0 0
t$perf-norm:sp_cancel_supplier_order 350 350 0 0.00 0 24254 1699 0 0
t$perf-norm:sp_cancel_write_off 895 895 0 0.00 0 4094 16 0 0
t$perf-norm:sp_client_order 18036 18036 0 0.00 0 12645 19 0 0
t$perf-norm:sp_customer_reserve 904 904 0 0.00 0 1986 7 0 0
t$perf-norm:sp_pay_from_customer 6137 6137 0 0.00 0 4047 10 0 0
t$perf-norm:sp_pay_to_supplier 5133 5133 0 0.00 0 3326 9 0 0
t$perf-norm:sp_reserve_write_off 8603 8603 0 0.00 0 5687 13 0 0
t$perf-norm:sp_supplier_invoice 4745 4745 0 0.00 0 3345 20 0 0
t$perf-norm:sp_supplier_order 4648 4648 0 0.00 0 9110 19 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 1011 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 541 22 0 0
t$perf-norm:srv_make_invnt_saldo 472 472 0 0.00 0 2805 33 0 0
t$perf-norm:srv_make_money_saldo 662 662 0 0.00 0 1491 12 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 49 17 0 0
v_add_invoice_to_stock 8990 8716 274 3.04 0 4824 20 0 274
v_all_customers 33462 33462 0 0.00 0 19 1 0 0
v_all_suppliers 26754 26754 0 0.00 0 61 1 0 0
v_all_wares 36072 36072 0 0.00 0 110 1 0 0
v_cancel_adding_invoice 706 706 0 0.00 0 1033 7 0 0
v_cancel_client_order 3128 3128 0 0.00 0 4887 6 0 0
v_cancel_customer_prepayment 1184 1184 0 0.00 0 4796 10 0 0
v_cancel_customer_reserve 1158 1158 0 0.00 0 4021 10 0 0
v_cancel_payment_to_supplier 694 694 0 0.00 0 1058 5 0 0
v_cancel_supplier_invoice 682 660 22 3.22 0 1945 16 0 22
v_cancel_supplier_order 700 700 0 0.00 0 1289 7 0 0
v_cancel_write_off 1790 1790 0 0.00 0 2558 16 0 0
v_max_id_clo_ord 4648 4648 0 0.00 0 914 2 0 0
v_max_id_clo_res 904 904 0 0.00 0 4345 21 0 0
v_max_id_ord_sup 4743 4743 0 0.00 0 3262 3 0 0
v_max_non_paid_invoice 1147 1147 0 0.00 0 499 3 0 0
v_max_non_paid_realizn 2920 2920 0 0.00 0 1569 4 0 0
v_min_id_clo_ord 4648 4648 0 0.00 0 1910 5 0 0
v_min_id_clo_res 904 904 0 0.00 0 5264 9 0 0
v_min_id_ord_sup 4743 4743 0 0.00 0 6980 6 0 0
v_min_non_paid_invoice 5133 5133 0 0.00 0 9351 20 0 0
v_min_non_paid_realizn 6137 6137 0 0.00 0 9803 30 0 0
v_our_firm 9044 9044 0 0.00 0 20 1 0 0
v_reserve_write_off 17204 17204 0 0.00 0 4727 7 0 0
x_lock_depdocs_on_canc_invoice 8738 8738 0 0.00 0 14522 132 0 0
x_lock_depdocs_on_canc_sup_ord 350 350 0 0.00 0 10293 341 0 0
x_make_qstorno_1000_1200 4648 4648 0 0.00 2 31971 1275 0 0
x_make_qstorno_1200_2000 4745 4745 0 0.00 2 52174 3006 0 0
x_make_qstorno_2100_3300 409082 409082 0 0.00 0 53489 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-03-2024 22:11:12 to 31-03-2024 22:11:16.

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
20:09:50 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:51 28880 8192000000 9881765696 10187300864 958993168 10.479 100 87 174 0 987030912 5064880 22972864
20:12:29 25577 8192000000 9936194016 10256281600 1018276464 11.055 100 86 172 0 1048373408 7771680 22325264
20:13:57 15059 8192000000 9968837664 10299744256 1051175136 11.372 100 85 170 0 1081943648 9085040 21683472
20:15:16 11145 8192000000 10029203968 10378821632 1114562976 11.976 100 69 138 0 1140742560 9874320 16305264
20:16:30 8506 8192000000 10073194640 10432671744 1165854656 12.458 100 78 154 1 1195299760 11814688 17630416
20:17:42 3719 8192000000 10119111008 10487406592 1211584944 12.884 100 79 156 0 1241785408 12427904 17772560
20:18:48 3269 8192000000 10148898976 10527305728 1244896720 13.191 100 83 163 2 1276108416 12734768 18476928
20:19:53 1494 8192000000 10186095984 10567909376 1275707248 13.474 100 86 172 0 1308191840 13641664 18842928
20:20:56 795 8192000000 10208171136 10591162368 1290328112 13.607 100 92 184 2 1324402256 13520128 20554016
20:21:57 9032 8192000000 10199171888 10594144256 1294332928 13.644 100 50 97 2 1311705760 6594976 10777856
20:23:07 5353 8192000000 10196296112 10607325184 1304219872 13.734 100 37 74 0 1320488496 8471312 7797312
20:24:20 8194 8192000000 10204093648 10618183680 1318161824 13.860 100 17 32 0 1327270608 5358672 3750112
20:25:31 9871 8192000000 10212598720 10630705152 1322791008 13.902 100 18 36 1 1337290368 10328656 4170704
20:26:46 32241 8192000000 10230292176 10643525632 1330692768 13.973 100 52 102 0 1349992832 5262144 14037920
20:28:19 5747 8192000000 10233264000 10653040640 1336586880 14.027 100 26 53 0 1348684576 6145056 5952640
20:29:27 5747 8192000000 10222969328 10639187968 1329019968 13.958 100 17 31 1 1338508624 5947456 3541200
20:30:40 22831 8192000000 10241122096 10650980352 1323465392 13.908 99 41 82 0 1339716512 7003440 9247680
20:32:19 64802 8192000000 10233332288 10649444352 1295860896 13.658 96 31 62 0 1312491712 9188304 7442512
20:34:26 75586 8192000000 10244604400 10655760384 1314304080 13.825 98 48 93 0 1337936896 12541808 11091008
20:37:08 21918 8192000000 10261020432 10676293632 1337126288 14.031 99 41 79 3 1365450896 18911488 9413120
20:38:36 20754 8192000000 10240932288 10654928896 1293620384 13.637 96 41 80 2 1322414032 18660256 10133392
20:40:05 9816 8192000000 10259408816 10668830720 1338693616 14.046 100 54 103 1 1370469120 20051248 11724256
20:41:20 1446 8192000000 10253725520 10652098560 1324663584 13.919 100 65 130 1 1364184464 24002432 15518448
20:42:27 3498 8192000000 10274276192 10677264384 1346549376 14.116 100 72 144 1 1389792288 26302256 16940656
20:43:52 8651 8192000000 10281098192 10681610240 1344754448 14.100 100 68 136 0 1390512192 29289312 16468432
20:45:06 2749 8192000000 10289752272 10692796416 1352282976 14.168 100 69 134 2 1398763424 29731680 16748768
20:46:14 5300 8192000000 10296328288 10688917504 1341530080 14.071 100 82 162 2 1400317168 39852944 18934144
20:47:26 3895 8192000000 10309002064 10713403392 1355161376 14.194 100 71 139 0 1414036720 41360656 17514688
20:48:35 922 8192000000 10325079552 10732384256 1372381120 14.348 100 85 162 2 1429839728 37336624 20121984
20:49:39 5797 8192000000 10322031264 10746208256 1384114960 14.453 100 52 104 0 1432007904 34631600 13261344
20:50:49 2378 8192000000 10337724976 10746982400 1388959936 14.497 100 68 134 0 1437190784 31646704 16584144
20:51:58 9935 8192000000 10333954176 10757197824 1399056896 14.587 100 37 74 0 1440138144 31331152 9750096
20:53:15 17990 8192000000 10325570784 10754670592 1377971424 14.398 99 32 64 0 1422870064 36314544 8584096
20:54:36 21893 8192000000 10324101984 10769735680 1390258128 14.508 100 28 56 0 1437991968 39872096 7861744
20:56:01 39115 8192000000 10312426176 10761101312 1366939696 14.300 99 20 40 0 1410903056 38111136 5852224
20:57:43 77272 8192000000 10311141232 10740785152 1389677312 14.503 100 38 76 4 1415799568 16809200 9313056
21:00:02 93395 8192000000 10303488448 10743033856 1380424128 14.420 100 28 56 1 1402844256 15192800 7227328
21:02:37 14056 8192000000 10318901104 10754809856 1396112720 14.560 100 55 109 2 1422629616 14174272 12342624
21:03:56 42559 8192000000 10292718800 10749804544 1395733696 14.557 100 14 28 1 1410810848 11914992 3162160
21:06:21 55851 8192000000 10306091120 10763632640 1408277792 14.669 100 31 63 2 1427219344 11391328 7550224
21:08:21 98520 8192000000 10317991632 10773237760 1399913536 14.594 99 20 39 0 1420252512 15445072 4893904
21:11:03 92506 8192000000 10298764976 10744639488 1382489056 14.439 98 15 30 0 1402218400 16692736 3036608
21:13:37 68213 8192000000 10320270592 10770698240 1404920512 14.639 100 32 64 1 1425674016 13547296 7206208
21:15:48 20986 8192000000 10317313600 10770141184 1405763008 14.646 100 37 75 1 1431148720 16612944 8772768
21:17:17 61180 8192000000 10290201264 10751123456 1362400192 14.259 97 30 58 2 1390033552 20830944 6802416
21:20:44 66058 8192000000 10273721888 10732859392 1366132816 14.292 99 18 36 1 1377719056 7619760 3966480
21:22:51 32194 8192000000 10256021264 10706567168 1315836432 13.839 95 40 80 0 1332426448 7123840 9466176
21:24:24 53827 8192000000 10278185616 10723966976 1333147152 13.996 97 16 32 0 1343464048 7238976 3077920
21:26:19 43639 8192000000 10290263136 10743848960 1353319952 14.177 97 19 38 0 1368275088 10722160 4232976
21:28:03 28776 8192000000 10258448640 10685583360 1254726928 13.282 91 20 40 1 1266069248 7142400 4199920
21:29:33 56184 8192000000 10257430272 10691100672 1290734512 13.611 95 32 64 0 1308341600 10824432 6782656
21:31:30 50262 8192000000 10243575088 10685579264 1306560640 13.755 97 20 40 0 1327073360 15833952 4678768
21:33:21 74992 8192000000 10240663552 10681610240 1287358704 13.580 96 26 53 0 1304574448 11697280 5518464
21:35:40 80656 8192000000 10250491264 10684063744 1299354496 13.689 96 34 69 0 1316003744 9428528 7220720
21:38:06 40234 8192000000 10255831568 10700955648 1350239984 14.150 100 13 26 0 1367385280 14145536 2999760
21:39:47 46842 8192000000 10274876464 10725072896 1377281696 14.392 100 9 18 1 1392878816 13679248 1917872
21:42:33 65819 8192000000 10283821984 10738741248 1377343040 14.393 100 15 30 0 1390753184 10134944 3275200
21:44:39 57574 8192000000 10285247696 10730663936 1358904768 14.228 98 7 14 0 1367913440 7694784 1313888
21:46:40 53380 8192000000 10303003312 10745155584 1378722304 14.405 99 19 38 0 1391195888 7805392 4668192
21:48:40 31997 8192000000 10299689440 10751496192 1381746512 14.432 98 15 30 0 1401602752 16682528 3173712
21:50:13 59414 8192000000 10299394752 10753257472 1390606640 14.511 100 7 14 0 1404529968 12160160 1763168
21:52:15 55105 8192000000 10327212432 10765815808 1384477712 14.457 99 28 56 0 1401920848 11819872 5623264
21:54:11 64095 8192000000 10316311536 10770919424 1391161856 14.516 99 15 31 0 1403735840 9264608 3309376
21:56:48 106821 8192000000 10309645696 10766004224 1404524512 14.635 100 15 28 0 1419343472 12096544 2722416
21:59:45 34464 8192000000 10295398656 10760753152 1395453232 14.554 100 20 40 0 1411854048 12054896 4345920
22:01:44 36933 8192000000 10285655376 10751483904 1384488832 14.457 99 14 28 0 1394130176 6590704 3050640
22:04:16 56872 8192000000 10281544928 10730881024 1373773936 14.361 99 12 24 0 1386097072 9569840 2753296
22:06:41 43997 8192000000 10265997824 10721484800 1336742864 14.028 97 21 42 1 1358927920 17382144 4802912
22:08:25 31389 8192000000 10259455088 10707226624 1340298864 14.060 98 21 42 0 1354764352 9741472 4724016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 31-03-2024 22:11:18 to 31-03-2024 22:11:32.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 137 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-03-2024 22:11:33 to 31-03-2024 22:11:35.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          174987
MON$OLDEST_ACTIVE               178010
MON$OLDEST_SNAPSHOT             178010
MON$NEXT_TRANSACTION            178010
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1893952
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Mar 31 22:11:36 2024 
 
Database header page information: 
    Flags            0 
    Generation        92692 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    174987 
    Oldest active        178010 
    Oldest snapshot        178010 
    Next transaction    178011 
    Sequence number        0 
    Next attachment ID    716 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.46, total records: 7783692 
    Average version length: 48.16, total versions: 70923, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86896 
    Data pages: 86896, average fill: 71% 
    Primary pages: 86896, secondary pages: 0, swept pages: 20887 
    Empty pages: 4, full pages: 65919 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 131 
    40 - 59% = 1781 
    60 - 79% = 84937 
    80 - 99% = 34 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23392, nodes: 7783692 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1724841, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 342 
        20 - 39% = 1886 
        40 - 59% = 4117 
        60 - 79% = 2328 
        80 - 99% = 14719 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13560, nodes: 7783692 
    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: 1547592, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1573 
        40 - 59% = 2093 
        60 - 79% = 1026 
        80 - 99% = 8868 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8395, nodes: 7783692 
    Average node length: 6.62, total dup: 5813541, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1540345, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 996 
        40 - 59% = 1396 
        60 - 79% = 899 
        80 - 99% = 4972 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.56, total records: 2262004 
    Average version length: 34.63, total versions: 70498, max versions: 3 
    Average fragment length: 5.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28664 
    Data pages: 28664, average fill: 73% 
    Primary pages: 28661, secondary pages: 3, swept pages: 11526 
    Empty pages: 0, full pages: 21212 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 138 
    40 - 59% = 2130 
    60 - 79% = 25763 
    80 - 99% = 617 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4589, nodes: 2262004 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 697207, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 938 
        40 - 59% = 841 
        60 - 79% = 735 
        80 - 99% = 2075 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2551, nodes: 2264164 
    Average node length: 4.97, total dup: 2263265, max dup: 20675 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1250816, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 270 
        40 - 59% = 1577 
        60 - 79% = 517 
        80 - 99% = 185 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2076, nodes: 2262004 
    Average node length: 4.97, total dup: 2261954, max dup: 130539 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1068348, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 172 
        40 - 59% = 1043 
        60 - 79% = 47 
        80 - 99% = 811 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4349, nodes: 2262004 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 697207, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 98 
        20 - 39% = 591 
        40 - 59% = 581 
        60 - 79% = 826 
        80 - 99% = 2253 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.42, total records: 400 
    Average version length: 22.86, total versions: 237237, max versions: 624 
    Average fragment length: 2.00, total fragments: 50, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1320 
    Data pages: 1320, average fill: 89% 
    Primary pages: 14, secondary pages: 1306, swept pages: 0 
    Empty pages: 7, full pages: 1312 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1312 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 14.28, total records: 93662 
    Average version length: 68.29, total versions: 74090, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.16 
    Pointer pages: 6, data page slots: 2448 
    Data pages: 1568, average fill: 73% 
    Primary pages: 1567, secondary pages: 1, swept pages: 0 
    Empty pages: 109, full pages: 1135 
    Fill distribution: 
     0 - 19% = 146 
    20 - 39% = 75 
    40 - 59% = 118 
    60 - 79% = 276 
    80 - 99% = 953 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705124, depth: 3, leaf buckets: 260, nodes: 93662 
    Average node length: 13.10, total dup: 6615, max dup: 2 
    Average key length: 10.69, compression ratio: 2.53 
    Average prefix length: 19.24, average data length: 7.76 
    Clustering factor: 67635, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 123 
        60 - 79% = 95 
        80 - 99% = 21 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 18002, max versions: 953 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 90% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 7.45, total records: 1121 
    Average version length: 42.85, total versions: 933, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 7.79 
    Pointer pages: 1, data page slots: 24 
    Data pages: 20, average fill: 54% 
    Primary pages: 18, secondary pages: 2, swept pages: 0 
    Empty pages: 1, full pages: 8 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 5 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90924, depth: 2, leaf buckets: 2, nodes: 1121 
    Average node length: 4.55, total dup: 1024, max dup: 112 
    Average key length: 2.92, compression ratio: 6.50 
    Average prefix length: 18.16, average data length: 0.84 
    Clustering factor: 607, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.03, total records: 70 
    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: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.16, total records: 789228 
    Average version length: 25.37, total versions: 64273, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8224 
    Data pages: 8216, average fill: 67% 
    Primary pages: 8187, secondary pages: 29, swept pages: 1881 
    Empty pages: 150, full pages: 6902 
    Fill distribution: 
     0 - 19% = 327 
    20 - 39% = 266 
    40 - 59% = 274 
    60 - 79% = 7112 
    80 - 99% = 237 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 889, nodes: 789228 
    Average node length: 4.87, total dup: 789179, max dup: 141888 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88998, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 134 
        40 - 59% = 505 
        60 - 79% = 205 
        80 - 99% = 44 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 938, nodes: 789228 
    Average node length: 5.87, total dup: 702746, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158972, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 102 
        40 - 59% = 425 
        60 - 79% = 151 
        80 - 99% = 259 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 995, nodes: 789228 
    Average node length: 5.87, total dup: 702746, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160941, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 215 
        40 - 59% = 388 
        60 - 79% = 132 
        80 - 99% = 256 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1153, nodes: 789228 
    Average node length: 5.96, total dup: 702746, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154160, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 283 
        40 - 59% = 594 
        60 - 79% = 200 
        80 - 99% = 73 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5464 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.65, total fragments: 57, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 58% 
    Primary pages: 73, secondary pages: 21, swept pages: 51 
    Empty pages: 11, full pages: 64 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5464 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.43, average data length: 1.55 
    Clustering factor: 5188, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5464 
    Average node length: 11.12, 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: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 81765 
    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: 792 
    Data pages: 792, average fill: 71% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 787 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 787 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34092, depth: 2, leaf buckets: 105, nodes: 81765 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3414, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.14, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 146.72, total records: 178731 
    Average version length: 152.19, total versions: 5021, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 7, data page slots: 5448 
    Data pages: 4320, average fill: 85% 
    Primary pages: 4320, secondary pages: 0, swept pages: 1 
    Empty pages: 68, full pages: 4216 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 7 
    40 - 59% = 18 
    60 - 79% = 9 
    80 - 99% = 4216 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 149.59, total records: 184067 
    Average version length: 148.53, total versions: 1892, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 6, data page slots: 5504 
    Data pages: 4424, average fill: 86% 
    Primary pages: 4423, secondary pages: 1, swept pages: 5 
    Empty pages: 46, full pages: 4347 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 6 
    40 - 59% = 14 
    60 - 79% = 10 
    80 - 99% = 4346 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 149.71, total records: 171878 
    Average version length: 149.01, total versions: 1478, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 7, data page slots: 4632 
    Data pages: 4112, average fill: 86% 
    Primary pages: 4112, secondary pages: 0, swept pages: 3 
    Empty pages: 30, full pages: 4062 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 4062 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.91, total records: 184856 
    Average version length: 152.48, total versions: 5254, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 6, data page slots: 5288 
    Data pages: 4472, average fill: 85% 
    Primary pages: 4472, secondary pages: 0, swept pages: 1 
    Empty pages: 71, full pages: 4375 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 12 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 4374 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 136.19, total records: 155041 
    Average version length: 154.85, total versions: 14974, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.45 
    Pointer pages: 6, data page slots: 5168 
    Data pages: 3736, average fill: 86% 
    Primary pages: 3736, secondary pages: 0, swept pages: 3 
    Empty pages: 47, full pages: 3666 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 4 
    80 - 99% = 3666 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 140.24, total records: 191114 
    Average version length: 154.66, total versions: 13895, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.09 
    Pointer pages: 8, data page slots: 6368 
    Data pages: 4664, average fill: 85% 
    Primary pages: 4664, secondary pages: 0, swept pages: 5 
    Empty pages: 109, full pages: 4529 
    Fill distribution: 
     0 - 19% = 112 
    20 - 39% = 9 
    40 - 59% = 10 
    60 - 79% = 4 
    80 - 99% = 4529 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.32, total records: 172088 
    Average version length: 151.30, total versions: 3027, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 4648 
    Data pages: 4144, average fill: 86% 
    Primary pages: 4144, secondary pages: 0, swept pages: 5 
    Empty pages: 55, full pages: 4069 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 11 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 4069 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.62, total records: 164248 
    Average version length: 151.51, total versions: 2396, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 7, data page slots: 4480 
    Data pages: 3968, average fill: 85% 
    Primary pages: 3967, secondary pages: 1, swept pages: 5 
    Empty pages: 67, full pages: 3873 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 6 
    40 - 59% = 12 
    60 - 79% = 6 
    80 - 99% = 3874 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 140.94, total records: 182449 
    Average version length: 154.36, total versions: 12217, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.03 
    Pointer pages: 8, data page slots: 5704 
    Data pages: 4424, average fill: 86% 
    Primary pages: 4424, secondary pages: 0, swept pages: 3 
    Empty pages: 78, full pages: 4314 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 12 
    40 - 59% = 10 
    60 - 79% = 8 
    80 - 99% = 4314 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 127.79, total records: 199802 
    Average version length: 155.05, total versions: 30669, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.27 
    Pointer pages: 8, data page slots: 5064 
    Data pages: 4816, average fill: 87% 
    Primary pages: 4816, secondary pages: 0, swept pages: 7 
    Empty pages: 57, full pages: 4743 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4743 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.90, total records: 2117658 
    Average version length: 52.94, total versions: 34084, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25552 
    Data pages: 25552, average fill: 71% 
    Primary pages: 25552, secondary pages: 0, swept pages: 10625 
    Empty pages: 234, full pages: 21276 
    Fill distribution: 
     0 - 19% = 465 
    20 - 39% = 439 
    40 - 59% = 973 
    60 - 79% = 23373 
    80 - 99% = 302 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2616, nodes: 2117658 
    Average node length: 5.44, total dup: 1976736, max dup: 1644 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182800, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 314 
        40 - 59% = 1706 
        60 - 79% = 293 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2760, nodes: 2117658 
    Average node length: 5.69, total dup: 1901038, max dup: 72 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 378180, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 5 
        40 - 59% = 2361 
        60 - 79% = 368 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2159, nodes: 2117658 
    Average node length: 4.96, total dup: 2117558, max dup: 28406 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180614, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 180 
        40 - 59% = 1175 
        60 - 79% = 393 
        80 - 99% = 409 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 42.95, total records: 149708 
    Average version length: 69.17, total versions: 56818, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.93 
    Pointer pages: 3, data page slots: 4464 
    Data pages: 3248, average fill: 53% 
    Primary pages: 3248, secondary pages: 0, swept pages: 584 
    Empty pages: 708, full pages: 1817 
    Fill distribution: 
     0 - 19% = 961 
    20 - 39% = 203 
    40 - 59% = 158 
    60 - 79% = 738 
    80 - 99% = 1188 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103536, depth: 3, leaf buckets: 230, nodes: 149708 
    Average node length: 6.42, total dup: 130266, max dup: 14 
    Average key length: 3.94, compression ratio: 10.66 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26023, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 49 
        40 - 59% = 113 
        60 - 79% = 53 
        80 - 99% = 14 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.25, total records: 6921440 
    Average version length: 68.78, total versions: 371905, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 62, data page slots: 100080 
    Data pages: 100080, average fill: 74% 
    Primary pages: 100080, secondary pages: 0, swept pages: 26412 
    Empty pages: 27, full pages: 77248 
    Fill distribution: 
     0 - 19% = 134 
    20 - 39% = 854 
    40 - 59% = 6575 
    60 - 79% = 86910 
    80 - 99% = 5607 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10627, nodes: 6921440 
    Average node length: 6.51, total dup: 5986582, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1546402, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 1878 
        40 - 59% = 5704 
        60 - 79% = 2585 
        80 - 99% = 445 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8463, nodes: 6921440 
    Average node length: 5.40, total dup: 6643594, max dup: 169 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1351617, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1239 
        40 - 59% = 4739 
        60 - 79% = 1555 
        80 - 99% = 923 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8510, nodes: 6921440 
    Average node length: 5.40, total dup: 6643594, max dup: 169 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1354168, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1282 
        40 - 59% = 4726 
        60 - 79% = 1574 
        80 - 99% = 920 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.23, total records: 11901178 
    Average version length: 68.76, total versions: 297485, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 103, data page slots: 166656 
    Data pages: 166656, average fill: 76% 
    Primary pages: 166656, secondary pages: 0, swept pages: 80223 
    Empty pages: 8, full pages: 148502 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 536 
    40 - 59% = 4439 
    60 - 79% = 156783 
    80 - 99% = 4854 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18282, nodes: 11901178 
    Average node length: 6.57, total dup: 10375911, max dup: 58 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2349117, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 2518 
        40 - 59% = 10776 
        60 - 79% = 4186 
        80 - 99% = 782 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 43.98, total records: 1561014 
    Average version length: 69.11, total versions: 568280, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.87 
    Pointer pages: 26, data page slots: 41688 
    Data pages: 28255, average fill: 63% 
    Primary pages: 28255, secondary pages: 0, swept pages: 7648 
    Empty pages: 3045, full pages: 18389 
    Fill distribution: 
     0 - 19% = 4849 
    20 - 39% = 1900 
    40 - 59% = 1733 
    60 - 79% = 10964 
    80 - 99% = 8809 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2167, nodes: 1561014 
    Average node length: 5.52, total dup: 1497510, max dup: 97 
    Average key length: 2.56, compression ratio: 16.38 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 105807, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 589 
        40 - 59% = 1058 
        60 - 79% = 408 
        80 - 99% = 100 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 40.52, total records: 1081845 
    Average version length: 69.13, total versions: 446565, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.11 
    Pointer pages: 22, data page slots: 35672 
    Data pages: 26048, average fill: 48% 
    Primary pages: 26048, secondary pages: 0, swept pages: 6333 
    Empty pages: 5672, full pages: 12375 
    Fill distribution: 
     0 - 19% = 9032 
    20 - 39% = 2521 
    40 - 59% = 1242 
    60 - 79% = 4525 
    80 - 99% = 8728 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1491, nodes: 1081845 
    Average node length: 5.76, total dup: 1012141, max dup: 104 
    Average key length: 2.83, compression ratio: 14.82 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 143773, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 306 
        40 - 59% = 771 
        60 - 79% = 346 
        80 - 99% = 68 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.99, total records: 9325968 
    Average version length: 68.97, total versions: 393872, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 88, data page slots: 143176 
    Data pages: 143152, average fill: 70% 
    Primary pages: 143152, secondary pages: 0, swept pages: 60585 
    Empty pages: 172, full pages: 79565 
    Fill distribution: 
     0 - 19% = 765 
    20 - 39% = 4732 
    40 - 59% = 19813 
    60 - 79% = 112148 
    80 - 99% = 5694 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13520, nodes: 9325968 
    Average node length: 6.68, total dup: 7736603, max dup: 17 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1985565, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1146 
        40 - 59% = 6835 
        60 - 79% = 4793 
        80 - 99% = 741 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21167233 
    Average version length: 83.00, total versions: 10753, 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: 319120 
    Data pages: 319120, average fill: 81% 
    Primary pages: 319120, secondary pages: 0, swept pages: 13565 
    Empty pages: 51, full pages: 318093 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 54 
    40 - 59% = 120 
    60 - 79% = 27964 
    80 - 99% = 290907 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19331, nodes: 21167233 
    Average node length: 5.72, total dup: 20685715, max dup: 140 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3284485, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 8016 
        60 - 79% = 552 
        80 - 99% = 10755 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17197, nodes: 21167233 
    Average node length: 6.31, total dup: 18602989, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914900, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 6 
        40 - 59% = 790 
        60 - 79% = 264 
        80 - 99% = 16133 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21068, nodes: 21167233 
    Average node length: 6.35, total dup: 18520644, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578113, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 8172 
        60 - 79% = 610 
        80 - 99% = 12277 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16075, nodes: 21167233 
    Average node length: 5.56, total dup: 21167133, max dup: 229909 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943709, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2784 
        60 - 79% = 419 
        80 - 99% = 12865 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.34, total records: 9750719 
    Average version length: 82.59, total versions: 364216, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 104, data page slots: 168320 
    Data pages: 168304, average fill: 71% 
    Primary pages: 168304, secondary pages: 0, swept pages: 80105 
    Empty pages: 283, full pages: 101282 
    Fill distribution: 
     0 - 19% = 1132 
    20 - 39% = 5673 
    40 - 59% = 22207 
    60 - 79% = 76625 
    80 - 99% = 62667 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11356, nodes: 9750719 
    Average node length: 5.36, total dup: 9441464, max dup: 192 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2121463, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 48 
        40 - 59% = 8148 
        60 - 79% = 3037 
        80 - 99% = 119 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13575, nodes: 9750719 
    Average node length: 6.23, total dup: 8084286, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1465740, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 3939 
        40 - 59% = 4346 
        60 - 79% = 2595 
        80 - 99% = 2547 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12691, nodes: 9750719 
    Average node length: 5.98, total dup: 8461991, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2318028, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 64 
        40 - 59% = 9138 
        60 - 79% = 3349 
        80 - 99% = 135 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10079, nodes: 9750719 
    Average node length: 5.13, total dup: 9750619, max dup: 161983 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1498175, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1193 
        40 - 59% = 4851 
        60 - 79% = 1770 
        80 - 99% = 2220 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.33, total records: 11407259 
    Average version length: 82.46, total versions: 273795, 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: 190760 
    Data pages: 189600, average fill: 74% 
    Primary pages: 189600, secondary pages: 0, swept pages: 69531 
    Empty pages: 2277, full pages: 145045 
    Fill distribution: 
     0 - 19% = 3905 
    20 - 39% = 6331 
    40 - 59% = 16113 
    60 - 79% = 44848 
    80 - 99% = 118403 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13141, nodes: 11407259 
    Average node length: 5.30, total dup: 11297442, max dup: 664 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2380997, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 66 
        40 - 59% = 9048 
        60 - 79% = 3879 
        80 - 99% = 146 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10563, nodes: 11407259 
    Average node length: 5.50, total dup: 10909016, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 720916, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 161 
        20 - 39% = 883 
        40 - 59% = 2597 
        60 - 79% = 1856 
        80 - 99% = 5066 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15024, nodes: 11407259 
    Average node length: 6.03, total dup: 9955234, max dup: 64 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2397496, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 96 
        40 - 59% = 10529 
        60 - 79% = 4226 
        80 - 99% = 171 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10863, nodes: 11407259 
    Average node length: 5.22, total dup: 11407159, max dup: 210130 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 709412, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 111 
        20 - 39% = 840 
        40 - 59% = 4784 
        60 - 79% = 1495 
        80 - 99% = 3633 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 80.01, total records: 9830011 
    Average version length: 82.92, total versions: 324561, 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: 106, data page slots: 171792 
    Data pages: 171768, average fill: 71% 
    Primary pages: 171768, secondary pages: 0, swept pages: 88194 
    Empty pages: 380, full pages: 99070 
    Fill distribution: 
     0 - 19% = 1287 
    20 - 39% = 6249 
    40 - 59% = 24630 
    60 - 79% = 80750 
    80 - 99% = 58852 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11901, nodes: 9830011 
    Average node length: 5.17, total dup: 9801151, max dup: 2120 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1935497, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1480 
        40 - 59% = 7994 
        60 - 79% = 1827 
        80 - 99% = 564 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13674, nodes: 9830011 
    Average node length: 6.24, total dup: 8150077, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1427242, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 4010 
        40 - 59% = 4255 
        60 - 79% = 2574 
        80 - 99% = 2663 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12526, nodes: 9830011 
    Average node length: 5.43, total dup: 9389914, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2068730, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1452 
        40 - 59% = 8801 
        60 - 79% = 1663 
        80 - 99% = 579 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10203, nodes: 9830011 
    Average node length: 5.14, total dup: 9829911, max dup: 164446 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1519125, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1251 
        40 - 59% = 4930 
        60 - 79% = 1741 
        80 - 99% = 2232 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.77, total records: 576766 
    Average version length: 68.85, total versions: 3412, 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: 7960 
    Data pages: 7960, average fill: 76% 
    Primary pages: 7960, secondary pages: 0, swept pages: 4043 
    Empty pages: 1, full pages: 6859 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 10 
    40 - 59% = 130 
    60 - 79% = 7768 
    80 - 99% = 51 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45541, depth: 3, leaf buckets: 734, nodes: 576766 
    Average node length: 5.95, total dup: 491200, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100500, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 520 
        60 - 79% = 91 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32273, depth: 3, leaf buckets: 764, nodes: 576766 
    Average node length: 6.15, total dup: 473058, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100556, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 35 
        40 - 59% = 536 
        60 - 79% = 97 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 560, nodes: 576766 
    Average node length: 4.86, total dup: 576666, max dup: 10115 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89275, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 20 
        40 - 59% = 321 
        60 - 79% = 92 
        80 - 99% = 126 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar 31 22:11:59 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7783692 70923 1 0.0000 0.0000
DOC_LIST 2262004 70498 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 237237 624 59300.0000 0.0000
INVNT_TURNOVER_LOG 93662 74090 1 0.0000 0.0000
MONEY_SALDO 49 18002 953 36700.0000 0.0000
MONEY_TURNOVER_LOG 1121 933 1 0.0000 0.0000
PDISTR 789228 64273 4 0.0000 0.0000
PERF_SPLIT_0 178731 5021 1 0.0000 0.0000
PERF_SPLIT_1 184067 1892 1 0.0000 0.0000
PERF_SPLIT_2 171878 1478 1 0.0000 0.0000
PERF_SPLIT_3 184856 5254 1 0.0000 0.0000
PERF_SPLIT_4 155041 14974 1 0.0000 0.0000
PERF_SPLIT_5 191114 13895 1 0.0000 0.0000
PERF_SPLIT_6 172088 3027 1 0.0000 0.0000
PERF_SPLIT_7 164248 2396 1 0.0000 0.0000
PERF_SPLIT_8 182449 12217 1 0.0000 0.0000
PERF_SPLIT_9 199802 30669 1 0.0000 0.0000
PSTORNED 2117658 34084 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 149708 56818 1 0.0000 0.0000
XQD_1000_3300 6921440 371905 1 0.0000 0.0000
XQD_1200_2000 11901178 297485 1 0.0000 0.0000
XQD_2000_3300 1561014 568280 1 0.0000 0.0000
XQD_2100_3300 1081845 446565 1 0.0000 0.0000
XQD_3300_3400 9325968 393872 1 0.0000 0.0000
XQS_1000_1200 21167233 10753 1 0.0000 0.0000
XQS_1000_3300 9750719 364216 1 0.0000 0.0000
XQS_1200_2000 11407259 273795 1 0.0000 0.0000
XQS_2100_3300 9830011 324561 1 0.0000 0.0000
XQS_3300_3400 576766 3412 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-oltp30 according to config parameter 'remove_isql_logs'  

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