Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.03.2024 22:10
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 15800616 kB
MemAvailable 30260648 kB
Buffers 0 kB
Cached 15962984 kB
SwapCached 2188 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-03 22:09:39
DTS_END                         2024-03-03 22:09:39.9280
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49704
TRN_ID                          170744
ATT_ID                          531
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: 8970.49 22266 897049
customer order: creation 168.54 329 16854
customer order: refuse 14.84 400 1484
order to supplier: creation 45.13 1380 4513
order to supplier: removal 3.39 117115 339
invoice (draft): creation 45.05 3499 4505
invoice (draft): removal 48.79 873 4879
invoice accept: apply 40.79 19897 4079
invoice accept: cancel 44.47 932 4447
customer reserve: creation 3928.00 187 392800
customer reserve: removal 4339.93 70 433993
realization accept: apply 83.01 247 8301
realization accept: cancel 77.39 144 7739
payment from customer: creation 60.24 171 6024
payment from customer: removal 5.46 135 546
payment to supplier: creation 49.25 229 4925
payment to supplier: removal 3.63 98 363
service: total inventory turnovers 5.03 1164 503
service: total monetary turnovers 6.63 29 663
service: aggregate perf. data 0.89 19891 89
service: refresh index statistics 0.03 278529 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 03-03-2024 22:11:18 to 03-03-2024 22:11:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2706
TEST_TIME 2 3017
TEST_TIME 3 2724
TEST_TIME 4 2484
TEST_TIME 5 2922
TEST_TIME 6 3139
TEST_TIME 7 3295
TEST_TIME 8 3336
TEST_TIME 9 3661
TEST_TIME 10 3981
TEST_TIME 11 4327
TEST_TIME 12 4657
TEST_TIME 13 4690
TEST_TIME 14 4810
TEST_TIME 15 5495
TEST_TIME 16 5633
TEST_TIME 17 5821
TEST_TIME 18 6041
TEST_TIME 19 6287
TEST_TIME 20 6496
TEST_TIME 21 6442
TEST_TIME 22 6550
TEST_TIME 23 6935
TEST_TIME 24 7081
TEST_TIME 25 7126
TEST_TIME 26 7259
TEST_TIME 27 7590
TEST_TIME 28 8021
TEST_TIME 29 8169
TEST_TIME 30 8402
TEST_TIME 31 8689
TEST_TIME 32 8870
TEST_TIME 33 8684
TEST_TIME 34 8784
TEST_TIME 35 8697
TEST_TIME 36 9010
TEST_TIME 37 9146
TEST_TIME 38 8991
TEST_TIME 39 9026
TEST_TIME 40 8952
TEST_TIME 41 8930
TEST_TIME 42 8928
TEST_TIME 43 8864
TEST_TIME 44 8705
TEST_TIME 45 8697
TEST_TIME 46 8601
TEST_TIME 47 8700
TEST_TIME 48 8820
TEST_TIME 49 8696
TEST_TIME 50 8679
TEST_TIME 51 8706
TEST_TIME 52 8713
TEST_TIME 53 8694
TEST_TIME 54 8660
TEST_TIME 55 8678
TEST_TIME 56 8663
TEST_TIME 57 8598
TEST_TIME 58 8533
TEST_TIME 59 8487
TEST_TIME 60 8570
TEST_TIME 61 8512
TEST_TIME 62 8501
TEST_TIME 63 8613
TEST_TIME 64 8664
TEST_TIME 65 8644
TEST_TIME 66 8630
TEST_TIME 67 8776
TEST_TIME 68 8751
TEST_TIME 69 8752
TEST_TIME 70 8816
TEST_TIME 71 8890
TEST_TIME 72 8988
TEST_TIME 73 9005
TEST_TIME 74 8935
TEST_TIME 75 8879
TEST_TIME 76 8820
TEST_TIME 77 8867
TEST_TIME 78 8811
TEST_TIME 79 8798
TEST_TIME 80 8830
TEST_TIME 81 8818
TEST_TIME 82 8792
TEST_TIME 83 8832
TEST_TIME 84 8827
TEST_TIME 85 8856
TEST_TIME 86 8924
TEST_TIME 87 8986
TEST_TIME 88 9010
TEST_TIME 89 9053
TEST_TIME 90 9060
TEST_TIME 91 9130
TEST_TIME 92 9094
TEST_TIME 93 9147
TEST_TIME 94 9056
TEST_TIME 95 9041
TEST_TIME 96 9015
TEST_TIME 97 8990
TEST_TIME 98 9059
TEST_TIME 99 9016
TEST_TIME 100 8984

