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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-05 04:07:49
DTS_END                         2024-04-05 04:07:49.5380
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(68:17)
IP                              ::1/60468
TRN_ID                          177556
ATT_ID                          570
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: 8845.24 19177 884524
customer order: creation 186.36 425 18636
customer order: refuse 15.30 328 1530
order to supplier: creation 49.72 1266 4972
order to supplier: removal 3.35 81570 335
invoice (draft): creation 49.15 3110 4915
invoice (draft): removal 44.90 746 4490
invoice accept: apply 44.22 19683 4422
invoice accept: cancel 40.15 782 4015
customer reserve: creation 4199.26 191 419926
customer reserve: removal 3903.76 55 390376
realization accept: apply 90.25 179 9025
realization accept: cancel 82.01 116 8201
payment from customer: creation 63.67 119 6367
payment from customer: removal 5.80 91 580
payment to supplier: creation 51.87 129 5187
payment to supplier: removal 3.61 58 361
service: total inventory turnovers 3.91 3618 391
service: total monetary turnovers 6.93 471 693
service: aggregate perf. data 0.99 12390 99
service: refresh index statistics 0.03 258214 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-04-2024 04:08:55 to 05-04-2024 04:08:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3998
TEST_TIME 2 4050
TEST_TIME 3 5145
TEST_TIME 4 4462
TEST_TIME 5 3955
TEST_TIME 6 4545
TEST_TIME 7 4477
TEST_TIME 8 4675
TEST_TIME 9 5052
TEST_TIME 10 5289
TEST_TIME 11 5487
TEST_TIME 12 5960
TEST_TIME 13 6117
TEST_TIME 14 6551
TEST_TIME 15 6935
TEST_TIME 16 7774
TEST_TIME 17 8026
TEST_TIME 18 8367
TEST_TIME 19 8527
TEST_TIME 20 9138
TEST_TIME 21 9084
TEST_TIME 22 9269
TEST_TIME 23 9965
TEST_TIME 24 9575
TEST_TIME 25 9346
TEST_TIME 26 9399
TEST_TIME 27 9404
TEST_TIME 28 9439
TEST_TIME 29 9272
TEST_TIME 30 9247
TEST_TIME 31 9134
TEST_TIME 32 8875
TEST_TIME 33 8771
TEST_TIME 34 8783
TEST_TIME 35 8736
TEST_TIME 36 8761
TEST_TIME 37 8604
TEST_TIME 38 8638
TEST_TIME 39 8700
TEST_TIME 40 8600
TEST_TIME 41 8691
TEST_TIME 42 8705
TEST_TIME 43 8800
TEST_TIME 44 8801
TEST_TIME 45 8937
TEST_TIME 46 8881
TEST_TIME 47 8932
TEST_TIME 48 8994
TEST_TIME 49 9060
TEST_TIME 50 8986
TEST_TIME 51 8970
TEST_TIME 52 8840
TEST_TIME 53 8759
TEST_TIME 54 8686
TEST_TIME 55 8645
TEST_TIME 56 8645
TEST_TIME 57 8611
TEST_TIME 58 8563
TEST_TIME 59 8663
TEST_TIME 60 8658
TEST_TIME 61 8672
TEST_TIME 62 8712
TEST_TIME 63 8653
TEST_TIME 64 8850
TEST_TIME 65 8848
TEST_TIME 66 8860
TEST_TIME 67 8875
TEST_TIME 68 8928
TEST_TIME 69 8874
TEST_TIME 70 8771
TEST_TIME 71 8799
TEST_TIME 72 8759
TEST_TIME 73 8733
TEST_TIME 74 8710
TEST_TIME 75 8746
TEST_TIME 76 8729
TEST_TIME 77 8728
TEST_TIME 78 8721
TEST_TIME 79 8809
TEST_TIME 80 8798
TEST_TIME 81 8782
TEST_TIME 82 8905
TEST_TIME 83 8910
TEST_TIME 84 8944
TEST_TIME 85 8940
TEST_TIME 86 9048
TEST_TIME 87 9020
TEST_TIME 88 8931
TEST_TIME 89 8917
TEST_TIME 90 8915
TEST_TIME 91 8856
TEST_TIME 92 8830
TEST_TIME 93 8785
TEST_TIME 94 8828
TEST_TIME 95 8824
TEST_TIME 96 8816
TEST_TIME 97 8846
TEST_TIME 98 8817
TEST_TIME 99 8853
TEST_TIME 100 8850

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-04-2024 04:08:59 to 05-04-2024 04:09:02.

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 1267642 1267642 0 0.00 0 22862 7 0 0
doc_list_biud 1267642 1267642 0 0.00 0 29607 22 0 0
sp_add_invoice_to_stock 4528 4422 106 2.34 40 210451 19683 0 106
sp_cancel_adding_invoice 4015 4015 0 0.00 3 59205 783 0 0
sp_cancel_client_order 1530 1530 0 0.00 4 8427 328 0 0
sp_cancel_customer_reserve 390376 390376 0 0.00 0 16508 56 0 0
sp_cancel_pay_from_customer 580 580 0 0.00 2 11335 92 0 0
sp_cancel_pay_to_supplier 361 361 0 0.00 2 1505 58 0 0
sp_cancel_supplier_invoice 4497 4490 7 0.15 1 23703 747 0 7
sp_cancel_supplier_order 335 335 0 0.00 7 891879 81571 0 0
sp_cancel_write_off 8201 8201 0 0.00 1 24192 116 0 0
sp_client_order 18636 18636 0 0.00 3 28588 425 0 0
sp_customer_reserve 419926 419926 0 0.00 0 100842 192 0 0
sp_fill_shopping_cart 28522 28522 0 0.00 1 11266 39 0 0
sp_fill_shopping_cart_clo_res 419918 419918 0 0.00 0 22288 18 0 0
sp_get_clo_for_invoice 4413 4413 0 0.00 0 33432 418 0 0
sp_kill_cost_storno 13157 13157 0 0.00 0 11310 60 0 0
sp_kill_qstorno_ret_qs2qd 793778 793778 0 0.00 0 24157 31 0 0
sp_kill_qty_storno 422385 422385 0 0.00 0 29607 66 0 0
sp_lock_selected_doc 18484 18484 0 0.00 0 7665 5 0 0
sp_make_cost_storno 24992 24992 0 0.00 0 18198 57 0 0
sp_multiply_rows_for_pdistr 24992 24992 0 0.00 0 10983 35 0 0
sp_multiply_rows_for_qdistr 18636 18636 0 0.00 0 17162 238 0 0
sp_pay_from_customer 6367 6367 0 0.00 3 13518 120 0 0
sp_pay_to_supplier 5187 5187 0 0.00 4 12619 129 0 0
sp_payment_common 11554 11554 0 0.00 1 10952 27 0 0
sp_qd_handle_on_cancel_clo 1530 1530 0 0.00 0 8420 306 0 0
sp_qd_handle_on_invoice_upd_sts 8428 8428 0 0.00 0 29607 272 0 0
sp_qd_handle_on_reserve_upd_sts 9025 9025 0 0.00 0 20756 49 0 0
sp_reserve_write_off 9025 9025 0 0.00 5 29309 180 0 0
sp_supplier_invoice 4915 4915 0 0.00 6 76830 3110 0 0
sp_supplier_order 4972 4972 0 0.00 5 35152 1266 0 0
srv_aggregate_perf_data 99 99 0 0.00 1749 91195 12391 0 0
srv_fill_mon_cache_memory 51 51 0 0.00 2655 132327 49885 0 0
srv_find_qd_qs_mism 838769 838769 0 0.00 0 17577 7 0 0
srv_make_invnt_saldo 391 391 0 0.00 38 87844 3619 0 0
srv_make_money_saldo 693 693 0 0.00 1 34094 472 0 0
srv_recalc_idx_stat 3 3 0 0.00 180911 351079 258214 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4422 4422 0 0.00 0 10169 139 0 0
t$perf-norm:sp_cancel_adding_invoice 328 328 0 0.00 0 3487 95 0 0
t$perf-norm:sp_cancel_client_order 1530 1530 0 0.00 0 1834 12 0 0
t$perf-norm:sp_cancel_customer_reserve 605 605 0 0.00 0 626 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 580 580 0 0.00 0 1838 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 361 361 0 0.00 0 462 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 365 365 0 0.00 0 2763 20 0 0
t$perf-norm:sp_cancel_supplier_order 335 335 0 0.00 0 21371 1366 0 0
t$perf-norm:sp_cancel_write_off 942 942 0 0.00 0 2890 15 0 0
t$perf-norm:sp_client_order 18636 18636 0 0.00 0 14883 13 0 0
t$perf-norm:sp_customer_reserve 902 902 0 0.00 0 3281 9 0 0
t$perf-norm:sp_pay_from_customer 6367 6367 0 0.00 0 3470 10 0 0
t$perf-norm:sp_pay_to_supplier 5187 5187 0 0.00 0 9822 10 0 0
t$perf-norm:sp_reserve_write_off 9025 9025 0 0.00 0 10086 10 0 0
t$perf-norm:sp_supplier_invoice 4915 4915 0 0.00 0 2527 9 0 0
t$perf-norm:sp_supplier_order 4972 4972 0 0.00 0 3842 11 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 904 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 51 51 0 0.00 0 133 4 0 0
t$perf-norm:srv_make_invnt_saldo 391 391 0 0.00 0 1905 9 0 0
t$perf-norm:srv_make_money_saldo 693 693 0 0.00 0 1820 8 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 5 102 38 0 0
v_add_invoice_to_stock 9038 8826 212 2.34 0 8094 16 0 212
v_all_customers 34560 34560 0 0.00 0 81 0 0 0
v_all_suppliers 27704 27704 0 0.00 0 80 1 0 0
v_all_wares 37272 37272 0 0.00 0 83 1 0 0
v_cancel_adding_invoice 656 656 0 0.00 0 742 8 0 0
v_cancel_client_order 3060 3060 0 0.00 0 903 3 0 0
v_cancel_customer_prepayment 1160 1160 0 0.00 0 756 4 0 0
v_cancel_customer_reserve 1210 1210 0 0.00 0 654 4 0 0
v_cancel_payment_to_supplier 722 722 0 0.00 0 425 4 0 0
v_cancel_supplier_invoice 744 730 14 1.88 0 3371 17 0 14
v_cancel_supplier_order 670 670 0 0.00 0 5286 16 0 0
v_cancel_write_off 1884 1884 0 0.00 0 6055 16 0 0
v_max_id_clo_ord 4972 4972 0 0.00 0 532 1 0 0
v_max_id_clo_res 902 902 0 0.00 0 2272 15 0 0
v_max_id_ord_sup 4914 4914 0 0.00 0 3339 5 0 0
v_max_non_paid_invoice 1221 1221 0 0.00 0 236 2 0 0
v_max_non_paid_realizn 3032 3032 0 0.00 0 2066 3 0 0
v_min_id_clo_ord 4972 4972 0 0.00 0 6564 4 0 0
v_min_id_clo_res 902 902 0 0.00 0 4620 19 0 0
v_min_id_ord_sup 4914 4914 0 0.00 0 7374 9 0 0
v_min_non_paid_invoice 5187 5187 0 0.00 0 10939 21 0 0
v_min_non_paid_realizn 6367 6367 0 0.00 0 10946 20 0 0
v_our_firm 9382 9382 0 0.00 0 22 1 0 0
v_reserve_write_off 18050 18050 0 0.00 0 5269 6 0 0
x_lock_depdocs_on_canc_invoice 8140 8140 0 0.00 0 16265 109 0 0
x_lock_depdocs_on_canc_sup_ord 335 335 0 0.00 0 12118 337 0 0
x_make_qstorno_1000_1200 4972 4972 0 0.00 1 35089 1200 0 0
x_make_qstorno_1200_2000 4915 4915 0 0.00 3 76825 2952 0 0
x_make_qstorno_2100_3300 419926 419926 0 0.00 0 100839 172 0 0

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

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
02:07:53 1188 8192000000 8961232000 9027870720 17291232 0.210 4 2 5 0 17745312 124480 329600
02:08:56 21831 8192000000 9692834912 9990914048 773603744 8.628 100 85 170 0 801671440 7590784 20476912
02:10:24 14615 8192000000 9756594688 10067439616 837322528 9.273 100 88 176 0 867841328 10333680 20185120
02:11:54 9095 8192000000 9791293600 10111029248 863890016 9.539 100 85 170 0 899052544 15897936 19264592
02:13:08 12993 8192000000 9831248624 10163286016 899353104 9.892 100 81 162 1 942880784 26160272 17367408
02:14:26 7272 8192000000 9887225984 10228408320 928208480 10.177 100 78 156 0 1000388496 56131360 16048656
02:15:37 5230 8192000000 9940905696 10290196480 958225312 10.472 100 86 173 0 1051526720 75665600 17635808
02:16:47 5062 8192000000 9970300064 10329444352 995982720 10.840 100 78 149 0 1079489680 69374848 14132112
02:17:53 1631 8192000000 9982262096 10350055424 1027692656 11.146 100 73 143 0 1104745376 62925824 14126896
02:18:57 1657 8192000000 10032544448 10404376576 1053202736 11.391 100 87 174 1 1138509696 69064240 16242720
02:20:00 3054 8192000000 10033298432 10418388992 1065982016 11.514 100 62 124 0 1137468768 59439600 12047152
02:21:19 3039 8192000000 10017844944 10423099392 1071739792 11.569 100 41 79 1 1144934896 65028480 8166624
02:22:25 4738 8192000000 10007115152 10394980352 1075679440 11.606 100 47 96 0 1107367184 22603968 9083776
02:23:30 4717 8192000000 9988233696 10390671360 1079666192 11.644 100 36 73 0 1108208384 21217840 7324352
02:24:36 49013 8192000000 10000069568 10401058816 1084178256 11.687 100 44 88 0 1113832704 20229472 9424976
02:26:26 3769 8192000000 10005643488 10408423424 1086277424 11.707 100 37 74 0 1119057184 24801424 7978336
02:27:32 5977 8192000000 9988220848 10388463616 1060908560 11.465 98 25 50 0 1088787040 22005664 5872816
02:28:46 46117 8192000000 10023385536 10417598464 1068714544 11.540 99 50 100 0 1128443600 50139536 9589520
02:30:38 132325 8192000000 10083986176 10499948544 1085780160 11.703 98 38 74 1 1154093296 60479792 7833344
02:34:10 17411 8192000000 10126352224 10524725248 1096834432 11.808 99 57 113 0 1217433760 109875072 10724256
02:35:30 28314 8192000000 10129885536 10535981056 1087205376 11.716 98 36 72 0 1222900528 128190720 7504432
02:37:05 40426 8192000000 10166401584 10588045312 1091363808 11.756 97 41 81 0 1244406816 144530512 8512496
02:38:49 13310 8192000000 10227793568 10642722816 1124789040 12.072 100 48 96 0 1322520048 187126560 10604448
02:40:04 6638 8192000000 10238924736 10635632640 1106985824 11.904 100 57 113 0 1341233360 220907520 13340016
02:41:14 12609 8192000000 10243527568 10634547200 1073521968 11.586 97 64 124 0 1331394048 243821392 14050688
02:42:30 5663 8192000000 10252354672 10659708928 1110584496 11.938 100 62 124 0 1356110688 232023808 13502384
02:43:44 13832 8192000000 10204215360 10628837376 1094676304 11.787 100 41 81 1 1333002240 228454880 9871056
02:45:02 5465 8192000000 10184443648 10614173696 1087771136 11.721 99 50 100 0 1268436544 169168688 11496720
02:46:12 20645 8192000000 10186893360 10627006464 1096459488 11.804 100 29 57 1 1308924608 206154720 6310400
02:47:57 19680 8192000000 10141446528 10570858496 1090623488 11.749 99 22 44 0 1228029056 132934192 4471376
02:49:19 17072 8192000000 10143142560 10567704576 1092749280 11.769 100 24 48 0 1244573952 146498992 5325680
02:50:40 27219 8192000000 10057679888 10472304640 1115208752 11.982 100 31 60 3 1150120976 29141136 5771088
02:52:07 53084 8192000000 10126020320 10556895232 1122208512 12.048 100 39 78 1 1208634272 78157904 8267856
02:55:05 35782 8192000000 10045855120 10498260992 1123258704 12.058 100 16 32 0 1182749552 56712512 2778336
02:56:41 74372 8192000000 10056811776 10501349376 1125874496 12.082 100 11 21 0 1164798896 36645696 2278704
02:58:57 117075 8192000000 10068353392 10518073344 1139609168 12.212 100 28 56 0 1187852400 42330720 5912512
03:01:59 33094 8192000000 10077659680 10510102528 1137184176 12.189 100 32 63 1 1193765328 49411008 7170144
03:03:36 58444 8192000000 10070930448 10541985792 1138827072 12.204 100 13 26 0 1189144704 47596336 2721296
03:05:35 51728 8192000000 10080902960 10534285312 1141936736 12.234 100 7 14 0 1183090928 39609136 1545056
03:07:30 46348 8192000000 10102351040 10552762368 1156792912 12.373 100 24 48 1 1217867712 56186752 4888048
03:09:17 86403 8192000000 10059864112 10502205440 1143039376 12.244 99 16 32 1 1193197360 46784048 3373936
03:11:47 91521 8192000000 10054467168 10518306816 1101242912 11.849 96 10 20 0 1143476096 40528528 1704656
03:14:20 104791 8192000000 10057034624 10529251328 1046934224 11.331 92 10 20 0 1124407536 75524192 1949120
03:17:06 64298 8192000000 10090595088 10529927168 1134270656 12.162 100 22 44 1 1185579792 46660848 4648288
03:19:18 91887 8192000000 10054550800 10496708608 1110547440 11.938 99 29 58 0 1143311744 27273648 5490656
03:22:19 2655 8192000000 10073006160 10496311296 1119527696 12.023 100 48 92 0 1173947552 45121216 9298640
03:23:33 39124 8192000000 10076473168 10519461888 1068666304 11.539 96 34 68 0 1171465008 96427808 6370896
03:25:14 46774 8192000000 10038127968 10487746560 1063484960 11.490 97 12 25 0 1131426016 65047920 2893136
03:27:01 9558 8192000000 10014765872 10431909888 1074896000 11.599 98 33 63 1 1101437776 20347680 6194096
03:28:11 71187 8192000000 10037011152 10502656000 1062516336 11.481 98 20 40 0 1128952976 62354512 4082128
03:30:27 54659 8192000000 10092916032 10578173952 1073403440 11.585 98 39 77 0 1195546032 114522528 7620064
03:32:23 43927 8192000000 10046344544 10463690752 1070091328 11.553 98 24 49 0 1116128288 41176352 4860608
03:34:10 31080 8192000000 10053296032 10477166592 1081918384 11.666 99 50 100 1 1143942560 51584896 10439280
03:35:45 127694 8192000000 10052663936 10484707328 1094919776 11.789 99 29 58 0 1164638800 63902032 5816992
03:38:55 38079 8192000000 10045102144 10514550784 1109714928 11.930 100 7 14 1 1151887520 40958464 1214128
03:40:51 43625 8192000000 10021043504 10462863360 1074622096 11.596 97 14 28 0 1117157584 39651792 2883696
03:42:39 32836 8192000000 10033272576 10483486720 1110684448 11.939 100 16 32 0 1164495680 50673056 3138176
03:44:13 33077 8192000000 10046287648 10468515840 1087821680 11.722 97 28 51 1 1119010832 26315248 4873904
03:45:46 48351 8192000000 10093834544 10566471680 1120898688 12.035 100 33 66 0 1185309216 57323504 7087024
03:47:41 99520 8192000000 10103706272 10567626752 1116207216 11.991 98 31 62 0 1196869168 74294752 6367200
03:50:31 56295 8192000000 10105535360 10542206976 1131422576 12.135 99 18 35 0 1186820304 52041808 3355920
03:52:31 38412 8192000000 10157145712 10601861120 1119219200 12.020 98 24 48 1 1217249872 93193376 4837296
03:54:13 125758 8192000000 10054938832 10485530624 1118086704 12.009 99 20 40 0 1176755120 54828000 3840416
03:57:29 48511 8192000000 10035165648 10523324416 1116879408 11.998 99 7 14 0 1162425408 44136224 1409776
03:59:22 34201 8192000000 10042686288 10489106432 1115338544 11.983 99 10 20 0 1154320864 36971792 2010528
04:00:56 55770 8192000000 10050717472 10532577280 1108894528 11.922 99 20 40 0 1156311984 42900832 4516624
04:03:07 79189 8192000000 10062952832 10498953216 1069301008 11.545 95 15 30 0 1108659120 36296208 3061904
04:05:53 68282 8192000000 10104842352 10583347200 1108252224 11.916 99 49 98 0 1206241232 87496896 10492112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 05-04-2024 04:09:09 to 05-04-2024 04:09:23.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 106 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-04-2024 04:09:24 to 05-04-2024 04:09:26.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Fri Apr  5 04:09:27 2024 
 
