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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15675136 kB
MemAvailable 30198652 kB
Buffers 0 kB
Cached 16062600 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 3.0.12
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-01 22:09:45
DTS_END                         2024-04-01 22:09:45.9790
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56954
TRN_ID                          183034
ATT_ID                          576
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: 9208.60 20292 920860
customer order: creation 189.01 369 18901
customer order: refuse 15.96 400 1596
order to supplier: creation 49.91 1425 4991
order to supplier: removal 3.37 96223 337
invoice (draft): creation 50.23 3569 5023
invoice (draft): removal 46.73 930 4673
invoice accept: apply 46.08 22560 4608
invoice accept: cancel 42.35 1018 4235
customer reserve: creation 4319.83 221 431983
customer reserve: removal 4136.95 61 413695
realization accept: apply 89.06 197 8906
realization accept: cancel 78.02 133 7802
payment from customer: creation 64.78 123 6478
payment from customer: removal 6.19 96 619
payment to supplier: creation 53.03 161 5303
payment to supplier: removal 3.72 118 372
service: total inventory turnovers 5.30 1175 530
service: total monetary turnovers 7.19 39 719
service: aggregate perf. data 0.86 18969 86
service: refresh index statistics 0.03 258046 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-04-2024 22:10:51 to 01-04-2024 22:10:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5747
TEST_TIME 2 5192
TEST_TIME 3 4239
TEST_TIME 4 3988
TEST_TIME 5 4814
TEST_TIME 6 5123
TEST_TIME 7 5408
TEST_TIME 8 5292
TEST_TIME 9 5487
TEST_TIME 10 5382
TEST_TIME 11 5422
TEST_TIME 12 5756
TEST_TIME 13 6096
TEST_TIME 14 6301
TEST_TIME 15 6265
TEST_TIME 16 6216
TEST_TIME 17 6653
TEST_TIME 18 6668
TEST_TIME 19 6819
TEST_TIME 20 7054
TEST_TIME 21 7106
TEST_TIME 22 7417
TEST_TIME 23 7375
TEST_TIME 24 7550
TEST_TIME 25 7938
TEST_TIME 26 8112
TEST_TIME 27 8282
TEST_TIME 28 8448
TEST_TIME 29 8296
TEST_TIME 30 8722
TEST_TIME 31 9355
TEST_TIME 32 9360
TEST_TIME 33 9456
TEST_TIME 34 9433
TEST_TIME 35 9478
TEST_TIME 36 9358
TEST_TIME 37 9357
TEST_TIME 38 9219
TEST_TIME 39 9212
TEST_TIME 40 9172
TEST_TIME 41 9134
TEST_TIME 42 9036
TEST_TIME 43 9018
TEST_TIME 44 8932
TEST_TIME 45 8985
TEST_TIME 46 8866
TEST_TIME 47 9121
TEST_TIME 48 9014
TEST_TIME 49 9017
TEST_TIME 50 8905
TEST_TIME 51 8994
TEST_TIME 52 9224
TEST_TIME 53 9221
TEST_TIME 54 9177
TEST_TIME 55 9225
TEST_TIME 56 9341
TEST_TIME 57 9350
TEST_TIME 58 9306
TEST_TIME 59 9316
TEST_TIME 60 9357
TEST_TIME 61 9390
TEST_TIME 62 9380
TEST_TIME 63 9297
TEST_TIME 64 9233
TEST_TIME 65 9252
TEST_TIME 66 9145
TEST_TIME 67 9171
TEST_TIME 68 9148
TEST_TIME 69 9088
TEST_TIME 70 9117
TEST_TIME 71 9064
TEST_TIME 72 9006
TEST_TIME 73 8997
TEST_TIME 74 9010
TEST_TIME 75 9016
TEST_TIME 76 9049
TEST_TIME 77 9103
TEST_TIME 78 9104
TEST_TIME 79 9165
TEST_TIME 80 9182
TEST_TIME 81 9206
TEST_TIME 82 9251
TEST_TIME 83 9249
TEST_TIME 84 9298
TEST_TIME 85 9258
TEST_TIME 86 9309
TEST_TIME 87 9247
TEST_TIME 88 9196
TEST_TIME 89 9188
TEST_TIME 90 9160
TEST_TIME 91 9172
TEST_TIME 92 9118
TEST_TIME 93 9147
TEST_TIME 94 9106
TEST_TIME 95 9098
TEST_TIME 96 9143
TEST_TIME 97 9103
TEST_TIME 98 9133
TEST_TIME 99 9198
TEST_TIME 100 9213

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-04-2024 22:10:54 to 01-04-2024 22:10:57.

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 1314154 1314154 0 0.00 0 33937 8 0 0
doc_list_biud 1314154 1314154 0 0.00 0 41525 25 0 0
sp_add_invoice_to_stock 4732 4608 124 2.62 10 177026 22561 0 124
sp_cancel_adding_invoice 4235 4235 0 0.00 4 82618 1018 0 0
sp_cancel_client_order 1596 1596 0 0.00 4 12826 400 0 0
sp_cancel_customer_reserve 413695 413695 0 0.00 1 21811 61 0 0
sp_cancel_pay_from_customer 619 619 0 0.00 3 6673 96 0 0
sp_cancel_pay_to_supplier 372 372 0 0.00 3 7117 118 0 0
sp_cancel_supplier_invoice 4681 4673 8 0.17 2 41540 930 0 8
sp_cancel_supplier_order 337 337 0 0.00 6 1047801 96223 0 0
sp_cancel_write_off 7802 7802 0 0.00 1 7881 133 0 0
sp_client_order 18901 18901 0 0.00 3 32129 369 0 0
sp_customer_reserve 431983 431983 0 0.00 0 67944 222 0 0
sp_fill_shopping_cart 28901 28901 0 0.00 1 13434 40 0 0
sp_fill_shopping_cart_clo_res 431969 431969 0 0.00 0 17339 17 0 0
sp_get_clo_for_invoice 4594 4594 0 0.00 0 28906 288 0 0
sp_kill_cost_storno 13028 13028 0 0.00 0 16196 66 0 0
sp_kill_qstorno_ret_qs2qd 840202 840202 0 0.00 0 41507 34 0 0
sp_kill_qty_storno 445835 445835 0 0.00 0 41521 74 0 0
sp_lock_selected_doc 18682 18682 0 0.00 0 7149 5 0 0
sp_make_cost_storno 25278 25278 0 0.00 0 15937 70 0 0
sp_multiply_rows_for_pdistr 25278 25278 0 0.00 0 9074 30 0 0
sp_multiply_rows_for_qdistr 18901 18901 0 0.00 0 12937 162 0 0
sp_pay_from_customer 6478 6478 0 0.00 4 11533 124 0 0
sp_pay_to_supplier 5303 5303 0 0.00 5 13645 161 0 0
sp_payment_common 11781 11781 0 0.00 1 13525 37 0 0
sp_qd_handle_on_cancel_clo 1596 1596 0 0.00 0 12815 376 0 0
sp_qd_handle_on_invoice_upd_sts 8826 8826 0 0.00 0 35713 334 0 0
sp_qd_handle_on_reserve_upd_sts 8906 8906 0 0.00 0 10717 67 0 0
sp_reserve_write_off 8906 8906 0 0.00 6 15639 197 0 0
sp_supplier_invoice 5023 5023 0 0.00 6 94908 3570 0 0
sp_supplier_order 4991 4991 0 0.00 4 29251 1426 0 0
srv_aggregate_perf_data 86 86 0 0.00 1433 187093 18969 0 0
srv_fill_mon_cache_memory 60 60 0 0.00 1396 107455 33433 0 0
srv_find_qd_qs_mism 873622 873622 0 0.00 0 33935 8 0 0
srv_make_invnt_saldo 530 530 0 0.00 20 105484 1176 0 0
srv_make_money_saldo 719 719 0 0.00 1 4136 39 0 0
srv_recalc_idx_stat 3 3 0 0.00 197471 332248 258047 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4608 4608 0 0.00 0 24323 222 0 0
t$perf-norm:sp_cancel_adding_invoice 385 385 0 0.00 1 15143 167 0 0
t$perf-norm:sp_cancel_client_order 1596 1596 0 0.00 0 3324 16 0 0
t$perf-norm:sp_cancel_customer_reserve 567 567 0 0.00 0 1445 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 619 619 0 0.00 0 1067 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 372 372 0 0.00 0 471 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 608 15 0 0
t$perf-norm:sp_cancel_supplier_order 337 337 0 0.00 0 30238 1814 0 0
t$perf-norm:sp_cancel_write_off 923 923 0 0.00 0 5976 15 0 0
t$perf-norm:sp_client_order 18901 18901 0 0.00 0 11812 20 0 0
t$perf-norm:sp_customer_reserve 938 938 0 0.00 0 3953 12 0 0
t$perf-norm:sp_pay_from_customer 6478 6478 0 0.00 0 7098 11 0 0
t$perf-norm:sp_pay_to_supplier 5303 5303 0 0.00 0 4499 10 0 0
t$perf-norm:sp_reserve_write_off 8906 8906 0 0.00 0 7660 11 0 0
t$perf-norm:sp_supplier_invoice 5023 5023 0 0.00 0 7837 21 0 0
t$perf-norm:sp_supplier_order 4991 4991 0 0.00 0 11679 21 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 339 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 60 60 0 0.00 0 6 1 0 0
t$perf-norm:srv_make_invnt_saldo 530 530 0 0.00 0 1080 26 0 0
t$perf-norm:srv_make_money_saldo 719 719 0 0.00 0 1357 23 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 162 55 0 0
v_add_invoice_to_stock 9430 9182 248 2.62 0 3767 16 0 248
v_all_customers 34852 34852 0 0.00 0 94 1 0 0
v_all_suppliers 28022 28022 0 0.00 0 70 1 0 0
v_all_wares 37802 37802 0 0.00 0 83 1 0 0
v_cancel_adding_invoice 770 770 0 0.00 0 2811 12 0 0
v_cancel_client_order 3192 3192 0 0.00 0 1603 3 0 0
v_cancel_customer_prepayment 1238 1238 0 0.00 0 4589 8 0 0
v_cancel_customer_reserve 1134 1134 0 0.00 0 106 3 0 0
v_cancel_payment_to_supplier 744 744 0 0.00 0 853 5 0 0
v_cancel_supplier_invoice 788 772 16 2.03 0 922 15 0 16
v_cancel_supplier_order 674 674 0 0.00 0 152 3 0 0
v_cancel_write_off 1846 1846 0 0.00 0 4239 15 0 0
v_max_id_clo_ord 4984 4984 0 0.00 0 432 2 0 0
v_max_id_clo_res 938 938 0 0.00 0 2301 19 0 0
v_max_id_ord_sup 5016 5016 0 0.00 0 6859 9 0 0
v_max_non_paid_invoice 1292 1292 0 0.00 0 1232 4 0 0
v_max_non_paid_realizn 3245 3245 0 0.00 0 2885 6 0 0
v_min_id_clo_ord 4984 4984 0 0.00 0 9633 12 0 0
v_min_id_clo_res 938 938 0 0.00 0 1372 4 0 0
v_min_id_ord_sup 5016 5016 0 0.00 0 7537 10 0 0
v_min_non_paid_invoice 5303 5303 0 0.00 0 13520 33 0 0
v_min_non_paid_realizn 6478 6478 0 0.00 0 8634 24 0 0
v_our_firm 9416 9416 0 0.00 0 22 1 0 0
v_reserve_write_off 17812 17812 0 0.00 0 3695 5 0 0
x_lock_depdocs_on_canc_invoice 8522 8522 0 0.00 0 11632 150 0 0
x_lock_depdocs_on_canc_sup_ord 337 337 0 0.00 0 5785 343 0 0
x_make_qstorno_1000_1200 4991 4991 0 0.00 1 29246 1334 0 0
x_make_qstorno_1200_2000 5023 5023 0 0.00 3 94868 3425 0 0
x_make_qstorno_2100_3300 431983 431983 0 0.00 0 67941 201 0 0

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

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
20:09:49 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:50 26004 8192000000 9887435520 10192384000 970557008 10.592 100 89 178 0 999550304 5931840 23061456
20:12:31 23828 8192000000 9931837584 10253717504 1017547792 11.048 100 84 168 0 1047548992 8114112 21887088
20:13:59 13760 8192000000 9973731728 10303602688 1058280752 11.440 100 82 164 0 1087884080 9284864 20318464
20:15:18 11725 8192000000 10031380016 10378133504 1118887216 12.016 100 74 148 0 1146712576 10428224 17397136
20:16:33 8544 8192000000 10071070064 10430574592 1158725264 12.391 100 71 141 0 1185654640 11050032 15879344
20:17:44 4158 8192000000 10125929280 10491080704 1209372592 12.863 100 83 166 1 1241616592 13424064 18819936
20:18:50 2401 8192000000 10148796704 10519486464 1236204016 13.111 100 87 174 0 1269340480 14045488 19090976
20:19:56 2719 8192000000 10170252880 10546434048 1252769520 13.264 100 84 166 0 1285096064 14348432 17978112
20:21:01 1360 8192000000 10194548144 10579918848 1283657904 13.546 100 85 170 0 1315937536 11371008 20908624
20:22:04 734 8192000000 10211510176 10598477824 1298242880 13.679 100 85 171 2 1328683184 11630800 18809504
20:23:06 6037 8192000000 10190035952 10597154816 1300862528 13.703 100 26 49 0 1313204448 7032448 5309472
20:24:13 4922 8192000000 10196534448 10609295360 1312497392 13.809 100 27 54 1 1326194656 7555776 6141488
20:25:19 9605 8192000000 10201266208 10619572224 1320188288 13.878 100 15 30 1 1329439296 6170576 3080432
20:26:30 38931 8192000000 10226886688 10634690560 1322196128 13.897 100 36 71 2 1336790720 4958256 9636336
20:28:10 7603 8192000000 10226538416 10644930560 1330757408 13.974 100 30 60 1 1342614848 5479904 6377536
20:29:23 11648 8192000000 10223402416 10641821696 1311136000 13.796 98 16 30 1 1320498752 6027408 3335344
20:30:38 8498 8192000000 10222240096 10627063808 1307310960 13.762 98 47 94 4 1326041472 8235920 10494592
20:31:53 9760 8192000000 10245154144 10650292224 1335168256 14.014 100 56 111 0 1357370800 9282928 12919616
20:33:06 77670 8192000000 10208957040 10623631360 1293446176 13.636 97 32 65 1 1312364512 11770000 7148336
20:35:33 53518 8192000000 10211101712 10616061952 1224131904 13.000 92 36 66 1 1245337424 13726688 7478832
20:37:32 7992 8192000000 10219062128 10624159744 1300052112 13.696 99 48 95 0 1326677696 15971184 10654400
20:38:48 10891 8192000000 10224852368 10629320704 1308376048 13.771 100 47 92 1 1336696512 17634240 10686224
20:40:06 9744 8192000000 10230421296 10630344704 1313969568 13.822 100 51 97 1 1342305328 17151024 11184736
20:41:19 4789 8192000000 10232301744 10629857280 1289079520 13.596 98 49 98 0 1322421904 20729536 12612848
20:42:30 4963 8192000000 10226025056 10618183680 1276211424 13.478 97 59 117 0 1313345104 23308352 13825328
20:43:39 4613 8192000000 10253402544 10651029504 1322987568 13.904 100 66 131 0 1360947776 22477200 15483008
20:44:50 11854 8192000000 10258499248 10659303424 1319406816 13.871 99 58 116 2 1357137984 23919280 13811888
20:46:10 1830 8192000000 10294082992 10687356928 1349453184 14.143 100 81 162 1 1395423664 27700544 18269936
20:47:16 1390 8192000000 10311884992 10706513920 1363309312 14.267 100 91 182 2 1413950336 29935840 20705184
20:48:24 4493 8192000000 10306230688 10710061056 1363723184 14.271 100 72 141 1 1411898016 32061824 16113008
20:49:32 8035 8192000000 10326450208 10728280064 1380891520 14.425 100 91 182 0 1434272560 32296208 21084832
20:50:44 3638 8192000000 10325077296 10734948352 1382929520 14.443 100 64 128 0 1431525792 32953856 15642416
20:51:53 6231 8192000000 10317116512 10733297664 1381249584 14.428 100 52 103 0 1424073872 30512112 12312176
20:53:12 3098 8192000000 10348158480 10757435392 1391819088 14.522 100 70 140 0 1449154400 40676000 16659312
20:54:22 11636 8192000000 10336971072 10768039936 1400271856 14.597 100 40 79 2 1445484560 34858832 10353872
20:55:46 23488 8192000000 10326177392 10762604544 1399588432 14.591 100 22 44 0 1436486720 31270032 5628256
20:57:14 27102 8192000000 10305040160 10743648256 1379363200 14.411 99 32 64 0 1410967216 23575792 8028224
20:58:51 14396 8192000000 10317901696 10753425408 1380194736 14.418 100 29 54 1 1425431248 37145856 8090656
21:00:09 4925 8192000000 10329382208 10764148736 1390246736 14.508 100 52 103 1 1431656480 29198496 12211248
21:01:16 13714 8192000000 10313823840 10756534272 1400094784 14.596 100 17 35 0 1415005744 11044544 3866416
21:02:48 33291 8192000000 10304528352 10762989568 1390963536 14.514 99 15 30 0 1406136848 11706112 3467200
21:04:24 98848 8192000000 10292024272 10734354432 1334221168 14.005 95 20 40 0 1348354512 9534480 4598864
21:07:05 107455 8192000000 10295307920 10748653568 1372214640 14.347 98 21 42 0 1385906560 8319920 5372000
21:09:54 86292 8192000000 10291842336 10739916800 1363762688 14.271 98 27 54 0 1385437520 15140560 6534272
21:12:27 8495 8192000000 10310809472 10752917504 1400831184 14.602 100 29 57 1 1418527664 11563056 6133424
21:13:38 30044 8192000000 10316563632 10740703232 1350593712 14.153 96 42 84 0 1380152800 18832592 10726496
21:15:24 39687 8192000000 10291765632 10736140288 1373404752 14.358 100 18 36 0 1404524144 26502352 4617040
21:17:10 47828 8192000000 10282515840 10727362560 1363386000 14.268 99 20 40 0 1383849184 15741632 4721552
21:18:59 45390 8192000000 10284048688 10720628736 1357881392 14.218 99 29 54 1 1381269680 16027104 7361184
21:20:46 46980 8192000000 10255274144 10705711104 1300494592 13.700 96 24 48 0 1325642000 19476656 5670752
21:22:35 15003 8192000000 10256290336 10691768320 1335473472 14.017 99 48 96 0 1355180400 8381296 11325632
21:23:59 20496 8192000000 10246418288 10676875264 1314878000 13.830 98 30 60 0 1330824368 9592720 6353648
21:25:25 10186 8192000000 10271119008 10696851456 1345876048 14.110 100 60 120 0 1373849968 15126848 12847072
21:27:41 13170 8192000000 10272833200 10701684736 1352202320 14.167 100 42 82 2 1369970016 9033232 8734464
21:28:57 84854 8192000000 10258944144 10706579456 1309134800 13.778 96 27 54 0 1327958800 12869232 5954768
21:31:25 46465 8192000000 10267241168 10701488128 1342950848 14.084 99 26 52 0 1356889328 8054672 5883808
21:33:16 90577 8192000000 10263537040 10719723520 1352215808 14.167 99 27 53 0 1372027296 13293712 6517776
21:36:18 11267 8192000000 10257823520 10704257024 1350297200 14.150 99 26 50 0 1368898656 12838656 5762800
21:37:30 37457 8192000000 10255830048 10703753216 1338934816 14.048 98 17 34 0 1350047104 7479168 3633120
21:39:22 56436 8192000000 10261375312 10709585920 1337676048 14.036 98 11 22 0 1351339760 11251280 2412432
21:41:20 50054 8192000000 10269867072 10726805504 1375991408 14.381 100 16 32 0 1386303808 6929040 3383360
21:43:11 57469 8192000000 10285896080 10746404864 1358322128 14.222 98 18 37 0 1377312896 14589440 4401328
21:45:16 41271 8192000000 10284099328 10734936064 1354001008 14.183 98 18 36 0 1373883776 15256128 4626640
21:47:11 56471 8192000000 10279325856 10724110336 1346012592 14.112 97 30 60 0 1362262944 9231552 7018800
21:49:15 15199 8192000000 10300184160 10735493120 1371002448 14.336 99 44 88 1 1393941248 13236560 9702240
21:50:32 47338 8192000000 10308920864 10753138688 1389898160 14.505 100 25 48 0 1410583200 14562960 6122080
21:52:23 102018 8192000000 10286804896 10739699712 1355506944 14.197 97 27 52 0 1373051200 11720752 5823504
21:55:06 61492 8192000000 10306973088 10752417792 1357836288 14.218 97 34 68 0 1380709824 15492128 7381408
21:57:08 67057 8192000000 10278890256 10738466816 1380607600 14.422 100 34 68 0 1402691392 14156368 7927424
21:59:16 6075 8192000000 10297406496 10738429952 1383122240 14.444 100 48 96 2 1405700448 11291328 11286880
22:00:29 14937 8192000000 10249423616 10703847424 1337277152 14.033 98 15 31 1 1351243152 10762016 3203984
22:01:46 53477 8192000000 10229964352 10685849600 1308750944 13.775 97 7 14 0 1323382192 12876336 1754912
22:03:55 62177 8192000000 10254300128 10705235968 1338444560 14.043 99 9 18 0 1352580608 11888368 2247680
22:06:02 24853 8192000000 10260125152 10694365184 1311974896 13.804 97 23 44 0 1328317712 11531664 4811152
22:07:30 72068 8192000000 10269336736 10710482944 1321518880 13.890 97 18 36 1 1342310288 16639424 4151984
22:09:43 15432 8192000000 8897531760 9113010176 46773632 0.567 4 1 2 0 47564976 748992 42352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 01-04-2024 22:11:04 to 01-04-2024 22:11:19.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-04-2024 22:11:20 to 01-04-2024 22:11:22.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          183998
MON$OLDEST_ACTIVE               183999
MON$OLDEST_SNAPSHOT             183999
MON$NEXT_TRANSACTION            183999
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1911648
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Mon Apr  1 22:11:23 2024 
 
