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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-30 01:09:44
DTS_END                         2024-03-30 01:09:44.2770
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44938
TRN_ID                          176745
ATT_ID                          547
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: 9072.68 24064 907268
customer order: creation 176.24 332 17624
customer order: refuse 15.02 380 1502
order to supplier: creation 46.49 1277 4649
order to supplier: removal 3.67 98905 367
invoice (draft): creation 47.09 3410 4709
invoice (draft): removal 49.16 829 4916
invoice accept: apply 42.01 21717 4201
invoice accept: cancel 44.43 843 4443
customer reserve: creation 3982.37 211 398237
customer reserve: removal 4367.04 64 436704
realization accept: apply 85.19 197 8519
realization accept: cancel 80.71 126 8071
payment from customer: creation 60.44 107 6044
payment from customer: removal 5.52 71 552
payment to supplier: creation 51.17 144 5117
payment to supplier: removal 3.92 98 392
service: total inventory turnovers 4.71 1183 471
service: total monetary turnovers 6.65 27 665
service: aggregate perf. data 0.82 19378 82
service: refresh index statistics 0.03 331980 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-03-2024 01:10:57 to 30-03-2024 01:10:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 624
TEST_TIME 2 1353
TEST_TIME 3 2220
TEST_TIME 4 3122
TEST_TIME 5 3621
TEST_TIME 6 4120
TEST_TIME 7 4045
TEST_TIME 8 4365
TEST_TIME 9 4366
TEST_TIME 10 4310
TEST_TIME 11 4522
TEST_TIME 12 4571
TEST_TIME 13 4623
TEST_TIME 14 4882
TEST_TIME 15 5390
TEST_TIME 16 5612
TEST_TIME 17 5831
TEST_TIME 18 6209
TEST_TIME 19 6343
TEST_TIME 20 6607
TEST_TIME 21 7200
TEST_TIME 22 7640
TEST_TIME 23 7981
TEST_TIME 24 8089
TEST_TIME 25 8423
TEST_TIME 26 8526
TEST_TIME 27 9105
TEST_TIME 28 8964
TEST_TIME 29 8986
TEST_TIME 30 8996
TEST_TIME 31 8801
TEST_TIME 32 8685
TEST_TIME 33 8947
TEST_TIME 34 8812
TEST_TIME 35 8791
TEST_TIME 36 8696
TEST_TIME 37 8783
TEST_TIME 38 8710
TEST_TIME 39 8686
TEST_TIME 40 8706
TEST_TIME 41 8795
TEST_TIME 42 8721
TEST_TIME 43 8599
TEST_TIME 44 8597
TEST_TIME 45 8725
TEST_TIME 46 8794
TEST_TIME 47 8760
TEST_TIME 48 8755
TEST_TIME 49 8899
TEST_TIME 50 8857
TEST_TIME 51 8842
TEST_TIME 52 8864
TEST_TIME 53 8878
TEST_TIME 54 8838
TEST_TIME 55 8900
TEST_TIME 56 8996
TEST_TIME 57 8980
TEST_TIME 58 9141
TEST_TIME 59 9205
TEST_TIME 60 9146
TEST_TIME 61 9055
TEST_TIME 62 9028
TEST_TIME 63 9020
TEST_TIME 64 8981
TEST_TIME 65 8970
TEST_TIME 66 9007
TEST_TIME 67 8928
TEST_TIME 68 8918
TEST_TIME 69 8913
TEST_TIME 70 8885
TEST_TIME 71 8899
TEST_TIME 72 8869
TEST_TIME 73 8930
TEST_TIME 74 8944
TEST_TIME 75 8935
TEST_TIME 76 8902
TEST_TIME 77 8989
TEST_TIME 78 9057
TEST_TIME 79 9034
TEST_TIME 80 9032
TEST_TIME 81 9175
TEST_TIME 82 9135
TEST_TIME 83 9163
TEST_TIME 84 9178
TEST_TIME 85 9207
TEST_TIME 86 9251
TEST_TIME 87 9179
TEST_TIME 88 9139
TEST_TIME 89 9157
TEST_TIME 90 9125
TEST_TIME 91 9114
TEST_TIME 92 9105
TEST_TIME 93 9060
TEST_TIME 94 9006
TEST_TIME 95 8989
TEST_TIME 96 9069
TEST_TIME 97 9040
TEST_TIME 98 9055
TEST_TIME 99 9044
TEST_TIME 100 9073

