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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15586716 kB
MemAvailable 30053744 kB
Buffers 20 kB
Cached 16098412 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 4.0.5
DB_NAME                         /home/bases/oltp40-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-11 04:07:50
DTS_END                         2024-04-11 04:07:50.6300
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/58822
TRN_ID                          174406
ATT_ID                          512
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: 8828.86 17968 882886
customer order: creation 178.66 449 17866
customer order: refuse 15.36 364 1536
order to supplier: creation 47.70 1252 4770
order to supplier: removal 3.30 87269 330
invoice (draft): creation 46.86 2989 4686
invoice (draft): removal 46.33 707 4633
invoice accept: apply 43.24 21099 4324
invoice accept: cancel 41.96 766 4196
customer reserve: creation 4006.35 209 400635
customer reserve: removal 4100.97 56 410097
realization accept: apply 87.11 183 8711
realization accept: cancel 78.67 134 7867
payment from customer: creation 61.06 122 6106
payment from customer: removal 5.73 92 573
payment to supplier: creation 50.98 148 5098
payment to supplier: removal 3.36 61 336
service: total inventory turnovers 4.19 3470 419
service: total monetary turnovers 6.00 512 600
service: aggregate perf. data 1.00 12120 100
service: refresh index statistics 0.03 227365 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-04-2024 04:09:32 to 11-04-2024 04:09:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3237
TEST_TIME 2 3757
TEST_TIME 3 2888
TEST_TIME 4 4439
TEST_TIME 5 4278
TEST_TIME 6 4959
TEST_TIME 7 5408
TEST_TIME 8 5344
TEST_TIME 9 5732
TEST_TIME 10 6283
TEST_TIME 11 6709
TEST_TIME 12 6726
TEST_TIME 13 6604
TEST_TIME 14 6660
TEST_TIME 15 6528
TEST_TIME 16 6590
TEST_TIME 17 6747
TEST_TIME 18 6748
TEST_TIME 19 6835
TEST_TIME 20 7085
TEST_TIME 21 7248
TEST_TIME 22 7556
TEST_TIME 23 7703
TEST_TIME 24 7748
TEST_TIME 25 8137
TEST_TIME 26 9497
TEST_TIME 27 9376
TEST_TIME 28 9488
TEST_TIME 29 9315
TEST_TIME 30 9134
TEST_TIME 31 9032
TEST_TIME 32 8919
TEST_TIME 33 8801
TEST_TIME 34 8944
TEST_TIME 35 8799
TEST_TIME 36 8891
TEST_TIME 37 8824
TEST_TIME 38 8908
TEST_TIME 39 8844
TEST_TIME 40 8750
TEST_TIME 41 8713
TEST_TIME 42 8622
TEST_TIME 43 8690
TEST_TIME 44 8621
TEST_TIME 45 8707
TEST_TIME 46 8826
TEST_TIME 47 8835
TEST_TIME 48 8966
TEST_TIME 49 9016
TEST_TIME 50 8983
TEST_TIME 51 9087
TEST_TIME 52 9154
TEST_TIME 53 9157
TEST_TIME 54 9325
TEST_TIME 55 9309
TEST_TIME 56 9155
TEST_TIME 57 9055
TEST_TIME 58 9065
TEST_TIME 59 9014
TEST_TIME 60 9026
TEST_TIME 61 9007
TEST_TIME 62 8977
TEST_TIME 63 8957
TEST_TIME 64 8992
TEST_TIME 65 9031
TEST_TIME 66 9063
TEST_TIME 67 9042
TEST_TIME 68 9077
TEST_TIME 69 9044
TEST_TIME 70 9187
TEST_TIME 71 9143
TEST_TIME 72 9218
TEST_TIME 73 9256
TEST_TIME 74 9243
TEST_TIME 75 9238
TEST_TIME 76 9132
TEST_TIME 77 9053
TEST_TIME 78 9013
TEST_TIME 79 8951
TEST_TIME 80 8915
TEST_TIME 81 8870
TEST_TIME 82 8877
TEST_TIME 83 8880
TEST_TIME 84 8869
TEST_TIME 85 8899
TEST_TIME 86 8884
TEST_TIME 87 8947
TEST_TIME 88 8922
TEST_TIME 89 8943
TEST_TIME 90 8955
TEST_TIME 91 9012
TEST_TIME 92 9016
TEST_TIME 93 9099
TEST_TIME 94 9066
TEST_TIME 95 8981
TEST_TIME 96 8968
TEST_TIME 97 8931
TEST_TIME 98 8934
TEST_TIME 99 8879
TEST_TIME 100 8835

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-04-2024 04:09:35 to 11-04-2024 04:09:38.

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 1250139 1250139 0 0.00 0 23805 8 0 0
doc_list_biud 1250136 1250136 0 0.00 0 49281 23 0 0
sp_add_invoice_to_stock 4452 4324 128 2.87 33 212339 21100 0 128
sp_cancel_adding_invoice 4196 4196 0 0.00 5 55200 766 0 0
sp_cancel_client_order 1536 1536 0 0.00 4 13023 365 0 0
sp_cancel_customer_reserve 410097 410097 0 0.00 0 43228 56 0 0
sp_cancel_pay_from_customer 573 573 0 0.00 2 9669 92 0 0
sp_cancel_pay_to_supplier 336 336 0 0.00 2 1485 62 0 0
sp_cancel_supplier_invoice 4645 4633 12 0.25 2 49288 708 0 12
sp_cancel_supplier_order 330 330 0 0.00 4 867949 87270 0 0
sp_cancel_write_off 7867 7867 0 0.00 1 10881 135 0 0
sp_client_order 17866 17866 0 0.00 3 38705 449 0 0
sp_customer_reserve 400635 400635 0 0.00 0 63698 210 0 0
sp_fill_shopping_cart 27304 27304 0 0.00 1 13027 34 0 0
sp_fill_shopping_cart_clo_res 400615 400615 0 0.00 0 18594 18 0 0
sp_get_clo_for_invoice 4304 4304 0 0.00 0 37688 392 0 0
sp_kill_cost_storno 12972 12972 0 0.00 0 14786 64 0 0
sp_kill_qstorno_ret_qs2qd 833024 833024 0 0.00 0 49279 30 0 0
sp_kill_qty_storno 441674 441674 0 0.00 0 49280 66 0 0
sp_lock_selected_doc 17961 17961 0 0.00 0 9631 6 0 0
sp_make_cost_storno 24219 24219 0 0.00 0 19082 67 0 0
sp_multiply_rows_for_pdistr 24219 24219 0 0.00 0 16270 36 0 0
sp_multiply_rows_for_qdistr 17866 17866 0 0.00 0 20431 233 0 0
sp_pay_from_customer 6106 6106 0 0.00 3 11738 123 0 0
sp_pay_to_supplier 5098 5098 0 0.00 4 14227 148 0 0
sp_payment_common 11204 11204 0 0.00 1 7644 22 0 0
sp_qd_handle_on_cancel_clo 1536 1536 0 0.00 0 13017 340 0 0
sp_qd_handle_on_invoice_upd_sts 8500 8500 0 0.00 0 31645 298 0 0
sp_qd_handle_on_reserve_upd_sts 8711 8711 0 0.00 0 20318 52 0 0
sp_reserve_write_off 8711 8711 0 0.00 6 25763 184 0 0
sp_supplier_invoice 4686 4686 0 0.00 5 72288 2990 0 0
sp_supplier_order 4770 4770 0 0.00 4 32471 1252 0 0
srv_aggregate_perf_data 101 100 1 0.99 1900 183849 12121 0 1
srv_fill_mon_cache_memory 61 61 0 0.00 659 103595 35252 0 0
srv_find_qd_qs_mism 839866 839866 0 0.00 0 16730 8 0 0
srv_make_invnt_saldo 419 419 0 0.00 49 81193 3471 0 0
srv_make_money_saldo 600 600 0 0.00 1 11595 513 0 0
srv_recalc_idx_stat 3 3 0 0.00 96640 299247 227365 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4324 4324 0 0.00 0 12019 179 0 0
t$perf-norm:sp_cancel_adding_invoice 375 375 0 0.00 0 4489 74 0 0
t$perf-norm:sp_cancel_client_order 1536 1536 0 0.00 0 1267 10 0 0
t$perf-norm:sp_cancel_customer_reserve 620 620 0 0.00 0 2338 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 573 573 0 0.00 0 1259 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 336 336 0 0.00 0 2388 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 336 336 0 0.00 0 3356 29 0 0
t$perf-norm:sp_cancel_supplier_order 330 330 0 0.00 0 21637 1646 0 0
t$perf-norm:sp_cancel_write_off 840 840 0 0.00 0 1484 6 0 0
t$perf-norm:sp_client_order 17866 17866 0 0.00 0 11171 15 0 0
t$perf-norm:sp_customer_reserve 815 815 0 0.00 0 1975 7 0 0
t$perf-norm:sp_pay_from_customer 6106 6106 0 0.00 0 7203 8 0 0
t$perf-norm:sp_pay_to_supplier 5098 5098 0 0.00 0 4459 9 0 0
t$perf-norm:sp_reserve_write_off 8711 8711 0 0.00 0 6315 11 0 0
t$perf-norm:sp_supplier_invoice 4686 4686 0 0.00 0 3357 14 0 0
t$perf-norm:sp_supplier_order 4770 4770 0 0.00 0 7977 16 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 1991 26 0 0
t$perf-norm:srv_fill_mon_cache_memory 61 61 0 0.00 0 18 1 0 0
t$perf-norm:srv_make_invnt_saldo 419 419 0 0.00 0 2374 16 0 0
t$perf-norm:srv_make_money_saldo 600 600 0 0.00 0 1260 7 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 8864 8608 256 2.88 0 3836 17 0 256
v_all_customers 32792 32792 0 0.00 0 16 0 0 0
v_all_suppliers 26822 26822 0 0.00 0 16 1 0 0
v_all_wares 35726 35726 0 0.00 0 166 1 0 0
v_cancel_adding_invoice 750 750 0 0.00 0 1267 7 0 0
v_cancel_client_order 3072 3072 0 0.00 0 1616 4 0 0
v_cancel_customer_prepayment 1146 1146 0 0.00 0 1745 7 0 0
v_cancel_customer_reserve 1240 1240 0 0.00 0 2188 5 0 0
v_cancel_payment_to_supplier 672 672 0 0.00 0 1463 7 0 0
v_cancel_supplier_invoice 696 672 24 3.44 0 2180 14 0 24
v_cancel_supplier_order 660 660 0 0.00 0 2005 6 0 0
v_cancel_write_off 1680 1680 0 0.00 0 2791 14 0 0
v_max_id_clo_ord 4765 4765 0 0.00 0 611 2 0 0
v_max_id_clo_res 815 815 0 0.00 0 4878 28 0 0
v_max_id_ord_sup 4674 4674 0 0.00 0 4829 6 0 0
v_max_non_paid_invoice 1126 1126 0 0.00 0 2300 4 0 0
v_max_non_paid_realizn 3075 3075 0 0.00 0 1383 3 0 0
v_min_id_clo_ord 4765 4765 0 0.00 0 11409 18 0 0
v_min_id_clo_res 815 815 0 0.00 0 3886 10 0 0
v_min_id_ord_sup 4674 4674 0 0.00 0 6374 5 0 0
v_min_non_paid_invoice 5098 5098 0 0.00 0 5961 18 0 0
v_min_non_paid_realizn 6106 6106 0 0.00 0 5434 14 0 0
v_our_firm 8996 8996 0 0.00 0 60 1 0 0
v_reserve_write_off 17422 17422 0 0.00 0 3842 5 0 0
x_lock_depdocs_on_canc_invoice 8493 8493 0 0.00 0 17806 101 0 0
x_lock_depdocs_on_canc_sup_ord 330 330 0 0.00 0 9979 324 0 0
x_make_qstorno_1000_1200 4770 4770 0 0.00 1 32463 1169 0 0
x_make_qstorno_1200_2000 4686 4686 0 0.00 2 71709 2871 0 0
x_make_qstorno_2100_3300 400635 400635 0 0.00 0 58190 189 0 0

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

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
02:07:54 8 8192000000 8798426784 8809533440 4463136 0.054 2 1 2 0 4562528 63616 35776
02:08:55 22161 8192000000 9725446992 10026946560 804575760 8.943 100 88 176 0 832632256 7693408 20363088
02:10:27 27650 8192000000 9764760576 10073214976 834717296 9.247 100 87 174 0 866623760 12336848 19569616
02:12:00 10530 8192000000 9784280304 10104008704 857613136 9.476 100 79 159 0 896900384 21821472 17465776
02:13:14 10375 8192000000 9840406720 10170109952 894155984 9.840 100 78 155 0 946524816 36278000 16090832
02:14:27 6493 8192000000 9889954656 10230575104 930853472 10.203 100 87 173 1 1001160752 52501920 17805360
02:15:36 6104 8192000000 9930264640 10284584960 965226368 10.540 100 82 166 0 1042020848 60386112 16408368
02:16:46 2646 8192000000 9974176192 10338304000 1000504576 10.883 100 79 159 0 1088692832 72973552 15214704
02:17:49 2303 8192000000 10010085104 10374311936 1022882144 11.100 100 84 166 0 1118424800 80396336 15146320
02:18:54 1584 8192000000 9998260544 10373750784 1039334048 11.258 100 75 150 0 1108785440 54853824 14597568
02:19:57 28191 8192000000 9954065760 10343276544 1047764432 11.339 100 46 92 0 1088264864 30757568 9742864
02:21:35 4967 8192000000 9994265328 10389110784 1056032400 11.418 100 35 70 0 1107056272 44452960 6570912
02:22:41 4895 8192000000 9984377952 10376937472 1067879984 11.532 100 51 101 1 1100434160 21526528 11027648
02:23:47 8777 8192000000 9975571440 10383794176 1077495536 11.624 100 20 38 1 1100097472 18649376 3952560
02:24:56 39827 8192000000 9994915776 10394689536 1081023648 11.657 100 38 76 0 1102982400 12650320 9308432
02:26:37 7365 8192000000 9994889152 10406387712 1082024624 11.667 100 24 49 0 1117425952 30180432 5220896
02:27:46 4723 8192000000 9996420528 10396041216 1081472016 11.661 100 45 91 0 1115663792 25171968 9019808
02:28:56 7829 8192000000 10030820656 10431561728 1084948128 11.695 100 50 100 0 1142937808 48024032 9965648
02:30:07 82184 8192000000 10070376288 10481065984 1083485104 11.681 99 49 95 1 1179427584 86652064 9290416
02:32:33 10280 8192000000 10032131488 10438365184 1093251984 11.774 99 35 68 1 1148805296 48591936 6961376
02:33:47 21452 8192000000 10062650080 10481086464 1090824240 11.750 99 40 79 0 1173009744 73743936 8441568
02:35:12 5463 8192000000 10092717248 10488102912 1103766784 11.873 100 55 110 0 1202464624 88039648 10658192
02:36:22 9477 8192000000 10080292272 10473656320 1083654384 11.682 100 53 100 0 1191129216 97408800 10066032
02:37:34 4033 8192000000 10085893824 10463608832 1022016192 11.091 94 66 131 0 1162850704 127034080 13800432
02:38:43 18372 8192000000 10068888256 10481061888 1044392368 11.307 98 45 89 0 1152987360 99385248 9209744
02:40:04 4842 8192000000 10095641696 10492608512 1068851520 11.541 99 46 90 0 1196335312 117872480 9611312
02:41:17 17242 8192000000 10095219184 10499276800 1086687952 11.711 100 42 82 0 1195417968 100157712 8572304
02:42:48 8352 8192000000 10146347248 10550308864 1088530176 11.729 99 46 91 1 1249065360 149721184 10814000
02:44:03 3648 8192000000 10176425072 10580353024 1096554976 11.805 100 53 107 1 1290944304 182032256 12357072
02:45:12 10399 8192000000 10224793136 10618241024 1086948288 11.714 99 60 118 2 1323277808 223691296 12638224
02:46:29 1475 8192000000 10282249600 10677420032 1111024624 11.942 100 73 141 2 1388637632 262578576 15034432
02:47:35 657 8192000000 10276641696 10686681088 1112904896 11.960 100 88 173 2 1374651408 241905360 19841152
02:48:39 4844 8192000000 10281621584 10709143552 1116559424 11.994 99 57 111 0 1393227024 262629872 14037728
02:49:53 5157 8192000000 10298914208 10717061120 1124270720 12.067 99 46 91 1 1396927760 261842544 10814496
02:50:59 17428 8192000000 10320494224 10783989760 1123174448 12.057 100 22 44 0 1421890624 293261216 5454960
02:52:21 10399 8192000000 10305039616 10758868992 1115771760 11.987 100 32 64 0 1407500704 283785888 7943056
02:53:54 25388 8192000000 10034261360 10452447232 1096705904 11.806 99 23 44 0 1156188000 54146336 5335760
02:55:25 46132 8192000000 10046033712 10498277376 1110809216 11.940 100 15 29 0 1162226720 48135664 3281840
02:57:11 12993 8192000000 10073398752 10483781632 1116000368 11.989 100 43 86 0 1166737904 42328976 8408560
02:58:28 84612 8192000000 10097327008 10558496768 1121105440 12.037 100 32 64 0 1205746976 77219808 7421728
03:00:55 13639 8192000000 10068153488 10525319168 1120220592 12.029 100 21 42 0 1176571504 51650448 4700464
03:02:10 24857 8192000000 10085847904 10517475328 1114970368 11.979 99 45 88 1 1160673520 36178528 9524624
03:03:39 64895 8192000000 10077538448 10529075200 1131268080 12.133 100 13 26 0 1193927168 59945376 2713712
03:05:45 18793 8192000000 10083313968 10568937472 1137335280 12.190 100 4 8 0 1186039968 47886176 818512
03:07:09 44967 8192000000 10081851136 10540273664 1139160304 12.208 100 18 34 0 1195283600 52448176 3675120
03:09:02 21301 8192000000 10084874176 10536226816 1138974000 12.206 99 32 64 0 1174717872 29829376 5914496
03:10:25 58849 8192000000 10073381776 10552217600 1103988640 11.875 96 5 10 0 1132996816 28086240 921936
03:12:29 56660 8192000000 10110359040 10593329152 1145141264 12.264 99 19 38 0 1257567120 108490784 3935072
03:14:27 35702 8192000000 10117227696 10573430784 1118118608 12.009 98 21 42 0 1206628304 84023504 4486192
03:16:04 13126 8192000000 10090624464 10518081536 1123019136 12.056 99 42 84 0 1171808304 40637856 8151312
03:17:18 9350 8192000000 10086905840 10511757312 1128222672 12.105 100 43 86 0 1175354048 38873296 8258080
03:18:31 15977 8192000000 10098306848 10547142656 1108516816 11.918 99 45 90 0 1201883680 84640544 8726320
03:19:50 93676 8192000000 10060995808 10574368768 1064504896 11.500 94 13 26 0 1112259904 44456016 3298992
03:22:30 89196 8192000000 10065716368 10488348672 1126281792 12.086 100 27 54 1 1172216320 40128064 5806464
03:25:00 14361 8192000000 10093417760 10528288768 1104259584 11.878 98 41 82 0 1184816864 72600320 7956960
03:26:15 63882 8192000000 10072181696 10554765312 1103812320 11.874 99 16 32 0 1218197760 111020848 3364592
03:28:36 54307 8192000000 9968862960 10433507328 974690208 10.632 89 8 16 1 1008344560 31971232 1683120
03:30:32 74572 8192000000 10062281264 10539003904 1091266800 11.755 100 16 32 0 1175954512 81047120 3640592
03:32:47 28115 8192000000 10042201056 10463993856 1078816576 11.636 98 45 84 1 1130930432 43862992 8250864
03:34:16 27702 8192000000 10023611632 10448048128 1070786320 11.560 99 38 75 1 1128127280 49903344 7437616
03:35:46 41756 8192000000 10056907648 10486501376 1063294672 11.488 97 23 46 0 1109693568 41854176 4544720
03:37:28 58388 8192000000 10039113024 10452791296 1079656640 11.644 98 21 42 0 1132266720 48911584 3698496
03:39:26 103595 8192000000 10078326240 10544107520 1100134672 11.839 99 16 32 0 1144966112 42115312 2716128
03:42:12 78614 8192000000 10073257616 10542878720 1121860992 12.045 100 31 61 1 1158954064 31449536 5643536
03:44:49 44500 8192000000 10079427440 10525310976 1124695840 12.071 100 32 63 2 1166306432 35678656 5931936
03:46:35 31747 8192000000 10069086576 10526519296 1133753776 12.157 100 8 16 0 1180540864 45092112 1694976
03:48:20 29913 8192000000 10065381104 10542895104 1122107552 12.047 99 7 14 0 1170974080 47301552 1564976
03:49:52 49240 8192000000 10069755856 10510110720 1123190112 12.057 99 19 38 0 1158151056 31354640 3606304
03:51:43 30278 8192000000 10089248432 10548002816 1129118640 12.113 99 20 40 0 1165914896 32920944 3875312
03:53:16 64493 8192000000 10105112384 10548969472 1087840272 11.722 95 32 64 0 1123265424 28436080 6989072
03:55:21 50319 8192000000 10062932608 10511900672 1115058064 11.980 99 20 40 0 1150042368 30856544 4127760
03:57:16 53822 8192000000 10069513488 10559729664 1100740256 11.845 97 28 56 0 1174592256 67849120 6002880
03:59:12 22471 8192000000 10096237008 10524852224 1138705392 12.203 100 53 104 0 1174041584 24793392 10542800
04:00:37 87020 8192000000 10102274000 10592415744 1129111488 12.113 99 18 36 0 1212774240 80276544 3386208
04:03:10 57176 8192000000 10079010672 10519220224 1099245152 11.830 97 25 50 0 1151962112 47648320 5068640
04:05:11 64205 8192000000 10027820672 10520428544 1080260976 11.650 97 5 10 0 1129961552 48646064 1054512
04:07:17 41461 8192000000 9080864432 9343942656 238543488 2.829 22 3 6 0 263165040 24012688 608864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 128 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-04-2024 04:10:01 to 11-04-2024 04:10:03.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Apr 11 04:10:04 2024 
 
