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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-18 22:09:40
DTS_END                         2024-03-18 22:09:40.4160
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/60328
TRN_ID                          180199
ATT_ID                          587
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: 9505.50 19433 950550
customer order: creation 185.15 331 18515
customer order: refuse 15.08 327 1508
order to supplier: creation 49.01 1241 4901
order to supplier: removal 3.51 91151 351
invoice (draft): creation 48.92 3264 4892
invoice (draft): removal 51.91 754 5191
invoice accept: apply 44.21 20301 4421
invoice accept: cancel 46.42 834 4642
customer reserve: creation 4218.89 195 421889
customer reserve: removal 4522.64 54 452264
realization accept: apply 91.20 196 9120
realization accept: cancel 90.22 106 9022
payment from customer: creation 63.20 144 6320
payment from customer: removal 6.41 74 641
payment to supplier: creation 52.21 177 5221
payment to supplier: removal 3.80 72 380
service: total inventory turnovers 5.02 1088 502
service: total monetary turnovers 6.74 31 674
service: aggregate perf. data 0.93 18433 93
service: refresh index statistics 0.03 249879 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-03-2024 22:10:47 to 18-03-2024 22:10:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3701
TEST_TIME 2 3959
TEST_TIME 3 3499
TEST_TIME 4 3077
TEST_TIME 5 3285
TEST_TIME 6 3825
TEST_TIME 7 4370
TEST_TIME 8 4997
TEST_TIME 9 5347
TEST_TIME 10 6061
TEST_TIME 11 5961
TEST_TIME 12 5821
TEST_TIME 13 6176
TEST_TIME 14 6340
TEST_TIME 15 6552
TEST_TIME 16 6622
TEST_TIME 17 6765
TEST_TIME 18 6937
TEST_TIME 19 6973
TEST_TIME 20 7047
TEST_TIME 21 7476
TEST_TIME 22 7784
TEST_TIME 23 8182
TEST_TIME 24 8114
TEST_TIME 25 8171
TEST_TIME 26 8478
TEST_TIME 27 9154
TEST_TIME 28 9422
TEST_TIME 29 9285
TEST_TIME 30 9655
TEST_TIME 31 9512
TEST_TIME 32 9496
TEST_TIME 33 9618
TEST_TIME 34 9574
TEST_TIME 35 9403
TEST_TIME 36 9185
TEST_TIME 37 9076
TEST_TIME 38 9206
TEST_TIME 39 9153
TEST_TIME 40 9195
TEST_TIME 41 9269
TEST_TIME 42 9279
TEST_TIME 43 9170
TEST_TIME 44 9198
TEST_TIME 45 9132
TEST_TIME 46 9048
TEST_TIME 47 9033
TEST_TIME 48 9011
TEST_TIME 49 9000
TEST_TIME 50 9007
TEST_TIME 51 9108
TEST_TIME 52 9126
TEST_TIME 53 9160
TEST_TIME 54 9121
TEST_TIME 55 9219
TEST_TIME 56 9232
TEST_TIME 57 9202
TEST_TIME 58 9331
TEST_TIME 59 9391
TEST_TIME 60 9395
TEST_TIME 61 9486
TEST_TIME 62 9634
TEST_TIME 63 9528
TEST_TIME 64 9466
TEST_TIME 65 9411
TEST_TIME 66 9406
TEST_TIME 67 9400
TEST_TIME 68 9329
TEST_TIME 69 9321
TEST_TIME 70 9312
TEST_TIME 71 9331
TEST_TIME 72 9313
TEST_TIME 73 9255
TEST_TIME 74 9424
TEST_TIME 75 9392
TEST_TIME 76 9460
TEST_TIME 77 9443
TEST_TIME 78 9462
TEST_TIME 79 9487
TEST_TIME 80 9625
TEST_TIME 81 9615
TEST_TIME 82 9591
TEST_TIME 83 9714
TEST_TIME 84 9698
TEST_TIME 85 9766
TEST_TIME 86 9678
TEST_TIME 87 9628
TEST_TIME 88 9570
TEST_TIME 89 9573
TEST_TIME 90 9532
TEST_TIME 91 9523
TEST_TIME 92 9489
TEST_TIME 93 9485
TEST_TIME 94 9507
TEST_TIME 95 9508
TEST_TIME 96 9503
TEST_TIME 97 9476
TEST_TIME 98 9556
TEST_TIME 99 9568
TEST_TIME 100 9512

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-03-2024 22:10:50 to 18-03-2024 22:10:53.

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 1335791 1335791 0 0.00 0 18606 8 0 0
doc_list_biud 1335791 1335791 0 0.00 0 34427 24 0 0
sp_add_invoice_to_stock 4508 4421 87 1.92 33 186848 20301 0 87
sp_cancel_adding_invoice 4642 4642 0 0.00 4 79603 834 0 0
sp_cancel_client_order 1508 1508 0 0.00 4 7770 328 0 0
sp_cancel_customer_reserve 452264 452264 0 0.00 0 33803 55 0 0
sp_cancel_pay_from_customer 641 641 0 0.00 2 2047 74 0 0
sp_cancel_pay_to_supplier 380 380 0 0.00 3 5297 73 0 0
sp_cancel_supplier_invoice 5200 5191 9 0.17 1 15808 755 0 9
sp_cancel_supplier_order 351 351 0 0.00 8 1138295 91152 0 0
sp_cancel_write_off 9022 9022 0 0.00 1 8024 107 0 0
sp_client_order 18515 18515 0 0.00 3 29058 332 0 0
sp_customer_reserve 421889 421889 0 0.00 0 81888 196 0 0
sp_fill_shopping_cart 28307 28307 0 0.00 1 11463 34 0 0
sp_fill_shopping_cart_clo_res 421880 421880 0 0.00 0 14660 15 0 0
sp_get_clo_for_invoice 4412 4412 0 0.00 0 24062 278 0 0
sp_kill_cost_storno 14685 14685 0 0.00 0 12145 59 0 0
sp_kill_qstorno_ret_qs2qd 919092 919092 0 0.00 0 33794 30 0 0
sp_kill_qty_storno 486508 486508 0 0.00 0 34426 65 0 0
sp_lock_selected_doc 18678 18678 0 0.00 0 8619 6 0 0
sp_make_cost_storno 25071 25071 0 0.00 0 18602 71 0 0
sp_multiply_rows_for_pdistr 25071 25071 0 0.00 0 10896 38 0 0
sp_multiply_rows_for_qdistr 18515 18515 0 0.00 0 11523 139 0 0
sp_pay_from_customer 6320 6320 0 0.00 4 26829 145 0 0
sp_pay_to_supplier 5221 5221 0 0.00 4 15798 177 0 0
sp_payment_common 11541 11541 0 0.00 1 26371 42 0 0
sp_qd_handle_on_cancel_clo 1508 1508 0 0.00 0 7761 306 0 0
sp_qd_handle_on_invoice_upd_sts 9052 9052 0 0.00 0 34424 330 0 0
sp_qd_handle_on_reserve_upd_sts 9120 9120 0 0.00 0 21462 59 0 0
sp_reserve_write_off 9120 9120 0 0.00 6 21471 197 0 0
sp_supplier_invoice 4892 4892 0 0.00 7 109215 3265 0 0
sp_supplier_order 4901 4901 0 0.00 5 22333 1241 0 0
srv_aggregate_perf_data 94 93 1 1.06 1475 515545 18433 0 1
srv_fill_mon_cache_memory 56 56 0 0.00 1652 114303 39460 0 0
srv_find_qd_qs_mism 904869 904869 0 0.00 0 9696 7 0 0
srv_make_invnt_saldo 502 502 0 0.00 42 47251 1089 0 0
srv_make_money_saldo 674 674 0 0.00 1 3412 31 0 0
srv_recalc_idx_stat 3 3 0 0.00 183040 314361 249880 0 0
t$perf-abend:sp_add_invoice_to_stock 87 87 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 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 4422 4422 0 0.00 0 15048 164 0 0
t$perf-norm:sp_cancel_adding_invoice 367 367 0 0.00 0 3085 108 0 0
t$perf-norm:sp_cancel_client_order 1508 1508 0 0.00 0 1449 13 0 0
t$perf-norm:sp_cancel_customer_reserve 644 644 0 0.00 0 6344 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 641 641 0 0.00 0 790 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 380 380 0 0.00 0 1976 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 358 358 0 0.00 0 13211 47 0 0
t$perf-norm:sp_cancel_supplier_order 351 351 0 0.00 0 23361 1571 0 0
t$perf-norm:sp_cancel_write_off 899 899 0 0.00 0 11245 16 0 0
t$perf-norm:sp_client_order 18516 18516 0 0.00 0 7486 17 0 0
t$perf-norm:sp_customer_reserve 874 874 0 0.00 0 1766 9 0 0
t$perf-norm:sp_pay_from_customer 6320 6320 0 0.00 0 10662 9 0 0
t$perf-norm:sp_pay_to_supplier 5221 5221 0 0.00 0 3625 7 0 0
t$perf-norm:sp_reserve_write_off 9120 9120 0 0.00 0 4231 11 0 0
t$perf-norm:sp_supplier_invoice 4892 4892 0 0.00 0 8564 18 0 0
t$perf-norm:sp_supplier_order 4901 4901 0 0.00 0 8066 14 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 1126 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 167 4 0 0
t$perf-norm:srv_make_invnt_saldo 502 502 0 0.00 0 1130 21 0 0
t$perf-norm:srv_make_money_saldo 674 674 0 0.00 0 3805 24 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 8992 8818 174 1.93 0 4208 18 0 174
v_all_customers 34044 34044 0 0.00 0 22 1 0 0
v_all_suppliers 27698 27698 0 0.00 0 18 1 0 0
v_all_wares 37030 37030 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 734 734 0 0.00 0 4271 18 0 0
v_cancel_client_order 3016 3016 0 0.00 0 1554 4 0 0
v_cancel_customer_prepayment 1282 1282 0 0.00 0 1703 8 0 0
v_cancel_customer_reserve 1288 1288 0 0.00 0 2282 10 0 0
v_cancel_payment_to_supplier 760 760 0 0.00 0 1389 5 0 0
v_cancel_supplier_invoice 734 716 18 2.45 0 3101 31 0 18
v_cancel_supplier_order 702 702 0 0.00 0 2837 15 0 0
v_cancel_write_off 1798 1798 0 0.00 0 1919 13 0 0
v_max_id_clo_ord 4901 4901 0 0.00 0 375 2 0 0
v_max_id_clo_res 874 874 0 0.00 0 2548 19 0 0
v_max_id_ord_sup 4891 4891 0 0.00 0 4997 4 0 0
v_max_non_paid_invoice 1164 1164 0 0.00 0 3273 5 0 0
v_max_non_paid_realizn 3293 3293 0 0.00 0 26358 15 0 0
v_min_id_clo_ord 4901 4901 0 0.00 0 4269 9 0 0
v_min_id_clo_res 874 874 0 0.00 0 2697 13 0 0
v_min_id_ord_sup 4891 4891 0 0.00 0 4198 5 0 0
v_min_non_paid_invoice 5221 5221 0 0.00 0 9628 30 0 0
v_min_non_paid_realizn 6320 6320 0 0.00 0 13208 32 0 0
v_our_firm 9040 9040 0 0.00 0 21 1 0 0
v_reserve_write_off 18240 18240 0 0.00 0 4532 7 0 0
x_lock_depdocs_on_canc_invoice 9475 9475 0 0.00 0 13876 127 0 0
x_lock_depdocs_on_canc_sup_ord 351 351 0 0.00 0 9287 357 0 0
x_make_qstorno_1000_1200 4901 4901 0 0.00 1 22262 1155 0 0
x_make_qstorno_1200_2000 4892 4892 0 0.00 3 109194 3149 0 0
x_make_qstorno_2100_3300 421889 421889 0 0.00 0 81795 178 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 18-03-2024 22:10:54 to 18-03-2024 22:10:59.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
20:09:44 3 8192000000 8800086032 8811675648 6480208 0.079 2 1 2 0 6579840 56848 42784
20:10:44 35898 8192000000 9903721216 10213285888 979789504 10.682 100 89 178 0 1008573008 5792608 22990896
20:12:24 12462 8192000000 9930220432 10250600448 1020974272 11.081 100 88 176 0 1051709168 8225168 22509728
20:13:41 17541 8192000000 9970185168 10302787584 1055852496 11.417 100 79 158 0 1084887424 9216480 19818448
20:15:01 11924 8192000000 10023911280 10369081344 1109494448 11.928 100 82 164 0 1139826096 10663360 19668288
20:16:16 8035 8192000000 10060825584 10412265472 1146404704 12.276 100 80 160 0 1177962432 13200208 18357520
20:17:29 5032 8192000000 10094206608 10459746304 1185642864 12.643 100 67 134 0 1213082320 12128400 15311056
20:18:36 3476 8192000000 10134681968 10508652544 1229141664 13.046 100 70 136 0 1255155936 11431232 14583040
20:19:41 1754 8192000000 10172731376 10553626624 1262247568 13.351 100 79 157 1 1292775584 12795472 17732544
20:20:45 846 8192000000 10198440464 10582429696 1283740256 13.547 100 87 174 0 1316040048 13326608 18973184
20:21:47 15157 8192000000 10200267200 10592391168 1295464032 13.654 100 64 129 3 1320107488 9922240 14721216
20:23:03 8884 8192000000 10200052464 10605465600 1307249648 13.761 100 30 60 0 1321151536 7609744 6292144
20:24:13 8079 8192000000 10200139600 10615377920 1315552048 13.836 100 23 44 0 1326512784 5867888 5092848
20:25:22 7040 8192000000 10210450736 10626494464 1324335552 13.916 100 20 40 1 1334285536 5955136 3994848
20:26:34 47854 8192000000 10226784096 10642255872 1329793696 13.965 100 46 93 0 1346728336 6240912 10693728
20:28:22 2446 8192000000 10233289760 10644328448 1329944000 13.967 100 43 87 1 1347584208 6527408 11112800
20:29:25 5550 8192000000 10222152240 10644586496 1333950928 14.003 100 32 61 0 1347124144 5557824 7615392
20:30:39 35951 8192000000 10253404528 10663895040 1332327264 13.988 99 44 88 0 1351117456 9228752 9561440
20:32:29 114302 8192000000 10275050992 10697072640 1360206080 14.239 100 44 87 1 1381697136 10751632 10739424
20:35:44 30724 8192000000 10254308304 10670936064 1304419664 13.735 96 30 60 1 1328890976 17363984 7107328
20:37:18 1651 8192000000 10219657968 10618630144 1297301984 13.671 99 57 110 0 1328755472 18711488 12742000
20:38:26 15497 8192000000 10232310640 10638159872 1315289200 13.834 100 51 100 0 1346203728 19255872 11658656
20:39:56 4069 8192000000 10192907072 10585460736 1260350272 13.333 98 66 130 1 1293946976 19010336 14586368
20:41:09 3296 8192000000 10214272096 10604867584 1279574544 13.509 99 57 110 1 1314651472 22173920 12903008
20:42:17 4852 8192000000 10233087024 10627309568 1307976912 13.768 100 59 116 1 1340985200 19475920 13532368
20:43:30 4769 8192000000 10249633632 10647842816 1317797008 13.857 99 63 125 1 1357053776 24206912 15049856
20:44:37 4400 8192000000 10278058000 10672066560 1327434176 13.944 99 78 154 1 1371931088 26353120 18143792
20:45:48 3455 8192000000 10293687088 10692284416 1348470560 14.134 100 75 148 0 1398083552 31947984 17665008
20:47:03 4262 8192000000 10313624016 10709852160 1363558128 14.269 100 71 143 1 1413479392 32465936 17455328
20:48:17 1818 8192000000 10333366448 10737893376 1378935600 14.407 100 77 151 0 1439440384 42016064 18488720
20:49:26 6400 8192000000 10350081632 10755973120 1386630416 14.476 100 77 153 0 1454587280 48698912 19257952
20:50:36 14996 8192000000 10336449136 10767101952 1390308528 14.509 100 48 96 2 1453859152 50752080 12798544
20:52:04 10598 8192000000 10321307760 10752770048 1383454480 14.447 100 35 70 0 1436558976 43721856 9382640
20:53:19 19598 8192000000 10315540960 10746970112 1368870656 14.317 99 33 66 0 1415489888 38323984 8295248
20:55:15 35024 8192000000 10322316144 10756718592 1366500160 14.296 100 32 61 0 1418673712 44246896 7926656
20:56:52 15401 8192000000 10307303632 10759196672 1381891808 14.433 100 19 38 0 1412550784 25772448 4886528
20:58:16 39537 8192000000 10291981648 10729697280 1377479312 14.394 100 28 55 1 1396372160 12801280 6091568
20:59:58 30050 8192000000 10294825264 10718961664 1367106528 14.301 99 45 91 4 1385240816 8833840 9300448
21:01:34 45280 8192000000 10295941648 10748780544 1381907216 14.434 100 16 32 0 1400348016 14575472 3865328
21:03:22 35882 8192000000 10314769984 10753777664 1396346976 14.562 100 32 64 1 1413620720 9957968 7315776
21:05:07 109863 8192000000 10309734048 10765090816 1388621888 14.494 99 41 80 0 1416046160 17318480 10105792
21:08:04 26431 8192000000 10298111920 10748542976 1386181488 14.472 99 29 56 1 1400489568 7401552 6906528
21:09:33 36565 8192000000 10332116464 10783105024 1414763184 14.726 100 45 90 1 1438939408 12730768 11445456
21:11:19 19129 8192000000 10321250304 10788032512 1413459472 14.715 100 6 12 0 1430377232 15729536 1188224
21:12:39 14977 8192000000 10310023200 10765836288 1400706976 14.601 99 18 36 1 1413393904 8162336 4524592
21:14:55 30446 8192000000 10311362272 10776592384 1392215760 14.526 98 14 28 0 1410118240 14735648 3166832
21:16:36 70878 8192000000 10276531056 10738311168 1359465520 14.233 97 18 36 1 1371802720 8181312 4155888
21:18:50 43239 8192000000 10295288528 10752192512 1370215712 14.329 99 8 14 0 1380828144 9128544 1483888
21:20:35 31780 8192000000 10276617824 10720235520 1318209072 13.860 95 21 43 0 1334103904 10586976 5307856
21:22:50 26666 8192000000 10245544064 10679955456 1299441296 13.690 97 36 72 1 1315821744 8812608 7567840
21:24:26 35424 8192000000 10240877392 10683584512 1318978032 13.867 99 13 26 1 1331076640 9153248 2945360
21:26:07 29643 8192000000 10261803040 10691031040 1321581056 13.891 99 51 101 0 1348826416 16393360 10852000
21:27:42 64885 8192000000 10262089232 10699390976 1284297712 13.552 95 15 31 0 1302359792 14712064 3350016
21:29:47 84796 8192000000 10261275728 10718130176 1320587648 13.882 98 9 18 0 1352245024 29294896 2362480
21:32:21 57001 8192000000 10258855392 10697052160 1333709072 14.001 99 40 78 0 1349602368 7022144 8871152
21:34:21 37825 8192000000 10271419936 10705584128 1335011840 14.012 99 49 98 0 1359974160 14087536 10874784
21:36:13 49018 8192000000 10265407872 10720903168 1366493744 14.296 100 29 58 0 1385273120 12625312 6154064
21:38:03 70984 8192000000 10257435168 10720194560 1347367648 14.124 99 13 26 0 1362627952 11731584 3528720
21:40:17 70299 8192000000 10266578784 10727690240 1364522800 14.278 100 7 14 0 1376174080 10384176 1267104
21:42:29 85086 8192000000 10285457760 10755031040 1351066656 14.157 98 10 19 0 1373349360 20429584 1853120
21:44:55 66128 8192000000 10289610128 10742169600 1377754416 14.396 100 22 44 0 1391445072 8578240 5112416
21:47:09 47422 8192000000 10313737616 10774396928 1390485376 14.510 100 19 38 0 1407497584 13072320 3939888
21:48:57 91007 8192000000 10291320048 10753077248 1354953248 14.192 97 16 32 0 1380941264 22336544 3651472
21:51:35 54809 8192000000 10302310512 10765869056 1392568144 14.529 100 27 54 0 1411553792 12373536 6612112
21:53:30 39184 8192000000 10323306528 10767220736 1388252240 14.490 99 31 62 0 1410721648 15698496 6770912
21:55:10 94389 8192000000 10289562624 10747879424 1367934080 14.309 98 16 32 1 1379527056 8214240 3378736
21:57:46 65289 8192000000 10270422016 10733998080 1342171104 14.077 97 30 60 0 1361956496 13061920 6723472
21:59:52 26799 8192000000 10271625104 10733060096 1361582848 14.252 99 5 10 0 1376508688 13752704 1173136
22:01:44 56189 8192000000 10285132336 10744684544 1370276784 14.330 99 6 12 0 1382045696 10400752 1368160
22:03:40 52945 8192000000 10283524400 10756198400 1381082800 14.426 100 13 26 0 1397833712 13360208 3390704
22:05:36 23695 8192000000 10269340432 10714169344 1319737808 13.874 96 47 91 3 1340750816 10235312 10777696
22:07:00 45104 8192000000 10260309152 10712088576 1311629440 13.801 96 18 36 1 1329700224 13542736 4528048
22:08:49 69965 8192000000 9091928032 9325912064 242806080 2.878 19 3 6 0 250382208 7020144 555984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 87 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:03, from 18-03-2024 22:11:15 to 18-03-2024 22:11:18.

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          180712
MON$OLDEST_ACTIVE               180713
MON$OLDEST_SNAPSHOT             180713
MON$NEXT_TRANSACTION            180713
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                       1901216
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.33736 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33736 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33736 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33736 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Mon Mar 18 22:11:19 2024 
 
