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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15690996 kB
MemAvailable 30296088 kB
Buffers 0 kB
Cached 16070520 kB
SwapCached 2580 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-25 22:09:47
DTS_END                         2024-03-25 22:09:47.6010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44286
TRN_ID                          170989
ATT_ID                          550
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: 9143.30 19196 914330
customer order: creation 170.72 406 17072
customer order: refuse 15.58 401 1558
order to supplier: creation 45.83 1392 4583
order to supplier: removal 3.51 105919 351
invoice (draft): creation 45.15 3399 4515
invoice (draft): removal 51.91 886 5191
invoice accept: apply 40.08 23047 4008
invoice accept: cancel 46.32 937 4632
customer reserve: creation 3850.23 219 385023
customer reserve: removal 4582.34 62 458234
realization accept: apply 81.99 216 8199
realization accept: cancel 80.72 127 8072
payment from customer: creation 58.29 150 5829
payment from customer: removal 5.95 103 595
payment to supplier: creation 49.05 178 4905
payment to supplier: removal 3.59 84 359
service: total inventory turnovers 4.41 1396 441
service: total monetary turnovers 6.77 47 677
service: aggregate perf. data 0.83 17021 83
service: refresh index statistics 0.03 227921 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-03-2024 22:12:08 to 25-03-2024 22:12:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1950
TEST_TIME 2 3607
TEST_TIME 3 4040
TEST_TIME 4 4118
TEST_TIME 5 4179
TEST_TIME 6 4808
TEST_TIME 7 5344
TEST_TIME 8 5209
TEST_TIME 9 5876
TEST_TIME 10 5681
TEST_TIME 11 5819
TEST_TIME 12 6302
TEST_TIME 13 6536
TEST_TIME 14 6478
TEST_TIME 15 7022
TEST_TIME 16 7081
TEST_TIME 17 7218
TEST_TIME 18 7322
TEST_TIME 19 7458
TEST_TIME 20 7475
TEST_TIME 21 7617
TEST_TIME 22 7844
TEST_TIME 23 7822
TEST_TIME 24 8171
TEST_TIME 25 8001
TEST_TIME 26 8019
TEST_TIME 27 8357
TEST_TIME 28 9101
TEST_TIME 29 9590
TEST_TIME 30 9478
TEST_TIME 31 9876
TEST_TIME 32 9699
TEST_TIME 33 9767
TEST_TIME 34 9603
TEST_TIME 35 9572
TEST_TIME 36 9531
TEST_TIME 37 9428
TEST_TIME 38 9313
TEST_TIME 39 9473
TEST_TIME 40 9405
TEST_TIME 41 9342
TEST_TIME 42 9296
TEST_TIME 43 9152
TEST_TIME 44 9088
TEST_TIME 45 9021
TEST_TIME 46 8979
TEST_TIME 47 9110
TEST_TIME 48 9252
TEST_TIME 49 9187
TEST_TIME 50 9181
TEST_TIME 51 9160
TEST_TIME 52 9117
TEST_TIME 53 9022
TEST_TIME 54 9000
TEST_TIME 55 8963
TEST_TIME 56 8847
TEST_TIME 57 8840
TEST_TIME 58 8809
TEST_TIME 59 8770
TEST_TIME 60 8750
TEST_TIME 61 8835
TEST_TIME 62 8928
TEST_TIME 63 8921
TEST_TIME 64 8908
TEST_TIME 65 9008
TEST_TIME 66 8962
TEST_TIME 67 8998
TEST_TIME 68 9170
TEST_TIME 69 9192
TEST_TIME 70 9237
TEST_TIME 71 9265
TEST_TIME 72 9273
TEST_TIME 73 9166
TEST_TIME 74 9116
TEST_TIME 75 9104
TEST_TIME 76 9139
TEST_TIME 77 9079
TEST_TIME 78 9016
TEST_TIME 79 8976
TEST_TIME 80 8946
TEST_TIME 81 8941
TEST_TIME 82 8940
TEST_TIME 83 8926
TEST_TIME 84 8916
TEST_TIME 85 8965
TEST_TIME 86 9026
TEST_TIME 87 9052
TEST_TIME 88 9038
TEST_TIME 89 9083
TEST_TIME 90 9031
TEST_TIME 91 8977
TEST_TIME 92 9207
TEST_TIME 93 9180
TEST_TIME 94 9272
TEST_TIME 95 9279
TEST_TIME 96 9281
TEST_TIME 97 9203
TEST_TIME 98 9161
TEST_TIME 99 9169
TEST_TIME 100 9148

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-03-2024 22:12:11 to 25-03-2024 22:12:14.

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 1267024 1267024 0 0.00 0 26150 8 0 0
doc_list_biud 1267023 1267023 0 0.00 0 23788 29 0 0
sp_add_invoice_to_stock 4118 4008 110 2.67 33 188108 23047 0 110
sp_cancel_adding_invoice 4632 4632 0 0.00 6 60214 938 0 0
sp_cancel_client_order 1558 1558 0 0.00 4 9380 401 0 0
sp_cancel_customer_reserve 458234 458234 0 0.00 0 22923 62 0 0
sp_cancel_pay_from_customer 595 595 0 0.00 3 3835 104 0 0
sp_cancel_pay_to_supplier 359 359 0 0.00 3 3210 85 0 0
sp_cancel_supplier_invoice 5197 5191 6 0.11 2 21047 886 0 6
sp_cancel_supplier_order 351 351 0 0.00 5 924398 105920 0 0
sp_cancel_write_off 8072 8072 0 0.00 1 7323 127 0 0
sp_client_order 17072 17072 0 0.00 3 28200 407 0 0
sp_customer_reserve 385023 385023 0 0.00 0 100398 219 0 0
sp_fill_shopping_cart 26169 26169 0 0.00 1 12627 41 0 0
sp_fill_shopping_cart_clo_res 385015 385015 0 0.00 0 18420 15 0 0
sp_get_clo_for_invoice 3998 3998 0 0.00 0 18951 295 0 0
sp_kill_cost_storno 13658 13658 0 0.00 0 11564 71 0 0
sp_kill_qstorno_ret_qs2qd 930082 930082 0 0.00 0 22885 34 0 0
sp_kill_qty_storno 490235 490235 0 0.00 0 23783 74 0 0
sp_lock_selected_doc 17141 17141 0 0.00 0 6395 6 0 0
sp_make_cost_storno 22931 22931 0 0.00 0 23437 71 0 0
sp_multiply_rows_for_pdistr 22931 22931 0 0.00 0 16705 39 0 0
sp_multiply_rows_for_qdistr 17072 17072 0 0.00 0 19579 169 0 0
sp_pay_from_customer 5829 5829 0 0.00 4 47200 150 0 0
sp_pay_to_supplier 4905 4905 0 0.00 4 26211 178 0 0
sp_payment_common 10734 10734 0 0.00 1 47188 40 0 0
sp_qd_handle_on_cancel_clo 1558 1558 0 0.00 0 9375 365 0 0
sp_qd_handle_on_invoice_upd_sts 8630 8630 0 0.00 0 23780 395 0 0
sp_qd_handle_on_reserve_upd_sts 8199 8199 0 0.00 0 17232 70 0 0
sp_reserve_write_off 8199 8199 0 0.00 6 34792 216 0 0
sp_supplier_invoice 4515 4515 0 0.00 6 69601 3399 0 0
sp_supplier_order 4583 4583 0 0.00 5 41981 1393 0 0
srv_aggregate_perf_data 83 83 0 0.00 1581 140069 17021 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 992 151432 41733 0 0
srv_find_qd_qs_mism 872788 872788 0 0.00 0 10525 6 0 0
srv_make_invnt_saldo 441 441 0 0.00 56 101253 1396 0 0
srv_make_money_saldo 677 677 0 0.00 0 5844 47 0 0
srv_recalc_idx_stat 3 3 0 0.00 142781 293746 227921 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4009 4009 0 0.00 0 21169 263 0 0
t$perf-norm:sp_cancel_adding_invoice 312 312 0 0.00 0 5655 139 0 0
t$perf-norm:sp_cancel_client_order 1558 1558 0 0.00 0 8202 29 0 0
t$perf-norm:sp_cancel_customer_reserve 577 577 0 0.00 0 3228 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 595 595 0 0.00 0 711 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 359 359 0 0.00 0 4140 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 324 324 0 0.00 0 1823 18 0 0
t$perf-norm:sp_cancel_supplier_order 351 351 0 0.00 0 34620 1838 0 0
t$perf-norm:sp_cancel_write_off 869 869 0 0.00 0 4487 22 0 0
t$perf-norm:sp_client_order 17072 17072 0 0.00 0 16592 26 0 0
t$perf-norm:sp_customer_reserve 831 831 0 0.00 0 10927 23 0 0
t$perf-norm:sp_pay_from_customer 5829 5829 0 0.00 0 16653 15 0 0
t$perf-norm:sp_pay_to_supplier 4905 4905 0 0.00 0 10535 18 0 0
t$perf-norm:sp_reserve_write_off 8199 8199 0 0.00 0 6413 17 0 0
t$perf-norm:sp_supplier_invoice 4515 4515 0 0.00 0 10837 29 0 0
t$perf-norm:sp_supplier_order 4583 4583 0 0.00 0 10618 32 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 773 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 179 4 0 0
t$perf-norm:srv_make_invnt_saldo 441 441 0 0.00 0 3534 48 0 0
t$perf-norm:srv_make_money_saldo 677 677 0 0.00 0 765 22 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 29 15 0 0
v_add_invoice_to_stock 8214 7994 220 2.67 0 3482 18 0 220
v_all_customers 31264 31264 0 0.00 0 22 1 0 0
v_all_suppliers 25838 25838 0 0.00 0 30 1 0 0
v_all_wares 34144 34144 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 624 624 0 0.00 0 1613 11 0 0
v_cancel_client_order 3116 3116 0 0.00 0 2428 7 0 0
v_cancel_customer_prepayment 1190 1190 0 0.00 0 1502 5 0 0
v_cancel_customer_reserve 1154 1154 0 0.00 0 420 4 0 0
v_cancel_payment_to_supplier 718 718 0 0.00 0 2056 6 0 0
v_cancel_supplier_invoice 660 648 12 1.81 0 1093 16 0 12
v_cancel_supplier_order 702 702 0 0.00 0 1512 9 0 0
v_cancel_write_off 1738 1738 0 0.00 0 2486 16 0 0
v_max_id_clo_ord 4583 4583 0 0.00 0 73 1 0 0
v_max_id_clo_res 831 831 0 0.00 0 1818 10 0 0
v_max_id_ord_sup 4514 4514 0 0.00 0 7913 7 0 0
v_max_non_paid_invoice 1083 1083 0 0.00 0 2708 7 0 0
v_max_non_paid_realizn 2894 2894 0 0.00 0 4332 7 0 0
v_min_id_clo_ord 4583 4583 0 0.00 0 3346 11 0 0
v_min_id_clo_res 831 831 0 0.00 0 1871 7 0 0
v_min_id_ord_sup 4514 4514 0 0.00 0 7246 11 0 0
v_min_non_paid_invoice 4905 4905 0 0.00 0 6264 18 0 0
v_min_non_paid_realizn 5829 5829 0 0.00 0 10964 32 0 0
v_our_firm 8750 8750 0 0.00 0 78 1 0 0
v_reserve_write_off 16398 16398 0 0.00 0 4935 7 0 0
x_lock_depdocs_on_canc_invoice 9499 9499 0 0.00 0 17929 162 0 0
x_lock_depdocs_on_canc_sup_ord 351 351 0 0.00 0 3636 384 0 0
x_make_qstorno_1000_1200 4583 4583 0 0.00 1 41930 1301 0 0
x_make_qstorno_1200_2000 4515 4515 0 0.00 2 69591 3250 0 0
x_make_qstorno_2100_3300 385023 385023 0 0.00 0 100376 200 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-03-2024 22:12:15 to 25-03-2024 22:12:19.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
20:09:51 2 8192000000 8799991872 8811675648 6386048 0.077 2 1 2 0 6485680 56848 42784
20:10:52 24516 8192000000 9898747024 10209177600 975856752 10.644 100 79 158 0 1001810288 5501216 20452320
20:12:20 17971 8192000000 9946464832 10270068736 1024495264 11.115 100 88 176 0 1055461936 8691120 22275552
20:13:52 11152 8192000000 9982302688 10315780096 1065914128 11.513 100 82 164 0 1096321248 10009552 20397568
20:15:11 7560 8192000000 10023146528 10364854272 1108773280 11.921 100 82 164 0 1139122928 10672672 19676976
20:16:25 11607 8192000000 10055327072 10407673856 1139288480 12.209 100 88 176 1 1172114304 11775648 21050176
20:17:41 5516 8192000000 10108625040 10472038400 1195271520 12.732 100 72 141 1 1223224416 12789232 15163664
20:18:52 2274 8192000000 10152742352 10524368896 1241805072 13.163 100 84 169 0 1273373648 13324064 18244512
20:19:57 1604 8192000000 10188458384 10569867264 1279861584 13.512 100 86 169 2 1311366400 12593296 18911520
20:21:00 1703 8192000000 10209575296 10590773248 1296946112 13.667 100 90 178 4 1329030320 12330528 19753680
20:22:03 21632 8192000000 10205889728 10601054208 1304325328 13.735 100 58 117 1 1324317536 6252160 13740048
20:23:26 2528 8192000000 10200625792 10611290112 1309429008 13.781 100 40 82 0 1324556464 5716224 9411232
20:24:29 5752 8192000000 10203560384 10618257408 1318788432 13.866 100 23 43 1 1329013872 5754112 4471328
20:25:38 12949 8192000000 10211536976 10628132864 1325820960 13.929 100 12 24 0 1333958176 5658272 2478944
20:26:52 60008 8192000000 10217974176 10640838656 1329202960 13.960 100 16 31 0 1337569456 5051744 3314752
20:28:53 6205 8192000000 10228357216 10647642112 1335234400 14.014 100 29 57 0 1347761216 6524752 6002064
20:30:04 38352 8192000000 10211773616 10618380288 1301513408 13.709 98 36 71 0 1315144544 5930608 7700528
20:32:05 2084 8192000000 10242890800 10646798336 1321760208 13.893 99 71 140 1 1351306144 13329888 16216048
20:33:35 32668 8192000000 10245723344 10668822528 1344263472 14.096 100 39 76 0 1369328192 16339504 8725216
20:35:10 17685 8192000000 10243545712 10655776768 1323326432 13.907 99 44 84 0 1347069184 14096288 9646464
20:36:31 25930 8192000000 10236906640 10646409216 1314500128 13.827 99 45 90 0 1341735824 16968064 10267632
20:38:02 4300 8192000000 10227927216 10632880128 1312167904 13.806 99 52 104 2 1341885280 16640288 13077088
20:39:09 6045 8192000000 10210267664 10605985792 1291598224 13.619 99 59 116 1 1319798912 14160000 14040688
20:40:17 14374 8192000000 10207769488 10605699072 1281913968 13.530 98 61 122 0 1316032064 20132560 13985536
20:41:56 2840 8192000000 10236809104 10630234112 1308597456 13.773 99 59 111 0 1346643120 24227200 13818464
20:43:04 2943 8192000000 10269563792 10671992832 1334730272 14.010 100 70 138 1 1378508672 27069744 16708656
20:44:14 990 8192000000 10296564544 10692972544 1347863072 14.128 100 85 168 0 1399978368 32120816 19994480
20:45:20 1219 8192000000 10293866800 10691252224 1351414288 14.160 100 86 168 0 1398420368 26724176 20281904
20:46:25 1451 8192000000 10315724592 10716311552 1367648208 14.306 100 91 179 0 1417616640 28290256 21678176
20:47:35 5409 8192000000 10318045648 10717941760 1368966048 14.318 100 76 154 1 1417863840 30788416 18109376
20:48:46 4369 8192000000 10329820096 10736283648 1380562016 14.422 100 81 159 0 1436549712 36683968 19303728
20:49:57 3956 8192000000 10354527792 10759086080 1395135232 14.552 100 81 160 0 1453783696 39136928 19511536
20:51:08 2149 8192000000 10362393392 10771435520 1403489280 14.626 100 86 168 4 1467202112 41804896 21907936
20:52:15 4774 8192000000 10370512800 10786734080 1412211392 14.704 100 62 124 2 1467722592 39666752 15844448
20:53:26 16982 8192000000 10368868128 10800484352 1421748128 14.788 100 37 71 1 1480440576 48705184 9987264
20:55:04 17611 8192000000 10364015744 10794999808 1405518512 14.644 100 32 62 0 1468940336 54368272 9053552
20:56:25 22339 8192000000 10344233152 10786336768 1399430368 14.590 100 24 48 0 1457724160 50960864 7332928
20:57:57 23179 8192000000 10330119488 10770767872 1398898784 14.585 100 26 51 0 1436586256 30782304 6905168
20:59:22 33946 8192000000 10319569040 10754662400 1378717328 14.405 99 41 82 0 1413792624 25177952 9897344
21:00:58 19739 8192000000 10311918192 10752909312 1391575408 14.520 100 33 66 0 1414589232 15351904 7661920
21:02:19 31559 8192000000 10302738320 10748420096 1384486480 14.457 99 29 59 0 1404095456 12853744 6755232
21:03:57 121082 8192000000 10292479120 10744475648 1372986416 14.354 98 25 51 0 1385816784 7584512 5245856
21:07:00 123576 8192000000 10299767392 10762043392 1369895248 14.326 98 32 64 2 1390422480 12863040 7664192
21:10:08 24687 8192000000 10307979776 10760007680 1398811008 14.584 100 46 94 0 1417770736 8657088 10302640
21:11:34 77268 8192000000 10332061344 10776047616 1386451856 14.474 98 33 64 1 1403476000 9959968 7064176
21:13:57 16414 8192000000 10325127920 10770350080 1397006080 14.568 99 45 90 1 1424282032 16331472 10944480
21:15:28 23606 8192000000 10345264272 10784862208 1407337776 14.660 100 49 96 0 1445006560 26579040 11089744
21:16:52 73081 8192000000 10301527616 10779291648 1368481232 14.313 98 10 20 0 1397280800 26111664 2687904
21:19:06 42137 8192000000 10268680160 10727272448 1319881792 13.876 95 13 27 1 1340710944 17930560 2898592
21:22:34 25101 8192000000 10292012512 10736189440 1379605392 14.413 100 31 61 1 1395772640 9207664 6959584
21:24:05 90382 8192000000 10262716880 10715111424 1337226256 14.032 97 14 29 0 1350593392 9816560 3550576
21:28:28 30005 8192000000 10253331872 10688942080 1319331568 13.871 98 28 56 1 1332621840 6641248 6649024
21:29:59 49117 8192000000 10264319472 10713481216 1337825504 14.038 99 24 48 0 1359743072 16379888 5537680
21:32:03 76329 8192000000 10247724992 10687102976 1277425648 13.490 95 16 32 0 1292090064 11493040 3171376
21:34:26 57716 8192000000 10263173200 10699010048 1309902928 13.785 97 20 39 1 1325293904 11160112 4230864
21:36:24 45422 8192000000 10280953968 10733281280 1350086592 14.148 99 26 52 0 1373363024 17588768 5687664
21:38:18 121956 8192000000 10280706480 10738601984 1331388000 13.980 97 8 16 0 1350382768 17479040 1515728
21:41:24 85560 8192000000 10282302112 10713608192 1359370176 14.232 99 16 32 0 1380525680 17259296 3896208
21:43:51 69502 8192000000 10260802160 10719674368 1353480224 14.179 98 10 20 0 1366366512 10822256 2064032
21:46:22 54404 8192000000 10278978288 10737188864 1369762768 14.325 99 10 20 0 1380447376 8470544 2214064
21:48:17 46055 8192000000 10288566768 10740228096 1386720400 14.477 100 17 33 0 1407592320 17103872 3768048
21:50:04 61865 8192000000 10274839456 10737496064 1368452608 14.313 99 13 26 0 1382388704 10830848 3105248
21:52:07 43817 8192000000 10288315200 10742644736 1373658176 14.360 99 8 16 0 1382389504 6983728 1747600
21:53:53 51793 8192000000 10302303088 10761678848 1384503984 14.457 99 21 42 0 1403619184 14469088 4646112
21:55:48 87354 8192000000 10302768720 10755559424 1362533120 14.260 97 22 44 0 1377233648 9707456 4993072
21:58:17 46017 8192000000 10308785552 10763227136 1384233008 14.454 98 22 46 0 1402101296 12713648 5154640
22:00:08 60712 8192000000 10328400864 10781179904 1397113792 14.569 99 29 58 1 1420588624 16911168 6563664
22:02:21 123029 8192000000 10322667936 10791124992 1374944240 14.371 97 20 40 0 1393994192 14714560 4335392
22:05:24 151432 8192000000 10294430032 10751213568 1353281888 14.177 96 17 32 0 1375549568 18455488 3812192
22:09:15 37188 8192000000 9585041056 9931329536 733328368 8.216 53 6 12 0 738978160 4537088 1112704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 25-03-2024 22:12:21 to 25-03-2024 22:12:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-03-2024 22:12:36 to 25-03-2024 22:12:38.

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          169766
MON$OLDEST_ACTIVE               171203
MON$OLDEST_SNAPSHOT             171203
MON$NEXT_TRANSACTION            171203
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                       1914656
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 Mon Mar 25 22:12:39 2024 
 
