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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15653456 kB
MemAvailable 30165524 kB
Buffers 0 kB
Cached 16083112 kB
SwapCached 2504 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-03 22:09:46
DTS_END                         2024-04-03 22:09:46.8150
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56548
TRN_ID                          183919
ATT_ID                          575
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: 9447.57 20378 944757
customer order: creation 187.71 345 18771
customer order: refuse 16.09 400 1609
order to supplier: creation 49.32 1305 4932
order to supplier: removal 3.61 94732 361
invoice (draft): creation 48.52 3069 4852
invoice (draft): removal 49.80 760 4980
invoice accept: apply 44.48 21143 4448
invoice accept: cancel 45.27 913 4527
customer reserve: creation 4217.45 204 421745
customer reserve: removal 4470.52 61 447052
realization accept: apply 91.31 204 9131
realization accept: cancel 83.96 130 8396
payment from customer: creation 62.93 134 6293
payment from customer: removal 6.25 82 625
payment to supplier: creation 53.14 147 5314
payment to supplier: removal 3.77 57 377
service: total inventory turnovers 5.05 1003 505
service: total monetary turnovers 7.44 24 744
service: aggregate perf. data 0.92 16987 92
service: refresh index statistics 0.03 265861 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-04-2024 22:11:04 to 03-04-2024 22:11:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4085
TEST_TIME 2 4216
TEST_TIME 3 3571
TEST_TIME 4 3831
TEST_TIME 5 3574
TEST_TIME 6 4783
TEST_TIME 7 4763
TEST_TIME 8 5207
TEST_TIME 9 5224
TEST_TIME 10 5167
TEST_TIME 11 5228
TEST_TIME 12 5814
TEST_TIME 13 5676
TEST_TIME 14 5736
TEST_TIME 15 6262
TEST_TIME 16 6237
TEST_TIME 17 6326
TEST_TIME 18 6416
TEST_TIME 19 6547
TEST_TIME 20 6807
TEST_TIME 21 7206
TEST_TIME 22 7529
TEST_TIME 23 7666
TEST_TIME 24 8105
TEST_TIME 25 8391
TEST_TIME 26 9351
TEST_TIME 27 9304
TEST_TIME 28 9164
TEST_TIME 29 9226
TEST_TIME 30 9021
TEST_TIME 31 9123
TEST_TIME 32 8969
TEST_TIME 33 8773
TEST_TIME 34 8899
TEST_TIME 35 8934
TEST_TIME 36 8824
TEST_TIME 37 8829
TEST_TIME 38 8783
TEST_TIME 39 8891
TEST_TIME 40 8957
TEST_TIME 41 8850
TEST_TIME 42 8873
TEST_TIME 43 8953
TEST_TIME 44 8835
TEST_TIME 45 8886
TEST_TIME 46 9136
TEST_TIME 47 9146
TEST_TIME 48 9026
TEST_TIME 49 9165
TEST_TIME 50 9231
TEST_TIME 51 9258
TEST_TIME 52 9259
TEST_TIME 53 9307
TEST_TIME 54 9492
TEST_TIME 55 9422
TEST_TIME 56 9583
TEST_TIME 57 9715
TEST_TIME 58 9765
TEST_TIME 59 9690
TEST_TIME 60 9566
TEST_TIME 61 9488
TEST_TIME 62 9370
TEST_TIME 63 9424
TEST_TIME 64 9527
TEST_TIME 65 9495
TEST_TIME 66 9468
TEST_TIME 67 9456
TEST_TIME 68 9399
TEST_TIME 69 9313
TEST_TIME 70 9281
TEST_TIME 71 9286
TEST_TIME 72 9261
TEST_TIME 73 9330
TEST_TIME 74 9367
TEST_TIME 75 9347
TEST_TIME 76 9479
TEST_TIME 77 9473
TEST_TIME 78 9525
TEST_TIME 79 9521
TEST_TIME 80 9508
TEST_TIME 81 9631
TEST_TIME 82 9663
TEST_TIME 83 9698
TEST_TIME 84 9664
TEST_TIME 85 9618
TEST_TIME 86 9569
TEST_TIME 87 9497
TEST_TIME 88 9505
TEST_TIME 89 9530
TEST_TIME 90 9461
TEST_TIME 91 9430
TEST_TIME 92 9392
TEST_TIME 93 9348
TEST_TIME 94 9348
TEST_TIME 95 9378
TEST_TIME 96 9396
TEST_TIME 97 9398
TEST_TIME 98 9432
TEST_TIME 99 9407
TEST_TIME 100 9455

