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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-24 22:09:42
DTS_END                         2024-03-24 22:09:42.1980
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58998
TRN_ID                          173840
ATT_ID                          601
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: 9313.92 16650 931392
customer order: creation 175.74 401 17574
customer order: refuse 14.62 375 1462
order to supplier: creation 47.24 1286 4724
order to supplier: removal 3.82 83859 382
invoice (draft): creation 48.83 3019 4883
invoice (draft): removal 51.57 754 5157
invoice accept: apply 42.83 19781 4283
invoice accept: cancel 46.23 766 4623
customer reserve: creation 4100.68 191 410068
customer reserve: removal 4473.40 56 447340
realization accept: apply 86.16 192 8616
realization accept: cancel 88.72 118 8872
payment from customer: creation 61.52 115 6152
payment from customer: removal 5.91 101 591
payment to supplier: creation 50.99 135 5099
payment to supplier: removal 3.13 71 313
service: total inventory turnovers 5.03 946 503
service: total monetary turnovers 6.60 20 660
service: aggregate perf. data 0.87 19563 87
service: refresh index statistics 0.03 201257 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-03-2024 22:11:42 to 24-03-2024 22:11:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3296
TEST_TIME 2 3645
TEST_TIME 3 4237
TEST_TIME 4 4412
TEST_TIME 5 4551
TEST_TIME 6 4373
TEST_TIME 7 5138
TEST_TIME 8 4880
TEST_TIME 9 4803
TEST_TIME 10 5331
TEST_TIME 11 5577
TEST_TIME 12 6243
TEST_TIME 13 6167
TEST_TIME 14 6559
TEST_TIME 15 7043
TEST_TIME 16 6951
TEST_TIME 17 6924
TEST_TIME 18 7005
TEST_TIME 19 7358
TEST_TIME 20 7541
TEST_TIME 21 7688
TEST_TIME 22 7795
TEST_TIME 23 8075
TEST_TIME 24 8306
TEST_TIME 25 9295
TEST_TIME 26 9149
TEST_TIME 27 9162
TEST_TIME 28 9020
TEST_TIME 29 8872
TEST_TIME 30 8856
TEST_TIME 31 8719
TEST_TIME 32 8703
TEST_TIME 33 8679
TEST_TIME 34 8677
TEST_TIME 35 8777
TEST_TIME 36 8822
TEST_TIME 37 8801
TEST_TIME 38 8813
TEST_TIME 39 8749
TEST_TIME 40 8599
TEST_TIME 41 8657
TEST_TIME 42 8763
TEST_TIME 43 8807
TEST_TIME 44 8847
TEST_TIME 45 8927
TEST_TIME 46 8905
TEST_TIME 47 8937
TEST_TIME 48 8931
TEST_TIME 49 9023
TEST_TIME 50 9153
TEST_TIME 51 9218
TEST_TIME 52 9298
TEST_TIME 53 9353
TEST_TIME 54 9332
TEST_TIME 55 9438
TEST_TIME 56 9379
TEST_TIME 57 9267
TEST_TIME 58 9173
TEST_TIME 59 9122
TEST_TIME 60 9206
TEST_TIME 61 9147
TEST_TIME 62 9114
TEST_TIME 63 9067
TEST_TIME 64 9027
TEST_TIME 65 9046
TEST_TIME 66 9081
TEST_TIME 67 9114
TEST_TIME 68 9121
TEST_TIME 69 9122
TEST_TIME 70 9089
TEST_TIME 71 9226
TEST_TIME 72 9227
TEST_TIME 73 9224
TEST_TIME 74 9294
TEST_TIME 75 9364
TEST_TIME 76 9319
TEST_TIME 77 9343
TEST_TIME 78 9380
TEST_TIME 79 9298
TEST_TIME 80 9226
TEST_TIME 81 9223
TEST_TIME 82 9284
TEST_TIME 83 9253
TEST_TIME 84 9174
TEST_TIME 85 9120
TEST_TIME 86 9171
TEST_TIME 87 9155
TEST_TIME 88 9173
TEST_TIME 89 9200
TEST_TIME 90 9214
TEST_TIME 91 9263
TEST_TIME 92 9243
TEST_TIME 93 9320
TEST_TIME 94 9296
TEST_TIME 95 9373
TEST_TIME 96 9393
TEST_TIME 97 9409
TEST_TIME 98 9451
TEST_TIME 99 9406
TEST_TIME 100 9332

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-03-2024 22:11:46 to 24-03-2024 22:11:49.

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 1306387 1306387 0 0.00 0 12194 7 0 0
doc_list_biud 1306383 1306383 0 0.00 0 26496 25 0 0
sp_add_invoice_to_stock 4370 4283 87 1.99 41 176265 19781 0 87
sp_cancel_adding_invoice 4623 4623 0 0.00 4 78634 766 0 0
sp_cancel_client_order 1462 1462 0 0.00 4 19736 375 0 0
sp_cancel_customer_reserve 447340 447340 0 0.00 0 26500 56 0 0
sp_cancel_pay_from_customer 591 591 0 0.00 2 6244 101 0 0
sp_cancel_pay_to_supplier 313 313 0 0.00 3 5665 71 0 0
sp_cancel_supplier_invoice 5161 5157 4 0.07 1 12554 754 0 4
sp_cancel_supplier_order 382 382 0 0.00 7 769245 83860 0 0
sp_cancel_write_off 8872 8872 0 0.00 1 13482 118 0 0
sp_client_order 17574 17574 0 0.00 3 22483 401 0 0
sp_customer_reserve 410068 410068 0 0.00 0 50782 192 0 0
sp_fill_shopping_cart 27178 27178 0 0.00 1 20552 34 0 0
sp_fill_shopping_cart_clo_res 410056 410056 0 0.00 0 25757 14 0 0
sp_get_clo_for_invoice 4265 4265 0 0.00 0 27030 278 0 0
sp_kill_cost_storno 14399 14399 0 0.00 0 5011 53 0 0
sp_kill_qstorno_ret_qs2qd 909091 909091 0 0.00 0 26494 31 0 0
sp_kill_qty_storno 480713 480713 0 0.00 0 26496 67 0 0
sp_lock_selected_doc 17781 17781 0 0.00 0 9234 5 0 0
sp_make_cost_storno 24130 24130 0 0.00 0 12192 56 0 0
sp_multiply_rows_for_pdistr 24127 24127 0 0.00 0 10126 25 0 0
sp_multiply_rows_for_qdistr 17574 17574 0 0.00 0 13836 181 0 0
sp_pay_from_customer 6152 6152 0 0.00 4 10139 115 0 0
sp_pay_to_supplier 5099 5099 0 0.00 5 11710 135 0 0
sp_payment_common 11250 11250 0 0.00 1 7838 25 0 0
sp_qd_handle_on_cancel_clo 1462 1462 0 0.00 0 19731 353 0 0
sp_qd_handle_on_invoice_upd_sts 8886 8886 0 0.00 0 16611 310 0 0
sp_qd_handle_on_reserve_upd_sts 8614 8614 0 0.00 0 19448 70 0 0
sp_reserve_write_off 8616 8616 0 0.00 6 19477 193 0 0
sp_supplier_invoice 4883 4883 0 0.00 5 73392 3019 0 0
sp_supplier_order 4724 4724 0 0.00 4 26427 1286 0 0
srv_aggregate_perf_data 87 87 0 0.00 1709 267411 19563 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1623 125024 42832 0 0
srv_find_qd_qs_mism 887474 887474 0 0.00 0 11008 7 0 0
srv_make_invnt_saldo 503 503 0 0.00 36 52857 946 0 0
srv_make_money_saldo 660 660 0 0.00 1 750 21 0 0
srv_recalc_idx_stat 3 3 0 0.00 95991 345352 201258 0 0
t$perf-abend:sp_add_invoice_to_stock 87 87 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4284 4284 0 0.00 0 12731 164 0 0
t$perf-norm:sp_cancel_adding_invoice 355 355 0 0.00 0 1968 92 0 0
t$perf-norm:sp_cancel_client_order 1462 1462 0 0.00 0 1540 11 0 0
t$perf-norm:sp_cancel_customer_reserve 572 572 0 0.00 0 1694 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 591 591 0 0.00 0 3159 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 313 313 0 0.00 0 9807 37 0 0
t$perf-norm:sp_cancel_supplier_invoice 361 361 0 0.00 0 1123 16 0 0
t$perf-norm:sp_cancel_supplier_order 382 382 0 0.00 0 23846 1478 0 0
t$perf-norm:sp_cancel_write_off 869 869 0 0.00 0 1203 6 0 0
t$perf-norm:sp_client_order 17574 17574 0 0.00 0 8703 18 0 0
t$perf-norm:sp_customer_reserve 837 837 0 0.00 0 2658 7 0 0
t$perf-norm:sp_pay_from_customer 6152 6152 0 0.00 0 7786 10 0 0
t$perf-norm:sp_pay_to_supplier 5099 5099 0 0.00 0 7800 11 0 0
t$perf-norm:sp_reserve_write_off 8616 8616 0 0.00 0 14331 12 0 0
t$perf-norm:sp_supplier_invoice 4883 4883 0 0.00 0 2621 16 0 0
t$perf-norm:sp_supplier_order 4724 4724 0 0.00 0 9692 16 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 704 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 442 8 0 0
t$perf-norm:srv_make_invnt_saldo 503 503 0 0.00 0 5281 40 0 0
t$perf-norm:srv_make_money_saldo 660 660 0 0.00 0 2530 14 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 5 2 0 0
v_add_invoice_to_stock 8698 8524 174 2.00 0 7504 19 0 174
v_all_customers 32812 32812 0 0.00 0 18 0 0 0
v_all_suppliers 27192 27192 0 0.00 0 20 1 0 0
v_all_wares 35148 35148 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 710 710 0 0.00 0 358 6 0 0
v_cancel_client_order 2924 2924 0 0.00 0 4135 7 0 0
v_cancel_customer_prepayment 1182 1182 0 0.00 0 6238 18 0 0
v_cancel_customer_reserve 1144 1144 0 0.00 0 683 4 0 0
v_cancel_payment_to_supplier 626 626 0 0.00 0 5654 12 0 0
v_cancel_supplier_invoice 730 722 8 1.09 0 3394 23 0 8
v_cancel_supplier_order 764 764 0 0.00 0 1693 6 0 0
v_cancel_write_off 1738 1738 0 0.00 0 5124 16 0 0
v_max_id_clo_ord 4724 4724 0 0.00 0 612 1 0 0
v_max_id_clo_res 837 837 0 0.00 0 2742 18 0 0
v_max_id_ord_sup 4880 4880 0 0.00 0 7249 6 0 0
v_max_non_paid_invoice 1107 1107 0 0.00 0 951 3 0 0
v_max_non_paid_realizn 2932 2932 0 0.00 0 4740 8 0 0
v_min_id_clo_ord 4724 4724 0 0.00 0 5437 9 0 0
v_min_id_clo_res 837 837 0 0.00 0 1687 5 0 0
v_min_id_ord_sup 4880 4880 0 0.00 0 4171 6 0 0
v_min_non_paid_invoice 5099 5099 0 0.00 0 7297 15 0 0
v_min_non_paid_realizn 6151 6151 0 0.00 0 7296 19 0 0
v_our_firm 8774 8774 0 0.00 0 16 1 0 0
v_reserve_write_off 17228 17228 0 0.00 0 8201 10 0 0
x_lock_depdocs_on_canc_invoice 9419 9419 0 0.00 0 14725 122 0 0
x_lock_depdocs_on_canc_sup_ord 382 382 0 0.00 0 5091 242 0 0
x_make_qstorno_1000_1200 4724 4724 0 0.00 2 26358 1205 0 0
x_make_qstorno_1200_2000 4883 4883 0 0.00 2 73384 2903 0 0
x_make_qstorno_2100_3300 410068 410068 0 0.00 0 50780 175 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-03-2024 22:11:50 to 24-03-2024 22:11:54.

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
20:09:45 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:45 14812 8192000000 9878966800 10180689920 965561680 10.543 100 92 184 0 995154304 5267232 24325392
20:12:08 11220 8192000000 9926869136 10242863104 1009166624 10.967 100 90 180 0 1040179888 7937440 23075824
20:13:25 11016 8192000000 9961620544 10290651136 1045304608 11.316 100 87 174 0 1076874512 9704784 21865120
20:14:40 19970 8192000000 10037037728 10377080832 1111101280 11.943 100 93 184 0 1144524320 11519056 21903984
20:16:05 6537 8192000000 10060676768 10413031424 1145106000 12.264 100 84 168 0 1178669664 13096976 20466688
20:17:15 5733 8192000000 10092329984 10455207936 1181861296 12.608 100 77 154 0 1211220368 12167728 17191344
20:18:23 2619 8192000000 10134521200 10503901184 1219596880 12.958 100 87 174 0 1253045696 14328976 19119840
20:19:28 2865 8192000000 10164128704 10542874624 1261559232 13.344 100 74 148 0 1288954528 11022912 16372384
20:20:33 1670 8192000000 10195532400 10579197952 1282772992 13.538 100 81 162 0 1313464672 12602528 18089152
20:21:38 24103 8192000000 10196924848 10593841152 1296110464 13.660 100 55 110 1 1316855616 8595104 12150048
20:23:04 3176 8192000000 10204388128 10606284800 1307896704 13.767 100 44 87 0 1326322544 8543952 9881888
20:24:08 43867 8192000000 10214910352 10624622592 1319580912 13.873 100 43 86 1 1335300336 5283008 10436416
20:25:53 9946 8192000000 10216275136 10632847360 1324593680 13.918 100 20 40 1 1334192912 5248832 4350400
20:27:04 8429 8192000000 10214729264 10637381632 1331228864 13.978 100 16 32 1 1340229792 5700800 3300128
20:28:19 45797 8192000000 10228668304 10646061056 1331873152 13.984 100 37 67 2 1349614976 9457952 8283872
20:30:16 10527 8192000000 10234012272 10645778432 1334537584 14.008 100 48 96 0 1352866432 7632864 10695984
20:31:33 29877 8192000000 10252918688 10668912640 1340717488 14.064 99 42 84 1 1362937408 12151904 10068016
20:33:16 17862 8192000000 10272702352 10692403200 1367998112 14.309 100 41 83 0 1391586736 13584416 10004208
20:34:36 54212 8192000000 10276336832 10695176192 1367382576 14.304 100 46 93 0 1395775712 16496592 11896544
20:37:16 20957 8192000000 10275182976 10693222400 1363401040 14.268 100 52 104 1 1392823552 17567616 11854896
20:38:46 17077 8192000000 10242055808 10654343168 1286472240 13.572 95 38 76 0 1315138832 19056416 9610176
20:40:07 8555 8192000000 10232036400 10635493376 1308366912 13.771 100 47 94 0 1340741248 20508096 11866240
20:41:20 7361 8192000000 10212503664 10615525376 1269444080 13.417 97 51 103 0 1308514592 26310272 12760240
20:42:38 11366 8192000000 10225029984 10624548864 1272996224 13.449 98 49 96 0 1308350528 23321136 12033168
20:43:55 1620 8192000000 10269763472 10670227456 1323568512 13.909 99 69 138 1 1365695248 25886000 16240736
20:45:00 8109 8192000000 10278472928 10684628992 1351784528 14.164 100 54 108 0 1384826496 20085040 12956928
20:46:16 2035 8192000000 10301043760 10700759040 1362803344 14.263 100 71 140 1 1406407696 26673440 16930912
20:47:24 5425 8192000000 10305905040 10708705280 1364901472 14.281 100 70 139 1 1414694704 32090528 17702704
20:48:34 7292 8192000000 10296475232 10701049856 1359034784 14.229 100 65 130 2 1406593856 30702880 16856192
20:49:46 3399 8192000000 10306598992 10723196928 1375563360 14.377 100 42 82 0 1415004496 28922896 10518240
20:50:52 20368 8192000000 10304460832 10729897984 1375500896 14.376 100 27 54 0 1412340672 29426096 7413680
20:52:36 30779 8192000000 10291740768 10732593152 1370453088 14.331 100 18 36 0 1413488864 37613392 5422384
20:54:12 39806 8192000000 10273867808 10714796032 1369985280 14.327 100 17 34 0 1404019440 29640976 4393184
20:55:53 9698 8192000000 10300800016 10730483712 1377957888 14.398 100 39 77 1 1400769104 14449296 8361920
20:57:10 34696 8192000000 10294465072 10736533504 1382085968 14.435 100 30 59 0 1402569248 14270864 6212416
20:58:55 67882 8192000000 10286370272 10738909184 1389203600 14.499 100 21 42 0 1402268704 8143888 4921216
21:01:07 32172 8192000000 10318492272 10748751872 1381450608 14.430 99 35 70 1 1396631440 7286720 7894112
21:02:41 18491 8192000000 10313194400 10753347584 1403155040 14.623 100 44 86 1 1422762496 8946352 10661104
21:04:09 72190 8192000000 10308755920 10767601664 1413843360 14.718 100 9 18 0 1425351376 9349952 2158064
21:06:22 22921 8192000000 10314751696 10779394048 1414107616 14.720 100 21 42 1 1430191152 11331136 4752400
21:07:48 39797 8192000000 10315843984 10773737472 1414762112 14.726 100 19 36 0 1430965648 11604992 4598544
21:09:31 74392 8192000000 10314016240 10768039936 1403652704 14.628 99 22 44 0 1421419872 12613824 5153344
21:11:47 43033 8192000000 10316692880 10769096704 1407398176 14.661 99 28 56 1 1422316288 8322336 6595776
21:13:41 91455 8192000000 10323122240 10777403392 1383091808 14.444 97 15 30 1 1396217072 10045424 3079840
21:16:13 57807 8192000000 10324913216 10767273984 1383467904 14.448 98 29 58 1 1403137632 12781216 6888512
21:18:16 68897 8192000000 10302887856 10760953856 1362006256 14.255 97 26 52 1 1385757408 17833120 5918032
21:20:27 95009 8192000000 10308783856 10776354816 1343033632 14.085 95 13 26 0 1363271808 17496080 2742096
21:23:03 117127 8192000000 10277681680 10726199296 1256783360 13.301 90 10 20 0 1274447888 15511456 2153072
21:26:02 125024 8192000000 10255413536 10700124160 1313097280 13.814 96 22 44 0 1325149616 7170976 4881360
21:29:09 25092 8192000000 10240635056 10687680512 1303716816 13.729 96 20 40 1 1315853264 7952816 4183632
21:30:37 40798 8192000000 10240330384 10690809856 1339130080 14.050 99 8 16 0 1349384320 8528112 1726128
21:32:18 66757 8192000000 10240503472 10687934464 1324163392 13.914 97 12 24 0 1335415024 8326832 2924800
21:34:25 45696 8192000000 10232065392 10669731840 1261753328 13.346 94 22 43 0 1279401712 12958832 4689552
21:36:13 72982 8192000000 10230627632 10669199360 1295417776 13.654 97 23 43 0 1311539856 11077344 5044736
21:38:34 30171 8192000000 10262681872 10694270976 1347386208 14.124 100 35 71 0 1363812864 9085552 7341104
21:40:11 60741 8192000000 10286143888 10728828928 1356733136 14.208 99 29 58 0 1387281840 24100080 6448624
21:42:14 47312 8192000000 10281168624 10720165888 1344057536 14.094 98 19 39 0 1362251168 13986288 4207344
21:44:05 31410 8192000000 10301421728 10739220480 1384442400 14.456 100 39 77 0 1404562672 11206384 8913888
21:46:00 15714 8192000000 10321567696 10759430144 1399242000 14.588 100 47 93 0 1421633616 12252336 10139280
21:47:17 87389 8192000000 10303462032 10760200192 1383067472 14.444 99 37 75 0 1407057936 15711584 8278880
21:49:53 29159 8192000000 10302062624 10748760064 1392591872 14.529 100 31 61 0 1408115216 8812800 6710544
21:51:38 44282 8192000000 10288334960 10759155712 1387619968 14.485 99 16 32 1 1402336032 11278080 3437984
21:53:23 48265 8192000000 10298022512 10748530688 1383091024 14.444 99 14 28 0 1396959072 10982112 2885936
21:55:15 77088 8192000000 10316047360 10763776000 1390578656 14.511 99 13 25 0 1405130352 11257280 3294416
21:57:36 59809 8192000000 10331292448 10786201600 1400699712 14.601 99 23 46 0 1423043248 16830496 5513040
21:59:40 86024 8192000000 10301636784 10753298432 1359367872 14.232 97 17 35 0 1378625872 15966160 3291840
22:02:33 73038 8192000000 10313054688 10759872512 1358937872 14.228 97 10 19 0 1370618048 9847648 1832528
22:04:51 39304 8192000000 10308138704 10747273216 1363350768 14.267 98 32 64 0 1383601024 13139888 7110368
22:07:14 74093 8192000000 10288689680 10741866496 1371366368 14.339 99 12 24 0 1385819360 11903600 2549392
22:09:37 33348 8192000000 9505481376 9826873344 650369232 7.355 48 6 12 0 655397104 3929088 1098784

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 24-03-2024 22:11:56 to 24-03-2024 22:12:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 87 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-03-2024 22:12:11 to 24-03-2024 22:12:13.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Mar 24 22:12:14 2024 
 
