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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15721928 kB
MemAvailable 30272884 kB
Buffers 20 kB
Cached 15974048 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 04:07:50
DTS_END                         2024-03-18 04:07:50.0340
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/36434
TRN_ID                          175739
ATT_ID                          549
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: 9056.51 23228 905651
customer order: creation 183.22 384 18322
customer order: refuse 15.48 366 1548
order to supplier: creation 47.73 1248 4773
order to supplier: removal 3.41 84607 341
invoice (draft): creation 48.52 2994 4852
invoice (draft): removal 47.00 681 4700
invoice accept: apply 43.80 19566 4380
invoice accept: cancel 43.12 877 4312
customer reserve: creation 4099.63 192 409963
customer reserve: removal 4216.53 56 421653
realization accept: apply 87.71 201 8771
realization accept: cancel 86.23 123 8623
payment from customer: creation 61.83 156 6183
payment from customer: removal 6.08 88 608
payment to supplier: creation 50.98 126 5098
payment to supplier: removal 3.78 78 378
service: total inventory turnovers 4.08 3884 408
service: total monetary turnovers 6.43 484 643
service: aggregate perf. data 0.92 13223 92
service: refresh index statistics 0.03 335225 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 18-03-2024 04:09:57 to 18-03-2024 04:10:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4098
TEST_TIME 2 4041
TEST_TIME 3 5031
TEST_TIME 4 4940
TEST_TIME 5 4666
TEST_TIME 6 4787
TEST_TIME 7 5139
TEST_TIME 8 4868
TEST_TIME 9 4889
TEST_TIME 10 5153
TEST_TIME 11 5784
TEST_TIME 12 5819
TEST_TIME 13 5855
TEST_TIME 14 6257
TEST_TIME 15 6656
TEST_TIME 16 7017
TEST_TIME 17 7464
TEST_TIME 18 7741
TEST_TIME 19 7881
TEST_TIME 20 8183
TEST_TIME 21 8473
TEST_TIME 22 8728
TEST_TIME 23 9044
TEST_TIME 24 9109
TEST_TIME 25 9340
TEST_TIME 26 9897
TEST_TIME 27 9959
TEST_TIME 28 9779
TEST_TIME 29 9782
TEST_TIME 30 9690
TEST_TIME 31 9930
TEST_TIME 32 9911
TEST_TIME 33 9671
TEST_TIME 34 9465
TEST_TIME 35 9325
TEST_TIME 36 9330
TEST_TIME 37 9224
TEST_TIME 38 9349
TEST_TIME 39 9384
TEST_TIME 40 9268
TEST_TIME 41 9160
TEST_TIME 42 9145
TEST_TIME 43 9248
TEST_TIME 44 9414
TEST_TIME 45 9349
TEST_TIME 46 9425
TEST_TIME 47 9548
TEST_TIME 48 9541
TEST_TIME 49 9526
TEST_TIME 50 9617
TEST_TIME 51 9613
TEST_TIME 52 9656
TEST_TIME 53 9777
TEST_TIME 54 9748
TEST_TIME 55 9639
TEST_TIME 56 9585
TEST_TIME 57 9445
TEST_TIME 58 9463
TEST_TIME 59 9480
TEST_TIME 60 9422
TEST_TIME 61 9343
TEST_TIME 62 9263
TEST_TIME 63 9242
TEST_TIME 64 9247
TEST_TIME 65 9231
TEST_TIME 66 9199
TEST_TIME 67 9309
TEST_TIME 68 9245
TEST_TIME 69 9250
TEST_TIME 70 9412
TEST_TIME 71 9447
TEST_TIME 72 9436
TEST_TIME 73 9482
TEST_TIME 74 9576
TEST_TIME 75 9629
TEST_TIME 76 9695
TEST_TIME 77 9622
TEST_TIME 78 9510
TEST_TIME 79 9466
TEST_TIME 80 9385
TEST_TIME 81 9359
TEST_TIME 82 9253
TEST_TIME 83 9195
TEST_TIME 84 9164
TEST_TIME 85 9168
TEST_TIME 86 9155
TEST_TIME 87 9137
TEST_TIME 88 9148
TEST_TIME 89 9142
TEST_TIME 90 9170
TEST_TIME 91 9160
TEST_TIME 92 9135
TEST_TIME 93 9210
TEST_TIME 94 9233
TEST_TIME 95 9250
TEST_TIME 96 9280
TEST_TIME 97 9199
TEST_TIME 98 9137
TEST_TIME 99 9116
TEST_TIME 100 9063

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-03-2024 04:10:01 to 18-03-2024 04:10:04.

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 1280662 1280662 0 0.00 0 24711 8 0 0
doc_list_biud 1280661 1280661 0 0.00 0 36131 24 0 0
sp_add_invoice_to_stock 4554 4380 174 3.82 14 181174 19567 0 174
sp_cancel_adding_invoice 4312 4312 0 0.00 4 100500 877 0 0
sp_cancel_client_order 1548 1548 0 0.00 4 14687 367 0 0
sp_cancel_customer_reserve 421653 421653 0 0.00 0 19218 56 0 0
sp_cancel_pay_from_customer 608 608 0 0.00 2 6193 88 0 0
sp_cancel_pay_to_supplier 378 378 0 0.00 2 4426 79 0 0
sp_cancel_supplier_invoice 4718 4700 18 0.38 2 39199 682 0 18
sp_cancel_supplier_order 341 341 0 0.00 6 891009 84607 0 0
sp_cancel_write_off 8623 8623 0 0.00 1 15206 123 0 0
sp_client_order 18322 18322 0 0.00 3 25632 384 0 0
sp_customer_reserve 409963 409963 0 0.00 0 37230 192 0 0
sp_fill_shopping_cart 27937 27937 0 0.00 1 33343 39 0 0
sp_fill_shopping_cart_clo_res 409950 409950 0 0.00 0 20276 16 0 0
sp_get_clo_for_invoice 4367 4367 0 0.00 0 35243 384 0 0
sp_kill_cost_storno 13921 13921 0 0.00 0 6453 60 0 0
sp_kill_qstorno_ret_qs2qd 856970 856970 0 0.00 0 21603 30 0 0
sp_kill_qty_storno 454315 454315 0 0.00 0 36131 66 0 0
sp_lock_selected_doc 18228 18228 0 0.00 0 7793 4 0 0
sp_make_cost_storno 24419 24419 0 0.00 0 24707 60 0 0
sp_multiply_rows_for_pdistr 24419 24419 0 0.00 0 22794 35 0 0
sp_multiply_rows_for_qdistr 18322 18322 0 0.00 0 18569 207 0 0
sp_pay_from_customer 6183 6183 0 0.00 4 22802 157 0 0
sp_pay_to_supplier 5098 5098 0 0.00 4 14018 127 0 0
sp_payment_common 11281 11281 0 0.00 1 17604 24 0 0
sp_qd_handle_on_cancel_clo 1548 1548 0 0.00 0 9306 317 0 0
sp_qd_handle_on_invoice_upd_sts 8679 8679 0 0.00 0 36131 294 0 0
sp_qd_handle_on_reserve_upd_sts 8771 8771 0 0.00 0 18859 71 0 0
sp_reserve_write_off 8771 8771 0 0.00 6 24754 201 0 0
sp_supplier_invoice 4852 4852 0 0.00 5 94020 2995 0 0
sp_supplier_order 4773 4773 0 0.00 4 29064 1248 0 0
srv_aggregate_perf_data 92 92 0 0.00 1872 104278 13224 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1343 105396 39847 0 0
srv_find_qd_qs_mism 861363 861363 0 0.00 0 15593 7 0 0
srv_make_invnt_saldo 408 408 0 0.00 24 86524 3885 0 0
srv_make_money_saldo 643 643 0 0.00 1 13076 485 0 0
srv_recalc_idx_stat 3 3 0 0.00 213748 434872 335226 0 0
t$perf-abend:sp_add_invoice_to_stock 174 174 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4380 4380 0 0.00 0 11336 161 0 0
t$perf-norm:sp_cancel_adding_invoice 401 401 0 0.00 0 5567 127 0 0
t$perf-norm:sp_cancel_client_order 1548 1548 0 0.00 0 1737 12 0 0
t$perf-norm:sp_cancel_customer_reserve 609 609 0 0.00 0 2263 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 608 608 0 0.00 0 1777 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 378 378 0 0.00 0 10939 51 0 0
t$perf-norm:sp_cancel_supplier_invoice 343 343 0 0.00 0 7169 34 0 0
t$perf-norm:sp_cancel_supplier_order 341 341 0 0.00 0 19413 1481 0 0
t$perf-norm:sp_cancel_write_off 862 862 0 0.00 0 1000 6 0 0
t$perf-norm:sp_client_order 18322 18322 0 0.00 0 10355 16 0 0
t$perf-norm:sp_customer_reserve 893 893 0 0.00 0 1851 7 0 0
t$perf-norm:sp_pay_from_customer 6183 6183 0 0.00 0 2822 8 0 0
t$perf-norm:sp_pay_to_supplier 5098 5098 0 0.00 0 14320 13 0 0
t$perf-norm:sp_reserve_write_off 8771 8771 0 0.00 0 7230 11 0 0
t$perf-norm:sp_supplier_invoice 4852 4852 0 0.00 0 3076 14 0 0
t$perf-norm:sp_supplier_order 4773 4773 0 0.00 0 2619 14 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 626 30 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 479 9 0 0
t$perf-norm:srv_make_invnt_saldo 408 408 0 0.00 0 1947 22 0 0
t$perf-norm:srv_make_money_saldo 643 643 0 0.00 0 1436 8 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 11 5 0 0
v_add_invoice_to_stock 9082 8734 348 3.83 0 13724 19 0 348
v_all_customers 33682 33682 0 0.00 0 19 1 0 0
v_all_suppliers 27280 27280 0 0.00 0 28 1 0 0
v_all_wares 36642 36642 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 802 802 0 0.00 0 2831 16 0 0
v_cancel_client_order 3096 3096 0 0.00 0 14359 17 0 0
v_cancel_customer_prepayment 1216 1216 0 0.00 0 6171 17 0 0
v_cancel_customer_reserve 1218 1218 0 0.00 0 307 3 0 0
v_cancel_payment_to_supplier 756 756 0 0.00 0 4381 13 0 0
v_cancel_supplier_invoice 722 686 36 4.98 0 12142 50 0 36
v_cancel_supplier_order 682 682 0 0.00 0 193 3 0 0
v_cancel_write_off 1724 1724 0 0.00 0 4977 17 0 0
v_max_id_clo_ord 4770 4770 0 0.00 0 7785 3 0 0
v_max_id_clo_res 893 893 0 0.00 0 5652 21 0 0
v_max_id_ord_sup 4845 4845 0 0.00 0 6245 4 0 0
v_max_non_paid_invoice 1073 1073 0 0.00 0 444 2 0 0
v_max_non_paid_realizn 3065 3065 0 0.00 0 4957 6 0 0
v_min_id_clo_ord 4770 4770 0 0.00 0 7557 14 0 0
v_min_id_clo_res 893 893 0 0.00 0 2089 10 0 0
v_min_id_ord_sup 4845 4845 0 0.00 0 6038 10 0 0
v_min_non_paid_invoice 5098 5098 0 0.00 0 6509 14 0 0
v_min_non_paid_realizn 6183 6183 0 0.00 0 10100 18 0 0
v_our_firm 9196 9196 0 0.00 0 45 1 0 0
v_reserve_write_off 17542 17542 0 0.00 0 9916 8 0 0
x_lock_depdocs_on_canc_invoice 8669 8669 0 0.00 0 25642 118 0 0
x_lock_depdocs_on_canc_sup_ord 341 341 0 0.00 0 7948 297 0 0
x_make_qstorno_1000_1200 4773 4773 0 0.00 1 29059 1161 0 0
x_make_qstorno_1200_2000 4852 4852 0 0.00 3 81652 2853 0 0
x_make_qstorno_2100_3300 409963 409963 0 0.00 0 37229 174 0 0

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

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
02:07:53 1200 8192000000 8955009456 9018175488 12004304 0.146 4 2 5 0 12245568 94864 146400
02:08:56 26240 8192000000 9714903344 10015510528 789265056 8.787 100 90 182 0 819513296 8196432 22051808
02:10:24 14507 8192000000 9759287424 10067058688 833977760 9.239 100 89 178 0 865633744 11155008 20500976
02:11:41 16366 8192000000 9774444992 10088861696 850645616 9.407 100 88 176 0 887926848 17026592 20254640
02:13:10 12452 8192000000 9819385536 10147983360 886212848 9.761 100 85 170 0 932685120 27992320 18479952
02:14:27 12268 8192000000 9878539936 10218979328 922438480 10.120 100 72 144 0 982578560 45391488 14748592
02:15:42 5226 8192000000 9926443856 10275135488 954039696 10.431 100 80 161 1 1041690096 71419200 16231200
02:16:51 3304 8192000000 9965779840 10327494656 994092016 10.821 100 84 168 0 1083222592 72961648 16168928
02:17:58 2964 8192000000 9995826400 10367516672 1023918032 11.110 100 82 164 0 1119737984 79903456 15916496
02:19:03 3058 8192000000 10010806656 10384928768 1039654368 11.261 100 83 165 0 1133112096 78276896 15180832
02:20:07 1262 8192000000 10025886240 10402717696 1062159088 11.477 100 92 187 0 1150907264 70597008 18151168
02:21:10 5691 8192000000 10034697504 10418135040 1062869776 11.484 100 79 158 0 1149222848 69564080 16788992
02:22:17 5567 8192000000 9996056496 10394988544 1067696304 11.530 100 38 74 0 1107144048 32183968 7263776
02:23:24 6557 8192000000 9993113472 10391109632 1076034144 11.610 100 34 69 0 1104745472 21918368 6792960
02:24:31 7052 8192000000 9993165376 10405429248 1082195584 11.668 100 24 48 0 1112096992 24852656 5048752
02:25:41 31120 8192000000 10001347072 10401439744 1085766480 11.702 100 44 86 0 1106503968 11556848 9180640
02:27:12 5248 8192000000 9999805664 10408112128 1075875712 11.608 99 25 47 0 1101528496 21352656 4300128
02:28:20 11737 8192000000 10016846496 10420256768 1096365184 11.803 100 55 111 0 1128913008 21362192 11185632
02:29:37 32007 8192000000 10053154432 10461229056 1069693936 11.549 97 40 80 0 1136563648 58916032 7953680
02:31:14 52051 8192000000 10061000736 10472927232 1114259440 11.973 100 47 94 0 1165702800 41548416 9894944
02:33:19 19446 8192000000 10082520464 10488438784 1088542432 11.729 97 44 86 0 1175860272 78502416 8815424
02:34:42 24029 8192000000 10125906704 10534916096 1129267088 12.114 100 50 100 0 1224088560 84319856 10501616
02:36:24 11964 8192000000 10158387648 10572058624 1129934560 12.121 100 39 78 0 1272353728 134111184 8307984
02:37:50 10255 8192000000 10168689200 10583474176 1114338128 11.973 99 49 93 0 1281560528 157446880 9775520
02:39:06 4243 8192000000 10144356560 10558730240 1096419616 11.804 99 52 101 1 1247295232 139810320 11065296
02:40:20 8012 8192000000 10170498752 10569285632 1093135520 11.772 99 55 110 0 1268580608 163936880 11508208
02:41:32 1767 8192000000 10207091792 10596511744 1093262384 11.774 100 75 150 0 1307301296 197816928 16221984
02:42:38 5523 8192000000 10235612656 10638344192 1094939152 11.790 100 58 114 1 1336133552 229004032 12190368
02:43:48 2567 8192000000 10213273328 10616229888 1095613424 11.796 99 77 149 0 1313019568 202172864 15233280
02:44:56 2247 8192000000 10227829056 10628145152 1108656064 11.920 100 87 173 0 1326331328 199048960 18626304
02:46:00 4412 8192000000 10215086896 10604036096 1102331856 11.860 100 71 140 2 1313239968 197068288 13839824
02:47:09 1341 8192000000 10261220048 10661818368 1120908272 12.036 100 77 154 0 1358740304 221525648 16306384
02:48:14 5503 8192000000 10232086912 10649829376 1101507872 11.852 100 27 54 0 1332439440 224490560 6441008
02:49:23 6494 8192000000 10216605056 10648068096 1099037328 11.829 99 41 82 0 1312292768 203722032 9533408
02:50:33 37575 8192000000 10213103632 10691887104 1109311584 11.926 100 21 42 2 1307092128 193040688 4739856
02:52:49 19781 8192000000 10094088096 10584313856 1099787264 11.836 100 11 21 0 1231530672 129296896 2446512
02:54:16 58843 8192000000 10035989536 10463264768 1096944512 11.809 99 14 26 1 1135080736 35582480 2553744
02:56:17 43925 8192000000 10081617456 10529497088 1116766128 11.996 100 30 60 0 1198181840 75236960 6178752
02:58:09 23213 8192000000 10107240624 10544107520 1117073088 11.999 100 18 36 0 1200870384 80294464 3502832
02:59:47 103555 8192000000 10034546096 10467311616 1107365168 11.907 99 24 46 1 1132660368 20521184 4774016
03:02:41 3519 8192000000 10060196096 10495660032 1122378736 12.049 100 36 70 1 1159698688 29725376 7594576
03:03:45 31140 8192000000 10114679504 10546868224 1127569888 12.098 100 46 92 0 1212968304 75554832 9843584
03:05:18 25967 8192000000 10115302048 10577829888 1128702848 12.109 100 16 32 0 1231100160 98720976 3676336
03:06:46 16796 8192000000 10100166032 10544410624 1139650848 12.212 100 15 30 0 1210447344 67521072 3275424
03:08:17 32384 8192000000 10142224688 10589073408 1150491184 12.314 100 15 30 0 1247243520 93418528 3333808
03:09:51 50375 8192000000 10125939584 10620284928 1141035232 12.225 100 16 32 1 1253778176 109688112 3054832
03:11:44 51387 8192000000 10117763296 10571546624 1130299152 12.124 99 14 27 0 1199914128 67063232 2551744
03:13:40 54804 8192000000 10043174992 10507362304 1042398800 11.288 92 17 34 0 1117548288 71466096 3683392
03:15:35 31463 8192000000 10090789744 10534125568 1101654224 11.853 98 41 82 0 1155246480 46155888 7436368
03:17:09 48559 8192000000 10076026592 10529882112 1086096144 11.706 97 31 62 0 1149681376 57988800 5596432
03:19:02 105394 8192000000 10028407456 10476220416 1001147648 10.890 90 14 28 0 1060291872 56219088 2925136
03:21:54 73371 8192000000 10015108848 10438533120 1076329376 11.612 97 34 67 0 1110050016 26932960 6787680
03:24:39 28097 8192000000 10043926768 10506383360 1072887184 11.580 98 23 46 0 1146521696 69359072 4275440
03:26:08 34382 8192000000 10019849600 10505400320 1097436192 11.813 100 7 14 0 1165301792 66662688 1202912
03:27:49 50350 8192000000 10013905984 10448101376 1054602960 11.405 96 9 18 0 1083725568 27446480 1676128
03:29:39 89125 8192000000 10062192112 10541146112 1102629632 11.863 100 20 40 0 1189530656 82381552 4519472
03:32:10 33233 8192000000 10006914288 10448723968 1059255136 11.449 97 20 38 0 1089302304 26375248 3671920
03:33:50 56087 8192000000 10050970080 10517491712 1102194304 11.858 100 19 38 0 1178500528 72474784 3831440
03:35:50 43843 8192000000 10094555632 10541969408 1086260240 11.707 98 34 68 0 1183393760 89948752 7184768
03:37:41 74493 8192000000 10062356608 10553061376 1089152208 11.735 98 15 30 0 1157455680 65381488 2921984
03:40:01 46747 8192000000 10102297840 10563825664 1117181936 12.000 99 28 56 0 1199970480 78014384 4774160
03:41:54 102922 8192000000 10107845232 10565726208 1100434896 11.842 97 17 34 0 1159176128 55749776 2991456
03:44:45 96651 8192000000 10061107616 10508857344 1130040640 12.122 100 32 64 0 1176771104 39903968 6826496
03:47:27 38997 8192000000 10087303232 10546159616 1139876016 12.214 100 8 16 0 1205353472 63907392 1570064
03:50:40 85660 8192000000 10053086352 10539831296 1115620128 11.986 98 11 22 0 1151058160 33110992 2327040
03:53:11 59198 8192000000 10062264240 10503839744 1107595136 11.910 97 24 48 0 1139453552 27601360 4257056
03:55:16 47335 8192000000 10097205600 10546069504 1115636576 11.986 98 22 42 1 1155814128 36113088 4064464
03:57:05 55154 8192000000 10044305152 10483789824 1036756592 11.233 91 21 42 0 1096525872 55704032 4065248
03:59:00 39981 8192000000 10095683888 10530377728 1088130384 11.725 98 39 78 0 1163600400 68244752 7225264
04:00:45 46004 8192000000 10076074720 10504589312 1100232416 11.840 99 44 89 0 1173469360 63413344 9823600
04:02:31 78467 8192000000 10062210880 10553323520 1119596144 12.023 100 16 32 0 1180375936 57305568 3474224
04:04:49 68568 8192000000 10022199984 10461294592 1069354288 11.546 95 29 58 1 1100239216 25071040 5813888
04:06:59 40382 8192000000 10023799568 10473377792 1054685984 11.406 95 12 24 0 1100974976 44108160 2180832

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 18-03-2024 04:10:11 to 18-03-2024 04:10:25.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 174 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-03-2024 04:10:26 to 18-03-2024 04:10:28.

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          175736
MON$OLDEST_ACTIVE               175966
MON$OLDEST_SNAPSHOT             175966
MON$NEXT_TRANSACTION            175966
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                       1912800
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             702
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 04:10:29 2024 
 
