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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15580876 kB
MemAvailable 30144260 kB
Buffers 0 kB
Cached 16183044 kB
SwapCached 2512 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-04-08 19:09:48
DTS_END                         2024-04-08 19:09:48.8110
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39194
TRN_ID                          174247
ATT_ID                          547
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: 9118.33 18434 911833
customer order: creation 172.44 378 17244
customer order: refuse 15.50 377 1550
order to supplier: creation 45.22 1370 4522
order to supplier: removal 3.70 88782 370
invoice (draft): creation 45.77 3639 4577
invoice (draft): removal 49.80 740 4980
invoice accept: apply 42.49 20876 4249
invoice accept: cancel 44.23 874 4423
customer reserve: creation 3992.11 205 399211
customer reserve: removal 4410.23 59 441023
realization accept: apply 85.62 208 8562
realization accept: cancel 79.49 114 7949
payment from customer: creation 60.27 152 6027
payment from customer: removal 5.85 98 585
payment to supplier: creation 49.09 151 4909
payment to supplier: removal 3.75 99 375
service: total inventory turnovers 4.78 1059 478
service: total monetary turnovers 7.07 30 707
service: aggregate perf. data 0.89 17676 89
service: refresh index statistics 0.03 231802 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 08-04-2024 19:11:48 to 08-04-2024 19:11:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2864
TEST_TIME 2 3149
TEST_TIME 3 3508
TEST_TIME 4 3425
TEST_TIME 5 3770
TEST_TIME 6 4193
TEST_TIME 7 4591
TEST_TIME 8 4706
TEST_TIME 9 5221
TEST_TIME 10 5209
TEST_TIME 11 5424
TEST_TIME 12 5287
TEST_TIME 13 5725
TEST_TIME 14 6066
TEST_TIME 15 6119
TEST_TIME 16 6413
TEST_TIME 17 6697
TEST_TIME 18 7080
TEST_TIME 19 7102
TEST_TIME 20 7578
TEST_TIME 21 7481
TEST_TIME 22 8129
TEST_TIME 23 8411
TEST_TIME 24 8219
TEST_TIME 25 8327
TEST_TIME 26 8316
TEST_TIME 27 8521
TEST_TIME 28 8664
TEST_TIME 29 8589
TEST_TIME 30 8729
TEST_TIME 31 8987
TEST_TIME 32 8866
TEST_TIME 33 8920
TEST_TIME 34 8866
TEST_TIME 35 8936
TEST_TIME 36 9064
TEST_TIME 37 9085
TEST_TIME 38 9034
TEST_TIME 39 8839
TEST_TIME 40 8868
TEST_TIME 41 8862
TEST_TIME 42 8748
TEST_TIME 43 8742
TEST_TIME 44 8828
TEST_TIME 45 8780
TEST_TIME 46 8710
TEST_TIME 47 8741
TEST_TIME 48 8703
TEST_TIME 49 8707
TEST_TIME 50 8970
TEST_TIME 51 9057
TEST_TIME 52 9194
TEST_TIME 53 9108
TEST_TIME 54 9078
TEST_TIME 55 9236
TEST_TIME 56 9345
TEST_TIME 57 9272
TEST_TIME 58 9265
TEST_TIME 59 9372
TEST_TIME 60 9450
TEST_TIME 61 9395
TEST_TIME 62 9284
TEST_TIME 63 9253
TEST_TIME 64 9239
TEST_TIME 65 9158
TEST_TIME 66 9142
TEST_TIME 67 9196
TEST_TIME 68 9168
TEST_TIME 69 9115
TEST_TIME 70 9072
TEST_TIME 71 9054
TEST_TIME 72 8990
TEST_TIME 73 9042
TEST_TIME 74 9081
TEST_TIME 75 9089
TEST_TIME 76 9141
TEST_TIME 77 9104
TEST_TIME 78 9133
TEST_TIME 79 9189
TEST_TIME 80 9164
TEST_TIME 81 9165
TEST_TIME 82 9186
TEST_TIME 83 9254
TEST_TIME 84 9292
TEST_TIME 85 9320
TEST_TIME 86 9296
TEST_TIME 87 9376
TEST_TIME 88 9346
TEST_TIME 89 9271
TEST_TIME 90 9339
TEST_TIME 91 9265
TEST_TIME 92 9280
TEST_TIME 93 9277
TEST_TIME 94 9242
TEST_TIME 95 9226
TEST_TIME 96 9246
TEST_TIME 97 9198
TEST_TIME 98 9166
TEST_TIME 99 9125
TEST_TIME 100 9126

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-04-2024 19:11:52 to 08-04-2024 19:11:55.

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 1277336 1277336 0 0.00 0 34607 7 0 0
doc_list_biud 1277336 1277336 0 0.00 0 42181 26 0 0
sp_add_invoice_to_stock 4359 4249 110 2.52 45 217503 20877 0 110
sp_cancel_adding_invoice 4423 4423 0 0.00 5 68276 875 0 0
sp_cancel_client_order 1550 1550 0 0.00 3 10445 378 0 0
sp_cancel_customer_reserve 441023 441023 0 0.00 0 42187 59 0 0
sp_cancel_pay_from_customer 585 585 0 0.00 2 5382 98 0 0
sp_cancel_pay_to_supplier 375 375 0 0.00 2 9565 99 0 0
sp_cancel_supplier_invoice 4988 4980 8 0.16 2 14091 741 0 8
sp_cancel_supplier_order 370 370 0 0.00 4 882392 88783 0 0
sp_cancel_write_off 7949 7949 0 0.00 1 20597 115 0 0
sp_client_order 17244 17244 0 0.00 3 24603 379 0 0
sp_customer_reserve 399211 399211 0 0.00 0 108005 205 0 0
sp_fill_shopping_cart 26337 26337 0 0.00 1 24397 40 0 0
sp_fill_shopping_cart_clo_res 399199 399199 0 0.00 0 15342 14 0 0
sp_get_clo_for_invoice 4235 4235 0 0.00 0 24278 273 0 0
sp_kill_cost_storno 13332 13332 0 0.00 0 9936 61 0 0
sp_kill_qstorno_ret_qs2qd 895345 895345 0 0.00 0 42148 32 0 0
sp_kill_qty_storno 473090 473090 0 0.00 0 42180 70 0 0
sp_lock_selected_doc 17711 17711 0 0.00 0 8597 6 0 0
sp_make_cost_storno 23731 23731 0 0.00 0 34579 75 0 0
sp_multiply_rows_for_pdistr 23731 23731 0 0.00 0 9261 34 0 0
sp_multiply_rows_for_qdistr 17244 17244 0 0.00 0 24091 185 0 0
sp_pay_from_customer 6027 6027 0 0.00 4 21507 153 0 0
sp_pay_to_supplier 4909 4909 0 0.00 4 20059 152 0 0
sp_payment_common 10936 10936 0 0.00 1 17893 35 0 0
sp_qd_handle_on_cancel_clo 1550 1550 0 0.00 0 10437 326 0 0
sp_qd_handle_on_invoice_upd_sts 8656 8656 0 0.00 0 25796 336 0 0
sp_qd_handle_on_reserve_upd_sts 8562 8562 0 0.00 0 8761 66 0 0
sp_reserve_write_off 8562 8562 0 0.00 6 34642 209 0 0
sp_supplier_invoice 4577 4577 0 0.00 6 82179 3640 0 0
sp_supplier_order 4522 4522 0 0.00 5 68827 1371 0 0
srv_aggregate_perf_data 89 89 0 0.00 2099 303070 17676 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1157 116561 36898 0 0
srv_find_qd_qs_mism 869269 869269 0 0.00 0 22924 6 0 0
srv_make_invnt_saldo 478 478 0 0.00 40 24069 1059 0 0
srv_make_money_saldo 707 707 0 0.00 1 1759 31 0 0
srv_recalc_idx_stat 3 3 0 0.00 153474 281340 231802 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4249 4249 0 0.00 0 11037 187 0 0
t$perf-norm:sp_cancel_adding_invoice 330 330 0 0.00 0 2707 106 0 0
t$perf-norm:sp_cancel_client_order 1550 1550 0 0.00 0 2865 12 0 0
t$perf-norm:sp_cancel_customer_reserve 549 549 0 0.00 0 866 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 585 585 0 0.00 0 447 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 375 375 0 0.00 0 1316 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 962 14 0 0
t$perf-norm:sp_cancel_supplier_order 370 370 0 0.00 0 36870 1753 0 0
t$perf-norm:sp_cancel_write_off 825 825 0 0.00 0 2897 11 0 0
t$perf-norm:sp_client_order 17244 17244 0 0.00 0 10946 18 0 0
t$perf-norm:sp_customer_reserve 867 867 0 0.00 0 1562 8 0 0
t$perf-norm:sp_pay_from_customer 6027 6027 0 0.00 0 10315 11 0 0
t$perf-norm:sp_pay_to_supplier 4909 4909 0 0.00 0 9192 14 0 0
t$perf-norm:sp_reserve_write_off 8562 8562 0 0.00 0 8272 13 0 0
t$perf-norm:sp_supplier_invoice 4577 4577 0 0.00 0 11104 24 0 0
t$perf-norm:sp_supplier_order 4522 4522 0 0.00 0 4502 19 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 385 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 47 2 0 0
t$perf-norm:srv_make_invnt_saldo 478 478 0 0.00 0 1664 23 0 0
t$perf-norm:srv_make_money_saldo 707 707 0 0.00 0 2209 24 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 8686 8466 220 2.53 0 9230 21 0 220
v_all_customers 31800 31800 0 0.00 0 22 1 0 0
v_all_suppliers 25828 25828 0 0.00 0 16 1 0 0
v_all_wares 34488 34488 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 660 660 0 0.00 0 641 8 0 0
v_cancel_client_order 3100 3100 0 0.00 0 3832 8 0 0
v_cancel_customer_prepayment 1170 1170 0 0.00 0 5028 14 0 0
v_cancel_customer_reserve 1098 1098 0 0.00 0 853 5 0 0
v_cancel_payment_to_supplier 750 750 0 0.00 0 972 8 0 0
v_cancel_supplier_invoice 680 664 16 2.35 0 3189 18 0 16
v_cancel_supplier_order 740 740 0 0.00 0 1062 5 0 0
v_cancel_write_off 1650 1650 0 0.00 0 3317 15 0 0
v_max_id_clo_ord 4522 4522 0 0.00 0 948 2 0 0
v_max_id_clo_res 867 867 0 0.00 0 1940 9 0 0
v_max_id_ord_sup 4571 4571 0 0.00 0 4066 3 0 0
v_max_non_paid_invoice 1088 1088 0 0.00 0 647 4 0 0
v_max_non_paid_realizn 3008 3008 0 0.00 0 17888 10 0 0
v_min_id_clo_ord 4522 4522 0 0.00 0 24351 31 0 0
v_min_id_clo_res 867 867 0 0.00 0 6461 14 0 0
v_min_id_ord_sup 4571 4571 0 0.00 0 3781 5 0 0
v_min_non_paid_invoice 4909 4909 0 0.00 0 5793 24 0 0
v_min_non_paid_realizn 6027 6027 0 0.00 0 11465 24 0 0
v_our_firm 8726 8726 0 0.00 0 66 1 0 0
v_reserve_write_off 17124 17124 0 0.00 0 4982 7 0 0
x_lock_depdocs_on_canc_invoice 9071 9071 0 0.00 0 17204 140 0 0
x_lock_depdocs_on_canc_sup_ord 370 370 0 0.00 0 18589 350 0 0
x_make_qstorno_1000_1200 4522 4522 0 0.00 1 68821 1270 0 0
x_make_qstorno_1200_2000 4577 4577 0 0.00 3 82168 3507 0 0
x_make_qstorno_2100_3300 399211 399211 0 0.00 0 108003 188 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-04-2024 19:11:56 to 08-04-2024 19:12:00.

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
17:09:52 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:53 37462 8192000000 9909739328 10221088768 990623840 10.788 100 89 178 0 1019857888 6198160 23035888
17:12:37 17438 8192000000 9953398928 10274799616 1035357056 11.220 100 94 188 0 1068517632 9023488 24137088
17:14:00 15815 8192000000 9976428880 10309763072 1061718864 11.473 100 80 160 0 1091417136 9855552 19842720
17:15:18 14210 8192000000 10033390976 10380500992 1122360624 12.049 100 82 162 0 1151895792 10423296 19111872
17:16:41 5310 8192000000 10081525936 10438336512 1164850496 12.449 100 81 162 1 1195558608 12350768 18357344
17:17:48 5069 8192000000 10115027024 10483527680 1206145872 12.833 100 85 164 2 1237401968 12608640 18647456
17:18:55 1776 8192000000 10155832048 10528886784 1245401504 13.196 100 87 176 0 1277864400 13194288 19268608
17:19:58 1159 8192000000 10182916256 10564481024 1274195424 13.460 100 85 170 0 1306135680 13122432 18817824
17:21:01 1162 8192000000 10216861408 10602483712 1299894432 13.694 100 82 163 2 1329240544 11875488 17470624
17:22:04 42393 8192000000 10197749632 10607448064 1305359840 13.744 100 26 52 0 1318011888 6930640 5721408
17:23:50 7551 8192000000 10208101120 10619465728 1316524912 13.845 100 28 54 1 1328907168 5442448 6939808
17:24:59 10191 8192000000 10208584416 10629115904 1323605568 13.909 100 20 40 0 1334591232 6677776 4307888
17:26:12 17104 8192000000 10221988416 10639659008 1329088784 13.959 100 23 46 0 1344073104 10542400 4441920
17:27:29 11382 8192000000 10239413872 10645176320 1330482896 13.972 100 66 132 1 1352105968 5660736 15962336
17:28:41 6113 8192000000 10217212272 10639532032 1331128416 13.977 100 27 52 0 1343148368 6276752 5743200
17:29:51 18447 8192000000 10219352976 10630324224 1307904128 13.767 99 33 63 0 1321477312 6286448 7286736
17:31:32 69052 8192000000 10213771360 10633433088 1308313936 13.771 98 47 92 1 1330708816 11102800 11292080
17:33:55 40653 8192000000 10225761680 10636800000 1290390176 13.608 97 29 58 0 1309977984 12897120 6690688
17:35:46 7941 8192000000 10229081264 10637135872 1314069104 13.823 100 53 105 4 1343246432 16493856 12683472
17:37:03 31995 8192000000 10244917888 10648133632 1303444336 13.727 98 55 110 0 1335866880 19729072 12693472
17:38:45 22349 8192000000 10231952528 10633449472 1303787152 13.730 99 57 114 1 1334253536 17036144 13430240
17:40:11 11053 8192000000 10238923456 10641272832 1307536672 13.764 99 51 102 0 1339673888 19889968 12247248
17:41:28 12380 8192000000 10237016240 10633510912 1310892128 13.794 99 62 123 0 1347059424 21729200 14438096
17:42:45 11628 8192000000 10237564784 10641997824 1293087840 13.632 98 52 104 2 1333802672 28314544 12400288
17:44:01 10770 8192000000 10265493776 10671550464 1333509888 13.999 100 49 98 1 1371640160 25864048 12266224
17:45:18 3300 8192000000 10268762272 10671837184 1343445520 14.088 100 76 148 0 1382290464 20575216 18269728
17:46:27 5904 8192000000 10278317104 10687553536 1349146656 14.140 100 59 115 1 1388249296 24524000 14578640
17:47:38 1156 8192000000 10294289264 10687639552 1348898672 14.138 100 78 153 0 1392657248 25545744 18212832
17:48:44 3654 8192000000 10297359984 10705338368 1361234224 14.248 100 67 134 2 1400754960 22771504 16749232
17:49:49 7679 8192000000 10291078784 10719068160 1372789024 14.352 100 34 67 2 1404259424 23304192 8166208
17:50:59 5090 8192000000 10313420512 10732097536 1379554416 14.413 100 69 135 2 1417856672 21492272 16809984
17:52:07 22557 8192000000 10290567664 10734882816 1380163024 14.418 100 22 45 1 1406545744 20641568 5741152
17:53:36 4214 8192000000 10335889280 10753642496 1398040608 14.578 100 86 172 1 1435441072 16301952 21098512
17:54:42 29595 8192000000 10333875936 10765852672 1403828464 14.629 100 47 94 0 1431824352 16822416 11173472
17:56:23 20240 8192000000 10311397744 10756296704 1391363792 14.518 100 20 40 0 1417391280 20775536 5251952
17:58:08 35106 8192000000 10300336240 10732806144 1383810704 14.451 100 35 70 2 1401946432 9664000 8471728
17:59:56 30370 8192000000 10298404752 10756382720 1392508032 14.528 100 10 20 0 1410035936 14922864 2605040
18:01:57 8832 8192000000 10323043504 10752077824 1396307952 14.562 100 69 126 4 1418951280 8081056 14562272
18:03:13 27139 8192000000 10318368416 10756816896 1402704160 14.619 100 43 85 0 1424504912 12577216 9223536
18:04:42 47072 8192000000 10302791408 10766565376 1391057328 14.515 99 11 23 0 1409395968 16027152 2311488
18:06:32 32151 8192000000 10308793888 10758197248 1393013408 14.533 99 29 59 1 1407283840 8053136 6217296
18:08:54 61763 8192000000 10327341584 10772185088 1410587088 14.689 100 41 80 0 1431601456 12458976 8555392
18:11:00 56897 8192000000 10320231520 10770227200 1401953568 14.612 99 30 57 1 1422271888 14192448 6125872
18:12:58 10226 8192000000 10340285440 10782384128 1407651824 14.663 99 48 96 2 1439822080 20741104 11429152
18:14:14 21494 8192000000 10322440208 10768142336 1400043680 14.595 99 41 81 2 1432039104 22501056 9494368
18:15:40 53403 8192000000 10314457296 10770923520 1379277536 14.410 98 21 42 0 1409342624 24691328 5373760
18:17:38 41347 8192000000 10292059680 10742116352 1348715392 14.136 97 21 43 0 1381986832 27856624 5414816
18:19:21 17751 8192000000 10308239488 10757320704 1373348352 14.357 99 31 60 1 1410392960 29762736 7281872
18:20:43 44080 8192000000 10269072736 10722050048 1339093328 14.049 97 18 36 0 1356275936 12816608 4366000
18:22:28 16890 8192000000 10296608880 10733158400 1364930336 14.282 99 43 86 0 1384098096 9485888 9681872
18:23:50 34117 8192000000 10298576800 10751209472 1389117696 14.498 100 14 28 0 1408478896 15884320 3476880
18:25:24 108080 8192000000 10248303152 10692141056 1155405184 12.360 84 10 20 0 1174645072 17017264 2222624
18:28:34 86585 8192000000 10247420624 10692943872 1276922208 13.485 95 13 26 0 1296277728 16530688 2824832
18:31:01 87738 8192000000 10273519904 10704306176 1352982592 14.174 100 49 96 0 1375001312 11023856 10994864
18:33:47 31455 8192000000 10259984560 10701901824 1343149312 14.086 99 32 64 0 1363048336 12620688 7278336
18:35:20 24555 8192000000 10266757392 10710097920 1350505584 14.152 99 37 74 0 1371333792 12315568 8512640
18:36:47 61345 8192000000 10225140624 10676719616 1284359680 13.553 96 12 24 0 1298901504 11650416 2891408
18:38:49 44001 8192000000 10247636080 10695299072 1329517968 13.963 99 12 24 0 1343246928 10967872 2761088
18:40:38 62808 8192000000 10262755216 10710695936 1347186176 14.122 99 17 34 0 1358897568 8131872 3579520
18:42:44 66407 8192000000 10266677184 10721587200 1336841648 14.029 98 9 18 0 1350979312 11614224 2523440
18:44:53 59553 8192000000 10276722256 10735824896 1367579568 14.305 99 22 44 0 1384221728 12031568 4610592
18:46:55 19040 8192000000 10284332032 10729336832 1376958560 14.389 100 44 88 0 1396565328 8049440 11557328
18:48:17 61605 8192000000 10291629392 10738835456 1381975072 14.434 100 15 30 0 1399397840 14295008 3127760
18:50:19 35916 8192000000 10306350896 10747936768 1378637568 14.404 99 37 73 1 1395566368 8892544 8036256
18:51:56 60251 8192000000 10309215536 10775306240 1387207264 14.481 99 27 52 1 1406757360 13547744 6002352
18:53:56 116561 8192000000 10317014832 10771492864 1332363664 13.989 95 17 34 1 1349364752 13261984 3739104
18:56:53 100331 8192000000 10289012432 10744586240 1361822336 14.254 98 12 24 0 1378548192 13810304 2915552
18:59:40 51158 8192000000 10285485664 10756988928 1375066976 14.372 99 6 12 0 1389898080 13180176 1650928
19:01:32 1837 8192000000 10318733680 10766147584 1406910080 14.656 100 54 109 4 1431089168 11955920 12223168
19:02:36 53586 8192000000 10296608144 10760888320 1387725904 14.486 99 11 22 0 1403936848 13846608 2364336
19:04:38 41020 8192000000 10293629520 10746277888 1367412624 14.304 98 23 46 0 1387344880 14727600 5204656
19:08:18 50966 8192000000 10287952736 10746130432 1359288528 14.231 98 19 38 0 1381696432 18578544 3829360

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 08-04-2024 19:12:02 to 08-04-2024 19:12:16.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-04-2024 19:12:17 to 08-04-2024 19:12:19.

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          172271
MON$OLDEST_ACTIVE               174365
MON$OLDEST_SNAPSHOT             174365
MON$NEXT_TRANSACTION            174365
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                       1912096
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Mon Apr  8 19:12:20 2024 
 
