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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-18 22:09:44
DTS_END                         2024-02-18 22:09:43.9210
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54890
TRN_ID                          170844
ATT_ID                          582
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: 8896.17 21844 889617
customer order: creation 167.93 378 16793
customer order: refuse 14.27 386 1427
order to supplier: creation 44.11 1288 4411
order to supplier: removal 3.56 96373 356
invoice (draft): creation 45.87 3686 4587
invoice (draft): removal 49.13 775 4913
invoice accept: apply 41.38 21835 4138
invoice accept: cancel 43.97 924 4397
customer reserve: creation 3897.99 211 389799
customer reserve: removal 4299.60 63 429960
realization accept: apply 81.57 236 8157
realization accept: cancel 78.55 132 7855
payment from customer: creation 58.87 147 5887
payment from customer: removal 5.88 102 588
payment to supplier: creation 47.24 173 4724
payment to supplier: removal 3.40 103 340
service: total inventory turnovers 4.95 1251 495
service: total monetary turnovers 7.02 31 702
service: aggregate perf. data 0.85 16642 85
service: refresh index statistics 0.03 292152 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-02-2024 22:11:27 to 18-02-2024 22:11:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5131
TEST_TIME 2 4300
TEST_TIME 3 3854
TEST_TIME 4 3717
TEST_TIME 5 3863
TEST_TIME 6 4405
TEST_TIME 7 4830
TEST_TIME 8 5304
TEST_TIME 9 5439
TEST_TIME 10 5536
TEST_TIME 11 5739
TEST_TIME 12 5706
TEST_TIME 13 5880
TEST_TIME 14 5807
TEST_TIME 15 6171
TEST_TIME 16 6523
TEST_TIME 17 6642
TEST_TIME 18 6756
TEST_TIME 19 6785
TEST_TIME 20 6855
TEST_TIME 21 7412
TEST_TIME 22 7652
TEST_TIME 23 7651
TEST_TIME 24 7793
TEST_TIME 25 7992
TEST_TIME 26 8491
TEST_TIME 27 8465
TEST_TIME 28 8909
TEST_TIME 29 9162
TEST_TIME 30 9448
TEST_TIME 31 9285
TEST_TIME 32 9338
TEST_TIME 33 9535
TEST_TIME 34 9314
TEST_TIME 35 9197
TEST_TIME 36 9126
TEST_TIME 37 9089
TEST_TIME 38 9252
TEST_TIME 39 9095
TEST_TIME 40 8995
TEST_TIME 41 9004
TEST_TIME 42 8968
TEST_TIME 43 8981
TEST_TIME 44 8994
TEST_TIME 45 8891
TEST_TIME 46 8909
TEST_TIME 47 8877
TEST_TIME 48 8808
TEST_TIME 49 8716
TEST_TIME 50 8707
TEST_TIME 51 8713
TEST_TIME 52 8764
TEST_TIME 53 8662
TEST_TIME 54 8730
TEST_TIME 55 8675
TEST_TIME 56 8625
TEST_TIME 57 8577
TEST_TIME 58 8665
TEST_TIME 59 8691
TEST_TIME 60 8652
TEST_TIME 61 8725
TEST_TIME 62 8753
TEST_TIME 63 8787
TEST_TIME 64 8831
TEST_TIME 65 8847
TEST_TIME 66 8943
TEST_TIME 67 8948
TEST_TIME 68 8891
TEST_TIME 69 8977
TEST_TIME 70 9147
TEST_TIME 71 9230
TEST_TIME 72 9168
TEST_TIME 73 9075
TEST_TIME 74 9008
TEST_TIME 75 8977
TEST_TIME 76 8988
TEST_TIME 77 8913
TEST_TIME 78 8946
TEST_TIME 79 8918
TEST_TIME 80 8829
TEST_TIME 81 8884
TEST_TIME 82 8830
TEST_TIME 83 8801
TEST_TIME 84 8858
TEST_TIME 85 8822
TEST_TIME 86 8827
TEST_TIME 87 8826
TEST_TIME 88 8897
TEST_TIME 89 8915
TEST_TIME 90 8980
TEST_TIME 91 9042
TEST_TIME 92 9003
TEST_TIME 93 9013
TEST_TIME 94 9042
TEST_TIME 95 9051
TEST_TIME 96 9039
TEST_TIME 97 9102
TEST_TIME 98 9034
TEST_TIME 99 8959
TEST_TIME 100 8903

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-02-2024 22:11:30 to 18-02-2024 22:11:33.

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 1246035 1246035 0 0.00 0 17142 8 0 0
doc_list_biud 1246035 1246035 0 0.00 0 56008 28 0 0
sp_add_invoice_to_stock 4197 4138 59 1.40 46 171199 21836 0 59
sp_cancel_adding_invoice 4397 4397 0 0.00 3 64344 924 0 0
sp_cancel_client_order 1427 1427 0 0.00 4 9378 386 0 0
sp_cancel_customer_reserve 429960 429960 0 0.00 0 31552 64 0 0
sp_cancel_pay_from_customer 588 588 0 0.00 3 5712 102 0 0
sp_cancel_pay_to_supplier 340 340 0 0.00 3 4674 103 0 0
sp_cancel_supplier_invoice 4917 4913 4 0.08 1 56013 775 0 4
sp_cancel_supplier_order 356 356 0 0.00 7 969279 96374 0 0
sp_cancel_write_off 7855 7855 0 0.00 1 10533 132 0 0
sp_client_order 16793 16793 0 0.00 3 21902 379 0 0
sp_customer_reserve 389799 389799 0 0.00 0 33391 212 0 0
sp_fill_shopping_cart 25779 25779 0 0.00 1 24572 39 0 0
sp_fill_shopping_cart_clo_res 389782 389782 0 0.00 0 14382 16 0 0
sp_get_clo_for_invoice 4121 4121 0 0.00 0 33727 399 0 0
sp_kill_cost_storno 13180 13180 0 0.00 0 9666 70 0 0
sp_kill_qstorno_ret_qs2qd 873044 873044 0 0.00 0 56005 34 0 0
sp_kill_qty_storno 461186 461186 0 0.00 0 56007 74 0 0
sp_lock_selected_doc 16975 16975 0 0.00 0 6688 7 0 0
sp_make_cost_storno 22889 22889 0 0.00 0 17125 81 0 0
sp_multiply_rows_for_pdistr 22889 22889 0 0.00 0 8837 37 0 0
sp_multiply_rows_for_qdistr 16793 16793 0 0.00 0 14368 158 0 0
sp_pay_from_customer 5887 5887 0 0.00 4 10641 148 0 0
sp_pay_to_supplier 4724 4724 0 0.00 5 13582 173 0 0
sp_payment_common 10611 10611 0 0.00 1 9434 36 0 0
sp_qd_handle_on_cancel_clo 1427 1427 0 0.00 0 9372 349 0 0
sp_qd_handle_on_invoice_upd_sts 8518 8518 0 0.00 0 20239 353 0 0
sp_qd_handle_on_reserve_upd_sts 8157 8157 0 0.00 0 14096 75 0 0
sp_reserve_write_off 8157 8157 0 0.00 6 14762 236 0 0
sp_supplier_invoice 4587 4587 0 0.00 6 112837 3687 0 0
sp_supplier_order 4411 4411 0 0.00 5 26968 1288 0 0
srv_aggregate_perf_data 86 85 1 1.16 2097 137680 16642 0 1
srv_fill_mon_cache_memory 56 56 0 0.00 1052 119243 38079 0 0
srv_find_qd_qs_mism 847850 847850 0 0.00 0 13038 6 0 0
srv_make_invnt_saldo 495 495 0 0.00 43 132331 1251 0 0
srv_make_money_saldo 702 702 0 0.00 1 2971 32 0 0
srv_recalc_idx_stat 3 3 0 0.00 238795 338338 292152 0 0
t$perf-abend:sp_add_invoice_to_stock 59 59 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4139 4139 0 0.00 0 11851 196 0 0
t$perf-norm:sp_cancel_adding_invoice 341 341 0 0.00 0 10557 187 0 0
t$perf-norm:sp_cancel_client_order 1427 1427 0 0.00 0 6766 18 0 0
t$perf-norm:sp_cancel_customer_reserve 564 564 0 0.00 0 3340 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 588 588 0 0.00 0 1090 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 340 340 0 0.00 0 303 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 319 319 0 0.00 0 1124 15 0 0
t$perf-norm:sp_cancel_supplier_order 356 356 0 0.00 0 32584 1906 0 0
t$perf-norm:sp_cancel_write_off 762 762 0 0.00 0 1222 9 0 0
t$perf-norm:sp_client_order 16793 16793 0 0.00 0 12241 23 0 0
t$perf-norm:sp_customer_reserve 837 837 0 0.00 0 412 4 0 0
t$perf-norm:sp_pay_from_customer 5887 5887 0 0.00 0 17703 14 0 0
t$perf-norm:sp_pay_to_supplier 4724 4724 0 0.00 0 27769 18 0 0
t$perf-norm:sp_reserve_write_off 8157 8157 0 0.00 0 9024 14 0 0
t$perf-norm:sp_supplier_invoice 4587 4587 0 0.00 0 8255 25 0 0
t$perf-norm:sp_supplier_order 4411 4411 0 0.00 0 10238 24 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 297 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 603 13 0 0
t$perf-norm:srv_make_invnt_saldo 495 495 0 0.00 0 1704 31 0 0
t$perf-norm:srv_make_money_saldo 702 702 0 0.00 0 1745 31 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 8360 8242 118 1.41 0 7581 21 0 118
v_all_customers 31118 31118 0 0.00 0 24 1 0 0
v_all_suppliers 25278 25278 0 0.00 0 66 1 0 0
v_all_wares 33586 33586 0 0.00 0 38 1 0 0
v_cancel_adding_invoice 682 682 0 0.00 0 1447 14 0 0
v_cancel_client_order 2854 2854 0 0.00 0 6793 8 0 0
v_cancel_customer_prepayment 1176 1176 0 0.00 0 1868 9 0 0
v_cancel_customer_reserve 1128 1128 0 0.00 0 4910 10 0 0
v_cancel_payment_to_supplier 680 680 0 0.00 0 3346 11 0 0
v_cancel_supplier_invoice 646 638 8 1.23 0 1216 14 0 8
v_cancel_supplier_order 712 712 0 0.00 0 1967 12 0 0
v_cancel_write_off 1524 1524 0 0.00 0 3054 17 0 0
v_max_id_clo_ord 4404 4404 0 0.00 0 1594 2 0 0
v_max_id_clo_res 837 837 0 0.00 0 917 9 0 0
v_max_id_ord_sup 4582 4582 0 0.00 0 3661 3 0 0
v_max_non_paid_invoice 1071 1071 0 0.00 0 290 3 0 0
v_max_non_paid_realizn 2923 2923 0 0.00 0 4710 6 0 0
v_min_id_clo_ord 4404 4404 0 0.00 0 8151 9 0 0
v_min_id_clo_res 837 837 0 0.00 0 6643 14 0 0
v_min_id_ord_sup 4582 4582 0 0.00 0 3447 7 0 0
v_min_non_paid_invoice 4724 4724 0 0.00 0 7735 24 0 0
v_min_non_paid_realizn 5887 5887 0 0.00 0 8618 31 0 0
v_our_firm 8396 8396 0 0.00 0 21 1 0 0
v_reserve_write_off 16314 16314 0 0.00 0 6594 8 0 0
x_lock_depdocs_on_canc_invoice 8991 8991 0 0.00 0 15039 138 0 0
x_lock_depdocs_on_canc_sup_ord 356 356 0 0.00 0 29176 449 0 0
x_make_qstorno_1000_1200 4411 4411 0 0.00 1 23652 1200 0 0
x_make_qstorno_1200_2000 4587 4587 0 0.00 3 101055 3552 0 0
x_make_qstorno_2100_3300 389799 389799 0 0.00 0 33351 192 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 18-02-2024 22:11:34 to 18-02-2024 22:11:39.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
20:09:47 3 8192000000 8798598864 8809840640 5061968 0.061 2 1 2 0 5161568 56816 42784
20:10:48 17288 8192000000 9874662864 10177306624 958152752 10.471 100 90 180 0 987392864 5007296 24232816
20:12:11 18100 8192000000 9924865152 10240946176 1009096192 10.967 100 86 172 0 1037939776 6607856 22235728
20:13:33 19453 8192000000 9956142832 10289659904 1046064864 11.323 100 74 148 0 1073068544 8328176 18675504
20:15:01 11914 8192000000 10031382160 10376196096 1115402064 11.984 100 80 158 0 1144597472 10370192 18825216
20:16:18 9964 8192000000 10083953648 10444296192 1176388256 12.556 100 83 166 0 1207352400 12027728 18936416
20:17:32 4431 8192000000 10121324560 10489200640 1213147456 12.898 100 80 160 0 1243405968 12448256 17810256
20:18:38 2266 8192000000 10156848768 10531950592 1243061888 13.174 100 80 159 0 1273178128 12160800 17955440
20:19:42 1699 8192000000 10176808960 10560000000 1270686400 13.428 100 87 172 2 1303904288 14347776 18870112
20:20:44 994 8192000000 10204520208 10587213824 1292462736 13.627 100 88 175 1 1324864672 13190736 19211200
20:21:46 25361 8192000000 10193642064 10598838272 1296122800 13.660 100 36 72 0 1312521904 8417680 7981424
20:23:13 8241 8192000000 10189668400 10602147840 1305295616 13.743 100 27 52 0 1317556752 5920224 6340912
20:24:25 10512 8192000000 10199360496 10618556416 1313180832 13.815 100 15 30 0 1321946976 5457840 3308304
20:25:40 66115 8192000000 10218902944 10639323136 1328444384 13.953 100 22 44 0 1339013952 5494624 5074944
20:27:47 6709 8192000000 10216375088 10639069184 1324867872 13.921 99 28 56 1 1337049584 5491328 6690384
20:28:55 6772 8192000000 10230834032 10646446080 1326062112 13.932 99 31 63 1 1338958928 5832608 7064208
20:30:09 5469 8192000000 10214900000 10617565184 1311384912 13.799 99 42 83 3 1328457392 6631280 10441200
20:31:20 16935 8192000000 10213452160 10626129920 1302818928 13.721 99 40 80 1 1321314192 9143296 9351968
20:33:13 39464 8192000000 10233907904 10645377024 1307090368 13.760 98 43 87 1 1327317024 10585232 9641424
20:35:08 16494 8192000000 10251608752 10664275968 1330030784 13.967 99 46 90 1 1355681888 14827936 10823168
20:36:32 7828 8192000000 10239973072 10642538496 1309516016 13.782 98 60 119 1 1339428816 14762544 15150256
20:38:02 22652 8192000000 10219463184 10619224064 1264918528 13.375 96 39 74 0 1290244080 16512400 8813152
20:39:40 19085 8192000000 10226509728 10638774272 1312370992 13.808 100 43 84 0 1343050608 20990000 9689616
20:41:05 9163 8192000000 10223941856 10623655936 1295958672 13.658 99 54 108 1 1327193152 18642864 12591616
20:42:24 12168 8192000000 10212816096 10608205824 1290446128 13.608 100 60 117 1 1327550528 23284608 13819792
20:43:40 4232 8192000000 10234617904 10626482176 1299172736 13.688 100 67 131 0 1339145856 24046144 15926976
20:44:52 4197 8192000000 10271969568 10667577344 1332930896 13.994 100 75 147 1 1374818736 23671312 18216528
20:46:01 1047 8192000000 10295341968 10693578752 1355971248 14.201 100 76 150 0 1398752752 24837968 17943536
20:47:09 5169 8192000000 10307182768 10710523904 1363923360 14.273 100 80 161 1 1411417504 27968576 19525568
20:48:19 10895 8192000000 10320599808 10725634048 1376981008 14.390 100 70 140 2 1426675488 32826288 16868192
20:49:35 1565 8192000000 10345488448 10752286720 1389744320 14.504 100 71 140 1 1447023616 39014368 18264928
20:50:39 13270 8192000000 10314349488 10738380800 1384237200 14.454 100 41 82 0 1426872016 32164720 10470096
20:52:13 5121 8192000000 10331161888 10748870656 1392821184 14.531 100 63 125 0 1437314048 28581104 15911760
20:53:23 11758 8192000000 10337509728 10764652544 1401157776 14.605 100 43 86 0 1444400480 31782976 11459728
20:54:55 23602 8192000000 10333216832 10779467776 1401634480 14.610 100 29 58 0 1447678208 37761696 8282032
20:56:20 16915 8192000000 10344642176 10773753856 1404183792 14.632 100 45 90 1 1445634640 30029104 11421744
20:57:48 23785 8192000000 10331886432 10775011328 1397189696 14.570 100 16 32 2 1433837728 32277632 4370400
20:59:13 21313 8192000000 10328052400 10769072128 1385054720 14.462 99 28 56 0 1424728112 32821776 6851616
21:00:53 1859 8192000000 10333597808 10758737920 1399249200 14.588 100 69 137 0 1428868080 14086080 15532800
21:01:57 13481 8192000000 10310705136 10760577024 1400302400 14.598 100 14 28 0 1423072448 19353696 3416352
21:04:18 84941 8192000000 10309425600 10764369920 1399632528 14.592 100 18 36 0 1418856448 14857024 4366896
21:06:44 99760 8192000000 10308826224 10770485248 1406023520 14.649 100 19 38 0 1423245872 13398816 3823536
21:09:28 12748 8192000000 10316154464 10768175104 1405068736 14.640 99 33 64 0 1423308000 10895824 7343440
21:10:43 49742 8192000000 10321271568 10774941696 1408515120 14.671 100 25 51 0 1428777376 14475936 5786320
21:12:36 20061 8192000000 10318627600 10773737472 1408809872 14.673 100 26 52 0 1433856624 19338864 5707888
21:13:59 23319 8192000000 10298425264 10746540032 1369207040 14.320 98 10 20 0 1381164464 8692208 3265216
21:15:25 64752 8192000000 10277484336 10727055360 1344581536 14.099 96 20 38 0 1358718064 9658816 4477712
21:17:30 100996 8192000000 10308572912 10765004800 1401188752 14.606 100 38 74 1 1419572048 9801888 8581408
21:20:35 38331 8192000000 10300737984 10745937920 1372690928 14.351 98 40 78 0 1392767088 10930944 9145216
21:22:19 19623 8192000000 10291718256 10732556288 1380739200 14.423 100 42 84 0 1402226432 12277392 9209840
21:23:40 58693 8192000000 10263892272 10723905536 1335586640 14.018 97 16 33 0 1354353216 14846368 3920208
21:25:39 51930 8192000000 10260432480 10706649088 1330442480 13.971 98 16 32 1 1346706448 12538016 3725952
21:27:42 51424 8192000000 10248892736 10707861504 1348779936 14.136 100 9 18 0 1364216640 13329184 2107520
21:29:34 83532 8192000000 10234763888 10678620160 1243298160 13.177 91 14 28 1 1261255136 14748864 3208112
21:32:03 25530 8192000000 10262381152 10684055552 1318555136 13.864 98 50 101 1 1341022016 11246368 11220512
21:33:32 22118 8192000000 10258234496 10688626688 1334895376 14.011 100 45 89 2 1358873984 14021264 9957344
21:35:05 70380 8192000000 10253628384 10686279680 1290473312 13.609 96 14 28 0 1310315056 16585696 3256048
21:37:16 81831 8192000000 10269837488 10719772672 1318815248 13.866 97 19 38 0 1343972544 20655456 4501840
21:39:38 83349 8192000000 10281750992 10736783360 1348636784 14.135 98 8 16 1 1365635856 15660976 1338096
21:42:02 119243 8192000000 10267638048 10711199744 1331734352 13.983 97 29 58 0 1347162432 9019376 6408704
21:45:05 48059 8192000000 10259895696 10717265920 1346859376 14.119 98 14 28 0 1359310384 9387856 3063152
21:47:18 41215 8192000000 10275047152 10736480256 1378398944 14.402 100 7 14 0 1394729696 14822128 1508624
21:48:59 80536 8192000000 10277748592 10733723648 1359180800 14.230 98 14 27 0 1374291728 12044768 3066160
21:52:33 71537 8192000000 10294333472 10758443008 1403217296 14.624 100 12 24 1 1415251184 9382464 2651424
21:55:00 33778 8192000000 10326425664 10774896640 1414485664 14.724 100 25 50 0 1436869088 16839376 5544048
21:56:39 60362 8192000000 10328407984 10787696640 1402393072 14.616 99 21 42 0 1421390480 14093216 4904192
21:59:01 52149 8192000000 10320613712 10785058816 1388173568 14.490 98 19 38 0 1406698960 14405712 4119680
22:00:59 104315 8192000000 10317498368 10771828736 1368465872 14.313 97 20 40 0 1385259360 12697888 4095600
22:03:43 49872 8192000000 10307856848 10757816320 1372695984 14.351 98 24 48 0 1391169728 12582256 5891488
22:05:35 29849 8192000000 10294887232 10732924928 1354971952 14.192 97 25 50 0 1370005856 9790288 5243616
22:07:09 84713 8192000000 10281069952 10729099264 1368800496 14.316 99 17 34 0 1383434848 10580832 4053520
22:09:41 6167 8192000000 9762190896 10135232512 896878400 9.867 65 6 12 0 908742768 10925248 939120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 18-02-2024 22:11:40 to 18-02-2024 22:11:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 59 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

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

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          171406
MON$OLDEST_ACTIVE               172224
MON$OLDEST_SNAPSHOT             172224
MON$NEXT_TRANSACTION            172224
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                       1903008
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.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 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 Feb 18 22:11:58 2024 
 
