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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-12 10:07:52
DTS_END                         2024-03-12 10:07:52.4310
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/41126
TRN_ID                          174491
ATT_ID                          526
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: 9613.10 19279 961310
customer order: creation 177.22 386 17722
customer order: refuse 15.46 341 1546
order to supplier: creation 46.07 1265 4607
order to supplier: removal 3.74 91670 374
invoice (draft): creation 46.35 2888 4635
invoice (draft): removal 54.44 690 5444
invoice accept: apply 42.51 20709 4251
invoice accept: cancel 49.36 734 4936
customer reserve: creation 4068.78 200 406878
customer reserve: removal 4808.96 57 480896
realization accept: apply 85.63 199 8563
realization accept: cancel 82.36 129 8236
payment from customer: creation 61.56 125 6156
payment from customer: removal 5.87 88 587
payment to supplier: creation 50.24 150 5024
payment to supplier: removal 3.33 125 333
service: total inventory turnovers 3.92 3561 392
service: total monetary turnovers 6.24 590 624
service: aggregate perf. data 1.03 15853 103
service: refresh index statistics 0.03 245811 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-03-2024 10:09:32 to 12-03-2024 10:09:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2157
TEST_TIME 2 3337
TEST_TIME 3 4818
TEST_TIME 4 4227
TEST_TIME 5 4713
TEST_TIME 6 5380
TEST_TIME 7 5579
TEST_TIME 8 5914
TEST_TIME 9 5649
TEST_TIME 10 5833
TEST_TIME 11 5780
TEST_TIME 12 5764
TEST_TIME 13 5838
TEST_TIME 14 5861
TEST_TIME 15 6027
TEST_TIME 16 6190
TEST_TIME 17 6643
TEST_TIME 18 6708
TEST_TIME 19 6742
TEST_TIME 20 7244
TEST_TIME 21 7558
TEST_TIME 22 7854
TEST_TIME 23 7891
TEST_TIME 24 8402
TEST_TIME 25 9679
TEST_TIME 26 9926
TEST_TIME 27 9937
TEST_TIME 28 9816
TEST_TIME 29 9671
TEST_TIME 30 9493
TEST_TIME 31 9370
TEST_TIME 32 9350
TEST_TIME 33 9263
TEST_TIME 34 9267
TEST_TIME 35 9154
TEST_TIME 36 9214
TEST_TIME 37 9531
TEST_TIME 38 9392
TEST_TIME 39 9238
TEST_TIME 40 9238
TEST_TIME 41 9182
TEST_TIME 42 9322
TEST_TIME 43 9241
TEST_TIME 44 9389
TEST_TIME 45 9372
TEST_TIME 46 9531
TEST_TIME 47 9699
TEST_TIME 48 9695
TEST_TIME 49 9769
TEST_TIME 50 9801
TEST_TIME 51 9795
TEST_TIME 52 9823
TEST_TIME 53 9787
TEST_TIME 54 9887
TEST_TIME 55 9920
TEST_TIME 56 9756
TEST_TIME 57 9673
TEST_TIME 58 9667
TEST_TIME 59 9603
TEST_TIME 60 9547
TEST_TIME 61 9628
TEST_TIME 62 9603
TEST_TIME 63 9568
TEST_TIME 64 9481
TEST_TIME 65 9376
TEST_TIME 66 9402
TEST_TIME 67 9414
TEST_TIME 68 9429
TEST_TIME 69 9429
TEST_TIME 70 9490
TEST_TIME 71 9520
TEST_TIME 72 9597
TEST_TIME 73 9589
TEST_TIME 74 9607
TEST_TIME 75 9655
TEST_TIME 76 9649
TEST_TIME 77 9700
TEST_TIME 78 9800
TEST_TIME 79 9842
TEST_TIME 80 9761
TEST_TIME 81 9720
TEST_TIME 82 9636
TEST_TIME 83 9586
TEST_TIME 84 9616
TEST_TIME 85 9579
TEST_TIME 86 9517
TEST_TIME 87 9484
TEST_TIME 88 9501
TEST_TIME 89 9484
TEST_TIME 90 9534
TEST_TIME 91 9518
TEST_TIME 92 9505
TEST_TIME 93 9567
TEST_TIME 94 9555
TEST_TIME 95 9546
TEST_TIME 96 9558
TEST_TIME 97 9682
TEST_TIME 98 9702
TEST_TIME 99 9687
TEST_TIME 100 9620

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-03-2024 10:09:35 to 12-03-2024 10:09:39.

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 1333196 1333196 0 0.00 0 25290 8 0 0
doc_list_biud 1333187 1333187 0 0.00 0 45448 26 0 0
sp_add_invoice_to_stock 4423 4251 172 3.88 37 215053 20710 0 172
sp_cancel_adding_invoice 4936 4936 0 0.00 4 67596 734 0 0
sp_cancel_client_order 1546 1546 0 0.00 4 8191 341 0 0
sp_cancel_customer_reserve 480896 480896 0 0.00 0 45450 57 0 0
sp_cancel_pay_from_customer 587 587 0 0.00 3 3584 88 0 0
sp_cancel_pay_to_supplier 333 333 0 0.00 3 4618 126 0 0
sp_cancel_supplier_invoice 5456 5444 12 0.21 1 26579 690 0 12
sp_cancel_supplier_order 374 374 0 0.00 17 1009647 91670 0 0
sp_cancel_write_off 8236 8236 0 0.00 1 9421 129 0 0
sp_client_order 17722 17722 0 0.00 3 25884 386 0 0
sp_customer_reserve 406878 406878 0 0.00 0 42180 200 0 0
sp_fill_shopping_cart 26957 26957 0 0.00 1 12465 34 0 0
sp_fill_shopping_cart_clo_res 406872 406872 0 0.00 0 19176 15 0 0
sp_get_clo_for_invoice 4246 4246 0 0.00 0 22802 330 0 0
sp_kill_cost_storno 14092 14092 0 0.00 0 10639 64 0 0
sp_kill_qstorno_ret_qs2qd 975846 975846 0 0.00 0 45446 31 0 0
sp_kill_qty_storno 514235 514235 0 0.00 0 45448 66 0 0
sp_lock_selected_doc 17830 17830 0 0.00 0 7795 6 0 0
sp_make_cost_storno 23989 23989 0 0.00 0 17303 68 0 0
sp_multiply_rows_for_pdistr 23985 23985 0 0.00 0 12212 38 0 0
sp_multiply_rows_for_qdistr 17722 17722 0 0.00 0 11912 194 0 0
sp_pay_from_customer 6156 6156 0 0.00 3 12989 126 0 0
sp_pay_to_supplier 5024 5024 0 0.00 4 11863 150 0 0
sp_payment_common 11178 11178 0 0.00 1 11306 25 0 0
sp_qd_handle_on_cancel_clo 1546 1546 0 0.00 0 8184 314 0 0
sp_qd_handle_on_invoice_upd_sts 9181 9181 0 0.00 0 13239 286 0 0
sp_qd_handle_on_reserve_upd_sts 8558 8558 0 0.00 0 14895 61 0 0
sp_reserve_write_off 8563 8563 0 0.00 5 18041 199 0 0
sp_supplier_invoice 4635 4635 0 0.00 5 90883 2888 0 0
sp_supplier_order 4607 4607 0 0.00 5 38241 1266 0 0
srv_aggregate_perf_data 103 103 0 0.00 1612 423758 15854 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 2185 180839 44051 0 0
srv_find_qd_qs_mism 917667 917667 0 0.00 0 25286 7 0 0
srv_make_invnt_saldo 392 392 0 0.00 44 94399 3562 0 0
srv_make_money_saldo 624 624 0 0.00 1 16292 590 0 0
srv_recalc_idx_stat 3 3 0 0.00 215219 269805 245811 0 0
t$perf-abend:sp_add_invoice_to_stock 172 172 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 4251 4251 0 0.00 0 14555 172 0 0
t$perf-norm:sp_cancel_adding_invoice 336 336 0 0.00 0 3706 82 0 0
t$perf-norm:sp_cancel_client_order 1546 1546 0 0.00 0 712 7 0 0
t$perf-norm:sp_cancel_customer_reserve 598 598 0 0.00 0 4154 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 587 587 0 0.00 0 601 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 333 333 0 0.00 0 302 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 365 365 0 0.00 0 342 9 0 0
t$perf-norm:sp_cancel_supplier_order 374 374 0 0.00 0 32969 1489 0 0
t$perf-norm:sp_cancel_write_off 889 889 0 0.00 0 4514 9 0 0
t$perf-norm:sp_client_order 17722 17722 0 0.00 0 5438 14 0 0
t$perf-norm:sp_customer_reserve 883 883 0 0.00 0 3214 12 0 0
t$perf-norm:sp_pay_from_customer 6156 6156 0 0.00 0 8045 8 0 0
t$perf-norm:sp_pay_to_supplier 5024 5024 0 0.00 0 4062 9 0 0
t$perf-norm:sp_reserve_write_off 8563 8563 0 0.00 0 6157 7 0 0
t$perf-norm:sp_supplier_invoice 4635 4635 0 0.00 0 5451 18 0 0
t$perf-norm:sp_supplier_order 4607 4607 0 0.00 0 3519 13 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 112 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 14 1 0 0
t$perf-norm:srv_make_invnt_saldo 392 392 0 0.00 0 462 6 0 0
t$perf-norm:srv_make_money_saldo 624 624 0 0.00 0 1185 6 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 27 10 0 0
v_add_invoice_to_stock 8831 8488 343 3.88 0 6675 22 0 343
v_all_customers 32952 32952 0 0.00 0 19 1 0 0
v_all_suppliers 26440 26440 0 0.00 0 30 1 0 0
v_all_wares 35434 35434 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 672 672 0 0.00 0 2023 11 0 0
v_cancel_client_order 3092 3092 0 0.00 0 1897 3 0 0
v_cancel_customer_prepayment 1174 1174 0 0.00 0 2027 10 0 0
v_cancel_customer_reserve 1196 1196 0 0.00 0 2022 9 0 0
v_cancel_payment_to_supplier 666 666 0 0.00 0 2278 15 0 0
v_cancel_supplier_invoice 754 730 24 3.18 0 1229 15 0 24
v_cancel_supplier_order 748 748 0 0.00 0 1248 6 0 0
v_cancel_write_off 1778 1778 0 0.00 0 3698 14 0 0
v_max_id_clo_ord 4607 4607 0 0.00 0 1843 2 0 0
v_max_id_clo_res 882 882 0 0.00 0 1548 12 0 0
v_max_id_ord_sup 4632 4632 0 0.00 0 4429 4 0 0
v_max_non_paid_invoice 1041 1041 0 0.00 0 3662 8 0 0
v_max_non_paid_realizn 2957 2957 0 0.00 0 1188 3 0 0
v_min_id_clo_ord 4607 4607 0 0.00 0 7993 15 0 0
v_min_id_clo_res 882 882 0 0.00 0 3608 8 0 0
v_min_id_ord_sup 4632 4632 0 0.00 0 5643 9 0 0
v_min_non_paid_invoice 5022 5022 0 0.00 0 8166 13 0 0
v_min_non_paid_realizn 6156 6156 0 0.00 0 11301 20 0 0
v_our_firm 8878 8878 0 0.00 0 22 1 0 0
v_reserve_write_off 17111 17111 0 0.00 0 6992 7 0 0
x_lock_depdocs_on_canc_invoice 10015 10015 0 0.00 0 18393 117 0 0
x_lock_depdocs_on_canc_sup_ord 374 374 0 0.00 0 18215 328 0 0
x_make_qstorno_1000_1200 4607 4607 0 0.00 1 38185 1188 0 0
x_make_qstorno_1200_2000 4635 4635 0 0.00 2 87296 2768 0 0
x_make_qstorno_2100_3300 406878 406878 0 0.00 0 42175 182 0 0

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

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:55 4 8192000000 8804564912 8817995776 9316960 0.113 3 3 4 0 9536576 132656 86960
08:08:56 25967 8192000000 9721468224 10019557376 796997072 8.866 100 88 176 0 825942400 7656752 21288576
08:10:28 19621 8192000000 9767124928 10072141824 838461024 9.284 100 91 182 0 871724848 11079184 22184640
08:11:52 15672 8192000000 9795031360 10111381504 866052112 9.561 100 87 172 0 903942000 17572192 20317696
08:13:22 10906 8192000000 9854511664 10189979648 914848304 10.045 100 81 162 0 971093872 38553344 17692224
08:14:35 6517 8192000000 9905492464 10250321920 949879712 10.390 100 77 153 0 1015428048 49584192 15964144
08:15:45 7009 8192000000 9948318544 10304471040 974570800 10.631 100 69 133 0 1055773088 67112240 14090048
08:16:55 1760 8192000000 9986820032 10343976960 1006282272 10.939 100 86 171 1 1115354272 92402048 16669952
08:17:59 3313 8192000000 9998614672 10366562304 1029285120 11.162 100 74 145 0 1116199920 72893936 14020864
08:19:04 1148 8192000000 10012737408 10385620992 1058717936 11.444 100 88 177 2 1128434704 51566000 18150768
08:20:07 36510 8192000000 10022576224 10405445632 1061983120 11.475 100 68 134 0 1133940320 58459760 13497440
08:21:44 4600 8192000000 9987933296 10381570048 1070606640 11.558 100 40 78 1 1095997792 17265968 8125184
08:22:50 9146 8192000000 9987735952 10389823488 1077251232 11.621 100 35 72 1 1104836752 19415568 8169952
08:24:04 7237 8192000000 9993943936 10393501696 1076577472 11.615 99 28 55 1 1099152528 16951552 5623504
08:25:12 33012 8192000000 10011646464 10408251392 1089544192 11.738 100 52 102 0 1117662800 17176848 10941760
08:26:46 5253 8192000000 10011652976 10416881664 1093958752 11.780 100 32 65 1 1132628368 31895424 6774192
08:27:54 5274 8192000000 10005140624 10410070016 1097963392 11.818 100 25 49 2 1123184000 20222608 4998000
08:29:07 36436 8192000000 10035367888 10443780096 1096433776 11.804 99 34 67 1 1134962528 31605696 6923056
08:30:52 46751 8192000000 10017095856 10412261376 1058975984 11.447 95 49 92 1 1093793792 25242992 9574816
08:32:44 13409 8192000000 10080980176 10484924416 1100339808 11.841 99 53 105 0 1185916432 75225920 10350704
08:34:02 16083 8192000000 10081942064 10475114496 1107032416 11.904 100 66 130 1 1188985328 67777664 14175248
08:35:21 29456 8192000000 10052310448 10478854144 1096715424 11.806 100 35 68 0 1176945088 72734208 7495456
08:37:04 21080 8192000000 10085655696 10497372160 1100543840 11.843 100 30 60 0 1195603328 88820304 6239184
08:38:30 9808 8192000000 10139887808 10544500736 1110347840 11.936 99 55 110 0 1245153408 122910176 11895392
08:39:46 21616 8192000000 10124118880 10510376960 1041046064 11.275 94 43 83 0 1180465904 130413776 9006064
08:41:15 2295 8192000000 10174288944 10558656512 1108919872 11.922 100 58 113 0 1273989136 152855216 12214048
08:42:23 3740 8192000000 10246134448 10634686464 1112413952 11.955 98 72 140 1 1338384032 210154288 15815792
08:43:32 2842 8192000000 10308299328 10700894208 1133590176 12.155 100 77 155 0 1414545776 262912176 18043424
08:44:45 4960 8192000000 10337912288 10744811520 1154580288 12.352 100 66 131 1 1438958256 269896736 14481232
08:45:56 3070 8192000000 10408892352 10806030336 1156076784 12.367 100 83 164 1 1504624064 330306896 18240384
08:47:04 2775 8192000000 10414441152 10840690688 1158570368 12.390 100 74 143 0 1507893520 332556848 16766304
08:48:10 2182 8192000000 10422956672 10829606912 1162934528 12.431 100 78 150 1 1527569424 346867232 17767664
08:49:15 14412 8192000000 10400550976 10837721088 1167371648 12.472 100 51 102 0 1496408432 317148784 11888000
08:50:32 26047 8192000000 10397045952 10831892480 1146608368 12.278 100 23 46 0 1486245120 333238560 6398192
08:52:03 36053 8192000000 10148312720 10764120064 1135591968 12.174 100 13 26 1 1356457216 217345728 3519520
08:53:40 111813 8192000000 10076078688 10550312960 1130052240 12.122 99 7 12 1 1164216864 33099904 1064720
08:56:33 111797 8192000000 10091891824 10535227392 1114495440 11.975 97 33 64 0 1177606368 56114960 6995968
08:59:34 54494 8192000000 10089103248 10562400256 1146701984 12.279 100 25 51 0 1224921056 72400384 5818688
09:01:47 10431 8192000000 10111623440 10561310720 1154531040 12.352 100 17 34 1 1227696384 69448832 3716512
09:03:00 33666 8192000000 10199800080 10679771136 1154674960 12.353 99 34 68 0 1321989456 159521248 7793248
09:04:46 45246 8192000000 10125101376 10622582784 1153342560 12.341 100 8 16 0 1252331200 97361072 1627568
09:06:33 52130 8192000000 10148111120 10594861056 1144956928 12.262 99 15 29 0 1242148448 94015952 3175568
09:08:25 54325 8192000000 10116425632 10569564160 1133709744 12.156 98 18 36 0 1211666960 73630896 4326320
09:10:21 33775 8192000000 10145278768 10578526208 1136131760 12.179 98 34 68 0 1212765392 70047568 6586064
09:11:58 47579 8192000000 10131936896 10592325632 1143401920 12.248 99 22 45 2 1209653616 61906656 4345040
09:13:51 32070 8192000000 10109808640 10595446784 1134637232 12.165 98 30 60 0 1199402704 58906528 5858944
09:15:38 123579 8192000000 10106662736 10562076672 1093975008 11.780 95 28 56 0 1143326048 43883456 5467584
09:18:42 60065 8192000000 10060857392 10525937664 1104835104 11.883 97 10 20 0 1146637984 39901776 1901104
09:20:49 60292 8192000000 10126669776 10643165184 1123386096 12.059 98 40 80 0 1218350608 87235056 7729456
09:22:58 95342 8192000000 10060755824 10490421248 1058238848 11.440 94 22 44 2 1089954416 27293504 4422064
09:25:52 44966 8192000000 10042943344 10497056768 1069959792 11.552 97 26 52 0 1118676608 43880464 4836352
09:27:37 8450 8192000000 10085762144 10499039232 1094436336 11.785 99 63 127 1 1176669552 69024576 13208640
09:28:47 16922 8192000000 10046437456 10486923264 1078736096 11.635 97 37 73 0 1120212736 34910816 6565824
09:30:05 48880 8192000000 10055046864 10505109504 1098478960 11.823 99 18 37 0 1164409968 61700720 4230288
09:31:59 41009 8192000000 10083938384 10524991488 1099511328 11.833 100 13 26 0 1180244960 77653296 3080336
09:34:01 39133 8192000000 10063232272 10559287296 1112193296 11.953 100 9 16 0 1192162528 78503168 1466064
09:35:40 52984 8192000000 10102043648 10546913280 1114858368 11.978 99 32 62 1 1185919712 64459328 6602016
09:37:36 50577 8192000000 10088477664 10548252672 1119125760 12.019 99 20 40 0 1228175328 104988272 4061296
09:39:29 58879 8192000000 10060011136 10520301568 1110736752 11.939 98 8 14 0 1159232832 47092656 1403424
09:41:31 51788 8192000000 10070640784 10538070016 1131253808 12.133 99 26 51 1 1216604160 79723856 5626496
09:43:26 21399 8192000000 10137985504 10573713408 1149414560 12.304 100 27 54 1 1221460592 66496352 5549680
09:44:50 48133 8192000000 10092432192 10547838976 1140607648 12.221 100 20 38 0 1248074304 103585952 3880704
09:46:38 133012 8192000000 10066311584 10533101568 1116808336 11.997 97 23 46 1 1154659792 33307296 4544160
09:49:56 14123 8192000000 10094826752 10518208512 1147278448 12.284 100 68 134 2 1190337568 29840016 13219104
09:51:11 70332 8192000000 10084308512 10570223616 1147745840 12.288 100 15 30 0 1226952368 75961040 3245488
09:53:25 67591 8192000000 10111690864 10575097856 1155375312 12.360 100 17 34 0 1209096368 49895488 3825568
09:56:06 50030 8192000000 10111962656 10569236480 1147391664 12.285 99 13 26 1 1207271216 57173056 2706496
09:58:36 31065 8192000000 10074032688 10509578240 1114959488 11.979 97 22 43 0 1142893728 23746240 4188000
10:00:07 102126 8192000000 10059057968 10525200384 1112653008 11.958 97 12 24 0 1159150320 44193920 2303392
10:02:55 65538 8192000000 10141086944 10609844224 1106111120 11.896 97 28 54 0 1159160464 47474816 5574528
10:05:06 180838 8192000000 8893247264 9079980032 59759440 0.724 6 2 4 0 60847744 802240 286064

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 172 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 12-03-2024 10:10:01 to 12-03-2024 10:10:03.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Tue Mar 12 10:10:04 2024 
 
