Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.02.2024 19: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 15879456 kB
MemAvailable 30198220 kB
Buffers 0 kB
Cached 15847836 kB
SwapCached 4824 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-14 19:09:35
DTS_END                         2024-02-14 19:09:35.4130
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/54604
TRN_ID                          175066
ATT_ID                          542
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: 9008.95 23794 900895
customer order: creation 172.14 386 17214
customer order: refuse 14.56 376 1456
order to supplier: creation 46.26 1274 4626
order to supplier: removal 3.47 96003 347
invoice (draft): creation 45.89 3276 4589
invoice (draft): removal 47.90 867 4790
invoice accept: apply 42.39 21544 4239
invoice accept: cancel 43.34 827 4334
customer reserve: creation 4014.03 209 401403
customer reserve: removal 4284.91 60 428491
realization accept: apply 86.17 196 8617
realization accept: cancel 76.49 131 7649
payment from customer: creation 59.33 117 5933
payment from customer: removal 6.02 102 602
payment to supplier: creation 49.36 133 4936
payment to supplier: removal 3.78 90 378
service: total inventory turnovers 5.25 1131 525
service: total monetary turnovers 6.89 47 689
service: aggregate perf. data 0.74 24499 74
service: refresh index statistics 0.03 324606 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-02-2024 19:10:38 to 14-02-2024 19:10:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2623
TEST_TIME 2 3397
TEST_TIME 3 4081
TEST_TIME 4 3934
TEST_TIME 5 3890
TEST_TIME 6 4333
TEST_TIME 7 4251
TEST_TIME 8 4612
TEST_TIME 9 5038
TEST_TIME 10 5080
TEST_TIME 11 5074
TEST_TIME 12 5449
TEST_TIME 13 5417
TEST_TIME 14 5484
TEST_TIME 15 5700
TEST_TIME 16 5942
TEST_TIME 17 6190
TEST_TIME 18 6845
TEST_TIME 19 7085
TEST_TIME 20 7364
TEST_TIME 21 7432
TEST_TIME 22 7713
TEST_TIME 23 8019
TEST_TIME 24 7934
TEST_TIME 25 7847
TEST_TIME 26 8097
TEST_TIME 27 8584
TEST_TIME 28 9037
TEST_TIME 29 9250
TEST_TIME 30 8975
TEST_TIME 31 8951
TEST_TIME 32 9090
TEST_TIME 33 8944
TEST_TIME 34 8829
TEST_TIME 35 8760
TEST_TIME 36 8690
TEST_TIME 37 8697
TEST_TIME 38 8677
TEST_TIME 39 8644
TEST_TIME 40 8693
TEST_TIME 41 8673
TEST_TIME 42 8630
TEST_TIME 43 8590
TEST_TIME 44 8636
TEST_TIME 45 8655
TEST_TIME 46 8602
TEST_TIME 47 8618
TEST_TIME 48 8603
TEST_TIME 49 8762
TEST_TIME 50 8803
TEST_TIME 51 8814
TEST_TIME 52 8950
TEST_TIME 53 8885
TEST_TIME 54 9040
TEST_TIME 55 9032
TEST_TIME 56 9008
TEST_TIME 57 9060
TEST_TIME 58 9051
TEST_TIME 59 9129
TEST_TIME 60 9014
TEST_TIME 61 8958
TEST_TIME 62 8993
TEST_TIME 63 8928
TEST_TIME 64 8860
TEST_TIME 65 8910
TEST_TIME 66 8883
TEST_TIME 67 8873
TEST_TIME 68 8858
TEST_TIME 69 8786
TEST_TIME 70 8771
TEST_TIME 71 8941
TEST_TIME 72 8934
TEST_TIME 73 8939
TEST_TIME 74 9032
TEST_TIME 75 9000
TEST_TIME 76 9010
TEST_TIME 77 9085
TEST_TIME 78 9073
TEST_TIME 79 9106
TEST_TIME 80 9136
TEST_TIME 81 9106
TEST_TIME 82 9201
TEST_TIME 83 9236
TEST_TIME 84 9275
TEST_TIME 85 9222
TEST_TIME 86 9143
TEST_TIME 87 9096
TEST_TIME 88 9107
TEST_TIME 89 9147
TEST_TIME 90 9151
TEST_TIME 91 9100
TEST_TIME 92 9074
TEST_TIME 93 9043
TEST_TIME 94 9003
TEST_TIME 95 8985
TEST_TIME 96 8974
TEST_TIME 97 8965
TEST_TIME 98 9003
TEST_TIME 99 9060
TEST_TIME 100 9017

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-02-2024 19:10:42 to 14-02-2024 19:10:45.

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 1269040 1269040 0 0.00 0 21441 7 0 0
doc_list_biud 1269040 1269040 0 0.00 0 25456 27 0 0
sp_add_invoice_to_stock 4387 4239 148 3.37 48 240320 21544 0 148
sp_cancel_adding_invoice 4334 4334 0 0.00 5 61821 827 0 0
sp_cancel_client_order 1456 1456 0 0.00 4 17712 377 0 0
sp_cancel_customer_reserve 428491 428491 0 0.00 1 25457 61 0 0
sp_cancel_pay_from_customer 602 602 0 0.00 3 9415 102 0 0
sp_cancel_pay_to_supplier 378 378 0 0.00 2 5245 91 0 0
sp_cancel_supplier_invoice 4800 4790 10 0.20 2 20645 867 0 10
sp_cancel_supplier_order 347 347 0 0.00 8 849502 96003 0 0
sp_cancel_write_off 7649 7649 0 0.00 1 15662 132 0 0
sp_client_order 17214 17214 0 0.00 3 30369 387 0 0
sp_customer_reserve 401403 401403 0 0.00 0 37910 210 0 0
sp_fill_shopping_cart 26428 26428 0 0.00 1 18398 41 0 0
sp_fill_shopping_cart_clo_res 401393 401393 0 0.00 0 17740 15 0 0
sp_get_clo_for_invoice 4229 4229 0 0.00 0 28905 325 0 0
sp_kill_cost_storno 12963 12963 0 0.00 0 9408 67 0 0
sp_kill_qstorno_ret_qs2qd 869768 869768 0 0.00 0 25451 33 0 0
sp_kill_qty_storno 459913 459913 0 0.00 0 25456 72 0 0
sp_lock_selected_doc 17704 17704 0 0.00 0 4961 4 0 0
sp_make_cost_storno 23715 23715 0 0.00 0 14963 59 0 0
sp_multiply_rows_for_pdistr 23715 23715 0 0.00 0 10529 30 0 0
sp_multiply_rows_for_qdistr 17214 17214 0 0.00 0 11158 169 0 0
sp_pay_from_customer 5933 5933 0 0.00 4 13293 118 0 0
sp_pay_to_supplier 4936 4936 0 0.00 5 10010 133 0 0
sp_payment_common 10869 10869 0 0.00 2 10419 31 0 0
sp_qd_handle_on_cancel_clo 1456 1456 0 0.00 0 17707 350 0 0
sp_qd_handle_on_invoice_upd_sts 8563 8563 0 0.00 0 22449 332 0 0
sp_qd_handle_on_reserve_upd_sts 8617 8617 0 0.00 0 20636 79 0 0
sp_reserve_write_off 8617 8617 0 0.00 7 20649 197 0 0
sp_supplier_invoice 4589 4589 0 0.00 6 84790 3276 0 0
sp_supplier_order 4626 4626 0 0.00 4 59065 1274 0 0
srv_aggregate_perf_data 75 74 1 1.33 1804 557930 24499 0 1
srv_fill_mon_cache_memory 56 56 0 0.00 1745 137031 39565 0 0
srv_find_qd_qs_mism 858557 858557 0 0.00 0 21440 7 0 0
srv_make_invnt_saldo 525 525 0 0.00 26 32316 1131 0 0
srv_make_money_saldo 689 689 0 0.00 1 7411 47 0 0
srv_recalc_idx_stat 3 3 0 0.00 208666 435568 324606 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4240 4240 0 0.00 0 22453 204 0 0
t$perf-norm:sp_cancel_adding_invoice 335 335 0 0.00 0 16675 179 0 0
t$perf-norm:sp_cancel_client_order 1456 1456 0 0.00 0 1424 11 0 0
t$perf-norm:sp_cancel_customer_reserve 544 544 0 0.00 0 1084 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 602 602 0 0.00 0 1234 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 378 378 0 0.00 0 404 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 326 326 0 0.00 0 603 14 0 0
t$perf-norm:sp_cancel_supplier_order 347 347 0 0.00 0 23010 1662 0 0
t$perf-norm:sp_cancel_write_off 871 871 0 0.00 0 4874 11 0 0
t$perf-norm:sp_client_order 17214 17214 0 0.00 0 4223 16 0 0
t$perf-norm:sp_customer_reserve 821 821 0 0.00 0 4947 17 0 0
t$perf-norm:sp_pay_from_customer 5933 5933 0 0.00 0 4567 11 0 0
t$perf-norm:sp_pay_to_supplier 4936 4936 0 0.00 0 9869 17 0 0
t$perf-norm:sp_reserve_write_off 8617 8617 0 0.00 0 9276 12 0 0
t$perf-norm:sp_supplier_invoice 4589 4589 0 0.00 0 4740 18 0 0
t$perf-norm:sp_supplier_order 4626 4626 0 0.00 0 2968 12 0 0
t$perf-norm:srv_aggregate_perf_data 74 74 0 0.00 0 84 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 336 13 0 0
t$perf-norm:srv_make_invnt_saldo 525 525 0 0.00 0 984 24 0 0
t$perf-norm:srv_make_money_saldo 689 689 0 0.00 0 4313 27 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 8 5 0 0
v_add_invoice_to_stock 8754 8458 296 3.38 0 9271 20 0 296
v_all_customers 31422 31422 0 0.00 0 30 1 0 0
v_all_suppliers 25970 25970 0 0.00 0 30 1 0 0
v_all_wares 34428 34428 0 0.00 0 52 1 0 0
v_cancel_adding_invoice 670 670 0 0.00 0 487 8 0 0
v_cancel_client_order 2912 2912 0 0.00 0 2812 8 0 0
v_cancel_customer_prepayment 1204 1204 0 0.00 0 4600 9 0 0
v_cancel_customer_reserve 1088 1088 0 0.00 0 4119 18 0 0
v_cancel_payment_to_supplier 756 756 0 0.00 0 2069 8 0 0
v_cancel_supplier_invoice 672 652 20 2.97 0 2801 23 0 20
v_cancel_supplier_order 694 694 0 0.00 0 463 4 0 0
v_cancel_write_off 1742 1742 0 0.00 0 2440 13 0 0
v_max_id_clo_ord 4625 4625 0 0.00 0 5257 3 0 0
v_max_id_clo_res 821 821 0 0.00 0 3978 14 0 0
v_max_id_ord_sup 4589 4589 0 0.00 0 4874 8 0 0
v_max_non_paid_invoice 1165 1165 0 0.00 0 1958 7 0 0
v_max_non_paid_realizn 3065 3065 0 0.00 0 3865 7 0 0
v_min_id_clo_ord 4625 4625 0 0.00 0 8452 17 0 0
v_min_id_clo_res 821 821 0 0.00 0 6850 22 0 0
v_min_id_ord_sup 4589 4589 0 0.00 0 3245 4 0 0
v_min_non_paid_invoice 4936 4936 0 0.00 0 7040 23 0 0
v_min_non_paid_realizn 5933 5933 0 0.00 0 7920 22 0 0
v_our_firm 8742 8742 0 0.00 0 18 1 0 0
v_reserve_write_off 17232 17232 0 0.00 0 3500 6 0 0
x_lock_depdocs_on_canc_invoice 8798 8798 0 0.00 0 18544 147 0 0
x_lock_depdocs_on_canc_sup_ord 347 347 0 0.00 0 9418 328 0 0
x_make_qstorno_1000_1200 4626 4626 0 0.00 1 59060 1181 0 0
x_make_qstorno_1200_2000 4589 4589 0 0.00 3 84604 3133 0 0
x_make_qstorno_2100_3300 401403 401403 0 0.00 0 36061 191 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-02-2024 19:10:46 to 14-02-2024 19:10:50.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:39 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:40 25546 8192000000 9895978240 10201993216 979647904 10.681 100 87 172 0 1006941712 5467344 21826464
17:12:09 20621 8192000000 9940818640 10259795968 1018674800 11.059 100 86 172 0 1048352160 7909936 21767424
17:13:39 3144 8192000000 9965460448 10294906880 1053367440 11.393 100 82 162 0 1082855616 9482464 20005712
17:14:45 7746 8192000000 10012136400 10353180672 1098209584 11.821 100 83 164 1 1128507120 10926928 19370608
17:15:56 5529 8192000000 10070332336 10421735424 1147333024 12.284 100 84 168 1 1179704272 12910512 19460736
17:17:04 4127 8192000000 10100244384 10464120832 1191116720 12.694 100 76 152 0 1220066288 11848016 17101552
17:18:11 2250 8192000000 10140294896 10513612800 1233490368 13.086 100 83 162 0 1264579536 13304848 17784320
17:19:16 6239 8192000000 10167701632 10549735424 1261776688 13.346 100 80 160 0 1292170928 12844128 17550112
17:20:25 1766 8192000000 10196105216 10581274624 1282527344 13.536 100 89 176 1 1316951248 14362688 20061216
17:21:28 11289 8192000000 10188104784 10587983872 1290766928 13.611 100 56 107 2 1310187424 7241552 12178944
17:22:44 4723 8192000000 10188639920 10598477824 1301406240 13.708 100 38 76 0 1318469392 8797584 8265568
17:23:51 4873 8192000000 10200682352 10608779264 1311282704 13.798 100 40 80 0 1326960432 5999760 9677968
17:24:56 12145 8192000000 10204376560 10624868352 1316306656 13.843 100 16 32 0 1330154368 10700496 3147216
17:26:11 37840 8192000000 10223558368 10637324288 1326160256 13.932 100 12 23 1 1333101536 4743728 2197552
17:27:51 4874 8192000000 10236044928 10655092736 1332638320 13.991 100 33 66 1 1352682752 12817136 7227296
17:29:01 6115 8192000000 10229831120 10652229632 1337425744 14.034 100 28 56 0 1354316640 10635744 6255152
17:30:14 20669 8192000000 10225894128 10637684736 1314270528 13.825 99 36 72 2 1329681280 6745568 8665184
17:31:38 30636 8192000000 10247536048 10665181184 1339405184 14.052 100 46 92 2 1365449376 15594176 10450016
17:33:10 66611 8192000000 10214124000 10622955520 1262769056 13.355 94 35 70 0 1282912576 11894912 8248608
17:35:37 41764 8192000000 10224932768 10629255168 1279130128 13.505 96 42 84 0 1305427328 16350512 9946688
17:37:25 37457 8192000000 10217192224 10636189696 1281798784 13.529 97 39 76 0 1309468704 18414016 9255904
17:39:14 14991 8192000000 10216517888 10617892864 1279896224 13.512 97 43 84 1 1305885872 16519536 9470112
17:40:37 19175 8192000000 10240014320 10644701184 1320072704 13.877 100 44 87 1 1348821248 18758016 9990528
17:42:02 2555 8192000000 10243633200 10638069760 1314803040 13.830 99 67 132 0 1349069088 18691648 15574400
17:43:14 2361 8192000000 10254181120 10649124864 1324017536 13.913 100 65 128 0 1361479696 21504528 15957632
17:44:21 4020 8192000000 10276773872 10680627200 1347076336 14.121 100 60 118 0 1387755152 26428016 14250800
17:45:28 2355 8192000000 10279607472 10682073088 1343669504 14.090 100 67 133 1 1387122784 27174112 16279168
17:46:34 3707 8192000000 10292620448 10697564160 1352415712 14.169 100 66 130 0 1400981504 32505072 16060720
17:47:41 1743 8192000000 10293717072 10704502784 1357703744 14.217 100 67 131 0 1399462640 26563488 15195408
17:48:47 7389 8192000000 10309589440 10717614080 1365809344 14.289 100 73 141 1 1412815088 30195632 16810112
17:50:06 10156 8192000000 10335296880 10740760576 1387753808 14.486 100 82 164 1 1435481808 28936128 18791872
17:51:23 10190 8192000000 10341517456 10757558272 1394801872 14.549 100 54 108 0 1447329776 38576000 13951904
17:52:57 17400 8192000000 10331204512 10762395648 1400736992 14.602 100 24 48 0 1437894960 30842816 6315152
17:54:17 16892 8192000000 10337657024 10767769600 1397820704 14.576 100 27 54 1 1442604000 37119024 7664272
17:55:50 32913 8192000000 10318143984 10766671872 1382480448 14.439 100 18 36 0 1428454784 40373792 5600544
17:57:27 20654 8192000000 10301894432 10748186624 1381358592 14.429 100 17 34 0 1414004160 28175600 4469968
17:58:52 72261 8192000000 10302358016 10744393728 1392261792 14.526 100 40 80 0 1409634192 8194912 9177488
18:01:07 17204 8192000000 10294197024 10752000000 1394875984 14.549 100 21 42 0 1408624848 9152144 4596720
18:02:25 26596 8192000000 10288702064 10742923264 1393303344 14.535 100 14 28 0 1403790608 6999184 3488080
18:04:04 41872 8192000000 10309616736 10760663040 1407166736 14.659 100 39 78 0 1425286592 9952176 8167680
18:05:48 55521 8192000000 10320393136 10775519232 1409795376 14.682 100 25 49 0 1430996864 15420768 5780720
18:07:58 70141 8192000000 10318652048 10780635136 1420011360 14.773 100 21 42 0 1437349376 11861040 5476976
18:10:30 23087 8192000000 10327316640 10775048192 1402974288 14.621 99 25 49 1 1423644304 15070192 5599824
18:12:08 21256 8192000000 10318251872 10783412224 1415188960 14.730 100 8 15 0 1433043952 16259360 1595632
18:13:31 43394 8192000000 10299949408 10776662016 1398480192 14.581 99 24 47 0 1419279584 15729264 5070128
18:15:18 57362 8192000000 10315803760 10778144768 1384580176 14.457 98 8 16 0 1397812144 11659120 1572848
18:17:16 49021 8192000000 10302049440 10759888896 1356935360 14.210 96 18 36 0 1376130608 14933792 4261456
18:19:05 46675 8192000000 10292186544 10740236288 1353087344 14.175 97 14 28 0 1369712864 13222912 3402608
18:20:54 58339 8192000000 10288923728 10746904576 1364018384 14.273 98 23 46 0 1386991088 17612240 5360464
18:22:55 77331 8192000000 10258194240 10718380032 1281825952 13.530 93 17 32 0 1303910000 18335152 3748896
18:25:20 9272 8192000000 10288545296 10712379392 1359110368 14.229 100 57 114 0 1384163616 12573872 12479376
18:26:34 21098 8192000000 10245473408 10678013952 1288220656 13.588 96 51 102 0 1315000112 15750368 11029088
18:28:05 57964 8192000000 10257909024 10693812224 1314340240 13.825 98 34 68 0 1346323200 24168320 7814640
18:30:09 137031 8192000000 10249459152 10704797696 1298899376 13.685 96 19 38 0 1315722064 12754912 4067776
18:33:26 15147 8192000000 10254955216 10685407232 1338413568 14.043 99 44 88 0 1360002016 11719728 9868720
18:35:52 42736 8192000000 10250482816 10699665408 1338576160 14.045 99 21 41 0 1355291440 11800176 4915104
18:37:36 67792 8192000000 10264851776 10713849856 1347423536 14.124 99 17 34 0 1364127968 12570992 4133440
18:40:46 72716 8192000000 10269807136 10710773760 1314279360 13.825 96 7 15 0 1326154928 10420976 1454592
18:42:59 69975 8192000000 10257876640 10702651392 1326334336 13.934 97 12 24 0 1336726944 8215104 2177504
18:45:10 40487 8192000000 10282205936 10718461952 1346897120 14.120 98 34 68 0 1366858864 12389280 7572464
18:46:54 28286 8192000000 10283343936 10724818944 1371390288 14.340 100 34 68 0 1387857968 9069488 7398192
18:48:29 21722 8192000000 10304696864 10746949632 1391410832 14.518 100 37 74 1 1412014672 12396944 8206896
18:50:14 63419 8192000000 10325316016 10769612800 1399029424 14.586 100 24 48 0 1419660672 15586816 5044432
18:52:17 45853 8192000000 10308821744 10756202496 1374523632 14.368 98 14 28 1 1394646816 16522912 3600272
18:54:11 96840 8192000000 10314898384 10763726848 1406628880 14.654 100 35 70 0 1424579856 9736496 8214480
18:56:50 73832 8192000000 10309238032 10774720512 1394146928 14.543 99 26 52 0 1417779200 17573264 6059008
18:59:05 25420 8192000000 10294585264 10749685760 1385284816 14.464 99 24 48 0 1399526288 8716688 5524784
19:00:41 67712 8192000000 10280772864 10737790976 1366848304 14.299 98 10 20 0 1376033200 6849120 2335776
19:02:49 82727 8192000000 10263132480 10721312768 1354879136 14.191 98 15 30 0 1365521568 7521792 3120640
19:05:12 42768 8192000000 10274586208 10730135552 1360807584 14.245 98 23 46 0 1380560160 14810144 4942432
19:06:54 77514 8192000000 10279811168 10733748224 1317580720 13.855 95 21 42 0 1332906256 10164144 5161392
19:09:12 31604 8192000000 9202572352 9452556288 357652576 4.183 26 2 4 0 362291136 4546352 92208

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 14-02-2024 19:10:52 to 14-02-2024 19:11:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 148 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-02-2024 19:11:07 to 14-02-2024 19:11:09.

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          175006
MON$OLDEST_ACTIVE               175701
MON$OLDEST_SNAPSHOT             175701
MON$NEXT_TRANSACTION            175701
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                       1893440
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.33730 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33730 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33730 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33730 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 Feb 14 19:11:10 2024 
 
