Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.02.2024 01: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 15920592 kB
MemAvailable 30261516 kB
Buffers 0 kB
Cached 15806584 kB
SwapCached 2732 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-02-17 01:09:39
DTS_END                         2024-02-17 01:09:39.8800
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57396
TRN_ID                          176353
ATT_ID                          574
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: 9031.07 22454 903107
customer order: creation 173.55 382 17355
customer order: refuse 15.18 380 1518
order to supplier: creation 46.42 1405 4642
order to supplier: removal 3.57 103856 357
invoice (draft): creation 45.91 3641 4591
invoice (draft): removal 47.87 924 4787
invoice accept: apply 42.19 22701 4219
invoice accept: cancel 43.41 1145 4341
customer reserve: creation 4052.92 217 405292
customer reserve: removal 4254.39 70 425439
realization accept: apply 85.63 216 8563
realization accept: cancel 87.24 127 8724
payment from customer: creation 61.59 133 6159
payment from customer: removal 5.65 108 565
payment to supplier: creation 49.56 175 4956
payment to supplier: removal 3.22 79 322
service: total inventory turnovers 5.31 979 531
service: total monetary turnovers 6.63 54 663
service: aggregate perf. data 0.80 17634 80
service: refresh index statistics 0.03 294854 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-02-2024 01:10:54 to 17-02-2024 01:10:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3553
TEST_TIME 2 3935
TEST_TIME 3 3195
TEST_TIME 4 4204
TEST_TIME 5 3817
TEST_TIME 6 4642
TEST_TIME 7 4626
TEST_TIME 8 4876
TEST_TIME 9 5063
TEST_TIME 10 5049
TEST_TIME 11 5587
TEST_TIME 12 5458
TEST_TIME 13 5520
TEST_TIME 14 5781
TEST_TIME 15 5817
TEST_TIME 16 5886
TEST_TIME 17 6141
TEST_TIME 18 6205
TEST_TIME 19 6625
TEST_TIME 20 7009
TEST_TIME 21 7212
TEST_TIME 22 7369
TEST_TIME 23 7474
TEST_TIME 24 7680
TEST_TIME 25 7681
TEST_TIME 26 7718
TEST_TIME 27 7795
TEST_TIME 28 8140
TEST_TIME 29 8952
TEST_TIME 30 9287
TEST_TIME 31 9369
TEST_TIME 32 9288
TEST_TIME 33 9288
TEST_TIME 34 9261
TEST_TIME 35 9262
TEST_TIME 36 9199
TEST_TIME 37 9075
TEST_TIME 38 9008
TEST_TIME 39 9007
TEST_TIME 40 9064
TEST_TIME 41 9001
TEST_TIME 42 8835
TEST_TIME 43 8925
TEST_TIME 44 8924
TEST_TIME 45 8786
TEST_TIME 46 8787
TEST_TIME 47 8785
TEST_TIME 48 8745
TEST_TIME 49 8655
TEST_TIME 50 8528
TEST_TIME 51 8531
TEST_TIME 52 8538
TEST_TIME 53 8559
TEST_TIME 54 8574
TEST_TIME 55 8652
TEST_TIME 56 8688
TEST_TIME 57 8713
TEST_TIME 58 8723
TEST_TIME 59 8715
TEST_TIME 60 8767
TEST_TIME 61 8826
TEST_TIME 62 8779
TEST_TIME 63 8945
TEST_TIME 64 8911
TEST_TIME 65 8915
TEST_TIME 66 8849
TEST_TIME 67 8808
TEST_TIME 68 8716
TEST_TIME 69 8712
TEST_TIME 70 8819
TEST_TIME 71 8739
TEST_TIME 72 8720
TEST_TIME 73 8803
TEST_TIME 74 8806
TEST_TIME 75 8805
TEST_TIME 76 8931
TEST_TIME 77 8863
TEST_TIME 78 8925
TEST_TIME 79 8911
TEST_TIME 80 8925
TEST_TIME 81 8927
TEST_TIME 82 8910
TEST_TIME 83 9041
TEST_TIME 84 9025
TEST_TIME 85 9037
TEST_TIME 86 9142
TEST_TIME 87 9157
TEST_TIME 88 9138
TEST_TIME 89 9055
TEST_TIME 90 9030
TEST_TIME 91 9067
TEST_TIME 92 9020
TEST_TIME 93 9011
TEST_TIME 94 8968
TEST_TIME 95 8938
TEST_TIME 96 8912
TEST_TIME 97 8924
TEST_TIME 98 9055
TEST_TIME 99 9059
TEST_TIME 100 9036

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-02-2024 01:10:58 to 17-02-2024 01:11:01.

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 1274610 1274610 0 0.00 0 20314 8 0 0
doc_list_biud 1274608 1274608 0 0.00 0 82869 30 0 0
sp_add_invoice_to_stock 4302 4219 83 1.92 38 173172 22701 0 83
sp_cancel_adding_invoice 4341 4341 0 0.00 4 91684 1145 0 0
sp_cancel_client_order 1518 1518 0 0.00 4 7905 381 0 0
sp_cancel_customer_reserve 425439 425439 0 0.00 0 26326 70 0 0
sp_cancel_pay_from_customer 565 565 0 0.00 3 4902 108 0 0
sp_cancel_pay_to_supplier 322 322 0 0.00 2 3750 80 0 0
sp_cancel_supplier_invoice 4795 4787 8 0.16 2 82878 925 0 8
sp_cancel_supplier_order 357 357 0 0.00 6 1066832 103857 0 0
sp_cancel_write_off 8724 8724 0 0.00 1 14765 127 0 0
sp_client_order 17355 17355 0 0.00 3 28266 382 0 0
sp_customer_reserve 405292 405292 0 0.00 0 40492 217 0 0
sp_fill_shopping_cart 26581 26581 0 0.00 1 21020 42 0 0
sp_fill_shopping_cart_clo_res 405287 405287 0 0.00 0 16254 15 0 0
sp_get_clo_for_invoice 4213 4213 0 0.00 0 23267 305 0 0
sp_kill_cost_storno 13952 13952 0 0.00 0 10183 66 0 0
sp_kill_qstorno_ret_qs2qd 864746 864746 0 0.00 0 82865 38 0 0
sp_kill_qty_storno 457941 457941 0 0.00 0 82868 82 0 0
sp_lock_selected_doc 17731 17731 0 0.00 0 11904 8 0 0
sp_make_cost_storno 23890 23890 0 0.00 0 16978 76 0 0
sp_multiply_rows_for_pdistr 23890 23890 0 0.00 0 10488 32 0 0
sp_multiply_rows_for_qdistr 17355 17355 0 0.00 0 14590 166 0 0
sp_pay_from_customer 6159 6159 0 0.00 4 21781 133 0 0
sp_pay_to_supplier 4956 4956 0 0.00 5 24612 176 0 0
sp_payment_common 11115 11115 0 0.00 2 10971 37 0 0
sp_qd_handle_on_cancel_clo 1518 1518 0 0.00 0 7063 339 0 0
sp_qd_handle_on_invoice_upd_sts 8553 8553 0 0.00 0 25448 386 0 0
sp_qd_handle_on_reserve_upd_sts 8563 8563 0 0.00 0 12737 66 0 0
sp_reserve_write_off 8563 8563 0 0.00 6 16984 217 0 0
sp_supplier_invoice 4591 4591 0 0.00 6 100083 3642 0 0
sp_supplier_order 4642 4642 0 0.00 5 97013 1406 0 0
srv_aggregate_perf_data 80 80 0 0.00 1954 252502 17635 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1663 108611 36452 0 0
srv_find_qd_qs_mism 860280 860280 0 0.00 0 20309 7 0 0
srv_make_invnt_saldo 531 531 0 0.00 50 40028 979 0 0
srv_make_money_saldo 663 663 0 0.00 0 10165 54 0 0
srv_recalc_idx_stat 3 3 0 0.00 225336 334326 294855 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4219 4219 0 0.00 0 23246 190 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 1 5023 138 0 0
t$perf-norm:sp_cancel_client_order 1518 1518 0 0.00 0 1660 13 0 0
t$perf-norm:sp_cancel_customer_reserve 550 550 0 0.00 0 1089 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 565 565 0 0.00 0 2121 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 322 322 0 0.00 0 1033 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 353 353 0 0.00 0 743 13 0 0
t$perf-norm:sp_cancel_supplier_order 357 357 0 0.00 0 26026 1790 0 0
t$perf-norm:sp_cancel_write_off 890 890 0 0.00 0 2704 12 0 0
t$perf-norm:sp_client_order 17355 17355 0 0.00 0 10250 17 0 0
t$perf-norm:sp_customer_reserve 853 853 0 0.00 0 5020 15 0 0
t$perf-norm:sp_pay_from_customer 6159 6159 0 0.00 0 4037 10 0 0
t$perf-norm:sp_pay_to_supplier 4956 4956 0 0.00 0 22176 18 0 0
t$perf-norm:sp_reserve_write_off 8563 8563 0 0.00 0 23668 13 0 0
t$perf-norm:sp_supplier_invoice 4591 4591 0 0.00 0 27661 25 0 0
t$perf-norm:sp_supplier_order 4642 4642 0 0.00 0 11300 18 0 0
t$perf-norm:srv_aggregate_perf_data 80 80 0 0.00 0 814 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 5 1 0 0
t$perf-norm:srv_make_invnt_saldo 531 531 0 0.00 0 638 18 0 0
t$perf-norm:srv_make_money_saldo 663 663 0 0.00 0 706 15 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 9 5 0 0
v_add_invoice_to_stock 8590 8424 166 1.93 0 10510 19 0 166
v_all_customers 32426 32426 0 0.00 0 102 1 0 0
v_all_suppliers 26362 26362 0 0.00 0 43 1 0 0
v_all_wares 34708 34708 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 3417 18 0 0
v_cancel_client_order 3036 3036 0 0.00 0 3414 7 0 0
v_cancel_customer_prepayment 1130 1130 0 0.00 0 2086 11 0 0
v_cancel_customer_reserve 1100 1100 0 0.00 0 3398 8 0 0
v_cancel_payment_to_supplier 644 644 0 0.00 0 2005 7 0 0
v_cancel_supplier_invoice 722 706 16 2.21 0 5754 30 0 16
v_cancel_supplier_order 714 714 0 0.00 0 2750 16 0 0
v_cancel_write_off 1780 1780 0 0.00 0 1806 13 0 0
v_max_id_clo_ord 4641 4641 0 0.00 0 1183 2 0 0
v_max_id_clo_res 853 853 0 0.00 0 4451 21 0 0
v_max_id_ord_sup 4586 4586 0 0.00 0 8587 4 0 0
v_max_non_paid_invoice 1002 1002 0 0.00 0 643 3 0 0
v_max_non_paid_realizn 2989 2989 0 0.00 0 3466 7 0 0
v_min_id_clo_ord 4641 4641 0 0.00 0 18990 17 0 0
v_min_id_clo_res 853 853 0 0.00 0 6158 25 0 0
v_min_id_ord_sup 4586 4586 0 0.00 0 5651 9 0 0
v_min_non_paid_invoice 4956 4956 0 0.00 0 9670 27 0 0
v_min_non_paid_realizn 6159 6159 0 0.00 0 10969 30 0 0
v_our_firm 8622 8622 0 0.00 0 17 1 0 0
v_reserve_write_off 17124 17124 0 0.00 0 12680 11 0 0
x_lock_depdocs_on_canc_invoice 8775 8775 0 0.00 0 24414 145 0 0
x_lock_depdocs_on_canc_sup_ord 357 357 0 0.00 0 35263 406 0 0
x_make_qstorno_1000_1200 4642 4642 0 0.00 2 96995 1314 0 0
x_make_qstorno_1200_2000 4591 4591 0 0.00 3 100064 3491 0 0
x_make_qstorno_2100_3300 405292 405292 0 0.00 0 37730 198 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-02-2024 01:11:02 to 17-02-2024 01:11:06.

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
23:09:44 41 8192000000 8825665648 8848052224 18094240 0.220 13 2 3 0 18249936 80752 74944
23:10:45 26229 8192000000 9906995904 10217209856 992266992 10.803 100 91 182 0 1021386208 5474640 23644576
23:12:25 11998 8192000000 9945303712 10265772032 1031263920 11.181 100 89 178 0 1061724464 7553104 22907440
23:13:42 17254 8192000000 9971285232 10301292544 1057969904 11.437 100 86 172 0 1089029792 9439680 21620208
23:15:04 16521 8192000000 10030986064 10382176256 1116060704 11.990 100 66 132 0 1140943904 9595104 15288096
23:16:23 6707 8192000000 10086188176 10448535552 1178397072 12.575 100 85 167 0 1209100288 12164592 18538624
23:17:32 4474 8192000000 10127678320 10500997120 1218991488 12.952 100 77 154 1 1248895152 12478192 17425472
23:18:40 2793 8192000000 10155458992 10534424576 1244446064 13.187 100 79 155 1 1273711520 12284672 16980784
23:19:44 1372 8192000000 10188026896 10566619136 1270889104 13.430 100 95 189 0 1306327952 13787312 21651536
23:20:47 1442 8192000000 10206643344 10590175232 1290574080 13.609 100 91 184 1 1323862128 12562240 20725808
23:21:50 2944 8192000000 10193502048 10597023744 1294199968 13.642 100 54 105 0 1315930832 10577552 11153312
23:22:53 5841 8192000000 10196872432 10602680320 1301651424 13.710 100 30 60 0 1315601808 7384256 6566128
23:24:02 8455 8192000000 10190759792 10606632960 1308739840 13.775 100 18 36 0 1318514928 5844624 3930464
23:25:11 52474 8192000000 10221118672 10626416640 1317392176 13.853 100 50 97 1 1334698656 5248624 12057856
23:27:04 7197 8192000000 10213319696 10637881344 1326115808 13.932 100 21 40 0 1336387008 5828736 4442464
23:28:12 5235 8192000000 10224633552 10644234240 1331657712 13.982 100 21 43 0 1343247536 6687456 4902368
23:29:24 10403 8192000000 10207887616 10627473408 1310977248 13.795 99 15 30 0 1319956032 5335952 3642832
23:30:41 28816 8192000000 10223138080 10633416704 1310242864 13.788 99 45 90 0 1329289648 8856064 10190720
23:32:29 67594 8192000000 10238014912 10651955200 1313588944 13.819 98 50 100 0 1336007808 10167776 12251088
23:34:42 9444 8192000000 10236004016 10643386368 1305469856 13.745 98 56 111 1 1328063104 10378304 12214944
23:35:56 6899 8192000000 10206811552 10609610752 1280517552 13.518 98 48 94 0 1308689216 17214320 10957344
23:37:16 22598 8192000000 10213837904 10615480320 1282270768 13.534 98 50 98 0 1311055648 17153840 11631040
23:39:02 12118 8192000000 10176650944 10570113024 1249030736 13.229 98 46 92 0 1276317744 16518128 10768880
23:40:19 25376 8192000000 10184206560 10583564288 1262446224 13.352 99 44 88 0 1292257696 19431840 10379632
23:42:18 1664 8192000000 10230767632 10618015744 1301383792 13.708 100 64 122 1 1334106016 18701792 14020432
23:43:25 11221 8192000000 10242148352 10641838080 1319698656 13.874 100 44 86 0 1350526208 20716560 10110992
23:44:40 3359 8192000000 10271146928 10662588416 1332542288 13.990 100 74 148 2 1377212656 27374048 17296320
23:45:48 1663 8192000000 10307989568 10700181504 1359905104 14.237 100 77 152 1 1410344304 32431088 18008112
23:46:55 1883 8192000000 10324909760 10721427456 1372759776 14.352 100 83 166 0 1426448256 33264496 20423984
23:48:03 4327 8192000000 10304666256 10708455424 1365361072 14.285 100 66 130 2 1411926960 31059808 15506080
23:49:11 2773 8192000000 10336249792 10739515392 1387408320 14.483 100 82 163 1 1442753648 35112544 20232784
23:50:18 20106 8192000000 10334002320 10754891776 1397139392 14.570 100 45 89 0 1444143360 35236256 11767712
23:51:51 16077 8192000000 10350797632 10772762624 1411721392 14.699 100 54 107 0 1458619648 33168784 13729472
23:53:26 8310 8192000000 10360381232 10788257792 1421961008 14.790 100 49 98 0 1465710144 31221920 12527216
23:54:58 9276 8192000000 10374172448 10803634176 1431757888 14.877 100 45 88 1 1480329088 36280512 12290688
23:56:26 5989 8192000000 10368880464 10801512448 1424890496 14.816 100 40 80 0 1474367248 38429824 11046928
23:57:35 24346 8192000000 10350352688 10806824960 1413649088 14.716 100 21 42 0 1464381680 43986432 6746160
23:59:00 26704 8192000000 10321900944 10781155328 1409162608 14.676 100 15 27 0 1437920976 25786544 2971824
00:00:30 76322 8192000000 10337614704 10780045312 1414015232 14.720 100 36 73 0 1436435200 13344048 9075920
00:02:49 26012 8192000000 10324633328 10777649152 1420175968 14.774 100 25 50 0 1436442592 10409616 5857008
00:04:22 24062 8192000000 10314156848 10780049408 1417191200 14.748 100 10 20 0 1431381296 11515648 2674448
00:05:49 56975 8192000000 10311946624 10771300352 1393346160 14.536 98 15 30 1 1403911984 7507872 3057952
00:07:57 37169 8192000000 10334566784 10791030784 1424805808 14.815 100 24 44 0 1447212512 16952272 5454432
00:10:33 108596 8192000000 10318303072 10769518592 1390920480 14.514 98 36 72 2 1406258512 7589360 7748672
00:13:27 73376 8192000000 10313207312 10775265280 1400693488 14.601 99 17 34 0 1415081920 10410848 3977584
00:15:42 13066 8192000000 10313220496 10758774784 1404122240 14.632 100 40 77 1 1420449520 8081408 8245872
00:16:58 57363 8192000000 10308978912 10766315520 1408927872 14.674 100 25 49 1 1424392768 9843392 5621504
00:18:57 78187 8192000000 10299860880 10766143488 1395450592 14.554 99 17 32 0 1410870080 11470928 3948560
00:21:15 42866 8192000000 10295052992 10761170944 1377491520 14.394 98 10 20 0 1387856816 8172000 2193296
00:22:58 56363 8192000000 10263446336 10713673728 1281082176 13.523 92 21 42 0 1294538736 8599408 4857152
00:24:55 60322 8192000000 10251644640 10704449536 1287082160 13.578 94 26 52 0 1303462768 10521840 5858768
00:26:56 23751 8192000000 10237484512 10671124480 1252366816 13.260 92 31 62 0 1268643232 9237408 7039008
00:28:23 7834 8192000000 10231785760 10662658048 1315750432 13.838 99 39 77 0 1333554944 10221856 7582656
00:29:35 48610 8192000000 10238041952 10693251072 1324153936 13.914 99 29 58 0 1346561744 15819312 6588496
00:31:33 24604 8192000000 10267346640 10692476928 1342498208 14.080 100 36 68 0 1363846000 13336384 8011408
00:32:59 31628 8192000000 10258500416 10695102464 1345800864 14.110 100 22 44 0 1363446080 12715184 4930032
00:34:31 100286 8192000000 10238540976 10686177280 1330343744 13.970 99 33 66 0 1347664912 9540064 7781104
00:37:12 46070 8192000000 10233714176 10657992704 1309921680 13.785 98 51 102 0 1335948000 15103808 10922512
00:39:04 30050 8192000000 10237733184 10683858944 1327536976 13.945 99 22 44 0 1348925040 16424480 4963584
00:40:41 70880 8192000000 10271756720 10719408128 1363997648 14.273 100 11 22 0 1382076240 15654816 2423776
00:42:58 29594 8192000000 10258046560 10700718080 1342330624 14.078 99 12 25 0 1355562000 11036432 2194944
00:44:28 29299 8192000000 10302119680 10735882240 1380220736 14.419 100 34 68 0 1398664224 10747840 7695648
00:46:03 67560 8192000000 10291338672 10738962432 1375361376 14.375 99 17 33 0 1390847232 11750720 3735136
00:48:16 38084 8192000000 10292497888 10736492544 1373245008 14.356 99 17 36 0 1384493360 7424624 3823728
00:49:59 27174 8192000000 10311078224 10757177344 1394193872 14.543 100 31 62 0 1409513952 8934560 6385520
00:51:28 74163 8192000000 10312082336 10787397632 1410616416 14.689 100 23 46 0 1435178256 18963728 5598112
00:53:43 30644 8192000000 10303763296 10750611456 1386468304 14.474 99 30 60 0 1410351344 17610528 6272512
00:55:20 48482 8192000000 10299145328 10760552448 1362937936 14.264 98 17 34 0 1387322992 20297552 4087504
00:57:20 25529 8192000000 10287880688 10729504768 1376206608 14.383 100 31 62 1 1391046416 7967424 6872384
00:58:50 54313 8192000000 10297355376 10740461568 1364097696 14.274 98 26 52 0 1378129248 8181408 5850144
01:00:45 66403 8192000000 10284843712 10740346880 1359919616 14.237 98 22 44 0 1379032352 14351024 4761712
01:02:52 61580 8192000000 10292933856 10751954944 1390768816 14.513 100 13 26 1 1408151984 13766960 3616208
01:04:56 56329 8192000000 10281587424 10730606592 1352477808 14.170 98 17 34 0 1374452480 17669776 4304896
01:06:52 39914 8192000000 10278858064 10743648256 1340053344 14.058 97 8 14 0 1364255584 22369104 1833136
01:08:35 60135 8192000000 10272781568 10712698880 1300390944 13.699 95 23 43 0 1315118128 10114592 4612592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 17-02-2024 01:11:08 to 17-02-2024 01:11:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 83 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-02-2024 01:11:23 to 17-02-2024 01:11:25.

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          175110
MON$OLDEST_ACTIVE               176812
MON$OLDEST_SNAPSHOT             176812
MON$NEXT_TRANSACTION            176812
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                       1894016
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.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sat Feb 17 01:11:26 2024 
 