Database header page information: 
    Flags            0 
    Generation        96111 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    183998 
    Oldest active        183999 
    Oldest snapshot        183999 
    Next transaction    184000 
    Sequence number        0 
    Next attachment ID    731 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.24, total records: 7874217 
    Average version length: 48.16, total versions: 108227, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87280 
    Data pages: 87280, average fill: 72% 
    Primary pages: 87280, secondary pages: 0, swept pages: 16250 
    Empty pages: 2, full pages: 69423 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 58 
    40 - 59% = 657 
    60 - 79% = 86516 
    80 - 99% = 39 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23594, nodes: 7874217 
    Average node length: 18.94, total dup: 0, max dup: 0 
    Average key length: 15.95, compression ratio: 1.69 
    Average prefix length: 14.05, average data length: 12.95 
    Clustering factor: 1774902, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 370 
        20 - 39% = 1551 
        40 - 59% = 4471 
        60 - 79% = 2190 
        80 - 99% = 15012 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13671, nodes: 7874217 
    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: 1596814, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1470 
        40 - 59% = 2229 
        60 - 79% = 964 
        80 - 99% = 9008 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8477, nodes: 7874217 
    Average node length: 6.64, total dup: 5850893, max dup: 49 
    Average key length: 3.66, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1589726, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 863 
        40 - 59% = 1547 
        60 - 79% = 807 
        80 - 99% = 5111 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.11, total records: 2315104 
    Average version length: 34.62, total versions: 109974, max versions: 3 
    Average fragment length: 8.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28688 
    Data pages: 28688, average fill: 75% 
    Primary pages: 28684, secondary pages: 4, swept pages: 9027 
    Empty pages: 3, full pages: 24049 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 63 
    40 - 59% = 926 
    60 - 79% = 26489 
    80 - 99% = 1203 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4667, nodes: 2315104 
    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: 721746, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 900 
        40 - 59% = 932 
        60 - 79% = 654 
        80 - 99% = 2181 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2565, nodes: 2317993 
    Average node length: 4.97, total dup: 2317094, max dup: 20208 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1281043, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 254 
        40 - 59% = 1546 
        60 - 79% = 554 
        80 - 99% = 210 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2094, nodes: 2315104 
    Average node length: 4.97, total dup: 2315054, max dup: 130660 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1080653, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 16 
        40 - 59% = 1217 
        60 - 79% = 58 
        80 - 99% = 799 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4459, nodes: 2315104 
    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: 721746, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 570 
        40 - 59% = 695 
        60 - 79% = 730 
        80 - 99% = 2351 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.25, total records: 400 
    Average version length: 22.88, total versions: 249773, max versions: 654 
    Average fragment length: 2.00, total fragments: 58, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1416 
    Data pages: 1408, average fill: 88% 
    Primary pages: 16, secondary pages: 1392, swept pages: 0 
    Empty pages: 9, full pages: 1397 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 1395 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 11.13, total records: 125137 
    Average version length: 68.28, total versions: 104759, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.91 
    Pointer pages: 7, data page slots: 3592 
    Data pages: 2432, average fill: 64% 
    Primary pages: 2431, secondary pages: 1, swept pages: 0 
    Empty pages: 332, full pages: 1445 
    Fill distribution: 
     0 - 19% = 436 
    20 - 39% = 197 
    40 - 59% = 208 
    60 - 79% = 346 
    80 - 99% = 1245 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1709153, depth: 3, leaf buckets: 397, nodes: 125137 
    Average node length: 13.36, total dup: 9668, max dup: 1 
    Average key length: 10.61, compression ratio: 2.54 
    Average prefix length: 19.31, average data length: 7.69 
    Clustering factor: 90419, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 28 
        40 - 59% = 274 
        60 - 79% = 86 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 18999, max versions: 1010 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 85% 
    Primary pages: 5, secondary pages: 67, swept pages: 0 
    Empty pages: 4, full pages: 67 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 64 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 7.34, total records: 1911 
    Average version length: 43.62, total versions: 1592, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 7.90 
    Pointer pages: 1, data page slots: 56 
    Data pages: 29, average fill: 62% 
    Primary pages: 28, secondary pages: 1, swept pages: 0 
    Empty pages: 3, full pages: 15 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94734, depth: 2, leaf buckets: 5, nodes: 1911 
    Average node length: 4.28, total dup: 1813, max dup: 268 
    Average key length: 2.57, compression ratio: 7.39 
    Average prefix length: 18.48, average data length: 0.52 
    Clustering factor: 963, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.96, total records: 77 
    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.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 54% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 77 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.66, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.86, total records: 782360 
    Average version length: 25.69, total versions: 73971, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8272 
    Data pages: 8264, average fill: 67% 
    Primary pages: 8217, secondary pages: 47, swept pages: 1602 
    Empty pages: 180, full pages: 7063 
    Fill distribution: 
     0 - 19% = 369 
    20 - 39% = 407 
    40 - 59% = 243 
    60 - 79% = 6974 
    80 - 99% = 271 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 871, nodes: 782360 
    Average node length: 4.87, total dup: 782311, max dup: 139297 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88788, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 137 
        40 - 59% = 483 
        60 - 79% = 192 
        80 - 99% = 59 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 929, nodes: 782360 
    Average node length: 5.87, total dup: 696633, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156322, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 119 
        40 - 59% = 381 
        60 - 79% = 163 
        80 - 99% = 262 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 966, nodes: 782360 
    Average node length: 5.87, total dup: 696633, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158306, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 200 
        40 - 59% = 363 
        60 - 79% = 149 
        80 - 99% = 254 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1117, nodes: 782360 
    Average node length: 5.95, total dup: 696633, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151803, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 252 
        40 - 59% = 585 
        60 - 79% = 202 
        80 - 99% = 76 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.89, total records: 5474 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.89, total fragments: 64, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 104 
    Data pages: 104, average fill: 53% 
    Primary pages: 85, secondary pages: 19, swept pages: 53 
    Empty pages: 15, full pages: 66 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5474 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.45, average data length: 1.55 
    Clustering factor: 5178, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5474 
    Average node length: 11.10, 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: 150, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.09, total records: 84074 
    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: 816 
    Data pages: 816, average fill: 71% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 809 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 809 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33076, depth: 2, leaf buckets: 110, nodes: 84074 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3688, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 105 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 143.91, total records: 196531 
    Average version length: 154.23, total versions: 9728, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 7, data page slots: 6464 
    Data pages: 4712, average fill: 86% 
    Primary pages: 4712, secondary pages: 0, swept pages: 2 
    Empty pages: 35, full pages: 4666 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 4667 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 149.33, total records: 167942 
    Average version length: 150.10, total versions: 1849, 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: 4368 
    Data pages: 4032, average fill: 86% 
    Primary pages: 4032, secondary pages: 0, swept pages: 2 
    Empty pages: 50, full pages: 3972 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3972 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.45, total records: 162088 
    Average version length: 151.99, total versions: 3653, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 5, data page slots: 4608 
    Data pages: 3872, average fill: 86% 
    Primary pages: 3872, secondary pages: 0, swept pages: 1 
    Empty pages: 27, full pages: 3832 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 3832 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.91, total records: 176239 
    Average version length: 152.80, total versions: 2691, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 8, data page slots: 4440 
    Data pages: 4200, average fill: 87% 
    Primary pages: 4200, secondary pages: 0, swept pages: 2 
    Empty pages: 15, full pages: 4176 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4176 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.55, total records: 152983 
    Average version length: 148.94, total versions: 1497, 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: 7, data page slots: 4056 
    Data pages: 3680, average fill: 86% 
    Primary pages: 3679, secondary pages: 1, swept pages: 1 
    Empty pages: 43, full pages: 3618 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3618 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 130.63, total records: 197305 
    Average version length: 155.14, total versions: 26598, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.98 
    Pointer pages: 7, data page slots: 5088 
    Data pages: 4720, average fill: 87% 
    Primary pages: 4720, secondary pages: 0, swept pages: 3 
    Empty pages: 20, full pages: 4685 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4685 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.93, total records: 172592 
    Average version length: 150.30, total versions: 2501, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 4392 
    Data pages: 4160, average fill: 86% 
    Primary pages: 4160, secondary pages: 0, swept pages: 7 
    Empty pages: 58, full pages: 4086 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4083 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 138.01, total records: 188887 
    Average version length: 154.38, total versions: 16581, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.29 
    Pointer pages: 6, data page slots: 5544 
    Data pages: 4520, average fill: 87% 
    Primary pages: 4520, secondary pages: 0, swept pages: 1 
    Empty pages: 23, full pages: 4485 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 0 
    80 - 99% = 4485 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.09, total records: 172970 
    Average version length: 154.58, total versions: 7907, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 7, data page slots: 5848 
    Data pages: 4160, average fill: 86% 
    Primary pages: 4160, secondary pages: 0, swept pages: 2 
    Empty pages: 51, full pages: 4098 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4096 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 137.13, total records: 174886 
    Average version length: 154.39, total versions: 15926, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.37 
    Pointer pages: 7, data page slots: 4584 
    Data pages: 4192, average fill: 87% 
    Primary pages: 4192, secondary pages: 0, swept pages: 2 
    Empty pages: 36, full pages: 4143 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4143 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.65, total records: 2146476 
    Average version length: 52.95, total versions: 44973, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25776 
    Data pages: 25776, average fill: 72% 
    Primary pages: 25776, secondary pages: 0, swept pages: 10118 
    Empty pages: 240, full pages: 21765 
    Fill distribution: 
     0 - 19% = 438 
    20 - 39% = 383 
    40 - 59% = 884 
    60 - 79% = 23680 
    80 - 99% = 391 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2636, nodes: 2146476 
    Average node length: 5.44, total dup: 2004087, max dup: 1396 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184703, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 240 
        40 - 59% = 1804 
        60 - 79% = 300 
        80 - 99% = 287 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2764, nodes: 2146476 
    Average node length: 5.69, total dup: 1927095, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 382838, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2271 
        60 - 79% = 459 
        80 - 99% = 30 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2226, nodes: 2146476 
    Average node length: 4.96, total dup: 2146376, max dup: 28014 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 182468, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 189 
        40 - 59% = 1265 
        60 - 79% = 404 
        80 - 99% = 367 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 37.26, total records: 166180 
    Average version length: 69.17, total versions: 76724, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.38 
    Pointer pages: 3, data page slots: 4864 
    Data pages: 3464, average fill: 56% 
    Primary pages: 3464, secondary pages: 0, swept pages: 672 
    Empty pages: 900, full pages: 2295 
    Fill distribution: 
     0 - 19% = 1113 
    20 - 39% = 19 
    40 - 59% = 20 
    60 - 79% = 727 
    80 - 99% = 1585 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554876, depth: 3, leaf buckets: 238, nodes: 166180 
    Average node length: 6.44, total dup: 144813, max dup: 14 
    Average key length: 3.91, compression ratio: 10.75 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 28515, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 28 
        40 - 59% = 117 
        60 - 79% = 66 
        80 - 99% = 24 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.15, total records: 6836808 
    Average version length: 68.82, total versions: 477319, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 60, data page slots: 96608 
    Data pages: 96608, average fill: 76% 
    Primary pages: 96608, secondary pages: 0, swept pages: 17310 
    Empty pages: 108, full pages: 85342 
    Fill distribution: 
     0 - 19% = 451 
    20 - 39% = 597 
    40 - 59% = 2914 
    60 - 79% = 82834 
    80 - 99% = 9812 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10492, nodes: 6836808 
    Average node length: 6.51, total dup: 5912696, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1528083, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1833 
        40 - 59% = 5734 
        60 - 79% = 2389 
        80 - 99% = 525 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8110, nodes: 6836808 
    Average node length: 5.40, total dup: 6558890, max dup: 161 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1332835, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1097 
        40 - 59% = 4254 
        60 - 79% = 1667 
        80 - 99% = 1084 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8184, nodes: 6836808 
    Average node length: 5.40, total dup: 6558890, max dup: 161 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1335249, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1177 
        40 - 59% = 4268 
        60 - 79% = 1664 
        80 - 99% = 1068 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.71, total records: 11776259 
    Average version length: 68.76, total versions: 385139, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 100, data page slots: 161864 
    Data pages: 161864, average fill: 77% 
    Primary pages: 161864, secondary pages: 0, swept pages: 64118 
    Empty pages: 6, full pages: 159081 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 104 
    40 - 59% = 775 
    60 - 79% = 152108 
    80 - 99% = 8864 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18140, nodes: 11776259 
    Average node length: 6.55, total dup: 10265956, max dup: 71 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2348422, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 2670 
        40 - 59% = 10699 
        60 - 79% = 3864 
        80 - 99% = 878 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 38.56, total records: 1807960 
    Average version length: 69.13, total versions: 799653, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.27 
    Pointer pages: 28, data page slots: 44568 
    Data pages: 29104, average fill: 72% 
    Primary pages: 29104, secondary pages: 0, swept pages: 4629 
    Empty pages: 1608, full pages: 21909 
    Fill distribution: 
     0 - 19% = 2694 
    20 - 39% = 1402 
    40 - 59% = 1508 
    60 - 79% = 10307 
    80 - 99% = 13193 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2243, nodes: 1807960 
    Average node length: 5.51, total dup: 1735178, max dup: 99 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 125761, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 383 
        40 - 59% = 1036 
        60 - 79% = 605 
        80 - 99% = 210 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.34, total records: 1275885 
    Average version length: 69.13, total versions: 622419, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.57 
    Pointer pages: 22, data page slots: 35024 
    Data pages: 27888, average fill: 53% 
    Primary pages: 27888, secondary pages: 0, swept pages: 6531 
    Empty pages: 6000, full pages: 15479 
    Fill distribution: 
     0 - 19% = 8629 
    20 - 39% = 1503 
    40 - 59% = 1184 
    60 - 79% = 5386 
    80 - 99% = 11186 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1647, nodes: 1275885 
    Average node length: 5.75, total dup: 1195567, max dup: 103 
    Average key length: 2.81, compression ratio: 14.95 
    Average prefix length: 41.25, average data length: 0.75 
    Clustering factor: 165830, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 241 
        40 - 59% = 802 
        60 - 79% = 469 
        80 - 99% = 131 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.91, total records: 9706754 
    Average version length: 68.97, total versions: 562213, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 90, data page slots: 146624 
    Data pages: 146592, average fill: 71% 
    Primary pages: 146591, secondary pages: 1, swept pages: 47523 
    Empty pages: 235, full pages: 95594 
    Fill distribution: 
     0 - 19% = 837 
    20 - 39% = 4590 
    40 - 59% = 18938 
    60 - 79% = 112492 
    80 - 99% = 9735 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13590, nodes: 9706754 
    Average node length: 6.69, total dup: 8055482, max dup: 19 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2135522, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 863 
        40 - 59% = 6256 
        60 - 79% = 5459 
        80 - 99% = 1011 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21205559 
    Average version length: 82.90, total versions: 14751, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319504 
    Data pages: 319504, average fill: 81% 
    Primary pages: 319504, secondary pages: 0, swept pages: 12615 
    Empty pages: 17, full pages: 319211 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 7 
    40 - 59% = 29 
    60 - 79% = 27274 
    80 - 99% = 292168 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19331, nodes: 21205559 
    Average node length: 5.72, total dup: 20723295, max dup: 168 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3290739, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 7960 
        60 - 79% = 539 
        80 - 99% = 10825 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17242, nodes: 21205559 
    Average node length: 6.31, total dup: 18636175, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917892, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 837 
        60 - 79% = 276 
        80 - 99% = 16128 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21076, nodes: 21205559 
    Average node length: 6.35, total dup: 18554397, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3585579, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 0 
        40 - 59% = 8108 
        60 - 79% = 622 
        80 - 99% = 12331 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16289, nodes: 21205559 
    Average node length: 5.56, total dup: 21205459, max dup: 232355 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 946610, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 3144 
        60 - 79% = 454 
        80 - 99% = 12683 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.16, total records: 10126400 
    Average version length: 82.66, total versions: 524284, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 107, data page slots: 173920 
    Data pages: 173904, average fill: 72% 
    Primary pages: 173904, secondary pages: 0, swept pages: 67562 
    Empty pages: 309, full pages: 109836 
    Fill distribution: 
     0 - 19% = 1053 
    20 - 39% = 5443 
    40 - 59% = 24143 
    60 - 79% = 72165 
    80 - 99% = 71100 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11463, nodes: 10126400 
    Average node length: 5.38, total dup: 9811554, max dup: 203 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2255626, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 76 
        40 - 59% = 7042 
        60 - 79% = 4149 
        80 - 99% = 195 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13968, nodes: 10126400 
    Average node length: 6.25, total dup: 8398710, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1580817, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 152 
        20 - 39% = 4104 
        40 - 59% = 4263 
        60 - 79% = 2671 
        80 - 99% = 2778 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12791, nodes: 10126400 
    Average node length: 5.99, total dup: 8794220, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2451967, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 82 
        40 - 59% = 7956 
        60 - 79% = 4513 
        80 - 99% = 238 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10601, nodes: 10126400 
    Average node length: 5.15, total dup: 10126300, max dup: 155268 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1619842, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1211 
        40 - 59% = 5412 
        60 - 79% = 1798 
        80 - 99% = 2133 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.30, total records: 11813286 
    Average version length: 82.60, total versions: 432747, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 121, data page slots: 196464 
    Data pages: 195224, average fill: 74% 
    Primary pages: 195224, secondary pages: 0, swept pages: 63927 
    Empty pages: 2799, full pages: 154079 
    Fill distribution: 
     0 - 19% = 4456 
    20 - 39% = 5994 
    40 - 59% = 15471 
    60 - 79% = 40771 
    80 - 99% = 128532 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13180, nodes: 11813286 
    Average node length: 5.31, total dup: 11702154, max dup: 628 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2464601, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 53 
        40 - 59% = 8037 
        60 - 79% = 4685 
        80 - 99% = 405 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10855, nodes: 11813286 
    Average node length: 5.51, total dup: 11299561, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 746156, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 784 
        40 - 59% = 2730 
        60 - 79% = 1864 
        80 - 99% = 5331 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15068, nodes: 11813286 
    Average node length: 6.03, total dup: 10318304, max dup: 76 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2481268, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 89 
        40 - 59% = 9441 
        60 - 79% = 5068 
        80 - 99% = 468 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11237, nodes: 11813286 
    Average node length: 5.24, total dup: 11813186, max dup: 198256 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 733729, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 77 
        20 - 39% = 764 
        40 - 59% = 5201 
        60 - 79% = 1523 
        80 - 99% = 3672 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.44, total records: 10252930 
    Average version length: 82.92, total versions: 534164, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 109, data page slots: 177088 
    Data pages: 177056, average fill: 72% 
    Primary pages: 177056, secondary pages: 0, swept pages: 69551 
    Empty pages: 360, full pages: 109711 
    Fill distribution: 
     0 - 19% = 1077 
    20 - 39% = 5507 
    40 - 59% = 25068 
    60 - 79% = 74675 
    80 - 99% = 70729 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12336, nodes: 10252930 
    Average node length: 5.19, total dup: 10223255, max dup: 2119 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2057083, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1417 
        40 - 59% = 8273 
        60 - 79% = 1975 
        80 - 99% = 642 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14134, nodes: 10252930 
    Average node length: 6.26, total dup: 8502610, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1539480, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 215 
        20 - 39% = 4055 
        40 - 59% = 4318 
        60 - 79% = 2663 
        80 - 99% = 2883 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12992, nodes: 10252930 
    Average node length: 5.45, total dup: 9796293, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2195844, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1343 
        40 - 59% = 9277 
        60 - 79% = 1765 
        80 - 99% = 585 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10761, nodes: 10252930 
    Average node length: 5.16, total dup: 10252830, max dup: 157429 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1637555, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1264 
        40 - 59% = 5524 
        60 - 79% = 1752 
        80 - 99% = 2177 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.32, total records: 581519 
    Average version length: 68.77, total versions: 7294, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 76% 
    Primary pages: 8064, secondary pages: 0, swept pages: 3723 
    Empty pages: 0, full pages: 6884 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 25 
    40 - 59% = 230 
    60 - 79% = 7681 
    80 - 99% = 126 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45234, depth: 3, leaf buckets: 742, nodes: 581519 
    Average node length: 5.95, total dup: 495151, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101222, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 521 
        60 - 79% = 97 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36204, depth: 3, leaf buckets: 774, nodes: 581519 
    Average node length: 6.15, total dup: 476988, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101270, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 544 
        60 - 79% = 99 
        80 - 99% = 92 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 572, nodes: 581519 
    Average node length: 4.86, total dup: 581419, max dup: 9384 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89833, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 18 
        40 - 59% = 347 
        60 - 79% = 80 
        80 - 99% = 126 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Apr  1 22:11:47 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7874217 108227 1 0.0000 0.0000