Database header page information: 
    Flags            0 
    Generation        94488 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    180712 
    Oldest active        180713 
    Oldest snapshot        180713 
    Next transaction    180714 
    Sequence number        0 
    Next attachment ID    728 
    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.15, total records: 7801618 
    Average version length: 48.16, total versions: 120483, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86888 
    Data pages: 86888, average fill: 72% 
    Primary pages: 86888, secondary pages: 0, swept pages: 14750 
    Empty pages: 8, full pages: 69937 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 146 
    40 - 59% = 2029 
    60 - 79% = 84645 
    80 - 99% = 48 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23503, nodes: 7801618 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1726677, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 364 
        20 - 39% = 1635 
        40 - 59% = 4419 
        60 - 79% = 2518 
        80 - 99% = 14567 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13646, nodes: 7801618 
    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: 1549025, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1497 
        40 - 59% = 2246 
        60 - 79% = 1128 
        80 - 99% = 8774 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8420, nodes: 7801618 
    Average node length: 6.62, total dup: 5827320, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1541824, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 880 
        40 - 59% = 1526 
        60 - 79% = 945 
        80 - 99% = 4933 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.85, total records: 2265052 
    Average version length: 34.50, total versions: 125275, max versions: 3 
    Average fragment length: 8.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28400 
    Data pages: 28400, average fill: 74% 
    Primary pages: 28395, secondary pages: 5, swept pages: 8201 
    Empty pages: 9, full pages: 22451 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 120 
    40 - 59% = 1376 
    60 - 79% = 25724 
    80 - 99% = 1164 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4612, nodes: 2265052 
    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: 695103, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 873 
        40 - 59% = 935 
        60 - 79% = 777 
        80 - 99% = 2026 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2528, nodes: 2267817 
    Average node length: 4.97, total dup: 2266918, max dup: 18678 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1254266, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 251 
        40 - 59% = 1510 
        60 - 79% = 571 
        80 - 99% = 192 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2066, nodes: 2265052 
    Average node length: 4.97, total dup: 2265002, max dup: 130457 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062640, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 38 
        40 - 59% = 1174 
        60 - 79% = 46 
        80 - 99% = 802 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4402, nodes: 2265052 
    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: 695103, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 511 
        40 - 59% = 715 
        60 - 79% = 856 
        80 - 99% = 2197 
 
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.24, total records: 400 
    Average version length: 23.20, total versions: 238272, max versions: 618 
    Average fragment length: 2.03, total fragments: 58, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1480 
    Data pages: 1480, average fill: 81% 
    Primary pages: 146, secondary pages: 1334, swept pages: 0 
    Empty pages: 139, full pages: 1321 
    Fill distribution: 
     0 - 19% = 158 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1321 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 9.63, total records: 87641 
    Average version length: 68.27, total versions: 75283, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 9.14 
    Pointer pages: 6, data page slots: 2056 
    Data pages: 1464, average fill: 74% 
    Primary pages: 1463, secondary pages: 1, swept pages: 0 
    Empty pages: 107, full pages: 1095 
    Fill distribution: 
     0 - 19% = 147 
    20 - 39% = 75 
    40 - 59% = 68 
    60 - 79% = 228 
    80 - 99% = 946 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1699122, depth: 3, leaf buckets: 288, nodes: 87641 
    Average node length: 13.15, total dup: 4882, max dup: 2 
    Average key length: 10.80, compression ratio: 2.50 
    Average prefix length: 19.14, average data length: 7.86 
    Clustering factor: 65199, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 90 
        40 - 59% = 124 
        60 - 79% = 69 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18360, max versions: 944 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 63 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 6.03, total records: 1592 
    Average version length: 43.15, total versions: 1372, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 9.62 
    Pointer pages: 1, data page slots: 48 
    Data pages: 29, average fill: 51% 
    Primary pages: 27, secondary pages: 2, swept pages: 3 
    Empty pages: 9, full pages: 13 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89409, depth: 2, leaf buckets: 2, nodes: 1592 
    Average node length: 4.40, total dup: 1494, max dup: 182 
    Average key length: 2.65, compression ratio: 7.16 
    Average prefix length: 18.41, average data length: 0.59 
    Clustering factor: 833, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.11, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.92, total records: 833528 
    Average version length: 25.55, total versions: 77179, 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: 8096 
    Data pages: 8096, average fill: 72% 
    Primary pages: 8079, secondary pages: 17, swept pages: 1083 
    Empty pages: 6, full pages: 7771 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 12 
    40 - 59% = 19 
    60 - 79% = 7728 
    80 - 99% = 321 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 911, nodes: 833528 
    Average node length: 4.87, total dup: 833479, max dup: 150852 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92457, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 122 
        40 - 59% = 515 
        60 - 79% = 205 
        80 - 99% = 69 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 989, nodes: 833528 
    Average node length: 5.88, total dup: 741908, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166461, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 81 
        40 - 59% = 522 
        60 - 79% = 109 
        80 - 99% = 276 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1036, nodes: 833528 
    Average node length: 5.89, total dup: 741908, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 168423, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 184 
        40 - 59% = 482 
        60 - 79% = 99 
        80 - 99% = 271 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1156, nodes: 833528 
    Average node length: 5.97, total dup: 741908, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 161012, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 229 
        40 - 59% = 604 
        60 - 79% = 217 
        80 - 99% = 105 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.75, total records: 5458 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.75, total fragments: 91, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 72, secondary pages: 24, swept pages: 49 
    Empty pages: 12, full pages: 65 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5458 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.03 
    Average prefix length: 34.43, average data length: 1.55 
    Clustering factor: 5127, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5458 
    Average node length: 11.12, 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: 142, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.08, total records: 83024 
    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: 800 
    Data pages: 800, average fill: 71% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 799 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 799 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34446, depth: 2, leaf buckets: 106, nodes: 83024 
    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: 3239, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 103 
 
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.11, 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: 144.00, total records: 183683 
    Average version length: 151.62, total versions: 8913, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 8, data page slots: 4712 
    Data pages: 4400, average fill: 86% 
    Primary pages: 4399, secondary pages: 1, swept pages: 1 
    Empty pages: 35, full pages: 4354 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4353 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 141.34, total records: 174380 
    Average version length: 152.24, total versions: 11043, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 6, data page slots: 5864 
    Data pages: 4208, average fill: 86% 
    Primary pages: 4208, secondary pages: 0, swept pages: 7 
    Empty pages: 68, full pages: 4124 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4123 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 137.75, total records: 169526 
    Average version length: 152.20, total versions: 14617, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.31 
    Pointer pages: 5, data page slots: 5024 
    Data pages: 4072, average fill: 86% 
    Primary pages: 4072, secondary pages: 0, swept pages: 1 
    Empty pages: 51, full pages: 4009 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 4009 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 135.39, total records: 158008 
    Average version length: 152.37, total versions: 16071, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.53 
    Pointer pages: 5, data page slots: 4760 
    Data pages: 3824, average fill: 86% 
    Primary pages: 3824, secondary pages: 0, swept pages: 3 
    Empty pages: 75, full pages: 3730 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 3731 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 144.08, total records: 148498 
    Average version length: 148.93, total versions: 6614, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 7, data page slots: 4960 
    Data pages: 3576, average fill: 86% 
    Primary pages: 3576, secondary pages: 0, swept pages: 2 
    Empty pages: 55, full pages: 3505 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3505 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 139.06, total records: 168400 
    Average version length: 151.55, total versions: 12961, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.20 
    Pointer pages: 7, data page slots: 4304 
    Data pages: 4024, average fill: 87% 
    Primary pages: 4023, secondary pages: 1, swept pages: 1 
    Empty pages: 35, full pages: 3977 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3978 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 122.01, total records: 193784 
    Average version length: 154.15, total versions: 36912, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.90 
    Pointer pages: 7, data page slots: 5680 
    Data pages: 4632, average fill: 88% 
    Primary pages: 4632, secondary pages: 0, swept pages: 6 
    Empty pages: 25, full pages: 4595 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 4595 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 139.69, total records: 190211 
    Average version length: 152.26, total versions: 14305, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.14 
    Pointer pages: 6, data page slots: 5416 
    Data pages: 4560, average fill: 87% 
    Primary pages: 4560, secondary pages: 0, swept pages: 2 
    Empty pages: 43, full pages: 4504 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4504 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 107.88, total records: 243388 
    Average version length: 154.70, total versions: 69606, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.72 
    Pointer pages: 7, data page slots: 6200 
    Data pages: 5832, average fill: 89% 
    Primary pages: 5832, secondary pages: 0, swept pages: 2 
    Empty pages: 23, full pages: 5800 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 5801 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 141.26, total records: 170814 
    Average version length: 149.88, total versions: 10932, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.01 
    Pointer pages: 6, data page slots: 4256 
    Data pages: 4080, average fill: 87% 
    Primary pages: 4080, secondary pages: 0, swept pages: 4 
    Empty pages: 35, full pages: 4039 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4039 
 
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.34, total records: 2104428 
    Average version length: 52.94, total versions: 56283, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25448 
    Data pages: 25448, average fill: 71% 
    Primary pages: 25448, secondary pages: 0, swept pages: 9981 
    Empty pages: 256, full pages: 21223 
    Fill distribution: 
     0 - 19% = 511 
    20 - 39% = 424 
    40 - 59% = 1042 
    60 - 79% = 22939 
    80 - 99% = 532 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2576, nodes: 2104428 
    Average node length: 5.44, total dup: 1963858, max dup: 2083 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183381, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 296 
        40 - 59% = 1641 
        60 - 79% = 337 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2758, nodes: 2104428 
    Average node length: 5.69, total dup: 1888957, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377097, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2367 
        60 - 79% = 355 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2153, nodes: 2104428 
    Average node length: 4.96, total dup: 2104328, max dup: 26774 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180813, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 201 
        40 - 59% = 1148 
        60 - 79% = 392 
        80 - 99% = 412 
 
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: 36.03, total records: 157329 
    Average version length: 69.18, total versions: 75444, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.50 
    Pointer pages: 3, data page slots: 4096 
    Data pages: 3048, average fill: 60% 
    Primary pages: 3048, secondary pages: 0, swept pages: 345 
    Empty pages: 492, full pages: 2058 
    Fill distribution: 
     0 - 19% = 694 
    20 - 39% = 151 
    40 - 59% = 107 
    60 - 79% = 695 
    80 - 99% = 1401 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 367376, depth: 3, leaf buckets: 248, nodes: 157329 
    Average node length: 6.42, total dup: 137064, max dup: 14 
    Average key length: 3.91, compression ratio: 10.73 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 27334, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 42 
        40 - 59% = 145 
        60 - 79% = 48 
        80 - 99% = 9 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.00, total records: 7246789 
    Average version length: 68.78, total versions: 521611, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 63, data page slots: 102216 
    Data pages: 102216, average fill: 76% 
    Primary pages: 102216, secondary pages: 0, swept pages: 17959 
    Empty pages: 13, full pages: 90326 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 589 
    40 - 59% = 3631 
    60 - 79% = 87489 
    80 - 99% = 10432 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10670, nodes: 7246789 
    Average node length: 6.51, total dup: 6265175, max dup: 41 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1592882, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1244 
        40 - 59% = 5920 
        60 - 79% = 2849 
        80 - 99% = 643 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8651, nodes: 7246789 
    Average node length: 5.40, total dup: 6958118, max dup: 145 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1388539, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1000 
        40 - 59% = 4971 
        60 - 79% = 1594 
        80 - 99% = 1076 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8736, nodes: 7246789 
    Average node length: 5.40, total dup: 6958118, max dup: 145 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1391139, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1065 
        40 - 59% = 5000 
        60 - 79% = 1632 
        80 - 99% = 1034 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.51, total records: 12212423 
    Average version length: 68.72, total versions: 432409, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 103, data page slots: 167664 
    Data pages: 167664, average fill: 77% 
    Primary pages: 167664, secondary pages: 0, swept pages: 66021 
    Empty pages: 6, full pages: 165440 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 95 
    40 - 59% = 624 
    60 - 79% = 156463 
    80 - 99% = 10470 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18321, nodes: 12212423 
    Average node length: 6.59, total dup: 10642675, max dup: 67 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2388732, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1878 
        40 - 59% = 10849 
        60 - 79% = 4672 
        80 - 99% = 886 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 38.41, total records: 1887732 
    Average version length: 69.14, total versions: 839418, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.28 
    Pointer pages: 28, data page slots: 44624 
    Data pages: 28548, average fill: 76% 
    Primary pages: 28547, secondary pages: 1, swept pages: 3166 
    Empty pages: 1300, full pages: 24538 
    Fill distribution: 
     0 - 19% = 1979 
    20 - 39% = 828 
    40 - 59% = 584 
    60 - 79% = 10703 
    80 - 99% = 14454 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2284, nodes: 1887732 
    Average node length: 5.50, total dup: 1812191, max dup: 99 
    Average key length: 2.54, compression ratio: 16.53 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 128820, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 285 
        40 - 59% = 1069 
        60 - 79% = 678 
        80 - 99% = 235 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 36.98, total records: 1096320 
    Average version length: 69.13, total versions: 509067, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.41 
    Pointer pages: 21, data page slots: 33176 
    Data pages: 26496, average fill: 48% 
    Primary pages: 26496, secondary pages: 0, swept pages: 5555 
    Empty pages: 5578, full pages: 11598 
    Fill distribution: 
     0 - 19% = 8707 
    20 - 39% = 2131 
    40 - 59% = 1940 
    60 - 79% = 6361 
    80 - 99% = 7357 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1505, nodes: 1096320 
    Average node length: 5.78, total dup: 1024227, max dup: 116 
    Average key length: 2.85, compression ratio: 14.75 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 146304, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 377 
        40 - 59% = 635 
        60 - 79% = 394 
        80 - 99% = 95 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.02, total records: 9299324 
    Average version length: 68.97, total versions: 523040, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 88, data page slots: 143024 
    Data pages: 143000, average fill: 70% 
    Primary pages: 143000, secondary pages: 0, swept pages: 43664 
    Empty pages: 183, full pages: 87735 
    Fill distribution: 
     0 - 19% = 891 
    20 - 39% = 6184 
    40 - 59% = 21826 
    60 - 79% = 104915 
    80 - 99% = 9184 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13485, nodes: 9299324 
    Average node length: 6.67, total dup: 7717509, max dup: 29 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 1999380, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1208 
        40 - 59% = 6762 
        60 - 79% = 4776 
        80 - 99% = 739 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21195513 
    Average version length: 83.01, total versions: 14268, 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: 319264 
    Data pages: 319264, average fill: 81% 
    Primary pages: 319264, secondary pages: 0, swept pages: 11448 
    Empty pages: 5, full pages: 319258 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 26760 
    80 - 99% = 292498 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19403, nodes: 21195513 
    Average node length: 5.72, total dup: 20713445, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288818, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8101 
        60 - 79% = 569 
        80 - 99% = 10728 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17234, nodes: 21195513 
    Average node length: 6.31, total dup: 18627453, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916631, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 841 
        60 - 79% = 264 
        80 - 99% = 16123 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21171, nodes: 21195513 
    Average node length: 6.35, total dup: 18545470, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3583555, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8342 
        60 - 79% = 635 
        80 - 99% = 12190 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16254, nodes: 21195513 
    Average node length: 5.56, total dup: 21195413, max dup: 229531 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945449, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 3119 
        60 - 79% = 429 
        80 - 99% = 12701 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.95, total records: 9759668 
    Average version length: 82.63, total versions: 528309, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 105, data page slots: 169976 
    Data pages: 169936, average fill: 71% 
    Primary pages: 169936, secondary pages: 0, swept pages: 61324 
    Empty pages: 568, full pages: 106389 
    Fill distribution: 
     0 - 19% = 1691 
    20 - 39% = 7338 
    40 - 59% = 24952 
    60 - 79% = 66204 
    80 - 99% = 69751 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11355, nodes: 9759668 
    Average node length: 5.36, total dup: 9450055, max dup: 198 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2131788, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 72 
        40 - 59% = 7939 
        60 - 79% = 3242 
        80 - 99% = 98 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13687, nodes: 9759668 
    Average node length: 6.23, total dup: 8093807, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1473056, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 154 
        20 - 39% = 3830 
        40 - 59% = 4779 
        60 - 79% = 2552 
        80 - 99% = 2372 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12690, nodes: 9759668 
    Average node length: 5.98, total dup: 8473673, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2330456, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 101 
        40 - 59% = 8930 
        60 - 79% = 3560 
        80 - 99% = 99 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10272, nodes: 9759668 
    Average node length: 5.13, total dup: 9759568, max dup: 149154 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1511745, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 56 
        20 - 39% = 1233 
        40 - 59% = 5286 
        60 - 79% = 1701 
        80 - 99% = 1996 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.98, total records: 11438334 
    Average version length: 82.57, total versions: 460509, 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: 118, data page slots: 191520 
    Data pages: 190128, average fill: 74% 
    Primary pages: 190128, secondary pages: 0, swept pages: 62891 
    Empty pages: 2922, full pages: 148142 
    Fill distribution: 
     0 - 19% = 4744 
    20 - 39% = 6249 
    40 - 59% = 15517 
    60 - 79% = 40577 
    80 - 99% = 123041 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13126, nodes: 11438334 
    Average node length: 5.29, total dup: 11328198, max dup: 635 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2384749, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 91 
        40 - 59% = 8924 
        60 - 79% = 3950 
        80 - 99% = 158 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10610, nodes: 11438334 
    Average node length: 5.49, total dup: 10940283, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 717098, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 159 
        20 - 39% = 876 
        40 - 59% = 2648 
        60 - 79% = 1890 
        80 - 99% = 5037 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15014, nodes: 11438334 
    Average node length: 6.02, total dup: 9983763, max dup: 75 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2401291, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 119 
        40 - 59% = 10376 
        60 - 79% = 4308 
        80 - 99% = 207 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10956, nodes: 11438334 
    Average node length: 5.21, total dup: 11438234, max dup: 176974 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 705791, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 840 
        40 - 59% = 5005 
        60 - 79% = 1489 
        80 - 99% = 3530 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.33, total records: 9868741 
    Average version length: 82.92, total versions: 526483, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 107, data page slots: 173448 
    Data pages: 173400, average fill: 71% 
    Primary pages: 173400, secondary pages: 0, swept pages: 65015 
    Empty pages: 721, full pages: 105174 
    Fill distribution: 
     0 - 19% = 1918 
    20 - 39% = 7730 
    40 - 59% = 26117 
    60 - 79% = 69813 
    80 - 99% = 67822 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11861, nodes: 9868741 
    Average node length: 5.18, total dup: 9839839, max dup: 2057 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1955900, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1446 
        40 - 59% = 7795 
        60 - 79% = 1954 
        80 - 99% = 634 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13805, nodes: 9868741 
    Average node length: 6.25, total dup: 8183739, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1437183, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 183 
        20 - 39% = 3859 
        40 - 59% = 4711 
        60 - 79% = 2529 
        80 - 99% = 2523 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12495, nodes: 9868741 
    Average node length: 5.43, total dup: 9429547, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2089612, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1453 
        40 - 59% = 8654 
        60 - 79% = 1755 
        80 - 99% = 607 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10343, nodes: 9868741 
    Average node length: 5.15, total dup: 9868641, max dup: 149869 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1533718, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1224 
        40 - 59% = 5284 
        60 - 79% = 1676 
        80 - 99% = 2122 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.28, total records: 573458 
    Average version length: 68.86, total versions: 7484, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 75% 
    Primary pages: 8000, secondary pages: 0, swept pages: 3805 
    Empty pages: 1, full pages: 6665 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 28 
    40 - 59% = 309 
    60 - 79% = 7540 
    80 - 99% = 122 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39708, depth: 3, leaf buckets: 725, nodes: 573458 
    Average node length: 5.95, total dup: 488043, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100248, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 491 
        60 - 79% = 101 
        80 - 99% = 96 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29720, depth: 3, leaf buckets: 761, nodes: 573458 
    Average node length: 6.15, total dup: 470242, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100299, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 40 
        40 - 59% = 517 
        60 - 79% = 109 
        80 - 99% = 93 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 589, nodes: 573458 
    Average node length: 4.86, total dup: 573358, max dup: 9451 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89123, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 354 
        60 - 79% = 115 
        80 - 99% = 87 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Mar 18 22:11:43 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7801618 120483 1 0.0000 0.0000
