Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.03.2024 10:08
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 15741480 kB
MemAvailable 30250004 kB
Buffers 0 kB
Cached 15993616 kB
SwapCached 2248 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-02 10:07:50
DTS_END                         2024-03-02 10:07:50.7330
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/44136
TRN_ID                          180884
ATT_ID                          550
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9020.37 18136 902037
customer order: creation 189.23 438 18923
customer order: refuse 16.21 364 1621
order to supplier: creation 50.59 1346 5059
order to supplier: removal 3.45 79862 345
invoice (draft): creation 49.84 3440 4984
invoice (draft): removal 45.23 677 4523
invoice accept: apply 45.83 22073 4583
invoice accept: cancel 40.47 893 4047
customer reserve: creation 4362.22 214 436222
customer reserve: removal 3910.52 57 391052
realization accept: apply 91.50 181 9150
realization accept: cancel 77.42 120 7742
payment from customer: creation 63.48 122 6348
payment from customer: removal 6.15 83 615
payment to supplier: creation 52.28 133 5228
payment to supplier: removal 3.72 73 372
service: total inventory turnovers 4.25 3545 425
service: total monetary turnovers 6.83 573 683
service: aggregate perf. data 1.11 9231 111
service: refresh index statistics 0.04 239293 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6691
TEST_TIME 2 5050
TEST_TIME 3 4668
TEST_TIME 4 4813
TEST_TIME 5 4828
TEST_TIME 6 6043
TEST_TIME 7 6012
TEST_TIME 8 6435
TEST_TIME 9 6539
TEST_TIME 10 6579
TEST_TIME 11 6783
TEST_TIME 12 6764
TEST_TIME 13 7072
TEST_TIME 14 7174
TEST_TIME 15 7471
TEST_TIME 16 7532
TEST_TIME 17 7902
TEST_TIME 18 7913
TEST_TIME 19 7864
TEST_TIME 20 7928
TEST_TIME 21 8246
TEST_TIME 22 8325
TEST_TIME 23 8821
TEST_TIME 24 9233
TEST_TIME 25 9319
TEST_TIME 26 9513
TEST_TIME 27 9497
TEST_TIME 28 9193
TEST_TIME 29 8986
TEST_TIME 30 8885
TEST_TIME 31 8958
TEST_TIME 32 8864
TEST_TIME 33 8875
TEST_TIME 34 8815
TEST_TIME 35 8747
TEST_TIME 36 8597
TEST_TIME 37 8581
TEST_TIME 38 8576
TEST_TIME 39 8611
TEST_TIME 40 8666
TEST_TIME 41 8711
TEST_TIME 42 8739
TEST_TIME 43 8782
TEST_TIME 44 8755
TEST_TIME 45 8925
TEST_TIME 46 9086
TEST_TIME 47 9076
TEST_TIME 48 9090
TEST_TIME 49 9211
TEST_TIME 50 9134
TEST_TIME 51 9183
TEST_TIME 52 9063
TEST_TIME 53 9027
TEST_TIME 54 8899
TEST_TIME 55 8905
TEST_TIME 56 8922
TEST_TIME 57 8827
TEST_TIME 58 8847
TEST_TIME 59 8801
TEST_TIME 60 8891
TEST_TIME 61 8853
TEST_TIME 62 8822
TEST_TIME 63 8920
TEST_TIME 64 8944
TEST_TIME 65 8935
TEST_TIME 66 8934
TEST_TIME 67 8983
TEST_TIME 68 9011
TEST_TIME 69 9047
TEST_TIME 70 9033
TEST_TIME 71 9156
TEST_TIME 72 9133
TEST_TIME 73 9043
TEST_TIME 74 8988
TEST_TIME 75 9039
TEST_TIME 76 9022
TEST_TIME 77 9014
TEST_TIME 78 8983
TEST_TIME 79 9079
TEST_TIME 80 9042
TEST_TIME 81 9149
TEST_TIME 82 9096
TEST_TIME 83 9112
TEST_TIME 84 9181
TEST_TIME 85 9182
TEST_TIME 86 9198
TEST_TIME 87 9212
TEST_TIME 88 9225
TEST_TIME 89 9150
TEST_TIME 90 9134
TEST_TIME 91 9071
TEST_TIME 92 9070
TEST_TIME 93 9024
TEST_TIME 94 8994
TEST_TIME 95 8941
TEST_TIME 96 8993
TEST_TIME 97 9026
TEST_TIME 98 8998
TEST_TIME 99 9024
TEST_TIME 100 9041

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-03-2024 10:09:09 to 02-03-2024 10:09:12.

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 1299264 1299264 0 0.00 0 14484 8 0 0
doc_list_biud 1299262 1299262 0 0.00 0 49185 22 0 0
sp_add_invoice_to_stock 4698 4583 115 2.44 30 227093 22074 0 115
sp_cancel_adding_invoice 4047 4047 0 0.00 5 75209 894 0 0
sp_cancel_client_order 1621 1621 0 0.00 4 15354 365 0 0
sp_cancel_customer_reserve 391052 391052 0 0.00 0 25725 58 0 0
sp_cancel_pay_from_customer 615 615 0 0.00 2 4652 84 0 0
sp_cancel_pay_to_supplier 372 372 0 0.00 2 2692 74 0 0
sp_cancel_supplier_invoice 4532 4523 9 0.19 1 15079 678 0 9
sp_cancel_supplier_order 345 345 0 0.00 4 945282 79862 0 0
sp_cancel_write_off 7742 7742 0 0.00 1 20713 121 0 0
sp_client_order 18923 18923 0 0.00 3 50344 438 0 0
sp_customer_reserve 436222 436222 0 0.00 0 102183 214 0 0
sp_fill_shopping_cart 28960 28960 0 0.00 1 13912 39 0 0
sp_fill_shopping_cart_clo_res 436209 436209 0 0.00 0 20639 18 0 0
sp_get_clo_for_invoice 4558 4558 0 0.00 0 42708 410 0 0
sp_kill_cost_storno 12776 12776 0 0.00 0 12037 57 0 0
sp_kill_qstorno_ret_qs2qd 794714 794714 0 0.00 0 25720 31 0 0
sp_kill_qty_storno 423037 423037 0 0.00 0 49185 67 0 0
sp_lock_selected_doc 18918 18918 0 0.00 0 7162 5 0 0
sp_make_cost_storno 25284 25284 0 0.00 0 14465 56 0 0
sp_multiply_rows_for_pdistr 25283 25283 0 0.00 0 10694 32 0 0
sp_multiply_rows_for_qdistr 18923 18923 0 0.00 0 50334 238 0 0
sp_pay_from_customer 6348 6348 0 0.00 4 11322 122 0 0
sp_pay_to_supplier 5228 5228 0 0.00 4 13042 133 0 0
sp_payment_common 11575 11575 0 0.00 1 7651 22 0 0
sp_qd_handle_on_cancel_clo 1621 1621 0 0.00 0 15346 334 0 0
sp_qd_handle_on_invoice_upd_sts 8604 8604 0 0.00 0 49185 297 0 0
sp_qd_handle_on_reserve_upd_sts 9150 9150 0 0.00 0 20690 64 0 0
sp_reserve_write_off 9150 9150 0 0.00 6 20733 182 0 0
sp_supplier_invoice 4984 4984 0 0.00 6 113100 3441 0 0
sp_supplier_order 5059 5059 0 0.00 4 90852 1347 0 0
srv_aggregate_perf_data 111 111 0 0.00 1866 50797 9232 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1101 241430 41160 0 0
srv_find_qd_qs_mism 854874 854874 0 0.00 0 12878 8 0 0
srv_make_invnt_saldo 425 425 0 0.00 28 117445 3545 0 0
srv_make_money_saldo 683 683 0 0.00 1 27224 573 0 0
srv_recalc_idx_stat 4 4 0 0.00 103710 427693 239293 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4584 4584 0 0.00 0 25089 165 0 0
t$perf-norm:sp_cancel_adding_invoice 349 349 0 0.00 1 2554 83 0 0
t$perf-norm:sp_cancel_client_order 1621 1621 0 0.00 0 4711 15 0 0
t$perf-norm:sp_cancel_customer_reserve 619 619 0 0.00 0 572 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 615 615 0 0.00 0 465 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 372 372 0 0.00 0 712 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 349 349 0 0.00 0 536 11 0 0
t$perf-norm:sp_cancel_supplier_order 345 345 0 0.00 0 18554 1313 0 0
t$perf-norm:sp_cancel_write_off 942 942 0 0.00 0 1316 6 0 0
t$perf-norm:sp_client_order 18923 18923 0 0.00 0 5631 15 0 0
t$perf-norm:sp_customer_reserve 938 938 0 0.00 0 1367 6 0 0
t$perf-norm:sp_pay_from_customer 6348 6348 0 0.00 0 14913 9 0 0
t$perf-norm:sp_pay_to_supplier 5228 5228 0 0.00 0 4954 9 0 0
t$perf-norm:sp_reserve_write_off 9150 9150 0 0.00 0 8817 9 0 0
t$perf-norm:sp_supplier_invoice 4984 4984 0 0.00 0 5383 18 0 0
t$perf-norm:sp_supplier_order 5059 5059 0 0.00 0 4775 13 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 68 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 26 1 0 0
t$perf-norm:srv_make_invnt_saldo 425 425 0 0.00 0 2135 14 0 0
t$perf-norm:srv_make_money_saldo 683 683 0 0.00 0 1628 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 9344 9114 230 2.46 0 6186 19 0 230
v_all_customers 34572 34572 0 0.00 0 108 1 0 0
v_all_suppliers 27964 27964 0 0.00 0 21 1 0 0
v_all_wares 37846 37846 0 0.00 0 45 1 0 0
v_cancel_adding_invoice 698 698 0 0.00 0 1257 9 0 0
v_cancel_client_order 3242 3242 0 0.00 0 5112 6 0 0
v_cancel_customer_prepayment 1230 1230 0 0.00 0 852 3 0 0
v_cancel_customer_reserve 1238 1238 0 0.00 0 1049 5 0 0
v_cancel_payment_to_supplier 744 744 0 0.00 0 1202 5 0 0
v_cancel_supplier_invoice 716 698 18 2.51 0 5167 20 0 18
v_cancel_supplier_order 690 690 0 0.00 0 2438 8 0 0
v_cancel_write_off 1884 1884 0 0.00 0 956 14 0 0
v_max_id_clo_ord 5057 5057 0 0.00 0 639 1 0 0
v_max_id_clo_res 938 938 0 0.00 0 1476 9 0 0
v_max_id_ord_sup 4979 4979 0 0.00 0 7442 6 0 0
v_max_non_paid_invoice 1281 1281 0 0.00 0 144 2 0 0
v_max_non_paid_realizn 3260 3260 0 0.00 0 3188 4 0 0
v_min_id_clo_ord 5057 5057 0 0.00 0 2595 7 0 0
v_min_id_clo_res 938 938 0 0.00 0 3988 16 0 0
v_min_id_ord_sup 4979 4979 0 0.00 0 5489 6 0 0
v_min_non_paid_invoice 5227 5227 0 0.00 0 5734 12 0 0
v_min_non_paid_realizn 6348 6348 0 0.00 0 6428 17 0 0
v_our_firm 9450 9450 0 0.00 0 17 1 0 0
v_reserve_write_off 18298 18298 0 0.00 0 5175 5 0 0
x_lock_depdocs_on_canc_invoice 8221 8221 0 0.00 0 15774 126 0 0
x_lock_depdocs_on_canc_sup_ord 345 345 0 0.00 0 2302 260 0 0
x_make_qstorno_1000_1200 5059 5059 0 0.00 1 90835 1274 0 0
x_make_qstorno_1200_2000 4984 4984 0 0.00 3 111634 3285 0 0
x_make_qstorno_2100_3300 436222 436222 0 0.00 0 102179 193 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-03-2024 10:09:13 to 02-03-2024 10:09:17.

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
08:07:54 1 8192000000 8796669328 8807108608 3187328 0.038 1 1 2 0 3284944 61840 35776
08:08:55 32263 8192000000 9718303456 10014539776 794919536 8.845 100 93 186 0 825404176 7688240 22796400
08:10:40 19249 8192000000 9756246016 10061692928 828178464 9.181 100 90 180 0 861687376 11750624 21758288
08:12:06 23309 8192000000 9791692656 10105200640 852208528 9.422 100 94 188 0 898351184 23476368 22666288
08:13:32 8754 8192000000 9835865728 10167267328 900967408 9.908 100 71 142 0 950174320 33194352 16012560
08:14:50 7045 8192000000 9905251824 10250866688 955974560 10.450 100 78 156 0 1016721680 44190400 16556720
08:16:00 4704 8192000000 9935596784 10290397184 986573568 10.748 100 80 160 0 1048218176 45110272 16534336
08:17:08 3136 8192000000 9976898672 10338795520 1013706592 11.011 100 79 152 1 1085772848 57072864 14993392
08:18:13 1401 8192000000 10016484768 10383720448 1029751328 11.166 100 85 168 0 1128211808 81962816 16497664
08:19:17 1779 8192000000 10037970080 10411061248 1054243360 11.401 100 79 159 0 1147018032 77143104 15631568
08:20:21 32150 8192000000 9978506272 10373287936 1063831328 11.493 100 42 82 0 1117200864 45004512 8365024
08:21:56 3830 8192000000 10001434976 10391924736 1072961184 11.580 100 42 84 1 1113361568 32140832 8259552
08:23:01 7762 8192000000 9995677808 10394017792 1082461232 11.671 100 31 63 0 1110173872 21456768 6255872
08:24:10 62041 8192000000 9994014352 10398724096 1085957536 11.704 100 38 75 2 1105673232 11859840 7855856
08:26:13 5253 8192000000 10010816096 10406371328 1097117472 11.810 100 53 104 0 1120002656 12015136 10870048
08:27:22 12760 8192000000 9994465904 10403758080 1062313552 11.479 97 23 45 0 1092171728 25287472 4570704
08:28:38 31015 8192000000 10045486496 10448482304 1108581616 11.919 100 49 96 1 1153310160 34715360 10013184
08:30:33 11051 8192000000 10038826912 10442268672 1108697248 11.920 100 43 86 1 1150517120 33678912 8140960
08:31:48 3642 8192000000 10068576128 10467713024 1106373104 11.898 100 50 101 0 1181493968 64933408 10187456
08:32:55 5715 8192000000 10102204624 10504642560 1105776496 11.892 100 52 104 1 1209583168 93171152 10635520
08:34:09 14206 8192000000 10065415392 10468495360 1076322544 11.612 98 48 94 0 1164076400 77551024 10202832
08:35:26 8656 8192000000 10081543568 10479071232 1073103936 11.582 98 46 90 0 1183458000 101186352 9167712
08:36:37 4666 8192000000 10073504240 10454618112 1048480896 11.346 97 57 114 3 1160213328 99443968 12288464
08:37:44 6630 8192000000 10079054576 10467934208 1077216576 11.621 100 54 106 1 1195065520 106669472 11179472
08:38:59 6109 8192000000 10138890352 10529824768 1094802352 11.788 100 65 130 0 1240616736 131975664 13838720
08:40:10 4941 8192000000 10134197328 10535534592 1095222208 11.792 100 58 115 1 1246714176 138837472 12654496
08:41:20 3910 8192000000 10155827808 10547658752 1096738640 11.807 100 65 130 0 1258151408 147756272 13656496
08:42:28 1100 8192000000 10172400624 10565042176 1110017952 11.933 100 74 144 1 1278219824 152204448 15997424
08:43:33 5850 8192000000 10202365056 10600562688 1110106416 11.933 100 62 125 0 1307435872 183205648 14123808
08:44:44 1351 8192000000 10234654592 10629771264 1120598272 12.033 100 81 162 0 1336268992 197470224 18200496
08:45:53 13454 8192000000 10223866816 10641702912 1125658880 12.080 100 60 117 1 1320640096 181953136 13028080
08:47:21 1344 8192000000 10293871264 10691919872 1140574640 12.221 100 89 178 0 1391285744 230624912 20086192
08:48:28 15851 8192000000 10261751664 10709688320 1137768336 12.195 100 28 56 0 1351684176 207083360 6832480
08:50:23 14439 8192000000 10220687216 10663661568 1133022384 12.150 100 28 56 0 1349352960 210354464 5976112
08:51:39 35415 8192000000 10139835728 10618798080 1130010080 12.121 100 17 32 0 1270685776 136543840 4131856
08:53:17 24932 8192000000 10083332368 10504163328 1140317552 12.219 100 31 62 0 1207655232 61126656 6211024
08:54:47 106231 8192000000 10062644960 10504863744 1135996752 12.178 100 38 76 2 1175779168 30785072 8997344
08:57:39 33296 8192000000 10116936448 10543435776 1138086160 12.198 100 48 94 0 1207938608 59661488 10190960
08:59:16 28796 8192000000 10091216224 10544406528 1146657248 12.278 100 28 56 0 1212152016 58843872 6650896
09:00:49 43387 8192000000 10090924640 10569175040 1150554448 12.315 100 13 26 0 1223162960 69770624 2837888
09:02:37 61332 8192000000 10108291856 10557493248 1141496208 12.230 99 26 52 0 1190758512 43074272 6188032
09:04:57 43628 8192000000 10100387168 10560724992 1149166192 12.302 100 32 65 0 1221543456 65263456 7113808
09:06:41 42343 8192000000 10093172544 10541322240 1147341696 12.285 100 11 23 0 1195205952 45566368 2297888
09:08:25 35742 8192000000 10111562576 10585767936 1141830080 12.233 99 31 62 0 1211380288 63233568 6316640
09:10:06 19459 8192000000 10100063744 10547245056 1160309696 12.406 100 30 60 0 1201590480 35324512 5956272
09:11:28 80556 8192000000 10195122864 10688077824 1161045072 12.413 99 19 38 0 1262901008 97828640 4027296
09:13:50 56261 8192000000 10086189360 10516209664 1091945872 11.761 95 13 26 1 1120863216 26434576 2482768
09:15:47 124550 8192000000 10064317168 10509598720 1040681456 11.271 92 17 35 0 1075017152 31364080 2971616
09:18:52 63258 8192000000 10041783024 10467110912 1050150800 11.362 95 42 83 1 1096910208 38315712 8443696
09:21:10 77962 8192000000 10053640960 10481528832 1058809616 11.445 96 33 66 0 1113170352 47377680 6983056
09:23:32 241430 8192000000 10020352944 10506817536 1021209776 11.084 92 13 25 0 1072462528 48876368 2376384
09:28:36 26203 8192000000 10031226352 10451259392 1039660384 11.261 95 22 44 1 1077318480 33432752 4225344
09:30:11 74225 8192000000 10018565600 10496253952 1076643136 11.615 98 15 30 0 1148691088 68826864 3221088
09:32:26 37621 8192000000 10018570144 10437509120 1088350816 11.727 100 29 58 1 1118402016 24342048 5709152
09:34:06 17842 8192000000 10069006416 10487263232 1096619360 11.806 100 44 88 0 1165190768 59947488 8623920
09:35:29 40210 8192000000 10066046784 10507628544 1102268528 11.859 100 29 57 0 1170203296 61704192 6230576
09:37:15 55558 8192000000 10064662048 10527727616 1119623008 12.023 100 21 42 0 1183386704 59368368 4395328
09:39:13 104650 8192000000 10079724992 10507681792 1122534688 12.051 99 29 57 1 1179937744 51936480 5466576
09:42:08 45166 8192000000 10078405904 10563624960 1136591440 12.183 100 14 28 0 1181385968 42083040 2711488
09:43:56 27417 8192000000 10064063280 10510024704 1128197904 12.104 99 7 12 1 1154685104 25626432 860768
09:45:25 30355 8192000000 10100370288 10529779712 1133641488 12.156 99 28 56 0 1181363472 41409920 6312064
09:47:04 119151 8192000000 10098344256 10602754048 1130390000 12.125 98 15 30 0 1197207008 63314192 3502816
09:50:05 33905 8192000000 10115678368 10554245120 1155775680 12.364 100 40 78 0 1224507104 60966976 7764448
09:51:45 41610 8192000000 10098023328 10533150720 1134809952 12.167 98 22 44 0 1184852080 45953840 4088288
09:54:06 25388 8192000000 10077089312 10502066176 1112313808 11.954 97 29 58 0 1163458960 45080144 6065008
09:55:33 22509 8192000000 10106530544 10542104576 1115434752 11.984 99 47 92 0 1184831504 60422224 8974528
09:57:21 91330 8192000000 10098738176 10537742336 1134410400 12.163 100 25 50 0 1166614896 27133536 5070960
09:59:53 45159 8192000000 10095574320 10568986624 1127712944 12.100 99 13 26 0 1210921664 80382352 2826368
10:01:40 48201 8192000000 10123110352 10612371456 1140796272 12.223 100 11 22 0 1233252624 89920432 2535920
10:03:28 77040 8192000000 10092471120 10557267968 1116145360 11.991 98 15 30 0 1186963376 67370816 3447200
10:05:46 29774 8192000000 10135744896 10570473472 1124937184 12.074 99 29 58 0 1210806880 79367312 6502384
10:07:23 39114 8192000000 8934929104 9111224320 91919856 1.109 9 4 8 0 127472448 34712064 840528

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 115 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

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          181191
MON$OLDEST_ACTIVE               181192
MON$OLDEST_SNAPSHOT             181192
MON$NEXT_TRANSACTION            181192
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                       1914592
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             710
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3062 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3062 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3062 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3062 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 Sat Mar  2 10:09:37 2024 
 