Performance per minute, chart


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

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 1257525 1257525 0 0.00 0 50123 8 0 0
doc_list_biud 1257522 1257522 0 0.00 0 31456 31 0 0
sp_add_invoice_to_stock 4266 4079 187 4.38 53 221974 19897 0 187
sp_cancel_adding_invoice 4447 4447 0 0.00 5 54460 932 0 0
sp_cancel_client_order 1484 1484 0 0.00 3 11897 400 0 0
sp_cancel_customer_reserve 433993 433993 0 0.00 0 23765 70 0 0
sp_cancel_pay_from_customer 546 546 0 0.00 3 13183 135 0 0
sp_cancel_pay_to_supplier 363 363 0 0.00 3 10186 99 0 0
sp_cancel_supplier_invoice 4889 4879 10 0.20 2 27857 873 0 10
sp_cancel_supplier_order 339 339 0 0.00 6 1091725 117116 0 0
sp_cancel_write_off 7739 7739 0 0.00 1 22234 144 0 0
sp_client_order 16854 16854 0 0.00 3 21017 329 0 0
sp_customer_reserve 392800 392800 0 0.00 0 139311 188 0 0
sp_fill_shopping_cart 25858 25858 0 0.00 1 21216 42 0 0
sp_fill_shopping_cart_clo_res 392792 392792 0 0.00 0 13469 15 0 0
sp_get_clo_for_invoice 4063 4063 0 0.00 0 16300 332 0 0
sp_kill_cost_storno 13095 13095 0 0.00 0 22097 85 0 0
sp_kill_qstorno_ret_qs2qd 880943 880943 0 0.00 0 27830 38 0 0
sp_kill_qty_storno 465244 465244 0 0.00 0 31455 82 0 0
sp_lock_selected_doc 17193 17193 0 0.00 0 7625 5 0 0
sp_make_cost_storno 23313 23313 0 0.00 0 47527 96 0 0
sp_multiply_rows_for_pdistr 23312 23312 0 0.00 0 29400 45 0 0
sp_multiply_rows_for_qdistr 16854 16854 0 0.00 0 13179 131 0 0
sp_pay_from_customer 6024 6024 0 0.00 4 29564 172 0 0
sp_pay_to_supplier 4925 4925 0 0.00 5 44685 229 0 0
sp_payment_common 10949 10949 0 0.00 2 29375 71 0 0
sp_qd_handle_on_cancel_clo 1484 1484 0 0.00 0 11887 366 0 0
sp_qd_handle_on_invoice_upd_sts 8510 8510 0 0.00 0 31453 409 0 0
sp_qd_handle_on_reserve_upd_sts 8300 8300 0 0.00 0 10492 60 0 0
sp_reserve_write_off 8301 8301 0 0.00 7 50350 247 0 0
sp_supplier_invoice 4505 4505 0 0.00 6 94843 3499 0 0
sp_supplier_order 4513 4513 0 0.00 5 31624 1380 0 0
srv_aggregate_perf_data 89 89 0 0.00 1857 193823 19891 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1578 153904 45653 0 0
srv_find_qd_qs_mism 855463 855463 0 0.00 0 21877 5 0 0
srv_make_invnt_saldo 503 503 0 0.00 40 98213 1164 0 0
srv_make_money_saldo 663 663 0 0.00 1 1032 30 0 0
srv_recalc_idx_stat 3 3 0 0.00 210363 383715 278530 0 0
t$perf-abend:sp_add_invoice_to_stock 187 187 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4079 4079 0 0.00 0 11547 218 0 0
t$perf-norm:sp_cancel_adding_invoice 345 345 0 0.00 0 2163 91 0 0
t$perf-norm:sp_cancel_client_order 1484 1484 0 0.00 0 4273 23 0 0
t$perf-norm:sp_cancel_customer_reserve 565 565 0 0.00 0 1985 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 546 546 0 0.00 0 16847 44 0 0
t$perf-norm:sp_cancel_pay_to_supplier 363 363 0 0.00 0 570 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 348 348 0 0.00 0 1878 26 0 0
t$perf-norm:sp_cancel_supplier_order 339 339 0 0.00 0 24018 2261 0 0
t$perf-norm:sp_cancel_write_off 840 840 0 0.00 0 3002 12 0 0
t$perf-norm:sp_client_order 16854 16854 0 0.00 0 14529 22 0 0
t$perf-norm:sp_customer_reserve 838 838 0 0.00 0 7921 21 0 0
t$perf-norm:sp_pay_from_customer 6024 6024 0 0.00 0 3767 7 0 0
t$perf-norm:sp_pay_to_supplier 4925 4925 0 0.00 0 17735 24 0 0
t$perf-norm:sp_reserve_write_off 8301 8301 0 0.00 0 16533 18 0 0
t$perf-norm:sp_supplier_invoice 4505 4505 0 0.00 0 16424 28 0 0
t$perf-norm:sp_supplier_order 4513 4513 0 0.00 0 17020 21 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 1590 44 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 71 2 0 0
t$perf-norm:srv_make_invnt_saldo 503 503 0 0.00 0 1611 33 0 0
t$perf-norm:srv_make_money_saldo 663 663 0 0.00 0 615 20 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 8500 8126 374 4.40 0 3922 21 0 374
v_all_customers 31642 31642 0 0.00 0 16 1 0 0
v_all_suppliers 25882 25882 0 0.00 0 24 1 0 0
v_all_wares 33708 33708 0 0.00 0 93 1 0 0
v_cancel_adding_invoice 690 690 0 0.00 0 3189 14 0 0
v_cancel_client_order 2968 2968 0 0.00 0 3170 9 0 0
v_cancel_customer_prepayment 1092 1092 0 0.00 0 3375 16 0 0
v_cancel_customer_reserve 1130 1130 0 0.00 0 2901 6 0 0
v_cancel_payment_to_supplier 726 726 0 0.00 0 1534 7 0 0
v_cancel_supplier_invoice 716 696 20 2.79 0 2564 29 0 20
v_cancel_supplier_order 678 678 0 0.00 0 1229 9 0 0
v_cancel_write_off 1680 1680 0 0.00 0 2607 16 0 0
v_max_id_clo_ord 4504 4504 0 0.00 0 1386 2 0 0
v_max_id_clo_res 838 838 0 0.00 0 2190 7 0 0
v_max_id_ord_sup 4500 4500 0 0.00 0 5639 4 0 0
v_max_non_paid_invoice 988 988 0 0.00 0 2913 9 0 0
v_max_non_paid_realizn 2898 2898 0 0.00 0 1225 4 0 0
v_min_id_clo_ord 4504 4504 0 0.00 0 7171 13 0 0
v_min_id_clo_res 838 838 0 0.00 0 4295 7 0 0
v_min_id_ord_sup 4500 4500 0 0.00 0 6452 8 0 0
v_min_non_paid_invoice 4925 4925 0 0.00 0 29229 63 0 0
v_min_non_paid_realizn 6024 6024 0 0.00 0 23991 59 0 0
v_our_firm 8318 8318 0 0.00 0 14 1 0 0
v_reserve_write_off 16600 16600 0 0.00 0 3165 6 0 0
x_lock_depdocs_on_canc_invoice 8978 8978 0 0.00 0 10553 156 0 0
x_lock_depdocs_on_canc_sup_ord 339 339 0 0.00 0 11545 439 0 0
x_make_qstorno_1000_1200 4513 4513 0 0.00 1 31560 1284 0 0
x_make_qstorno_1200_2000 4505 4505 0 0.00 3 82034 3352 0 0
x_make_qstorno_2100_3300 392800 392800 0 0.00 0 139251 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-03-2024 22:11:26 to 03-03-2024 22:11:30.

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:43 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:44 24411 8192000000 9898805136 10208972800 978041136 10.665 100 89 178 0 1007653008 5480496 24131376
20:12:13 10054 8192000000 9934740960 10251300864 1019307872 11.065 100 89 178 0 1049575872 7597536 22670464
20:13:28 18785 8192000000 9957313648 10286002176 1043083056 11.294 100 87 174 0 1073879168 8585296 22210816
20:14:58 11320 8192000000 10011488416 10354163712 1102122832 11.858 100 83 165 0 1131274480 9341280 19810368
20:16:13 8082 8192000000 10057425936 10411851776 1144116176 12.254 100 80 160 0 1174271296 11568880 18586240
20:17:24 4975 8192000000 10104065712 10466816000 1189046064 12.674 100 81 161 0 1220625840 13092560 18487216
20:18:31 3882 8192000000 10134360464 10508263424 1223451632 12.994 100 72 142 0 1251969536 12326512 16191392
20:19:38 3057 8192000000 10175150880 10559307776 1266741984 13.392 100 81 161 0 1298839440 13468720 18628736
20:20:43 897 8192000000 10196812880 10577829888 1283090832 13.541 100 83 163 0 1314085232 13431584 17562816
20:21:46 2062 8192000000 10210711824 10594172928 1297606896 13.673 100 81 163 1 1327145760 12990208 16548656
20:22:51 4817 8192000000 10200628592 10600017920 1305449424 13.745 100 60 118 1 1328106432 10523600 12133408
20:23:59 8837 8192000000 10205057344 10612084736 1313677680 13.819 100 39 73 0 1329924880 7587264 8659936
20:25:09 6298 8192000000 10210142400 10625945600 1325141328 13.923 100 43 84 0 1346457136 12499664 8816144
20:26:19 60067 8192000000 10232924368 10638159872 1328057696 13.950 100 43 87 1 1343181200 5493056 9630448
20:28:20 6165 8192000000 10230118960 10646958080 1336961568 14.030 100 28 57 0 1349961600 6640768 6359264
20:29:27 7405 8192000000 10215279632 10635390976 1319048720 13.868 99 20 40 0 1329715712 5975248 4691744
20:30:40 60965 8192000000 10240469920 10654461952 1319840768 13.875 98 41 82 0 1339112352 9193488 10078096
20:32:46 141647 8192000000 10250153104 10669580288 1306671024 13.756 96 35 70 0 1331567184 16418768 8477392
20:36:35 19676 8192000000 10269379696 10684092416 1347869280 14.128 99 38 75 0 1376052928 19460320 8723328
20:38:05 13533 8192000000 10263308432 10678857728 1334205872 14.005 98 43 87 1 1365973232 21087808 10679552
20:39:26 32965 8192000000 10274839152 10692530176 1342836400 14.083 99 43 84 1 1378976768 26171840 9968528
20:41:17 8296 8192000000 10260447968 10670362624 1334001584 14.003 99 48 96 0 1368111584 23207232 10902768
20:42:31 5163 8192000000 10262684592 10654375936 1317862224 13.857 99 75 150 0 1363733216 28872608 16998384
20:43:42 12412 8192000000 10289905616 10694696960 1343177856 14.086 100 68 136 0 1394717488 35461488 16078144
20:45:06 2878 8192000000 10265268992 10663698432 1318394208 13.862 98 72 140 0 1365396080 30055888 16945984
20:46:13 7718 8192000000 10271639088 10673528832 1335954384 14.021 100 61 119 0 1375719232 25307920 14456928
20:47:30 3528 8192000000 10308155840 10704105472 1357592160 14.216 100 79 158 0 1409525200 32491664 19441376
20:48:37 4105 8192000000 10291187680 10704367616 1361038112 14.247 100 51 102 1 1400144016 26296192 12809712
20:49:53 9201 8192000000 10321930848 10725851136 1375608576 14.377 100 84 166 1 1424587856 28263120 20716160
20:51:12 1951 8192000000 10330331344 10739290112 1379483296 14.412 100 70 137 1 1435738768 36834240 19421232
20:52:20 1568 8192000000 10361779584 10772398080 1405007024 14.640 100 74 148 1 1465273984 40854048 19412912
20:53:24 22185 8192000000 10336759904 10772361216 1402800032 14.620 100 31 62 0 1446460736 34835712 8824992
20:55:04 10422 8192000000 10351293104 10778853376 1404690448 14.637 100 45 91 0 1456613680 40079232 11844000
20:56:21 7750 8192000000 10355337376 10789847040 1411674112 14.699 100 32 64 0 1467518416 46858784 8985520
20:57:50 17074 8192000000 10327985840 10773864448 1393035280 14.533 100 30 60 1 1444723696 43324992 8363424
20:59:27 23002 8192000000 10299925968 10741567488 1363928544 14.273 99 15 30 1 1398983872 31071168 3984160
21:00:56 2413 8192000000 10320271264 10735149056 1367140320 14.301 98 82 162 2 1412277296 24755520 20381456
21:02:00 28993 8192000000 10321188272 10761879552 1393655984 14.538 100 20 40 0 1427305632 28253952 5395696
21:03:52 23438 8192000000 10320386128 10776584192 1397904336 14.576 100 14 28 0 1432451120 30980768 3566016
21:05:30 39948 8192000000 10298670768 10745393152 1385152432 14.463 100 22 44 1 1409227280 19323120 4751728
21:07:13 97656 8192000000 10288910160 10744737792 1390577440 14.511 100 19 38 0 1408967120 13510624 4879056
21:10:00 64123 8192000000 10310425392 10763776000 1408214896 14.668 100 27 55 0 1427578576 13339856 6023824
21:12:10 153892 8192000000 10324724544 10778071040 1393451968 14.537 98 27 54 0 1414827376 14669600 6705808
21:15:49 26710 8192000000 10336552224 10778619904 1411575184 14.698 100 46 89 2 1441524608 19629376 10320048
21:17:18 148458 8192000000 10309301856 10769907712 1384820912 14.460 98 17 33 0 1401057792 12743760 3493120
21:20:47 30763 8192000000 10312268384 10776428544 1407918128 14.665 100 15 28 0 1432043056 21261728 2863200
21:22:21 83254 8192000000 10278872704 10730708992 1354733280 14.190 96 18 36 0 1369032656 10245408 4053968
21:24:45 14167 8192000000 10293381648 10754408448 1400133760 14.596 100 15 28 0 1414641840 11485344 3022736
21:26:00 53053 8192000000 10273743136 10728931328 1362474080 14.260 97 22 44 0 1375163072 7785216 4903776
21:27:53 86557 8192000000 10299093136 10756890624 1356890000 14.209 97 9 18 0 1367211152 8019520 2301632
21:30:21 35792 8192000000 10282275872 10731798528 1364027904 14.274 99 27 53 0 1382559360 11876784 6654672
21:32:05 65250 8192000000 10240322416 10685538304 1288559968 13.591 94 28 56 1 1307266576 12243520 6463088
21:34:11 71142 8192000000 10254188912 10687672320 1271026320 13.431 94 21 42 0 1286769536 11222480 4520736
21:36:23 59925 8192000000 10241749184 10684497920 1300412624 13.699 97 17 34 0 1314581376 10619248 3549504
21:38:25 35463 8192000000 10267957680 10708054016 1354751424 14.190 100 29 58 0 1376166080 15252240 6162416
21:40:10 61133 8192000000 10273184272 10724552704 1346849184 14.119 99 14 26 1 1363153552 14014784 2289584
21:42:12 104263 8192000000 10278761248 10726785024 1351800640 14.164 98 22 43 0 1369574992 12917360 4856992
21:45:13 16558 8192000000 10277427504 10713554944 1365165232 14.284 99 35 67 1 1381345824 8952304 7228288
21:46:31 88214 8192000000 10274439584 10733187072 1350665120 14.153 98 10 20 0 1366345616 13717568 1962928
21:49:17 74118 8192000000 10290400912 10728505344 1352608816 14.171 98 35 70 0 1367797232 7219760 7968656
21:51:31 14577 8192000000 10284685456 10729193472 1378250400 14.401 100 37 72 1 1392602848 6915040 7437408
21:52:49 43670 8192000000 10293543904 10749038592 1385303488 14.464 100 19 35 0 1402304112 12801248 4199376
21:54:34 57993 8192000000 10307580176 10764111872 1401774224 14.611 100 20 41 0 1421973168 15835072 4363872
21:57:07 90241 8192000000 10286915536 10742366208 1329624976 13.964 95 16 32 0 1348972336 16100448 3246912
21:59:49 77161 8192000000 10296537920 10753298432 1351743584 14.163 97 19 38 0 1370357344 14536944 4076816
22:02:12 127432 8192000000 10303710080 10754834432 1395943456 14.559 100 12 24 1 1415196128 16393968 2858704
22:05:19 42025 8192000000 10290273232 10747772928 1390171824 14.507 100 13 26 0 1405071584 12386128 2513632
22:07:07 63442 8192000000 10280473600 10745155584 1351070960 14.157 97 12 24 0 1362895200 9656464 2167776
22:09:13 31630 8192000000 9278610672 9558110208 441812432 5.117 33 3 6 0 445197536 2809104 576000

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 03-03-2024 22:11:32 to 03-03-2024 22:11:46.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 187 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          170998
MON$OLDEST_ACTIVE               170999
MON$OLDEST_SNAPSHOT             170999
MON$NEXT_TRANSACTION            170999
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                       1904416
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.33733 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33733 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33733 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33733 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  3 22:11:50 2024 
 
