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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-19 07:07:49
DTS_END                         2024-03-19 07:07:49.9220
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/52080
TRN_ID                          172995
ATT_ID                          535
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: 9127.98 23258 912798
customer order: creation 175.59 384 17559
customer order: refuse 14.93 376 1493
order to supplier: creation 47.09 1235 4709
order to supplier: removal 3.45 88330 345
invoice (draft): creation 46.44 3176 4644
invoice (draft): removal 48.53 684 4853
invoice accept: apply 43.41 21508 4341
invoice accept: cancel 44.07 803 4407
customer reserve: creation 4134.82 208 413482
customer reserve: removal 4273.11 57 427311
realization accept: apply 84.88 211 8488
realization accept: cancel 81.09 132 8109
payment from customer: creation 60.54 131 6054
payment from customer: removal 5.88 80 588
payment to supplier: creation 49.93 156 4993
payment to supplier: removal 3.74 116 374
service: total inventory turnovers 3.65 4456 365
service: total monetary turnovers 5.78 602 578
service: aggregate perf. data 1.02 13426 102
service: refresh index statistics 0.03 329091 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-03-2024 07:10:19 to 19-03-2024 07:10:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2311
TEST_TIME 2 3237
TEST_TIME 3 3510
TEST_TIME 4 2902
TEST_TIME 5 5074
TEST_TIME 6 5332
TEST_TIME 7 5872
TEST_TIME 8 5912
TEST_TIME 9 6239
TEST_TIME 10 6052
TEST_TIME 11 6040
TEST_TIME 12 5936
TEST_TIME 13 6069
TEST_TIME 14 6441
TEST_TIME 15 6576
TEST_TIME 16 6594
TEST_TIME 17 6577
TEST_TIME 18 6802
TEST_TIME 19 7074
TEST_TIME 20 7108
TEST_TIME 21 7285
TEST_TIME 22 7438
TEST_TIME 23 7518
TEST_TIME 24 7546
TEST_TIME 25 7920
TEST_TIME 26 8626
TEST_TIME 27 8590
TEST_TIME 28 9140
TEST_TIME 29 9253
TEST_TIME 30 9225
TEST_TIME 31 9264
TEST_TIME 32 9148
TEST_TIME 33 9269
TEST_TIME 34 9494
TEST_TIME 35 9518
TEST_TIME 36 9505
TEST_TIME 37 9399
TEST_TIME 38 9269
TEST_TIME 39 9253
TEST_TIME 40 9158
TEST_TIME 41 9094
TEST_TIME 42 9041
TEST_TIME 43 9224
TEST_TIME 44 9131
TEST_TIME 45 9035
TEST_TIME 46 8925
TEST_TIME 47 8908
TEST_TIME 48 9124
TEST_TIME 49 9164
TEST_TIME 50 9131
TEST_TIME 51 9155
TEST_TIME 52 9171
TEST_TIME 53 9201
TEST_TIME 54 9191
TEST_TIME 55 9233
TEST_TIME 56 9229
TEST_TIME 57 9363
TEST_TIME 58 9220
TEST_TIME 59 9190
TEST_TIME 60 9099
TEST_TIME 61 9138
TEST_TIME 62 9053
TEST_TIME 63 9005
TEST_TIME 64 9017
TEST_TIME 65 8938
TEST_TIME 66 9187
TEST_TIME 67 9168
TEST_TIME 68 9118
TEST_TIME 69 9090
TEST_TIME 70 9267
TEST_TIME 71 9258
TEST_TIME 72 9280
TEST_TIME 73 9355
TEST_TIME 74 9367
TEST_TIME 75 9382
TEST_TIME 76 9316
TEST_TIME 77 9241
TEST_TIME 78 9251
TEST_TIME 79 9245
TEST_TIME 80 9171
TEST_TIME 81 9136
TEST_TIME 82 9076
TEST_TIME 83 9122
TEST_TIME 84 9097
TEST_TIME 85 9116
TEST_TIME 86 9100
TEST_TIME 87 9186
TEST_TIME 88 9180
TEST_TIME 89 9178
TEST_TIME 90 9178
TEST_TIME 91 9232
TEST_TIME 92 9235
TEST_TIME 93 9339
TEST_TIME 94 9372
TEST_TIME 95 9356
TEST_TIME 96 9274
TEST_TIME 97 9239
TEST_TIME 98 9174
TEST_TIME 99 9170
TEST_TIME 100 9131

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-03-2024 07:10:22 to 19-03-2024 07:10:26.

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 1290343 1290343 0 0.00 0 20025 8 0 0
doc_list_biud 1290343 1290343 0 0.00 0 30377 24 0 0
sp_add_invoice_to_stock 4454 4341 113 2.53 52 196425 21509 0 113
sp_cancel_adding_invoice 4407 4407 0 0.00 4 85409 803 0 0
sp_cancel_client_order 1493 1493 0 0.00 4 10100 376 0 0
sp_cancel_customer_reserve 427311 427311 0 0.00 0 30379 57 0 0
sp_cancel_pay_from_customer 588 588 0 0.00 3 7044 80 0 0
sp_cancel_pay_to_supplier 374 374 0 0.00 2 6007 116 0 0
sp_cancel_supplier_invoice 4864 4853 11 0.22 1 29701 684 0 11
sp_cancel_supplier_order 345 345 0 0.00 5 871053 88331 0 0
sp_cancel_write_off 8109 8109 0 0.00 1 24146 132 0 0
sp_client_order 17559 17559 0 0.00 3 23755 385 0 0
sp_customer_reserve 413482 413482 0 0.00 0 129013 208 0 0
sp_fill_shopping_cart 26904 26904 0 0.00 1 16164 38 0 0
sp_fill_shopping_cart_clo_res 413478 413478 0 0.00 0 28389 17 0 0
sp_get_clo_for_invoice 4337 4337 0 0.00 0 35411 425 0 0
sp_kill_cost_storno 13478 13478 0 0.00 0 9061 67 0 0
sp_kill_qstorno_ret_qs2qd 867929 867929 0 0.00 0 30375 31 0 0
sp_kill_qty_storno 459343 459343 0 0.00 0 30377 67 0 0
sp_lock_selected_doc 17789 17789 0 0.00 0 9666 6 0 0
sp_make_cost_storno 23872 23872 0 0.00 0 19621 70 0 0
sp_multiply_rows_for_pdistr 23872 23872 0 0.00 0 7905 37 0 0
sp_multiply_rows_for_qdistr 17559 17559 0 0.00 0 17802 173 0 0
sp_pay_from_customer 6054 6054 0 0.00 3 14012 131 0 0
sp_pay_to_supplier 4993 4993 0 0.00 4 15844 157 0 0
sp_payment_common 11047 11047 0 0.00 1 13944 33 0 0
sp_qd_handle_on_cancel_clo 1493 1493 0 0.00 0 10096 351 0 0
sp_qd_handle_on_invoice_upd_sts 8744 8744 0 0.00 0 25283 293 0 0
sp_qd_handle_on_reserve_upd_sts 8488 8488 0 0.00 0 21521 61 0 0
sp_reserve_write_off 8488 8488 0 0.00 6 21566 212 0 0
sp_supplier_invoice 4644 4644 0 0.00 6 94324 3176 0 0
sp_supplier_order 4709 4709 0 0.00 4 22069 1235 0 0
srv_aggregate_perf_data 102 102 0 0.00 1596 197283 13426 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1239 104718 36416 0 0
srv_find_qd_qs_mism 868843 868843 0 0.00 0 20022 8 0 0
srv_make_invnt_saldo 365 365 0 0.00 87 100381 4457 0 0
srv_make_money_saldo 578 578 0 0.00 1 12064 602 0 0
srv_recalc_idx_stat 3 3 0 0.00 280900 397967 329091 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4341 4341 0 0.00 0 5393 168 0 0
t$perf-norm:sp_cancel_adding_invoice 357 357 0 0.00 0 7999 100 0 0
t$perf-norm:sp_cancel_client_order 1493 1493 0 0.00 0 5712 22 0 0
t$perf-norm:sp_cancel_customer_reserve 612 612 0 0.00 0 7056 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 588 588 0 0.00 0 1781 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 374 374 0 0.00 0 4329 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 347 347 0 0.00 0 3203 32 0 0
t$perf-norm:sp_cancel_supplier_order 345 345 0 0.00 0 23805 1536 0 0
t$perf-norm:sp_cancel_write_off 848 848 0 0.00 0 5693 11 0 0
t$perf-norm:sp_client_order 17561 17561 0 0.00 0 5830 16 0 0
t$perf-norm:sp_customer_reserve 823 823 0 0.00 0 350 4 0 0
t$perf-norm:sp_pay_from_customer 6054 6054 0 0.00 0 11101 12 0 0
t$perf-norm:sp_pay_to_supplier 4993 4993 0 0.00 0 4818 8 0 0
t$perf-norm:sp_reserve_write_off 8489 8489 0 0.00 0 10506 12 0 0
t$perf-norm:sp_supplier_invoice 4644 4644 0 0.00 0 9887 19 0 0
t$perf-norm:sp_supplier_order 4709 4709 0 0.00 0 23121 22 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 4369 59 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 150 3 0 0
t$perf-norm:srv_make_invnt_saldo 365 365 0 0.00 0 1695 12 0 0
t$perf-norm:srv_make_money_saldo 578 578 0 0.00 0 5846 15 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 12 5 0 0
v_add_invoice_to_stock 8900 8674 226 2.53 0 8608 17 0 226
v_all_customers 32380 32380 0 0.00 0 19 1 0 0
v_all_suppliers 26188 26188 0 0.00 0 23 1 0 0
v_all_wares 35116 35116 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 714 714 0 0.00 0 1170 8 0 0
v_cancel_client_order 2986 2986 0 0.00 0 3703 7 0 0
v_cancel_customer_prepayment 1176 1176 0 0.00 0 840 6 0 0
v_cancel_customer_reserve 1224 1224 0 0.00 0 5260 13 0 0
v_cancel_payment_to_supplier 748 748 0 0.00 0 995 4 0 0
v_cancel_supplier_invoice 716 694 22 3.07 0 2467 21 0 22
v_cancel_supplier_order 690 690 0 0.00 0 2192 8 0 0
v_cancel_write_off 1696 1696 0 0.00 0 4814 19 0 0
v_max_id_clo_ord 4709 4709 0 0.00 0 710 2 0 0
v_max_id_clo_res 823 823 0 0.00 0 3415 17 0 0
v_max_id_ord_sup 4636 4636 0 0.00 0 2740 3 0 0
v_max_non_paid_invoice 1244 1244 0 0.00 0 129 2 0 0
v_max_non_paid_realizn 3024 3024 0 0.00 0 3380 5 0 0
v_min_id_clo_ord 4709 4709 0 0.00 0 16084 15 0 0
v_min_id_clo_res 823 823 0 0.00 0 8265 33 0 0
v_min_id_ord_sup 4636 4636 0 0.00 0 3285 5 0 0
v_min_non_paid_invoice 4993 4993 0 0.00 0 8761 28 0 0
v_min_non_paid_realizn 6054 6054 0 0.00 0 7610 25 0 0
v_our_firm 8796 8796 0 0.00 0 28 1 0 0
v_reserve_write_off 16976 16976 0 0.00 0 4532 8 0 0
x_lock_depdocs_on_canc_invoice 8913 8913 0 0.00 0 13923 111 0 0
x_lock_depdocs_on_canc_sup_ord 345 345 0 0.00 0 2463 306 0 0
x_make_qstorno_1000_1200 4709 4709 0 0.00 1 22065 1152 0 0
x_make_qstorno_1200_2000 4644 4644 0 0.00 2 86944 3038 0 0
x_make_qstorno_2100_3300 413482 413482 0 0.00 0 129011 189 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-03-2024 07:10:27 to 19-03-2024 07:10:31.

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
05:07:53 1 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
05:08:54 28682 8192000000 9719740080 10022862848 791694672 8.812 100 83 167 0 819577568 7730224 20152672
05:10:26 14858 8192000000 9778358016 10093408256 856365200 9.464 100 90 181 0 887313312 10620880 20327232
05:11:48 16875 8192000000 9802183888 10123722752 874365968 9.644 100 91 182 0 911904864 16714912 20823984
05:13:12 12148 8192000000 9852508080 10188185600 912856352 10.026 100 80 160 0 962943472 32901680 17185440
05:14:26 7788 8192000000 9895850672 10240618496 945741472 10.349 100 79 154 1 1008377664 46932896 15703296
05:15:38 5097 8192000000 9952372144 10303062016 969804928 10.585 100 84 166 0 1056613712 70523248 16285536
05:16:46 3711 8192000000 9983859248 10347520000 1002767600 10.905 100 87 174 0 1096404112 76634000 17002512
05:17:53 2298 8192000000 9998130976 10367856640 1023587360 11.107 100 79 156 0 1117815680 79717376 14510944
05:18:57 1552 8192000000 10015102688 10388602880 1044576032 11.309 100 84 165 1 1128007232 67372016 16059184
05:20:00 964 8192000000 10013156016 10390401024 1062856576 11.484 100 84 165 0 1124429632 45811584 15761472
05:21:03 1234 8192000000 10002431392 10388590592 1066697360 11.521 100 76 153 0 1118913392 36303312 15912720
05:22:06 10557 8192000000 9980325712 10383048704 1064953808 11.504 100 36 70 0 1098120016 25768608 7397600
05:23:19 7250 8192000000 9989815376 10392035328 1079067824 11.639 100 40 80 0 1108815424 21622592 8125008
05:24:29 6811 8192000000 9989143552 10403667968 1088152496 11.725 100 15 32 1 1105299552 13723520 3423536
05:25:36 30267 8192000000 10006992368 10407727104 1092291264 11.764 100 54 108 1 1123568496 19659072 11618160
05:27:07 4103 8192000000 10016452944 10421186560 1096631808 11.806 100 46 92 0 1126383184 19462688 10288688
05:28:16 14349 8192000000 10011289760 10418409472 1098777472 11.826 100 33 64 0 1123725024 18272720 6674832
05:29:48 17447 8192000000 10058627968 10460655616 1106685744 11.901 100 50 95 0 1165024768 48285632 10053392
05:31:13 72135 8192000000 10062141664 10490281984 1066771088 11.521 96 25 50 0 1167448864 95086976 5590800
05:33:32 12509 8192000000 10057784368 10466263040 1107821728 11.912 99 50 96 0 1165939760 48444960 9673072
05:34:48 7502 8192000000 10102614416 10500939776 1118089696 12.009 100 70 140 0 1204006608 72137216 13779696
05:36:01 25812 8192000000 10060120176 10462294016 1063713952 11.492 97 57 108 1 1148984400 73989424 11281024
05:37:34 21223 8192000000 10063740096 10464141312 1092674096 11.768 100 46 89 2 1172845296 71095712 9075488
05:39:02 21127 8192000000 10073293008 10468073472 1064756112 11.502 97 41 80 0 1160835920 87681712 8398096
05:40:29 28274 8192000000 10104952784 10519519232 1087414528 11.718 99 36 70 0 1213590976 118214512 7961936
05:42:08 7298 8192000000 10065205520 10459979776 1044165312 11.305 97 48 96 0 1145839408 91900496 9773600
05:43:20 6094 8192000000 10112429760 10506285056 1082041856 11.667 100 53 103 1 1219504224 126070976 11391392
05:44:37 3230 8192000000 10120986464 10508648448 1068086576 11.534 98 51 102 0 1213035696 134130208 10818912
05:45:48 1236 8192000000 10196618176 10578485248 1108937264 11.922 100 94 186 1 1297963584 169622016 19404304
05:46:58 4721 8192000000 10200331088 10593447936 1116721088 11.996 100 76 152 0 1302882544 169286912 16874544
05:48:09 2724 8192000000 10204571344 10616094720 1122151216 12.047 100 67 134 0 1304512560 168086336 14275008
05:49:17 2628 8192000000 10257378864 10678448128 1142515824 12.239 100 69 138 1 1362441904 204623168 15302912
05:50:29 7509 8192000000 10325505200 10759680000 1152142272 12.330 100 38 76 0 1433326192 271746560 9437360
05:51:47 7337 8192000000 10360354912 10800848896 1141420400 12.229 100 43 85 0 1465620416 313872560 10327456
05:53:00 11900 8192000000 10293880608 10796220416 1134128720 12.160 100 30 59 0 1400417632 258917120 7371792
05:54:14 53537 8192000000 10206930080 10675007488 1120079600 12.028 100 28 56 0 1304589152 177573696 6935856
05:56:41 29524 8192000000 10059446064 10492080128 1120572624 12.032 100 20 36 1 1168766336 44540272 3653440
05:58:12 23545 8192000000 10085443520 10514006016 1131802608 12.138 100 30 59 0 1184259456 46265904 6190944
05:59:43 17082 8192000000 10105264848 10527358976 1134816144 12.167 100 58 118 1 1194948736 47639888 12492704
06:01:07 104717 8192000000 10073248464 10533527552 1123075456 12.056 99 9 18 1 1185217920 60551408 1591056
06:03:54 32104 8192000000 10085672752 10523439104 1141819424 12.233 100 19 39 0 1190945280 44861664 4264192
06:05:30 63655 8192000000 10100084192 10559307776 1146400864 12.276 100 39 78 1 1195785872 41448272 7936736
06:07:38 94550 8192000000 10085388736 10535112704 1099331184 11.831 96 23 46 0 1138540240 34735984 4473072
06:10:15 23984 8192000000 10086302928 10577494016 1135915296 12.177 99 24 49 0 1221201104 80615056 4670752
06:11:50 65210 8192000000 10109169648 10560733184 1130991536 12.131 99 16 32 1 1176383280 41938368 3453376
06:14:00 49021 8192000000 10148818176 10607501312 1103575088 11.872 97 20 40 0 1212625344 104784896 4265360
06:15:53 19424 8192000000 10067360128 10495352832 1100702016 11.844 97 45 82 0 1133175824 24299184 8174624
06:17:14 28337 8192000000 10070870144 10523508736 1109559872 11.928 99 33 62 1 1170906528 55052112 6294544
06:18:45 7494 8192000000 10062662736 10469511168 1097474496 11.814 100 67 130 2 1148647152 37299968 13872688
06:19:56 10260 8192000000 10057074464 10477985792 1089846928 11.741 99 33 66 0 1134772992 38702704 6223360
06:21:10 27601 8192000000 10061518288 10497208320 1079738672 11.645 98 39 78 1 1139430912 52501008 7191232
06:22:39 19457 8192000000 10067604272 10506592256 1095459776 11.795 99 45 90 1 1164400864 60751792 8189296
06:24:03 23348 8192000000 10114244752 10550673408 1083147200 11.677 98 46 90 0 1194329584 102314896 8867488
06:25:31 64611 8192000000 10032776720 10497261568 1072896592 11.580 98 23 46 1 1152424592 73643440 5884560
06:28:20 52958 8192000000 10053741520 10516926464 1061057648 11.467 97 37 74 0 1143163808 74770608 7335552
06:31:15 81910 8192000000 10114790368 10588434432 1086189104 11.706 99 18 36 0 1191860192 101567648 4103440
06:33:38 76113 8192000000 10022061136 10468397056 1052990800 11.389 96 14 26 1 1093143056 37552512 2599744
06:35:54 74793 8192000000 10094646144 10556551168 1100280944 11.840 100 17 34 0 1177919760 74155408 3483408
06:38:46 55377 8192000000 10102860784 10584510464 1098287296 11.821 98 21 42 0 1182569008 80453184 3828528
06:40:50 46496 8192000000 10076258336 10507431936 1113421040 11.965 99 17 33 0 1166781888 50249776 3111072
06:42:39 13121 8192000000 10087475040 10514030592 1123453920 12.060 100 46 91 0 1172974288 40594832 8925536
06:43:56 72723 8192000000 10092697216 10536980480 1129263712 12.114 100 49 98 0 1216674096 77729376 9681008
06:46:11 35641 8192000000 10080476416 10547531776 1135574608 12.174 100 24 48 0 1190909088 50430784 4903696
06:47:49 33629 8192000000 10081106912 10568589312 1127154656 12.095 99 7 14 0 1195991728 67190768 1646304
06:49:54 33801 8192000000 10109152272 10590306304 1135276080 12.171 100 29 58 1 1199958160 59016640 5665440
06:51:39 37295 8192000000 10069436624 10519465984 1128467280 12.107 100 25 50 0 1169873200 35705648 5700272
06:53:16 84959 8192000000 10069509600 10591698944 1107232720 11.906 97 16 32 0 1186447232 75841488 3373024
06:55:52 40258 8192000000 10069500448 10508320768 1115143440 11.981 98 15 30 0 1151292624 33510800 2638384
06:57:37 76280 8192000000 10114449888 10620354560 1116974240 11.998 98 16 32 0 1204371504 84059440 3337824
06:59:54 51764 8192000000 10113658432 10614906880 1119800400 12.025 98 21 42 1 1193576816 69690064 4086352
07:01:47 90457 8192000000 10051944816 10534756352 1085777392 11.702 96 9 18 0 1140059104 52704896 1576816
07:04:55 45129 8192000000 10079083056 10532507648 1130339104 12.125 100 29 58 1 1171596848 36059248 5198496
07:06:44 40468 8192000000 10106504736 10568273920 1133481600 12.154 100 10 20 0 1207346352 71768800 2095952

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 19-03-2024 07:10:33 to 19-03-2024 07:10:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-03-2024 07:10:48 to 19-03-2024 07:10:50.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          170238
MON$OLDEST_ACTIVE               173109
MON$OLDEST_SNAPSHOT             173109
MON$NEXT_TRANSACTION            173109
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1930272
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             688
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Tue Mar 19 07:10:51 2024 
 