Performance per minute, chart


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

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 1272567 1272567 0 0.00 0 25992 8 0 0
doc_list_biud 1272567 1272567 0 0.00 0 91326 28 0 0
sp_add_invoice_to_stock 4321 4201 120 2.77 40 156621 21718 0 120
sp_cancel_adding_invoice 4443 4443 0 0.00 5 63616 844 0 0
sp_cancel_client_order 1502 1502 0 0.00 4 8672 380 0 0
sp_cancel_customer_reserve 436704 436704 0 0.00 0 16905 65 0 0
sp_cancel_pay_from_customer 552 552 0 0.00 2 3648 72 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 5138 99 0 0
sp_cancel_supplier_invoice 4924 4916 8 0.16 1 91346 830 0 8
sp_cancel_supplier_order 367 367 0 0.00 10 1053431 98906 0 0
sp_cancel_write_off 8071 8071 0 0.00 1 8896 127 0 0
sp_client_order 17624 17624 0 0.00 3 32033 332 0 0
sp_customer_reserve 398237 398237 0 0.00 0 40712 212 0 0
sp_fill_shopping_cart 26966 26966 0 0.00 1 37001 40 0 0
sp_fill_shopping_cart_clo_res 398237 398237 0 0.00 0 18021 15 0 0
sp_get_clo_for_invoice 4201 4201 0 0.00 0 21880 328 0 0
sp_kill_cost_storno 13458 13458 0 0.00 0 25986 76 0 0
sp_kill_qstorno_ret_qs2qd 886762 886762 0 0.00 0 91315 35 0 0
sp_kill_qty_storno 468723 468723 0 0.00 0 91320 75 0 0
sp_lock_selected_doc 17753 17753 0 0.00 0 8163 5 0 0
sp_make_cost_storno 23881 23881 0 0.00 0 20554 65 0 0
sp_multiply_rows_for_pdistr 23881 23881 0 0.00 0 16318 33 0 0
sp_multiply_rows_for_qdistr 17624 17624 0 0.00 0 17070 145 0 0
sp_pay_from_customer 6044 6044 0 0.00 4 11990 108 0 0
sp_pay_to_supplier 5117 5117 0 0.00 5 16407 144 0 0
sp_payment_common 11161 11161 0 0.00 1 11976 31 0 0
sp_qd_handle_on_cancel_clo 1502 1502 0 0.00 0 8522 345 0 0
sp_qd_handle_on_invoice_upd_sts 8644 8644 0 0.00 0 37331 325 0 0
sp_qd_handle_on_reserve_upd_sts 8519 8519 0 0.00 0 17109 58 0 0
sp_reserve_write_off 8519 8519 0 0.00 6 29332 197 0 0
sp_supplier_invoice 4709 4709 0 0.00 6 96341 3411 0 0
sp_supplier_order 4649 4649 0 0.00 4 81244 1278 0 0
srv_aggregate_perf_data 82 82 0 0.00 1944 270140 19379 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 2223 119509 36259 0 0
srv_find_qd_qs_mism 864599 864599 0 0.00 0 16858 7 0 0
srv_make_invnt_saldo 471 471 0 0.00 40 95999 1184 0 0
srv_make_money_saldo 665 665 0 0.00 1 964 28 0 0
srv_recalc_idx_stat 3 3 0 0.00 293697 402771 331980 0 0
t$perf-abend:sp_add_invoice_to_stock 120 120 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4201 4201 0 0.00 0 11134 193 0 0
t$perf-norm:sp_cancel_adding_invoice 340 340 0 0.00 0 13199 163 0 0
t$perf-norm:sp_cancel_client_order 1502 1502 0 0.00 0 2590 16 0 0
t$perf-norm:sp_cancel_customer_reserve 596 596 0 0.00 0 2014 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 552 552 0 0.00 0 4193 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 663 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 369 369 0 0.00 0 5938 35 0 0
t$perf-norm:sp_cancel_supplier_order 367 367 0 0.00 0 41054 1884 0 0
t$perf-norm:sp_cancel_write_off 915 915 0 0.00 0 5233 12 0 0
t$perf-norm:sp_client_order 17624 17624 0 0.00 0 7440 18 0 0
t$perf-norm:sp_customer_reserve 868 868 0 0.00 0 6986 15 0 0
t$perf-norm:sp_pay_from_customer 6044 6044 0 0.00 0 4464 7 0 0
t$perf-norm:sp_pay_to_supplier 5117 5117 0 0.00 0 6928 14 0 0
t$perf-norm:sp_reserve_write_off 8519 8519 0 0.00 0 14661 13 0 0
t$perf-norm:sp_supplier_invoice 4709 4709 0 0.00 0 8024 19 0 0
t$perf-norm:sp_supplier_order 4649 4649 0 0.00 0 6936 20 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 148 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 117 3 0 0
t$perf-norm:srv_make_invnt_saldo 471 471 0 0.00 0 747 25 0 0
t$perf-norm:srv_make_money_saldo 665 665 0 0.00 0 2743 23 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 17 7 0 0
v_add_invoice_to_stock 8642 8402 240 2.77 0 3215 18 0 240
v_all_customers 32736 32736 0 0.00 0 21 1 0 0
v_all_suppliers 26478 26478 0 0.00 0 20 1 0 0
v_all_wares 35246 35246 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 680 680 0 0.00 0 86 5 0 0
v_cancel_client_order 3004 3004 0 0.00 0 7497 6 0 0
v_cancel_customer_prepayment 1104 1104 0 0.00 0 1239 3 0 0
v_cancel_customer_reserve 1192 1192 0 0.00 0 752 4 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 1472 8 0 0
v_cancel_supplier_invoice 754 738 16 2.12 0 918 14 0 16
v_cancel_supplier_order 734 734 0 0.00 0 2709 9 0 0
v_cancel_write_off 1830 1830 0 0.00 0 1887 13 0 0
v_max_id_clo_ord 4649 4649 0 0.00 0 221 1 0 0
v_max_id_clo_res 868 868 0 0.00 0 3788 23 0 0
v_max_id_ord_sup 4693 4693 0 0.00 0 16082 6 0 0
v_max_non_paid_invoice 1220 1220 0 0.00 0 6860 11 0 0
v_max_non_paid_realizn 2945 2945 0 0.00 0 4794 8 0 0
v_min_id_clo_ord 4649 4649 0 0.00 0 4499 7 0 0
v_min_id_clo_res 868 868 0 0.00 0 6645 19 0 0
v_min_id_ord_sup 4693 4693 0 0.00 0 32013 19 0 0
v_min_non_paid_invoice 5117 5117 0 0.00 0 5383 21 0 0
v_min_non_paid_realizn 6044 6044 0 0.00 0 11892 21 0 0
v_our_firm 8708 8708 0 0.00 0 23 1 0 0
v_reserve_write_off 17038 17038 0 0.00 0 4528 5 0 0
x_lock_depdocs_on_canc_invoice 8990 8990 0 0.00 0 29991 161 0 0
x_lock_depdocs_on_canc_sup_ord 367 367 0 0.00 0 15286 373 0 0
x_make_qstorno_1000_1200 4649 4649 0 0.00 1 81233 1202 0 0
x_make_qstorno_1200_2000 4709 4709 0 0.00 2 96311 3252 0 0
x_make_qstorno_2100_3300 398237 398237 0 0.00 0 40032 193 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-03-2024 01:11:05 to 30-03-2024 01:11:09.

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
23:09:48 11 8192000000 8803652400 8816594944 8754480 0.106 3 2 3 0 8896912 67472 74960
23:10:49 36944 8192000000 9912210656 10224427008 983130496 10.715 100 78 156 0 1009217360 5752768 20334096
23:12:32 21413 8192000000 9969309456 10296963072 1053081216 11.390 100 94 188 0 1084990736 8454512 23455008
23:14:09 16026 8192000000 9999212096 10335752192 1083374144 11.680 100 88 176 0 1115073136 10385136 21313856
23:15:28 8094 8192000000 10040976448 10390241280 1129099616 12.113 100 81 162 0 1159422608 11401440 18921552
23:16:38 6554 8192000000 10080156480 10443726848 1173856592 12.533 100 73 146 0 1202169312 11521376 16791344
23:17:47 3438 8192000000 10118620736 10490167296 1212954304 12.896 100 81 161 0 1243772624 13186640 17631680
23:18:52 2026 8192000000 10157466432 10531356672 1242059280 13.165 100 85 170 0 1273826912 13089424 18678208
23:19:56 1201 8192000000 10191281712 10573250560 1273765872 13.456 100 89 176 0 1307530976 14825568 18939536
23:20:59 1057 8192000000 10208189392 10595844096 1293963072 13.640 100 82 159 0 1324825312 13237984 17624256
23:22:01 1800 8192000000 10196219776 10602106880 1301751712 13.711 100 59 118 3 1323932912 8517696 13663504
23:23:04 3362 8192000000 10199861712 10607677440 1308836496 13.776 100 42 83 0 1325617456 6870528 9910432
23:24:08 6557 8192000000 10207963136 10621935616 1321271376 13.888 100 21 42 0 1331158336 5444512 4442448
23:25:16 54168 8192000000 10215364672 10636713984 1326528208 13.936 100 28 55 0 1338280096 5108576 6643312
23:27:12 3601 8192000000 10221220368 10641965056 1330040896 13.968 100 27 53 2 1343007680 7352512 5614272
23:28:16 5474 8192000000 10212673776 10637131776 1321388432 13.889 99 27 53 0 1333382032 5579264 6414336
23:29:23 44807 8192000000 10228938880 10645286912 1326270992 13.933 100 31 60 1 1343965760 9323984 8370784
23:31:55 5298 8192000000 10223972512 10626080768 1294132528 13.642 98 51 102 0 1316863728 11398144 11333056
23:33:06 8653 8192000000 10241108176 10647097344 1326791296 13.938 100 57 114 0 1355096400 15003056 13302048
23:34:23 12682 8192000000 10236440512 10641723392 1319224832 13.870 100 55 109 1 1347695904 15627936 12843136
23:35:40 6193 8192000000 10241701232 10644570112 1316975392 13.849 99 50 100 0 1343440048 15298864 11165792
23:36:55 32346 8192000000 10228028192 10641952768 1294511376 13.645 97 28 56 1 1321254752 19799008 6944368
23:38:34 27798 8192000000 10257153200 10665164800 1313713056 13.820 98 45 90 0 1347704128 23017584 10973488
23:40:06 6730 8192000000 10266577552 10673168384 1339253088 14.051 100 47 94 1 1378464816 27981072 11230656
23:41:26 11159 8192000000 10251484656 10652049408 1286240832 13.570 96 50 100 1 1329227696 30697600 12289264
23:42:46 5978 8192000000 10276781728 10690379776 1344282416 14.096 100 49 95 0 1391924144 35677536 11964192
23:44:05 2217 8192000000 10269732384 10661625856 1318858720 13.866 99 84 165 3 1373991424 34027360 21105344
23:45:12 4995 8192000000 10289709712 10689732608 1342963984 14.084 100 66 129 0 1393216944 33841424 16411536
23:46:25 3673 8192000000 10296531936 10697125888 1351116768 14.158 100 69 134 0 1402571904 34924992 16530144
23:47:34 5505 8192000000 10317323616 10721689600 1361019632 14.247 100 81 160 0 1420315552 39456368 19839552
23:48:48 5209 8192000000 10344916896 10751606784 1387694624 14.485 100 76 152 2 1450392080 43816896 18880560
23:49:59 3812 8192000000 10345409744 10759548928 1389006432 14.497 100 65 124 1 1450065584 44664368 16394784
23:51:08 12117 8192000000 10337745360 10762039296 1400984448 14.604 100 49 98 0 1446382800 32947120 12451232
23:52:23 31344 8192000000 10313729232 10757197824 1375775120 14.379 99 23 46 0 1420754448 38374208 6605120
23:54:37 33740 8192000000 10293942880 10745327616 1379065040 14.408 100 14 27 0 1411407280 28084272 4257968
23:56:14 43528 8192000000 10290851216 10738610176 1385428096 14.465 100 18 36 1 1410772992 20462384 4882512
23:57:59 6409 8192000000 10300495680 10745442304 1386964592 14.479 100 27 54 0 1407788080 15076112 5747376
23:59:13 17293 8192000000 10274984320 10725486592 1369204992 14.320 99 22 44 0 1382829872 8831104 4793776
00:00:37 49679 8192000000 10291914080 10745745408 1382941152 14.443 99 26 52 0 1400695616 12150928 5603536
00:02:29 33270 8192000000 10292417008 10748592128 1393012400 14.533 100 26 51 0 1411567456 12798128 5756928
00:04:06 15852 8192000000 10299169440 10754867200 1399584240 14.591 100 16 32 0 1417710288 14289168 3836880
00:05:23 12545 8192000000 10314829584 10762764288 1401959776 14.612 100 17 34 0 1418862192 12731792 4170624
00:06:37 35725 8192000000 10312087680 10768150528 1395828000 14.558 99 16 32 0 1418002336 17598816 4575520
00:08:17 119509 8192000000 10305810784 10775052288 1413964336 14.719 100 22 45 0 1438583088 18695424 5923328
00:11:18 13339 8192000000 10322931040 10775502848 1419762928 14.771 100 44 88 0 1437963072 7716976 10483168
00:12:32 46219 8192000000 10310134704 10763943936 1407102880 14.658 99 34 68 0 1426609232 11460048 8046304
00:14:25 39891 8192000000 10306004864 10784149504 1402355408 14.616 99 8 16 0 1415647888 11393968 1898512
00:16:07 52147 8192000000 10308972592 10754064384 1374734048 14.369 97 22 44 0 1388939968 9119920 5086000
00:18:05 24859 8192000000 10325737680 10766360576 1395400880 14.554 99 49 99 0 1418669424 12054576 11213968
00:19:36 77489 8192000000 10301503328 10747158528 1347437712 14.124 96 25 50 0 1362069616 9187536 5444368
00:21:57 69297 8192000000 10284487232 10722197504 1303393472 13.726 94 29 58 0 1318619728 9002000 6224256
00:24:09 44082 8192000000 10258921056 10700009472 1281547728 13.527 93 29 58 0 1300651616 12256656 6847232
00:26:02 35206 8192000000 10249399920 10690179072 1306770880 13.757 97 24 48 1 1326283568 14292240 5220448
00:27:43 59282 8192000000 10235540112 10690379776 1304758304 13.738 98 7 14 0 1321236944 15037296 1441344
00:29:44 92234 8192000000 10243546768 10682023936 1330233792 13.969 99 32 64 0 1347678640 9699808 7745040
00:32:25 53413 8192000000 10238336368 10691538944 1340949600 14.066 100 11 22 0 1356164256 12926144 2288512
00:34:53 20267 8192000000 10259052560 10691522560 1326299792 13.934 98 38 76 0 1345867008 11018384 8548832
00:36:18 40764 8192000000 10235774096 10672447488 1325458448 13.926 98 14 28 0 1337656784 8769168 3429168
00:38:02 72401 8192000000 10248755296 10699481088 1354879376 14.191 100 15 30 0 1370553728 11601952 4072400
00:40:15 8094 8192000000 10251928992 10693005312 1356266336 14.204 100 23 46 1 1369832496 8637392 4928768
00:41:42 54700 8192000000 10254264544 10700578816 1336441296 14.025 98 13 26 0 1353307104 13427552 3438256
00:43:38 43056 8192000000 10266407264 10710290432 1334359440 14.007 97 19 38 0 1345902832 7607504 3935888
00:45:22 11130 8192000000 10303940784 10731704320 1383117824 14.444 100 68 133 1 1410388288 12476480 14793984
00:46:36 90504 8192000000 10284042592 10727567360 1366135584 14.292 99 16 32 0 1383529184 13875632 3517968
00:49:45 34591 8192000000 10306756480 10745966592 1391788768 14.522 100 37 72 0 1415243664 14966864 8488032
00:51:21 33489 8192000000 10305229552 10744295424 1392733328 14.530 100 28 57 0 1409240704 10715952 5791424
00:53:00 64486 8192000000 10316336944 10763001856 1385499664 14.466 99 32 64 0 1404080320 11809568 6771088
00:55:09 90771 8192000000 10289117008 10739138560 1347341728 14.124 96 20 40 0 1365671936 13931504 4398704
00:58:35 69988 8192000000 10285444160 10733912064 1337625712 14.036 96 16 32 1 1353399392 12525712 3247968
01:00:48 66479 8192000000 10247844992 10705022976 1290514288 13.609 94 8 15 0 1300925312 8726256 1684768
01:02:58 45526 8192000000 10289482288 10739924992 1383820912 14.451 100 17 34 0 1400585104 12607280 4156912
01:05:03 52817 8192000000 10289664784 10757722112 1383375280 14.447 100 6 12 0 1397658624 12865312 1418032
01:06:57 48433 8192000000 10279581152 10731307008 1358300736 14.222 98 22 44 0 1375165936 11552336 5312864
01:08:46 49993 8192000000 10258479344 10714607616 1326380960 13.934 98 14 29 0 1347515072 16985552 4148560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 120 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-03-2024 01:11:26 to 30-03-2024 01:11:28.

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          174623
MON$OLDEST_ACTIVE               176871
MON$OLDEST_SNAPSHOT             176871
MON$NEXT_TRANSACTION            176871
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                       1892288
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sat Mar 30 01:11:29 2024 
 