Database header page information: 
    Flags            0 
    Generation        91669 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    175006 
    Oldest active        175701 
    Oldest snapshot        175701 
    Next transaction    175702 
    Sequence number        0 
    Next attachment ID    713 
    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.36, total records: 7765961 
    Average version length: 48.16, total versions: 85811, 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: 86832 
    Data pages: 86832, average fill: 71% 
    Primary pages: 86832, secondary pages: 0, swept pages: 18886 
    Empty pages: 8, full pages: 65914 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 195 
    40 - 59% = 1830 
    60 - 79% = 84754 
    80 - 99% = 21 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23264, nodes: 7765961 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1720646, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 343 
        20 - 39% = 1613 
        40 - 59% = 4243 
        60 - 79% = 2432 
        80 - 99% = 14633 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13526, nodes: 7765961 
    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: 1543790, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1522 
        40 - 59% = 2062 
        60 - 79% = 1129 
        80 - 99% = 8812 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8338, nodes: 7765961 
    Average node length: 6.62, total dup: 5803387, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1536705, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 895 
        40 - 59% = 1390 
        60 - 79% = 959 
        80 - 99% = 4951 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.32, total records: 2255183 
    Average version length: 34.67, total versions: 88624, max versions: 3 
    Average fragment length: 7.80, total fragments: 5, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28432 
    Data pages: 28432, average fill: 73% 
    Primary pages: 28427, secondary pages: 5, swept pages: 10173 
    Empty pages: 2, full pages: 21246 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 141 
    40 - 59% = 1480 
    60 - 79% = 26081 
    80 - 99% = 711 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4561, nodes: 2255183 
    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: 702626, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 873 
        40 - 59% = 865 
        60 - 79% = 765 
        80 - 99% = 2057 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2563, nodes: 2257810 
    Average node length: 4.97, total dup: 2256911, max dup: 18233 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1248991, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 295 
        40 - 59% = 1584 
        60 - 79% = 513 
        80 - 99% = 170 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2049, nodes: 2255183 
    Average node length: 4.97, total dup: 2255133, max dup: 130305 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061805, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 82 
        40 - 59% = 1092 
        60 - 79% = 48 
        80 - 99% = 824 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4346, nodes: 2255183 
    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: 702626, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 567 
        40 - 59% = 600 
        60 - 79% = 851 
        80 - 99% = 2226 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.36, total records: 400 
    Average version length: 22.61, total versions: 251927, max versions: 653 
    Average fragment length: 2.00, total fragments: 51, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1472 
    Data pages: 1392, average fill: 89% 
    Primary pages: 9, secondary pages: 1383, swept pages: 0 
    Empty pages: 2, full pages: 1389 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 1387 
 
    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: 5.99, total records: 85647 
    Average version length: 68.29, total versions: 78146, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 14.70 
    Pointer pages: 7, data page slots: 1856 
    Data pages: 1496, average fill: 71% 
    Primary pages: 1495, secondary pages: 1, swept pages: 0 
    Empty pages: 133, full pages: 1034 
    Fill distribution: 
     0 - 19% = 182 
    20 - 39% = 107 
    40 - 59% = 118 
    60 - 79% = 125 
    80 - 99% = 964 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701492, depth: 3, leaf buckets: 280, nodes: 85647 
    Average node length: 13.16, total dup: 6404, max dup: 1 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 62017, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 91 
        40 - 59% = 102 
        60 - 79% = 85 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 18007, max versions: 982 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 80% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 62 
 
    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.76, total records: 1388 
    Average version length: 43.39, total versions: 1209, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 10.07 
    Pointer pages: 1, data page slots: 40 
    Data pages: 29, average fill: 46% 
    Primary pages: 28, secondary pages: 1, swept pages: 4 
    Empty pages: 8, full pages: 12 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 8 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89862, depth: 2, leaf buckets: 3, nodes: 1388 
    Average node length: 4.41, total dup: 1291, max dup: 145 
    Average key length: 2.76, compression ratio: 6.89 
    Average prefix length: 18.31, average data length: 0.69 
    Clustering factor: 749, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        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.95, 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: 36.00, total records: 797625 
    Average version length: 25.62, total versions: 70041, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8032, average fill: 70% 
    Primary pages: 8007, secondary pages: 25, swept pages: 1372 
    Empty pages: 51, full pages: 6638 
    Fill distribution: 
     0 - 19% = 103 
    20 - 39% = 108 
    40 - 59% = 319 
    60 - 79% = 7305 
    80 - 99% = 197 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 885, nodes: 797625 
    Average node length: 4.87, total dup: 797576, max dup: 151661 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88835, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 136 
        40 - 59% = 498 
        60 - 79% = 193 
        80 - 99% = 56 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 946, nodes: 797625 
    Average node length: 5.88, total dup: 710044, max dup: 47 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159615, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 94 
        40 - 59% = 452 
        60 - 79% = 114 
        80 - 99% = 284 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 988, nodes: 797625 
    Average node length: 5.88, total dup: 710044, max dup: 47 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161558, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 198 
        40 - 59% = 400 
        60 - 79% = 108 
        80 - 99% = 281 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1137, nodes: 797625 
    Average node length: 5.96, total dup: 710044, max dup: 47 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154161, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 246 
        40 - 59% = 586 
        60 - 79% = 213 
        80 - 99% = 87 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.84, total records: 5495 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.91, total fragments: 70, 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: 3, full pages: 66 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 2 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5495 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.05 
    Average prefix length: 34.49, average data length: 1.55 
    Clustering factor: 5231, ratio: 0.95 
    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: 5495 
    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: 154, 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.13, total records: 79906 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 776 
    Data pages: 776, average fill: 71% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 770 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 770 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36922, depth: 2, leaf buckets: 103, nodes: 79906 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3053, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 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: 148.98, total records: 172742 
    Average version length: 147.92, total versions: 2326, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 9, data page slots: 4864 
    Data pages: 4120, average fill: 86% 
    Primary pages: 4119, secondary pages: 1, swept pages: 2 
    Empty pages: 22, full pages: 4085 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4085 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 144.75, total records: 177850 
    Average version length: 152.36, total versions: 7227, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 6, data page slots: 5152 
    Data pages: 4272, average fill: 86% 
    Primary pages: 4272, secondary pages: 0, swept pages: 4 
    Empty pages: 52, full pages: 4203 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 4202 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 134.52, total records: 170327 
    Average version length: 154.70, total versions: 18241, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.61 
    Pointer pages: 7, data page slots: 4504 
    Data pages: 4064, average fill: 87% 
    Primary pages: 4064, secondary pages: 0, swept pages: 2 
    Empty pages: 20, full pages: 4033 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4033 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.35, total records: 176962 
    Average version length: 151.15, total versions: 4453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 5232 
    Data pages: 4224, average fill: 86% 
    Primary pages: 4224, secondary pages: 0, swept pages: 4 
    Empty pages: 24, full pages: 4191 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4190 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 137.25, total records: 153749 
    Average version length: 154.61, total versions: 13672, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.36 
    Pointer pages: 7, data page slots: 4008 
    Data pages: 3704, average fill: 86% 
    Primary pages: 3704, secondary pages: 0, swept pages: 1 
    Empty pages: 53, full pages: 3639 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3641 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 133.47, total records: 185555 
    Average version length: 154.50, total versions: 21334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.71 
    Pointer pages: 7, data page slots: 4656 
    Data pages: 4432, average fill: 87% 
    Primary pages: 4432, secondary pages: 0, swept pages: 2 
    Empty pages: 25, full pages: 4399 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4399 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 132.50, total records: 169647 
    Average version length: 154.58, total versions: 20526, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.80 
    Pointer pages: 6, data page slots: 4744 
    Data pages: 4072, average fill: 87% 
    Primary pages: 4072, secondary pages: 0, swept pages: 3 
    Empty pages: 43, full pages: 4018 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4018 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 144.24, total records: 188258 
    Average version length: 153.16, total versions: 8698, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.76 
    Pointer pages: 7, data page slots: 5024 
    Data pages: 4504, average fill: 87% 
    Primary pages: 4504, secondary pages: 0, swept pages: 5 
    Empty pages: 30, full pages: 4463 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4462 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.85, total records: 171913 
    Average version length: 150.61, total versions: 3454, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 8, data page slots: 4624 
    Data pages: 4096, average fill: 86% 
    Primary pages: 4096, secondary pages: 0, swept pages: 3 
    Empty pages: 23, full pages: 4066 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4065 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.31, total records: 174379 
    Average version length: 149.88, total versions: 3133, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 6, data page slots: 4408 
    Data pages: 4176, average fill: 86% 
    Primary pages: 4175, secondary pages: 1, swept pages: 2 
    Empty pages: 40, full pages: 4126 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4126 
 
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.86, total records: 2107616 
    Average version length: 53.05, total versions: 35485, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25464 
    Data pages: 25464, average fill: 71% 
    Primary pages: 25464, secondary pages: 0, swept pages: 10615 
    Empty pages: 272, full pages: 20909 
    Fill distribution: 
     0 - 19% = 501 
    20 - 39% = 384 
    40 - 59% = 1018 
    60 - 79% = 23237 
    80 - 99% = 324 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2579, nodes: 2107616 
    Average node length: 5.44, total dup: 1966460, max dup: 1382 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182820, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 277 
        40 - 59% = 1705 
        60 - 79% = 282 
        80 - 99% = 309 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2759, nodes: 2107616 
    Average node length: 5.69, total dup: 1891940, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377003, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 2405 
        60 - 79% = 318 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2134, nodes: 2107616 
    Average node length: 4.96, total dup: 2107516, max dup: 27083 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180199, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 183 
        40 - 59% = 1150 
        60 - 79% = 377 
        80 - 99% = 422 
 
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.63, total records: 156930 
    Average version length: 69.18, total versions: 69354, 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: 3, data page slots: 4256 
    Data pages: 3224, average fill: 56% 
    Primary pages: 3224, secondary pages: 0, swept pages: 469 
    Empty pages: 646, full pages: 2043 
    Fill distribution: 
     0 - 19% = 924 
    20 - 39% = 124 
    40 - 59% = 45 
    60 - 79% = 760 
    80 - 99% = 1371 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103349, depth: 3, leaf buckets: 236, nodes: 156930 
    Average node length: 6.45, total dup: 136486, max dup: 14 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26896, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 39 
        40 - 59% = 121 
        60 - 79% = 60 
        80 - 99% = 15 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.31, total records: 7124038 
    Average version length: 68.80, total versions: 480919, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 63, data page slots: 102576 
    Data pages: 102576, average fill: 74% 
    Primary pages: 102576, secondary pages: 0, swept pages: 20484 
    Empty pages: 25, full pages: 82820 
    Fill distribution: 
     0 - 19% = 126 
    20 - 39% = 1123 
    40 - 59% = 6838 
    60 - 79% = 85923 
    80 - 99% = 8566 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10702, nodes: 7124038 
    Average node length: 6.51, total dup: 6163120, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1582723, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1483 
        40 - 59% = 5938 
        60 - 79% = 2788 
        80 - 99% = 486 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8370, nodes: 7124038 
    Average node length: 5.40, total dup: 6840093, max dup: 185 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1377543, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1034 
        40 - 59% = 4476 
        60 - 79% = 1659 
        80 - 99% = 1195 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8428, nodes: 7124038 
    Average node length: 5.40, total dup: 6840093, max dup: 185 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1380052, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1065 
        40 - 59% = 4496 
        60 - 79% = 1665 
        80 - 99% = 1193 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.75, total records: 12139227 
    Average version length: 68.74, total versions: 388813, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 104, data page slots: 168416 
    Data pages: 168416, average fill: 76% 
    Primary pages: 168416, secondary pages: 0, swept pages: 68859 
    Empty pages: 9, full pages: 159088 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 572 
    40 - 59% = 2894 
    60 - 79% = 157090 
    80 - 99% = 7789 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18314, nodes: 12139227 
    Average node length: 6.58, total dup: 10582244, max dup: 64 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2381887, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 2045 
        40 - 59% = 10872 
        60 - 79% = 4553 
        80 - 99% = 817 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 39.15, total records: 1658333 
    Average version length: 69.08, total versions: 719554, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.22 
    Pointer pages: 25, data page slots: 39616 
    Data pages: 28960, average fill: 66% 
    Primary pages: 28959, secondary pages: 1, swept pages: 5763 
    Empty pages: 2766, full pages: 20312 
    Fill distribution: 
     0 - 19% = 4468 
    20 - 39% = 1803 
    40 - 59% = 1435 
    60 - 79% = 9994 
    80 - 99% = 11260 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2142, nodes: 1658333 
    Average node length: 5.52, total dup: 1590943, max dup: 99 
    Average key length: 2.56, compression ratio: 16.43 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 109237, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 436 
        40 - 59% = 1038 
        60 - 79% = 508 
        80 - 99% = 151 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.08, total records: 1145809 
    Average version length: 69.12, total versions: 513683, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.31 
    Pointer pages: 21, data page slots: 33736 
    Data pages: 28552, average fill: 47% 
    Primary pages: 28552, secondary pages: 0, swept pages: 7067 
    Empty pages: 6781, full pages: 13922 
    Fill distribution: 
     0 - 19% = 11043 
    20 - 39% = 2159 
    40 - 59% = 896 
    60 - 79% = 4621 
    80 - 99% = 9833 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1533, nodes: 1145809 
    Average node length: 5.77, total dup: 1071514, max dup: 99 
    Average key length: 2.83, compression ratio: 14.82 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 153803, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 318 
        40 - 59% = 719 
        60 - 79% = 354 
        80 - 99% = 140 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.66, total records: 9254181 
    Average version length: 69.01, total versions: 435322, 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: 88, data page slots: 142312 
    Data pages: 142304, average fill: 70% 
    Primary pages: 142304, secondary pages: 0, swept pages: 55804 
    Empty pages: 333, full pages: 82108 
    Fill distribution: 
     0 - 19% = 1115 
    20 - 39% = 4773 
    40 - 59% = 21033 
    60 - 79% = 107844 
    80 - 99% = 7539 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13489, nodes: 9254181 
    Average node length: 6.67, total dup: 7677181, max dup: 29 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2030279, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1216 
        40 - 59% = 6866 
        60 - 79% = 4764 
        80 - 99% = 642 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21150269 
    Average version length: 82.97, total versions: 13343, 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: 318784 
    Data pages: 318784, average fill: 81% 
    Primary pages: 318784, secondary pages: 0, swept pages: 12251 
    Empty pages: 30, full pages: 317967 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 38 
    40 - 59% = 102 
    60 - 79% = 27468 
    80 - 99% = 291126 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19378, nodes: 21150269 
    Average node length: 5.72, total dup: 20669328, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280970, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 8144 
        60 - 79% = 547 
        80 - 99% = 10685 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17165, nodes: 21150269 
    Average node length: 6.31, total dup: 18588013, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 912737, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 6 
        40 - 59% = 774 
        60 - 79% = 264 
        80 - 99% = 16117 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21138, nodes: 21150269 
    Average node length: 6.35, total dup: 18505741, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575021, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 3 
        40 - 59% = 8366 
        60 - 79% = 576 
        80 - 99% = 12184 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16072, nodes: 21150269 
    Average node length: 5.56, total dup: 21150169, max dup: 228563 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941748, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2827 
        60 - 79% = 391 
        80 - 99% = 12842 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.82, total records: 9700440 
    Average version length: 82.68, total versions: 423125, 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: 102, data page slots: 166256 
    Data pages: 166240, average fill: 72% 
    Primary pages: 166240, secondary pages: 0, swept pages: 69670 
    Empty pages: 340, full pages: 100701 
    Fill distribution: 
     0 - 19% = 972 
    20 - 39% = 4142 
    40 - 59% = 20776 
    60 - 79% = 77608 
    80 - 99% = 62742 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11336, nodes: 9700440 
    Average node length: 5.36, total dup: 9390511, max dup: 204 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2180228, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 69 
        40 - 59% = 8125 
        60 - 79% = 3043 
        80 - 99% = 96 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13471, nodes: 9700440 
    Average node length: 6.23, total dup: 8041618, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1527533, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 3736 
        40 - 59% = 4495 
        60 - 79% = 2739 
        80 - 99% = 2352 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12665, nodes: 9700440 
    Average node length: 5.97, total dup: 8415935, max dup: 34 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2370712, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 89 
        40 - 59% = 9150 
        60 - 79% = 3313 
        80 - 99% = 111 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10201, nodes: 9700440 
    Average node length: 5.13, total dup: 9700340, max dup: 150869 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1547861, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1256 
        40 - 59% = 5079 
        60 - 79% = 1817 
        80 - 99% = 2006 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.00, total records: 11277445 
    Average version length: 82.59, total versions: 315255, 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: 117, data page slots: 190392 
    Data pages: 189208, average fill: 73% 
    Primary pages: 189208, secondary pages: 0, swept pages: 71406 
    Empty pages: 2611, full pages: 141659 
    Fill distribution: 
     0 - 19% = 4556 
    20 - 39% = 7163 
    40 - 59% = 17020 
    60 - 79% = 44523 
    80 - 99% = 115946 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13114, nodes: 11277445 
    Average node length: 5.30, total dup: 11167706, max dup: 640 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2338277, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 128 
        40 - 59% = 9123 
        60 - 79% = 3752 
        80 - 99% = 111 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10399, nodes: 11277445 
    Average node length: 5.49, total dup: 10785062, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 692346, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 868 
        40 - 59% = 2567 
        60 - 79% = 1766 
        80 - 99% = 5047 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14993, nodes: 11277445 
    Average node length: 6.02, total dup: 9836989, max dup: 77 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2354800, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 157 
        40 - 59% = 10595 
        60 - 79% = 4093 
        80 - 99% = 147 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10703, nodes: 11277445 
    Average node length: 5.22, total dup: 11277345, max dup: 200864 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 682199, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 866 
        40 - 59% = 4637 
        60 - 79% = 1516 
        80 - 99% = 3589 
 
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.40, total records: 9786641 
    Average version length: 82.95, total versions: 395356, 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: 104, data page slots: 169440 
    Data pages: 169408, average fill: 72% 
    Primary pages: 169408, secondary pages: 0, swept pages: 78507 
    Empty pages: 447, full pages: 98608 
    Fill distribution: 
     0 - 19% = 1259 
    20 - 39% = 4506 
    40 - 59% = 21742 
    60 - 79% = 82827 
    80 - 99% = 59074 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11774, nodes: 9786641 
    Average node length: 5.17, total dup: 9757644, max dup: 1995 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1986729, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1490 
        40 - 59% = 7755 
        60 - 79% = 1844 
        80 - 99% = 656 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13559, nodes: 9786641 
    Average node length: 6.24, total dup: 8113541, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1499507, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 181 
        20 - 39% = 3722 
        40 - 59% = 4498 
        60 - 79% = 2667 
        80 - 99% = 2491 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12442, nodes: 9786641 
    Average node length: 5.43, total dup: 9348344, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2120855, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1414 
        40 - 59% = 8761 
        60 - 79% = 1658 
        80 - 99% = 576 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10298, nodes: 9786641 
    Average node length: 5.14, total dup: 9786541, max dup: 153148 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1579200, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1276 
        40 - 59% = 5141 
        60 - 79% = 1845 
        80 - 99% = 2008 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.64, total records: 576978 
    Average version length: 68.80, total versions: 4552, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 7960 
    Data pages: 7960, average fill: 76% 
    Primary pages: 7960, secondary pages: 0, swept pages: 3728 
    Empty pages: 7, full pages: 6958 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 7 
    40 - 59% = 148 
    60 - 79% = 7733 
    80 - 99% = 65 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 48334, depth: 3, leaf buckets: 740, nodes: 576978 
    Average node length: 5.95, total dup: 491126, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100779, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 528 
        60 - 79% = 96 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 40374, depth: 3, leaf buckets: 763, nodes: 576978 
    Average node length: 6.15, total dup: 473150, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100830, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 545 
        60 - 79% = 93 
        80 - 99% = 94 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 573, nodes: 576978 
    Average node length: 4.86, total dup: 576878, max dup: 9832 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89460, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 329 
        60 - 79% = 93 
        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 Feb 14 19:11:34 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7765961 85811 1 0.0000 0.0000