Database header page information: 
    Flags            0 
    Generation        92589 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    175661 
    Oldest active        177916 
    Oldest snapshot        177916 
    Next transaction    177917 
    Sequence number        0 
    Next attachment ID    703 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.40, total records: 7842996 
    Average version length: 48.16, total versions: 99119, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 56, data page slots: 89840 
    Data pages: 89840, average fill: 70% 
    Primary pages: 89837, secondary pages: 3, swept pages: 32823 
    Empty pages: 8, full pages: 75743 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 74 
    40 - 59% = 1833 
    60 - 79% = 87832 
    80 - 99% = 77 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23304, nodes: 7842996 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.05, average data length: 12.95 
    Clustering factor: 1697035, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 371 
        20 - 39% = 1356 
        40 - 59% = 4371 
        60 - 79% = 2150 
        80 - 99% = 15056 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13514, nodes: 7842996 
    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: 1522034, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1343 
        40 - 59% = 2208 
        60 - 79% = 923 
        80 - 99% = 9040 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8371, nodes: 7842996 
    Average node length: 6.64, total dup: 5831556, max dup: 49 
    Average key length: 3.65, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1515018, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 154 
        20 - 39% = 718 
        40 - 59% = 1599 
        60 - 79% = 753 
        80 - 99% = 5147 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.43, total records: 2301831 
    Average version length: 58.90, total versions: 49752, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 29136 
    Data pages: 29136, average fill: 73% 
    Primary pages: 29134, secondary pages: 2, swept pages: 8342 
    Empty pages: 1, full pages: 22979 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 21 
    40 - 59% = 297 
    60 - 79% = 28690 
    80 - 99% = 119 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4574, nodes: 2301831 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 696871, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 776 
        40 - 59% = 973 
        60 - 79% = 604 
        80 - 99% = 2221 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2479, nodes: 2303483 
    Average node length: 4.97, total dup: 2302584, max dup: 19890 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1270191, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 180 
        40 - 59% = 1466 
        60 - 79% = 568 
        80 - 99% = 263 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1828, nodes: 2301831 
    Average node length: 4.97, total dup: 2301781, max dup: 130427 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1088322, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 688 
        60 - 79% = 41 
        80 - 99% = 1096 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4383, nodes: 2301831 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 696871, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 473 
        40 - 59% = 751 
        60 - 79% = 696 
        80 - 99% = 2363 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.40, total records: 400 
    Average version length: 29.00, total versions: 1964, max versions: 5 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 67% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 1, full pages: 13 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 116869 
    Average version length: 68.29, total versions: 104662, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.79 
    Pointer pages: 6, data page slots: 3856 
    Data pages: 1992, average fill: 78% 
    Primary pages: 1991, secondary pages: 1, swept pages: 0 
    Empty pages: 125, full pages: 1546 
    Fill distribution: 
     0 - 19% = 183 
    20 - 39% = 91 
    40 - 59% = 91 
    60 - 79% = 194 
    80 - 99% = 1433 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700747, depth: 3, leaf buckets: 344, nodes: 116869 
    Average node length: 13.27, total dup: 8213, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.29, average data length: 7.71 
    Clustering factor: 87929, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 257 
        60 - 79% = 44 
        80 - 99% = 37 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 206, max versions: 7 
    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: 4 
    Data pages: 4, average fill: 22% 
    Primary pages: 1, secondary pages: 3, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.47, total records: 1544 
    Average version length: 43.50, total versions: 1436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.06 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 53% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 2, full pages: 12 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89427, depth: 2, leaf buckets: 2, nodes: 1544 
    Average node length: 4.42, total dup: 1447, max dup: 177 
    Average key length: 2.66, compression ratio: 7.14 
    Average prefix length: 18.40, average data length: 0.60 
    Clustering factor: 860, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.63, total records: 68 
    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: 48% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 68 
    Average node length: 11.71, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.29, average data length: 7.71 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.65, total records: 798286 
    Average version length: 37.91, total versions: 39918, max versions: 2 
    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: 8224 
    Data pages: 8216, average fill: 66% 
    Primary pages: 8215, secondary pages: 1, swept pages: 834 
    Empty pages: 32, full pages: 7650 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 21 
    40 - 59% = 94 
    60 - 79% = 7953 
    80 - 99% = 87 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 815, nodes: 776569 
    Average node length: 4.88, total dup: 776520, max dup: 134933 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90585, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 94 
        40 - 59% = 443 
        60 - 79% = 171 
        80 - 99% = 106 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 883, nodes: 776569 
    Average node length: 5.88, total dup: 691371, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157252, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 43 
        40 - 59% = 411 
        60 - 79% = 164 
        80 - 99% = 265 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 909, nodes: 776569 
    Average node length: 5.89, total dup: 691371, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159128, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 98 
        40 - 59% = 394 
        60 - 79% = 150 
        80 - 99% = 267 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1094, nodes: 776569 
    Average node length: 5.97, total dup: 691371, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152546, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 245 
        40 - 59% = 555 
        60 - 79% = 208 
        80 - 99% = 85 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.74, total records: 5461 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.40, total fragments: 15, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 81, secondary pages: 14, swept pages: 47 
    Empty pages: 12, full pages: 57 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5461 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.41, average data length: 1.55 
    Clustering factor: 5124, 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: 1504255, depth: 2, leaf buckets: 10, nodes: 5461 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 169, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 81479 
    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: 848 
    Data pages: 848, average fill: 66% 
    Primary pages: 848, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 846 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 846 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33674, depth: 2, leaf buckets: 104, nodes: 81479 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.15, compression ratio: 1.10 
    Average prefix length: 3.85, average data length: 5.15 
    Clustering factor: 3279, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 137.85, total records: 182558 
    Average version length: 153.68, total versions: 16712, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.30 
    Pointer pages: 5, data page slots: 6568 
    Data pages: 4592, average fill: 83% 
    Primary pages: 4590, secondary pages: 2, swept pages: 7 
    Empty pages: 98, full pages: 4473 
    Fill distribution: 
     0 - 19% = 103 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4473 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 145.94, total records: 155780 
    Average version length: 152.61, total versions: 5958, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 8, data page slots: 4632 
    Data pages: 3880, average fill: 83% 
    Primary pages: 3879, secondary pages: 1, swept pages: 5 
    Empty pages: 39, full pages: 3824 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 3821 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 137.44, total records: 156663 
    Average version length: 153.89, total versions: 15128, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.34 
    Pointer pages: 6, data page slots: 5400 
    Data pages: 3904, average fill: 84% 
    Primary pages: 3902, secondary pages: 2, swept pages: 6 
    Empty pages: 44, full pages: 3845 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 3846 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 135.48, total records: 163192 
    Average version length: 154.09, total versions: 17781, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.52 
    Pointer pages: 6, data page slots: 5104 
    Data pages: 4048, average fill: 84% 
    Primary pages: 4046, secondary pages: 2, swept pages: 3 
    Empty pages: 29, full pages: 3999 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 11 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 3998 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.66, total records: 148023 
    Average version length: 152.25, total versions: 8314, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 5, data page slots: 4496 
    Data pages: 3680, average fill: 83% 
    Primary pages: 3679, secondary pages: 1, swept pages: 1 
    Empty pages: 46, full pages: 3622 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3621 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 125.00, total records: 183808 
    Average version length: 154.98, total versions: 33585, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.57 
    Pointer pages: 6, data page slots: 4784 
    Data pages: 4552, average fill: 86% 
    Primary pages: 4550, secondary pages: 2, swept pages: 3 
    Empty pages: 25, full pages: 4515 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 4515 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 142.37, total records: 164623 
    Average version length: 152.52, total versions: 10064, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 6, data page slots: 5464 
    Data pages: 4096, average fill: 84% 
    Primary pages: 4095, secondary pages: 1, swept pages: 4 
    Empty pages: 45, full pages: 4032 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 4033 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 142.26, total records: 161975 
    Average version length: 152.20, total versions: 9796, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.92 
    Pointer pages: 6, data page slots: 5248 
    Data pages: 4056, average fill: 83% 
    Primary pages: 4054, secondary pages: 2, swept pages: 1 
    Empty pages: 74, full pages: 3965 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3967 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 119.17, total records: 187494 
    Average version length: 154.79, total versions: 41900, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.23 
    Pointer pages: 6, data page slots: 5552 
    Data pages: 4728, average fill: 85% 
    Primary pages: 4725, secondary pages: 3, swept pages: 1 
    Empty pages: 96, full pages: 4603 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 15 
    40 - 59% = 2 
    60 - 79% = 8 
    80 - 99% = 4605 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 144.95, total records: 164256 
    Average version length: 151.33, total versions: 7155, 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: 7, data page slots: 5792 
    Data pages: 4144, average fill: 82% 
    Primary pages: 4142, secondary pages: 2, swept pages: 3 
    Empty pages: 93, full pages: 4021 
    Fill distribution: 
     0 - 19% = 95 
    20 - 39% = 11 
    40 - 59% = 10 
    60 - 79% = 6 
    80 - 99% = 4022 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.76, total records: 2150397 
    Average version length: 52.82, total versions: 48957, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 26000 
    Data pages: 26000, average fill: 71% 
    Primary pages: 25986, secondary pages: 14, swept pages: 9323 
    Empty pages: 73, full pages: 24054 
    Fill distribution: 
     0 - 19% = 146 
    20 - 39% = 166 
    40 - 59% = 494 
    60 - 79% = 24698 
    80 - 99% = 496 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2609, nodes: 2150397 
    Average node length: 5.44, total dup: 2008669, max dup: 1515 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 184915, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 225 
        40 - 59% = 1756 
        60 - 79% = 326 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2763, nodes: 2150397 
    Average node length: 5.69, total dup: 1930805, max dup: 62 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 383114, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2267 
        60 - 79% = 456 
        80 - 99% = 33 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2127, nodes: 2150397 
    Average node length: 4.96, total dup: 2150297, max dup: 27947 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182147, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 169 
        40 - 59% = 1090 
        60 - 79% = 389 
        80 - 99% = 477 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 40.30, total records: 155374 
    Average version length: 69.18, total versions: 74635, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.13 
    Pointer pages: 3, data page slots: 3872 
    Data pages: 2944, average fill: 64% 
    Primary pages: 2944, secondary pages: 0, swept pages: 296 
    Empty pages: 403, full pages: 2144 
    Fill distribution: 
     0 - 19% = 555 
    20 - 39% = 91 
    40 - 59% = 68 
    60 - 79% = 893 
    80 - 99% = 1337 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104033, depth: 3, leaf buckets: 221, nodes: 155374 
    Average node length: 6.46, total dup: 135345, max dup: 29 
    Average key length: 3.93, compression ratio: 10.68 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27137, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 18 
        40 - 59% = 113 
        60 - 79% = 77 
        80 - 99% = 13 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.71, total records: 6910188 
    Average version length: 68.77, total versions: 488273, 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: 63, data page slots: 102064 
    Data pages: 102064, average fill: 73% 
    Primary pages: 102063, secondary pages: 1, swept pages: 10220 
    Empty pages: 0, full pages: 81736 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 335 
    40 - 59% = 4658 
    60 - 79% = 94971 
    80 - 99% = 2089 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10557, nodes: 6910188 
    Average node length: 6.51, total dup: 5979989, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1645907, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1676 
        40 - 59% = 5934 
        60 - 79% = 2497 
        80 - 99% = 445 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8224, nodes: 6910188 
    Average node length: 5.40, total dup: 6634768, max dup: 198 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1446270, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1037 
        40 - 59% = 4458 
        60 - 79% = 1722 
        80 - 99% = 997 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8272, nodes: 6910188 
    Average node length: 5.40, total dup: 6634768, max dup: 198 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1448661, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1103 
        40 - 59% = 4391 
        60 - 79% = 1776 
        80 - 99% = 994 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.83, total records: 11751635 
    Average version length: 68.73, total versions: 409997, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 104, data page slots: 169160 
    Data pages: 169160, average fill: 74% 
    Primary pages: 169160, secondary pages: 0, swept pages: 47264 
    Empty pages: 2, full pages: 157954 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 396 
    40 - 59% = 2925 
    60 - 79% = 163116 
    80 - 99% = 2703 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18187, nodes: 11748357 
    Average node length: 6.58, total dup: 10243052, max dup: 59 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2465373, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 2611 
        40 - 59% = 10777 
        60 - 79% = 4004 
        80 - 99% = 767 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 43.60, total records: 1871915 
    Average version length: 69.06, total versions: 493745, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.89 
    Pointer pages: 25, data page slots: 40312 
    Data pages: 30592, average fill: 63% 
    Primary pages: 30487, secondary pages: 105, swept pages: 3957 
    Empty pages: 1728, full pages: 24352 
    Fill distribution: 
     0 - 19% = 2915 
    20 - 39% = 3935 
    40 - 59% = 2660 
    60 - 79% = 13944 
    80 - 99% = 7138 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 2040, nodes: 1570685 
    Average node length: 5.52, total dup: 1506742, max dup: 49 
    Average key length: 2.56, compression ratio: 16.41 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 111231, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 366 
        40 - 59% = 1046 
        60 - 79% = 512 
        80 - 99% = 106 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 36.36, total records: 1524197 
    Average version length: 68.99, total versions: 179767, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.47 
    Pointer pages: 21, data page slots: 32592 
    Data pages: 27432, average fill: 44% 
    Primary pages: 27431, secondary pages: 1, swept pages: 4407 
    Empty pages: 4328, full pages: 15025 
    Fill distribution: 
     0 - 19% = 6670 
    20 - 39% = 3580 
    40 - 59% = 6699 
    60 - 79% = 9979 
    80 - 99% = 504 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1226, nodes: 874701 
    Average node length: 5.93, total dup: 806336, max dup: 70 
    Average key length: 2.99, compression ratio: 14.03 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 123405, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 246 
        40 - 59% = 588 
        60 - 79% = 353 
        80 - 99% = 38 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.22, total records: 9650680 
    Average version length: 68.97, total versions: 581537, 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: 87, data page slots: 141712 
    Data pages: 141712, average fill: 73% 
    Primary pages: 141701, secondary pages: 11, swept pages: 25405 
    Empty pages: 67, full pages: 106317 
    Fill distribution: 
     0 - 19% = 155 
    20 - 39% = 485 
    40 - 59% = 5065 
    60 - 79% = 131701 
    80 - 99% = 4306 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13479, nodes: 9641002 
    Average node length: 6.67, total dup: 7998991, max dup: 15 
    Average key length: 3.66, compression ratio: 11.48 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2200486, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 712 
        40 - 59% = 6468 
        60 - 79% = 5366 
        80 - 99% = 933 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21179025 
    Average version length: 82.99, total versions: 15912, 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: 197, data page slots: 320064 
    Data pages: 320064, average fill: 81% 
    Primary pages: 320060, secondary pages: 4, swept pages: 11287 
    Empty pages: 6, full pages: 320054 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 48701 
    80 - 99% = 271353 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19224, nodes: 21179025 
    Average node length: 5.72, total dup: 20697444, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286910, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 7769 
        60 - 79% = 573 
        80 - 99% = 10878 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17198, nodes: 21179025 
    Average node length: 6.31, total dup: 18610968, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919177, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 5 
        40 - 59% = 797 
        60 - 79% = 256 
        80 - 99% = 16137 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20981, nodes: 21179025 
    Average node length: 6.35, total dup: 18530973, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582495, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 2 
        40 - 59% = 7954 
        60 - 79% = 661 
        80 - 99% = 12358 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16212, nodes: 21179025 
    Average node length: 5.56, total dup: 21178925, max dup: 229447 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948087, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 6 
        40 - 59% = 3099 
        60 - 79% = 349 
        80 - 99% = 12755 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 78.25, total records: 10085630 
    Average version length: 82.67, total versions: 572904, 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: 102, data page slots: 166288 
    Data pages: 166256, average fill: 75% 
    Primary pages: 166240, secondary pages: 16, swept pages: 45790 
    Empty pages: 234, full pages: 129497 
    Fill distribution: 
     0 - 19% = 523 
    20 - 39% = 1042 
    40 - 59% = 7227 
    60 - 79% = 126240 
    80 - 99% = 31224 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11349, nodes: 10085630 
    Average node length: 5.37, total dup: 9773434, max dup: 194 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2314668, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 8 
        40 - 59% = 6942 
        60 - 79% = 4154 
        80 - 99% = 240 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13564, nodes: 10085630 
    Average node length: 6.25, total dup: 8365287, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1636372, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 3459 
        40 - 59% = 4429 
        60 - 79% = 2532 
        80 - 99% = 2998 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12677, nodes: 10085630 
    Average node length: 5.99, total dup: 8766683, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2509896, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 11 
        40 - 59% = 7866 
        60 - 79% = 4529 
        80 - 99% = 267 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10150, nodes: 10085630 
    Average node length: 5.15, total dup: 10085530, max dup: 156868 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1642663, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 936 
        40 - 59% = 4803 
        60 - 79% = 1908 
        80 - 99% = 2468 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.80, total records: 11807144 
    Average version length: 82.60, total versions: 405616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 118, data page slots: 192200 
    Data pages: 191344, average fill: 76% 
    Primary pages: 191229, secondary pages: 115, swept pages: 47771 
    Empty pages: 1211, full pages: 165812 
    Fill distribution: 
     0 - 19% = 2012 
    20 - 39% = 2888 
    40 - 59% = 8695 
    60 - 79% = 104247 
    80 - 99% = 73502 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13156, nodes: 11807144 
    Average node length: 5.32, total dup: 11696276, max dup: 675 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2475625, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 62 
        40 - 59% = 7818 
        60 - 79% = 4846 
        80 - 99% = 428 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10761, nodes: 11807144 
    Average node length: 5.52, total dup: 11293193, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 760610, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 740 
        40 - 59% = 2628 
        60 - 79% = 1814 
        80 - 99% = 5448 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15049, nodes: 11807144 
    Average node length: 6.04, total dup: 10315583, max dup: 79 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2492184, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 77 
        40 - 59% = 9267 
        60 - 79% = 5211 
        80 - 99% = 491 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 11076, nodes: 11807144 
    Average node length: 5.25, total dup: 11807044, max dup: 195769 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 747476, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 70 
        20 - 39% = 711 
        40 - 59% = 4885 
        60 - 79% = 1507 
        80 - 99% = 3903 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 79.31, total records: 10099023 
    Average version length: 82.94, total versions: 469369, 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: 105, data page slots: 170736 
    Data pages: 170672, average fill: 73% 
    Primary pages: 170659, secondary pages: 13, swept pages: 56016 
    Empty pages: 457, full pages: 119549 
    Fill distribution: 
     0 - 19% = 1116 
    20 - 39% = 2539 
    40 - 59% = 11423 
    60 - 79% = 129809 
    80 - 99% = 25785 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12146, nodes: 10099023 
    Average node length: 5.19, total dup: 10069868, max dup: 1599 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2056557, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1320 
        40 - 59% = 8296 
        60 - 79% = 1883 
        80 - 99% = 623 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13652, nodes: 10099023 
    Average node length: 6.26, total dup: 8376266, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1570360, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 189 
        20 - 39% = 3480 
        40 - 59% = 4505 
        60 - 79% = 2478 
        80 - 99% = 3000 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12760, nodes: 10099023 
    Average node length: 5.45, total dup: 9649747, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2196381, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1257 
        40 - 59% = 9157 
        60 - 79% = 1675 
        80 - 99% = 633 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10308, nodes: 10099023 
    Average node length: 5.16, total dup: 10098923, max dup: 158417 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1642086, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1015 
        40 - 59% = 5075 
        60 - 79% = 1837 
        80 - 99% = 2348 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.29, total records: 578836 
    Average version length: 68.81, total versions: 8647, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8080 
    Data pages: 8080, average fill: 75% 
    Primary pages: 8080, secondary pages: 0, swept pages: 3010 
    Empty pages: 0, full pages: 7239 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 3 
    40 - 59% = 80 
    60 - 79% = 7852 
    80 - 99% = 145 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39435, depth: 3, leaf buckets: 738, nodes: 578836 
    Average node length: 5.95, total dup: 492877, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101987, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 508 
        60 - 79% = 106 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29638, depth: 3, leaf buckets: 759, nodes: 578836 
    Average node length: 6.15, total dup: 474804, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102046, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 511 
        60 - 79% = 107 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 559, nodes: 578836 
    Average node length: 4.86, total dup: 578736, max dup: 9306 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90660, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 315 
        60 - 79% = 70 
        80 - 99% = 142 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Apr  5 04:09:51 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7842996 99119 1 0.0000 0.0000
