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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-16 01:09:45
DTS_END                         2024-03-16 01:09:45.9470
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48464
TRN_ID                          173879
ATT_ID                          563
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: 9042.19 23199 904219
customer order: creation 171.69 392 17169
customer order: refuse 14.99 378 1499
order to supplier: creation 45.83 1362 4583
order to supplier: removal 3.30 107781 330
invoice (draft): creation 46.59 3507 4659
invoice (draft): removal 48.86 895 4886
invoice accept: apply 41.84 21078 4184
invoice accept: cancel 43.71 1053 4371
customer reserve: creation 4031.70 201 403170
customer reserve: removal 4300.39 66 430039
realization accept: apply 84.36 209 8436
realization accept: cancel 78.32 117 7832
payment from customer: creation 59.90 121 5990
payment from customer: removal 5.44 75 544
payment to supplier: creation 49.32 141 4932
payment to supplier: removal 3.19 84 319
service: total inventory turnovers 5.01 1021 501
service: total monetary turnovers 6.79 62 679
service: aggregate perf. data 0.93 19893 93
service: refresh index statistics 0.03 305535 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-03-2024 01:10:59 to 16-03-2024 01:11:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3059
TEST_TIME 2 3702
TEST_TIME 3 2824
TEST_TIME 4 3660
TEST_TIME 5 3596
TEST_TIME 6 4825
TEST_TIME 7 4579
TEST_TIME 8 4813
TEST_TIME 9 5259
TEST_TIME 10 5798
TEST_TIME 11 5733
TEST_TIME 12 5633
TEST_TIME 13 5881
TEST_TIME 14 6047
TEST_TIME 15 6106
TEST_TIME 16 6225
TEST_TIME 17 6222
TEST_TIME 18 6286
TEST_TIME 19 6466
TEST_TIME 20 6564
TEST_TIME 21 6785
TEST_TIME 22 7173
TEST_TIME 23 7337
TEST_TIME 24 7510
TEST_TIME 25 7537
TEST_TIME 26 7597
TEST_TIME 27 7740
TEST_TIME 28 8045
TEST_TIME 29 8385
TEST_TIME 30 8760
TEST_TIME 31 9087
TEST_TIME 32 8975
TEST_TIME 33 8902
TEST_TIME 34 8880
TEST_TIME 35 8793
TEST_TIME 36 8668
TEST_TIME 37 8655
TEST_TIME 38 8669
TEST_TIME 39 8739
TEST_TIME 40 8642
TEST_TIME 41 8581
TEST_TIME 42 8570
TEST_TIME 43 8543
TEST_TIME 44 8623
TEST_TIME 45 8651
TEST_TIME 46 8574
TEST_TIME 47 8553
TEST_TIME 48 8448
TEST_TIME 49 8398
TEST_TIME 50 8443
TEST_TIME 51 8397
TEST_TIME 52 8501
TEST_TIME 53 8512
TEST_TIME 54 8570
TEST_TIME 55 8531
TEST_TIME 56 8589
TEST_TIME 57 8680
TEST_TIME 58 8750
TEST_TIME 59 8724
TEST_TIME 60 8873
TEST_TIME 61 8831
TEST_TIME 62 8906
TEST_TIME 63 8886
TEST_TIME 64 8877
TEST_TIME 65 8848
TEST_TIME 66 8844
TEST_TIME 67 8824
TEST_TIME 68 8815
TEST_TIME 69 8762
TEST_TIME 70 8712
TEST_TIME 71 8603
TEST_TIME 72 8659
TEST_TIME 73 8795
TEST_TIME 74 8767
TEST_TIME 75 8830
TEST_TIME 76 8841
TEST_TIME 77 8890
TEST_TIME 78 8913
TEST_TIME 79 8938
TEST_TIME 80 8965
TEST_TIME 81 8903
TEST_TIME 82 9007
TEST_TIME 83 9092
TEST_TIME 84 9139
TEST_TIME 85 9162
TEST_TIME 86 9214
TEST_TIME 87 9223
TEST_TIME 88 9170
TEST_TIME 89 9085
TEST_TIME 90 9112
TEST_TIME 91 9063
TEST_TIME 92 9040
TEST_TIME 93 9021
TEST_TIME 94 8996
TEST_TIME 95 9022
TEST_TIME 96 8987
TEST_TIME 97 8992
TEST_TIME 98 9043
TEST_TIME 99 9038
TEST_TIME 100 9047

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 16-03-2024 01:11:02 to 16-03-2024 01:11:06.

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 1272643 1272643 0 0.00 0 22228 7 0 0
doc_list_biud 1272643 1272643 0 0.00 0 44743 29 0 0
sp_add_invoice_to_stock 4292 4184 108 2.51 50 227703 21078 0 108
sp_cancel_adding_invoice 4371 4371 0 0.00 3 72812 1054 0 0
sp_cancel_client_order 1499 1499 0 0.00 3 12436 378 0 0
sp_cancel_customer_reserve 430039 430039 0 0.00 0 30300 67 0 0
sp_cancel_pay_from_customer 544 544 0 0.00 3 3823 75 0 0
sp_cancel_pay_to_supplier 319 319 0 0.00 3 7614 85 0 0
sp_cancel_supplier_invoice 4898 4886 12 0.24 2 20332 896 0 12
sp_cancel_supplier_order 330 330 0 0.00 6 1016883 107781 0 0
sp_cancel_write_off 7832 7832 0 0.00 1 8934 118 0 0
sp_client_order 17169 17169 0 0.00 3 35298 392 0 0
sp_customer_reserve 403170 403170 0 0.00 0 46248 202 0 0
sp_fill_shopping_cart 26407 26407 0 0.00 1 14961 38 0 0
sp_fill_shopping_cart_clo_res 403167 403167 0 0.00 0 31685 15 0 0
sp_get_clo_for_invoice 4181 4181 0 0.00 0 24930 314 0 0
sp_kill_cost_storno 13066 13066 0 0.00 0 18535 64 0 0
sp_kill_qstorno_ret_qs2qd 873126 873126 0 0.00 0 30284 36 0 0
sp_kill_qty_storno 461574 461574 0 0.00 0 44742 78 0 0
sp_lock_selected_doc 17398 17398 0 0.00 0 8761 8 0 0
sp_make_cost_storno 23539 23539 0 0.00 0 14092 55 0 0
sp_multiply_rows_for_pdistr 23539 23539 0 0.00 0 10253 32 0 0
sp_multiply_rows_for_qdistr 17169 17169 0 0.00 0 32153 177 0 0
sp_pay_from_customer 5990 5990 0 0.00 4 12523 122 0 0
sp_pay_to_supplier 4932 4932 0 0.00 5 14097 142 0 0
sp_payment_common 10922 10922 0 0.00 1 8337 30 0 0
sp_qd_handle_on_cancel_clo 1499 1499 0 0.00 0 12430 343 0 0
sp_qd_handle_on_invoice_upd_sts 8552 8552 0 0.00 0 44741 344 0 0
sp_qd_handle_on_reserve_upd_sts 8436 8436 0 0.00 0 12831 73 0 0
sp_reserve_write_off 8436 8436 0 0.00 6 17250 210 0 0
sp_supplier_invoice 4659 4659 0 0.00 8 81564 3508 0 0
sp_supplier_order 4583 4583 0 0.00 4 56406 1363 0 0
srv_aggregate_perf_data 93 93 0 0.00 1696 488180 19894 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 2110 97701 38102 0 0
srv_find_qd_qs_mism 861218 861218 0 0.00 0 22227 6 0 0
srv_make_invnt_saldo 501 501 0 0.00 32 34972 1022 0 0
srv_make_money_saldo 679 679 0 0.00 1 20696 62 0 0
srv_recalc_idx_stat 3 3 0 0.00 215309 399090 305535 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4186 4186 0 0.00 0 5927 172 0 0
t$perf-norm:sp_cancel_adding_invoice 371 371 0 0.00 0 2390 94 0 0
t$perf-norm:sp_cancel_client_order 1499 1499 0 0.00 0 2555 11 0 0
t$perf-norm:sp_cancel_customer_reserve 605 605 0 0.00 0 2057 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 544 544 0 0.00 0 2794 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 319 319 0 0.00 0 2135 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 325 325 0 0.00 0 1401 21 0 0
t$perf-norm:sp_cancel_supplier_order 330 330 0 0.00 0 16924 1900 0 0
t$perf-norm:sp_cancel_write_off 788 788 0 0.00 0 2947 13 0 0
t$perf-norm:sp_client_order 17169 17169 0 0.00 0 5811 16 0 0
t$perf-norm:sp_customer_reserve 896 896 0 0.00 0 2117 9 0 0
t$perf-norm:sp_pay_from_customer 5990 5990 0 0.00 0 3439 7 0 0
t$perf-norm:sp_pay_to_supplier 4932 4932 0 0.00 0 2684 9 0 0
t$perf-norm:sp_reserve_write_off 8436 8436 0 0.00 0 3159 10 0 0
t$perf-norm:sp_supplier_invoice 4659 4659 0 0.00 0 2912 15 0 0
t$perf-norm:sp_supplier_order 4583 4583 0 0.00 0 2086 15 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 593 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 242 7 0 0
t$perf-norm:srv_make_invnt_saldo 501 501 0 0.00 0 856 24 0 0
t$perf-norm:srv_make_money_saldo 679 679 0 0.00 0 882 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 8578 8362 216 2.51 0 9075 22 0 216
v_all_customers 31502 31502 0 0.00 0 107 1 0 0
v_all_suppliers 26084 26084 0 0.00 0 24 1 0 0
v_all_wares 34338 34338 0 0.00 0 81 1 0 0
v_cancel_adding_invoice 742 742 0 0.00 0 2042 8 0 0
v_cancel_client_order 2998 2998 0 0.00 0 5143 6 0 0
v_cancel_customer_prepayment 1088 1088 0 0.00 0 3053 10 0 0
v_cancel_customer_reserve 1210 1210 0 0.00 0 1863 6 0 0
v_cancel_payment_to_supplier 638 638 0 0.00 0 223 4 0 0
v_cancel_supplier_invoice 674 650 24 3.56 0 8410 45 0 24
v_cancel_supplier_order 660 660 0 0.00 0 2520 10 0 0
v_cancel_write_off 1576 1576 0 0.00 0 5487 18 0 0
v_max_id_clo_ord 4582 4582 0 0.00 0 474 1 0 0
v_max_id_clo_res 896 896 0 0.00 0 3587 18 0 0
v_max_id_ord_sup 4656 4656 0 0.00 0 2665 3 0 0
v_max_non_paid_invoice 1128 1128 0 0.00 0 81 2 0 0
v_max_non_paid_realizn 3031 3031 0 0.00 0 1957 5 0 0
v_min_id_clo_ord 4582 4582 0 0.00 0 3233 8 0 0
v_min_id_clo_res 896 896 0 0.00 0 7065 28 0 0
v_min_id_ord_sup 4656 4656 0 0.00 0 4804 5 0 0
v_min_non_paid_invoice 4932 4932 0 0.00 0 7913 21 0 0
v_min_non_paid_realizn 5990 5990 0 0.00 0 8333 26 0 0
v_our_firm 8754 8754 0 0.00 0 71 1 0 0
v_reserve_write_off 16872 16872 0 0.00 0 9079 9 0 0
x_lock_depdocs_on_canc_invoice 8932 8932 0 0.00 0 8334 133 0 0
x_lock_depdocs_on_canc_sup_ord 330 330 0 0.00 0 5682 329 0 0
x_make_qstorno_1000_1200 4583 4583 0 0.00 1 53133 1282 0 0
x_make_qstorno_1200_2000 4659 4659 0 0.00 4 81135 3372 0 0
x_make_qstorno_2100_3300 403170 403170 0 0.00 0 43900 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-03-2024 01:11:07 to 16-03-2024 01:11:11.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
23:09:49 4 8192000000 8801913712 8814104576 7937056 0.096 2 2 3 0 8078144 66144 74944
23:10:50 22198 8192000000 9898785264 10212499456 987045088 10.753 100 90 180 0 1017258032 6072640 24140304
23:12:18 27582 8192000000 9952417696 10276216832 1029993904 11.168 100 88 176 0 1060986384 8509456 22483024
23:13:48 11276 8192000000 9975336080 10302607360 1057619168 11.434 100 93 186 0 1090801120 9897680 23284272
23:15:04 9736 8192000000 10005370176 10350211072 1092132288 11.763 100 74 144 1 1120405248 10869200 17403760
23:16:18 4490 8192000000 10057654864 10413154304 1151597344 12.324 100 78 154 0 1180035344 10996384 17441616
23:17:26 2885 8192000000 10120031744 10485727232 1206513776 12.837 100 83 167 0 1238103520 12579312 19010432
23:18:31 2318 8192000000 10158686752 10530840576 1245589392 13.198 100 93 183 0 1280251744 14930768 19731584
23:19:36 1758 8192000000 10187998848 10567749632 1276143360 13.478 100 88 176 0 1309612176 14305136 19163680
23:20:40 1163 8192000000 10203399200 10587930624 1289755744 13.602 100 87 170 1 1322433440 13819184 18858512
23:21:42 8373 8192000000 10206593184 10605379584 1309770816 13.784 100 38 72 0 1325080336 5718896 9590624
23:22:52 19021 8192000000 10227868416 10632503296 1316682512 13.847 100 64 128 1 1342188000 10468720 15036768
23:24:12 5251 8192000000 10215117920 10629795840 1322667280 13.901 100 33 66 0 1338293504 8581248 7044976
23:25:18 6086 8192000000 10221348912 10638540800 1330638592 13.973 100 32 63 0 1345170128 7800048 6731488
23:26:31 61340 8192000000 10229262880 10648764416 1334720976 14.010 100 17 32 1 1343036816 5247104 3068736
23:28:33 7600 8192000000 10222769424 10639880192 1331711152 13.983 100 21 43 1 1341964448 5736496 4516800
23:29:41 27432 8192000000 10221058736 10636677120 1317444272 13.854 99 20 39 0 1327822384 5413136 4964976
23:31:19 95280 8192000000 10232100352 10640252928 1311328384 13.798 98 54 108 0 1333665232 9852976 12483872
23:34:01 12087 8192000000 10244987408 10661138432 1339112080 14.049 100 47 94 0 1361222016 11703968 10405968
23:35:16 36452 8192000000 10248515616 10673123328 1327640608 13.946 98 34 68 0 1350148320 14997536 7510176
23:36:57 18386 8192000000 10240841504 10658832384 1318112592 13.860 98 43 84 1 1342224432 14323568 9788272
23:38:19 22521 8192000000 10230177664 10641072128 1298589632 13.682 98 53 104 0 1327971824 16742208 12639984
23:39:47 14665 8192000000 10209083376 10625003520 1289655520 13.601 98 40 77 1 1315044656 16428672 8960464
23:41:05 9125 8192000000 10219199760 10618347520 1287324928 13.580 99 44 88 0 1314991632 17806608 9860096
23:42:25 7830 8192000000 10236153776 10643869696 1312259984 13.807 99 41 81 0 1342116112 20038160 9817968
23:43:38 2240 8192000000 10232157008 10630832128 1298536752 13.682 99 68 134 4 1336171968 21359392 16275824
23:44:44 7283 8192000000 10273166240 10669817856 1335702304 14.019 100 78 149 2 1377457568 24277520 17477744
23:45:58 7001 8192000000 10285184304 10687975424 1350591088 14.153 100 64 124 2 1388844624 23824256 14429280
23:47:17 2608 8192000000 10308988832 10711613440 1370764880 14.334 100 75 148 0 1413614992 24708256 18141856
23:48:24 3113 8192000000 10318476000 10724085760 1369402640 14.322 99 66 131 1 1418213728 32624368 16186720
23:49:33 3113 8192000000 10334273968 10742087680 1391046912 14.515 100 70 136 1 1438478032 30260096 17171024
23:50:42 2106 8192000000 10349300896 10761854976 1399615536 14.592 100 70 140 0 1455012192 38001040 17395616
23:51:53 8095 8192000000 10330684768 10759757824 1401119552 14.605 100 52 104 0 1445365104 29841712 14403840
23:53:08 8863 8192000000 10328522576 10761998336 1402281968 14.615 100 43 86 1 1443860944 29377264 12201712
23:54:20 26890 8192000000 10324818192 10757808128 1396212880 14.561 100 31 62 0 1436012160 31089568 8709712
23:55:59 8246 8192000000 10332966768 10759196672 1389535536 14.502 100 44 88 1 1432106240 30425728 12144976
23:57:13 23934 8192000000 10328773744 10770382848 1403792832 14.629 100 30 60 0 1443782000 31635920 8353248
23:58:52 25038 8192000000 10314765920 10766839808 1389229584 14.499 100 26 52 0 1425933632 29704336 6999712
00:00:56 29551 8192000000 10282653888 10735656960 1384018672 14.452 100 6 12 0 1394988416 9753376 1216368
00:02:32 36937 8192000000 10299768608 10753601536 1394268320 14.544 100 24 48 0 1411527424 11653872 5605232
00:04:32 58198 8192000000 10310273808 10758610944 1395324176 14.553 100 33 66 0 1410532816 7618704 7589936
00:06:31 86035 8192000000 10300408560 10767073280 1402709120 14.619 100 21 40 1 1417961728 11631184 3621424
00:09:06 71610 8192000000 10316531584 10768515072 1396690848 14.566 99 13 26 0 1405648096 6319536 2637712
00:11:20 13395 8192000000 10319636592 10773528576 1416291072 14.740 100 19 38 0 1427660352 6861520 4507760
00:12:35 21769 8192000000 10311829696 10757201920 1368548288 14.314 97 26 52 0 1384692992 9629696 6515008
00:14:05 51525 8192000000 10299725808 10757173248 1380646496 14.422 98 16 33 0 1394421904 9927472 3847936
00:16:01 33289 8192000000 10279021808 10735525888 1373663344 14.360 99 15 30 0 1387304192 9994272 3646576
00:18:31 12563 8192000000 10298328832 10743406592 1387090416 14.480 100 38 76 1 1409446320 13313520 9042384
00:19:45 44512 8192000000 10276909232 10739433472 1370943376 14.335 99 15 30 0 1385803760 11227184 3633200
00:21:50 45899 8192000000 10272332912 10722111488 1351695328 14.163 98 16 33 0 1363587952 8349504 3543120
00:23:41 36003 8192000000 10262962128 10693619712 1270180080 13.423 93 20 38 0 1284137936 9323376 4634480
00:25:20 48851 8192000000 10267769792 10713214976 1331617104 13.982 98 17 34 0 1353588672 18046832 3924736
00:27:13 47280 8192000000 10240435152 10679287808 1285821376 13.566 96 8 16 0 1302491904 14923808 1746720
00:29:01 63443 8192000000 10232283456 10668244992 1252507664 13.261 95 10 20 0 1270645104 15874944 2262496
00:31:09 32351 8192000000 10251243184 10683633664 1312588816 13.810 99 23 46 0 1332570208 14376016 5605376
00:32:42 32416 8192000000 10259349520 10690306048 1311695424 13.801 98 50 100 0 1335954944 13473968 10785552
00:34:16 26730 8192000000 10262325728 10681901056 1313327056 13.816 98 54 108 0 1339735776 14857984 11550736
00:35:47 86965 8192000000 10233384992 10678960128 1313694816 13.820 98 29 58 0 1335382080 15226336 6460928
00:38:17 50150 8192000000 10253737152 10703495168 1348469808 14.134 100 18 34 1 1363448368 11474816 3503744
00:40:08 57647 8192000000 10286992432 10731802624 1371648704 14.342 100 19 36 0 1395700416 19567120 4484592
00:42:11 53925 8192000000 10268911872 10728804352 1352975840 14.174 99 8 16 0 1374844160 20451744 1416576
00:44:29 87796 8192000000 10280749024 10722279424 1339933808 14.057 97 11 22 0 1350495488 8519440 2042240
00:47:20 89980 8192000000 10299869104 10749464576 1368873888 14.317 99 14 28 0 1385956016 13971152 3110976
00:49:55 34290 8192000000 10314980064 10757689344 1389359616 14.500 100 24 47 0 1408110192 13571744 5178832
00:51:32 37334 8192000000 10312907136 10760134656 1394211632 14.543 100 41 82 0 1416354624 13142128 9000864
00:53:17 97700 8192000000 10311796896 10764492800 1380240512 14.419 99 10 20 1 1400366640 17870032 2256096
00:56:00 74453 8192000000 10320012752 10770092032 1397364112 14.572 100 13 27 0 1420816560 20546576 2905872
00:58:16 88675 8192000000 10298902032 10761826304 1372070256 14.346 98 47 89 2 1391653968 9118800 10464912
01:00:46 50258 8192000000 10286553296 10737254400 1370995616 14.336 98 29 56 0 1388961312 11878000 6087696
01:02:36 62572 8192000000 10286834752 10753060864 1379565248 14.413 99 7 14 0 1392625072 11555536 1504288
01:05:05 34186 8192000000 10287026528 10740912128 1369738032 14.325 99 16 32 0 1389264304 16384784 3141488
01:06:43 42622 8192000000 10284469504 10734112768 1329113360 13.959 96 17 34 0 1346040944 12978752 3948832
01:08:29 58549 8192000000 10261746688 10711859200 1306444352 13.754 95 23 44 0 1320348832 9076176 4828304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 16-03-2024 01:11:13 to 16-03-2024 01:11:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-03-2024 01:11:28 to 16-03-2024 01:11:30.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sat Mar 16 01:11:31 2024 
 