Database header page information: 
    Flags            0 
    Generation        90785 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    174062 
    Oldest active        174063 
    Oldest snapshot        174063 
    Next transaction    174064 
    Sequence number        0 
    Next attachment ID    703 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.79, total records: 7663208 
    Average version length: 48.16, total versions: 16272, 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: 53, data page slots: 86224 
    Data pages: 86224, average fill: 71% 
    Primary pages: 86224, secondary pages: 0, swept pages: 47036 
    Empty pages: 6, full pages: 46744 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 101 
    40 - 59% = 1807 
    60 - 79% = 84272 
    80 - 99% = 4 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23205, nodes: 7663208 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1702366, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 302 
        20 - 39% = 2320 
        40 - 59% = 3775 
        60 - 79% = 2542 
        80 - 99% = 14266 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13500, nodes: 7663208 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1524006, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1934 
        40 - 59% = 1736 
        60 - 79% = 1208 
        80 - 99% = 8621 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8330, nodes: 7663208 
    Average node length: 6.60, total dup: 5754956, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1517175, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 1194 
        40 - 59% = 1209 
        60 - 79% = 1007 
        80 - 99% = 4791 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 57.13, total records: 2202717 
    Average version length: 34.90, total versions: 21943, max versions: 2 
    Average fragment length: 6.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28000 
    Data pages: 28000, average fill: 72% 
    Primary pages: 27995, secondary pages: 5, swept pages: 20626 
    Empty pages: 9, full pages: 15737 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 64 
    40 - 59% = 1260 
    60 - 79% = 26541 
    80 - 99% = 117 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4544, nodes: 2202717 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 684936, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1044 
        40 - 59% = 765 
        60 - 79% = 749 
        80 - 99% = 1985 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2511, nodes: 2203872 
    Average node length: 4.97, total dup: 2202973, max dup: 20096 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1239971, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 306 
        40 - 59% = 1534 
        60 - 79% = 506 
        80 - 99% = 163 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2008, nodes: 2202717 
    Average node length: 4.97, total dup: 2202667, max dup: 130223 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1042400, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 59 
        40 - 59% = 1073 
        60 - 79% = 51 
        80 - 99% = 822 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4340, nodes: 2202717 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 684936, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 106 
        20 - 39% = 674 
        40 - 59% = 583 
        60 - 79% = 887 
        80 - 99% = 2090 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.60, total records: 400 
    Average version length: 22.95, total versions: 244516, max versions: 633 
    Average fragment length: 2.00, total fragments: 38, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1352 
    Data pages: 1352, average fill: 90% 
    Primary pages: 14, secondary pages: 1338, swept pages: 0 
    Empty pages: 7, full pages: 1344 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1344 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 5.26, total records: 57521 
    Average version length: 68.29, total versions: 53088, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 16.71 
    Pointer pages: 6, data page slots: 1872 
    Data pages: 1624, average fill: 45% 
    Primary pages: 1623, secondary pages: 1, swept pages: 393 
    Empty pages: 465, full pages: 511 
    Fill distribution: 
     0 - 19% = 542 
    20 - 39% = 217 
    40 - 59% = 229 
    60 - 79% = 181 
    80 - 99% = 455 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1689483, depth: 3, leaf buckets: 229, nodes: 57521 
    Average node length: 13.49, total dup: 3633, max dup: 1 
    Average key length: 10.84, compression ratio: 2.49 
    Average prefix length: 19.10, average data length: 7.90 
    Clustering factor: 42212, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 111 
        40 - 59% = 80 
        60 - 79% = 34 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 18599, max versions: 958 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 11 
    80 - 99% = 56 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 4.53, total records: 1027 
    Average version length: 43.32, total versions: 919, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 12.81 
    Pointer pages: 1, data page slots: 96 
    Data pages: 33, average fill: 32% 
    Primary pages: 32, secondary pages: 1, swept pages: 7 
    Empty pages: 8, full pages: 5 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 5 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92519, depth: 2, leaf buckets: 3, nodes: 1027 
    Average node length: 4.83, total dup: 929, max dup: 109 
    Average key length: 3.01, compression ratio: 6.31 
    Average prefix length: 18.08, average data length: 0.92 
    Clustering factor: 586, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.04, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 37.24, total records: 798313 
    Average version length: 25.85, total versions: 23095, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.45 
    Pointer pages: 6, data page slots: 8176 
    Data pages: 8176, average fill: 67% 
    Primary pages: 8151, secondary pages: 25, swept pages: 5316 
    Empty pages: 33, full pages: 3471 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 55 
    40 - 59% = 619 
    60 - 79% = 7387 
    80 - 99% = 55 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 898, nodes: 798313 
    Average node length: 4.87, total dup: 798264, max dup: 145783 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89458, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 157 
        40 - 59% = 501 
        60 - 79% = 183 
        80 - 99% = 57 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 986, nodes: 798313 
    Average node length: 5.88, total dup: 710654, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159845, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 107 
        40 - 59% = 520 
        60 - 79% = 120 
        80 - 99% = 238 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1029, nodes: 798313 
    Average node length: 5.89, total dup: 710654, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161668, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 222 
        40 - 59% = 456 
        60 - 79% = 104 
        80 - 99% = 245 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1146, nodes: 798313 
    Average node length: 5.97, total dup: 710654, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154630, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 249 
        40 - 59% = 617 
        60 - 79% = 202 
        80 - 99% = 77 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.65, total records: 5419 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.84, total fragments: 136, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.05 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 73, secondary pages: 23, swept pages: 63 
    Empty pages: 10, full pages: 61 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5419 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.01 
    Average prefix length: 34.35, average data length: 1.55 
    Clustering factor: 5127, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5419 
    Average node length: 11.11, 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: 135, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 80117 
    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: 776 
    Data pages: 776, average fill: 71% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 772 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 772 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38292, depth: 2, leaf buckets: 102, nodes: 80117 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3231, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.57, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 138.79, total records: 166378 
    Average version length: 154.40, total versions: 13486, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.22 
    Pointer pages: 5, data page slots: 5056 
    Data pages: 4024, average fill: 86% 
    Primary pages: 4024, secondary pages: 0, swept pages: 5 
    Empty pages: 66, full pages: 3942 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3942 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 149.26, total records: 156602 
    Average version length: 150.11, total versions: 1514, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 5, data page slots: 4528 
    Data pages: 3752, average fill: 86% 
    Primary pages: 3752, secondary pages: 0, swept pages: 7 
    Empty pages: 41, full pages: 3699 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3698 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 145.67, total records: 146357 
    Average version length: 151.92, total versions: 4722, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 5, data page slots: 4272 
    Data pages: 3520, average fill: 86% 
    Primary pages: 3520, secondary pages: 0, swept pages: 2 
    Empty pages: 55, full pages: 3453 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3454 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.66, total records: 163502 
    Average version length: 151.70, total versions: 4735, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 6, data page slots: 5296 
    Data pages: 3936, average fill: 86% 
    Primary pages: 3936, secondary pages: 0, swept pages: 6 
    Empty pages: 51, full pages: 3864 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 3864 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.93, total records: 144765 
    Average version length: 146.98, total versions: 1839, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 4120 
    Data pages: 3480, average fill: 86% 
    Primary pages: 3479, secondary pages: 1, swept pages: 8 
    Empty pages: 43, full pages: 3413 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 10 
    80 - 99% = 3412 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.90, total records: 181498 
    Average version length: 151.02, total versions: 4022, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 6, data page slots: 5760 
    Data pages: 4384, average fill: 85% 
    Primary pages: 4383, secondary pages: 1, swept pages: 4 
    Empty pages: 67, full pages: 4297 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 4295 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 145.02, total records: 174089 
    Average version length: 153.33, total versions: 7103, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 8, data page slots: 4872 
    Data pages: 4200, average fill: 86% 
    Primary pages: 4200, secondary pages: 0, swept pages: 6 
    Empty pages: 59, full pages: 4121 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4122 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 144.57, total records: 145208 
    Average version length: 152.93, total versions: 5775, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 5, data page slots: 5632 
    Data pages: 3488, average fill: 86% 
    Primary pages: 3488, secondary pages: 0, swept pages: 3 
    Empty pages: 47, full pages: 3425 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 3425 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.72, total records: 174964 
    Average version length: 152.18, total versions: 7499, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 8, data page slots: 5480 
    Data pages: 4232, average fill: 86% 
    Primary pages: 4232, secondary pages: 0, swept pages: 1 
    Empty pages: 71, full pages: 4143 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4143 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.54, total records: 158300 
    Average version length: 148.74, total versions: 2621, 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: 6, data page slots: 4680 
    Data pages: 3800, average fill: 86% 
    Primary pages: 3800, secondary pages: 0, swept pages: 3 
    Empty pages: 39, full pages: 3745 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3744 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 52.54, total records: 2059540 
    Average version length: 52.96, total versions: 8229, 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: 25208 
    Data pages: 25208, average fill: 70% 
    Primary pages: 25208, secondary pages: 0, swept pages: 14138 
    Empty pages: 250, full pages: 18562 
    Fill distribution: 
     0 - 19% = 503 
    20 - 39% = 442 
    40 - 59% = 1423 
    60 - 79% = 22789 
    80 - 99% = 51 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2589, nodes: 2059540 
    Average node length: 5.44, total dup: 1921643, max dup: 1374 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179097, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 344 
        40 - 59% = 1700 
        60 - 79% = 288 
        80 - 99% = 254 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2754, nodes: 2059540 
    Average node length: 5.70, total dup: 1847756, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 368351, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2493 
        60 - 79% = 224 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2122, nodes: 2059540 
    Average node length: 4.96, total dup: 2059440, max dup: 27997 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 176806, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 241 
        40 - 59% = 1117 
        60 - 79% = 344 
        80 - 99% = 416 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 55.86, total records: 102753 
    Average version length: 69.14, total versions: 19832, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.26 
    Pointer pages: 3, data page slots: 3688 
    Data pages: 2600, average fill: 45% 
    Primary pages: 2600, secondary pages: 0, swept pages: 872 
    Empty pages: 288, full pages: 252 
    Fill distribution: 
     0 - 19% = 427 
    20 - 39% = 456 
    40 - 59% = 938 
    60 - 79% = 702 
    80 - 99% = 77 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103744, depth: 3, leaf buckets: 205, nodes: 102753 
    Average node length: 6.56, total dup: 89386, max dup: 14 
    Average key length: 4.02, compression ratio: 10.45 
    Average prefix length: 40.11, average data length: 1.89 
    Clustering factor: 18182, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 98 
        40 - 59% = 93 
        60 - 79% = 14 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 68.04, total records: 6936775 
    Average version length: 68.74, total versions: 91611, 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: 64, data page slots: 103696 
    Data pages: 103680, average fill: 71% 
    Primary pages: 103680, secondary pages: 0, swept pages: 76888 
    Empty pages: 13, full pages: 53208 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 576 
    40 - 59% = 8530 
    60 - 79% = 93686 
    80 - 99% = 838 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10743, nodes: 6936775 
    Average node length: 6.51, total dup: 6001207, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1526343, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1948 
        40 - 59% = 5868 
        60 - 79% = 2484 
        80 - 99% = 436 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8523, nodes: 6936775 
    Average node length: 5.40, total dup: 6659188, max dup: 121 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1330821, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1275 
        40 - 59% = 4809 
        60 - 79% = 1496 
        80 - 99% = 931 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8591, nodes: 6936775 
    Average node length: 5.40, total dup: 6659188, max dup: 121 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1333449, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1379 
        40 - 59% = 4781 
        60 - 79% = 1515 
        80 - 99% = 910 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 68.31, total records: 11919821 
    Average version length: 68.74, total versions: 110660, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.84 
    Pointer pages: 104, data page slots: 169432 
    Data pages: 169432, average fill: 74% 
    Primary pages: 169432, secondary pages: 0, swept pages: 122422 
    Empty pages: 3, full pages: 129875 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 346 
    40 - 59% = 5327 
    60 - 79% = 162050 
    80 - 99% = 1679 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18361, nodes: 11919821 
    Average node length: 6.59, total dup: 10392677, max dup: 51 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2340328, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 2539 
        40 - 59% = 10811 
        60 - 79% = 4190 
        80 - 99% = 799 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 60.29, total records: 1208386 
    Average version length: 69.11, total versions: 154984, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.09 
    Pointer pages: 25, data page slots: 39296 
    Data pages: 28472, average fill: 47% 
    Primary pages: 28472, secondary pages: 0, swept pages: 17752 
    Empty pages: 5537, full pages: 10879 
    Fill distribution: 
     0 - 19% = 8164 
    20 - 39% = 3597 
    40 - 59% = 3605 
    60 - 79% = 10947 
    80 - 99% = 2159 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2167, nodes: 1208386 
    Average node length: 5.56, total dup: 1159561, max dup: 49 
    Average key length: 2.58, compression ratio: 16.25 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 83868, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1288 
        40 - 59% = 751 
        60 - 79% = 110 
        80 - 99% = 8 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 58.26, total records: 780901 
    Average version length: 69.16, total versions: 121539, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.16 
    Pointer pages: 19, data page slots: 30368 
    Data pages: 25072, average fill: 36% 
    Primary pages: 25072, secondary pages: 0, swept pages: 14338 
    Empty pages: 4167, full pages: 1188 
    Fill distribution: 
     0 - 19% = 7595 
    20 - 39% = 5493 
    40 - 59% = 7422 
    60 - 79% = 4304 
    80 - 99% = 258 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1449, nodes: 780901 
    Average node length: 5.88, total dup: 724426, max dup: 59 
    Average key length: 2.95, compression ratio: 14.24 
    Average prefix length: 41.12, average data length: 0.88 
    Clustering factor: 112041, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 812 
        40 - 59% = 542 
        60 - 79% = 82 
        80 - 99% = 9 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.64, total records: 9191387 
    Average version length: 68.86, total versions: 567465, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 86, data page slots: 138952 
    Data pages: 138904, average fill: 71% 
    Primary pages: 138904, secondary pages: 0, swept pages: 65002 
    Empty pages: 249, full pages: 85585 
    Fill distribution: 
     0 - 19% = 818 
    20 - 39% = 3770 
    40 - 59% = 16655 
    60 - 79% = 105388 
    80 - 99% = 12273 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13443, nodes: 9191387 
    Average node length: 6.66, total dup: 7623370, max dup: 15 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2030391, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1304 
        40 - 59% = 6810 
        60 - 79% = 4683 
        80 - 99% = 644 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.43, total records: 21163898 
    Average version length: 82.84, total versions: 27853, 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: 318760 
    Data pages: 318760, average fill: 81% 
    Primary pages: 318760, secondary pages: 0, swept pages: 10172 
    Empty pages: 4, full pages: 318755 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 26282 
    80 - 99% = 292473 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19438, nodes: 21163898 
    Average node length: 5.72, total dup: 20682799, max dup: 166 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3282536, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 0 
        40 - 59% = 8249 
        60 - 79% = 550 
        80 - 99% = 10628 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17174, nodes: 21163898 
    Average node length: 6.31, total dup: 18598304, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914709, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 778 
        60 - 79% = 268 
        80 - 99% = 16124 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21251, nodes: 21163898 
    Average node length: 6.35, total dup: 18518414, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577777, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 8580 
        60 - 79% = 619 
        80 - 99% = 12043 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16088, nodes: 21163898 
    Average node length: 5.56, total dup: 21163798, max dup: 231796 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943473, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 11 
        40 - 59% = 2826 
        60 - 79% = 423 
        80 - 99% = 12828 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 74.33, total records: 10061161 
    Average version length: 82.61, total versions: 986302, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.70 
    Pointer pages: 102, data page slots: 166240 
    Data pages: 166192, average fill: 75% 
    Primary pages: 166192, secondary pages: 0, swept pages: 35908 
    Empty pages: 335, full pages: 129426 
    Fill distribution: 
     0 - 19% = 1006 
    20 - 39% = 4183 
    40 - 59% = 15359 
    60 - 79% = 51519 
    80 - 99% = 94125 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11332, nodes: 10061161 
    Average node length: 5.34, total dup: 9750998, max dup: 212 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2249245, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 29 
        40 - 59% = 7103 
        60 - 79% = 4056 
        80 - 99% = 141 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13614, nodes: 10061161 
    Average node length: 6.21, total dup: 8342051, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1576929, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 3703 
        40 - 59% = 4433 
        60 - 79% = 2579 
        80 - 99% = 2778 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12640, nodes: 10061161 
    Average node length: 5.95, total dup: 8752058, max dup: 49 
    Average key length: 2.83, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2451435, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 39 
        40 - 59% = 7995 
        60 - 79% = 4428 
        80 - 99% = 177 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10285, nodes: 10061161 
    Average node length: 5.11, total dup: 10061061, max dup: 170700 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1602474, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1081 
        40 - 59% = 5036 
        60 - 79% = 1840 
        80 - 99% = 2281 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 76.96, total records: 11657204 
    Average version length: 82.53, total versions: 756046, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 118, data page slots: 192056 
    Data pages: 190880, average fill: 75% 
    Primary pages: 190880, secondary pages: 0, swept pages: 50392 
    Empty pages: 2749, full pages: 155793 
    Fill distribution: 
     0 - 19% = 4250 
    20 - 39% = 5211 
    40 - 59% = 13069 
    60 - 79% = 36231 
    80 - 99% = 132119 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13132, nodes: 11657204 
    Average node length: 5.29, total dup: 11547186, max dup: 664 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2429203, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 73 
        40 - 59% = 8326 
        60 - 79% = 4508 
        80 - 99% = 220 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10584, nodes: 11657204 
    Average node length: 5.49, total dup: 11150071, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 730044, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 794 
        40 - 59% = 2518 
        60 - 79% = 1812 
        80 - 99% = 5328 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15020, nodes: 11657204 
    Average node length: 6.02, total dup: 10184581, max dup: 78 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2445800, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 90 
        40 - 59% = 9791 
        60 - 79% = 4864 
        80 - 99% = 268 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11026, nodes: 11657204 
    Average node length: 5.22, total dup: 11657104, max dup: 225948 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 718129, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 802 
        40 - 59% = 4952 
        60 - 79% = 1455 
        80 - 99% = 3710 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 74.81, total records: 10162133 
    Average version length: 82.91, total versions: 973739, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.68 
    Pointer pages: 105, data page slots: 171208 
    Data pages: 171152, average fill: 74% 
    Primary pages: 171152, secondary pages: 0, swept pages: 37342 
    Empty pages: 372, full pages: 127361 
    Fill distribution: 
     0 - 19% = 1175 
    20 - 39% = 5473 
    40 - 59% = 19932 
    60 - 79% = 53055 
    80 - 99% = 91517 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12024, nodes: 10162133 
    Average node length: 5.16, total dup: 10132988, max dup: 2597 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2055312, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1272 
        40 - 59% = 8010 
        60 - 79% = 2070 
        80 - 99% = 641 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13753, nodes: 10162133 
    Average node length: 6.23, total dup: 8424446, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1537452, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 3640 
        40 - 59% = 4428 
        60 - 79% = 2583 
        80 - 99% = 2924 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12675, nodes: 10162133 
    Average node length: 5.41, total dup: 9715318, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2193960, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1286 
        40 - 59% = 8916 
        60 - 79% = 1822 
        80 - 99% = 630 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10443, nodes: 10162133 
    Average node length: 5.13, total dup: 10162033, max dup: 173031 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1623226, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1128 
        40 - 59% = 5203 
        60 - 79% = 1748 
        80 - 99% = 2325 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.15, total records: 581601 
    Average version length: 68.79, total versions: 17129, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 5, data page slots: 7968 
    Data pages: 7968, average fill: 77% 
    Primary pages: 7968, secondary pages: 0, swept pages: 2548 
    Empty pages: 1, full pages: 7361 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 23 
    40 - 59% = 109 
    60 - 79% = 7448 
    80 - 99% = 386 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41008, depth: 3, leaf buckets: 736, nodes: 581601 
    Average node length: 5.94, total dup: 495463, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101344, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 511 
        60 - 79% = 113 
        80 - 99% = 91 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33704, depth: 3, leaf buckets: 762, nodes: 581601 
    Average node length: 6.15, total dup: 477084, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101404, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 537 
        60 - 79% = 108 
        80 - 99% = 97 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 576, nodes: 581601 
    Average node length: 4.86, total dup: 581501, max dup: 10044 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89887, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 340 
        60 - 79% = 108 
        80 - 99% = 104 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar 24 22:12:37 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7663208 16272 1 0.0000 0.0000
