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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-18 07:07:49
DTS_END                         2024-03-18 07:07:49.2140
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/37958
TRN_ID                          168225
ATT_ID                          499
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: 8985.53 17760 898553
customer order: creation 176.37 433 17637
customer order: refuse 14.74 344 1474
order to supplier: creation 46.91 1237 4691
order to supplier: removal 3.55 91905 355
invoice (draft): creation 46.91 3023 4691
invoice (draft): removal 49.63 650 4963
invoice accept: apply 41.45 19496 4145
invoice accept: cancel 44.90 848 4490
customer reserve: creation 3905.57 191 390557
customer reserve: removal 4356.82 60 435682
realization accept: apply 83.61 191 8361
realization accept: cancel 82.59 131 8259
payment from customer: creation 61.08 159 6108
payment from customer: removal 5.89 82 589
payment to supplier: creation 50.37 165 5037
payment to supplier: removal 3.48 95 348
service: total inventory turnovers 3.94 3552 394
service: total monetary turnovers 6.76 512 676
service: aggregate perf. data 0.93 14960 93
service: refresh index statistics 0.03 217156 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 18-03-2024 07:09:05 to 18-03-2024 07:09:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2549
TEST_TIME 2 2001
TEST_TIME 3 3306
TEST_TIME 4 3618
TEST_TIME 5 3817
TEST_TIME 6 4823
TEST_TIME 7 5866
TEST_TIME 8 6048
TEST_TIME 9 6200
TEST_TIME 10 6376
TEST_TIME 11 6605
TEST_TIME 12 6807
TEST_TIME 13 6648
TEST_TIME 14 6412
TEST_TIME 15 6410
TEST_TIME 16 6495
TEST_TIME 17 6412
TEST_TIME 18 6509
TEST_TIME 19 6531
TEST_TIME 20 6826
TEST_TIME 21 6881
TEST_TIME 22 7000
TEST_TIME 23 7379
TEST_TIME 24 7841
TEST_TIME 25 8207
TEST_TIME 26 8549
TEST_TIME 27 9147
TEST_TIME 28 9265
TEST_TIME 29 9429
TEST_TIME 30 9220
TEST_TIME 31 9114
TEST_TIME 32 9275
TEST_TIME 33 9008
TEST_TIME 34 8752
TEST_TIME 35 8996
TEST_TIME 36 8916
TEST_TIME 37 9157
TEST_TIME 38 9056
TEST_TIME 39 9022
TEST_TIME 40 9005
TEST_TIME 41 8874
TEST_TIME 42 8823
TEST_TIME 43 8688
TEST_TIME 44 8838
TEST_TIME 45 8772
TEST_TIME 46 8863
TEST_TIME 47 8951
TEST_TIME 48 8968
TEST_TIME 49 8986
TEST_TIME 50 8983
TEST_TIME 51 8973
TEST_TIME 52 9110
TEST_TIME 53 9257
TEST_TIME 54 9192
TEST_TIME 55 9247
TEST_TIME 56 9324
TEST_TIME 57 9210
TEST_TIME 58 9149
TEST_TIME 59 9076
TEST_TIME 60 9035
TEST_TIME 61 9046
TEST_TIME 62 8980
TEST_TIME 63 8912
TEST_TIME 64 8859
TEST_TIME 65 8894
TEST_TIME 66 9038
TEST_TIME 67 9047
TEST_TIME 68 9076
TEST_TIME 69 9068
TEST_TIME 70 9112
TEST_TIME 71 9128
TEST_TIME 72 9145
TEST_TIME 73 9243
TEST_TIME 74 9214
TEST_TIME 75 9202
TEST_TIME 76 9134
TEST_TIME 77 9116
TEST_TIME 78 9069
TEST_TIME 79 9054
TEST_TIME 80 8994
TEST_TIME 81 8962
TEST_TIME 82 9066
TEST_TIME 83 9058
TEST_TIME 84 9043
TEST_TIME 85 9033
TEST_TIME 86 9081
TEST_TIME 87 9193
TEST_TIME 88 9210
TEST_TIME 89 9232
TEST_TIME 90 9231
TEST_TIME 91 9288
TEST_TIME 92 9228
TEST_TIME 93 9191
TEST_TIME 94 9150
TEST_TIME 95 9106
TEST_TIME 96 9075
TEST_TIME 97 9063
TEST_TIME 98 9082
TEST_TIME 99 9052
TEST_TIME 100 8998

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-03-2024 07:09:09 to 18-03-2024 07:09:12.

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 1257397 1257397 0 0.00 0 43111 7 0 0
doc_list_biud 1257388 1257388 0 0.00 0 43524 26 0 0
sp_add_invoice_to_stock 4245 4145 100 2.35 21 194518 19497 0 100
sp_cancel_adding_invoice 4490 4490 0 0.00 4 66122 849 0 0
sp_cancel_client_order 1474 1474 0 0.00 5 9757 345 0 0
sp_cancel_customer_reserve 435682 435682 0 0.00 0 32445 61 0 0
sp_cancel_pay_from_customer 589 589 0 0.00 3 9564 83 0 0
sp_cancel_pay_to_supplier 348 348 0 0.00 2 5123 95 0 0
sp_cancel_supplier_invoice 4972 4963 9 0.18 1 28663 651 0 9
sp_cancel_supplier_order 355 355 0 0.00 6 867450 91905 0 0
sp_cancel_write_off 8259 8259 0 0.00 1 43113 131 0 0
sp_client_order 17637 17637 0 0.00 3 16170 433 0 0
sp_customer_reserve 390557 390557 0 0.00 0 47264 192 0 0
sp_fill_shopping_cart 27019 27019 0 0.00 1 15285 37 0 0
sp_fill_shopping_cart_clo_res 390545 390545 0 0.00 0 16925 16 0 0
sp_get_clo_for_invoice 4133 4133 0 0.00 0 20479 366 0 0
sp_kill_cost_storno 13686 13686 0 0.00 0 43111 73 0 0
sp_kill_qstorno_ret_qs2qd 884941 884941 0 0.00 0 32443 32 0 0
sp_kill_qty_storno 467712 467712 0 0.00 0 43523 69 0 0
sp_lock_selected_doc 17383 17383 0 0.00 0 10465 5 0 0
sp_make_cost_storno 23639 23639 0 0.00 0 34867 68 0 0
sp_multiply_rows_for_pdistr 23639 23639 0 0.00 0 33289 43 0 0
sp_multiply_rows_for_qdistr 17637 17637 0 0.00 0 14611 235 0 0
sp_pay_from_customer 6108 6108 0 0.00 4 35405 160 0 0
sp_pay_to_supplier 5037 5037 0 0.00 5 37135 165 0 0
sp_payment_common 11144 11144 0 0.00 1 27412 46 0 0
sp_qd_handle_on_cancel_clo 1474 1474 0 0.00 0 9752 327 0 0
sp_qd_handle_on_invoice_upd_sts 8620 8620 0 0.00 0 43522 293 0 0
sp_qd_handle_on_reserve_upd_sts 8359 8359 0 0.00 0 11968 44 0 0
sp_reserve_write_off 8361 8361 0 0.00 6 37145 192 0 0
sp_supplier_invoice 4691 4691 0 0.00 4 109623 3023 0 0
sp_supplier_order 4691 4691 0 0.00 4 37371 1238 0 0
srv_aggregate_perf_data 93 93 0 0.00 1421 199785 14960 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1546 122439 44202 0 0
srv_find_qd_qs_mism 856514 856514 0 0.00 0 18547 6 0 0
srv_make_invnt_saldo 394 394 0 0.00 41 104247 3553 0 0
srv_make_money_saldo 676 676 0 0.00 1 12606 512 0 0
srv_recalc_idx_stat 3 3 0 0.00 134124 266841 217156 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4145 4145 0 0.00 0 9871 155 0 0
t$perf-norm:sp_cancel_adding_invoice 369 369 0 0.00 0 5367 118 0 0
t$perf-norm:sp_cancel_client_order 1474 1474 0 0.00 0 7984 14 0 0
t$perf-norm:sp_cancel_customer_reserve 583 583 0 0.00 0 1060 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 589 589 0 0.00 0 2830 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 348 348 0 0.00 0 304 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 347 347 0 0.00 0 567 10 0 0
t$perf-norm:sp_cancel_supplier_order 355 355 0 0.00 0 15522 1436 0 0
t$perf-norm:sp_cancel_write_off 829 829 0 0.00 0 2982 6 0 0
t$perf-norm:sp_client_order 17637 17637 0 0.00 0 7238 15 0 0
t$perf-norm:sp_customer_reserve 887 887 0 0.00 0 791 5 0 0
t$perf-norm:sp_pay_from_customer 6108 6108 0 0.00 0 4270 9 0 0
t$perf-norm:sp_pay_to_supplier 5037 5037 0 0.00 0 4554 12 0 0
t$perf-norm:sp_reserve_write_off 8361 8361 0 0.00 0 5446 11 0 0
t$perf-norm:sp_supplier_invoice 4691 4691 0 0.00 0 9225 14 0 0
t$perf-norm:sp_supplier_order 4691 4691 0 0.00 0 5464 16 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 317 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 3364 64 0 0
t$perf-norm:srv_make_invnt_saldo 394 394 0 0.00 0 535 5 0 0
t$perf-norm:srv_make_money_saldo 676 676 0 0.00 0 1506 6 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 8460 8260 200 2.36 0 4677 15 0 200
v_all_customers 32898 32898 0 0.00 0 130 0 0 0
v_all_suppliers 26860 26860 0 0.00 0 19 1 0 0
v_all_wares 35274 35274 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 738 738 0 0.00 0 1295 8 0 0
v_cancel_client_order 2948 2948 0 0.00 0 847 3 0 0
v_cancel_customer_prepayment 1178 1178 0 0.00 0 2380 9 0 0
v_cancel_customer_reserve 1166 1166 0 0.00 0 417 4 0 0
v_cancel_payment_to_supplier 696 696 0 0.00 0 5062 19 0 0
v_cancel_supplier_invoice 712 694 18 2.52 0 1165 12 0 18
v_cancel_supplier_order 710 710 0 0.00 0 290 4 0 0
v_cancel_write_off 1658 1658 0 0.00 0 1181 11 0 0
v_max_id_clo_ord 4691 4691 0 0.00 0 1541 2 0 0
v_max_id_clo_res 887 887 0 0.00 0 6790 16 0 0
v_max_id_ord_sup 4691 4691 0 0.00 0 13918 8 0 0
v_max_non_paid_invoice 988 988 0 0.00 0 362 2 0 0
v_max_non_paid_realizn 2897 2897 0 0.00 0 1340 3 0 0
v_min_id_clo_ord 4691 4691 0 0.00 0 10209 15 0 0
v_min_id_clo_res 887 887 0 0.00 0 12134 27 0 0
v_min_id_ord_sup 4691 4691 0 0.00 0 6625 7 0 0
v_min_non_paid_invoice 5036 5036 0 0.00 0 21559 29 0 0
v_min_non_paid_realizn 6108 6108 0 0.00 0 26661 49 0 0
v_our_firm 8798 8798 0 0.00 0 74 1 0 0
v_reserve_write_off 16718 16718 0 0.00 0 5060 6 0 0
x_lock_depdocs_on_canc_invoice 9106 9106 0 0.00 0 18920 114 0 0
x_lock_depdocs_on_canc_sup_ord 355 355 0 0.00 0 2446 274 0 0
x_make_qstorno_1000_1200 4691 4691 0 0.00 1 37365 1155 0 0
x_make_qstorno_1200_2000 4691 4691 0 0.00 2 109615 2893 0 0
x_make_qstorno_2100_3300 390557 390557 0 0.00 0 47264 173 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 18-03-2024 07:09:13 to 18-03-2024 07:09:18.

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
05:07:53 958 8192000000 8935138352 8992669696 12145888 0.148 4 2 4 0 12524592 130608 248096
05:08:55 32364 8192000000 9696800032 9994575872 771423472 8.606 100 85 171 0 799996800 7137360 21435968
05:10:31 22545 8192000000 9752121776 10062495744 830073552 9.200 100 86 172 0 860995600 10295008 20627040
05:12:00 20495 8192000000 9796658832 10119348224 865600176 9.556 100 86 169 0 900516880 16009312 18907392
05:13:24 14005 8192000000 9856148112 10190077952 910304512 10.000 100 78 156 0 964353504 38194896 15854096
05:14:41 6476 8192000000 9904136416 10247684096 944636128 10.338 100 89 178 0 1017568432 55105360 17826944
05:15:55 3004 8192000000 9956152880 10308407296 977045536 10.655 100 90 178 0 1065939696 71235616 17658544
05:17:03 3045 8192000000 9974810976 10336239616 1003131904 10.909 100 77 150 0 1088252000 70591664 14528432
05:18:08 1806 8192000000 10001232096 10371231744 1025088016 11.121 100 84 168 1 1113403632 72490400 15825216
05:19:12 1471 8192000000 10013065264 10384625664 1041741056 11.281 100 86 169 0 1124714208 66735136 16238016
05:20:15 1233 8192000000 10031341456 10406473728 1052841952 11.388 100 91 181 2 1144533488 72886912 18804624
05:21:19 29344 8192000000 10011647376 10405650432 1061418032 11.470 100 63 124 0 1135286480 60367776 13500672
05:23:06 4657 8192000000 10005810992 10402402304 1067253376 11.526 100 41 82 0 1128933152 53904416 7775360
05:24:14 23138 8192000000 10008110528 10405175296 1074469008 11.595 100 57 112 0 1118272160 32225552 11577600
05:25:39 6523 8192000000 10009838272 10410909696 1078452176 11.633 100 49 97 0 1120618944 32424640 9742128
05:26:47 11414 8192000000 10025512480 10435964928 1087985568 11.724 100 37 74 1 1121626304 25807872 7832864
05:28:06 102229 8192000000 10025793776 10434068480 1094989360 11.790 100 30 60 1 1126740464 25605296 6145808
05:30:59 22587 8192000000 10049020224 10455658496 1085210880 11.697 98 34 67 0 1141025888 48444992 7370016
05:32:29 17369 8192000000 10089363968 10489253888 1080882224 11.656 97 58 116 0 1175483792 82591216 12010352
05:33:53 14821 8192000000 10071966512 10498863104 1082006064 11.667 98 52 103 0 1183118960 90970256 10142640
05:35:14 2812 8192000000 10081956960 10483605504 1100835888 11.846 100 59 115 0 1184841280 71892176 12113216
05:36:24 7546 8192000000 10079452592 10473996288 1078763408 11.636 98 65 130 0 1170916864 79052640 13100816
05:37:36 8505 8192000000 10092039824 10494074880 1088357984 11.727 99 46 92 0 1188073168 90836800 8878384
05:38:55 15416 8192000000 10085094208 10484019200 1075031648 11.600 98 50 99 0 1180968560 95319120 10617792
05:40:14 4137 8192000000 10083504384 10479300608 1076932688 11.618 99 42 84 0 1180871664 95059168 8879808
05:41:23 55632 8192000000 10138184240 10558881792 1093571344 11.777 99 33 64 0 1258314480 157330112 7413024
05:43:26 8465 8192000000 10186469600 10589020160 1106482272 11.899 99 47 95 1 1285072368 168299392 10290704
05:44:39 7855 8192000000 10213643104 10614652928 1112167344 11.953 100 56 112 1 1315777184 191347312 12262528
05:46:05 4312 8192000000 10189447328 10586505216 1068942720 11.542 98 60 118 0 1281580048 199495408 13141920
05:47:16 1545 8192000000 10268930000 10659119104 1094913552 11.789 100 63 126 2 1374647872 264936144 14798176
05:48:26 12310 8192000000 10270045664 10684043264 1085197232 11.697 99 46 91 1 1360234224 264055424 10981568
05:49:42 9072 8192000000 10296188112 10696486912 1106529344 11.900 100 59 114 0 1399767792 279588800 13649648
05:51:03 19097 8192000000 10294708400 10769588224 1118314512 12.011 100 28 56 0 1402985600 277600560 7070528
05:52:40 11366 8192000000 10241821808 10702290944 1108785136 11.921 100 23 44 0 1355498736 240734832 5978768
05:53:58 31419 8192000000 10145825440 10671828992 1098710416 11.825 100 9 18 0 1254020976 153043200 2267360
05:55:30 95308 8192000000 10037925056 10493620224 1095520784 11.795 99 6 12 0 1146483952 49919424 1043744
05:58:10 30028 8192000000 10112082016 10537934848 1127023792 12.093 100 35 66 1 1211074832 77322800 6728240
05:59:47 122439 8192000000 10133594112 10578280448 1118813040 12.016 100 25 50 0 1222173984 97812448 5548496
06:03:04 47417 8192000000 10138759696 10584231936 1131590128 12.136 100 27 53 0 1211315536 73327104 6398304
06:04:56 76296 8192000000 10066145376 10530144256 1110333984 11.936 98 21 40 0 1161431152 47207856 3889312
06:07:13 53541 8192000000 10065834592 10527260672 1139658592 12.212 100 13 26 0 1165284672 23253360 2372720
06:09:48 28144 8192000000 10103020304 10554130432 1146882416 12.280 100 24 49 0 1201998176 49682416 5433344
06:11:17 72261 8192000000 10121103856 10639048704 1147165904 12.283 100 7 15 0 1191688016 43247920 1274192
06:13:31 38968 8192000000 10113666384 10577969152 1159848960 12.402 100 40 78 1 1228978368 60173680 8955728
06:15:12 47523 8192000000 10071369680 10509770752 1130537088 12.126 98 21 43 0 1156029200 21350144 4141968
06:17:00 38132 8192000000 10124919296 10574385152 1144343600 12.256 99 32 65 0 1206737248 56380864 6012784
06:18:39 44131 8192000000 10113112576 10588487680 1135849792 12.176 98 33 66 1 1234144160 90709744 7584624
06:20:30 88469 8192000000 10100873824 10529345536 1080188688 11.649 94 11 22 0 1115220160 33220496 1810976
06:23:00 59597 8192000000 10066690272 10506727424 1128607904 12.108 99 9 18 0 1158932240 28790560 1533776
06:25:00 81813 8192000000 10069083824 10538082304 1125604640 12.080 98 19 36 0 1180074224 50351312 4118272
06:27:27 27819 8192000000 10106117136 10553708544 1145130496 12.264 100 38 76 1 1218501312 66219936 7150880
06:28:57 40274 8192000000 10024030368 10484510720 1041362176 11.278 92 6 11 0 1056832960 14489984 980800
06:30:50 109014 8192000000 10111349040 10590228480 1069069840 11.543 97 14 28 0 1161228000 89129968 3028192
06:33:39 21428 8192000000 10040169392 10529193984 1079859904 11.646 99 11 23 0 1186367632 104049856 2457872
06:35:26 37869 8192000000 10020314512 10430726144 1043994352 11.303 95 37 73 0 1085705808 34486912 7224544
06:37:06 46511 8192000000 10030990656 10471546880 1060775424 11.464 97 35 70 0 1110128992 42967424 6386144
06:38:53 41357 8192000000 10082232704 10538926080 1088358192 11.727 99 33 66 0 1154306880 59805776 6142912
06:40:35 81728 8192000000 10026526336 10446450688 1058124592 11.439 96 23 44 1 1093393952 31104544 4164816
06:43:04 40943 8192000000 10056647088 10497101824 1096948784 11.809 99 35 70 0 1169196064 65420944 6826336
06:45:00 28144 8192000000 10038691248 10492248064 1112560000 11.957 100 24 48 0 1147924720 30416192 4948528
06:46:28 51890 8192000000 10089259552 10554322944 1124403712 12.069 100 13 24 0 1198070352 70485312 3181328
06:49:02 59183 8192000000 10050594000 10524446720 1107347056 11.907 99 19 38 0 1162193776 50485120 4361600
06:51:04 35136 8192000000 10080440272 10528227328 1110881104 11.941 98 38 74 0 1175832400 57150320 7800976
06:53:05 82412 8192000000 10110857136 10603950080 1130344176 12.125 100 18 36 0 1240946032 106508784 4093072
06:55:33 92260 8192000000 10083326800 10558705664 1072801264 11.579 95 26 52 0 1122989056 45027776 5160016
06:58:06 55808 8192000000 10056983248 10491514880 1116253520 11.992 99 17 35 0 1153188880 33780176 3155184
07:00:02 100153 8192000000 10062198128 10504404992 1106320800 11.898 98 34 68 0 1166791328 53523600 6946928
07:02:43 40853 8192000000 10075506960 10549219328 1120333152 12.030 99 6 12 1 1182667552 61136416 1197984
07:04:24 79104 8192000000 10077008048 10558894080 1120357504 12.030 99 18 34 1 1168935008 44581264 3996240
07:06:44 34398 8192000000 10097703392 10543587328 1124602352 12.070 99 15 30 0 1179506992 51683008 3221632

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 18-03-2024 07:09:20 to 18-03-2024 07:09:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 100 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Mon Mar 18 07:09:38 2024 
 