Database header page information: 
    Flags            0 
    Generation        90818 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    172722 
    Oldest active        174412 
    Oldest snapshot        174412 
    Next transaction    174413 
    Sequence number        0 
    Next attachment ID    706 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.22, total records: 7793562 
    Average version length: 48.16, total versions: 110187, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86800 
    Data pages: 86800, average fill: 72% 
    Primary pages: 86800, secondary pages: 0, swept pages: 16224 
    Empty pages: 3, full pages: 66034 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 112 
    40 - 59% = 1349 
    60 - 79% = 85281 
    80 - 99% = 39 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23317, nodes: 7793562 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1734196, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 335 
        20 - 39% = 1690 
        40 - 59% = 4190 
        60 - 79% = 2241 
        80 - 99% = 14861 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13531, nodes: 7793562 
    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: 1556882, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1529 
        40 - 59% = 2058 
        60 - 79% = 1033 
        80 - 99% = 8911 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8353, nodes: 7793562 
    Average node length: 6.63, total dup: 5811949, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1549885, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 922 
        40 - 59% = 1407 
        60 - 79% = 855 
        80 - 99% = 5047 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.97, total records: 2273775 
    Average version length: 34.58, total versions: 114147, max versions: 3 
    Average fragment length: 10.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28432 
    Data pages: 28432, average fill: 74% 
    Primary pages: 28427, secondary pages: 5, swept pages: 8598 
    Empty pages: 5, full pages: 21734 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 64 
    40 - 59% = 929 
    60 - 79% = 26465 
    80 - 99% = 963 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4586, nodes: 2273775 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 702929, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 884 
        40 - 59% = 874 
        60 - 79% = 686 
        80 - 99% = 2142 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2512, nodes: 2276770 
    Average node length: 4.97, total dup: 2275871, max dup: 21196 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1253953, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 235 
        40 - 59% = 1500 
        60 - 79% = 564 
        80 - 99% = 211 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2047, nodes: 2273775 
    Average node length: 4.97, total dup: 2273725, max dup: 130420 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1066754, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 54 
        40 - 59% = 1113 
        60 - 79% = 42 
        80 - 99% = 832 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4381, nodes: 2273775 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 702929, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 553 
        40 - 59% = 653 
        60 - 79% = 788 
        80 - 99% = 2282 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.36, total records: 400 
    Average version length: 22.89, total versions: 246656, max versions: 643 
    Average fragment length: 2.04, total fragments: 52, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1376 
    Data pages: 1376, average fill: 89% 
    Primary pages: 9, secondary pages: 1367, swept pages: 0 
    Empty pages: 2, full pages: 1373 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1369 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 9.75, total records: 116104 
    Average version length: 68.29, total versions: 99533, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 9.02 
    Pointer pages: 6, data page slots: 3136 
    Data pages: 2520, average fill: 58% 
    Primary pages: 2519, secondary pages: 1, swept pages: 0 
    Empty pages: 436, full pages: 1291 
    Fill distribution: 
     0 - 19% = 632 
    20 - 39% = 198 
    40 - 59% = 244 
    60 - 79% = 334 
    80 - 99% = 1112 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703708, depth: 3, leaf buckets: 401, nodes: 116104 
    Average node length: 13.22, total dup: 9082, max dup: 2 
    Average key length: 10.55, compression ratio: 2.56 
    Average prefix length: 19.36, average data length: 7.64 
    Clustering factor: 82752, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 51 
        40 - 59% = 332 
        60 - 79% = 16 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18707, max versions: 970 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 4, secondary pages: 68, swept pages: 0 
    Empty pages: 3, full pages: 68 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 14 
    80 - 99% = 55 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 4.46, total records: 2242 
    Average version length: 43.42, total versions: 2020, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 13.00 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 54% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 17 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 10 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91478, depth: 2, leaf buckets: 3, nodes: 2242 
    Average node length: 4.15, total dup: 2144, max dup: 240 
    Average key length: 2.47, compression ratio: 7.69 
    Average prefix length: 18.57, average data length: 0.43 
    Clustering factor: 1172, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.92, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.58, total records: 808803 
    Average version length: 25.54, total versions: 88361, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 5, data page slots: 7928 
    Data pages: 7928, average fill: 72% 
    Primary pages: 7911, secondary pages: 17, swept pages: 1013 
    Empty pages: 23, full pages: 7427 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 27 
    40 - 59% = 57 
    60 - 79% = 7407 
    80 - 99% = 398 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 881, nodes: 808803 
    Average node length: 4.87, total dup: 808754, max dup: 149821 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89827, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 122 
        40 - 59% = 487 
        60 - 79% = 201 
        80 - 99% = 69 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 898, nodes: 808803 
    Average node length: 5.88, total dup: 720195, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160959, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 89 
        40 - 59% = 335 
        60 - 79% = 135 
        80 - 99% = 335 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 960, nodes: 808803 
    Average node length: 5.88, total dup: 720195, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162884, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 187 
        40 - 59% = 339 
        60 - 79% = 121 
        80 - 99% = 313 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1155, nodes: 808803 
    Average node length: 5.96, total dup: 720195, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155592, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 257 
        40 - 59% = 608 
        60 - 79% = 209 
        80 - 99% = 79 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.84, total records: 5459 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.82, total fragments: 44, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 72, secondary pages: 24, swept pages: 53 
    Empty pages: 15, full pages: 61 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5459 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5117, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5459 
    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: 146, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 79748 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 776 
    Data pages: 776, average fill: 71% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 768 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 768 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36512, depth: 2, leaf buckets: 101, nodes: 79748 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3281, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 132.34, total records: 190384 
    Average version length: 154.96, total versions: 23479, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.82 
    Pointer pages: 6, data page slots: 8472 
    Data pages: 4640, average fill: 86% 
    Primary pages: 4640, secondary pages: 0, swept pages: 2 
    Empty pages: 99, full pages: 4505 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 12 
    40 - 59% = 12 
    60 - 79% = 10 
    80 - 99% = 4505 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 149.73, total records: 175876 
    Average version length: 149.58, total versions: 1477, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 6, data page slots: 5112 
    Data pages: 4240, average fill: 85% 
    Primary pages: 4240, secondary pages: 0, swept pages: 2 
    Empty pages: 62, full pages: 4160 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 2 
    80 - 99% = 4159 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 149.88, total records: 165079 
    Average version length: 150.18, total versions: 1080, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 6, data page slots: 4856 
    Data pages: 3944, average fill: 86% 
    Primary pages: 3944, secondary pages: 0, swept pages: 1 
    Empty pages: 30, full pages: 3904 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 1 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3903 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 138.24, total records: 186098 
    Average version length: 154.14, total versions: 15798, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.27 
    Pointer pages: 5, data page slots: 6744 
    Data pages: 4552, average fill: 85% 
    Primary pages: 4552, secondary pages: 0, swept pages: 2 
    Empty pages: 114, full pages: 4395 
    Fill distribution: 
     0 - 19% = 118 
    20 - 39% = 11 
    40 - 59% = 13 
    60 - 79% = 15 
    80 - 99% = 4395 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.50, total records: 155709 
    Average version length: 150.94, total versions: 1715, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 6, data page slots: 4720 
    Data pages: 3776, average fill: 85% 
    Primary pages: 3776, secondary pages: 0, swept pages: 1 
    Empty pages: 73, full pages: 3686 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3687 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 150.83, total records: 186374 
    Average version length: 137.34, total versions: 448, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 7, data page slots: 6064 
    Data pages: 4448, average fill: 86% 
    Primary pages: 4448, secondary pages: 0, swept pages: 4 
    Empty pages: 23, full pages: 4413 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4413 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.60, total records: 177593 
    Average version length: 152.66, total versions: 3014, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 7, data page slots: 5672 
    Data pages: 4328, average fill: 85% 
    Primary pages: 4327, secondary pages: 1, swept pages: 1 
    Empty pages: 97, full pages: 4196 
    Fill distribution: 
     0 - 19% = 102 
    20 - 39% = 11 
    40 - 59% = 12 
    60 - 79% = 7 
    80 - 99% = 4196 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 130.84, total records: 194904 
    Average version length: 154.93, total versions: 26087, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.96 
    Pointer pages: 6, data page slots: 8480 
    Data pages: 4848, average fill: 84% 
    Primary pages: 4848, secondary pages: 0, swept pages: 1 
    Empty pages: 154, full pages: 4583 
    Fill distribution: 
     0 - 19% = 160 
    20 - 39% = 14 
    40 - 59% = 80 
    60 - 79% = 11 
    80 - 99% = 4583 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 146.40, total records: 180405 
    Average version length: 153.76, total versions: 5545, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 6136 
    Data pages: 4376, average fill: 85% 
    Primary pages: 4376, secondary pages: 0, swept pages: 5 
    Empty pages: 87, full pages: 4264 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 11 
    80 - 99% = 4263 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 145.97, total records: 163001 
    Average version length: 153.09, total versions: 5254, 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: 6, data page slots: 6048 
    Data pages: 3976, average fill: 85% 
    Primary pages: 3976, secondary pages: 0, swept pages: 1 
    Empty pages: 96, full pages: 3836 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 13 
    40 - 59% = 9 
    60 - 79% = 22 
    80 - 99% = 3834 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.61, total records: 2117774 
    Average version length: 52.97, total versions: 45689, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25536 
    Data pages: 25536, average fill: 71% 
    Primary pages: 25536, secondary pages: 0, swept pages: 10400 
    Empty pages: 207, full pages: 20860 
    Fill distribution: 
     0 - 19% = 382 
    20 - 39% = 418 
    40 - 59% = 1137 
    60 - 79% = 23196 
    80 - 99% = 403 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2600, nodes: 2117774 
    Average node length: 5.44, total dup: 1976735, max dup: 1468 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182791, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 294 
        40 - 59% = 1700 
        60 - 79% = 298 
        80 - 99% = 304 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2117774 
    Average node length: 5.69, total dup: 1900739, max dup: 74 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377887, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2377 
        60 - 79% = 348 
        80 - 99% = 30 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2154, nodes: 2117774 
    Average node length: 4.96, total dup: 2117674, max dup: 28465 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 180444, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 208 
        40 - 59% = 1135 
        60 - 79% = 382 
        80 - 99% = 428 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 34.29, total records: 164813 
    Average version length: 69.18, total versions: 83175, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.67 
    Pointer pages: 3, data page slots: 4128 
    Data pages: 3128, average fill: 62% 
    Primary pages: 3128, secondary pages: 0, swept pages: 423 
    Empty pages: 602, full pages: 2090 
    Fill distribution: 
     0 - 19% = 726 
    20 - 39% = 12 
    40 - 59% = 58 
    60 - 79% = 896 
    80 - 99% = 1436 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104755, depth: 3, leaf buckets: 232, nodes: 164813 
    Average node length: 6.47, total dup: 143511, max dup: 14 
    Average key length: 3.92, compression ratio: 10.72 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 27900, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 22 
        40 - 59% = 114 
        60 - 79% = 72 
        80 - 99% = 23 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.15, total records: 7127078 
    Average version length: 68.76, total versions: 497571, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 62, data page slots: 101000 
    Data pages: 101000, average fill: 76% 
    Primary pages: 101000, secondary pages: 0, swept pages: 19016 
    Empty pages: 8, full pages: 84615 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 402 
    40 - 59% = 3930 
    60 - 79% = 87250 
    80 - 99% = 9371 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10618, nodes: 7127078 
    Average node length: 6.51, total dup: 6165114, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1578226, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1480 
        40 - 59% = 5810 
        60 - 79% = 2677 
        80 - 99% = 642 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8447, nodes: 7127078 
    Average node length: 5.39, total dup: 6844733, max dup: 185 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1375700, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1066 
        40 - 59% = 4555 
        60 - 79% = 1703 
        80 - 99% = 1114 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8484, nodes: 7127078 
    Average node length: 5.39, total dup: 6844733, max dup: 185 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1378165, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1118 
        40 - 59% = 4503 
        60 - 79% = 1726 
        80 - 99% = 1125 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.63, total records: 12085391 
    Average version length: 68.72, total versions: 406607, 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: 103, data page slots: 167056 
    Data pages: 167056, average fill: 77% 
    Primary pages: 167056, secondary pages: 0, swept pages: 67418 
    Empty pages: 0, full pages: 159495 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 262 
    40 - 59% = 2030 
    60 - 79% = 156258 
    80 - 99% = 8488 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18239, nodes: 12085391 
    Average node length: 6.58, total dup: 10534722, max dup: 79 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2371105, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2262 
        40 - 59% = 10638 
        60 - 79% = 4304 
        80 - 99% = 1011 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 39.27, total records: 1730992 
    Average version length: 69.13, total versions: 748185, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.21 
    Pointer pages: 26, data page slots: 41328 
    Data pages: 29784, average fill: 67% 
    Primary pages: 29784, secondary pages: 0, swept pages: 6164 
    Empty pages: 2584, full pages: 21084 
    Fill distribution: 
     0 - 19% = 4360 
    20 - 39% = 1756 
    40 - 59% = 1411 
    60 - 79% = 10282 
    80 - 99% = 11975 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2199, nodes: 1730992 
    Average node length: 5.51, total dup: 1661200, max dup: 99 
    Average key length: 2.55, compression ratio: 16.47 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 115325, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 433 
        40 - 59% = 1024 
        60 - 79% = 554 
        80 - 99% = 179 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.14, total records: 1289178 
    Average version length: 69.13, total versions: 632785, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.59 
    Pointer pages: 21, data page slots: 33664 
    Data pages: 28008, average fill: 54% 
    Primary pages: 28008, secondary pages: 0, swept pages: 5197 
    Empty pages: 5391, full pages: 14879 
    Fill distribution: 
     0 - 19% = 8105 
    20 - 39% = 1760 
    40 - 59% = 1401 
    60 - 79% = 6264 
    80 - 99% = 10478 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1696, nodes: 1289178 
    Average node length: 5.76, total dup: 1206830, max dup: 107 
    Average key length: 2.82, compression ratio: 14.88 
    Average prefix length: 41.24, average data length: 0.76 
    Clustering factor: 171808, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 267 
        40 - 59% = 841 
        60 - 79% = 469 
        80 - 99% = 114 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.84, total records: 9375017 
    Average version length: 68.98, total versions: 551140, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 89, data page slots: 143856 
    Data pages: 143856, average fill: 70% 
    Primary pages: 143856, secondary pages: 0, swept pages: 49663 
    Empty pages: 261, full pages: 82128 
    Fill distribution: 
     0 - 19% = 930 
    20 - 39% = 4615 
    40 - 59% = 19943 
    60 - 79% = 109774 
    80 - 99% = 8594 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13483, nodes: 9375017 
    Average node length: 6.68, total dup: 7779123, max dup: 27 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2021391, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1212 
        40 - 59% = 6464 
        60 - 79% = 4986 
        80 - 99% = 819 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21149606 
    Average version length: 83.01, total versions: 15548, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318720 
    Data pages: 318720, average fill: 81% 
    Primary pages: 318720, secondary pages: 0, swept pages: 12238 
    Empty pages: 22, full pages: 318185 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 41 
    40 - 59% = 80 
    60 - 79% = 27265 
    80 - 99% = 291302 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19323, nodes: 21149606 
    Average node length: 5.72, total dup: 20668721, max dup: 129 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3282440, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8016 
        60 - 79% = 553 
        80 - 99% = 10746 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17178, nodes: 21149606 
    Average node length: 6.31, total dup: 18586554, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914950, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 3 
        40 - 59% = 791 
        60 - 79% = 288 
        80 - 99% = 16092 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21106, nodes: 21149606 
    Average node length: 6.35, total dup: 18505339, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3576273, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 8267 
        60 - 79% = 668 
        80 - 99% = 12166 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16155, nodes: 21149606 
    Average node length: 5.56, total dup: 21149506, max dup: 232742 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943750, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 3004 
        60 - 79% = 399 
        80 - 99% = 12745 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.02, total records: 9801181 
    Average version length: 82.66, total versions: 522670, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 103, data page slots: 167184 
    Data pages: 167144, average fill: 72% 
    Primary pages: 167144, secondary pages: 0, swept pages: 65673 
    Empty pages: 349, full pages: 105595 
    Fill distribution: 
     0 - 19% = 1027 
    20 - 39% = 4256 
    40 - 59% = 19500 
    60 - 79% = 76341 
    80 - 99% = 66020 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11362, nodes: 9801181 
    Average node length: 5.36, total dup: 9490770, max dup: 207 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2161621, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 44 
        40 - 59% = 7948 
        60 - 79% = 3223 
        80 - 99% = 146 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13572, nodes: 9801181 
    Average node length: 6.23, total dup: 8127184, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1501612, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 4033 
        40 - 59% = 4256 
        60 - 79% = 2545 
        80 - 99% = 2609 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12697, nodes: 9801181 
    Average node length: 5.98, total dup: 8508729, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2358685, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 57 
        40 - 59% = 8935 
        60 - 79% = 3544 
        80 - 99% = 158 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10210, nodes: 9801181 
    Average node length: 5.13, total dup: 9801081, max dup: 166944 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1519275, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1226 
        40 - 59% = 5132 
        60 - 79% = 1720 
        80 - 99% = 2096 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.59, total records: 11409643 
    Average version length: 82.62, total versions: 376276, 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: 119, data page slots: 194072 
    Data pages: 192488, average fill: 73% 
    Primary pages: 192488, secondary pages: 0, swept pages: 72910 
    Empty pages: 2965, full pages: 142247 
    Fill distribution: 
     0 - 19% = 4955 
    20 - 39% = 7337 
    40 - 59% = 19320 
    60 - 79% = 43670 
    80 - 99% = 117206 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13138, nodes: 11409643 
    Average node length: 5.30, total dup: 11299555, max dup: 643 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2378556, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 147 
        40 - 59% = 8813 
        60 - 79% = 3954 
        80 - 99% = 224 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10530, nodes: 11409643 
    Average node length: 5.50, total dup: 10912462, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 721039, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 827 
        40 - 59% = 2569 
        60 - 79% = 1934 
        80 - 99% = 5040 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15037, nodes: 11409643 
    Average node length: 6.03, total dup: 9958066, max dup: 85 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2395064, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 202 
        40 - 59% = 10311 
        60 - 79% = 4265 
        80 - 99% = 256 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10844, nodes: 11409643 
    Average node length: 5.23, total dup: 11409543, max dup: 214840 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 710049, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 87 
        20 - 39% = 811 
        40 - 59% = 4873 
        60 - 79% = 1485 
        80 - 99% = 3588 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.51, total records: 9899305 
    Average version length: 82.93, total versions: 505138, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 105, data page slots: 171064 
    Data pages: 171056, average fill: 72% 
    Primary pages: 171056, secondary pages: 0, swept pages: 70616 
    Empty pages: 439, full pages: 104130 
    Fill distribution: 
     0 - 19% = 1245 
    20 - 39% = 5014 
    40 - 59% = 22196 
    60 - 79% = 78927 
    80 - 99% = 63674 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11937, nodes: 9899305 
    Average node length: 5.17, total dup: 9870168, max dup: 2583 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1954921, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1449 
        40 - 59% = 7987 
        60 - 79% = 1882 
        80 - 99% = 584 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13697, nodes: 9899305 
    Average node length: 6.24, total dup: 8208518, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1464337, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 204 
        20 - 39% = 3968 
        40 - 59% = 4259 
        60 - 79% = 2545 
        80 - 99% = 2721 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12579, nodes: 9899305 
    Average node length: 5.43, total dup: 9457695, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2092303, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1404 
        40 - 59% = 8922 
        60 - 79% = 1659 
        80 - 99% = 565 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10296, nodes: 9899305 
    Average node length: 5.14, total dup: 9899205, max dup: 169126 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1535448, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1162 
        40 - 59% = 5245 
        60 - 79% = 1740 
        80 - 99% = 2115 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.42, total records: 576618 
    Average version length: 68.79, total versions: 6328, 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: 8000 
    Data pages: 8000, average fill: 75% 
    Primary pages: 8000, secondary pages: 0, swept pages: 3820 
    Empty pages: 5, full pages: 6725 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 7 
    40 - 59% = 182 
    60 - 79% = 7703 
    80 - 99% = 103 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46082, depth: 3, leaf buckets: 741, nodes: 576618 
    Average node length: 5.95, total dup: 490965, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100249, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 536 
        60 - 79% = 95 
        80 - 99% = 82 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33468, depth: 3, leaf buckets: 756, nodes: 576618 
    Average node length: 6.15, total dup: 472851, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100299, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 529 
        60 - 79% = 96 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 576, nodes: 576618 
    Average node length: 4.86, total dup: 576518, max dup: 9900 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88944, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 341 
        60 - 79% = 89 
        80 - 99% = 115 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Mar 16 01:11:55 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7793562 110187 1 0.0000 0.0000