DOC_LIST 2255183 88624 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 251927 653 62900.0000 0.0000
INVNT_TURNOVER_LOG 85647 78146 1 0.0000 0.0000
MONEY_SALDO 49 18007 982 36700.0000 0.0000
MONEY_TURNOVER_LOG 1388 1209 1 0.0000 0.0000
PDISTR 797625 70041 4 0.0000 0.0000
PERF_SPLIT_0 172742 2326 1 0.0000 0.0000
PERF_SPLIT_1 177850 7227 1 0.0000 0.0000
PERF_SPLIT_2 170327 18241 1 0.0000 0.0000
PERF_SPLIT_3 176962 4453 1 0.0000 0.0000
PERF_SPLIT_4 153749 13672 1 0.0000 0.0000
PERF_SPLIT_5 185555 21334 1 0.0000 0.0000
PERF_SPLIT_6 169647 20526 1 0.0000 0.0000
PERF_SPLIT_7 188258 8698 1 0.0000 0.0000
PERF_SPLIT_8 171913 3454 1 0.0000 0.0000
PERF_SPLIT_9 174379 3133 1 0.0000 0.0000
PSTORNED 2107616 35485 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 156930 69354 1 0.0000 0.0000
XQD_1000_3300 7124038 480919 1 0.0000 0.0000
XQD_1200_2000 12139227 388813 1 0.0000 0.0000
XQD_2000_3300 1658333 719554 1 0.0000 0.0000
XQD_2100_3300 1145809 513683 1 0.0000 0.0000
XQD_3300_3400 9254181 435322 1 0.0000 0.0000
XQS_1000_1200 21150269 13343 1 0.0000 0.0000
XQS_1000_3300 9700440 423125 1 0.0000 0.0000
XQS_1200_2000 11277445 315255 1 0.0000 0.0000
XQS_2100_3300 9786641 395356 1 0.0000 0.0000
XQS_3300_3400 576978 4552 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 ---
:339: 
:340: mscs-test-161.budzdorov.ru    Wed Feb 14 19:09:46 2024
:341:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:342: 
:343: 
:344: mscs-test-161.budzdorov.ru    Wed Feb 14 19:09:46 2024
:345:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:346: 
:347: 
:348: mscs-test-161.budzdorov.ru    Wed Feb 14 19:09:46 2024
:349:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:350: 
:351: 
:352: mscs-test-161.budzdorov.ru    Wed Feb 14 19:09:46 2024
:353:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:354: 
:355: 
:356: mscs-test-161.budzdorov.ru    Wed Feb 14 19:09:46 2024
:357:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:358: 
:359: 
:360: mscs-test-161.budzdorov.ru    Wed Feb 14 19:09:49 2024
:361:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:362: 
--- end of diff output ---

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

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