Database header page information: 
    Flags            0 
    Generation        92243 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    175110 
    Oldest active        176812 
    Oldest snapshot        176812 
    Next transaction    176813 
    Sequence number        0 
    Next attachment ID    715 
    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.17, total records: 7810800 
    Average version length: 48.16, total versions: 118440, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86784 
    Data pages: 86784, average fill: 72% 
    Primary pages: 86784, secondary pages: 0, swept pages: 16105 
    Empty pages: 5, full pages: 64275 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 32 
    40 - 59% = 538 
    60 - 79% = 86173 
    80 - 99% = 28 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23393, nodes: 7810800 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1746294, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 374 
        20 - 39% = 1503 
        40 - 59% = 4429 
        60 - 79% = 2327 
        80 - 99% = 14760 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13548, nodes: 7810800 
    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: 1568793, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1411 
        40 - 59% = 2178 
        60 - 79% = 1083 
        80 - 99% = 8876 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8376, nodes: 7810800 
    Average node length: 6.63, total dup: 5823257, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1561987, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 777 
        40 - 59% = 1546 
        60 - 79% = 888 
        80 - 99% = 5014 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.91, total records: 2279038 
    Average version length: 34.92, total versions: 119134, max versions: 3 
    Average fragment length: 4.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28360 
    Data pages: 28360, average fill: 75% 
    Primary pages: 28355, secondary pages: 5, swept pages: 8453 
    Empty pages: 7, full pages: 22169 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 78 
    40 - 59% = 809 
    60 - 79% = 26232 
    80 - 99% = 1223 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4574, nodes: 2279038 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 708632, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 837 
        40 - 59% = 906 
        60 - 79% = 719 
        80 - 99% = 2112 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2532, nodes: 2282734 
    Average node length: 4.97, total dup: 2281835, max dup: 21061 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259516, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 247 
        40 - 59% = 1508 
        60 - 79% = 580 
        80 - 99% = 196 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2072, nodes: 2279038 
    Average node length: 4.97, total dup: 2278988, max dup: 130334 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1066412, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 41 
        40 - 59% = 1183 
        60 - 79% = 43 
        80 - 99% = 799 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4406, nodes: 2279038 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 708632, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 512 
        40 - 59% = 726 
        60 - 79% = 770 
        80 - 99% = 2276 
 
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.04, total records: 400 
    Average version length: 22.58, total versions: 252352, max versions: 659 
    Average fragment length: 2.00, total fragments: 71, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1440 
    Data pages: 1400, average fill: 89% 
    Primary pages: 9, secondary pages: 1391, swept pages: 0 
    Empty pages: 2, full pages: 1397 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1395 
 
    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: 3.91, total records: 146256 
    Average version length: 68.30, total versions: 137887, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 22.50 
    Pointer pages: 6, data page slots: 3024 
    Data pages: 2528, average fill: 73% 
    Primary pages: 2526, secondary pages: 2, swept pages: 0 
    Empty pages: 204, full pages: 1731 
    Fill distribution: 
     0 - 19% = 293 
    20 - 39% = 172 
    40 - 59% = 216 
    60 - 79% = 178 
    80 - 99% = 1669 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1711028, depth: 3, leaf buckets: 461, nodes: 146256 
    Average node length: 13.39, total dup: 12556, max dup: 3 
    Average key length: 10.52, compression ratio: 2.57 
    Average prefix length: 19.39, average data length: 7.61 
    Clustering factor: 106485, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 80 
        40 - 59% = 228 
        60 - 79% = 150 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 17796, max versions: 955 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 57 
 
    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: 2.24, total records: 2605 
    Average version length: 43.74, total versions: 2473, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 25.88 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 63% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 2, full pages: 18 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 87755, depth: 2, leaf buckets: 3, nodes: 2605 
    Average node length: 4.22, total dup: 2507, max dup: 268 
    Average key length: 2.41, compression ratio: 7.90 
    Average prefix length: 18.63, average data length: 0.37 
    Clustering factor: 1319, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.99, total records: 75 
    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: 52% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.87, total records: 818191 
    Average version length: 25.68, total versions: 77013, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8248 
    Data pages: 8248, average fill: 70% 
    Primary pages: 8223, secondary pages: 25, swept pages: 1520 
    Empty pages: 92, full pages: 7432 
    Fill distribution: 
     0 - 19% = 192 
    20 - 39% = 160 
    40 - 59% = 138 
    60 - 79% = 7428 
    80 - 99% = 330 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 904, nodes: 818191 
    Average node length: 4.87, total dup: 818142, max dup: 151486 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90746, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 123 
        40 - 59% = 515 
        60 - 79% = 210 
        80 - 99% = 56 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 990, nodes: 818191 
    Average node length: 5.88, total dup: 728269, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162557, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 85 
        40 - 59% = 516 
        60 - 79% = 126 
        80 - 99% = 259 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1027, nodes: 818191 
    Average node length: 5.88, total dup: 728269, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164649, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 192 
        40 - 59% = 476 
        60 - 79% = 100 
        80 - 99% = 259 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1143, nodes: 818191 
    Average node length: 5.96, total dup: 728269, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157512, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 242 
        40 - 59% = 585 
        60 - 79% = 223 
        80 - 99% = 92 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5425 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.79, total fragments: 63, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 71, secondary pages: 17, swept pages: 52 
    Empty pages: 6, full pages: 67 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5425 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.01 
    Average prefix length: 34.36, average data length: 1.55 
    Clustering factor: 5088, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 1 
        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: 5425 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 149, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 80958 
    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: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 780 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 780 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34865, depth: 2, leaf buckets: 103, nodes: 80958 
    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: 3415, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 102 
 
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.22, 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.20 
    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: 147.34, total records: 163792 
    Average version length: 154.00, total versions: 3754, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 6152 
    Data pages: 3968, average fill: 85% 
    Primary pages: 3967, secondary pages: 1, swept pages: 1 
    Empty pages: 71, full pages: 3860 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 12 
    40 - 59% = 13 
    60 - 79% = 8 
    80 - 99% = 3861 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.10, total records: 174602 
    Average version length: 150.31, total versions: 1089, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 7, data page slots: 4584 
    Data pages: 4232, average fill: 85% 
    Primary pages: 4232, secondary pages: 0, swept pages: 1 
    Empty pages: 86, full pages: 4130 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 1 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4129 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.00, total records: 164341 
    Average version length: 153.01, total versions: 3965, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 7, data page slots: 5240 
    Data pages: 3952, average fill: 86% 
    Primary pages: 3952, secondary pages: 0, swept pages: 2 
    Empty pages: 57, full pages: 3875 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 1 
    40 - 59% = 7 
    60 - 79% = 10 
    80 - 99% = 3874 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.99, total records: 157342 
    Average version length: 151.73, total versions: 1646, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 4640 
    Data pages: 3760, average fill: 86% 
    Primary pages: 3760, secondary pages: 0, swept pages: 2 
    Empty pages: 33, full pages: 3712 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3711 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 150.40, total records: 158479 
    Average version length: 148.71, total versions: 760, 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: 8, data page slots: 5280 
    Data pages: 3800, average fill: 86% 
    Primary pages: 3800, secondary pages: 0, swept pages: 1 
    Empty pages: 40, full pages: 3750 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3751 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.92, total records: 168221 
    Average version length: 153.07, total versions: 2215, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 6224 
    Data pages: 4040, average fill: 86% 
    Primary pages: 4040, secondary pages: 0, swept pages: 3 
    Empty pages: 47, full pages: 3977 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 3977 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.31, total records: 188670 
    Average version length: 152.70, total versions: 3520, 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: 7, data page slots: 5864 
    Data pages: 4536, average fill: 86% 
    Primary pages: 4536, secondary pages: 0, swept pages: 4 
    Empty pages: 52, full pages: 4463 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 4463 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 137.21, total records: 185471 
    Average version length: 155.12, total versions: 16607, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.36 
    Pointer pages: 7, data page slots: 5760 
    Data pages: 4480, average fill: 86% 
    Primary pages: 4480, secondary pages: 0, swept pages: 2 
    Empty pages: 69, full pages: 4387 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 11 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4386 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.94, total records: 175658 
    Average version length: 153.65, total versions: 6995, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 6, data page slots: 5384 
    Data pages: 4264, average fill: 85% 
    Primary pages: 4264, secondary pages: 0, swept pages: 1 
    Empty pages: 87, full pages: 4152 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 4151 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.87, total records: 160465 
    Average version length: 149.56, total versions: 1808, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 6144 
    Data pages: 3864, average fill: 85% 
    Primary pages: 3863, secondary pages: 1, swept pages: 7 
    Empty pages: 59, full pages: 3777 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 3 
    40 - 59% = 14 
    60 - 79% = 7 
    80 - 99% = 3777 
 
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.32, total records: 2119073 
    Average version length: 52.90, total versions: 57381, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25384 
    Data pages: 25384, average fill: 72% 
    Primary pages: 25384, secondary pages: 0, swept pages: 9926 
    Empty pages: 159, full pages: 20857 
    Fill distribution: 
     0 - 19% = 340 
    20 - 39% = 325 
    40 - 59% = 897 
    60 - 79% = 23304 
    80 - 99% = 518 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2600, nodes: 2119073 
    Average node length: 5.44, total dup: 1978005, max dup: 1416 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182429, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 275 
        40 - 59% = 1741 
        60 - 79% = 289 
        80 - 99% = 291 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2119073 
    Average node length: 5.69, total dup: 1902332, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 378361, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2378 
        60 - 79% = 349 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2135, nodes: 2119073 
    Average node length: 4.96, total dup: 2118973, max dup: 28728 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180415, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 154 
        40 - 59% = 1158 
        60 - 79% = 411 
        80 - 99% = 411 
 
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: 34.69, total records: 160728 
    Average version length: 69.16, total versions: 80184, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.63 
    Pointer pages: 3, data page slots: 4144 
    Data pages: 3152, average fill: 60% 
    Primary pages: 3152, secondary pages: 0, swept pages: 532 
    Empty pages: 710, full pages: 2139 
    Fill distribution: 
     0 - 19% = 866 
    20 - 39% = 21 
    40 - 59% = 42 
    60 - 79% = 613 
    80 - 99% = 1610 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 100218, depth: 3, leaf buckets: 222, nodes: 160728 
    Average node length: 6.45, total dup: 139915, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27344, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 15 
        40 - 59% = 106 
        60 - 79% = 75 
        80 - 99% = 25 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.31, total records: 7039396 
    Average version length: 68.80, total versions: 372136, 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: 62, data page slots: 100064 
    Data pages: 100064, average fill: 75% 
    Primary pages: 100064, secondary pages: 0, swept pages: 23031 
    Empty pages: 38, full pages: 84346 
    Fill distribution: 
     0 - 19% = 246 
    20 - 39% = 849 
    40 - 59% = 4363 
    60 - 79% = 87786 
    80 - 99% = 6820 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10631, nodes: 7039396 
    Average node length: 6.51, total dup: 6088920, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1578008, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1667 
        40 - 59% = 5811 
        60 - 79% = 2575 
        80 - 99% = 574 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8419, nodes: 7039396 
    Average node length: 5.40, total dup: 6758969, max dup: 147 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1370063, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1181 
        40 - 59% = 4560 
        60 - 79% = 1548 
        80 - 99% = 1119 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8476, nodes: 7039396 
    Average node length: 5.40, total dup: 6758969, max dup: 147 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1372588, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1206 
        40 - 59% = 4599 
        60 - 79% = 1562 
        80 - 99% = 1105 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.11, total records: 11917622 
    Average version length: 68.73, total versions: 318283, 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: 101, data page slots: 164576 
    Data pages: 164576, average fill: 77% 
    Primary pages: 164576, secondary pages: 0, swept pages: 73313 
    Empty pages: 7, full pages: 157729 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 254 
    40 - 59% = 1886 
    60 - 79% = 155609 
    80 - 99% = 6806 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18197, nodes: 11917622 
    Average node length: 6.56, total dup: 10390224, max dup: 62 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2365759, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 2466 
        40 - 59% = 10742 
        60 - 79% = 4116 
        80 - 99% = 854 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.37, total records: 1776590 
    Average version length: 69.12, total versions: 713822, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.05 
    Pointer pages: 27, data page slots: 43088 
    Data pages: 30056, average fill: 68% 
    Primary pages: 30056, secondary pages: 0, swept pages: 6669 
    Empty pages: 2269, full pages: 21331 
    Fill distribution: 
     0 - 19% = 3836 
    20 - 39% = 1858 
    40 - 59% = 1729 
    60 - 79% = 10724 
    80 - 99% = 11909 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2268, nodes: 1776590 
    Average node length: 5.50, total dup: 1705109, max dup: 99 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 121431, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 424 
        40 - 59% = 1122 
        60 - 79% = 540 
        80 - 99% = 175 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.53, total records: 1340542 
    Average version length: 69.13, total versions: 650408, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.55 
    Pointer pages: 22, data page slots: 35480 
    Data pages: 27104, average fill: 58% 
    Primary pages: 27104, secondary pages: 0, swept pages: 5748 
    Empty pages: 6030, full pages: 17320 
    Fill distribution: 
     0 - 19% = 7950 
    20 - 39% = 640 
    40 - 59% = 458 
    60 - 79% = 4259 
    80 - 99% = 13797 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1653, nodes: 1340542 
    Average node length: 5.76, total dup: 1254466, max dup: 109 
    Average key length: 2.82, compression ratio: 14.91 
    Average prefix length: 41.25, average data length: 0.75 
    Clustering factor: 190534, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 148 
        40 - 59% = 816 
        60 - 79% = 496 
        80 - 99% = 187 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.54, total records: 9408363 
    Average version length: 68.96, total versions: 594866, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 88, data page slots: 142504 
    Data pages: 142480, average fill: 71% 
    Primary pages: 142479, secondary pages: 1, swept pages: 47330 
    Empty pages: 184, full pages: 81198 
    Fill distribution: 
     0 - 19% = 633 
    20 - 39% = 2916 
    40 - 59% = 16954 
    60 - 79% = 112447 
    80 - 99% = 9530 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13533, nodes: 9408363 
    Average node length: 6.67, total dup: 7803863, max dup: 29 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2055653, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1005 
        40 - 59% = 6799 
        60 - 79% = 4973 
        80 - 99% = 753 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21167208 
    Average version length: 82.88, total versions: 12166, 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: 319032 
    Data pages: 319032, average fill: 81% 
    Primary pages: 319032, secondary pages: 0, swept pages: 13008 
    Empty pages: 17, full pages: 318207 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 36 
    40 - 59% = 108 
    60 - 79% = 27688 
    80 - 99% = 291171 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19605, nodes: 21167208 
    Average node length: 5.72, total dup: 20685885, max dup: 135 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3283206, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8564 
        60 - 79% = 546 
        80 - 99% = 10489 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17219, nodes: 21167208 
    Average node length: 6.31, total dup: 18601406, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915139, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 837 
        60 - 79% = 283 
        80 - 99% = 16093 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21363, nodes: 21167208 
    Average node length: 6.35, total dup: 18520793, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578263, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8752 
        60 - 79% = 636 
        80 - 99% = 11968 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16138, nodes: 21167208 
    Average node length: 5.56, total dup: 21167108, max dup: 230700 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943895, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2932 
        60 - 79% = 418 
        80 - 99% = 12780 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.80, total records: 9815335 
    Average version length: 82.62, total versions: 550697, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 102, data page slots: 166296 
    Data pages: 166272, average fill: 73% 
    Primary pages: 166272, secondary pages: 0, swept pages: 64412 
    Empty pages: 268, full pages: 104715 
    Fill distribution: 
     0 - 19% = 875 
    20 - 39% = 3256 
    40 - 59% = 17630 
    60 - 79% = 81601 
    80 - 99% = 62910 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11359, nodes: 9815335 
    Average node length: 5.36, total dup: 9505208, max dup: 203 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2209977, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 37 
        40 - 59% = 7835 
        60 - 79% = 3365 
        80 - 99% = 119 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13636, nodes: 9815335 
    Average node length: 6.23, total dup: 8137626, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1553353, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 3811 
        40 - 59% = 4657 
        60 - 79% = 2540 
        80 - 99% = 2500 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12684, nodes: 9815335 
    Average node length: 5.98, total dup: 8518454, max dup: 40 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2398781, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 54 
        40 - 59% = 8853 
        60 - 79% = 3618 
        80 - 99% = 157 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10267, nodes: 9815335 
    Average node length: 5.13, total dup: 9815235, max dup: 165204 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1578502, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1247 
        40 - 59% = 5059 
        60 - 79% = 1810 
        80 - 99% = 2110 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.06, total records: 11590107 
    Average version length: 82.52, total versions: 456933, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 117, data page slots: 190264 
    Data pages: 189088, average fill: 75% 
    Primary pages: 189088, secondary pages: 0, swept pages: 59845 
    Empty pages: 1660, full pages: 152289 
    Fill distribution: 
     0 - 19% = 2946 
    20 - 39% = 5168 
    40 - 59% = 13292 
    60 - 79% = 41685 
    80 - 99% = 125997 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13133, nodes: 11590107 
    Average node length: 5.32, total dup: 11480027, max dup: 668 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2427858, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 77 
        40 - 59% = 8291 
        60 - 79% = 4562 
        80 - 99% = 201 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10647, nodes: 11590107 
    Average node length: 5.51, total dup: 11085373, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 740583, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 158 
        20 - 39% = 786 
        40 - 59% = 2591 
        60 - 79% = 1888 
        80 - 99% = 5224 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15019, nodes: 11590107 
    Average node length: 6.04, total dup: 10121431, max dup: 75 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2444336, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 112 
        40 - 59% = 9733 
        60 - 79% = 4916 
        80 - 99% = 255 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10961, nodes: 11590107 
    Average node length: 5.24, total dup: 11590007, max dup: 200380 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 727941, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 93 
        20 - 39% = 776 
        40 - 59% = 4807 
        60 - 79% = 1544 
        80 - 99% = 3741 
 
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.16, total records: 9929723 
    Average version length: 82.92, total versions: 549451, 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: 170304 
    Data pages: 170232, average fill: 72% 
    Primary pages: 170232, secondary pages: 0, swept pages: 67552 
    Empty pages: 358, full pages: 103424 
    Fill distribution: 
     0 - 19% = 1052 
    20 - 39% = 3862 
    40 - 59% = 19323 
    60 - 79% = 85964 
    80 - 99% = 60031 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11963, nodes: 9929723 
    Average node length: 5.18, total dup: 9900920, max dup: 1533 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2014222, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1462 
        40 - 59% = 7965 
        60 - 79% = 1896 
        80 - 99% = 604 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13788, nodes: 9929723 
    Average node length: 6.25, total dup: 8231860, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1515895, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 212 
        20 - 39% = 3786 
        40 - 59% = 4599 
        60 - 79% = 2590 
        80 - 99% = 2601 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12593, nodes: 9929723 
    Average node length: 5.43, total dup: 9487430, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2147401, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1364 
        40 - 59% = 8896 
        60 - 79% = 1715 
        80 - 99% = 581 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10494, nodes: 9929723 
    Average node length: 5.15, total dup: 9929623, max dup: 167728 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1604946, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1277 
        40 - 59% = 5393 
        60 - 79% = 1666 
        80 - 99% = 2115 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.02, total records: 576493 
    Average version length: 68.85, total versions: 9718, 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: 5, data page slots: 7952 
    Data pages: 7952, average fill: 76% 
    Primary pages: 7952, secondary pages: 0, swept pages: 3453 
    Empty pages: 4, full pages: 6895 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 8 
    40 - 59% = 104 
    60 - 79% = 7661 
    80 - 99% = 173 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 36945, depth: 3, leaf buckets: 737, nodes: 576493 
    Average node length: 5.95, total dup: 490847, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100549, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 514 
        60 - 79% = 107 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30779, depth: 3, leaf buckets: 756, nodes: 576493 
    Average node length: 6.15, total dup: 472825, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100598, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 534 
        60 - 79% = 99 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 571, nodes: 576493 
    Average node length: 4.86, total dup: 576393, max dup: 9540 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89442, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 337 
        60 - 79% = 104 
        80 - 99% = 107 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Feb 17 01:11:50 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7810800 118440 1 0.0000 0.0000
