Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.04.2024 04:09
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 15394328 kB
MemAvailable 30052972 kB
Buffers 20 kB
Cached 16279152 kB
SwapCached 2492 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 4.0.5
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
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-04-10 04:07:49
DTS_END                         2024-04-10 04:07:49.3450
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/45144
TRN_ID                          180417
ATT_ID                          565
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: 8992.08 24886 899208
customer order: creation 185.96 349 18596
customer order: refuse 16.25 332 1625
order to supplier: creation 49.28 1269 4928
order to supplier: removal 3.51 61257 351
invoice (draft): creation 49.86 3018 4986
invoice (draft): removal 44.81 640 4481
invoice accept: apply 45.35 21146 4535
invoice accept: cancel 40.17 820 4017
customer reserve: creation 4319.12 206 431912
customer reserve: removal 3938.73 44 393873
realization accept: apply 90.18 202 9018
realization accept: cancel 70.74 116 7074
payment from customer: creation 64.52 124 6452
payment from customer: removal 6.55 77 655
payment to supplier: creation 51.82 139 5182
payment to supplier: removal 3.69 78 369
service: total inventory turnovers 4.27 3424 427
service: total monetary turnovers 6.60 454 660
service: aggregate perf. data 0.64 22643 64
service: refresh index statistics 0.03 381389 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 10-04-2024 04:09:38 to 10-04-2024 04:09:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5404
TEST_TIME 2 5112
TEST_TIME 3 6250
TEST_TIME 4 5586
TEST_TIME 5 5536
TEST_TIME 6 5942
TEST_TIME 7 6466
TEST_TIME 8 6370
TEST_TIME 9 7345
TEST_TIME 10 7093
TEST_TIME 11 6955
TEST_TIME 12 6777
TEST_TIME 13 6904
TEST_TIME 14 7460
TEST_TIME 15 7560
TEST_TIME 16 7457
TEST_TIME 17 7536
TEST_TIME 18 7477
TEST_TIME 19 7601
TEST_TIME 20 7647
TEST_TIME 21 7868
TEST_TIME 22 8306
TEST_TIME 23 8287
TEST_TIME 24 8400
TEST_TIME 25 8386
TEST_TIME 26 8247
TEST_TIME 27 8593
TEST_TIME 28 8818
TEST_TIME 29 8856
TEST_TIME 30 8785
TEST_TIME 31 8774
TEST_TIME 32 8718
TEST_TIME 33 9021
TEST_TIME 34 9113
TEST_TIME 35 9166
TEST_TIME 36 9238
TEST_TIME 37 9091
TEST_TIME 38 9019
TEST_TIME 39 9002
TEST_TIME 40 8934
TEST_TIME 41 8905
TEST_TIME 42 8977
TEST_TIME 43 8944
TEST_TIME 44 8826
TEST_TIME 45 8878
TEST_TIME 46 8842
TEST_TIME 47 8914
TEST_TIME 48 8888
TEST_TIME 49 8985
TEST_TIME 50 9072
TEST_TIME 51 9035
TEST_TIME 52 9074
TEST_TIME 53 9127
TEST_TIME 54 9177
TEST_TIME 55 9218
TEST_TIME 56 9157
TEST_TIME 57 9201
TEST_TIME 58 9076
TEST_TIME 59 9018
TEST_TIME 60 9032
TEST_TIME 61 8912
TEST_TIME 62 8883
TEST_TIME 63 8824
TEST_TIME 64 8927
TEST_TIME 65 8968
TEST_TIME 66 8989
TEST_TIME 67 8997
TEST_TIME 68 8980
TEST_TIME 69 8947
TEST_TIME 70 8975
TEST_TIME 71 9015
TEST_TIME 72 9038
TEST_TIME 73 8991
TEST_TIME 74 9024
TEST_TIME 75 9134
TEST_TIME 76 9151
TEST_TIME 77 9090
TEST_TIME 78 9002
TEST_TIME 79 8978
TEST_TIME 80 8924
TEST_TIME 81 8989
TEST_TIME 82 8983
TEST_TIME 83 8994
TEST_TIME 84 8979
TEST_TIME 85 8935
TEST_TIME 86 8960
TEST_TIME 87 9019
TEST_TIME 88 9059
TEST_TIME 89 9023
TEST_TIME 90 9086
TEST_TIME 91 9146
TEST_TIME 92 9165
TEST_TIME 93 9213
TEST_TIME 94 9223
TEST_TIME 95 9129
TEST_TIME 96 9103
TEST_TIME 97 9079
TEST_TIME 98 9039
TEST_TIME 99 9052
TEST_TIME 100 9006

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-04-2024 04:09:42 to 10-04-2024 04:09:45.

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 1292218 1292218 0 0.00 0 22734 8 0 0
doc_list_biud 1292216 1292216 0 0.00 0 28361 18 0 0
sp_add_invoice_to_stock 4723 4535 188 3.98 57 221599 21147 0 188
sp_cancel_adding_invoice 4017 4017 0 0.00 3 78774 820 0 0
sp_cancel_client_order 1625 1625 0 0.00 3 7408 332 0 0
sp_cancel_customer_reserve 393873 393873 0 0.00 0 24696 44 0 0
sp_cancel_pay_from_customer 655 655 0 0.00 2 2741 78 0 0
sp_cancel_pay_to_supplier 369 369 0 0.00 2 4372 78 0 0
sp_cancel_supplier_invoice 4493 4481 12 0.26 2 28406 640 0 12
sp_cancel_supplier_order 351 351 0 0.00 6 534320 61257 0 0
sp_cancel_write_off 7074 7074 0 0.00 1 15172 116 0 0
sp_client_order 18596 18596 0 0.00 3 24173 350 0 0
sp_customer_reserve 431912 431912 0 0.00 0 105559 207 0 0
sp_fill_shopping_cart 28502 28502 0 0.00 1 13034 34 0 0
sp_fill_shopping_cart_clo_res 431895 431895 0 0.00 0 18932 15 0 0
sp_get_clo_for_invoice 4517 4517 0 0.00 0 20219 334 0 0
sp_kill_cost_storno 12115 12115 0 0.00 0 15169 59 0 0
sp_kill_qstorno_ret_qs2qd 799652 799652 0 0.00 0 28359 24 0 0
sp_kill_qty_storno 424954 424954 0 0.00 0 28361 53 0 0
sp_lock_selected_doc 18782 18782 0 0.00 0 5969 5 0 0
sp_make_cost_storno 25166 25166 0 0.00 0 18154 70 0 0
sp_multiply_rows_for_pdistr 25166 25166 0 0.00 0 9501 35 0 0
sp_multiply_rows_for_qdistr 18596 18596 0 0.00 0 15726 156 0 0
sp_pay_from_customer 6452 6452 0 0.00 4 15470 124 0 0
sp_pay_to_supplier 5182 5182 0 0.00 4 11096 139 0 0
sp_payment_common 11633 11633 0 0.00 1 9156 24 0 0
sp_qd_handle_on_cancel_clo 1625 1625 0 0.00 0 7398 303 0 0
sp_qd_handle_on_invoice_upd_sts 8532 8532 0 0.00 0 23955 249 0 0
sp_qd_handle_on_reserve_upd_sts 9018 9018 0 0.00 0 21040 51 0 0
sp_reserve_write_off 9018 9018 0 0.00 6 21130 203 0 0
sp_supplier_invoice 4986 4986 0 0.00 5 67911 3018 0 0
sp_supplier_order 4928 4928 0 0.00 4 30785 1269 0 0
srv_aggregate_perf_data 64 64 0 0.00 2097 368983 22643 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1269 204443 41013 0 0
srv_find_qd_qs_mism 852264 852264 0 0.00 0 22734 7 0 0
srv_make_invnt_saldo 427 427 0 0.00 49 96927 3424 0 0
srv_make_money_saldo 660 660 0 0.00 1 9328 455 0 0
srv_recalc_idx_stat 3 3 0 0.00 174284 626448 381390 0 0
t$perf-abend:sp_add_invoice_to_stock 188 188 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4537 4537 0 0.00 0 29557 168 0 0
t$perf-norm:sp_cancel_adding_invoice 361 361 0 0.00 0 1891 90 0 0
t$perf-norm:sp_cancel_client_order 1625 1625 0 0.00 0 1792 11 0 0
t$perf-norm:sp_cancel_customer_reserve 601 601 0 0.00 0 575 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 655 655 0 0.00 0 1567 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 369 369 0 0.00 0 3010 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 354 354 0 0.00 0 439 9 0 0
t$perf-norm:sp_cancel_supplier_order 351 351 0 0.00 0 21003 1289 0 0
t$perf-norm:sp_cancel_write_off 934 934 0 0.00 0 2994 11 0 0
t$perf-norm:sp_client_order 18596 18596 0 0.00 0 8248 12 0 0
t$perf-norm:sp_customer_reserve 915 915 0 0.00 0 4331 10 0 0
t$perf-norm:sp_pay_from_customer 6452 6452 0 0.00 0 6763 9 0 0
t$perf-norm:sp_pay_to_supplier 5182 5182 0 0.00 0 10826 10 0 0
t$perf-norm:sp_reserve_write_off 9018 9018 0 0.00 0 16002 9 0 0
t$perf-norm:sp_supplier_invoice 4986 4986 0 0.00 0 19072 23 0 0
t$perf-norm:sp_supplier_order 4928 4928 0 0.00 0 33953 19 0 0
t$perf-norm:srv_aggregate_perf_data 64 64 0 0.00 0 525 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 3427 64 0 0
t$perf-norm:srv_make_invnt_saldo 427 427 0 0.00 0 1016 14 0 0
t$perf-norm:srv_make_money_saldo 660 660 0 0.00 0 1610 6 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 55 28 0 0
v_add_invoice_to_stock 9404 9028 376 3.99 0 6597 17 0 376
v_all_customers 34130 34130 0 0.00 0 26 0 0 0
v_all_suppliers 27672 27672 0 0.00 0 32 1 0 0
v_all_wares 37192 37192 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 722 722 0 0.00 0 312 7 0 0
v_cancel_client_order 3250 3250 0 0.00 0 3120 7 0 0
v_cancel_customer_prepayment 1310 1310 0 0.00 0 2707 10 0 0
v_cancel_customer_reserve 1202 1202 0 0.00 0 2561 6 0 0
v_cancel_payment_to_supplier 738 738 0 0.00 0 604 5 0 0
v_cancel_supplier_invoice 732 708 24 3.27 0 2701 19 0 24
v_cancel_supplier_order 702 702 0 0.00 0 3063 15 0 0
v_cancel_write_off 1868 1868 0 0.00 0 3309 18 0 0
v_max_id_clo_ord 4925 4925 0 0.00 0 682 2 0 0
v_max_id_clo_res 915 915 0 0.00 0 1484 7 0 0
v_max_id_ord_sup 4981 4981 0 0.00 0 4187 2 0 0
v_max_non_paid_invoice 1251 1251 0 0.00 0 1108 4 0 0
v_max_non_paid_realizn 3390 3390 0 0.00 0 2251 5 0 0
v_min_id_clo_ord 4925 4925 0 0.00 0 3053 9 0 0
v_min_id_clo_res 915 915 0 0.00 0 6674 24 0 0
v_min_id_ord_sup 4981 4981 0 0.00 0 2980 4 0 0
v_min_non_paid_invoice 5181 5181 0 0.00 0 6806 13 0 0
v_min_non_paid_realizn 6452 6452 0 0.00 0 5988 20 0 0
v_our_firm 9186 9186 0 0.00 0 22 1 0 0
v_reserve_write_off 18036 18036 0 0.00 0 6162 7 0 0
x_lock_depdocs_on_canc_invoice 8144 8144 0 0.00 0 6590 95 0 0
x_lock_depdocs_on_canc_sup_ord 351 351 0 0.00 0 3375 247 0 0
x_make_qstorno_1000_1200 4928 4928 0 0.00 1 30653 1193 0 0
x_make_qstorno_1200_2000 4986 4986 0 0.00 2 67893 2897 0 0
x_make_qstorno_2100_3300 431912 431912 0 0.00 0 105558 189 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 10-04-2024 04:09:46 to 10-04-2024 04:09:51.

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
02:07:53 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
02:08:54 30756 8192000000 9709720160 10007973888 785230720 8.746 100 85 170 0 812868720 7499424 20138576
02:10:38 18132 8192000000 9753457792 10061303808 828597760 9.185 100 87 174 0 860432704 11647888 20187056
02:12:06 12914 8192000000 9780918832 10099437568 856341104 9.464 100 82 164 0 891956560 17205792 18409664
02:13:28 16268 8192000000 9850123744 10184089600 901237312 9.911 100 75 150 0 955727568 38039120 16451136
02:14:50 7149 8192000000 9887417328 10227273728 938049184 10.274 100 80 156 0 996052016 42250544 15752288
02:16:00 4706 8192000000 9934285056 10291826688 976832080 10.653 100 72 142 1 1050086768 59300352 13954336
02:17:07 2566 8192000000 9981960144 10342703104 1000666048 10.885 100 86 170 0 1100254672 83557040 16031584
02:18:12 1920 8192000000 9985603904 10355613696 1023645808 11.107 100 78 152 0 1097131312 59020256 14465248
02:19:16 1064 8192000000 10021367072 10396131328 1046357296 11.326 100 89 173 1 1134346096 70673088 17315712
02:20:18 1625 8192000000 10034235200 10413932544 1059518816 11.452 100 82 164 1 1147820864 71909232 16392816
02:21:22 5360 8192000000 10012444384 10396233728 1063885936 11.494 100 64 127 0 1126732160 51006480 11839744
02:22:29 9133 8192000000 9986118720 10387320832 1071947168 11.571 100 27 54 0 1105452912 28175600 5330144
02:23:39 4970 8192000000 10004814944 10399580160 1075833696 11.608 100 42 85 0 1104820832 21089168 7897968
02:24:45 5967 8192000000 10005689344 10410967040 1083912768 11.685 100 45 91 0 1121967584 28013872 10040944
02:25:54 49413 8192000000 9987834672 10392449024 1082317264 11.670 100 47 91 0 1101793008 9133648 10342096
02:27:44 7473 8192000000 10037500736 10440794112 1089613968 11.739 100 38 72 1 1126698240 29781744 7302528
02:29:04 23908 8192000000 10061700864 10466873344 1099367040 11.832 99 49 98 0 1157715440 49065680 9282720
02:30:33 8430 8192000000 10049622064 10452516864 1095131360 11.791 100 54 107 0 1164663056 59280848 10250848
02:31:45 11229 8192000000 10069482368 10478538752 1096947568 11.809 99 50 100 0 1167387008 60594176 9845264
02:33:00 23872 8192000000 10109938048 10525429760 1113688448 11.967 100 57 112 0 1219859888 94861472 11309968
02:34:29 5008 8192000000 10070995248 10470313984 1104332224 11.879 100 58 114 0 1182092448 65850176 11910048
02:35:37 21391 8192000000 10092567072 10500661248 1102836928 11.865 100 39 78 0 1180514704 69411040 8266736
02:37:02 4764 8192000000 10065022960 10462232576 1101685056 11.854 100 56 108 0 1179945616 67135376 11125184
02:38:15 37715 8192000000 10033532128 10437689344 1074112704 11.591 99 29 53 0 1140012000 59906656 5992640
02:39:58 29743 8192000000 10067597696 10470473728 1071551488 11.567 100 40 80 0 1185356000 104705552 9098960
02:41:53 7062 8192000000 10059338240 10449018880 1075220160 11.602 99 61 121 1 1153222704 65811264 12191280
02:43:05 1268 8192000000 10096009904 10482171904 1086638080 11.711 100 76 148 1 1200064816 98626096 14800640
02:44:09 3687 8192000000 10126677904 10526765056 1100390048 11.841 100 62 124 1 1231799296 119256304 12152944
02:45:16 4916 8192000000 10135301600 10529001472 1105631200 11.891 100 64 126 1 1236666656 118656048 12379408
02:46:24 3807 8192000000 10183921920 10585247744 1110619408 11.938 100 68 134 1 1286451760 161521936 14310416
02:47:30 19343 8192000000 10205492960 10612740096 1111668688 11.948 100 67 130 2 1320411744 195497184 13245872
02:48:55 6947 8192000000 10140339184 10577510400 1117803920 12.006 100 60 118 1 1249065168 119173744 12087504
02:50:05 16511 8192000000 10122999824 10584784896 1114064048 11.971 100 34 66 1 1233529936 112291168 7174720
02:52:00 33608 8192000000 10076612752 10489327616 1117295984 12.001 100 31 62 0 1208769104 85099568 6373552
02:53:37 35089 8192000000 10153530176 10599088128 1123547296 12.060 100 20 40 0 1235103616 107307872 4248448
02:55:13 73879 8192000000 10067431936 10537680896 1129393008 12.116 100 14 28 0 1178131328 46330784 2407536
02:57:28 24869 8192000000 10069483600 10489012224 1134322256 12.162 100 39 77 0 1160908720 18549648 8036816
02:58:58 25496 8192000000 10089955920 10518224896 1142555664 12.240 100 47 94 0 1192848416 41061408 9231344
03:00:26 28269 8192000000 10060622448 10553475072 1124222416 12.067 99 18 36 0 1200911696 72843200 3846080
03:01:56 42766 8192000000 10091535760 10538704896 1134519072 12.164 99 16 33 0 1181461152 43718608 3223472
03:04:06 82834 8192000000 10080728656 10515591168 1125717232 12.081 99 39 76 0 1156886464 23411056 7758176
03:07:03 7094 8192000000 10052765536 10485923840 1126227728 12.086 100 25 49 2 1161380512 30133424 5019360
03:08:19 11006 8192000000 10085729200 10521100288 1130378352 12.125 99 49 95 1 1187804208 47174832 10251024
03:09:32 38925 8192000000 10080309776 10566864896 1111601984 11.948 98 22 44 0 1197121488 80923888 4595616
03:11:11 72680 8192000000 10048318384 10523971584 1098394320 11.822 97 14 28 0 1163808544 62489584 2924640
03:13:25 33477 8192000000 10098694880 10532958208 1131559184 12.136 100 30 60 1 1202269472 64749408 5960880
03:15:03 56554 8192000000 10109696752 10547900416 1090008320 11.743 96 31 62 0 1168262352 71825888 6428144
03:17:02 20108 8192000000 10083132912 10518458368 1107816144 11.912 99 25 50 0 1179764976 66698992 5249840
03:18:29 18059 8192000000 10046958640 10464264192 1075844384 11.608 98 45 90 1 1130201024 45909120 8447520
03:19:47 20480 8192000000 10052966800 10472603648 1061744048 11.473 97 41 82 0 1123799360 54356752 7698560
03:21:08 5386 8192000000 10050791376 10459267072 1088454624 11.728 100 58 113 2 1133655632 34186544 11014464
03:22:15 60571 8192000000 10015493984 10423795712 1047499104 11.337 97 22 42 0 1079601968 27992144 4110720
03:24:19 125406 8192000000 10035366336 10461745152 1087823584 11.722 100 40 79 2 1139490816 43947520 7719712
03:27:57 38048 8192000000 10045267216 10519863296 1084308064 11.689 99 5 10 0 1151948336 66470416 1169856
03:29:40 59082 8192000000 10086014976 10517217280 1092038272 11.762 100 20 40 0 1160990640 64594720 4357648
03:31:51 19868 8192000000 10048115648 10477682688 1086515584 11.710 99 17 34 0 1140328720 50207648 3605488
03:33:20 56869 8192000000 10038318336 10492502016 1068838976 11.541 97 15 30 0 1122896336 50867392 3189968
03:35:57 58326 8192000000 10067990064 10514481152 1092770176 11.769 99 21 42 0 1167365552 70481680 4113696
03:37:56 102237 8192000000 10059467744 10552053760 1106691632 11.901 99 18 36 0 1159358432 49368144 3298656
03:40:38 82062 8192000000 10118879520 10578591744 1122667872 12.052 100 23 46 0 1194666544 67386800 4611872
03:43:10 111858 8192000000 10063707600 10523959296 1090691680 11.749 97 14 28 0 1138392464 45524576 2176208
03:46:03 57937 8192000000 10065927600 10529169408 1111222080 11.944 99 19 38 0 1163010192 48206928 3581184
03:48:01 68232 8192000000 10091104192 10620796928 1125936944 12.083 100 21 42 0 1216140208 85502272 4700992
03:50:14 72703 8192000000 10064162992 10501296128 1118856832 12.016 99 32 65 0 1158553696 33038672 6658192
03:52:29 27458 8192000000 10102178240 10525896704 1133683440 12.156 100 46 92 1 1194381680 50772112 9926128
03:54:01 53046 8192000000 10091146560 10588909568 1126238864 12.086 99 6 12 0 1216585824 89120480 1226480
03:56:29 40162 8192000000 10127943120 10576572416 1123040288 12.056 100 17 34 0 1207536224 80989904 3506032
03:58:38 65334 8192000000 10105517360 10533834752 1121506848 12.041 99 23 44 0 1178663392 52433520 4723024
04:01:50 84397 8192000000 10072415856 10512416768 1106867648 11.903 98 23 46 1 1155535296 44074528 4593120
04:04:21 204443 8192000000 10056214256 10507239424 1047711376 11.339 93 30 60 0 1134051152 80323344 6016432

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 10-04-2024 04:09:53 to 10-04-2024 04:10:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 188 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-04-2024 04:10:07 to 10-04-2024 04:10:09.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          177436
MON$OLDEST_ACTIVE               180591
MON$OLDEST_SNAPSHOT             180591
MON$NEXT_TRANSACTION            180591
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-30 07:30:08.6030 GMT
MON$PAGES                       1929504
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             705
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3083 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3083 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Wed Apr 10 04:10:10 2024 
 