Database header page information: 
    Flags            0 
    Generation        91893 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    175736 
    Oldest active        175966 
    Oldest snapshot        175966 
    Next transaction    175967 
    Sequence number        0 
    Next attachment ID    702 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 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.79, total records: 7721945 
    Average version length: 48.16, total versions: 21555, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88800 
    Data pages: 88800, average fill: 69% 
    Primary pages: 88798, secondary pages: 2, swept pages: 52958 
    Empty pages: 4, full pages: 64135 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 40 
    40 - 59% = 1763 
    60 - 79% = 86979 
    80 - 99% = 8 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23202, nodes: 7721945 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1679710, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 320 
        20 - 39% = 1896 
        40 - 59% = 4018 
        60 - 79% = 2498 
        80 - 99% = 14470 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13473, nodes: 7721945 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1503338, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1615 
        40 - 59% = 1952 
        60 - 79% = 1174 
        80 - 99% = 8732 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8318, nodes: 7721945 
    Average node length: 6.61, total dup: 5786281, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1496562, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 999 
        40 - 59% = 1339 
        60 - 79% = 974 
        80 - 99% = 4883 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.19, total records: 2225509 
    Average version length: 58.90, total versions: 11252, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28584 
    Data pages: 28584, average fill: 71% 
    Primary pages: 28582, secondary pages: 2, swept pages: 17271 
    Empty pages: 1, full pages: 17011 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 12 
    40 - 59% = 445 
    60 - 79% = 28111 
    80 - 99% = 12 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4543, nodes: 2225509 
    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: 677407, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 934 
        40 - 59% = 849 
        60 - 79% = 733 
        80 - 99% = 2027 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2424, nodes: 2226185 
    Average node length: 4.97, total dup: 2225287, max dup: 20143 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1268132, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 219 
        40 - 59% = 1385 
        60 - 79% = 595 
        80 - 99% = 221 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1781, nodes: 2225509 
    Average node length: 4.97, total dup: 2225459, max dup: 130336 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1060575, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 638 
        60 - 79% = 33 
        80 - 99% = 1099 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4345, nodes: 2225509 
    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: 677407, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 628 
        40 - 59% = 612 
        60 - 79% = 842 
        80 - 99% = 2166 
 
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.31, total records: 400 
    Average version length: 29.17, total versions: 1858, max versions: 5 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 65% 
    Primary pages: 10, secondary pages: 14, swept pages: 0 
    Empty pages: 3, full pages: 14 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 15 
 
    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: 12.21, total records: 65990 
    Average version length: 68.28, total versions: 62418, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.21 
    Pointer pages: 6, data page slots: 1936 
    Data pages: 1328, average fill: 68% 
    Primary pages: 1327, secondary pages: 1, swept pages: 24 
    Empty pages: 147, full pages: 848 
    Fill distribution: 
     0 - 19% = 235 
    20 - 39% = 76 
    40 - 59% = 88 
    60 - 79% = 147 
    80 - 99% = 782 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701217, depth: 3, leaf buckets: 227, nodes: 65990 
    Average node length: 13.57, total dup: 3871, max dup: 1 
    Average key length: 10.77, compression ratio: 2.51 
    Average prefix length: 19.17, average data length: 7.83 
    Clustering factor: 50013, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 81 
        40 - 59% = 91 
        60 - 79% = 42 
        80 - 99% = 12 
 
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: 123, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 58% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 10.58, total records: 1028 
    Average version length: 43.48, total versions: 980, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.48 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 36% 
    Primary pages: 31, secondary pages: 1, swept pages: 4 
    Empty pages: 8, full pages: 3 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90517, depth: 2, leaf buckets: 2, nodes: 1028 
    Average node length: 4.68, total dup: 933, max dup: 132 
    Average key length: 3.00, compression ratio: 6.33 
    Average prefix length: 18.09, average data length: 0.91 
    Clustering factor: 604, ratio: 0.59 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        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.59, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.82, total records: 807151 
    Average version length: 37.84, total versions: 19541, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8768 
    Data pages: 8768, average fill: 63% 
    Primary pages: 8767, secondary pages: 1, swept pages: 4170 
    Empty pages: 34, full pages: 3693 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 78 
    40 - 59% = 1413 
    60 - 79% = 7173 
    80 - 99% = 43 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 866, nodes: 797799 
    Average node length: 4.88, total dup: 797750, max dup: 142214 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90513, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 151 
        40 - 59% = 432 
        60 - 79% = 181 
        80 - 99% = 101 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1002, nodes: 797799 
    Average node length: 5.89, total dup: 710416, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158207, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 60 
        40 - 59% = 630 
        60 - 79% = 90 
        80 - 99% = 221 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1045, nodes: 797799 
    Average node length: 5.89, total dup: 710416, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160042, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 120 
        40 - 59% = 645 
        60 - 79% = 92 
        80 - 99% = 188 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1143, nodes: 797799 
    Average node length: 5.97, total dup: 710416, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152905, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 247 
        40 - 59% = 604 
        60 - 79% = 205 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.81, total records: 5511 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.63, total fragments: 27, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 112 
    Data pages: 87, average fill: 62% 
    Primary pages: 76, secondary pages: 11, swept pages: 58 
    Empty pages: 3, full pages: 62 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5511 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.08 
    Average prefix length: 34.54, average data length: 1.54 
    Clustering factor: 5303, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5511 
    Average node length: 11.13, 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: 166, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        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.04, total records: 79260 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 824 
    Data pages: 824, average fill: 66% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 822 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 822 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34235, depth: 2, leaf buckets: 101, nodes: 79260 
    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: 3240, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.56, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 148.47, total records: 168526 
    Average version length: 151.83, total versions: 2958, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 9, data page slots: 4776 
    Data pages: 4232, average fill: 82% 
    Primary pages: 4231, secondary pages: 1, swept pages: 37 
    Empty pages: 81, full pages: 4127 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 10 
    80 - 99% = 4125 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 145.32, total records: 153242 
    Average version length: 152.64, total versions: 6025, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 6, data page slots: 5664 
    Data pages: 3832, average fill: 83% 
    Primary pages: 3830, secondary pages: 2, swept pages: 3 
    Empty pages: 60, full pages: 3750 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 3751 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.07, total records: 141402 
    Average version length: 150.96, total versions: 3087, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 9, data page slots: 5000 
    Data pages: 3544, average fill: 82% 
    Primary pages: 3542, secondary pages: 2, swept pages: 13 
    Empty pages: 61, full pages: 3465 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3466 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 144.31, total records: 165674 
    Average version length: 153.00, total versions: 8381, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 9, data page slots: 4600 
    Data pages: 4144, average fill: 83% 
    Primary pages: 4142, secondary pages: 2, swept pages: 2 
    Empty pages: 52, full pages: 4067 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 4067 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.25, total records: 159343 
    Average version length: 153.15, total versions: 10098, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.92 
    Pointer pages: 6, data page slots: 4136 
    Data pages: 3968, average fill: 84% 
    Primary pages: 3965, secondary pages: 3, swept pages: 5 
    Empty pages: 41, full pages: 3908 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 8 
    40 - 59% = 0 
    60 - 79% = 10 
    80 - 99% = 3908 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 144.81, total records: 160173 
    Average version length: 152.61, total versions: 7425, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 7, data page slots: 4624 
    Data pages: 4040, average fill: 82% 
    Primary pages: 4038, secondary pages: 2, swept pages: 3 
    Empty pages: 81, full pages: 3918 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 18 
    40 - 59% = 12 
    60 - 79% = 9 
    80 - 99% = 3918 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 145.94, total records: 171513 
    Average version length: 152.13, total versions: 6698, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 7, data page slots: 5032 
    Data pages: 4280, average fill: 83% 
    Primary pages: 4277, secondary pages: 3, swept pages: 5 
    Empty pages: 46, full pages: 4209 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 4209 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 139.01, total records: 150557 
    Average version length: 153.84, total versions: 12687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.20 
    Pointer pages: 5, data page slots: 4992 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3766, secondary pages: 2, swept pages: 10 
    Empty pages: 53, full pages: 3683 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 15 
    80 - 99% = 3681 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 145.77, total records: 156177 
    Average version length: 151.79, total versions: 6013, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 6, data page slots: 4720 
    Data pages: 3952, average fill: 82% 
    Primary pages: 3950, secondary pages: 2, swept pages: 6 
    Empty pages: 97, full pages: 3824 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 14 
    80 - 99% = 3823 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 150.07, total records: 154773 
    Average version length: 145.18, total versions: 1274, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 6, data page slots: 4160 
    Data pages: 3840, average fill: 83% 
    Primary pages: 3838, secondary pages: 2, swept pages: 8 
    Empty pages: 29, full pages: 3799 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3799 
 
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.53, total records: 2062042 
    Average version length: 52.80, total versions: 10347, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25688 
    Data pages: 25688, average fill: 69% 
    Primary pages: 25674, secondary pages: 14, swept pages: 13119 
    Empty pages: 257, full pages: 21083 
    Fill distribution: 
     0 - 19% = 463 
    20 - 39% = 371 
    40 - 59% = 1087 
    60 - 79% = 23695 
    80 - 99% = 72 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2530, nodes: 2062042 
    Average node length: 5.44, total dup: 1923157, max dup: 1514 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179962, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 315 
        40 - 59% = 1586 
        60 - 79% = 314 
        80 - 99% = 311 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2753, nodes: 2062042 
    Average node length: 5.70, total dup: 1849987, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370042, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2495 
        60 - 79% = 225 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2115, nodes: 2062042 
    Average node length: 4.96, total dup: 2061942, max dup: 27270 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 177896, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 210 
        40 - 59% = 1121 
        60 - 79% = 388 
        80 - 99% = 396 
 
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: 47.92, total records: 126248 
    Average version length: 69.17, total versions: 44677, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.63 
    Pointer pages: 3, data page slots: 4224 
    Data pages: 3176, average fill: 48% 
    Primary pages: 3176, secondary pages: 0, swept pages: 392 
    Empty pages: 365, full pages: 730 
    Fill distribution: 
     0 - 19% = 564 
    20 - 39% = 537 
    40 - 59% = 907 
    60 - 79% = 832 
    80 - 99% = 336 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 334720, depth: 3, leaf buckets: 233, nodes: 126248 
    Average node length: 6.59, total dup: 109643, max dup: 14 
    Average key length: 4.00, compression ratio: 10.51 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 22423, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 94 
        40 - 59% = 106 
        60 - 79% = 33 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.17, total records: 6744919 
    Average version length: 68.78, total versions: 201440, 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: 66, data page slots: 106160 
    Data pages: 106160, average fill: 68% 
    Primary pages: 106159, secondary pages: 1, swept pages: 53872 
    Empty pages: 62, full pages: 37473 
    Fill distribution: 
     0 - 19% = 489 
    20 - 39% = 1743 
    40 - 59% = 12095 
    60 - 79% = 91577 
    80 - 99% = 256 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10710, nodes: 6744919 
    Average node length: 6.51, total dup: 5833643, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1574688, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2048 
        40 - 59% = 6254 
        60 - 79% = 2094 
        80 - 99% = 307 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8425, nodes: 6744919 
    Average node length: 5.40, total dup: 6471047, max dup: 133 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1396542, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1471 
        40 - 59% = 4634 
        60 - 79% = 1481 
        80 - 99% = 828 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8459, nodes: 6744919 
    Average node length: 5.40, total dup: 6471047, max dup: 133 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1398936, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1470 
        40 - 59% = 4686 
        60 - 79% = 1499 
        80 - 99% = 798 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.10, total records: 11823124 
    Average version length: 68.74, total versions: 167417, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 108, data page slots: 174688 
    Data pages: 174688, average fill: 72% 
    Primary pages: 174687, secondary pages: 1, swept pages: 107325 
    Empty pages: 4, full pages: 116297 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 662 
    40 - 59% = 8104 
    60 - 79% = 165149 
    80 - 99% = 735 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18490, nodes: 11822388 
    Average node length: 6.61, total dup: 10306927, max dup: 75 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2422890, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 18 
        20 - 39% = 2655 
        40 - 59% = 11117 
        60 - 79% = 4117 
        80 - 99% = 583 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 58.05, total records: 1210267 
    Average version length: 69.04, total versions: 178236, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.17 
    Pointer pages: 27, data page slots: 42584 
    Data pages: 26303, average fill: 50% 
    Primary pages: 26200, secondary pages: 103, swept pages: 12615 
    Empty pages: 4077, full pages: 12063 
    Fill distribution: 
     0 - 19% = 6333 
    20 - 39% = 2948 
    40 - 59% = 2959 
    60 - 79% = 11853 
    80 - 99% = 2210 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1757, nodes: 1164938 
    Average node length: 5.54, total dup: 1117584, max dup: 49 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 80608, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 627 
        40 - 59% = 852 
        60 - 79% = 248 
        80 - 99% = 17 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 48.10, total records: 901247 
    Average version length: 69.01, total versions: 92020, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.62 
    Pointer pages: 21, data page slots: 32752 
    Data pages: 26376, average fill: 33% 
    Primary pages: 26375, secondary pages: 1, swept pages: 10302 
    Empty pages: 4385, full pages: 3054 
    Fill distribution: 
     0 - 19% = 8688 
    20 - 39% = 6542 
    40 - 59% = 7412 
    60 - 79% = 3659 
    80 - 99% = 75 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1149, nodes: 679374 
    Average node length: 5.85, total dup: 630680, max dup: 68 
    Average key length: 2.93, compression ratio: 14.33 
    Average prefix length: 41.14, average data length: 0.86 
    Clustering factor: 86745, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 509 
        40 - 59% = 534 
        60 - 79% = 105 
        80 - 99% = 1 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 68.10, total records: 9043223 
    Average version length: 68.97, total versions: 118871, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 89, data page slots: 143696 
    Data pages: 143680, average fill: 67% 
    Primary pages: 143660, secondary pages: 20, swept pages: 84538 
    Empty pages: 312, full pages: 65392 
    Fill distribution: 
     0 - 19% = 1165 
    20 - 39% = 5995 
    40 - 59% = 19250 
    60 - 79% = 116843 
    80 - 99% = 427 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13467, nodes: 9041402 
    Average node length: 6.68, total dup: 7500490, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2080812, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1316 
        40 - 59% = 7245 
        60 - 79% = 4399 
        80 - 99% = 506 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21143285 
    Average version length: 82.89, total versions: 4199, 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: 319816 
    Data pages: 319816, average fill: 81% 
    Primary pages: 319811, secondary pages: 5, swept pages: 14074 
    Empty pages: 47, full pages: 318656 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 47 
    40 - 59% = 149 
    60 - 79% = 49564 
    80 - 99% = 269976 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19383, nodes: 21143285 
    Average node length: 5.72, total dup: 20662358, max dup: 153 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281946, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8127 
        60 - 79% = 576 
        80 - 99% = 10673 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17152, nodes: 21143285 
    Average node length: 6.31, total dup: 18580466, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916129, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 751 
        60 - 79% = 279 
        80 - 99% = 16117 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21177, nodes: 21143285 
    Average node length: 6.35, total dup: 18499425, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3576056, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8438 
        60 - 79% = 604 
        80 - 99% = 12131 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16108, nodes: 21143285 
    Average node length: 5.56, total dup: 21143185, max dup: 231103 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945112, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2931 
        60 - 79% = 359 
        80 - 99% = 12809 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.82, total records: 9450048 
    Average version length: 82.60, total versions: 76761, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 105, data page slots: 169784 
    Data pages: 169744, average fill: 68% 
    Primary pages: 169713, secondary pages: 31, swept pages: 109355 
    Empty pages: 400, full pages: 92938 
    Fill distribution: 
     0 - 19% = 1605 
    20 - 39% = 8441 
    40 - 59% = 25105 
    60 - 79% = 120503 
    80 - 99% = 14090 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11352, nodes: 9450048 
    Average node length: 5.36, total dup: 9143722, max dup: 161 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2154730, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 74 
        40 - 59% = 8941 
        60 - 79% = 2270 
        80 - 99% = 64 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13214, nodes: 9450048 
    Average node length: 6.22, total dup: 7835272, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1520736, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 3779 
        40 - 59% = 4334 
        60 - 79% = 2633 
        80 - 99% = 2325 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12669, nodes: 9450048 
    Average node length: 5.98, total dup: 8191444, max dup: 29 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2336404, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 96 
        40 - 59% = 10016 
        60 - 79% = 2470 
        80 - 99% = 86 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9955, nodes: 9450048 
    Average node length: 5.12, total dup: 9449948, max dup: 153895 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1547278, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1377 
        40 - 59% = 4833 
        60 - 79% = 1715 
        80 - 99% = 1986 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.83, total records: 11135438 
    Average version length: 82.51, total versions: 72512, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 118, data page slots: 192344 
    Data pages: 190632, average fill: 71% 
    Primary pages: 190521, secondary pages: 111, swept pages: 73474 
    Empty pages: 3295, full pages: 144824 
    Fill distribution: 
     0 - 19% = 5385 
    20 - 39% = 7426 
    40 - 59% = 17062 
    60 - 79% = 102034 
    80 - 99% = 58725 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13135, nodes: 11135438 
    Average node length: 5.29, total dup: 11026276, max dup: 622 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2319425, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 146 
        40 - 59% = 9688 
        60 - 79% = 3202 
        80 - 99% = 99 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10302, nodes: 11135438 
    Average node length: 5.49, total dup: 10648237, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 701853, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 187 
        20 - 39% = 864 
        40 - 59% = 2536 
        60 - 79% = 1748 
        80 - 99% = 4967 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15018, nodes: 11135438 
    Average node length: 6.02, total dup: 9712920, max dup: 64 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2335782, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 209 
        40 - 59% = 11238 
        60 - 79% = 3427 
        80 - 99% = 139 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10589, nodes: 11135438 
    Average node length: 5.21, total dup: 11135338, max dup: 199213 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.44, average data length: 0.00 
    Clustering factor: 690802, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 843 
        40 - 59% = 4632 
        60 - 79% = 1467 
        80 - 99% = 3539 
 
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: 82.15, total records: 9565514 
    Average version length: 82.87, total versions: 76644, 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: 107, data page slots: 174208 
    Data pages: 174184, average fill: 68% 
    Primary pages: 174148, secondary pages: 36, swept pages: 113550 
    Empty pages: 458, full pages: 91420 
    Fill distribution: 
     0 - 19% = 1732 
    20 - 39% = 9720 
    40 - 59% = 28480 
    60 - 79% = 120121 
    80 - 99% = 14131 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11675, nodes: 9565514 
    Average node length: 5.17, total dup: 9536913, max dup: 1461 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1958999, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1563 
        40 - 59% = 7794 
        60 - 79% = 1720 
        80 - 99% = 564 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13350, nodes: 9565514 
    Average node length: 6.24, total dup: 7930644, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1478578, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 3797 
        40 - 59% = 4360 
        60 - 79% = 2549 
        80 - 99% = 2484 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12251, nodes: 9565514 
    Average node length: 5.43, total dup: 9133231, max dup: 87 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2087555, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1468 
        40 - 59% = 8598 
        60 - 79% = 1572 
        80 - 99% = 581 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10122, nodes: 9565514 
    Average node length: 5.14, total dup: 9565414, max dup: 156137 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1561728, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1340 
        40 - 59% = 5128 
        60 - 79% = 1579 
        80 - 99% = 2030 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.95, total records: 568433 
    Average version length: 68.79, total versions: 2094, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 74% 
    Primary pages: 8016, secondary pages: 0, swept pages: 4236 
    Empty pages: 0, full pages: 6598 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 16 
    40 - 59% = 158 
    60 - 79% = 7807 
    80 - 99% = 31 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42617, depth: 3, leaf buckets: 735, nodes: 568433 
    Average node length: 5.94, total dup: 484146, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100085, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 32 
        40 - 59% = 532 
        60 - 79% = 81 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34529, depth: 3, leaf buckets: 751, nodes: 568433 
    Average node length: 6.15, total dup: 466294, max dup: 17 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100142, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 36 
        40 - 59% = 523 
        60 - 79% = 85 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 579, nodes: 568433 
    Average node length: 4.86, total dup: 568333, max dup: 9782 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88954, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 45 
        40 - 59% = 344 
        60 - 79% = 84 
        80 - 99% = 105 
 
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 04:10:53 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7721945 21555 1 0.0000 0.0000
DOC_LIST 2225509 11252 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1858 5 400.0000 0.0000
INVNT_TURNOVER_LOG 65990 62418 1 0.0000 0.0000
MONEY_SALDO 49 123 4 200.0000 0.0000
MONEY_TURNOVER_LOG 1028 980 1 0.0000 0.0000
PDISTR 807151 19541 3 0.0000 0.0000
PERF_SPLIT_0 168526 2958 1 0.0000 0.0000
PERF_SPLIT_1 153242 6025 1 0.0000 0.0000
PERF_SPLIT_2 141402 3087 1 0.0000 0.0000
PERF_SPLIT_3 165674 8381 1 0.0000 0.0000
PERF_SPLIT_4 159343 10098 1 0.0000 0.0000
PERF_SPLIT_5 160173 7425 1 0.0000 0.0000
PERF_SPLIT_6 171513 6698 1 0.0000 0.0000
PERF_SPLIT_7 150557 12687 1 0.0000 0.0000
PERF_SPLIT_8 156177 6013 1 0.0000 0.0000
PERF_SPLIT_9 154773 1274 1 0.0000 0.0000
PSTORNED 2062042 10347 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 126248 44677 1 0.0000 0.0000
XQD_1000_3300 6744919 201440 1 0.0000 0.0000
XQD_1200_2000 11823124 167417 1 0.0000 0.0000
XQD_2000_3300 1210267 178236 1 0.0000 0.0000
XQD_2100_3300 901247 92020 1 0.0000 0.0000
XQD_3300_3400 9043223 118871 1 0.0000 0.0000
XQS_1000_1200 21143285 4199 1 0.0000 0.0000
XQS_1000_3300 9450048 76761 1 0.0000 0.0000
XQS_1200_2000 11135438 72512 1 0.0000 0.0000
XQS_2100_3300 9565514 76644 1 0.0000 0.0000
XQS_3300_3400 568433 2094 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 ---
:49: 
:50: mscs-test-161.budzdorov.ru    Mon Mar 18 04:08:15 2024
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:52: 
--- end of diff output ---

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

18.03.24 04:11:05. 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 04:11:08 No severe PSQL-related problems occured
18.03.24 04:11:09. End of report.