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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-13 16:09:43
DTS_END                         2024-04-13 16:09:43.7420
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_INVNT_SALDO(40:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50562
TRN_ID                          172118
ATT_ID                          586
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 8976.87 25163 897687
customer order: creation 166.66 365 16666
customer order: refuse 14.41 415 1441
order to supplier: creation 44.47 1307 4447
order to supplier: removal 3.28 104843 328
invoice (draft): creation 45.39 3329 4539
invoice (draft): removal 47.98 834 4798
invoice accept: apply 42.25 21247 4225
invoice accept: cancel 43.54 810 4354
customer reserve: creation 3985.96 207 398596
customer reserve: removal 4289.52 63 428952
realization accept: apply 83.19 173 8319
realization accept: cancel 82.86 119 8286
payment from customer: creation 58.88 108 5888
payment from customer: removal 5.63 103 563
payment to supplier: creation 47.29 146 4729
payment to supplier: removal 3.42 75 342
service: total inventory turnovers 4.99 1140 499
service: total monetary turnovers 6.36 49 636
service: aggregate perf. data 0.76 23830 76
service: refresh index statistics 0.03 344101 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-04-2024 16:11:12 to 13-04-2024 16:11:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2511
TEST_TIME 2 2735
TEST_TIME 3 4004
TEST_TIME 4 3883
TEST_TIME 5 4286
TEST_TIME 6 5150
TEST_TIME 7 4822
TEST_TIME 8 4745
TEST_TIME 9 4887
TEST_TIME 10 4948
TEST_TIME 11 5309
TEST_TIME 12 5781
TEST_TIME 13 5876
TEST_TIME 14 6133
TEST_TIME 15 6584
TEST_TIME 16 6766
TEST_TIME 17 7312
TEST_TIME 18 7237
TEST_TIME 19 7461
TEST_TIME 20 7462
TEST_TIME 21 7679
TEST_TIME 22 7766
TEST_TIME 23 8132
TEST_TIME 24 8207
TEST_TIME 25 8133
TEST_TIME 26 8515
TEST_TIME 27 8898
TEST_TIME 28 9539
TEST_TIME 29 9313
TEST_TIME 30 9299
TEST_TIME 31 9428
TEST_TIME 32 9218
TEST_TIME 33 9213
TEST_TIME 34 9276
TEST_TIME 35 9202
TEST_TIME 36 9008
TEST_TIME 37 9155
TEST_TIME 38 9049
TEST_TIME 39 8939
TEST_TIME 40 8759
TEST_TIME 41 8794
TEST_TIME 42 8849
TEST_TIME 43 8927
TEST_TIME 44 8937
TEST_TIME 45 8912
TEST_TIME 46 8798
TEST_TIME 47 8683
TEST_TIME 48 8683
TEST_TIME 49 8655
TEST_TIME 50 8714
TEST_TIME 51 8685
TEST_TIME 52 8848
TEST_TIME 53 8784
TEST_TIME 54 8880
TEST_TIME 55 8834
TEST_TIME 56 8839
TEST_TIME 57 8910
TEST_TIME 58 8947
TEST_TIME 59 8879
TEST_TIME 60 8912
TEST_TIME 61 8982
TEST_TIME 62 8971
TEST_TIME 63 8962
TEST_TIME 64 8855
TEST_TIME 65 8896
TEST_TIME 66 8871
TEST_TIME 67 8810
TEST_TIME 68 8784
TEST_TIME 69 8759
TEST_TIME 70 8739
TEST_TIME 71 8689
TEST_TIME 72 8785
TEST_TIME 73 8813
TEST_TIME 74 8817
TEST_TIME 75 8850
TEST_TIME 76 8943
TEST_TIME 77 8906
TEST_TIME 78 8994
TEST_TIME 79 9015
TEST_TIME 80 9052
TEST_TIME 81 9011
TEST_TIME 82 9110
TEST_TIME 83 9120
TEST_TIME 84 9117
TEST_TIME 85 9148
TEST_TIME 86 9168
TEST_TIME 87 9263
TEST_TIME 88 9170
TEST_TIME 89 9086
TEST_TIME 90 9086
TEST_TIME 91 9049
TEST_TIME 92 9093
TEST_TIME 93 9053
TEST_TIME 94 9054
TEST_TIME 95 9028
TEST_TIME 96 8997
TEST_TIME 97 8980
TEST_TIME 98 8963
TEST_TIME 99 9013
TEST_TIME 100 8984

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-04-2024 16:11:16 to 13-04-2024 16:11:19.

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 1260886 1260886 0 0.00 0 21824 7 0 0
doc_list_biud 1260885 1260885 0 0.00 0 27298 27 0 0
sp_add_invoice_to_stock 4332 4225 107 2.46 31 205285 21247 0 107
sp_cancel_adding_invoice 4354 4354 0 0.00 4 65065 811 0 0
sp_cancel_client_order 1441 1441 0 0.00 4 13014 416 0 0
sp_cancel_customer_reserve 428952 428952 0 0.00 0 23189 64 0 0
sp_cancel_pay_from_customer 563 563 0 0.00 3 12003 103 0 0
sp_cancel_pay_to_supplier 342 342 0 0.00 3 1313 76 0 0
sp_cancel_supplier_invoice 4806 4798 8 0.16 2 27308 835 0 8
sp_cancel_supplier_order 328 328 0 0.00 8 915883 104843 0 0
sp_cancel_write_off 8286 8286 0 0.00 1 13901 120 0 0
sp_client_order 16666 16666 0 0.00 3 32740 366 0 0
sp_customer_reserve 398596 398596 0 0.00 0 47535 207 0 0
sp_fill_shopping_cart 25646 25646 0 0.00 1 17235 38 0 0
sp_fill_shopping_cart_clo_res 398588 398588 0 0.00 0 22796 16 0 0
sp_get_clo_for_invoice 4213 4213 0 0.00 0 24921 324 0 0
sp_kill_cost_storno 13545 13545 0 0.00 0 5600 58 0 0
sp_kill_qstorno_ret_qs2qd 871316 871316 0 0.00 0 27293 35 0 0
sp_kill_qty_storno 460690 460690 0 0.00 0 27296 74 0 0
sp_lock_selected_doc 17243 17243 0 0.00 0 6652 5 0 0
sp_make_cost_storno 23148 23148 0 0.00 0 17725 56 0 0
sp_multiply_rows_for_pdistr 23148 23148 0 0.00 0 8784 29 0 0
sp_multiply_rows_for_qdistr 16666 16666 0 0.00 0 14251 141 0 0
sp_pay_from_customer 5888 5888 0 0.00 4 11182 109 0 0
sp_pay_to_supplier 4729 4729 0 0.00 4 25848 147 0 0
sp_payment_common 10617 10617 0 0.00 1 25832 25 0 0
sp_qd_handle_on_cancel_clo 1441 1441 0 0.00 0 13004 380 0 0
sp_qd_handle_on_invoice_upd_sts 8566 8566 0 0.00 0 18161 332 0 0
sp_qd_handle_on_reserve_upd_sts 8319 8319 0 0.00 0 10885 60 0 0
sp_reserve_write_off 8319 8319 0 0.00 6 21835 174 0 0
sp_supplier_invoice 4539 4539 0 0.00 8 78968 3330 0 0
sp_supplier_order 4447 4447 0 0.00 4 40233 1307 0 0
srv_aggregate_perf_data 77 76 1 1.29 1558 225661 23831 0 1
srv_fill_mon_cache_memory 58 58 0 0.00 2493 123102 35813 0 0
srv_find_qd_qs_mism 855032 855032 0 0.00 0 21452 7 0 0
srv_make_invnt_saldo 499 499 0 0.00 39 72651 1140 0 0
srv_make_money_saldo 636 636 0 0.00 1 8398 49 0 0
srv_recalc_idx_stat 3 3 0 0.00 264667 456093 344101 0 0
t$perf-abend:sp_add_invoice_to_stock 107 107 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 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 4225 4225 0 0.00 0 9031 195 0 0
t$perf-norm:sp_cancel_adding_invoice 319 319 0 0.00 0 15983 147 0 0
t$perf-norm:sp_cancel_client_order 1441 1441 0 0.00 0 5162 18 0 0
t$perf-norm:sp_cancel_customer_reserve 564 564 0 0.00 0 1576 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 563 563 0 0.00 0 655 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 342 342 0 0.00 0 700 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 337 337 0 0.00 0 3499 23 0 0
t$perf-norm:sp_cancel_supplier_order 328 328 0 0.00 0 30513 1911 0 0
t$perf-norm:sp_cancel_write_off 819 819 0 0.00 0 855 8 0 0
t$perf-norm:sp_client_order 16666 16666 0 0.00 0 11446 17 0 0
t$perf-norm:sp_customer_reserve 789 789 0 0.00 0 2841 7 0 0
t$perf-norm:sp_pay_from_customer 5888 5888 0 0.00 0 2076 7 0 0
t$perf-norm:sp_pay_to_supplier 4729 4729 0 0.00 0 6607 13 0 0
t$perf-norm:sp_reserve_write_off 8319 8319 0 0.00 0 10362 15 0 0
t$perf-norm:sp_supplier_invoice 4539 4539 0 0.00 0 3541 20 0 0
t$perf-norm:sp_supplier_order 4447 4447 0 0.00 0 16435 21 0 0
t$perf-norm:srv_aggregate_perf_data 76 76 0 0.00 0 300 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 13 1 0 0
t$perf-norm:srv_make_invnt_saldo 499 499 0 0.00 0 2750 35 0 0
t$perf-norm:srv_make_money_saldo 636 636 0 0.00 0 945 19 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 4 82 34 0 0
v_add_invoice_to_stock 8636 8422 214 2.47 0 5177 21 0 214
v_all_customers 30804 30804 0 0.00 0 27 1 0 0
v_all_suppliers 25122 25122 0 0.00 0 19 1 0 0
v_all_wares 33332 33332 0 0.00 0 119 1 0 0
v_cancel_adding_invoice 638 638 0 0.00 0 2454 19 0 0
v_cancel_client_order 2882 2882 0 0.00 0 3451 10 0 0
v_cancel_customer_prepayment 1126 1126 0 0.00 0 4377 9 0 0
v_cancel_customer_reserve 1128 1128 0 0.00 0 4541 11 0 0
v_cancel_payment_to_supplier 684 684 0 0.00 0 296 4 0 0
v_cancel_supplier_invoice 690 674 16 2.31 0 1514 16 0 16
v_cancel_supplier_order 656 656 0 0.00 0 1100 8 0 0
v_cancel_write_off 1638 1638 0 0.00 0 6781 16 0 0
v_max_id_clo_ord 4447 4447 0 0.00 0 3068 2 0 0
v_max_id_clo_res 789 789 0 0.00 0 951 5 0 0
v_max_id_ord_sup 4532 4532 0 0.00 0 2668 2 0 0
v_max_non_paid_invoice 1147 1147 0 0.00 0 789 4 0 0
v_max_non_paid_realizn 2961 2961 0 0.00 0 799 4 0 0
v_min_id_clo_ord 4447 4447 0 0.00 0 1275 5 0 0
v_min_id_clo_res 789 789 0 0.00 0 1875 8 0 0
v_min_id_ord_sup 4532 4532 0 0.00 0 4654 7 0 0
v_min_non_paid_invoice 4729 4729 0 0.00 0 25828 22 0 0
v_min_non_paid_realizn 5888 5888 0 0.00 0 7953 17 0 0
v_our_firm 8382 8382 0 0.00 0 18 1 0 0
v_reserve_write_off 16638 16638 0 0.00 0 3812 7 0 0
x_lock_depdocs_on_canc_invoice 8815 8815 0 0.00 0 12368 138 0 0
x_lock_depdocs_on_canc_sup_ord 328 328 0 0.00 0 5486 364 0 0
x_make_qstorno_1000_1200 4447 4447 0 0.00 1 40176 1228 0 0
x_make_qstorno_1200_2000 4539 4539 0 0.00 3 78926 3194 0 0
x_make_qstorno_2100_3300 398596 398596 0 0.00 0 38773 188 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-04-2024 16:11:20 to 13-04-2024 16:11:24.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:09:47 7 8192000000 8798878432 8810168320 5304288 0.064 2 1 2 0 5403888 56816 42784
14:10:48 32404 8192000000 9899489056 10209280000 984086656 10.724 100 92 184 0 1013897600 5845072 23965872
14:12:24 10137 8192000000 9940939232 10259759104 1024258144 11.113 100 92 184 0 1055844496 8238864 23347488
14:13:37 16433 8192000000 9977716272 10307878912 1053880352 11.398 100 84 168 0 1084226256 9514928 20830976
14:15:00 12058 8192000000 10019776752 10361413632 1105100432 11.886 100 82 162 1 1135464912 11008208 19356272
14:16:15 10065 8192000000 10055102304 10409541632 1147598176 12.287 100 71 142 0 1175306032 11846656 15861200
14:17:30 3879 8192000000 10116635888 10481278976 1201820032 12.793 100 83 165 2 1234064192 13564880 18679280
14:18:36 1393 8192000000 10157873552 10530652160 1242350256 13.168 100 85 169 0 1274035600 12970592 18714752
14:19:42 2404 8192000000 10172777040 10551947264 1266132368 13.386 100 80 158 1 1296121968 13508208 16481392
14:20:46 1207 8192000000 10206551376 10590695424 1292038752 13.623 100 92 184 0 1326110560 13915216 20156592
14:21:49 4669 8192000000 10196655808 10591989760 1297548880 13.673 100 62 121 1 1316937280 5753296 13635104
14:22:55 3600 8192000000 10212735488 10617417728 1313380320 13.817 100 47 94 0 1331750848 8153200 10217328
14:24:02 3085 8192000000 10206529616 10619842560 1316492208 13.845 100 41 83 0 1334024320 8723968 8808144
14:25:06 9467 8192000000 10211093232 10621321216 1319736464 13.874 100 25 50 0 1331610016 5398880 6474672
14:26:16 1093 8192000000 10228650464 10633035776 1322016288 13.895 100 59 118 1 1342588608 7673824 12898496
14:27:17 4107 8192000000 10219808080 10635616256 1325699104 13.928 100 30 59 0 1343051664 10215760 7136800
14:28:24 7222 8192000000 10221726624 10646597632 1330822240 13.975 100 29 58 0 1347960896 10402608 6736048
14:29:34 66230 8192000000 10225755296 10635476992 1314751680 13.829 99 41 81 0 1330497232 7005856 8739696
14:31:45 17380 8192000000 10228763712 10640990208 1315118880 13.832 99 46 92 0 1341562832 15980096 10463856
14:33:10 9791 8192000000 10260781328 10669813760 1347915808 14.129 100 54 108 0 1375447216 15281472 12249936
14:34:28 17125 8192000000 10240753440 10643030016 1295411904 13.654 96 56 112 1 1324466976 16216720 12838352
14:35:52 11494 8192000000 10254737744 10674659328 1345971936 14.111 100 36 72 0 1374379232 18988496 9418800
14:37:06 8077 8192000000 10246488784 10652880896 1319492544 13.872 99 49 98 0 1349554784 18440352 11621888
14:38:18 11125 8192000000 10219783216 10618036224 1268381312 13.407 95 44 84 3 1300512720 22296384 9835024
14:39:33 12509 8192000000 10235491184 10632060928 1305922256 13.749 100 57 113 0 1349272240 29541696 13808288
14:40:48 20132 8192000000 10236781584 10646487040 1288677136 13.592 97 38 76 1 1324281664 26218304 9386224
14:42:11 18250 8192000000 10250186832 10655129600 1312424432 13.808 98 60 116 1 1354133808 27526352 14183024
14:43:33 4814 8192000000 10289415968 10693128192 1344610160 14.099 100 70 139 1 1395568624 34724928 16233536
14:44:42 2489 8192000000 10288103776 10687741952 1343020656 14.085 100 82 163 0 1391952176 28985168 19946352
14:45:50 3209 8192000000 10315379760 10718089216 1364873168 14.281 100 84 165 2 1419749104 34850352 20025584
14:47:00 4332 8192000000 10317984832 10727387136 1375495344 14.376 100 75 151 0 1424553008 30947776 18109888
14:48:07 4561 8192000000 10332084912 10745626624 1390894496 14.514 100 74 139 0 1438776272 30096544 17785232
14:49:16 2688 8192000000 10356787328 10770767872 1408894656 14.674 100 87 172 0 1462576144 32838384 20843104
14:50:25 12565 8192000000 10340732848 10764533760 1389950768 14.505 99 42 83 0 1438442912 37946672 10545472
14:51:42 5155 8192000000 10340747152 10760929280 1396814560 14.567 100 57 116 0 1447188608 35777712 14596336
14:52:54 13697 8192000000 10321220192 10767667200 1393518608 14.537 100 21 42 0 1436310384 36808592 5983184
14:54:26 5423 8192000000 10341007136 10761498624 1388272720 14.490 100 63 124 0 1441572832 37414624 15885488
14:55:37 16590 8192000000 10332460304 10775056384 1393279264 14.535 100 15 30 0 1436978192 39171808 4527120
14:57:05 45438 8192000000 10314340736 10766303232 1395882800 14.558 100 16 32 1 1430732480 30758624 4091056
14:58:52 18451 8192000000 10318662032 10761916416 1394530064 14.546 100 47 90 2 1421472768 16068512 10874192
15:00:17 7861 8192000000 10318109440 10764152832 1400656816 14.601 100 61 119 1 1428324832 12742608 14925408
15:01:28 25451 8192000000 10321918128 10764406784 1401090560 14.605 100 28 56 0 1419003856 11363392 6549904
15:03:19 96491 8192000000 10313470064 10784616448 1406773440 14.655 100 14 26 0 1425277248 15655888 2847920
15:06:02 63880 8192000000 10312660880 10776342528 1402237936 14.615 99 32 64 0 1421316144 11930544 7147664
15:08:10 42335 8192000000 10320599952 10780090368 1420219200 14.775 100 26 52 1 1437786096 11879072 5687824
15:10:03 15483 8192000000 10327994144 10783715328 1421685968 14.788 100 16 30 0 1437009616 11489552 3834096
15:11:22 37666 8192000000 10326121664 10783444992 1407877712 14.665 99 18 36 0 1427039712 14864416 4297584
15:13:08 62990 8192000000 10302977552 10764619776 1380098976 14.417 98 16 32 0 1396390640 12949328 3342336
15:15:19 79962 8192000000 10305868096 10761039872 1385966848 14.470 98 18 36 1 1397969968 8178752 3824368
15:17:44 34361 8192000000 10300082816 10765910016 1402190768 14.614 100 16 30 0 1416286016 10332672 3762576
15:19:32 18411 8192000000 10289849936 10740862976 1372282736 14.347 98 44 87 1 1392169248 9684080 10202432
15:20:56 45342 8192000000 10293205536 10749304832 1355157248 14.194 97 16 32 0 1380322704 21363296 3802160
15:22:52 43736 8192000000 10295249472 10753245184 1393379856 14.536 100 20 40 0 1407837872 9963760 4494256
15:24:42 10721 8192000000 10278858496 10721734656 1329612096 13.964 95 44 88 0 1348320368 8246944 10461328
15:25:53 48487 8192000000 10263690928 10708996096 1299404144 13.690 95 23 46 0 1319125008 14383056 5337808
15:27:42 70055 8192000000 10251518272 10689277952 1267758320 13.401 94 19 37 0 1286471872 14666688 4046864
15:29:59 74880 8192000000 10264322592 10705653760 1331416480 13.980 99 22 44 0 1347561568 11187888 4957200
15:32:14 83638 8192000000 10249966448 10691411968 1276405600 13.480 94 23 46 0 1291317744 10101424 4810720
15:35:10 72807 8192000000 10247465552 10693226496 1299997648 13.695 96 22 44 0 1315768800 11161328 4609824
15:37:33 21241 8192000000 10245182224 10680791040 1310488240 13.791 97 36 68 0 1329830000 11584992 7756768
15:38:59 69793 8192000000 10269565600 10721763328 1349026320 14.139 99 15 28 1 1367688320 15730912 2931088
15:42:05 39261 8192000000 10260617376 10695196672 1326968400 13.940 97 22 39 0 1346872272 15872400 4031472
15:43:49 18577 8192000000 10285372128 10723823616 1378474944 14.403 100 26 51 1 1396440880 11972704 5993232
15:45:14 39091 8192000000 10294006496 10745204736 1384386096 14.456 100 26 53 2 1408780048 18027008 6366944
15:46:54 45519 8192000000 10299082880 10746916864 1394950352 14.550 100 30 60 0 1417072448 15167824 6954272
15:48:53 53879 8192000000 10306516400 10763149312 1385358832 14.464 99 19 38 0 1405262304 15528976 4374496
15:51:09 48345 8192000000 10317096672 10773843968 1405902368 14.648 100 24 48 1 1423248240 12044528 5301344
15:52:59 123097 8192000000 10322410752 10770042880 1379711264 14.414 98 25 51 0 1401093728 15879696 5502768
15:57:19 90036 8192000000 10285448032 10731229184 1367351216 14.303 98 21 42 0 1380388912 8049408 4988288
16:00:00 14688 8192000000 10306845888 10749517824 1376994816 14.390 99 50 96 1 1404825040 15799872 12030352
16:01:18 60887 8192000000 10291438608 10761355264 1371779984 14.343 99 8 16 0 1396397072 22612880 2004208
16:03:19 39654 8192000000 10282606128 10737774592 1375361280 14.375 99 12 24 1 1390007120 11607104 3038736
16:05:08 46663 8192000000 10293629600 10749861888 1377665696 14.396 99 26 51 0 1394872064 10898336 6308032
16:07:07 71778 8192000000 10292945728 10768527360 1383867136 14.451 99 15 30 0 1405232320 17730192 3634992
16:09:20 28487 8192000000 9158868368 9397121024 308808928 3.632 23 10 18 0 313251424 3037600 1404896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 107 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-04-2024 16:11:41 to 13-04-2024 16:11:43.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sat Apr 13 16:11:44 2024 
 
Database header page information: 
    Flags            0 
    Generation        90086 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    172426 
    Oldest active        172427 
    Oldest snapshot        172427 
    Next transaction    172428 
    Sequence number        0 
    Next attachment ID    703 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.45, total records: 7738639 
    Average version length: 48.16, total versions: 71991, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86816 
    Data pages: 86816, average fill: 71% 
    Primary pages: 86816, secondary pages: 0, swept pages: 26945 
    Empty pages: 8, full pages: 56742 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 104 
    40 - 59% = 1880 
    60 - 79% = 84799 
    80 - 99% = 17 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23184, nodes: 7738639 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1716180, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 313 
        20 - 39% = 1786 
        40 - 59% = 4137 
        60 - 79% = 2276 
        80 - 99% = 14672 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13456, nodes: 7738639 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1538803, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1588 
        40 - 59% = 1960 
        60 - 79% = 1079 
        80 - 99% = 8829 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8291, nodes: 7738639 
    Average node length: 6.62, total dup: 5783770, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1531724, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 962 
        40 - 59% = 1349 
        60 - 79% = 860 
        80 - 99% = 5010 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.43, total records: 2245790 
    Average version length: 34.72, total versions: 78725, max versions: 3 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28400 
    Data pages: 28400, average fill: 73% 
    Primary pages: 28396, secondary pages: 4, swept pages: 12022 
    Empty pages: 4, full pages: 18406 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 40 
    40 - 59% = 911 
    60 - 79% = 26917 
    80 - 99% = 518 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4553, nodes: 2245790 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 695064, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 968 
        40 - 59% = 796 
        60 - 79% = 693 
        80 - 99% = 2095 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2517, nodes: 2248109 
    Average node length: 4.97, total dup: 2247210, max dup: 17666 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1249511, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 257 
        40 - 59% = 1526 
        60 - 79% = 545 
        80 - 99% = 187 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2028, nodes: 2245790 
    Average node length: 4.97, total dup: 2245740, max dup: 130054 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1060116, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 66 
        40 - 59% = 1076 
        60 - 79% = 33 
        80 - 99% = 848 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4368, nodes: 2245790 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 695064, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 89 
        20 - 39% = 648 
        40 - 59% = 616 
        60 - 79% = 804 
        80 - 99% = 2211 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.41, total records: 400 
    Average version length: 22.95, total versions: 236777, max versions: 621 
    Average fragment length: 2.00, total fragments: 49, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1464 
    Data pages: 1320, average fill: 89% 
    Primary pages: 10, secondary pages: 1310, swept pages: 0 
    Empty pages: 3, full pages: 1316 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1315 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 6.97, total records: 90819 
    Average version length: 68.29, total versions: 81559, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 12.63 
    Pointer pages: 7, data page slots: 4144 
    Data pages: 2144, average fill: 54% 
    Primary pages: 2143, secondary pages: 1, swept pages: 0 
    Empty pages: 342, full pages: 894 
    Fill distribution: 
     0 - 19% = 515 
    20 - 39% = 318 
    40 - 59% = 273 
    60 - 79% = 238 
    80 - 99% = 800 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701486, depth: 3, leaf buckets: 401, nodes: 90819 
    Average node length: 13.36, total dup: 7369, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 64207, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 253 
        40 - 59% = 143 
        60 - 79% = 2 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 17846, max versions: 935 
    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: 72 
    Data pages: 72, average fill: 80% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 14 
    80 - 99% = 51 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.28, total records: 1499 
    Average version length: 43.76, total versions: 1423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 25.40 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 47% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 6, full pages: 9 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 2 
    40 - 59% = 8 
    60 - 79% = 2 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89555, depth: 2, leaf buckets: 3, nodes: 1499 
    Average node length: 4.36, total dup: 1401, max dup: 172 
    Average key length: 2.70, compression ratio: 7.03 
    Average prefix length: 18.36, average data length: 0.64 
    Clustering factor: 803, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 75 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.30, total records: 808651 
    Average version length: 25.68, total versions: 60024, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8048 
    Data pages: 8048, average fill: 70% 
    Primary pages: 8024, secondary pages: 24, swept pages: 1625 
    Empty pages: 55, full pages: 7325 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 94 
    40 - 59% = 169 
    60 - 79% = 7435 
    80 - 99% = 237 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 872, nodes: 808651 
    Average node length: 4.87, total dup: 808602, max dup: 151826 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89151, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 92 
        40 - 59% = 497 
        60 - 79% = 214 
        80 - 99% = 68 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 927, nodes: 808651 
    Average node length: 5.88, total dup: 719747, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159922, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 91 
        40 - 59% = 394 
        60 - 79% = 151 
        80 - 99% = 289 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 966, nodes: 808651 
    Average node length: 5.88, total dup: 719747, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161874, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 187 
        40 - 59% = 355 
        60 - 79% = 132 
        80 - 99% = 292 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1132, nodes: 808651 
    Average node length: 5.96, total dup: 719747, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154819, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 231 
        40 - 59% = 596 
        60 - 79% = 207 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.82, total records: 5450 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.67, total fragments: 93, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 76, secondary pages: 12, swept pages: 52 
    Empty pages: 8, full pages: 67 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 68 
    80 - 99% = 2 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5450 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.60, compression ratio: 10.00 
    Average prefix length: 34.39, average data length: 1.56 
    Clustering factor: 5185, 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: 1504233, depth: 2, leaf buckets: 10, nodes: 5450 
    Average node length: 11.09, 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: 143, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.18, total records: 78001 
    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: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 752 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 752 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36232, depth: 2, leaf buckets: 101, nodes: 78001 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3174, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.64, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.28 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 147.74, total records: 167571 
    Average version length: 150.71, total versions: 3733, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 5, data page slots: 5176 
    Data pages: 4120, average fill: 84% 
    Primary pages: 4119, secondary pages: 1, swept pages: 5 
    Empty pages: 122, full pages: 3953 
    Fill distribution: 
     0 - 19% = 129 
    20 - 39% = 13 
    40 - 59% = 13 
    60 - 79% = 13 
    80 - 99% = 3952 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 138.19, total records: 188734 
    Average version length: 154.79, total versions: 16136, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.27 
    Pointer pages: 7, data page slots: 6720 
    Data pages: 4576, average fill: 86% 
    Primary pages: 4576, secondary pages: 0, swept pages: 3 
    Empty pages: 77, full pages: 4472 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 11 
    80 - 99% = 4472 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.72, total records: 158441 
    Average version length: 150.28, total versions: 2247, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 6, data page slots: 4752 
    Data pages: 3832, average fill: 85% 
    Primary pages: 3832, secondary pages: 0, swept pages: 5 
    Empty pages: 74, full pages: 3742 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3743 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 132.00, total records: 198174 
    Average version length: 154.82, total versions: 25137, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.85 
    Pointer pages: 7, data page slots: 6200 
    Data pages: 4872, average fill: 85% 
    Primary pages: 4872, secondary pages: 0, swept pages: 3 
    Empty pages: 135, full pages: 4690 
    Fill distribution: 
     0 - 19% = 138 
    20 - 39% = 16 
    40 - 59% = 12 
    60 - 79% = 17 
    80 - 99% = 4689 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 147.07, total records: 159402 
    Average version length: 152.38, total versions: 4267, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 5704 
    Data pages: 3880, average fill: 85% 
    Primary pages: 3879, secondary pages: 1, swept pages: 4 
    Empty pages: 84, full pages: 3766 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 13 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3766 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 129.12, total records: 186580 
    Average version length: 154.86, total versions: 27050, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.14 
    Pointer pages: 7, data page slots: 6664 
    Data pages: 4584, average fill: 85% 
    Primary pages: 4584, secondary pages: 0, swept pages: 7 
    Empty pages: 126, full pages: 4419 
    Fill distribution: 
     0 - 19% = 132 
    20 - 39% = 13 
    40 - 59% = 13 
    60 - 79% = 9 
    80 - 99% = 4417 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 146.91, total records: 179664 
    Average version length: 152.93, total versions: 5146, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 7, data page slots: 6080 
    Data pages: 4448, average fill: 83% 
    Primary pages: 4447, secondary pages: 1, swept pages: 12 
    Empty pages: 157, full pages: 4244 
    Fill distribution: 
     0 - 19% = 164 
    20 - 39% = 16 
    40 - 59% = 13 
    60 - 79% = 12 
    80 - 99% = 4243 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 128.59, total records: 187894 
    Average version length: 154.77, total versions: 28055, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.19 
    Pointer pages: 7, data page slots: 7968 
    Data pages: 4608, average fill: 85% 
    Primary pages: 4608, secondary pages: 0, swept pages: 1 
    Empty pages: 115, full pages: 4456 
    Fill distribution: 
     0 - 19% = 122 
    20 - 39% = 15 
    40 - 59% = 12 
    60 - 79% = 2 
    80 - 99% = 4457 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 125.76, total records: 201633 
    Average version length: 154.50, total versions: 33748, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.49 
    Pointer pages: 8, data page slots: 7144 
    Data pages: 4952, average fill: 85% 
    Primary pages: 4952, secondary pages: 0, swept pages: 1 
    Empty pages: 131, full pages: 4779 
    Fill distribution: 
     0 - 19% = 138 
    20 - 39% = 16 
    40 - 59% = 13 
    60 - 79% = 5 
    80 - 99% = 4780 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 131.80, total records: 179406 
    Average version length: 154.76, total versions: 22650, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.87 
    Pointer pages: 7, data page slots: 5880 
    Data pages: 4328, average fill: 87% 
    Primary pages: 4328, secondary pages: 0, swept pages: 4 
    Empty pages: 55, full pages: 4247 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 7 
    40 - 59% = 10 
    60 - 79% = 4 
    80 - 99% = 4247 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.90, total records: 2088892 
    Average version length: 52.89, total versions: 33629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25512 
    Data pages: 25512, average fill: 70% 
    Primary pages: 25512, secondary pages: 0, swept pages: 12595 
    Empty pages: 231, full pages: 19232 
    Fill distribution: 
     0 - 19% = 460 
    20 - 39% = 471 
    40 - 59% = 1407 
    60 - 79% = 22879 
    80 - 99% = 295 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2591, nodes: 2088892 
    Average node length: 5.44, total dup: 1948824, max dup: 1460 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180718, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 310 
        40 - 59% = 1733 
        60 - 79% = 245 
        80 - 99% = 298 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2763, nodes: 2088892 
    Average node length: 5.70, total dup: 1874044, max dup: 70 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372968, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2434 
        60 - 79% = 293 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2136, nodes: 2088892 
    Average node length: 4.96, total dup: 2088792, max dup: 27611 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 178562, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 216 
        40 - 59% = 1121 
        60 - 79% = 374 
        80 - 99% = 421 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 41.25, total records: 129052 
    Average version length: 69.17, total versions: 52127, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.05 
    Pointer pages: 3, data page slots: 4320 
    Data pages: 3071, average fill: 49% 
    Primary pages: 3071, secondary pages: 0, swept pages: 577 
    Empty pages: 683, full pages: 1417 
    Fill distribution: 
     0 - 19% = 942 
    20 - 39% = 333 
    40 - 59% = 257 
    60 - 79% = 562 
    80 - 99% = 977 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 98549, depth: 3, leaf buckets: 222, nodes: 129052 
    Average node length: 6.40, total dup: 112115, max dup: 14 
    Average key length: 4.01, compression ratio: 10.49 
    Average prefix length: 40.12, average data length: 1.88 
    Clustering factor: 22561, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 94 
        40 - 59% = 92 
        60 - 79% = 33 
        80 - 99% = 3 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.89, total records: 6974631 
    Average version length: 68.76, total versions: 310728, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 63, data page slots: 101232 
    Data pages: 101232, average fill: 74% 
    Primary pages: 101232, secondary pages: 0, swept pages: 33062 
    Empty pages: 4, full pages: 74459 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 760 
    40 - 59% = 7447 
    60 - 79% = 88507 
    80 - 99% = 4486 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10648, nodes: 6974631 
    Average node length: 6.52, total dup: 6028743, max dup: 29 
    Average key length: 3.53, compression ratio: 11.90 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1547052, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1680 
        40 - 59% = 5978 
        60 - 79% = 2456 
        80 - 99% = 525 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8453, nodes: 6974631 
    Average node length: 5.40, total dup: 6694951, max dup: 144 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1353852, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1206 
        40 - 59% = 4667 
        60 - 79% = 1624 
        80 - 99% = 947 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8495, nodes: 6974631 
    Average node length: 5.40, total dup: 6694951, max dup: 144 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1356257, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1237 
        40 - 59% = 4678 
        60 - 79% = 1621 
        80 - 99% = 952 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.58, total records: 11963245 
    Average version length: 68.71, total versions: 238290, 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: 103, data page slots: 167384 
    Data pages: 167384, average fill: 76% 
    Primary pages: 167384, secondary pages: 0, swept pages: 85317 
    Empty pages: 5, full pages: 150454 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 546 
    40 - 59% = 4618 
    60 - 79% = 158300 
    80 - 99% = 3860 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18347, nodes: 11963245 
    Average node length: 6.58, total dup: 10425689, max dup: 59 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2353517, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 2381 
        40 - 59% = 10941 
        60 - 79% = 4277 
        80 - 99% = 716 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 45.77, total records: 1397382 
    Average version length: 69.10, total versions: 472686, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.75 
    Pointer pages: 26, data page slots: 41744 
    Data pages: 28984, average fill: 55% 
    Primary pages: 28984, secondary pages: 0, swept pages: 11088 
    Empty pages: 4149, full pages: 15082 
    Fill distribution: 
     0 - 19% = 6997 
    20 - 39% = 2818 
    40 - 59% = 2427 
    60 - 79% = 9809 
    80 - 99% = 6933 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2085, nodes: 1397382 
    Average node length: 5.52, total dup: 1340554, max dup: 95 
    Average key length: 2.57, compression ratio: 16.33 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 92577, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 795 
        40 - 59% = 915 
        60 - 79% = 310 
        80 - 99% = 58 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 41.93, total records: 1134321 
    Average version length: 69.12, total versions: 445178, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.00 
    Pointer pages: 22, data page slots: 34368 
    Data pages: 27096, average fill: 48% 
    Primary pages: 27096, secondary pages: 0, swept pages: 6322 
    Empty pages: 4807, full pages: 10740 
    Fill distribution: 
     0 - 19% = 7899 
    20 - 39% = 3386 
    40 - 59% = 3000 
    60 - 79% = 5095 
    80 - 99% = 7716 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1611, nodes: 1134321 
    Average node length: 5.82, total dup: 1056084, max dup: 102 
    Average key length: 2.89, compression ratio: 14.54 
    Average prefix length: 41.18, average data length: 0.82 
    Clustering factor: 153883, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 432 
        40 - 59% = 729 
        60 - 79% = 364 
        80 - 99% = 82 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.83, total records: 9194822 
    Average version length: 68.93, total versions: 409785, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 88, data page slots: 143080 
    Data pages: 143072, average fill: 69% 
    Primary pages: 143071, secondary pages: 1, swept pages: 62266 
    Empty pages: 216, full pages: 70776 
    Fill distribution: 
     0 - 19% = 671 
    20 - 39% = 3905 
    40 - 59% = 23283 
    60 - 79% = 110698 
    80 - 99% = 4515 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13530, nodes: 9194822 
    Average node length: 6.68, total dup: 7626310, max dup: 23 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1977798, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1245 
        40 - 59% = 7049 
        60 - 79% = 4648 
        80 - 99% = 587 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21121878 
    Average version length: 82.95, total versions: 7586, 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: 318488 
    Data pages: 318488, average fill: 81% 
    Primary pages: 318488, secondary pages: 0, swept pages: 13191 
    Empty pages: 49, full pages: 317204 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 67 
    40 - 59% = 170 
    60 - 79% = 27858 
    80 - 99% = 290311 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19348, nodes: 21121878 
    Average node length: 5.72, total dup: 20641600, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277127, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8102 
        60 - 79% = 563 
        80 - 99% = 10678 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17150, nodes: 21121878 
    Average node length: 6.31, total dup: 18560881, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914012, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 4 
        40 - 59% = 774 
        60 - 79% = 276 
        80 - 99% = 16092 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21139, nodes: 21121878 
    Average node length: 6.35, total dup: 18480592, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571266, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8422 
        60 - 79% = 568 
        80 - 99% = 12142 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 15942, nodes: 21121878 
    Average node length: 5.56, total dup: 21121778, max dup: 229964 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942757, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2625 
        60 - 79% = 371 
        80 - 99% = 12942 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.80, total records: 9540965 
    Average version length: 82.55, total versions: 303915, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 103, data page slots: 167168 
    Data pages: 167152, average fill: 70% 
    Primary pages: 167152, secondary pages: 0, swept pages: 89211 
    Empty pages: 337, full pages: 89324 
    Fill distribution: 
     0 - 19% = 1023 
    20 - 39% = 4836 
    40 - 59% = 25716 
    60 - 79% = 84056 
    80 - 99% = 51521 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11389, nodes: 9540965 
    Average node length: 5.38, total dup: 9232650, max dup: 190 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2116557, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 69 
        40 - 59% = 8624 
        60 - 79% = 2598 
        80 - 99% = 97 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13486, nodes: 9540965 
    Average node length: 6.24, total dup: 7910603, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1476229, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 137 
        20 - 39% = 4295 
        40 - 59% = 4096 
        60 - 79% = 2516 
        80 - 99% = 2442 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12722, nodes: 9540965 
    Average node length: 6.00, total dup: 8272812, max dup: 42 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2299796, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 83 
        40 - 59% = 9649 
        60 - 79% = 2869 
        80 - 99% = 117 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9974, nodes: 9540965 
    Average node length: 5.14, total dup: 9540865, max dup: 155593 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.44, average data length: 0.00 
    Clustering factor: 1508785, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1318 
        40 - 59% = 4780 
        60 - 79% = 1727 
        80 - 99% = 2107 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.48, total records: 11213551 
    Average version length: 82.53, total versions: 248441, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 117, data page slots: 189992 
    Data pages: 189032, average fill: 73% 
    Primary pages: 189032, secondary pages: 0, swept pages: 78047 
    Empty pages: 2060, full pages: 137955 
    Fill distribution: 
     0 - 19% = 4046 
    20 - 39% = 7600 
    40 - 59% = 19107 
    60 - 79% = 46535 
    80 - 99% = 111744 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13138, nodes: 11213551 
    Average node length: 5.31, total dup: 11103772, max dup: 642 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2332226, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 163 
        40 - 59% = 9283 
        60 - 79% = 3548 
        80 - 99% = 144 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10366, nodes: 11213551 
    Average node length: 5.51, total dup: 10723999, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 699537, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 844 
        40 - 59% = 2542 
        60 - 79% = 1820 
        80 - 99% = 5005 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15016, nodes: 11213551 
    Average node length: 6.04, total dup: 9780116, max dup: 66 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2348495, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 182 
        40 - 59% = 10800 
        60 - 79% = 3863 
        80 - 99% = 171 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10692, nodes: 11213551 
    Average node length: 5.23, total dup: 11213451, max dup: 196444 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 688199, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 812 
        40 - 59% = 4811 
        60 - 79% = 1441 
        80 - 99% = 3536 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 80.03, total records: 9667501 
    Average version length: 82.83, total versions: 316230, 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: 105, data page slots: 170232 
    Data pages: 170184, average fill: 70% 
    Primary pages: 170184, secondary pages: 0, swept pages: 89111 
    Empty pages: 309, full pages: 88969 
    Fill distribution: 
     0 - 19% = 1004 
    20 - 39% = 4920 
    40 - 59% = 25976 
    60 - 79% = 89578 
    80 - 99% = 48706 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11801, nodes: 9667501 
    Average node length: 5.18, total dup: 9638629, max dup: 1895 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1927042, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1531 
        40 - 59% = 7937 
        60 - 79% = 1763 
        80 - 99% = 550 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13580, nodes: 9667501 
    Average node length: 6.25, total dup: 8015549, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1447738, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 4267 
        40 - 59% = 4024 
        60 - 79% = 2537 
        80 - 99% = 2586 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12421, nodes: 9667501 
    Average node length: 5.43, total dup: 9231455, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2057915, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1488 
        40 - 59% = 8729 
        60 - 79% = 1636 
        80 - 99% = 547 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10077, nodes: 9667501 
    Average node length: 5.15, total dup: 9667401, max dup: 155442 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.44, average data length: 0.00 
    Clustering factor: 1534131, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1281 
        40 - 59% = 4899 
        60 - 79% = 1711 
        80 - 99% = 2152 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.48, total records: 571967 
    Average version length: 68.79, total versions: 5733, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7976, average fill: 75% 
    Primary pages: 7976, secondary pages: 0, swept pages: 4422 
    Empty pages: 3, full pages: 6393 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 13 
    40 - 59% = 189 
    60 - 79% = 7702 
    80 - 99% = 69 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 48422, depth: 3, leaf buckets: 735, nodes: 571967 
    Average node length: 5.95, total dup: 486881, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99775, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 522 
        60 - 79% = 93 
        80 - 99% = 89 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35737, depth: 3, leaf buckets: 752, nodes: 571967 
    Average node length: 6.15, total dup: 469034, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99830, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 524 
        60 - 79% = 95 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 566, nodes: 571967 
    Average node length: 4.86, total dup: 571867, max dup: 8813 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88599, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 49 
        40 - 59% = 312 
        60 - 79% = 79 
        80 - 99% = 125 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Apr 13 16:12:09 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7738639 71991 1 0.0000 0.0000
DOC_LIST 2245790 78725 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 236777 621 59100.0000 0.0000
INVNT_TURNOVER_LOG 90819 81559 1 0.0000 0.0000
MONEY_SALDO 49 17846 935 36400.0000 0.0000
MONEY_TURNOVER_LOG 1499 1423 1 0.0000 0.0000
PDISTR 808651 60024 4 0.0000 0.0000
PERF_SPLIT_0 167571 3733 1 0.0000 0.0000
PERF_SPLIT_1 188734 16136 1 0.0000 0.0000
PERF_SPLIT_2 158441 2247 1 0.0000 0.0000
PERF_SPLIT_3 198174 25137 1 0.0000 0.0000
PERF_SPLIT_4 159402 4267 1 0.0000 0.0000
PERF_SPLIT_5 186580 27050 1 0.0000 0.0000
PERF_SPLIT_6 179664 5146 1 0.0000 0.0000
PERF_SPLIT_7 187894 28055 1 0.0000 0.0000
PERF_SPLIT_8 201633 33748 1 0.0000 0.0000
PERF_SPLIT_9 179406 22650 1 0.0000 0.0000
PSTORNED 2088892 33629 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 129052 52127 1 0.0000 0.0000
XQD_1000_3300 6974631 310728 1 0.0000 0.0000
XQD_1200_2000 11963245 238290 1 0.0000 0.0000
XQD_2000_3300 1397382 472686 1 0.0000 0.0000
XQD_2100_3300 1134321 445178 1 0.0000 0.0000
XQD_3300_3400 9194822 409785 1 0.0000 0.0000
XQS_1000_1200 21121878 7586 1 0.0000 0.0000
XQS_1000_3300 9540965 303915 1 0.0000 0.0000
XQS_1200_2000 11213551 248441 1 0.0000 0.0000
XQS_2100_3300 9667501 316230 1 0.0000 0.0000
XQS_3300_3400 571967 5733 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 ---
:1134: 
:1135: mscs-test-161.budzdorov.ru    Sat Apr 13 16:09:53 2024
:1136:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1137: 
--- end of diff output ---

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

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