Database header page information: 
    Flags            0 
    Generation        89270 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    170998 
    Oldest active        170999 
    Oldest snapshot        170999 
    Next transaction    171000 
    Sequence number        0 
    Next attachment ID    697 
    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.40, total records: 7730354 
    Average version length: 48.16, total versions: 79724, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87168 
    Data pages: 87168, average fill: 71% 
    Primary pages: 87168, secondary pages: 0, swept pages: 26891 
    Empty pages: 5, full pages: 57855 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 198 
    40 - 59% = 3746 
    60 - 79% = 83181 
    80 - 99% = 25 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23158, nodes: 7730354 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1686642, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 344 
        20 - 39% = 1780 
        40 - 59% = 4027 
        60 - 79% = 2354 
        80 - 99% = 14653 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13459, nodes: 7730354 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1511012, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1560 
        40 - 59% = 1999 
        60 - 79% = 1090 
        80 - 99% = 8810 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8260, nodes: 7730354 
    Average node length: 6.61, total dup: 5787587, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1504036, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 972 
        40 - 59% = 1326 
        60 - 79% = 921 
        80 - 99% = 4944 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.40, total records: 2232997 
    Average version length: 34.68, total versions: 80612, max versions: 3 
    Average fragment length: 8.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28616 
    Data pages: 28616, average fill: 72% 
    Primary pages: 28610, secondary pages: 6, swept pages: 12051 
    Empty pages: 3, full pages: 18666 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 145 
    40 - 59% = 2379 
    60 - 79% = 25432 
    80 - 99% = 642 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4524, nodes: 2232997 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678359, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 920 
        40 - 59% = 804 
        60 - 79% = 738 
        80 - 99% = 2062 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2514, nodes: 2235504 
    Average node length: 4.97, total dup: 2234605, max dup: 19924 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1239851, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 268 
        40 - 59% = 1556 
        60 - 79% = 500 
        80 - 99% = 188 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2028, nodes: 2232997 
    Average node length: 4.97, total dup: 2232947, max dup: 130048 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1060329, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 127 
        40 - 59% = 995 
        60 - 79% = 45 
        80 - 99% = 855 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4285, nodes: 2232997 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678359, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 79 
        20 - 39% = 591 
        40 - 59% = 571 
        60 - 79% = 828 
        80 - 99% = 2216 
 
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.43, total records: 400 
    Average version length: 22.58, total versions: 236328, max versions: 611 
    Average fragment length: 2.00, total fragments: 49, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1280 
    Data pages: 1280, average fill: 91% 
    Primary pages: 10, secondary pages: 1270, swept pages: 0 
    Empty pages: 3, full pages: 1276 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 1276 
 
    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.96, total records: 76185 
    Average version length: 68.28, total versions: 69539, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 14.77 
    Pointer pages: 8, data page slots: 2280 
    Data pages: 1560, average fill: 61% 
    Primary pages: 1559, secondary pages: 1, swept pages: 0 
    Empty pages: 276, full pages: 851 
    Fill distribution: 
     0 - 19% = 344 
    20 - 39% = 119 
    40 - 59% = 146 
    60 - 79% = 151 
    80 - 99% = 800 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1693862, depth: 3, leaf buckets: 311, nodes: 76185 
    Average node length: 13.23, total dup: 4085, max dup: 1 
    Average key length: 10.80, compression ratio: 2.50 
    Average prefix length: 19.14, average data length: 7.86 
    Clustering factor: 56484, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 205 
        40 - 59% = 83 
        60 - 79% = 20 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18375, max versions: 971 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 82% 
    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% = 1 
    60 - 79% = 13 
    80 - 99% = 53 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 9.67, total records: 1995 
    Average version length: 43.14, total versions: 1550, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 6.00 
    Pointer pages: 1, data page slots: 40 
    Data pages: 30, average fill: 61% 
    Primary pages: 27, secondary pages: 3, swept pages: 4 
    Empty pages: 5, full pages: 17 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 16 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89307, depth: 2, leaf buckets: 5, nodes: 1995 
    Average node length: 4.18, total dup: 1897, max dup: 204 
    Average key length: 2.52, compression ratio: 7.54 
    Average prefix length: 18.53, average data length: 0.47 
    Clustering factor: 1028, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        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.19, total records: 70 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.17, total records: 815418 
    Average version length: 25.47, total versions: 66002, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8520 
    Data pages: 8504, average fill: 67% 
    Primary pages: 8457, secondary pages: 47, swept pages: 2238 
    Empty pages: 137, full pages: 6262 
    Fill distribution: 
     0 - 19% = 280 
    20 - 39% = 220 
    40 - 59% = 503 
    60 - 79% = 7267 
    80 - 99% = 234 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 930, nodes: 815418 
    Average node length: 4.87, total dup: 815369, max dup: 154349 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89234, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 154 
        40 - 59% = 552 
        60 - 79% = 173 
        80 - 99% = 50 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1024, nodes: 815418 
    Average node length: 5.88, total dup: 726257, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160517, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 113 
        40 - 59% = 568 
        60 - 79% = 99 
        80 - 99% = 241 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1058, nodes: 815418 
    Average node length: 5.88, total dup: 726257, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162479, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 200 
        40 - 59% = 529 
        60 - 79% = 80 
        80 - 99% = 249 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1187, nodes: 815418 
    Average node length: 5.96, total dup: 726257, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155187, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 283 
        40 - 59% = 636 
        60 - 79% = 192 
        80 - 99% = 75 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.90, total records: 5494 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.84, total fragments: 61, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 72, secondary pages: 24, swept pages: 55 
    Empty pages: 12, full pages: 65 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 67 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5494 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.08 
    Average prefix length: 34.50, average data length: 1.54 
    Clustering factor: 5160, ratio: 0.94 
    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: 5494 
    Average node length: 11.12, 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: 155, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.09, total records: 77815 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 752 
    Data pages: 752, average fill: 71% 
    Primary pages: 752, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 749 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 749 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34653, depth: 2, leaf buckets: 99, nodes: 77815 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3382, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, 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.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    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: 150.30, total records: 164135 
    Average version length: 146.82, total versions: 939, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 7, data page slots: 4680 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3920, secondary pages: 0, swept pages: 6 
    Empty pages: 22, full pages: 3886 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3887 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 147.96, total records: 159686 
    Average version length: 152.78, total versions: 3276, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 4400 
    Data pages: 3896, average fill: 85% 
    Primary pages: 3895, secondary pages: 1, swept pages: 6 
    Empty pages: 95, full pages: 3774 
    Fill distribution: 
     0 - 19% = 100 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 10 
    80 - 99% = 3773 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.75, total records: 157649 
    Average version length: 150.30, total versions: 2398, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 8, data page slots: 5424 
    Data pages: 3800, average fill: 85% 
    Primary pages: 3800, secondary pages: 0, swept pages: 2 
    Empty pages: 52, full pages: 3726 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 3727 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.72, total records: 148653 
    Average version length: 151.61, total versions: 3068, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 4760 
    Data pages: 3576, average fill: 86% 
    Primary pages: 3576, secondary pages: 0, swept pages: 3 
    Empty pages: 47, full pages: 3507 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 3506 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.24, total records: 154652 
    Average version length: 150.88, total versions: 3138, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 9, data page slots: 5056 
    Data pages: 3752, average fill: 85% 
    Primary pages: 3752, secondary pages: 0, swept pages: 4 
    Empty pages: 64, full pages: 3656 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 15 
    40 - 59% = 11 
    60 - 79% = 4 
    80 - 99% = 3656 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 149.22, total records: 157899 
    Average version length: 149.93, total versions: 1738, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 4136 
    Data pages: 3800, average fill: 85% 
    Primary pages: 3800, secondary pages: 0, swept pages: 3 
    Empty pages: 51, full pages: 3733 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3733 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 137.01, total records: 188066 
    Average version length: 154.36, total versions: 17723, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.38 
    Pointer pages: 7, data page slots: 5776 
    Data pages: 4640, average fill: 84% 
    Primary pages: 4639, secondary pages: 1, swept pages: 5 
    Empty pages: 146, full pages: 4451 
    Fill distribution: 
     0 - 19% = 149 
    20 - 39% = 15 
    40 - 59% = 14 
    60 - 79% = 12 
    80 - 99% = 4450 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.64, total records: 174705 
    Average version length: 151.84, total versions: 3189, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 8, data page slots: 5600 
    Data pages: 4232, average fill: 85% 
    Primary pages: 4232, secondary pages: 0, swept pages: 7 
    Empty pages: 72, full pages: 4135 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 4135 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.22, total records: 173089 
    Average version length: 153.00, total versions: 2328, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 5488 
    Data pages: 4160, average fill: 86% 
    Primary pages: 4160, secondary pages: 0, swept pages: 1 
    Empty pages: 47, full pages: 4102 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4102 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.28, total records: 158474 
    Average version length: 152.65, total versions: 3048, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 8, data page slots: 5328 
    Data pages: 3848, average fill: 85% 
    Primary pages: 3848, secondary pages: 0, swept pages: 5 
    Empty pages: 79, full pages: 3750 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3751 
 
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: 51.67, total records: 2097499 
    Average version length: 52.90, total versions: 42743, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25416 
    Data pages: 25416, average fill: 71% 
    Primary pages: 25416, secondary pages: 0, swept pages: 11441 
    Empty pages: 232, full pages: 20107 
    Fill distribution: 
     0 - 19% = 459 
    20 - 39% = 373 
    40 - 59% = 1170 
    60 - 79% = 23040 
    80 - 99% = 374 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2598, nodes: 2097499 
    Average node length: 5.44, total dup: 1956773, max dup: 1263 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181181, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 294 
        40 - 59% = 1722 
        60 - 79% = 306 
        80 - 99% = 274 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2752, nodes: 2097499 
    Average node length: 5.69, total dup: 1882607, max dup: 72 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374627, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 2429 
        60 - 79% = 283 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2116, nodes: 2097499 
    Average node length: 4.96, total dup: 2097399, max dup: 28864 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 179050, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 172 
        40 - 59% = 1135 
        60 - 79% = 385 
        80 - 99% = 422 
 
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: 37.64, total records: 132383 
    Average version length: 69.18, total versions: 60414, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.35 
    Pointer pages: 3, data page slots: 4488 
    Data pages: 3088, average fill: 50% 
    Primary pages: 3088, secondary pages: 0, swept pages: 545 
    Empty pages: 759, full pages: 1518 
    Fill distribution: 
     0 - 19% = 1024 
    20 - 39% = 168 
    40 - 59% = 220 
    60 - 79% = 587 
    80 - 99% = 1089 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103239, depth: 3, leaf buckets: 211, nodes: 132383 
    Average node length: 6.38, total dup: 115275, max dup: 14 
    Average key length: 3.97, compression ratio: 10.59 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22741, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 60 
        40 - 59% = 98 
        60 - 79% = 45 
        80 - 99% = 8 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.37, total records: 7079118 
    Average version length: 68.77, total versions: 367514, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 65, data page slots: 104672 
    Data pages: 104672, average fill: 72% 
    Primary pages: 104672, secondary pages: 0, swept pages: 35768 
    Empty pages: 42, full pages: 67107 
    Fill distribution: 
     0 - 19% = 318 
    20 - 39% = 996 
    40 - 59% = 8406 
    60 - 79% = 90241 
    80 - 99% = 4711 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10753, nodes: 7079118 
    Average node length: 6.51, total dup: 6125542, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1565998, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1693 
        40 - 59% = 5894 
        60 - 79% = 2700 
        80 - 99% = 456 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8618, nodes: 7079118 
    Average node length: 5.39, total dup: 6798487, max dup: 181 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1366799, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1151 
        40 - 59% = 5033 
        60 - 79% = 1504 
        80 - 99% = 922 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8692, nodes: 7079118 
    Average node length: 5.40, total dup: 6798487, max dup: 181 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1369447, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1288 
        40 - 59% = 4962 
        60 - 79% = 1527 
        80 - 99% = 908 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.98, total records: 12162102 
    Average version length: 68.71, total versions: 347857, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 105, data page slots: 171320 
    Data pages: 171320, average fill: 75% 
    Primary pages: 171320, secondary pages: 0, swept pages: 85402 
    Empty pages: 7, full pages: 146125 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 543 
    40 - 59% = 5361 
    60 - 79% = 159659 
    80 - 99% = 5709 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18523, nodes: 12162102 
    Average node length: 6.59, total dup: 10605050, max dup: 81 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2387756, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 2211 
        40 - 59% = 10889 
        60 - 79% = 4724 
        80 - 99% = 682 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 42.40, total records: 1609324 
    Average version length: 69.10, total versions: 622531, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.97 
    Pointer pages: 27, data page slots: 42240 
    Data pages: 31253, average fill: 59% 
    Primary pages: 31252, secondary pages: 1, swept pages: 10494 
    Empty pages: 4713, full pages: 18630 
    Fill distribution: 
     0 - 19% = 6683 
    20 - 39% = 2493 
    40 - 59% = 2106 
    60 - 79% = 10630 
    80 - 99% = 9341 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2343, nodes: 1609324 
    Average node length: 5.52, total dup: 1544324, max dup: 95 
    Average key length: 2.56, compression ratio: 16.41 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 105472, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 754 
        40 - 59% = 1153 
        60 - 79% = 366 
        80 - 99% = 53 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 40.86, total records: 1000581 
    Average version length: 69.14, total versions: 408048, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.08 
    Pointer pages: 24, data page slots: 38424 
    Data pages: 29024, average fill: 40% 
    Primary pages: 29024, secondary pages: 0, swept pages: 8862 
    Empty pages: 7666, full pages: 9076 
    Fill distribution: 
     0 - 19% = 11764 
    20 - 39% = 3231 
    40 - 59% = 3333 
    60 - 79% = 3667 
    80 - 99% = 7029 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1505, nodes: 1000581 
    Average node length: 5.77, total dup: 935589, max dup: 116 
    Average key length: 2.85, compression ratio: 14.75 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 131074, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 518 
        40 - 59% = 653 
        60 - 79% = 268 
        80 - 99% = 59 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.80, total records: 9131295 
    Average version length: 68.98, total versions: 410153, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 88, data page slots: 142128 
    Data pages: 142112, average fill: 69% 
    Primary pages: 142112, secondary pages: 0, swept pages: 69278 
    Empty pages: 217, full pages: 74431 
    Fill distribution: 
     0 - 19% = 804 
    20 - 39% = 5049 
    40 - 59% = 22941 
    60 - 79% = 106928 
    80 - 99% = 6390 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13485, nodes: 9131295 
    Average node length: 6.68, total dup: 7574245, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1911721, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1374 
        40 - 59% = 6928 
        60 - 79% = 4580 
        80 - 99% = 603 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21118067 
    Average version length: 82.92, total versions: 9958, 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: 318456 
    Data pages: 318456, average fill: 81% 
    Primary pages: 318456, secondary pages: 0, swept pages: 13435 
    Empty pages: 45, full pages: 317068 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 58 
    40 - 59% = 186 
    60 - 79% = 28145 
    80 - 99% = 289981 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19429, nodes: 21118067 
    Average node length: 5.72, total dup: 20637815, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276553, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8292 
        60 - 79% = 543 
        80 - 99% = 10589 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17126, nodes: 21118067 
    Average node length: 6.31, total dup: 18558259, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914008, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 6 
        40 - 59% = 745 
        60 - 79% = 273 
        80 - 99% = 16099 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21173, nodes: 21118067 
    Average node length: 6.35, total dup: 18477618, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3570430, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8519 
        60 - 79% = 556 
        80 - 99% = 12094 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 15957, nodes: 21118067 
    Average node length: 5.56, total dup: 21117967, max dup: 231149 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942775, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2679 
        60 - 79% = 337 
        80 - 99% = 12932 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 80.02, total records: 9450745 
    Average version length: 82.61, total versions: 274332, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 104, data page slots: 169400 
    Data pages: 169320, average fill: 69% 
    Primary pages: 169320, secondary pages: 0, swept pages: 102733 
    Empty pages: 480, full pages: 87893 
    Fill distribution: 
     0 - 19% = 1478 
    20 - 39% = 7808 
    40 - 59% = 30579 
    60 - 79% = 77905 
    80 - 99% = 51550 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11340, nodes: 9450745 
    Average node length: 5.37, total dup: 9145546, max dup: 185 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2042364, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 86 
        40 - 59% = 8865 
        60 - 79% = 2342 
        80 - 99% = 45 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13378, nodes: 9450745 
    Average node length: 6.23, total dup: 7832829, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1400416, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 144 
        20 - 39% = 4054 
        40 - 59% = 4280 
        60 - 79% = 2610 
        80 - 99% = 2290 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12669, nodes: 9450745 
    Average node length: 5.98, total dup: 8196041, max dup: 39 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2233298, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 107 
        40 - 59% = 9950 
        60 - 79% = 2559 
        80 - 99% = 53 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9948, nodes: 9450745 
    Average node length: 5.13, total dup: 9450645, max dup: 157984 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1451542, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1319 
        40 - 59% = 4891 
        60 - 79% = 1675 
        80 - 99% = 2019 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.23, total records: 11148856 
    Average version length: 82.51, total versions: 279748, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 116, data page slots: 187992 
    Data pages: 186840, average fill: 73% 
    Primary pages: 186840, secondary pages: 0, swept pages: 72402 
    Empty pages: 2532, full pages: 140697 
    Fill distribution: 
     0 - 19% = 4461 
    20 - 39% = 6995 
    40 - 59% = 17015 
    60 - 79% = 43860 
    80 - 99% = 114509 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13111, nodes: 11148856 
    Average node length: 5.29, total dup: 11039843, max dup: 636 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2326880, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 125 
        40 - 59% = 9717 
        60 - 79% = 3158 
        80 - 99% = 110 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10310, nodes: 11148856 
    Average node length: 5.48, total dup: 10661733, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 706844, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 154 
        20 - 39% = 872 
        40 - 59% = 2530 
        60 - 79% = 1839 
        80 - 99% = 4915 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14998, nodes: 11148856 
    Average node length: 6.01, total dup: 9727690, max dup: 69 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2343188, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 163 
        40 - 59% = 11311 
        60 - 79% = 3401 
        80 - 99% = 121 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10606, nodes: 11148856 
    Average node length: 5.21, total dup: 11148756, max dup: 189340 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 695272, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 849 
        40 - 59% = 4671 
        60 - 79% = 1461 
        80 - 99% = 3530 
 
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: 78.39, total records: 9804280 
    Average version length: 82.76, total versions: 514498, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 105, data page slots: 170712 
    Data pages: 170704, average fill: 71% 
    Primary pages: 170704, secondary pages: 0, swept pages: 92151 
    Empty pages: 240, full pages: 94766 
    Fill distribution: 
     0 - 19% = 903 
    20 - 39% = 4458 
    40 - 59% = 24066 
    60 - 79% = 83825 
    80 - 99% = 57452 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11856, nodes: 9804280 
    Average node length: 5.18, total dup: 9774510, max dup: 2115 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1941038, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1599 
        40 - 59% = 7654 
        60 - 79% = 1966 
        80 - 99% = 604 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13737, nodes: 9804280 
    Average node length: 6.25, total dup: 8126845, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1426962, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 182 
        20 - 39% = 3756 
        40 - 59% = 4823 
        60 - 79% = 2567 
        80 - 99% = 2409 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12472, nodes: 9804280 
    Average node length: 5.44, total dup: 9362548, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2072110, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1495 
        40 - 59% = 8620 
        60 - 79% = 1750 
        80 - 99% = 583 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10289, nodes: 9804280 
    Average node length: 5.15, total dup: 9804180, max dup: 162709 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1524480, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1245 
        40 - 59% = 5242 
        60 - 79% = 1704 
        80 - 99% = 2056 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 65.96, total records: 587696 
    Average version length: 68.81, total versions: 19056, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 5, data page slots: 7952 
    Data pages: 7952, average fill: 78% 
    Primary pages: 7952, secondary pages: 0, swept pages: 2020 
    Empty pages: 5, full pages: 7886 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 4 
    40 - 59% = 12 
    60 - 79% = 7453 
    80 - 99% = 478 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41435, depth: 3, leaf buckets: 754, nodes: 587696 
    Average node length: 5.95, total dup: 500442, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102472, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 14 
        40 - 59% = 557 
        60 - 79% = 107 
        80 - 99% = 76 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32707, depth: 3, leaf buckets: 767, nodes: 587696 
    Average node length: 6.15, total dup: 481997, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102547, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 15 
        40 - 59% = 541 
        60 - 79% = 116 
        80 - 99% = 94 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 565, nodes: 587696 
    Average node length: 4.86, total dup: 587596, max dup: 9646 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90818, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 339 
        60 - 79% = 90 
        80 - 99% = 129 
 
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  3 22:12:14 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7730354 79724 1 0.0000 0.0000
DOC_LIST 2232997 80612 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 236328 611 59000.0000 0.0000
INVNT_TURNOVER_LOG 76185 69539 1 0.0000 0.0000
MONEY_SALDO 49 18375 971 37500.0000 0.0000
MONEY_TURNOVER_LOG 1995 1550 1 0.0000 0.0000
PDISTR 815418 66002 6 0.0000 0.0000
PERF_SPLIT_0 164135 939 1 0.0000 0.0000
PERF_SPLIT_1 159686 3276 1 0.0000 0.0000
PERF_SPLIT_2 157649 2398 1 0.0000 0.0000
PERF_SPLIT_3 148653 3068 1 0.0000 0.0000
PERF_SPLIT_4 154652 3138 1 0.0000 0.0000
PERF_SPLIT_5 157899 1738 1 0.0000 0.0000
PERF_SPLIT_6 188066 17723 1 0.0000 0.0000
PERF_SPLIT_7 174705 3189 1 0.0000 0.0000
PERF_SPLIT_8 173089 2328 1 0.0000 0.0000
PERF_SPLIT_9 158474 3048 1 0.0000 0.0000
PSTORNED 2097499 42743 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 132383 60414 1 0.0000 0.0000
XQD_1000_3300 7079118 367514 1 0.0000 0.0000
XQD_1200_2000 12162102 347857 1 0.0000 0.0000
XQD_2000_3300 1609324 622531 1 0.0000 0.0000
XQD_2100_3300 1000581 408048 1 0.0000 0.0000
XQD_3300_3400 9131295 410153 1 0.0000 0.0000
XQS_1000_1200 21118067 9958 1 0.0000 0.0000
XQS_1000_3300 9450745 274332 1 0.0000 0.0000
XQS_1200_2000 11148856 279748 1 0.0000 0.0000
XQS_2100_3300 9804280 514498 1 0.0000 0.0000
XQS_3300_3400 587696 19056 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 ---
:128: 
:129: mscs-test-161.budzdorov.ru    Sun Mar  3 22:09:46 2024
:130:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:131: 
:132: 
:133: mscs-test-161.budzdorov.ru    Sun Mar  3 22:09:51 2024
:134:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:135: 
--- end of diff output ---

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

03.03.24 22:12:26. 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-03 22:12:28 No severe PSQL-related problems occured
03.03.24 22:12:29. End of report.