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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-03 01:09:45
DTS_END                         2024-03-03 01:09:45.5560
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(108:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37762
TRN_ID                          170506
ATT_ID                          550
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: 8990.28 20449 899028
customer order: creation 165.60 392 16560
customer order: refuse 14.31 386 1431
order to supplier: creation 45.16 1446 4516
order to supplier: removal 3.54 98743 354
invoice (draft): creation 45.90 3447 4590
invoice (draft): removal 50.26 780 5026
invoice accept: apply 40.62 23323 4062
invoice accept: cancel 45.20 1025 4520
customer reserve: creation 3868.96 226 386896
customer reserve: removal 4425.02 64 442502
realization accept: apply 82.78 196 8278
realization accept: cancel 75.55 125 7555
payment from customer: creation 57.31 109 5731
payment from customer: removal 5.33 96 533
payment to supplier: creation 49.09 131 4909
payment to supplier: removal 3.49 80 349
service: total inventory turnovers 4.62 1292 462
service: total monetary turnovers 6.75 29 675
service: aggregate perf. data 0.76 26248 76
service: refresh index statistics 0.03 250848 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-03-2024 01:11:05 to 03-03-2024 01:11:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1675
TEST_TIME 2 3436
TEST_TIME 3 3065
TEST_TIME 4 3401
TEST_TIME 5 3869
TEST_TIME 6 4490
TEST_TIME 7 4542
TEST_TIME 8 5142
TEST_TIME 9 5028
TEST_TIME 10 5020
TEST_TIME 11 5197
TEST_TIME 12 5507
TEST_TIME 13 5927
TEST_TIME 14 5849
TEST_TIME 15 6033
TEST_TIME 16 6162
TEST_TIME 17 6250
TEST_TIME 18 6521
TEST_TIME 19 6468
TEST_TIME 20 6815
TEST_TIME 21 7111
TEST_TIME 22 7149
TEST_TIME 23 7161
TEST_TIME 24 7135
TEST_TIME 25 7497
TEST_TIME 26 7540
TEST_TIME 27 7519
TEST_TIME 28 7560
TEST_TIME 29 7778
TEST_TIME 30 8098
TEST_TIME 31 8743
TEST_TIME 32 8784
TEST_TIME 33 8950
TEST_TIME 34 8846
TEST_TIME 35 8727
TEST_TIME 36 8716
TEST_TIME 37 8561
TEST_TIME 38 8637
TEST_TIME 39 8685
TEST_TIME 40 8517
TEST_TIME 41 8546
TEST_TIME 42 8531
TEST_TIME 43 8495
TEST_TIME 44 8648
TEST_TIME 45 8647
TEST_TIME 46 8627
TEST_TIME 47 8608
TEST_TIME 48 8559
TEST_TIME 49 8555
TEST_TIME 50 8623
TEST_TIME 51 9057
TEST_TIME 52 9055
TEST_TIME 53 8972
TEST_TIME 54 9025
TEST_TIME 55 9124
TEST_TIME 56 9090
TEST_TIME 57 9121
TEST_TIME 58 9151
TEST_TIME 59 9158
TEST_TIME 60 9143
TEST_TIME 61 9159
TEST_TIME 62 9121
TEST_TIME 63 8999
TEST_TIME 64 9020
TEST_TIME 65 8944
TEST_TIME 66 8908
TEST_TIME 67 8886
TEST_TIME 68 8913
TEST_TIME 69 8868
TEST_TIME 70 8877
TEST_TIME 71 8804
TEST_TIME 72 8790
TEST_TIME 73 8761
TEST_TIME 74 8807
TEST_TIME 75 8838
TEST_TIME 76 8859
TEST_TIME 77 8911
TEST_TIME 78 8891
TEST_TIME 79 8924
TEST_TIME 80 8961
TEST_TIME 81 8987
TEST_TIME 82 9009
TEST_TIME 83 9018
TEST_TIME 84 9062
TEST_TIME 85 9051
TEST_TIME 86 9099
TEST_TIME 87 9116
TEST_TIME 88 9049
TEST_TIME 89 9059
TEST_TIME 90 9026
TEST_TIME 91 9001
TEST_TIME 92 8979
TEST_TIME 93 8927
TEST_TIME 94 8935
TEST_TIME 95 8932
TEST_TIME 96 8946
TEST_TIME 97 8973
TEST_TIME 98 9010
TEST_TIME 99 8987
TEST_TIME 100 8994

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1253587 1253587 0 0.00 0 19307 7 0 0
doc_list_biud 1253587 1253587 0 0.00 0 40111 28 0 0
sp_add_invoice_to_stock 4159 4062 97 2.33 41 217759 23323 0 97
sp_cancel_adding_invoice 4520 4520 0 0.00 5 81436 1026 0 0
sp_cancel_client_order 1431 1431 0 0.00 4 8553 387 0 0
sp_cancel_customer_reserve 442502 442502 0 0.00 0 39960 64 0 0
sp_cancel_pay_from_customer 533 533 0 0.00 3 4024 96 0 0
sp_cancel_pay_to_supplier 349 349 0 0.00 2 2116 81 0 0
sp_cancel_supplier_invoice 5038 5026 12 0.23 1 14449 781 0 12
sp_cancel_supplier_order 354 354 0 0.00 9 974874 98743 0 0
sp_cancel_write_off 7555 7555 0 0.00 1 8619 125 0 0
sp_client_order 16560 16560 0 0.00 3 30835 393 0 0
sp_customer_reserve 386896 386896 0 0.00 0 87566 226 0 0
sp_fill_shopping_cart 25661 25661 0 0.00 1 11432 33 0 0
sp_fill_shopping_cart_clo_res 386892 386892 0 0.00 0 20867 17 0 0
sp_get_clo_for_invoice 4055 4055 0 0.00 0 29100 316 0 0
sp_kill_cost_storno 12957 12957 0 0.00 0 5119 63 0 0
sp_kill_qstorno_ret_qs2qd 897939 897939 0 0.00 0 33924 34 0 0
sp_kill_qty_storno 473719 473719 0 0.00 0 40109 74 0 0
sp_lock_selected_doc 17157 17157 0 0.00 0 8153 6 0 0
sp_make_cost_storno 22971 22971 0 0.00 0 19297 61 0 0
sp_multiply_rows_for_pdistr 22971 22971 0 0.00 0 9023 30 0 0
sp_multiply_rows_for_qdistr 16560 16560 0 0.00 0 22958 183 0 0
sp_pay_from_customer 5731 5731 0 0.00 4 13335 109 0 0
sp_pay_to_supplier 4909 4909 0 0.00 5 10988 132 0 0
sp_payment_common 10640 10640 0 0.00 1 7641 26 0 0
sp_qd_handle_on_cancel_clo 1431 1431 0 0.00 0 8546 357 0 0
sp_qd_handle_on_invoice_upd_sts 8573 8573 0 0.00 0 40109 346 0 0
sp_qd_handle_on_reserve_upd_sts 8278 8278 0 0.00 0 18033 65 0 0
sp_reserve_write_off 8278 8278 0 0.00 6 18050 196 0 0
sp_supplier_invoice 4590 4590 0 0.00 7 91009 3447 0 0
sp_supplier_order 4516 4516 0 0.00 5 34163 1446 0 0
srv_aggregate_perf_data 76 76 0 0.00 1424 501461 26248 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1109 111234 37392 0 0
srv_find_qd_qs_mism 857895 857895 0 0.00 0 18277 6 0 0
srv_make_invnt_saldo 462 462 0 0.00 47 52536 1293 0 0
srv_make_money_saldo 675 675 0 0.00 0 1053 29 0 0
srv_recalc_idx_stat 3 3 0 0.00 160388 372114 250849 0 0
t$perf-abend:sp_add_invoice_to_stock 97 97 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4062 4062 0 0.00 0 10999 183 0 0
t$perf-norm:sp_cancel_adding_invoice 343 343 0 0.00 1 6021 144 0 0
t$perf-norm:sp_cancel_client_order 1431 1431 0 0.00 0 2062 13 0 0
t$perf-norm:sp_cancel_customer_reserve 577 577 0 0.00 0 512 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 533 533 0 0.00 0 6541 30 0 0
t$perf-norm:sp_cancel_pay_to_supplier 349 349 0 0.00 0 793 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 324 324 0 0.00 0 1708 17 0 0
t$perf-norm:sp_cancel_supplier_order 354 354 0 0.00 0 30313 1935 0 0
t$perf-norm:sp_cancel_write_off 915 915 0 0.00 0 3187 11 0 0
t$perf-norm:sp_client_order 16560 16560 0 0.00 0 6916 23 0 0
t$perf-norm:sp_customer_reserve 800 800 0 0.00 0 4132 15 0 0
t$perf-norm:sp_pay_from_customer 5731 5731 0 0.00 0 5866 9 0 0
t$perf-norm:sp_pay_to_supplier 4909 4909 0 0.00 0 4233 12 0 0
t$perf-norm:sp_reserve_write_off 8278 8278 0 0.00 0 4169 13 0 0
t$perf-norm:sp_supplier_invoice 4590 4590 0 0.00 0 3243 19 0 0
t$perf-norm:sp_supplier_order 4516 4516 0 0.00 0 3789 18 0 0
t$perf-norm:srv_aggregate_perf_data 76 76 0 0.00 0 274 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 6 1 0 0
t$perf-norm:srv_make_invnt_saldo 462 462 0 0.00 0 1338 31 0 0
t$perf-norm:srv_make_money_saldo 675 675 0 0.00 0 550 16 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 13 6 0 0
v_add_invoice_to_stock 8300 8106 194 2.33 0 4494 18 0 194
v_all_customers 30602 30602 0 0.00 0 27 1 0 0
v_all_suppliers 25854 25854 0 0.00 0 114 1 0 0
v_all_wares 33120 33120 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 686 686 0 0.00 0 1732 15 0 0
v_cancel_client_order 2862 2862 0 0.00 0 4381 9 0 0
v_cancel_customer_prepayment 1066 1066 0 0.00 0 2995 11 0 0
v_cancel_customer_reserve 1154 1154 0 0.00 0 5206 8 0 0
v_cancel_payment_to_supplier 698 698 0 0.00 0 2098 9 0 0
v_cancel_supplier_invoice 672 648 24 3.57 0 636 14 0 24
v_cancel_supplier_order 708 708 0 0.00 0 734 4 0 0
v_cancel_write_off 1830 1830 0 0.00 0 3090 17 0 0
v_max_id_clo_ord 4515 4515 0 0.00 0 652 1 0 0
v_max_id_clo_res 800 800 0 0.00 0 3840 20 0 0
v_max_id_ord_sup 4586 4586 0 0.00 0 2099 3 0 0
v_max_non_paid_invoice 1083 1083 0 0.00 0 2176 4 0 0
v_max_non_paid_realizn 2871 2871 0 0.00 0 1132 5 0 0
v_min_id_clo_ord 4515 4515 0 0.00 0 4849 7 0 0
v_min_id_clo_res 800 800 0 0.00 0 1311 4 0 0
v_min_id_ord_sup 4586 4586 0 0.00 0 5833 6 0 0
v_min_non_paid_invoice 4909 4909 0 0.00 0 4805 18 0 0
v_min_non_paid_realizn 5731 5731 0 0.00 0 4822 18 0 0
v_our_firm 8238 8238 0 0.00 0 22 1 0 0
v_reserve_write_off 16556 16556 0 0.00 0 5164 7 0 0
x_lock_depdocs_on_canc_invoice 9222 9222 0 0.00 0 14051 149 0 0
x_lock_depdocs_on_canc_sup_ord 354 354 0 0.00 0 10971 334 0 0
x_make_qstorno_1000_1200 4516 4516 0 0.00 1 34137 1371 0 0
x_make_qstorno_1200_2000 4590 4590 0 0.00 3 90606 3329 0 0
x_make_qstorno_2100_3300 386896 386896 0 0.00 0 87565 206 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-03-2024 01:11:13 to 03-03-2024 01:11:17.

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
23:09:49 1 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:50 16405 8192000000 9879038832 10184581120 967206560 10.559 100 86 172 0 994397808 4957760 22233488
23:12:10 25815 8192000000 9939757184 10255777792 1018057504 11.053 100 90 180 0 1048475184 7015728 23401952
23:13:42 15541 8192000000 9969814128 10298077184 1053429536 11.394 100 85 170 0 1083221744 8262304 21529904
23:15:05 9794 8192000000 10006606752 10349608960 1101592240 11.853 100 79 158 0 1130355456 9734752 19028464
23:16:24 7305 8192000000 10064647424 10420822016 1153612688 12.343 100 75 148 0 1181467040 11147680 16706672
23:17:35 4334 8192000000 10127386320 10494808064 1213013776 12.897 100 81 160 0 1242670064 12355344 17300944
23:18:41 2754 8192000000 10164841424 10542379008 1247938192 13.219 100 80 160 1 1277988144 12422304 17627648
23:19:46 1187 8192000000 10194919792 10579152896 1277640176 13.491 100 78 156 0 1311718464 17092176 16986112
23:20:48 2318 8192000000 10219962768 10602856448 1300281568 13.698 100 91 182 0 1333700736 13573104 19846064
23:21:51 21062 8192000000 10199407600 10603757568 1306718400 13.756 100 33 66 1 1321526384 7144160 7663824
23:23:13 7928 8192000000 10203450128 10618679296 1318950608 13.867 100 28 56 1 1332161312 6819984 6390720
23:24:24 9192 8192000000 10210740048 10631163904 1326860368 13.939 100 21 42 1 1338124672 6780400 4483904
23:25:35 52227 8192000000 10227222560 10641575936 1334432816 14.007 100 25 48 1 1345151264 4489168 6229280
23:27:29 6713 8192000000 10240967248 10661105664 1340016672 14.058 100 21 42 0 1354444096 10359744 4067680
23:28:37 4426 8192000000 10213372256 10629181440 1321918320 13.894 99 27 54 0 1334117520 5795040 6404160
23:29:42 40599 8192000000 10225346304 10642964480 1329731456 13.965 100 28 54 0 1341596128 6043808 5820864
23:31:26 3769 8192000000 10244650384 10654621696 1330496032 13.972 99 51 101 0 1351859616 10288896 11074688
23:32:42 37436 8192000000 10225792480 10638942208 1304199984 13.733 98 41 80 0 1323199184 9351888 9647312
23:34:33 15873 8192000000 10222830368 10631065600 1291474208 13.618 97 50 100 0 1313697728 10405024 11818496
23:35:56 30163 8192000000 10226388768 10637234176 1295382400 13.653 98 45 90 0 1315953616 10708384 9862832
23:37:36 7413 8192000000 10235327200 10649776128 1307790192 13.766 98 39 78 0 1329372864 12384176 9198496
23:38:46 11956 8192000000 10239879856 10640773120 1313441184 13.817 99 55 111 0 1338050576 11854880 12754512
23:40:01 10992 8192000000 10231176688 10636169216 1318369056 13.862 100 52 101 0 1343328576 13423328 11536192
23:41:14 9999 8192000000 10222615840 10624270336 1306031104 13.750 99 57 111 1 1334573776 15355328 13187344
23:42:26 6760 8192000000 10239414848 10636595200 1313650032 13.819 100 59 110 0 1343327056 16499584 13177440
23:43:38 6511 8192000000 10240998528 10644230144 1319698912 13.874 100 51 101 1 1347539840 16008976 11831952
23:44:54 4305 8192000000 10278327632 10682814464 1343013232 14.085 100 64 126 1 1380726416 23264064 14449120
23:46:10 14886 8192000000 10270670096 10679767040 1341535520 14.071 100 69 138 0 1379708192 21397920 16774752
23:47:29 7011 8192000000 10290635584 10701660160 1358287952 14.222 100 60 117 0 1394270752 22306304 13676496
23:48:42 4043 8192000000 10310052720 10717151232 1369320192 14.321 100 80 156 5 1416828848 28789296 18719360
23:49:49 1165 8192000000 10319046736 10717122560 1370331328 14.330 100 90 177 0 1420495776 28140992 22023456
23:50:55 13089 8192000000 10294890480 10723856384 1374088192 14.364 100 41 82 1 1411428416 27173952 10166272
23:52:15 17675 8192000000 10299948144 10726313984 1364182624 14.275 99 35 70 0 1398800960 25340272 9278064
23:53:40 13648 8192000000 10326233728 10742915072 1381424272 14.429 100 60 116 0 1428148384 32207648 14516464
23:55:09 1107 8192000000 10316435280 10742050816 1389026368 14.497 100 51 101 2 1425781568 23929072 12826128
23:56:14 23756 8192000000 10316747376 10756050944 1392264368 14.526 100 19 38 1 1425235360 27935600 5035392
23:57:52 13567 8192000000 10336337216 10772209664 1395013184 14.551 100 31 61 0 1441532784 38230352 8289248
23:59:12 8602 8192000000 10337791216 10778636288 1400660256 14.601 100 37 74 0 1447728608 37446928 9621424
00:00:27 43527 8192000000 10302526576 10753626112 1392460656 14.528 100 14 28 0 1424655488 28382848 3811984
00:02:22 38327 8192000000 10303013264 10764795904 1392599360 14.529 100 5 10 0 1408413248 14926848 887040
00:04:01 35491 8192000000 10321389088 10759831552 1404097168 14.631 100 48 94 0 1424448416 9669440 10681808
00:05:41 39510 8192000000 10322117424 10768297984 1403122720 14.623 100 60 119 2 1424793360 8773120 12897520
00:07:30 53719 8192000000 10318453360 10762817536 1393955456 14.541 99 27 54 0 1412317440 12540672 5821312
00:09:29 41612 8192000000 10326281680 10773602304 1412405600 14.705 100 39 79 0 1432666144 11891760 8368784
00:11:15 8580 8192000000 10318975872 10767556608 1397896128 14.576 98 28 54 0 1415395184 11256224 6242832
00:12:29 27977 8192000000 10331982656 10773782528 1401825184 14.611 99 56 112 2 1433439376 18327072 13287120
00:14:02 105958 8192000000 10304166656 10760736768 1370947744 14.336 98 22 45 0 1393263520 16918608 5397168
00:17:27 48720 8192000000 10300662512 10748231680 1358599216 14.225 98 28 55 1 1387499696 22070416 6830064
00:19:17 71914 8192000000 10299862752 10772205568 1384307584 14.455 100 20 40 1 1421830992 32067536 5455872
00:21:41 48681 8192000000 10257516864 10693443584 1297419216 13.672 95 31 60 0 1315255648 10965824 6870608
00:23:36 47913 8192000000 10276950832 10725421056 1356516080 14.206 100 25 50 0 1378373184 16376960 5480144
00:25:40 44324 8192000000 10287597344 10725502976 1353484096 14.179 98 35 65 0 1372279680 11447920 7347664
00:27:32 51615 8192000000 10271117792 10699616256 1286563712 13.573 94 29 57 0 1303717728 10166144 6987872
00:29:26 30350 8192000000 10258559760 10692472832 1313284080 13.816 97 22 44 0 1326834672 8736528 4814064
00:30:57 36990 8192000000 10260560288 10694680576 1321561584 13.891 98 27 54 1 1338793920 11526464 5705872
00:32:38 44276 8192000000 10264317936 10701836288 1331675680 13.982 98 56 112 0 1355123104 11055056 12392368
00:34:58 13747 8192000000 10241508608 10680483840 1338270672 14.042 99 30 59 1 1352713472 8086416 6356384
00:36:18 8512 8192000000 10272740112 10696273920 1355877056 14.200 100 56 110 0 1378584000 9650544 13056400
00:37:33 72917 8192000000 10251600208 10695917568 1344983264 14.102 99 10 21 0 1358495792 11219952 2292576
00:39:46 54454 8192000000 10270095584 10722508800 1351887536 14.164 98 6 12 0 1363572464 10602288 1082640
00:41:45 29974 8192000000 10279037312 10733293568 1374834816 14.370 100 17 34 1 1387861504 9148928 3877760
00:43:22 62779 8192000000 10278644288 10727690240 1366512464 14.296 99 14 28 0 1381517264 12215184 2789616
00:46:12 55138 8192000000 10306502272 10751475712 1390783104 14.513 100 20 40 0 1406749232 11159152 4806976
00:48:11 50480 8192000000 10317278704 10768990208 1402248672 14.615 100 10 20 0 1414159552 9880448 2030432
00:50:08 111233 8192000000 10311356256 10762309632 1380800608 14.424 98 10 20 0 1393432960 10247328 2385024
00:53:00 108738 8192000000 10312431696 10763149312 1381858384 14.433 98 10 18 0 1396989248 13178976 1951888
00:55:50 102807 8192000000 10320559024 10776543232 1400679616 14.601 99 18 36 0 1419466992 14866592 3920784
00:58:33 95529 8192000000 10326215344 10792300544 1391351968 14.518 98 24 48 0 1417420480 20811408 5257104
01:01:09 63964 8192000000 10295416320 10752593920 1348083984 14.130 96 15 30 0 1367376720 15741856 3550880
01:03:13 29715 8192000000 10295175264 10751365120 1350653984 14.153 97 28 56 2 1379471040 22334384 6482672
01:04:45 70697 8192000000 10298388336 10761392128 1393912704 14.541 100 12 24 0 1413798304 16737264 3148336
01:07:01 45339 8192000000 10310680096 10762362880 1377742336 14.396 98 33 66 0 1394722000 9100480 7879184
01:08:48 68838 8192000000 9294177488 9602220032 413931568 4.809 30 8 16 0 423404768 7675552 1797648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 03-03-2024 01:11:19 to 03-03-2024 01:11:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 97 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

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

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          170505
MON$OLDEST_ACTIVE               171609
MON$OLDEST_SNAPSHOT             171609
MON$NEXT_TRANSACTION            171609
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                       1912672
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.33733 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33733 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33733 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33733 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Mar  3 01:11:37 2024 
 
Database header page information: 
    Flags            0 
    Generation        89445 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    170505 
    Oldest active        171609 
    Oldest snapshot        171609 
    Next transaction    171610 
    Sequence number        0 
    Next attachment ID    700 
    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.17, total records: 7752845 
    Average version length: 48.16, total versions: 117469, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86920 
    Data pages: 86920, average fill: 71% 
    Primary pages: 86920, secondary pages: 0, swept pages: 15933 
    Empty pages: 6, full pages: 64186 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 143 
    40 - 59% = 2660 
    60 - 79% = 84078 
    80 - 99% = 25 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23240, nodes: 7752845 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1715257, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 339 
        20 - 39% = 1909 
        40 - 59% = 3965 
        60 - 79% = 2341 
        80 - 99% = 14686 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13487, nodes: 7752845 
    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: 1538619, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1669 
        40 - 59% = 1926 
        60 - 79% = 1044 
        80 - 99% = 8848 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8310, nodes: 7752845 
    Average node length: 6.62, total dup: 5797145, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1531811, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 1002 
        40 - 59% = 1319 
        60 - 79% = 869 
        80 - 99% = 4993 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.84, total records: 2245430 
    Average version length: 34.56, total versions: 121415, max versions: 3 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28368 
    Data pages: 28368, average fill: 74% 
    Primary pages: 28364, secondary pages: 4, swept pages: 8400 
    Empty pages: 6, full pages: 19944 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 94 
    40 - 59% = 1451 
    60 - 79% = 25717 
    80 - 99% = 1087 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4524, nodes: 2245430 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 686288, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 921 
        40 - 59% = 800 
        60 - 79% = 701 
        80 - 99% = 2102 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2528, nodes: 2248375 
    Average node length: 4.97, total dup: 2247476, max dup: 19484 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1245479, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 270 
        40 - 59% = 1552 
        60 - 79% = 504 
        80 - 99% = 195 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2048, nodes: 2245430 
    Average node length: 4.97, total dup: 2245380, max dup: 130141 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1058907, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 75 
        40 - 59% = 1111 
        60 - 79% = 46 
        80 - 99% = 814 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4330, nodes: 2245430 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 686288, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 572 
        40 - 59% = 596 
        60 - 79% = 783 
        80 - 99% = 2267 
 
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.43, total records: 400 
    Average version length: 23.24, total versions: 231843, max versions: 602 
    Average fragment length: 2.00, total fragments: 50, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1400 
    Data pages: 1304, average fill: 89% 
    Primary pages: 12, secondary pages: 1292, swept pages: 0 
    Empty pages: 5, full pages: 1298 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1297 
 
    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: 9.81, total records: 109398 
    Average version length: 68.30, total versions: 93687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.97 
    Pointer pages: 7, data page slots: 3208 
    Data pages: 1936, average fill: 70% 
    Primary pages: 1935, secondary pages: 1, swept pages: 0 
    Empty pages: 146, full pages: 1302 
    Fill distribution: 
     0 - 19% = 247 
    20 - 39% = 124 
    40 - 59% = 162 
    60 - 79% = 249 
    80 - 99% = 1154 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1706666, depth: 3, leaf buckets: 389, nodes: 109398 
    Average node length: 13.37, total dup: 9363, max dup: 2 
    Average key length: 10.55, compression ratio: 2.56 
    Average prefix length: 19.36, average data length: 7.64 
    Clustering factor: 76901, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 99 
        40 - 59% = 248 
        60 - 79% = 38 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 17065, max versions: 959 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 86% 
    Primary pages: 3, secondary pages: 61, swept pages: 0 
    Empty pages: 2, full pages: 61 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 56 
 
    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: 5.10, total records: 1844 
    Average version length: 43.72, total versions: 1635, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 11.38 
    Pointer pages: 1, data page slots: 40 
    Data pages: 39, average fill: 46% 
    Primary pages: 37, secondary pages: 2, swept pages: 0 
    Empty pages: 7, full pages: 13 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 3 
    40 - 59% = 10 
    60 - 79% = 4 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89560, depth: 2, leaf buckets: 2, nodes: 1844 
    Average node length: 4.23, total dup: 1746, max dup: 223 
    Average key length: 2.56, compression ratio: 7.41 
    Average prefix length: 18.49, average data length: 0.51 
    Clustering factor: 996, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.97, total records: 74 
    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: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    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: 35.95, total records: 813672 
    Average version length: 25.50, total versions: 74907, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 7968 
    Data pages: 7944, average fill: 72% 
    Primary pages: 7929, secondary pages: 15, swept pages: 1070 
    Empty pages: 24, full pages: 7664 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 20 
    40 - 59% = 43 
    60 - 79% = 7532 
    80 - 99% = 308 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 877, nodes: 813672 
    Average node length: 4.87, total dup: 813623, max dup: 155237 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89126, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 101 
        40 - 59% = 501 
        60 - 79% = 203 
        80 - 99% = 71 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 893, nodes: 813672 
    Average node length: 5.88, total dup: 724370, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161056, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 72 
        40 - 59% = 350 
        60 - 79% = 122 
        80 - 99% = 346 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 934, nodes: 813672 
    Average node length: 5.88, total dup: 724370, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163049, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 167 
        40 - 59% = 321 
        60 - 79% = 97 
        80 - 99% = 349 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1132, nodes: 813672 
    Average node length: 5.96, total dup: 724370, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155736, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 222 
        40 - 59% = 599 
        60 - 79% = 195 
        80 - 99% = 114 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.87, total records: 5461 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.30, total fragments: 61, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 78, secondary pages: 18, swept pages: 51 
    Empty pages: 12, full pages: 63 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 66 
    80 - 99% = 2 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5461 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.04 
    Average prefix length: 34.44, average data length: 1.55 
    Clustering factor: 4981, ratio: 0.91 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5461 
    Average node length: 11.12, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 151, 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.12, total records: 78337 
    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: 4, full pages: 755 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 755 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32198, depth: 2, leaf buckets: 99, nodes: 78337 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3393, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
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: 150.00, total records: 183697 
    Average version length: 151.25, total versions: 1505, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 7, data page slots: 6504 
    Data pages: 4464, average fill: 85% 
    Primary pages: 4463, secondary pages: 1, swept pages: 3 
    Empty pages: 92, full pages: 4345 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 11 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 4345 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.68, total records: 169584 
    Average version length: 138.57, total versions: 246, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 7, data page slots: 4264 
    Data pages: 4072, average fill: 86% 
    Primary pages: 4072, secondary pages: 0, swept pages: 2 
    Empty pages: 50, full pages: 4012 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4012 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.87, total records: 165409 
    Average version length: 153.01, total versions: 3309, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 6, data page slots: 5488 
    Data pages: 3968, average fill: 86% 
    Primary pages: 3968, secondary pages: 0, swept pages: 3 
    Empty pages: 44, full pages: 3906 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3906 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 150.00, total records: 146148 
    Average version length: 138.68, total versions: 245, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 6, data page slots: 4208 
    Data pages: 3496, average fill: 86% 
    Primary pages: 3496, secondary pages: 0, swept pages: 1 
    Empty pages: 43, full pages: 3442 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3442 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.86, total records: 163709 
    Average version length: 150.08, total versions: 1234, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 8, data page slots: 5528 
    Data pages: 3944, average fill: 85% 
    Primary pages: 3944, secondary pages: 0, swept pages: 1 
    Empty pages: 58, full pages: 3872 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 3872 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.11, total records: 165232 
    Average version length: 154.42, total versions: 2980, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 6, data page slots: 4352 
    Data pages: 3952, average fill: 86% 
    Primary pages: 3952, secondary pages: 0, swept pages: 3 
    Empty pages: 33, full pages: 3907 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3907 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 146.60, total records: 174397 
    Average version length: 153.36, total versions: 5140, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 8, data page slots: 4664 
    Data pages: 4184, average fill: 86% 
    Primary pages: 4184, secondary pages: 0, swept pages: 1 
    Empty pages: 43, full pages: 4128 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 4127 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 134.01, total records: 181336 
    Average version length: 155.03, total versions: 20293, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.66 
    Pointer pages: 8, data page slots: 5368 
    Data pages: 4392, average fill: 86% 
    Primary pages: 4391, secondary pages: 1, swept pages: 1 
    Empty pages: 73, full pages: 4293 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 7 
    40 - 59% = 8 
    60 - 79% = 9 
    80 - 99% = 4293 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 130.66, total records: 207617 
    Average version length: 154.97, total versions: 28066, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.98 
    Pointer pages: 7, data page slots: 7592 
    Data pages: 5040, average fill: 86% 
    Primary pages: 5040, secondary pages: 0, swept pages: 2 
    Empty pages: 87, full pages: 4921 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 10 
    40 - 59% = 9 
    60 - 79% = 12 
    80 - 99% = 4920 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 150.50, total records: 168114 
    Average version length: 146.01, total versions: 611, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 8, data page slots: 5048 
    Data pages: 4024, average fill: 86% 
    Primary pages: 4023, secondary pages: 1, swept pages: 1 
    Empty pages: 35, full pages: 3978 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3978 
 
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.37, total records: 2115741 
    Average version length: 52.94, total versions: 55243, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25520 
    Data pages: 25520, average fill: 71% 
    Primary pages: 25520, secondary pages: 0, swept pages: 10018 
    Empty pages: 246, full pages: 21041 
    Fill distribution: 
     0 - 19% = 452 
    20 - 39% = 424 
    40 - 59% = 1000 
    60 - 79% = 23147 
    80 - 99% = 497 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2591, nodes: 2115741 
    Average node length: 5.44, total dup: 1974618, max dup: 2067 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182549, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 236 
        40 - 59% = 1758 
        60 - 79% = 291 
        80 - 99% = 300 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2115741 
    Average node length: 5.69, total dup: 1899349, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377858, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2381 
        60 - 79% = 354 
        80 - 99% = 17 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2156, nodes: 2115741 
    Average node length: 4.96, total dup: 2115641, max dup: 28347 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180211, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 200 
        40 - 59% = 1181 
        60 - 79% = 347 
        80 - 99% = 428 
 
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: 38.98, total records: 149872 
    Average version length: 69.17, total versions: 65462, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.23 
    Pointer pages: 3, data page slots: 4208 
    Data pages: 3391, average fill: 51% 
    Primary pages: 3391, secondary pages: 0, swept pages: 596 
    Empty pages: 789, full pages: 1750 
    Fill distribution: 
     0 - 19% = 1060 
    20 - 39% = 211 
    40 - 59% = 200 
    60 - 79% = 728 
    80 - 99% = 1192 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 98290, depth: 3, leaf buckets: 226, nodes: 149872 
    Average node length: 6.42, total dup: 130386, max dup: 29 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25267, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 38 
        40 - 59% = 116 
        60 - 79% = 58 
        80 - 99% = 12 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.70, total records: 7291209 
    Average version length: 68.76, total versions: 450947, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 63, data page slots: 102512 
    Data pages: 102512, average fill: 76% 
    Primary pages: 102512, secondary pages: 0, swept pages: 19491 
    Empty pages: 20, full pages: 91409 
    Fill distribution: 
     0 - 19% = 129 
    20 - 39% = 603 
    40 - 59% = 3173 
    60 - 79% = 89213 
    80 - 99% = 9394 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10807, nodes: 7291209 
    Average node length: 6.51, total dup: 6308328, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1622834, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1390 
        40 - 59% = 5908 
        60 - 79% = 2937 
        80 - 99% = 558 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8552, nodes: 7291209 
    Average node length: 5.39, total dup: 7006042, max dup: 180 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1410228, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1027 
        40 - 59% = 4621 
        60 - 79% = 1688 
        80 - 99% = 1205 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8599, nodes: 7291209 
    Average node length: 5.39, total dup: 7006042, max dup: 180 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1412695, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1090 
        40 - 59% = 4600 
        60 - 79% = 1691 
        80 - 99% = 1214 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.03, total records: 12109122 
    Average version length: 68.76, total versions: 339374, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 103, data page slots: 167888 
    Data pages: 167888, average fill: 77% 
    Primary pages: 167888, secondary pages: 0, swept pages: 72343 
    Empty pages: 2, full pages: 157997 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 383 
    40 - 59% = 2848 
    60 - 79% = 157760 
    80 - 99% = 6870 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18347, nodes: 12109122 
    Average node length: 6.58, total dup: 10554872, max dup: 59 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2377413, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 2179 
        40 - 59% = 10827 
        60 - 79% = 4401 
        80 - 99% = 902 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.82, total records: 1833495 
    Average version length: 69.13, total versions: 750958, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.09 
    Pointer pages: 27, data page slots: 42568 
    Data pages: 30270, average fill: 70% 
    Primary pages: 30270, secondary pages: 0, swept pages: 6455 
    Empty pages: 2137, full pages: 22274 
    Fill distribution: 
     0 - 19% = 3435 
    20 - 39% = 1623 
    40 - 59% = 1721 
    60 - 79% = 11126 
    80 - 99% = 12365 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2407, nodes: 1833495 
    Average node length: 5.51, total dup: 1759871, max dup: 99 
    Average key length: 2.55, compression ratio: 16.48 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 122835, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 516 
        40 - 59% = 1178 
        60 - 79% = 575 
        80 - 99% = 126 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.14, total records: 1290893 
    Average version length: 69.13, total versions: 633567, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.59 
    Pointer pages: 21, data page slots: 33056 
    Data pages: 28872, average fill: 52% 
    Primary pages: 28872, secondary pages: 0, swept pages: 6381 
    Empty pages: 6257, full pages: 15683 
    Fill distribution: 
     0 - 19% = 9389 
    20 - 39% = 1336 
    40 - 59% = 1023 
    60 - 79% = 6364 
    80 - 99% = 10760 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1765, nodes: 1290893 
    Average node length: 5.80, total dup: 1204510, max dup: 109 
    Average key length: 2.86, compression ratio: 14.70 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 182654, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 352 
        40 - 59% = 873 
        60 - 79% = 437 
        80 - 99% = 100 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.90, total records: 9277174 
    Average version length: 68.95, total versions: 672682, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 89, data page slots: 144608 
    Data pages: 144592, average fill: 69% 
    Primary pages: 144592, secondary pages: 0, swept pages: 42677 
    Empty pages: 202, full pages: 78096 
    Fill distribution: 
     0 - 19% = 941 
    20 - 39% = 5761 
    40 - 59% = 22687 
    60 - 79% = 105131 
    80 - 99% = 10072 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13475, nodes: 9277174 
    Average node length: 6.69, total dup: 7695460, max dup: 27 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1971475, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1297 
        40 - 59% = 6540 
        60 - 79% = 4895 
        80 - 99% = 739 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21125881 
    Average version length: 82.90, total versions: 15872, 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: 318456 
    Data pages: 318456, average fill: 81% 
    Primary pages: 318456, secondary pages: 0, swept pages: 12031 
    Empty pages: 44, full pages: 317504 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 57 
    40 - 59% = 150 
    60 - 79% = 27313 
    80 - 99% = 290867 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19496, nodes: 21125881 
    Average node length: 5.72, total dup: 20645431, max dup: 147 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278868, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 8409 
        60 - 79% = 538 
        80 - 99% = 10541 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17155, nodes: 21125881 
    Average node length: 6.31, total dup: 18566354, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914181, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 11 
        40 - 59% = 772 
        60 - 79% = 295 
        80 - 99% = 16074 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21251, nodes: 21125881 
    Average node length: 6.35, total dup: 18484841, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3572377, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1 
        40 - 59% = 8612 
        60 - 79% = 615 
        80 - 99% = 12012 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16100, nodes: 21125881 
    Average node length: 5.56, total dup: 21125781, max dup: 231444 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942971, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 2906 
        60 - 79% = 380 
        80 - 99% = 12797 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.45, total records: 9643101 
    Average version length: 82.60, total versions: 580121, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 106, data page slots: 172592 
    Data pages: 172568, average fill: 69% 
    Primary pages: 172568, secondary pages: 0, swept pages: 66242 
    Empty pages: 677, full pages: 94686 
    Fill distribution: 
     0 - 19% = 2091 
    20 - 39% = 8732 
    40 - 59% = 29598 
    60 - 79% = 71860 
    80 - 99% = 60287 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11403, nodes: 9643101 
    Average node length: 5.38, total dup: 9335908, max dup: 204 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2099101, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 142 
        40 - 59% = 8263 
        60 - 79% = 2951 
        80 - 99% = 46 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13489, nodes: 9643101 
    Average node length: 6.25, total dup: 7995219, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1438900, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 4071 
        40 - 59% = 4210 
        60 - 79% = 2510 
        80 - 99% = 2556 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12719, nodes: 9643101 
    Average node length: 6.00, total dup: 8368879, max dup: 36 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2290450, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 150 
        40 - 59% = 9288 
        60 - 79% = 3216 
        80 - 99% = 64 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10125, nodes: 9643101 
    Average node length: 5.15, total dup: 9643001, max dup: 150928 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1482116, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1276 
        40 - 59% = 5042 
        60 - 79% = 1658 
        80 - 99% = 2104 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.97, total records: 11376638 
    Average version length: 82.55, total versions: 460616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 119, data page slots: 193920 
    Data pages: 192464, average fill: 73% 
    Primary pages: 192464, secondary pages: 0, swept pages: 69543 
    Empty pages: 3375, full pages: 142657 
    Fill distribution: 
     0 - 19% = 5495 
    20 - 39% = 7661 
    40 - 59% = 18619 
    60 - 79% = 42592 
    80 - 99% = 118097 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13145, nodes: 11376638 
    Average node length: 5.30, total dup: 11266904, max dup: 646 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2365121, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 123 
        40 - 59% = 9120 
        60 - 79% = 3759 
        80 - 99% = 142 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10467, nodes: 11376638 
    Average node length: 5.50, total dup: 10880714, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 709716, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 164 
        20 - 39% = 848 
        40 - 59% = 2508 
        60 - 79% = 1825 
        80 - 99% = 5122 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15030, nodes: 11376638 
    Average node length: 6.02, total dup: 9929355, max dup: 82 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2381625, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 145 
        40 - 59% = 10649 
        60 - 79% = 4078 
        80 - 99% = 158 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10811, nodes: 11376638 
    Average node length: 5.22, total dup: 11376538, max dup: 184588 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 698354, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 80 
        20 - 39% = 849 
        40 - 59% = 4765 
        60 - 79% = 1565 
        80 - 99% = 3552 
 
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: 77.79, total records: 9758552 
    Average version length: 82.89, total versions: 582393, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 108, data page slots: 175864 
    Data pages: 175824, average fill: 69% 
    Primary pages: 175824, secondary pages: 0, swept pages: 68011 
    Empty pages: 681, full pages: 95331 
    Fill distribution: 
     0 - 19% = 2089 
    20 - 39% = 9332 
    40 - 59% = 31208 
    60 - 79% = 72729 
    80 - 99% = 60466 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11854, nodes: 9758552 
    Average node length: 5.19, total dup: 9729840, max dup: 1754 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1908585, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1503 
        40 - 59% = 7904 
        60 - 79% = 1829 
        80 - 99% = 581 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13626, nodes: 9758552 
    Average node length: 6.26, total dup: 8090337, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1406873, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 189 
        20 - 39% = 4098 
        40 - 59% = 4111 
        60 - 79% = 2570 
        80 - 99% = 2658 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12481, nodes: 9758552 
    Average node length: 5.45, total dup: 9323406, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2042993, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1457 
        40 - 59% = 8848 
        60 - 79% = 1592 
        80 - 99% = 560 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10389, nodes: 9758552 
    Average node length: 5.16, total dup: 9758452, max dup: 152630 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1503196, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1350 
        40 - 59% = 5318 
        60 - 79% = 1616 
        80 - 99% = 2056 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.11, total records: 580666 
    Average version length: 68.76, total versions: 8999, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8032 
    Data pages: 8032, average fill: 76% 
    Primary pages: 8032, secondary pages: 0, swept pages: 3447 
    Empty pages: 3, full pages: 6940 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 28 
    40 - 59% = 157 
    60 - 79% = 7685 
    80 - 99% = 158 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42585, depth: 3, leaf buckets: 739, nodes: 580666 
    Average node length: 5.95, total dup: 494430, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100946, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 528 
        60 - 79% = 95 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30632, depth: 3, leaf buckets: 762, nodes: 580666 
    Average node length: 6.15, total dup: 476289, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100996, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 535 
        60 - 79% = 104 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 570, nodes: 580666 
    Average node length: 4.86, total dup: 580566, max dup: 9173 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89634, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 323 
        60 - 79% = 84 
        80 - 99% = 130 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar  3 01:12:00 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7752845 117469 1 0.0000 0.0000
DOC_LIST 2245430 121415 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 231843 602 57900.0000 0.0000
INVNT_TURNOVER_LOG 109398 93687 1 0.0000 0.0000
MONEY_SALDO 49 17065 959 34800.0000 0.0000
MONEY_TURNOVER_LOG 1844 1635 1 0.0000 0.0000
PDISTR 813672 74907 4 0.0000 0.0000
PERF_SPLIT_0 183697 1505 1 0.0000 0.0000
PERF_SPLIT_1 169584 246 1 0.0000 0.0000
PERF_SPLIT_2 165409 3309 1 0.0000 0.0000
PERF_SPLIT_3 146148 245 1 0.0000 0.0000
PERF_SPLIT_4 163709 1234 1 0.0000 0.0000
PERF_SPLIT_5 165232 2980 1 0.0000 0.0000
PERF_SPLIT_6 174397 5140 1 0.0000 0.0000
PERF_SPLIT_7 181336 20293 1 0.0000 0.0000
PERF_SPLIT_8 207617 28066 1 0.0000 0.0000
PERF_SPLIT_9 168114 611 1 0.0000 0.0000
PSTORNED 2115741 55243 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 149872 65462 1 0.0000 0.0000
XQD_1000_3300 7291209 450947 1 0.0000 0.0000
XQD_1200_2000 12109122 339374 1 0.0000 0.0000
XQD_2000_3300 1833495 750958 1 0.0000 0.0000
XQD_2100_3300 1290893 633567 1 0.0000 0.0000
XQD_3300_3400 9277174 672682 1 0.0000 0.0000
XQS_1000_1200 21125881 15872 1 0.0000 0.0000
XQS_1000_3300 9643101 580121 1 0.0000 0.0000
XQS_1200_2000 11376638 460616 1 0.0000 0.0000
XQS_2100_3300 9758552 582393 1 0.0000 0.0000
XQS_3300_3400 580666 8999 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 ---
:77: 
:78: mscs-test-161.budzdorov.ru    Sun Mar  3 01:10:04 2024
:79:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:80: 
:81: 
:82: mscs-test-161.budzdorov.ru    Sun Mar  3 01:10:19 2024
:83:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:84: 
--- end of diff output ---

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

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