Database header page information: 
    Flags            0 
    Generation        89659 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    171406 
    Oldest active        172224 
    Oldest snapshot        172224 
    Next transaction    172225 
    Sequence number        0 
    Next attachment ID    700 
    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.64, total records: 7698710 
    Average version length: 48.15, total versions: 40125, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87088 
    Data pages: 87088, average fill: 71% 
    Primary pages: 87088, secondary pages: 0, swept pages: 39535 
    Empty pages: 6, full pages: 51021 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 323 
    40 - 59% = 3825 
    60 - 79% = 82902 
    80 - 99% = 12 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23148, nodes: 7698710 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1685804, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 306 
        20 - 39% = 1918 
        40 - 59% = 4048 
        60 - 79% = 2467 
        80 - 99% = 14409 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13449, nodes: 7698710 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1509603, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1638 
        40 - 59% = 1969 
        60 - 79% = 1140 
        80 - 99% = 8702 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8327, nodes: 7698710 
    Average node length: 6.61, total dup: 5767039, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1502673, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 1005 
        40 - 59% = 1346 
        60 - 79% = 968 
        80 - 99% = 4859 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.92, total records: 2222109 
    Average version length: 34.95, total versions: 39406, max versions: 4 
    Average fragment length: 6.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28608 
    Data pages: 28608, average fill: 72% 
    Primary pages: 28600, secondary pages: 8, swept pages: 17086 
    Empty pages: 9, full pages: 16703 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 185 
    40 - 59% = 2173 
    60 - 79% = 25970 
    80 - 99% = 253 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4526, nodes: 2222109 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 672901, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 940 
        40 - 59% = 815 
        60 - 79% = 758 
        80 - 99% = 2013 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2505, nodes: 2223872 
    Average node length: 4.97, total dup: 2222973, max dup: 19806 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1236658, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 279 
        40 - 59% = 1545 
        60 - 79% = 502 
        80 - 99% = 178 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2014, nodes: 2222109 
    Average node length: 4.97, total dup: 2222059, max dup: 130267 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1057603, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 108 
        40 - 59% = 986 
        60 - 79% = 44 
        80 - 99% = 870 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4343, nodes: 2222109 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 672901, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 589 
        40 - 59% = 603 
        60 - 79% = 859 
        80 - 99% = 2165 
 
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.50, total records: 400 
    Average version length: 23.18, total versions: 237820, max versions: 616 
    Average fragment length: 2.00, total fragments: 45, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1312 
    Data pages: 1312, average fill: 91% 
    Primary pages: 8, secondary pages: 1304, swept pages: 0 
    Empty pages: 1, full pages: 1310 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1310 
 
    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: 10.49, total records: 69408 
    Average version length: 68.28, total versions: 58741, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.39 
    Pointer pages: 7, data page slots: 3344 
    Data pages: 1608, average fill: 54% 
    Primary pages: 1607, secondary pages: 1, swept pages: 112 
    Empty pages: 336, full pages: 719 
    Fill distribution: 
     0 - 19% = 439 
    20 - 39% = 128 
    40 - 59% = 178 
    60 - 79% = 272 
    80 - 99% = 591 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1712684, depth: 3, leaf buckets: 264, nodes: 69408 
    Average node length: 13.71, total dup: 3813, max dup: 2 
    Average key length: 10.90, compression ratio: 2.48 
    Average prefix length: 19.05, average data length: 7.95 
    Clustering factor: 53625, ratio: 0.77 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 119 
        40 - 59% = 110 
        60 - 79% = 34 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18032, max versions: 998 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 81% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 12 
    80 - 99% = 53 
 
    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: 2.61, total records: 1326 
    Average version length: 43.39, total versions: 1246, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 22.24 
    Pointer pages: 1, data page slots: 32 
    Data pages: 26, average fill: 50% 
    Primary pages: 25, secondary pages: 1, swept pages: 5 
    Empty pages: 6, full pages: 8 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89995, depth: 2, leaf buckets: 2, nodes: 1326 
    Average node length: 4.65, total dup: 1228, max dup: 137 
    Average key length: 2.78, compression ratio: 6.83 
    Average prefix length: 18.29, average data length: 0.71 
    Clustering factor: 732, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.01, 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: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    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.68, total records: 785419 
    Average version length: 25.75, total versions: 43487, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8208 
    Data pages: 8208, average fill: 66% 
    Primary pages: 8185, secondary pages: 23, swept pages: 3311 
    Empty pages: 107, full pages: 4214 
    Fill distribution: 
     0 - 19% = 230 
    20 - 39% = 159 
    40 - 59% = 497 
    60 - 79% = 7201 
    80 - 99% = 121 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 892, nodes: 785419 
    Average node length: 4.87, total dup: 785370, max dup: 147216 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87586, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 157 
        40 - 59% = 517 
        60 - 79% = 164 
        80 - 99% = 54 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 980, nodes: 785419 
    Average node length: 5.88, total dup: 699450, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156099, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 121 
        40 - 59% = 505 
        60 - 79% = 120 
        80 - 99% = 232 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1013, nodes: 785419 
    Average node length: 5.88, total dup: 699450, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158013, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 204 
        40 - 59% = 461 
        60 - 79% = 120 
        80 - 99% = 227 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1147, nodes: 785419 
    Average node length: 5.96, total dup: 699450, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151035, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 288 
        40 - 59% = 580 
        60 - 79% = 204 
        80 - 99% = 71 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5394 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.91, total fragments: 80, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 72, secondary pages: 24, swept pages: 61 
    Empty pages: 11, full pages: 62 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 67 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5394 
    Average node length: 5.53, total dup: 0, max dup: 0 
    Average key length: 3.60, compression ratio: 9.95 
    Average prefix length: 34.29, average data length: 1.56 
    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: 5394 
    Average node length: 11.14, 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: 148, 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.14, total records: 78694 
    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: 0, full pages: 758 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 758 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 31769, depth: 2, leaf buckets: 102, nodes: 78694 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3236, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 1 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, 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.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 132.96, total records: 191942 
    Average version length: 154.17, total versions: 22828, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.76 
    Pointer pages: 7, data page slots: 5288 
    Data pages: 4640, average fill: 86% 
    Primary pages: 4640, secondary pages: 0, swept pages: 1 
    Empty pages: 71, full pages: 4541 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 10 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4541 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 138.40, total records: 185799 
    Average version length: 153.02, total versions: 15499, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.25 
    Pointer pages: 7, data page slots: 5368 
    Data pages: 4520, average fill: 85% 
    Primary pages: 4520, secondary pages: 0, swept pages: 1 
    Empty pages: 100, full pages: 4394 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 4395 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.00, total records: 177523 
    Average version length: 149.42, total versions: 3576, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 8, data page slots: 5184 
    Data pages: 4304, average fill: 85% 
    Primary pages: 4304, secondary pages: 0, swept pages: 3 
    Empty pages: 90, full pages: 4198 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4197 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.70, total records: 177958 
    Average version length: 149.58, total versions: 3805, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 6376 
    Data pages: 4288, average fill: 86% 
    Primary pages: 4288, secondary pages: 0, swept pages: 1 
    Empty pages: 63, full pages: 4201 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 4200 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 144.91, total records: 170411 
    Average version length: 151.74, total versions: 6982, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 8, data page slots: 6552 
    Data pages: 4136, average fill: 85% 
    Primary pages: 4136, secondary pages: 0, swept pages: 6 
    Empty pages: 81, full pages: 4025 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 7 
    40 - 59% = 10 
    60 - 79% = 8 
    80 - 99% = 4025 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 145.42, total records: 175235 
    Average version length: 151.27, total versions: 6424, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 7, data page slots: 5512 
    Data pages: 4248, average fill: 85% 
    Primary pages: 4248, secondary pages: 0, swept pages: 4 
    Empty pages: 83, full pages: 4137 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 9 
    40 - 59% = 10 
    60 - 79% = 8 
    80 - 99% = 4135 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 140.66, total records: 176978 
    Average version length: 152.84, total versions: 11931, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.06 
    Pointer pages: 7, data page slots: 5472 
    Data pages: 4272, average fill: 86% 
    Primary pages: 4272, secondary pages: 0, swept pages: 3 
    Empty pages: 67, full pages: 4181 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4181 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 139.58, total records: 184864 
    Average version length: 153.68, total versions: 13902, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.15 
    Pointer pages: 6, data page slots: 6624 
    Data pages: 4512, average fill: 85% 
    Primary pages: 4512, secondary pages: 0, swept pages: 7 
    Empty pages: 115, full pages: 4368 
    Fill distribution: 
     0 - 19% = 117 
    20 - 39% = 12 
    40 - 59% = 4 
    60 - 79% = 11 
    80 - 99% = 4368 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 146.61, total records: 169560 
    Average version length: 151.59, total versions: 4784, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 7, data page slots: 6688 
    Data pages: 4080, average fill: 86% 
    Primary pages: 4080, secondary pages: 0, swept pages: 3 
    Empty pages: 55, full pages: 4008 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4008 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 145.80, total records: 167365 
    Average version length: 151.67, total versions: 5302, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 6, data page slots: 4784 
    Data pages: 4016, average fill: 86% 
    Primary pages: 4016, secondary pages: 0, swept pages: 8 
    Empty pages: 52, full pages: 3943 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 3941 
 
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: 52.18, total records: 2089997 
    Average version length: 52.88, total versions: 22234, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25728 
    Data pages: 25720, average fill: 70% 
    Primary pages: 25720, secondary pages: 0, swept pages: 12503 
    Empty pages: 366, full pages: 19511 
    Fill distribution: 
     0 - 19% = 674 
    20 - 39% = 491 
    40 - 59% = 1423 
    60 - 79% = 22976 
    80 - 99% = 156 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2605, nodes: 2089997 
    Average node length: 5.44, total dup: 1949660, max dup: 1307 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180358, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 333 
        40 - 59% = 1709 
        60 - 79% = 285 
        80 - 99% = 273 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2758, nodes: 2089997 
    Average node length: 5.69, total dup: 1875562, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372746, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 2421 
        60 - 79% = 307 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2127, nodes: 2089997 
    Average node length: 4.96, total dup: 2089897, max dup: 28080 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178199, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 209 
        40 - 59% = 1124 
        60 - 79% = 358 
        80 - 99% = 434 
 
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: 48.66, total records: 130445 
    Average version length: 69.17, total versions: 38744, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.59 
    Pointer pages: 3, data page slots: 4360 
    Data pages: 3120, average fill: 48% 
    Primary pages: 3120, secondary pages: 0, swept pages: 530 
    Empty pages: 542, full pages: 726 
    Fill distribution: 
     0 - 19% = 703 
    20 - 39% = 279 
    40 - 59% = 813 
    60 - 79% = 940 
    80 - 99% = 385 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 99264, depth: 3, leaf buckets: 237, nodes: 130445 
    Average node length: 6.55, total dup: 113572, max dup: 14 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22186, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 83 
        40 - 59% = 124 
        60 - 79% = 26 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.78, total records: 6943315 
    Average version length: 68.79, total versions: 220113, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 64, data page slots: 103624 
    Data pages: 103624, average fill: 72% 
    Primary pages: 103624, secondary pages: 0, swept pages: 56854 
    Empty pages: 7, full pages: 55583 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 477 
    40 - 59% = 8506 
    60 - 79% = 92374 
    80 - 99% = 2228 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10814, nodes: 6943315 
    Average node length: 6.51, total dup: 6007767, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1536260, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1926 
        40 - 59% = 6074 
        60 - 79% = 2463 
        80 - 99% = 344 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8508, nodes: 6943315 
    Average node length: 5.40, total dup: 6666142, max dup: 135 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1336361, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1348 
        40 - 59% = 4576 
        60 - 79% = 1738 
        80 - 99% = 839 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8568, nodes: 6943315 
    Average node length: 5.40, total dup: 6666142, max dup: 135 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1338902, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1412 
        40 - 59% = 4548 
        60 - 79% = 1754 
        80 - 99% = 851 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.79, total records: 11945680 
    Average version length: 68.76, total versions: 202316, 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: 104, data page slots: 169040 
    Data pages: 169040, average fill: 75% 
    Primary pages: 169040, secondary pages: 0, swept pages: 107364 
    Empty pages: 1, full pages: 135311 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 318 
    40 - 59% = 4831 
    60 - 79% = 160579 
    80 - 99% = 3288 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18407, nodes: 11945680 
    Average node length: 6.59, total dup: 10417112, max dup: 54 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2339951, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 2575 
        40 - 59% = 10801 
        60 - 79% = 4264 
        80 - 99% = 737 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 51.97, total records: 1332598 
    Average version length: 69.06, total versions: 331223, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.42 
    Pointer pages: 28, data page slots: 44856 
    Data pages: 29696, average fill: 51% 
    Primary pages: 29694, secondary pages: 2, swept pages: 14888 
    Empty pages: 5416, full pages: 13453 
    Fill distribution: 
     0 - 19% = 8074 
    20 - 39% = 3127 
    40 - 59% = 2971 
    60 - 79% = 10763 
    80 - 99% = 4761 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2296, nodes: 1332598 
    Average node length: 5.55, total dup: 1277675, max dup: 95 
    Average key length: 2.59, compression ratio: 16.22 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 91654, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1268 
        40 - 59% = 861 
        60 - 79% = 151 
        80 - 99% = 10 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 54.07, total records: 820473 
    Average version length: 69.14, total versions: 177546, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.33 
    Pointer pages: 22, data page slots: 35864 
    Data pages: 28688, average fill: 33% 
    Primary pages: 28688, secondary pages: 0, swept pages: 13032 
    Empty pages: 7043, full pages: 2173 
    Fill distribution: 
     0 - 19% = 11370 
    20 - 39% = 4862 
    40 - 59% = 6566 
    60 - 79% = 5077 
    80 - 99% = 813 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1497, nodes: 820473 
    Average node length: 5.86, total dup: 762327, max dup: 95 
    Average key length: 2.93, compression ratio: 14.33 
    Average prefix length: 41.14, average data length: 0.86 
    Clustering factor: 113867, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 843 
        40 - 59% = 557 
        60 - 79% = 88 
        80 - 99% = 8 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 8906716 
    Average version length: 68.98, total versions: 179486, 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: 88, data page slots: 142768 
    Data pages: 142744, average fill: 67% 
    Primary pages: 142744, secondary pages: 0, swept pages: 94225 
    Empty pages: 407, full pages: 61884 
    Fill distribution: 
     0 - 19% = 1291 
    20 - 39% = 6400 
    40 - 59% = 27343 
    60 - 79% = 105302 
    80 - 99% = 2408 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13489, nodes: 8906716 
    Average node length: 6.68, total dup: 7385164, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1900674, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1626 
        40 - 59% = 7206 
        60 - 79% = 4205 
        80 - 99% = 448 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21115724 
    Average version length: 82.60, total versions: 3361, 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: 318400 
    Data pages: 318400, average fill: 81% 
    Primary pages: 318400, secondary pages: 0, swept pages: 13439 
    Empty pages: 31, full pages: 317063 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 61 
    40 - 59% = 204 
    60 - 79% = 28063 
    80 - 99% = 290008 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19457, nodes: 21115724 
    Average node length: 5.72, total dup: 20635255, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3274750, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8349 
        60 - 79% = 527 
        80 - 99% = 10575 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17161, nodes: 21115724 
    Average node length: 6.31, total dup: 18556596, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 912315, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 824 
        60 - 79% = 279 
        80 - 99% = 16056 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21215, nodes: 21115724 
    Average node length: 6.35, total dup: 18475171, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3568869, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 4 
        40 - 59% = 8570 
        60 - 79% = 596 
        80 - 99% = 12043 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 15994, nodes: 21115724 
    Average node length: 5.56, total dup: 21115624, max dup: 229980 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941100, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 17 
        40 - 59% = 2704 
        60 - 79% = 396 
        80 - 99% = 12876 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 74.31, total records: 10183840 
    Average version length: 82.62, total versions: 1001251, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.70 
    Pointer pages: 104, data page slots: 168200 
    Data pages: 168160, average fill: 75% 
    Primary pages: 168160, secondary pages: 0, swept pages: 35151 
    Empty pages: 359, full pages: 131552 
    Fill distribution: 
     0 - 19% = 1099 
    20 - 39% = 4133 
    40 - 59% = 16592 
    60 - 79% = 46882 
    80 - 99% = 99454 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11352, nodes: 10183840 
    Average node length: 5.35, total dup: 9872407, max dup: 229 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2235240, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 29 
        40 - 59% = 6545 
        60 - 79% = 4586 
        80 - 99% = 189 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13668, nodes: 10183840 
    Average node length: 6.22, total dup: 8446227, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1556123, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 153 
        20 - 39% = 3351 
        40 - 59% = 4698 
        60 - 79% = 2615 
        80 - 99% = 2851 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12670, nodes: 10183840 
    Average node length: 5.96, total dup: 8869169, max dup: 54 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2445940, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 46 
        40 - 59% = 7508 
        60 - 79% = 4895 
        80 - 99% = 220 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10372, nodes: 10183840 
    Average node length: 5.13, total dup: 10183740, max dup: 171921 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1584637, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1030 
        40 - 59% = 5290 
        60 - 79% = 1731 
        80 - 99% = 2296 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 81.43, total records: 11057327 
    Average version length: 82.44, total versions: 116799, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 118, data page slots: 192408 
    Data pages: 190624, average fill: 71% 
    Primary pages: 190624, secondary pages: 0, swept pages: 83888 
    Empty pages: 3801, full pages: 135232 
    Fill distribution: 
     0 - 19% = 6568 
    20 - 39% = 9384 
    40 - 59% = 20459 
    60 - 79% = 44989 
    80 - 99% = 109224 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13129, nodes: 11057327 
    Average node length: 5.29, total dup: 10948067, max dup: 640 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2300940, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 218 
        40 - 59% = 9655 
        60 - 79% = 3153 
        80 - 99% = 102 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10279, nodes: 11057327 
    Average node length: 5.49, total dup: 10573329, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 694282, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 180 
        20 - 39% = 860 
        40 - 59% = 2492 
        60 - 79% = 1925 
        80 - 99% = 4822 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15023, nodes: 11057327 
    Average node length: 6.02, total dup: 9644037, max dup: 73 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2317287, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 260 
        40 - 59% = 11145 
        60 - 79% = 3497 
        80 - 99% = 115 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10512, nodes: 11057327 
    Average node length: 5.21, total dup: 11057227, max dup: 205917 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 683464, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 916 
        40 - 59% = 4596 
        60 - 79% = 1411 
        80 - 99% = 3501 
 
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: 74.48, total records: 10326125 
    Average version length: 82.91, total versions: 1029899, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.69 
    Pointer pages: 106, data page slots: 171512 
    Data pages: 171448, average fill: 75% 
    Primary pages: 171448, secondary pages: 0, swept pages: 34379 
    Empty pages: 574, full pages: 134628 
    Fill distribution: 
     0 - 19% = 1407 
    20 - 39% = 4421 
    40 - 59% = 17316 
    60 - 79% = 47209 
    80 - 99% = 101095 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12161, nodes: 10326125 
    Average node length: 5.17, total dup: 10296177, max dup: 1849 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2065023, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1271 
        40 - 59% = 8011 
        60 - 79% = 2185 
        80 - 99% = 669 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13801, nodes: 10326125 
    Average node length: 6.24, total dup: 8563383, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1526998, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 205 
        20 - 39% = 3256 
        40 - 59% = 4739 
        60 - 79% = 2611 
        80 - 99% = 2990 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12808, nodes: 10326125 
    Average node length: 5.42, total dup: 9872817, max dup: 110 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2204721, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1249 
        40 - 59% = 8945 
        60 - 79% = 1940 
        80 - 99% = 647 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10531, nodes: 10326125 
    Average node length: 5.14, total dup: 10326025, max dup: 175296 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1609176, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 982 
        40 - 59% = 5416 
        60 - 79% = 1755 
        80 - 99% = 2351 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.30, total records: 585034 
    Average version length: 68.83, total versions: 16038, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 5, data page slots: 7968 
    Data pages: 7968, average fill: 77% 
    Primary pages: 7968, secondary pages: 0, swept pages: 2261 
    Empty pages: 7, full pages: 7662 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 10 
    40 - 59% = 68 
    60 - 79% = 7507 
    80 - 99% = 375 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 28733, depth: 3, leaf buckets: 734, nodes: 585034 
    Average node length: 5.95, total dup: 498247, max dup: 89 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101859, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 19 
        40 - 59% = 516 
        60 - 79% = 100 
        80 - 99% = 98 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 21837, depth: 3, leaf buckets: 760, nodes: 585034 
    Average node length: 6.15, total dup: 479841, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101921, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 18 
        40 - 59% = 532 
        60 - 79% = 109 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 580, nodes: 585034 
    Average node length: 4.86, total dup: 584934, max dup: 9564 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90336, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 350 
        60 - 79% = 100 
        80 - 99% = 109 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Feb 18 22:12:22 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7698710 40125 1 0.0000 0.0000