Database header page information: 
    Flags            0 
    Generation        94535 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    181191 
    Oldest active        181192 
    Oldest snapshot        181192 
    Next transaction    181193 
    Sequence number        0 
    Next attachment ID    710 
    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.44, total records: 7874565 
    Average version length: 48.16, total versions: 92006, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 56, data page slots: 90312 
    Data pages: 90312, average fill: 70% 
    Primary pages: 90311, secondary pages: 1, swept pages: 35220 
    Empty pages: 3, full pages: 72850 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 62 
    40 - 59% = 1758 
    60 - 79% = 88420 
    80 - 99% = 61 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23515, nodes: 7874565 
    Average node length: 18.95, total dup: 0, max dup: 0 
    Average key length: 15.96, compression ratio: 1.69 
    Average prefix length: 14.04, average data length: 12.96 
    Clustering factor: 1702383, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 383 
        20 - 39% = 1459 
        40 - 59% = 4505 
        60 - 79% = 2005 
        80 - 99% = 15163 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13611, nodes: 7874565 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1527390, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1441 
        40 - 59% = 2182 
        60 - 79% = 928 
        80 - 99% = 9060 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8443, nodes: 7874565 
    Average node length: 6.65, total dup: 5844617, max dup: 49 
    Average key length: 3.66, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1520357, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 855 
        40 - 59% = 1563 
        60 - 79% = 718 
        80 - 99% = 5178 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.48, total records: 2321173 
    Average version length: 58.87, total versions: 48461, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 19, data page slots: 29560 
    Data pages: 29560, average fill: 72% 
    Primary pages: 29558, secondary pages: 2, swept pages: 9624 
    Empty pages: 6, full pages: 20942 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 44 
    40 - 59% = 420 
    60 - 79% = 28974 
    80 - 99% = 112 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4624, nodes: 2321173 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 700173, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 847 
        40 - 59% = 947 
        60 - 79% = 557 
        80 - 99% = 2273 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2465, nodes: 2322788 
    Average node length: 4.97, total dup: 2321889, max dup: 19526 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1280056, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 202 
        40 - 59% = 1393 
        60 - 79% = 559 
        80 - 99% = 309 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1832, nodes: 2321173 
    Average node length: 4.97, total dup: 2321123, max dup: 130548 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1101108, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 658 
        60 - 79% = 44 
        80 - 99% = 1124 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4463, nodes: 2321173 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 700173, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 567 
        40 - 59% = 729 
        60 - 79% = 650 
        80 - 99% = 2405 
 
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.33, total records: 400 
    Average version length: 27.98, total versions: 2465, max versions: 7 
    Average fragment length: 2.00, total fragments: 7, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 58% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 4, full pages: 16 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 14 
 
    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: 13.34, total records: 118460 
    Average version length: 68.29, total versions: 109802, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.60 
    Pointer pages: 6, data page slots: 2784 
    Data pages: 2640, average fill: 61% 
    Primary pages: 2639, secondary pages: 1, swept pages: 0 
    Empty pages: 318, full pages: 1296 
    Fill distribution: 
     0 - 19% = 457 
    20 - 39% = 301 
    40 - 59% = 371 
    60 - 79% = 354 
    80 - 99% = 1157 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1711835, depth: 3, leaf buckets: 407, nodes: 118460 
    Average node length: 13.28, total dup: 8771, max dup: 1 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 85123, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 57 
        40 - 59% = 318 
        60 - 79% = 31 
        80 - 99% = 0 
 
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: 175, max versions: 5 
    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: 3 
    Data pages: 2, average fill: 39% 
    Primary pages: 1, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 10.75, total records: 1941 
    Average version length: 43.61, total versions: 1844, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.39 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 53% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 5, full pages: 15 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90307, depth: 2, leaf buckets: 2, nodes: 1941 
    Average node length: 4.26, total dup: 1843, max dup: 191 
    Average key length: 2.54, compression ratio: 7.49 
    Average prefix length: 18.51, average data length: 0.49 
    Clustering factor: 1076, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 1 
        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.58, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    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: 72 
    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: 35.74, total records: 764498 
    Average version length: 37.95, total versions: 38514, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 7856 
    Data pages: 7848, average fill: 67% 
    Primary pages: 7847, secondary pages: 1, swept pages: 939 
    Empty pages: 13, full pages: 7527 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 26 
    40 - 59% = 73 
    60 - 79% = 7648 
    80 - 99% = 76 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 790, nodes: 745804 
    Average node length: 4.87, total dup: 745755, max dup: 127625 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89033, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 122 
        40 - 59% = 386 
        60 - 79% = 173 
        80 - 99% = 107 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 787, nodes: 745804 
    Average node length: 5.88, total dup: 663492, max dup: 49 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 153990, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 262 
        60 - 79% = 150 
        80 - 99% = 340 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 825, nodes: 745804 
    Average node length: 5.88, total dup: 663492, max dup: 49 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155769, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 108 
        40 - 59% = 242 
        60 - 79% = 148 
        80 - 99% = 327 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1068, nodes: 745804 
    Average node length: 5.97, total dup: 663492, max dup: 49 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 149037, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 273 
        40 - 59% = 524 
        60 - 79% = 166 
        80 - 99% = 102 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 63.00, total records: 5507 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.95, total fragments: 21, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 58% 
    Primary pages: 82, secondary pages: 12, swept pages: 53 
    Empty pages: 12, full pages: 56 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5507 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.11 
    Average prefix length: 34.59, average data length: 1.54 
    Clustering factor: 5254, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5507 
    Average node length: 11.14, 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: 168, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 82453 
    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: 864 
    Data pages: 864, average fill: 65% 
    Primary pages: 864, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 856 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 856 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34959, depth: 2, leaf buckets: 105, nodes: 82453 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3316, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 103 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.08, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 147.65, total records: 150619 
    Average version length: 154.12, total versions: 3678, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 8, data page slots: 5096 
    Data pages: 3760, average fill: 83% 
    Primary pages: 3756, secondary pages: 4, swept pages: 5 
    Empty pages: 49, full pages: 3690 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 2 
    80 - 99% = 3690 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 132.43, total records: 166009 
    Average version length: 154.86, total versions: 21748, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.81 
    Pointer pages: 6, data page slots: 4872 
    Data pages: 4128, average fill: 85% 
    Primary pages: 4126, secondary pages: 2, swept pages: 3 
    Empty pages: 40, full pages: 4076 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4075 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 129.83, total records: 192695 
    Average version length: 155.02, total versions: 28903, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.06 
    Pointer pages: 7, data page slots: 6680 
    Data pages: 4792, average fill: 85% 
    Primary pages: 4789, secondary pages: 3, swept pages: 5 
    Empty pages: 35, full pages: 4739 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4739 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 147.23, total records: 160952 
    Average version length: 152.72, total versions: 4237, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 7, data page slots: 4280 
    Data pages: 3984, average fill: 83% 
    Primary pages: 3982, secondary pages: 2, swept pages: 7 
    Empty pages: 22, full pages: 3943 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3942 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 148.80, total records: 158929 
    Average version length: 152.40, total versions: 2377, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 6, data page slots: 5720 
    Data pages: 3928, average fill: 83% 
    Primary pages: 3927, secondary pages: 1, swept pages: 7 
    Empty pages: 21, full pages: 3891 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 3890 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 150.67, total records: 144115 
    Average version length: 137.06, total versions: 211, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 7, data page slots: 4784 
    Data pages: 3568, average fill: 83% 
    Primary pages: 3566, secondary pages: 2, swept pages: 4 
    Empty pages: 28, full pages: 3531 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3531 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 150.57, total records: 158235 
    Average version length: 137.78, total versions: 420, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 6, data page slots: 5216 
    Data pages: 3936, average fill: 83% 
    Primary pages: 3934, secondary pages: 2, swept pages: 11 
    Empty pages: 40, full pages: 3865 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 9 
    40 - 59% = 11 
    60 - 79% = 9 
    80 - 99% = 3864 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.37, total records: 166381 
    Average version length: 151.75, total versions: 2156, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 4504 
    Data pages: 4160, average fill: 83% 
    Primary pages: 4158, secondary pages: 2, swept pages: 4 
    Empty pages: 62, full pages: 4081 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4079 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.88, total records: 153104 
    Average version length: 138.00, total versions: 271, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 7, data page slots: 4496 
    Data pages: 3800, average fill: 83% 
    Primary pages: 3798, secondary pages: 2, swept pages: 4 
    Empty pages: 34, full pages: 3753 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3753 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 149.29, total records: 168365 
    Average version length: 152.02, total versions: 2228, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 6, data page slots: 4680 
    Data pages: 4176, average fill: 83% 
    Primary pages: 4172, secondary pages: 4, swept pages: 2 
    Empty pages: 31, full pages: 4130 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4129 
 
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: 51.87, total records: 2169374 
    Average version length: 52.92, total versions: 43602, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 17, data page slots: 26304 
    Data pages: 26304, average fill: 71% 
    Primary pages: 26290, secondary pages: 14, swept pages: 10352 
    Empty pages: 71, full pages: 23705 
    Fill distribution: 
     0 - 19% = 186 
    20 - 39% = 170 
    40 - 59% = 593 
    60 - 79% = 24897 
    80 - 99% = 458 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2620, nodes: 2169374 
    Average node length: 5.43, total dup: 2026995, max dup: 1654 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 185566, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 234 
        40 - 59% = 1741 
        60 - 79% = 324 
        80 - 99% = 316 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2770, nodes: 2169374 
    Average node length: 5.69, total dup: 1948128, max dup: 64 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 385673, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2216 
        60 - 79% = 515 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2159, nodes: 2169374 
    Average node length: 4.96, total dup: 2169274, max dup: 28126 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 183003, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 166 
        40 - 59% = 1138 
        60 - 79% = 389 
        80 - 99% = 462 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 40.47, total records: 163659 
    Average version length: 69.18, total versions: 78116, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.11 
    Pointer pages: 3, data page slots: 4312 
    Data pages: 3144, average fill: 63% 
    Primary pages: 3144, secondary pages: 0, swept pages: 357 
    Empty pages: 484, full pages: 2239 
    Fill distribution: 
     0 - 19% = 644 
    20 - 39% = 84 
    40 - 59% = 70 
    60 - 79% = 904 
    80 - 99% = 1442 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104337, depth: 3, leaf buckets: 236, nodes: 163659 
    Average node length: 6.48, total dup: 142425, max dup: 14 
    Average key length: 3.93, compression ratio: 10.70 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 28712, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 35 
        40 - 59% = 102 
        60 - 79% = 80 
        80 - 99% = 18 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.26, total records: 6656912 
    Average version length: 68.82, total versions: 412047, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 61, data page slots: 99400 
    Data pages: 99400, average fill: 72% 
    Primary pages: 99400, secondary pages: 0, swept pages: 12224 
    Empty pages: 110, full pages: 78770 
    Fill distribution: 
     0 - 19% = 712 
    20 - 39% = 1286 
    40 - 59% = 4317 
    60 - 79% = 91688 
    80 - 99% = 1397 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10403, nodes: 6656912 
    Average node length: 6.51, total dup: 5757106, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1587192, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 2121 
        40 - 59% = 5519 
        60 - 79% = 2269 
        80 - 99% = 482 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 7993, nodes: 6656912 
    Average node length: 5.41, total dup: 6382698, max dup: 151 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1406554, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1200 
        40 - 59% = 4139 
        60 - 79% = 1673 
        80 - 99% = 976 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8053, nodes: 6656912 
    Average node length: 5.41, total dup: 6382698, max dup: 151 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1408881, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1325 
        40 - 59% = 4063 
        60 - 79% = 1647 
        80 - 99% = 1013 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.16, total records: 11700332 
    Average version length: 68.81, total versions: 347527, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 104, data page slots: 168256 
    Data pages: 168256, average fill: 74% 
    Primary pages: 168256, secondary pages: 0, swept pages: 51732 
    Empty pages: 4, full pages: 159280 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 377 
    40 - 59% = 2621 
    60 - 79% = 162956 
    80 - 99% = 2266 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18134, nodes: 11696980 
    Average node length: 6.58, total dup: 10197331, max dup: 65 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2447946, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 18 
        20 - 39% = 2663 
        40 - 59% = 10714 
        60 - 79% = 3988 
        80 - 99% = 751 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 43.06, total records: 1712925 
    Average version length: 69.10, total versions: 460300, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.93 
    Pointer pages: 25, data page slots: 40016 
    Data pages: 30216, average fill: 58% 
    Primary pages: 30069, secondary pages: 147, swept pages: 5840 
    Empty pages: 2656, full pages: 21437 
    Fill distribution: 
     0 - 19% = 4309 
    20 - 39% = 4274 
    40 - 59% = 2866 
    60 - 79% = 12494 
    80 - 99% = 6273 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1966, nodes: 1430189 
    Average node length: 5.52, total dup: 1371893, max dup: 49 
    Average key length: 2.57, compression ratio: 16.35 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 99300, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 521 
        40 - 59% = 952 
        60 - 79% = 424 
        80 - 99% = 62 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 35.73, total records: 1377502 
    Average version length: 69.01, total versions: 169591, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.53 
    Pointer pages: 20, data page slots: 32152 
    Data pages: 27448, average fill: 40% 
    Primary pages: 27447, secondary pages: 1, swept pages: 5922 
    Empty pages: 5722, full pages: 14457 
    Fill distribution: 
     0 - 19% = 8451 
    20 - 39% = 3338 
    40 - 59% = 6513 
    60 - 79% = 8721 
    80 - 99% = 425 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1110, nodes: 783175 
    Average node length: 5.96, total dup: 720673, max dup: 65 
    Average key length: 3.02, compression ratio: 13.91 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 110586, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 239 
        40 - 59% = 524 
        60 - 79% = 305 
        80 - 99% = 41 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.71, total records: 9767631 
    Average version length: 69.00, total versions: 512880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 90, data page slots: 146248 
    Data pages: 146248, average fill: 72% 
    Primary pages: 146234, secondary pages: 14, swept pages: 37101 
    Empty pages: 61, full pages: 92194 
    Fill distribution: 
     0 - 19% = 211 
    20 - 39% = 856 
    40 - 59% = 9569 
    60 - 79% = 131518 
    80 - 99% = 4094 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13564, nodes: 9760881 
    Average node length: 6.70, total dup: 8097366, max dup: 14 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2214957, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 770 
        40 - 59% = 6267 
        60 - 79% = 5383 
        80 - 99% = 1141 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21190776 
    Average version length: 82.89, total versions: 18735, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320336 
    Data pages: 320336, average fill: 81% 
    Primary pages: 320330, secondary pages: 6, swept pages: 12586 
    Empty pages: 13, full pages: 320138 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 16 
    40 - 59% = 17 
    60 - 79% = 49510 
    80 - 99% = 270768 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19400, nodes: 21190776 
    Average node length: 5.72, total dup: 20708886, max dup: 130 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3290881, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8084 
        60 - 79% = 590 
        80 - 99% = 10720 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17250, nodes: 21190776 
    Average node length: 6.31, total dup: 18621968, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919626, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2 
        40 - 59% = 854 
        60 - 79% = 281 
        80 - 99% = 16106 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21134, nodes: 21190776 
    Average node length: 6.35, total dup: 18541063, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3585553, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8267 
        60 - 79% = 616 
        80 - 99% = 12244 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16255, nodes: 21190776 
    Average node length: 5.56, total dup: 21190676, max dup: 231478 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948463, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 11 
        40 - 59% = 3149 
        60 - 79% = 365 
        80 - 99% = 12730 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.00, total records: 10178807 
    Average version length: 82.65, total versions: 475484, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 106, data page slots: 172752 
    Data pages: 172736, average fill: 73% 
    Primary pages: 172714, secondary pages: 22, swept pages: 58900 
    Empty pages: 315, full pages: 115408 
    Fill distribution: 
     0 - 19% = 853 
    20 - 39% = 2524 
    40 - 59% = 13919 
    60 - 79% = 128845 
    80 - 99% = 26595 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11399, nodes: 10178807 
    Average node length: 5.39, total dup: 9864011, max dup: 174 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2315280, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 18 
        40 - 59% = 6590 
        60 - 79% = 4539 
        80 - 99% = 249 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13902, nodes: 10178807 
    Average node length: 6.27, total dup: 8440038, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1633150, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 3747 
        40 - 59% = 4513 
        60 - 79% = 2573 
        80 - 99% = 2928 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12726, nodes: 10178807 
    Average node length: 6.01, total dup: 8843587, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2514000, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 29 
        40 - 59% = 7501 
        60 - 79% = 4881 
        80 - 99% = 310 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10402, nodes: 10178807 
    Average node length: 5.17, total dup: 10178707, max dup: 157067 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1657574, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1064 
        40 - 59% = 4953 
        60 - 79% = 1925 
        80 - 99% = 2423 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.70, total records: 11830258 
    Average version length: 82.57, total versions: 422965, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 119, data page slots: 192688 
    Data pages: 191720, average fill: 76% 
    Primary pages: 191606, secondary pages: 114, swept pages: 51307 
    Empty pages: 987, full pages: 163385 
    Fill distribution: 
     0 - 19% = 1790 
    20 - 39% = 3024 
    40 - 59% = 9418 
    60 - 79% = 99695 
    80 - 99% = 77793 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13167, nodes: 11830258 
    Average node length: 5.34, total dup: 11719317, max dup: 657 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2481624, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 75 
        40 - 59% = 7663 
        60 - 79% = 5028 
        80 - 99% = 401 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10756, nodes: 11830258 
    Average node length: 5.53, total dup: 11315900, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 761465, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 802 
        40 - 59% = 2560 
        60 - 79% = 1712 
        80 - 99% = 5547 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15055, nodes: 11830258 
    Average node length: 6.05, total dup: 10337822, max dup: 80 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2498223, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 101 
        40 - 59% = 9056 
        60 - 79% = 5473 
        80 - 99% = 424 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10964, nodes: 11830258 
    Average node length: 5.26, total dup: 11830158, max dup: 196261 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 747732, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 77 
        20 - 39% = 735 
        40 - 59% = 4554 
        60 - 79% = 1468 
        80 - 99% = 4130 
 
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: 79.37, total records: 10295023 
    Average version length: 82.94, total versions: 471203, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 108, data page slots: 175392 
    Data pages: 175368, average fill: 73% 
    Primary pages: 175345, secondary pages: 23, swept pages: 60372 
    Empty pages: 255, full pages: 116445 
    Fill distribution: 
     0 - 19% = 784 
    20 - 39% = 2657 
    40 - 59% = 14891 
    60 - 79% = 130729 
    80 - 99% = 26307 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12362, nodes: 10295023 
    Average node length: 5.21, total dup: 10265237, max dup: 2546 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2125446, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1326 
        40 - 59% = 8284 
        60 - 79% = 2042 
        80 - 99% = 678 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13992, nodes: 10295023 
    Average node length: 6.28, total dup: 8535874, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1615189, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 196 
        20 - 39% = 3627 
        40 - 59% = 4536 
        60 - 79% = 2545 
        80 - 99% = 3088 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 13014, nodes: 10295023 
    Average node length: 5.47, total dup: 9837051, max dup: 101 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2265141, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1302 
        40 - 59% = 9247 
        60 - 79% = 1793 
        80 - 99% = 649 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10691, nodes: 10295023 
    Average node length: 5.18, total dup: 10294923, max dup: 159406 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1694363, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1096 
        40 - 59% = 5352 
        60 - 79% = 1919 
        80 - 99% = 2295 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.24, total records: 585097 
    Average version length: 68.82, total versions: 9278, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 6, data page slots: 8176 
    Data pages: 8176, average fill: 75% 
    Primary pages: 8176, secondary pages: 0, swept pages: 3263 
    Empty pages: 7, full pages: 7172 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 6 
    40 - 59% = 112 
    60 - 79% = 7789 
    80 - 99% = 259 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43944, depth: 3, leaf buckets: 742, nodes: 585097 
    Average node length: 5.95, total dup: 498292, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102203, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 523 
        60 - 79% = 107 
        80 - 99% = 91 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34271, depth: 3, leaf buckets: 761, nodes: 585097 
    Average node length: 6.15, total dup: 480145, max dup: 27 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102255, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 513 
        60 - 79% = 115 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 570, nodes: 585097 
    Average node length: 4.86, total dup: 584997, max dup: 9510 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90836, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 344 
        60 - 79% = 47 
        80 - 99% = 149 
 
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 Sat Mar  2 10:10:01 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7874565 92006 1 0.0000 0.0000
DOC_LIST 2321173 48461 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2465 7 600.0000 0.0000
INVNT_TURNOVER_LOG 118460 109802 1 0.0000 0.0000
MONEY_SALDO 49 175 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1941 1844 1 0.0000 0.0000
PDISTR 764498 38514 3 0.0000 0.0000
PERF_SPLIT_0 150619 3678 1 0.0000 0.0000
PERF_SPLIT_1 166009 21748 1 0.0000 0.0000
PERF_SPLIT_2 192695 28903 1 0.0000 0.0000
PERF_SPLIT_3 160952 4237 1 0.0000 0.0000
PERF_SPLIT_4 158929 2377 1 0.0000 0.0000
PERF_SPLIT_5 144115 211 1 0.0000 0.0000
PERF_SPLIT_6 158235 420 1 0.0000 0.0000
PERF_SPLIT_7 166381 2156 1 0.0000 0.0000
PERF_SPLIT_8 153104 271 1 0.0000 0.0000
PERF_SPLIT_9 168365 2228 1 0.0000 0.0000
PSTORNED 2169374 43602 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 163659 78116 1 0.0000 0.0000
XQD_1000_3300 6656912 412047 1 0.0000 0.0000
XQD_1200_2000 11700332 347527 1 0.0000 0.0000
XQD_2000_3300 1712925 460300 1 0.0000 0.0000
XQD_2100_3300 1377502 169591 1 0.0000 0.0000
XQD_3300_3400 9767631 512880 1 0.0000 0.0000
XQS_1000_1200 21190776 18735 1 0.0000 0.0000
XQS_1000_3300 10178807 475484 1 0.0000 0.0000
XQS_1200_2000 11830258 422965 1 0.0000 0.0000
XQS_2100_3300 10295023 471203 1 0.0000 0.0000
XQS_3300_3400 585097 9278 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'  

02.03.24 10:10:13. 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-02 10:10:16 No severe PSQL-related problems occured
02.03.24 10:10:17. End of report.