Database header page information: 
    Flags            0 
    Generation        89296 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    169766 
    Oldest active        171203 
    Oldest snapshot        171203 
    Next transaction    171204 
    Sequence number        0 
    Next attachment ID    697 
    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.42, total records: 7674082 
    Average version length: 48.17, total versions: 75293, 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: 86776 
    Data pages: 86776, average fill: 71% 
    Primary pages: 86776, secondary pages: 0, swept pages: 32552 
    Empty pages: 6, full pages: 51391 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 313 
    40 - 59% = 3916 
    60 - 79% = 82497 
    80 - 99% = 23 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23047, nodes: 7674082 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1683537, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 290 
        20 - 39% = 2004 
        40 - 59% = 3911 
        60 - 79% = 2485 
        80 - 99% = 14357 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13395, nodes: 7674082 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1506345, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1667 
        40 - 59% = 1874 
        60 - 79% = 1154 
        80 - 99% = 8700 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8237, nodes: 7674082 
    Average node length: 6.60, total dup: 5765847, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1499472, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 114 
        20 - 39% = 1060 
        40 - 59% = 1219 
        60 - 79% = 982 
        80 - 99% = 4862 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.40, total records: 2197777 
    Average version length: 34.77, total versions: 76782, max versions: 3 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28496 
    Data pages: 28496, average fill: 71% 
    Primary pages: 28490, secondary pages: 6, swept pages: 13680 
    Empty pages: 6, full pages: 17129 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 215 
    40 - 59% = 2852 
    60 - 79% = 24872 
    80 - 99% = 516 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4480, nodes: 2197777 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 672882, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 959 
        40 - 59% = 751 
        60 - 79% = 788 
        80 - 99% = 1982 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2512, nodes: 2200160 
    Average node length: 4.97, total dup: 2199261, max dup: 18599 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1231997, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 318 
        40 - 59% = 1530 
        60 - 79% = 488 
        80 - 99% = 174 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1986, nodes: 2197777 
    Average node length: 4.97, total dup: 2197727, max dup: 130269 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1048582, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 220 
        40 - 59% = 822 
        60 - 79% = 65 
        80 - 99% = 873 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4281, nodes: 2197777 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 672882, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 82 
        20 - 39% = 676 
        40 - 59% = 526 
        60 - 79% = 859 
        80 - 99% = 2138 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.24, total records: 400 
    Average version length: 22.72, total versions: 225506, max versions: 595 
    Average fragment length: 2.00, total fragments: 56, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1248 
    Data pages: 1248, average fill: 89% 
    Primary pages: 11, secondary pages: 1237, swept pages: 0 
    Empty pages: 4, full pages: 1243 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1244 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 9.06, total records: 87183 
    Average version length: 68.29, total versions: 75620, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 9.71 
    Pointer pages: 7, data page slots: 2552 
    Data pages: 1616, average fill: 67% 
    Primary pages: 1615, secondary pages: 1, swept pages: 0 
    Empty pages: 194, full pages: 941 
    Fill distribution: 
     0 - 19% = 217 
    20 - 39% = 112 
    40 - 59% = 200 
    60 - 79% = 240 
    80 - 99% = 847 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701564, depth: 3, leaf buckets: 375, nodes: 87183 
    Average node length: 13.39, total dup: 6418, max dup: 2 
    Average key length: 10.70, compression ratio: 2.52 
    Average prefix length: 19.22, average data length: 7.78 
    Clustering factor: 63538, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 243 
        40 - 59% = 119 
        60 - 79% = 13 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 16564, max versions: 947 
    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: 84% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 10 
    80 - 99% = 52 
 
    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: 3.71, total records: 1205 
    Average version length: 43.54, total versions: 1105, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 15.65 
    Pointer pages: 1, data page slots: 48 
    Data pages: 36, average fill: 34% 
    Primary pages: 35, secondary pages: 1, swept pages: 1 
    Empty pages: 12, full pages: 5 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 2 
    40 - 59% = 7 
    60 - 79% = 2 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91521, depth: 2, leaf buckets: 2, nodes: 1205 
    Average node length: 4.65, total dup: 1107, max dup: 167 
    Average key length: 2.86, compression ratio: 6.64 
    Average prefix length: 18.22, average data length: 0.78 
    Clustering factor: 636, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.24, total records: 70 
    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: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.64, total records: 816594 
    Average version length: 25.69, total versions: 47354, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8280 
    Data pages: 8272, average fill: 68% 
    Primary pages: 8247, secondary pages: 25, swept pages: 2960 
    Empty pages: 58, full pages: 5707 
    Fill distribution: 
     0 - 19% = 119 
    20 - 39% = 94 
    40 - 59% = 375 
    60 - 79% = 7518 
    80 - 99% = 166 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 905, nodes: 816594 
    Average node length: 4.87, total dup: 816545, max dup: 154591 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89301, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 131 
        40 - 59% = 521 
        60 - 79% = 183 
        80 - 99% = 68 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 959, nodes: 816594 
    Average node length: 5.88, total dup: 726756, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160772, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 115 
        40 - 59% = 431 
        60 - 79% = 116 
        80 - 99% = 294 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 988, nodes: 816594 
    Average node length: 5.88, total dup: 726756, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162730, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 199 
        40 - 59% = 389 
        60 - 79% = 86 
        80 - 99% = 314 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1163, nodes: 816594 
    Average node length: 5.96, total dup: 726756, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155109, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 246 
        40 - 59% = 632 
        60 - 79% = 188 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.82, total records: 5431 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.16, total fragments: 68, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 104 
    Data pages: 103, average fill: 52% 
    Primary pages: 80, secondary pages: 23, swept pages: 56 
    Empty pages: 21, full pages: 66 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5431 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.05 
    Average prefix length: 34.37, average data length: 1.54 
    Clustering factor: 5158, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5431 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 160, 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.09, total records: 78355 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 754 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 754 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35395, depth: 2, leaf buckets: 100, nodes: 78355 
    Average node length: 10.19, total dup: 0, max dup: 0 
    Average key length: 8.20, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3330, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 118.00, total records: 197836 
    Average version length: 154.00, total versions: 43136, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.37 
    Pointer pages: 8, data page slots: 6104 
    Data pages: 4768, average fill: 88% 
    Primary pages: 4768, secondary pages: 0, swept pages: 55 
    Empty pages: 58, full pages: 4695 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 4694 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 134.26, total records: 186010 
    Average version length: 152.45, total versions: 20444, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.63 
    Pointer pages: 8, data page slots: 4936 
    Data pages: 4448, average fill: 87% 
    Primary pages: 4448, secondary pages: 0, swept pages: 38 
    Empty pages: 35, full pages: 4403 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 4404 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 132.28, total records: 171077 
    Average version length: 152.98, total versions: 20769, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.82 
    Pointer pages: 7, data page slots: 5216 
    Data pages: 4072, average fill: 87% 
    Primary pages: 4071, secondary pages: 1, swept pages: 16 
    Empty pages: 18, full pages: 4047 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4046 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 136.91, total records: 179383 
    Average version length: 151.87, total versions: 16711, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.39 
    Pointer pages: 7, data page slots: 6808 
    Data pages: 4280, average fill: 87% 
    Primary pages: 4280, secondary pages: 0, swept pages: 26 
    Empty pages: 25, full pages: 4247 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4247 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 117.89, total records: 188981 
    Average version length: 153.64, total versions: 41231, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.39 
    Pointer pages: 6, data page slots: 5664 
    Data pages: 4496, average fill: 89% 
    Primary pages: 4496, secondary pages: 0, swept pages: 6 
    Empty pages: 5, full pages: 4484 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 4484 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 111.92, total records: 212995 
    Average version length: 154.34, total versions: 55010, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.15 
    Pointer pages: 6, data page slots: 5968 
    Data pages: 5112, average fill: 88% 
    Primary pages: 5112, secondary pages: 0, swept pages: 30 
    Empty pages: 36, full pages: 5066 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 5066 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 138.87, total records: 170580 
    Average version length: 151.19, total versions: 13604, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.21 
    Pointer pages: 10, data page slots: 4752 
    Data pages: 4064, average fill: 87% 
    Primary pages: 4064, secondary pages: 0, swept pages: 3 
    Empty pages: 16, full pages: 4031 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 4 
    40 - 59% = 9 
    60 - 79% = 3 
    80 - 99% = 4030 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 119.76, total records: 213357 
    Average version length: 154.13, total versions: 44009, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.16 
    Pointer pages: 7, data page slots: 5688 
    Data pages: 5112, average fill: 88% 
    Primary pages: 5112, secondary pages: 0, swept pages: 2 
    Empty pages: 36, full pages: 5066 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 5066 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 129.40, total records: 188240 
    Average version length: 153.29, total versions: 27003, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.11 
    Pointer pages: 8, data page slots: 5656 
    Data pages: 4552, average fill: 86% 
    Primary pages: 4551, secondary pages: 1, swept pages: 5 
    Empty pages: 68, full pages: 4453 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 9 
    40 - 59% = 10 
    60 - 79% = 10 
    80 - 99% = 4453 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 141.67, total records: 174684 
    Average version length: 150.74, total versions: 10774, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 7, data page slots: 4608 
    Data pages: 4176, average fill: 87% 
    Primary pages: 4176, secondary pages: 0, swept pages: 1 
    Empty pages: 33, full pages: 4133 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4132 
 
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.79, total records: 2076274 
    Average version length: 52.88, total versions: 37218, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25656 
    Data pages: 25656, average fill: 70% 
    Primary pages: 25656, secondary pages: 0, swept pages: 12125 
    Empty pages: 350, full pages: 19321 
    Fill distribution: 
     0 - 19% = 677 
    20 - 39% = 617 
    40 - 59% = 1482 
    60 - 79% = 22602 
    80 - 99% = 278 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2579, nodes: 2076274 
    Average node length: 5.44, total dup: 1936539, max dup: 1474 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179490, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 287 
        40 - 59% = 1721 
        60 - 79% = 298 
        80 - 99% = 271 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2750, nodes: 2076274 
    Average node length: 5.69, total dup: 1863134, max dup: 70 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370917, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2479 
        60 - 79% = 237 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2116, nodes: 2076274 
    Average node length: 4.96, total dup: 2076174, max dup: 28244 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177624, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 204 
        40 - 59% = 1137 
        60 - 79% = 348 
        80 - 99% = 427 
 
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: 47.01, total records: 131028 
    Average version length: 69.17, total versions: 42009, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.68 
    Pointer pages: 3, data page slots: 4872 
    Data pages: 3432, average fill: 44% 
    Primary pages: 3432, secondary pages: 0, swept pages: 682 
    Empty pages: 750, full pages: 936 
    Fill distribution: 
     0 - 19% = 1022 
    20 - 39% = 403 
    40 - 59% = 707 
    60 - 79% = 681 
    80 - 99% = 619 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101722, depth: 3, leaf buckets: 230, nodes: 131028 
    Average node length: 6.51, total dup: 113975, max dup: 14 
    Average key length: 3.97, compression ratio: 10.57 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 22104, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 73 
        40 - 59% = 115 
        60 - 79% = 40 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.35, total records: 7294039 
    Average version length: 68.75, total versions: 276457, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 66, data page slots: 106920 
    Data pages: 106920, average fill: 73% 
    Primary pages: 106920, secondary pages: 0, swept pages: 48977 
    Empty pages: 6, full pages: 68358 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 382 
    40 - 59% = 7320 
    60 - 79% = 95721 
    80 - 99% = 3473 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10817, nodes: 7294039 
    Average node length: 6.51, total dup: 6306408, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1601268, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1340 
        40 - 59% = 5958 
        60 - 79% = 2958 
        80 - 99% = 557 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8794, nodes: 7294039 
    Average node length: 5.39, total dup: 7005803, max dup: 159 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1398970, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1143 
        40 - 59% = 5023 
        60 - 79% = 1512 
        80 - 99% = 1107 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8858, nodes: 7294039 
    Average node length: 5.39, total dup: 7005803, max dup: 159 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1401462, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1242 
        40 - 59% = 4982 
        60 - 79% = 1548 
        80 - 99% = 1078 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.63, total records: 12214972 
    Average version length: 68.72, total versions: 234509, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 106, data page slots: 171736 
    Data pages: 171736, average fill: 75% 
    Primary pages: 171736, secondary pages: 0, swept pages: 97263 
    Empty pages: 0, full pages: 146161 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 339 
    40 - 59% = 4495 
    60 - 79% = 162894 
    80 - 99% = 3991 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18473, nodes: 12214972 
    Average node length: 6.60, total dup: 10644266, max dup: 57 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2386318, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1969 
        40 - 59% = 10811 
        60 - 79% = 4922 
        80 - 99% = 737 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 45.76, total records: 1640160 
    Average version length: 69.09, total versions: 554700, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.75 
    Pointer pages: 28, data page slots: 45504 
    Data pages: 33056, average fill: 57% 
    Primary pages: 33056, secondary pages: 0, swept pages: 13322 
    Empty pages: 4240, full pages: 17662 
    Fill distribution: 
     0 - 19% = 7399 
    20 - 39% = 3024 
    40 - 59% = 2825 
    60 - 79% = 11578 
    80 - 99% = 8230 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2579, nodes: 1640160 
    Average node length: 5.52, total dup: 1573268, max dup: 97 
    Average key length: 2.57, compression ratio: 16.36 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 114172, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 1071 
        40 - 59% = 1198 
        60 - 79% = 265 
        80 - 99% = 28 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 43.38, total records: 1003144 
    Average version length: 69.13, total versions: 372747, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.90 
    Pointer pages: 23, data page slots: 37248 
    Data pages: 30272, average fill: 39% 
    Primary pages: 30272, secondary pages: 0, swept pages: 10013 
    Empty pages: 7575, full pages: 6931 
    Fill distribution: 
     0 - 19% = 11768 
    20 - 39% = 3756 
    40 - 59% = 4731 
    60 - 79% = 5205 
    80 - 99% = 4812 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1620, nodes: 1003144 
    Average node length: 5.84, total dup: 931722, max dup: 99 
    Average key length: 2.92, compression ratio: 14.38 
    Average prefix length: 41.15, average data length: 0.85 
    Clustering factor: 142296, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 646 
        40 - 59% = 741 
        60 - 79% = 205 
        80 - 99% = 27 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.76, total records: 8696670 
    Average version length: 68.96, total versions: 269084, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 88, data page slots: 142984 
    Data pages: 142936, average fill: 65% 
    Primary pages: 142936, secondary pages: 0, swept pages: 87840 
    Empty pages: 512, full pages: 60217 
    Fill distribution: 
     0 - 19% = 1604 
    20 - 39% = 9725 
    40 - 59% = 30855 
    60 - 79% = 97236 
    80 - 99% = 3516 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13449, nodes: 8696670 
    Average node length: 6.68, total dup: 7212611, max dup: 27 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1834855, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1809 
        40 - 59% = 7502 
        60 - 79% = 3778 
        80 - 99% = 360 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21116524 
    Average version length: 82.77, total versions: 6920, 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: 318456 
    Data pages: 318456, average fill: 81% 
    Primary pages: 318456, secondary pages: 0, swept pages: 14834 
    Empty pages: 51, full pages: 317047 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 54 
    40 - 59% = 206 
    60 - 79% = 28689 
    80 - 99% = 289431 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19310, nodes: 21116524 
    Average node length: 5.72, total dup: 20636160, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3275786, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 8040 
        60 - 79% = 537 
        80 - 99% = 10724 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17154, nodes: 21116524 
    Average node length: 6.31, total dup: 18557223, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913729, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 7 
        40 - 59% = 784 
        60 - 79% = 275 
        80 - 99% = 16084 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21093, nodes: 21116524 
    Average node length: 6.35, total dup: 18476303, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3569622, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2 
        40 - 59% = 8302 
        60 - 79% = 604 
        80 - 99% = 12177 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16073, nodes: 21116524 
    Average node length: 5.56, total dup: 21116424, max dup: 226949 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942486, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2848 
        60 - 79% = 412 
        80 - 99% = 12801 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 80.46, total records: 9094740 
    Average version length: 82.66, total versions: 214091, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 103, data page slots: 167152 
    Data pages: 167104, average fill: 67% 
    Primary pages: 167104, secondary pages: 0, swept pages: 110183 
    Empty pages: 777, full pages: 80054 
    Fill distribution: 
     0 - 19% = 2336 
    20 - 39% = 10047 
    40 - 59% = 33320 
    60 - 79% = 76154 
    80 - 99% = 45247 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11342, nodes: 9094740 
    Average node length: 5.36, total dup: 8790905, max dup: 164 
    Average key length: 2.24, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 1974735, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 174 
        40 - 59% = 9624 
        60 - 79% = 1534 
        80 - 99% = 9 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 12969, nodes: 9094740 
    Average node length: 6.22, total dup: 7537570, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1349800, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 4108 
        40 - 59% = 4089 
        60 - 79% = 2552 
        80 - 99% = 2097 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12660, nodes: 9094740 
    Average node length: 5.98, total dup: 7873384, max dup: 29 
    Average key length: 2.86, compression ratio: 3.14 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2153165, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 212 
        40 - 59% = 10694 
        60 - 79% = 1729 
        80 - 99% = 25 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9700, nodes: 9094740 
    Average node length: 5.12, total dup: 9094640, max dup: 148289 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1396429, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1490 
        40 - 59% = 4607 
        60 - 79% = 1692 
        80 - 99% = 1865 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.49, total records: 10950429 
    Average version length: 82.59, total versions: 240547, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 118, data page slots: 192328 
    Data pages: 190584, average fill: 70% 
    Primary pages: 190584, secondary pages: 0, swept pages: 83354 
    Empty pages: 4045, full pages: 132410 
    Fill distribution: 
     0 - 19% = 7129 
    20 - 39% = 10121 
    40 - 59% = 21705 
    60 - 79% = 44701 
    80 - 99% = 106928 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13138, nodes: 10950429 
    Average node length: 5.29, total dup: 10841107, max dup: 613 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2283467, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 169 
        40 - 59% = 10162 
        60 - 79% = 2745 
        80 - 99% = 60 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10196, nodes: 10950429 
    Average node length: 5.49, total dup: 10470969, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 693600, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 174 
        20 - 39% = 909 
        40 - 59% = 2477 
        60 - 79% = 1809 
        80 - 99% = 4827 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15018, nodes: 10950429 
    Average node length: 6.03, total dup: 9543022, max dup: 74 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.31, average data length: 0.69 
    Clustering factor: 2299673, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 196 
        40 - 59% = 11775 
        60 - 79% = 2966 
        80 - 99% = 78 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10473, nodes: 10950429 
    Average node length: 5.21, total dup: 10950329, max dup: 191836 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 682914, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 915 
        40 - 59% = 4491 
        60 - 79% = 1529 
        80 - 99% = 3431 
 
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: 81.12, total records: 9172805 
    Average version length: 82.94, total versions: 178780, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 105, data page slots: 170904 
    Data pages: 170832, average fill: 66% 
    Primary pages: 170832, secondary pages: 0, swept pages: 118807 
    Empty pages: 828, full pages: 79056 
    Fill distribution: 
     0 - 19% = 2623 
    20 - 39% = 11701 
    40 - 59% = 34964 
    60 - 79% = 78739 
    80 - 99% = 42805 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11354, nodes: 9172805 
    Average node length: 5.16, total dup: 9144357, max dup: 1546 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1788756, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1678 
        40 - 59% = 7564 
        60 - 79% = 1593 
        80 - 99% = 479 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13123, nodes: 9172805 
    Average node length: 6.24, total dup: 7602077, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 1321569, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 4154 
        40 - 59% = 4076 
        60 - 79% = 2510 
        80 - 99% = 2205 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 11960, nodes: 9172805 
    Average node length: 5.42, total dup: 8754817, max dup: 81 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1913637, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1621 
        40 - 59% = 8408 
        60 - 79% = 1471 
        80 - 99% = 433 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 9757, nodes: 9172805 
    Average node length: 5.13, total dup: 9172705, max dup: 150392 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1410979, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1471 
        40 - 59% = 4599 
        60 - 79% = 1726 
        80 - 99% = 1925 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.84, total records: 569104 
    Average version length: 68.75, total versions: 2665, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7976, average fill: 75% 
    Primary pages: 7976, secondary pages: 0, swept pages: 4662 
    Empty pages: 0, full pages: 6325 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 34 
    40 - 59% = 275 
    60 - 79% = 7625 
    80 - 99% = 38 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 47476, depth: 3, leaf buckets: 747, nodes: 569104 
    Average node length: 5.95, total dup: 484396, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 98982, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 566 
        60 - 79% = 80 
        80 - 99% = 71 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 39393, depth: 3, leaf buckets: 772, nodes: 569104 
    Average node length: 6.15, total dup: 466697, max dup: 15 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99032, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 573 
        60 - 79% = 81 
        80 - 99% = 84 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 552, nodes: 569104 
    Average node length: 4.86, total dup: 569004, max dup: 9615 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 87972, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 309 
        60 - 79% = 85 
        80 - 99% = 129 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Mar 25 22:13:02 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7674082 75293 1 0.0000 0.0000