DOC_LIST 2273775 114147 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 246656 643 61600.0000 0.0000
INVNT_TURNOVER_LOG 116104 99533 1 0.0000 0.0000
MONEY_SALDO 49 18707 970 38100.0000 0.0000
MONEY_TURNOVER_LOG 2242 2020 1 0.0000 0.0000
PDISTR 808803 88361 4 0.0000 0.0000
PERF_SPLIT_0 190384 23479 1 0.0000 0.0000
PERF_SPLIT_1 175876 1477 1 0.0000 0.0000
PERF_SPLIT_2 165079 1080 1 0.0000 0.0000
PERF_SPLIT_3 186098 15798 1 0.0000 0.0000
PERF_SPLIT_4 155709 1715 1 0.0000 0.0000
PERF_SPLIT_5 186374 448 1 0.0000 0.0000
PERF_SPLIT_6 177593 3014 1 0.0000 0.0000
PERF_SPLIT_7 194904 26087 1 0.0000 0.0000
PERF_SPLIT_8 180405 5545 1 0.0000 0.0000
PERF_SPLIT_9 163001 5254 1 0.0000 0.0000
PSTORNED 2117774 45689 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 164813 83175 1 0.0000 0.0000
XQD_1000_3300 7127078 497571 1 0.0000 0.0000
XQD_1200_2000 12085391 406607 1 0.0000 0.0000
XQD_2000_3300 1730992 748185 1 0.0000 0.0000
XQD_2100_3300 1289178 632785 1 0.0000 0.0000
XQD_3300_3400 9375017 551140 1 0.0000 0.0000
XQS_1000_1200 21149606 15548 1 0.0000 0.0000
XQS_1000_3300 9801181 522670 1 0.0000 0.0000
XQS_1200_2000 11409643 376276 1 0.0000 0.0000
XQS_2100_3300 9899305 505138 1 0.0000 0.0000
XQS_3300_3400 576618 6328 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 ---
:393: 
:394: mscs-test-161.budzdorov.ru    Sat Mar 16 01:10:01 2024
:395:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:396: 
:397: 
:398: mscs-test-161.budzdorov.ru    Sat Mar 16 01:10:01 2024
:399:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:400: 
--- end of diff output ---

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

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