DOC_LIST 2265052 125275 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 238272 618 59500.0000 0.0000
INVNT_TURNOVER_LOG 87641 75283 1 0.0000 0.0000
MONEY_SALDO 49 18360 944 37400.0000 0.0000
MONEY_TURNOVER_LOG 1592 1372 1 0.0000 0.0000
PDISTR 833528 77179 4 0.0000 0.0000
PERF_SPLIT_0 183683 8913 1 0.0000 0.0000
PERF_SPLIT_1 174380 11043 1 0.0000 0.0000
PERF_SPLIT_2 169526 14617 1 0.0000 0.0000
PERF_SPLIT_3 158008 16071 1 0.0000 0.0000
PERF_SPLIT_4 148498 6614 1 0.0000 0.0000
PERF_SPLIT_5 168400 12961 1 0.0000 0.0000
PERF_SPLIT_6 193784 36912 1 0.0000 0.0000
PERF_SPLIT_7 190211 14305 1 0.0000 0.0000
PERF_SPLIT_8 243388 69606 1 0.0000 0.0000
PERF_SPLIT_9 170814 10932 1 0.0000 0.0000
PSTORNED 2104428 56283 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 157329 75444 1 0.0000 0.0000
XQD_1000_3300 7246789 521611 1 0.0000 0.0000
XQD_1200_2000 12212423 432409 1 0.0000 0.0000
XQD_2000_3300 1887732 839418 1 0.0000 0.0000
XQD_2100_3300 1096320 509067 1 0.0000 0.0000
XQD_3300_3400 9299324 523040 1 0.0000 0.0000
XQS_1000_1200 21195513 14268 1 0.0000 0.0000
XQS_1000_3300 9759668 528309 1 0.0000 0.0000
XQS_1200_2000 11438334 460509 1 0.0000 0.0000
XQS_2100_3300 9868741 526483 1 0.0000 0.0000
XQS_3300_3400 573458 7484 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 ---
--- end of diff output ---

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

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