DOC_LIST 2197777 76782 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 225506 595 56300.0000 0.0000
INVNT_TURNOVER_LOG 87183 75620 1 0.0000 0.0000
MONEY_SALDO 49 16564 947 33800.0000 0.0000
MONEY_TURNOVER_LOG 1205 1105 1 0.0000 0.0000
PDISTR 816594 47354 5 0.0000 0.0000
PERF_SPLIT_0 197836 43136 1 0.0000 0.0000
PERF_SPLIT_1 186010 20444 1 0.0000 0.0000
PERF_SPLIT_2 171077 20769 1 0.0000 0.0000
PERF_SPLIT_3 179383 16711 1 0.0000 0.0000
PERF_SPLIT_4 188981 41231 1 0.0000 0.0000
PERF_SPLIT_5 212995 55010 1 0.0000 0.0000
PERF_SPLIT_6 170580 13604 1 0.0000 0.0000
PERF_SPLIT_7 213357 44009 1 0.0000 0.0000
PERF_SPLIT_8 188240 27003 1 0.0000 0.0000
PERF_SPLIT_9 174684 10774 1 0.0000 0.0000
PSTORNED 2076274 37218 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 131028 42009 1 0.0000 0.0000
XQD_1000_3300 7294039 276457 1 0.0000 0.0000
XQD_1200_2000 12214972 234509 1 0.0000 0.0000
XQD_2000_3300 1640160 554700 1 0.0000 0.0000
XQD_2100_3300 1003144 372747 1 0.0000 0.0000
XQD_3300_3400 8696670 269084 1 0.0000 0.0000
XQS_1000_1200 21116524 6920 1 0.0000 0.0000
XQS_1000_3300 9094740 214091 1 0.0000 0.0000
XQS_1200_2000 10950429 240547 1 0.0000 0.0000
XQS_2100_3300 9172805 178780 1 0.0000 0.0000
XQS_3300_3400 569104 2665 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 ---
:332: 
:333: mscs-test-161.budzdorov.ru    Mon Mar 25 22:10:15 2024
:334:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:335: 
--- end of diff output ---

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

25.03.24 22:13:14. 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-25 22:13:17 No severe PSQL-related problems occured
25.03.24 22:13:18. End of report.