DOC_LIST 2222109 39406 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 237820 616 59400.0000 0.0000
INVNT_TURNOVER_LOG 69408 58741 1 0.0000 0.0000
MONEY_SALDO 49 18032 998 36800.0000 0.0000
MONEY_TURNOVER_LOG 1326 1246 1 0.0000 0.0000
PDISTR 785419 43487 5 0.0000 0.0000
PERF_SPLIT_0 191942 22828 1 0.0000 0.0000
PERF_SPLIT_1 185799 15499 1 0.0000 0.0000
PERF_SPLIT_2 177523 3576 1 0.0000 0.0000
PERF_SPLIT_3 177958 3805 1 0.0000 0.0000
PERF_SPLIT_4 170411 6982 1 0.0000 0.0000
PERF_SPLIT_5 175235 6424 1 0.0000 0.0000
PERF_SPLIT_6 176978 11931 1 0.0000 0.0000
PERF_SPLIT_7 184864 13902 1 0.0000 0.0000
PERF_SPLIT_8 169560 4784 1 0.0000 0.0000
PERF_SPLIT_9 167365 5302 1 0.0000 0.0000
PSTORNED 2089997 22234 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 130445 38744 1 0.0000 0.0000
XQD_1000_3300 6943315 220113 1 0.0000 0.0000
XQD_1200_2000 11945680 202316 1 0.0000 0.0000
XQD_2000_3300 1332598 331223 1 0.0000 0.0000
XQD_2100_3300 820473 177546 1 0.0000 0.0000
XQD_3300_3400 8906716 179486 1 0.0000 0.0000
XQS_1000_1200 21115724 3361 1 0.0000 0.0000
XQS_1000_3300 10183840 1001251 1 0.0000 0.0000
XQS_1200_2000 11057327 116799 1 0.0000 0.0000
XQS_2100_3300 10326125 1029899 1 0.0000 0.0000
XQS_3300_3400 585034 16038 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 ---
:790: 
:791: mscs-test-161.budzdorov.ru    Sun Feb 18 22:09:57 2024
:792:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:793: 
:794: 
:795: mscs-test-161.budzdorov.ru    Sun Feb 18 22:09:59 2024
:796:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:797: 
:798: 
:799: mscs-test-161.budzdorov.ru    Sun Feb 18 22:10:02 2024
:800:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:801: 
--- end of diff output ---

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

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