Database header page information: 
    Flags            0 
    Generation        91906 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    174623 
    Oldest active        176871 
    Oldest snapshot        176871 
    Next transaction    176872 
    Sequence number        0 
    Next attachment ID    717 
    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.26, total records: 7787165 
    Average version length: 48.16, total versions: 102730, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86808 
    Data pages: 86808, average fill: 72% 
    Primary pages: 86808, secondary pages: 0, swept pages: 15922 
    Empty pages: 10, full pages: 69686 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 140 
    40 - 59% = 2233 
    60 - 79% = 84372 
    80 - 99% = 28 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23379, nodes: 7787165 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1741819, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 349 
        20 - 39% = 1717 
        40 - 59% = 4344 
        60 - 79% = 2267 
        80 - 99% = 14702 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13537, nodes: 7787165 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1564151, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1473 
        40 - 59% = 2150 
        60 - 79% = 1069 
        80 - 99% = 8845 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8350, nodes: 7787165 
    Average node length: 6.62, total dup: 5812921, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1557025, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 907 
        40 - 59% = 1435 
        60 - 79% = 871 
        80 - 99% = 5009 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.04, total records: 2264652 
    Average version length: 34.67, total versions: 108001, max versions: 3 
    Average fragment length: 8.50, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28480 
    Data pages: 28480, average fill: 74% 
    Primary pages: 28474, secondary pages: 6, swept pages: 9267 
    Empty pages: 0, full pages: 21430 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 85 
    40 - 59% = 1491 
    60 - 79% = 25889 
    80 - 99% = 1000 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4580, nodes: 2264652 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 706605, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 891 
        40 - 59% = 888 
        60 - 79% = 696 
        80 - 99% = 2105 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2554, nodes: 2267646 
    Average node length: 4.97, total dup: 2266747, max dup: 19043 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1254255, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 267 
        40 - 59% = 1592 
        60 - 79% = 505 
        80 - 99% = 185 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2016, nodes: 2264652 
    Average node length: 4.97, total dup: 2264602, max dup: 130324 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1065304, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 54 
        40 - 59% = 1048 
        60 - 79% = 52 
        80 - 99% = 859 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4389, nodes: 2264652 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 706605, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 579 
        40 - 59% = 629 
        60 - 79% = 802 
        80 - 99% = 2253 
 
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.40, total records: 400 
    Average version length: 23.24, total versions: 234359, max versions: 610 
    Average fragment length: 2.08, total fragments: 51, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1312 
    Data pages: 1312, average fill: 89% 
    Primary pages: 14, secondary pages: 1298, swept pages: 0 
    Empty pages: 7, full pages: 1304 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1304 
 
    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: 7.67, total records: 172983 
    Average version length: 68.29, total versions: 153563, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 11.47 
    Pointer pages: 6, data page slots: 3320 
    Data pages: 2504, average fill: 85% 
    Primary pages: 2503, secondary pages: 1, swept pages: 0 
    Empty pages: 34, full pages: 2261 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 37 
    40 - 59% = 64 
    60 - 79% = 258 
    80 - 99% = 2078 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1709184, depth: 3, leaf buckets: 413, nodes: 172983 
    Average node length: 13.05, total dup: 14260, max dup: 2 
    Average key length: 10.50, compression ratio: 2.57 
    Average prefix length: 19.41, average data length: 7.59 
    Clustering factor: 122633, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 107 
        60 - 79% = 241 
        80 - 99% = 65 
 
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: 16808, max versions: 968 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 85% 
    Primary pages: 4, secondary pages: 60, swept pages: 0 
    Empty pages: 3, full pages: 60 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 5.38, total records: 3042 
    Average version length: 43.52, total versions: 2676, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 10.79 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 71% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 28 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 26 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89857, depth: 2, leaf buckets: 2, nodes: 3042 
    Average node length: 4.05, total dup: 2944, max dup: 347 
    Average key length: 2.34, compression ratio: 8.11 
    Average prefix length: 18.69, average data length: 0.31 
    Clustering factor: 1500, ratio: 0.49 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 1 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.69, total records: 817007 
    Average version length: 25.55, total versions: 83821, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8000, average fill: 72% 
    Primary pages: 7982, secondary pages: 18, swept pages: 1157 
    Empty pages: 29, full pages: 7729 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 31 
    40 - 59% = 53 
    60 - 79% = 7490 
    80 - 99% = 372 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 890, nodes: 817007 
    Average node length: 4.87, total dup: 816958, max dup: 156811 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89838, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 111 
        40 - 59% = 506 
        60 - 79% = 210 
        80 - 99% = 61 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 943, nodes: 817007 
    Average node length: 5.88, total dup: 727560, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162822, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 67 
        40 - 59% = 448 
        60 - 79% = 134 
        80 - 99% = 293 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 995, nodes: 817007 
    Average node length: 5.88, total dup: 727560, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164832, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 187 
        40 - 59% = 397 
        60 - 79% = 128 
        80 - 99% = 283 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1134, nodes: 817007 
    Average node length: 5.96, total dup: 727560, max dup: 44 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157497, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 213 
        40 - 59% = 613 
        60 - 79% = 205 
        80 - 99% = 103 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5454 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.42, total fragments: 83, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 128 
    Data pages: 96, average fill: 57% 
    Primary pages: 74, secondary pages: 22, swept pages: 51 
    Empty pages: 10, full pages: 65 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5454 
    Average node length: 5.44, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.06 
    Average prefix length: 34.41, average data length: 1.54 
    Clustering factor: 5099, ratio: 0.93 
    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: 5454 
    Average node length: 11.08, 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: 143, 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.15, total records: 80768 
    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: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 778 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 778 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32751, depth: 2, leaf buckets: 103, nodes: 80768 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3071, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.61, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 148.14, total records: 174693 
    Average version length: 151.35, total versions: 3283, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 6, data page slots: 5200 
    Data pages: 4184, average fill: 86% 
    Primary pages: 4183, secondary pages: 1, swept pages: 3 
    Empty pages: 41, full pages: 4132 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4132 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 149.83, total records: 164000 
    Average version length: 151.65, total versions: 1284, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 6, data page slots: 4904 
    Data pages: 3912, average fill: 86% 
    Primary pages: 3912, secondary pages: 0, swept pages: 1 
    Empty pages: 21, full pages: 3882 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3882 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.23, total records: 168175 
    Average version length: 153.41, total versions: 4182, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 6, data page slots: 4568 
    Data pages: 4048, average fill: 86% 
    Primary pages: 4048, secondary pages: 0, swept pages: 1 
    Empty pages: 53, full pages: 3984 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 3984 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.19, total records: 187815 
    Average version length: 154.04, total versions: 6189, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 6, data page slots: 5344 
    Data pages: 4512, average fill: 86% 
    Primary pages: 4512, secondary pages: 0, swept pages: 2 
    Empty pages: 47, full pages: 4454 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 4453 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 146.13, total records: 175530 
    Average version length: 154.09, total versions: 5843, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 6, data page slots: 5488 
    Data pages: 4200, average fill: 86% 
    Primary pages: 4200, secondary pages: 0, swept pages: 2 
    Empty pages: 30, full pages: 4162 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 4161 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 150.18, total records: 172488 
    Average version length: 145.75, total versions: 1018, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 4640 
    Data pages: 4136, average fill: 86% 
    Primary pages: 4135, secondary pages: 1, swept pages: 1 
    Empty pages: 42, full pages: 4081 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4083 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 137.96, total records: 200259 
    Average version length: 154.54, total versions: 17345, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.29 
    Pointer pages: 9, data page slots: 6112 
    Data pages: 4784, average fill: 87% 
    Primary pages: 4784, secondary pages: 0, swept pages: 1 
    Empty pages: 24, full pages: 4750 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 4750 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 114.28, total records: 232399 
    Average version length: 155.30, total versions: 56557, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.84 
    Pointer pages: 7, data page slots: 6504 
    Data pages: 5592, average fill: 88% 
    Primary pages: 5591, secondary pages: 1, swept pages: 1 
    Empty pages: 41, full pages: 5541 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 5541 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.28, total records: 184628 
    Average version length: 152.12, total versions: 2450, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 9, data page slots: 4848 
    Data pages: 4408, average fill: 86% 
    Primary pages: 4408, secondary pages: 0, swept pages: 3 
    Empty pages: 23, full pages: 4378 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 4378 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.67, total records: 169010 
    Average version length: 150.53, total versions: 1601, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 7, data page slots: 4816 
    Data pages: 4040, average fill: 86% 
    Primary pages: 4040, secondary pages: 0, swept pages: 4 
    Empty pages: 28, full pages: 4003 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4002 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.53, total records: 2109911 
    Average version length: 52.90, total versions: 48559, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25712 
    Data pages: 25704, average fill: 71% 
    Primary pages: 25704, secondary pages: 0, swept pages: 10198 
    Empty pages: 324, full pages: 20869 
    Fill distribution: 
     0 - 19% = 617 
    20 - 39% = 493 
    40 - 59% = 1123 
    60 - 79% = 23036 
    80 - 99% = 435 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2624, nodes: 2109911 
    Average node length: 5.44, total dup: 1968568, max dup: 1480 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182284, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 300 
        40 - 59% = 1760 
        60 - 79% = 306 
        80 - 99% = 254 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2109911 
    Average node length: 5.69, total dup: 1893941, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376755, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 2362 
        60 - 79% = 368 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2173, nodes: 2109911 
    Average node length: 4.96, total dup: 2109811, max dup: 27850 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180118, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 173 
        40 - 59% = 1226 
        60 - 79% = 391 
        80 - 99% = 383 
 
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: 37.89, total records: 163393 
    Average version length: 69.17, total versions: 73960, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.33 
    Pointer pages: 3, data page slots: 4048 
    Data pages: 3224, average fill: 59% 
    Primary pages: 3224, secondary pages: 0, swept pages: 519 
    Empty pages: 632, full pages: 2136 
    Fill distribution: 
     0 - 19% = 842 
    20 - 39% = 119 
    40 - 59% = 95 
    60 - 79% = 570 
    80 - 99% = 1598 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101135, depth: 3, leaf buckets: 239, nodes: 163393 
    Average node length: 6.45, total dup: 142166, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27650, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 116 
        60 - 79% = 71 
        80 - 99% = 14 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.10, total records: 7047787 
    Average version length: 68.75, total versions: 394047, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 62, data page slots: 100008 
    Data pages: 100008, average fill: 75% 
    Primary pages: 100008, secondary pages: 0, swept pages: 22623 
    Empty pages: 9, full pages: 83394 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 419 
    40 - 59% = 4158 
    60 - 79% = 88552 
    80 - 99% = 6839 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10606, nodes: 7047787 
    Average node length: 6.51, total dup: 6094303, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1572232, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1656 
        40 - 59% = 5564 
        60 - 79% = 2839 
        80 - 99% = 540 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8360, nodes: 7047787 
    Average node length: 5.40, total dup: 6766439, max dup: 179 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1375347, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 997 
        40 - 59% = 4672 
        60 - 79% = 1578 
        80 - 99% = 1100 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8422, nodes: 7047787 
    Average node length: 5.40, total dup: 6766439, max dup: 179 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1377856, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1117 
        40 - 59% = 4603 
        60 - 79% = 1591 
        80 - 99% = 1106 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.99, total records: 12022797 
    Average version length: 68.72, total versions: 341016, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 103, data page slots: 166792 
    Data pages: 166792, average fill: 76% 
    Primary pages: 166792, secondary pages: 0, swept pages: 73461 
    Empty pages: 7, full pages: 157331 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 514 
    40 - 59% = 2996 
    60 - 79% = 156406 
    80 - 99% = 6821 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18317, nodes: 12022797 
    Average node length: 6.57, total dup: 10480209, max dup: 61 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2365771, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 2352 
        40 - 59% = 10788 
        60 - 79% = 4328 
        80 - 99% = 822 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.27, total records: 1684473 
    Average version length: 69.12, total versions: 679213, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.05 
    Pointer pages: 26, data page slots: 41480 
    Data pages: 28048, average fill: 69% 
    Primary pages: 28048, secondary pages: 0, swept pages: 5690 
    Empty pages: 2169, full pages: 20683 
    Fill distribution: 
     0 - 19% = 3521 
    20 - 39% = 1439 
    40 - 59% = 1292 
    60 - 79% = 10744 
    80 - 99% = 11052 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2192, nodes: 1684473 
    Average node length: 5.51, total dup: 1616102, max dup: 99 
    Average key length: 2.56, compression ratio: 16.42 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 112590, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 439 
        40 - 59% = 1088 
        60 - 79% = 500 
        80 - 99% = 154 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.65, total records: 1238109 
    Average version length: 69.13, total versions: 598418, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.53 
    Pointer pages: 20, data page slots: 32008 
    Data pages: 27056, average fill: 53% 
    Primary pages: 27056, secondary pages: 0, swept pages: 6504 
    Empty pages: 6364, full pages: 15412 
    Fill distribution: 
     0 - 19% = 8985 
    20 - 39% = 969 
    40 - 59% = 809 
    60 - 79% = 4242 
    80 - 99% = 12051 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1544, nodes: 1238109 
    Average node length: 5.77, total dup: 1157476, max dup: 99 
    Average key length: 2.83, compression ratio: 14.82 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 166432, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 194 
        40 - 59% = 707 
        60 - 79% = 468 
        80 - 99% = 171 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.98, total records: 9346694 
    Average version length: 68.95, total versions: 531003, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 88, data page slots: 143496 
    Data pages: 143480, average fill: 70% 
    Primary pages: 143480, secondary pages: 0, swept pages: 48239 
    Empty pages: 449, full pages: 85387 
    Fill distribution: 
     0 - 19% = 1301 
    20 - 39% = 4933 
    40 - 59% = 20433 
    60 - 79% = 108272 
    80 - 99% = 8541 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13497, nodes: 9346694 
    Average node length: 6.68, total dup: 7753394, max dup: 27 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2044803, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1229 
        40 - 59% = 6552 
        60 - 79% = 4940 
        80 - 99% = 775 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21152147 
    Average version length: 82.93, total versions: 13884, 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: 318776 
    Data pages: 318776, average fill: 81% 
    Primary pages: 318776, secondary pages: 0, swept pages: 12579 
    Empty pages: 28, full pages: 318198 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 26 
    40 - 59% = 73 
    60 - 79% = 27438 
    80 - 99% = 291197 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19457, nodes: 21152147 
    Average node length: 5.72, total dup: 20670833, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281207, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 2 
        40 - 59% = 8276 
        60 - 79% = 540 
        80 - 99% = 10630 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17164, nodes: 21152147 
    Average node length: 6.31, total dup: 18589192, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913861, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 776 
        60 - 79% = 255 
        80 - 99% = 16127 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21236, nodes: 21152147 
    Average node length: 6.35, total dup: 18507078, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575511, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8540 
        60 - 79% = 625 
        80 - 99% = 12065 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16130, nodes: 21152147 
    Average node length: 5.56, total dup: 21152047, max dup: 229786 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942652, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 2939 
        60 - 79% = 396 
        80 - 99% = 12784 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.09, total records: 9784338 
    Average version length: 82.64, total versions: 512823, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 102, data page slots: 166128 
    Data pages: 166112, average fill: 73% 
    Primary pages: 166112, secondary pages: 0, swept pages: 61129 
    Empty pages: 386, full pages: 107263 
    Fill distribution: 
     0 - 19% = 1068 
    20 - 39% = 4031 
    40 - 59% = 18388 
    60 - 79% = 75906 
    80 - 99% = 66719 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11354, nodes: 9784338 
    Average node length: 5.35, total dup: 9474906, max dup: 208 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2206899, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 31 
        40 - 59% = 8092 
        60 - 79% = 3083 
        80 - 99% = 146 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13508, nodes: 9784338 
    Average node length: 6.22, total dup: 8112236, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1552964, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 3859 
        40 - 59% = 4399 
        60 - 79% = 2585 
        80 - 99% = 2540 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12685, nodes: 9784338 
    Average node length: 5.96, total dup: 8491620, max dup: 38 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2395798, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 49 
        40 - 59% = 9065 
        60 - 79% = 3395 
        80 - 99% = 175 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10098, nodes: 9784338 
    Average node length: 5.12, total dup: 9784238, max dup: 155203 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1579095, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1125 
        40 - 59% = 5030 
        60 - 79% = 1743 
        80 - 99% = 2165 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.39, total records: 11438061 
    Average version length: 82.55, total versions: 405114, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 191688 
    Data pages: 190352, average fill: 74% 
    Primary pages: 190352, secondary pages: 0, swept pages: 66471 
    Empty pages: 2699, full pages: 146657 
    Fill distribution: 
     0 - 19% = 4475 
    20 - 39% = 6541 
    40 - 59% = 15746 
    60 - 79% = 42759 
    80 - 99% = 120831 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13135, nodes: 11438061 
    Average node length: 5.30, total dup: 11328418, max dup: 695 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2376598, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 78 
        40 - 59% = 8915 
        60 - 79% = 3979 
        80 - 99% = 162 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10503, nodes: 11438061 
    Average node length: 5.49, total dup: 10938818, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 708899, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 144 
        20 - 39% = 830 
        40 - 59% = 2543 
        60 - 79% = 1862 
        80 - 99% = 5124 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15021, nodes: 11438061 
    Average node length: 6.02, total dup: 9985741, max dup: 74 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2393152, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 106 
        40 - 59% = 10400 
        60 - 79% = 4313 
        80 - 99% = 200 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10812, nodes: 11438061 
    Average node length: 5.22, total dup: 11437961, max dup: 193405 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 697312, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 81 
        20 - 39% = 790 
        40 - 59% = 4816 
        60 - 79% = 1493 
        80 - 99% = 3632 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.54, total records: 9889569 
    Average version length: 82.91, total versions: 501573, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 105, data page slots: 170632 
    Data pages: 170616, average fill: 72% 
    Primary pages: 170616, secondary pages: 0, swept pages: 67653 
    Empty pages: 486, full pages: 106381 
    Fill distribution: 
     0 - 19% = 1422 
    20 - 39% = 5353 
    40 - 59% = 21375 
    60 - 79% = 78529 
    80 - 99% = 63937 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11951, nodes: 9889569 
    Average node length: 5.16, total dup: 9860729, max dup: 1558 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2011772, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1561 
        40 - 59% = 7906 
        60 - 79% = 1823 
        80 - 99% = 622 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13658, nodes: 9889569 
    Average node length: 6.23, total dup: 8199145, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1514538, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 186 
        20 - 39% = 3845 
        40 - 59% = 4403 
        60 - 79% = 2544 
        80 - 99% = 2680 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12585, nodes: 9889569 
    Average node length: 5.42, total dup: 9447844, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2145276, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1447 
        40 - 59% = 8875 
        60 - 79% = 1651 
        80 - 99% = 571 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10280, nodes: 9889569 
    Average node length: 5.13, total dup: 9889469, max dup: 157387 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1598829, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1210 
        40 - 59% = 5069 
        60 - 79% = 1798 
        80 - 99% = 2167 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.32, total records: 579574 
    Average version length: 68.80, total versions: 7269, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7984 
    Data pages: 7984, average fill: 76% 
    Primary pages: 7984, secondary pages: 0, swept pages: 3478 
    Empty pages: 3, full pages: 7016 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 13 
    40 - 59% = 114 
    60 - 79% = 7734 
    80 - 99% = 120 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44027, depth: 3, leaf buckets: 742, nodes: 579574 
    Average node length: 5.94, total dup: 493786, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100719, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 526 
        60 - 79% = 96 
        80 - 99% = 89 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33618, depth: 3, leaf buckets: 759, nodes: 579574 
    Average node length: 6.15, total dup: 475503, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100781, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 530 
        60 - 79% = 101 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 584, nodes: 579574 
    Average node length: 4.86, total dup: 579474, max dup: 9888 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89404, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 352 
        60 - 79% = 87 
        80 - 99% = 116 
 
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 Sat Mar 30 01:11:52 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7787165 102730 1 0.0000 0.0000
DOC_LIST 2264652 108001 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 234359 610 58500.0000 0.0000
INVNT_TURNOVER_LOG 172983 153563 1 0.0000 0.0000
MONEY_SALDO 49 16808 968 34300.0000 0.0000
MONEY_TURNOVER_LOG 3042 2676 1 0.0000 0.0000
PDISTR 817007 83821 4 0.0000 0.0000
PERF_SPLIT_0 174693 3283 1 0.0000 0.0000
PERF_SPLIT_1 164000 1284 1 0.0000 0.0000
PERF_SPLIT_2 168175 4182 1 0.0000 0.0000
PERF_SPLIT_3 187815 6189 1 0.0000 0.0000
PERF_SPLIT_4 175530 5843 1 0.0000 0.0000
PERF_SPLIT_5 172488 1018 1 0.0000 0.0000
PERF_SPLIT_6 200259 17345 1 0.0000 0.0000
PERF_SPLIT_7 232399 56557 1 0.0000 0.0000
PERF_SPLIT_8 184628 2450 1 0.0000 0.0000
PERF_SPLIT_9 169010 1601 1 0.0000 0.0000
PSTORNED 2109911 48559 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 163393 73960 1 0.0000 0.0000
XQD_1000_3300 7047787 394047 1 0.0000 0.0000
XQD_1200_2000 12022797 341016 1 0.0000 0.0000
XQD_2000_3300 1684473 679213 1 0.0000 0.0000
XQD_2100_3300 1238109 598418 1 0.0000 0.0000
XQD_3300_3400 9346694 531003 1 0.0000 0.0000
XQS_1000_1200 21152147 13884 1 0.0000 0.0000
XQS_1000_3300 9784338 512823 1 0.0000 0.0000
XQS_1200_2000 11438061 405114 1 0.0000 0.0000
XQS_2100_3300 9889569 501573 1 0.0000 0.0000
XQS_3300_3400 579574 7269 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 ---
:553: 
:554: mscs-test-161.budzdorov.ru    Sat Mar 30 01:09:49 2024
:555:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:556: 
:557: 
:558: mscs-test-161.budzdorov.ru    Sat Mar 30 01:09:51 2024
:559:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:560: 
:561: 
:562: mscs-test-161.budzdorov.ru    Sat Mar 30 01:09:51 2024
:563:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:564: 
--- end of diff output ---

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

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