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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-13 19:09:42
DTS_END                         2024-04-13 19:09:42.9940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51952
TRN_ID                          171320
ATT_ID                          528
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: 8971.76 26151 897176
customer order: creation 169.97 387 16997
customer order: refuse 14.55 397 1455
order to supplier: creation 44.54 1430 4454
order to supplier: removal 3.54 101084 354
invoice (draft): creation 44.17 3758 4417
invoice (draft): removal 47.98 917 4798
invoice accept: apply 41.49 21649 4149
invoice accept: cancel 43.55 880 4355
customer reserve: creation 3974.70 208 397470
customer reserve: removal 4308.55 64 430855
realization accept: apply 81.14 218 8114
realization accept: cancel 71.86 136 7186
payment from customer: creation 56.24 137 5624
payment from customer: removal 5.54 112 554
payment to supplier: creation 49.06 159 4906
payment to supplier: removal 3.17 72 317
service: total inventory turnovers 4.72 906 472
service: total monetary turnovers 6.19 30 619
service: aggregate perf. data 0.77 24427 77
service: refresh index statistics 0.03 366050 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 13-04-2024 19:11:24 to 13-04-2024 19:11:27.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8354
TEST_TIME 2 6198
TEST_TIME 3 5758
TEST_TIME 4 4811
TEST_TIME 5 5361
TEST_TIME 6 5665
TEST_TIME 7 5524
TEST_TIME 8 5302
TEST_TIME 9 5468
TEST_TIME 10 5381
TEST_TIME 11 5449
TEST_TIME 12 5578
TEST_TIME 13 5839
TEST_TIME 14 5834
TEST_TIME 15 6371
TEST_TIME 16 6602
TEST_TIME 17 6849
TEST_TIME 18 6864
TEST_TIME 19 7267
TEST_TIME 20 7238
TEST_TIME 21 7473
TEST_TIME 22 7488
TEST_TIME 23 7741
TEST_TIME 24 7910
TEST_TIME 25 8124
TEST_TIME 26 8431
TEST_TIME 27 8281
TEST_TIME 28 8303
TEST_TIME 29 8652
TEST_TIME 30 9088
TEST_TIME 31 9045
TEST_TIME 32 8915
TEST_TIME 33 8918
TEST_TIME 34 9080
TEST_TIME 35 9298
TEST_TIME 36 9218
TEST_TIME 37 9117
TEST_TIME 38 9104
TEST_TIME 39 9035
TEST_TIME 40 9030
TEST_TIME 41 8954
TEST_TIME 42 8840
TEST_TIME 43 8823
TEST_TIME 44 8771
TEST_TIME 45 8692
TEST_TIME 46 8651
TEST_TIME 47 8613
TEST_TIME 48 8730
TEST_TIME 49 8778
TEST_TIME 50 8724
TEST_TIME 51 8599
TEST_TIME 52 8515
TEST_TIME 53 8565
TEST_TIME 54 8520
TEST_TIME 55 8575
TEST_TIME 56 8550
TEST_TIME 57 8581
TEST_TIME 58 8681
TEST_TIME 59 8677
TEST_TIME 60 8739
TEST_TIME 61 8742
TEST_TIME 62 8838
TEST_TIME 63 8810
TEST_TIME 64 8867
TEST_TIME 65 8801
TEST_TIME 66 8922
TEST_TIME 67 9092
TEST_TIME 68 9049
TEST_TIME 69 8952
TEST_TIME 70 8929
TEST_TIME 71 8924
TEST_TIME 72 8947
TEST_TIME 73 8950
TEST_TIME 74 8866
TEST_TIME 75 8881
TEST_TIME 76 8925
TEST_TIME 77 8980
TEST_TIME 78 8947
TEST_TIME 79 8991
TEST_TIME 80 9030
TEST_TIME 81 9050
TEST_TIME 82 9037
TEST_TIME 83 9069
TEST_TIME 84 9075
TEST_TIME 85 9111
TEST_TIME 86 9163
TEST_TIME 87 9214
TEST_TIME 88 9213
TEST_TIME 89 9270
TEST_TIME 90 9267
TEST_TIME 91 9189
TEST_TIME 92 9161
TEST_TIME 93 9155
TEST_TIME 94 9139
TEST_TIME 95 9108
TEST_TIME 96 9088
TEST_TIME 97 9051
TEST_TIME 98 9031
TEST_TIME 99 9036
TEST_TIME 100 8975