DOC_LIST 2301831 49752 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1964 5 400.0000 0.0000
INVNT_TURNOVER_LOG 116869 104662 1 0.0000 0.0000
MONEY_SALDO 49 206 7 400.0000 0.0000
MONEY_TURNOVER_LOG 1544 1436 1 0.0000 0.0000
PDISTR 798286 39918 2 0.0000 0.0000
PERF_SPLIT_0 182558 16712 1 0.0000 0.0000
PERF_SPLIT_1 155780 5958 1 0.0000 0.0000
PERF_SPLIT_2 156663 15128 1 0.0000 0.0000
PERF_SPLIT_3 163192 17781 1 0.0000 0.0000
PERF_SPLIT_4 148023 8314 1 0.0000 0.0000
PERF_SPLIT_5 183808 33585 1 0.0000 0.0000
PERF_SPLIT_6 164623 10064 1 0.0000 0.0000
PERF_SPLIT_7 161975 9796 1 0.0000 0.0000
PERF_SPLIT_8 187494 41900 1 0.0000 0.0000
PERF_SPLIT_9 164256 7155 1 0.0000 0.0000
PSTORNED 2150397 48957 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 155374 74635 1 0.0000 0.0000
XQD_1000_3300 6910188 488273 1 0.0000 0.0000
XQD_1200_2000 11751635 409997 1 0.0000 0.0000
XQD_2000_3300 1871915 493745 1 0.0000 0.0000
XQD_2100_3300 1524197 179767 1 0.0000 0.0000
XQD_3300_3400 9650680 581537 1 0.0000 0.0000
XQS_1000_1200 21179025 15912 1 0.0000 0.0000
XQS_1000_3300 10085630 572904 1 0.0000 0.0000
XQS_1200_2000 11807144 405616 1 0.0000 0.0000
XQS_2100_3300 10099023 469369 1 0.0000 0.0000
XQS_3300_3400 578836 8647 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 ---
:141: 
:142: mscs-test-161.budzdorov.ru    Fri Apr  5 04:07:51 2024
:143:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:144: 
:145: 
:146: mscs-test-161.budzdorov.ru    Fri Apr  5 04:07:54 2024
:147:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:148: 
--- end of diff output ---

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

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