Performance per minute, chart


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

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 1330312 1330312 0 0.00 0 22128 8 0 0
doc_list_biud 1330312 1330312 0 0.00 0 39133 26 0 0
sp_add_invoice_to_stock 4540 4448 92 2.02 33 230228 21144 0 92
sp_cancel_adding_invoice 4527 4527 0 0.00 4 51915 913 0 0
sp_cancel_client_order 1609 1609 0 0.00 4 15454 401 0 0
sp_cancel_customer_reserve 447052 447052 0 0.00 0 39136 61 0 0
sp_cancel_pay_from_customer 625 625 0 0.00 2 8978 82 0 0
sp_cancel_pay_to_supplier 377 377 0 0.00 2 2001 57 0 0
sp_cancel_supplier_invoice 4995 4980 15 0.30 1 12760 760 0 15
sp_cancel_supplier_order 361 361 0 0.00 9 867085 94732 0 0
sp_cancel_write_off 8396 8396 0 0.00 1 10309 130 0 0
sp_client_order 18771 18771 0 0.00 3 20452 346 0 0
sp_customer_reserve 421745 421745 0 0.00 0 48057 205 0 0
sp_fill_shopping_cart 28545 28545 0 0.00 1 17166 38 0 0
sp_fill_shopping_cart_clo_res 421738 421738 0 0.00 0 19341 15 0 0
sp_get_clo_for_invoice 4438 4438 0 0.00 0 35561 277 0 0
sp_kill_cost_storno 13925 13925 0 0.00 0 9338 62 0 0
sp_kill_qstorno_ret_qs2qd 907841 907841 0 0.00 0 37817 33 0 0
sp_kill_qty_storno 480494 480494 0 0.00 0 39133 72 0 0
sp_lock_selected_doc 18767 18767 0 0.00 0 8051 5 0 0
sp_make_cost_storno 25176 25176 0 0.00 0 22107 75 0 0
sp_multiply_rows_for_pdistr 25176 25176 0 0.00 0 6399 29 0 0
sp_multiply_rows_for_qdistr 18771 18771 0 0.00 0 19166 150 0 0
sp_pay_from_customer 6293 6293 0 0.00 4 12865 135 0 0
sp_pay_to_supplier 5314 5314 0 0.00 5 17135 147 0 0
sp_payment_common 11607 11607 0 0.00 1 9421 35 0 0
sp_qd_handle_on_cancel_clo 1609 1609 0 0.00 0 15436 375 0 0
sp_qd_handle_on_invoice_upd_sts 8965 8965 0 0.00 0 35173 330 0 0
sp_qd_handle_on_reserve_upd_sts 9131 9131 0 0.00 0 20430 61 0 0
sp_reserve_write_off 9131 9131 0 0.00 6 20465 205 0 0
sp_supplier_invoice 4852 4852 0 0.00 6 82459 3069 0 0
sp_supplier_order 4932 4932 0 0.00 6 33724 1305 0 0
srv_aggregate_perf_data 92 92 0 0.00 2158 249421 16987 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 2063 111150 37781 0 0
srv_find_qd_qs_mism 899106 899106 0 0.00 0 17511 7 0 0
srv_make_invnt_saldo 505 505 0 0.00 41 28140 1004 0 0
srv_make_money_saldo 744 744 0 0.00 1 751 24 0 0
srv_recalc_idx_stat 3 3 0 0.00 195839 307516 265861 0 0
t$perf-abend:sp_add_invoice_to_stock 92 92 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4449 4449 0 0.00 0 34625 208 0 0
t$perf-norm:sp_cancel_adding_invoice 381 381 0 0.00 0 8367 153 0 0
t$perf-norm:sp_cancel_client_order 1609 1609 0 0.00 0 4896 19 0 0
t$perf-norm:sp_cancel_customer_reserve 558 558 0 0.00 0 6660 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 625 625 0 0.00 0 201 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 377 377 0 0.00 0 241 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 344 344 0 0.00 0 2114 25 0 0
t$perf-norm:sp_cancel_supplier_order 361 361 0 0.00 0 36797 1732 0 0
t$perf-norm:sp_cancel_write_off 943 943 0 0.00 0 1287 7 0 0
t$perf-norm:sp_client_order 18771 18771 0 0.00 0 5924 17 0 0
t$perf-norm:sp_customer_reserve 868 868 0 0.00 0 1619 6 0 0
t$perf-norm:sp_pay_from_customer 6293 6293 0 0.00 0 5656 11 0 0
t$perf-norm:sp_pay_to_supplier 5314 5314 0 0.00 0 5867 13 0 0
t$perf-norm:sp_reserve_write_off 9131 9131 0 0.00 0 13856 15 0 0
t$perf-norm:sp_supplier_invoice 4852 4852 0 0.00 0 6133 21 0 0
t$perf-norm:sp_supplier_order 4932 4932 0 0.00 0 17012 19 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 347 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 333 10 0 0
t$perf-norm:srv_make_invnt_saldo 505 505 0 0.00 0 1079 32 0 0
t$perf-norm:srv_make_money_saldo 744 744 0 0.00 0 2788 19 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 15 6 0 0
v_add_invoice_to_stock 9060 8876 184 2.03 0 6906 17 0 184
v_all_customers 34338 34338 0 0.00 0 27 1 0 0
v_all_suppliers 27916 27916 0 0.00 0 133 1 0 0
v_all_wares 37540 37540 0 0.00 0 58 1 0 0
v_cancel_adding_invoice 762 762 0 0.00 0 1380 8 0 0
v_cancel_client_order 3218 3218 0 0.00 0 6143 6 0 0
v_cancel_customer_prepayment 1250 1250 0 0.00 0 3138 6 0 0
v_cancel_customer_reserve 1116 1116 0 0.00 0 1943 7 0 0
v_cancel_payment_to_supplier 754 754 0 0.00 0 1969 5 0 0
v_cancel_supplier_invoice 718 688 30 4.17 0 1309 17 0 30
v_cancel_supplier_order 722 722 0 0.00 0 391 3 0 0
v_cancel_write_off 1886 1886 0 0.00 0 3989 15 0 0
v_max_id_clo_ord 4932 4932 0 0.00 0 902 2 0 0
v_max_id_clo_res 868 868 0 0.00 0 2395 12 0 0
v_max_id_ord_sup 4843 4843 0 0.00 0 5621 3 0 0
v_max_non_paid_invoice 1131 1131 0 0.00 0 921 4 0 0
v_max_non_paid_realizn 3183 3183 0 0.00 0 1172 4 0 0
v_min_id_clo_ord 4932 4932 0 0.00 0 17128 20 0 0
v_min_id_clo_res 868 868 0 0.00 0 8020 24 0 0
v_min_id_ord_sup 4843 4843 0 0.00 0 5442 7 0 0
v_min_non_paid_invoice 5314 5314 0 0.00 0 9135 22 0 0
v_min_non_paid_realizn 6293 6293 0 0.00 0 6602 29 0 0
v_our_firm 9422 9422 0 0.00 0 27 1 0 0
v_reserve_write_off 18262 18262 0 0.00 0 5177 6 0 0
x_lock_depdocs_on_canc_invoice 9163 9163 0 0.00 0 15242 139 0 0
x_lock_depdocs_on_canc_sup_ord 361 361 0 0.00 0 4005 325 0 0
x_make_qstorno_1000_1200 4932 4932 0 0.00 1 33698 1214 0 0
x_make_qstorno_1200_2000 4852 4852 0 0.00 3 82053 2939 0 0
x_make_qstorno_2100_3300 421745 421745 0 0.00 0 48051 186 0 0

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

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
20:09:50 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:51 35033 8192000000 9902064528 10213449728 982414608 10.708 100 93 186 0 1012919104 5542016 24962480
20:12:34 16979 8192000000 9941413584 10262859776 1021705376 11.088 100 93 186 0 1054194800 8262080 24227344
20:13:52 16085 8192000000 9980904112 10312458240 1063841424 11.493 100 86 172 0 1095086304 9846880 21398000
20:15:12 11065 8192000000 10019012352 10366459904 1104677712 11.882 100 73 143 0 1132405504 10774400 16953392
20:16:25 6551 8192000000 10070811776 10427289600 1158658816 12.391 100 86 171 0 1190237136 12388352 19189968
20:17:37 3647 8192000000 10122031792 10489262080 1212860816 12.896 100 82 162 2 1243566736 12496816 18209104
20:18:43 2895 8192000000 10154746464 10529742848 1241952912 13.164 100 78 156 0 1272575856 13817584 16805360
20:19:48 1619 8192000000 10186201568 10571579392 1278180928 13.496 100 81 159 0 1309346832 13181808 17984096
20:20:51 1210 8192000000 10214541408 10599829504 1295948880 13.658 100 87 173 1 1327714352 12720736 19044736
20:21:53 14236 8192000000 10203326992 10605608960 1303852544 13.730 100 58 116 2 1326371216 9821136 12697536
20:23:08 7455 8192000000 10197478480 10612064256 1314041184 13.823 100 25 48 1 1325864352 6668944 5154224
20:24:17 9315 8192000000 10210877952 10628857856 1327432576 13.944 100 20 40 0 1337584096 5636752 4514768
20:25:31 16866 8192000000 10227245776 10645438464 1339964736 14.057 100 27 52 0 1352323232 5676080 6682416
20:26:48 24988 8192000000 10229413184 10652930048 1328175600 13.951 99 22 42 0 1338538272 5994816 4367856
20:28:16 8558 8192000000 10237643200 10668531712 1349142240 14.140 100 20 39 0 1359528000 5380096 5005664
20:29:25 6103 8192000000 10211854112 10630397952 1315819024 13.839 98 26 50 0 1327090160 5362560 5908576
20:30:37 15537 8192000000 10233682928 10639802368 1322747504 13.902 100 52 102 0 1342629008 8348112 11533392
20:31:55 88496 8192000000 10237342112 10651369472 1322693232 13.901 99 42 84 0 1343613712 10494256 10426224
20:34:32 25787 8192000000 10249979488 10657435648 1322097840 13.896 99 46 89 0 1346616400 14080304 10438256
20:36:02 8170 8192000000 10236768512 10644090880 1288765680 13.593 97 36 72 0 1311384320 14038624 8580016
20:37:13 14493 8192000000 10225863520 10628153344 1291171888 13.615 98 57 114 1 1321445920 16823920 13450112
20:38:44 16017 8192000000 10213859616 10611367936 1295712464 13.656 99 57 112 0 1328507856 19548240 13247152
20:40:08 14901 8192000000 10233585792 10636288000 1305483488 13.745 99 59 118 2 1339637040 20368368 13785184
20:41:33 26514 8192000000 10252743936 10662297600 1324849328 13.921 99 42 83 1 1356889072 21778224 10261520
20:43:12 6012 8192000000 10269636320 10667986944 1335128016 14.013 100 74 142 1 1377264096 25108896 17027184
20:44:22 20549 8192000000 10288187872 10701549568 1356143408 14.203 100 57 113 1 1397101984 27214448 13744128
20:46:07 6852 8192000000 10324433888 10728243200 1371836208 14.343 99 67 134 1 1418109024 29353552 16919264
20:47:23 6467 8192000000 10330831536 10737618944 1388373984 14.491 100 71 136 0 1434790432 30129632 16286816
20:48:33 2597 8192000000 10354046160 10760146944 1398525872 14.582 100 80 159 2 1459714752 41286464 19902416
20:49:41 3252 8192000000 10359450304 10761535488 1393104128 14.534 100 90 181 0 1458684640 42973664 22606848
20:50:51 2061 8192000000 10351574496 10767552512 1401245248 14.606 100 65 131 0 1455031824 37385664 16400912
20:52:07 9178 8192000000 10336605888 10758217728 1391570976 14.520 100 46 92 1 1440612944 37541600 11500368
20:53:20 20704 8192000000 10325014560 10771079168 1398263264 14.580 100 29 58 0 1440402880 34176784 7962832
20:54:45 36324 8192000000 10303740544 10760962048 1372934704 14.353 99 14 28 0 1407048912 29996448 4117760
20:56:54 17702 8192000000 10304969376 10742001664 1384744384 14.459 100 41 87 2 1404020048 10127600 9148064
20:58:14 49098 8192000000 10300527536 10746748928 1378014208 14.399 99 22 46 0 1398774688 15794832 4965648
21:00:32 76230 8192000000 10297007360 10751324160 1395234400 14.553 100 22 44 0 1409354624 9258480 4861744
21:03:25 40098 8192000000 10314328176 10753593344 1384796528 14.459 99 40 77 1 1404231712 10344240 9090944
21:05:09 33143 8192000000 10307699472 10757672960 1405846512 14.647 100 24 48 0 1419029600 7838880 5344208
21:06:45 9472 8192000000 10320139600 10768785408 1411684608 14.699 100 29 56 0 1430080128 11930048 6465472
21:07:57 6227 8192000000 10322688032 10767306752 1399143600 14.587 99 45 89 0 1422577072 13506960 9926512
21:09:06 40796 8192000000 10297194960 10758717440 1364682928 14.279 97 22 42 0 1383707760 14534864 4489968
21:10:57 31387 8192000000 10301287840 10753638400 1390894032 14.514 99 21 42 0 1405778224 10166064 4718128
21:13:02 39112 8192000000 10294052256 10749583360 1388142192 14.489 100 15 30 0 1404173184 12470848 3560144
21:15:00 33097 8192000000 10287867792 10743099392 1350619680 14.153 97 15 29 0 1369476608 15267008 3589920
21:16:37 47880 8192000000 10280375760 10726301696 1305811568 13.748 94 22 41 0 1321553424 10902080 4839776
21:18:27 52701 8192000000 10284957456 10736750592 1347838176 14.128 98 19 39 0 1374724816 22552688 4333952
21:20:27 34359 8192000000 10265090528 10710528000 1320060976 13.877 97 29 58 0 1346905008 19965024 6879008
21:22:02 30818 8192000000 10278426368 10714533888 1355750912 14.199 100 30 60 0 1376654848 14142464 6761472
21:23:33 71781 8192000000 10253034592 10680381440 1246771456 13.209 92 16 32 0 1261173008 10891104 3510448
21:25:49 68472 8192000000 10255052848 10712489984 1329256256 13.960 99 5 10 0 1346811040 16559264 995520
21:27:57 111150 8192000000 10262485392 10707529728 1353968016 14.183 100 21 41 1 1376953168 17691408 5293744
21:30:50 59130 8192000000 10281457840 10718244864 1357852960 14.218 100 46 90 0 1385662480 18010160 9799360
21:32:54 11402 8192000000 10265170320 10705629184 1348284592 14.132 99 44 88 0 1370273984 11952736 10036656
21:34:31 32088 8192000000 10238425248 10683699200 1317704960 13.856 97 11 23 0 1326535424 6493760 2336704
21:36:04 40612 8192000000 10246098608 10693251072 1321429552 13.890 97 27 54 0 1336523616 8626224 6467840
21:38:27 66243 8192000000 10248501840 10697203712 1351525760 14.161 99 19 38 0 1363275632 7292656 4457216
21:40:35 64032 8192000000 10282784208 10734690304 1376066416 14.381 100 15 30 0 1388651104 9688464 2896224
21:42:40 47507 8192000000 10287593216 10737573888 1380490208 14.421 100 17 34 0 1396930528 12635520 3804800
21:44:28 76223 8192000000 10297120960 10755371008 1391749072 14.521 100 15 30 0 1410293136 14857232 3686832
21:46:54 10842 8192000000 10316274560 10747928576 1381406208 14.429 99 50 100 0 1403246592 9726192 12114192
21:48:12 56323 8192000000 10328795408 10762416128 1375473664 14.376 98 38 76 1 1395530640 11461008 8595968
21:50:10 104192 8192000000 10315340432 10777534464 1374759632 14.370 98 23 46 0 1397126656 16930832 5436192
21:52:55 48306 8192000000 10311393872 10756218880 1361799952 14.254 97 18 36 0 1379595280 13714880 4080448
21:54:47 91898 8192000000 10269041616 10710994944 1316393584 13.844 95 26 52 0 1328921936 6823760 5704592
21:57:26 44924 8192000000 10255534480 10715787264 1334244704 14.005 97 33 66 0 1351990672 10226336 7519632
21:59:13 27461 8192000000 10261582416 10725212160 1361345808 14.249 99 4 8 0 1371373872 9208896 819168
22:00:41 49145 8192000000 10259165248 10713948160 1346567488 14.117 98 15 30 0 1357995664 8049040 3379136
22:02:34 72732 8192000000 10259024432 10723680256 1351542528 14.161 99 17 34 0 1370389552 14918256 3928768
22:05:23 14554 8192000000 10253157520 10694029312 1316933904 13.849 96 34 68 0 1338859520 14048960 7876656
22:06:45 43971 8192000000 10266067008 10712260608 1338306640 14.042 98 23 48 0 1354802064 11307088 5188336
22:08:33 36627 8192000000 10278681488 10711339008 1340225152 14.059 99 41 82 0 1363758240 13857024 9676064

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 03-04-2024 22:11:18 to 03-04-2024 22:11:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 92 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

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

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          181379
MON$OLDEST_ACTIVE               184530
MON$OLDEST_SNAPSHOT             184530
MON$NEXT_TRANSACTION            184530
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                       1907104
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 Wed Apr  3 22:11:35 2024 
 
