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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-25 16:09:35
DTS_END                         2024-02-25 16:09:35.6140
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35180
TRN_ID                          187500
ATT_ID                          627
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: 9416.88 15011 941688
customer order: creation 195.26 337 19526
customer order: refuse 16.35 370 1635
order to supplier: creation 52.13 1299 5213
order to supplier: removal 3.92 95729 392
invoice (draft): creation 50.16 3101 5016
invoice (draft): removal 50.67 888 5067
invoice accept: apply 44.89 19436 4489
invoice accept: cancel 45.36 1045 4536
customer reserve: creation 4220.84 189 422084
customer reserve: removal 4419.49 66 441949
realization accept: apply 92.48 182 9248
realization accept: cancel 82.10 123 8210
payment from customer: creation 66.29 111 6629
payment from customer: removal 5.79 82 579
payment to supplier: creation 54.18 153 5418
payment to supplier: removal 3.57 63 357
service: total inventory turnovers 5.10 1089 510
service: total monetary turnovers 7.26 33 726
service: aggregate perf. data 1.01 13959 101
service: refresh index statistics 0.03 161973 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-02-2024 16:10:43 to 25-02-2024 16:10:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4413
TEST_TIME 2 4144
TEST_TIME 3 3434
TEST_TIME 4 2990
TEST_TIME 5 3424
TEST_TIME 6 3306
TEST_TIME 7 3774
TEST_TIME 8 4264
TEST_TIME 9 4580
TEST_TIME 10 5164
TEST_TIME 11 5389
TEST_TIME 12 5505
TEST_TIME 13 6148
TEST_TIME 14 6213
TEST_TIME 15 6419
TEST_TIME 16 6655
TEST_TIME 17 6710
TEST_TIME 18 6731
TEST_TIME 19 7212
TEST_TIME 20 7295
TEST_TIME 21 7391
TEST_TIME 22 7413
TEST_TIME 23 7482
TEST_TIME 24 7634
TEST_TIME 25 7945
TEST_TIME 26 8244
TEST_TIME 27 8580
TEST_TIME 28 9020
TEST_TIME 29 9049
TEST_TIME 30 9598
TEST_TIME 31 10039
TEST_TIME 32 10008
TEST_TIME 33 9972
TEST_TIME 34 9920
TEST_TIME 35 9853
TEST_TIME 36 9811
TEST_TIME 37 9755
TEST_TIME 38 9740
TEST_TIME 39 9750
TEST_TIME 40 9642
TEST_TIME 41 9884
TEST_TIME 42 9824
TEST_TIME 43 9814
TEST_TIME 44 9623
TEST_TIME 45 9596
TEST_TIME 46 9527
TEST_TIME 47 9677
TEST_TIME 48 9538
TEST_TIME 49 9561
TEST_TIME 50 9533
TEST_TIME 51 9467
TEST_TIME 52 9611
TEST_TIME 53 9591
TEST_TIME 54 9522
TEST_TIME 55 9425
TEST_TIME 56 9421
TEST_TIME 57 9516
TEST_TIME 58 9440
TEST_TIME 59 9405
TEST_TIME 60 9400
TEST_TIME 61 9352
TEST_TIME 62 9271
TEST_TIME 63 9241
TEST_TIME 64 9220
TEST_TIME 65 9177
TEST_TIME 66 9209
TEST_TIME 67 9198
TEST_TIME 68 9286
TEST_TIME 69 9288
TEST_TIME 70 9358
TEST_TIME 71 9409
TEST_TIME 72 9441
TEST_TIME 73 9496
TEST_TIME 74 9540
TEST_TIME 75 9537
TEST_TIME 76 9623
TEST_TIME 77 9659
TEST_TIME 78 9654
TEST_TIME 79 9611
TEST_TIME 80 9520
TEST_TIME 81 9581
TEST_TIME 82 9536
TEST_TIME 83 9514
TEST_TIME 84 9486
TEST_TIME 85 9433
TEST_TIME 86 9407
TEST_TIME 87 9410
TEST_TIME 88 9382
TEST_TIME 89 9384
TEST_TIME 90 9403
TEST_TIME 91 9369
TEST_TIME 92 9401
TEST_TIME 93 9374
TEST_TIME 94 9359
TEST_TIME 95 9407
TEST_TIME 96 9435
TEST_TIME 97 9480
TEST_TIME 98 9451
TEST_TIME 99 9438
TEST_TIME 100 9424

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-02-2024 16:10:47 to 25-02-2024 16:10:50.

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 1330571 1330571 0 0.00 0 34000 7 0 0
doc_list_biud 1330568 1330568 0 0.00 0 29182 28 0 0
sp_add_invoice_to_stock 4634 4489 145 3.12 24 198208 19436 0 145
sp_cancel_adding_invoice 4536 4536 0 0.00 4 53203 1045 0 0
sp_cancel_client_order 1635 1635 0 0.00 5 7149 370 0 0
sp_cancel_customer_reserve 441949 441949 0 0.00 0 24344 67 0 0
sp_cancel_pay_from_customer 579 579 0 0.00 3 5317 82 0 0
sp_cancel_pay_to_supplier 357 357 0 0.00 3 1164 64 0 0
sp_cancel_supplier_invoice 5082 5067 15 0.29 1 14555 888 0 15
sp_cancel_supplier_order 392 392 0 0.00 5 1226903 95729 0 0
sp_cancel_write_off 8210 8210 0 0.00 1 7884 123 0 0
sp_client_order 19526 19526 0 0.00 3 18479 338 0 0
sp_customer_reserve 422084 422084 0 0.00 0 124832 190 0 0
sp_fill_shopping_cart 29752 29752 0 0.00 1 23981 36 0 0
sp_fill_shopping_cart_clo_res 422078 422078 0 0.00 0 24438 14 0 0
sp_get_clo_for_invoice 4483 4483 0 0.00 0 22639 297 0 0
sp_kill_cost_storno 13682 13682 0 0.00 0 7878 69 0 0
sp_kill_qstorno_ret_qs2qd 897567 897567 0 0.00 0 24343 36 0 0
sp_kill_qty_storno 475520 475520 0 0.00 0 29180 78 0 0
sp_lock_selected_doc 19041 19041 0 0.00 0 5403 4 0 0
sp_make_cost_storno 25778 25778 0 0.00 0 33987 59 0 0
sp_multiply_rows_for_pdistr 25777 25777 0 0.00 0 13493 31 0 0
sp_multiply_rows_for_qdistr 19526 19526 0 0.00 0 15596 150 0 0
sp_pay_from_customer 6629 6629 0 0.00 4 13485 112 0 0
sp_pay_to_supplier 5418 5418 0 0.00 4 25836 154 0 0
sp_payment_common 12046 12046 0 0.00 1 25360 30 0 0
sp_qd_handle_on_cancel_clo 1635 1635 0 0.00 0 7142 345 0 0
sp_qd_handle_on_invoice_upd_sts 9019 9019 0 0.00 0 29178 362 0 0
sp_qd_handle_on_reserve_upd_sts 9248 9248 0 0.00 0 12597 61 0 0
sp_reserve_write_off 9248 9248 0 0.00 6 13468 182 0 0
sp_supplier_invoice 5016 5016 0 0.00 7 94465 3102 0 0
sp_supplier_order 5213 5213 0 0.00 5 38341 1300 0 0
srv_aggregate_perf_data 101 101 0 0.00 1764 88937 13959 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1548 112743 37299 0 0
srv_find_qd_qs_mism 896556 896556 0 0.00 0 14212 6 0 0
srv_make_invnt_saldo 510 510 0 0.00 27 39545 1089 0 0
srv_make_money_saldo 726 726 0 0.00 1 2788 34 0 0
srv_recalc_idx_stat 3 3 0 0.00 134708 187260 161974 0 0
t$perf-abend:sp_add_invoice_to_stock 145 145 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4491 4491 0 0.00 0 23874 206 0 0
t$perf-norm:sp_cancel_adding_invoice 387 387 0 0.00 0 5583 116 0 0
t$perf-norm:sp_cancel_client_order 1635 1635 0 0.00 0 4583 20 0 0
t$perf-norm:sp_cancel_customer_reserve 631 631 0 0.00 0 2638 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 579 579 0 0.00 0 2265 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 357 357 0 0.00 0 764 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 377 377 0 0.00 0 572 15 0 0
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 0 24673 1829 0 0
t$perf-norm:sp_cancel_write_off 952 952 0 0.00 0 4479 18 0 0
t$perf-norm:sp_client_order 19526 19526 0 0.00 0 9519 18 0 0
t$perf-norm:sp_customer_reserve 862 862 0 0.00 0 2544 10 0 0
t$perf-norm:sp_pay_from_customer 6629 6629 0 0.00 0 3635 8 0 0
t$perf-norm:sp_pay_to_supplier 5418 5418 0 0.00 0 5503 12 0 0
t$perf-norm:sp_reserve_write_off 9248 9248 0 0.00 0 5551 10 0 0
t$perf-norm:sp_supplier_invoice 5016 5016 0 0.00 0 9777 29 0 0
t$perf-norm:sp_supplier_order 5213 5213 0 0.00 0 3024 17 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 330 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 908 17 0 0
t$perf-norm:srv_make_invnt_saldo 510 510 0 0.00 0 1135 36 0 0
t$perf-norm:srv_make_money_saldo 726 726 0 0.00 0 2010 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 9256 8966 290 3.13 0 5827 19 0 290
v_all_customers 35916 35916 0 0.00 0 23 1 0 0
v_all_suppliers 28970 28970 0 0.00 0 25 1 0 0
v_all_wares 39048 39048 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 774 774 0 0.00 0 887 7 0 0
v_cancel_client_order 3270 3270 0 0.00 0 1975 5 0 0
v_cancel_customer_prepayment 1158 1158 0 0.00 0 844 4 0 0
v_cancel_customer_reserve 1262 1262 0 0.00 0 662 3 0 0
v_cancel_payment_to_supplier 714 714 0 0.00 0 115 2 0 0
v_cancel_supplier_invoice 784 754 30 3.82 0 6574 27 0 30
v_cancel_supplier_order 784 784 0 0.00 0 1770 6 0 0
v_cancel_write_off 1904 1904 0 0.00 0 2201 13 0 0
v_max_id_clo_ord 5212 5212 0 0.00 0 424 2 0 0
v_max_id_clo_res 862 862 0 0.00 0 2391 18 0 0
v_max_id_ord_sup 5015 5015 0 0.00 0 6847 4 0 0
v_max_non_paid_invoice 1159 1159 0 0.00 0 798 4 0 0
v_max_non_paid_realizn 3151 3151 0 0.00 0 1159 5 0 0
v_min_id_clo_ord 5212 5212 0 0.00 0 3469 8 0 0
v_min_id_clo_res 862 862 0 0.00 0 11122 24 0 0
v_min_id_ord_sup 5015 5015 0 0.00 0 4718 8 0 0
v_min_non_paid_invoice 5417 5417 0 0.00 0 25356 21 0 0
v_min_non_paid_realizn 6629 6629 0 0.00 0 7925 21 0 0
v_our_firm 10088 10088 0 0.00 0 24 1 0 0
v_reserve_write_off 18496 18496 0 0.00 0 6396 6 0 0
x_lock_depdocs_on_canc_invoice 9226 9226 0 0.00 0 18336 153 0 0
x_lock_depdocs_on_canc_sup_ord 392 392 0 0.00 0 5633 287 0 0
x_make_qstorno_1000_1200 5213 5213 0 0.00 2 38332 1214 0 0
x_make_qstorno_1200_2000 5016 5016 0 0.00 3 94440 2975 0 0
x_make_qstorno_2100_3300 422084 422084 0 0.00 0 124826 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-02-2024 16:10:51 to 25-02-2024 16:10:55.

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
14:09:39 1 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:40 36931 8192000000 9884124416 10193711104 973175744 10.618 100 90 180 0 1002491424 5964848 23350832
14:12:25 20857 8192000000 9935189120 10257420288 1022504144 11.096 100 87 174 0 1052428080 7716176 22207760
14:13:52 12658 8192000000 9969291632 10297991168 1057484400 11.432 100 88 176 0 1088569920 9078944 22006576
14:15:12 11091 8192000000 10014076736 10361602048 1100594608 11.843 100 72 144 0 1127249792 9380944 17274240
14:16:25 5469 8192000000 10069987360 10427928576 1157457056 12.379 100 80 160 0 1187858416 11920416 18480944
14:17:33 3316 8192000000 10120077008 10489495552 1210819024 12.877 100 80 159 0 1241114560 12768272 17527264
14:18:39 1833 8192000000 10159404800 10535116800 1248585472 13.225 100 82 158 1 1278920880 11953664 18381744
14:19:43 1803 8192000000 10186159664 10564513792 1270666832 13.428 100 86 170 2 1303558480 13984480 18907168
14:20:47 7602 8192000000 10205879408 10590621696 1295271168 13.652 100 78 154 0 1325444704 13896512 16277024
14:21:55 11833 8192000000 10185312528 10593185792 1299630928 13.692 100 31 61 0 1312948592 6665344 6652320
14:23:09 6006 8192000000 10200196368 10612350976 1313681968 13.819 100 23 46 0 1325103696 6056080 5365648
14:24:16 8545 8192000000 10207925328 10623385600 1320262032 13.879 100 20 40 1 1330649200 5858720 4528448
14:25:25 10337 8192000000 10215961184 10626961408 1326462256 13.935 100 24 48 1 1338241264 6453872 5325136
14:26:37 28942 8192000000 10242132064 10650177536 1332739904 13.992 100 48 93 0 1349964240 5961568 11262768
14:28:06 4330 8192000000 10241973712 10653835264 1338770288 14.046 100 38 76 0 1355890608 8561776 8558544
14:29:13 6718 8192000000 10217312496 10636922880 1306967808 13.759 98 12 25 0 1314779776 5049344 2762624
14:30:31 29187 8192000000 10221490400 10631536640 1322467296 13.899 99 49 97 2 1343708816 9670848 11570672
14:32:04 112743 8192000000 10231522864 10651181056 1297247264 13.670 97 43 86 0 1318646256 10815520 10583472
14:35:17 37800 8192000000 10227625808 10637508608 1280505040 13.518 95 37 74 0 1307904144 18436912 8962192
14:37:00 17817 8192000000 10246092256 10664374272 1323129552 13.905 99 35 70 0 1349377360 18192208 8055600
14:38:31 24635 8192000000 10251348352 10658377728 1281286304 13.525 95 46 91 0 1311869728 19690784 10892640
14:40:03 1616 8192000000 10251194032 10651148288 1311713200 13.802 99 59 116 0 1346255728 20304576 14237952
14:41:09 3512 8192000000 10249042768 10648743936 1316695376 13.847 99 68 134 0 1355582992 23355632 15531984
14:42:24 10290 8192000000 10247272048 10655059968 1315128784 13.833 99 45 86 2 1350199248 24470160 10600304
14:43:45 5399 8192000000 10249774128 10651426816 1324057984 13.913 100 66 131 3 1359919184 20297488 15563712
14:44:58 5117 8192000000 10269430544 10666713088 1335636672 14.018 100 71 140 0 1382192992 29240832 17315488
14:46:07 5661 8192000000 10295674400 10700685312 1361523664 14.251 100 73 146 0 1405106144 25662144 17920336
14:47:20 11173 8192000000 10301534528 10707623936 1354992816 14.192 99 63 126 0 1403820672 33664992 15162864
14:48:40 1544 8192000000 10349901344 10748620800 1393304144 14.535 100 95 186 0 1446406512 31277696 21824672
14:49:47 2209 8192000000 10350826352 10760421376 1403199488 14.623 100 75 150 0 1453985664 32535968 18250208
14:50:56 6222 8192000000 10353775232 10773450752 1408834256 14.674 100 57 110 1 1455833648 32345648 14653744
14:52:06 6070 8192000000 10352937312 10771218432 1401533136 14.609 100 52 100 0 1454354848 38926784 13894928
14:53:19 13608 8192000000 10361977952 10793361408 1418485376 14.759 100 35 70 1 1471314256 42455856 10373024
14:54:39 13013 8192000000 10371463312 10806165504 1416123856 14.738 100 42 83 0 1477757824 50089984 11543984
14:55:58 25181 8192000000 10354190256 10794991616 1407278800 14.660 100 31 63 0 1467687456 51144080 9264576
14:57:37 24820 8192000000 10343066496 10801356800 1405318848 14.642 100 24 48 0 1447256336 35311664 6625824
15:00:20 22909 8192000000 10333069584 10790760448 1403890384 14.630 100 31 59 0 1441548800 30809136 6849280
15:01:45 44060 8192000000 10320992320 10768560128 1407319424 14.660 100 34 70 0 1427031376 12185072 7526880
15:03:42 47079 8192000000 10317538080 10752221184 1394599504 14.547 100 30 58 0 1408500448 7301152 6599792
15:05:35 78856 8192000000 10306568928 10758041600 1374748288 14.370 98 12 24 0 1387105728 9415088 2942352
15:07:58 89827 8192000000 10315975312 10766434304 1352733552 14.172 96 11 20 0 1368364688 13650208 1980928
15:10:42 71195 8192000000 10310839920 10756399104 1365274688 14.285 97 18 36 2 1380160368 10751312 4134368
15:12:54 104464 8192000000 10310299840 10767679488 1398898000 14.585 100 21 42 1 1411518608 8209072 4411536
15:15:44 17166 8192000000 10305003952 10754949120 1387920320 14.487 99 54 108 1 1416424320 15585040 12918960
15:17:05 66397 8192000000 10270666080 10709209088 1300665248 13.701 94 28 54 2 1321094544 14076400 6352896
15:19:23 19985 8192000000 10290405856 10723823616 1358786560 14.226 99 41 83 0 1379376512 10997776 9592176
15:20:45 13569 8192000000 10251650960 10679812096 1308381456 13.771 96 50 98 1 1335540192 14731568 12427168
15:22:00 27287 8192000000 10242681088 10692612096 1333184944 13.996 99 17 32 0 1345055680 8022144 3848592
15:23:30 51111 8192000000 10262887680 10711015424 1344556752 14.098 99 15 30 0 1360593200 11783216 4253232
15:25:25 51499 8192000000 10252155440 10699587584 1322112272 13.896 97 26 52 0 1341898656 13453008 6333376
15:27:18 112590 8192000000 10250319264 10700976128 1317953328 13.858 97 12 24 0 1332066272 11060656 3052288
15:30:13 36252 8192000000 10250289856 10703982592 1347366560 14.124 99 8 16 0 1355414080 6209808 1837712
15:31:52 38824 8192000000 10251427168 10700226560 1331799472 13.983 98 17 34 0 1342875104 7313568 3762064
15:33:31 38866 8192000000 10237593856 10690424832 1329569664 13.963 99 19 36 1 1340085904 7062624 3453616
15:35:13 30012 8192000000 10257766832 10697994240 1331711280 13.983 99 22 44 0 1345063632 8476656 4875696
15:36:52 32713 8192000000 10256780640 10708615168 1355323104 14.195 100 28 56 0 1373351344 11820512 6207728
15:38:25 48301 8192000000 10254220800 10703077376 1318649984 13.864 97 18 36 0 1332389152 9825040 3914128
15:40:15 67371 8192000000 10267251440 10711973888 1331903392 13.984 97 26 52 0 1351134192 13512112 5718688
15:42:23 46410 8192000000 10286021136 10741796864 1359043920 14.229 99 23 46 0 1382433520 18372160 5017440
15:44:38 16029 8192000000 10307115712 10748891136 1388630736 14.494 100 35 70 0 1407480976 11512416 7337824
15:45:57 59700 8192000000 10307634128 10764873728 1366635840 14.297 98 21 42 1 1383504368 12453760 4414768
15:48:02 25079 8192000000 10317298592 10762420224 1384237152 14.454 99 30 60 0 1402454144 11339712 6877280
15:49:27 83795 8192000000 10296887408 10761232384 1377906736 14.398 99 28 56 1 1402998000 18102864 6988400
15:51:53 15653 8192000000 10292602704 10746105856 1375180416 14.373 99 24 46 1 1388939424 7747840 6011168
15:53:09 49177 8192000000 10291154800 10752921600 1394871856 14.549 100 16 32 0 1406170224 7612960 3685408
15:55:00 47361 8192000000 10299451072 10760994816 1401661360 14.610 100 17 33 0 1414577296 9247648 3668288
15:56:48 52685 8192000000 10297194528 10767499264 1405359152 14.643 100 18 36 0 1417839840 8411888 4068800
15:58:41 30494 8192000000 10306043776 10760945664 1387812528 14.486 99 23 46 0 1400260720 7567584 4880608
16:00:14 42818 8192000000 10285568272 10729443328 1326405840 13.935 96 19 38 0 1338714176 7881552 4426784
16:02:02 31147 8192000000 10292255680 10741026816 1370571104 14.332 99 28 55 0 1382947600 6320144 6056352
16:03:34 36416 8192000000 10275133600 10719748096 1335477952 14.017 97 40 80 0 1359302352 15104064 8720336
16:05:11 47878 8192000000 10277824864 10721177600 1331656464 13.982 97 28 57 0 1351207360 13328704 6222192
16:07:02 50537 8192000000 10267036976 10691825664 1248897120 13.228 92 32 64 1 1264850544 9015632 6937792
16:08:55 60106 8192000000 9083268672 9302245376 239733344 2.843 18 3 6 0 248785216 8659456 392416

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 25-02-2024 16:10:57 to 25-02-2024 16:11:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 145 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-02-2024 16:11:12 to 25-02-2024 16:11:14.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Feb 25 16:11:15 2024 
 