DOC_LIST 2315104 109974 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 249773 654 62400.0000 0.0000
INVNT_TURNOVER_LOG 125137 104759 1 0.0000 0.0000
MONEY_SALDO 49 18999 1010 38700.0000 0.0000
MONEY_TURNOVER_LOG 1911 1592 1 0.0000 0.0000
PDISTR 782360 73971 4 0.0000 0.0000
PERF_SPLIT_0 196531 9728 1 0.0000 0.0000
PERF_SPLIT_1 167942 1849 1 0.0000 0.0000
PERF_SPLIT_2 162088 3653 1 0.0000 0.0000
PERF_SPLIT_3 176239 2691 1 0.0000 0.0000
PERF_SPLIT_4 152983 1497 1 0.0000 0.0000
PERF_SPLIT_5 197305 26598 1 0.0000 0.0000
PERF_SPLIT_6 172592 2501 1 0.0000 0.0000
PERF_SPLIT_7 188887 16581 1 0.0000 0.0000
PERF_SPLIT_8 172970 7907 1 0.0000 0.0000
PERF_SPLIT_9 174886 15926 1 0.0000 0.0000
PSTORNED 2146476 44973 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 166180 76724 1 0.0000 0.0000
XQD_1000_3300 6836808 477319 1 0.0000 0.0000
XQD_1200_2000 11776259 385139 1 0.0000 0.0000
XQD_2000_3300 1807960 799653 1 0.0000 0.0000
XQD_2100_3300 1275885 622419 1 0.0000 0.0000
XQD_3300_3400 9706754 562213 1 0.0000 0.0000
XQS_1000_1200 21205559 14751 1 0.0000 0.0000
XQS_1000_3300 10126400 524284 1 0.0000 0.0000
XQS_1200_2000 11813286 432747 1 0.0000 0.0000
XQS_2100_3300 10252930 534164 1 0.0000 0.0000
XQS_3300_3400 581519 7294 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-oltp30 according to config parameter 'remove_isql_logs'  

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