Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.03.2024 16: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 16012232 kB
MemAvailable 30298812 kB
Buffers 0 kB
Cached 15751204 kB
SwapCached 2612 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-24 16:09:45
DTS_END                         2024-03-24 16:09:45.7250
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55274
TRN_ID                          170532
ATT_ID                          554
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: 8973.57 21822 897357
customer order: creation 171.82 399 17182
customer order: refuse 14.35 336 1435
order to supplier: creation 44.16 1430 4416
order to supplier: removal 3.46 96325 346
invoice (draft): creation 45.81 3546 4581
invoice (draft): removal 49.02 798 4902
invoice accept: apply 41.69 21463 4169
invoice accept: cancel 44.24 856 4424
customer reserve: creation 3942.59 206 394259
customer reserve: removal 4330.47 60 433047
realization accept: apply 83.12 217 8312
realization accept: cancel 77.02 146 7702
payment from customer: creation 57.25 140 5725
payment from customer: removal 5.66 110 566
payment to supplier: creation 47.59 172 4759
payment to supplier: removal 3.67 85 367
service: total inventory turnovers 4.56 1137 456
service: total monetary turnovers 6.34 33 634
service: aggregate perf. data 0.72 24654 72
service: refresh index statistics 0.03 284323 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 24-03-2024 16:11:11 to 24-03-2024 16:11:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2269
TEST_TIME 2 2780
TEST_TIME 3 3868
TEST_TIME 4 3438
TEST_TIME 5 3662
TEST_TIME 6 4547
TEST_TIME 7 4689
TEST_TIME 8 4901
TEST_TIME 9 5610
TEST_TIME 10 5594
TEST_TIME 11 5739
TEST_TIME 12 5763
TEST_TIME 13 6170
TEST_TIME 14 6367
TEST_TIME 15 6661
TEST_TIME 16 6772
TEST_TIME 17 6830
TEST_TIME 18 6795
TEST_TIME 19 6814
TEST_TIME 20 6733
TEST_TIME 21 7129
TEST_TIME 22 7147
TEST_TIME 23 7322
TEST_TIME 24 7536
TEST_TIME 25 7697
TEST_TIME 26 7864
TEST_TIME 27 7999
TEST_TIME 28 8188
TEST_TIME 29 8110
TEST_TIME 30 8650
TEST_TIME 31 8869
TEST_TIME 32 9044
TEST_TIME 33 8875
TEST_TIME 34 8861
TEST_TIME 35 8902
TEST_TIME 36 8785
TEST_TIME 37 8634
TEST_TIME 38 8567
TEST_TIME 39 8498
TEST_TIME 40 8492
TEST_TIME 41 8619
TEST_TIME 42 8495
TEST_TIME 43 8506
TEST_TIME 44 8377
TEST_TIME 45 8381
TEST_TIME 46 8386
TEST_TIME 47 8426
TEST_TIME 48 8399
TEST_TIME 49 8552
TEST_TIME 50 8525
TEST_TIME 51 8556
TEST_TIME 52 8537
TEST_TIME 53 8467
TEST_TIME 54 8497
TEST_TIME 55 8654
TEST_TIME 56 8750
TEST_TIME 57 8759
TEST_TIME 58 8742
TEST_TIME 59 8736
TEST_TIME 60 8821
TEST_TIME 61 8823
TEST_TIME 62 8785
TEST_TIME 63 8677
TEST_TIME 64 8706
TEST_TIME 65 8647
TEST_TIME 66 8655
TEST_TIME 67 8640
TEST_TIME 68 8628
TEST_TIME 69 8650
TEST_TIME 70 8595
TEST_TIME 71 8540
TEST_TIME 72 8562
TEST_TIME 73 8598
TEST_TIME 74 8570
TEST_TIME 75 8612
TEST_TIME 76 8633
TEST_TIME 77 8728
TEST_TIME 78 8756
TEST_TIME 79 8795
TEST_TIME 80 8767
TEST_TIME 81 8798
TEST_TIME 82 8888
TEST_TIME 83 8958
TEST_TIME 84 9019
TEST_TIME 85 9007
TEST_TIME 86 8993
TEST_TIME 87 9153
TEST_TIME 88 9059
TEST_TIME 89 9028
TEST_TIME 90 9013
TEST_TIME 91 8991
TEST_TIME 92 9026
TEST_TIME 93 8983
TEST_TIME 94 8959
TEST_TIME 95 8952
TEST_TIME 96 8986
TEST_TIME 97 8948
TEST_TIME 98 8951
TEST_TIME 99 8984
TEST_TIME 100 8979

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-03-2024 16:11:15 to 24-03-2024 16:11:18.

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 1258434 1258434 0 0.00 0 21149 7 0 0
doc_list_biud 1258434 1258434 0 0.00 0 44902 27 0 0
sp_add_invoice_to_stock 4236 4169 67 1.58 33 161045 21464 0 67
sp_cancel_adding_invoice 4424 4424 0 0.00 5 56822 857 0 0
sp_cancel_client_order 1435 1435 0 0.00 4 10375 336 0 0
sp_cancel_customer_reserve 433047 433047 0 0.00 0 24429 60 0 0
sp_cancel_pay_from_customer 566 566 0 0.00 3 6114 110 0 0
sp_cancel_pay_to_supplier 367 367 0 0.00 3 5069 86 0 0
sp_cancel_supplier_invoice 4903 4902 1 0.02 1 13279 799 0 1
sp_cancel_supplier_order 346 346 0 0.00 5 813463 96325 0 0
sp_cancel_write_off 7702 7702 0 0.00 1 14603 147 0 0
sp_client_order 17182 17182 0 0.00 2 31599 399 0 0
sp_customer_reserve 394259 394259 0 0.00 0 53469 206 0 0
sp_fill_shopping_cart 26175 26175 0 0.00 1 20577 41 0 0
sp_fill_shopping_cart_clo_res 394253 394253 0 0.00 0 18091 17 0 0
sp_get_clo_for_invoice 4163 4163 0 0.00 0 37206 369 0 0
sp_kill_cost_storno 13059 13059 0 0.00 0 7771 67 0 0
sp_kill_qstorno_ret_qs2qd 879044 879044 0 0.00 0 24426 33 0 0
sp_kill_qty_storno 464331 464331 0 0.00 0 44901 72 0 0
sp_lock_selected_doc 17252 17252 0 0.00 0 8160 6 0 0
sp_make_cost_storno 22959 22959 0 0.00 0 21116 77 0 0
sp_multiply_rows_for_pdistr 22959 22959 0 0.00 0 9532 32 0 0
sp_multiply_rows_for_qdistr 17182 17182 0 0.00 0 14471 171 0 0
sp_pay_from_customer 5725 5725 0 0.00 4 19053 141 0 0
sp_pay_to_supplier 4759 4759 0 0.00 5 14338 172 0 0
sp_payment_common 10484 10484 0 0.00 1 14317 35 0 0
sp_qd_handle_on_cancel_clo 1435 1435 0 0.00 0 10367 308 0 0
sp_qd_handle_on_invoice_upd_sts 8587 8587 0 0.00 0 44899 375 0 0
sp_qd_handle_on_reserve_upd_sts 8312 8312 0 0.00 0 21913 71 0 0
sp_reserve_write_off 8312 8312 0 0.00 6 21997 217 0 0
sp_supplier_invoice 4581 4581 0 0.00 7 81881 3546 0 0
sp_supplier_order 4416 4416 0 0.00 5 31660 1430 0 0
srv_aggregate_perf_data 72 72 0 0.00 1893 352254 24655 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1516 126325 37269 0 0
srv_find_qd_qs_mism 855678 855678 0 0.00 0 11132 6 0 0
srv_make_invnt_saldo 456 456 0 0.00 39 25579 1138 0 0
srv_make_money_saldo 634 634 0 0.00 1 2201 34 0 0
srv_recalc_idx_stat 3 3 0 0.00 152042 434180 284324 0 0
t$perf-abend:sp_add_invoice_to_stock 67 67 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4169 4169 0 0.00 0 11999 195 0 0
t$perf-norm:sp_cancel_adding_invoice 332 332 0 0.00 0 2944 92 0 0
t$perf-norm:sp_cancel_client_order 1435 1435 0 0.00 0 3559 14 0 0
t$perf-norm:sp_cancel_customer_reserve 557 557 0 0.00 0 1145 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 566 566 0 0.00 0 562 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 367 367 0 0.00 0 2353 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 329 329 0 0.00 0 475 14 0 0
t$perf-norm:sp_cancel_supplier_order 346 346 0 0.00 0 20905 1663 0 0
t$perf-norm:sp_cancel_write_off 845 845 0 0.00 0 1384 8 0 0
t$perf-norm:sp_client_order 17182 17182 0 0.00 0 9316 18 0 0
t$perf-norm:sp_customer_reserve 845 845 0 0.00 0 1041 6 0 0
t$perf-norm:sp_pay_from_customer 5725 5725 0 0.00 0 3797 10 0 0
t$perf-norm:sp_pay_to_supplier 4759 4759 0 0.00 0 4622 13 0 0
t$perf-norm:sp_reserve_write_off 8312 8312 0 0.00 0 6101 14 0 0
t$perf-norm:sp_supplier_invoice 4581 4581 0 0.00 0 5624 20 0 0
t$perf-norm:sp_supplier_order 4416 4416 0 0.00 0 2370 18 0 0
t$perf-norm:srv_aggregate_perf_data 72 72 0 0.00 0 144 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 229 7 0 0
t$perf-norm:srv_make_invnt_saldo 456 456 0 0.00 0 1075 26 0 0
t$perf-norm:srv_make_money_saldo 634 634 0 0.00 0 914 24 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 9 5 0 0
v_add_invoice_to_stock 8460 8326 134 1.58 0 5201 20 0 134
v_all_customers 31570 31570 0 0.00 0 43 1 0 0
v_all_suppliers 25288 25288 0 0.00 0 91 1 0 0
v_all_wares 34360 34360 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 664 664 0 0.00 0 93 5 0 0
v_cancel_client_order 2870 2870 0 0.00 0 1646 5 0 0
v_cancel_customer_prepayment 1132 1132 0 0.00 0 2487 10 0 0
v_cancel_customer_reserve 1114 1114 0 0.00 0 2106 6 0 0
v_cancel_payment_to_supplier 734 734 0 0.00 0 1178 7 0 0
v_cancel_supplier_invoice 660 658 2 0.30 0 2229 22 0 2
v_cancel_supplier_order 692 692 0 0.00 0 778 4 0 0
v_cancel_write_off 1690 1690 0 0.00 0 3033 27 0 0
v_max_id_clo_ord 4414 4414 0 0.00 0 5498 3 0 0
v_max_id_clo_res 845 845 0 0.00 0 3656 21 0 0
v_max_id_ord_sup 4580 4580 0 0.00 0 4887 6 0 0
v_max_non_paid_invoice 1109 1109 0 0.00 0 955 5 0 0
v_max_non_paid_realizn 2919 2919 0 0.00 0 6407 13 0 0
v_min_id_clo_ord 4414 4414 0 0.00 0 4561 12 0 0
v_min_id_clo_res 845 845 0 0.00 0 6422 21 0 0
v_min_id_ord_sup 4580 4580 0 0.00 0 5812 8 0 0
v_min_non_paid_invoice 4759 4759 0 0.00 0 14312 26 0 0
v_min_non_paid_realizn 5725 5725 0 0.00 0 6495 22 0 0
v_our_firm 8402 8402 0 0.00 0 15 1 0 0
v_reserve_write_off 16624 16624 0 0.00 0 5206 8 0 0
x_lock_depdocs_on_canc_invoice 8997 8997 0 0.00 0 10810 129 0 0
x_lock_depdocs_on_canc_sup_ord 346 346 0 0.00 0 7674 356 0 0
x_make_qstorno_1000_1200 4416 4416 0 0.00 1 31600 1334 0 0
x_make_qstorno_1200_2000 4581 4581 0 0.00 3 81874 3401 0 0
x_make_qstorno_2100_3300 394259 394259 0 0.00 0 44534 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-03-2024 16:11:19 to 24-03-2024 16:11:23.

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
14:09:49 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:50 21500 8192000000 9885734624 10195931136 977068768 10.656 100 84 169 0 1004547040 5118288 22359984
14:12:15 15071 8192000000 9938081344 10257907712 1022293040 11.094 100 88 176 0 1051991920 7276368 22422512
14:13:34 18058 8192000000 9977636848 10306404352 1055153120 11.410 100 90 178 1 1090197904 12767488 22277296
14:14:56 11835 8192000000 10012886176 10354036736 1097204704 11.811 100 80 160 0 1125493840 9147680 19141456
14:16:12 6955 8192000000 10060271056 10418663424 1155227600 12.359 100 82 164 0 1185321728 10938640 19155488
14:17:26 4838 8192000000 10116101440 10481127424 1202193536 12.797 100 81 160 0 1233749984 13215840 18340608
14:18:34 2986 8192000000 10143230672 10515873792 1231100016 13.064 100 79 158 1 1262253408 13836096 17317296
14:19:42 1677 8192000000 10176838512 10555105280 1262595248 13.354 100 82 163 0 1294621216 13675680 18350288
14:20:45 922 8192000000 10208638544 10591666176 1288108320 13.587 100 93 185 3 1321585104 12863840 20612944
14:21:49 18988 8192000000 10215337456 10610606080 1307285632 13.761 100 59 118 0 1332017104 11247584 13483888
14:23:09 7936 8192000000 10211526464 10613522432 1313075440 13.814 100 23 47 0 1324002304 5178880 5747984
14:24:19 6605 8192000000 10206719280 10624012288 1322701408 13.901 100 25 50 0 1335213184 6898736 5613040
14:25:27 9568 8192000000 10213091392 10638483456 1334968400 14.012 100 25 50 0 1346378864 5785840 5624624
14:26:37 10011 8192000000 10231295664 10648100864 1341815296 14.074 100 30 58 0 1354374656 5727056 6832304
14:27:49 22419 8192000000 10233466736 10658648064 1346063216 14.112 100 21 40 2 1357746864 6142080 5541568
14:29:16 7111 8192000000 10221780512 10638745600 1312798800 13.811 98 26 53 1 1325183664 6202816 6182048
14:30:32 17130 8192000000 10250297552 10662817792 1348687472 14.136 100 53 104 0 1368143136 7462880 11992784
14:32:01 17687 8192000000 10237117344 10645209088 1321104976 13.887 99 44 88 0 1341102704 9940928 10056800
14:33:31 44190 8192000000 10249374656 10665222144 1323317856 13.907 98 47 93 1 1348640656 13946832 11375968
14:35:18 23759 8192000000 10255883248 10674896896 1348354048 14.133 100 40 80 1 1371572944 14077920 9140976
14:36:48 25400 8192000000 10245679824 10656731136 1323321888 13.907 99 45 88 1 1349491520 16232864 9936768
14:38:21 6008 8192000000 10246016816 10655158272 1321618816 13.891 99 59 118 1 1353079872 16618944 14842112
14:39:32 16594 8192000000 10231818864 10630221824 1307985296 13.768 99 56 113 0 1336727840 16465744 12276800
14:40:52 14277 8192000000 10237786928 10643263488 1280868208 13.521 97 58 114 1 1313729120 19596240 13264672
14:42:09 3656 8192000000 10238076336 10639511552 1315812864 13.839 100 48 91 0 1349498208 22993344 10692000
14:43:17 11361 8192000000 10238804064 10650730496 1325085200 13.923 100 39 77 0 1354108176 19483968 9539008
14:44:35 2765 8192000000 10241271328 10651373568 1321902256 13.894 100 55 107 1 1354344240 19191056 13250928
14:45:44 6791 8192000000 10261611360 10666135552 1335977968 14.021 100 60 112 0 1370321040 21605568 12737504
14:46:59 1515 8192000000 10277616880 10679177216 1343586048 14.090 100 76 150 0 1382463776 21260672 17617056
14:48:06 6192 8192000000 10286208880 10695364608 1355194352 14.194 100 59 115 2 1392287344 23051312 14041680
14:49:20 6319 8192000000 10315763312 10725941248 1377573968 14.395 100 75 147 0 1424690944 28628880 18488096
14:50:32 1734 8192000000 10316388896 10724421632 1375274192 14.374 100 69 138 3 1427975680 35413952 17287536
14:51:37 7400 8192000000 10318048928 10737262592 1381049872 14.426 100 44 85 1 1421758880 30140832 10568176
14:53:10 3217 8192000000 10324305760 10736164864 1380703184 14.423 100 72 139 1 1431037984 33073040 17261760
14:54:20 17598 8192000000 10307262080 10740109312 1379776368 14.415 100 22 45 0 1418508496 32034240 6697888
14:55:42 6897 8192000000 10329545376 10752974848 1394033776 14.542 100 43 84 0 1432264352 28002448 10228128
14:56:51 18219 8192000000 10326527680 10769088512 1395142288 14.552 100 27 54 1 1436898592 34267408 7488896
14:58:14 24923 8192000000 10328828400 10773446656 1392710464 14.530 100 19 38 0 1436025232 37591392 5723376
15:00:05 24989 8192000000 10318982256 10763350016 1397036320 14.569 100 23 46 1 1429540336 26859184 5644832
15:01:39 56009 8192000000 10306893920 10757128192 1394644128 14.547 100 18 34 0 1410695488 12196240 3855120
15:03:40 15701 8192000000 10314504848 10753945600 1393557472 14.538 100 51 100 0 1415271488 10156512 11557504
15:05:17 26904 8192000000 10302905424 10758135808 1398940048 14.586 100 33 67 0 1418077232 11978384 7158800
15:06:51 17948 8192000000 10315444128 10764009472 1397925248 14.577 100 22 44 0 1420975904 17640464 5410192
15:08:30 91827 8192000000 10311315120 10762399744 1401066720 14.604 100 24 49 0 1421962240 14763488 6132032
15:11:03 48197 8192000000 10317242608 10758574080 1396210288 14.561 99 51 102 1 1418158160 10435520 11512352
15:12:53 49037 8192000000 10338519664 10780114944 1409901808 14.683 100 40 80 0 1436158864 16779328 9477728
15:14:48 29903 8192000000 10309994144 10761072640 1385211840 14.463 98 22 44 0 1412628416 22269824 5146752
15:16:23 59545 8192000000 10305895872 10758193152 1391806880 14.522 99 21 42 0 1411262608 14734128 4721600
15:19:04 64215 8192000000 10280463200 10726432768 1336100448 14.022 96 9 18 0 1347632784 9720272 1812064
15:21:09 51702 8192000000 10289913392 10728087552 1328768336 13.956 96 22 44 0 1341137984 6602800 5766848
15:23:02 54292 8192000000 10276661152 10727436288 1344933232 14.102 98 22 44 0 1367267536 17210432 5123872
15:24:56 51826 8192000000 10240677312 10688757760 1274325072 13.461 94 17 32 0 1287803920 10099120 3379728
15:26:48 95249 8192000000 10261925952 10695700480 1256811632 13.301 93 19 38 0 1271633984 10867968 3954384
15:29:32 91052 8192000000 10239616848 10669256704 1239039856 13.137 92 17 34 0 1254882128 11824608 4017664
15:32:05 126324 8192000000 10227613280 10667950080 1305510768 13.745 98 24 49 0 1320691056 9837472 5342816
15:35:13 21652 8192000000 10240612432 10667700224 1319524704 13.872 99 24 47 1 1336282992 10970144 5788144
15:36:41 47339 8192000000 10233756896 10685362176 1339804816 14.056 100 12 24 0 1353852224 11141712 2905696
15:38:31 33579 8192000000 10235141856 10670673920 1294070832 13.641 96 20 40 0 1304023152 5707792 4244528
15:40:31 76222 8192000000 10263154544 10704326656 1358577920 14.225 100 35 68 0 1379751056 13404624 7768512
15:42:53 32089 8192000000 10268179248 10707738624 1361529984 14.251 99 15 28 0 1371462912 7378560 2554368
15:44:28 41646 8192000000 10294552752 10735886336 1369779488 14.325 99 23 46 0 1385299728 10195024 5325216
15:46:10 39708 8192000000 10283140112 10724130816 1355816960 14.200 98 24 48 0 1369842800 8507072 5518768
15:47:58 44328 8192000000 10297966896 10732453888 1369182784 14.320 99 15 30 1 1380846208 8523440 3139984
15:49:44 34645 8192000000 10318663136 10755182592 1389532288 14.502 99 34 68 0 1411548768 14264208 7752272
15:51:19 72156 8192000000 10308218336 10763345920 1382620768 14.440 99 16 32 0 1405574624 19428896 3524960
15:53:34 79331 8192000000 10316258000 10762682368 1387694048 14.485 99 9 18 0 1400476896 11154672 1628176
15:55:55 42397 8192000000 10319547488 10791911424 1412175712 14.703 100 23 45 1 1434703152 17241408 5286032
15:57:39 91978 8192000000 10310856816 10765041664 1388789536 14.495 99 17 34 1 1408358432 15606112 3962784
16:00:11 26209 8192000000 10297027168 10747437056 1394009440 14.542 100 7 14 0 1411027376 15368976 1648960
16:01:38 44193 8192000000 10301307648 10768924672 1398463680 14.581 100 17 34 0 1415506112 13250800 3791632
16:03:23 46114 8192000000 10284354064 10732920832 1332600048 13.991 95 12 24 0 1347282624 11485984 3196592
16:05:12 64020 8192000000 10258590000 10715484160 1343481936 14.089 98 16 32 1 1357833280 10675024 3676320
16:07:59 48251 8192000000 10267597056 10731147264 1348909712 14.138 98 9 18 0 1360705552 9928352 1867488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 24-03-2024 16:11:25 to 24-03-2024 16:11:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 67 v_add_invoice_to_stock 335544517
except 1 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-03-2024 16:11:40 to 24-03-2024 16:11:42.

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          169528
MON$OLDEST_ACTIVE               170644
MON$OLDEST_SNAPSHOT             170644
MON$NEXT_TRANSACTION            170644
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                       1886144
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Mar 24 16:11:43 2024 
 