Database header page information: 
    Flags            0 
    Generation        87891 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    164758 
    Oldest active        168406 
    Oldest snapshot        168406 
    Next transaction    168407 
    Sequence number        0 
    Next attachment ID    679 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.57, total records: 7691165 
    Average version length: 48.16, total versions: 64484, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87920 
    Data pages: 87920, average fill: 70% 
    Primary pages: 87919, secondary pages: 1, swept pages: 37255 
    Empty pages: 4, full pages: 72967 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 24 
    40 - 59% = 720 
    60 - 79% = 87130 
    80 - 99% = 38 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 22950, nodes: 7691165 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1677389, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 283 
        20 - 39% = 1892 
        40 - 59% = 3774 
        60 - 79% = 2374 
        80 - 99% = 14627 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13357, nodes: 7691165 
    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: 1500856, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1598 
        40 - 59% = 1843 
        60 - 79% = 1132 
        80 - 99% = 8783 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8216, nodes: 7691165 
    Average node length: 6.60, total dup: 5771851, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1493805, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 984 
        40 - 59% = 1255 
        60 - 79% = 920 
        80 - 99% = 4940 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.68, total records: 2210804 
    Average version length: 58.82, total versions: 34078, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28216 
    Data pages: 28216, average fill: 72% 
    Primary pages: 28214, secondary pages: 2, swept pages: 8829 
    Empty pages: 3, full pages: 17590 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 59 
    40 - 59% = 443 
    60 - 79% = 27639 
    80 - 99% = 57 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4473, nodes: 2210804 
    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: 676379, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 896 
        40 - 59% = 788 
        60 - 79% = 733 
        80 - 99% = 2056 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2369, nodes: 2212159 
    Average node length: 4.97, total dup: 2211260, max dup: 21153 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1250721, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 193 
        40 - 59% = 1363 
        60 - 79% = 532 
        80 - 99% = 280 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1730, nodes: 2210804 
    Average node length: 4.97, total dup: 2210754, max dup: 130074 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1048957, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 570 
        60 - 79% = 55 
        80 - 99% = 1099 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4265, nodes: 2210804 
    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: 676379, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 602 
        40 - 59% = 513 
        60 - 79% = 828 
        80 - 99% = 2218 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.19, total records: 400 
    Average version length: 26.04, total versions: 2949, max versions: 9 
    Average fragment length: 2.00, total fragments: 7, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 64% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 5, full pages: 19 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 20 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 10.09, total records: 86022 
    Average version length: 68.29, total versions: 84436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.72 
    Pointer pages: 6, data page slots: 2976 
    Data pages: 1648, average fill: 72% 
    Primary pages: 1647, secondary pages: 1, swept pages: 0 
    Empty pages: 120, full pages: 1067 
    Fill distribution: 
     0 - 19% = 175 
    20 - 39% = 141 
    40 - 59% = 146 
    60 - 79% = 224 
    80 - 99% = 962 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1698669, depth: 3, leaf buckets: 291, nodes: 86022 
    Average node length: 13.29, total dup: 5022, max dup: 1 
    Average key length: 10.73, compression ratio: 2.52 
    Average prefix length: 19.21, average data length: 7.79 
    Clustering factor: 63650, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 107 
        40 - 59% = 109 
        60 - 79% = 70 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 302, max versions: 12 
    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: 16 
    Data pages: 16, average fill: 7% 
    Primary pages: 8, secondary pages: 8, swept pages: 0 
    Empty pages: 7, full pages: 1 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.36, total records: 1577 
    Average version length: 43.22, total versions: 1468, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.10 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 69% 
    Primary pages: 23, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 14 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91545, depth: 2, leaf buckets: 3, nodes: 1577 
    Average node length: 4.26, total dup: 1479, max dup: 141 
    Average key length: 2.67, compression ratio: 7.12 
    Average prefix length: 18.39, average data length: 0.61 
    Clustering factor: 874, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.56, total records: 70 
    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: 49% 
    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% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.41, total records: 846462 
    Average version length: 37.93, total versions: 28884, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8904 
    Data pages: 8904, average fill: 65% 
    Primary pages: 8901, secondary pages: 3, swept pages: 1903 
    Empty pages: 44, full pages: 6958 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 57 
    40 - 59% = 505 
    60 - 79% = 8208 
    80 - 99% = 61 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 886, nodes: 832351 
    Average node length: 4.88, total dup: 832302, max dup: 161983 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92676, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 123 
        40 - 59% = 461 
        60 - 79% = 186 
        80 - 99% = 115 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1019, nodes: 832351 
    Average node length: 5.89, total dup: 741546, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.10, average data length: 0.90 
    Clustering factor: 165479, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 45 
        40 - 59% = 654 
        60 - 79% = 62 
        80 - 99% = 256 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1039, nodes: 832351 
    Average node length: 5.89, total dup: 741546, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 167386, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 79 
        40 - 59% = 636 
        60 - 79% = 75 
        80 - 99% = 247 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1168, nodes: 832351 
    Average node length: 5.97, total dup: 741546, max dup: 42 
    Average key length: 3.09, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 159658, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 224 
        40 - 59% = 649 
        60 - 79% = 209 
        80 - 99% = 85 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.72, total records: 5447 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.31, total fragments: 29, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 62% 
    Primary pages: 78, secondary pages: 9, swept pages: 53 
    Empty pages: 8, full pages: 55 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5447 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.39, average data length: 1.55 
    Clustering factor: 5182, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5447 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 183, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 76965 
    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: 800 
    Data pages: 800, average fill: 66% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 799 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 799 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34319, depth: 2, leaf buckets: 97, nodes: 76965 
    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: 2880, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 150.68, total records: 173367 
    Average version length: 148.52, total versions: 763, 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: 4504 
    Data pages: 4296, average fill: 83% 
    Primary pages: 4293, secondary pages: 3, swept pages: 2 
    Empty pages: 28, full pages: 4255 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4255 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.61, total records: 146092 
    Average version length: 137.80, total versions: 393, 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: 4528 
    Data pages: 3640, average fill: 83% 
    Primary pages: 3638, secondary pages: 2, swept pages: 2 
    Empty pages: 46, full pages: 3579 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3579 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.88, total records: 130731 
    Average version length: 149.80, total versions: 1194, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 6, data page slots: 3928 
    Data pages: 3240, average fill: 83% 
    Primary pages: 3238, secondary pages: 2, swept pages: 2 
    Empty pages: 21, full pages: 3207 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 3207 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 150.26, total records: 138280 
    Average version length: 148.10, total versions: 956, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 4312 
    Data pages: 3464, average fill: 82% 
    Primary pages: 3461, secondary pages: 3, swept pages: 3 
    Empty pages: 56, full pages: 3392 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3393 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.68, total records: 154352 
    Average version length: 148.96, total versions: 819, 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: 8, data page slots: 4256 
    Data pages: 3840, average fill: 83% 
    Primary pages: 3837, secondary pages: 3, swept pages: 4 
    Empty pages: 37, full pages: 3791 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3791 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.64, total records: 143134 
    Average version length: 144.33, total versions: 410, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 7, data page slots: 4376 
    Data pages: 3560, average fill: 83% 
    Primary pages: 3558, secondary pages: 2, swept pages: 5 
    Empty pages: 39, full pages: 3508 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3507 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 148.36, total records: 156869 
    Average version length: 152.14, total versions: 3281, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 6, data page slots: 4360 
    Data pages: 3896, average fill: 83% 
    Primary pages: 3893, secondary pages: 3, swept pages: 5 
    Empty pages: 31, full pages: 3850 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3850 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 148.77, total records: 150873 
    Average version length: 152.75, total versions: 2761, 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: 5, data page slots: 4192 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3765, secondary pages: 3, swept pages: 1 
    Empty pages: 49, full pages: 3705 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3705 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 149.99, total records: 145882 
    Average version length: 149.03, total versions: 1124, 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: 3600 
    Data pages: 3600, average fill: 83% 
    Primary pages: 3597, secondary pages: 3, swept pages: 4 
    Empty pages: 11, full pages: 3577 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3576 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 149.49, total records: 154222 
    Average version length: 151.54, total versions: 1997, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 4288 
    Data pages: 3840, average fill: 83% 
    Primary pages: 3838, secondary pages: 2, swept pages: 3 
    Empty pages: 42, full pages: 3785 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3785 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.21, total records: 2051201 
    Average version length: 52.97, total versions: 25306, 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: 25336 
    Data pages: 25336, average fill: 70% 
    Primary pages: 25323, secondary pages: 13, swept pages: 11143 
    Empty pages: 203, full pages: 21817 
    Fill distribution: 
     0 - 19% = 379 
    20 - 39% = 318 
    40 - 59% = 931 
    60 - 79% = 23474 
    80 - 99% = 234 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2543, nodes: 2051201 
    Average node length: 5.45, total dup: 1912557, max dup: 1448 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 179996, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 326 
        40 - 59% = 1637 
        60 - 79% = 280 
        80 - 99% = 294 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2051201 
    Average node length: 5.70, total dup: 1840335, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 368914, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2553 
        60 - 79% = 169 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2075, nodes: 2051201 
    Average node length: 4.96, total dup: 2051101, max dup: 28674 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177742, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 210 
        40 - 59% = 1039 
        60 - 79% = 412 
        80 - 99% = 411 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 45.93, total records: 157798 
    Average version length: 69.17, total versions: 61018, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.74 
    Pointer pages: 3, data page slots: 3808 
    Data pages: 3056, average fill: 61% 
    Primary pages: 3056, secondary pages: 0, swept pages: 344 
    Empty pages: 424, full pages: 1924 
    Fill distribution: 
     0 - 19% = 551 
    20 - 39% = 131 
    40 - 59% = 251 
    60 - 79% = 1029 
    80 - 99% = 1094 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1553459, depth: 3, leaf buckets: 232, nodes: 157798 
    Average node length: 6.45, total dup: 137302, max dup: 14 
    Average key length: 3.93, compression ratio: 10.70 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27902, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 124 
        60 - 79% = 64 
        80 - 99% = 15 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.97, total records: 7198309 
    Average version length: 68.73, total versions: 356746, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 66, data page slots: 106816 
    Data pages: 106816, average fill: 72% 
    Primary pages: 106815, secondary pages: 1, swept pages: 21204 
    Empty pages: 2, full pages: 76264 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 267 
    40 - 59% = 4786 
    60 - 79% = 100533 
    80 - 99% = 1206 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10822, nodes: 7198309 
    Average node length: 6.50, total dup: 6230143, max dup: 29 
    Average key length: 3.51, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1705737, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1617 
        40 - 59% = 5944 
        60 - 79% = 2688 
        80 - 99% = 568 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8825, nodes: 7198309 
    Average node length: 5.39, total dup: 6918809, max dup: 178 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1501244, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1263 
        40 - 59% = 5177 
        60 - 79% = 1470 
        80 - 99% = 901 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8868, nodes: 7198309 
    Average node length: 5.39, total dup: 6918809, max dup: 178 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1503671, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1287 
        40 - 59% = 5171 
        60 - 79% = 1474 
        80 - 99% = 928 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.39, total records: 12149984 
    Average version length: 68.71, total versions: 312041, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 108, data page slots: 175600 
    Data pages: 175600, average fill: 74% 
    Primary pages: 175599, secondary pages: 1, swept pages: 65054 
    Empty pages: 9, full pages: 155892 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 448 
    40 - 59% = 4200 
    60 - 79% = 168837 
    80 - 99% = 2083 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18549, nodes: 12147997 
    Average node length: 6.61, total dup: 10593346, max dup: 51 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2484172, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2165 
        40 - 59% = 11024 
        60 - 79% = 4617 
        80 - 99% = 719 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 49.40, total records: 1527699 
    Average version length: 69.09, total versions: 328815, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.55 
    Pointer pages: 26, data page slots: 40648 
    Data pages: 27632, average fill: 58% 
    Primary pages: 27546, secondary pages: 86, swept pages: 6604 
    Empty pages: 2055, full pages: 18174 
    Fill distribution: 
     0 - 19% = 3745 
    20 - 39% = 3900 
    40 - 59% = 2593 
    60 - 79% = 12880 
    80 - 99% = 4514 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1808, nodes: 1354938 
    Average node length: 5.52, total dup: 1300115, max dup: 49 
    Average key length: 2.57, compression ratio: 16.36 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 97303, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 417 
        40 - 59% = 862 
        60 - 79% = 443 
        80 - 99% = 76 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 43.09, total records: 1118108 
    Average version length: 69.05, total versions: 149353, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.92 
    Pointer pages: 20, data page slots: 31696 
    Data pages: 26280, average fill: 39% 
    Primary pages: 26280, secondary pages: 0, swept pages: 5576 
    Empty pages: 4522, full pages: 9301 
    Fill distribution: 
     0 - 19% = 7744 
    20 - 39% = 4664 
    40 - 59% = 6545 
    60 - 79% = 7058 
    80 - 99% = 269 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1188, nodes: 784908 
    Average node length: 5.89, total dup: 726353, max dup: 65 
    Average key length: 2.96, compression ratio: 14.19 
    Average prefix length: 41.11, average data length: 0.89 
    Clustering factor: 110071, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 349 
        40 - 59% = 583 
        60 - 79% = 241 
        80 - 99% = 15 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.10, total records: 8869046 
    Average version length: 69.00, total versions: 262517, 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: 87, data page slots: 140472 
    Data pages: 140456, average fill: 67% 
    Primary pages: 140444, secondary pages: 12, swept pages: 58347 
    Empty pages: 373, full pages: 70244 
    Fill distribution: 
     0 - 19% = 1115 
    20 - 39% = 5864 
    40 - 59% = 18841 
    60 - 79% = 113090 
    80 - 99% = 1546 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13420, nodes: 8866061 
    Average node length: 6.66, total dup: 7355559, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1988689, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1507 
        40 - 59% = 7395 
        60 - 79% = 4148 
        80 - 99% = 369 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21104130 
    Average version length: 82.97, total versions: 12448, 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: 319008 
    Data pages: 319008, average fill: 81% 
    Primary pages: 319002, secondary pages: 6, swept pages: 11940 
    Empty pages: 29, full pages: 318636 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 23 
    40 - 59% = 62 
    60 - 79% = 47932 
    80 - 99% = 270942 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19265, nodes: 21104130 
    Average node length: 5.72, total dup: 20624134, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276314, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 0 
        40 - 59% = 7999 
        60 - 79% = 502 
        80 - 99% = 10754 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17124, nodes: 21104130 
    Average node length: 6.31, total dup: 18546802, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915630, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 6 
        40 - 59% = 761 
        60 - 79% = 269 
        80 - 99% = 16083 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21054, nodes: 21104130 
    Average node length: 6.35, total dup: 18465504, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3569886, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8274 
        60 - 79% = 585 
        80 - 99% = 12187 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16052, nodes: 21104130 
    Average node length: 5.56, total dup: 21104030, max dup: 229981 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944378, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 10 
        40 - 59% = 2869 
        60 - 79% = 353 
        80 - 99% = 12818 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.21, total records: 9332783 
    Average version length: 82.63, total versions: 278676, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 102, data page slots: 166344 
    Data pages: 166304, average fill: 69% 
    Primary pages: 166276, secondary pages: 28, swept pages: 76068 
    Empty pages: 633, full pages: 100798 
    Fill distribution: 
     0 - 19% = 1932 
    20 - 39% = 8148 
    40 - 59% = 22388 
    60 - 79% = 115228 
    80 - 99% = 18608 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11312, nodes: 9332783 
    Average node length: 5.34, total dup: 9030482, max dup: 182 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2115743, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 87 
        40 - 59% = 9327 
        60 - 79% = 1845 
        80 - 99% = 53 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 12840, nodes: 9332783 
    Average node length: 6.21, total dup: 7737321, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1480733, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 3610 
        40 - 59% = 4053 
        60 - 79% = 2684 
        80 - 99% = 2365 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12636, nodes: 9332783 
    Average node length: 5.96, total dup: 8093760, max dup: 41 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2300132, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 103 
        40 - 59% = 10383 
        60 - 79% = 2084 
        80 - 99% = 62 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9753, nodes: 9332783 
    Average node length: 5.11, total dup: 9332683, max dup: 165842 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1498511, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1199 
        40 - 59% = 4859 
        60 - 79% = 1683 
        80 - 99% = 1963 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.70, total records: 11070276 
    Average version length: 82.61, total versions: 240925, 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: 117, data page slots: 189496 
    Data pages: 188048, average fill: 72% 
    Primary pages: 187923, secondary pages: 125, swept pages: 66848 
    Empty pages: 2571, full pages: 144638 
    Fill distribution: 
     0 - 19% = 4385 
    20 - 39% = 6887 
    40 - 59% = 16195 
    60 - 79% = 98604 
    80 - 99% = 61977 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13124, nodes: 11070276 
    Average node length: 5.29, total dup: 10961456, max dup: 664 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2319203, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 125 
        40 - 59% = 10011 
        60 - 79% = 2884 
        80 - 99% = 104 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10242, nodes: 11070276 
    Average node length: 5.49, total dup: 10586017, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 712256, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 167 
        20 - 39% = 856 
        40 - 59% = 2535 
        60 - 79% = 1776 
        80 - 99% = 4908 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15013, nodes: 11070276 
    Average node length: 6.02, total dup: 9656131, max dup: 70 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2335590, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 156 
        40 - 59% = 11605 
        60 - 79% = 3114 
        80 - 99% = 136 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10512, nodes: 11070276 
    Average node length: 5.21, total dup: 11070176, max dup: 208937 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 699821, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 813 
        40 - 59% = 4555 
        60 - 79% = 1550 
        80 - 99% = 3499 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.64, total records: 9435409 
    Average version length: 82.96, total versions: 267736, 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: 105, data page slots: 171008 
    Data pages: 170944, average fill: 68% 
    Primary pages: 170916, secondary pages: 28, swept pages: 81898 
    Empty pages: 662, full pages: 97837 
    Fill distribution: 
     0 - 19% = 1955 
    20 - 39% = 9665 
    40 - 59% = 26363 
    60 - 79% = 114736 
    80 - 99% = 18225 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11456, nodes: 9435409 
    Average node length: 5.16, total dup: 9407198, max dup: 2673 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1908396, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1557 
        40 - 59% = 7579 
        60 - 79% = 1725 
        80 - 99% = 557 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 12968, nodes: 9435409 
    Average node length: 6.23, total dup: 7822181, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1439380, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 3660 
        40 - 59% = 4006 
        60 - 79% = 2672 
        80 - 99% = 2491 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12049, nodes: 9435409 
    Average node length: 5.42, total dup: 9011078, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2039281, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1453 
        40 - 59% = 8478 
        60 - 79% = 1552 
        80 - 99% = 540 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9907, nodes: 9435409 
    Average node length: 5.13, total dup: 9435309, max dup: 168312 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1508905, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1257 
        40 - 59% = 4964 
        60 - 79% = 1653 
        80 - 99% = 1993 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.77, total records: 567916 
    Average version length: 68.79, total versions: 3787, 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: 7968 
    Data pages: 7968, average fill: 75% 
    Primary pages: 7968, secondary pages: 0, swept pages: 3381 
    Empty pages: 4, full pages: 6922 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 10 
    40 - 59% = 136 
    60 - 79% = 7769 
    80 - 99% = 49 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 47058, depth: 3, leaf buckets: 735, nodes: 567916 
    Average node length: 5.95, total dup: 483502, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100303, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 526 
        60 - 79% = 93 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34795, depth: 3, leaf buckets: 751, nodes: 567916 
    Average node length: 6.15, total dup: 465747, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100351, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 538 
        60 - 79% = 77 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 553, nodes: 567916 
    Average node length: 4.86, total dup: 567816, max dup: 9739 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89181, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 308 
        60 - 79% = 91 
        80 - 99% = 124 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Mar 18 07:10:01 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7691165 64484 1 0.0000 0.0000