Database header page information: 
    Flags            0 
    Generation        94482 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    177436 
    Oldest active        180591 
    Oldest snapshot        180591 
    Next transaction    180592 
    Sequence number        0 
    Next attachment ID    705 
    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 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    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: 1504333, 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: 1504335, 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: 1504334, 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: 1504332, 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: 1504331, 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: 532, Index root page: 533 
    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: 1504264, 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: 1504266, 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: 1504265, 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: 1504263, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.50, total records: 7827152 
    Average version length: 48.16, total versions: 79282, 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: 56, data page slots: 90576 
    Data pages: 90576, average fill: 69% 
    Primary pages: 90575, secondary pages: 1, swept pages: 41162 
    Empty pages: 2, full pages: 63632 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 134 
    40 - 59% = 3598 
    60 - 79% = 86781 
    80 - 99% = 44 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23303, nodes: 7827152 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.05, average data length: 12.95 
    Clustering factor: 1675243, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 353 
        20 - 39% = 1589 
        40 - 59% = 4145 
        60 - 79% = 2194 
        80 - 99% = 15022 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13528, nodes: 7827152 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1500687, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1499 
        40 - 59% = 2049 
        60 - 79% = 1002 
        80 - 99% = 8978 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8342, nodes: 7827152 
    Average node length: 6.64, total dup: 5821547, max dup: 49 
    Average key length: 3.65, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1493584, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 130 
        20 - 39% = 874 
        40 - 59% = 1408 
        60 - 79% = 794 
        80 - 99% = 5136 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.65, total records: 2295348 
    Average version length: 58.86, total versions: 39122, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 19, data page slots: 29856 
    Data pages: 29856, average fill: 71% 
    Primary pages: 29856, secondary pages: 0, swept pages: 12788 
    Empty pages: 0, full pages: 16845 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 51 
    40 - 59% = 1088 
    60 - 79% = 28619 
    80 - 99% = 88 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4585, nodes: 2295348 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 685264, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 910 
        40 - 59% = 839 
        60 - 79% = 613 
        80 - 99% = 2223 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2468, nodes: 2296381 
    Average node length: 4.97, total dup: 2295482, max dup: 19183 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1265252, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 214 
        40 - 59% = 1435 
        60 - 79% = 541 
        80 - 99% = 278 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1878, nodes: 2295348 
    Average node length: 4.97, total dup: 2295298, max dup: 130397 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1101497, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 735 
        60 - 79% = 32 
        80 - 99% = 1103 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4402, nodes: 2295348 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 685264, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 595 
        40 - 59% = 598 
        60 - 79% = 703 
        80 - 99% = 2385 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    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: 1504337, 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: 1504338, 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: 1504336, 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: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, 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.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, 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: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.41, total records: 400 
    Average version length: 27.85, total versions: 2520, max versions: 8 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 60% 
    Primary pages: 8, secondary pages: 24, swept pages: 0 
    Empty pages: 1, full pages: 15 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 16 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, 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: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 12.55, total records: 97782 
    Average version length: 68.30, total versions: 91935, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.01 
    Pointer pages: 5, data page slots: 3288 
    Data pages: 1704, average fill: 78% 
    Primary pages: 1703, secondary pages: 1, swept pages: 0 
    Empty pages: 93, full pages: 1288 
    Fill distribution: 
     0 - 19% = 134 
    20 - 39% = 64 
    40 - 59% = 106 
    60 - 79% = 246 
    80 - 99% = 1154 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1699955, depth: 3, leaf buckets: 309, nodes: 97782 
    Average node length: 13.42, total dup: 7237, max dup: 2 
    Average key length: 10.68, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 71815, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 60 
        40 - 59% = 160 
        60 - 79% = 69 
        80 - 99% = 19 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 181, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 79% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, 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: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.77, total records: 1534 
    Average version length: 43.54, total versions: 1367, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.54 
    Pointer pages: 1, data page slots: 56 
    Data pages: 40, average fill: 40% 
    Primary pages: 39, secondary pages: 1, swept pages: 14 
    Empty pages: 17, full pages: 16 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92574, depth: 2, leaf buckets: 2, nodes: 1534 
    Average node length: 4.24, total dup: 1437, max dup: 171 
    Average key length: 2.68, compression ratio: 7.10 
    Average prefix length: 18.39, average data length: 0.61 
    Clustering factor: 835, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.59, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    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: 548, Index root page: 549 
    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: 1504251, 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: 1504249, 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: 1504248, 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: 1504250, 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: 1504247, 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: 550, Index root page: 551 
    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: 1504246, 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: 1504244, 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: 1504243, 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: 1504245, 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: 1504242, 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: 496, Index root page: 497 
    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: 1544827, 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: 1544826, 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: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.42, total records: 749218 
    Average version length: 37.92, total versions: 26110, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 5, data page slots: 8008 
    Data pages: 8008, average fill: 64% 
    Primary pages: 8007, secondary pages: 1, swept pages: 2088 
    Empty pages: 8, full pages: 4398 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 52 
    40 - 59% = 1075 
    60 - 79% = 6821 
    80 - 99% = 47 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 798, nodes: 736920 
    Average node length: 4.87, total dup: 736871, max dup: 134848 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88303, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 123 
        40 - 59% = 425 
        60 - 79% = 148 
        80 - 99% = 101 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 772, nodes: 736920 
    Average node length: 5.88, total dup: 655835, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 152702, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 242 
        60 - 79% = 169 
        80 - 99% = 329 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 802, nodes: 736920 
    Average node length: 5.88, total dup: 655835, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 154475, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 92 
        40 - 59% = 222 
        60 - 79% = 169 
        80 - 99% = 319 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1071, nodes: 736920 
    Average node length: 5.97, total dup: 655835, max dup: 42 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 147403, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 291 
        40 - 59% = 515 
        60 - 79% = 185 
        80 - 99% = 79 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5489 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.36, total fragments: 42, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 75, secondary pages: 13, swept pages: 59 
    Empty pages: 8, full pages: 56 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5489 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.10 
    Average prefix length: 34.50, average data length: 1.54 
    Clustering factor: 5084, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5489 
    Average node length: 11.13, 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: 151, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 81691 
    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: 856 
    Data pages: 856, average fill: 65% 
    Primary pages: 856, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 848 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 848 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32659, depth: 2, leaf buckets: 104, nodes: 81691 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.84, average data length: 5.16 
    Clustering factor: 3395, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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: 1504261, 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: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    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: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.50, total records: 156031 
    Average version length: 152.68, total versions: 1647, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 6, data page slots: 4400 
    Data pages: 3896, average fill: 83% 
    Primary pages: 3893, secondary pages: 3, swept pages: 3 
    Empty pages: 57, full pages: 3825 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3825 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 151.06, total records: 132935 
    Average version length: 136.67, total versions: 164, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 7, data page slots: 4248 
    Data pages: 3304, average fill: 83% 
    Primary pages: 3302, secondary pages: 2, swept pages: 5 
    Empty pages: 30, full pages: 3261 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3260 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.23, total records: 143767 
    Average version length: 151.93, total versions: 785, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 4352 
    Data pages: 3552, average fill: 83% 
    Primary pages: 3550, secondary pages: 2, swept pages: 2 
    Empty pages: 18, full pages: 3523 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3523 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.22, total records: 150259 
    Average version length: 152.96, total versions: 1821, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 6, data page slots: 4264 
    Data pages: 3720, average fill: 83% 
    Primary pages: 3718, secondary pages: 2, swept pages: 3 
    Empty pages: 29, full pages: 3683 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 0 
    80 - 99% = 3683 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 149.46, total records: 149293 
    Average version length: 152.54, total versions: 1421, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 5808 
    Data pages: 3760, average fill: 82% 
    Primary pages: 3758, secondary pages: 2, swept pages: 6 
    Empty pages: 87, full pages: 3649 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 3649 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 142.30, total records: 155047 
    Average version length: 155.42, total versions: 9499, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.92 
    Pointer pages: 6, data page slots: 4608 
    Data pages: 3848, average fill: 84% 
    Primary pages: 3846, secondary pages: 2, swept pages: 1 
    Empty pages: 29, full pages: 3806 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 3806 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.24, total records: 142738 
    Average version length: 152.23, total versions: 1594, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 6, data page slots: 3872 
    Data pages: 3568, average fill: 82% 
    Primary pages: 3564, secondary pages: 4, swept pages: 7 
    Empty pages: 56, full pages: 3495 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 0 
    80 - 99% = 3495 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 150.83, total records: 153232 
    Average version length: 137.53, total versions: 182, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 6, data page slots: 4088 
    Data pages: 3816, average fill: 83% 
    Primary pages: 3813, secondary pages: 3, swept pages: 4 
    Empty pages: 50, full pages: 3752 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3752 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 141.43, total records: 172616 
    Average version length: 154.63, total versions: 11774, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.99 
    Pointer pages: 6, data page slots: 5064 
    Data pages: 4296, average fill: 84% 
    Primary pages: 4294, secondary pages: 2, swept pages: 6 
    Empty pages: 47, full pages: 4230 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 9 
    80 - 99% = 4231 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 149.67, total records: 144252 
    Average version length: 150.48, total versions: 1064, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 5, data page slots: 3784 
    Data pages: 3584, average fill: 83% 
    Primary pages: 3582, secondary pages: 2, swept pages: 5 
    Empty pages: 41, full pages: 3528 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3528 
 
