Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.02.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 15767088 kB
MemAvailable 30275064 kB
Buffers 0 kB
Cached 15951296 kB
SwapCached 2496 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-27 22:09:40
DTS_END                         2024-02-27 22:09:40.4830
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38408
TRN_ID                          183930
ATT_ID                          634
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: 9331.83 20983 933183
customer order: creation 184.84 367 18484
customer order: refuse 16.23 367 1623
order to supplier: creation 48.12 1289 4812
order to supplier: removal 3.49 97616 349
invoice (draft): creation 49.46 3498 4946
invoice (draft): removal 48.22 957 4822
invoice accept: apply 45.10 19933 4510
invoice accept: cancel 43.69 910 4369
customer reserve: creation 4299.27 192 429927
customer reserve: removal 4286.46 62 428646
realization accept: apply 88.35 170 8835
realization accept: cancel 80.72 129 8072
payment from customer: creation 63.55 98 6355
payment from customer: removal 6.11 71 611
payment to supplier: creation 51.68 121 5168
payment to supplier: removal 3.51 117 351
service: total inventory turnovers 5.34 1059 534
service: total monetary turnovers 6.83 66 683
service: aggregate perf. data 0.83 21798 83
service: refresh index statistics 0.03 270844 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-02-2024 22:10:32 to 27-02-2024 22:10:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1240
TEST_TIME 2 1423
TEST_TIME 3 1881
TEST_TIME 4 1904
TEST_TIME 5 2131
TEST_TIME 6 2381
TEST_TIME 7 3173
TEST_TIME 8 3548
TEST_TIME 9 3846
TEST_TIME 10 3999
TEST_TIME 11 4584
TEST_TIME 12 4830
TEST_TIME 13 5047
TEST_TIME 14 5666
TEST_TIME 15 5727
TEST_TIME 16 6129
TEST_TIME 17 6461
TEST_TIME 18 6460
TEST_TIME 19 6559
TEST_TIME 20 6592
TEST_TIME 21 7222
TEST_TIME 22 7523
TEST_TIME 23 7708
TEST_TIME 24 7687
TEST_TIME 25 7974
TEST_TIME 26 9216
TEST_TIME 27 9453
TEST_TIME 28 9249
TEST_TIME 29 9224
TEST_TIME 30 9293
TEST_TIME 31 9256
TEST_TIME 32 9170
TEST_TIME 33 9104
TEST_TIME 34 8886
TEST_TIME 35 9034
TEST_TIME 36 9091
TEST_TIME 37 8944
TEST_TIME 38 8994
TEST_TIME 39 8981
TEST_TIME 40 8996
TEST_TIME 41 9117
TEST_TIME 42 8999
TEST_TIME 43 8969
TEST_TIME 44 9034
TEST_TIME 45 8876
TEST_TIME 46 8863
TEST_TIME 47 8916
TEST_TIME 48 8866
TEST_TIME 49 8842
TEST_TIME 50 8935
TEST_TIME 51 9037
TEST_TIME 52 9004
TEST_TIME 53 9109
TEST_TIME 54 9129
TEST_TIME 55 9151
TEST_TIME 56 9157
TEST_TIME 57 9218
TEST_TIME 58 9375
TEST_TIME 59 9374
TEST_TIME 60 9357
TEST_TIME 61 9281
TEST_TIME 62 9253
TEST_TIME 63 9161
TEST_TIME 64 9132
TEST_TIME 65 9199
TEST_TIME 66 9173
TEST_TIME 67 9146
TEST_TIME 68 9100
TEST_TIME 69 9099
TEST_TIME 70 9066
TEST_TIME 71 9115
TEST_TIME 72 9105
TEST_TIME 73 9181
TEST_TIME 74 9216
TEST_TIME 75 9218
TEST_TIME 76 9230
TEST_TIME 77 9226
TEST_TIME 78 9268
TEST_TIME 79 9360
TEST_TIME 80 9339
TEST_TIME 81 9399
TEST_TIME 82 9368
TEST_TIME 83 9428
TEST_TIME 84 9534
TEST_TIME 85 9486
TEST_TIME 86 9417
TEST_TIME 87 9390
TEST_TIME 88 9349
TEST_TIME 89 9374
TEST_TIME 90 9333
TEST_TIME 91 9276
TEST_TIME 92 9252
TEST_TIME 93 9258
TEST_TIME 94 9263
TEST_TIME 95 9238
TEST_TIME 96 9277
TEST_TIME 97 9294
TEST_TIME 98 9300
TEST_TIME 99 9342
TEST_TIME 100 9347

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-02-2024 22:10:36 to 27-02-2024 22:10:39.

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 1326662 1326662 0 0.00 0 49469 7 0 0
doc_list_biud 1326662 1326662 0 0.00 0 63072 26 0 0
sp_add_invoice_to_stock 4603 4510 93 2.02 30 227377 19934 0 93
sp_cancel_adding_invoice 4369 4369 0 0.00 4 67809 910 0 0
sp_cancel_client_order 1623 1623 0 0.00 4 33770 367 0 0
sp_cancel_customer_reserve 428646 428646 0 0.00 0 39438 63 0 0
sp_cancel_pay_from_customer 611 611 0 0.00 3 3663 72 0 0
sp_cancel_pay_to_supplier 351 351 0 0.00 2 5933 118 0 0
sp_cancel_supplier_invoice 4827 4822 5 0.10 1 63084 958 0 5
sp_cancel_supplier_order 349 349 0 0.00 7 1091118 97616 0 0
sp_cancel_write_off 8072 8072 0 0.00 1 23052 130 0 0
sp_client_order 18484 18484 0 0.00 3 34100 368 0 0
sp_customer_reserve 429927 429927 0 0.00 0 63922 192 0 0
sp_fill_shopping_cart 28239 28239 0 0.00 1 26916 43 0 0
sp_fill_shopping_cart_clo_res 429905 429905 0 0.00 0 30858 16 0 0
sp_get_clo_for_invoice 4488 4488 0 0.00 0 32286 325 0 0
sp_kill_cost_storno 13403 13403 0 0.00 0 4430 59 0 0
sp_kill_qstorno_ret_qs2qd 870535 870535 0 0.00 0 63070 35 0 0
sp_kill_qty_storno 461204 461204 0 0.00 0 63071 75 0 0
sp_lock_selected_doc 18475 18475 0 0.00 0 9825 6 0 0
sp_make_cost_storno 24846 24846 0 0.00 0 49458 54 0 0
sp_multiply_rows_for_pdistr 24846 24846 0 0.00 0 7675 24 0 0
sp_multiply_rows_for_qdistr 18484 18484 0 0.00 0 19640 174 0 0
sp_pay_from_customer 6355 6355 0 0.00 4 25362 98 0 0
sp_pay_to_supplier 5168 5168 0 0.00 4 39369 122 0 0
sp_payment_common 11523 11523 0 0.00 2 38871 26 0 0
sp_qd_handle_on_cancel_clo 1623 1623 0 0.00 0 33761 326 0 0
sp_qd_handle_on_invoice_upd_sts 8857 8857 0 0.00 0 47193 313 0 0
sp_qd_handle_on_reserve_upd_sts 8835 8835 0 0.00 0 33695 65 0 0
sp_reserve_write_off 8835 8835 0 0.00 6 33892 171 0 0
sp_supplier_invoice 4946 4946 0 0.00 7 101495 3498 0 0
sp_supplier_order 4812 4812 0 0.00 4 72291 1290 0 0
srv_aggregate_perf_data 84 83 1 1.19 1674 405118 21799 0 1
srv_fill_mon_cache_memory 57 57 0 0.00 2192 137142 38882 0 0
srv_find_qd_qs_mism 887703 887703 0 0.00 0 7803 7 0 0
srv_make_invnt_saldo 534 534 0 0.00 48 69522 1060 0 0
srv_make_money_saldo 683 683 0 0.00 1 27796 67 0 0
srv_recalc_idx_stat 3 3 0 0.00 221263 300026 270844 0 0
t$perf-abend:sp_add_invoice_to_stock 93 93 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4510 4510 0 0.00 0 14247 185 0 0
t$perf-norm:sp_cancel_adding_invoice 366 366 0 0.00 0 3275 84 0 0
t$perf-norm:sp_cancel_client_order 1623 1623 0 0.00 0 1602 11 0 0
t$perf-norm:sp_cancel_customer_reserve 626 626 0 0.00 0 983 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 611 611 0 0.00 0 674 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 351 351 0 0.00 0 1606 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 337 337 0 0.00 0 968 13 0 0
t$perf-norm:sp_cancel_supplier_order 349 349 0 0.00 0 36072 1909 0 0
t$perf-norm:sp_cancel_write_off 889 889 0 0.00 0 2829 11 0 0
t$perf-norm:sp_client_order 18484 18484 0 0.00 0 9659 17 0 0
t$perf-norm:sp_customer_reserve 868 868 0 0.00 0 4172 15 0 0
t$perf-norm:sp_pay_from_customer 6355 6355 0 0.00 0 6991 9 0 0
t$perf-norm:sp_pay_to_supplier 5168 5168 0 0.00 0 30678 21 0 0
t$perf-norm:sp_reserve_write_off 8835 8835 0 0.00 0 6164 9 0 0
t$perf-norm:sp_supplier_invoice 4946 4946 0 0.00 0 6991 18 0 0
t$perf-norm:sp_supplier_order 4812 4812 0 0.00 0 4667 16 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 6317 95 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 1173 41 0 0
t$perf-norm:srv_make_invnt_saldo 534 534 0 0.00 0 1138 19 0 0
t$perf-norm:srv_make_money_saldo 683 683 0 0.00 0 587 17 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 22 9 0 0
v_add_invoice_to_stock 9162 8976 186 2.03 0 2393 16 0 186
v_all_customers 34126 34126 0 0.00 0 60 1 0 0
v_all_suppliers 27474 27474 0 0.00 0 24 1 0 0
v_all_wares 36964 36964 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 732 732 0 0.00 0 1346 10 0 0
v_cancel_client_order 3246 3246 0 0.00 0 2595 6 0 0
v_cancel_customer_prepayment 1222 1222 0 0.00 0 460 3 0 0
v_cancel_customer_reserve 1252 1252 0 0.00 0 415 3 0 0
v_cancel_payment_to_supplier 702 702 0 0.00 0 3394 22 0 0
v_cancel_supplier_invoice 684 674 10 1.46 0 895 15 0 10
v_cancel_supplier_order 698 698 0 0.00 0 315 3 0 0
v_cancel_write_off 1778 1778 0 0.00 0 4543 19 0 0
v_max_id_clo_ord 4812 4812 0 0.00 0 540 1 0 0
v_max_id_clo_res 868 868 0 0.00 0 4298 25 0 0
v_max_id_ord_sup 4945 4945 0 0.00 0 10240 8 0 0
v_max_non_paid_invoice 1188 1188 0 0.00 0 3416 5 0 0
v_max_non_paid_realizn 3130 3130 0 0.00 0 869 3 0 0
v_min_id_clo_ord 4812 4812 0 0.00 0 2422 7 0 0
v_min_id_clo_res 868 868 0 0.00 0 994 5 0 0
v_min_id_ord_sup 4945 4945 0 0.00 0 10002 12 0 0
v_min_non_paid_invoice 5168 5168 0 0.00 0 38868 19 0 0
v_min_non_paid_realizn 6355 6355 0 0.00 0 25351 19 0 0
v_our_firm 9288 9288 0 0.00 0 14 1 0 0
v_reserve_write_off 17670 17670 0 0.00 0 3059 5 0 0
x_lock_depdocs_on_canc_invoice 8854 8854 0 0.00 0 9441 130 0 0
x_lock_depdocs_on_canc_sup_ord 349 349 0 0.00 0 3244 304 0 0
x_make_qstorno_1000_1200 4812 4812 0 0.00 1 72282 1205 0 0
x_make_qstorno_1200_2000 4946 4946 0 0.00 2 101097 3334 0 0
x_make_qstorno_2100_3300 429927 429927 0 0.00 0 63896 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-02-2024 22:10:40 to 27-02-2024 22:10:44.

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:44 4 8192000000 8801948400 8814362624 7911552 0.096 3 1 2 0 8012544 58208 42784
20:10:44 31084 8192000000 9902713264 10211737600 983528944 10.719 100 85 170 1 1011288400 5828624 21930832
20:12:22 15332 8192000000 9949770544 10271289344 1028201616 11.151 100 87 174 0 1058839456 8339808 22298032
20:13:43 13330 8192000000 9988190048 10319540224 1064825088 11.503 100 88 176 0 1096709744 9660960 22223696
20:15:01 9613 8192000000 10025001920 10368610304 1106353920 11.898 100 86 172 1 1138391488 11394848 20642720
20:16:13 6209 8192000000 10067636080 10421989376 1151202864 12.321 100 84 166 1 1183868720 13487280 19178576
20:17:24 4898 8192000000 10112675440 10478022656 1198266944 12.760 100 79 158 0 1229159104 13531024 17361136
20:18:31 2026 8192000000 10156285232 10525921280 1238658592 13.134 100 88 174 1 1272164464 14262032 19243840
20:19:35 884 8192000000 10190854304 10568081408 1271803952 13.438 100 89 179 1 1305393488 13347632 20241904
20:20:36 4021 8192000000 10184971120 10583838720 1290460640 13.608 100 61 122 0 1316023584 12591408 12971536
20:21:43 8054 8192000000 10185915136 10588831744 1295350688 13.653 100 41 82 0 1312835664 7694496 9790480
20:22:52 7463 8192000000 10191721664 10605862912 1307481712 13.763 100 26 51 0 1319852256 7073504 5297040
20:24:01 9976 8192000000 10212545088 10624040960 1320573904 13.882 100 19 36 2 1329859920 5205008 4081008
20:25:13 46635 8192000000 10235637744 10641743872 1330532048 13.972 100 60 119 0 1348869024 5279360 13057616
20:27:00 4139 8192000000 10229358848 10646573056 1335406288 14.016 100 36 73 0 1351615552 7224560 8984704
20:28:05 10123 8192000000 10234474464 10653241344 1340188576 14.059 100 15 28 0 1348687056 5684576 2813904
20:29:19 7204 8192000000 10195233984 10605875200 1287932144 13.585 97 21 42 0 1298643712 5961360 4750208
20:30:30 137140 8192000000 10217734272 10633494528 1302414320 13.717 98 32 65 0 1320348992 10566272 7368400
20:33:55 38507 8192000000 10262979856 10678927360 1340059648 14.058 99 33 64 0 1366358480 18595696 7703136
20:35:37 32825 8192000000 10256718960 10666872832 1301691216 13.711 96 43 86 0 1336191392 24099296 10400880
20:37:15 18041 8192000000 10244087664 10645585920 1286970880 13.577 95 42 84 1 1319702080 22665168 10066032
20:38:37 19146 8192000000 10252116656 10659311616 1292226064 13.625 96 36 71 1 1326588144 25710736 8651344
20:40:00 19482 8192000000 10239653056 10645762048 1294748576 13.647 97 35 70 0 1332561120 29035120 8777424
20:41:28 2979 8192000000 10255343056 10648014848 1316068736 13.841 100 74 141 0 1362325104 29631360 16625008
20:42:38 7137 8192000000 10265080608 10663522304 1320499344 13.881 100 64 128 3 1371156544 35613744 15043456
20:43:53 5726 8192000000 10281444480 10682998784 1343722240 14.091 100 64 129 1 1394387872 35554336 15111296
20:45:05 5005 8192000000 10276520304 10670755840 1326780112 13.938 99 77 151 0 1380510240 36398272 17331856
20:46:18 2413 8192000000 10298720720 10701291520 1354169568 14.185 100 69 136 0 1405314368 33670528 17474272
20:47:24 2187 8192000000 10320933632 10719297536 1371981920 14.345 100 83 156 3 1425800064 34353120 19465024
20:48:31 3867 8192000000 10331037952 10734219264 1378721904 14.405 100 77 152 0 1434846576 36727104 19397568
20:49:39 8867 8192000000 10338743488 10745745408 1384986224 14.461 100 68 136 1 1443319168 40628960 17703984
20:50:52 21188 8192000000 10336785280 10763620352 1400581680 14.600 100 34 68 1 1443800832 33604400 9614752
20:52:19 16024 8192000000 10330337536 10760626176 1394965792 14.550 100 27 54 0 1438217968 35559856 7692320
20:53:56 10991 8192000000 10324068176 10755231744 1380173408 14.418 100 41 80 0 1433566192 41632992 11759792
20:55:13 13094 8192000000 10318432224 10759942144 1387718944 14.486 100 46 91 0 1432551200 31936720 12895536
20:56:28 64276 8192000000 10291712976 10741456896 1373998272 14.363 99 8 14 0 1388382752 13031584 1352896
20:58:37 91281 8192000000 10306314960 10760736768 1392350048 14.527 100 11 23 0 1406570816 11198064 3022704
21:01:23 13802 8192000000 10309815648 10754473984 1399576736 14.591 100 25 51 0 1417916880 12757024 5583120
21:02:41 117188 8192000000 10332394192 10774802432 1402611168 14.618 100 30 60 1 1426300208 16573968 7115072
21:05:43 86758 8192000000 10310213024 10776092672 1395078352 14.551 99 15 29 1 1414075520 15913968 3083200
21:08:11 11109 8192000000 10320450128 10754494464 1381760912 14.432 98 55 108 2 1401781808 7310112 12710784
21:09:24 7717 8192000000 10324575504 10768859136 1404965376 14.639 100 48 96 1 1428416464 12542128 10908960
21:10:35 49359 8192000000 10295933136 10755063808 1388942352 14.496 99 12 24 0 1399589488 7954640 2692496
21:12:29 41878 8192000000 10299293344 10755923968 1377702032 14.396 98 23 43 0 1390924336 8443152 4779152
21:14:36 36537 8192000000 10263553472 10710134784 1321144016 13.887 96 41 81 1 1345203392 13917232 10142144
21:16:14 50881 8192000000 10270276496 10738810880 1344579424 14.099 98 8 16 0 1361639040 15185232 1874384
21:18:05 43934 8192000000 10263785648 10706755584 1330386864 13.971 97 19 38 0 1342987632 8501024 4099744
21:19:50 59955 8192000000 10237647392 10683297792 1281229936 13.524 95 14 28 0 1296191216 11759824 3201456
21:21:54 29407 8192000000 10255304896 10706141184 1330386272 13.971 98 22 44 0 1350255600 14651280 5218048
21:23:24 13309 8192000000 10253558640 10688749568 1339654576 14.054 99 38 77 1 1356656336 8932304 8069456
21:24:38 15170 8192000000 10261509824 10685358080 1337559616 14.035 100 46 92 0 1362137216 14460592 10117008
21:25:55 6559 8192000000 10278756496 10700390400 1353394832 14.178 100 63 123 0 1376755392 9001632 14358928
21:27:03 51551 8192000000 10260455520 10713083904 1349966896 14.147 100 20 40 0 1371424144 16715504 4741744
21:29:04 33411 8192000000 10261844704 10692780032 1305136672 13.742 96 27 54 0 1321823888 10387152 6300064
21:30:42 111591 8192000000 10244231280 10681860096 1325838800 13.930 98 41 82 0 1344391328 9027296 9525232
21:33:43 4202 8192000000 10250055728 10688712704 1338369568 14.043 99 25 50 0 1357913920 13805408 5738944
21:34:49 45472 8192000000 10239805600 10693263360 1338003584 14.039 99 18 36 0 1354076576 11777344 4295648
21:38:13 28984 8192000000 10253179904 10705448960 1344731552 14.100 99 30 59 1 1363358688 11973328 6653808
21:39:57 65554 8192000000 10282708576 10730061824 1376899696 14.389 100 26 47 0 1389200640 7847792 4453152
21:42:04 43052 8192000000 10304731968 10744369152 1375937024 14.380 99 25 49 0 1393019232 11154960 5927248
21:43:52 53403 8192000000 10293398160 10742329344 1366251552 14.293 98 18 35 1 1379050928 8937600 3861776
21:45:47 51470 8192000000 10311223136 10754060288 1383352320 14.447 99 28 56 0 1400559904 11019680 6187904
21:47:43 56406 8192000000 10314993664 10766209024 1358087632 14.220 97 40 78 0 1382021616 14861856 9072128
21:49:40 62053 8192000000 10321599568 10767929344 1373114112 14.355 98 22 43 0 1394296112 16917568 4264432
21:51:43 16122 8192000000 10304968608 10737594368 1363300240 14.267 98 51 102 3 1386479872 12111360 11068272
21:53:04 64004 8192000000 10284440144 10746908672 1352602048 14.171 98 14 28 0 1371490560 16156464 2732048
21:55:08 95565 8192000000 10281576016 10727518208 1355812480 14.200 98 35 70 1 1370411168 6905904 7692784
21:57:53 42259 8192000000 10267748016 10727206912 1367892560 14.308 99 16 32 0 1379371424 7703936 3774928
21:59:37 21000 8192000000 10267373808 10726420480 1371400992 14.340 100 9 18 0 1384981360 11553920 2026448
22:01:04 56899 8192000000 10250468032 10711289856 1312545104 13.809 96 9 18 1 1327693472 12752816 2395552
22:03:08 48082 8192000000 10267038880 10724646912 1344095264 14.094 99 18 35 0 1359097312 11055152 3946896
22:04:58 67114 8192000000 10243209168 10690195456 1259095808 13.322 93 31 62 1 1281803936 15276640 7431488
22:07:06 84385 8192000000 10247542128 10702729216 1308767024 13.775 97 15 31 0 1324856992 12845888 3244080
22:09:36 9893 8192000000 8878263456 9187549184 4048240 0.049 1 1 2 0 4152768 62176 42352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 27-02-2024 22:10:46 to 27-02-2024 22:11:00.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 93 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

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

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          184293
MON$OLDEST_ACTIVE               184294
MON$OLDEST_SNAPSHOT             184294
MON$NEXT_TRANSACTION            184294
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                       1911072
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Tue Feb 27 22:11:04 2024 
 