Database header page information: 
    Flags            0 
    Generation        97815 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    187780 
    Oldest active        187781 
    Oldest snapshot        187781 
    Next transaction    187782 
    Sequence number        0 
    Next attachment ID    741 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.03, total records: 7869190 
    Average version length: 48.16, total versions: 142702, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 87824 
    Data pages: 87824, average fill: 72% 
    Primary pages: 87824, secondary pages: 0, swept pages: 11135 
    Empty pages: 6, full pages: 80430 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 296 
    40 - 59% = 4228 
    60 - 79% = 83208 
    80 - 99% = 71 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23682, nodes: 7869190 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1749810, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 362 
        20 - 39% = 1707 
        40 - 59% = 4449 
        60 - 79% = 2326 
        80 - 99% = 14838 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13759, nodes: 7869190 
    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: 1571956, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1538 
        40 - 59% = 2292 
        60 - 79% = 1012 
        80 - 99% = 8917 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8505, nodes: 7869190 
    Average node length: 6.63, total dup: 5864743, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1564629, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 924 
        40 - 59% = 1541 
        60 - 79% = 856 
        80 - 99% = 5034 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.76, total records: 2296410 
    Average version length: 34.66, total versions: 136274, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28792 
    Data pages: 28792, average fill: 74% 
    Primary pages: 28783, secondary pages: 9, swept pages: 6387 
    Empty pages: 7, full pages: 24183 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 142 
    40 - 59% = 1889 
    60 - 79% = 25114 
    80 - 99% = 1629 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4653, nodes: 2296410 
    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: 693145, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 894 
        40 - 59% = 946 
        60 - 79% = 686 
        80 - 99% = 2127 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2563, nodes: 2300135 
    Average node length: 4.97, total dup: 2299236, max dup: 20015 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1271152, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 235 
        40 - 59% = 1582 
        60 - 79% = 552 
        80 - 99% = 191 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2083, nodes: 2296410 
    Average node length: 4.97, total dup: 2296360, max dup: 131025 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1077437, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 82 
        40 - 59% = 1131 
        60 - 79% = 56 
        80 - 99% = 811 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4424, nodes: 2296410 
    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: 693145, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 539 
        40 - 59% = 650 
        60 - 79% = 802 
        80 - 99% = 2306 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.55, total records: 400 
    Average version length: 23.08, total versions: 250670, max versions: 659 
    Average fragment length: 2.00, total fragments: 43, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1384 
    Data pages: 1384, average fill: 90% 
    Primary pages: 7, secondary pages: 1377, swept pages: 0 
    Empty pages: 0, full pages: 1383 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1383 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 12.18, total records: 71762 
    Average version length: 68.28, total versions: 58966, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.22 
    Pointer pages: 7, data page slots: 2584 
    Data pages: 1760, average fill: 51% 
    Primary pages: 1759, secondary pages: 1, swept pages: 0 
    Empty pages: 239, full pages: 557 
    Fill distribution: 
     0 - 19% = 367 
    20 - 39% = 272 
    40 - 59% = 353 
    60 - 79% = 335 
    80 - 99% = 433 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705753, depth: 3, leaf buckets: 333, nodes: 71762 
    Average node length: 13.36, total dup: 3745, max dup: 2 
    Average key length: 10.99, compression ratio: 2.46 
    Average prefix length: 18.95, average data length: 8.05 
    Clustering factor: 57911, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 259 
        40 - 59% = 70 
        60 - 79% = 4 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 19368, max versions: 1013 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 86% 
    Primary pages: 4, secondary pages: 68, swept pages: 0 
    Empty pages: 3, full pages: 68 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 64 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 4.06, total records: 1297 
    Average version length: 43.11, total versions: 1180, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 14.28 
    Pointer pages: 1, data page slots: 32 
    Data pages: 29, average fill: 44% 
    Primary pages: 28, secondary pages: 1, swept pages: 0 
    Empty pages: 5, full pages: 7 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 4 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91223, depth: 2, leaf buckets: 2, nodes: 1297 
    Average node length: 4.56, total dup: 1200, max dup: 131 
    Average key length: 2.78, compression ratio: 6.82 
    Average prefix length: 18.29, average data length: 0.71 
    Clustering factor: 713, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.99, total records: 75 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.37, total records: 805908 
    Average version length: 25.35, total versions: 97153, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.53 
    Pointer pages: 6, data page slots: 8440 
    Data pages: 8432, average fill: 68% 
    Primary pages: 8387, secondary pages: 45, swept pages: 1072 
    Empty pages: 167, full pages: 7034 
    Fill distribution: 
     0 - 19% = 346 
    20 - 39% = 262 
    40 - 59% = 313 
    60 - 79% = 7106 
    80 - 99% = 405 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 914, nodes: 805908 
    Average node length: 4.87, total dup: 805859, max dup: 148033 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90709, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 153 
        40 - 59% = 520 
        60 - 79% = 197 
        80 - 99% = 43 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 988, nodes: 805908 
    Average node length: 5.88, total dup: 717652, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161186, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 139 
        40 - 59% = 463 
        60 - 79% = 147 
        80 - 99% = 239 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1038, nodes: 805908 
    Average node length: 5.88, total dup: 717652, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163224, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 252 
        40 - 59% = 416 
        60 - 79% = 116 
        80 - 99% = 254 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1146, nodes: 805908 
    Average node length: 5.96, total dup: 717652, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156213, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 223 
        40 - 59% = 643 
        60 - 79% = 197 
        80 - 99% = 80 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.86, total records: 5520 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.64, total fragments: 104, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 104 
    Data pages: 103, average fill: 53% 
    Primary pages: 84, secondary pages: 19, swept pages: 47 
    Empty pages: 16, full pages: 64 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 69 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5520 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.10 
    Average prefix length: 34.54, average data length: 1.54 
    Clustering factor: 5301, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5520 
    Average node length: 11.12, 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: 144, 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: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 86466 
    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: 840 
    Data pages: 840, average fill: 71% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 832 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 833 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34513, depth: 2, leaf buckets: 111, nodes: 86466 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3792, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 107 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.72, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.27 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 147.14, total records: 165515 
    Average version length: 152.57, total versions: 3960, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 5088 
    Data pages: 3976, average fill: 86% 
    Primary pages: 3975, secondary pages: 1, swept pages: 2 
    Empty pages: 50, full pages: 3911 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 1 
    80 - 99% = 3911 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 137.57, total records: 167593 
    Average version length: 154.63, total versions: 14646, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.33 
    Pointer pages: 6, data page slots: 6288 
    Data pages: 4112, average fill: 85% 
    Primary pages: 4112, secondary pages: 0, swept pages: 2 
    Empty pages: 120, full pages: 3957 
    Fill distribution: 
     0 - 19% = 124 
    20 - 39% = 11 
    40 - 59% = 13 
    60 - 79% = 7 
    80 - 99% = 3957 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.83, total records: 181255 
    Average version length: 153.55, total versions: 5092, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 7, data page slots: 4720 
    Data pages: 4320, average fill: 87% 
    Primary pages: 4320, secondary pages: 0, swept pages: 4 
    Empty pages: 18, full pages: 4291 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4292 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 137.85, total records: 184156 
    Average version length: 155.05, total versions: 16060, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.30 
    Pointer pages: 6, data page slots: 4704 
    Data pages: 4392, average fill: 87% 
    Primary pages: 4392, secondary pages: 0, swept pages: 2 
    Empty pages: 16, full pages: 4369 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4368 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 147.11, total records: 171051 
    Average version length: 153.21, total versions: 4769, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 9, data page slots: 5904 
    Data pages: 4144, average fill: 85% 
    Primary pages: 4144, secondary pages: 0, swept pages: 3 
    Empty pages: 73, full pages: 4048 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 4 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 4048 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 140.71, total records: 196184 
    Average version length: 154.67, total versions: 13489, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.05 
    Pointer pages: 7, data page slots: 5160 
    Data pages: 4720, average fill: 86% 
    Primary pages: 4719, secondary pages: 1, swept pages: 3 
    Empty pages: 50, full pages: 4651 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4652 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.40, total records: 179220 
    Average version length: 152.67, total versions: 3011, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 4624 
    Data pages: 4280, average fill: 86% 
    Primary pages: 4279, secondary pages: 1, swept pages: 2 
    Empty pages: 29, full pages: 4240 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4240 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 146.72, total records: 163187 
    Average version length: 153.36, total versions: 4546, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 7, data page slots: 5032 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3919, secondary pages: 1, swept pages: 2 
    Empty pages: 48, full pages: 3860 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3858 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.16, total records: 186025 
    Average version length: 151.51, total versions: 2408, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 5144 
    Data pages: 4440, average fill: 86% 
    Primary pages: 4440, secondary pages: 0, swept pages: 1 
    Empty pages: 24, full pages: 4405 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4405 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 142.43, total records: 194425 
    Average version length: 154.69, total versions: 11169, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 7, data page slots: 4968 
    Data pages: 4648, average fill: 87% 
    Primary pages: 4648, secondary pages: 0, swept pages: 4 
    Empty pages: 29, full pages: 4610 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 4610 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.16, total records: 2160450 
    Average version length: 52.91, total versions: 65210, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25808 
    Data pages: 25808, average fill: 72% 
    Primary pages: 25808, secondary pages: 0, swept pages: 8276 
    Empty pages: 289, full pages: 23048 
    Fill distribution: 
     0 - 19% = 509 
    20 - 39% = 325 
    40 - 59% = 680 
    60 - 79% = 23683 
    80 - 99% = 611 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2663, nodes: 2160450 
    Average node length: 5.44, total dup: 2017655, max dup: 1416 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185773, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 269 
        40 - 59% = 1805 
        60 - 79% = 305 
        80 - 99% = 277 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2160450 
    Average node length: 5.69, total dup: 1940594, max dup: 69 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 385251, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2302 
        60 - 79% = 427 
        80 - 99% = 32 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2196, nodes: 2160450 
    Average node length: 4.96, total dup: 2160350, max dup: 29279 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 183166, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 159 
        40 - 59% = 1225 
        60 - 79% = 407 
        80 - 99% = 403 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 33.23, total records: 166873 
    Average version length: 69.19, total versions: 86751, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.79 
    Pointer pages: 3, data page slots: 4608 
    Data pages: 3256, average fill: 60% 
    Primary pages: 3256, secondary pages: 0, swept pages: 499 
    Empty pages: 698, full pages: 2282 
    Fill distribution: 
     0 - 19% = 866 
    20 - 39% = 15 
    40 - 59% = 21 
    60 - 79% = 833 
    80 - 99% = 1521 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103668, depth: 3, leaf buckets: 226, nodes: 166873 
    Average node length: 6.44, total dup: 145351, max dup: 19 
    Average key length: 3.90, compression ratio: 10.77 
    Average prefix length: 40.23, average data length: 1.77 
    Clustering factor: 28994, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 96 
        60 - 79% = 66 
        80 - 99% = 36 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 62.39, total records: 7350584 
    Average version length: 68.78, total versions: 700526, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.02 
    Pointer pages: 64, data page slots: 104152 
    Data pages: 104152, average fill: 76% 
    Primary pages: 104152, secondary pages: 0, swept pages: 11459 
    Empty pages: 196, full pages: 95603 
    Fill distribution: 
     0 - 19% = 995 
    20 - 39% = 1530 
    40 - 59% = 2436 
    60 - 79% = 81977 
    80 - 99% = 17214 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10822, nodes: 7350584 
    Average node length: 6.50, total dup: 6363847, max dup: 29 
    Average key length: 3.51, compression ratio: 11.97 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1628912, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1421 
        40 - 59% = 5824 
        60 - 79% = 2868 
        80 - 99% = 699 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8709, nodes: 7350584 
    Average node length: 5.39, total dup: 7064644, max dup: 181 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1399024, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 999 
        40 - 59% = 4945 
        60 - 79% = 1676 
        80 - 99% = 1083 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8790, nodes: 7350584 
    Average node length: 5.39, total dup: 7064644, max dup: 181 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1401612, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1047 
        40 - 59% = 4966 
        60 - 79% = 1683 
        80 - 99% = 1080 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 65.77, total records: 12232046 
    Average version length: 68.73, total versions: 565027, 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: 103, data page slots: 167504 
    Data pages: 167504, average fill: 78% 
    Primary pages: 167504, secondary pages: 0, swept pages: 52053 
    Empty pages: 6, full pages: 167389 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 12 
    60 - 79% = 153070 
    80 - 99% = 14415 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18465, nodes: 12232046 
    Average node length: 6.58, total dup: 10666172, max dup: 67 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.71, average data length: 1.29 
    Clustering factor: 2416494, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2115 
        40 - 59% = 10871 
        60 - 79% = 4529 
        80 - 99% = 925 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 33.13, total records: 2137565 
    Average version length: 69.11, total versions: 1113389, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.80 
    Pointer pages: 32, data page slots: 50472 
    Data pages: 30917, average fill: 81% 
    Primary pages: 30916, secondary pages: 1, swept pages: 2177 
    Empty pages: 963, full pages: 28683 
    Fill distribution: 
     0 - 19% = 1455 
    20 - 39% = 454 
    40 - 59% = 212 
    60 - 79% = 9058 
    80 - 99% = 19738 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2401, nodes: 2137565 
    Average node length: 5.51, total dup: 2051101, max dup: 99 
    Average key length: 2.54, compression ratio: 16.54 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 148929, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 110 
        40 - 59% = 1048 
        60 - 79% = 866 
        80 - 99% = 353 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.75, total records: 1204098 
    Average version length: 69.13, total versions: 528331, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.25 
    Pointer pages: 24, data page slots: 37928 
    Data pages: 29504, average fill: 47% 
    Primary pages: 29504, secondary pages: 0, swept pages: 7115 
    Empty pages: 7436, full pages: 13202 
    Fill distribution: 
     0 - 19% = 10556 
    20 - 39% = 1693 
    40 - 59% = 1704 
    60 - 79% = 7607 
    80 - 99% = 7944 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1644, nodes: 1204098 
    Average node length: 5.77, total dup: 1125698, max dup: 109 
    Average key length: 2.84, compression ratio: 14.81 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 165407, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 315 
        40 - 59% = 824 
        60 - 79% = 440 
        80 - 99% = 62 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.45, total records: 9639565 
    Average version length: 69.01, total versions: 762423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.99 
    Pointer pages: 92, data page slots: 148744 
    Data pages: 148728, average fill: 70% 
    Primary pages: 148727, secondary pages: 1, swept pages: 36828 
    Empty pages: 591, full pages: 102772 
    Fill distribution: 
     0 - 19% = 1902 
    20 - 39% = 8295 
    40 - 59% = 23566 
    60 - 79% = 96188 
    80 - 99% = 18777 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13559, nodes: 9639565 
    Average node length: 6.70, total dup: 7998770, max dup: 27 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2073980, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 938 
        40 - 59% = 6266 
        60 - 79% = 5316 
        80 - 99% = 1038 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.44, total records: 21261795 
    Average version length: 82.89, total versions: 26554, 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: 320280 
    Data pages: 320280, average fill: 81% 
    Primary pages: 320280, secondary pages: 0, swept pages: 11956 
    Empty pages: 7, full pages: 320272 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 26977 
    80 - 99% = 293296 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19941, nodes: 21261795 
    Average node length: 5.72, total dup: 20778463, max dup: 169 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3298830, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 9069 
        60 - 79% = 602 
        80 - 99% = 10263 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17327, nodes: 21261795 
    Average node length: 6.31, total dup: 18684381, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 921099, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 7 
        40 - 59% = 874 
        60 - 79% = 302 
        80 - 99% = 16135 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21740, nodes: 21261795 
    Average node length: 6.35, total dup: 18604107, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3595387, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 9327 
        60 - 79% = 683 
        80 - 99% = 11722 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16358, nodes: 21261795 
    Average node length: 5.56, total dup: 21261695, max dup: 233616 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 950067, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 3233 
        60 - 79% = 433 
        80 - 99% = 12685 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 76.23, total records: 10092053 
    Average version length: 82.67, total versions: 757345, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 109, data page slots: 177256 
    Data pages: 177256, average fill: 71% 
    Primary pages: 177256, secondary pages: 0, swept pages: 54654 
    Empty pages: 734, full pages: 116429 
    Fill distribution: 
     0 - 19% = 2365 
    20 - 39% = 10275 
    40 - 59% = 28698 
    60 - 79% = 49299 
    80 - 99% = 86619 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11441, nodes: 10092053 
    Average node length: 5.39, total dup: 9781557, max dup: 259 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2208561, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 86 
        40 - 59% = 6877 
        60 - 79% = 4342 
        80 - 99% = 135 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 14002, nodes: 10092053 
    Average node length: 6.26, total dup: 8368281, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1528133, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 3852 
        40 - 59% = 4755 
        60 - 79% = 2619 
        80 - 99% = 2641 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12767, nodes: 10092053 
    Average node length: 6.00, total dup: 8779036, max dup: 44 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2410950, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 86 
        40 - 59% = 7883 
        60 - 79% = 4608 
        80 - 99% = 187 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10401, nodes: 10092053 
    Average node length: 5.16, total dup: 10091953, max dup: 162251 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1580785, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1016 
        40 - 59% = 5330 
        60 - 79% = 1698 
        80 - 99% = 2316 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.38, total records: 11710595 
    Average version length: 82.57, total versions: 558696, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 120, data page slots: 195704 
    Data pages: 194504, average fill: 74% 
    Primary pages: 194504, secondary pages: 0, swept pages: 60331 
    Empty pages: 2950, full pages: 153091 
    Fill distribution: 
     0 - 19% = 4846 
    20 - 39% = 6693 
    40 - 59% = 15562 
    60 - 79% = 39329 
    80 - 99% = 128074 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13163, nodes: 11710595 
    Average node length: 5.31, total dup: 11600323, max dup: 687 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2449475, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 82 
        40 - 59% = 8244 
        60 - 79% = 4528 
        80 - 99% = 308 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10807, nodes: 11710595 
    Average node length: 5.51, total dup: 11199955, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 746655, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 168 
        20 - 39% = 802 
        40 - 59% = 2754 
        60 - 79% = 1826 
        80 - 99% = 5257 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15061, nodes: 11710595 
    Average node length: 6.03, total dup: 10232179, max dup: 69 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2466169, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 101 
        40 - 59% = 9706 
        60 - 79% = 4892 
        80 - 99% = 359 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11168, nodes: 11710595 
    Average node length: 5.24, total dup: 11710495, max dup: 207023 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 733983, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 776 
        40 - 59% = 5131 
        60 - 79% = 1495 
        80 - 99% = 3666 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 77.02, total records: 10154165 
    Average version length: 82.96, total versions: 702209, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 111, data page slots: 181096 
    Data pages: 181072, average fill: 70% 
    Primary pages: 181072, secondary pages: 0, swept pages: 59716 
    Empty pages: 742, full pages: 112218 
    Fill distribution: 
     0 - 19% = 2498 
    20 - 39% = 10953 
    40 - 59% = 32176 
    60 - 79% = 53258 
    80 - 99% = 82187 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12141, nodes: 10154165 
    Average node length: 5.21, total dup: 10124678, max dup: 1854 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2012072, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1416 
        40 - 59% = 7914 
        60 - 79% = 2082 
        80 - 99% = 699 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14134, nodes: 10154165 
    Average node length: 6.28, total dup: 8420409, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1481323, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 183 
        20 - 39% = 3885 
        40 - 59% = 4726 
        60 - 79% = 2609 
        80 - 99% = 2731 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12801, nodes: 10154165 
    Average node length: 5.46, total dup: 9706506, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2149584, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1345 
        40 - 59% = 8941 
        60 - 79% = 1862 
        80 - 99% = 625 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10535, nodes: 10154165 
    Average node length: 5.18, total dup: 10154065, max dup: 162713 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1579798, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1089 
        40 - 59% = 5489 
        60 - 79% = 1623 
        80 - 99% = 2299 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.89, total records: 585867 
    Average version length: 68.81, total versions: 11053, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8128 
    Data pages: 8128, average fill: 76% 
    Primary pages: 8128, secondary pages: 0, swept pages: 3007 
    Empty pages: 3, full pages: 7090 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 35 
    40 - 59% = 262 
    60 - 79% = 7613 
    80 - 99% = 212 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40566, depth: 3, leaf buckets: 761, nodes: 585867 
    Average node length: 5.95, total dup: 498937, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101572, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 564 
        60 - 79% = 102 
        80 - 99% = 73 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28902, depth: 3, leaf buckets: 783, nodes: 585867 
    Average node length: 6.15, total dup: 480668, max dup: 25 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101630, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 577 
        60 - 79% = 103 
        80 - 99% = 81 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 578, nodes: 585867 
    Average node length: 4.86, total dup: 585767, max dup: 9349 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90195, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 25 
        40 - 59% = 342 
        60 - 79% = 89 
        80 - 99% = 121 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Feb 25 16:11:40 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7869190 142702 1 0.0000 0.0000