Database header page information: 
    Flags            0 
    Generation        95987 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    181379 
    Oldest active        184530 
    Oldest snapshot        184530 
    Next transaction    184531 
    Sequence number        0 
    Next attachment ID    732 
    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.28, total records: 7810550 
    Average version length: 48.16, total versions: 99625, 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: 86816 
    Data pages: 86816, average fill: 72% 
    Primary pages: 86816, secondary pages: 0, swept pages: 14366 
    Empty pages: 5, full pages: 75103 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 165 
    40 - 59% = 2420 
    60 - 79% = 84158 
    80 - 99% = 56 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23554, nodes: 7810550 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1753515, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 367 
        20 - 39% = 1842 
        40 - 59% = 4220 
        60 - 79% = 2489 
        80 - 99% = 14636 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13672, nodes: 7810550 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1574573, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1656 
        40 - 59% = 2074 
        60 - 79% = 1132 
        80 - 99% = 8809 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8466, nodes: 7810550 
    Average node length: 6.62, total dup: 5831086, max dup: 49 
    Average key length: 3.64, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1567739, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 1013 
        40 - 59% = 1392 
        60 - 79% = 932 
        80 - 99% = 4974 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.10, total records: 2270247 
    Average version length: 34.64, total versions: 106469, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28312 
    Data pages: 28312, average fill: 74% 
    Primary pages: 28307, secondary pages: 5, swept pages: 8842 
    Empty pages: 4, full pages: 23613 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 93 
    40 - 59% = 1306 
    60 - 79% = 25763 
    80 - 99% = 1135 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4624, nodes: 2270247 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 714194, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 969 
        40 - 59% = 837 
        60 - 79% = 761 
        80 - 99% = 2057 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2526, nodes: 2273168 
    Average node length: 4.97, total dup: 2272269, max dup: 20028 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1257887, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 246 
        40 - 59% = 1530 
        60 - 79% = 552 
        80 - 99% = 196 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2024, nodes: 2270247 
    Average node length: 4.97, total dup: 2270197, max dup: 130731 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062918, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 43 
        40 - 59% = 1085 
        60 - 79% = 63 
        80 - 99% = 829 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4424, nodes: 2270247 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 714194, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 610 
        40 - 59% = 623 
        60 - 79% = 854 
        80 - 99% = 2218 
 
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.10, total records: 400 
    Average version length: 23.04, total versions: 243141, max versions: 637 
    Average fragment length: 2.03, total fragments: 64, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1360 
    Data pages: 1352, average fill: 90% 
    Primary pages: 8, secondary pages: 1344, swept pages: 0 
    Empty pages: 1, full pages: 1350 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1349 
 
    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: 19.89, total records: 91003 
    Average version length: 68.28, total versions: 64502, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.42 
    Pointer pages: 6, data page slots: 1872 
    Data pages: 1512, average fill: 72% 
    Primary pages: 1511, secondary pages: 1, swept pages: 0 
    Empty pages: 111, full pages: 1046 
    Fill distribution: 
     0 - 19% = 145 
    20 - 39% = 33 
    40 - 59% = 128 
    60 - 79% = 395 
    80 - 99% = 811 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1709166, depth: 3, leaf buckets: 261, nodes: 91003 
    Average node length: 13.36, total dup: 5603, max dup: 2 
    Average key length: 10.78, compression ratio: 2.50 
    Average prefix length: 19.15, average data length: 7.85 
    Clustering factor: 66936, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 19 
        40 - 59% = 123 
        60 - 79% = 99 
        80 - 99% = 19 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18502, max versions: 1033 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 64 
 
    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: 5.58, total records: 1725 
    Average version length: 43.36, total versions: 1513, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 10.39 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 68% 
    Primary pages: 23, secondary pages: 1, swept pages: 0 
    Empty pages: 1, full pages: 14 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91530, depth: 2, leaf buckets: 2, nodes: 1725 
    Average node length: 4.19, total dup: 1627, max dup: 165 
    Average key length: 2.60, compression ratio: 7.30 
    Average prefix length: 18.45, average data length: 0.55 
    Clustering factor: 915, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.82, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.72, total records: 809953 
    Average version length: 25.33, total versions: 83970, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 71% 
    Primary pages: 7994, secondary pages: 22, swept pages: 1091 
    Empty pages: 28, full pages: 7081 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 48 
    40 - 59% = 203 
    60 - 79% = 7364 
    80 - 99% = 352 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 885, nodes: 809953 
    Average node length: 4.87, total dup: 809904, max dup: 147014 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90189, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 125 
        40 - 59% = 484 
        60 - 79% = 211 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 943, nodes: 809953 
    Average node length: 5.87, total dup: 721350, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161191, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 92 
        40 - 59% = 424 
        60 - 79% = 129 
        80 - 99% = 295 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 983, nodes: 809953 
    Average node length: 5.88, total dup: 721350, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163172, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 210 
        40 - 59% = 363 
        60 - 79% = 103 
        80 - 99% = 307 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1148, nodes: 809953 
    Average node length: 5.96, total dup: 721350, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155973, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 253 
        40 - 59% = 591 
        60 - 79% = 221 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.86, total records: 5496 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.80, total fragments: 81, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 71, secondary pages: 17, swept pages: 50 
    Empty pages: 5, full pages: 64 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5496 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.52, average data length: 1.54 
    Clustering factor: 5161, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5496 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 159, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 84411 
    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: 816 
    Data pages: 816, average fill: 71% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 812 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 812 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35740, depth: 2, leaf buckets: 111, nodes: 84411 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3546, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 105 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 137.15, total records: 183326 
    Average version length: 154.37, total versions: 16731, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.37 
    Pointer pages: 6, data page slots: 5352 
    Data pages: 4432, average fill: 86% 
    Primary pages: 4432, secondary pages: 0, swept pages: 5 
    Empty pages: 73, full pages: 4341 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4340 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 143.97, total records: 161585 
    Average version length: 152.72, total versions: 7048, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 7, data page slots: 5016 
    Data pages: 3896, average fill: 85% 
    Primary pages: 3896, secondary pages: 0, swept pages: 5 
    Empty pages: 68, full pages: 3811 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 3811 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.36, total records: 180604 
    Average version length: 153.03, total versions: 5578, 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: 7, data page slots: 5488 
    Data pages: 4336, average fill: 86% 
    Primary pages: 4336, secondary pages: 0, swept pages: 3 
    Empty pages: 47, full pages: 4271 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 4271 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 131.69, total records: 190046 
    Average version length: 155.15, total versions: 24315, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.88 
    Pointer pages: 6, data page slots: 5296 
    Data pages: 4592, average fill: 87% 
    Primary pages: 4592, secondary pages: 0, swept pages: 2 
    Empty pages: 67, full pages: 4511 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 2 
    40 - 59% = 9 
    60 - 79% = 2 
    80 - 99% = 4511 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 143.43, total records: 150225 
    Average version length: 154.15, total versions: 7193, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.82 
    Pointer pages: 7, data page slots: 4384 
    Data pages: 3624, average fill: 86% 
    Primary pages: 3624, secondary pages: 0, swept pages: 2 
    Empty pages: 60, full pages: 3546 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 3544 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 136.61, total records: 193229 
    Average version length: 154.72, total versions: 18320, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.41 
    Pointer pages: 7, data page slots: 5528 
    Data pages: 4672, average fill: 86% 
    Primary pages: 4672, secondary pages: 0, swept pages: 2 
    Empty pages: 75, full pages: 4576 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4576 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 129.42, total records: 193970 
    Average version length: 154.67, total versions: 27349, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.10 
    Pointer pages: 5, data page slots: 5568 
    Data pages: 4640, average fill: 87% 
    Primary pages: 4640, secondary pages: 0, swept pages: 2 
    Empty pages: 33, full pages: 4592 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 4593 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 147.55, total records: 180398 
    Average version length: 151.75, total versions: 4136, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 6, data page slots: 5600 
    Data pages: 4368, average fill: 85% 
    Primary pages: 4368, secondary pages: 0, swept pages: 1 
    Empty pages: 74, full pages: 4259 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 13 
    40 - 59% = 14 
    60 - 79% = 7 
    80 - 99% = 4258 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 143.47, total records: 189790 
    Average version length: 153.48, total versions: 9629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.82 
    Pointer pages: 5, data page slots: 5936 
    Data pages: 4584, average fill: 86% 
    Primary pages: 4584, secondary pages: 0, swept pages: 1 
    Empty pages: 68, full pages: 4491 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4491 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 145.18, total records: 180656 
    Average version length: 153.04, total versions: 6916, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 8, data page slots: 5472 
    Data pages: 4336, average fill: 86% 
    Primary pages: 4336, secondary pages: 0, swept pages: 9 
    Empty pages: 48, full pages: 4273 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4272 
 
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.50, total records: 2129010 
    Average version length: 52.90, total versions: 50472, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25464 
    Data pages: 25464, average fill: 72% 
    Primary pages: 25464, secondary pages: 0, swept pages: 8889 
    Empty pages: 276, full pages: 22499 
    Fill distribution: 
     0 - 19% = 475 
    20 - 39% = 339 
    40 - 59% = 732 
    60 - 79% = 23438 
    80 - 99% = 480 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2614, nodes: 2129010 
    Average node length: 5.44, total dup: 1987390, max dup: 1416 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185104, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 291 
        40 - 59% = 1718 
        60 - 79% = 310 
        80 - 99% = 290 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2129010 
    Average node length: 5.69, total dup: 1911225, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 381496, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2351 
        60 - 79% = 375 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2207, nodes: 2129010 
    Average node length: 4.96, total dup: 2128910, max dup: 27887 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 182253, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 191 
        40 - 59% = 1248 
        60 - 79% = 405 
        80 - 99% = 361 
 
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: 38.34, total records: 163169 
    Average version length: 69.18, total versions: 72778, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.29 
    Pointer pages: 3, data page slots: 3744 
    Data pages: 3248, average fill: 58% 
    Primary pages: 3248, secondary pages: 0, swept pages: 430 
    Empty pages: 609, full pages: 2131 
    Fill distribution: 
     0 - 19% = 825 
    20 - 39% = 151 
    40 - 59% = 83 
    60 - 79% = 750 
    80 - 99% = 1439 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102572, depth: 3, leaf buckets: 245, nodes: 163169 
    Average node length: 6.44, total dup: 142014, max dup: 29 
    Average key length: 3.92, compression ratio: 10.72 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 28123, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 45 
        40 - 59% = 121 
        60 - 79% = 65 
        80 - 99% = 13 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.78, total records: 7059118 
    Average version length: 68.81, total versions: 428283, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 63, data page slots: 101360 
    Data pages: 101360, average fill: 75% 
    Primary pages: 101360, secondary pages: 0, swept pages: 20759 
    Empty pages: 13, full pages: 80838 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 791 
    40 - 59% = 5853 
    60 - 79% = 87426 
    80 - 99% = 7201 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10627, nodes: 7059118 
    Average node length: 6.51, total dup: 6106039, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1563504, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1761 
        40 - 59% = 5514 
        60 - 79% = 2701 
        80 - 99% = 643 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8603, nodes: 7059118 
    Average node length: 5.40, total dup: 6777743, max dup: 150 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1367859, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1160 
        40 - 59% = 4999 
        60 - 79% = 1464 
        80 - 99% = 974 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8675, nodes: 7059118 
    Average node length: 5.40, total dup: 6777743, max dup: 150 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1370369, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1258 
        40 - 59% = 5002 
        60 - 79% = 1414 
        80 - 99% = 989 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.80, total records: 12068192 
    Average version length: 68.72, total versions: 377178, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 103, data page slots: 167728 
    Data pages: 167728, average fill: 76% 
    Primary pages: 167728, secondary pages: 0, swept pages: 70106 
    Empty pages: 2, full pages: 156970 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 565 
    40 - 59% = 3365 
    60 - 79% = 156358 
    80 - 99% = 7384 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18314, nodes: 12068192 
    Average node length: 6.57, total dup: 10521656, max dup: 71 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2378815, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 2376 
        40 - 59% = 10640 
        60 - 79% = 4277 
        80 - 99% = 989 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.72, total records: 1724475 
    Average version length: 69.13, total versions: 684291, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.02 
    Pointer pages: 26, data page slots: 41344 
    Data pages: 27719, average fill: 71% 
    Primary pages: 27718, secondary pages: 1, swept pages: 5045 
    Empty pages: 1524, full pages: 21314 
    Fill distribution: 
     0 - 19% = 2802 
    20 - 39% = 1446 
    40 - 59% = 1118 
    60 - 79% = 10823 
    80 - 99% = 11530 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2151, nodes: 1724475 
    Average node length: 5.51, total dup: 1655120, max dup: 95 
    Average key length: 2.55, compression ratio: 16.48 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 116456, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 332 
        40 - 59% = 1036 
        60 - 79% = 579 
        80 - 99% = 193 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.68, total records: 1058465 
    Average version length: 69.13, total versions: 465333, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.26 
    Pointer pages: 20, data page slots: 31072 
    Data pages: 25672, average fill: 48% 
    Primary pages: 25672, secondary pages: 0, swept pages: 5106 
    Empty pages: 4794, full pages: 11557 
    Fill distribution: 
     0 - 19% = 8817 
    20 - 39% = 2295 
    40 - 59% = 1466 
    60 - 79% = 5462 
    80 - 99% = 7632 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1412, nodes: 1058465 
    Average node length: 5.76, total dup: 990309, max dup: 95 
    Average key length: 2.84, compression ratio: 14.81 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 135990, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 263 
        40 - 59% = 678 
        60 - 79% = 366 
        80 - 99% = 103 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.64, total records: 9317223 
    Average version length: 68.96, total versions: 440679, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 89, data page slots: 143792 
    Data pages: 143760, average fill: 69% 
    Primary pages: 143760, secondary pages: 0, swept pages: 48290 
    Empty pages: 301, full pages: 93011 
    Fill distribution: 
     0 - 19% = 1193 
    20 - 39% = 7623 
    40 - 59% = 21872 
    60 - 79% = 105048 
    80 - 99% = 8024 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13462, nodes: 9317223 
    Average node length: 6.68, total dup: 7731011, max dup: 29 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2019287, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1197 
        40 - 59% = 6643 
        60 - 79% = 4801 
        80 - 99% = 816 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21208796 
    Average version length: 82.86, total versions: 15503, 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: 319488 
    Data pages: 319488, average fill: 81% 
    Primary pages: 319488, secondary pages: 0, swept pages: 12602 
    Empty pages: 4, full pages: 319483 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 27253 
    80 - 99% = 292230 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19444, nodes: 21208796 
    Average node length: 5.72, total dup: 20726243, max dup: 155 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3289394, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 3 
        40 - 59% = 8169 
        60 - 79% = 533 
        80 - 99% = 10729 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17267, nodes: 21208796 
    Average node length: 6.31, total dup: 18637967, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916482, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 852 
        60 - 79% = 313 
        80 - 99% = 16099 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21265, nodes: 21208796 
    Average node length: 6.35, total dup: 18556938, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3585032, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8499 
        60 - 79% = 620 
        80 - 99% = 12139 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16327, nodes: 21208796 
    Average node length: 5.56, total dup: 21208696, max dup: 231701 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945314, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 11 
        40 - 59% = 3196 
        60 - 79% = 478 
        80 - 99% = 12640 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.69, total records: 9776713 
    Average version length: 82.57, total versions: 442761, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 105, data page slots: 170904 
    Data pages: 170864, average fill: 71% 
    Primary pages: 170864, secondary pages: 0, swept pages: 66911 
    Empty pages: 401, full pages: 105029 
    Fill distribution: 
     0 - 19% = 1456 
    20 - 39% = 7963 
    40 - 59% = 26103 
    60 - 79% = 67714 
    80 - 99% = 67628 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11377, nodes: 9776713 
    Average node length: 5.36, total dup: 9466657, max dup: 201 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2144638, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 62 
        40 - 59% = 7988 
        60 - 79% = 3222 
        80 - 99% = 101 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13725, nodes: 9776713 
    Average node length: 6.23, total dup: 8106910, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1485095, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 4064 
        40 - 59% = 4440 
        60 - 79% = 2727 
        80 - 99% = 2363 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12703, nodes: 9776713 
    Average node length: 5.98, total dup: 8485076, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2338021, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 78 
        40 - 59% = 8976 
        60 - 79% = 3506 
        80 - 99% = 138 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10198, nodes: 9776713 
    Average node length: 5.13, total dup: 9776613, max dup: 160212 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1515679, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1184 
        40 - 59% = 5120 
        60 - 79% = 1744 
        80 - 99% = 2099 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.85, total records: 11425144 
    Average version length: 82.49, total versions: 341204, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 119, data page slots: 193344 
    Data pages: 191592, average fill: 73% 
    Primary pages: 191592, secondary pages: 0, swept pages: 67971 
    Empty pages: 3203, full pages: 146219 
    Fill distribution: 
     0 - 19% = 5330 
    20 - 39% = 7267 
    40 - 59% = 16639 
    60 - 79% = 40965 
    80 - 99% = 121391 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13131, nodes: 11425144 
    Average node length: 5.30, total dup: 11314962, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2372566, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 109 
        40 - 59% = 8834 
        60 - 79% = 4017 
        80 - 99% = 170 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10586, nodes: 11425144 
    Average node length: 5.49, total dup: 10927243, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 707641, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 892 
        40 - 59% = 2606 
        60 - 79% = 1824 
        80 - 99% = 5093 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15006, nodes: 11425144 
    Average node length: 6.02, total dup: 9972984, max dup: 79 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2389138, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 147 
        40 - 59% = 10310 
        60 - 79% = 4327 
        80 - 99% = 221 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10905, nodes: 11425144 
    Average node length: 5.22, total dup: 11425044, max dup: 202206 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 695451, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 835 
        40 - 59% = 4917 
        60 - 79% = 1527 
        80 - 99% = 3538 
 
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: 79.04, total records: 9893519 
    Average version length: 82.89, total versions: 442895, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 108, data page slots: 175784 
    Data pages: 175688, average fill: 70% 
    Primary pages: 175688, secondary pages: 0, swept pages: 73588 
    Empty pages: 889, full pages: 104934 
    Fill distribution: 
     0 - 19% = 2426 
    20 - 39% = 8985 
    40 - 59% = 28354 
    60 - 79% = 69689 
    80 - 99% = 66234 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11923, nodes: 9893519 
    Average node length: 5.18, total dup: 9864605, max dup: 1704 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1951567, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1439 
        40 - 59% = 7938 
        60 - 79% = 1868 
        80 - 99% = 643 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13862, nodes: 9893519 
    Average node length: 6.25, total dup: 8203734, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1447479, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 4071 
        40 - 59% = 4438 
        60 - 79% = 2676 
        80 - 99% = 2520 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12569, nodes: 9893519 
    Average node length: 5.44, total dup: 9452175, max dup: 95 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2087521, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1453 
        40 - 59% = 8776 
        60 - 79% = 1739 
        80 - 99% = 576 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10362, nodes: 9893519 
    Average node length: 5.16, total dup: 9893419, max dup: 164339 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1536277, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1264 
        40 - 59% = 5166 
        60 - 79% = 1755 
        80 - 99% = 2126 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.35, total records: 581140 
    Average version length: 68.81, total versions: 7060, 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: 8024 
    Data pages: 8024, average fill: 76% 
    Primary pages: 8024, secondary pages: 0, swept pages: 3413 
    Empty pages: 2, full pages: 7079 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 23 
    40 - 59% = 170 
    60 - 79% = 7719 
    80 - 99% = 105 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 49041, depth: 3, leaf buckets: 739, nodes: 581140 
    Average node length: 5.95, total dup: 495025, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101215, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 513 
        60 - 79% = 94 
        80 - 99% = 100 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36027, depth: 3, leaf buckets: 763, nodes: 581140 
    Average node length: 6.15, total dup: 476755, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101265, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 25 
        40 - 59% = 530 
        60 - 79% = 106 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 582, nodes: 581140 
    Average node length: 4.86, total dup: 581040, max dup: 9666 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89827, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 342 
        60 - 79% = 89 
        80 - 99% = 118 
 
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 Wed Apr  3 22:11:59 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7810550 99625 1 0.0000 0.0000
DOC_LIST 2270247 106469 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 243141 637 60700.0000 0.0000
INVNT_TURNOVER_LOG 91003 64502 1 0.0000 0.0000
MONEY_SALDO 49 18502 1033 37700.0000 0.0000
MONEY_TURNOVER_LOG 1725 1513 1 0.0000 0.0000
PDISTR 809953 83970 5 0.0000 0.0000
PERF_SPLIT_0 183326 16731 1 0.0000 0.0000
PERF_SPLIT_1 161585 7048 1 0.0000 0.0000
PERF_SPLIT_2 180604 5578 1 0.0000 0.0000
PERF_SPLIT_3 190046 24315 1 0.0000 0.0000
PERF_SPLIT_4 150225 7193 1 0.0000 0.0000
PERF_SPLIT_5 193229 18320 1 0.0000 0.0000
PERF_SPLIT_6 193970 27349 1 0.0000 0.0000
PERF_SPLIT_7 180398 4136 1 0.0000 0.0000
PERF_SPLIT_8 189790 9629 1 0.0000 0.0000
PERF_SPLIT_9 180656 6916 1 0.0000 0.0000
PSTORNED 2129010 50472 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 163169 72778 1 0.0000 0.0000
XQD_1000_3300 7059118 428283 1 0.0000 0.0000
XQD_1200_2000 12068192 377178 1 0.0000 0.0000
XQD_2000_3300 1724475 684291 1 0.0000 0.0000
XQD_2100_3300 1058465 465333 1 0.0000 0.0000
XQD_3300_3400 9317223 440679 1 0.0000 0.0000
XQS_1000_1200 21208796 15503 1 0.0000 0.0000
XQS_1000_3300 9776713 442761 1 0.0000 0.0000
XQS_1200_2000 11425144 341204 1 0.0000 0.0000
XQS_2100_3300 9893519 442895 1 0.0000 0.0000
XQS_3300_3400 581140 7060 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 ---
:736: 
:737: mscs-test-161.budzdorov.ru    Wed Apr  3 22:09:57 2024
:738:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:739: 
:740: 
:741: mscs-test-161.budzdorov.ru    Wed Apr  3 22:10:00 2024
:742:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:743: 
:744: 
:745: mscs-test-161.budzdorov.ru    Wed Apr  3 22:10:03 2024
:746:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:747: 
:748: 
:749: mscs-test-161.budzdorov.ru    Wed Apr  3 22:10:03 2024
:750:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:751: 
--- end of diff output ---

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

03.04.24 22:12:11. 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-03 22:12:13 No severe PSQL-related problems occured
03.04.24 22:12:15. End of report.