PHRASES (143) 
    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 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, 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: 1510375, 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: 1510374, 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: 1510373, 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: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.08, total records: 2155793 
    Average version length: 52.92, total versions: 33170, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 17, data page slots: 26688 
    Data pages: 26688, average fill: 70% 
    Primary pages: 26673, secondary pages: 15, swept pages: 12839 
    Empty pages: 180, full pages: 21377 
    Fill distribution: 
     0 - 19% = 381 
    20 - 39% = 358 
    40 - 59% = 1255 
    60 - 79% = 24366 
    80 - 99% = 328 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2632, nodes: 2155793 
    Average node length: 5.44, total dup: 2013139, max dup: 1654 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183379, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 246 
        40 - 59% = 1768 
        60 - 79% = 319 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2772, nodes: 2155793 
    Average node length: 5.69, total dup: 1935393, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 382426, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2253 
        60 - 79% = 482 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2162, nodes: 2155793 
    Average node length: 4.96, total dup: 2155693, max dup: 28391 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181728, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 210 
        40 - 59% = 1117 
        60 - 79% = 358 
        80 - 99% = 474 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    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: 1504339, 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: 498, Index root page: 499 
    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: 1544825, 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: 1544824, 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: 528, Index root page: 529 
    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: 1504327, 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: 1504328, 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: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, 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: 1 
    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: 1544931, 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: 1544828, 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: 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 TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, 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: 488, Index root page: 489 
    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: 1544829, 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: 490, Index root page: 491 
    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: 492, Index root page: 493 
    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: 546, Index root page: 547 
    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: 544, Index root page: 545 
    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: 1504252, 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: 486, Index root page: 487 
    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: 484, Index root page: 485 
    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: 1544831, 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: 1544830, 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: 480, Index root page: 481 
    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: 1544833, 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: 557, Index root page: 558 
    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: 1504237, 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: 538, Index root page: 539 
    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: 508, Index root page: 509 
    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: 1552183, 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: 1510377, 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: 1510382, 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: 1510380, 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: 526, Index root page: 527 
    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: 1504329, 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: 1504330, 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: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 45.08, total records: 128290 
    Average version length: 69.18, total versions: 51446, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.80 
    Pointer pages: 3, data page slots: 3608 
    Data pages: 2952, average fill: 53% 
    Primary pages: 2952, secondary pages: 0, swept pages: 351 
    Empty pages: 351, full pages: 1185 
    Fill distribution: 
     0 - 19% = 612 
    20 - 39% = 352 
    40 - 59% = 505 
    60 - 79% = 822 
    80 - 99% = 661 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104247, depth: 3, leaf buckets: 227, nodes: 128290 
    Average node length: 6.40, total dup: 111619, max dup: 14 
    Average key length: 3.98, compression ratio: 10.56 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 22992, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 92 
        40 - 59% = 97 
        60 - 79% = 36 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.09, total records: 6727561 
    Average version length: 68.82, total versions: 323155, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 65, data page slots: 104608 
    Data pages: 104608, average fill: 69% 
    Primary pages: 104606, secondary pages: 2, swept pages: 31675 
    Empty pages: 39, full pages: 53266 
    Fill distribution: 
     0 - 19% = 245 
    20 - 39% = 1405 
    40 - 59% = 12372 
    60 - 79% = 89437 
    80 - 99% = 1149 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10516, nodes: 6727561 
    Average node length: 6.52, total dup: 5817371, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1548027, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1979 
        40 - 59% = 5865 
        60 - 79% = 2232 
        80 - 99% = 431 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8029, nodes: 6727561 
    Average node length: 5.41, total dup: 6451747, max dup: 150 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1368889, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1156 
        40 - 59% = 4150 
        60 - 79% = 1637 
        80 - 99% = 1073 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8060, nodes: 6727561 
    Average node length: 5.41, total dup: 6451747, max dup: 150 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1371296, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1199 
        40 - 59% = 4103 
        60 - 79% = 1658 
        80 - 99% = 1096 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.47, total records: 11730486 
    Average version length: 68.79, total versions: 289311, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 106, data page slots: 172640 
    Data pages: 172640, average fill: 72% 
    Primary pages: 172639, secondary pages: 1, swept pages: 79144 
    Empty pages: 9, full pages: 130857 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 780 
    40 - 59% = 7952 
    60 - 79% = 162092 
    80 - 99% = 1745 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18275, nodes: 11727939 
    Average node length: 6.60, total dup: 10224175, max dup: 60 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2416187, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 2747 
        40 - 59% = 10725 
        60 - 79% = 4026 
        80 - 99% = 746 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 47.92, total records: 1553090 
    Average version length: 69.05, total versions: 318918, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.63 
    Pointer pages: 25, data page slots: 40488 
    Data pages: 33440, average fill: 48% 
    Primary pages: 33363, secondary pages: 77, swept pages: 13339 
    Empty pages: 5746, full pages: 17520 
    Fill distribution: 
     0 - 19% = 8661 
    20 - 39% = 5483 
    40 - 59% = 3117 
    60 - 79% = 11909 
    80 - 99% = 4270 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 2001, nodes: 1323760 
    Average node length: 5.53, total dup: 1269938, max dup: 49 
    Average key length: 2.57, compression ratio: 16.32 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 92660, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 746 
        40 - 59% = 940 
        60 - 79% = 272 
        80 - 99% = 31 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 48.82, total records: 984555 
    Average version length: 69.02, total versions: 98052, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.58 
    Pointer pages: 15, data page slots: 24240 
    Data pages: 24096, average fill: 40% 
    Primary pages: 24096, secondary pages: 0, swept pages: 6570 
    Empty pages: 1656, full pages: 4933 
    Fill distribution: 
     0 - 19% = 5052 
    20 - 39% = 6218 
    40 - 59% = 7942 
    60 - 79% = 4835 
    80 - 99% = 49 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1171, nodes: 751120 
    Average node length: 5.93, total dup: 692880, max dup: 61 
    Average key length: 3.00, compression ratio: 14.02 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 111110, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 350 
        40 - 59% = 612 
        60 - 79% = 197 
        80 - 99% = 10 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.02, total records: 9365637 
    Average version length: 69.01, total versions: 289495, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 93, data page slots: 150392 
    Data pages: 150392, average fill: 67% 
    Primary pages: 150379, secondary pages: 13, swept pages: 79855 
    Empty pages: 180, full pages: 54732 
    Fill distribution: 
     0 - 19% = 510 
    20 - 39% = 2886 
    40 - 59% = 29038 
    60 - 79% = 116230 
    80 - 99% = 1728 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13600, nodes: 9362612 
    Average node length: 6.74, total dup: 7761950, max dup: 20 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2076433, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1053 
        40 - 59% = 6732 
        60 - 79% = 5076 
        80 - 99% = 736 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21173821 
    Average version length: 82.99, total versions: 6498, 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: 197, data page slots: 320416 
    Data pages: 320416, average fill: 81% 
    Primary pages: 320409, secondary pages: 7, swept pages: 14558 
    Empty pages: 67, full pages: 318834 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 83 
    40 - 59% = 223 
    60 - 79% = 50053 
    80 - 99% = 269944 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19327, nodes: 21173821 
    Average node length: 5.72, total dup: 20692272, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3287371, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 0 
        40 - 59% = 7951 
        60 - 79% = 576 
        80 - 99% = 10791 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17197, nodes: 21173821 
    Average node length: 6.31, total dup: 18607835, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918581, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 4 
        40 - 59% = 754 
        60 - 79% = 296 
        80 - 99% = 16139 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21096, nodes: 21173821 
    Average node length: 6.35, total dup: 18526135, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3581706, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8198 
        60 - 79% = 638 
        80 - 99% = 12255 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16287, nodes: 21173821 
    Average node length: 5.56, total dup: 21173721, max dup: 229568 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947531, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 14 
        40 - 59% = 3262 
        60 - 79% = 324 
        80 - 99% = 12686 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.67, total records: 9767337 
    Average version length: 82.69, total versions: 233757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 107, data page slots: 174128 
    Data pages: 174128, average fill: 69% 
    Primary pages: 174109, secondary pages: 19, swept pages: 104594 
    Empty pages: 289, full pages: 81304 
    Fill distribution: 
     0 - 19% = 818 
    20 - 39% = 3769 
    40 - 59% = 26568 
    60 - 79% = 122944 
    80 - 99% = 20029 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11415, nodes: 9767337 
    Average node length: 5.42, total dup: 9454667, max dup: 199 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2200843, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 90 
        40 - 59% = 7573 
        60 - 79% = 3643 
        80 - 99% = 106 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13536, nodes: 9767337 
    Average node length: 6.29, total dup: 8093003, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1525335, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 111 
        20 - 39% = 4009 
        40 - 59% = 4124 
        60 - 79% = 2568 
        80 - 99% = 2724 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12750, nodes: 9767337 
    Average node length: 6.04, total dup: 8471081, max dup: 35 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2387647, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 113 
        40 - 59% = 8578 
        60 - 79% = 3920 
        80 - 99% = 134 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10357, nodes: 9767337 
    Average node length: 5.19, total dup: 9767237, max dup: 146255 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1577267, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 52 
        20 - 39% = 1318 
        40 - 59% = 5117 
        60 - 79% = 1771 
        80 - 99% = 2099 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.09, total records: 11503703 
    Average version length: 82.57, total versions: 193272, 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: 119, data page slots: 193672 
    Data pages: 192456, average fill: 73% 
    Primary pages: 192356, secondary pages: 100, swept pages: 71400 
    Empty pages: 1629, full pages: 147867 
    Fill distribution: 
     0 - 19% = 3084 
    20 - 39% = 5335 
    40 - 59% = 15273 
    60 - 79% = 101143 
    80 - 99% = 67621 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13142, nodes: 11503703 
    Average node length: 5.34, total dup: 11393070, max dup: 670 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2410280, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 69 
        40 - 59% = 8412 
        60 - 79% = 4445 
        80 - 99% = 216 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10563, nodes: 11503703 
    Average node length: 5.54, total dup: 11002509, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 741082, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 790 
        40 - 59% = 2608 
        60 - 79% = 1752 
        80 - 99% = 5268 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15038, nodes: 11503703 
    Average node length: 6.07, total dup: 10038960, max dup: 64 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2426790, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 97 
        40 - 59% = 9871 
        60 - 79% = 4838 
        80 - 99% = 231 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10886, nodes: 11503703 
    Average node length: 5.26, total dup: 11503603, max dup: 186595 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 729116, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 824 
        40 - 59% = 4572 
        60 - 79% = 1557 
        80 - 99% = 3839 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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: 1361775, 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: 1361777, 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: 1361776, 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: 1361774, 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: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 76.67, total records: 10518284 
    Average version length: 82.82, total versions: 865763, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 109, data page slots: 176416 
    Data pages: 176408, average fill: 75% 
    Primary pages: 176392, secondary pages: 16, swept pages: 63583 
    Empty pages: 26, full pages: 127828 
    Fill distribution: 
     0 - 19% = 225 
    20 - 39% = 1681 
    40 - 59% = 13724 
    60 - 79% = 113826 
    80 - 99% = 46952 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12627, nodes: 10518284 
    Average node length: 5.24, total dup: 10488052, max dup: 1653 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2143435, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1258 
        40 - 59% = 8502 
        60 - 79% = 2134 
        80 - 99% = 706 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 14077, nodes: 10518284 
    Average node length: 6.31, total dup: 8719944, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1608961, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 214 
        20 - 39% = 2938 
        40 - 59% = 5284 
        60 - 79% = 2374 
        80 - 99% = 3267 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 13346, nodes: 10518284 
    Average node length: 5.50, total dup: 10050760, max dup: 97 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2286983, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1239 
        40 - 59% = 9582 
        60 - 79% = 1844 
        80 - 99% = 655 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 11113, nodes: 10518284 
    Average node length: 5.22, total dup: 10518184, max dup: 159346 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1706015, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1152 
        40 - 59% = 5903 
        60 - 79% = 1810 
        80 - 99% = 2214 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.23, total records: 599122 
    Average version length: 68.83, total versions: 19718, 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: 6, data page slots: 8240 
    Data pages: 8240, average fill: 77% 
    Primary pages: 8239, secondary pages: 1, swept pages: 1820 
    Empty pages: 4, full pages: 8232 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 7761 
    80 - 99% = 473 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42903, depth: 3, leaf buckets: 748, nodes: 599122 
    Average node length: 5.95, total dup: 510596, max dup: 83 
    Average key length: 3.08, compression ratio: 2.92 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 104449, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 14 
        40 - 59% = 504 
        60 - 79% = 137 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31351, depth: 3, leaf buckets: 771, nodes: 599122 
    Average node length: 6.15, total dup: 491676, max dup: 27 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 104507, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 15 
        40 - 59% = 520 
        60 - 79% = 136 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 570, nodes: 599122 
    Average node length: 4.86, total dup: 599022, max dup: 10150 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 92790, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 13 
        40 - 59% = 340 
        60 - 79% = 57 
        80 - 99% = 158 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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: 563, Index root page: 564 
    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: 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 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    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: 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 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    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: 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 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    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: 1504235, 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: 1504236, 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: 571, Index root page: 572 
    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: 1504232, 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: 1504231, 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: 1504234, 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: 1504233, 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: 561, Index root page: 562 
    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: 559, Index root page: 560 
    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: 512, Index root page: 513 
    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: 1510372, 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 Wed Apr 10 04:10:35 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7827152 79282 1 0.0000 0.0000