Database header page information: 
    Flags            0 
    Generation        91216 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    174713 
    Oldest active        174714 
    Oldest snapshot        174714 
    Next transaction    174715 
    Sequence number        0 
    Next attachment ID    698 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.60, total records: 7752553 
    Average version length: 48.17, total versions: 59128, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89240 
    Data pages: 89240, average fill: 69% 
    Primary pages: 89239, secondary pages: 1, swept pages: 42364 
    Empty pages: 3, full pages: 67834 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 82 
    40 - 59% = 2311 
    60 - 79% = 86806 
    80 - 99% = 29 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23130, nodes: 7752553 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1680699, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 309 
        20 - 39% = 1681 
        40 - 59% = 4027 
        60 - 79% = 2406 
        80 - 99% = 14707 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13461, nodes: 7752553 
    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: 1505140, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1533 
        40 - 59% = 1984 
        60 - 79% = 1065 
        80 - 99% = 8878 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8277, nodes: 7752553 
    Average node length: 6.62, total dup: 5797003, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1498273, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 903 
        40 - 59% = 1353 
        60 - 79% = 892 
        80 - 99% = 5006 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.83, total records: 2245782 
    Average version length: 58.90, total versions: 28453, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28920 
    Data pages: 28920, average fill: 71% 
    Primary pages: 28918, secondary pages: 2, swept pages: 13225 
    Empty pages: 39, full pages: 16371 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 11 
    40 - 59% = 545 
    60 - 79% = 28277 
    80 - 99% = 36 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4519, nodes: 2245782 
    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: 680024, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 865 
        40 - 59% = 846 
        60 - 79% = 696 
        80 - 99% = 2112 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2461, nodes: 2246630 
    Average node length: 4.97, total dup: 2245732, max dup: 19308 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1260073, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 236 
        40 - 59% = 1436 
        60 - 79% = 550 
        80 - 99% = 237 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1798, nodes: 2245782 
    Average node length: 4.97, total dup: 2245732, max dup: 130309 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1070685, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 646 
        60 - 79% = 47 
        80 - 99% = 1098 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4350, nodes: 2245782 
    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: 680024, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 592 
        40 - 59% = 633 
        60 - 79% = 781 
        80 - 99% = 2244 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.38, total records: 400 
    Average version length: 29.91, total versions: 797, max versions: 2 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 40% 
    Primary pages: 14, secondary pages: 10, swept pages: 0 
    Empty pages: 11, full pages: 7 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 9 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 15.97, total records: 98161 
    Average version length: 68.30, total versions: 86633, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.51 
    Pointer pages: 6, data page slots: 2712 
    Data pages: 2024, average fill: 66% 
    Primary pages: 2023, secondary pages: 1, swept pages: 3 
    Empty pages: 171, full pages: 991 
    Fill distribution: 
     0 - 19% = 276 
    20 - 39% = 176 
    40 - 59% = 258 
    60 - 79% = 386 
    80 - 99% = 928 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703764, depth: 3, leaf buckets: 349, nodes: 98161 
    Average node length: 13.10, total dup: 7503, max dup: 2 
    Average key length: 10.69, compression ratio: 2.53 
    Average prefix length: 19.23, average data length: 7.77 
    Clustering factor: 73337, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 130 
        40 - 59% = 173 
        60 - 79% = 46 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 125, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 59% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.78, total records: 1843 
    Average version length: 43.66, total versions: 1699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.92 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 80% 
    Primary pages: 23, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 19 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91248, depth: 2, leaf buckets: 2, nodes: 1843 
    Average node length: 4.18, total dup: 1745, max dup: 226 
    Average key length: 2.56, compression ratio: 7.41 
    Average prefix length: 18.49, average data length: 0.51 
    Clustering factor: 941, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.58, total records: 77 
    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: 54% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 77 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.66, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.72, total records: 783232 
    Average version length: 37.93, total versions: 21327, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8344 
    Data pages: 8344, average fill: 64% 
    Primary pages: 8342, secondary pages: 2, swept pages: 2491 
    Empty pages: 11, full pages: 5321 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 74 
    40 - 59% = 829 
    60 - 79% = 7370 
    80 - 99% = 34 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 829, nodes: 773422 
    Average node length: 4.87, total dup: 773373, max dup: 138429 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89013, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 128 
        40 - 59% = 430 
        60 - 79% = 172 
        80 - 99% = 99 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 899, nodes: 773422 
    Average node length: 5.88, total dup: 688361, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156527, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 68 
        40 - 59% = 424 
        60 - 79% = 124 
        80 - 99% = 282 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 946, nodes: 773422 
    Average node length: 5.89, total dup: 688361, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158342, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 119 
        40 - 59% = 450 
        60 - 79% = 124 
        80 - 99% = 253 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1114, nodes: 773422 
    Average node length: 5.97, total dup: 688361, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151034, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 258 
        40 - 59% = 581 
        60 - 79% = 191 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.74, total records: 5488 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.58, total fragments: 19, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 78, secondary pages: 10, swept pages: 57 
    Empty pages: 6, full pages: 62 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5488 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.49, average data length: 1.55 
    Clustering factor: 5241, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5488 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 173, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 79641 
    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: 832 
    Data pages: 832, average fill: 66% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 827 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 827 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36653, depth: 2, leaf buckets: 102, nodes: 79641 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.84, average data length: 5.16 
    Clustering factor: 3068, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.58, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 141.72, total records: 161735 
    Average version length: 154.40, total versions: 10574, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 5, data page slots: 4632 
    Data pages: 4032, average fill: 83% 
    Primary pages: 4030, secondary pages: 2, swept pages: 8 
    Empty pages: 49, full pages: 3967 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3966 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 149.00, total records: 149812 
    Average version length: 150.82, total versions: 2215, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 4024 
    Data pages: 3720, average fill: 83% 
    Primary pages: 3717, secondary pages: 3, swept pages: 1 
    Empty pages: 30, full pages: 3674 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3674 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 144.79, total records: 169476 
    Average version length: 153.87, total versions: 7213, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 6, data page slots: 5280 
    Data pages: 4264, average fill: 82% 
    Primary pages: 4262, secondary pages: 2, swept pages: 6 
    Empty pages: 95, full pages: 4133 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 15 
    80 - 99% = 4134 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 148.65, total records: 155186 
    Average version length: 152.10, total versions: 2755, 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: 8, data page slots: 4872 
    Data pages: 3904, average fill: 82% 
    Primary pages: 3901, secondary pages: 3, swept pages: 5 
    Empty pages: 80, full pages: 3806 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3803 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 135.28, total records: 160314 
    Average version length: 154.89, total versions: 17525, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.54 
    Pointer pages: 7, data page slots: 4712 
    Data pages: 4016, average fill: 84% 
    Primary pages: 4014, secondary pages: 2, swept pages: 6 
    Empty pages: 60, full pages: 3926 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 13 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 3926 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.78, total records: 155074 
    Average version length: 137.09, total versions: 270, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 8, data page slots: 4976 
    Data pages: 3856, average fill: 83% 
    Primary pages: 3852, secondary pages: 4, swept pages: 8 
    Empty pages: 39, full pages: 3799 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3798 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 150.64, total records: 149679 
    Average version length: 138.07, total versions: 179, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 6, data page slots: 4608 
    Data pages: 3728, average fill: 82% 
    Primary pages: 3726, secondary pages: 2, swept pages: 8 
    Empty pages: 53, full pages: 3660 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3661 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 148.23, total records: 167093 
    Average version length: 152.45, total versions: 3417, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 8, data page slots: 5640 
    Data pages: 4184, average fill: 82% 
    Primary pages: 4182, secondary pages: 2, swept pages: 3 
    Empty pages: 66, full pages: 4094 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 11 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4094 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 135.02, total records: 165119 
    Average version length: 154.56, total versions: 18328, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.56 
    Pointer pages: 5, data page slots: 4736 
    Data pages: 4104, average fill: 84% 
    Primary pages: 4100, secondary pages: 4, swept pages: 1 
    Empty pages: 39, full pages: 4049 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 4050 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 149.17, total records: 159681 
    Average version length: 152.12, total versions: 2085, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 6, data page slots: 4840 
    Data pages: 3992, average fill: 82% 
    Primary pages: 3990, secondary pages: 2, swept pages: 2 
    Empty pages: 60, full pages: 3912 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3912 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.20, total records: 2107723 
    Average version length: 52.91, total versions: 26608, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25624 
    Data pages: 25624, average fill: 71% 
    Primary pages: 25616, secondary pages: 8, swept pages: 11168 
    Empty pages: 92, full pages: 22624 
    Fill distribution: 
     0 - 19% = 161 
    20 - 39% = 184 
    40 - 59% = 681 
    60 - 79% = 24356 
    80 - 99% = 242 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2593, nodes: 2107723 
    Average node length: 5.44, total dup: 1966984, max dup: 1649 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183360, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 284 
        40 - 59% = 1718 
        60 - 79% = 303 
        80 - 99% = 285 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2769, nodes: 2107723 
    Average node length: 5.69, total dup: 1891639, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377387, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2399 
        60 - 79% = 338 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2119, nodes: 2107723 
    Average node length: 4.96, total dup: 2107623, max dup: 28143 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180916, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 178 
        40 - 59% = 1127 
        60 - 79% = 385 
        80 - 99% = 429 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 48.14, total records: 133955 
    Average version length: 69.16, total versions: 46901, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.62 
    Pointer pages: 3, data page slots: 3792 
    Data pages: 2960, average fill: 54% 
    Primary pages: 2960, secondary pages: 0, swept pages: 370 
    Empty pages: 315, full pages: 1066 
    Fill distribution: 
     0 - 19% = 481 
    20 - 39% = 361 
    40 - 59% = 622 
    60 - 79% = 945 
    80 - 99% = 551 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 332685, depth: 3, leaf buckets: 232, nodes: 133955 
    Average node length: 6.52, total dup: 116414, max dup: 14 
    Average key length: 3.98, compression ratio: 10.56 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 23496, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 74 
        40 - 59% = 119 
        60 - 79% = 37 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.79, total records: 6838547 
    Average version length: 68.74, total versions: 247143, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 64, data page slots: 104072 
    Data pages: 104072, average fill: 70% 
    Primary pages: 104070, secondary pages: 2, swept pages: 34243 
    Empty pages: 8, full pages: 57374 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 445 
    40 - 59% = 8632 
    60 - 79% = 94424 
    80 - 99% = 522 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10598, nodes: 6838547 
    Average node length: 6.52, total dup: 5912990, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1612824, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1857 
        40 - 59% = 5920 
        60 - 79% = 2391 
        80 - 99% = 422 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8410, nodes: 6838547 
    Average node length: 5.40, total dup: 6561725, max dup: 128 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1424689, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1325 
        40 - 59% = 4696 
        60 - 79% = 1462 
        80 - 99% = 920 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8466, nodes: 6838547 
    Average node length: 5.40, total dup: 6561725, max dup: 128 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1427080, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1394 
        40 - 59% = 4660 
        60 - 79% = 1455 
        80 - 99% = 950 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.78, total records: 11820114 
    Average version length: 68.74, total versions: 229432, 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: 106, data page slots: 172640 
    Data pages: 172640, average fill: 73% 
    Primary pages: 172639, secondary pages: 1, swept pages: 79600 
    Empty pages: 4, full pages: 137846 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 548 
    40 - 59% = 6172 
    60 - 79% = 164650 
    80 - 99% = 1237 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18283, nodes: 11818354 
    Average node length: 6.60, total dup: 10302102, max dup: 51 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2441845, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 2580 
        40 - 59% = 10817 
        60 - 79% = 4144 
        80 - 99% = 728 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 52.73, total records: 1407874 
    Average version length: 69.07, total versions: 217998, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.39 
    Pointer pages: 25, data page slots: 40336 
    Data pages: 28440, average fill: 51% 
    Primary pages: 28365, secondary pages: 75, swept pages: 11029 
    Empty pages: 3448, full pages: 14925 
    Fill distribution: 
     0 - 19% = 5735 
    20 - 39% = 4250 
    40 - 59% = 3437 
    60 - 79% = 12362 
    80 - 99% = 2656 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1843, nodes: 1241630 
    Average node length: 5.53, total dup: 1191180, max dup: 49 
    Average key length: 2.58, compression ratio: 16.29 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 87459, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 613 
        40 - 59% = 902 
        60 - 79% = 297 
        80 - 99% = 14 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 44.70, total records: 1106379 
    Average version length: 68.99, total versions: 127446, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.82 
    Pointer pages: 20, data page slots: 31432 
    Data pages: 26256, average fill: 39% 
    Primary pages: 26256, secondary pages: 0, swept pages: 7124 
    Empty pages: 4018, full pages: 4882 
    Fill distribution: 
     0 - 19% = 6603 
    20 - 39% = 5292 
    40 - 59% = 8483 
    60 - 79% = 5781 
    80 - 99% = 97 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1222, nodes: 785480 
    Average node length: 5.94, total dup: 723988, max dup: 59 
    Average key length: 3.00, compression ratio: 13.99 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 110150, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 405 
        40 - 59% = 553 
        60 - 79% = 240 
        80 - 99% = 21 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.64, total records: 9213216 
    Average version length: 68.94, total versions: 342851, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 87, data page slots: 141768 
    Data pages: 141728, average fill: 70% 
    Primary pages: 141715, secondary pages: 13, swept pages: 57160 
    Empty pages: 200, full pages: 69622 
    Fill distribution: 
     0 - 19% = 606 
    20 - 39% = 1926 
    40 - 59% = 13147 
    60 - 79% = 124518 
    80 - 99% = 1531 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13482, nodes: 9208638 
    Average node length: 6.67, total dup: 7638377, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2095748, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1198 
        40 - 59% = 6935 
        60 - 79% = 4723 
        80 - 99% = 623 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21132711 
    Average version length: 83.02, total versions: 6248, 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: 319616 
    Data pages: 319616, average fill: 81% 
    Primary pages: 319613, secondary pages: 3, swept pages: 13631 
    Empty pages: 50, full pages: 318631 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 53 
    40 - 59% = 125 
    60 - 79% = 49160 
    80 - 99% = 270207 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19189, nodes: 21132711 
    Average node length: 5.72, total dup: 20651937, max dup: 143 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280072, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 7776 
        60 - 79% = 513 
        80 - 99% = 10895 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17169, nodes: 21132711 
    Average node length: 6.31, total dup: 18570089, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916827, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 794 
        60 - 79% = 277 
        80 - 99% = 16092 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20977, nodes: 21132711 
    Average node length: 6.35, total dup: 18489873, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3574446, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8056 
        60 - 79% = 603 
        80 - 99% = 12312 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16068, nodes: 21132711 
    Average node length: 5.56, total dup: 21132611, max dup: 228893 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945670, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 14 
        40 - 59% = 2867 
        60 - 79% = 342 
        80 - 99% = 12845 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.45, total records: 9577352 
    Average version length: 82.61, total versions: 256662, 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: 104, data page slots: 169008 
    Data pages: 168976, average fill: 70% 
    Primary pages: 168951, secondary pages: 25, swept pages: 87034 
    Empty pages: 574, full pages: 96211 
    Fill distribution: 
     0 - 19% = 1567 
    20 - 39% = 5474 
    40 - 59% = 21215 
    60 - 79% = 122469 
    80 - 99% = 18251 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11337, nodes: 9577352 
    Average node length: 5.36, total dup: 9269486, max dup: 190 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2158940, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 21 
        40 - 59% = 8615 
        60 - 79% = 2619 
        80 - 99% = 80 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13279, nodes: 9577352 
    Average node length: 6.22, total dup: 7941622, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1511141, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 3786 
        40 - 59% = 4296 
        60 - 79% = 2662 
        80 - 99% = 2411 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12655, nodes: 9577352 
    Average node length: 5.98, total dup: 8306096, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2345985, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 45 
        40 - 59% = 9566 
        60 - 79% = 2923 
        80 - 99% = 117 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10091, nodes: 9577352 
    Average node length: 5.13, total dup: 9577252, max dup: 156679 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1532984, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1308 
        40 - 59% = 5004 
        60 - 79% = 1790 
        80 - 99% = 1951 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.95, total records: 11327031 
    Average version length: 82.61, total versions: 209256, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 118, data page slots: 190984 
    Data pages: 189424, average fill: 73% 
    Primary pages: 189327, secondary pages: 97, swept pages: 63675 
    Empty pages: 2036, full pages: 151141 
    Fill distribution: 
     0 - 19% = 3653 
    20 - 39% = 5500 
    40 - 59% = 13687 
    60 - 79% = 102634 
    80 - 99% = 63950 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13124, nodes: 11327031 
    Average node length: 5.31, total dup: 11217235, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2370634, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 91 
        40 - 59% = 9113 
        60 - 79% = 3761 
        80 - 99% = 159 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10438, nodes: 11327031 
    Average node length: 5.50, total dup: 10832437, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 725163, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 158 
        20 - 39% = 795 
        40 - 59% = 2617 
        60 - 79% = 1770 
        80 - 99% = 5098 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15014, nodes: 11327031 
    Average node length: 6.03, total dup: 9884072, max dup: 73 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2387061, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 125 
        40 - 59% = 10593 
        60 - 79% = 4125 
        80 - 99% = 170 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10822, nodes: 11327031 
    Average node length: 5.23, total dup: 11326931, max dup: 191131 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 713950, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 824 
        40 - 59% = 4841 
        60 - 79% = 1490 
        80 - 99% = 3560 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.86, total records: 9683081 
    Average version length: 82.87, total versions: 246972, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 107, data page slots: 173072 
    Data pages: 173008, average fill: 69% 
    Primary pages: 172983, secondary pages: 25, swept pages: 91703 
    Empty pages: 599, full pages: 96163 
    Fill distribution: 
     0 - 19% = 1773 
    20 - 39% = 6951 
    40 - 59% = 23956 
    60 - 79% = 122898 
    80 - 99% = 17430 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11752, nodes: 9683081 
    Average node length: 5.17, total dup: 9654429, max dup: 1631 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1968084, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1509 
        40 - 59% = 7864 
        60 - 79% = 1753 
        80 - 99% = 591 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13401, nodes: 9683081 
    Average node length: 6.24, total dup: 8029567, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1479561, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 3763 
        40 - 59% = 4258 
        60 - 79% = 2659 
        80 - 99% = 2543 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12355, nodes: 9683081 
    Average node length: 5.43, total dup: 9247832, max dup: 91 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2100200, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1391 
        40 - 59% = 8788 
        60 - 79% = 1604 
        80 - 99% = 547 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10222, nodes: 9683081 
    Average node length: 5.14, total dup: 9682981, max dup: 158571 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1563915, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1309 
        40 - 59% = 5159 
        60 - 79% = 1758 
        80 - 99% = 1967 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.71, total records: 574727 
    Average version length: 68.85, total versions: 4405, 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: 8064 
    Data pages: 8064, average fill: 75% 
    Primary pages: 8064, secondary pages: 0, swept pages: 3709 
    Empty pages: 6, full pages: 6874 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 11 
    40 - 59% = 145 
    60 - 79% = 7834 
    80 - 99% = 68 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43925, depth: 3, leaf buckets: 737, nodes: 574727 
    Average node length: 5.95, total dup: 489198, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 101316, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 523 
        60 - 79% = 93 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31803, depth: 3, leaf buckets: 752, nodes: 574727 
    Average node length: 6.15, total dup: 471420, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101363, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 537 
        60 - 79% = 88 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 557, nodes: 574727 
    Average node length: 4.86, total dup: 574627, max dup: 9297 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90166, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 26 
        40 - 59% = 312 
        60 - 79% = 86 
        80 - 99% = 132 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Apr 11 04:10:28 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7752553 59128 1 0.0000 0.0000