Database header page information: 
    Flags            0 
    Generation        91345 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    174789 
    Oldest active        174790 
    Oldest snapshot        174790 
    Next transaction    174791 
    Sequence number        0 
    Next attachment ID    694 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.54, total records: 7659683 
    Average version length: 48.16, total versions: 69342, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88496 
    Data pages: 88496, average fill: 69% 
    Primary pages: 88495, secondary pages: 1, swept pages: 44503 
    Empty pages: 0, full pages: 59400 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 97 
    40 - 59% = 2341 
    60 - 79% = 86028 
    80 - 99% = 19 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23201, nodes: 7659683 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1651713, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 302 
        20 - 39% = 2103 
        40 - 59% = 4009 
        60 - 79% = 2632 
        80 - 99% = 14155 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13492, nodes: 7659683 
    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: 1475580, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1763 
        40 - 59% = 1906 
        60 - 79% = 1266 
        80 - 99% = 8556 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8328, nodes: 7659683 
    Average node length: 6.60, total dup: 5756607, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1468673, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 1096 
        40 - 59% = 1267 
        60 - 79% = 1069 
        80 - 99% = 4754 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.63, total records: 2191780 
    Average version length: 58.88, total versions: 34895, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28688 
    Data pages: 28688, average fill: 70% 
    Primary pages: 28685, secondary pages: 3, swept pages: 15419 
    Empty pages: 8, full pages: 13771 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 78 
    40 - 59% = 1622 
    60 - 79% = 26909 
    80 - 99% = 59 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4533, nodes: 2191780 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 667248, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 999 
        40 - 59% = 802 
        60 - 79% = 830 
        80 - 99% = 1902 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2411, nodes: 2192490 
    Average node length: 4.97, total dup: 2191593, max dup: 18290 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1249522, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 252 
        40 - 59% = 1416 
        60 - 79% = 515 
        80 - 99% = 227 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1777, nodes: 2191780 
    Average node length: 4.97, total dup: 2191730, max dup: 130260 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1053980, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 624 
        60 - 79% = 43 
        80 - 99% = 1098 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4323, nodes: 2191780 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 667248, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 656 
        40 - 59% = 603 
        60 - 79% = 943 
        80 - 99% = 2033 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.36, total records: 400 
    Average version length: 29.63, total versions: 1538, max versions: 4 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 58% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 4, full pages: 11 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 11.63, total records: 130687 
    Average version length: 68.29, total versions: 124899, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.57 
    Pointer pages: 6, data page slots: 3480 
    Data pages: 2664, average fill: 67% 
    Primary pages: 2663, secondary pages: 1, swept pages: 373 
    Empty pages: 430, full pages: 1594 
    Fill distribution: 
     0 - 19% = 491 
    20 - 39% = 178 
    40 - 59% = 246 
    60 - 79% = 225 
    80 - 99% = 1524 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1712352, depth: 3, leaf buckets: 418, nodes: 130687 
    Average node length: 13.21, total dup: 11625, max dup: 2 
    Average key length: 10.52, compression ratio: 2.57 
    Average prefix length: 19.38, average data length: 7.62 
    Clustering factor: 93404, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 304 
        60 - 79% = 77 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 49, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 38% 
    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 PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 20.55, total records: 2309 
    Average version length: 44.02, total versions: 1549, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 2.82 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 71% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 20 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 10 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91464, depth: 2, leaf buckets: 3, nodes: 2309 
    Average node length: 4.20, total dup: 2211, max dup: 238 
    Average key length: 2.46, compression ratio: 7.73 
    Average prefix length: 18.58, average data length: 0.42 
    Clustering factor: 1177, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.62, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 37.10, total records: 824461 
    Average version length: 37.93, total versions: 15391, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8872 
    Data pages: 8872, average fill: 64% 
    Primary pages: 8870, secondary pages: 2, swept pages: 4819 
    Empty pages: 8, full pages: 4107 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 56 
    40 - 59% = 1189 
    60 - 79% = 7564 
    80 - 99% = 38 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 889, nodes: 817681 
    Average node length: 4.89, total dup: 817632, max dup: 161133 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89636, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 149 
        40 - 59% = 454 
        60 - 79% = 183 
        80 - 99% = 102 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 939, nodes: 817681 
    Average node length: 5.89, total dup: 727926, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161043, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 36 
        40 - 59% = 494 
        60 - 79% = 87 
        80 - 99% = 319 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 973, nodes: 817681 
    Average node length: 5.90, total dup: 727926, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162935, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 74 
        40 - 59% = 512 
        60 - 79% = 80 
        80 - 99% = 306 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1158, nodes: 817681 
    Average node length: 5.98, total dup: 727926, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154705, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 247 
        40 - 59% = 600 
        60 - 79% = 216 
        80 - 99% = 90 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.75, total records: 5470 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.37, total fragments: 27, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 128 
    Data pages: 94, average fill: 57% 
    Primary pages: 81, secondary pages: 13, swept pages: 60 
    Empty pages: 9, full pages: 61 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5470 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5190, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5470 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 174, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 79262 
    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: 824 
    Data pages: 824, average fill: 66% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 823 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 823 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35312, depth: 2, leaf buckets: 101, nodes: 79262 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3035, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.56, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 150.96, total records: 165271 
    Average version length: 151.24, total versions: 417, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 7, data page slots: 5360 
    Data pages: 4104, average fill: 83% 
    Primary pages: 4101, secondary pages: 3, swept pages: 2 
    Empty pages: 32, full pages: 4060 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4058 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 149.97, total records: 157244 
    Average version length: 153.49, total versions: 1574, 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: 4528 
    Data pages: 3896, average fill: 83% 
    Primary pages: 3894, secondary pages: 2, swept pages: 2 
    Empty pages: 21, full pages: 3862 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3860 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.83, total records: 171163 
    Average version length: 151.85, total versions: 1445, 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: 7, data page slots: 4952 
    Data pages: 4256, average fill: 83% 
    Primary pages: 4254, secondary pages: 2, swept pages: 6 
    Empty pages: 45, full pages: 4192 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 4193 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 136.64, total records: 187100 
    Average version length: 154.85, total versions: 18948, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.41 
    Pointer pages: 6, data page slots: 5704 
    Data pages: 4648, average fill: 84% 
    Primary pages: 4646, secondary pages: 2, swept pages: 1 
    Empty pages: 41, full pages: 4595 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4594 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.41, total records: 154866 
    Average version length: 150.96, total versions: 811, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 7, data page slots: 5568 
    Data pages: 3872, average fill: 82% 
    Primary pages: 3870, secondary pages: 2, swept pages: 1 
    Empty pages: 59, full pages: 3799 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3799 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 149.28, total records: 144850 
    Average version length: 152.91, total versions: 1589, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 7, data page slots: 4736 
    Data pages: 3648, average fill: 82% 
    Primary pages: 3645, secondary pages: 3, swept pages: 4 
    Empty pages: 66, full pages: 3530 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 3 
    40 - 59% = 38 
    60 - 79% = 3 
    80 - 99% = 3530 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.05, total records: 182009 
    Average version length: 153.99, total versions: 2891, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 8, data page slots: 4880 
    Data pages: 4520, average fill: 83% 
    Primary pages: 4518, secondary pages: 2, swept pages: 3 
    Empty pages: 40, full pages: 4471 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4469 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 143.32, total records: 158104 
    Average version length: 154.64, total versions: 8611, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.83 
    Pointer pages: 7, data page slots: 4736 
    Data pages: 3936, average fill: 83% 
    Primary pages: 3934, secondary pages: 2, swept pages: 2 
    Empty pages: 40, full pages: 3877 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3877 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 148.97, total records: 140982 
    Average version length: 153.33, total versions: 1749, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 3960 
    Data pages: 3488, average fill: 83% 
    Primary pages: 3486, secondary pages: 2, swept pages: 1 
    Empty pages: 26, full pages: 3452 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 0 
    80 - 99% = 3452 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 150.77, total records: 155617 
    Average version length: 151.19, total versions: 429, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 6, data page slots: 5336 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3870, secondary pages: 2, swept pages: 8 
    Empty pages: 42, full pages: 3810 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3809 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.04, total records: 2065683 
    Average version length: 52.91, total versions: 33219, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25760 
    Data pages: 25752, average fill: 69% 
    Primary pages: 25738, secondary pages: 14, swept pages: 12433 
    Empty pages: 245, full pages: 21213 
    Fill distribution: 
     0 - 19% = 472 
    20 - 39% = 380 
    40 - 59% = 1099 
    60 - 79% = 23486 
    80 - 99% = 315 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2552, nodes: 2065683 
    Average node length: 5.45, total dup: 1926419, max dup: 1341 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180806, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 326 
        40 - 59% = 1609 
        60 - 79% = 301 
        80 - 99% = 309 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2751, nodes: 2065683 
    Average node length: 5.70, total dup: 1853371, max dup: 61 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370777, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2476 
        60 - 79% = 235 
        80 - 99% = 34 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2124, nodes: 2065683 
    Average node length: 4.96, total dup: 2065583, max dup: 28452 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178510, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 226 
        40 - 59% = 1086 
        60 - 79% = 420 
        80 - 99% = 391 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 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: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 50.46, total records: 126512 
    Average version length: 69.15, total versions: 39418, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.50 
    Pointer pages: 3, data page slots: 4048 
    Data pages: 3296, average fill: 46% 
    Primary pages: 3296, secondary pages: 0, swept pages: 628 
    Empty pages: 497, full pages: 462 
    Fill distribution: 
     0 - 19% = 707 
    20 - 39% = 383 
    40 - 59% = 998 
    60 - 79% = 1043 
    80 - 99% = 165 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1557712, depth: 3, leaf buckets: 242, nodes: 126512 
    Average node length: 6.58, total dup: 109933, max dup: 14 
    Average key length: 3.99, compression ratio: 10.53 
    Average prefix length: 40.14, average data length: 1.86 
    Clustering factor: 22355, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 109 
        40 - 59% = 109 
        60 - 79% = 22 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.28, total records: 7210448 
    Average version length: 68.70, total versions: 201187, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 68, data page slots: 110720 
    Data pages: 110720, average fill: 70% 
    Primary pages: 110720, secondary pages: 0, swept pages: 62141 
    Empty pages: 1, full pages: 48429 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 595 
    40 - 59% = 9664 
    60 - 79% = 99736 
    80 - 99% = 664 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10861, nodes: 7210448 
    Average node length: 6.51, total dup: 6236278, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1683207, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1662 
        40 - 59% = 5798 
        60 - 79% = 2855 
        80 - 99% = 534 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8737, nodes: 7210448 
    Average node length: 5.39, total dup: 6926220, max dup: 163 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1488704, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 1296 
        40 - 59% = 4759 
        60 - 79% = 1660 
        80 - 99% = 1006 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8781, nodes: 7210448 
    Average node length: 5.39, total dup: 6926220, max dup: 163 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1491101, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1291 
        40 - 59% = 4807 
        60 - 79% = 1717 
        80 - 99% = 962 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.27, total records: 12373510 
    Average version length: 68.67, total versions: 137956, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 111, data page slots: 181136 
    Data pages: 181136, average fill: 72% 
    Primary pages: 181136, secondary pages: 0, swept pages: 108730 
    Empty pages: 6, full pages: 132520 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 500 
    40 - 59% = 6282 
    60 - 79% = 173457 
    80 - 99% = 862 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18588, nodes: 12371192 
    Average node length: 6.64, total dup: 10784106, max dup: 58 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2490231, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 2033 
        40 - 59% = 10346 
        60 - 79% = 5297 
        80 - 99% = 886 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 50.62, total records: 1237018 
    Average version length: 69.12, total versions: 193086, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.49 
    Pointer pages: 26, data page slots: 41384 
    Data pages: 26520, average fill: 47% 
    Primary pages: 26449, secondary pages: 71, swept pages: 12089 
    Empty pages: 4206, full pages: 12829 
    Fill distribution: 
     0 - 19% = 6366 
    20 - 39% = 4816 
    40 - 59% = 2952 
    60 - 79% = 9928 
    80 - 99% = 2458 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1677, nodes: 1049192 
    Average node length: 5.56, total dup: 1006751, max dup: 49 
    Average key length: 2.59, compression ratio: 16.23 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 71180, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 698 
        40 - 59% = 764 
        60 - 79% = 196 
        80 - 99% = 4 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 51.90, total records: 836722 
    Average version length: 69.02, total versions: 74422, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.43 
    Pointer pages: 21, data page slots: 34072 
    Data pages: 28392, average fill: 30% 
    Primary pages: 28391, secondary pages: 1, swept pages: 14470 
    Empty pages: 5643, full pages: 1255 
    Fill distribution: 
     0 - 19% = 10564 
    20 - 39% = 7050 
    40 - 59% = 8033 
    60 - 79% = 2722 
    80 - 99% = 23 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1159, nodes: 672629 
    Average node length: 5.93, total dup: 621198, max dup: 62 
    Average key length: 3.00, compression ratio: 14.01 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 96922, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 527 
        40 - 59% = 497 
        60 - 79% = 125 
        80 - 99% = 8 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.25, total records: 8832157 
    Average version length: 68.77, total versions: 387157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 88, data page slots: 143472 
    Data pages: 143432, average fill: 66% 
    Primary pages: 143411, secondary pages: 21, swept pages: 79088 
    Empty pages: 420, full pages: 50490 
    Fill distribution: 
     0 - 19% = 1011 
    20 - 39% = 3636 
    40 - 59% = 28347 
    60 - 79% = 107842 
    80 - 99% = 2596 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13416, nodes: 8829394 
    Average node length: 6.68, total dup: 7324870, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1967639, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1814 
        40 - 59% = 7004 
        60 - 79% = 4067 
        80 - 99% = 529 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.45, total records: 21142717 
    Average version length: 82.98, total versions: 26413, 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: 319512 
    Data pages: 319512, average fill: 81% 
    Primary pages: 319507, secondary pages: 5, swept pages: 11197 
    Empty pages: 6, full pages: 319502 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 48237 
    80 - 99% = 271265 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19617, nodes: 21142717 
    Average node length: 5.72, total dup: 20661834, max dup: 153 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3282735, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 2 
        40 - 59% = 8645 
        60 - 79% = 523 
        80 - 99% = 10441 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17156, nodes: 21142717 
    Average node length: 6.31, total dup: 18580809, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916104, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 775 
        60 - 79% = 261 
        80 - 99% = 16115 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21428, nodes: 21142717 
    Average node length: 6.35, total dup: 18500122, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3576192, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 3 
        40 - 59% = 8957 
        60 - 79% = 608 
        80 - 99% = 11853 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16099, nodes: 21142717 
    Average node length: 5.56, total dup: 21142617, max dup: 228288 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944990, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 10 
        40 - 59% = 2903 
        60 - 79% = 377 
        80 - 99% = 12807 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 75.56, total records: 9809325 
    Average version length: 82.58, total versions: 914521, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 105, data page slots: 170496 
    Data pages: 170464, average fill: 72% 
    Primary pages: 170425, secondary pages: 39, swept pages: 38051 
    Empty pages: 666, full pages: 118694 
    Fill distribution: 
     0 - 19% = 1714 
    20 - 39% = 5105 
    40 - 59% = 20157 
    60 - 79% = 106851 
    80 - 99% = 36637 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11345, nodes: 9809325 
    Average node length: 5.36, total dup: 9500805, max dup: 209 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2206136, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 80 
        40 - 59% = 7710 
        60 - 79% = 3476 
        80 - 99% = 77 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13650, nodes: 9809325 
    Average node length: 6.23, total dup: 8136127, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1556521, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 3702 
        40 - 59% = 4807 
        60 - 79% = 2586 
        80 - 99% = 2408 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12654, nodes: 9809325 
    Average node length: 5.97, total dup: 8527248, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2406746, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 92 
        40 - 59% = 8660 
        60 - 79% = 3816 
        80 - 99% = 85 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10177, nodes: 9809325 
    Average node length: 5.14, total dup: 9809225, max dup: 148177 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1581563, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1160 
        40 - 59% = 5098 
        60 - 79% = 1801 
        80 - 99% = 2088 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 77.63, total records: 11172297 
    Average version length: 82.51, total versions: 709678, 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: 118, data page slots: 192032 
    Data pages: 190672, average fill: 73% 
    Primary pages: 190516, secondary pages: 156, swept pages: 56473 
    Empty pages: 3001, full pages: 146517 
    Fill distribution: 
     0 - 19% = 4904 
    20 - 39% = 7105 
    40 - 59% = 16609 
    60 - 79% = 90858 
    80 - 99% = 71196 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13093, nodes: 11172297 
    Average node length: 5.29, total dup: 11063356, max dup: 658 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2338502, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 139 
        40 - 59% = 9479 
        60 - 79% = 3386 
        80 - 99% = 88 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10255, nodes: 11172297 
    Average node length: 5.49, total dup: 10684543, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 714368, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 817 
        40 - 59% = 2497 
        60 - 79% = 1749 
        80 - 99% = 5046 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14972, nodes: 11172297 
    Average node length: 6.02, total dup: 9750446, max dup: 80 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2354984, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 166 
        40 - 59% = 11000 
        60 - 79% = 3700 
        80 - 99% = 104 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10615, nodes: 11172297 
    Average node length: 5.22, total dup: 11172197, max dup: 175560 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 701776, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 90 
        20 - 39% = 870 
        40 - 59% = 4635 
        60 - 79% = 1480 
        80 - 99% = 3540 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 76.06, total records: 9904648 
    Average version length: 82.88, total versions: 896342, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.66 
    Pointer pages: 108, data page slots: 174976 
    Data pages: 174920, average fill: 71% 
    Primary pages: 174888, secondary pages: 32, swept pages: 42356 
    Empty pages: 702, full pages: 116823 
    Fill distribution: 
     0 - 19% = 1868 
    20 - 39% = 6695 
    40 - 59% = 23652 
    60 - 79% = 107311 
    80 - 99% = 35394 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11754, nodes: 9904648 
    Average node length: 5.18, total dup: 9876033, max dup: 1616 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2020970, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1330 
        40 - 59% = 7689 
        60 - 79% = 2052 
        80 - 99% = 651 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13791, nodes: 9904648 
    Average node length: 6.25, total dup: 8214539, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1512203, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 162 
        20 - 39% = 3753 
        40 - 59% = 4838 
        60 - 79% = 2511 
        80 - 99% = 2527 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12371, nodes: 9904648 
    Average node length: 5.43, total dup: 9467655, max dup: 108 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2155369, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1290 
        40 - 59% = 8580 
        60 - 79% = 1832 
        80 - 99% = 649 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10395, nodes: 9904648 
    Average node length: 5.15, total dup: 9904548, max dup: 150530 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1586303, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1169 
        40 - 59% = 5462 
        60 - 79% = 1677 
        80 - 99% = 2051 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.80, total records: 579435 
    Average version length: 68.79, total versions: 13366, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 76% 
    Primary pages: 8064, secondary pages: 0, swept pages: 2644 
    Empty pages: 7, full pages: 7615 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 10 
    40 - 59% = 67 
    60 - 79% = 7713 
    80 - 99% = 265 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41563, depth: 3, leaf buckets: 745, nodes: 579435 
    Average node length: 5.95, total dup: 493333, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102176, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 544 
        60 - 79% = 97 
        80 - 99% = 82 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34161, depth: 3, leaf buckets: 764, nodes: 579435 
    Average node length: 6.15, total dup: 475282, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102222, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 535 
        60 - 79% = 103 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 579, nodes: 579435 
    Average node length: 4.86, total dup: 579335, max dup: 9285 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90685, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 338 
        60 - 79% = 82 
        80 - 99% = 120 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar 12 10:10:27 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7659683 69342 1 0.0000 0.0000