DOC_LIST 2296410 136274 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 250670 659 62600.0000 0.0000
INVNT_TURNOVER_LOG 71762 58966 1 0.0000 0.0000
MONEY_SALDO 49 19368 1013 39500.0000 0.0000
MONEY_TURNOVER_LOG 1297 1180 1 0.0000 0.0000
PDISTR 805908 97153 4 0.0000 0.0000
PERF_SPLIT_0 165515 3960 1 0.0000 0.0000
PERF_SPLIT_1 167593 14646 1 0.0000 0.0000
PERF_SPLIT_2 181255 5092 1 0.0000 0.0000
PERF_SPLIT_3 184156 16060 1 0.0000 0.0000
PERF_SPLIT_4 171051 4769 1 0.0000 0.0000
PERF_SPLIT_5 196184 13489 1 0.0000 0.0000
PERF_SPLIT_6 179220 3011 1 0.0000 0.0000
PERF_SPLIT_7 163187 4546 1 0.0000 0.0000
PERF_SPLIT_8 186025 2408 1 0.0000 0.0000
PERF_SPLIT_9 194425 11169 1 0.0000 0.0000
PSTORNED 2160450 65210 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 166873 86751 1 0.0000 0.0000
XQD_1000_3300 7350584 700526 1 0.0000 0.0000
XQD_1200_2000 12232046 565027 1 0.0000 0.0000
XQD_2000_3300 2137565 1113389 1 0.0000 0.0000
XQD_2100_3300 1204098 528331 1 0.0000 0.0000
XQD_3300_3400 9639565 762423 1 0.0000 0.0000
XQS_1000_1200 21261795 26554 1 0.0000 0.0000
XQS_1000_3300 10092053 757345 1 0.0000 0.0000
XQS_1200_2000 11710595 558696 1 0.0000 0.0000
XQS_2100_3300 10154165 702209 1 0.0000 0.0000
XQS_3300_3400 585867 11053 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 ---
:1124: 
:1125: mscs-test-161.budzdorov.ru    Sun Feb 25 16:10:08 2024
:1126:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1127: 
:1128: 
:1129: mscs-test-161.budzdorov.ru    Sun Feb 25 16:10:08 2024
:1130:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1131: 
--- end of diff output ---

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

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