DOC_LIST 2202717 21943 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 244516 633 61100.0000 0.0000
INVNT_TURNOVER_LOG 57521 53088 1 0.0000 0.0000
MONEY_SALDO 49 18599 958 37900.0000 0.0000
MONEY_TURNOVER_LOG 1027 919 1 0.0000 0.0000
PDISTR 798313 23095 5 0.0000 0.0000
PERF_SPLIT_0 166378 13486 1 0.0000 0.0000
PERF_SPLIT_1 156602 1514 1 0.0000 0.0000
PERF_SPLIT_2 146357 4722 1 0.0000 0.0000
PERF_SPLIT_3 163502 4735 1 0.0000 0.0000
PERF_SPLIT_4 144765 1839 1 0.0000 0.0000
PERF_SPLIT_5 181498 4022 1 0.0000 0.0000
PERF_SPLIT_6 174089 7103 1 0.0000 0.0000
PERF_SPLIT_7 145208 5775 1 0.0000 0.0000
PERF_SPLIT_8 174964 7499 1 0.0000 0.0000
PERF_SPLIT_9 158300 2621 1 0.0000 0.0000
PSTORNED 2059540 8229 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 102753 19832 1 0.0000 0.0000
XQD_1000_3300 6936775 91611 1 0.0000 0.0000
XQD_1200_2000 11919821 110660 1 0.0000 0.0000
XQD_2000_3300 1208386 154984 1 0.0000 0.0000
XQD_2100_3300 780901 121539 1 0.0000 0.0000
XQD_3300_3400 9191387 567465 1 0.0000 0.0000
XQS_1000_1200 21163898 27853 1 0.0000 0.0000
XQS_1000_3300 10061161 986302 1 0.0000 0.0000
XQS_1200_2000 11657204 756046 1 0.0000 0.0000
XQS_2100_3300 10162133 973739 1 0.0000 0.0000
XQS_3300_3400 581601 17129 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 ---
:260: 
:261: mscs-test-161.budzdorov.ru    Sun Mar 24 22:10:25 2024
:262:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:263: 
:264: 
:265: mscs-test-161.budzdorov.ru    Sun Mar 24 22:10:27 2024
:266:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:267: 
--- end of diff output ---

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

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