Database header page information: 
    Flags            0 
    Generation        88938 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    169528 
    Oldest active        170644 
    Oldest snapshot        170644 
    Next transaction    170645 
    Sequence number        0 
    Next attachment ID    703 
    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.30, total records: 7743211 
    Average version length: 48.16, total versions: 95347, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86512 
    Data pages: 86512, average fill: 71% 
    Primary pages: 86512, secondary pages: 0, swept pages: 19958 
    Empty pages: 1, full pages: 61274 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 36 
    40 - 59% = 1214 
    60 - 79% = 85193 
    80 - 99% = 61 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23166, nodes: 7743211 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1715286, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 336 
        20 - 39% = 1705 
        40 - 59% = 4112 
        60 - 79% = 2239 
        80 - 99% = 14774 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13430, nodes: 7743211 
    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: 1538001, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1510 
        40 - 59% = 1983 
        60 - 79% = 1079 
        80 - 99% = 8858 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8300, nodes: 7743211 
    Average node length: 6.62, total dup: 5789110, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1530917, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 928 
        40 - 59% = 1342 
        60 - 79% = 858 
        80 - 99% = 5033 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.13, total records: 2244297 
    Average version length: 34.50, total versions: 102210, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28416 
    Data pages: 28416, average fill: 73% 
    Primary pages: 28410, secondary pages: 6, swept pages: 10282 
    Empty pages: 8, full pages: 19110 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 84 
    40 - 59% = 1182 
    60 - 79% = 26388 
    80 - 99% = 742 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4516, nodes: 2244297 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 696005, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 910 
        40 - 59% = 796 
        60 - 79% = 702 
        80 - 99% = 2108 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2537, nodes: 2246620 
    Average node length: 4.97, total dup: 2245721, max dup: 19400 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1240622, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 292 
        40 - 59% = 1546 
        60 - 79% = 535 
        80 - 99% = 163 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2024, nodes: 2244297 
    Average node length: 4.97, total dup: 2244247, max dup: 130116 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1060250, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 61 
        40 - 59% = 1072 
        60 - 79% = 42 
        80 - 99% = 845 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4322, nodes: 2244297 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 696005, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 581 
        40 - 59% = 557 
        60 - 79% = 802 
        80 - 99% = 2269 
 
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.56, total records: 400 
    Average version length: 23.19, total versions: 228502, max versions: 597 
    Average fragment length: 2.00, total fragments: 42, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1264 
    Data pages: 1264, average fill: 90% 
    Primary pages: 11, secondary pages: 1253, swept pages: 0 
    Empty pages: 4, full pages: 1259 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1259 
 
    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: 14.64, total records: 117300 
    Average version length: 68.29, total versions: 92169, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.01 
    Pointer pages: 7, data page slots: 2576 
    Data pages: 2136, average fill: 68% 
    Primary pages: 2135, secondary pages: 1, swept pages: 0 
    Empty pages: 176, full pages: 1378 
    Fill distribution: 
     0 - 19% = 283 
    20 - 39% = 213 
    40 - 59% = 170 
    60 - 79% = 318 
    80 - 99% = 1152 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701971, depth: 3, leaf buckets: 399, nodes: 117300 
    Average node length: 13.12, total dup: 9656, max dup: 2 
    Average key length: 10.54, compression ratio: 2.56 
    Average prefix length: 19.37, average data length: 7.63 
    Clustering factor: 81882, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 59 
        40 - 59% = 308 
        60 - 79% = 30 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 16528, max versions: 913 
    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: 64 
    Data pages: 64, average fill: 83% 
    Primary pages: 4, secondary pages: 60, swept pages: 0 
    Empty pages: 3, full pages: 60 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 54 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 4.57, total records: 1561 
    Average version length: 43.65, total versions: 1403, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 12.69 
    Pointer pages: 1, data page slots: 40 
    Data pages: 31, average fill: 50% 
    Primary pages: 30, secondary pages: 1, swept pages: 1 
    Empty pages: 5, full pages: 12 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90793, depth: 2, leaf buckets: 3, nodes: 1561 
    Average node length: 4.15, total dup: 1463, max dup: 205 
    Average key length: 2.66, compression ratio: 7.13 
    Average prefix length: 18.40, average data length: 0.60 
    Clustering factor: 760, ratio: 0.49 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.04, total records: 74 
    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: 52% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.12, total records: 812406 
    Average version length: 25.39, total versions: 68639, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 70% 
    Primary pages: 8029, secondary pages: 35, swept pages: 1479 
    Empty pages: 80, full pages: 7540 
    Fill distribution: 
     0 - 19% = 132 
    20 - 39% = 61 
    40 - 59% = 88 
    60 - 79% = 7492 
    80 - 99% = 291 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 896, nodes: 812406 
    Average node length: 4.87, total dup: 812357, max dup: 152948 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89359, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 124 
        40 - 59% = 498 
        60 - 79% = 213 
        80 - 99% = 58 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 921, nodes: 812406 
    Average node length: 5.88, total dup: 723076, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161524, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 86 
        40 - 59% = 389 
        60 - 79% = 94 
        80 - 99% = 348 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 958, nodes: 812406 
    Average node length: 5.88, total dup: 723076, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163485, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 168 
        40 - 59% = 361 
        60 - 79% = 91 
        80 - 99% = 337 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1139, nodes: 812406 
    Average node length: 5.96, total dup: 723076, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155720, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 215 
        40 - 59% = 632 
        60 - 79% = 194 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5397 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.76, total fragments: 51, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 104 
    Data pages: 95, average fill: 56% 
    Primary pages: 77, secondary pages: 18, swept pages: 52 
    Empty pages: 11, full pages: 63 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5397 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.01 
    Average prefix length: 34.29, average data length: 1.54 
    Clustering factor: 5076, 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: 5397 
    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: 152, 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: 78194 
    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: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 753 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 753 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 29793, depth: 2, leaf buckets: 100, nodes: 78194 
    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: 3556, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.62, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 148.32, total records: 162959 
    Average version length: 149.70, total versions: 2615, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 6, data page slots: 4872 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3920, secondary pages: 0, swept pages: 3 
    Empty pages: 55, full pages: 3846 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3845 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 144.20, total records: 154580 
    Average version length: 152.30, total versions: 6591, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.76 
    Pointer pages: 7, data page slots: 5376 
    Data pages: 3704, average fill: 86% 
    Primary pages: 3704, secondary pages: 0, swept pages: 6 
    Empty pages: 43, full pages: 3651 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3650 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.89, total records: 182122 
    Average version length: 151.47, total versions: 5222, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 7, data page slots: 6608 
    Data pages: 4400, average fill: 86% 
    Primary pages: 4400, secondary pages: 0, swept pages: 3 
    Empty pages: 69, full pages: 4307 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 6 
    80 - 99% = 4308 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 134.24, total records: 184347 
    Average version length: 154.58, total versions: 20127, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.63 
    Pointer pages: 6, data page slots: 5344 
    Data pages: 4416, average fill: 87% 
    Primary pages: 4416, secondary pages: 0, swept pages: 3 
    Empty pages: 38, full pages: 4362 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4361 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 127.59, total records: 168636 
    Average version length: 154.51, total versions: 25961, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.29 
    Pointer pages: 6, data page slots: 5424 
    Data pages: 4056, average fill: 87% 
    Primary pages: 4056, secondary pages: 0, swept pages: 1 
    Empty pages: 40, full pages: 3995 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 10 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3996 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 138.08, total records: 173505 
    Average version length: 153.23, total versions: 14727, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.28 
    Pointer pages: 8, data page slots: 5544 
    Data pages: 4192, average fill: 86% 
    Primary pages: 4192, secondary pages: 0, swept pages: 3 
    Empty pages: 69, full pages: 4101 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 4100 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 137.28, total records: 157174 
    Average version length: 153.85, total versions: 14098, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.35 
    Pointer pages: 9, data page slots: 5800 
    Data pages: 3776, average fill: 86% 
    Primary pages: 3776, secondary pages: 0, swept pages: 1 
    Empty pages: 39, full pages: 3714 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 7 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 3715 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 145.06, total records: 179046 
    Average version length: 153.04, total versions: 7152, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 8, data page slots: 5664 
    Data pages: 4344, average fill: 85% 
    Primary pages: 4344, secondary pages: 0, swept pages: 1 
    Empty pages: 84, full pages: 4239 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 13 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4238 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.66, total records: 169693 
    Average version length: 151.03, total versions: 3818, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 5184 
    Data pages: 4112, average fill: 85% 
    Primary pages: 4112, secondary pages: 0, swept pages: 3 
    Empty pages: 82, full pages: 4014 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4011 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 120.50, total records: 196925 
    Average version length: 154.81, total versions: 39529, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.08 
    Pointer pages: 7, data page slots: 7352 
    Data pages: 4736, average fill: 88% 
    Primary pages: 4736, secondary pages: 0, swept pages: 1 
    Empty pages: 46, full pages: 4674 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4673 
 
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.71, total records: 2092090 
    Average version length: 52.98, total versions: 41105, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25440 
    Data pages: 25440, average fill: 71% 
    Primary pages: 25440, secondary pages: 0, swept pages: 11682 
    Empty pages: 273, full pages: 19968 
    Fill distribution: 
     0 - 19% = 520 
    20 - 39% = 434 
    40 - 59% = 1150 
    60 - 79% = 22946 
    80 - 99% = 390 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2570, nodes: 2092090 
    Average node length: 5.44, total dup: 1951893, max dup: 1386 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181315, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 292 
        40 - 59% = 1674 
        60 - 79% = 295 
        80 - 99% = 302 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2754, nodes: 2092090 
    Average node length: 5.69, total dup: 1877550, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374134, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2427 
        60 - 79% = 299 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2181, nodes: 2092090 
    Average node length: 4.96, total dup: 2091990, max dup: 28223 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178982, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 220 
        40 - 59% = 1196 
        60 - 79% = 394 
        80 - 99% = 368 
 
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: 41.54, total records: 147339 
    Average version length: 69.16, total versions: 58895, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 3, data page slots: 4208 
    Data pages: 2968, average fill: 57% 
    Primary pages: 2968, secondary pages: 0, swept pages: 374 
    Empty pages: 437, full pages: 1706 
    Fill distribution: 
     0 - 19% = 645 
    20 - 39% = 241 
    40 - 59% = 228 
    60 - 79% = 715 
    80 - 99% = 1139 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 99098, depth: 3, leaf buckets: 234, nodes: 147339 
    Average node length: 6.44, total dup: 127991, max dup: 14 
    Average key length: 3.97, compression ratio: 10.57 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 25301, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 53 
        40 - 59% = 114 
        60 - 79% = 60 
        80 - 99% = 6 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.12, total records: 7209204 
    Average version length: 68.75, total versions: 402964, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 63, data page slots: 101728 
    Data pages: 101728, average fill: 76% 
    Primary pages: 101728, secondary pages: 0, swept pages: 26271 
    Empty pages: 11, full pages: 87709 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 358 
    40 - 59% = 3461 
    60 - 79% = 90326 
    80 - 99% = 7518 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10747, nodes: 7209204 
    Average node length: 6.51, total dup: 6232910, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1578987, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1410 
        40 - 59% = 5958 
        60 - 79% = 2830 
        80 - 99% = 544 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8493, nodes: 7209204 
    Average node length: 5.39, total dup: 6923343, max dup: 132 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1377041, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 942 
        40 - 59% = 4746 
        60 - 79% = 1597 
        80 - 99% = 1195 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8531, nodes: 7209204 
    Average node length: 5.39, total dup: 6923343, max dup: 132 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1379420, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1043 
        40 - 59% = 4695 
        60 - 79% = 1597 
        80 - 99% = 1192 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.34, total records: 12095254 
    Average version length: 68.77, total versions: 284759, 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: 103, data page slots: 166872 
    Data pages: 166872, average fill: 77% 
    Primary pages: 166872, secondary pages: 0, swept pages: 76274 
    Empty pages: 4, full pages: 161430 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 266 
    40 - 59% = 1651 
    60 - 79% = 158922 
    80 - 99% = 5997 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18341, nodes: 12095254 
    Average node length: 6.58, total dup: 10539702, max dup: 63 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2367652, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 2145 
        40 - 59% = 10891 
        60 - 79% = 4379 
        80 - 99% = 888 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 44.47, total records: 1598014 
    Average version length: 69.11, total versions: 570159, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.83 
    Pointer pages: 26, data page slots: 41760 
    Data pages: 29480, average fill: 62% 
    Primary pages: 29479, secondary pages: 1, swept pages: 9626 
    Empty pages: 3217, full pages: 18289 
    Fill distribution: 
     0 - 19% = 5369 
    20 - 39% = 2215 
    40 - 59% = 1959 
    60 - 79% = 10837 
    80 - 99% = 9100 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2238, nodes: 1598014 
    Average node length: 5.51, total dup: 1533183, max dup: 95 
    Average key length: 2.56, compression ratio: 16.39 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 105878, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 658 
        40 - 59% = 1054 
        60 - 79% = 427 
        80 - 99% = 90 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 36.86, total records: 1185466 
    Average version length: 69.13, total versions: 552441, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.42 
    Pointer pages: 20, data page slots: 31936 
    Data pages: 26184, average fill: 53% 
    Primary pages: 26184, secondary pages: 0, swept pages: 5168 
    Empty pages: 4364, full pages: 13116 
    Fill distribution: 
     0 - 19% = 7092 
    20 - 39% = 2712 
    40 - 59% = 2078 
    60 - 79% = 4436 
    80 - 99% = 9866 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1625, nodes: 1185466 
    Average node length: 5.83, total dup: 1102600, max dup: 99 
    Average key length: 2.90, compression ratio: 14.50 
    Average prefix length: 41.17, average data length: 0.83 
    Clustering factor: 165874, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 347 
        40 - 59% = 751 
        60 - 79% = 407 
        80 - 99% = 119 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.62, total records: 9088788 
    Average version length: 68.94, total versions: 431380, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 88, data page slots: 142208 
    Data pages: 142168, average fill: 68% 
    Primary pages: 142168, secondary pages: 0, swept pages: 60974 
    Empty pages: 409, full pages: 73010 
    Fill distribution: 
     0 - 19% = 1288 
    20 - 39% = 5548 
    40 - 59% = 22657 
    60 - 79% = 106936 
    80 - 99% = 5739 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13461, nodes: 9088788 
    Average node length: 6.67, total dup: 7538028, max dup: 19 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1924748, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1400 
        40 - 59% = 6971 
        60 - 79% = 4488 
        80 - 99% = 600 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21136598 
    Average version length: 82.82, total versions: 10891, 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: 318632 
    Data pages: 318632, average fill: 81% 
    Primary pages: 318632, secondary pages: 0, swept pages: 12074 
    Empty pages: 51, full pages: 317626 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 61 
    40 - 59% = 137 
    60 - 79% = 27416 
    80 - 99% = 290943 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19200, nodes: 21136598 
    Average node length: 5.72, total dup: 20655791, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279332, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 7823 
        60 - 79% = 531 
        80 - 99% = 10842 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17162, nodes: 21136598 
    Average node length: 6.31, total dup: 18575092, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913896, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 789 
        60 - 79% = 276 
        80 - 99% = 16090 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21002, nodes: 21136598 
    Average node length: 6.35, total dup: 18493805, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573088, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8128 
        60 - 79% = 590 
        80 - 99% = 12277 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16039, nodes: 21136598 
    Average node length: 5.56, total dup: 21136498, max dup: 228808 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942479, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2802 
        60 - 79% = 375 
        80 - 99% = 12854 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.66, total records: 9549116 
    Average version length: 82.61, total versions: 434071, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 102, data page slots: 165520 
    Data pages: 165488, average fill: 71% 
    Primary pages: 165488, secondary pages: 0, swept pages: 75769 
    Empty pages: 374, full pages: 95999 
    Fill distribution: 
     0 - 19% = 1128 
    20 - 39% = 4945 
    40 - 59% = 22696 
    60 - 79% = 78800 
    80 - 99% = 57919 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11343, nodes: 9549116 
    Average node length: 5.35, total dup: 9240664, max dup: 193 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2076654, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 91 
        40 - 59% = 8591 
        60 - 79% = 2602 
        80 - 99% = 56 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13246, nodes: 9549116 
    Average node length: 6.22, total dup: 7914853, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1424705, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 3923 
        40 - 59% = 4165 
        60 - 79% = 2573 
        80 - 99% = 2469 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12662, nodes: 9549116 
    Average node length: 5.97, total dup: 8281054, max dup: 44 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2267901, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 92 
        40 - 59% = 9575 
        60 - 79% = 2926 
        80 - 99% = 64 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9942, nodes: 9549116 
    Average node length: 5.12, total dup: 9549016, max dup: 153058 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1455868, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1237 
        40 - 59% = 4880 
        60 - 79% = 1713 
        80 - 99% = 2068 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.80, total records: 11227998 
    Average version length: 82.59, total versions: 340122, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 117, data page slots: 190056 
    Data pages: 188768, average fill: 73% 
    Primary pages: 188768, secondary pages: 0, swept pages: 72480 
    Empty pages: 2599, full pages: 140026 
    Fill distribution: 
     0 - 19% = 4562 
    20 - 39% = 7186 
    40 - 59% = 17712 
    60 - 79% = 44584 
    80 - 99% = 114724 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13121, nodes: 11227998 
    Average node length: 5.30, total dup: 11117883, max dup: 636 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2336684, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 171 
        40 - 59% = 9227 
        60 - 79% = 3577 
        80 - 99% = 146 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10402, nodes: 11227998 
    Average node length: 5.49, total dup: 10737571, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 702355, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 909 
        40 - 59% = 2557 
        60 - 79% = 1820 
        80 - 99% = 4975 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15003, nodes: 11227998 
    Average node length: 6.03, total dup: 9792896, max dup: 70 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2353016, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 202 
        40 - 59% = 10769 
        60 - 79% = 3846 
        80 - 99% = 184 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10684, nodes: 11227998 
    Average node length: 5.22, total dup: 11227898, max dup: 181170 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 691865, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 847 
        40 - 59% = 4707 
        60 - 79% = 1453 
        80 - 99% = 3575 
 
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.89, total records: 9676513 
    Average version length: 82.90, total versions: 449517, 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: 104, data page slots: 169064 
    Data pages: 169016, average fill: 71% 
    Primary pages: 169016, secondary pages: 0, swept pages: 79562 
    Empty pages: 433, full pages: 95102 
    Fill distribution: 
     0 - 19% = 1237 
    20 - 39% = 5291 
    40 - 59% = 22675 
    60 - 79% = 85964 
    80 - 99% = 53849 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11767, nodes: 9676513 
    Average node length: 5.17, total dup: 9647577, max dup: 2003 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1879891, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1527 
        40 - 59% = 7922 
        60 - 79% = 1730 
        80 - 99% = 563 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13411, nodes: 9676513 
    Average node length: 6.24, total dup: 8020160, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1389491, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 202 
        20 - 39% = 3861 
        40 - 59% = 4148 
        60 - 79% = 2601 
        80 - 99% = 2599 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12364, nodes: 9676513 
    Average node length: 5.42, total dup: 9241350, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2013881, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1401 
        40 - 59% = 8853 
        60 - 79% = 1522 
        80 - 99% = 563 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10062, nodes: 9676513 
    Average node length: 5.14, total dup: 9676413, max dup: 155231 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1473908, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1239 
        40 - 59% = 4961 
        60 - 79% = 1685 
        80 - 99% = 2140 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.63, total records: 574131 
    Average version length: 68.89, total versions: 4543, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 7984 
    Data pages: 7984, average fill: 75% 
    Primary pages: 7984, secondary pages: 0, swept pages: 4304 
    Empty pages: 7, full pages: 6574 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 7 
    40 - 59% = 208 
    60 - 79% = 7680 
    80 - 99% = 82 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38085, depth: 3, leaf buckets: 729, nodes: 574131 
    Average node length: 5.95, total dup: 488674, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100130, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 509 
        60 - 79% = 94 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31559, depth: 3, leaf buckets: 755, nodes: 574131 
    Average node length: 6.15, total dup: 470770, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 100174, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 528 
        60 - 79% = 98 
        80 - 99% = 97 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 574, nodes: 574131 
    Average node length: 4.86, total dup: 574031, max dup: 9902 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88972, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 326 
        60 - 79% = 91 
        80 - 99% = 113 
 
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 Sun Mar 24 16:12:07 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7743211 95347 1 0.0000 0.0000
DOC_LIST 2244297 102210 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 228502 597 57100.0000 0.0000
INVNT_TURNOVER_LOG 117300 92169 1 0.0000 0.0000
MONEY_SALDO 49 16528 913 33700.0000 0.0000
MONEY_TURNOVER_LOG 1561 1403 1 0.0000 0.0000
PDISTR 812406 68639 6 0.0000 0.0000
PERF_SPLIT_0 162959 2615 1 0.0000 0.0000
PERF_SPLIT_1 154580 6591 1 0.0000 0.0000
PERF_SPLIT_2 182122 5222 1 0.0000 0.0000
PERF_SPLIT_3 184347 20127 1 0.0000 0.0000
PERF_SPLIT_4 168636 25961 1 0.0000 0.0000
PERF_SPLIT_5 173505 14727 1 0.0000 0.0000
PERF_SPLIT_6 157174 14098 1 0.0000 0.0000
PERF_SPLIT_7 179046 7152 1 0.0000 0.0000
PERF_SPLIT_8 169693 3818 1 0.0000 0.0000
PERF_SPLIT_9 196925 39529 1 0.0000 0.0000
PSTORNED 2092090 41105 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 147339 58895 1 0.0000 0.0000
XQD_1000_3300 7209204 402964 1 0.0000 0.0000
XQD_1200_2000 12095254 284759 1 0.0000 0.0000
XQD_2000_3300 1598014 570159 1 0.0000 0.0000
XQD_2100_3300 1185466 552441 1 0.0000 0.0000
XQD_3300_3400 9088788 431380 1 0.0000 0.0000
XQS_1000_1200 21136598 10891 1 0.0000 0.0000
XQS_1000_3300 9549116 434071 1 0.0000 0.0000
XQS_1200_2000 11227998 340122 1 0.0000 0.0000
XQS_2100_3300 9676513 449517 1 0.0000 0.0000
XQS_3300_3400 574131 4543 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 ---
:234: 
:235: mscs-test-161.budzdorov.ru    Sun Mar 24 16:09:47 2024
:236:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:237: 
:238: 
:239: mscs-test-161.budzdorov.ru    Sun Mar 24 16:09:58 2024
:240:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:241: 
--- end of diff output ---

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

24.03.24 16:12:18. 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-24 16:12:21 No severe PSQL-related problems occured
24.03.24 16:12:22. End of report.