DOC_LIST 2245782 28453 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 797 2 100.0000 0.0000
INVNT_TURNOVER_LOG 98161 86633 1 0.0000 0.0000
MONEY_SALDO 49 125 4 200.0000 0.0000
MONEY_TURNOVER_LOG 1843 1699 1 0.0000 0.0000
PDISTR 783232 21327 2 0.0000 0.0000
PERF_SPLIT_0 161735 10574 1 0.0000 0.0000
PERF_SPLIT_1 149812 2215 1 0.0000 0.0000
PERF_SPLIT_2 169476 7213 1 0.0000 0.0000
PERF_SPLIT_3 155186 2755 1 0.0000 0.0000
PERF_SPLIT_4 160314 17525 1 0.0000 0.0000
PERF_SPLIT_5 155074 270 1 0.0000 0.0000
PERF_SPLIT_6 149679 179 1 0.0000 0.0000
PERF_SPLIT_7 167093 3417 1 0.0000 0.0000
PERF_SPLIT_8 165119 18328 1 0.0000 0.0000
PERF_SPLIT_9 159681 2085 1 0.0000 0.0000
PSTORNED 2107723 26608 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 133955 46901 1 0.0000 0.0000
XQD_1000_3300 6838547 247143 1 0.0000 0.0000
XQD_1200_2000 11820114 229432 1 0.0000 0.0000
XQD_2000_3300 1407874 217998 1 0.0000 0.0000
XQD_2100_3300 1106379 127446 1 0.0000 0.0000
XQD_3300_3400 9213216 342851 1 0.0000 0.0000
XQS_1000_1200 21132711 6248 1 0.0000 0.0000
XQS_1000_3300 9577352 256662 1 0.0000 0.0000
XQS_1200_2000 11327031 209256 1 0.0000 0.0000
XQS_2100_3300 9683081 246972 1 0.0000 0.0000
XQS_3300_3400 574727 4405 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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