Database header page information: 
    Flags            0 
    Generation        95886 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    184293 
    Oldest active        184294 
    Oldest snapshot        184294 
    Next transaction    184295 
    Sequence number        0 
    Next attachment ID    736 
    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.18, total records: 7869039 
    Average version length: 48.16, total versions: 118233, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 87112 
    Data pages: 87112, average fill: 72% 
    Primary pages: 87112, secondary pages: 0, swept pages: 14951 
    Empty pages: 10, full pages: 72317 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 37 
    40 - 59% = 602 
    60 - 79% = 86402 
    80 - 99% = 47 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23704, nodes: 7869039 
    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: 1759198, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 371 
        20 - 39% = 1647 
        40 - 59% = 4614 
        60 - 79% = 2218 
        80 - 99% = 14854 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13745, nodes: 7869039 
    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: 1581300, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1495 
        40 - 59% = 2355 
        60 - 79% = 1006 
        80 - 99% = 8889 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8497, nodes: 7869039 
    Average node length: 6.64, total dup: 5849734, max dup: 49 
    Average key length: 3.65, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1574200, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 134 
        20 - 39% = 849 
        40 - 59% = 1657 
        60 - 79% = 812 
        80 - 99% = 5045 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.00, total records: 2311249 
    Average version length: 34.77, total versions: 118434, max versions: 3 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28360 
    Data pages: 28360, average fill: 76% 
    Primary pages: 28356, secondary pages: 4, swept pages: 8615 
    Empty pages: 2, full pages: 23969 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 15 
    40 - 59% = 210 
    60 - 79% = 26699 
    80 - 99% = 1429 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4682, nodes: 2311249 
    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: 717584, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 858 
        40 - 59% = 1022 
        60 - 79% = 643 
        80 - 99% = 2159 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2525, nodes: 2314692 
    Average node length: 4.97, total dup: 2313793, max dup: 20710 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1277129, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 197 
        40 - 59% = 1521 
        60 - 79% = 578 
        80 - 99% = 227 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2043, nodes: 2311249 
    Average node length: 4.97, total dup: 2311199, max dup: 130615 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1073930, ratio: 0.46 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 23 
        40 - 59% = 1133 
        60 - 79% = 36 
        80 - 99% = 844 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4496, nodes: 2311249 
    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: 717584, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 516 
        40 - 59% = 776 
        60 - 79% = 723 
        80 - 99% = 2338 
 
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.17, total records: 400 
    Average version length: 22.88, total versions: 255531, max versions: 667 
    Average fragment length: 2.00, total fragments: 67, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1416 
    Data pages: 1416, average fill: 90% 
    Primary pages: 10, secondary pages: 1406, swept pages: 0 
    Empty pages: 3, full pages: 1412 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1411 
 
    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: 8.24, total records: 147286 
    Average version length: 68.29, total versions: 129523, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 10.68 
    Pointer pages: 6, data page slots: 2728 
    Data pages: 2448, average fill: 75% 
    Primary pages: 2447, secondary pages: 1, swept pages: 0 
    Empty pages: 174, full pages: 1845 
    Fill distribution: 
     0 - 19% = 268 
    20 - 39% = 119 
    40 - 59% = 133 
    60 - 79% = 230 
    80 - 99% = 1698 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708063, depth: 3, leaf buckets: 409, nodes: 147286 
    Average node length: 13.07, total dup: 12730, max dup: 2 
    Average key length: 10.52, compression ratio: 2.57 
    Average prefix length: 19.40, average data length: 7.60 
    Clustering factor: 107193, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 14 
        40 - 59% = 223 
        60 - 79% = 171 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18539, max versions: 1024 
    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: 82% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 61 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.99, total records: 2517 
    Average version length: 43.73, total versions: 2348, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 19.37 
    Pointer pages: 1, data page slots: 96 
    Data pages: 38, average fill: 64% 
    Primary pages: 36, secondary pages: 2, swept pages: 0 
    Empty pages: 3, full pages: 24 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93029, depth: 2, leaf buckets: 2, nodes: 2517 
    Average node length: 4.19, total dup: 2420, max dup: 292 
    Average key length: 2.41, compression ratio: 7.88 
    Average prefix length: 18.63, average data length: 0.37 
    Clustering factor: 1288, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 2 
        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: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 34.88, total records: 795541 
    Average version length: 25.27, total versions: 115003, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.55 
    Pointer pages: 5, data page slots: 7936 
    Data pages: 7912, average fill: 72% 
    Primary pages: 7884, secondary pages: 28, swept pages: 877 
    Empty pages: 64, full pages: 7526 
    Fill distribution: 
     0 - 19% = 125 
    20 - 39% = 79 
    40 - 59% = 45 
    60 - 79% = 7089 
    80 - 99% = 574 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 876, nodes: 795541 
    Average node length: 4.87, total dup: 795492, max dup: 142308 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90611, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 110 
        40 - 59% = 491 
        60 - 79% = 228 
        80 - 99% = 44 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 906, nodes: 795541 
    Average node length: 5.88, total dup: 708200, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160284, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 115 
        40 - 59% = 331 
        60 - 79% = 165 
        80 - 99% = 294 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 937, nodes: 795541 
    Average node length: 5.88, total dup: 708200, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162245, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 199 
        40 - 59% = 285 
        60 - 79% = 139 
        80 - 99% = 314 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1111, nodes: 795541 
    Average node length: 5.96, total dup: 708200, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155358, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 232 
        40 - 59% = 578 
        60 - 79% = 202 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5397 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.85, total fragments: 88, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 71, secondary pages: 17, swept pages: 47 
    Empty pages: 5, full pages: 65 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5397 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.01 
    Average prefix length: 34.31, average data length: 1.55 
    Clustering factor: 5123, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5397 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 140, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.15, total records: 84092 
    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: 5, full pages: 810 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 810 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36091, depth: 2, leaf buckets: 108, nodes: 84092 
    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: 3108, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        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.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 146.77, total records: 184840 
    Average version length: 152.97, total versions: 5184, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 7, data page slots: 5960 
    Data pages: 4480, average fill: 85% 
    Primary pages: 4480, secondary pages: 0, swept pages: 7 
    Empty pages: 73, full pages: 4353 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 12 
    40 - 59% = 34 
    60 - 79% = 8 
    80 - 99% = 4352 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 148.14, total records: 191534 
    Average version length: 152.57, total versions: 3794, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 7032 
    Data pages: 4648, average fill: 85% 
    Primary pages: 4648, secondary pages: 0, swept pages: 3 
    Empty pages: 91, full pages: 4530 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 11 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4529 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 128.29, total records: 201806 
    Average version length: 155.04, total versions: 30205, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.22 
    Pointer pages: 6, data page slots: 5496 
    Data pages: 4880, average fill: 87% 
    Primary pages: 4880, secondary pages: 0, swept pages: 4 
    Empty pages: 66, full pages: 4782 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 12 
    40 - 59% = 11 
    60 - 79% = 7 
    80 - 99% = 4781 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 139.25, total records: 202307 
    Average version length: 154.85, total versions: 16031, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.18 
    Pointer pages: 8, data page slots: 6176 
    Data pages: 4872, average fill: 86% 
    Primary pages: 4872, secondary pages: 0, swept pages: 3 
    Empty pages: 51, full pages: 4800 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 4800 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.66, total records: 163013 
    Average version length: 152.46, total versions: 2585, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 5232 
    Data pages: 3968, average fill: 85% 
    Primary pages: 3967, secondary pages: 1, swept pages: 8 
    Empty pages: 88, full pages: 3852 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3851 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.93, total records: 179185 
    Average version length: 151.68, total versions: 2491, 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: 6, data page slots: 5016 
    Data pages: 4344, average fill: 85% 
    Primary pages: 4344, secondary pages: 0, swept pages: 3 
    Empty pages: 82, full pages: 4232 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 13 
    40 - 59% = 8 
    60 - 79% = 9 
    80 - 99% = 4230 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.01, total records: 187976 
    Average version length: 152.33, total versions: 3833, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 6, data page slots: 5328 
    Data pages: 4592, average fill: 84% 
    Primary pages: 4592, secondary pages: 0, swept pages: 4 
    Empty pages: 117, full pages: 4437 
    Fill distribution: 
     0 - 19% = 118 
    20 - 39% = 14 
    40 - 59% = 17 
    60 - 79% = 8 
    80 - 99% = 4435 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 136.97, total records: 189680 
    Average version length: 154.54, total versions: 17595, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.38 
    Pointer pages: 6, data page slots: 6400 
    Data pages: 4600, average fill: 86% 
    Primary pages: 4600, secondary pages: 0, swept pages: 4 
    Empty pages: 84, full pages: 4488 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 11 
    40 - 59% = 7 
    60 - 79% = 9 
    80 - 99% = 4488 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.92, total records: 163964 
    Average version length: 151.01, total versions: 2147, 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: 5680 
    Data pages: 3944, average fill: 86% 
    Primary pages: 3943, secondary pages: 1, swept pages: 3 
    Empty pages: 49, full pages: 3874 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 11 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3876 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.07, total records: 176392 
    Average version length: 153.40, total versions: 3445, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 8, data page slots: 6040 
    Data pages: 4288, average fill: 85% 
    Primary pages: 4288, secondary pages: 0, swept pages: 6 
    Empty pages: 91, full pages: 4167 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 8 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 4168 
 
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.31, total records: 2168021 
    Average version length: 52.93, total versions: 59279, 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: 25512 
    Data pages: 25512, average fill: 73% 
    Primary pages: 25512, secondary pages: 0, swept pages: 8765 
    Empty pages: 105, full pages: 22885 
    Fill distribution: 
     0 - 19% = 207 
    20 - 39% = 190 
    40 - 59% = 545 
    60 - 79% = 24005 
    80 - 99% = 565 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2627, nodes: 2168021 
    Average node length: 5.43, total dup: 2025578, max dup: 1814 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 186115, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 263 
        40 - 59% = 1733 
        60 - 79% = 303 
        80 - 99% = 319 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2760, nodes: 2168021 
    Average node length: 5.69, total dup: 1947067, max dup: 64 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 386231, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2231 
        60 - 79% = 488 
        80 - 99% = 40 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2201, nodes: 2168021 
    Average node length: 4.96, total dup: 2167921, max dup: 28694 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 183696, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 163 
        40 - 59% = 1185 
        60 - 79% = 452 
        80 - 99% = 399 
 
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: 34.74, total records: 177804 
    Average version length: 69.17, total versions: 88584, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.63 
    Pointer pages: 3, data page slots: 3984 
    Data pages: 3064, average fill: 68% 
    Primary pages: 3064, secondary pages: 0, swept pages: 339 
    Empty pages: 476, full pages: 2486 
    Fill distribution: 
     0 - 19% = 573 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 684 
    80 - 99% = 1803 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 334721, depth: 3, leaf buckets: 237, nodes: 177804 
    Average node length: 6.46, total dup: 155003, max dup: 14 
    Average key length: 3.89, compression ratio: 10.79 
    Average prefix length: 40.24, average data length: 1.76 
    Clustering factor: 29645, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 106 
        60 - 79% = 84 
        80 - 99% = 35 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.45, total records: 6997064 
    Average version length: 68.78, total versions: 558807, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.99 
    Pointer pages: 61, data page slots: 98904 
    Data pages: 98904, average fill: 76% 
    Primary pages: 98904, secondary pages: 0, swept pages: 15517 
    Empty pages: 2, full pages: 85920 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 579 
    40 - 59% = 4087 
    60 - 79% = 82062 
    80 - 99% = 12138 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10613, nodes: 6997064 
    Average node length: 6.51, total dup: 6056201, max dup: 44 
    Average key length: 3.52, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1564933, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1634 
        40 - 59% = 5888 
        60 - 79% = 2567 
        80 - 99% = 512 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8521, nodes: 6997064 
    Average node length: 5.40, total dup: 6717537, max dup: 176 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1360055, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1320 
        40 - 59% = 4662 
        60 - 79% = 1443 
        80 - 99% = 1083 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8554, nodes: 6997064 
    Average node length: 5.40, total dup: 6717537, max dup: 176 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1362587, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1386 
        40 - 59% = 4584 
        60 - 79% = 1506 
        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.31, total records: 11927860 
    Average version length: 68.72, total versions: 456413, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 102, data page slots: 165440 
    Data pages: 165440, average fill: 77% 
    Primary pages: 165440, secondary pages: 0, swept pages: 63446 
    Empty pages: 9, full pages: 155703 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 372 
    40 - 59% = 2775 
    60 - 79% = 152863 
    80 - 99% = 9396 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18310, nodes: 11927860 
    Average node length: 6.56, total dup: 10398738, max dup: 63 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2372259, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 2430 
        40 - 59% = 10925 
        60 - 79% = 4172 
        80 - 99% = 750 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 38.25, total records: 1833027 
    Average version length: 69.15, total versions: 819400, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.29 
    Pointer pages: 27, data page slots: 43616 
    Data pages: 27728, average fill: 76% 
    Primary pages: 27728, secondary pages: 0, swept pages: 3720 
    Empty pages: 1101, full pages: 23533 
    Fill distribution: 
     0 - 19% = 1829 
    20 - 39% = 833 
    40 - 59% = 817 
    60 - 79% = 10157 
    80 - 99% = 14092 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2229, nodes: 1833027 
    Average node length: 5.50, total dup: 1759465, max dup: 99 
    Average key length: 2.54, compression ratio: 16.51 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 123372, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 275 
        40 - 59% = 1108 
        60 - 79% = 606 
        80 - 99% = 228 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 32.96, total records: 1352475 
    Average version length: 69.14, total versions: 706618, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.82 
    Pointer pages: 21, data page slots: 33344 
    Data pages: 26760, average fill: 59% 
    Primary pages: 26760, secondary pages: 0, swept pages: 5259 
    Empty pages: 5485, full pages: 17685 
    Fill distribution: 
     0 - 19% = 7308 
    20 - 39% = 553 
    40 - 59% = 407 
    60 - 79% = 5191 
    80 - 99% = 13301 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1622, nodes: 1352475 
    Average node length: 5.74, total dup: 1268731, max dup: 130 
    Average key length: 2.79, compression ratio: 15.03 
    Average prefix length: 41.27, average data length: 0.73 
    Clustering factor: 179717, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 117 
        40 - 59% = 731 
        60 - 79% = 577 
        80 - 99% = 189 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.62, total records: 9663805 
    Average version length: 69.02, total versions: 599547, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 89, data page slots: 144592 
    Data pages: 144576, average fill: 72% 
    Primary pages: 144575, secondary pages: 1, swept pages: 45718 
    Empty pages: 274, full pages: 98298 
    Fill distribution: 
     0 - 19% = 977 
    20 - 39% = 4464 
    40 - 59% = 15963 
    60 - 79% = 110472 
    80 - 99% = 12700 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13531, nodes: 9663805 
    Average node length: 6.68, total dup: 8018024, max dup: 27 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2113420, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 740 
        40 - 59% = 6496 
        60 - 79% = 5357 
        80 - 99% = 937 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21202501 
    Average version length: 82.97, total versions: 17129, 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: 319384 
    Data pages: 319384, average fill: 81% 
    Primary pages: 319384, secondary pages: 0, swept pages: 12339 
    Empty pages: 0, full pages: 319383 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 27208 
    80 - 99% = 292175 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19254, nodes: 21202501 
    Average node length: 5.72, total dup: 20720245, max dup: 134 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288457, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 7823 
        60 - 79% = 517 
        80 - 99% = 10909 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17217, nodes: 21202501 
    Average node length: 6.31, total dup: 18633321, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915900, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 4 
        40 - 59% = 785 
        60 - 79% = 253 
        80 - 99% = 16169 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21060, nodes: 21202501 
    Average node length: 6.35, total dup: 18551574, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3583692, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 3 
        40 - 59% = 8110 
        60 - 79% = 616 
        80 - 99% = 12326 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16222, nodes: 21202501 
    Average node length: 5.56, total dup: 21202401, max dup: 232650 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944749, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 3035 
        60 - 79% = 420 
        80 - 99% = 12757 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.62, total records: 10108598 
    Average version length: 82.64, total versions: 589413, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 106, data page slots: 171936 
    Data pages: 171928, average fill: 73% 
    Primary pages: 171928, secondary pages: 0, swept pages: 64890 
    Empty pages: 346, full pages: 112929 
    Fill distribution: 
     0 - 19% = 1186 
    20 - 39% = 5345 
    40 - 59% = 19826 
    60 - 79% = 70617 
    80 - 99% = 74954 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11408, nodes: 10108598 
    Average node length: 5.36, total dup: 9795258, max dup: 195 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2235234, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 39 
        40 - 59% = 7089 
        60 - 79% = 4089 
        80 - 99% = 189 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13983, nodes: 10108598 
    Average node length: 6.24, total dup: 8381499, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1551367, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 134 
        20 - 39% = 3825 
        40 - 59% = 4854 
        60 - 79% = 2460 
        80 - 99% = 2710 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12729, nodes: 10108598 
    Average node length: 5.98, total dup: 8781718, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2436903, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 38 
        40 - 59% = 7986 
        60 - 79% = 4437 
        80 - 99% = 264 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10599, nodes: 10108598 
    Average node length: 5.14, total dup: 10108498, max dup: 164494 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1594159, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 53 
        20 - 39% = 1190 
        40 - 59% = 5406 
        60 - 79% = 1854 
        80 - 99% = 2096 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.33, total records: 11722512 
    Average version length: 82.53, total versions: 425397, 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: 119, data page slots: 193800 
    Data pages: 192528, average fill: 75% 
    Primary pages: 192528, secondary pages: 0, swept pages: 62070 
    Empty pages: 1969, full pages: 152183 
    Fill distribution: 
     0 - 19% = 3491 
    20 - 39% = 5573 
    40 - 59% = 14641 
    60 - 79% = 42428 
    80 - 99% = 126395 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13134, nodes: 11722512 
    Average node length: 5.31, total dup: 11611908, max dup: 659 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2444193, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 52 
        40 - 59% = 8124 
        60 - 79% = 4640 
        80 - 99% = 317 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10775, nodes: 11722512 
    Average node length: 5.51, total dup: 11212756, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 737346, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 806 
        40 - 59% = 2702 
        60 - 79% = 1886 
        80 - 99% = 5253 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15038, nodes: 11722512 
    Average node length: 6.04, total dup: 10236862, max dup: 65 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2460835, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 51 
        40 - 59% = 9637 
        60 - 79% = 4992 
        80 - 99% = 355 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11342, nodes: 11722512 
    Average node length: 5.24, total dup: 11722412, max dup: 194763 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 725949, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 768 
        40 - 59% = 5436 
        60 - 79% = 1549 
        80 - 99% = 3489 
 
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.01, total records: 10222325 
    Average version length: 82.97, total versions: 584694, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 108, data page slots: 175856 
    Data pages: 175848, average fill: 72% 
    Primary pages: 175848, secondary pages: 0, swept pages: 69847 
    Empty pages: 426, full pages: 110659 
    Fill distribution: 
     0 - 19% = 1391 
    20 - 39% = 5667 
    40 - 59% = 22036 
    60 - 79% = 74410 
    80 - 99% = 72344 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12233, nodes: 10222325 
    Average node length: 5.18, total dup: 10192940, max dup: 2287 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2048662, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1379 
        40 - 59% = 8200 
        60 - 79% = 1986 
        80 - 99% = 640 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14101, nodes: 10222325 
    Average node length: 6.25, total dup: 8475269, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1515550, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 204 
        20 - 39% = 3786 
        40 - 59% = 4788 
        60 - 79% = 2439 
        80 - 99% = 2884 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12909, nodes: 10222325 
    Average node length: 5.44, total dup: 9768852, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2187299, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1322 
        40 - 59% = 9141 
        60 - 79% = 1831 
        80 - 99% = 588 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10769, nodes: 10222325 
    Average node length: 5.16, total dup: 10222225, max dup: 166885 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1615902, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1210 
        40 - 59% = 5555 
        60 - 79% = 1838 
        80 - 99% = 2115 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.17, total records: 581987 
    Average version length: 68.78, total versions: 8614, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8008 
    Data pages: 8008, average fill: 76% 
    Primary pages: 8008, secondary pages: 0, swept pages: 3420 
    Empty pages: 2, full pages: 7105 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 14 
    40 - 59% = 121 
    60 - 79% = 7707 
    80 - 99% = 162 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42266, depth: 3, leaf buckets: 736, nodes: 581987 
    Average node length: 5.95, total dup: 495522, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101425, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 507 
        60 - 79% = 108 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 21695, depth: 3, leaf buckets: 760, nodes: 581987 
    Average node length: 6.15, total dup: 477340, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101492, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 24 
        40 - 59% = 525 
        60 - 79% = 108 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 570, nodes: 581987 
    Average node length: 4.86, total dup: 581887, max dup: 9981 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90078, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 328 
        60 - 79% = 92 
        80 - 99% = 122 
 
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 Tue Feb 27 22:11:28 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7869039 118233 1 0.0000 0.0000
DOC_LIST 2311249 118434 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 255531 667 63800.0000 0.0000
INVNT_TURNOVER_LOG 147286 129523 1 0.0000 0.0000
MONEY_SALDO 49 18539 1024 37800.0000 0.0000
MONEY_TURNOVER_LOG 2517 2348 1 0.0000 0.0000
PDISTR 795541 115003 5 0.0000 0.0000
PERF_SPLIT_0 184840 5184 1 0.0000 0.0000
PERF_SPLIT_1 191534 3794 1 0.0000 0.0000
PERF_SPLIT_2 201806 30205 1 0.0000 0.0000
PERF_SPLIT_3 202307 16031 1 0.0000 0.0000
PERF_SPLIT_4 163013 2585 1 0.0000 0.0000
PERF_SPLIT_5 179185 2491 1 0.0000 0.0000
PERF_SPLIT_6 187976 3833 1 0.0000 0.0000
PERF_SPLIT_7 189680 17595 1 0.0000 0.0000
PERF_SPLIT_8 163964 2147 1 0.0000 0.0000
PERF_SPLIT_9 176392 3445 1 0.0000 0.0000
PSTORNED 2168021 59279 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 177804 88584 1 0.0000 0.0000
XQD_1000_3300 6997064 558807 1 0.0000 0.0000
XQD_1200_2000 11927860 456413 1 0.0000 0.0000
XQD_2000_3300 1833027 819400 1 0.0000 0.0000
XQD_2100_3300 1352475 706618 1 0.0000 0.0000
XQD_3300_3400 9663805 599547 1 0.0000 0.0000
XQS_1000_1200 21202501 17129 1 0.0000 0.0000
XQS_1000_3300 10108598 589413 1 0.0000 0.0000
XQS_1200_2000 11722512 425397 1 0.0000 0.0000
XQS_2100_3300 10222325 584694 1 0.0000 0.0000
XQS_3300_3400 581987 8614 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'  

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