DOC_LIST 2295348 39122 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2520 8 600.0000 0.0000
INVNT_TURNOVER_LOG 97782 91935 1 0.0000 0.0000
MONEY_SALDO 49 181 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1534 1367 1 0.0000 0.0000
PDISTR 749218 26110 3 0.0000 0.0000
PERF_SPLIT_0 156031 1647 1 0.0000 0.0000
PERF_SPLIT_1 132935 164 1 0.0000 0.0000
PERF_SPLIT_2 143767 785 1 0.0000 0.0000
PERF_SPLIT_3 150259 1821 1 0.0000 0.0000
PERF_SPLIT_4 149293 1421 1 0.0000 0.0000
PERF_SPLIT_5 155047 9499 1 0.0000 0.0000
PERF_SPLIT_6 142738 1594 1 0.0000 0.0000
PERF_SPLIT_7 153232 182 1 0.0000 0.0000
PERF_SPLIT_8 172616 11774 1 0.0000 0.0000
PERF_SPLIT_9 144252 1064 1 0.0000 0.0000
PSTORNED 2155793 33170 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 128290 51446 1 0.0000 0.0000
XQD_1000_3300 6727561 323155 1 0.0000 0.0000
XQD_1200_2000 11730486 289311 1 0.0000 0.0000
XQD_2000_3300 1553090 318918 1 0.0000 0.0000
XQD_2100_3300 984555 98052 1 0.0000 0.0000
XQD_3300_3400 9365637 289495 1 0.0000 0.0000
XQS_1000_1200 21173821 6498 1 0.0000 0.0000
XQS_1000_3300 9767337 233757 1 0.0000 0.0000
XQS_1200_2000 11503703 193272 1 0.0000 0.0000
XQS_2100_3300 10518284 865763 1 0.0000 0.0000
XQS_3300_3400 599122 19718 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test 

--- start of diff output ---
--- end of diff output ---

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

10.04.24 04:10:47. There are 3 logs in /var/tmp/logs-oltp40 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-04-10 04:10:49 No severe PSQL-related problems occured
10.04.24 04:10:51. End of report.