DOC_LIST 2191780 34895 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1538 4 300.0000 0.0000
INVNT_TURNOVER_LOG 130687 124899 1 0.0000 0.0000
MONEY_SALDO 49 49 1 100.0000 0.0000
MONEY_TURNOVER_LOG 2309 1549 1 0.0000 0.0000
PDISTR 824461 15391 2 0.0000 0.0000
PERF_SPLIT_0 165271 417 1 0.0000 0.0000
PERF_SPLIT_1 157244 1574 1 0.0000 0.0000
PERF_SPLIT_2 171163 1445 1 0.0000 0.0000
PERF_SPLIT_3 187100 18948 1 0.0000 0.0000
PERF_SPLIT_4 154866 811 1 0.0000 0.0000
PERF_SPLIT_5 144850 1589 1 0.0000 0.0000
PERF_SPLIT_6 182009 2891 1 0.0000 0.0000
PERF_SPLIT_7 158104 8611 1 0.0000 0.0000
PERF_SPLIT_8 140982 1749 1 0.0000 0.0000
PERF_SPLIT_9 155617 429 1 0.0000 0.0000
PSTORNED 2065683 33219 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 126512 39418 1 0.0000 0.0000
XQD_1000_3300 7210448 201187 1 0.0000 0.0000
XQD_1200_2000 12373510 137956 1 0.0000 0.0000
XQD_2000_3300 1237018 193086 1 0.0000 0.0000
XQD_2100_3300 836722 74422 1 0.0000 0.0000
XQD_3300_3400 8832157 387157 1 0.0000 0.0000
XQS_1000_1200 21142717 26413 1 0.0000 0.0000
XQS_1000_3300 9809325 914521 1 0.0000 0.0000
XQS_1200_2000 11172297 709678 1 0.0000 0.0000
XQS_2100_3300 9904648 896342 1 0.0000 0.0000
XQS_3300_3400 579435 13366 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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