Performance per minute, chart


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

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 1260446 1260446 0 0.00 0 16157 8 0 0
doc_list_biud 1260445 1260445 0 0.00 0 105767 28 0 0
sp_add_invoice_to_stock 4317 4149 168 3.89 43 203622 21650 0 168
sp_cancel_adding_invoice 4355 4355 0 0.00 4 62867 881 0 0
sp_cancel_client_order 1455 1455 0 0.00 4 18691 398 0 0
sp_cancel_customer_reserve 430855 430855 0 0.00 0 59288 65 0 0
sp_cancel_pay_from_customer 554 554 0 0.00 3 12223 112 0 0
sp_cancel_pay_to_supplier 317 317 0 0.00 3 1588 72 0 0
sp_cancel_supplier_invoice 4804 4798 6 0.12 1 105825 918 0 6
sp_cancel_supplier_order 354 354 0 0.00 6 911355 101085 0 0
sp_cancel_write_off 7186 7186 0 0.00 1 22328 136 0 0
sp_client_order 16997 16997 0 0.00 3 33083 387 0 0
sp_customer_reserve 397470 397470 0 0.00 0 37404 209 0 0
sp_fill_shopping_cart 25861 25861 0 0.00 1 17659 37 0 0
sp_fill_shopping_cart_clo_res 397466 397466 0 0.00 0 17810 16 0 0
sp_get_clo_for_invoice 4143 4143 0 0.00 0 18255 326 0 0
sp_kill_cost_storno 12412 12412 0 0.00 0 10111 70 0 0
sp_kill_qstorno_ret_qs2qd 874048 874048 0 0.00 0 105765 35 0 0
sp_kill_qty_storno 461260 461260 0 0.00 0 105766 77 0 0
sp_lock_selected_doc 16925 16925 0 0.00 0 6196 4 0 0
sp_make_cost_storno 22787 22787 0 0.00 0 14860 62 0 0
sp_multiply_rows_for_pdistr 22787 22787 0 0.00 0 12066 32 0 0
sp_multiply_rows_for_qdistr 16997 16997 0 0.00 0 33074 177 0 0
sp_pay_from_customer 5624 5624 0 0.00 4 26217 138 0 0
sp_pay_to_supplier 4906 4906 0 0.00 4 26234 160 0 0
sp_payment_common 10529 10529 0 0.00 1 11235 28 0 0
sp_qd_handle_on_cancel_clo 1455 1455 0 0.00 0 18684 354 0 0
sp_qd_handle_on_invoice_upd_sts 8498 8498 0 0.00 0 30366 361 0 0
sp_qd_handle_on_reserve_upd_sts 8114 8114 0 0.00 0 14391 61 0 0
sp_reserve_write_off 8114 8114 0 0.00 6 20528 218 0 0
sp_supplier_invoice 4417 4417 0 0.00 7 105523 3759 0 0
sp_supplier_order 4454 4454 0 0.00 4 110954 1431 0 0
srv_aggregate_perf_data 77 77 0 0.00 1862 731136 24428 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1437 118236 36006 0 0
srv_find_qd_qs_mism 855157 855157 0 0.00 0 10419 7 0 0
srv_make_invnt_saldo 472 472 0 0.00 38 31462 906 0 0
srv_make_money_saldo 619 619 0 0.00 1 1181 30 0 0
srv_recalc_idx_stat 3 3 0 0.00 312992 460050 366050 0 0
t$perf-abend:sp_add_invoice_to_stock 168 168 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4149 4149 0 0.00 0 12611 196 0 0
t$perf-norm:sp_cancel_adding_invoice 313 313 0 0.00 0 3198 96 0 0
t$perf-norm:sp_cancel_client_order 1455 1455 0 0.00 0 5764 19 0 0
t$perf-norm:sp_cancel_customer_reserve 563 563 0 0.00 0 5784 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 554 554 0 0.00 0 878 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 317 317 0 0.00 0 1368 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 3148 22 0 0
t$perf-norm:sp_cancel_supplier_order 354 354 0 0.00 0 23924 1700 0 0
t$perf-norm:sp_cancel_write_off 782 782 0 0.00 0 1505 7 0 0
t$perf-norm:sp_client_order 16997 16997 0 0.00 0 11838 20 0 0
t$perf-norm:sp_customer_reserve 846 846 0 0.00 0 1872 6 0 0
t$perf-norm:sp_pay_from_customer 5624 5624 0 0.00 0 6513 13 0 0
t$perf-norm:sp_pay_to_supplier 4906 4906 0 0.00 0 10126 17 0 0
t$perf-norm:sp_reserve_write_off 8114 8114 0 0.00 0 6492 12 0 0
t$perf-norm:sp_supplier_invoice 4417 4417 0 0.00 0 5879 19 0 0
t$perf-norm:sp_supplier_order 4454 4454 0 0.00 0 4884 20 0 0
t$perf-norm:srv_aggregate_perf_data 77 77 0 0.00 0 201 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 79 3 0 0
t$perf-norm:srv_make_invnt_saldo 472 472 0 0.00 0 1851 28 0 0
t$perf-norm:srv_make_money_saldo 619 619 0 0.00 0 2194 18 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8618 8282 336 3.89 0 26425 37 0 336
v_all_customers 31124 31124 0 0.00 0 67 1 0 0
v_all_suppliers 25368 25368 0 0.00 0 36 1 0 0
v_all_wares 33994 33994 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 626 626 0 0.00 0 2094 11 0 0
v_cancel_client_order 2910 2910 0 0.00 0 14364 12 0 0
v_cancel_customer_prepayment 1108 1108 0 0.00 0 12197 26 0 0
v_cancel_customer_reserve 1126 1126 0 0.00 0 2980 9 0 0
v_cancel_payment_to_supplier 634 634 0 0.00 0 255 3 0 0
v_cancel_supplier_invoice 676 664 12 1.77 0 561 15 0 12
v_cancel_supplier_order 708 708 0 0.00 0 18341 41 0 0
v_cancel_write_off 1564 1564 0 0.00 0 22182 35 0 0
v_max_id_clo_ord 4452 4452 0 0.00 0 5212 3 0 0
v_max_id_clo_res 846 846 0 0.00 0 1590 7 0 0
v_max_id_ord_sup 4412 4412 0 0.00 0 2163 3 0 0
v_max_non_paid_invoice 1086 1086 0 0.00 0 247 2 0 0
v_max_non_paid_realizn 2871 2871 0 0.00 0 1074 4 0 0
v_min_id_clo_ord 4452 4452 0 0.00 0 10094 11 0 0
v_min_id_clo_res 846 846 0 0.00 0 3911 22 0 0
v_min_id_ord_sup 4412 4412 0 0.00 0 7198 8 0 0
v_min_non_paid_invoice 4906 4906 0 0.00 0 11228 27 0 0
v_min_non_paid_realizn 5623 5623 0 0.00 0 9926 19 0 0
v_our_firm 8374 8374 0 0.00 0 23 1 0 0
v_reserve_write_off 16226 16226 0 0.00 0 20330 17 0 0
x_lock_depdocs_on_canc_invoice 8821 8821 0 0.00 0 11207 141 0 0
x_lock_depdocs_on_canc_sup_ord 354 354 0 0.00 0 14229 379 0 0
x_make_qstorno_1000_1200 4454 4454 0 0.00 1 110949 1346 0 0
x_make_qstorno_1200_2000 4417 4417 0 0.00 3 105512 3625 0 0
x_make_qstorno_2100_3300 397470 397470 0 0.00 0 37398 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-04-2024 19:11:32 to 13-04-2024 19:11:36.

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
17:09:45 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:45 26419 8192000000 9908325824 10220552192 988583808 10.768 100 88 176 0 1017173328 5762496 22827024
17:12:18 14403 8192000000 9946555840 10268651520 1030571504 11.174 100 88 176 0 1060959616 7976256 22411856
17:13:47 17270 8192000000 9972889472 10303844352 1058129728 11.439 100 84 168 0 1088405408 9475872 20799808
17:15:12 12973 8192000000 10014411216 10364563456 1109216080 11.925 100 68 134 0 1135111024 10247792 15647152
17:16:31 6096 8192000000 10075301984 10434953216 1163565024 12.437 100 74 148 0 1191918096 10984128 17368944
17:17:40 2441 8192000000 10125238272 10493489152 1214295152 12.909 100 82 162 0 1245472512 13375984 17801376
17:18:44 2016 8192000000 10156363520 10531254272 1244512832 13.188 100 85 170 0 1275091968 12094016 18485120
17:19:48 2454 8192000000 10186239584 10570334208 1278223456 13.497 100 77 154 2 1309616928 14120384 17273088
17:20:53 1420 8192000000 10213660240 10602881024 1302346560 13.717 100 89 174 0 1334977632 12883952 19747120
17:21:55 40336 8192000000 10212303872 10614718464 1308629424 13.774 100 40 81 0 1323436624 4673040 10134160
17:23:37 2575 8192000000 10206256800 10622308352 1321465936 13.890 100 27 55 0 1333384400 5970496 5947968
17:24:42 6925 8192000000 10213342704 10629488640 1323994720 13.913 100 25 49 1 1335598384 6001056 5602608
17:25:52 6343 8192000000 10220880000 10642034688 1332957280 13.994 100 27 52 1 1345591648 7001808 5632560
17:26:58 46437 8192000000 10241711152 10654339072 1337494768 14.035 100 37 72 0 1354616976 8771440 8350768
17:28:47 8831 8192000000 10220536480 10644189184 1334005040 14.003 100 16 30 0 1342735952 5633520 3097392
17:29:56 6685 8192000000 10206653120 10614276096 1300385088 13.699 99 27 54 0 1313870688 7315552 6170048
17:31:13 7011 8192000000 10221733248 10622963712 1313907264 13.822 100 52 105 0 1335125984 9699280 11519440
17:32:48 13826 8192000000 10251094032 10660700160 1336776656 14.028 100 63 126 1 1366437488 15556432 14104400
17:34:18 8742 8192000000 10258151232 10664755200 1333203456 13.996 99 50 100 1 1359925856 15718480 11003920
17:35:28 12332 8192000000 10226765776 10622070784 1286159648 13.569 97 56 112 0 1316103488 17315584 12628256
17:37:37 14918 8192000000 10221920864 10623078400 1286696320 13.574 97 44 87 0 1316960496 20318544 9945632
17:39:09 14145 8192000000 10251281552 10649858048 1318845760 13.866 99 51 102 0 1350981536 20155488 11980288
17:40:37 22198 8192000000 10257157424 10668945408 1336996944 14.030 100 44 86 0 1375536464 27963296 10576224
17:42:08 7909 8192000000 10278951040 10687803392 1348489280 14.134 100 53 103 1 1392230880 30519344 13222256
17:43:20 6546 8192000000 10279031936 10679734272 1342564944 14.081 100 69 134 0 1390798288 32328048 15905296
17:44:52 1436 8192000000 10288126368 10682474496 1322910928 13.903 98 78 157 0 1373916656 32541616 18464112
17:45:59 6623 8192000000 10294551456 10699964416 1357964592 14.219 100 60 120 0 1402548864 29774896 14809376
17:47:30 6311 8192000000 10287515152 10698924032 1346018272 14.112 99 44 89 0 1384311104 26768512 11524320
17:48:39 19834 8192000000 10287301936 10704404480 1342015824 14.076 98 30 59 0 1379956016 30543824 7396368
17:50:13 8171 8192000000 10291981616 10717057024 1370795296 14.334 100 28 56 0 1406768192 28667536 7305360
17:51:26 2417 8192000000 10324299264 10729345024 1375421056 14.376 100 83 158 0 1429689696 34608368 19660272
17:52:35 15066 8192000000 10312418720 10740330496 1381567296 14.431 100 24 48 0 1421657968 33494896 6595776
17:53:58 8379 8192000000 10325273920 10742956032 1381912352 14.434 100 57 111 1 1432744896 36742768 14089776
17:55:10 26075 8192000000 10323940944 10760761344 1388536624 14.493 100 25 50 1 1433556752 38121040 6899088
17:56:52 25520 8192000000 10311433568 10748301312 1380900000 14.425 100 35 70 1 1421902192 32171568 8830624
17:58:20 14669 8192000000 10327052288 10757410816 1379110400 14.409 100 43 82 2 1431159600 41096752 10952448
17:59:39 11820 8192000000 10316610080 10754932736 1393028688 14.533 100 38 74 1 1431946848 29869456 9048704
18:00:57 82731 8192000000 10327750800 10771836928 1398422176 14.581 100 38 70 2 1433988544 26488224 9078144
18:03:54 46348 8192000000 10300576656 10771894272 1394397760 14.545 100 16 33 0 1421241552 22845808 3997984
18:05:55 36317 8192000000 10299162544 10745638912 1384354944 14.455 99 35 71 0 1402928720 10875248 7698528
18:07:34 46270 8192000000 10300524960 10747809792 1393637616 14.538 100 26 53 0 1411334560 11393392 6303552
18:09:29 58741 8192000000 10284437504 10740105216 1386127040 14.471 99 17 34 1 1398891168 9060864 3703264
18:11:37 79578 8192000000 10288637376 10747994112 1384155920 14.454 99 26 52 2 1398011008 7820608 6034480
18:13:59 63081 8192000000 10296998144 10746871808 1387782368 14.486 99 27 52 0 1402786688 8964224 6040096
18:16:29 24480 8192000000 10303865936 10748125184 1388932016 14.496 99 52 104 0 1413298768 12278288 12088464
18:18:22 24202 8192000000 10267348672 10728751104 1368198976 14.311 99 11 22 1 1378371952 7558816 2614160
18:19:47 51519 8192000000 10273418592 10730627072 1355220256 14.194 97 17 34 1 1368114448 8715024 4179168
18:21:49 48184 8192000000 10244045648 10709331968 1312744272 13.811 96 11 22 0 1326975056 12073376 2157408
18:23:39 44026 8192000000 10254382960 10696937472 1297058800 13.668 95 42 84 1 1315450544 8939152 9452592
18:25:26 14121 8192000000 10238788176 10675752960 1304545536 13.737 97 25 50 0 1321308400 11409536 5353328
18:26:42 13201 8192000000 10250783120 10681724928 1329816144 13.965 99 40 80 0 1348274608 9910432 8548032
18:27:57 58275 8192000000 10245893728 10682445824 1290806160 13.612 96 21 42 0 1308020208 13007088 4206960
18:30:02 59624 8192000000 10251625328 10682114048 1296397632 13.662 96 28 56 0 1321880016 18818000 6664384
18:32:03 22063 8192000000 10258468064 10694414336 1341184576 14.068 99 38 74 0 1357499424 8510000 7804848
18:33:30 43831 8192000000 10281852880 10716241920 1328475376 13.953 97 30 59 0 1350298256 15407328 6415552
18:35:16 74896 8192000000 10263663088 10725019648 1300381552 13.699 95 12 24 0 1331009120 27361728 3265840
18:37:43 103639 8192000000 10250779968 10682208256 1292174912 13.624 95 20 41 0 1306172288 9901616 4095760
18:40:41 37472 8192000000 10272625296 10707288064 1351489168 14.161 99 31 57 0 1375431664 17576128 6366368
18:42:33 70424 8192000000 10281619680 10738937856 1373806544 14.361 100 5 10 0 1387193936 12449536 937856
18:44:44 82059 8192000000 10281593168 10737270784 1369206688 14.320 99 17 33 0 1386522096 13380688 3934720
18:47:07 33197 8192000000 10289013008 10730565632 1373308832 14.357 99 28 56 1 1390231424 10537136 6385456
18:48:51 34786 8192000000 10296636992 10740191232 1374317776 14.366 99 19 38 0 1391493008 12165728 5009504
18:50:32 44985 8192000000 10294925088 10739326976 1380528368 14.421 99 22 44 0 1394314352 8696320 5089664
18:52:21 30714 8192000000 10306763296 10754535424 1397499120 14.573 100 22 44 0 1419518672 17478544 4541008
18:53:53 14178 8192000000 10322034688 10759331840 1403531728 14.626 100 48 92 0 1422729840 8674048 10524064
18:56:01 41215 8192000000 10323263952 10776526848 1387853616 14.487 99 16 32 0 1412695984 21218240 3624128
18:57:46 118236 8192000000 10312431856 10776461312 1376005248 14.381 98 7 14 0 1391758144 13574880 2178016
19:00:44 87798 8192000000 10285139536 10739605504 1333937104 14.003 95 17 34 1 1347028352 9216864 3874384
19:03:19 37295 8192000000 10264301312 10724360192 1368899424 14.317 99 16 30 1 1383556464 11856928 2800112
19:04:58 37582 8192000000 10265824096 10718064640 1338037248 14.040 97 14 28 0 1355322176 14800400 2484528
19:06:37 76367 8192000000 10275012336 10732396544 1373632400 14.360 99 15 31 0 1386580512 9420912 3527200
19:08:55 50162 8192000000 9963257584 10367590400 1060153168 11.458 76 11 22 1 1071697152 9366944 2177040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 13-04-2024 19:11:38 to 13-04-2024 19:11:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 168 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-04-2024 19:11:53 to 13-04-2024 19:11:55.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sat Apr 13 19:11:56 2024 
 