Database header page information: 
    Flags            0 
    Generation        90854 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    172271 
    Oldest active        174365 
    Oldest snapshot        174365 
    Next transaction    174366 
    Sequence number        0 
    Next attachment ID    707 
    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.49, total records: 7720937 
    Average version length: 48.16, total versions: 64166, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87256 
    Data pages: 87256, average fill: 71% 
    Primary pages: 87256, secondary pages: 0, swept pages: 25440 
    Empty pages: 3, full pages: 57050 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 222 
    40 - 59% = 3431 
    60 - 79% = 83564 
    80 - 99% = 10 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23232, nodes: 7720937 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1695155, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 320 
        20 - 39% = 2058 
        40 - 59% = 3890 
        60 - 79% = 2361 
        80 - 99% = 14603 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13499, nodes: 7720937 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1518243, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1736 
        40 - 59% = 1888 
        60 - 79% = 1093 
        80 - 99% = 8782 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8337, nodes: 7720937 
    Average node length: 6.61, total dup: 5779055, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1511182, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 1062 
        40 - 59% = 1293 
        60 - 79% = 912 
        80 - 99% = 4934 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.61, total records: 2231441 
    Average version length: 34.80, total versions: 63989, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28672 
    Data pages: 28672, average fill: 72% 
    Primary pages: 28667, secondary pages: 5, swept pages: 12843 
    Empty pages: 7, full pages: 17608 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 146 
    40 - 59% = 2065 
    60 - 79% = 26074 
    80 - 99% = 360 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4551, nodes: 2231441 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 689029, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 991 
        40 - 59% = 785 
        60 - 79% = 719 
        80 - 99% = 2056 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2527, nodes: 2233591 
    Average node length: 4.97, total dup: 2232692, max dup: 18881 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1232598, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 284 
        40 - 59% = 1548 
        60 - 79% = 519 
        80 - 99% = 175 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2061, nodes: 2231441 
    Average node length: 4.97, total dup: 2231391, max dup: 130371 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061181, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 115 
        40 - 59% = 1068 
        60 - 79% = 49 
        80 - 99% = 826 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4296, nodes: 2231441 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 689029, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 602 
        40 - 59% = 556 
        60 - 79% = 820 
        80 - 99% = 2232 
 
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.42, total records: 400 
    Average version length: 23.12, total versions: 236487, max versions: 614 
    Average fragment length: 2.06, total fragments: 50, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1328, average fill: 89% 
    Primary pages: 14, secondary pages: 1314, swept pages: 0 
    Empty pages: 7, full pages: 1320 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1320 
 
    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: 12.32, total records: 85131 
    Average version length: 68.28, total versions: 69784, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.14 
    Pointer pages: 6, data page slots: 3136 
    Data pages: 1688, average fill: 62% 
    Primary pages: 1687, secondary pages: 1, swept pages: 0 
    Empty pages: 195, full pages: 913 
    Fill distribution: 
     0 - 19% = 289 
    20 - 39% = 178 
    40 - 59% = 203 
    60 - 79% = 214 
    80 - 99% = 804 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1707541, depth: 3, leaf buckets: 382, nodes: 85131 
    Average node length: 13.38, total dup: 7051, max dup: 2 
    Average key length: 10.57, compression ratio: 2.55 
    Average prefix length: 19.34, average data length: 7.66 
    Clustering factor: 62018, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 277 
        40 - 59% = 94 
        60 - 79% = 10 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18744, max versions: 1006 
    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: 83% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 63 
 
    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: 3.97, total records: 1474 
    Average version length: 43.37, total versions: 1346, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 14.62 
    Pointer pages: 1, data page slots: 40 
    Data pages: 30, average fill: 49% 
    Primary pages: 28, secondary pages: 2, swept pages: 0 
    Empty pages: 1, full pages: 12 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92404, depth: 2, leaf buckets: 2, nodes: 1474 
    Average node length: 4.37, total dup: 1376, max dup: 176 
    Average key length: 2.70, compression ratio: 7.03 
    Average prefix length: 18.36, average data length: 0.64 
    Clustering factor: 804, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        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: 97.05, 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.15 
    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: 36.45, total records: 797460 
    Average version length: 25.59, total versions: 53459, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 5, data page slots: 7864 
    Data pages: 7864, average fill: 70% 
    Primary pages: 7852, secondary pages: 12, swept pages: 1484 
    Empty pages: 15, full pages: 6350 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 33 
    40 - 59% = 163 
    60 - 79% = 7500 
    80 - 99% = 144 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 880, nodes: 797460 
    Average node length: 4.87, total dup: 797411, max dup: 151413 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89423, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 122 
        40 - 59% = 505 
        60 - 79% = 195 
        80 - 99% = 58 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 911, nodes: 797460 
    Average node length: 5.88, total dup: 709855, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160701, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 107 
        40 - 59% = 348 
        60 - 79% = 147 
        80 - 99% = 308 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 956, nodes: 797460 
    Average node length: 5.88, total dup: 709855, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162590, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 188 
        40 - 59% = 333 
        60 - 79% = 139 
        80 - 99% = 296 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1142, nodes: 797460 
    Average node length: 5.96, total dup: 709855, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155391, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 261 
        40 - 59% = 577 
        60 - 79% = 218 
        80 - 99% = 84 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.84, total records: 5471 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.23, total fragments: 73, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 74, secondary pages: 22, swept pages: 57 
    Empty pages: 15, full pages: 64 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5471 
    Average node length: 5.44, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.08 
    Average prefix length: 34.44, average data length: 1.54 
    Clustering factor: 5140, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5471 
    Average node length: 11.08, 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.08, total records: 79993 
    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: 4, full pages: 770 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 770 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34954, depth: 2, leaf buckets: 102, nodes: 79993 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3230, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        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: 110.57, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 149.02, total records: 165643 
    Average version length: 153.02, total versions: 1909, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 4528 
    Data pages: 3984, average fill: 86% 
    Primary pages: 3984, secondary pages: 0, swept pages: 3 
    Empty pages: 57, full pages: 3912 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 3912 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 132.15, total records: 195414 
    Average version length: 155.02, total versions: 24531, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.83 
    Pointer pages: 6, data page slots: 4928 
    Data pages: 4672, average fill: 87% 
    Primary pages: 4672, secondary pages: 0, swept pages: 1 
    Empty pages: 20, full pages: 4641 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4641 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.37, total records: 180317 
    Average version length: 153.72, total versions: 5669, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 6, data page slots: 4864 
    Data pages: 4408, average fill: 85% 
    Primary pages: 4407, secondary pages: 1, swept pages: 7 
    Empty pages: 120, full pages: 4266 
    Fill distribution: 
     0 - 19% = 126 
    20 - 39% = 5 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 4264 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 150.20, total records: 165504 
    Average version length: 149.05, total versions: 923, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 4384 
    Data pages: 3984, average fill: 86% 
    Primary pages: 3984, secondary pages: 0, swept pages: 5 
    Empty pages: 52, full pages: 3912 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 3910 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 150.21, total records: 166829 
    Average version length: 150.75, total versions: 1084, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 8, data page slots: 4560 
    Data pages: 4024, average fill: 85% 
    Primary pages: 4024, secondary pages: 0, swept pages: 2 
    Empty pages: 56, full pages: 3950 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3949 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.43, total records: 159631 
    Average version length: 153.99, total versions: 2453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 6184 
    Data pages: 3880, average fill: 85% 
    Primary pages: 3880, secondary pages: 0, swept pages: 2 
    Empty pages: 87, full pages: 3762 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 14 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 3762 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.10, total records: 172048 
    Average version length: 151.73, total versions: 2132, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 8, data page slots: 5016 
    Data pages: 4128, average fill: 86% 
    Primary pages: 4127, secondary pages: 1, swept pages: 3 
    Empty pages: 48, full pages: 4067 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4069 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 150.60, total records: 166817 
    Average version length: 139.23, total versions: 142, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 6, data page slots: 4496 
    Data pages: 3984, average fill: 86% 
    Primary pages: 3984, secondary pages: 0, swept pages: 2 
    Empty pages: 31, full pages: 3941 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3941 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 136.84, total records: 177135 
    Average version length: 155.14, total versions: 16528, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.39 
    Pointer pages: 7, data page slots: 5528 
    Data pages: 4288, average fill: 86% 
    Primary pages: 4288, secondary pages: 0, swept pages: 5 
    Empty pages: 73, full pages: 4193 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4193 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.28, total records: 175628 
    Average version length: 152.92, total versions: 1923, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 6, data page slots: 5200 
    Data pages: 4224, average fill: 86% 
    Primary pages: 4224, secondary pages: 0, swept pages: 4 
    Empty pages: 56, full pages: 4150 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4150 
 
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.99, total records: 2096387 
    Average version length: 52.87, total versions: 30015, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25640 
    Data pages: 25624, average fill: 70% 
    Primary pages: 25624, secondary pages: 0, swept pages: 12026 
    Empty pages: 255, full pages: 19659 
    Fill distribution: 
     0 - 19% = 523 
    20 - 39% = 496 
    40 - 59% = 1370 
    60 - 79% = 22974 
    80 - 99% = 261 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2596, nodes: 2096387 
    Average node length: 5.44, total dup: 1956025, max dup: 1560 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181258, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 331 
        40 - 59% = 1678 
        60 - 79% = 280 
        80 - 99% = 303 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2096387 
    Average node length: 5.69, total dup: 1881318, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374453, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2390 
        60 - 79% = 349 
        80 - 99% = 17 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2182, nodes: 2096387 
    Average node length: 4.96, total dup: 2096287, max dup: 26927 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179126, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 258 
        40 - 59% = 1163 
        60 - 79% = 372 
        80 - 99% = 388 
 
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: 44.49, total records: 148061 
    Average version length: 69.16, total versions: 52872, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.83 
    Pointer pages: 3, data page slots: 3848 
    Data pages: 3000, average fill: 57% 
    Primary pages: 3000, secondary pages: 0, swept pages: 453 
    Empty pages: 443, full pages: 1725 
    Fill distribution: 
     0 - 19% = 680 
    20 - 39% = 263 
    40 - 59% = 213 
    60 - 79% = 727 
    80 - 99% = 1117 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104768, depth: 3, leaf buckets: 238, nodes: 148061 
    Average node length: 6.44, total dup: 128605, max dup: 14 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 25923, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 59 
        40 - 59% = 118 
        60 - 79% = 54 
        80 - 99% = 7 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.00, total records: 7063069 
    Average version length: 68.80, total versions: 302670, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 63, data page slots: 102752 
    Data pages: 102752, average fill: 73% 
    Primary pages: 102752, secondary pages: 0, swept pages: 34297 
    Empty pages: 12, full pages: 75829 
    Fill distribution: 
     0 - 19% = 154 
    20 - 39% = 1087 
    40 - 59% = 7237 
    60 - 79% = 89912 
    80 - 99% = 4362 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10702, nodes: 7063069 
    Average node length: 6.51, total dup: 6109523, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1554272, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 1757 
        40 - 59% = 5725 
        60 - 79% = 2647 
        80 - 99% = 558 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8478, nodes: 7063069 
    Average node length: 5.40, total dup: 6782572, max dup: 211 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1357530, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1233 
        40 - 59% = 4458 
        60 - 79% = 1771 
        80 - 99% = 1008 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8544, nodes: 7063069 
    Average node length: 5.40, total dup: 6782572, max dup: 211 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1360016, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1235 
        40 - 59% = 4571 
        60 - 79% = 1768 
        80 - 99% = 965 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.51, total records: 12103223 
    Average version length: 68.70, total versions: 253626, 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: 104, data page slots: 169304 
    Data pages: 169304, average fill: 76% 
    Primary pages: 169304, secondary pages: 0, swept pages: 85943 
    Empty pages: 7, full pages: 153034 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 694 
    40 - 59% = 4594 
    60 - 79% = 159692 
    80 - 99% = 4259 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18459, nodes: 12103223 
    Average node length: 6.58, total dup: 10548788, max dup: 49 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2372548, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 2418 
        40 - 59% = 10814 
        60 - 79% = 4277 
        80 - 99% = 918 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 46.50, total records: 1375379 
    Average version length: 69.10, total versions: 450631, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.71 
    Pointer pages: 27, data page slots: 43312 
    Data pages: 27327, average fill: 57% 
    Primary pages: 27327, secondary pages: 0, swept pages: 9030 
    Empty pages: 4221, full pages: 15543 
    Fill distribution: 
     0 - 19% = 6292 
    20 - 39% = 2035 
    40 - 59% = 1909 
    60 - 79% = 10190 
    80 - 99% = 6901 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2097, nodes: 1375379 
    Average node length: 5.52, total dup: 1319363, max dup: 99 
    Average key length: 2.58, compression ratio: 16.31 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 91720, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 865 
        40 - 59% = 898 
        60 - 79% = 278 
        80 - 99% = 47 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 43.00, total records: 1055690 
    Average version length: 69.12, total versions: 397929, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.93 
    Pointer pages: 18, data page slots: 28376 
    Data pages: 25336, average fill: 48% 
    Primary pages: 25336, secondary pages: 0, swept pages: 5935 
    Empty pages: 3861, full pages: 10720 
    Fill distribution: 
     0 - 19% = 7601 
    20 - 39% = 3497 
    40 - 59% = 2225 
    60 - 79% = 4620 
    80 - 99% = 7393 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1541, nodes: 1055690 
    Average node length: 5.80, total dup: 983923, max dup: 104 
    Average key length: 2.88, compression ratio: 14.60 
    Average prefix length: 41.19, average data length: 0.81 
    Clustering factor: 147858, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 455 
        40 - 59% = 727 
        60 - 79% = 299 
        80 - 99% = 60 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.67, total records: 8989672 
    Average version length: 69.00, total versions: 290052, 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: 90, data page slots: 146080 
    Data pages: 146048, average fill: 66% 
    Primary pages: 146048, secondary pages: 0, swept pages: 74762 
    Empty pages: 336, full pages: 62960 
    Fill distribution: 
     0 - 19% = 1343 
    20 - 39% = 8674 
    40 - 59% = 30512 
    60 - 79% = 101979 
    80 - 99% = 3540 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13435, nodes: 8989672 
    Average node length: 6.70, total dup: 7454483, max dup: 29 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1894925, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1619 
        40 - 59% = 6760 
        60 - 79% = 4433 
        80 - 99% = 617 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21132463 
    Average version length: 82.98, total versions: 8961, 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: 318680 
    Data pages: 318680, average fill: 81% 
    Primary pages: 318680, secondary pages: 0, swept pages: 14015 
    Empty pages: 47, full pages: 317257 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 75 
    40 - 59% = 156 
    60 - 79% = 28239 
    80 - 99% = 290126 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19493, nodes: 21132463 
    Average node length: 5.72, total dup: 20651719, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278671, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2 
        40 - 59% = 8381 
        60 - 79% = 530 
        80 - 99% = 10573 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17162, nodes: 21132463 
    Average node length: 6.31, total dup: 18570696, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915799, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 3 
        40 - 59% = 758 
        60 - 79% = 304 
        80 - 99% = 16093 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21277, nodes: 21132463 
    Average node length: 6.35, total dup: 18490043, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573280, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2 
        40 - 59% = 8673 
        60 - 79% = 560 
        80 - 99% = 12035 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16160, nodes: 21132463 
    Average node length: 5.56, total dup: 21132363, max dup: 229057 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944576, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 13 
        40 - 59% = 3039 
        60 - 79% = 375 
        80 - 99% = 12732 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.61, total records: 9475402 
    Average version length: 82.65, total versions: 321768, 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: 106, data page slots: 172640 
    Data pages: 172584, average fill: 68% 
    Primary pages: 172584, secondary pages: 0, swept pages: 89040 
    Empty pages: 732, full pages: 84282 
    Fill distribution: 
     0 - 19% = 2140 
    20 - 39% = 9462 
    40 - 59% = 32703 
    60 - 79% = 78994 
    80 - 99% = 49285 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11394, nodes: 9475402 
    Average node length: 5.38, total dup: 9168088, max dup: 170 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2058964, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 115 
        40 - 59% = 8740 
        60 - 79% = 2484 
        80 - 99% = 53 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13373, nodes: 9475402 
    Average node length: 6.25, total dup: 7852055, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1397464, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 4168 
        40 - 59% = 4089 
        60 - 79% = 2607 
        80 - 99% = 2380 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12724, nodes: 9475402 
    Average node length: 6.00, total dup: 8214258, max dup: 44 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2245274, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 157 
        40 - 59% = 9797 
        60 - 79% = 2689 
        80 - 99% = 78 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10016, nodes: 9475402 
    Average node length: 5.15, total dup: 9475302, max dup: 153047 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1444670, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1393 
        40 - 59% = 4899 
        60 - 79% = 1588 
        80 - 99% = 2095 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.53, total records: 11090481 
    Average version length: 82.54, total versions: 237767, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 118, data page slots: 191544 
    Data pages: 189920, average fill: 72% 
    Primary pages: 189920, secondary pages: 0, swept pages: 79760 
    Empty pages: 3131, full pages: 134616 
    Fill distribution: 
     0 - 19% = 5581 
    20 - 39% = 8613 
    40 - 59% = 20390 
    60 - 79% = 46666 
    80 - 99% = 108670 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13128, nodes: 11090481 
    Average node length: 5.30, total dup: 10980904, max dup: 636 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2315814, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 232 
        40 - 59% = 9561 
        60 - 79% = 3238 
        80 - 99% = 96 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10268, nodes: 11090481 
    Average node length: 5.49, total dup: 10605281, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 703679, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 175 
        20 - 39% = 870 
        40 - 59% = 2508 
        60 - 79% = 1792 
        80 - 99% = 4923 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15011, nodes: 11090481 
    Average node length: 6.02, total dup: 9671001, max dup: 77 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2332073, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 307 
        40 - 59% = 11009 
        60 - 79% = 3580 
        80 - 99% = 110 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10601, nodes: 11090481 
    Average node length: 5.22, total dup: 11090381, max dup: 192967 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 693065, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 914 
        40 - 59% = 4629 
        60 - 79% = 1464 
        80 - 99% = 3491 
 
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: 80.15, total records: 9569050 
    Average version length: 82.91, total versions: 298845, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 108, data page slots: 175432 
    Data pages: 175344, average fill: 68% 
    Primary pages: 175344, secondary pages: 0, swept pages: 95636 
    Empty pages: 767, full pages: 83863 
    Fill distribution: 
     0 - 19% = 2238 
    20 - 39% = 9878 
    40 - 59% = 33444 
    60 - 79% = 82065 
    80 - 99% = 47719 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11743, nodes: 9569050 
    Average node length: 5.19, total dup: 9540186, max dup: 1516 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1856115, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1575 
        40 - 59% = 7885 
        60 - 79% = 1715 
        80 - 99% = 529 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13466, nodes: 9569050 
    Average node length: 6.26, total dup: 7930179, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1366507, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 4161 
        40 - 59% = 4029 
        60 - 79% = 2563 
        80 - 99% = 2542 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12378, nodes: 9569050 
    Average node length: 5.44, total dup: 9136704, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 1988490, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1538 
        40 - 59% = 8730 
        60 - 79% = 1559 
        80 - 99% = 518 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10223, nodes: 9569050 
    Average node length: 5.16, total dup: 9568950, max dup: 155015 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1464097, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1461 
        40 - 59% = 5095 
        60 - 79% = 1615 
        80 - 99% = 2006 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.55, total records: 575834 
    Average version length: 68.81, total versions: 5249, 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: 8040 
    Data pages: 8040, average fill: 75% 
    Primary pages: 8040, secondary pages: 0, swept pages: 4135 
    Empty pages: 6, full pages: 6556 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 23 
    40 - 59% = 257 
    60 - 79% = 7674 
    80 - 99% = 77 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 47896, depth: 3, leaf buckets: 749, nodes: 575834 
    Average node length: 5.95, total dup: 490184, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100158, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 536 
        60 - 79% = 100 
        80 - 99% = 78 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29643, depth: 3, leaf buckets: 771, nodes: 575834 
    Average node length: 6.15, total dup: 472264, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100207, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 544 
        60 - 79% = 96 
        80 - 99% = 90 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 584, nodes: 575834 
    Average node length: 4.86, total dup: 575734, max dup: 9390 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88960, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 354 
        60 - 79% = 86 
        80 - 99% = 109 
 
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 Mon Apr  8 19:12:44 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7720937 64166 1 0.0000 0.0000
DOC_LIST 2231441 63989 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 236487 614 59100.0000 0.0000
INVNT_TURNOVER_LOG 85131 69784 1 0.0000 0.0000
MONEY_SALDO 49 18744 1006 38200.0000 0.0000
MONEY_TURNOVER_LOG 1474 1346 1 0.0000 0.0000
PDISTR 797460 53459 5 0.0000 0.0000
PERF_SPLIT_0 165643 1909 1 0.0000 0.0000
PERF_SPLIT_1 195414 24531 1 0.0000 0.0000
PERF_SPLIT_2 180317 5669 1 0.0000 0.0000
PERF_SPLIT_3 165504 923 1 0.0000 0.0000
PERF_SPLIT_4 166829 1084 1 0.0000 0.0000
PERF_SPLIT_5 159631 2453 1 0.0000 0.0000
PERF_SPLIT_6 172048 2132 1 0.0000 0.0000
PERF_SPLIT_7 166817 142 1 0.0000 0.0000
PERF_SPLIT_8 177135 16528 1 0.0000 0.0000
PERF_SPLIT_9 175628 1923 1 0.0000 0.0000
PSTORNED 2096387 30015 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 148061 52872 1 0.0000 0.0000
XQD_1000_3300 7063069 302670 1 0.0000 0.0000
XQD_1200_2000 12103223 253626 1 0.0000 0.0000
XQD_2000_3300 1375379 450631 1 0.0000 0.0000
XQD_2100_3300 1055690 397929 1 0.0000 0.0000
XQD_3300_3400 8989672 290052 1 0.0000 0.0000
XQS_1000_1200 21132463 8961 1 0.0000 0.0000
XQS_1000_3300 9475402 321768 1 0.0000 0.0000
XQS_1200_2000 11090481 237767 1 0.0000 0.0000
XQS_2100_3300 9569050 298845 1 0.0000 0.0000
XQS_3300_3400 575834 5249 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 ---
:967: 
:968: mscs-test-161.budzdorov.ru    Mon Apr  8 19:09:51 2024
:969:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:970: 
:971: 
:972: mscs-test-161.budzdorov.ru    Mon Apr  8 19:10:07 2024
:973:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:974: 
--- end of diff output ---

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

08.04.24 19:12:55. 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-04-08 19:12:58 No severe PSQL-related problems occured
08.04.24 19:12:59. End of report.