DOC_LIST 2279038 119134 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 252352 659 63000.0000 0.0000
INVNT_TURNOVER_LOG 146256 137887 1 0.0000 0.0000
MONEY_SALDO 49 17796 955 36300.0000 0.0000
MONEY_TURNOVER_LOG 2605 2473 1 0.0000 0.0000
PDISTR 818191 77013 4 0.0000 0.0000
PERF_SPLIT_0 163792 3754 1 0.0000 0.0000
PERF_SPLIT_1 174602 1089 1 0.0000 0.0000
PERF_SPLIT_2 164341 3965 1 0.0000 0.0000
PERF_SPLIT_3 157342 1646 1 0.0000 0.0000
PERF_SPLIT_4 158479 760 1 0.0000 0.0000
PERF_SPLIT_5 168221 2215 1 0.0000 0.0000
PERF_SPLIT_6 188670 3520 1 0.0000 0.0000
PERF_SPLIT_7 185471 16607 1 0.0000 0.0000
PERF_SPLIT_8 175658 6995 1 0.0000 0.0000
PERF_SPLIT_9 160465 1808 1 0.0000 0.0000
PSTORNED 2119073 57381 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 160728 80184 1 0.0000 0.0000
XQD_1000_3300 7039396 372136 1 0.0000 0.0000
XQD_1200_2000 11917622 318283 1 0.0000 0.0000
XQD_2000_3300 1776590 713822 1 0.0000 0.0000
XQD_2100_3300 1340542 650408 1 0.0000 0.0000
XQD_3300_3400 9408363 594866 1 0.0000 0.0000
XQS_1000_1200 21167208 12166 1 0.0000 0.0000
XQS_1000_3300 9815335 550697 1 0.0000 0.0000
XQS_1200_2000 11590107 456933 1 0.0000 0.0000
XQS_2100_3300 9929723 549451 1 0.0000 0.0000
XQS_3300_3400 576493 9718 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 ---
--- end of diff output ---

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

17.02.24 01:12:02. 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-02-17 01:12:04 No severe PSQL-related problems occured
17.02.24 01:12:06. End of report.