Database header page information: 
    Flags            0 
    Generation        89628 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    170375 
    Oldest active        171499 
    Oldest snapshot        171499 
    Next transaction    171500 
    Sequence number        0 
    Next attachment ID    702 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.61, total records: 7710887 
    Average version length: 48.16, total versions: 45280, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 86528 
    Data pages: 86528, average fill: 71% 
    Primary pages: 86528, secondary pages: 0, swept pages: 30776 
    Empty pages: 7, full pages: 55017 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 57 
    40 - 59% = 1336 
    60 - 79% = 85108 
    80 - 99% = 15 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23124, nodes: 7710887 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1704359, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 286 
        20 - 39% = 1829 
        40 - 59% = 4110 
        60 - 79% = 2392 
        80 - 99% = 14507 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13437, nodes: 7710887 
    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: 1527253, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1567 
        40 - 59% = 1988 
        60 - 79% = 1138 
        80 - 99% = 8744 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8323, nodes: 7710887 
    Average node length: 6.61, total dup: 5776951, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1520140, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 970 
        40 - 59% = 1376 
        60 - 79% = 931 
        80 - 99% = 4901 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.84, total records: 2224229 
    Average version length: 34.63, total versions: 46189, max versions: 3 
    Average fragment length: 8.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28320 
    Data pages: 28320, average fill: 72% 
    Primary pages: 28316, secondary pages: 4, swept pages: 12660 
    Empty pages: 1, full pages: 17896 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 79 
    40 - 59% = 1596 
    60 - 79% = 26364 
    80 - 99% = 274 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4534, nodes: 2224229 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 679769, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 939 
        40 - 59% = 818 
        60 - 79% = 736 
        80 - 99% = 2041 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2479, nodes: 2225837 
    Average node length: 4.97, total dup: 2224938, max dup: 20121 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1242969, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 249 
        40 - 59% = 1511 
        60 - 79% = 524 
        80 - 99% = 195 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2039, nodes: 2224229 
    Average node length: 4.97, total dup: 2224179, max dup: 130114 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1053488, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 185 
        40 - 59% = 985 
        60 - 79% = 46 
        80 - 99% = 821 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4349, nodes: 2224229 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 679769, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 627 
        40 - 59% = 624 
        60 - 79% = 816 
        80 - 99% = 2174 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.28, total records: 400 
    Average version length: 22.98, total versions: 233750, max versions: 611 
    Average fragment length: 2.04, total fragments: 56, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1296 
    Data pages: 1296, average fill: 90% 
    Primary pages: 10, secondary pages: 1286, swept pages: 0 
    Empty pages: 3, full pages: 1292 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1292 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 10.27, total records: 86765 
    Average version length: 68.28, total versions: 73712, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.57 
    Pointer pages: 7, data page slots: 1752 
    Data pages: 1320, average fill: 81% 
    Primary pages: 1319, secondary pages: 1, swept pages: 0 
    Empty pages: 32, full pages: 1115 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 47 
    40 - 59% = 38 
    60 - 79% = 201 
    80 - 99% = 967 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1709573, depth: 3, leaf buckets: 292, nodes: 86765 
    Average node length: 13.15, total dup: 4771, max dup: 1 
    Average key length: 10.71, compression ratio: 2.52 
    Average prefix length: 19.23, average data length: 7.77 
    Clustering factor: 62425, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 115 
        40 - 59% = 96 
        60 - 79% = 74 
        80 - 99% = 6 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 16907, max versions: 936 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 85% 
    Primary pages: 3, secondary pages: 61, swept pages: 0 
    Empty pages: 2, full pages: 61 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 8 
    80 - 99% = 53 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.83, total records: 1371 
    Average version length: 43.22, total versions: 1253, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 15.15 
    Pointer pages: 1, data page slots: 24 
    Data pages: 23, average fill: 57% 
    Primary pages: 23, secondary pages: 0, swept pages: 2 
    Empty pages: 3, full pages: 12 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90902, depth: 2, leaf buckets: 2, nodes: 1371 
    Average node length: 4.34, total dup: 1273, max dup: 160 
    Average key length: 2.76, compression ratio: 6.89 
    Average prefix length: 18.31, average data length: 0.69 
    Clustering factor: 736, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.10, total records: 73 
    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: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.66, total records: 788188 
    Average version length: 25.75, total versions: 44513, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8040, average fill: 68% 
    Primary pages: 8018, secondary pages: 22, swept pages: 2641 
    Empty pages: 71, full pages: 5622 
    Fill distribution: 
     0 - 19% = 128 
    20 - 39% = 129 
    40 - 59% = 466 
    60 - 79% = 7185 
    80 - 99% = 132 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 867, nodes: 788188 
    Average node length: 4.87, total dup: 788139, max dup: 148801 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87016, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 135 
        40 - 59% = 484 
        60 - 79% = 182 
        80 - 99% = 65 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 905, nodes: 788188 
    Average node length: 5.88, total dup: 701663, max dup: 45 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156481, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 98 
        40 - 59% = 368 
        60 - 79% = 124 
        80 - 99% = 315 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 935, nodes: 788188 
    Average node length: 5.88, total dup: 701663, max dup: 45 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158447, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 196 
        40 - 59% = 303 
        60 - 79% = 119 
        80 - 99% = 317 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1144, nodes: 788188 
    Average node length: 5.96, total dup: 701663, max dup: 45 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151356, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 267 
        40 - 59% = 619 
        60 - 79% = 188 
        80 - 99% = 69 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5437 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.82, total fragments: 57, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 79, secondary pages: 17, swept pages: 59 
    Empty pages: 15, full pages: 66 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5437 
    Average node length: 5.46, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.40, average data length: 1.54 
    Clustering factor: 5136, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5437 
    Average node length: 11.10, 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: 153, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.08, total records: 78009 
    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: 752 
    Data pages: 752, average fill: 71% 
    Primary pages: 752, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 751 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 751 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 31631, depth: 2, leaf buckets: 99, nodes: 78009 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3215, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.69, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.28 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 139.69, total records: 196332 
    Average version length: 154.92, total versions: 15075, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.14 
    Pointer pages: 7, data page slots: 5256 
    Data pages: 4744, average fill: 86% 
    Primary pages: 4744, secondary pages: 0, swept pages: 1 
    Empty pages: 51, full pages: 4643 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 4 
    40 - 59% = 38 
    60 - 79% = 2 
    80 - 99% = 4644 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 147.39, total records: 164294 
    Average version length: 153.63, total versions: 3762, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 5120 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3920, secondary pages: 0, swept pages: 1 
    Empty pages: 29, full pages: 3886 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3887 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 150.64, total records: 157690 
    Average version length: 149.48, total versions: 233, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 6, data page slots: 4200 
    Data pages: 3776, average fill: 86% 
    Primary pages: 3776, secondary pages: 0, swept pages: 4 
    Empty pages: 37, full pages: 3728 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 3728 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 149.90, total records: 171981 
    Average version length: 152.36, total versions: 1315, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 6, data page slots: 4432 
    Data pages: 4128, average fill: 86% 
    Primary pages: 4128, secondary pages: 0, swept pages: 5 
    Empty pages: 44, full pages: 4069 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4068 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.77, total records: 149984 
    Average version length: 153.06, total versions: 2116, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 4384 
    Data pages: 3600, average fill: 86% 
    Primary pages: 3600, secondary pages: 0, swept pages: 1 
    Empty pages: 38, full pages: 3546 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3546 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 149.12, total records: 153911 
    Average version length: 152.62, total versions: 1560, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 6, data page slots: 4320 
    Data pages: 3664, average fill: 86% 
    Primary pages: 3663, secondary pages: 1, swept pages: 2 
    Empty pages: 17, full pages: 3637 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 3637 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.09, total records: 148058 
    Average version length: 154.97, total versions: 3415, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 3896 
    Data pages: 3544, average fill: 86% 
    Primary pages: 3544, secondary pages: 0, swept pages: 1 
    Empty pages: 35, full pages: 3499 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 3499 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 151.17, total records: 168991 
    Average version length: 133.88, total versions: 75, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.22 
    Pointer pages: 8, data page slots: 5216 
    Data pages: 4040, average fill: 86% 
    Primary pages: 4040, secondary pages: 0, swept pages: 4 
    Empty pages: 22, full pages: 4005 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 4005 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.79, total records: 166598 
    Average version length: 153.23, total versions: 2465, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 4280 
    Data pages: 3992, average fill: 86% 
    Primary pages: 3992, secondary pages: 0, swept pages: 2 
    Empty pages: 37, full pages: 3944 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3944 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 150.86, total records: 167337 
    Average version length: 135.44, total versions: 71, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 6, data page slots: 4144 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4008, secondary pages: 0, swept pages: 1 
    Empty pages: 39, full pages: 3960 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 3960 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 52.17, total records: 2090613 
    Average version length: 52.97, total versions: 22917, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25520 
    Data pages: 25520, average fill: 70% 
    Primary pages: 25520, secondary pages: 0, swept pages: 12299 
    Empty pages: 307, full pages: 20073 
    Fill distribution: 
     0 - 19% = 608 
    20 - 39% = 476 
    40 - 59% = 1159 
    60 - 79% = 23094 
    80 - 99% = 183 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2597, nodes: 2090613 
    Average node length: 5.44, total dup: 1950201, max dup: 1186 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181137, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 292 
        40 - 59% = 1730 
        60 - 79% = 300 
        80 - 99% = 270 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2754, nodes: 2090613 
    Average node length: 5.69, total dup: 1876008, max dup: 79 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 373656, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2429 
        60 - 79% = 297 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2141, nodes: 2090613 
    Average node length: 4.96, total dup: 2090513, max dup: 28320 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179057, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 211 
        40 - 59% = 1137 
        60 - 79% = 379 
        80 - 99% = 412 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 46.37, total records: 123372 
    Average version length: 69.18, total versions: 40733, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.72 
    Pointer pages: 3, data page slots: 4264 
    Data pages: 3136, average fill: 45% 
    Primary pages: 3136, secondary pages: 0, swept pages: 701 
    Empty pages: 651, full pages: 1244 
    Fill distribution: 
     0 - 19% = 1010 
    20 - 39% = 453 
    40 - 59% = 309 
    60 - 79% = 531 
    80 - 99% = 833 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103817, depth: 3, leaf buckets: 208, nodes: 123372 
    Average node length: 6.35, total dup: 107203, max dup: 14 
    Average key length: 3.99, compression ratio: 10.52 
    Average prefix length: 40.14, average data length: 1.86 
    Clustering factor: 21489, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 78 
        40 - 59% = 88 
        60 - 79% = 35 
        80 - 99% = 7 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.21, total records: 6962998 
    Average version length: 68.79, total versions: 277808, 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: 64, data page slots: 103616 
    Data pages: 103616, average fill: 72% 
    Primary pages: 103616, secondary pages: 0, swept pages: 42343 
    Empty pages: 10, full pages: 63150 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 955 
    40 - 59% = 10200 
    60 - 79% = 89568 
    80 - 99% = 2829 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10742, nodes: 6962998 
    Average node length: 6.51, total dup: 6022049, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1536141, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1901 
        40 - 59% = 5907 
        60 - 79% = 2505 
        80 - 99% = 424 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8496, nodes: 6962998 
    Average node length: 5.40, total dup: 6684101, max dup: 141 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1346059, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1315 
        40 - 59% = 4677 
        60 - 79% = 1519 
        80 - 99% = 971 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8553, nodes: 6962998 
    Average node length: 5.40, total dup: 6684101, max dup: 141 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1348567, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1386 
        40 - 59% = 4648 
        60 - 79% = 1555 
        80 - 99% = 957 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.88, total records: 11975366 
    Average version length: 68.74, total versions: 185709, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 104, data page slots: 169008 
    Data pages: 169008, average fill: 75% 
    Primary pages: 169008, secondary pages: 0, swept pages: 99959 
    Empty pages: 12, full pages: 142638 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 596 
    40 - 59% = 5900 
    60 - 79% = 159850 
    80 - 99% = 2602 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18382, nodes: 11975366 
    Average node length: 6.58, total dup: 10442038, max dup: 63 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2346809, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 2401 
        40 - 59% = 10888 
        60 - 79% = 4342 
        80 - 99% = 722 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 50.21, total records: 1309574 
    Average version length: 69.07, total versions: 358225, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.51 
    Pointer pages: 25, data page slots: 39800 
    Data pages: 29222, average fill: 51% 
    Primary pages: 29221, secondary pages: 1, swept pages: 13906 
    Empty pages: 5045, full pages: 13438 
    Fill distribution: 
     0 - 19% = 8202 
    20 - 39% = 3130 
    40 - 59% = 2640 
    60 - 79% = 10200 
    80 - 99% = 5050 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2133, nodes: 1309574 
    Average node length: 5.53, total dup: 1255988, max dup: 97 
    Average key length: 2.58, compression ratio: 16.29 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 90198, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1078 
        40 - 59% = 840 
        60 - 79% = 182 
        80 - 99% = 26 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 45.19, total records: 936240 
    Average version length: 69.13, total versions: 323072, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.79 
    Pointer pages: 22, data page slots: 35152 
    Data pages: 27208, average fill: 40% 
    Primary pages: 27208, secondary pages: 0, swept pages: 8185 
    Empty pages: 5879, full pages: 6903 
    Fill distribution: 
     0 - 19% = 9771 
    20 - 39% = 4304 
    40 - 59% = 3952 
    60 - 79% = 4594 
    80 - 99% = 4587 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1548, nodes: 936240 
    Average node length: 5.81, total dup: 873118, max dup: 99 
    Average key length: 2.89, compression ratio: 14.55 
    Average prefix length: 41.18, average data length: 0.82 
    Clustering factor: 122511, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 679 
        40 - 59% = 686 
        60 - 79% = 169 
        80 - 99% = 14 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.01, total records: 9015518 
    Average version length: 69.00, total versions: 246880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 88, data page slots: 142008 
    Data pages: 141992, average fill: 68% 
    Primary pages: 141992, secondary pages: 0, swept pages: 77175 
    Empty pages: 281, full pages: 69571 
    Fill distribution: 
     0 - 19% = 1141 
    20 - 39% = 6105 
    40 - 59% = 23543 
    60 - 79% = 108530 
    80 - 99% = 2673 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13469, nodes: 9015518 
    Average node length: 6.68, total dup: 7476750, max dup: 19 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1946657, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1432 
        40 - 59% = 7159 
        60 - 79% = 4350 
        80 - 99% = 526 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21127264 
    Average version length: 82.93, total versions: 5745, 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: 318552 
    Data pages: 318552, average fill: 81% 
    Primary pages: 318552, secondary pages: 0, swept pages: 13371 
    Empty pages: 52, full pages: 317406 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 65 
    40 - 59% = 171 
    60 - 79% = 27877 
    80 - 99% = 290359 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19316, nodes: 21127264 
    Average node length: 5.72, total dup: 20646752, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279430, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1 
        40 - 59% = 8014 
        60 - 79% = 579 
        80 - 99% = 10713 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17145, nodes: 21127264 
    Average node length: 6.31, total dup: 18567161, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914773, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 5 
        40 - 59% = 764 
        60 - 79% = 261 
        80 - 99% = 16110 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21050, nodes: 21127264 
    Average node length: 6.35, total dup: 18485517, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3572665, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8223 
        60 - 79% = 588 
        80 - 99% = 12235 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16069, nodes: 21127264 
    Average node length: 5.56, total dup: 21127164, max dup: 230150 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943363, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 10 
        40 - 59% = 2834 
        60 - 79% = 394 
        80 - 99% = 12829 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 80.61, total records: 9433431 
    Average version length: 82.58, total versions: 206848, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 103, data page slots: 166680 
    Data pages: 166640, average fill: 70% 
    Primary pages: 166640, secondary pages: 0, swept pages: 98706 
    Empty pages: 459, full pages: 91005 
    Fill distribution: 
     0 - 19% = 1487 
    20 - 39% = 6667 
    40 - 59% = 26332 
    60 - 79% = 81763 
    80 - 99% = 50391 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11369, nodes: 9433431 
    Average node length: 5.35, total dup: 9126681, max dup: 168 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2076979, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 81 
        40 - 59% = 9027 
        60 - 79% = 2209 
        80 - 99% = 47 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13232, nodes: 9433431 
    Average node length: 6.22, total dup: 7817790, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1435726, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 3880 
        40 - 59% = 4305 
        60 - 79% = 2601 
        80 - 99% = 2323 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12693, nodes: 9433431 
    Average node length: 5.97, total dup: 8176830, max dup: 32 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2263948, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 112 
        40 - 59% = 10000 
        60 - 79% = 2509 
        80 - 99% = 71 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9910, nodes: 9433431 
    Average node length: 5.12, total dup: 9433331, max dup: 161303 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1470986, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 55 
        20 - 39% = 1306 
        40 - 59% = 4813 
        60 - 79% = 1700 
        80 - 99% = 2036 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 81.05, total records: 11073417 
    Average version length: 82.52, total versions: 167011, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 118, data page slots: 191120 
    Data pages: 189640, average fill: 72% 
    Primary pages: 189640, secondary pages: 0, swept pages: 83944 
    Empty pages: 3436, full pages: 134037 
    Fill distribution: 
     0 - 19% = 5852 
    20 - 39% = 8226 
    40 - 59% = 19942 
    60 - 79% = 48794 
    80 - 99% = 106826 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13131, nodes: 11073417 
    Average node length: 5.30, total dup: 10964130, max dup: 639 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2318808, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 183 
        40 - 59% = 9746 
        60 - 79% = 3096 
        80 - 99% = 103 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10247, nodes: 11073417 
    Average node length: 5.49, total dup: 10588812, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 714019, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 158 
        20 - 39% = 841 
        40 - 59% = 2486 
        60 - 79% = 1826 
        80 - 99% = 4936 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15012, nodes: 11073417 
    Average node length: 6.02, total dup: 9655841, max dup: 62 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2335056, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 226 
        40 - 59% = 11279 
        60 - 79% = 3369 
        80 - 99% = 136 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10557, nodes: 11073417 
    Average node length: 5.22, total dup: 11073317, max dup: 197229 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 703008, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 868 
        40 - 59% = 4629 
        60 - 79% = 1471 
        80 - 99% = 3489 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 81.27, total records: 9510257 
    Average version length: 82.92, total versions: 168368, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 104, data page slots: 169720 
    Data pages: 169688, average fill: 69% 
    Primary pages: 169688, secondary pages: 0, swept pages: 107077 
    Empty pages: 433, full pages: 88509 
    Fill distribution: 
     0 - 19% = 1592 
    20 - 39% = 7447 
    40 - 59% = 27697 
    60 - 79% = 84936 
    80 - 99% = 48016 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11631, nodes: 9510257 
    Average node length: 5.16, total dup: 9481299, max dup: 1780 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1882870, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1642 
        40 - 59% = 7698 
        60 - 79% = 1727 
        80 - 99% = 532 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13341, nodes: 9510257 
    Average node length: 6.23, total dup: 7881647, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1398327, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 182 
        20 - 39% = 3923 
        40 - 59% = 4177 
        60 - 79% = 2632 
        80 - 99% = 2427 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12226, nodes: 9510257 
    Average node length: 5.42, total dup: 9079906, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 2011661, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1524 
        40 - 59% = 8589 
        60 - 79% = 1562 
        80 - 99% = 531 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10016, nodes: 9510257 
    Average node length: 5.13, total dup: 9510157, max dup: 163038 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1485344, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1297 
        40 - 59% = 4976 
        60 - 79% = 1661 
        80 - 99% = 2036 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.89, total records: 575660 
    Average version length: 68.80, total versions: 2409, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 7984 
    Data pages: 7984, average fill: 75% 
    Primary pages: 7984, secondary pages: 0, swept pages: 4494 
    Empty pages: 3, full pages: 6599 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 7 
    40 - 59% = 158 
    60 - 79% = 7771 
    80 - 99% = 45 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 32951, depth: 3, leaf buckets: 737, nodes: 575660 
    Average node length: 5.95, total dup: 490035, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100135, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 524 
        60 - 79% = 92 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 25121, depth: 3, leaf buckets: 759, nodes: 575660 
    Average node length: 6.15, total dup: 472139, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100179, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 28 
        40 - 59% = 534 
        60 - 79% = 96 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 561, nodes: 575660 
    Average node length: 4.86, total dup: 575560, max dup: 9160 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88949, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 319 
        60 - 79% = 92 
        80 - 99% = 122 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Apr 13 19:12:19 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7710887 45280 1 0.0000 0.0000