DOC_LIST 2210804 34078 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2949 9 700.0000 0.0000
INVNT_TURNOVER_LOG 86022 84436 1 0.0000 0.0000
MONEY_SALDO 49 302 12 600.0000 0.0000
MONEY_TURNOVER_LOG 1577 1468 1 0.0000 0.0000
PDISTR 846462 28884 3 0.0000 0.0000
PERF_SPLIT_0 173367 763 1 0.0000 0.0000
PERF_SPLIT_1 146092 393 1 0.0000 0.0000
PERF_SPLIT_2 130731 1194 1 0.0000 0.0000
PERF_SPLIT_3 138280 956 1 0.0000 0.0000
PERF_SPLIT_4 154352 819 1 0.0000 0.0000
PERF_SPLIT_5 143134 410 1 0.0000 0.0000
PERF_SPLIT_6 156869 3281 1 0.0000 0.0000
PERF_SPLIT_7 150873 2761 1 0.0000 0.0000
PERF_SPLIT_8 145882 1124 1 0.0000 0.0000
PERF_SPLIT_9 154222 1997 1 0.0000 0.0000
PSTORNED 2051201 25306 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 157798 61018 1 0.0000 0.0000
XQD_1000_3300 7198309 356746 1 0.0000 0.0000
XQD_1200_2000 12149984 312041 1 0.0000 0.0000
XQD_2000_3300 1527699 328815 1 0.0000 0.0000
XQD_2100_3300 1118108 149353 1 0.0000 0.0000
XQD_3300_3400 8869046 262517 1 0.0000 0.0000
XQS_1000_1200 21104130 12448 1 0.0000 0.0000
XQS_1000_3300 9332783 278676 1 0.0000 0.0000
XQS_1200_2000 11070276 240925 1 0.0000 0.0000
XQS_2100_3300 9435409 267736 1 0.0000 0.0000
XQS_3300_3400 567916 3787 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 ---
:58: 
:59: mscs-test-161.budzdorov.ru    Mon Mar 18 07:07:51 2024
:60:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:61: 
:62: 
:63: mscs-test-161.budzdorov.ru    Mon Mar 18 07:07:54 2024
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:65: 
:66: 
:67: mscs-test-161.budzdorov.ru    Mon Mar 18 07:07:55 2024
:68:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:69: 
:70: 
:71: mscs-test-161.budzdorov.ru    Mon Mar 18 07:07:55 2024
:72:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:73: 
:74: 
:75: mscs-test-161.budzdorov.ru    Mon Mar 18 07:07:56 2024
:76:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:77: 
--- end of diff output ---

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

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