Database header page information: 
    Flags            0 
    Generation        90573 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    170238 
    Oldest active        173109 
    Oldest snapshot        173109 
    Next transaction    173110 
    Sequence number        0 
    Next attachment ID    688 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.68, total records: 7719703 
    Average version length: 48.16, total versions: 42365, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89440 
    Data pages: 89440, average fill: 69% 
    Primary pages: 89439, secondary pages: 1, swept pages: 49553 
    Empty pages: 2, full pages: 58518 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 107 
    40 - 59% = 3831 
    60 - 79% = 85473 
    80 - 99% = 17 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23193, nodes: 7719703 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1672983, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 301 
        20 - 39% = 1935 
        40 - 59% = 3943 
        60 - 79% = 2437 
        80 - 99% = 14577 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13484, nodes: 7719703 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1497678, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1659 
        40 - 59% = 1930 
        60 - 79% = 1084 
        80 - 99% = 8811 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8325, nodes: 7719703 
    Average node length: 6.61, total dup: 5775451, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1490681, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 1009 
        40 - 59% = 1317 
        60 - 79% = 939 
        80 - 99% = 4932 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.95, total records: 2234181 
    Average version length: 58.86, total versions: 22612, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 29104 
    Data pages: 29104, average fill: 71% 
    Primary pages: 29102, secondary pages: 2, swept pages: 15902 
    Empty pages: 5, full pages: 14881 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 34 
    40 - 59% = 1098 
    60 - 79% = 27925 
    80 - 99% = 34 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4549, nodes: 2234181 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 677936, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 969 
        40 - 59% = 777 
        60 - 79% = 774 
        80 - 99% = 2029 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2459, nodes: 2234819 
    Average node length: 4.97, total dup: 2233920, max dup: 19193 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1257949, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 274 
        40 - 59% = 1426 
        60 - 79% = 510 
        80 - 99% = 247 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1809, nodes: 2234181 
    Average node length: 4.97, total dup: 2234131, max dup: 130162 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1072511, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 667 
        60 - 79% = 32 
        80 - 99% = 1107 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4333, nodes: 2234181 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 677936, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 618 
        40 - 59% = 560 
        60 - 79% = 874 
        80 - 99% = 2186 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.38, total records: 400 
    Average version length: 18.81, total versions: 378, max versions: 1 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 28% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 11, full pages: 6 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 6 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 25.06, total records: 77084 
    Average version length: 68.28, total versions: 56198, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.51 
    Pointer pages: 6, data page slots: 2688 
    Data pages: 1624, average fill: 61% 
    Primary pages: 1623, secondary pages: 1, swept pages: 61 
    Empty pages: 260, full pages: 942 
    Fill distribution: 
     0 - 19% = 352 
    20 - 39% = 112 
    40 - 59% = 117 
    60 - 79% = 309 
    80 - 99% = 734 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1867032, depth: 3, leaf buckets: 323, nodes: 77084 
    Average node length: 13.77, total dup: 4255, max dup: 1 
    Average key length: 10.83, compression ratio: 2.49 
    Average prefix length: 19.11, average data length: 7.89 
    Clustering factor: 56335, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 220 
        40 - 59% = 54 
        60 - 79% = 45 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 44, max versions: 6 
    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: 1 
    Data pages: 1, average fill: 40% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 17.85, total records: 1235 
    Average version length: 43.59, total versions: 923, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 33% 
    Primary pages: 39, secondary pages: 1, swept pages: 5 
    Empty pages: 13, full pages: 8 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91452, depth: 2, leaf buckets: 2, nodes: 1235 
    Average node length: 4.40, total dup: 1137, max dup: 147 
    Average key length: 2.84, compression ratio: 6.69 
    Average prefix length: 18.24, average data length: 0.76 
    Clustering factor: 686, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.62, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, 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: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.86, total records: 796098 
    Average version length: 37.98, total versions: 18755, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8616 
    Data pages: 8616, average fill: 63% 
    Primary pages: 8614, secondary pages: 2, swept pages: 3442 
    Empty pages: 30, full pages: 4030 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 85 
    40 - 59% = 1347 
    60 - 79% = 7112 
    80 - 99% = 29 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 865, nodes: 786861 
    Average node length: 4.88, total dup: 786812, max dup: 140743 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89367, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 145 
        40 - 59% = 455 
        60 - 79% = 165 
        80 - 99% = 97 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 904, nodes: 786861 
    Average node length: 5.89, total dup: 700347, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157472, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 42 
        40 - 59% = 446 
        60 - 79% = 130 
        80 - 99% = 286 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 922, nodes: 786861 
    Average node length: 5.89, total dup: 700347, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159233, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 89 
        40 - 59% = 421 
        60 - 79% = 124 
        80 - 99% = 287 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1139, nodes: 786861 
    Average node length: 5.98, total dup: 700347, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152020, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 246 
        40 - 59% = 631 
        60 - 79% = 185 
        80 - 99% = 75 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5454 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.13, total fragments: 23, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 57% 
    Primary pages: 83, secondary pages: 11, swept pages: 57 
    Empty pages: 12, full pages: 59 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5454 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.42, average data length: 1.55 
    Clustering factor: 5199, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5454 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 170, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 78435 
    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: 66% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 814 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 814 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 31527, depth: 2, leaf buckets: 101, nodes: 78435 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3183, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.51, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.30 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 139.75, total records: 170113 
    Average version length: 152.71, total versions: 13408, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.14 
    Pointer pages: 5, data page slots: 6312 
    Data pages: 4280, average fill: 83% 
    Primary pages: 4277, secondary pages: 3, swept pages: 73 
    Empty pages: 93, full pages: 4159 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 6 
    40 - 59% = 9 
    60 - 79% = 10 
    80 - 99% = 4159 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 138.61, total records: 167209 
    Average version length: 152.89, total versions: 14910, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.24 
    Pointer pages: 6, data page slots: 7272 
    Data pages: 4272, average fill: 82% 
    Primary pages: 4269, secondary pages: 3, swept pages: 91 
    Empty pages: 136, full pages: 4085 
    Fill distribution: 
     0 - 19% = 138 
    20 - 39% = 15 
    40 - 59% = 15 
    60 - 79% = 18 
    80 - 99% = 4086 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 135.67, total records: 174582 
    Average version length: 153.19, total versions: 18907, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.50 
    Pointer pages: 6, data page slots: 6856 
    Data pages: 4480, average fill: 82% 
    Primary pages: 4478, secondary pages: 2, swept pages: 137 
    Empty pages: 164, full pages: 4266 
    Fill distribution: 
     0 - 19% = 168 
    20 - 39% = 16 
    40 - 59% = 17 
    60 - 79% = 12 
    80 - 99% = 4267 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 131.59, total records: 191967 
    Average version length: 154.07, total versions: 26501, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.89 
    Pointer pages: 6, data page slots: 5664 
    Data pages: 4816, average fill: 84% 
    Primary pages: 4814, secondary pages: 2, swept pages: 62 
    Empty pages: 78, full pages: 4716 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 8 
    40 - 59% = 8 
    60 - 79% = 3 
    80 - 99% = 4716 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 140.22, total records: 157729 
    Average version length: 152.87, total versions: 12050, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.10 
    Pointer pages: 6, data page slots: 5904 
    Data pages: 4000, average fill: 82% 
    Primary pages: 3998, secondary pages: 2, swept pages: 77 
    Empty pages: 109, full pages: 3861 
    Fill distribution: 
     0 - 19% = 111 
    20 - 39% = 13 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3862 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 141.38, total records: 165625 
    Average version length: 152.27, total versions: 11293, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 7, data page slots: 5752 
    Data pages: 4168, average fill: 83% 
    Primary pages: 4166, secondary pages: 2, swept pages: 74 
    Empty pages: 83, full pages: 4051 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 10 
    40 - 59% = 7 
    60 - 79% = 15 
    80 - 99% = 4050 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 131.25, total records: 170456 
    Average version length: 154.08, total versions: 23491, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.92 
    Pointer pages: 6, data page slots: 6168 
    Data pages: 4224, average fill: 85% 
    Primary pages: 4222, secondary pages: 2, swept pages: 17 
    Empty pages: 29, full pages: 4174 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 2 
    40 - 59% = 6 
    60 - 79% = 10 
    80 - 99% = 4175 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 138.05, total records: 158752 
    Average version length: 153.09, total versions: 14437, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.29 
    Pointer pages: 7, data page slots: 5144 
    Data pages: 3984, average fill: 83% 
    Primary pages: 3983, secondary pages: 1, swept pages: 77 
    Empty pages: 77, full pages: 3888 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 3888 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 141.79, total records: 161133 
    Average version length: 152.03, total versions: 10563, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.96 
    Pointer pages: 6, data page slots: 5352 
    Data pages: 4080, average fill: 82% 
    Primary pages: 4077, secondary pages: 3, swept pages: 80 
    Empty pages: 105, full pages: 3937 
    Fill distribution: 
     0 - 19% = 106 
    20 - 39% = 13 
    40 - 59% = 10 
    60 - 79% = 12 
    80 - 99% = 3939 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 136.21, total records: 177291 
    Average version length: 153.32, total versions: 18696, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.45 
    Pointer pages: 6, data page slots: 6136 
    Data pages: 4424, average fill: 84% 
    Primary pages: 4421, secondary pages: 3, swept pages: 22 
    Empty pages: 52, full pages: 4345 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 15 
    80 - 99% = 4345 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.45, total records: 2073429 
    Average version length: 52.97, total versions: 14064, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25936 
    Data pages: 25936, average fill: 69% 
    Primary pages: 25921, secondary pages: 15, swept pages: 13783 
    Empty pages: 202, full pages: 20080 
    Fill distribution: 
     0 - 19% = 423 
    20 - 39% = 445 
    40 - 59% = 1419 
    60 - 79% = 23567 
    80 - 99% = 82 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2573, nodes: 2073429 
    Average node length: 5.45, total dup: 1933747, max dup: 1193 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180217, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 324 
        40 - 59% = 1657 
        60 - 79% = 304 
        80 - 99% = 284 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2758, nodes: 2073429 
    Average node length: 5.70, total dup: 1860071, max dup: 69 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371261, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2488 
        60 - 79% = 230 
        80 - 99% = 32 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2133, nodes: 2073429 
    Average node length: 4.96, total dup: 2073329, max dup: 27063 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178410, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 233 
        40 - 59% = 1121 
        60 - 79% = 366 
        80 - 99% = 412 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 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: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 46.52, total records: 133687 
    Average version length: 69.17, total versions: 50418, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.71 
    Pointer pages: 3, data page slots: 4088 
    Data pages: 3024, average fill: 53% 
    Primary pages: 3024, secondary pages: 0, swept pages: 293 
    Empty pages: 337, full pages: 1007 
    Fill distribution: 
     0 - 19% = 473 
    20 - 39% = 381 
    40 - 59% = 726 
    60 - 79% = 915 
    80 - 99% = 529 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104751, depth: 3, leaf buckets: 245, nodes: 133687 
    Average node length: 6.50, total dup: 116307, max dup: 29 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 23628, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 102 
        40 - 59% = 115 
        60 - 79% = 27 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.50, total records: 6892814 
    Average version length: 68.76, total versions: 282877, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 66, data page slots: 106552 
    Data pages: 106552, average fill: 69% 
    Primary pages: 106551, secondary pages: 1, swept pages: 43678 
    Empty pages: 2, full pages: 43210 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 564 
    40 - 59% = 10041 
    60 - 79% = 95095 
    80 - 99% = 812 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10593, nodes: 6892814 
    Average node length: 6.52, total dup: 5957581, max dup: 29 
    Average key length: 3.53, compression ratio: 11.90 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1607678, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1644 
        40 - 59% = 6048 
        60 - 79% = 2472 
        80 - 99% = 417 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8561, nodes: 6892814 
    Average node length: 5.40, total dup: 6613797, max dup: 145 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1417918, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1268 
        40 - 59% = 5112 
        60 - 79% = 1222 
        80 - 99% = 946 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8593, nodes: 6892814 
    Average node length: 5.40, total dup: 6613797, max dup: 145 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1420390, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1262 
        40 - 59% = 5152 
        60 - 79% = 1229 
        80 - 99% = 943 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.10, total records: 11916018 
    Average version length: 68.74, total versions: 168417, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 107, data page slots: 174272 
    Data pages: 174272, average fill: 73% 
    Primary pages: 174270, secondary pages: 2, swept pages: 93699 
    Empty pages: 3, full pages: 132140 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 454 
    40 - 59% = 5924 
    60 - 79% = 167093 
    80 - 99% = 785 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18339, nodes: 11915042 
    Average node length: 6.62, total dup: 10383555, max dup: 71 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2444202, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 2297 
        40 - 59% = 11007 
        60 - 79% = 4320 
        80 - 99% = 696 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 54.39, total records: 1203153 
    Average version length: 69.03, total versions: 215713, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.32 
    Pointer pages: 27, data page slots: 42912 
    Data pages: 28784, average fill: 45% 
    Primary pages: 28722, secondary pages: 62, swept pages: 14216 
    Empty pages: 5694, full pages: 11912 
    Fill distribution: 
     0 - 19% = 8649 
    20 - 39% = 3748 
    40 - 59% = 3178 
    60 - 79% = 10683 
    80 - 99% = 2526 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1779, nodes: 1123281 
    Average node length: 5.55, total dup: 1077233, max dup: 49 
    Average key length: 2.59, compression ratio: 16.22 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 78033, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 742 
        40 - 59% = 799 
        60 - 79% = 216 
        80 - 99% = 12 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 47.92, total records: 975899 
    Average version length: 69.00, total versions: 140302, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.63 
    Pointer pages: 20, data page slots: 32352 
    Data pages: 27104, average fill: 36% 
    Primary pages: 27104, secondary pages: 0, swept pages: 8149 
    Empty pages: 4066, full pages: 3694 
    Fill distribution: 
     0 - 19% = 7318 
    20 - 39% = 6413 
    40 - 59% = 8800 
    60 - 79% = 4522 
    80 - 99% = 51 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1253, nodes: 773206 
    Average node length: 5.95, total dup: 712612, max dup: 64 
    Average key length: 3.01, compression ratio: 13.95 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 111843, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 464 
        40 - 59% = 604 
        60 - 79% = 174 
        80 - 99% = 10 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.66, total records: 9026218 
    Average version length: 68.91, total versions: 183754, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 90, data page slots: 146680 
    Data pages: 146664, average fill: 66% 
    Primary pages: 146649, secondary pages: 15, swept pages: 82841 
    Empty pages: 281, full pages: 55494 
    Fill distribution: 
     0 - 19% = 1125 
    20 - 39% = 6108 
    40 - 59% = 26149 
    60 - 79% = 112602 
    80 - 99% = 680 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13514, nodes: 9024099 
    Average node length: 6.70, total dup: 7483961, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2046304, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1314 
        40 - 59% = 7374 
        60 - 79% = 4314 
        80 - 99% = 511 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21123052 
    Average version length: 82.99, total versions: 4065, 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: 319472 
    Data pages: 319472, average fill: 81% 
    Primary pages: 319469, secondary pages: 3, swept pages: 13256 
    Empty pages: 52, full pages: 318501 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 62 
    40 - 59% = 131 
    60 - 79% = 48846 
    80 - 99% = 270340 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19304, nodes: 21123052 
    Average node length: 5.72, total dup: 20642592, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279944, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2 
        40 - 59% = 8004 
        60 - 79% = 569 
        80 - 99% = 10721 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17150, nodes: 21123052 
    Average node length: 6.31, total dup: 18562858, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917561, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 778 
        60 - 79% = 272 
        80 - 99% = 16096 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21091, nodes: 21123052 
    Average node length: 6.35, total dup: 18481928, max dup: 28 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573589, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8316 
        60 - 79% = 562 
        80 - 99% = 12206 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16134, nodes: 21123052 
    Average node length: 5.56, total dup: 21122952, max dup: 229471 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946419, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 3014 
        60 - 79% = 343 
        80 - 99% = 12765 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.09, total records: 9465956 
    Average version length: 82.59, total versions: 171611, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 106, data page slots: 172768 
    Data pages: 172760, average fill: 68% 
    Primary pages: 172732, secondary pages: 28, swept pages: 104961 
    Empty pages: 609, full pages: 84275 
    Fill distribution: 
     0 - 19% = 2115 
    20 - 39% = 8903 
    40 - 59% = 27950 
    60 - 79% = 117230 
    80 - 99% = 16562 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11365, nodes: 9465956 
    Average node length: 5.37, total dup: 9158522, max dup: 175 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2159743, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 91 
        40 - 59% = 8788 
        60 - 79% = 2433 
        80 - 99% = 50 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13348, nodes: 9465956 
    Average node length: 6.24, total dup: 7847293, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1515754, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 3964 
        40 - 59% = 4306 
        60 - 79% = 2710 
        80 - 99% = 2247 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12691, nodes: 9465956 
    Average node length: 5.99, total dup: 8205461, max dup: 33 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2341330, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 112 
        40 - 59% = 9827 
        60 - 79% = 2693 
        80 - 99% = 59 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10111, nodes: 9465956 
    Average node length: 5.14, total dup: 9465856, max dup: 151344 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1543583, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1449 
        40 - 59% = 4905 
        60 - 79% = 1791 
        80 - 99% = 1915 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.28, total records: 11104535 
    Average version length: 82.46, total versions: 155542, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 120, data page slots: 194480 
    Data pages: 193152, average fill: 70% 
    Primary pages: 192984, secondary pages: 168, swept pages: 82172 
    Empty pages: 3017, full pages: 135319 
    Fill distribution: 
     0 - 19% = 5298 
    20 - 39% = 8630 
    40 - 59% = 21114 
    60 - 79% = 98530 
    80 - 99% = 59580 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13133, nodes: 11104535 
    Average node length: 5.32, total dup: 10994842, max dup: 632 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2321371, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 150 
        40 - 59% = 9575 
        60 - 79% = 3298 
        80 - 99% = 110 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10315, nodes: 11104535 
    Average node length: 5.51, total dup: 10618707, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 708517, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 162 
        20 - 39% = 857 
        40 - 59% = 2492 
        60 - 79% = 1873 
        80 - 99% = 4931 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15014, nodes: 11104535 
    Average node length: 6.05, total dup: 9681912, max dup: 70 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2337676, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 183 
        40 - 59% = 11157 
        60 - 79% = 3537 
        80 - 99% = 136 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10694, nodes: 11104535 
    Average node length: 5.24, total dup: 11104435, max dup: 194524 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 697870, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 87 
        20 - 39% = 917 
        40 - 59% = 4715 
        60 - 79% = 1499 
        80 - 99% = 3476 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.87, total records: 9520632 
    Average version length: 82.88, total versions: 112111, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 109, data page slots: 177168 
    Data pages: 177128, average fill: 66% 
    Primary pages: 177099, secondary pages: 29, swept pages: 118462 
    Empty pages: 674, full pages: 78182 
    Fill distribution: 
     0 - 19% = 2318 
    20 - 39% = 10425 
    40 - 59% = 32271 
    60 - 79% = 117598 
    80 - 99% = 14516 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11713, nodes: 9520632 
    Average node length: 5.18, total dup: 9491915, max dup: 2107 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1944558, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1614 
        40 - 59% = 7846 
        60 - 79% = 1709 
        80 - 99% = 513 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13426, nodes: 9520632 
    Average node length: 6.25, total dup: 7891886, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1470076, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 3996 
        40 - 59% = 4189 
        60 - 79% = 2723 
        80 - 99% = 2352 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12338, nodes: 9520632 
    Average node length: 5.44, total dup: 9089047, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 2075209, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1619 
        40 - 59% = 8605 
        60 - 79% = 1566 
        80 - 99% = 520 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10317, nodes: 9520632 
    Average node length: 5.15, total dup: 9520532, max dup: 153020 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1555952, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1559 
        40 - 59% = 5121 
        60 - 79% = 1732 
        80 - 99% = 1859 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.94, total records: 570378 
    Average version length: 68.81, total versions: 2202, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8096 
    Data pages: 8096, average fill: 74% 
    Primary pages: 8096, secondary pages: 0, swept pages: 4638 
    Empty pages: 0, full pages: 6126 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 13 
    40 - 59% = 253 
    60 - 79% = 7806 
    80 - 99% = 23 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41566, depth: 3, leaf buckets: 737, nodes: 570378 
    Average node length: 5.95, total dup: 485579, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99924, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 529 
        60 - 79% = 86 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34206, depth: 3, leaf buckets: 759, nodes: 570378 
    Average node length: 6.15, total dup: 467675, max dup: 27 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99974, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 41 
        40 - 59% = 532 
        60 - 79% = 85 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 555, nodes: 570378 
    Average node length: 4.86, total dup: 570278, max dup: 9644 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89071, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 52 
        40 - 59% = 299 
        60 - 79% = 61 
        80 - 99% = 143 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar 19 07:11:15 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7719703 42365 1 0.0000 0.0000