DOC_LIST 2224229 46189 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 233750 611 58400.0000 0.0000
INVNT_TURNOVER_LOG 86765 73712 1 0.0000 0.0000
MONEY_SALDO 49 16907 936 34500.0000 0.0000
MONEY_TURNOVER_LOG 1371 1253 1 0.0000 0.0000
PDISTR 788188 44513 4 0.0000 0.0000
PERF_SPLIT_0 196332 15075 1 0.0000 0.0000
PERF_SPLIT_1 164294 3762 1 0.0000 0.0000
PERF_SPLIT_2 157690 233 1 0.0000 0.0000
PERF_SPLIT_3 171981 1315 1 0.0000 0.0000
PERF_SPLIT_4 149984 2116 1 0.0000 0.0000
PERF_SPLIT_5 153911 1560 1 0.0000 0.0000
PERF_SPLIT_6 148058 3415 1 0.0000 0.0000
PERF_SPLIT_7 168991 75 1 0.0000 0.0000
PERF_SPLIT_8 166598 2465 1 0.0000 0.0000
PERF_SPLIT_9 167337 71 1 0.0000 0.0000
PSTORNED 2090613 22917 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 123372 40733 1 0.0000 0.0000
XQD_1000_3300 6962998 277808 1 0.0000 0.0000
XQD_1200_2000 11975366 185709 1 0.0000 0.0000
XQD_2000_3300 1309574 358225 1 0.0000 0.0000
XQD_2100_3300 936240 323072 1 0.0000 0.0000
XQD_3300_3400 9015518 246880 1 0.0000 0.0000
XQS_1000_1200 21127264 5745 1 0.0000 0.0000
XQS_1000_3300 9433431 206848 1 0.0000 0.0000
XQS_1200_2000 11073417 167011 1 0.0000 0.0000
XQS_2100_3300 9510257 168368 1 0.0000 0.0000
XQS_3300_3400 575660 2409 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 ---
:1143: 
:1144: mscs-test-161.budzdorov.ru    Sat Apr 13 19:09:52 2024
:1145:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1146: 
:1147: 
:1148: mscs-test-161.budzdorov.ru    Sat Apr 13 19:09:53 2024
:1149:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1150: 
:1151: 
:1152: mscs-test-161.budzdorov.ru    Sat Apr 13 19:09:55 2024
:1153:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1154: 
:1155: 
:1156: mscs-test-161.budzdorov.ru    Sat Apr 13 19:09:56 2024
:1157:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1158: 
--- end of diff output ---

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

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