DOC_LIST 2234181 22612 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 378 1 0.0000 0.0000
INVNT_TURNOVER_LOG 77084 56198 1 0.0000 0.0000
MONEY_SALDO 49 44 6 0.0000 0.0000
MONEY_TURNOVER_LOG 1235 923 1 0.0000 0.0000
PDISTR 796098 18755 2 0.0000 0.0000
PERF_SPLIT_0 170113 13408 1 0.0000 0.0000
PERF_SPLIT_1 167209 14910 1 0.0000 0.0000
PERF_SPLIT_2 174582 18907 1 0.0000 0.0000
PERF_SPLIT_3 191967 26501 1 0.0000 0.0000
PERF_SPLIT_4 157729 12050 1 0.0000 0.0000
PERF_SPLIT_5 165625 11293 1 0.0000 0.0000
PERF_SPLIT_6 170456 23491 1 0.0000 0.0000
PERF_SPLIT_7 158752 14437 1 0.0000 0.0000
PERF_SPLIT_8 161133 10563 1 0.0000 0.0000
PERF_SPLIT_9 177291 18696 1 0.0000 0.0000
PSTORNED 2073429 14064 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 133687 50418 1 0.0000 0.0000
XQD_1000_3300 6892814 282877 1 0.0000 0.0000
XQD_1200_2000 11916018 168417 1 0.0000 0.0000
XQD_2000_3300 1203153 215713 1 0.0000 0.0000
XQD_2100_3300 975899 140302 1 0.0000 0.0000
XQD_3300_3400 9026218 183754 1 0.0000 0.0000
XQS_1000_1200 21123052 4065 1 0.0000 0.0000
XQS_1000_3300 9465956 171611 1 0.0000 0.0000
XQS_1200_2000 11104535 155542 1 0.0000 0.0000
XQS_2100_3300 9520632 112111 1 0.0000 0.0000
XQS_3300_3400 570378 2202 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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